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_RAISE_EVENT_PKG dependencies on FND_LOG

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

18: l_success VARCHAR2(30);
19:
20: BEGIN
21:
22: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
24: END IF;
25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

19:
20: BEGIN
21:
22: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
24: END IF;
25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);

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

22: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
24: END IF;
25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);

Line 27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);

23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
24: END IF;
25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);

Line 28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);

24: END IF;
25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);

Line 29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);

25:
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);

Line 30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);

26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);

Line 31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);

27: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Pre-Cons Relationship ID : ' || p_pre_cons_relationship_id);
28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);

Line 32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);

28: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Post-Cons Relationship ID : ' || p_post_cons_relationship_id);
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);
36: END IF;

Line 33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);

29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Type Code : ' || p_trx_type_code);
30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);
36: END IF;
37:

Line 34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);

30: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Day : ' || p_trx_date_day);
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);
36: END IF;
37:
38: l_success := gcs_cons_impact_analysis_pkg.hierarchy_altered

Line 35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);

31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Month : ' || p_trx_date_month);
32: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Transaction Date Year : ' || p_trx_date_year);
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Hidden Flag : ' || p_hidden_flag);
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermediate Trtmnt Id : ' || p_intermediate_trtmnt_id);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.RAISE_HIERARCHY_ALT_EVENT', 'Intermeidate Pct Owned : ' || p_intermediate_pct_owned);
36: END IF;
37:
38: l_success := gcs_cons_impact_analysis_pkg.hierarchy_altered
39: (p_pre_cons_relationship_id => p_pre_cons_relationship_id,

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

45: p_hidden_flag => p_hidden_flag,
46: p_intermediate_trtmnt_id => p_intermediate_trtmnt_id,
47: p_intermediate_pct_owned => p_intermediate_pct_owned);
48:
49: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
50: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
51: END IF;
52:
53: END;

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

46: p_intermediate_trtmnt_id => p_intermediate_trtmnt_id,
47: p_intermediate_pct_owned => p_intermediate_pct_owned);
48:
49: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
50: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_HIERARCHY_ALT_EVENT.begin', '<>');
51: END IF;
52:
53: END;
54:

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

69: l_end_date_version_id NUMBER :=
70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:
73: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');
75: END IF;
76:
77: SELECT to_char(date_assign_value, 'DD-MM-RR')

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

70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:
73: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');
75: END IF;
76:
77: SELECT to_char(date_assign_value, 'DD-MM-RR')
78: INTO l_cal_period_end_date

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

128: argument8 => p_analysis_cycle_id);
129:
130: COMMIT;
131:
132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.end', '<>');
134: END IF;
135:
136: END;

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

129:
130: COMMIT;
131:
132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.end', '<>');
134: END IF;
135:
136: END;
137:

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

153: l_end_date_version_id NUMBER :=
154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:
157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');
159: END IF;
160:
161: SELECT entity_name || ' on ' || to_char(sysdate, 'DD-MM-RR HH24:MI:SS')

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

154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:
157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');
159: END IF;
160:
161: SELECT entity_name || ' on ' || to_char(sysdate, 'DD-MM-RR HH24:MI:SS')
162: INTO l_event_key

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

237: COMMIT;
238:
239: WF_ENGINE.THRESHOLD := l_threshold;
240:
241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.end', '<>');
243: END IF;
244:
245: END;

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

238:
239: WF_ENGINE.THRESHOLD := l_threshold;
240:
241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.end', '<>');
243: END IF;
244:
245: END;
246:

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

279: l_process_identifier_exists NUMBER:=0;
280:
281: BEGIN
282:
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_CONSOLIDATION.begin', '<>');
285: END IF;
286: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.
287: --This fix is for running REQUEST SET.

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

280:
281: BEGIN
282:
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_CONSOLIDATION.begin', '<>');
285: END IF;
286: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.
287: --This fix is for running REQUEST SET.
288: BEGIN

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

562: BETWEEN gcr.start_date AND NVL(gcr.end_date,
563: TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));
564: END IF;
565:
566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_CONSOLIDATION.end', '<>');
568: END IF;
569:
570: EXCEPTION

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

563: TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));
564: END IF;
565:
566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_CONSOLIDATION.end', '<>');
568: END IF;
569:
570: EXCEPTION
571: WHEN OTHERS THEN