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

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

49: l_cal_period_map_id NUMBER;
50: l_cal_period_record gcs_utility_pkg.r_cal_period_info;
51:
52: BEGIN
53: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
54: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
55: g_api || '.ROLLUP_IMPACT.begin',
56: '<>');
57: END IF;

Line 54: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

50: l_cal_period_record gcs_utility_pkg.r_cal_period_info;
51:
52: BEGIN
53: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
54: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
55: g_api || '.ROLLUP_IMPACT.begin',
56: '<>');
57: END IF;
58:

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

55: g_api || '.ROLLUP_IMPACT.begin',
56: '<>');
57: END IF;
58:
59: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
61: g_api || '.ROLLUP_IMPACT',
62: 'Consolidation Entity : ' ||
63: p_consolidation_entity_id);

Line 60: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

56: '<>');
57: END IF;
58:
59: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
61: g_api || '.ROLLUP_IMPACT',
62: 'Consolidation Entity : ' ||
63: p_consolidation_entity_id);
64: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 64: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

60: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
61: g_api || '.ROLLUP_IMPACT',
62: 'Consolidation Entity : ' ||
63: p_consolidation_entity_id);
64: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
65: g_api || '.ROLLUP_IMPACT',
66: 'Hierarchy : ' || p_hierarchy_id);
67: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
68: g_api || '.ROLLUP_IMPACT',

Line 67: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

63: p_consolidation_entity_id);
64: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
65: g_api || '.ROLLUP_IMPACT',
66: 'Hierarchy : ' || p_hierarchy_id);
67: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
68: g_api || '.ROLLUP_IMPACT',
69: 'Calendar Period Id : ' || p_cal_period_id);
70: END IF;
71:

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

91: AND gcpm.TARGET_CALENDAR_ID = ghb.CALENDAR_ID
92: AND gcpm.TARGET_DIMENSION_GROUP_ID = ghb.DIMENSION_GROUP_ID
93: AND ghb.HIERARCHY_ID = p_hierarchy_id
94: AND fcpb.cal_period_id = p_cal_period_id;
95: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
97: g_api || '.ROLLUP_IMPACT',
98: 'Calendar Period Map Id = ' || l_cal_period_map_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

92: AND gcpm.TARGET_DIMENSION_GROUP_ID = ghb.DIMENSION_GROUP_ID
93: AND ghb.HIERARCHY_ID = p_hierarchy_id
94: AND fcpb.cal_period_id = p_cal_period_id;
95: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
97: g_api || '.ROLLUP_IMPACT',
98: 'Calendar Period Map Id = ' || l_cal_period_map_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
100: g_api || '.ROLLUP_IMPACT',

Line 99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

95: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
97: g_api || '.ROLLUP_IMPACT',
98: 'Calendar Period Map Id = ' || l_cal_period_map_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
100: g_api || '.ROLLUP_IMPACT',
101: ' Source Calendar Id = ' || l_src_calendar_id);
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
103: g_api || '.ROLLUP_IMPACT',

Line 102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

98: 'Calendar Period Map Id = ' || l_cal_period_map_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
100: g_api || '.ROLLUP_IMPACT',
101: ' Source Calendar Id = ' || l_src_calendar_id);
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
103: g_api || '.ROLLUP_IMPACT',
104: 'Source Dimension Group Id = ' ||
105: l_src_dimension_group_id);
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
103: g_api || '.ROLLUP_IMPACT',
104: 'Source Dimension Group Id = ' ||
105: l_src_dimension_group_id);
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
107: g_api || '.ROLLUP_IMPACT',
108: ' Target Calendar Id = ' || l_tgt_calendar_id);
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: g_api || '.ROLLUP_IMPACT',

Line 109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

105: l_src_dimension_group_id);
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
107: g_api || '.ROLLUP_IMPACT',
108: ' Target Calendar Id = ' || l_tgt_calendar_id);
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: g_api || '.ROLLUP_IMPACT',
111: 'Target Dimension Group Id = ' ||
112: l_tgt_dimension_group_id);
113: END IF;

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

113: END IF;
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_period_mapping_required := 'N';
117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
119: g_api || '.ROLLUP_IMPACT.exception',
120: 'NO DATA FOUND ');
121: END IF;

Line 118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

114: EXCEPTION
115: WHEN OTHERS THEN
116: l_period_mapping_required := 'N';
117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
119: g_api || '.ROLLUP_IMPACT.exception',
120: 'NO DATA FOUND ');
121: END IF;
122: END;

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

121: END IF;
122: END;
123: IF (l_period_mapping_required = 'Y') THEN
124: --period_mapping_required
125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
127: g_api || '.ROLLUP_IMPACT',
128: '<< Calendar Period Mapping required >>');
129: END IF;

Line 126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

122: END;
123: IF (l_period_mapping_required = 'Y') THEN
124: --period_mapping_required
125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
127: g_api || '.ROLLUP_IMPACT',
128: '<< Calendar Period Mapping required >>');
129: END IF;
130:

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

156: l_cal_period_record.cal_period_year - 1,
157: 'FOLLOWING',
158: l_cal_period_record.cal_period_year + 1);
159: l_cal_period_id := l_target_cal_period_id;
160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
162: g_api || '.ROLLUP_IMPACT',
163: 'Target Calendar Period Id = ' || l_cal_period_id);
164: END IF;

Line 161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

157: 'FOLLOWING',
158: l_cal_period_record.cal_period_year + 1);
159: l_cal_period_id := l_target_cal_period_id;
160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
162: g_api || '.ROLLUP_IMPACT',
163: 'Target Calendar Period Id = ' || l_cal_period_id);
164: END IF;
165: ELSE

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

163: 'Target Calendar Period Id = ' || l_cal_period_id);
164: END IF;
165: ELSE
166: --l_period_mapping_not_required
167: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
168: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
169: g_api || '.ROLLUP_IMPACT',
170: '<< Calendar Period Mapping is NOT required >>');
171: END IF;

Line 168: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

164: END IF;
165: ELSE
166: --l_period_mapping_not_required
167: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
168: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
169: g_api || '.ROLLUP_IMPACT',
170: '<< Calendar Period Mapping is NOT required >>');
171: END IF;
172: l_cal_period_id := p_cal_period_id;

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

178: WHERE cal_period_id = l_cal_period_id
179: AND attribute_id = l_end_date_attribute_id
180: AND version_id = l_end_date_version_id;
181:
182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: g_api || '.ROLLUP_IMPACT',
185: ' Calendar Period End Date = ' || l_end_date);
186: END IF;

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

179: AND attribute_id = l_end_date_attribute_id
180: AND version_id = l_end_date_version_id;
181:
182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: g_api || '.ROLLUP_IMPACT',
185: ' Calendar Period End Date = ' || l_end_date);
186: END IF;
187: WHILE (1 = 1) LOOP

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

189: FOR v_parent_entity IN c_parent_entity(l_child_entity_id,
190: p_hierarchy_id,
191: l_end_date,
192: l_cal_period_id) LOOP
193: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
195: g_api || '.ROLLUP_IMPACT',
196: ' l_child_entity_id = ' || l_child_entity_id);
197: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

190: p_hierarchy_id,
191: l_end_date,
192: l_cal_period_id) LOOP
193: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
195: g_api || '.ROLLUP_IMPACT',
196: ' l_child_entity_id = ' || l_child_entity_id);
197: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
198: g_api || '.ROLLUP_IMPACT',

Line 197: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

193: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
195: g_api || '.ROLLUP_IMPACT',
196: ' l_child_entity_id = ' || l_child_entity_id);
197: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
198: g_api || '.ROLLUP_IMPACT',
199: ' Updating the impacted status of Entity with Entity_Id = ' ||
200: v_parent_entity.parent_entity_id);
201: END IF;

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

212: ELSE
213: l_rows_updated := 1;
214: END IF;
215:
216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
218: g_api || '.ROLLUP_IMPACT',
219: ' Done');
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

213: l_rows_updated := 1;
214: END IF;
215:
216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
218: g_api || '.ROLLUP_IMPACT',
219: ' Done');
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
221: g_api || '.ROLLUP_IMPACT',

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
218: g_api || '.ROLLUP_IMPACT',
219: ' Done');
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
221: g_api || '.ROLLUP_IMPACT',
222: 'SQL%ROWCOUNT = ' || l_rows_updated);
223: END IF;
224: l_child_entity_id := v_parent_entity.parent_entity_id;

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

229: EXIT;
230: END IF;
231: END LOOP;
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
235: g_api || '.ROLLUP_IMPACT.end',
236: '<>');
237: END IF;

Line 234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

230: END IF;
231: END LOOP;
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
235: g_api || '.ROLLUP_IMPACT.end',
236: '<>');
237: END IF;
238: EXCEPTION

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

237: END IF;
238: EXCEPTION
239: WHEN OTHERS THEN
240: l_period_mapping_required := 'N';
241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
243: g_api || '.ROLLUP_IMPACT.exception',
244: SUBSTR(SQLERRM, 1, 100));
245: END IF;

Line 242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

238: EXCEPTION
239: WHEN OTHERS THEN
240: l_period_mapping_required := 'N';
241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
243: g_api || '.ROLLUP_IMPACT.exception',
244: SUBSTR(SQLERRM, 1, 100));
245: END IF;
246: -- End Bug fix : 6029020

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

262:
263: IS
264:
265: BEGIN
266: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
267: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
268: g_api || '.INSERT_IMPACT_ANALYSIS.begin',
269: '<>');
270: END IF;

Line 267: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

263: IS
264:
265: BEGIN
266: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
267: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
268: g_api || '.INSERT_IMPACT_ANALYSIS.begin',
269: '<>');
270: END IF;
271:

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

311: FND_GLOBAL.LOGIN_ID,
312: 1, -- Bugfix 3718098 : Added OBJECT_VERSION_NUMBER per Release Standards,
313: p_load_id);
314:
315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
316: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
317: g_api || '.INSERT_IMPACT_ANALYSIS.end',
318: '<>');
319: END IF;

Line 316: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

312: 1, -- Bugfix 3718098 : Added OBJECT_VERSION_NUMBER per Release Standards,
313: p_load_id);
314:
315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
316: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
317: g_api || '.INSERT_IMPACT_ANALYSIS.end',
318: '<>');
319: END IF;
320:

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

397: END IF;
398: l_intermediate_trtmnt_id := p_intermediate_trtmnt_id;
399: l_intermediate_pct_owned := p_intermediate_pct_owned;
400:
401: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
403: g_api || '.HIERARCHY_ALTERED.begin',
404: '<>');
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

398: l_intermediate_trtmnt_id := p_intermediate_trtmnt_id;
399: l_intermediate_pct_owned := p_intermediate_pct_owned;
400:
401: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
403: g_api || '.HIERARCHY_ALTERED.begin',
404: '<>');
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
406: g_api || '.HIERARCHY_ALTERED',

Line 405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

401: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
403: g_api || '.HIERARCHY_ALTERED.begin',
404: '<>');
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
406: g_api || '.HIERARCHY_ALTERED',
407: 'Pre-Cons Relationship Id : ' ||
408: p_pre_cons_relationship_id);
409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
406: g_api || '.HIERARCHY_ALTERED',
407: 'Pre-Cons Relationship Id : ' ||
408: p_pre_cons_relationship_id);
409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
410: g_api || '.HIERARCHY_ALTERED',
411: 'Post-Cons Relationship Id : ' ||
412: p_post_cons_relationship_id);
413: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 413: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
410: g_api || '.HIERARCHY_ALTERED',
411: 'Post-Cons Relationship Id : ' ||
412: p_post_cons_relationship_id);
413: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
414: g_api || '.HIERARCHY_ALTERED',
415: 'Trx Date : ' || l_trx_date);
416: END IF;
417:

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

475: AND fcpa_end_date.version_id = l_cp_end_date_version_id
476: AND l_trx_date BETWEEN fcpa_start_date.date_assign_value AND
477: fcpa_end_date.date_assign_value;
478:
479: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
481: g_api || '.HIERARCHY_ALTERED',
482: 'Calendar Period : ' || l_cal_period_id);
483: END IF;

Line 480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

476: AND l_trx_date BETWEEN fcpa_start_date.date_assign_value AND
477: fcpa_end_date.date_assign_value;
478:
479: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
481: g_api || '.HIERARCHY_ALTERED',
482: 'Calendar Period : ' || l_cal_period_id);
483: END IF;
484:

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

544: gcs_fem_hier_sync_pkg.entity_added(p_hierarchy_id => l_hierarchy_id,
545: p_cons_relationship_id => l_post_cons_relationship_id);
546: END IF;
547:
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
550: g_api || '.HIERARCHY_ALTERED',
551: 'Checking for Impact Analysis');
552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

545: p_cons_relationship_id => l_post_cons_relationship_id);
546: END IF;
547:
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
550: g_api || '.HIERARCHY_ALTERED',
551: 'Checking for Impact Analysis');
552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
553: g_api || '.HIERARCHY_ALTERED',

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
550: g_api || '.HIERARCHY_ALTERED',
551: 'Checking for Impact Analysis');
552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
553: g_api || '.HIERARCHY_ALTERED',
554: 'Parent Entity ID : ' || l_parent_entity_id);
555: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
556: g_api || '.HIERARCHY_ALTERED',

Line 555: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

551: 'Checking for Impact Analysis');
552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
553: g_api || '.HIERARCHY_ALTERED',
554: 'Parent Entity ID : ' || l_parent_entity_id);
555: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
556: g_api || '.HIERARCHY_ALTERED',
557: 'Hierarchy ID : ' || l_hierarchy_id);
558: END IF;
559:

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

585: AND gcer_inner.most_recent_flag = 'Y'
586: AND gcer_inner.cal_period_id > l_cal_period_id);
587: END;
588:
589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
591: g_api || '.HIERARCHY_ALTERED',
592: 'Run Name :');
593: END IF;

Line 590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

586: AND gcer_inner.cal_period_id > l_cal_period_id);
587: END;
588:
589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
591: g_api || '.HIERARCHY_ALTERED',
592: 'Run Name :');
593: END IF;
594:

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

597: FROM fem_entities_vl fev_parent, fem_entities_vl fev_child
598: WHERE fev_parent.entity_id = l_parent_entity_id
599: AND fev_child.entity_id = l_child_entity_id;
600:
601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
603: g_api || '.HIERARCHY_ALTERED',
604: 'Pre Cons Relatonship Id :' ||
605: l_pre_cons_relationship_id);

Line 602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

598: WHERE fev_parent.entity_id = l_parent_entity_id
599: AND fev_child.entity_id = l_child_entity_id;
600:
601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
603: g_api || '.HIERARCHY_ALTERED',
604: 'Pre Cons Relatonship Id :' ||
605: l_pre_cons_relationship_id);
606: END IF;

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

614: p_post_relationship_id => l_post_cons_relationship_id,
615: p_date_token => l_trx_date);
616:
617: ELSIF (l_post_cons_relationship_id = -1) THEN
618: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
620: g_api || '.HIERARCHY_ALTERED',
621: 'Post Cons Relatonship Id :' ||
622: l_pre_cons_relationship_id);

Line 619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

615: p_date_token => l_trx_date);
616:
617: ELSIF (l_post_cons_relationship_id = -1) THEN
618: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
620: g_api || '.HIERARCHY_ALTERED',
621: 'Post Cons Relatonship Id :' ||
622: l_pre_cons_relationship_id);
623: END IF;

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

631: p_date_token => l_trx_date);
632:
633: ELSE
634:
635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
637: g_api || '.hierarchy_altered',
638: 'Original Treatment Id : ' || l_orig_treatment_id);
639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

632:
633: ELSE
634:
635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
637: g_api || '.hierarchy_altered',
638: 'Original Treatment Id : ' || l_orig_treatment_id);
639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
640: g_api || '.hierarchy_altered',

Line 639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
637: g_api || '.hierarchy_altered',
638: 'Original Treatment Id : ' || l_orig_treatment_id);
639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
640: g_api || '.hierarchy_altered',
641: 'New Treatment Id : ' || l_new_treatment_id);
642: END IF;
643:

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

660: AND gcs_new.language = USERENV('LANG');
661:
662: END IF;
663:
664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: g_api || '.HIERARCHY_ALTERED',
667: 'Original Pct Owned : ' || l_new_pct_owned);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

661:
662: END IF;
663:
664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: g_api || '.HIERARCHY_ALTERED',
667: 'Original Pct Owned : ' || l_new_pct_owned);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: g_api || '.HIERARCHY_ALTERED',

Line 668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: g_api || '.HIERARCHY_ALTERED',
667: 'Original Pct Owned : ' || l_new_pct_owned);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: g_api || '.HIERARCHY_ALTERED',
670: 'New Pct Owned : ' || l_orig_pct_owned);
671: END IF;
672:

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

681: p_date_token => l_trx_date);
682:
683: END IF;
684:
685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
687: g_api || '.HIERARCHY_ALTERED',
688: 'Original Curr Trtmnt : ' || l_orig_curr_trtmnt_id);
689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

682:
683: END IF;
684:
685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
687: g_api || '.HIERARCHY_ALTERED',
688: 'Original Curr Trtmnt : ' || l_orig_curr_trtmnt_id);
689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
690: g_api || '.HIERARCHY_ALTERED',

Line 689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
687: g_api || '.HIERARCHY_ALTERED',
688: 'Original Curr Trtmnt : ' || l_orig_curr_trtmnt_id);
689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
690: g_api || '.HIERARCHY_ALTERED',
691: 'New Curr Trtmnt : ' || l_new_curr_trtmnt_id);
692: END IF;
693:

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

734: p_category_code => 'NOT_APPLICABLE');
735:
736: END IF;
737:
738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
740: g_api || '.HIERARCHY_ALTERED',
741: '<>');
742: END IF;

Line 739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

735:
736: END IF;
737:
738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
740: g_api || '.HIERARCHY_ALTERED',
741: '<>');
742: END IF;
743: EXCEPTION

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

741: '<>');
742: END IF;
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
747: g_api || '.HIERARCHY_ALTERED',
748: 'No Data Found');
749: END IF;

Line 746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

742: END IF;
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
747: g_api || '.HIERARCHY_ALTERED',
748: 'No Data Found');
749: END IF;
750: RETURN 'SUCCESS'; -- NO_IMPACT_OCCURRED

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

817: NVL(gcr.end_date, fcpa.date_assign_value);
818:
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_api || '.DATA_SUB_LOAD_EXECUTED.begin',
824: '<>');
825: END IF;

Line 822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

818:
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_api || '.DATA_SUB_LOAD_EXECUTED.begin',
824: '<>');
825: END IF;
826:

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

939: p_load_id => l_load_id);
940:
941: END LOOP;
942:
943: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
945: g_api || '.DATA_SUB_LOAD_EXECUTED.end',
946: '<>');
947: END IF;

Line 944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

940:
941: END LOOP;
942:
943: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
945: g_api || '.DATA_SUB_LOAD_EXECUTED.end',
946: '<>');
947: END IF;
948:

Line 952: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

948:
949: RETURN 'SUCCESS';
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
954: g_api || '.DATA_SUB_LOAD_EXECUTED',
955: SQLERRM);
956: END IF;

Line 953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

