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_PERIOD_INIT_PKG dependencies on GCS_UTILITY_PKG

Line 78: GCS_UTILITY_PKG.g_module_enter || fn_name ||

74: BEGIN
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
77: g_api || '.' || fn_name,
78: GCS_UTILITY_PKG.g_module_enter || fn_name ||
79: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
80: END IF;
81: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
82: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 81: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

77: g_api || '.' || fn_name,
78: GCS_UTILITY_PKG.g_module_enter || fn_name ||
79: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
80: END IF;
81: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
82: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
83:
84: -- Initialize this, and overwrite if necessary
85: l_query_entity_id := p_entity_id;

Line 96: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info

92: IF (l_target_entity_code = 'PARENT') THEN
93: SELECT nvl(decode(dim_attribute_varchar_member, 'E', 'Y', 'N'), 'N')
94: INTO l_is_elim_entity
95: FROM FEM_ENTITIES_ATTR
96: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
97: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
98: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
99: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
100: AND entity_id = p_entity_id

Line 98: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info

94: INTO l_is_elim_entity
95: FROM FEM_ENTITIES_ATTR
96: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
97: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
98: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
99: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
100: AND entity_id = p_entity_id
101: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
102: ('ENTITY_ID').associated_value_set_id;

Line 101: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

97: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
98: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
99: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
100: AND entity_id = p_entity_id
101: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
102: ('ENTITY_ID').associated_value_set_id;
103:
104: IF (l_is_elim_entity = 'Y') THEN
105: SELECT oper_fea.dim_attribute_numeric_member

Line 109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info

105: SELECT oper_fea.dim_attribute_numeric_member
106: INTO l_query_entity_id
107: FROM fem_entities_attr oper_fea,
108: fem_entities_attr elim_fea
109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
110: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
112: ('ENTITY_ID-ELIMINATION_ENTITY').version_id
113: AND elim_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

Line 111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info

107: FROM fem_entities_attr oper_fea,
108: fem_entities_attr elim_fea
109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
110: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
112: ('ENTITY_ID-ELIMINATION_ENTITY').version_id
113: AND elim_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
114: ('ENTITY_ID').associated_value_set_id
115: AND elim_fea.dim_attribute_numeric_member = p_entity_id

Line 113: AND elim_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

109: WHERE elim_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
110: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
111: AND elim_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
112: ('ENTITY_ID-ELIMINATION_ENTITY').version_id
113: AND elim_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
114: ('ENTITY_ID').associated_value_set_id
115: AND elim_fea.dim_attribute_numeric_member = p_entity_id
116: AND oper_fea.entity_id = elim_fea.entity_id
117: AND oper_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info

Line 117: AND oper_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info

113: AND elim_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
114: ('ENTITY_ID').associated_value_set_id
115: AND elim_fea.dim_attribute_numeric_member = p_entity_id
116: AND oper_fea.entity_id = elim_fea.entity_id
117: AND oper_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
118: ('ENTITY_ID-OPERATING_ENTITY').attribute_id
119: AND oper_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
120: ('ENTITY_ID-OPERATING_ENTITY').version_id
121: AND oper_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

Line 119: AND oper_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info

115: AND elim_fea.dim_attribute_numeric_member = p_entity_id
116: AND oper_fea.entity_id = elim_fea.entity_id
117: AND oper_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
118: ('ENTITY_ID-OPERATING_ENTITY').attribute_id
119: AND oper_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
120: ('ENTITY_ID-OPERATING_ENTITY').version_id
121: AND oper_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
122: ('ENTITY_ID').associated_value_set_id;
123: END IF;

Line 121: AND oper_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

117: AND oper_fea.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
118: ('ENTITY_ID-OPERATING_ENTITY').attribute_id
119: AND oper_fea.version_id = GCS_UTILITY_PKG.g_dimension_attr_info
120: ('ENTITY_ID-OPERATING_ENTITY').version_id
121: AND oper_fea.value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
122: ('ENTITY_ID').associated_value_set_id;
123: END IF;
124: END IF;
125:

Line 163: GCS_UTILITY_PKG.g_module_failure || fn_name ||

159: WHEN GCS_PI_ENTRY_FAILURE THEN
160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
161: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
162: g_api || '.' || fn_name,
163: GCS_UTILITY_PKG.g_module_failure || fn_name ||
164: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
165: END IF;
166: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
167: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 166: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

162: g_api || '.' || fn_name,
163: GCS_UTILITY_PKG.g_module_failure || fn_name ||
164: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
165: END IF;
166: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
167: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
168: RAISE GCS_PI_ENTRY_FAILURE;
169: WHEN OTHERS THEN
170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 173: GCS_UTILITY_PKG.g_module_failure || fn_name ||

169: WHEN OTHERS THEN
170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
172: g_api || '.' || fn_name,
173: GCS_UTILITY_PKG.g_module_failure || fn_name ||
174: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
175: END IF;
176: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
177: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 176: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

172: g_api || '.' || fn_name,
173: GCS_UTILITY_PKG.g_module_failure || fn_name ||
174: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
175: END IF;
176: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
177: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
178: RAISE;
179: END prepare_entry_header;
180:

Line 233: AND lp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id

229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id
232: AND lp_year.cal_period_id = lp.cal_period_id
233: AND lp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
234: AND lp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
235: AND fp_year.cal_period_id = fp.cal_period_id
236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id

Line 234: AND lp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id

230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id
232: AND lp_year.cal_period_id = lp.cal_period_id
233: AND lp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
234: AND lp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
235: AND fp_year.cal_period_id = fp.cal_period_id
236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
238: AND lp_year.number_assign_value = fp_year.number_assign_value

Line 236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id

232: AND lp_year.cal_period_id = lp.cal_period_id
233: AND lp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
234: AND lp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
235: AND fp_year.cal_period_id = fp.cal_period_id
236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
238: AND lp_year.number_assign_value = fp_year.number_assign_value
239: AND lp_num.cal_period_id = lp.cal_period_id
240: AND lp_num.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').attribute_id

Line 237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id

233: AND lp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
234: AND lp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
235: AND fp_year.cal_period_id = fp.cal_period_id
236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
238: AND lp_year.number_assign_value = fp_year.number_assign_value
239: AND lp_num.cal_period_id = lp.cal_period_id
240: AND lp_num.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').attribute_id
241: AND lp_num.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').version_id

Line 240: AND lp_num.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').attribute_id

236: AND fp_year.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
238: AND lp_year.number_assign_value = fp_year.number_assign_value
239: AND lp_num.cal_period_id = lp.cal_period_id
240: AND lp_num.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').attribute_id
241: AND lp_num.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').version_id
242: ORDER BY lp_num.number_assign_value desc;
243:
244: BEGIN

Line 241: AND lp_num.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').version_id

237: AND fp_year.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
238: AND lp_year.number_assign_value = fp_year.number_assign_value
239: AND lp_num.cal_period_id = lp.cal_period_id
240: AND lp_num.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').attribute_id
241: AND lp_num.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM').version_id
242: ORDER BY lp_num.number_assign_value desc;
243:
244: BEGIN
245: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 248: GCS_UTILITY_PKG.g_module_enter || fn_name ||

244: BEGIN
245: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
247: g_api || '.' || fn_name,
248: GCS_UTILITY_PKG.g_module_enter || fn_name ||
249: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
250: END IF;
251: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
252: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 251: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

247: g_api || '.' || fn_name,
248: GCS_UTILITY_PKG.g_module_enter || fn_name ||
249: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
250: END IF;
251: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
252: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
253:
254: l_category_code := g_entry_info(p_cat_index).category_code;
255:

Line 363: GCS_UTILITY_PKG.g_module_success || fn_name ||

359:
360: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
362: g_api || '.' || fn_name,
363: GCS_UTILITY_PKG.g_module_success || fn_name ||
364: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
365: END IF;
366: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
367: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 366: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

362: g_api || '.' || fn_name,
363: GCS_UTILITY_PKG.g_module_success || fn_name ||
364: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
365: END IF;
366: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
367: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
368:
369: EXCEPTION
370: WHEN GCS_PI_ENTRY_FAILURE THEN

Line 374: GCS_UTILITY_PKG.g_module_failure || fn_name ||

370: WHEN GCS_PI_ENTRY_FAILURE THEN
371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
373: g_api || '.' || fn_name,
374: GCS_UTILITY_PKG.g_module_failure || fn_name ||
375: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
376: END IF;
377: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
378: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 377: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

373: g_api || '.' || fn_name,
374: GCS_UTILITY_PKG.g_module_failure || fn_name ||
375: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
376: END IF;
377: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
378: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
379: RAISE GCS_PI_ENTRY_FAILURE;
380: WHEN OTHERS THEN
381: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 384: GCS_UTILITY_PKG.g_module_failure || fn_name ||

380: WHEN OTHERS THEN
381: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
382: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
383: g_api || '.' || fn_name,
384: GCS_UTILITY_PKG.g_module_failure || fn_name ||
385: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
386: END IF;
387: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
388: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 387: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

383: g_api || '.' || fn_name,
384: GCS_UTILITY_PKG.g_module_failure || fn_name ||
385: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
386: END IF;
387: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
388: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
389: RAISE;
390: END maintain_entries;
391:

Line 419: l_cal_period_info GCS_UTILITY_PKG.r_cal_period_info;

415: l_cons_entity_curr VARCHAR2(30);
416: l_is_elim_entity VARCHAR2(1);
417: l_re_template GCS_TEMPLATES_PKG.TemplateRecord;
418:
419: l_cal_period_info GCS_UTILITY_PKG.r_cal_period_info;
420: l_last_period_of_year VARCHAR2(1);
421: BEGIN
422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 425: GCS_UTILITY_PKG.g_module_enter || fn_name ||

421: BEGIN
422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
424: g_api || '.' || fn_name,
425: GCS_UTILITY_PKG.g_module_enter || fn_name ||
426: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
427:
428: -- parameters passed in
429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 457: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
454: g_api || '.' || fn_name,
455: 'p_category_code = ' || p_category_code);
456: END IF;
457: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
458: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
459:
460: -- In case of an error, roll back to this point
461: SAVEPOINT gcs_period_init_start;

