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', dbms_utility.format_error_stack);
18: fnd_message.raise_error;
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', dbms_utility.format_error_stack);
18: fnd_message.raise_error;
19: end GENERIC_ERROR;
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', dbms_utility.format_error_stack);
18: fnd_message.raise_error;
19: end GENERIC_ERROR;
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', dbms_utility.format_error_stack);
18: fnd_message.raise_error;
19: end GENERIC_ERROR;
20:
21: -- Init (PUBLIC)
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', dbms_utility.format_error_stack);
18: fnd_message.raise_error;
19: end GENERIC_ERROR;
20:
21: -- Init (PUBLIC)
22: -- This is generic routine to initialize attribute value inside a given