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 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 78: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

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

Line 84: fnd_log.string(p_level, api_module_concat,

80: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
81: text_with_date_len := length(text_with_date);
82: curr_index := 1;
83: WHILE curr_index <= text_with_date_len LOOP
84: fnd_log.string(p_level, api_module_concat,
85: substr(text_with_date, curr_index, 3500));
86: curr_index := curr_index + 3500;
87: END LOOP;
88: 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_RETAINED_EARNINGS';
111: BEGIN
112: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
113:
114: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
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: Only Roll Forward Rates Where Standard RE Rate Flag is Y
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 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 204: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

200: nvl(to_char(ghr2.translated_amount), 'X') <>
201: nvl(to_char(ghr3.translated_amount), 'X')));
202:
203: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
204: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
205: 'DELETE FROM gcs_historical_rates ghr' || g_nl ||
206: 'WHERE (rowid, ''E'') IN (' || g_nl ||
207: ' SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''E'')' || g_nl ||
208: ' FROM GCS_HISTORICAL_RATES ghr3, ' || g_nl ||

Line 255: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

251: AND ghr2.line_item_id (+)= ghr3.line_item_id
252: AND ghr3.standard_re_rate_flag = 'Y'
253: AND ghr3.line_item_id = p_hier_li_id );
254:
255: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
256: 'INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, ' ||
257: 'cal_period_id, from_currency, to_currency, line_item_id, ' ||
258: 'company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
259: 'product_id, natural_account_id, channel_id, project_id, customer_id, task_id, ' ||

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

329: AND ghr1.line_item_id = ghr.line_item_id AND ghr1.update_flag = 'N'
330: AND ghr1.from_currency = ghr.from_currency
331: AND ghr1.to_currency = ghr.to_currency);
332:
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;

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

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

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

366: is_rate NUMBER;
367:
368: module VARCHAR2(50) := 'TRANS_RE_FIRST_PER';
369: BEGIN
370: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
371:
372: IF p_eq_xlate_mode = 'YTD' THEN
373: eq_rate := p_end_rate;
374: ELSE

Line 385: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

381: is_rate := p_avg_rate;
382: END IF;
383:
384: IF p_group_by_flag = 'Y' THEN
385: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
386: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
387: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
388: 'product_id, natural_account_id, channel_id, ' ||
389: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||

Line 556: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

552: AND fb.line_item_id = p_hier_li_id
553: AND ghr.standard_re_rate_flag = 'Y' ;
554:
555: ELSE
556: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
557: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
558: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
559: 'product_id, natural_account_id, channel_id, ' ||
560: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||

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

728: IF SQL%ROWCOUNT = 0 THEN
729: raise GCS_CCY_NO_DATA;
730: END IF;
731: */
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;

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

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

Line 801: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

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

Line 1000: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

996: AND ghr.standard_re_rate_flag = 'Y'
997: AND ghr.update_flag = 'N' ;
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 1205: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

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

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

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