949: RETURN 'SUCCESS';
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
954: g_api || '.DATA_SUB_LOAD_EXECUTED',
955: SQLERRM);
956: END IF;
957: RETURN 'SUCCESS';

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

983: .version_id;
984:
985: BEGIN
986:
987: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
988: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
989: g_api || '.ACQDISP_ALTERED.begin',
990: '<>');
991: END IF;

Line 988: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

984:
985: BEGIN
986:
987: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
988: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
989: g_api || '.ACQDISP_ALTERED.begin',
990: '<>');
991: END IF;
992:

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

997: l_parameter_list));
998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
999: l_parameter_list));
1000:
1001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1003: g_api || '.ACQDISP_ALTERED',
1004: 'Change Type Code : ' || l_change_type_code);
1005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
999: l_parameter_list));
1000:
1001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1003: g_api || '.ACQDISP_ALTERED',
1004: 'Change Type Code : ' || l_change_type_code);
1005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1006: g_api || '.ACQDISP_ALTERED',

Line 1005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1003: g_api || '.ACQDISP_ALTERED',
1004: 'Change Type Code : ' || l_change_type_code);
1005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1006: g_api || '.ACQDISP_ALTERED',
1007: 'Entry ID : ' || l_entry_id);
1008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1009: g_api || '.ACQDISP_ALTERED',

Line 1008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1004: 'Change Type Code : ' || l_change_type_code);
1005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1006: g_api || '.ACQDISP_ALTERED',
1007: 'Entry ID : ' || l_entry_id);
1008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1009: g_api || '.ACQDISP_ALTERED',
1010: 'Original Entry ID : ' || l_orig_entry_id);
1011: END IF;
1012:

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

1027: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1028: AND fcpa_start.attribute_id = l_cal_period_attr
1029: AND fcpa_start.version_id = l_cal_period_version;
1030:
1031: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1033: g_api || '.ACQDISP_ALTERED',
1034: 'End Date Value : ' || l_start_cp_end_date);
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1028: AND fcpa_start.attribute_id = l_cal_period_attr
1029: AND fcpa_start.version_id = l_cal_period_version;
1030:
1031: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1033: g_api || '.ACQDISP_ALTERED',
1034: 'End Date Value : ' || l_start_cp_end_date);
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1036: g_api || '.ACQDISP_ALTERED',

Line 1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1031: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1033: g_api || '.ACQDISP_ALTERED',
1034: 'End Date Value : ' || l_start_cp_end_date);
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1036: g_api || '.ACQDISP_ALTERED',
1037: 'Entity ID : ' || l_entity_id);
1038: END IF;
1039:

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

1125: p_run_name => l_run_name,
1126: p_cons_entity_id => l_cons_entity_id,
1127: p_category_code => 'NOT_APPLICABLE');
1128:
1129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1131: g_api || '.ACQDISP_ALTERED.end',
1132: '<>');
1133: END IF;

Line 1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1126: p_cons_entity_id => l_cons_entity_id,
1127: p_category_code => 'NOT_APPLICABLE');
1128:
1129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1131: g_api || '.ACQDISP_ALTERED.end',
1132: '<>');
1133: END IF;
1134:

Line 1139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1135: RETURN 'SUCCESS';
1136:
1137: EXCEPTION
1138: WHEN NO_DATA_FOUND THEN
1139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1140: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1141: g_api || '.ACQDISP_ALTERED',
1142: 'Error occurred : ' || SQLERRM);
1143: END IF;

Line 1140: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1136:
1137: EXCEPTION
1138: WHEN NO_DATA_FOUND THEN
1139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1140: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1141: g_api || '.ACQDISP_ALTERED',
1142: 'Error occurred : ' || SQLERRM);
1143: END IF;
1144: RETURN 'SUCCESS';

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

1165: l_email VARCHAR2(200);
1166:
1167: BEGIN
1168:
1169: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1171: g_api || '.ADJUSTMENT_ALTERED.begin',
1172: '<>');
1173: END IF;

Line 1170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1166:
1167: BEGIN
1168:
1169: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1171: g_api || '.ADJUSTMENT_ALTERED.begin',
1172: '<>');
1173: END IF;
1174:

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

1178: l_parameter_list));
1179: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
1180: l_parameter_list));
1181:
1182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1184: g_api || '.ADJUSTMENT_ALTERED',
1185: 'Entry ID : ' || l_entry_id);
1186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1179: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
1180: l_parameter_list));
1181:
1182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1184: g_api || '.ADJUSTMENT_ALTERED',
1185: 'Entry ID : ' || l_entry_id);
1186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1187: g_api || '.ADJUSTMENT_ALTERED',

Line 1186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1184: g_api || '.ADJUSTMENT_ALTERED',
1185: 'Entry ID : ' || l_entry_id);
1186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1187: g_api || '.ADJUSTMENT_ALTERED',
1188: 'Original Entry ID : ' || l_orig_entry_id);
1189: END IF;
1190:

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

