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

Line 26: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

22: l_hashkey VARCHAR2(200);
23:
24: BEGIN
25:
26: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.begin', null);
28: END IF;
29:
30: SELECT ftcb.dimension_id,

Line 27: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.begin', null);

23:
24: BEGIN
25:
26: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.begin', null);
28: END IF;
29:
30: SELECT ftcb.dimension_id,
31: fda.attribute_id,

Line 94: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

90: l_index_dimension_attr_info(l_counter);
91: END LOOP;
92:
93:
94: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
95: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', null);
96: END IF;
97:
98: END init_dimension_attr_info;

Line 95: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', null);

91: END LOOP;
92:
93:
94: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
95: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', null);
96: END IF;
97:
98: END init_dimension_attr_info;
99:

Line 135: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

131: inv_global_combo_exception EXCEPTION;
132:
133: BEGIN
134:
135: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.begin', null);
137: END IF;
138:
139: -- Start bugfix 5707630: Select the dimensions enabled for historical rates on the

Line 136: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.begin', null);

132:
133: BEGIN
134:
135: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.begin', null);
137: END IF;
138:
139: -- Start bugfix 5707630: Select the dimensions enabled for historical rates on the
140: -- processing keys page and store it into the record for use during translation

Line 219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

215: l_index_gcs_dimension_info(l_counter);
216: END LOOP;
217: END IF;
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.end', null);
221: END IF;
222:
223: EXCEPTION

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.end', null);

216: END LOOP;
217: END IF;
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_info.end', null);
221: END IF;
222:
223: EXCEPTION
224: WHEN inv_application_exception THEN

Line 225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

221: END IF;
222:
223: EXCEPTION
224: WHEN inv_application_exception THEN
225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Applications Context');
227: END IF;
228: FND_MESSAGE.SET_NAME('GCS','Invalid_App_Group');
229: app_exception.raise_exception;

Line 226: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Applications Context');

222:
223: EXCEPTION
224: WHEN inv_application_exception THEN
225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Applications Context');
227: END IF;
228: FND_MESSAGE.SET_NAME('GCS','Invalid_App_Group');
229: app_exception.raise_exception;
230: WHEN inv_global_combo_exception THEN

Line 231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

227: END IF;
228: FND_MESSAGE.SET_NAME('GCS','Invalid_App_Group');
229: app_exception.raise_exception;
230: WHEN inv_global_combo_exception THEN
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Global VS Combo');
233: END IF;
234: FND_MESSAGE.SET_NAME('GCS','Invalid_Global_Como');
235: app_exception.raise_exception;

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Global VS Combo');

228: FND_MESSAGE.SET_NAME('GCS','Invalid_App_Group');
229: app_exception.raise_exception;
230: WHEN inv_global_combo_exception THEN
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'gcs.plsql.gcs_utility_pkg.init_dimension_info', 'Invalid Global VS Combo');
233: END IF;
234: FND_MESSAGE.SET_NAME('GCS','Invalid_Global_Como');
235: app_exception.raise_exception;
236: WHEN NO_DATA_FOUND THEN

Line 274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

270: l_next_cal_period_year NUMBER(15);
271:
272: BEGIN
273:
274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.begin', null);
276: END IF;
277:
278: SELECT fcpb.calendar_id, fcpb.dimension_group_id,

Line 275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.begin', null);

271:
272: BEGIN
273:
274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.begin', null);
276: END IF;
277:
278: SELECT fcpb.calendar_id, fcpb.dimension_group_id,
279: fcpa_number.number_assign_value, fcpa_year.number_assign_value,

Line 390: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

386: p_cal_period_record.next_cal_period_year := l_next_cal_period_year;
387: p_cal_period_record.cal_periods_per_year := l_periods_per_year;
388:
389:
390: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.end', null);
392: END IF;
393:
394: END get_cal_period_details;

Line 391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.end', null);

387: p_cal_period_record.cal_periods_per_year := l_periods_per_year;
388:
389:
390: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_cal_period_details.end', null);
392: END IF;
393:
394: END get_cal_period_details;
395:

Line 426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

422: l_temp VARCHAR2(1);
423:
424: BEGIN
425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.begin', null);
428: END IF;
429:
430: SELECT entity_name

Line 427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.begin', null);

