DBA Data[Home] [Help]

APPS.FND_CONC_RAC_UTILS dependencies on FND_MESSAGE

Line 106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

102: end if;
103:
104: exception
105: when others then
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.KILL_SESSION');
108: fnd_message.set_token('ERRNO', SQLCODE);
109: fnd_message.set_token('REASON', SQLERRM);
110: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 107: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.KILL_SESSION');

103:
104: exception
105: when others then
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.KILL_SESSION');
108: fnd_message.set_token('ERRNO', SQLCODE);
109: fnd_message.set_token('REASON', SQLERRM);
110: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
111: fnd_log.string(FND_LOG.LEVEL_ERROR,

Line 108: fnd_message.set_token('ERRNO', SQLCODE);

104: exception
105: when others then
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.KILL_SESSION');
108: fnd_message.set_token('ERRNO', SQLCODE);
109: fnd_message.set_token('REASON', SQLERRM);
110: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
111: fnd_log.string(FND_LOG.LEVEL_ERROR,
112: 'fnd.plsql.FND_CONC_RAC_UTILS.kill_session',

Line 109: fnd_message.set_token('REASON', SQLERRM);

105: when others then
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.KILL_SESSION');
108: fnd_message.set_token('ERRNO', SQLCODE);
109: fnd_message.set_token('REASON', SQLERRM);
110: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
111: fnd_log.string(FND_LOG.LEVEL_ERROR,
112: 'fnd.plsql.FND_CONC_RAC_UTILS.kill_session',
113: 'Oracle Error kill_session: '||SQLCODE||': '||SQLERRM);

Line 191: 'Unexpected error: '||fnd_message.get||' calling kill_session for session ' ||to_char(p_sid)||', serial# '||to_char(p_serial#)||' in instance '||to_char(p_inst));

187: 'Unexpected error submitting dbms_job to kill session ' ||to_char(p_sid)||', serial# '||to_char(p_serial#)||' in instance '||to_char(p_inst));
188: else
189: fnd_log.string(FND_LOG.LEVEL_ERROR,
190: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_kill_session',
191: 'Unexpected error: '||fnd_message.get||' calling kill_session for session ' ||to_char(p_sid)||', serial# '||to_char(p_serial#)||' in instance '||to_char(p_inst));
192: end if;
193:
194: end if;
195: l_retcode := 0;

Line 218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

214: return l_retcode;
215:
216: exception
217: when others then
218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');
220: fnd_message.set_token('ERRNO', SQLCODE);
221: fnd_message.set_token('REASON', SQLERRM);
222: p_message := fnd_message.get;

Line 219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');

215:
216: exception
217: when others then
218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');
220: fnd_message.set_token('ERRNO', SQLCODE);
221: fnd_message.set_token('REASON', SQLERRM);
222: p_message := fnd_message.get;
223: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 220: fnd_message.set_token('ERRNO', SQLCODE);

216: exception
217: when others then
218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');
220: fnd_message.set_token('ERRNO', SQLCODE);
221: fnd_message.set_token('REASON', SQLERRM);
222: p_message := fnd_message.get;
223: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
224: fnd_log.string(FND_LOG.LEVEL_ERROR,

Line 221: fnd_message.set_token('REASON', SQLERRM);

217: when others then
218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');
220: fnd_message.set_token('ERRNO', SQLCODE);
221: fnd_message.set_token('REASON', SQLERRM);
222: p_message := fnd_message.get;
223: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
224: fnd_log.string(FND_LOG.LEVEL_ERROR,
225: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_kill_session',

Line 222: p_message := fnd_message.get;

218: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
219: fnd_message.set_token('ROUTINE', 'FND_CONC_RAC_UTILS.SUBMIT_KILL_SESSION');
220: fnd_message.set_token('ERRNO', SQLCODE);
221: fnd_message.set_token('REASON', SQLERRM);
222: p_message := fnd_message.get;
223: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
224: fnd_log.string(FND_LOG.LEVEL_ERROR,
225: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_kill_session',
226: 'Exception in submit_kill_session: '||p_message);

Line 331: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

327: return l_retcode;
328:
329: exception
330: when others then
331: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
332: fnd_message.set_token('ROUTINE',
333: 'FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION');
334: fnd_message.set_token('ERRNO', SQLCODE);
335: fnd_message.set_token('REASON', SQLERRM);

Line 332: fnd_message.set_token('ROUTINE',

328:
329: exception
330: when others then
331: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
332: fnd_message.set_token('ROUTINE',
333: 'FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION');
334: fnd_message.set_token('ERRNO', SQLCODE);
335: fnd_message.set_token('REASON', SQLERRM);
336: p_message := fnd_message.get;

Line 334: fnd_message.set_token('ERRNO', SQLCODE);

330: when others then
331: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
332: fnd_message.set_token('ROUTINE',
333: 'FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION');
334: fnd_message.set_token('ERRNO', SQLCODE);
335: fnd_message.set_token('REASON', SQLERRM);
336: p_message := fnd_message.get;
337: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
338: fnd_log.string(FND_LOG.LEVEL_ERROR,

Line 335: fnd_message.set_token('REASON', SQLERRM);

331: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
332: fnd_message.set_token('ROUTINE',
333: 'FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION');
334: fnd_message.set_token('ERRNO', SQLCODE);
335: fnd_message.set_token('REASON', SQLERRM);
336: p_message := fnd_message.get;
337: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
338: fnd_log.string(FND_LOG.LEVEL_ERROR,
339: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_manager_kill_session',

Line 336: p_message := fnd_message.get;

332: fnd_message.set_token('ROUTINE',
333: 'FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION');
334: fnd_message.set_token('ERRNO', SQLCODE);
335: fnd_message.set_token('REASON', SQLERRM);
336: p_message := fnd_message.get;
337: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
338: fnd_log.string(FND_LOG.LEVEL_ERROR,
339: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_manager_kill_session',
340: 'Exception in submit_manager_kill_session: '||p_message);

Line 423: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

419: return l_retcode;
420:
421: exception
422: when others then
423: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
424: fnd_message.set_token('ROUTINE',
425: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_MGR_KILL_SESSION');
426: fnd_message.set_token('ERRNO', SQLCODE);
427: fnd_message.set_token('REASON', SQLERRM);

Line 424: fnd_message.set_token('ROUTINE',

420:
421: exception
422: when others then
423: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
424: fnd_message.set_token('ROUTINE',
425: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_MGR_KILL_SESSION');
426: fnd_message.set_token('ERRNO', SQLCODE);
427: fnd_message.set_token('REASON', SQLERRM);
428: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 426: fnd_message.set_token('ERRNO', SQLCODE);

422: when others then
423: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
424: fnd_message.set_token('ROUTINE',
425: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_MGR_KILL_SESSION');
426: fnd_message.set_token('ERRNO', SQLCODE);
427: fnd_message.set_token('REASON', SQLERRM);
428: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
429: fnd_log.message(FND_LOG.LEVEL_ERROR,
430: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_req_mgr_kill_session',

Line 427: fnd_message.set_token('REASON', SQLERRM);

423: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
424: fnd_message.set_token('ROUTINE',
425: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_MGR_KILL_SESSION');
426: fnd_message.set_token('ERRNO', SQLCODE);
427: fnd_message.set_token('REASON', SQLERRM);
428: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
429: fnd_log.message(FND_LOG.LEVEL_ERROR,
430: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_req_mgr_kill_session',
431: TRUE);

Line 552: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

548: return l_retcode;
549:
550: exception
551: when others then
552: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
553: fnd_message.set_token('ROUTINE',
554: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_KILL_SESSION');
555: fnd_message.set_token('ERRNO', SQLCODE);
556: fnd_message.set_token('REASON', SQLERRM);

Line 553: fnd_message.set_token('ROUTINE',

549:
550: exception
551: when others then
552: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
553: fnd_message.set_token('ROUTINE',
554: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_KILL_SESSION');
555: fnd_message.set_token('ERRNO', SQLCODE);
556: fnd_message.set_token('REASON', SQLERRM);
557: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 555: fnd_message.set_token('ERRNO', SQLCODE);

551: when others then
552: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
553: fnd_message.set_token('ROUTINE',
554: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_KILL_SESSION');
555: fnd_message.set_token('ERRNO', SQLCODE);
556: fnd_message.set_token('REASON', SQLERRM);
557: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
558: fnd_log.message(FND_LOG.LEVEL_ERROR,
559: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_req_kill_session',

Line 556: fnd_message.set_token('REASON', SQLERRM);

552: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
553: fnd_message.set_token('ROUTINE',
554: 'FND_CONC_RAC_UTILS.SUBMIT_REQ_KILL_SESSION');
555: fnd_message.set_token('ERRNO', SQLCODE);
556: fnd_message.set_token('REASON', SQLERRM);
557: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
558: fnd_log.message(FND_LOG.LEVEL_ERROR,
559: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_req_kill_session',
560: TRUE);