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_HRATES_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 166: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id

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

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

260: 'SELECT ' || g_nl ||
261: 'ghr.entity_id, ghr.hierarchy_id, ' || p_cal_period_id || ', '||
262: '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'', ' ||
263: 'ghr.account_type_code, ''N'', sysdate, ' ||
264: gcs_translation_pkg.g_fnd_user_id || ', ' || gcs_translation_pkg.g_fnd_login_id ||
265: ', sysdate, ' || gcs_translation_pkg.g_fnd_user_id || g_nl ||
266: 'FROM gcs_historical_rates ghr' || g_nl ||
267: 'WHERE ghr.entity_id = ' || p_entity_id || g_nl ||
268: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||

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

261: 'ghr.entity_id, ghr.hierarchy_id, ' || p_cal_period_id || ', '||
262: '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'', ' ||
263: 'ghr.account_type_code, ''N'', sysdate, ' ||
264: gcs_translation_pkg.g_fnd_user_id || ', ' || gcs_translation_pkg.g_fnd_login_id ||
265: ', sysdate, ' || gcs_translation_pkg.g_fnd_user_id || g_nl ||
266: 'FROM gcs_historical_rates ghr' || g_nl ||
267: 'WHERE ghr.entity_id = ' || p_entity_id || g_nl ||
268: 'AND ghr.hierarchy_id = ' || p_hierarchy_id || g_nl ||
269: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||

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

299: SELECT
300: ghr.entity_id, ghr.hierarchy_id,
301: p_cal_period_id, ghr.from_currency, ghr.to_currency,
302: 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',
303: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
304: gcs_translation_pkg.g_fnd_login_id, sysdate,
305: gcs_translation_pkg.g_fnd_user_id
306: FROM gcs_historical_rates ghr
307: WHERE ghr.entity_id = p_entity_id

Line 304: gcs_translation_pkg.g_fnd_login_id, sysdate,

300: ghr.entity_id, ghr.hierarchy_id,
301: p_cal_period_id, ghr.from_currency, ghr.to_currency,
302: 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',
303: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
304: gcs_translation_pkg.g_fnd_login_id, sysdate,
305: gcs_translation_pkg.g_fnd_user_id
306: FROM gcs_historical_rates ghr
307: WHERE ghr.entity_id = p_entity_id
308: AND ghr.hierarchy_id = p_hierarchy_id

Line 305: gcs_translation_pkg.g_fnd_user_id

301: p_cal_period_id, ghr.from_currency, ghr.to_currency,
302: 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',
303: ghr.account_type_code, 'N', sysdate, gcs_translation_pkg.g_fnd_user_id,
304: gcs_translation_pkg.g_fnd_login_id, sysdate,
305: gcs_translation_pkg.g_fnd_user_id
306: FROM gcs_historical_rates ghr
307: WHERE ghr.entity_id = p_entity_id
308: AND ghr.hierarchy_id = p_hierarchy_id
309: AND ghr.to_currency = p_to_ccy

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

325: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RF_UNEXPECTED_ERR');
329: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
330: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
331: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
332: module_log_write(module, g_module_failure);
333: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

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

326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RF_UNEXPECTED_ERR');
329: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
330: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
331: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
332: module_log_write(module, g_module_failure);
333: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
334: END Roll_Forward_Historical_Rates;

Line 333: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

329: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
330: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
331: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
332: module_log_write(module, g_module_failure);
333: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
334: END Roll_Forward_Historical_Rates;
335:
336:
337: --

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

443: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
444: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
445: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
446: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
447: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
448: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
449: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
450: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
451: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

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

444: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
445: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
446: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
447: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
448: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
449: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
450: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
451: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
452: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||

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

