You can't increase the MESSAGE_TEXT length.
Perhaps you could pass back a larger string in a dynamic result set or OUT parameter, or insert it into a log table.
Thank you for the response !!. Will add it in the OUT parameter.