Line 467: GCS_UTILITY_PKG.init_dimension_info;

463: -- ***** Setup *****
464: g_fnd_user_id := fnd_global.user_id;
465: g_fnd_login_id := fnd_global.login_id;
466:
467: GCS_UTILITY_PKG.init_dimension_info;
468: GCS_UTILITY_PKG.init_dimension_attr_info;
469:
470: -- get entity and parent entity's currencies
471: SELECT currency_code

Line 468: GCS_UTILITY_PKG.init_dimension_attr_info;

464: g_fnd_user_id := fnd_global.user_id;
465: g_fnd_login_id := fnd_global.login_id;
466:
467: GCS_UTILITY_PKG.init_dimension_info;
468: GCS_UTILITY_PKG.init_dimension_attr_info;
469:
470: -- get entity and parent entity's currencies
471: SELECT currency_code
472: INTO l_entity_curr

Line 499: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info

495: -- determine if the entity is an elimination entity
496: SELECT nvl(decode(dim_attribute_varchar_member, 'E', 'Y', 'N'), 'N')
497: INTO l_is_elim_entity
498: FROM FEM_ENTITIES_ATTR
499: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
500: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
501: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
502: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
503: AND entity_id = p_entity_id

Line 501: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info

497: INTO l_is_elim_entity
498: FROM FEM_ENTITIES_ATTR
499: WHERE attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info
500: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
501: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
502: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
503: AND entity_id = p_entity_id
504: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
505: ('ENTITY_ID').associated_value_set_id;

Line 504: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info

500: ('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id
501: AND version_id = GCS_UTILITY_PKG.g_dimension_attr_info
502: ('ENTITY_ID-ENTITY_TYPE_CODE').version_id
503: AND entity_id = p_entity_id
504: AND value_set_id = GCS_UTILITY_PKG.g_gcs_dimension_info
505: ('ENTITY_ID').associated_value_set_id;
506:
507: -- get retained earnings template
508: GCS_TEMPLATES_PKG.get_dimension_template(p_hierarchy_id, 'RE',

Line 512: GCS_UTILITY_PKG.get_cal_period_details(p_cal_period_id,

508: GCS_TEMPLATES_PKG.get_dimension_template(p_hierarchy_id, 'RE',
509: p_balance_type_code,
510: l_re_template);
511:
512: GCS_UTILITY_PKG.get_cal_period_details(p_cal_period_id,
513: l_cal_period_info);
514:
515: IF (l_cal_period_info.cal_period_number =
516: l_cal_period_info.cal_periods_per_year) THEN

Line 590: GCS_UTILITY_PKG.g_module_success || fn_name ||

586:
587: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
588: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
589: g_api || '.' || fn_name,
590: GCS_UTILITY_PKG.g_module_success || fn_name ||
591: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
592: END IF;
593: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
594: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 593: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

589: g_api || '.' || fn_name,
590: GCS_UTILITY_PKG.g_module_success || fn_name ||
591: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
592: END IF;
593: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
594: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
595:
596: EXCEPTION
597: WHEN GCS_PI_ENTRY_FAILURE THEN

Line 601: GCS_UTILITY_PKG.g_module_failure || fn_name ||

597: WHEN GCS_PI_ENTRY_FAILURE THEN
598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
599: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
600: g_api || '.' || fn_name,
601: GCS_UTILITY_PKG.g_module_failure || fn_name ||
602: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
603: END IF;
604: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
605: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 604: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

600: g_api || '.' || fn_name,
601: GCS_UTILITY_PKG.g_module_failure || fn_name ||
602: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
603: END IF;
604: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
605: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
606:
607: ROLLBACK TO gcs_period_init_start;
608: -- p_errbuf and p_retcode are set by GCS_ENTRY_PKG.create_entry_header()

Line 629: GCS_UTILITY_PKG.g_module_failure || fn_name ||

625: 'Is Elimination Entity = ' || l_is_elim_entity);
626:
627: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
628: g_api || '.' || fn_name,
629: GCS_UTILITY_PKG.g_module_failure || fn_name ||
630: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
631: END IF;
632: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
633: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 632: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

628: g_api || '.' || fn_name,
629: GCS_UTILITY_PKG.g_module_failure || fn_name ||
630: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
631: END IF;
632: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
633: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
634:
635: ROLLBACK TO gcs_period_init_start;
636: p_errbuf := 'GCS_PI_NO_DATA_FOUND';

Line 645: GCS_UTILITY_PKG.g_module_failure || fn_name ||

641: g_api || '.' || fn_name,
642: SUBSTR(SQLERRM, 1, 4000));
643: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
644: g_api || '.' || fn_name,
645: GCS_UTILITY_PKG.g_module_failure || fn_name ||
646: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
647: END IF;
648: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
649: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 648: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

644: g_api || '.' || fn_name,
645: GCS_UTILITY_PKG.g_module_failure || fn_name ||
646: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
647: END IF;
648: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
649: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
650:
651: ROLLBACK TO gcs_period_init_start;
652: p_errbuf := 'GCS_PI_UNHANDLED_EXCEPTION';