351: )
352: AND V3.CC_ENCMBRNC_STATUS = 'N'
353: THEN
354: l_EXCEPTION := NULL;
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
352: AND V3.CC_ENCMBRNC_STATUS = 'N'
353: THEN
354: l_EXCEPTION := NULL;
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 ,
353: THEN
354: l_EXCEPTION := NULL;
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,
385:
386: IF l_INVOICE_STATUS = TRUE
387: THEN
388: l_EXCEPTION := NULL;
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(
386: IF l_INVOICE_STATUS = TRUE
387: THEN
388: l_EXCEPTION := NULL;
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
387: THEN
388: l_EXCEPTION := NULL;
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 ,
418:
419: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IN'
420: THEN
421: l_EXCEPTION := NULL;
422: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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:
419: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IN'
420: THEN
421: l_EXCEPTION := NULL;
422: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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,
420: THEN
421: l_EXCEPTION := NULL;
422: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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
421: l_EXCEPTION := NULL;
422: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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 ,
451: THEN
452: IF IGC_CC_REVAL_FIX_PROCESS_PKG.REVALUE_FIX(V3.CC_HEADER_ID)
453: THEN
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 ,
452: IF IGC_CC_REVAL_FIX_PROCESS_PKG.REVALUE_FIX(V3.CC_HEADER_ID)
453: THEN
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,
493: )
494: AND V3.CC_ENCMBRNC_STATUS = 'N'
495: THEN
496: l_EXCEPTION := NULL;
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
494: AND V3.CC_ENCMBRNC_STATUS = 'N'
495: THEN
496: l_EXCEPTION := NULL;
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 ,
495: THEN
496: l_EXCEPTION := NULL;
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,
528:
529: IF V3.CC_STATE = 'PR' AND V3.CC_APPRVL_STATUS = 'IP'
530: THEN
531: l_EXCEPTION := NULL;
532: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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:
529: IF V3.CC_STATE = 'PR' AND V3.CC_APPRVL_STATUS = 'IP'
530: THEN
531: l_EXCEPTION := NULL;
532: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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
530: THEN
531: l_EXCEPTION := NULL;
532: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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 ,
531: l_EXCEPTION := NULL;
532: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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,
558:
559: IF V3.CC_STATE = 'CL' AND V3.CC_APPRVL_STATUS = 'IP'
560: THEN
561: l_EXCEPTION := NULL;
562: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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:
559: IF V3.CC_STATE = 'CL' AND V3.CC_APPRVL_STATUS = 'IP'
560: THEN
561: l_EXCEPTION := NULL;
562: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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
560: THEN
561: l_EXCEPTION := NULL;
562: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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 ,
561: l_EXCEPTION := NULL;
562: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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,
602: FETCH C5 INTO V5;
603: EXIT WHEN C5%NOTFOUND;
604: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
605: THEN
606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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;
603: EXIT WHEN C5%NOTFOUND;
604: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
605: THEN
606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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:
604: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
605: THEN
606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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
605: THEN
606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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 ,
606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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,
647:
648: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IP'
649: THEN
650: l_EXCEPTION := NULL;
651: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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:
648: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IP'
649: THEN
650: l_EXCEPTION := NULL;
651: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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
649: THEN
650: l_EXCEPTION := NULL;
651: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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 ,
650: l_EXCEPTION := NULL;
651: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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,
692: EXIT WHEN C5%NOTFOUND;
693:
694: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
695: THEN
696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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;
693:
694: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
695: THEN
696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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:
694: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
695: THEN
696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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
695: THEN
696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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 ,
696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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,
737:
738: IF V3.CC_STATE = 'CT' AND V3.CC_APPRVL_STATUS = 'IP'
739: THEN
740: l_EXCEPTION := NULL;
741: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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:
738: IF V3.CC_STATE = 'CT' AND V3.CC_APPRVL_STATUS = 'IP'
739: THEN
740: l_EXCEPTION := NULL;
741: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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
739: THEN
740: l_EXCEPTION := NULL;
741: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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 ,
740: l_EXCEPTION := NULL;
741: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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,
782: EXIT WHEN C5%NOTFOUND;
783:
784: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
785: THEN
786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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;
783:
784: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
785: THEN
786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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:
784: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
785: THEN
786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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
785: THEN
786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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 ,
786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);
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,
868: )
869: AND V3.CC_ENCMBRNC_STATUS = 'N'
870: THEN
871: l_EXCEPTION := NULL;
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
869: AND V3.CC_ENCMBRNC_STATUS = 'N'
870: THEN
871: l_EXCEPTION := NULL;
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 ,
870: THEN
871: l_EXCEPTION := NULL;
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,
903:
904: IF l_INVOICE_STATUS = TRUE
905: THEN
906: l_EXCEPTION := NULL;
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
904: IF l_INVOICE_STATUS = TRUE
905: THEN
906: l_EXCEPTION := NULL;
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 ,
905: THEN
906: l_EXCEPTION := NULL;
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,
934:
935: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IN'
936: THEN
937: l_EXCEPTION := NULL;
938: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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:
935: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IN'
936: THEN
937: l_EXCEPTION := NULL;
938: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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
936: THEN
937: l_EXCEPTION := NULL;
938: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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 ,
937: l_EXCEPTION := NULL;
938: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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,
986: )
987: AND V9.CC_ENCMBRNC_STATUS = 'N'
988: THEN
989: l_EXCEPTION := NULL;
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
987: AND V9.CC_ENCMBRNC_STATUS = 'N'
988: THEN
989: l_EXCEPTION := NULL;
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 ,
988: THEN
989: l_EXCEPTION := NULL;
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,
1012: V3.SET_OF_BOOKS_ID,
1013: p_REQUEST_ID);
1014:
1015: l_EXCEPTION := NULL;
1016: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1013: p_REQUEST_ID);
1014:
1015: l_EXCEPTION := NULL;
1016: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1014:
1015: l_EXCEPTION := NULL;
1016: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1015: l_EXCEPTION := NULL;
1016: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1049:
1050: IF l_INVOICE_STATUS = TRUE
1051: THEN
1052: l_EXCEPTION := NULL;
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
1050: IF l_INVOICE_STATUS = TRUE
1051: THEN
1052: l_EXCEPTION := NULL;
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 ,
1051: THEN
1052: l_EXCEPTION := NULL;
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,
1075: V3.SET_OF_BOOKS_ID,
1076: p_REQUEST_ID);
1077:
1078: l_EXCEPTION := NULL;
1079: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1076: p_REQUEST_ID);
1077:
1078: l_EXCEPTION := NULL;
1079: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1077:
1078: l_EXCEPTION := NULL;
1079: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1078: l_EXCEPTION := NULL;
1079: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1107:
1108: IF V9.CC_STATE = 'CM' AND V9.CC_APPRVL_STATUS = 'IN'
1109: THEN
1110: l_EXCEPTION := NULL;
1111: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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:
1108: IF V9.CC_STATE = 'CM' AND V9.CC_APPRVL_STATUS = 'IN'
1109: THEN
1110: l_EXCEPTION := NULL;
1111: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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
1109: THEN
1110: l_EXCEPTION := NULL;
1111: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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 ,
1110: l_EXCEPTION := NULL;
1111: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');
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,
1134: V3.SET_OF_BOOKS_ID,
1135: p_REQUEST_ID);
1136:
1137: l_EXCEPTION := NULL;
1138: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1135: p_REQUEST_ID);
1136:
1137: l_EXCEPTION := NULL;
1138: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1136:
1137: l_EXCEPTION := NULL;
1138: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1137: l_EXCEPTION := NULL;
1138: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1190: V3.ORG_ID,
1191: V3.SET_OF_BOOKS_ID,
1192: p_REQUEST_ID);
1193: l_EXCEPTION := NULL;
1194: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1191: V3.SET_OF_BOOKS_ID,
1192: p_REQUEST_ID);
1193: l_EXCEPTION := NULL;
1194: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1192: p_REQUEST_ID);
1193: l_EXCEPTION := NULL;
1194: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1193: l_EXCEPTION := NULL;
1194: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1231:
1232: IF V9.CC_STATE = 'PR' AND V9.CC_APPRVL_STATUS = 'IP'
1233: THEN
1234: l_EXCEPTION := NULL;
1235: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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:
1232: IF V9.CC_STATE = 'PR' AND V9.CC_APPRVL_STATUS = 'IP'
1233: THEN
1234: l_EXCEPTION := NULL;
1235: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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
1233: THEN
1234: l_EXCEPTION := NULL;
1235: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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 ,
1234: l_EXCEPTION := NULL;
1235: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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,
1257: V3.ORG_ID,
1258: V3.SET_OF_BOOKS_ID,
1259: p_REQUEST_ID);
1260: l_EXCEPTION := NULL;
1261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1258: V3.SET_OF_BOOKS_ID,
1259: p_REQUEST_ID);
1260: l_EXCEPTION := NULL;
1261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1259: p_REQUEST_ID);
1260: l_EXCEPTION := NULL;
1261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1260: l_EXCEPTION := NULL;
1261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1337:
1338: IF V9.CC_STATE = 'CL' AND V9.CC_APPRVL_STATUS = 'IP'
1339: THEN
1340: l_EXCEPTION := NULL;
1341: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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:
1338: IF V9.CC_STATE = 'CL' AND V9.CC_APPRVL_STATUS = 'IP'
1339: THEN
1340: l_EXCEPTION := NULL;
1341: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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
1339: THEN
1340: l_EXCEPTION := NULL;
1341: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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 ,
1340: l_EXCEPTION := NULL;
1341: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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,
1363: V3.ORG_ID,
1364: V3.SET_OF_BOOKS_ID,
1365: p_REQUEST_ID);
1366: l_EXCEPTION := NULL;
1367: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1364: V3.SET_OF_BOOKS_ID,
1365: p_REQUEST_ID);
1366: l_EXCEPTION := NULL;
1367: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1365: p_REQUEST_ID);
1366: l_EXCEPTION := NULL;
1367: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1366: l_EXCEPTION := NULL;
1367: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1422: EXIT WHEN C5%NOTFOUND;
1423:
1424: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1425: THEN
1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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;
1423:
1424: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1425: THEN
1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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:
1424: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1425: THEN
1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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
1425: THEN
1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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 ,
1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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,
1450: V3.SET_OF_BOOKS_ID,
1451: p_REQUEST_ID);
1452:
1453: l_EXCEPTION := NULL;
1454: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1451: p_REQUEST_ID);
1452:
1453: l_EXCEPTION := NULL;
1454: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1452:
1453: l_EXCEPTION := NULL;
1454: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1453: l_EXCEPTION := NULL;
1454: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1577:
1578: IF V9.CC_STATE = 'CM' AND V9.CC_APPRVL_STATUS = 'IP'
1579: THEN
1580: l_EXCEPTION := NULL;
1581: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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:
1578: IF V9.CC_STATE = 'CM' AND V9.CC_APPRVL_STATUS = 'IP'
1579: THEN
1580: l_EXCEPTION := NULL;
1581: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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
1579: THEN
1580: l_EXCEPTION := NULL;
1581: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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 ,
1580: l_EXCEPTION := NULL;
1581: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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,
1603: V3.SET_OF_BOOKS_ID,
1604: p_REQUEST_ID);
1605:
1606: l_EXCEPTION := NULL;
1607: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1604: p_REQUEST_ID);
1605:
1606: l_EXCEPTION := NULL;
1607: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1605:
1606: l_EXCEPTION := NULL;
1607: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1606: l_EXCEPTION := NULL;
1607: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1659: EXIT WHEN C5%NOTFOUND;
1660:
1661: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1662: THEN
1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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;
1660:
1661: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1662: THEN
1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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:
1661: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1662: THEN
1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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
1662: THEN
1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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 ,
1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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,
1687: V3.SET_OF_BOOKS_ID,
1688: p_REQUEST_ID);
1689:
1690: l_EXCEPTION := NULL;
1691: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1688: p_REQUEST_ID);
1689:
1690: l_EXCEPTION := NULL;
1691: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1689:
1690: l_EXCEPTION := NULL;
1691: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1690: l_EXCEPTION := NULL;
1691: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1809:
1810: IF V9.CC_STATE = 'CT' AND V9.CC_APPRVL_STATUS = 'IP'
1811: THEN
1812: l_EXCEPTION := NULL;
1813: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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:
1810: IF V9.CC_STATE = 'CT' AND V9.CC_APPRVL_STATUS = 'IP'
1811: THEN
1812: l_EXCEPTION := NULL;
1813: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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
1811: THEN
1812: l_EXCEPTION := NULL;
1813: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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 ,
1812: l_EXCEPTION := NULL;
1813: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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,
1835: V3.SET_OF_BOOKS_ID,
1836: p_REQUEST_ID);
1837:
1838: l_EXCEPTION := NULL;
1839: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1836: p_REQUEST_ID);
1837:
1838: l_EXCEPTION := NULL;
1839: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1837:
1838: l_EXCEPTION := NULL;
1839: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1838: l_EXCEPTION := NULL;
1839: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
1890: EXIT WHEN C5%NOTFOUND;
1891:
1892: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1893: THEN
1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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;
1891:
1892: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1893: THEN
1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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:
1892: IF V5.CC_DET_PF_BILLED_AMT > V5.CC_DET_PF_ENTERED_AMT
1893: THEN
1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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
1893: THEN
1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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 ,
1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');
1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);
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,
1917: V3.SET_OF_BOOKS_ID,
1918: p_REQUEST_ID);
1919:
1920: l_EXCEPTION := NULL;
1921: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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:
1918: p_REQUEST_ID);
1919:
1920: l_EXCEPTION := NULL;
1921: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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
1919:
1920: l_EXCEPTION := NULL;
1921: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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 ,
1920: l_EXCEPTION := NULL;
1921: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');
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,
2051: )
2052: AND V3.CC_ENCMBRNC_STATUS = 'N'
2053: THEN
2054: l_EXCEPTION := NULL;
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
2052: AND V3.CC_ENCMBRNC_STATUS = 'N'
2053: THEN
2054: l_EXCEPTION := NULL;
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 ,
2053: THEN
2054: l_EXCEPTION := NULL;
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,
2086:
2087: IF V3.CC_STATE = 'PR' AND V3.CC_APPRVL_STATUS = 'IP'
2088: THEN
2089: l_EXCEPTION := NULL;
2090: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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:
2087: IF V3.CC_STATE = 'PR' AND V3.CC_APPRVL_STATUS = 'IP'
2088: THEN
2089: l_EXCEPTION := NULL;
2090: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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
2088: THEN
2089: l_EXCEPTION := NULL;
2090: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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 ,
2089: l_EXCEPTION := NULL;
2090: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');
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,
2129:
2130: IF V3.CC_STATE = 'CL' AND V3.CC_APPRVL_STATUS = 'IP'
2131: THEN
2132: l_EXCEPTION := NULL;
2133: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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:
2130: IF V3.CC_STATE = 'CL' AND V3.CC_APPRVL_STATUS = 'IP'
2131: THEN
2132: l_EXCEPTION := NULL;
2133: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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
2131: THEN
2132: l_EXCEPTION := NULL;
2133: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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 ,
2132: l_EXCEPTION := NULL;
2133: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');
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,
2172:
2173: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IP'
2174: THEN
2175: l_EXCEPTION := NULL;
2176: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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:
2173: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS = 'IP'
2174: THEN
2175: l_EXCEPTION := NULL;
2176: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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
2174: THEN
2175: l_EXCEPTION := NULL;
2176: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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 ,
2175: l_EXCEPTION := NULL;
2176: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');
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,
2217:
2218: IF V3.CC_STATE = 'CT' AND V3.CC_APPRVL_STATUS = 'IP'
2219: THEN
2220: l_EXCEPTION := NULL;
2221: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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:
2218: IF V3.CC_STATE = 'CT' AND V3.CC_APPRVL_STATUS = 'IP'
2219: THEN
2220: l_EXCEPTION := NULL;
2221: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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
2219: THEN
2220: l_EXCEPTION := NULL;
2221: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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 ,
2220: l_EXCEPTION := NULL;
2221: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');
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,
3884: l_enable_budg_control_flag := 'N';
3885:
3886: IF (p_org_id IS NULL)
3887: THEN
3888: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');
3889: fnd_msg_pub.add;
3890: RAISE E_NULL_PARAMETER;
3891: END IF;
3892:
3891: END IF;
3892:
3893: IF (p_sob_id IS NULL)
3894: THEN
3895: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');
3896: fnd_msg_pub.add;
3897: RAISE E_NULL_PARAMETER;
3898: END IF;
3899: