eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_CONS_ENGINE_PKG dependencies on FND_LOG

Line 34: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

30: l_table_name VARCHAR2(30);
31: l_conc_request_status BOOLEAN;
32:
33: BEGIN
34: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
35: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.begin', '<>');
36: END IF;
37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 35: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.begin', '<>');

31: l_conc_request_status BOOLEAN;
32:
33: BEGIN
34: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
35: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.begin', '<>');
36: END IF;
37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);

Line 38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

34: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
35: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.begin', '<>');
36: END IF;
37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);
40: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Consoliation Entity : ' || p_cal_period_id);
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Analysis Cycle ID: ' || p_analysis_cycle_id);
42: END IF;

Line 39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);

35: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.begin', '<>');
36: END IF;
37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);
40: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Consoliation Entity : ' || p_cal_period_id);
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Analysis Cycle ID: ' || p_analysis_cycle_id);
42: END IF;
43:

Line 40: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Consoliation Entity : ' || p_cal_period_id);

36: END IF;
37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);
40: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Consoliation Entity : ' || p_cal_period_id);
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Analysis Cycle ID: ' || p_analysis_cycle_id);
42: END IF;
43:
44: -- Bugfix 5187689: Make sure the table has been selected before submitting the program

Line 41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Analysis Cycle ID: ' || p_analysis_cycle_id);

37:
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Hierarchy : ' || p_hierarchy_id);
40: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Consoliation Entity : ' || p_cal_period_id);
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_EPB_DATA_TRANSFER', 'Analysis Cycle ID: ' || p_analysis_cycle_id);
42: END IF;
43:
44: -- Bugfix 5187689: Make sure the table has been selected before submitting the program
45: SELECT epb_table_name

Line 63: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

59: argument4 => p_analysis_cycle_id);
60:
61: END IF;
62:
63: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.end', '<>');
65: END IF;
66:
67: COMMIT;

Line 64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.end', '<>');

60:
61: END IF;
62:
63: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_EPB_DATA_TRANSFER.end', '<>');
65: END IF;
66:
67: COMMIT;
68: EXCEPTION

Line 138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

134: AND p_cal_period_end_date BETWEEN gcr.start_date and NVL(end_date,to_date(p_cal_period_end_date,'DD-MM-RR'));
135:
136: BEGIN
137:
138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.begin', '<>');
140: END IF;
141:
142: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.begin', '<>');

135:
136: BEGIN
137:
138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.begin', '<>');
140: END IF;
141:
142: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
143:

Line 217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

213: END LOOP;
214:
215: result := 'COMPLETE';
216:
217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.end', '<>');
219: END IF;
220:
221: END prepare_immediate_children;

Line 218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.end', '<>');

214:
215: result := 'COMPLETE';
216:
217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PREPARE_IMMEDIATE_CHILDREN.end', '<>');
219: END IF;
220:
221: END prepare_immediate_children;
222:

Line 271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

267: AND gcer.run_name = gcerd.run_name
268: ANd gcer.run_entity_id = gcerd.consolidation_entity_id;
269:
270: BEGIN
271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS', '<>');
273: END IF;
274:
275: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS', '<>');

268: ANd gcer.run_entity_id = gcerd.consolidation_entity_id;
269:
270: BEGIN
271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS', '<>');
273: END IF;
274:
275: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
276:

Line 311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

307: ELSE
308: result := 'COMPLETE:F';
309: END IF;
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS.end', '<>');
313: END IF;
314:
315: END spawn_oper_entity_process;

Line 312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS.end', '<>');

308: result := 'COMPLETE:F';
309: END IF;
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_OPER_ENTITY_PROCESS.end', '<>');
313: END IF;
314:
315: END spawn_oper_entity_process;
316:

Line 337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

333: l_request_error_code VARCHAR2(2000);
334:
335: BEGIN
336:
337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION', '<>');
339: END IF;
340:
341:

Line 338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION', '<>');

334:
335: BEGIN
336:
337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION', '<>');
339: END IF;
340:
341:
342: l_execution_mode := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'EXECUTION_MODE', FALSE);

Line 435: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

431: END;
432:
433: END IF;
434:
435: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION.end', '<>');
437: END IF;
438:
439: END execute_data_preparation;

Line 436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION.end', '<>');

