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_TRANS_RE_DYNAMIC_PKG dependencies on GCS_TRANSLATION_PKG

Line 120: 'sysdate, ' || gcs_translation_pkg.g_fnd_user_id || ', ' ||

116: 'UPDATE gcs_historical_rates ghr' || g_nl ||
117: 'SET (translated_rate, translated_amount, rate_type_code, ' ||
118: 'last_update_date, last_updated_by, last_update_login) =' || g_nl ||
119: ' (SELECT ghr1.translated_rate, ghr1.translated_amount, ''P'', ' ||
120: 'sysdate, ' || gcs_translation_pkg.g_fnd_user_id || ', ' ||
121: gcs_translation_pkg.g_fnd_login_id || g_nl ||
122: ' FROM gcs_historical_rates ghr1' || g_nl ||
123: ' WHERE ghr1.entity_id = ghr.entity_id' || g_nl ||
124: ' AND ghr1.hierarchy_id = ghr.hierarchy_id' || g_nl ||

Line 121: gcs_translation_pkg.g_fnd_login_id || g_nl ||

117: 'SET (translated_rate, translated_amount, rate_type_code, ' ||
118: 'last_update_date, last_updated_by, last_update_login) =' || g_nl ||
119: ' (SELECT ghr1.translated_rate, ghr1.translated_amount, ''P'', ' ||
120: 'sysdate, ' || gcs_translation_pkg.g_fnd_user_id || ', ' ||
121: gcs_translation_pkg.g_fnd_login_id || g_nl ||
122: ' FROM gcs_historical_rates ghr1' || g_nl ||
123: ' WHERE ghr1.entity_id = ghr.entity_id' || g_nl ||
124: ' AND ghr1.hierarchy_id = ghr.hierarchy_id' || g_nl ||
125: ' AND ghr1.from_currency = ghr.from_currency' || g_nl ||

Line 168: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id

