DBA Data[Home] [Help]

APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_MESSAGE_PKG

Line 53: cn_message_pkg.debug(substr(msg,1,254));

49: PROCEDURE debugmsg(msg VARCHAR2) IS
50: BEGIN
51:
52: IF g_cn_debug = 'Y' THEN
53: cn_message_pkg.debug(substr(msg,1,254));
54: fnd_file.put_line(fnd_file.Log, msg); -- Bug fix 5125980
55: END IF;
56: -- comment out dbms_output before checking in file
57: -- dbms_output.put_line(substr(msg,1,254));

Line 106: cn_message_pkg.flush;

102: debugmsg('Loader : Conc_Submit: ' || fnd_message.get);
103: debugmsg('Loader : Conc_Submit : Submit failure for phys batch '
104: || x_physical_batch_id);
105: ELSE
106: cn_message_pkg.flush;
107: commit; -- Commit for each concurrent program i.e. runner
108: END IF;
109:
110: END conc_submit;

Line 298: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);

294: ||x_process);
295: -- conc_status := fnd_concurrent.set_completion_status(
296: -- status => 'ERROR',
297: -- message => '');
298: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);
299: WHEN conc_fail THEN
300: -- update_error(l_temp_phys_batch_id);
301: debugmsg('Conc_Dispatch : Exception conc_fail');
302: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);

Line 302: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);

298: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);
299: WHEN conc_fail THEN
300: -- update_error(l_temp_phys_batch_id);
301: debugmsg('Conc_Dispatch : Exception conc_fail');
302: -- cn_message_pkg.end_batch(x_parent_proc_audit_id);
303: conc_status := fnd_concurrent.set_completion_status(
304: status => 'ERROR',
305: message => '');
306: RAISE;

Line 2163: cn_message_pkg.begin_batch

2159: --+
2160: --+ Call begin_batch to get process_audit_id for debug log file
2161: --+
2162:
2163: cn_message_pkg.begin_batch
2164: (x_process_type => 'RESULTS_TRANSFER',
2165: x_parent_proc_audit_id => null,
2166: x_process_audit_id => l_process_audit_id,
2167: x_request_id => fnd_global.conc_request_id,

Line 2226: cn_message_pkg.end_batch(l_process_audit_id);

2222: WHERE sca_headers_interface_id = sca_update_headers(j);
2223:
2224: debugmsg('Results Transfer : End of Transfer');
2225:
2226: cn_message_pkg.end_batch(l_process_audit_id);
2227:
2228: EXCEPTION
2229:
2230: WHEN no_trx_lines THEN

Line 2242: cn_message_pkg.end_batch(l_process_audit_id);

2238: conc_status := fnd_concurrent.set_completion_status(
2239: status => 'ERROR',
2240: message => '');
2241:
2242: cn_message_pkg.end_batch(l_process_audit_id);
2243:
2244: WHEN OTHERS THEN
2245:
2246: ROLLBACK TO populate_results_savepoint;

Line 2255: cn_message_pkg.end_batch(l_process_audit_id);

2251: conc_status := fnd_concurrent.set_completion_status(
2252: status => 'ERROR',
2253: message => '');
2254:
2255: cn_message_pkg.end_batch(l_process_audit_id);
2256:
2257: END populate_results;
2258:
2259:

Line 2379: cn_message_pkg.begin_batch

2375: --+
2376: --+ Call begin_batch to get process_audit_id for debug log file
2377: --+
2378:
2379: cn_message_pkg.begin_batch
2380: (x_process_type => 'ALLOCATION_TRANSFER',
2381: x_parent_proc_audit_id => null,
2382: x_process_audit_id => l_process_audit_id,
2383: x_request_id => fnd_global.conc_request_id,

Line 2485: cn_message_pkg.end_batch(l_process_audit_id);

2481: raise no_trx_lines;
2482:
2483: end if;
2484:
2485: cn_message_pkg.end_batch(l_process_audit_id);
2486:
2487: EXCEPTION
2488:
2489: WHEN no_trx_lines THEN

Line 2501: cn_message_pkg.end_batch(l_process_audit_id);

2497: conc_status := fnd_concurrent.set_completion_status(
2498: status => 'ERROR',
2499: message => '');
2500:
2501: cn_message_pkg.end_batch(l_process_audit_id);
2502:
2503: WHEN OTHERS THEN
2504:
2505: ROLLBACK TO populate_data_savepoint;

Line 2514: cn_message_pkg.end_batch(l_process_audit_id);

2510: conc_status := fnd_concurrent.set_completion_status(
2511: status => 'ERROR',
2512: message => '');
2513:
2514: cn_message_pkg.end_batch(l_process_audit_id);
2515:
2516: END populate_data;
2517:
2518:

Line 3937: cn_message_pkg.begin_batch(

3933: BEGIN
3934:
3935: l_request_id := fnd_global.conc_request_id;
3936:
3937: cn_message_pkg.begin_batch(
3938: x_process_type => 'SCA Batch Runner'
3939: ,x_parent_proc_audit_id => p_parent_proc_audit_id
3940: ,x_process_audit_id => l_process_audit_id
3941: ,x_request_id => l_request_id

Line 4031: -- cn_message_pkg.flush;

4027:
4028: debugmsg(p_process || ' : SCA Batch Runner : Completed over physical batch : ' || p_physical_batch_id);
4029: debugmsg(p_process || ' : SCA Batch Runner : End ');
4030:
4031: -- cn_message_pkg.flush;
4032: -- COMMIT;
4033:
4034: -- cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');
4035: cn_message_pkg.end_batch(l_process_audit_id);

Line 4034: -- cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');

4030:
4031: -- cn_message_pkg.flush;
4032: -- COMMIT;
4033:
4034: -- cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');
4035: cn_message_pkg.end_batch(l_process_audit_id);
4036:
4037: retcode := 0;
4038: errbuf := 'Successful.';

Line 4035: cn_message_pkg.end_batch(l_process_audit_id);

4031: -- cn_message_pkg.flush;
4032: -- COMMIT;
4033:
4034: -- cn_message_pkg.set_name('CN','ALL_PROCESS_DONE_OK');
4035: cn_message_pkg.end_batch(l_process_audit_id);
4036:
4037: retcode := 0;
4038: errbuf := 'Successful.';
4039:

Line 4048: cn_message_pkg.end_batch(l_process_audit_id);

4044:
4045: retcode := 2;
4046: debugmsg(p_process || ' : SCA Batch Runner : Failed in populating : ' || p_physical_batch_id);
4047: debugmsg(p_process || ' : SCA Batch Runner : End ');
4048: cn_message_pkg.end_batch(l_process_audit_id);
4049:
4050: WHEN others THEN
4051:
4052: retcode := 2;

Line 4055: cn_message_pkg.end_batch(l_process_audit_id);

4051:
4052: retcode := 2;
4053: debugmsg(p_process || ' : SCA Batch Runner : Unexpected Exception : ' || p_physical_batch_id);
4054: debugmsg(p_process || ' : SCA Batch Runner : End ');
4055: cn_message_pkg.end_batch(l_process_audit_id);
4056:
4057: END sca_batch_runner;
4058:
4059: