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_REP_YEP_PVT dependencies on IGC_CC_PROCESS_EXCEPTIONS

Line 316: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;

312: l_PROCESS_TYPE VARCHAR2(25);
313: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
314: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
315: l_DUMMY VARCHAR2(1);
316: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
317:
318: BEGIN
319:
320: IF p_PROCESS_TYPE = 'Y'

Line 359: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

355: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');
356: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
357: l_EXCEPTION := FND_MESSAGE.GET;
358:
359: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
360: (PROCESS_TYPE ,
361: PROCESS_PHASE,
362: CC_HEADER_ID,
363: CC_ACCT_LINE_ID ,

Line 393: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(

389: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');
390: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
391: l_EXCEPTION := FND_MESSAGE.GET;
392:
393: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(
394: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
395: (PROCESS_TYPE ,
396: PROCESS_PHASE,
397: CC_HEADER_ID,

Line 394: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

390: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
391: l_EXCEPTION := FND_MESSAGE.GET;
392:
393: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(
394: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
395: (PROCESS_TYPE ,
396: PROCESS_PHASE,
397: CC_HEADER_ID,
398: CC_ACCT_LINE_ID ,

Line 427: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(p_PROCESS_TYPE,

423: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
424: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
425: l_EXCEPTION := FND_MESSAGE.GET;
426:
427: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(p_PROCESS_TYPE,
428: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
429: (PROCESS_TYPE ,
430: PROCESS_PHASE,
431: CC_HEADER_ID,

Line 428: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

424: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
425: l_EXCEPTION := FND_MESSAGE.GET;
426:
427: -- INSERT INTO IGC_CC_PROCESS_EXCEPTIONS VALUES(p_PROCESS_TYPE,
428: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
429: (PROCESS_TYPE ,
430: PROCESS_PHASE,
431: CC_HEADER_ID,
432: CC_ACCT_LINE_ID ,

Line 458: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

454: l_EXCEPTION := NULL;
455: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_REV_VARIANCES');
456: l_EXCEPTION := FND_MESSAGE.GET;
457:
458: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
459: (PROCESS_TYPE ,
460: PROCESS_PHASE,
461: CC_HEADER_ID,
462: CC_ACCT_LINE_ID ,

Line 501: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

497: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');
498: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
499: l_EXCEPTION := FND_MESSAGE.GET;
500:
501: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
502: (PROCESS_TYPE ,
503: PROCESS_PHASE,
504: CC_HEADER_ID,
505: CC_ACCT_LINE_ID ,

Line 537: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

533: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
534: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
535: l_EXCEPTION := FND_MESSAGE.GET;
536:
537: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
538: (PROCESS_TYPE ,
539: PROCESS_PHASE,
540: CC_HEADER_ID,
541: CC_ACCT_LINE_ID ,

Line 567: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

563: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
564: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
565: l_EXCEPTION := FND_MESSAGE.GET;
566:
567: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
568: (PROCESS_TYPE ,
569: PROCESS_PHASE,
570: CC_HEADER_ID,
571: CC_ACCT_LINE_ID ,

Line 612: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

608: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
609: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
610: l_EXCEPTION := FND_MESSAGE.GET;
611:
612: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
613: (PROCESS_TYPE ,
614: PROCESS_PHASE,
615: CC_HEADER_ID,
616: CC_ACCT_LINE_ID ,

Line 656: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

652: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
653: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
654: l_EXCEPTION := FND_MESSAGE.GET;
655:
656: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
657: (PROCESS_TYPE ,
658: PROCESS_PHASE,
659: CC_HEADER_ID,
660: CC_ACCT_LINE_ID ,

Line 702: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

698: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
699: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
700: l_EXCEPTION := FND_MESSAGE.GET;
701:
702: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
703: (PROCESS_TYPE ,
704: PROCESS_PHASE,
705: CC_HEADER_ID,
706: CC_ACCT_LINE_ID ,

Line 746: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

742: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
743: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
744: l_EXCEPTION := FND_MESSAGE.GET;
745:
746: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
747: (PROCESS_TYPE ,
748: PROCESS_PHASE,
749: CC_HEADER_ID,
750: CC_ACCT_LINE_ID ,

Line 792: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

788: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
789: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
790: l_EXCEPTION := FND_MESSAGE.GET;
791:
792: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
793: (PROCESS_TYPE ,
794: PROCESS_PHASE,
795: CC_HEADER_ID,
796: CC_ACCT_LINE_ID ,

Line 876: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

872: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');
873: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
874: l_EXCEPTION := FND_MESSAGE.GET;
875:
876: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
877: (PROCESS_TYPE ,
878: PROCESS_PHASE,
879: CC_HEADER_ID,
880: CC_ACCT_LINE_ID ,

Line 911: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

907: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');
908: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
909: l_EXCEPTION := FND_MESSAGE.GET;
910:
911: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
912: (PROCESS_TYPE ,
913: PROCESS_PHASE,
914: CC_HEADER_ID,
915: CC_ACCT_LINE_ID ,

Line 943: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

939: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
940: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
941: l_EXCEPTION := FND_MESSAGE.GET;
942:
943: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
944: (PROCESS_TYPE ,
945: PROCESS_PHASE,
946: CC_HEADER_ID,
947: CC_ACCT_LINE_ID ,

Line 994: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

990: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');
991: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
992: l_EXCEPTION := FND_MESSAGE.GET;
993:
994: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
995: (PROCESS_TYPE ,
996: PROCESS_PHASE,
997: CC_HEADER_ID,
998: CC_ACCT_LINE_ID ,

Line 1021: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1017: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1018: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1019: l_EXCEPTION := FND_MESSAGE.GET;
1020:
1021: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1022: (PROCESS_TYPE ,
1023: PROCESS_PHASE,
1024: CC_HEADER_ID,
1025: CC_ACCT_LINE_ID ,

Line 1057: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1053: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');
1054: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1055: l_EXCEPTION := FND_MESSAGE.GET;
1056:
1057: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1058: (PROCESS_TYPE ,
1059: PROCESS_PHASE,
1060: CC_HEADER_ID,
1061: CC_ACCT_LINE_ID ,

Line 1084: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1080: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1081: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1082: l_EXCEPTION := FND_MESSAGE.GET;
1083:
1084: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1085: (PROCESS_TYPE ,
1086: PROCESS_PHASE,
1087: CC_HEADER_ID,
1088: CC_ACCT_LINE_ID ,

Line 1116: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1112: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1113: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
1114: l_EXCEPTION := FND_MESSAGE.GET;
1115:
1116: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1117: (PROCESS_TYPE ,
1118: PROCESS_PHASE,
1119: CC_HEADER_ID,
1120: CC_ACCT_LINE_ID ,

Line 1143: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1139: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1140: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1141: l_EXCEPTION := FND_MESSAGE.GET;
1142:
1143: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1144: (PROCESS_TYPE ,
1145: PROCESS_PHASE,
1146: CC_HEADER_ID,
1147: CC_ACCT_LINE_ID ,

Line 1173: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1169: THEN
1170: IF IGC_CC_REVAL_FIX_PROCESS_PKG.REVALUE_FIX(V9.CC_HEADER_ID)
1171: THEN
1172:
1173: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1174: (PROCESS_TYPE ,
1175: PROCESS_PHASE,
1176: CC_HEADER_ID,
1177: CC_ACCT_LINE_ID ,

Line 1199: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1195: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1196: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1197: l_EXCEPTION := FND_MESSAGE.GET;
1198:
1199: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1200: (PROCESS_TYPE ,
1201: PROCESS_PHASE,
1202: CC_HEADER_ID,
1203: CC_ACCT_LINE_ID ,

Line 1240: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1236: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1237: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
1238: l_EXCEPTION := FND_MESSAGE.GET;
1239:
1240: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1241: (PROCESS_TYPE ,
1242: PROCESS_PHASE,
1243: CC_HEADER_ID,
1244: CC_ACCT_LINE_ID ,

Line 1266: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1262: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1263: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1264: l_EXCEPTION := FND_MESSAGE.GET;
1265:
1266: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1267: (PROCESS_TYPE ,
1268: PROCESS_PHASE,
1269: CC_HEADER_ID,
1270: CC_ACCT_LINE_ID ,

Line 1346: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1342: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1343: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
1344: l_EXCEPTION := FND_MESSAGE.GET;
1345:
1346: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1347: (PROCESS_TYPE ,
1348: PROCESS_PHASE,
1349: CC_HEADER_ID,
1350: CC_ACCT_LINE_ID ,

Line 1372: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1368: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1369: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1370: l_EXCEPTION := FND_MESSAGE.GET;
1371:
1372: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1373: (PROCESS_TYPE ,
1374: PROCESS_PHASE,
1375: CC_HEADER_ID,
1376: CC_ACCT_LINE_ID ,

Line 1432: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1428: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
1429: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
1430: l_EXCEPTION := FND_MESSAGE.GET;
1431:
1432: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1433: (PROCESS_TYPE ,
1434: PROCESS_PHASE,
1435: CC_HEADER_ID,
1436: CC_ACCT_LINE_ID ,

Line 1459: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1455: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1456: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1457: l_EXCEPTION := FND_MESSAGE.GET;
1458:
1459: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1460: (PROCESS_TYPE ,
1461: PROCESS_PHASE,
1462: CC_HEADER_ID,
1463: CC_ACCT_LINE_ID ,

Line 1586: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1582: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1583: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
1584: l_EXCEPTION := FND_MESSAGE.GET;
1585:
1586: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1587: (PROCESS_TYPE ,
1588: PROCESS_PHASE,
1589: CC_HEADER_ID,
1590: CC_ACCT_LINE_ID ,

Line 1612: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1608: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1609: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1610: l_EXCEPTION := FND_MESSAGE.GET;
1611:
1612: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1613: (PROCESS_TYPE ,
1614: PROCESS_PHASE,
1615: CC_HEADER_ID,
1616: CC_ACCT_LINE_ID ,

Line 1669: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1665: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
1666: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
1667: l_EXCEPTION := FND_MESSAGE.GET;
1668:
1669: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1670: (PROCESS_TYPE ,
1671: PROCESS_PHASE,
1672: CC_HEADER_ID,
1673: CC_ACCT_LINE_ID ,

Line 1696: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1692: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1693: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1694: l_EXCEPTION := FND_MESSAGE.GET;
1695:
1696: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1697: (PROCESS_TYPE ,
1698: PROCESS_PHASE,
1699: CC_HEADER_ID,
1700: CC_ACCT_LINE_ID ,

Line 1818: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1814: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
1815: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
1816: l_EXCEPTION := FND_MESSAGE.GET;
1817:
1818: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1819: (PROCESS_TYPE ,
1820: PROCESS_PHASE,
1821: CC_HEADER_ID,
1822: CC_ACCT_LINE_ID ,

Line 1844: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1840: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1841: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1842: l_EXCEPTION := FND_MESSAGE.GET;
1843:
1844: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1845: (PROCESS_TYPE ,
1846: PROCESS_PHASE,
1847: CC_HEADER_ID,
1848: CC_ACCT_LINE_ID ,

Line 1900: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1896: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);
1897: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);
1898: l_EXCEPTION := FND_MESSAGE.GET;
1899:
1900: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1901: (PROCESS_TYPE ,
1902: PROCESS_PHASE,
1903: CC_HEADER_ID,
1904: CC_ACCT_LINE_ID ,

Line 1926: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1922: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);
1923: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);
1924: l_EXCEPTION := FND_MESSAGE.GET;
1925:
1926: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1927: (PROCESS_TYPE ,
1928: PROCESS_PHASE,
1929: CC_HEADER_ID,
1930: CC_ACCT_LINE_ID ,

Line 2059: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2055: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');
2056: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
2057: l_EXCEPTION := FND_MESSAGE.GET;
2058:
2059: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2060: (PROCESS_TYPE ,
2061: PROCESS_PHASE,
2062: CC_HEADER_ID,
2063: CC_ACCT_LINE_ID ,

Line 2095: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2091: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
2092: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
2093: l_EXCEPTION := FND_MESSAGE.GET;
2094:
2095: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2096: (PROCESS_TYPE ,
2097: PROCESS_PHASE,
2098: CC_HEADER_ID,
2099: CC_ACCT_LINE_ID ,

Line 2138: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2134: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
2135: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
2136: l_EXCEPTION := FND_MESSAGE.GET;
2137:
2138: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2139: (PROCESS_TYPE ,
2140: PROCESS_PHASE,
2141: CC_HEADER_ID,
2142: CC_ACCT_LINE_ID ,

Line 2181: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2177: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
2178: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
2179: l_EXCEPTION := FND_MESSAGE.GET;
2180:
2181: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2182: (PROCESS_TYPE ,
2183: PROCESS_PHASE,
2184: CC_HEADER_ID,
2185: CC_ACCT_LINE_ID ,

Line 2226: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2222: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
2223: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);
2224: l_EXCEPTION := FND_MESSAGE.GET;
2225:
2226: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2227: (PROCESS_TYPE ,
2228: PROCESS_PHASE,
2229: CC_HEADER_ID,
2230: CC_ACCT_LINE_ID ,