432:
433: END IF;
434:
435: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_DATA_PREPARATION.end', '<>');
437: END IF;
438:
439: END execute_data_preparation;
440:

Line 461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

457: l_request_error_code VARCHAR2(200);
458:
459: BEGIN
460:
461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS.end', '<>');
463: END IF;
464:
465: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS.end', '<>');

458:
459: BEGIN
460:
461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS.end', '<>');
463: END IF;
464:
465: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
466: itemkey,

Line 523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

519: ELSE
520: result := 'COMPLETE:FULL';
521: END IF;
522:
523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS', '<>');
525: END IF;
526:
527: END init_oper_entity_process;

Line 524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS', '<>');

520: result := 'COMPLETE:FULL';
521: END IF;
522:
523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INIT_OPER_ENTITY_PROCESS', '<>');
525: END IF;
526:
527: END init_oper_entity_process;
528:

Line 547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

543: l_run_detail_id NUMBER(15);
544:
545: BEGIN
546:
547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
549: END IF;
550:
551: l_entity_id := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CONS_ENTITY', FALSE);

Line 548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');

544:
545: BEGIN
546:
547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
549: END IF;
550:
551: l_entity_id := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CONS_ENTITY', FALSE);
552: l_run_identifier := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'RUN_IDENTIFIER', FALSE);

Line 582: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

578: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);
579:
580: END IF;
581:
582: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
584: END IF;
585:
586: END check_aggregation_required;

Line 583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');

579:
580: END IF;
581:
582: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_AGGREGATION_REQUIRED', '<>');
584: END IF;
585:
586: END check_aggregation_required;
587:

Line 607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

603: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
604:
605: BEGIN
606:
607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
608: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');
609: END IF;
610:
611:

Line 608: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');

604:
605: BEGIN
606:
607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
608: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');
609: END IF;
610:
611:
612: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

664: -- p_run_detail_id => l_run_detail_id);
665:
666: result := 'COMPLETE';
667:
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');
670: END IF;
671:
672: END execute_aggregation;

Line 669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');

665:
666: result := 'COMPLETE';
667:
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_AGGREGATION', '<>');
670: END IF;
671:
672: END execute_aggregation;
673:

Line 680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

676: IS PRAGMA AUTONOMOUS_TRANSACTION;
677:
678: BEGIN
679:
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');
682: END IF;
683:
684: --Bugfix 4928211: For performance purposes deleting from gcs_flattened relations when parent node is fully complete with consolidation

Line 681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');

677:
678: BEGIN
679:
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');
682: END IF;
683:
684: --Bugfix 4928211: For performance purposes deleting from gcs_flattened relations when parent node is fully complete with consolidation
685: DELETE FROM gcs_flattened_relns

Line 690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

686: WHERE run_name = cons_entity_wf_info.run_identifier;
687:
688: COMMIT;
689:
690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');
692: END IF;
693:
694: END;

Line 691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');

687:
688: COMMIT;
689:
690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');
692: END IF;
693:
694: END;
695:

Line 720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

716: l_run_detail_id NUMBER(15);
717: l_top_entity_id NUMBER;
718:
719: BEGIN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
722: END IF;
723:
724: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');

717: l_top_entity_id NUMBER;
718:
719: BEGIN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
722: END IF;
723:
724: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
725:

Line 830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

826: p_bp_request_error_code => l_status_code);
827:
828: result := 'COMPLETE';
829:
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
832: END IF;
833:
834: EXCEPTION

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');

827:
828: result := 'COMPLETE';
829:
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
832: END IF;
833:
834: EXCEPTION
835: WHEN OTHERS THEN

Line 837: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

833:
834: EXCEPTION
835: WHEN OTHERS THEN
836: result := 'COMPLETE';
837: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENt', SQLERRM);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
840: END IF;
841:

Line 838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENt', SQLERRM);

834: EXCEPTION
835: WHEN OTHERS THEN
836: result := 'COMPLETE';
837: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENt', SQLERRM);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
840: END IF;
841:
842: END raise_completion_event;

Line 839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');

835: WHEN OTHERS THEN
836: result := 'COMPLETE';
837: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENt', SQLERRM);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_COMPLETION_EVENT', '<>');
840: END IF;
841:
842: END raise_completion_event;
843:

Line 851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

847: IS PRAGMA AUTONOMOUS_TRANSACTION;
848:
849: BEGIN
850:
851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');
853: END IF;
854:
855: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');

848:
849: BEGIN
850:
851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');
853: END IF;
854:
855: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns
856:

Line 898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

894: BETWEEN gcr.start_date AND NVL(gcr.end_date, cons_entity_wf_info.cal_period_end_date);
895:
896: COMMIT;
897:
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');
900: END IF;
901:
902: END;

Line 899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');

895:
896: COMMIT;
897:
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');
900: END IF;
901:
902: END;
903:

Line 951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

947:
948:
949: BEGIN
950:
951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
952: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');
953: END IF;
954:
955:

Line 952: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');

948:
949: BEGIN
950:
951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
952: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');
953: END IF;
954:
955:
956: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 1021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1017: ELSE
1018: result := 'COMPLETE:F';
1019: END IF;
1020:
1021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');
1023: END IF;
1024:
1025: END spawn_cons_entity_process;

Line 1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');

1018: result := 'COMPLETE:F';
1019: END IF;
1020:
1021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SPAWN_CONS_ENTITY_PROCESS', '<>');
1023: END IF;
1024:
1025: END spawn_cons_entity_process;
1026:

Line 1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1044: AND enabled_flag = 'Y';
1045:
1046: BEGIN
1047:
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');
1050: END IF;
1051:
1052: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 1049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');

1045:
1046: BEGIN
1047:
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');
1050: END IF;
1051:
1052: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
1053:

Line 1065: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1061: END LOOP;
1062:
1063: result := 'COMPLETE';
1064:
1065: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1066: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');
1067: END IF;
1068:
1069: END initialize_cons_process;

Line 1066: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');

1062:
1063: result := 'COMPLETE';
1064:
1065: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1066: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INITIALIZE_CONS_PROCESS', '<>');
1067: END IF;
1068:
1069: END initialize_cons_process;
1070:

Line 1087: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1083: l_impacted_flag VARCHAr2(1);
1084:
1085: BEGIN
1086:
1087: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');
1089: END IF;
1090:
1091: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');

1084:
1085: BEGIN
1086:
1087: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');
1089: END IF;
1090:
1091: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);
1092:

Line 1128: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1124: result := 'COMPLETE:T';
1125: END IF;
1126:
1127:
1128: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');
1130: END IF;
1131:
1132: EXCEPTION

Line 1129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');

1125: END IF;
1126:
1127:
1128: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_CONS_ENTITY_STATUS', '<>');
1130: END IF;
1131:
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN

Line 1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1150: l_locked_flag VARCHAR2(1);
1151:
1152: BEGIN
1153:
1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.begin', '<>');
1156: END IF;
1157:
1158: UPDATE gcs_cons_eng_runs

Line 1155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.begin', '<>');

1151:
1152: BEGIN
1153:
1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.begin', '<>');
1156: END IF;
1157:
1158: UPDATE gcs_cons_eng_runs
1159: SET most_recent_flag = 'Y'

Line 1221: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1217: RETURN run_detail_id INTO p_run_detail_id;
1218:
1219: COMMIT;
1220:
1221: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.end', '<>');
1223: END IF;
1224: END;
1225:

Line 1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.end', '<>');

1218:
1219: COMMIT;
1220:
1221: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.end', '<>');
1223: END IF;
1224: END;
1225:
1226: PROCEDURE retrieve_prior_runs( itemtype IN VARCHAR2,

Line 1241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1237: l_run_detail_id NUMBER(15);
1238:
1239: BEGIN
1240:
1241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');
1243: END IF;
1244:
1245:

Line 1242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');

1238:
1239: BEGIN
1240:
1241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');
1243: END IF;
1244:
1245:
1246: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype, itemkey, cons_entity_wf_info);

Line 1255: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1251: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'RUN_DETAIL_ID', l_run_detail_id);
1252:
1253: result := 'COMPLETE';
1254:
1255: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');
1257: END IF;
1258:
1259: END retrieve_prior_runs;

Line 1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');

1252:
1253: result := 'COMPLETE';
1254:
1255: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RETRIEVE_PRIOR_RUNS', '<>');
1257: END IF;
1258:
1259: END retrieve_prior_runs;
1260: