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.IGC_CC_REVALUE_PROCESS_PKG dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('IGC','IGC_CC_INVALID_RATE');

96: ( (p_rate > 0) AND (p_rate_type <> 'User')
97: AND (l_rate <> p_rate))
98: THEN
99: l_message := NULL;
100: FND_MESSAGE.SET_NAME('IGC','IGC_CC_INVALID_RATE');
101: FND_MESSAGE.SET_TOKEN('RATE',TO_CHAR(p_rate),TRUE);
102: l_message := FND_MESSAGE.GET;
103:
104: INSERT INTO

Line 101: FND_MESSAGE.SET_TOKEN('RATE',TO_CHAR(p_rate),TRUE);

97: AND (l_rate <> p_rate))
98: THEN
99: l_message := NULL;
100: FND_MESSAGE.SET_NAME('IGC','IGC_CC_INVALID_RATE');
101: FND_MESSAGE.SET_TOKEN('RATE',TO_CHAR(p_rate),TRUE);
102: l_message := FND_MESSAGE.GET;
103:
104: INSERT INTO
105: igc_cc_process_exceptions

Line 102: l_message := FND_MESSAGE.GET;

98: THEN
99: l_message := NULL;
100: FND_MESSAGE.SET_NAME('IGC','IGC_CC_INVALID_RATE');
101: FND_MESSAGE.SET_TOKEN('RATE',TO_CHAR(p_rate),TRUE);
102: l_message := FND_MESSAGE.GET;
103:
104: INSERT INTO
105: igc_cc_process_exceptions
106: ( process_type,

Line 173: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');

169:
170: IF (l_period_status IS NULL) OR ( NVL(l_period_status,'X') <> 'O') OR (p_rate_date IS NULL)
171: THEN
172: l_message := NULL;
173: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
174: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
175: l_message := FND_MESSAGE.GET;
176:
177: INSERT INTO

Line 174: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);

170: IF (l_period_status IS NULL) OR ( NVL(l_period_status,'X') <> 'O') OR (p_rate_date IS NULL)
171: THEN
172: l_message := NULL;
173: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
174: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
175: l_message := FND_MESSAGE.GET;
176:
177: INSERT INTO
178: igc_cc_process_exceptions

Line 175: l_message := FND_MESSAGE.GET;

171: THEN
172: l_message := NULL;
173: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
174: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
175: l_message := FND_MESSAGE.GET;
176:
177: INSERT INTO
178: igc_cc_process_exceptions
179: ( process_type,

Line 231: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');

227:
228: IF (l_cc_period_status IS NULL) OR (NVL(l_cc_period_status,'X') <> 'O')
229: THEN
230: l_message := NULL;
231: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
232: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
233: l_message := FND_MESSAGE.GET;
234:
235: INSERT INTO

Line 232: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);

228: IF (l_cc_period_status IS NULL) OR (NVL(l_cc_period_status,'X') <> 'O')
229: THEN
230: l_message := NULL;
231: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
232: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
233: l_message := FND_MESSAGE.GET;
234:
235: INSERT INTO
236: igc_cc_process_exceptions

Line 233: l_message := FND_MESSAGE.GET;

229: THEN
230: l_message := NULL;
231: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REVALUATION_DATE');
232: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
233: l_message := FND_MESSAGE.GET;
234:
235: INSERT INTO
236: igc_cc_process_exceptions
237: ( process_type,

Line 321: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');

317:
318: IF (NOT l_lock_cc)
319: THEN
320: l_message := NULL;
321: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
322: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
323: l_message := FND_MESSAGE.GET;
324:
325: INSERT

Line 322: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);

318: IF (NOT l_lock_cc)
319: THEN
320: l_message := NULL;
321: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
322: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
323: l_message := FND_MESSAGE.GET;
324:
325: INSERT
326: INTO igc_cc_process_exceptions

Line 323: l_message := FND_MESSAGE.GET;

319: THEN
320: l_message := NULL;
321: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
322: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
323: l_message := FND_MESSAGE.GET;
324:
325: INSERT
326: INTO igc_cc_process_exceptions
327: ( process_type,

Line 359: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');

355:
356: IF (NOT l_lock_po)
357: THEN
358: l_message := NULL;
359: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
360: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
361: l_message := FND_MESSAGE.GET;
362:
363: INSERT

Line 360: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);

356: IF (NOT l_lock_po)
357: THEN
358: l_message := NULL;
359: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
360: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
361: l_message := FND_MESSAGE.GET;
362:
363: INSERT
364: INTO igc_cc_process_exceptions

Line 361: l_message := FND_MESSAGE.GET;

357: THEN
358: l_message := NULL;
359: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
360: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
361: l_message := FND_MESSAGE.GET;
362:
363: INSERT
364: INTO igc_cc_process_exceptions
365: ( process_type,

Line 731: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');

727: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
728: THEN
729:
730: l_EXCEPTION := NULL;
731: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');
732: l_EXCEPTION := FND_MESSAGE.GET;
733: p_message := l_exception;
734: p_err_header_id := l_cc_headers_rec.cc_header_id;
735: p_err_acct_line_id := NULL;

Line 732: l_EXCEPTION := FND_MESSAGE.GET;

728: THEN
729:
730: l_EXCEPTION := NULL;
731: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');
732: l_EXCEPTION := FND_MESSAGE.GET;
733: p_message := l_exception;
734: p_err_header_id := l_cc_headers_rec.cc_header_id;
735: p_err_acct_line_id := NULL;
736: p_err_det_pf_line_id := NULL;

Line 825: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');

821:
822: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
823: THEN
824: l_EXCEPTION := NULL;
825: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
826: l_EXCEPTION := FND_MESSAGE.GET;
827: p_message := l_exception;
828: p_err_header_id := l_cc_headers_rec.cc_header_id;
829: p_err_acct_line_id := NULL;

Line 826: l_EXCEPTION := FND_MESSAGE.GET;

822: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
823: THEN
824: l_EXCEPTION := NULL;
825: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
826: l_EXCEPTION := FND_MESSAGE.GET;
827: p_message := l_exception;
828: p_err_header_id := l_cc_headers_rec.cc_header_id;
829: p_err_acct_line_id := NULL;
830: p_err_det_pf_line_id := NULL;

Line 945: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');

941:
942: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
943: THEN
944: l_EXCEPTION := NULL;
945: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
946: l_EXCEPTION := FND_MESSAGE.GET;
947: p_message := l_exception;
948: p_err_header_id := l_cc_headers_rec.cc_header_id;
949: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

Line 946: l_EXCEPTION := FND_MESSAGE.GET;

942: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
943: THEN
944: l_EXCEPTION := NULL;
945: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
946: l_EXCEPTION := FND_MESSAGE.GET;
947: p_message := l_exception;
948: p_err_header_id := l_cc_headers_rec.cc_header_id;
949: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;
950: p_err_det_pf_line_id := NULL;

Line 1027: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');

1023: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1024: THEN
1025:
1026: l_EXCEPTION := NULL;
1027: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');
1028: l_EXCEPTION := FND_MESSAGE.GET;
1029: p_message := l_exception;
1030: p_err_header_id := l_cc_headers_rec.cc_header_id;
1031: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

Line 1028: l_EXCEPTION := FND_MESSAGE.GET;

1024: THEN
1025:
1026: l_EXCEPTION := NULL;
1027: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');
1028: l_EXCEPTION := FND_MESSAGE.GET;
1029: p_message := l_exception;
1030: p_err_header_id := l_cc_headers_rec.cc_header_id;
1031: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;
1032: p_err_det_pf_line_id := l_cc_pmt_fcst_rec.CC_Det_PF_Line_Id;

Line 1145: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');

1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1142: THEN
1143:
1144: l_EXCEPTION := NULL;
1145: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');
1146: l_EXCEPTION := FND_MESSAGE.GET;
1147: p_message := l_exception;
1148: p_err_header_id := l_cc_headers_rec.cc_header_id;
1149: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

Line 1146: l_EXCEPTION := FND_MESSAGE.GET;

1142: THEN
1143:
1144: l_EXCEPTION := NULL;
1145: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');
1146: l_EXCEPTION := FND_MESSAGE.GET;
1147: p_message := l_exception;
1148: p_err_header_id := l_cc_headers_rec.cc_header_id;
1149: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;
1150: p_err_det_pf_line_id := l_cc_pmt_fcst_rec.CC_Det_PF_Line_Id;

Line 1286: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');

1282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1283: THEN
1284:
1285: l_EXCEPTION := NULL;
1286: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');
1287: l_EXCEPTION := FND_MESSAGE.GET;
1288: p_message := l_exception;
1289: p_err_header_id := l_cc_headers_rec.cc_header_id;
1290: p_err_acct_line_id := NULL;

Line 1287: l_EXCEPTION := FND_MESSAGE.GET;

1283: THEN
1284:
1285: l_EXCEPTION := NULL;
1286: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');
1287: l_EXCEPTION := FND_MESSAGE.GET;
1288: p_message := l_exception;
1289: p_err_header_id := l_cc_headers_rec.cc_header_id;
1290: p_err_acct_line_id := NULL;
1291: p_err_det_pf_line_id := NULL;

Line 1356: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_ACT_HIST_MSG');

1352:
1353: /* added following code to remove hard coded message */
1354: /* begin */
1355: l_action_hist_msg := NULL;
1356: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_ACT_HIST_MSG');
1357: FND_MESSAGE.SET_TOKEN ('REVAL_RATE', p_rate);
1358: FND_MESSAGE.SET_TOKEN ('REVAL_DATE_RATE', to_char(p_rate_date, 'DD-MON-YYYY'));
1359: l_action_hist_msg := FND_MESSAGE.GET;
1360: /*end */

Line 1357: FND_MESSAGE.SET_TOKEN ('REVAL_RATE', p_rate);

1353: /* added following code to remove hard coded message */
1354: /* begin */
1355: l_action_hist_msg := NULL;
1356: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_ACT_HIST_MSG');
1357: FND_MESSAGE.SET_TOKEN ('REVAL_RATE', p_rate);
1358: FND_MESSAGE.SET_TOKEN ('REVAL_DATE_RATE', to_char(p_rate_date, 'DD-MON-YYYY'));
1359: l_action_hist_msg := FND_MESSAGE.GET;
1360: /*end */
1361:

Line 1358: FND_MESSAGE.SET_TOKEN ('REVAL_DATE_RATE', to_char(p_rate_date, 'DD-MON-YYYY'));

1354: /* begin */
1355: l_action_hist_msg := NULL;
1356: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_ACT_HIST_MSG');
1357: FND_MESSAGE.SET_TOKEN ('REVAL_RATE', p_rate);
1358: FND_MESSAGE.SET_TOKEN ('REVAL_DATE_RATE', to_char(p_rate_date, 'DD-MON-YYYY'));
1359: l_action_hist_msg := FND_MESSAGE.GET;
1360: /*end */
1361:
1362: IGC_CC_ACTIONS_PKG.Insert_Row(

Line 1359: l_action_hist_msg := FND_MESSAGE.GET;

1355: l_action_hist_msg := NULL;
1356: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_ACT_HIST_MSG');
1357: FND_MESSAGE.SET_TOKEN ('REVAL_RATE', p_rate);
1358: FND_MESSAGE.SET_TOKEN ('REVAL_DATE_RATE', to_char(p_rate_date, 'DD-MON-YYYY'));
1359: l_action_hist_msg := FND_MESSAGE.GET;
1360: /*end */
1361:
1362: IGC_CC_ACTIONS_PKG.Insert_Row(
1363: l_api_version,

Line 1388: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');

1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1385: THEN
1386:
1387: l_EXCEPTION := NULL;
1388: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');
1389: l_EXCEPTION := FND_MESSAGE.GET;
1390: p_message := l_exception;
1391: p_err_header_id := l_cc_headers_rec.cc_header_id;
1392: p_err_acct_line_id := NULL;

Line 1389: l_EXCEPTION := FND_MESSAGE.GET;

1385: THEN
1386:
1387: l_EXCEPTION := NULL;
1388: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');
1389: l_EXCEPTION := FND_MESSAGE.GET;
1390: p_message := l_exception;
1391: p_err_header_id := l_cc_headers_rec.cc_header_id;
1392: p_err_acct_line_id := NULL;
1393: p_err_det_pf_line_id := NULL;

Line 1534: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');

1530: WHERE a.cc_header_id = p_cc_header_id AND
1531: request_id = p_request_id;
1532:
1533: l_message := NULL;
1534: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1535: l_message := FND_MESSAGE.GET;
1536:
1537: INSERT
1538: INTO igc_cc_process_exceptions

Line 1535: l_message := FND_MESSAGE.GET;

1531: request_id = p_request_id;
1532:
1533: l_message := NULL;
1534: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1535: l_message := FND_MESSAGE.GET;
1536:
1537: INSERT
1538: INTO igc_cc_process_exceptions
1539: (process_type,

Line 1937: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');

1933: FROM igi_lookups
1934: WHERE lookup_code = 'CC'
1935: AND lookup_type = 'GCC_DESCRIPTION';
1936:
1937: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1938: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1939: lv_message := fnd_message.get;
1940: errbuf := lv_message;
1941: retcode := 2;

Line 1938: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);

1934: WHERE lookup_code = 'CC'
1935: AND lookup_type = 'GCC_DESCRIPTION';
1936:
1937: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1938: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1939: lv_message := fnd_message.get;
1940: errbuf := lv_message;
1941: retcode := 2;
1942: return;

Line 1939: lv_message := fnd_message.get;

1935: AND lookup_type = 'GCC_DESCRIPTION';
1936:
1937: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1938: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1939: lv_message := fnd_message.get;
1940: errbuf := lv_message;
1941: retcode := 2;
1942: return;
1943: END IF;

Line 4348: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');

4344: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
4345:
4346:
4347: l_message := NULL;
4348: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');
4349: l_message := FND_MESSAGE.GET;
4350:
4351: -- IF l_debug_mode = 'Y' THEN
4352: -- Output_Debug (' IGCCREPB -- Reval Cover Fail process exceptions ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 4349: l_message := FND_MESSAGE.GET;

4345:
4346:
4347: l_message := NULL;
4348: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');
4349: l_message := FND_MESSAGE.GET;
4350:
4351: -- IF l_debug_mode = 'Y' THEN
4352: -- Output_Debug (' IGCCREPB -- Reval Cover Fail process exceptions ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4353: -- END IF;

Line 4862: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_NO_CC_SELECTED');

4858: /* Begin fix for bug 1609006 */
4859: IF (l_process_data_count = 0)
4860: THEN
4861: l_message := NULL;
4862: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_NO_CC_SELECTED');
4863: l_message := FND_MESSAGE.GET;
4864:
4865: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
4866: (PROCESS_TYPE,

Line 4863: l_message := FND_MESSAGE.GET;

4859: IF (l_process_data_count = 0)
4860: THEN
4861: l_message := NULL;
4862: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_NO_CC_SELECTED');
4863: l_message := FND_MESSAGE.GET;
4864:
4865: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
4866: (PROCESS_TYPE,
4867: PROCESS_PHASE,

Line 5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5017: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
5018: END IF;
5019: -- bug 3199488, start block
5020: IF (l_unexp_level >= l_debug_level) THEN
5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5022: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);
5025: END IF;

Line 5022: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);

5018: END IF;
5019: -- bug 3199488, start block
5020: IF (l_unexp_level >= l_debug_level) THEN
5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5022: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);
5025: END IF;
5026: -- bug 3199488, end block

Line 5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);

5019: -- bug 3199488, start block
5020: IF (l_unexp_level >= l_debug_level) THEN
5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5022: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);
5025: END IF;
5026: -- bug 3199488, end block
5027: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,