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
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,
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',
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);
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;
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;
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
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,
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',
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);
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);
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;
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,
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',
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);
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);
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
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',
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);
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);
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
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',
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);