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 587: cn_message_pkg.end_batch(l_process_audit_id);

583: --
584: retcode := 0;
585: errbuf := 'Rules Synchronization Completed Successfully';
586: debugmsg('Rules Synchronization Completed Successfully');
587: cn_message_pkg.end_batch(l_process_audit_id);
588: --
589:
590: EXCEPTION
591:

Line 594: cn_message_pkg.end_batch(l_process_audit_id);

590: EXCEPTION
591:
592: WHEN ex_invalid_rules THEN
593: ROLLBACK;
594: cn_message_pkg.end_batch(l_process_audit_id);
595: debugmsg('Rules Sync : Exception: ex_invalid_rules');
596: conc_status := fnd_concurrent.set_completion_status(
597: status => 'ERROR',
598: message => '');

Line 603: cn_message_pkg.end_batch(l_process_audit_id);

599:
600: WHEN l_no_rule_ex THEN
601: ROLLBACK;
602: debugmsg('Rules Sync : No Rules available in CN_SCA_CREDIT_RULES table');
603: cn_message_pkg.end_batch(l_process_audit_id);
604: conc_status := fnd_concurrent.set_completion_status(
605: status => 'ERROR',
606: message => '');
607:

Line 611: cn_message_pkg.end_batch(l_process_audit_id);

607:
608: WHEN FND_API.G_EXC_ERROR THEN
609: ROLLBACK;
610: debugmsg('Rules Sync : Execution Error');
611: cn_message_pkg.end_batch(l_process_audit_id);
612: conc_status := fnd_concurrent.set_completion_status(
613: status => 'ERROR',
614: message => '');
615:

Line 620: cn_message_pkg.end_batch(l_process_audit_id);

616: WHEN OTHERS THEN
617: ROLLBACK;
618: debugmsg('Rules Sync : Unexpected exception');
619: debugmsg('Oracle Error: '||SQLERRM);
620: cn_message_pkg.end_batch(l_process_audit_id);
621: conc_status := fnd_concurrent.set_completion_status(
622: status => 'ERROR',
623: message => '');
624: END;