25: procedure GENERIC_ERROR(routine in varchar2,
26: errcode in number,
27: errmsg in varchar2) is
28: begin
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: app_exception.raise_exception;
26: errcode in number,
27: errmsg in varchar2) is
28: begin
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: app_exception.raise_exception;
34: end;
27: errmsg in varchar2) is
28: begin
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: app_exception.raise_exception;
34: end;
35:
28: begin
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: app_exception.raise_exception;
34: end;
35:
36: /*