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 FND_LOG

Line 44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN

40: (p_module VARCHAR2,
41: p_action_type VARCHAR2) IS
42: BEGIN
43: -- Only print if the log level is set at the appropriate level
44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
46: p_action_type || ' ' || p_module || '() ' ||
47: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
48: END IF;

Line 45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,

41: p_action_type VARCHAR2) IS
42: BEGIN
43: -- Only print if the log level is set at the appropriate level
44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
46: p_action_type || ' ' || p_module || '() ' ||
47: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
48: END IF;
49: FND_FILE.PUT_LINE(FND_FILE.LOG, p_action_type || ' ' || p_module ||

Line 80: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

76: text_with_date_len NUMBER;
77: curr_index NUMBER;
78: BEGIN
79: -- Only print if the log level is set at the appropriate level
80: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
81: api_module_concat := g_api || '.' || p_module;
82: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
83: text_with_date_len := length(text_with_date);
84: curr_index := 1;

Line 86: fnd_log.string(p_level, api_module_concat,

82: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
83: text_with_date_len := length(text_with_date);
84: curr_index := 1;
85: WHILE curr_index <= text_with_date_len LOOP
86: fnd_log.string(p_level, api_module_concat,
87: substr(text_with_date, curr_index, 3500));
88: curr_index := curr_index + 3500;
89: END LOOP;
90: END IF;

Line 112: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

108: p_hier_li_id NUMBER) IS
109:
110: module VARCHAR2(50) := 'ROLL_FORWARD_HISTORICAL_RATES';
111: BEGIN
112: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
113:
114: --Bugfix 6111815: Added Standard RE Rate Flag
115: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
116: 'UPDATE gcs_historical_rates ghr' || g_nl ||

Line 115: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

111: BEGIN
112: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
113:
114: --Bugfix 6111815: Added Standard RE Rate Flag
115: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
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'', ' ||

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 200: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

196: nvl(to_char(ghr2.translated_amount), 'X') <>
197: nvl(to_char(ghr3.translated_amount), 'X')));
198:
199: --Bugfix 6111815: Added Standard RE Rate Flag
200: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
201: 'DELETE FROM gcs_historical_rates ghr' || g_nl ||
202: 'WHERE (rowid, ''E'') IN (' || g_nl ||
203: ' SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''E'')' || g_nl ||
204: ' FROM GCS_HISTORICAL_RATES ghr3, ' || g_nl ||

Line 250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

246: AND ghr2.line_item_id (+)= ghr3.line_item_id
247: AND ghr3.standard_re_rate_flag IS NULL );
248:
249: --Bugfix 6111815: Added Standard RE Rate Flag
250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
251: 'INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(entity_id, hierarchy_id, ' ||
252: 'cal_period_id, from_currency, to_currency, line_item_id, ' ||
253: 'company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
254: 'product_id, natural_account_id, channel_id, project_id, customer_id, task_id, ' ||

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 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 325: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

321: AND ghr1.line_item_id = ghr.line_item_id AND ghr1.update_flag = 'N'
322: AND ghr1.from_currency = ghr.from_currency
323: AND ghr1.to_currency = ghr.to_currency);
324:
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;

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 331: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

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;
335:

Line 362: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

358: is_rate NUMBER;
359:
360: module VARCHAR2(50) := 'TRANS_HRATES_FIRST_PER';
361: BEGIN
362: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
363:
364: IF p_eq_xlate_mode = 'YTD' THEN
365: eq_rate := p_end_rate;
366: ELSE

Line 377: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

373: is_rate := p_avg_rate;
374: END IF;
375:
376: IF p_group_by_flag = 'Y' THEN
377: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
378: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
379: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
380: 'product_id, natural_account_id, channel_id, ' ||
381: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||

Line 551: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

547: AND ghr_retained.cal_period_id = p_cal_period_id
548: AND ghr_retained.line_item_id = fb.line_item_id );
549:
550: ELSE
551: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
552: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
553: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
554: 'product_id, natural_account_id, channel_id, ' ||
555: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||

Line 729: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

725: IF SQL%ROWCOUNT = 0 THEN
726: raise GCS_CCY_NO_DATA;
727: END IF;
728:
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;

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 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 741: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

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;
745:

Line 798: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

794: FETCH get_object_id INTO fb_object_id;
795: CLOSE get_object_id;
796:
797: IF p_group_by_flag = 'Y' THEN
798: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
799: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
800: 'line_item_id, company_cost_center_org_id, ' ||
801: 'intercompany_id, financial_elem_id, product_id, ' ||
802: 'natural_account_id, channel_id, project_id, customer_id, task_id, ' ||

Line 1000: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

996: AND ghr_retained.cal_period_id = p_cal_period_id
997: AND ghr_retained.line_item_id = fb.line_item_id );
998:
999: ELSE
1000: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1001: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
1002: 'line_item_id, company_cost_center_org_id, ' ||
1003: 'intercompany_id, financial_elem_id, product_id, ' ||
1004: 'natural_account_id, channel_id, project_id, customer_id, task_id, ' ||

Line 1206: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

1202: IF SQL%ROWCOUNT = 0 THEN
1203: raise GCS_CCY_NO_DATA;
1204: END IF;
1205:
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;

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 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 1218: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

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;
1222: