DBA Data[Home] [Help]

APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_MESSAGE_PKG

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

20: PROCEDURE debugmsg(msg VARCHAR2) IS
21: BEGIN
22:
23: IF g_cn_debug = 'Y' THEN
24: cn_message_pkg.debug(substr(msg,1,254));
25: fnd_file.put_line(fnd_file.Log, msg);
26: END IF;
27:
28: END debugmsg;

Line 282: cn_message_pkg.begin_batch (

278: BEGIN
279:
280: p_org_id := mo_global.get_current_org_id();
281:
282: cn_message_pkg.begin_batch (
283: x_process_type => 'SCA Rules Sync',
284: x_parent_proc_audit_id => null,
285: x_process_audit_id => l_process_audit_id,
286: x_request_id => fnd_global.conc_request_id,

Line 581: cn_message_pkg.end_batch(l_process_audit_id);

577: --
578: retcode := 0;
579: errbuf := 'Rules Synchronization Completed Successfully';
580: debugmsg('Rules Synchronization Completed Successfully');
581: cn_message_pkg.end_batch(l_process_audit_id);
582: --
583:
584: EXCEPTION
585:

Line 588: cn_message_pkg.end_batch(l_process_audit_id);

584: EXCEPTION
585:
586: WHEN ex_invalid_rules THEN
587: ROLLBACK;
588: cn_message_pkg.end_batch(l_process_audit_id);
589: debugmsg('Rules Sync : Exception: ex_invalid_rules');
590: conc_status := fnd_concurrent.set_completion_status(
591: status => 'ERROR',
592: message => '');

Line 597: cn_message_pkg.end_batch(l_process_audit_id);

593:
594: WHEN l_no_rule_ex THEN
595: ROLLBACK;
596: debugmsg('Rules Sync : No Rules available in CN_SCA_CREDIT_RULES table');
597: cn_message_pkg.end_batch(l_process_audit_id);
598: conc_status := fnd_concurrent.set_completion_status(
599: status => 'ERROR',
600: message => '');
601:

Line 605: cn_message_pkg.end_batch(l_process_audit_id);

601:
602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK;
604: debugmsg('Rules Sync : Execution Error');
605: cn_message_pkg.end_batch(l_process_audit_id);
606: conc_status := fnd_concurrent.set_completion_status(
607: status => 'ERROR',
608: message => '');
609:

Line 614: cn_message_pkg.end_batch(l_process_audit_id);

610: WHEN OTHERS THEN
611: ROLLBACK;
612: debugmsg('Rules Sync : Unexpected exception');
613: debugmsg('Oracle Error: '||SQLERRM);
614: cn_message_pkg.end_batch(l_process_audit_id);
615: conc_status := fnd_concurrent.set_completion_status(
616: status => 'ERROR',
617: message => '');
618: END;