6: errcode in number,
7: errmsg in varchar2) is
8: l_msg varchar2(2000);
9: begin
10: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
11: fnd_message.set_token('ROUTINE', routine);
12: fnd_message.set_token('ERRNO', errcode);
13: fnd_message.set_token('REASON', errmsg);
14: fnd_message.raise_error;
7: errmsg in varchar2) is
8: l_msg varchar2(2000);
9: begin
10: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
11: fnd_message.set_token('ROUTINE', routine);
12: fnd_message.set_token('ERRNO', errcode);
13: fnd_message.set_token('REASON', errmsg);
14: fnd_message.raise_error;
15: end;
8: l_msg varchar2(2000);
9: begin
10: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
11: fnd_message.set_token('ROUTINE', routine);
12: fnd_message.set_token('ERRNO', errcode);
13: fnd_message.set_token('REASON', errmsg);
14: fnd_message.raise_error;
15: end;
16:
9: begin
10: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
11: fnd_message.set_token('ROUTINE', routine);
12: fnd_message.set_token('ERRNO', errcode);
13: fnd_message.set_token('REASON', errmsg);
14: fnd_message.raise_error;
15: end;
16:
17: function request_pvt (context in varchar2, cookie in out nocopy varchar2)
10: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
11: fnd_message.set_token('ROUTINE', routine);
12: fnd_message.set_token('ERRNO', errcode);
13: fnd_message.set_token('REASON', errmsg);
14: fnd_message.raise_error;
15: end;
16:
17: function request_pvt (context in varchar2, cookie in out nocopy varchar2)
18: return varchar2 as language java name