1332: AND geca_child.currency_code = p_from_currency;
1333:
1334: BEGIN
1335:
1336: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1337: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1338: g_api || '.DAILY_RATES_ALTERED.begin',
1339: '<>');
1340: END IF;

Line 1337: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1333:
1334: BEGIN
1335:
1336: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1337: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1338: g_api || '.DAILY_RATES_ALTERED.begin',
1339: '<>');
1340: END IF;
1341:

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

1355: 'YYYY/MM/DD');
1356: l_conversion_type := WF_EVENT.getValueForParameter('CONVERSION_TYPE',
1357: l_parameter_list);
1358:
1359: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1361: g_api || '.DAILY_RATES_ALTERED',
1362: 'From Currency : ' || l_from_currency);
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1356: l_conversion_type := WF_EVENT.getValueForParameter('CONVERSION_TYPE',
1357: l_parameter_list);
1358:
1359: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1361: g_api || '.DAILY_RATES_ALTERED',
1362: 'From Currency : ' || l_from_currency);
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1364: g_api || '.DAILY_RATES_ALTERED',

Line 1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1359: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1361: g_api || '.DAILY_RATES_ALTERED',
1362: 'From Currency : ' || l_from_currency);
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1364: g_api || '.DAILY_RATES_ALTERED',
1365: 'To Currency : ' || l_to_currency);
1366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1367: g_api || '.DAILY_RATES_ALTERED',

Line 1366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1362: 'From Currency : ' || l_from_currency);
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1364: g_api || '.DAILY_RATES_ALTERED',
1365: 'To Currency : ' || l_to_currency);
1366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1367: g_api || '.DAILY_RATES_ALTERED',
1368: 'From Date : ' || l_from_conversion_date);
1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1370: g_api || '.DAILY_RATES_ALTERED',

Line 1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1365: 'To Currency : ' || l_to_currency);
1366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1367: g_api || '.DAILY_RATES_ALTERED',
1368: 'From Date : ' || l_from_conversion_date);
1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1370: g_api || '.DAILY_RATES_ALTERED',
1371: 'To Date : ' || l_to_conversion_date);
1372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1373: g_api || '.DAILY_RATES_ALTERED',

Line 1372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1368: 'From Date : ' || l_from_conversion_date);
1369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1370: g_api || '.DAILY_RATES_ALTERED',
1371: 'To Date : ' || l_to_conversion_date);
1372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1373: g_api || '.DAILY_RATES_ALTERED',
1374: 'Conversion Type : ' || l_conversion_type);
1375: END IF;
1376:

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

1402: p_category_code => 'NOT_APPLICABLE');
1403:
1404: END LOOP;
1405:
1406: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1408: g_api || '.DAILY_RATES_ALTERED.end',
1409: '<>');
1410: END IF;

Line 1407: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1403:
1404: END LOOP;
1405:
1406: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1408: g_api || '.DAILY_RATES_ALTERED.end',
1409: '<>');
1410: END IF;
1411:

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

1430: l_run_entity_id NUMBER(15);
1431:
1432: BEGIN
1433:
1434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1436: g_api || '.HISTORICAL_RATES_ALTERED.begin',
1437: '<>');
1438: END IF;

Line 1435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1431:
1432: BEGIN
1433:
1434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1436: g_api || '.HISTORICAL_RATES_ALTERED.begin',
1437: '<>');
1438: END IF;
1439:

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

1445: l_parameter_list));
1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',
1447: l_parameter_list));
1448:
1449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: g_api || '.HISTORICAL_RATES_ALTERED',
1452: 'Calendar Period : ' || l_cal_period_id);
1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',
1447: l_parameter_list));
1448:
1449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: g_api || '.HISTORICAL_RATES_ALTERED',
1452: 'Calendar Period : ' || l_cal_period_id);
1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1454: g_api || '.HISTORICAL_RATES_ALTERED',

Line 1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: g_api || '.HISTORICAL_RATES_ALTERED',
1452: 'Calendar Period : ' || l_cal_period_id);
1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1454: g_api || '.HISTORICAL_RATES_ALTERED',
1455: 'Entity : ' || l_entity_id);
1456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1457: g_api || '.HISTORICAL_RATES_ALTERED',

Line 1456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1452: 'Calendar Period : ' || l_cal_period_id);
1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1454: g_api || '.HISTORICAL_RATES_ALTERED',
1455: 'Entity : ' || l_entity_id);
1456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1457: g_api || '.HISTORICAL_RATES_ALTERED',
1458: 'Hierarchy : ' || l_hierarchy_id);
1459: END IF;
1460:

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

1489: p_run_name => l_run_name,
1490: p_cons_entity_id => l_run_entity_id,
1491: p_category_code => 'NOT_APPLICABLE');
1492:
1493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1495: g_api || '.HISTORICAL_RATES_ALTERED.end',
1496: '<>');
1497: END IF;

Line 1494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1490: p_cons_entity_id => l_run_entity_id,
1491: p_category_code => 'NOT_APPLICABLE');
1492:
1493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1495: g_api || '.HISTORICAL_RATES_ALTERED.end',
1496: '<>');
1497: END IF;
1498:

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

1519: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1520:
1521: BEGIN
1522:
1523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1525: g_api || '.CONSOLIDATION_COMPLETED.begin',
1526: '<>');
1527: END IF;

Line 1524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1520:
1521: BEGIN
1522:
1523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1525: g_api || '.CONSOLIDATION_COMPLETED.begin',
1526: '<>');
1527: END IF;
1528:

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

1525: g_api || '.CONSOLIDATION_COMPLETED.begin',
1526: '<>');
1527: END IF;
1528:
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1531: g_api || '.CONSOLIDATION_COMPLETED',
1532: 'Run Name : ' || p_run_name);
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1526: '<>');
1527: END IF;
1528:
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1531: g_api || '.CONSOLIDATION_COMPLETED',
1532: 'Run Name : ' || p_run_name);
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1534: g_api || '.CONSOLIDATION_COMPLETED',

Line 1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1531: g_api || '.CONSOLIDATION_COMPLETED',
1532: 'Run Name : ' || p_run_name);
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1534: g_api || '.CONSOLIDATION_COMPLETED',
1535: 'Run Entity : ' || p_run_entity_id);
1536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1537: g_api || '.CONSOLIDATION_COMPLETED',

Line 1536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1532: 'Run Name : ' || p_run_name);
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1534: g_api || '.CONSOLIDATION_COMPLETED',
1535: 'Run Entity : ' || p_run_entity_id);
1536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1537: g_api || '.CONSOLIDATION_COMPLETED',
1538: 'Cal Period : ' || p_cal_period_id);
1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1540: g_api || '.CONSOLIDATION_COMPLETED',

Line 1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1535: 'Run Entity : ' || p_run_entity_id);
1536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1537: g_api || '.CONSOLIDATION_COMPLETED',
1538: 'Cal Period : ' || p_cal_period_id);
1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1540: g_api || '.CONSOLIDATION_COMPLETED',
1541: 'Period End Date : ' || p_cal_period_end_date);
1542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1543: g_api || '.CONSOLIDATION_COMPLETED',

Line 1542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1538: 'Cal Period : ' || p_cal_period_id);
1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1540: g_api || '.CONSOLIDATION_COMPLETED',
1541: 'Period End Date : ' || p_cal_period_end_date);
1542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1543: g_api || '.CONSOLIDATION_COMPLETED',
1544: 'Hierarchy : ' || p_hierarchy_id);
1545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1546: g_api || '.CONSOLIDATION_COMPLETED',

Line 1545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1541: 'Period End Date : ' || p_cal_period_end_date);
1542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1543: g_api || '.CONSOLIDATION_COMPLETED',
1544: 'Hierarchy : ' || p_hierarchy_id);
1545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1546: g_api || '.CONSOLIDATION_COMPLETED',
1547: 'Balance Type : ' || p_balance_type_code);
1548: END IF;
1549:

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

1644: -- No impact has occurred
1645: END;
1646:
1647: COMMIT;
1648: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1649: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1650: g_api || '.CONSOLIDATION_COMPLETED.end',
1651: '<>');
1652: END IF;

Line 1649: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1645: END;
1646:
1647: COMMIT;
1648: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1649: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1650: g_api || '.CONSOLIDATION_COMPLETED.end',
1651: '<>');
1652: END IF;
1653:

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

1732: AND fgvcd.value_set_id <> p_consolidation_vs_id;
1733:
1734: BEGIN
1735:
1736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1738: g_api || '.VALUE_SET_MAP_UPDATED.begin',
1739: '<>');
1740: END IF;

Line 1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1733:
1734: BEGIN
1735:
1736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1738: g_api || '.VALUE_SET_MAP_UPDATED.begin',
1739: '<>');
1740: END IF;
1741:

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

1738: g_api || '.VALUE_SET_MAP_UPDATED.begin',
1739: '<>');
1740: END IF;
1741:
1742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1744: g_api || '.VALUE_SET_MAP_UPDATED',
1745: 'Dimension Id : ' || p_dimension_id);
1746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1739: '<>');
1740: END IF;
1741:
1742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1744: g_api || '.VALUE_SET_MAP_UPDATED',
1745: 'Dimension Id : ' || p_dimension_id);
1746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1747: g_api || '.VALUE_SET_MAP_UPDATED',

Line 1746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1744: g_api || '.VALUE_SET_MAP_UPDATED',
1745: 'Dimension Id : ' || p_dimension_id);
1746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1747: g_api || '.VALUE_SET_MAP_UPDATED',
1748: 'Effective Start Date : ' || p_eff_start_date);
1749: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1750: g_api || '.VALUE_SET_MAP_UPDATED',