423:
424: BEGIN
425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.begin', null);
428: END IF;
429:
430: SELECT entity_name
431: INTO l_entity_name

Line 473: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

469:
470: p_entry_header.name := l_entry_header;
471: p_entry_header.description := l_entry_description;
472:
473: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.end', null);
475: END IF;
476:
477: END get_entry_header;

Line 474: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.end', null);

470: p_entry_header.name := l_entry_header;
471: p_entry_header.description := l_entry_description;
472:
473: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.get_entry_header.end', null);
475: END IF;
476:
477: END get_entry_header;
478:

Line 604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

600:
601: org_id NUMBER;
602: BEGIN
603:
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
606: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.begin',
607: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
608: END IF;

Line 605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

601: org_id NUMBER;
602: BEGIN
603:
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
606: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.begin',
607: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
608: END IF;
609:

Line 610: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

606: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.begin',
607: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
608: END IF;
609:
610: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
612: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.bind',
613: 'ENTITY_ID: ' || p_entity_id);
614: END IF;

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

607: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
608: END IF;
609:
610: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
612: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.bind',
613: 'ENTITY_ID: ' || p_entity_id);
614: END IF;
615:

Line 628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

624: IF (org_id IS NULL) THEN
625: org_id :=-1;
626: END IF;
627:
628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
630: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID',
631: 'BASE_ORG_ID: ' || org_id);
632: END IF;

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

625: org_id :=-1;
626: END IF;
627:
628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
630: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID',
631: 'BASE_ORG_ID: ' || org_id);
632: END IF;
633:

Line 634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

630: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID',
631: 'BASE_ORG_ID: ' || org_id);
632: END IF;
633:
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.end',
637: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
638: END IF;

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

631: 'BASE_ORG_ID: ' || org_id);
632: END IF;
633:
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'gcs.plsql.GCS_UTILITY_PKG.GET_BASE_ORG_ID.end',
637: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
638: END IF;
639:

Line 701: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

697: AND NVL(r.end_date, sysdate))
698: AND r.actual_ownership_flag='Y';
699:
700: BEGIN
701: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
703: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID. begin',
704: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
705: END IF;

Line 702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

698: AND r.actual_ownership_flag='Y';
699:
700: BEGIN
701: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
703: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID. begin',
704: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
705: END IF;
706:

Line 710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

706:
707: l_entity_id:=p_entity_id;
708: c_entity_id:=p_entity_id;
709: l_hierarchy_id := p_hierarchy_id;
710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
712: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
713: 'ENTITY_ID: '||l_entity_id
714: ||'; HIERARCHY_ID: '|| l_hierarchy_id);

Line 711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

707: l_entity_id:=p_entity_id;
708: c_entity_id:=p_entity_id;
709: l_hierarchy_id := p_hierarchy_id;
710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
712: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
713: 'ENTITY_ID: '||l_entity_id
714: ||'; HIERARCHY_ID: '|| l_hierarchy_id);
715: END IF;

Line 726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

722: AND attribute_id = g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
723: AND version_id = g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id
724: AND value_set_id = g_gcs_dimension_info('ENTITY_ID').associated_value_set_id;
725:
726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
727: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
728: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_entity_type',
729: 'ATTRIBUTE_ID: '|| g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
730: ||'; VERSION_ID: '|| g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id

Line 727: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

723: AND version_id = g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id
724: AND value_set_id = g_gcs_dimension_info('ENTITY_ID').associated_value_set_id;
725:
726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
727: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
728: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_entity_type',
729: 'ATTRIBUTE_ID: '|| g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
730: ||'; VERSION_ID: '|| g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id
731: ||'; VALUE_SET_ID: '|| g_gcs_dimension_info('ENTITY_ID').associated_value_set_id

Line 753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

749: AND R.actual_ownership_flag='Y'
750: AND R.HIERARCHY_ID = l_hierarchy_id;
751: */
752:
753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
755: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_consolidation_entity',
756: 'ATTRIBUTE_ID: '|| g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
757: ||'; VERSION_ID: '|| g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id

Line 754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

750: AND R.HIERARCHY_ID = l_hierarchy_id;
751: */
752:
753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
755: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_consolidation_entity',
756: 'ATTRIBUTE_ID: '|| g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
757: ||'; VERSION_ID: '|| g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id
758: ||'; ENTITY_ID: '|| l_entity_id);

Line 768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