164: UPDATE gcs_historical_rates ghr
165: SET (translated_rate, translated_amount, rate_type_code,
166: last_update_date, last_updated_by, last_update_login) =
167: (SELECT ghr1.translated_rate, ghr1.translated_amount, 'P', sysdate,
168: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id
169: FROM gcs_historical_rates ghr1
170: WHERE ghr1.entity_id = ghr.entity_id
171: AND ghr1.hierarchy_id = ghr.hierarchy_id
172: AND ghr1.from_currency = ghr.from_currency

Line 269: gcs_translation_pkg.g_fnd_user_id || ', ' || gcs_translation_pkg.g_fnd_login_id ||

265: 'SELECT ' || g_nl ||
266: ' ''Y'', ghr.entity_id, ghr.hierarchy_id, ' || p_cal_period_id || ', '||
267: 'ghr.from_currency, ghr.to_currency, ghr.line_item_id, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'ghr.translated_rate, ghr.translated_amount, ''P'', ''N'', ' ||
268: 'ghr.account_type_code, ''N'', sysdate, ' ||
269: gcs_translation_pkg.g_fnd_user_id || ', ' || gcs_translation_pkg.g_fnd_login_id ||
270: ', sysdate, ' || gcs_translation_pkg.g_fnd_user_id || g_nl ||
271: 'FROM gcs_historical_rates ghr' || g_nl ||
272: 'WHERE ghr.entity_id = ' || p_entity_id || g_nl ||
273: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||

Line 270: ', sysdate, ' || gcs_translation_pkg.g_fnd_user_id || g_nl ||

266: ' ''Y'', ghr.entity_id, ghr.hierarchy_id, ' || p_cal_period_id || ', '||
267: 'ghr.from_currency, ghr.to_currency, ghr.line_item_id, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'NULL, ' ||'ghr.translated_rate, ghr.translated_amount, ''P'', ''N'', ' ||
268: 'ghr.account_type_code, ''N'', sysdate, ' ||
269: gcs_translation_pkg.g_fnd_user_id || ', ' || gcs_translation_pkg.g_fnd_login_id ||
270: ', sysdate, ' || gcs_translation_pkg.g_fnd_user_id || g_nl ||
271: 'FROM gcs_historical_rates ghr' || g_nl ||
272: 'WHERE ghr.entity_id = ' || p_entity_id || g_nl ||
273: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
274: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||

Line 310: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,

306: SELECT
307: 'Y', ghr.entity_id, ghr.hierarchy_id,
308: p_cal_period_id, ghr.from_currency, ghr.to_currency,
309: ghr.line_item_id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ghr.translated_rate, ghr.translated_amount, 'P', 'N',
310: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
311: gcs_translation_pkg.g_fnd_login_id, sysdate,
312: gcs_translation_pkg.g_fnd_user_id
313: FROM gcs_historical_rates ghr
314: WHERE ghr.entity_id = p_entity_id

Line 311: gcs_translation_pkg.g_fnd_login_id, sysdate,

307: 'Y', ghr.entity_id, ghr.hierarchy_id,
308: p_cal_period_id, ghr.from_currency, ghr.to_currency,
309: ghr.line_item_id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ghr.translated_rate, ghr.translated_amount, 'P', 'N',
310: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
311: gcs_translation_pkg.g_fnd_login_id, sysdate,
312: gcs_translation_pkg.g_fnd_user_id
313: FROM gcs_historical_rates ghr
314: WHERE ghr.entity_id = p_entity_id
315: AND ghr.hierarchy_id = p_hierarchy_id

Line 312: gcs_translation_pkg.g_fnd_user_id

308: p_cal_period_id, ghr.from_currency, ghr.to_currency,
309: ghr.line_item_id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ghr.translated_rate, ghr.translated_amount, 'P', 'N',
310: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
311: gcs_translation_pkg.g_fnd_login_id, sysdate,
312: gcs_translation_pkg.g_fnd_user_id
313: FROM gcs_historical_rates ghr
314: WHERE ghr.entity_id = p_entity_id
315: AND ghr.hierarchy_id = p_hierarchy_id
316: AND ghr.to_currency = p_to_ccy

Line 337: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

333: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
334: EXCEPTION
335: WHEN OTHERS THEN
336: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RF_UNEXPECTED_ERR');
337: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
338: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
339: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
340: module_log_write(module, g_module_failure);
341: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

Line 338: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

334: EXCEPTION
335: WHEN OTHERS THEN
336: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RF_UNEXPECTED_ERR');
337: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
338: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
339: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
340: module_log_write(module, g_module_failure);
341: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
342: END Roll_Forward_Retained_Earnings;

Line 341: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

337: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
338: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
339: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
340: module_log_write(module, g_module_failure);
341: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
342: END Roll_Forward_Retained_Earnings;
343:
344:
345: --

Line 455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

451: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
452: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
453: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
454: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
456: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
457: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
458: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
459: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

Line 456: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||

452: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
453: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
454: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
456: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
457: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
458: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
459: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
460: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||

Line 458: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||

454: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
456: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
457: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
458: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
459: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
460: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||
461: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
462: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||

Line 459: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
456: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
457: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
458: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
459: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
460: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||
461: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
462: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||
463: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||

Line 540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

536: FEM_LN_ITEMS_ATTR li,
537: FEM_EXT_ACCT_TYPES_ATTR fxata,
538: GCS_HISTORICAL_RATES ghr
539: WHERE li.line_item_id = fb.line_item_id
540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
541: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
542: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
543: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
544: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 541: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

537: FEM_EXT_ACCT_TYPES_ATTR fxata,
538: GCS_HISTORICAL_RATES ghr
539: WHERE li.line_item_id = fb.line_item_id
540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
541: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
542: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
543: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
544: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
545: AND ghr.entity_id = p_entity_id

Line 543: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

539: WHERE li.line_item_id = fb.line_item_id
540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
541: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
542: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
543: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
544: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
545: AND ghr.entity_id = p_entity_id
546: AND ghr.hierarchy_id = p_hierarchy_id
547: AND ghr.from_currency = p_from_ccy

Line 544: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
541: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
542: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
543: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
544: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
545: AND ghr.entity_id = p_entity_id
546: AND ghr.hierarchy_id = p_hierarchy_id
547: AND ghr.from_currency = p_from_ccy
548: AND ghr.to_currency = p_to_ccy

Line 625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

621: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
622: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
623: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
624: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
626: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
627: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
628: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
629: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

Line 626: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||

622: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
623: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
624: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
626: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
627: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
628: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
629: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
630: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||

Line 628: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||

624: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
626: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
627: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
628: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
629: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
630: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||
631: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
632: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||

Line 629: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
626: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
627: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
628: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
629: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
630: 'AND ghr.entity_id = ' || p_entity_id || g_nl ||
631: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
632: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||
633: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||

Line 709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

705: FEM_LN_ITEMS_ATTR li,
706: FEM_EXT_ACCT_TYPES_ATTR fxata,
707: GCS_HISTORICAL_RATES ghr
708: WHERE li.line_item_id = fb.line_item_id
709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
710: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
711: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
712: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
713: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 710: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

706: FEM_EXT_ACCT_TYPES_ATTR fxata,
707: GCS_HISTORICAL_RATES ghr
708: WHERE li.line_item_id = fb.line_item_id
709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
710: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
711: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
712: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
713: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
714: AND ghr.entity_id = p_entity_id

Line 712: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

708: WHERE li.line_item_id = fb.line_item_id
709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
710: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
711: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
712: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
713: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
714: AND ghr.entity_id = p_entity_id
715: AND ghr.hierarchy_id = p_hierarchy_id
716: AND ghr.from_currency = p_from_ccy

Line 713: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
710: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
711: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
712: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
713: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
714: AND ghr.entity_id = p_entity_id
715: AND ghr.hierarchy_id = p_hierarchy_id
716: AND ghr.from_currency = p_from_ccy
717: AND ghr.to_currency = p_to_ccy

Line 736: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

732: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
733: EXCEPTION
734: WHEN GCS_CCY_NO_DATA THEN
735: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
736: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
737: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
738: module_log_write(module, g_module_failure);
739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN OTHERS THEN

Line 737: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

733: EXCEPTION
734: WHEN GCS_CCY_NO_DATA THEN
735: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
736: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
737: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
738: module_log_write(module, g_module_failure);
739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN OTHERS THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_FIRST_UNEXPECTED_ERR');

Line 739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

735: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
736: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
737: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
738: module_log_write(module, g_module_failure);
739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN OTHERS THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_FIRST_UNEXPECTED_ERR');
742: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

Line 742: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

738: module_log_write(module, g_module_failure);
739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN OTHERS THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_FIRST_UNEXPECTED_ERR');
742: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
744: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
745: module_log_write(module, g_module_failure);
746: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

Line 743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

739: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN OTHERS THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_FIRST_UNEXPECTED_ERR');
742: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
744: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
745: module_log_write(module, g_module_failure);
746: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
747: END Trans_RE_First_Per;

Line 746: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

742: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
744: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
745: module_log_write(module, g_module_failure);
746: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
747: END Trans_RE_First_Per;
748:
749:
750: --

Line 880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

876: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
877: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
878: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
879: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
881: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
882: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
883: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
884: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

Line 881: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||

877: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
878: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
879: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
881: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
882: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
883: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
884: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
885: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||

Line 883: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||

879: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
881: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
882: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
883: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
884: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
885: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||
886: 'AND fbp.cal_period_id (+)= ' || p_prev_period_id || g_nl ||
887: 'AND fbp.source_system_code (+)= ' || p_source_system_code || g_nl ||

Line 884: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
881: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
882: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
883: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
884: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
885: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||
886: 'AND fbp.cal_period_id (+)= ' || p_prev_period_id || g_nl ||
887: 'AND fbp.source_system_code (+)= ' || p_source_system_code || g_nl ||
888: 'AND fbp.currency_code (+)= ''' || p_to_ccy || '''' || g_nl ||

Line 978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

974: FEM_LN_ITEMS_ATTR li,
975: FEM_EXT_ACCT_TYPES_ATTR fxata
976: WHERE fbp.created_by_object_id (+)= fb_object_id
977: AND li.line_item_id = fb.line_item_id
978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
979: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
980: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
981: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
982: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 979: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

975: FEM_EXT_ACCT_TYPES_ATTR fxata
976: WHERE fbp.created_by_object_id (+)= fb_object_id
977: AND li.line_item_id = fb.line_item_id
978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
979: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
980: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
981: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
982: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
983: AND fbp.dataset_code (+)= p_hier_dataset_code

Line 981: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

977: AND li.line_item_id = fb.line_item_id
978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
979: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
980: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
981: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
982: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
983: AND fbp.dataset_code (+)= p_hier_dataset_code
984: AND fbp.cal_period_id (+)= p_prev_period_id
985: AND fbp.source_system_code (+)= p_source_system_code

Line 982: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
979: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
980: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
981: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
982: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
983: AND fbp.dataset_code (+)= p_hier_dataset_code
984: AND fbp.cal_period_id (+)= p_prev_period_id
985: AND fbp.source_system_code (+)= p_source_system_code
986: AND fbp.currency_code (+)= p_to_ccy

Line 1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

1074: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1075: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1076: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
1077: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
1079: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
1080: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
1081: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
1082: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

Line 1079: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||

1075: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1076: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
1077: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
1079: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
1080: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
1081: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
1082: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
1083: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||

Line 1081: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||

1077: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
1079: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
1080: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
1081: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
1082: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
1083: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||
1084: 'AND fbp.cal_period_id (+)= ' || p_prev_period_id || g_nl ||
1085: 'AND fbp.source_system_code (+)= ' || p_source_system_code || g_nl ||

Line 1082: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
1079: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
1080: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
1081: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
1082: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
1083: 'AND fbp.dataset_code (+)= ' || p_hier_dataset_code || g_nl ||
1084: 'AND fbp.cal_period_id (+)= ' || p_prev_period_id || g_nl ||
1085: 'AND fbp.source_system_code (+)= ' || p_source_system_code || g_nl ||
1086: 'AND fbp.currency_code (+)= ''' || p_to_ccy || '''' || g_nl ||

Line 1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

1171: FEM_LN_ITEMS_ATTR li,
1172: FEM_EXT_ACCT_TYPES_ATTR fxata
1173: WHERE fbp.created_by_object_id (+)= fb_object_id
1174: AND li.line_item_id = fb.line_item_id
1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
1176: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
1177: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
1178: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
1179: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 1176: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

1172: FEM_EXT_ACCT_TYPES_ATTR fxata
1173: WHERE fbp.created_by_object_id (+)= fb_object_id
1174: AND li.line_item_id = fb.line_item_id
1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
1176: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
1177: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
1178: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
1179: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
1180: AND fbp.dataset_code (+)= p_hier_dataset_code

Line 1178: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

1174: AND li.line_item_id = fb.line_item_id
1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
1176: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
1177: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
1178: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
1179: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
1180: AND fbp.dataset_code (+)= p_hier_dataset_code
1181: AND fbp.cal_period_id (+)= p_prev_period_id
1182: AND fbp.source_system_code (+)= p_source_system_code

Line 1179: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
1176: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
1177: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
1178: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
1179: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
1180: AND fbp.dataset_code (+)= p_hier_dataset_code
1181: AND fbp.cal_period_id (+)= p_prev_period_id
1182: AND fbp.source_system_code (+)= p_source_system_code
1183: AND fbp.currency_code (+)= p_to_ccy

Line 1209: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

1205: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
1206: EXCEPTION
1207: WHEN GCS_CCY_NO_DATA THEN
1208: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
1209: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1210: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1211: module_log_write(module, g_module_failure);
1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1213: WHEN OTHERS THEN

Line 1210: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

1206: EXCEPTION
1207: WHEN GCS_CCY_NO_DATA THEN
1208: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
1209: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1210: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1211: module_log_write(module, g_module_failure);
1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SUBSQ_UNEXPECTED_ERR');

Line 1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

1208: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_TRANSLATE_DATA_ERR');
1209: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1210: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1211: module_log_write(module, g_module_failure);
1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SUBSQ_UNEXPECTED_ERR');
1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1216: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

Line 1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

1211: module_log_write(module, g_module_failure);
1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SUBSQ_UNEXPECTED_ERR');
1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1216: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1217: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1218: module_log_write(module, g_module_failure);
1219: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

Line 1216: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

1212: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SUBSQ_UNEXPECTED_ERR');
1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1216: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1217: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1218: module_log_write(module, g_module_failure);
1219: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1220: END Trans_RE_Subseq_Per;

Line 1219: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1216: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1217: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1218: module_log_write(module, g_module_failure);
1219: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1220: END Trans_RE_Subseq_Per;
1221:
1222: END GCS_TRANS_RE_DYNAMIC_PKG;