APPS.FND_CONC_RAC_UTILS dependencies on DBMS_JOB

Line 127: -- p_jobno - Job number of the dbms_job

123: -- CAUTION: This procedure does a COMMIT
124: -- (Now uses an autonomous_transaction)
125: --
126: -- Parameters:
127: -- p_jobno - Job number of the dbms_job
128: -- p_message - Oracle error message, allow 4000 characters
129: -- p_sid - Session ID of session to kill
130: -- p_serial# - Serial# of session to kill
131: -- p_inst - Instance ID where dbms_job should run

Line 131: -- p_inst - Instance ID where dbms_job should run

127: -- p_jobno - Job number of the dbms_job
128: -- p_message - Oracle error message, allow 4000 characters
129: -- p_sid - Session ID of session to kill
130: -- p_serial# - Serial# of session to kill
131: -- p_inst - Instance ID where dbms_job should run
132: --
133: -- Returns:
134: -- 0 - Oracle error, message available
135: -- 1 - Could not submit job in given instance, message available

Line 166: DBMS_JOB.SUBMIT(

162: if (l_inst = p_inst) then
163: p_jobno := 0;
164: kill_session(p_sid, p_serial#);
165: else
166: DBMS_JOB.SUBMIT(
167: job => p_jobno,
168: what => 'FND_CONC_RAC_UTILS.kill_session('''||to_char(p_sid)||''', '''||to_char(p_serial#)||''');',
169: instance => p_inst);
170: end if;

Line 178: 'Cannot submit dbms_job. Instance '||to_char(p_inst)||' not available.');

174: if SQLCODE = -23428 then
175: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
176: fnd_log.string(FND_LOG.LEVEL_ERROR,
177: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_kill_session',
178: 'Cannot submit dbms_job. Instance '||to_char(p_inst)||' not available.');
179: end if;
180: l_retcode := 1;
181: raise;
182: else

Line 187: 'Unexpected error submitting dbms_job to kill session ' ||to_char(p_sid)||', serial# '||to_char(p_serial#)||' in instance '||to_char(p_inst));

183: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: if l_inst <> p_inst then
185: fnd_log.string(FND_LOG.LEVEL_ERROR,
186: 'fnd.plsql.FND_CONC_RAC_UTILS.submit_kill_session',
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));

Line 239: -- p_jobno - job number of the dbms_job

235: -- Calls submit_kill_session given the concurrent_process_id of a manager
236: --
237: -- Parameters:
238: -- p_cpid - concurrent_process_id of manager to kill
239: -- p_jobno - job number of the dbms_job
240: -- p_message - message buffer for error, allow 4000 characters
241: --
242: -- Returns:
243: -- 0 - Oracle error. Check message

Line 353: -- p_jobno - job number of the dbms_job

349: -- Kills a manager session based on the request it is running
350: --
351: -- Parameters:
352: -- p_reqid - request_id for which manager session must be killed
353: -- p_jobno - job number of the dbms_job
354: -- p_message - message buffer for error, allow 4000 characters
355: --
356: -- Returns:
357: -- 0 - Oracle error. Check message

Line 447: -- p_jobno - job number of the dbms_job

443: -- Calls submit_kill_session given the request_id of a concurrent request
444: --
445: -- Parameters:
446: -- p_reqid - request_id for which session must be killed
447: -- p_jobno - job number of the dbms_job
448: -- p_message - message buffer for error, allow 4000 characters
449: --
450: -- Returns:
451: -- 0 - Oracle error. Check message