764: WHERE fea.attribute_id = g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
765: AND fea.version_id = g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id
766: AND fea.dim_attribute_numeric_member = l_entity_id;
767:
768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
770: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_consolidation_entity',
771: 'CONSOLIDATION ENTITY: '|| c_entity_id);
772: END IF;

Line 769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

765: AND fea.version_id = g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id
766: AND fea.dim_attribute_numeric_member = l_entity_id;
767:
768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
770: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.get_consolidation_entity',
771: 'CONSOLIDATION ENTITY: '|| c_entity_id);
772: END IF;
773:

Line 786: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

782: FOR childRec IN getAllChildEntityId(c_entity_id, l_hierarchy_id ) LOOP
783: IF childRec.child_entity_id <> l_entity_id then
784: l_org_id :=Get_Base_Org_Id(childRec.child_entity_id);
785: END IF;
786: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
787: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
788: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
789: 'Consolidation entity ENTITY_ID: ' || c_entity_id
790: ||'; Operating entity ENTITY_ID: ' || l_entity_id);

Line 787: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

783: IF childRec.child_entity_id <> l_entity_id then
784: l_org_id :=Get_Base_Org_Id(childRec.child_entity_id);
785: END IF;
786: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
787: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
788: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
789: 'Consolidation entity ENTITY_ID: ' || c_entity_id
790: ||'; Operating entity ENTITY_ID: ' || l_entity_id);
791: END IF;

Line 798: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

794: END LOOP;
795: ELSE
796: l_org_id := Get_Base_Org_Id(l_entity_id);
797:
798: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
800: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
801: 'Consolidation entity ENTITY_ID: ' || c_entity_id
802: ||'; Associated Operating entity ENTITY_ID: ' || l_entity_id);

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

795: ELSE
796: l_org_id := Get_Base_Org_Id(l_entity_id);
797:
798: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
800: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.bind',
801: 'Consolidation entity ENTITY_ID: ' || c_entity_id
802: ||'; Associated Operating entity ENTITY_ID: ' || l_entity_id);
803: END IF;

Line 809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

805: CLOSE getOpEntityId;
806:
807: END IF; --If entity_type ='O'
808:
809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
811: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.end',
812: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;

Line 810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

806:
807: END IF; --If entity_type ='O'
808:
809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
811: 'gcs.plsql.GCS_UTILITY_PKG.GET_ORG_ID.end',
812: TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;
814:

Line 868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

864:
865: BEGIN
866:
867:
868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
870: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate. begin',
871: null);
872: END IF;

Line 869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

865: BEGIN
866:
867:
868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
870: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate. begin',
871: null);
872: END IF;
873: p_errbuf := 'SUCCESS';

Line 876: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

872: END IF;
873: p_errbuf := 'SUCCESS';
874: -- Get the period end date.
875:
876: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
878: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.Get the period end date.'
879: , null);
880: END IF;

Line 877: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

873: p_errbuf := 'SUCCESS';
874: -- Get the period end date.
875:
876: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
878: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.Get the period end date.'
879: , null);
880: END IF;
881:

Line 895: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

891:
892: BEGIN
893: -- Get the default currency treatment.
894:
895: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
896: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
897: 'gcs.plsql.gcs_utility_pkg.'
898: ||'get_conversion_rate'
899: ||'Source Currency: '||P_source_currency

Line 896: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

892: BEGIN
893: -- Get the default currency treatment.
894:
895: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
896: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
897: 'gcs.plsql.gcs_utility_pkg.'
898: ||'get_conversion_rate'
899: ||'Source Currency: '||P_source_currency
900: ||' Target Currency: '||P_Target_currency

Line 905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

901: ||' End Date: '||l_period_end_date,
902: null);
903: END IF;
904:
905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
907: 'gcs.plsql.gcs_utility_pkg.'
908: ||'get_conversion_rate.Get the default rate type',
909: null);

Line 906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

902: null);
903: END IF;
904:
905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
907: 'gcs.plsql.gcs_utility_pkg.'
908: ||'get_conversion_rate.Get the default rate type',
909: null);
910: END IF;

Line 924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

920: BEGIN
921: -- Get the conversion rate for the above ending_rate_type and
922: -- period end date combination.
923:
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
926: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.'
927: ||'Get the rate for default rate type and period '
928: ||'end date combination', null);

Line 925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

921: -- Get the conversion rate for the above ending_rate_type and
922: -- period end date combination.
923:
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
926: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.'
927: ||'Get the rate for default rate type and period '
928: ||'end date combination', null);
929: END IF;

Line 932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

928: ||'end date combination', null);
929: END IF;
930:
931:
932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
934: 'gcs.plsql.gcs_utility_pkg.'
935: ||'get_conversion_rate'
936: ||' Default Conversion Type: '||l_rate_type,

Line 933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

929: END IF;
930:
931:
932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
934: 'gcs.plsql.gcs_utility_pkg.'
935: ||'get_conversion_rate'
936: ||' Default Conversion Type: '||l_rate_type,
937: null);

Line 953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

949: EXCEPTION
950:
951: WHEN OTHERS THEN
952:
953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'
955: ||'get_conversion_rate'|| SUBSTR(SQLERRM, 1, 255), null);
956: END IF;
957:

Line 954: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'

950:
951: WHEN OTHERS THEN
952:
953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'
955: ||'get_conversion_rate'|| SUBSTR(SQLERRM, 1, 255), null);
956: END IF;
957:
958: l_conv_rate := 1;

Line 966: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

962: END;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'
968: ||'get_conversion_rate'|| SUBSTR(SQLERRM, 1, 255), null);
969: END IF;
970:

Line 967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'

963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'gcs.plsql.gcs_utility_pkg.'
968: ||'get_conversion_rate'|| SUBSTR(SQLERRM, 1, 255), null);
969: END IF;
970:
971: -- Get the conversion Rate for 'Corporate' rate type and period

Line 979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

975:
976: -- Get the conversion Rate for 'Corporate' rate type and period
977: -- end date combination.
978:
979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
981: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.'
982: ||'Get the rate for ''Corporate''rate type and period '
983: ||'end date combination', null);

Line 980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

976: -- Get the conversion Rate for 'Corporate' rate type and period
977: -- end date combination.
978:
979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
981: 'gcs.plsql.gcs_utility_pkg.get_conversion_rate.'
982: ||'Get the rate for ''Corporate''rate type and period '
983: ||'end date combination', null);
984: END IF;

Line 1005: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1001: END; -- Corporate Type Block Ends
1002:
1003: END; -- Default Rate Type Block End;
1004:
1005: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1007: gcs_utility_pkg.g_module_success
1008: || ' '
1009: || 'gcs.plsql.gcs_utility_pkg.'

Line 1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1002:
1003: END; -- Default Rate Type Block End;
1004:
1005: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1007: gcs_utility_pkg.g_module_success
1008: || ' '
1009: || 'gcs.plsql.gcs_utility_pkg.'
1010: ||'get_conversion_rate'

Line 1024: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1020:
1021: EXCEPTION
1022: WHEN OTHERS THEN
1023:
1024: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1026: gcs_utility_pkg.g_module_success
1027: || ' '
1028: || 'gcs.plsql.gcs_utility_pkg.'

Line 1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1021: EXCEPTION
1022: WHEN OTHERS THEN
1023:
1024: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1026: gcs_utility_pkg.g_module_success
1027: || ' '
1028: || 'gcs.plsql.gcs_utility_pkg.'
1029: ||'get_conversion_rate'

Line 1070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1066: l_period_year_version NUMBER :=
1067: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id;
1068:
1069: BEGIN
1070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.populate_calendar_map_details.begin', '<>');
1072: END IF;
1073:
1074: delete from gcs_cal_period_maps_gt;

Line 1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.populate_calendar_map_details.begin', '<>');

1067: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id;
1068:
1069: BEGIN
1070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.populate_calendar_map_details.begin', '<>');
1072: END IF;
1073:
1074: delete from gcs_cal_period_maps_gt;
1075:

Line 1197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1193: 'PRIOR', l_cal_period_record.cal_period_year - 1,
1194: 'FOLLOWING', l_cal_period_record.cal_period_year + 1);
1195: END IF;
1196:
1197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', '<>');
1199: END IF;
1200:
1201: END;

Line 1198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', '<>');

1194: 'FOLLOWING', l_cal_period_record.cal_period_year + 1);
1195: END IF;
1196:
1197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.init_dimension_attr_info.end', '<>');
1199: END IF;
1200:
1201: END;
1202: