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