10: procedure GENERIC_ERROR(routine in varchar2,
11: errcode in number,
12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
11: errcode in number,
12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;
12: errmsg in varchar2) is
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;
20:
13: begin
14: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
15: fnd_message.set_token('ROUTINE', routine);
16: fnd_message.set_token('ERRNO', errcode);
17: fnd_message.set_token('REASON', errmsg);
18: app_exception.raise_exception;
19: end;
20:
21: