DBA Data[Home] [Help]

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_MESSAGE_PKG

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

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

Line 183: cn_message_pkg.FLUSH;

179: debugmsg('Loader : Conc_Submit : Submit failure for phys batch ' || x_physical_batch_id);
180: debugmsg('Loader : Conc_Submit: ' || fnd_message.get);
181: debugmsg('Loader : Conc_Submit : Submit failure for phys batch ' || x_physical_batch_id);
182: ELSE
183: cn_message_pkg.FLUSH;
184: COMMIT; -- Commit for each concurrent program i.e. runner
185: END IF;
186:
187: debugmsg('Conc_Submit : End Procedure');

Line 286: --cn_message_pkg.flush;

282: END LOOP;
283:
284: debugmsg('SCA : Conc_Dispatch : Total conc requests submitted : ' || x_batch_total);
285: debugmsg('Total conc requests submitted : ' || x_batch_total);
286: --cn_message_pkg.flush;
287: debug_v := l_primary_request_stack(primary_ptr);
288: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');
289:
290: IF l_sleep_time_char IS NOT NULL THEN

Line 734: cn_message_pkg.begin_batch(

730: index_ex EXCEPTION;
731: no_rule_ex EXCEPTION;
732: BEGIN
733: p_org_id := mo_global.get_current_org_id();
734: cn_message_pkg.begin_batch(
735: x_process_type => 'ALLOCATION_PROCESS'
736: , x_parent_proc_audit_id => NULL
737: , x_process_audit_id => l_process_audit_id
738: , x_request_id => fnd_global.conc_request_id

Line 892: cn_message_pkg.end_batch(l_process_audit_id);

888: END;
889:
890: COMMIT WORK;
891: debugmsg('Allocation Process : Ending: get_sales_credits ');
892: cn_message_pkg.end_batch(l_process_audit_id);
893: EXCEPTION
894: WHEN no_trx THEN
895: debugmsg('Get Sales Credits : No input transactions found for Rules Engine Processing');
896: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 898: cn_message_pkg.end_batch(l_process_audit_id);

894: WHEN no_trx THEN
895: debugmsg('Get Sales Credits : No input transactions found for Rules Engine Processing');
896: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
897: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
898: cn_message_pkg.end_batch(l_process_audit_id);
899: WHEN no_rule_ex THEN
900: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
901: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
902: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

Line 903: cn_message_pkg.end_batch(l_process_audit_id);

899: WHEN no_rule_ex THEN
900: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
901: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
902: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
903: cn_message_pkg.end_batch(l_process_audit_id);
904: WHEN index_ex THEN
905: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
906: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
907: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

Line 908: cn_message_pkg.end_batch(l_process_audit_id);

904: WHEN index_ex THEN
905: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
906: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
907: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
908: cn_message_pkg.end_batch(l_process_audit_id);
909: WHEN OTHERS THEN
910: debugmsg('Get Sales Credits : Unexpected exception');
911: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);
912: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 914: cn_message_pkg.end_batch(l_process_audit_id);

910: debugmsg('Get Sales Credits : Unexpected exception');
911: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);
912: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
913: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
914: cn_message_pkg.end_batch(l_process_audit_id);
915: END get_sales_credits;
916:
917: --
918:

