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_REVAL_FIX_PROCESS_PKG dependencies on FND_MESSAGE

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

310: END IF;
311:
312: -- bug 3199488, start block
313: IF (l_unexp_level >= l_debug_level) THEN
314: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
315: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
316: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
317: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.validate_params.Unexp1',TRUE);
318: END IF;

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

311:
312: -- bug 3199488, start block
313: IF (l_unexp_level >= l_debug_level) THEN
314: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
315: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
316: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
317: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.validate_params.Unexp1',TRUE);
318: END IF;
319: -- bug 3199488, end block

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

312: -- bug 3199488, start block
313: IF (l_unexp_level >= l_debug_level) THEN
314: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
315: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
316: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
317: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.validate_params.Unexp1',TRUE);
318: END IF;
319: -- bug 3199488, end block
320:

Line 330: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_NO_REV_VARIANCES');

326:
327: IF (NOT revalue_fix(p_cc_header_id))
328: THEN
329: l_message := NULL;
330: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_NO_REV_VARIANCES');
331: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
332: l_message := FND_MESSAGE.GET;
333:
334: INSERT INTO

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

327: IF (NOT revalue_fix(p_cc_header_id))
328: THEN
329: l_message := NULL;
330: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_NO_REV_VARIANCES');
331: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
332: l_message := FND_MESSAGE.GET;
333:
334: INSERT INTO
335: igc_cc_process_exceptions

Line 332: l_message := FND_MESSAGE.GET;