Line 1749: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1745: 'Dimension Id : ' || p_dimension_id);
1746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1747: g_api || '.VALUE_SET_MAP_UPDATED',
1748: 'Effective Start Date : ' || p_eff_start_date);
1749: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1750: g_api || '.VALUE_SET_MAP_UPDATED',
1751: 'Effective End Date : ' || p_eff_end_date);
1752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1753: g_api || '.VALUE_SET_MAP_UPDATED',

Line 1752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1748: 'Effective Start Date : ' || p_eff_start_date);
1749: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1750: g_api || '.VALUE_SET_MAP_UPDATED',
1751: 'Effective End Date : ' || p_eff_end_date);
1752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1753: g_api || '.VALUE_SET_MAP_UPDATED',
1754: 'Consolidation VS Id : ' || p_consolidation_vs_id);
1755: END IF;
1756:

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

1755: END IF;
1756:
1757: FOR v_impacted_hierarchies IN c_impacted_hierarchies LOOP
1758:
1759: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1761: g_api || '.VALUE_SET_MAP_UPDATED',
1762: 'Hierarchy Id : ' ||
1763: v_impacted_hierarchies.hierarchy_id);

Line 1760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1756:
1757: FOR v_impacted_hierarchies IN c_impacted_hierarchies LOOP
1758:
1759: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1761: g_api || '.VALUE_SET_MAP_UPDATED',
1762: 'Hierarchy Id : ' ||
1763: v_impacted_hierarchies.hierarchy_id);
1764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1761: g_api || '.VALUE_SET_MAP_UPDATED',
1762: 'Hierarchy Id : ' ||
1763: v_impacted_hierarchies.hierarchy_id);
1764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1765: g_api || '.VALUE_SET_MAP_UPDATED',
1766: 'Cal Period Id : ' ||
1767: v_impacted_hierarchies.cal_period_id);
1768: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1768: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1765: g_api || '.VALUE_SET_MAP_UPDATED',
1766: 'Cal Period Id : ' ||
1767: v_impacted_hierarchies.cal_period_id);
1768: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1769: g_api || '.VALUE_SET_MAP_UPDATED',
1770: 'Cal Period End Date : ' ||
1771: v_impacted_hierarchies.end_date);
1772: END IF;

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

1774: FOR v_impacted_entities IN c_impacted_entities(v_impacted_hierarchies.hierarchy_id,
1775: v_impacted_hierarchies.cal_period_id,
1776: v_impacted_hierarchies.end_date) LOOP
1777:
1778: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1780: g_api || '.VALUE_SET_MAP_UPDATED',
1781: 'Parent Entity Id : ' ||
1782: v_impacted_entities.parent_entity_id);

Line 1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1775: v_impacted_hierarchies.cal_period_id,
1776: v_impacted_hierarchies.end_date) LOOP
1777:
1778: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1780: g_api || '.VALUE_SET_MAP_UPDATED',
1781: 'Parent Entity Id : ' ||
1782: v_impacted_entities.parent_entity_id);
1783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1780: g_api || '.VALUE_SET_MAP_UPDATED',
1781: 'Parent Entity Id : ' ||
1782: v_impacted_entities.parent_entity_id);
1783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1784: g_api || '.VALUE_SET_MAP_UPDATED',
1785: 'Child Entity Id : ' ||
1786: v_impacted_entities.child_entity_id);
1787: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1787: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1784: g_api || '.VALUE_SET_MAP_UPDATED',
1785: 'Child Entity Id : ' ||
1786: v_impacted_entities.child_entity_id);
1787: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1788: g_api || '.VALUE_SET_MAP_UPDATED',
1789: 'Run Name : ' || v_impacted_entities.run_name);
1790: END IF;
1791:

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

1837: END LOOP;
1838:
1839: COMMIT;
1840:
1841: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1843: g_api || '.VALUE_SET_MAP_UPDATED.end',
1844: '<>');
1845: END IF;

Line 1842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1838:
1839: COMMIT;
1840:
1841: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1843: g_api || '.VALUE_SET_MAP_UPDATED.end',
1844: '<>');
1845: END IF;
1846: END;

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

1874: l_email VARCHAR2(200);
1875:
1876: BEGIN
1877:
1878: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1880: g_api || '.ADJUSTMENT_DISABLED.begin',
1881: '<>');
1882: END IF;

Line 1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1875:
1876: BEGIN
1877:
1878: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1880: g_api || '.ADJUSTMENT_DISABLED.begin',
1881: '<>');
1882: END IF;
1883:

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

1885:
1886: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
1887: l_parameter_list));
1888:
1889: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1891: g_api || '.ADJUSTMENT_DISABLED',
1892: 'Entry ID : ' || l_entry_id);
1893:

Line 1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1886: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
1887: l_parameter_list));
1888:
1889: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1891: g_api || '.ADJUSTMENT_DISABLED',
1892: 'Entry ID : ' || l_entry_id);
1893:
1894: END IF;