Line 3158: cn_message_pkg.begin_batch(

3154: /* Convert the dates for the varchar2 parameters passed in from concurrent program */
3155: l_start_date := fnd_date.canonical_to_date(p_start_date);
3156: l_end_date := fnd_date.canonical_to_date(p_end_date);
3157: /* Call begin_batch to get process_audit_id for debug log file */
3158: cn_message_pkg.begin_batch(
3159: x_process_type => 'SCATM'
3160: , x_parent_proc_audit_id => NULL
3161: , x_process_audit_id => l_process_audit_id
3162: , x_request_id => fnd_global.conc_request_id

Line 3310: cn_message_pkg.end_batch(l_process_audit_id);

3306: debugmsg('SCA : CN_SCATM_TAE_PUB.update_txns_processed completed successfully');
3307: -- Call end_batch to end debug log file
3308: debugmsg('SCA : CN_SCATM_TAE_PUB. Parent Process Complete Successfully at '||CURRENT_TIMESTAMP);
3309: debugmsg('SCA : End of SCATM');
3310: cn_message_pkg.end_batch(l_process_audit_id);
3311: COMMIT;
3312: EXCEPTION
3313: WHEN l_invalid_date_range THEN
3314: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_date_range');

Line 3316: cn_message_pkg.end_batch(l_process_audit_id);

3312: EXCEPTION
3313: WHEN l_invalid_date_range THEN
3314: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_date_range');
3315: debugmsg('SCA : End of SCATM');
3316: cn_message_pkg.end_batch(l_process_audit_id);
3317: WHEN l_skip_crediting THEN
3318: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_skip_crediting');
3319: debugmsg('SCA : End of SCATM');
3320: cn_message_pkg.end_batch(l_process_audit_id);

Line 3320: cn_message_pkg.end_batch(l_process_audit_id);

3316: cn_message_pkg.end_batch(l_process_audit_id);
3317: WHEN l_skip_crediting THEN
3318: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_skip_crediting');
3319: debugmsg('SCA : End of SCATM');
3320: cn_message_pkg.end_batch(l_process_audit_id);
3321: WHEN l_invalid_run_mode THEN
3322: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
3323: debugmsg('SCA : End of SCATM');
3324: cn_message_pkg.end_batch(l_process_audit_id);

Line 3324: cn_message_pkg.end_batch(l_process_audit_id);

3320: cn_message_pkg.end_batch(l_process_audit_id);
3321: WHEN l_invalid_run_mode THEN
3322: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.l_invalid_run_mode');
3323: debugmsg('SCA : End of SCATM');
3324: cn_message_pkg.end_batch(l_process_audit_id);
3325: WHEN fnd_api.g_exc_error THEN
3326: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3327: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3328: debugmsg('SCA : SQLERRM : ' || SQLERRM);

Line 3330: cn_message_pkg.end_batch(l_process_audit_id);

3326: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3327: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3328: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3329: debugmsg('SCA : End of SCATM');
3330: cn_message_pkg.end_batch(l_process_audit_id);
3331: WHEN child_proc_fail_exception THEN
3332: debugmsg('SCA : Unexpected exception');
3333: debugmsg('SCA : Child Process Failed ');
3334: debugmsg('SCA : Check Log of Child Process ');

Line 3341: cn_message_pkg.end_batch(l_process_audit_id);

3337: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3338: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3339: -- Call end_batch to end debug log file
3340: debugmsg('SCA : End of SCATM');
3341: cn_message_pkg.end_batch(l_process_audit_id);
3342: retcode := 2;
3343: errbuf := 'Unexpected Error : ' || SQLERRM;
3344: END get_assignments;
3345:

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

3393: debugmsg('SCA : CN_SCATM_TAE_PUB.get_assignments.g_exc_error');
3394: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3395: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3396: debugmsg('SCA : End of SCATM');
3397: -- cn_message_pkg.end_batch(l_process_audit_id);
3398: WHEN OTHERS THEN
3399: debugmsg('SCA : Unexpected exception');
3400: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3401: debugmsg('SCA : SQLERRM : ' || SQLERRM);

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

3400: debugmsg('SCA : SQLCODE : ' || SQLCODE);
3401: debugmsg('SCA : SQLERRM : ' || SQLERRM);
3402: -- Call end_batch to end debug log file
3403: debugmsg('SCA : End of SCATM');
3404: --cn_message_pkg.end_batch(l_process_audit_id);
3405: retcode := 2;
3406: errbuf := 'Unexpected Error : ' || SQLERRM;
3407:
3408: END batch_process_txns;