446: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
447: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
448: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
449: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
450: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
451: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
452: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||
453: 'AND ghr.hierarchy_id (+) = ' || p_hierarchy_id || g_nl ||
454: 'AND ghr.from_currency (+) = ''' || p_from_ccy || '''' || g_nl ||

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

447: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
448: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
449: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
450: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
451: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
452: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||
453: 'AND ghr.hierarchy_id (+) = ' || p_hierarchy_id || g_nl ||
454: 'AND ghr.from_currency (+) = ''' || p_from_ccy || '''' || g_nl ||
455: 'AND ghr.to_currency (+) = ''' || p_to_ccy || '''' || g_nl ||

Line 530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

526: FEM_LN_ITEMS_ATTR li,
527: FEM_EXT_ACCT_TYPES_ATTR fxata,
528: GCS_HISTORICAL_RATES ghr
529: WHERE li.line_item_id = fb.line_item_id
530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
531: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
532: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
533: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
534: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 531: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

527: FEM_EXT_ACCT_TYPES_ATTR fxata,
528: GCS_HISTORICAL_RATES ghr
529: WHERE li.line_item_id = fb.line_item_id
530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
531: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
532: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
533: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
534: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
535: AND ghr.entity_id(+) = p_entity_id

Line 533: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

529: WHERE li.line_item_id = fb.line_item_id
530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
531: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
532: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
533: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
534: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
535: AND ghr.entity_id(+) = p_entity_id
536: AND ghr.hierarchy_id (+) = p_hierarchy_id
537: AND ghr.from_currency (+) = p_from_ccy

Line 534: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

530: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
531: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
532: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
533: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
534: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
535: AND ghr.entity_id(+) = p_entity_id
536: AND ghr.hierarchy_id (+) = p_hierarchy_id
537: AND ghr.from_currency (+) = p_from_ccy
538: AND ghr.to_currency (+) = p_to_ccy

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

616: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
617: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
618: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
619: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
620: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
621: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
622: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
623: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
624: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||

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

617: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
618: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
619: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
620: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
621: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
622: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
623: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
624: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
625: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||

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

619: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
620: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
621: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
622: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
623: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
624: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
625: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||
626: 'AND ghr.hierarchy_id (+) = ' || p_hierarchy_id || g_nl ||
627: 'AND ghr.from_currency (+) = ''' || p_from_ccy || '''' || g_nl ||

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

620: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||
621: 'AND li.version_id = ' || gcs_translation_pkg.g_li_acct_type_v_id || g_nl ||
622: 'AND fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
623: 'AND fxata.attribute_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_attr_id || g_nl ||
624: 'AND fxata.version_id = ' || gcs_translation_pkg.g_xat_basic_acct_type_v_id || g_nl ||
625: 'AND ghr.entity_id(+) = ' || p_entity_id || g_nl ||
626: 'AND ghr.hierarchy_id (+) = ' || p_hierarchy_id || g_nl ||
627: 'AND ghr.from_currency (+) = ''' || p_from_ccy || '''' || g_nl ||
628: 'AND ghr.to_currency (+) = ''' || p_to_ccy || '''' || g_nl ||

Line 702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

698: FEM_LN_ITEMS_ATTR li,
699: FEM_EXT_ACCT_TYPES_ATTR fxata,
700: GCS_HISTORICAL_RATES ghr
701: WHERE li.line_item_id = fb.line_item_id
702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
703: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
704: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
705: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
706: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 703: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

699: FEM_EXT_ACCT_TYPES_ATTR fxata,
700: GCS_HISTORICAL_RATES ghr
701: WHERE li.line_item_id = fb.line_item_id
702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
703: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
704: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
705: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
706: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
707: AND ghr.entity_id(+) = p_entity_id

Line 705: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

701: WHERE li.line_item_id = fb.line_item_id
702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
703: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
704: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
705: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
706: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
707: AND ghr.entity_id(+) = p_entity_id
708: AND ghr.hierarchy_id (+) = p_hierarchy_id
709: AND ghr.from_currency (+) = p_from_ccy

Line 706: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

702: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
703: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
704: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
705: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
706: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
707: AND ghr.entity_id(+) = p_entity_id
708: AND ghr.hierarchy_id (+) = p_hierarchy_id
709: AND ghr.from_currency (+) = p_from_ccy
710: AND ghr.to_currency (+) = p_to_ccy

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

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

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

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

Line 736: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

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

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

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

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

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

Line 743: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

739: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
740: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
741: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
742: module_log_write(module, g_module_failure);
743: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
744: END Trans_HRates_First_Per;
745:
746:
747: --

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

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

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

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

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

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

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

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

Line 973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

969: FEM_LN_ITEMS_ATTR li,
970: FEM_EXT_ACCT_TYPES_ATTR fxata
971: WHERE fbp.created_by_object_id (+)= fb_object_id
972: AND li.line_item_id = fb.line_item_id
973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
974: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
975: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
976: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
977: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

Line 974: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

970: FEM_EXT_ACCT_TYPES_ATTR fxata
971: WHERE fbp.created_by_object_id (+)= fb_object_id
972: AND li.line_item_id = fb.line_item_id
973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
974: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
975: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
976: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
977: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
978: AND fbp.dataset_code (+)= p_hier_dataset_code

Line 976: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

972: AND li.line_item_id = fb.line_item_id
973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
974: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
975: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
976: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
977: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
978: AND fbp.dataset_code (+)= p_hier_dataset_code
979: AND fbp.cal_period_id (+)= p_prev_period_id
980: AND fbp.source_system_code (+)= p_source_system_code

Line 977: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

973: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id
974: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id
975: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
976: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id
977: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id
978: AND fbp.dataset_code (+)= p_hier_dataset_code
979: AND fbp.cal_period_id (+)= p_prev_period_id
980: AND fbp.source_system_code (+)= p_source_system_code
981: 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 1173: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

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

Line 1174: AND li.version_id = gcs_translation_pkg.g_li_acct_type_v_id

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

Line 1176: AND fxata.attribute_id = gcs_translation_pkg.g_xat_basic_acct_type_attr_id

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

Line 1177: AND fxata.version_id = gcs_translation_pkg.g_xat_basic_acct_type_v_id

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

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

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

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

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

Line 1213: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

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

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

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

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

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

Line 1220: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

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