DBA Data[Home] [Help]

APPS.IGC_CC_REP_YEP_PVT dependencies on FND_MESSAGE

Line 355: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');

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

Line 356: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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 ,

Line 357: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 389: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');

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(

Line 390: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 391: l_EXCEPTION := FND_MESSAGE.GET;

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 ,

Line 422: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');

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:

Line 423: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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,

Line 424: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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

Line 425: l_EXCEPTION := FND_MESSAGE.GET;

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 ,

Line 455: FND_MESSAGE.SET_NAME('IGC','IGC_CC_HAS_REV_VARIANCES');

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 ,

Line 456: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 497: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');

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

Line 498: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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 ,

Line 499: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 532: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');

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:

Line 533: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 534: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 535: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 562: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');

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:

Line 563: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 564: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 565: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 606: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 607: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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:

Line 608: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 609: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 610: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 651: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');

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:

Line 652: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 653: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 654: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 696: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 697: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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:

Line 698: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 699: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 700: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 741: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');

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:

Line 742: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 743: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 744: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 786: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 787: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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:

Line 788: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 789: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 790: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 872: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');

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

Line 873: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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 ,

Line 874: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 907: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');

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

Line 908: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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 ,

Line 909: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 938: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');

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:

Line 939: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 940: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 941: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 990: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');

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

Line 991: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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 ,

Line 992: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1016: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1017: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1018: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1019: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1053: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_INVOICE_PAID_OR_CAN');

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

Line 1054: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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 ,

Line 1055: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1079: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1080: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1081: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1082: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1111: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_CM_INCOMPLETE');

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:

Line 1112: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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

Line 1113: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 1114: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1138: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1139: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1140: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1141: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1194: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1195: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1196: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1197: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1235: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');

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:

Line 1236: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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

Line 1237: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 1238: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1262: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1263: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1264: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1341: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');

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:

Line 1342: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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

Line 1343: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 1344: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1367: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1368: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1369: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1370: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1426: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 1427: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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:

Line 1428: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 1429: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 1430: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1454: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1455: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1456: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1457: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1581: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');

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:

Line 1582: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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

Line 1583: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 1584: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1607: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1608: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1609: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1610: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1663: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 1664: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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:

Line 1665: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 1666: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 1667: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1691: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1692: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1693: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1694: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1813: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');

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:

Line 1814: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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

Line 1815: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 1816: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1839: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1840: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1841: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1842: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1894: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_OVERBILLED');

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;

Line 1895: FND_MESSAGE.SET_TOKEN('NUMBER',V9.CC_NUM,TRUE);

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:

Line 1896: FND_MESSAGE.SET_TOKEN('ACCT_LINE_NUM',V4.CC_ACCT_LINE_NUM,TRUE);

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

Line 1897: FND_MESSAGE.SET_TOKEN('PF_LINE_NUM',V5.CC_DET_PF_LINE_NUM,TRUE);

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 ,

Line 1898: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 1921: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_REL_COVER_FAIL');

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:

Line 1922: FND_MESSAGE.SET_TOKEN('NUMBER1',V9.CC_NUM,TRUE);

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

Line 1923: FND_MESSAGE.SET_TOKEN('NUMBER2',V3.CC_NUM,TRUE);

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 ,

Line 1924: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 2055: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_NOT_FULLY_ENC');

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

Line 2056: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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 ,

Line 2057: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 2090: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_PR_INPROCESS');

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:

Line 2091: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 2092: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 2093: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 2133: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CL_INPROCESS');

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:

Line 2134: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 2135: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 2136: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 2176: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CM_INPROCESS');

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:

Line 2177: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 2178: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 2179: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 2221: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_CT_INPROCESS');

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:

Line 2222: FND_MESSAGE.SET_TOKEN('NUMBER',V3.CC_NUM,TRUE);

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

Line 2223: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_PROCESS_TYPE,TRUE);

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 ,

Line 2224: l_EXCEPTION := FND_MESSAGE.GET;

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,

Line 3888: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');

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:

Line 3895: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');

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: