How to get the exact line number where the exception was raised, if this is your question, then watch the video to get an answer.
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE Function displays the call stack at the point where an exception was raised, even if the procedure is called from an exception handler in an outer scope. The output is similar to the output of the SQLERRM function, but not subject to the same size limitation.