DBA Data[Home] [Help]

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_MESSAGE_PKG

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

61: --
62: PROCEDURE debugmsg(msg VARCHAR2) IS
63: BEGIN
64: IF g_cn_debug = 'Y' THEN
65: cn_message_pkg.DEBUG(SUBSTR(msg, 1, 254));
66: fnd_file.put_line(fnd_file.LOG, msg);
67: END IF;
68: END debugmsg;
69:

Line 105: cn_message_pkg.FLUSH;

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

Line 208: --cn_message_pkg.flush;

204: END LOOP;
205:
206: debugmsg('SCA : Conc_Dispatch : Total conc requests submitted : ' || x_batch_total);
207: debugmsg('Total conc requests submitted : ' || x_batch_total);
208: --cn_message_pkg.flush;
209: debug_v := l_primary_request_stack(primary_ptr);
210: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');
211:
212: IF l_sleep_time_char IS NOT NULL THEN

Line 656: cn_message_pkg.begin_batch(

652: index_ex EXCEPTION;
653: no_rule_ex EXCEPTION;
654: BEGIN
655: p_org_id := mo_global.get_current_org_id();
656: cn_message_pkg.begin_batch(
657: x_process_type => 'ALLOCATION_PROCESS'
658: , x_parent_proc_audit_id => NULL
659: , x_process_audit_id => l_process_audit_id
660: , x_request_id => fnd_global.conc_request_id

Line 814: cn_message_pkg.end_batch(l_process_audit_id);

810: END;
811:
812: COMMIT WORK;
813: debugmsg('Allocation Process : Ending: get_sales_credits ');
814: cn_message_pkg.end_batch(l_process_audit_id);
815: EXCEPTION
816: WHEN no_trx THEN
817: debugmsg('Get Sales Credits : No input transactions found for Rules Engine Processing');
818: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 820: cn_message_pkg.end_batch(l_process_audit_id);

816: WHEN no_trx THEN
817: debugmsg('Get Sales Credits : No input transactions found for Rules Engine Processing');
818: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
819: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
820: cn_message_pkg.end_batch(l_process_audit_id);
821: WHEN no_rule_ex THEN
822: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
823: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
824: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

Line 825: cn_message_pkg.end_batch(l_process_audit_id);

821: WHEN no_rule_ex THEN
822: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
823: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
824: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
825: cn_message_pkg.end_batch(l_process_audit_id);
826: WHEN index_ex THEN
827: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
828: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
829: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

Line 830: cn_message_pkg.end_batch(l_process_audit_id);

826: WHEN index_ex THEN
827: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
828: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
829: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
830: cn_message_pkg.end_batch(l_process_audit_id);
831: WHEN OTHERS THEN
832: debugmsg('Get Sales Credits : Unexpected exception');
833: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);
834: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 836: cn_message_pkg.end_batch(l_process_audit_id);

832: debugmsg('Get Sales Credits : Unexpected exception');
833: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);
834: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
835: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
836: cn_message_pkg.end_batch(l_process_audit_id);
837: END get_sales_credits;
838:
839: --
840:

Line 2697: cn_message_pkg.begin_batch(

2693: /* Convert the dates for the varchar2 parameters passed in from concurrent program */
2694: l_start_date := fnd_date.canonical_to_date(p_start_date);
2695: l_end_date := fnd_date.canonical_to_date(p_end_date);
2696: /* Call begin_batch to get process_audit_id for debug log file */
2697: cn_message_pkg.begin_batch(
2698: x_process_type => 'SCATM'
2699: , x_parent_proc_audit_id => NULL
2700: , x_process_audit_id => l_process_audit_id
2701: , x_request_id => fnd_global.conc_request_id

Line 2864: cn_message_pkg.end_batch(l_process_audit_id);

2860: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed completed successfully');
2861: COMMIT;
2862: -- Call end_batch to end debug log file
2863: debugmsg('SCA : End of SCATM');
2864: cn_message_pkg.end_batch(l_process_audit_id);
2865: EXCEPTION
2866: WHEN l_invalid_date_range THEN
2867: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_date_range');
2868: debugmsg('SCA : End of SCATM');

Line 2869: cn_message_pkg.end_batch(l_process_audit_id);

2865: EXCEPTION
2866: WHEN l_invalid_date_range THEN
2867: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_date_range');
2868: debugmsg('SCA : End of SCATM');
2869: cn_message_pkg.end_batch(l_process_audit_id);
2870: WHEN l_skip_crediting THEN
2871: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_skip_crediting');
2872: debugmsg('SCA : End of SCATM');
2873: cn_message_pkg.end_batch(l_process_audit_id);

Line 2873: cn_message_pkg.end_batch(l_process_audit_id);

2869: cn_message_pkg.end_batch(l_process_audit_id);
2870: WHEN l_skip_crediting THEN
2871: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_skip_crediting');
2872: debugmsg('SCA : End of SCATM');
2873: cn_message_pkg.end_batch(l_process_audit_id);
2874: WHEN l_invalid_run_mode THEN
2875: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
2876: debugmsg('SCA : End of SCATM');
2877: cn_message_pkg.end_batch(l_process_audit_id);

Line 2877: cn_message_pkg.end_batch(l_process_audit_id);

2873: cn_message_pkg.end_batch(l_process_audit_id);
2874: WHEN l_invalid_run_mode THEN
2875: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
2876: debugmsg('SCA : End of SCATM');
2877: cn_message_pkg.end_batch(l_process_audit_id);
2878: WHEN fnd_api.g_exc_error THEN
2879: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
2880: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2881: debugmsg('SCA : SQLERRM : ' || SQLERRM);

Line 2883: cn_message_pkg.end_batch(l_process_audit_id);

2879: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
2880: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2881: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2882: debugmsg('SCA : End of SCATM');
2883: cn_message_pkg.end_batch(l_process_audit_id);
2884: WHEN OTHERS THEN
2885: debugmsg('SCA : Unexpected exception');
2886: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2887: debugmsg('SCA : SQLERRM : ' || SQLERRM);

Line 2890: cn_message_pkg.end_batch(l_process_audit_id);

2886: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2887: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2888: -- Call end_batch to end debug log file
2889: debugmsg('SCA : End of SCATM');
2890: cn_message_pkg.end_batch(l_process_audit_id);
2891: retcode := 2;
2892: errbuf := 'Unexpected Error : ' || SQLERRM;
2893: END get_assignments;
2894:

Line 2943: -- cn_message_pkg.end_batch(l_process_audit_id);

2939: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
2940: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2941: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2942: debugmsg('SCA : End of SCATM');
2943: -- cn_message_pkg.end_batch(l_process_audit_id);
2944: WHEN OTHERS THEN
2945: debugmsg('SCA : Unexpected exception');
2946: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2947: debugmsg('SCA : SQLERRM : ' || SQLERRM);

Line 2950: --cn_message_pkg.end_batch(l_process_audit_id);

2946: debugmsg('SCA : SQLCODE : ' || SQLCODE);
2947: debugmsg('SCA : SQLERRM : ' || SQLERRM);
2948: -- Call end_batch to end debug log file
2949: debugmsg('SCA : End of SCATM');
2950: --cn_message_pkg.end_batch(l_process_audit_id);
2951: retcode := 2;
2952: errbuf := 'Unexpected Error : ' || SQLERRM;
2953:
2954: END batch_process_txns;