381: PROCEDURE sql_error(p_routine IN VARCHAR2,
382: p_errcode IN NUMBER,
383: p_errmsg IN VARCHAR2) IS
384: BEGIN
385: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
386: fnd_message.set_token('ROUTINE', p_routine);
387: fnd_message.set_token('ERRNO', p_errcode);
388: fnd_message.set_token('REASON', p_errmsg);
389: app_exception.raise_exception;
382: p_errcode IN NUMBER,
383: p_errmsg IN VARCHAR2) IS
384: BEGIN
385: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
386: fnd_message.set_token('ROUTINE', p_routine);
387: fnd_message.set_token('ERRNO', p_errcode);
388: fnd_message.set_token('REASON', p_errmsg);
389: app_exception.raise_exception;
390: EXCEPTION
383: p_errmsg IN VARCHAR2) IS
384: BEGIN
385: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
386: fnd_message.set_token('ROUTINE', p_routine);
387: fnd_message.set_token('ERRNO', p_errcode);
388: fnd_message.set_token('REASON', p_errmsg);
389: app_exception.raise_exception;
390: EXCEPTION
391: WHEN OTHERS THEN RAISE;
384: BEGIN
385: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
386: fnd_message.set_token('ROUTINE', p_routine);
387: fnd_message.set_token('ERRNO', p_errcode);
388: fnd_message.set_token('REASON', p_errmsg);
389: app_exception.raise_exception;
390: EXCEPTION
391: WHEN OTHERS THEN RAISE;
392: END sql_error;