53: errcode in number,
54: errmsg in varchar2)
55: is
56: begin
57: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
58: fnd_message.set_token('ROUTINE', routine);
59: fnd_message.set_token('ERRNO', errcode);
60: fnd_message.set_token('REASON', errmsg);
61: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
54: errmsg in varchar2)
55: is
56: begin
57: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
58: fnd_message.set_token('ROUTINE', routine);
59: fnd_message.set_token('ERRNO', errcode);
60: fnd_message.set_token('REASON', errmsg);
61: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
62: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,routine, TRUE);
55: is
56: begin
57: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
58: fnd_message.set_token('ROUTINE', routine);
59: fnd_message.set_token('ERRNO', errcode);
60: fnd_message.set_token('REASON', errmsg);
61: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
62: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,routine, TRUE);
63: end if;
56: begin
57: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
58: fnd_message.set_token('ROUTINE', routine);
59: fnd_message.set_token('ERRNO', errcode);
60: fnd_message.set_token('REASON', errmsg);
61: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
62: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,routine, TRUE);
63: end if;
64: fnd_message.raise_error;
60: fnd_message.set_token('REASON', errmsg);
61: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
62: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,routine, TRUE);
63: end if;
64: fnd_message.raise_error;
65: end debug_exception;
66:
67:
68: function request_pvt (context in varchar2, cookie in out nocopy varchar2,sid in varchar2)