328: THEN
329: l_message := NULL;
330: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_NO_REV_VARIANCES');
331: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
332: l_message := FND_MESSAGE.GET;
333:
334: INSERT INTO
335: igc_cc_process_exceptions
336: ( process_type,

Line 402: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');

398:
399: IF (l_period_status IS NULL) OR ( NVL(l_period_status,'X') <> 'O') OR (p_revalue_fix_date IS NULL)
400: THEN
401: l_message := NULL;
402: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
403: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
404: l_message := FND_MESSAGE.GET;
405:
406: INSERT INTO

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

399: IF (l_period_status IS NULL) OR ( NVL(l_period_status,'X') <> 'O') OR (p_revalue_fix_date IS NULL)
400: THEN
401: l_message := NULL;
402: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
403: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
404: l_message := FND_MESSAGE.GET;
405:
406: INSERT INTO
407: igc_cc_process_exceptions

Line 404: l_message := FND_MESSAGE.GET;

400: THEN
401: l_message := NULL;
402: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
403: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
404: l_message := FND_MESSAGE.GET;
405:
406: INSERT INTO
407: igc_cc_process_exceptions
408: ( process_type,

Line 460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');

456:
457: IF (l_cc_period_status IS NULL) OR (NVL(l_cc_period_status,'X') <> 'O')
458: THEN
459: l_message := NULL;
460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
461: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
462: l_message := FND_MESSAGE.GET;
463:
464: INSERT INTO

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

457: IF (l_cc_period_status IS NULL) OR (NVL(l_cc_period_status,'X') <> 'O')
458: THEN
459: l_message := NULL;
460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
461: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
462: l_message := FND_MESSAGE.GET;
463:
464: INSERT INTO
465: igc_cc_process_exceptions

Line 462: l_message := FND_MESSAGE.GET;

458: THEN
459: l_message := NULL;
460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REV_VAR_FIX_DATE');
461: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
462: l_message := FND_MESSAGE.GET;
463:
464: INSERT INTO
465: igc_cc_process_exceptions
466: ( process_type,

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

522: IF (NOT l_lock_cc)
523: THEN
524:
525: l_message := NULL;
526: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
527: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
528: l_message := FND_MESSAGE.GET;
529:
530: INSERT

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

523: THEN
524:
525: l_message := NULL;
526: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
527: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
528: l_message := FND_MESSAGE.GET;
529:
530: INSERT
531: INTO igc_cc_process_exceptions

Line 528: l_message := FND_MESSAGE.GET;

524:
525: l_message := NULL;
526: FND_MESSAGE.SET_NAME('IGC','IGC_CC_LOCK_FAILURE');
527: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
528: l_message := FND_MESSAGE.GET;
529:
530: INSERT
531: INTO igc_cc_process_exceptions
532: ( process_type,

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

561: IF (NOT l_lock_po)
562: THEN
563:
564: l_message := NULL;
565: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
566: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
567: l_message := FND_MESSAGE.GET;
568:
569: INSERT

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

562: THEN
563:
564: l_message := NULL;
565: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
566: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
567: l_message := FND_MESSAGE.GET;
568:
569: INSERT
570: INTO igc_cc_process_exceptions

Line 567: l_message := FND_MESSAGE.GET;

563:
564: l_message := NULL;
565: FND_MESSAGE.SET_NAME('IGC','IGC_CC_PO_LOCK_FAILURE');
566: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
567: l_message := FND_MESSAGE.GET;
568:
569: INSERT
570: INTO igc_cc_process_exceptions
571: ( process_type,

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

908: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
909: THEN
910:
911: l_EXCEPTION := NULL;
912: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');
913: l_EXCEPTION := FND_MESSAGE.GET;
914: p_message := l_exception;
915: p_err_header_id := l_cc_headers_rec.cc_header_id;
916: p_err_acct_line_id := NULL;

Line 913: l_EXCEPTION := FND_MESSAGE.GET;

909: THEN
910:
911: l_EXCEPTION := NULL;
912: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');
913: l_EXCEPTION := FND_MESSAGE.GET;
914: p_message := l_exception;
915: p_err_header_id := l_cc_headers_rec.cc_header_id;
916: p_err_acct_line_id := NULL;
917: p_err_det_pf_line_id := NULL;

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

1036: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1037: THEN
1038:
1039: l_EXCEPTION := NULL;
1040: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');
1041: l_EXCEPTION := FND_MESSAGE.GET;
1042:
1043: p_message := l_exception;
1044: p_err_header_id := l_cc_headers_rec.cc_header_id;

Line 1041: l_EXCEPTION := FND_MESSAGE.GET;

1037: THEN
1038:
1039: l_EXCEPTION := NULL;
1040: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');
1041: l_EXCEPTION := FND_MESSAGE.GET;
1042:
1043: p_message := l_exception;
1044: p_err_header_id := l_cc_headers_rec.cc_header_id;
1045: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

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

1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1139: THEN
1140:
1141: l_EXCEPTION := NULL;
1142: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');
1143: l_EXCEPTION := FND_MESSAGE.GET;
1144:
1145: p_message := l_exception;
1146: p_err_header_id := l_cc_headers_rec.cc_header_id;

Line 1143: l_EXCEPTION := FND_MESSAGE.GET;

1139: THEN
1140:
1141: l_EXCEPTION := NULL;
1142: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');
1143: l_EXCEPTION := FND_MESSAGE.GET;
1144:
1145: p_message := l_exception;
1146: p_err_header_id := l_cc_headers_rec.cc_header_id;
1147: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

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

1225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1226: THEN
1227:
1228: l_EXCEPTION := NULL;
1229: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
1230: l_EXCEPTION := FND_MESSAGE.GET;
1231:
1232: p_message := l_exception;
1233: p_err_header_id := l_cc_headers_rec.cc_header_id;

Line 1230: l_EXCEPTION := FND_MESSAGE.GET;

1226: THEN
1227:
1228: l_EXCEPTION := NULL;
1229: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
1230: l_EXCEPTION := FND_MESSAGE.GET;
1231:
1232: p_message := l_exception;
1233: p_err_header_id := l_cc_headers_rec.cc_header_id;
1234: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

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

1321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1322: THEN
1323:
1324: l_EXCEPTION := NULL;
1325: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
1326: l_EXCEPTION := FND_MESSAGE.GET;
1327:
1328: p_message := l_exception;
1329: p_err_header_id := l_cc_headers_rec.cc_header_id;

Line 1326: l_EXCEPTION := FND_MESSAGE.GET;

1322: THEN
1323:
1324: l_EXCEPTION := NULL;
1325: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
1326: l_EXCEPTION := FND_MESSAGE.GET;
1327:
1328: p_message := l_exception;
1329: p_err_header_id := l_cc_headers_rec.cc_header_id;
1330: p_err_acct_line_id := l_cc_acct_lines_rec.CC_ACCT_LINE_ID;

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

1443: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1444: THEN
1445:
1446: l_EXCEPTION := NULL;
1447: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');
1448: l_EXCEPTION := FND_MESSAGE.GET;
1449:
1450:
1451: p_message := l_exception;

Line 1448: l_EXCEPTION := FND_MESSAGE.GET;

1444: THEN
1445:
1446: l_EXCEPTION := NULL;
1447: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');
1448: l_EXCEPTION := FND_MESSAGE.GET;
1449:
1450:
1451: p_message := l_exception;
1452: p_err_header_id := l_cc_headers_rec.cc_header_id;

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

1521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1522: THEN
1523:
1524: l_EXCEPTION := NULL;
1525: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');
1526: l_EXCEPTION := FND_MESSAGE.GET;
1527:
1528:
1529: p_message := l_exception;

Line 1526: l_EXCEPTION := FND_MESSAGE.GET;

1522: THEN
1523:
1524: l_EXCEPTION := NULL;
1525: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');
1526: l_EXCEPTION := FND_MESSAGE.GET;
1527:
1528:
1529: p_message := l_exception;
1530: p_err_header_id := l_cc_headers_rec.cc_header_id;

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

1566: WHERE a.cc_header_id = p_cc_header_id AND
1567: request_id = p_request_id;
1568:
1569: l_message := NULL;
1570: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1571: l_message := FND_MESSAGE.GET;
1572:
1573: INSERT
1574: INTO igc_cc_process_exceptions

Line 1571: l_message := FND_MESSAGE.GET;

1567: request_id = p_request_id;
1568:
1569: l_message := NULL;
1570: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1571: l_message := FND_MESSAGE.GET;
1572:
1573: INSERT
1574: INTO igc_cc_process_exceptions
1575: (process_type,

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

1874: FROM igi_lookups
1875: WHERE lookup_code = 'CC'
1876: AND lookup_type = 'GCC_DESCRIPTION';
1877:
1878: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1879: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1880: lv_message := fnd_message.get;
1881: errbuf := lv_message;
1882: retcode := 2;

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

1875: WHERE lookup_code = 'CC'
1876: AND lookup_type = 'GCC_DESCRIPTION';
1877:
1878: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1879: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1880: lv_message := fnd_message.get;
1881: errbuf := lv_message;
1882: retcode := 2;
1883: return;

Line 1880: lv_message := fnd_message.get;

1876: AND lookup_type = 'GCC_DESCRIPTION';
1877:
1878: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1879: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1880: lv_message := fnd_message.get;
1881: errbuf := lv_message;
1882: retcode := 2;
1883: return;
1884: END IF;

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

2940:
2941: IF (l_reservation_status = 'F')
2942: THEN
2943: l_message := NULL;
2944: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');
2945: l_message := FND_MESSAGE.GET;
2946:
2947: INSERT INTO
2948: igc_cc_process_exceptions

Line 2945: l_message := FND_MESSAGE.GET;

2941: IF (l_reservation_status = 'F')
2942: THEN
2943: l_message := NULL;
2944: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');
2945: l_message := FND_MESSAGE.GET;
2946:
2947: INSERT INTO
2948: igc_cc_process_exceptions
2949: ( process_type,

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

3509: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_fix_main');
3510: END IF;
3511: -- bug 3199488, start block
3512: IF (l_unexp_level >= l_debug_level) THEN
3513: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3514: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
3515: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
3516: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.revalue_fix_main.Unexp2',TRUE);
3517: END IF;

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

3510: END IF;
3511: -- bug 3199488, start block
3512: IF (l_unexp_level >= l_debug_level) THEN
3513: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3514: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
3515: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
3516: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.revalue_fix_main.Unexp2',TRUE);
3517: END IF;
3518: -- bug 3199488, end block

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

3511: -- bug 3199488, start block
3512: IF (l_unexp_level >= l_debug_level) THEN
3513: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3514: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
3515: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
3516: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_reval_fix_process_pkg.revalue_fix_main.Unexp2',TRUE);
3517: END IF;
3518: -- bug 3199488, end block
3519: