DBA Data[Home] [Help]

APPS.GCS_CONS_MONITOR_PKG dependencies on FND_LOG

Line 140: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

136: l_undo_cnt NUMBER(15) := 0;
137: l_child_cnt NUMBER(15) := 0;
138: l_api_name VARCHAR2(30) := 'load_entity';
139: BEGIN
140: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
141: fnd_log.STRING(fnd_log.level_procedure,
142: g_pkg_name || '.' || l_api_name,
143: gcs_utility_pkg.g_module_enter || ' p_entity_id = ' ||
144: p_entity_id || ' p_hierarchy_id = ' || p_hierarchy_id ||

Line 141: fnd_log.STRING(fnd_log.level_procedure,

137: l_child_cnt NUMBER(15) := 0;
138: l_api_name VARCHAR2(30) := 'load_entity';
139: BEGIN
140: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
141: fnd_log.STRING(fnd_log.level_procedure,
142: g_pkg_name || '.' || l_api_name,
143: gcs_utility_pkg.g_module_enter || ' p_entity_id = ' ||
144: p_entity_id || ' p_hierarchy_id = ' || p_hierarchy_id ||
145: ' p_cal_period_id = ' || p_cal_period_id ||

Line 321: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

317: l_parent_id number;
318: l_api_name VARCHAR2(30) := 'add_entity';
319:
320: BEGIN
321: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
322: fnd_log.STRING(fnd_log.level_procedure,
323: g_pkg_name || '.' || l_api_name,
324: gcs_utility_pkg.g_module_enter || ' p_entity_id = ' ||
325: p_entity_id || ' p_hierarchy_id = ' || p_hierarchy_id || ' ' ||

Line 322: fnd_log.STRING(fnd_log.level_procedure,

318: l_api_name VARCHAR2(30) := 'add_entity';
319:
320: BEGIN
321: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
322: fnd_log.STRING(fnd_log.level_procedure,
323: g_pkg_name || '.' || l_api_name,
324: gcs_utility_pkg.g_module_enter || ' p_entity_id = ' ||
325: p_entity_id || ' p_hierarchy_id = ' || p_hierarchy_id || ' ' ||
326: ' p_start_date = ' || p_start_date || ' ' ||

Line 439: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

435: x_errbuf := fnd_message.get;
436: x_retcode := fnd_api.g_ret_sts_error;
437:
438: -- Write the appropriate information to the execution report
439: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
440: fnd_log.STRING(fnd_log.level_error,
441: g_pkg_name || '.' || l_api_name,
442: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
443: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 440: fnd_log.STRING(fnd_log.level_error,

436: x_retcode := fnd_api.g_ret_sts_error;
437:
438: -- Write the appropriate information to the execution report
439: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
440: fnd_log.STRING(fnd_log.level_error,
441: g_pkg_name || '.' || l_api_name,
442: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
443: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
444: END IF;

Line 451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

447: x_errbuf := SQLCODE || SQLERRM;
448: x_retcode := fnd_api.g_ret_sts_unexp_error;
449:
450: -- Write the appropriate information to the execution report
451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
452: fnd_log.STRING(fnd_log.level_error,
453: g_pkg_name || '.' || l_api_name,
454: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
455: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 452: fnd_log.STRING(fnd_log.level_error,

448: x_retcode := fnd_api.g_ret_sts_unexp_error;
449:
450: -- Write the appropriate information to the execution report
451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
452: fnd_log.STRING(fnd_log.level_error,
453: g_pkg_name || '.' || l_api_name,
454: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
455: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
456: END IF;

Line 567: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

563: AND fcpa.version_id = g_cal_period_end_date_version
564: AND fcpa.date_assign_value > p_end_date;
565:
566: BEGIN
567: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
568: fnd_log.STRING(fnd_log.level_procedure,
569: g_pkg_name || '.' || l_api_name,
570: gcs_utility_pkg.g_module_enter || ' p_load_id = ' ||
571: p_load_id || ', p_cons_rel_id = ' || p_cons_rel_id ||

Line 568: fnd_log.STRING(fnd_log.level_procedure,

564: AND fcpa.date_assign_value > p_end_date;
565:
566: BEGIN
567: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
568: fnd_log.STRING(fnd_log.level_procedure,
569: g_pkg_name || '.' || l_api_name,
570: gcs_utility_pkg.g_module_enter || ' p_load_id = ' ||
571: p_load_id || ', p_cons_rel_id = ' || p_cons_rel_id ||
572: ', p_hierarchy_id = ' || p_hierarchy_id ||

Line 686: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

682: CLOSE c_cons_rel_data;
683: END IF;
684: END IF;
685:
686: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
687: fnd_log.STRING(fnd_log.level_procedure,
688: g_pkg_name || '.' || l_api_name,
689: gcs_utility_pkg.g_module_success || ' ' ||
690: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 687: fnd_log.STRING(fnd_log.level_procedure,

683: END IF;
684: END IF;
685:
686: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
687: fnd_log.STRING(fnd_log.level_procedure,
688: g_pkg_name || '.' || l_api_name,
689: gcs_utility_pkg.g_module_success || ' ' ||
690: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
691: END IF;

Line 697: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: NULL;
696: WHEN OTHERS THEN
697: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
698: fnd_log.STRING(fnd_log.level_error,
699: g_pkg_name || '.' || l_api_name,
700: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
701: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 698: fnd_log.STRING(fnd_log.level_error,

694: WHEN NO_DATA_FOUND THEN
695: NULL;
696: WHEN OTHERS THEN
697: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
698: fnd_log.STRING(fnd_log.level_error,
699: g_pkg_name || '.' || l_api_name,
700: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
701: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
702: END IF;

Line 744: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

740: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
741:
742: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
743:
744: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
745: fnd_log.STRING(fnd_log.level_procedure,
746: g_pkg_name || '.' || l_api_name,
747: gcs_utility_pkg.g_module_enter ||
748: ', p_hierarchy_id = ' || p_hierarchy_id ||

Line 745: fnd_log.STRING(fnd_log.level_procedure,

741:
742: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
743:
744: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
745: fnd_log.STRING(fnd_log.level_procedure,
746: g_pkg_name || '.' || l_api_name,
747: gcs_utility_pkg.g_module_enter ||
748: ', p_hierarchy_id = ' || p_hierarchy_id ||
749: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 768: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
765: g_pkg_name || '.' || l_api_name || ' EXIT');
766: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
767:
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
769: fnd_log.STRING(fnd_log.level_procedure,
770: g_pkg_name || '.' || l_api_name,
771: gcs_utility_pkg.g_module_success || ' ' ||
772: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 769: fnd_log.STRING(fnd_log.level_procedure,

765: g_pkg_name || '.' || l_api_name || ' EXIT');
766: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
767:
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
769: fnd_log.STRING(fnd_log.level_procedure,
770: g_pkg_name || '.' || l_api_name,
771: gcs_utility_pkg.g_module_success || ' ' ||
772: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
773: END IF;

Line 791: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

787: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
788: x_errbuf);
789: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
790:
791: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
792: fnd_log.STRING(fnd_log.level_error,
793: g_pkg_name || '.' || l_api_name,
794: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
795: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 792: fnd_log.STRING(fnd_log.level_error,

788: x_errbuf);
789: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
790:
791: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
792: fnd_log.STRING(fnd_log.level_error,
793: g_pkg_name || '.' || l_api_name,
794: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
795: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
796: END IF;

Line 821: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

817:
818: l_api_name VARCHAR2(80) := 'submit_update_data_status';
819: BEGIN
820:
821: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
822: fnd_log.STRING(fnd_log.level_procedure,
823: g_pkg_name || '.' || l_api_name,
824: gcs_utility_pkg.g_module_enter || ' p_load_id = ' ||
825: p_load_id || ', p_cons_rel_id = ' || p_cons_rel_id ||

Line 822: fnd_log.STRING(fnd_log.level_procedure,

818: l_api_name VARCHAR2(80) := 'submit_update_data_status';
819: BEGIN
820:
821: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
822: fnd_log.STRING(fnd_log.level_procedure,
823: g_pkg_name || '.' || l_api_name,
824: gcs_utility_pkg.g_module_enter || ' p_load_id = ' ||
825: p_load_id || ', p_cons_rel_id = ' || p_cons_rel_id ||
826: ', p_hierarchy_id = ' || p_hierarchy_id ||

Line 848: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

844: FND_FILE.PUT_LINE(FND_FILE.LOG,
845: g_pkg_name || '.' || l_api_name || ' EXIT : ' ||
846: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
847:
848: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
849: fnd_log.STRING(fnd_log.level_procedure,
850: g_pkg_name || '.' || l_api_name,
851: gcs_utility_pkg.g_module_success || ' ' ||
852: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 849: fnd_log.STRING(fnd_log.level_procedure,

845: g_pkg_name || '.' || l_api_name || ' EXIT : ' ||
846: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
847:
848: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
849: fnd_log.STRING(fnd_log.level_procedure,
850: g_pkg_name || '.' || l_api_name,
851: gcs_utility_pkg.g_module_success || ' ' ||
852: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
853: END IF;

Line 859: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN
857: NULL;
858: WHEN OTHERS THEN
859: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
860: fnd_log.STRING(fnd_log.level_error,
861: g_pkg_name || '.' || l_api_name,
862: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
863: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 860: fnd_log.STRING(fnd_log.level_error,

856: WHEN NO_DATA_FOUND THEN
857: NULL;
858: WHEN OTHERS THEN
859: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
860: fnd_log.STRING(fnd_log.level_error,
861: g_pkg_name || '.' || l_api_name,
862: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM ||
863: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
864: END IF;