APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_MESSAGE_PKG

Line 36: cn_message_pkg.DEBUG(SUBSTR(msg, 1, 254));

32:
33: -- Local Procedure for showing debug msg
34: PROCEDURE debugmsg(msg VARCHAR2) IS
35: BEGIN
36: cn_message_pkg.DEBUG(SUBSTR(msg, 1, 254));
37: -- comment out dbms_output before checking in file
38: -- dbms_output.put_line(substr(msg,1,254));
39: END debugmsg;
40:

Line 246: cn_message_pkg.FLUSH;

242: END LOOP;
243:
244: CLOSE logical_batches;
245:
246: cn_message_pkg.FLUSH;
247: COMMIT;
248: debugmsg('Loader : Assign : Assignment commit complete.');
249: EXCEPTION
250: WHEN OTHERS THEN

Line 335: cn_message_pkg.FLUSH;

331: debugmsg('Loader : Conc_Submit : Submit failure for phys batch ' || x_physical_batch_id);
332: debugmsg('Loader : Conc_Submit: ' || fnd_message.get);
333: debugmsg('Loader : Conc_Submit : Submit failure for phys batch ' || x_physical_batch_id);
334: ELSE
335: cn_message_pkg.FLUSH;
336: COMMIT; -- Commit for each concurrent program i.e. runner
337: END IF;
338: END conc_submit;
339:

Line 515: cn_message_pkg.end_batch(x_parent_proc_audit_id);

511: END LOOP;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: debugmsg('Loader : Conc_Dispatch : no rows for process ' || g_physical_process);
515: cn_message_pkg.end_batch(x_parent_proc_audit_id);
516: WHEN conc_fail THEN
517: update_error(l_temp_phys_batch_id);
518: debugmsg('Loader : Conc_Dispatch : Exception conc_fail');
519: cn_message_pkg.end_batch(x_parent_proc_audit_id);

Line 519: cn_message_pkg.end_batch(x_parent_proc_audit_id);

515: cn_message_pkg.end_batch(x_parent_proc_audit_id);
516: WHEN conc_fail THEN
517: update_error(l_temp_phys_batch_id);
518: debugmsg('Loader : Conc_Dispatch : Exception conc_fail');
519: cn_message_pkg.end_batch(x_parent_proc_audit_id);
520: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
521: WHEN OTHERS THEN
522: debugmsg('Loader : Conc_Dispatch : Unexpected Exception');
523: RAISE;

Line 1189: cn_message_pkg.begin_batch(

1185:
1186: --+
1187: --+ Call begin_batch to get process_audit_id for debug log file
1188: --+
1189: cn_message_pkg.begin_batch(
1190: x_process_type => 'LOADER'
1191: , x_parent_proc_audit_id => NULL
1192: , x_process_audit_id => l_process_audit_id
1193: , x_request_id => fnd_global.conc_request_id

Line 1352: cn_message_pkg.end_batch(l_process_audit_id);

1348: void_batches(p_physical_batch_id => NULL, p_logical_batch_id => l_logical_batch_id);
1349:
1350: -- Call end_batch to end debug log file
1351: debugmsg('Loader : End of Loader');
1352: cn_message_pkg.end_batch(l_process_audit_id);
1353:
1354: EXCEPTION
1355: WHEN invalid_date THEN
1356: -- Call end_batch to end debug log file

Line 1360: cn_message_pkg.end_batch(l_process_audit_id);

1356: -- Call end_batch to end debug log file
1357: errbuf := 'Parameter End Date is not within an open acc period';
1358: retcode := 1;
1359: debugmsg('Loader : End of Loader');
1360: cn_message_pkg.end_batch(l_process_audit_id);
1361: WHEN no_trx_lines THEN
1362: -- Call end_batch to end debug log file
1363: errbuf := 'No transactions to load';
1364: retcode := 1;

Line 1366: cn_message_pkg.end_batch(l_process_audit_id);

1362: -- Call end_batch to end debug log file
1363: errbuf := 'No transactions to load';
1364: retcode := 1;
1365: debugmsg('Loader : End of Loader');
1366: cn_message_pkg.end_batch(l_process_audit_id);
1367: WHEN fail_validate_ruleset THEN
1368: errbuf := 'Ruleset validation failed';
1369: retcode := 1;
1370: debugmsg('Loader : validate ruleset fails.');

Line 1372: cn_message_pkg.end_batch(l_process_audit_id);

1368: errbuf := 'Ruleset validation failed';
1369: retcode := 1;
1370: debugmsg('Loader : validate ruleset fails.');
1371: debugmsg('Loader : End of Loader');
1372: cn_message_pkg.end_batch(l_process_audit_id);
1373: WHEN OTHERS THEN
1374: debugmsg('Loader : Unexpected exception.');
1375: -- Call end_batch to end debug log file
1376: errbuf := SQLERRM;

Line 1379: cn_message_pkg.end_batch(l_process_audit_id);

1375: -- Call end_batch to end debug log file
1376: errbuf := SQLERRM;
1377: retcode := 2;
1378: debugmsg('Loader : End of Loader');
1379: cn_message_pkg.end_batch(l_process_audit_id);
1380: END LOAD;
1381:
1382: -- Procedure Name
1383: -- Assign