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_DYN_BUILD_PKG dependencies on FND_LOG

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

46: (p_module VARCHAR2,
47: p_action_type VARCHAR2) IS
48: BEGIN
49: -- Only print if the log level is set at the appropriate level
50: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
51: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
52: p_action_type || ' ' || p_module || '() ' ||
53: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
54: END IF;

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

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

Line 85: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

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

Line 91: fnd_log.string(p_level, api_module_concat,

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

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

175: (p_module VARCHAR2,
176: p_action_type VARCHAR2) IS
177: BEGIN
178: -- Only print if the log level is set at the appropriate level
179: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || ''.'' || p_module,
181: p_action_type || '' '' || p_module || ''() '' ||
182: to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
183: END IF;

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

176: p_action_type VARCHAR2) IS
177: BEGIN
178: -- Only print if the log level is set at the appropriate level
179: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || ''.'' || p_module,
181: p_action_type || '' '' || p_module || ''() '' ||
182: to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
183: END IF;
184: FND_FILE.PUT_LINE(FND_FILE.LOG, p_action_type || '' '' || p_module ||

Line 215: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

211: text_with_date_len NUMBER;
212: curr_index NUMBER;
213: BEGIN
214: -- Only print if the log level is set at the appropriate level
215: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
216: api_module_concat := g_api || ''.'' || p_module;
217: text_with_date := to_char(sysdate,''DD-MON-YYYY HH:MI:SS'')||g_nl||p_text;
218: text_with_date_len := length(text_with_date);
219: curr_index := 1;

Line 221: fnd_log.string(p_level, api_module_concat,

217: text_with_date := to_char(sysdate,''DD-MON-YYYY HH:MI:SS'')||g_nl||p_text;
218: text_with_date_len := length(text_with_date);
219: curr_index := 1;
220: WHILE curr_index <= text_with_date_len LOOP
221: fnd_log.string(p_level, api_module_concat,
222: substr(text_with_date, curr_index, 3500));
223: curr_index := curr_index + 3500;
224: END LOOP;
225: END IF;

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

243: p_hier_li_id NUMBER) IS
244:
245: module VARCHAR2(50) := ''ROLL_FORWARD_HISTORICAL_RATES'';
246: BEGIN
247: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
248:
249: --Bugfix 6111815: Added Standard RE Rate Flag
250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
251: ''UPDATE gcs_historical_rates ghr'' || g_nl ||

Line 250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

246: BEGIN
247: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
248:
249: --Bugfix 6111815: Added Standard RE Rate Flag
250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
251: ''UPDATE gcs_historical_rates ghr'' || g_nl ||
252: ''SET (translated_rate, translated_amount, rate_type_code, '' ||
253: ''last_update_date, last_updated_by, last_update_login) ='' || g_nl ||
254: '' (SELECT ghr1.translated_rate, ghr1.translated_amount, ''''P'''', '' ||

Line 256: gcs_translation_pkg.g_fnd_login_id || g_nl ||

252: ''SET (translated_rate, translated_amount, rate_type_code, '' ||
253: ''last_update_date, last_updated_by, last_update_login) ='' || g_nl ||
254: '' (SELECT ghr1.translated_rate, ghr1.translated_amount, ''''P'''', '' ||
255: ''sysdate, '' || gcs_translation_pkg.g_fnd_user_id || '', '' ||
256: gcs_translation_pkg.g_fnd_login_id || g_nl ||
257: '' FROM gcs_historical_rates ghr1'' || g_nl ||
258: '' WHERE ghr1.entity_id = ghr.entity_id'' || g_nl ||
259: '' AND ghr1.hierarchy_id = ghr.hierarchy_id'' || g_nl ||
260: '' AND ghr1.from_currency = ghr.from_currency'' || g_nl ||

Line 330: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id

326: UPDATE gcs_historical_rates ghr
327: SET (translated_rate, translated_amount, rate_type_code,
328: last_update_date, last_updated_by, last_update_login) =
329: (SELECT ghr1.translated_rate, ghr1.translated_amount, ''P'', sysdate,
330: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id
331: FROM gcs_historical_rates ghr1
332: WHERE ghr1.entity_id = ghr.entity_id
333: AND ghr1.hierarchy_id = ghr.hierarchy_id
334: AND ghr1.from_currency = ghr.from_currency

Line 393: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

389: nvl(to_char(ghr2.translated_amount), ''X'') <>
390: nvl(to_char(ghr3.translated_amount), ''X'')));
391:
392: --Bugfix 6111815: Added Standard RE Rate Flag
393: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
394: ''DELETE FROM gcs_historical_rates ghr'' || g_nl ||
395: ''WHERE (rowid, ''''E'''') IN ('' || g_nl ||
396: '' SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''''E'''')'' || g_nl ||
397: '' FROM GCS_HISTORICAL_RATES ghr3, '' || g_nl ||

Line 471: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

467: body_block :=
468: ' );
469:
470: --Bugfix 6111815: Added Standard RE Rate Flag
471: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
472: ''INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(entity_id, hierarchy_id, '' ||
473: ''cal_period_id, from_currency, to_currency, line_item_id, '' ||
474: ''company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
475: ''product_id, natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

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

495:
496: body_block :=
497: '''ghr.translated_rate, ghr.translated_amount, ''''P'''', ''''N'''', '' ||
498: ''ghr.account_type_code, ''''N'''', sysdate, '' ||
499: gcs_translation_pkg.g_fnd_user_id || '', '' || gcs_translation_pkg.g_fnd_login_id ||
500: '', sysdate, '' || gcs_translation_pkg.g_fnd_user_id || g_nl ||
501: ''FROM gcs_historical_rates ghr'' || g_nl ||
502: ''WHERE ghr.entity_id = '' || p_entity_id || g_nl ||
503: ''AND ghr.hierarchy_id = '' || p_hierarchy_id || g_nl ||

Line 568: gcs_translation_pkg.g_fnd_login_id, sysdate,

564: --Bugfix 6111815: Added Standard RE Rate Flag
565: body_block :=
566: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',
567: ghr.account_type_code, ''N'', sysdate, gcs_translation_pkg.g_fnd_user_id,
568: gcs_translation_pkg.g_fnd_login_id, sysdate,
569: gcs_translation_pkg.g_fnd_user_id
570: FROM gcs_historical_rates ghr
571: WHERE ghr.entity_id = p_entity_id
572: AND ghr.hierarchy_id = p_hierarchy_id

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

599: ' AND ghr1.update_flag = ''N''
600: AND ghr1.from_currency = ghr.from_currency
601: AND ghr1.to_currency = ghr.to_currency);
602:
603: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
607: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
607: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
608: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
609: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
610: module_log_write(module, g_module_failure);
611: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
612: END Roll_Forward_Historical_Rates;

Line 609: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

605: WHEN OTHERS THEN
606: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
607: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
608: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
609: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
610: module_log_write(module, g_module_failure);
611: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
612: END Roll_Forward_Historical_Rates;
613:

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

636: is_rate NUMBER;
637:
638: module VARCHAR2(50) := ''TRANS_HRATES_FIRST_PER'';
639: BEGIN
640: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
641:
642: IF p_eq_xlate_mode = ''YTD'' THEN
643: eq_rate := p_end_rate;
644: ELSE

Line 655: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

651: is_rate := p_avg_rate;
652: END IF;
653:
654: IF p_group_by_flag = ''Y'' THEN
655: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
656: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
657: ''line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
658: ''product_id, natural_account_id, channel_id, '' ||
659: ''project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, '' ||

Line 957: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

953: body_block :=
954: ' );
955:
956: ELSE
957: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
958: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
959: ''line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
960: ''product_id, natural_account_id, channel_id, '' ||
961: ''project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, '' ||

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

1232: IF SQL%ROWCOUNT = 0 THEN
1233: raise GCS_CCY_NO_DATA;
1234: END IF;
1235:
1236: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
1237: EXCEPTION
1238: WHEN GCS_CCY_NO_DATA THEN
1239: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
1240: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

1237: EXCEPTION
1238: WHEN GCS_CCY_NO_DATA THEN
1239: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
1240: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1241: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1242: module_log_write(module, g_module_failure);
1243: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1244: WHEN OTHERS THEN
1245: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');

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

1243: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1244: WHEN OTHERS THEN
1245: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');
1246: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1247: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1248: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1249: module_log_write(module, g_module_failure);
1250: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1251: END Trans_HRates_First_Per;

Line 1248: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

1244: WHEN OTHERS THEN
1245: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');
1246: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1247: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1248: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1249: module_log_write(module, g_module_failure);
1250: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1251: END Trans_HRates_First_Per;
1252:

Line 1305: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1301: FETCH get_object_id INTO fb_object_id;
1302: CLOSE get_object_id;
1303:
1304: IF p_group_by_flag = ''Y'' THEN
1305: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1306: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
1307: ''line_item_id, company_cost_center_org_id, '' ||
1308: ''intercompany_id, financial_elem_id, product_id, '' ||
1309: ''natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

Line 1664: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1660: body_block :=
1661: ' );
1662:
1663: ELSE
1664: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1665: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
1666: ''line_item_id, company_cost_center_org_id, '' ||
1667: ''intercompany_id, financial_elem_id, product_id, '' ||
1668: ''natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

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

1995: IF SQL%ROWCOUNT = 0 THEN
1996: raise GCS_CCY_NO_DATA;
1997: END IF;
1998:
1999: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
2000: EXCEPTION
2001: WHEN GCS_CCY_NO_DATA THEN
2002: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
2003: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

2000: EXCEPTION
2001: WHEN GCS_CCY_NO_DATA THEN
2002: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
2003: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
2004: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
2005: module_log_write(module, g_module_failure);
2006: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
2007: WHEN OTHERS THEN
2008: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');

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

2006: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
2007: WHEN OTHERS THEN
2008: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');
2009: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
2010: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
2011: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2012: module_log_write(module, g_module_failure);
2013: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
2014: END Trans_HRates_Subseq_Per;

Line 2011: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

2007: WHEN OTHERS THEN
2008: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');
2009: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
2010: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
2011: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2012: module_log_write(module, g_module_failure);
2013: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
2014: END Trans_HRates_Subseq_Per;
2015:

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

2036: EXCEPTION
2037: WHEN GCS_CCY_APPLSYS_NOT_FOUND THEN
2038: FND_MESSAGE.SET_NAME('GCS', 'GCS_APPLSYS_NOT_FOUND');
2039: g_error_text := FND_MESSAGE.get;
2040: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2041: x_errbuf := g_error_text;
2042: x_retcode := '2';
2043: module_log_write(module, g_module_failure);
2044: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN

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

2043: module_log_write(module, g_module_failure);
2044: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN
2045: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_BUILD_ERR');
2046: g_error_text := FND_MESSAGE.get;
2047: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2048: x_errbuf := g_error_text;
2049: x_retcode := '2';
2050: module_log_write(module, g_module_failure);
2051: WHEN OTHERS THEN

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

2050: module_log_write(module, g_module_failure);
2051: WHEN OTHERS THEN
2052: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
2053: g_error_text := FND_MESSAGE.get;
2054: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2055: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2056: x_errbuf := g_error_text;
2057: x_retcode := '2';
2058: module_log_write(module, g_module_failure);

Line 2055: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

2051: WHEN OTHERS THEN
2052: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
2053: g_error_text := FND_MESSAGE.get;
2054: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2055: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2056: x_errbuf := g_error_text;
2057: x_retcode := '2';
2058: module_log_write(module, g_module_failure);
2059: END Create_Package;