49: errcode in number,
50: errmsg in varchar2) is
51: l_msg varchar2(2000);
52: begin
53: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
54: fnd_message.set_token('ROUTINE', routine);
55: fnd_message.set_token('ERRNO', errcode);
56: fnd_message.set_token('REASON', errmsg);
57: fnd_message.raise_error;
50: errmsg in varchar2) is
51: l_msg varchar2(2000);
52: begin
53: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
54: fnd_message.set_token('ROUTINE', routine);
55: fnd_message.set_token('ERRNO', errcode);
56: fnd_message.set_token('REASON', errmsg);
57: fnd_message.raise_error;
58: end;
51: l_msg varchar2(2000);
52: begin
53: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
54: fnd_message.set_token('ROUTINE', routine);
55: fnd_message.set_token('ERRNO', errcode);
56: fnd_message.set_token('REASON', errmsg);
57: fnd_message.raise_error;
58: end;
59:
52: begin
53: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
54: fnd_message.set_token('ROUTINE', routine);
55: fnd_message.set_token('ERRNO', errcode);
56: fnd_message.set_token('REASON', errmsg);
57: fnd_message.raise_error;
58: end;
59:
60: --
53: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
54: fnd_message.set_token('ROUTINE', routine);
55: fnd_message.set_token('ERRNO', errcode);
56: fnd_message.set_token('REASON', errmsg);
57: fnd_message.raise_error;
58: end;
59:
60: --
61: -- Transfer_pvt