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

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

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

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

48: p_action_type VARCHAR2) IS
49: BEGIN
50: -- Only print if the log level is set at the appropriate level
51: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
52: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
53: p_action_type || ' ' || p_module || '() ' ||
54: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
55: END IF;
56: 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: text_with_date_len NUMBER;
82: curr_index NUMBER;
83: BEGIN
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 175: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN

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

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

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

Line 209: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

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

Line 215: fnd_log.string(p_level, api_module_concat,

211: text_with_date := to_char(sysdate,''DD-MON-YYYY HH:MI:SS'')||g_nl||p_text;
212: text_with_date_len := length(text_with_date);
213: curr_index := 1;
214: WHILE curr_index <= text_with_date_len LOOP
215: fnd_log.string(p_level, api_module_concat,
216: substr(text_with_date, curr_index, 3500));
217: curr_index := curr_index + 3500;
218: END LOOP;
219: END IF;

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

239: p_hier_li_id NUMBER) IS
240:
241: module VARCHAR2(50) := ''ROLL_FORWARD_RETAINED_EARNINGS'';
242: BEGIN
243: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
244:
245: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
246: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
247: ''UPDATE gcs_historical_rates ghr'' || g_nl ||

Line 246: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

242: BEGIN
243: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
244:
245: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
246: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
247: ''UPDATE gcs_historical_rates ghr'' || g_nl ||
248: ''SET (translated_rate, translated_amount, rate_type_code, '' ||
249: ''last_update_date, last_updated_by, last_update_login) ='' || g_nl ||
250: '' (SELECT ghr1.translated_rate, ghr1.translated_amount, ''''P'''', '' ||

Line 252: gcs_translation_pkg.g_fnd_login_id || g_nl ||

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

Line 328: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id

324: UPDATE gcs_historical_rates ghr
325: SET (translated_rate, translated_amount, rate_type_code,
326: last_update_date, last_updated_by, last_update_login) =
327: (SELECT ghr1.translated_rate, ghr1.translated_amount, ''P'', sysdate,
328: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id
329: FROM gcs_historical_rates ghr1
330: WHERE ghr1.entity_id = ghr.entity_id
331: AND ghr1.hierarchy_id = ghr.hierarchy_id
332: 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: Only Roll Forward Rates Where Standard RE Rate Flag is Y
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 473: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

469: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
470: body_block :=
471: ' );
472:
473: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
474: ''INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, '' ||
475: ''cal_period_id, from_currency, to_currency, line_item_id, '' ||
476: ''company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
477: ''product_id, natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

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

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

Line 572: gcs_translation_pkg.g_fnd_login_id, sysdate,

568: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
569: body_block :=
570: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',
571: ghr.account_type_code, ''N'', sysdate, gcs_translation_pkg.g_fnd_user_id,
572: gcs_translation_pkg.g_fnd_login_id, sysdate,
573: gcs_translation_pkg.g_fnd_user_id
574: FROM gcs_historical_rates ghr
575: WHERE ghr.entity_id = p_entity_id
576: AND ghr.hierarchy_id = p_hierarchy_id

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

604: ' AND ghr1.update_flag = ''N''
605: AND ghr1.from_currency = ghr.from_currency
606: AND ghr1.to_currency = ghr.to_currency);
607:
608: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
609: EXCEPTION
610: WHEN OTHERS THEN
611: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
612: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

609: EXCEPTION
610: WHEN OTHERS THEN
611: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
612: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
613: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
614: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
615: module_log_write(module, g_module_failure);
616: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
617: END Roll_Forward_Retained_Earnings;

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

610: WHEN OTHERS THEN
611: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_RF_UNEXPECTED_ERR'');
612: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
613: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
614: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
615: module_log_write(module, g_module_failure);
616: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
617: END Roll_Forward_Retained_Earnings;
618:

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

641: is_rate NUMBER;
642:
643: module VARCHAR2(50) := ''TRANS_RE_FIRST_PER'';
644: BEGIN
645: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
646:
647: IF p_eq_xlate_mode = ''YTD'' THEN
648: eq_rate := p_end_rate;
649: ELSE

Line 660: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

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

Line 947: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

943: body_block :=
944: ' ;
945:
946: ELSE
947: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
948: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
949: ''line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
950: ''product_id, natural_account_id, channel_id, '' ||
951: ''project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, '' ||

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

1207: IF SQL%ROWCOUNT = 0 THEN
1208: raise GCS_CCY_NO_DATA;
1209: END IF;
1210: */
1211: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
1212: EXCEPTION
1213: WHEN GCS_CCY_NO_DATA THEN
1214: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
1215: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

1212: EXCEPTION
1213: WHEN GCS_CCY_NO_DATA THEN
1214: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_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: module_log_write(module, g_module_failure);
1218: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1219: WHEN OTHERS THEN
1220: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');

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

1218: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1219: WHEN OTHERS THEN
1220: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');
1221: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1222: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1223: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1224: module_log_write(module, g_module_failure);
1225: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1226: END Trans_RE_First_Per;

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

1219: WHEN OTHERS THEN
1220: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_FIRST_UNEXPECTED_ERR'');
1221: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1222: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1223: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1224: module_log_write(module, g_module_failure);
1225: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1226: END Trans_RE_First_Per;
1227:

Line 1280: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1276: FETCH get_object_id INTO fb_object_id;
1277: CLOSE get_object_id;
1278:
1279: IF p_group_by_flag = ''Y'' THEN
1280: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1281: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
1282: ''line_item_id, company_cost_center_org_id, '' ||
1283: ''intercompany_id, financial_elem_id, product_id, '' ||
1284: ''natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

Line 1621: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1617: body_block :=
1618: ' ;
1619:
1620: ELSE
1621: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1622: ''INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, '' ||
1623: ''line_item_id, company_cost_center_org_id, '' ||
1624: ''intercompany_id, financial_elem_id, product_id, '' ||
1625: ''natural_account_id, channel_id, project_id, customer_id, task_id, '' ||

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

1937: IF SQL%ROWCOUNT = 0 THEN
1938: raise GCS_CCY_NO_DATA;
1939: END IF;
1940: */
1941: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
1942: EXCEPTION
1943: WHEN GCS_CCY_NO_DATA THEN
1944: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
1945: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;

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

1942: EXCEPTION
1943: WHEN GCS_CCY_NO_DATA THEN
1944: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NO_TRANSLATE_DATA_ERR'');
1945: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1946: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1947: module_log_write(module, g_module_failure);
1948: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1949: WHEN OTHERS THEN
1950: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');

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

1948: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1949: WHEN OTHERS THEN
1950: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');
1951: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1952: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1953: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1954: module_log_write(module, g_module_failure);
1955: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1956: END Trans_RE_Subseq_Per;

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

1949: WHEN OTHERS THEN
1950: FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_SUBSQ_UNEXPECTED_ERR'');
1951: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
1952: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
1953: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1954: module_log_write(module, g_module_failure);
1955: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
1956: END Trans_RE_Subseq_Per;
1957:

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

1976: EXCEPTION
1977: WHEN GCS_CCY_APPLSYS_NOT_FOUND THEN
1978: FND_MESSAGE.SET_NAME('GCS', 'GCS_APPLSYS_NOT_FOUND');
1979: g_error_text := FND_MESSAGE.get;
1980: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1981: x_errbuf := g_error_text;
1982: x_retcode := '2';
1983: module_log_write(module, g_module_failure);
1984: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN

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

1983: module_log_write(module, g_module_failure);
1984: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN
1985: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_BUILD_ERR');
1986: g_error_text := FND_MESSAGE.get;
1987: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1988: x_errbuf := g_error_text;
1989: x_retcode := '2';
1990: module_log_write(module, g_module_failure);
1991: WHEN OTHERS THEN

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

1990: module_log_write(module, g_module_failure);
1991: WHEN OTHERS THEN
1992: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
1993: g_error_text := FND_MESSAGE.get;
1994: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1995: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1996: x_errbuf := g_error_text;
1997: x_retcode := '2';
1998: module_log_write(module, g_module_failure);

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

1991: WHEN OTHERS THEN
1992: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
1993: g_error_text := FND_MESSAGE.get;
1994: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1995: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1996: x_errbuf := g_error_text;
1997: x_retcode := '2';
1998: module_log_write(module, g_module_failure);
1999: END Create_Package;