eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XCV_BUS dependencies on FND_MESSAGE

Line 208: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

204: close csr_sec_grp;
205: --
206: -- The primary key is invalid therefore we must error
207: --
208: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
209: fnd_message.raise_error;
210: --
211: end if;
212: close csr_sec_grp;

Line 209: fnd_message.raise_error;

205: --
206: -- The primary key is invalid therefore we must error
207: --
208: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
209: fnd_message.raise_error;
210: --
211: end if;
212: close csr_sec_grp;
213: --

Line 428: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');

424: open c2 ;
425: fetch c2 into l_dummy;
426: close c2;
427: if l_dummy = 'N' then
428: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
429: fnd_message.raise_error;
430: end if ;
431: end if;
432: end if ;

Line 429: fnd_message.raise_error;

425: fetch c2 into l_dummy;
426: close c2;
427: if l_dummy = 'N' then
428: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
429: fnd_message.raise_error;
430: end if ;
431: end if;
432: end if ;
433: --

Line 591: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');

587: --
588: close c1;
589: if l_crit_typ_cd = 'PPC' and p_val_1 is null then
590: --
591: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');
592: fnd_message.raise_error;
593: --
594: end if;
595: --

Line 592: fnd_message.raise_error;

588: close c1;
589: if l_crit_typ_cd = 'PPC' and p_val_1 is null then
590: --
591: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');
592: fnd_message.raise_error;
593: --
594: end if;
595: --
596: --

Line 604: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

600: begin
601: l_number := to_number(p_val_1);
602: exception
603: when invalid_number then
604: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
605: fnd_message.raise_error;
606: end;
607: end if;
608: --

Line 605: fnd_message.raise_error;

601: l_number := to_number(p_val_1);
602: exception
603: when invalid_number then
604: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
605: fnd_message.raise_error;
606: end;
607: end if;
608: --
609: if l_crit_typ_cd = 'PID' then

Line 615: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

611: open c2 (nvl(p_ext_crit_bg_id,p_business_group_id ) ) ;
612: fetch c2 into l_dummy;
613: if c2%notfound then
614: close c2;
615: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
616: fnd_message.raise_error;
617: end if;
618: close c2;
619: --

Line 616: fnd_message.raise_error;

612: fetch c2 into l_dummy;
613: if c2%notfound then
614: close c2;
615: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
616: fnd_message.raise_error;
617: end if;
618: close c2;
619: --
620: elsif l_crit_typ_cd = 'PST' then

Line 633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

629: p_effective_date => p_effective_date) then
630: --
631: -- raise error as does not exist as lookup
632: --
633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
634: fnd_message.set_token('FIELD','p_val_1');
635: fnd_message.set_name('TYPE','US_STATE');
636: fnd_message.raise_error;
637: --

Line 634: fnd_message.set_token('FIELD','p_val_1');

630: --
631: -- raise error as does not exist as lookup
632: --
633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
634: fnd_message.set_token('FIELD','p_val_1');
635: fnd_message.set_name('TYPE','US_STATE');
636: fnd_message.raise_error;
637: --
638: end if;

Line 635: fnd_message.set_name('TYPE','US_STATE');

631: -- raise error as does not exist as lookup
632: --
633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
634: fnd_message.set_token('FIELD','p_val_1');
635: fnd_message.set_name('TYPE','US_STATE');
636: fnd_message.raise_error;
637: --
638: end if;
639: else

Line 636: fnd_message.raise_error;

632: --
633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
634: fnd_message.set_token('FIELD','p_val_1');
635: fnd_message.set_name('TYPE','US_STATE');
636: fnd_message.raise_error;
637: --
638: end if;
639: else
640: /* BG is null, so alternative call is required */

Line 648: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

644: p_effective_date => p_effective_date) then
645: --
646: -- raise error as does not exist as lookup
647: --
648: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
649: fnd_message.set_token('FIELD','p_val_1');
650: fnd_message.set_name('TYPE','US_STATE');
651: fnd_message.raise_error;
652: --

Line 649: fnd_message.set_token('FIELD','p_val_1');

645: --
646: -- raise error as does not exist as lookup
647: --
648: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
649: fnd_message.set_token('FIELD','p_val_1');
650: fnd_message.set_name('TYPE','US_STATE');
651: fnd_message.raise_error;
652: --
653: end if;

Line 650: fnd_message.set_name('TYPE','US_STATE');

646: -- raise error as does not exist as lookup
647: --
648: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
649: fnd_message.set_token('FIELD','p_val_1');
650: fnd_message.set_name('TYPE','US_STATE');
651: fnd_message.raise_error;
652: --
653: end if;
654: end if;

Line 651: fnd_message.raise_error;

647: --
648: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
649: fnd_message.set_token('FIELD','p_val_1');
650: fnd_message.set_name('TYPE','US_STATE');
651: fnd_message.raise_error;
652: --
653: end if;
654: end if;
655: --

Line 668: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

664: open c3 (nvl(p_ext_crit_bg_id,p_business_group_id ) );
665: fetch c3 into l_dummy;
666: if c3%notfound then
667: close c3;
668: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
669: fnd_message.raise_error;
670: end if;
671: close c3;
672: --

Line 669: fnd_message.raise_error;

665: fetch c3 into l_dummy;
666: if c3%notfound then
667: close c3;
668: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
669: fnd_message.raise_error;
670: end if;
671: close c3;
672: --
673: elsif l_crit_typ_cd = 'PLO' then

Line 679: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

675: open c4;
676: fetch c4 into l_dummy;
677: if c4%notfound then
678: close c4;
679: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
680: fnd_message.raise_error;
681: end if;
682: close c4;
683: --

Line 680: fnd_message.raise_error;

676: fetch c4 into l_dummy;
677: if c4%notfound then
678: close c4;
679: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
680: fnd_message.raise_error;
681: end if;
682: close c4;
683: --
684: elsif l_crit_typ_cd = 'PLE' then

Line 690: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

686: open c5(nvl(p_ext_crit_bg_id,p_business_group_id ) );
687: fetch c5 into l_dummy;
688: if c5%notfound then
689: close c5;
690: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
691: fnd_message.raise_error;
692: end if;
693: close c5;
694: --

Line 691: fnd_message.raise_error;

687: fetch c5 into l_dummy;
688: if c5%notfound then
689: close c5;
690: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
691: fnd_message.raise_error;
692: end if;
693: close c5;
694: --
695: elsif l_crit_typ_cd = 'BPL' then

Line 701: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

697: open c6(nvl(p_ext_crit_bg_id,p_business_group_id ) );
698: fetch c6 into l_dummy;
699: if c6%notfound then
700: close c6;
701: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
702: fnd_message.raise_error;
703: end if;
704: close c6;
705:

Line 702: fnd_message.raise_error;

698: fetch c6 into l_dummy;
699: if c6%notfound then
700: close c6;
701: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
702: fnd_message.raise_error;
703: end if;
704: close c6;
705:
706:

Line 720: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

716: p_effective_date => p_effective_date) then
717: --
718: -- raise error as does not exist as lookup
719: --
720: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
721: -- Commented for Bug 2493525
722: /* fnd_message.set_token('FIELD','p_val_1');
723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:

Line 722: /* fnd_message.set_token('FIELD','p_val_1');

718: -- raise error as does not exist as lookup
719: --
720: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
721: -- Commented for Bug 2493525
722: /* fnd_message.set_token('FIELD','p_val_1');
723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:
725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');

Line 723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */

719: --
720: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
721: -- Commented for Bug 2493525
722: /* fnd_message.set_token('FIELD','p_val_1');
723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:
725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');
727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');

Line 725: fnd_message.set_token('VALUE',p_val_1);

721: -- Commented for Bug 2493525
722: /* fnd_message.set_token('FIELD','p_val_1');
723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:
725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');
727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
728: -- End of Bug 2493525
729: fnd_message.raise_error;

Line 726: fnd_message.set_token('FIELD','Value');

722: /* fnd_message.set_token('FIELD','p_val_1');
723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:
725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');
727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
728: -- End of Bug 2493525
729: fnd_message.raise_error;
730: --

Line 727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');

723: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
724:
725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');
727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
728: -- End of Bug 2493525
729: fnd_message.raise_error;
730: --
731: end if;

Line 729: fnd_message.raise_error;

725: fnd_message.set_token('VALUE',p_val_1);
726: fnd_message.set_token('FIELD','Value');
727: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
728: -- End of Bug 2493525
729: fnd_message.raise_error;
730: --
731: end if;
732: else
733: /* BG is null, so alternative call is required */

Line 741: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

737: p_effective_date => p_effective_date) then
738: --
739: -- raise error as does not exist as lookup
740: --
741: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
742: -- Commented for Bug 2493525
743: /* fnd_message.set_token('FIELD','p_val_1');
744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:

Line 743: /* fnd_message.set_token('FIELD','p_val_1');

739: -- raise error as does not exist as lookup
740: --
741: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
742: -- Commented for Bug 2493525
743: /* fnd_message.set_token('FIELD','p_val_1');
744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:
746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');

Line 744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */

740: --
741: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
742: -- Commented for Bug 2493525
743: /* fnd_message.set_token('FIELD','p_val_1');
744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:
746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');
748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');

Line 746: fnd_message.set_token('VALUE',p_val_1);

742: -- Commented for Bug 2493525
743: /* fnd_message.set_token('FIELD','p_val_1');
744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:
746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');
748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
749: -- End of Bug 2493525
750: fnd_message.raise_error;

Line 747: fnd_message.set_token('FIELD','Value');

743: /* fnd_message.set_token('FIELD','p_val_1');
744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:
746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');
748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
749: -- End of Bug 2493525
750: fnd_message.raise_error;
751: --

Line 748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');

744: fnd_message.set_name('TYPE','BEN_EXT_CHG_TYP'); */
745:
746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');
748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
749: -- End of Bug 2493525
750: fnd_message.raise_error;
751: --
752: end if;

Line 750: fnd_message.raise_error;

746: fnd_message.set_token('VALUE',p_val_1);
747: fnd_message.set_token('FIELD','Value');
748: fnd_message.set_token('TYPE','BEN_EXT_CHG_TYP');
749: -- End of Bug 2493525
750: fnd_message.raise_error;
751: --
752: end if;
753: end if;
754:

Line 770: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

766: p_effective_date => p_effective_date) then
767: --
768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
771: -- Commented for Bug 2493525
772: /* fnd_message.set_token('FIELD','p_val_1');
773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:

Line 772: /* fnd_message.set_token('FIELD','p_val_1');

768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
771: -- Commented for Bug 2493525
772: /* fnd_message.set_token('FIELD','p_val_1');
773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:
775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');

Line 773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */

769: --
770: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
771: -- Commented for Bug 2493525
772: /* fnd_message.set_token('FIELD','p_val_1');
773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:
775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');
777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 775: fnd_message.set_token('VALUE',p_val_1);

771: -- Commented for Bug 2493525
772: /* fnd_message.set_token('FIELD','p_val_1');
773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:
775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');
777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
778: -- End of Bug 2493525
779: fnd_message.raise_error;

Line 776: fnd_message.set_token('FIELD','Value');

772: /* fnd_message.set_token('FIELD','p_val_1');
773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:
775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');
777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
778: -- End of Bug 2493525
779: fnd_message.raise_error;
780: --

Line 777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

773: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
774:
775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');
777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
778: -- End of Bug 2493525
779: fnd_message.raise_error;
780: --
781: end if;

Line 779: fnd_message.raise_error;

775: fnd_message.set_token('VALUE',p_val_1);
776: fnd_message.set_token('FIELD','Value');
777: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
778: -- End of Bug 2493525
779: fnd_message.raise_error;
780: --
781: end if;
782: else
783: /* BG is null, so alternative call is required */

Line 791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

787: p_effective_date => p_effective_date) then
788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: -- Commented for Bug 2493525
793: /* fnd_message.set_token('FIELD','p_val_1');
794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:

Line 793: /* fnd_message.set_token('FIELD','p_val_1');

789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: -- Commented for Bug 2493525
793: /* fnd_message.set_token('FIELD','p_val_1');
794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:
796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');

Line 794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */

790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: -- Commented for Bug 2493525
793: /* fnd_message.set_token('FIELD','p_val_1');
794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:
796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');
798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 796: fnd_message.set_token('VALUE',p_val_1);

792: -- Commented for Bug 2493525
793: /* fnd_message.set_token('FIELD','p_val_1');
794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:
796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');
798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
799: -- End of Bug 2493525
800: fnd_message.raise_error;

Line 797: fnd_message.set_token('FIELD','Value');

793: /* fnd_message.set_token('FIELD','p_val_1');
794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:
796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');
798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
799: -- End of Bug 2493525
800: fnd_message.raise_error;
801: --

Line 798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

794: fnd_message.set_name('TYPE','BEN_EXT_CHG_EVT'); */
795:
796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');
798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
799: -- End of Bug 2493525
800: fnd_message.raise_error;
801: --
802: end if;

Line 800: fnd_message.raise_error;

796: fnd_message.set_token('VALUE',p_val_1);
797: fnd_message.set_token('FIELD','Value');
798: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
799: -- End of Bug 2493525
800: fnd_message.raise_error;
801: --
802: end if;
803: end if;
804: elsif p_val_2 = 'PAY' then

Line 810: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

806: open c10 ;
807: fetch c10 into l_dummy ;
808: if c10%notfound then
809: close c10 ;
810: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
811: fnd_message.raise_error;
812: end if ;
813:
814: close c10 ;

Line 811: fnd_message.raise_error;

807: fetch c10 into l_dummy ;
808: if c10%notfound then
809: close c10 ;
810: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
811: fnd_message.raise_error;
812: end if ;
813:
814: close c10 ;
815:

Line 825: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

821: open c7(nvl(p_ext_crit_bg_id,p_business_group_id ) );
822: fetch c7 into l_dummy;
823: if c7%notfound then
824: close c7;
825: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
826: fnd_message.raise_error;
827: end if;
828: close c7;
829: --

Line 826: fnd_message.raise_error;

822: fetch c7 into l_dummy;
823: if c7%notfound then
824: close c7;
825: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
826: fnd_message.raise_error;
827: end if;
828: close c7;
829: --
830: elsif l_crit_typ_cd = 'PAS' then

Line 836: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');

832: open c8(nvl(p_ext_crit_bg_id,p_business_group_id ) );
833: fetch c8 into l_dummy;
834: if c8%notfound then
835: close c8;
836: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
837: fnd_message.raise_error;
838: end if;
839: close c8;
840: --

Line 837: fnd_message.raise_error;

833: fetch c8 into l_dummy;
834: if c8%notfound then
835: close c8;
836: fnd_message.set_name('BEN','BEN_91911_EXT_INVLD_VAL1');
837: fnd_message.raise_error;
838: end if;
839: close c8;
840: --
841: end if;

Line 850: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');

846: open c9;
847: fetch c9 into l_dummy;
848: if c9%found then
849: close c9;
850: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
851: fnd_message.raise_error;
852: end if;
853: close c9;
854: --

Line 851: fnd_message.raise_error;

847: fetch c9 into l_dummy;
848: if c9%found then
849: close c9;
850: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
851: fnd_message.raise_error;
852: end if;
853: close c9;
854: --
855: end if;

Line 947: fnd_message.set_name('BEN','BEN_91913_EXT_INVLD_VAL2');

943: -- val_2 is currently only valid with parent crit_typ_cd = PPC
944: --
945: /*if p_val_2 is not null and l_crit_typ_cd <> 'PPC' then
946: --
947: fnd_message.set_name('BEN','BEN_91913_EXT_INVLD_VAL2');
948: fnd_message.raise_error;
949: --
950: end if;*/
951: --

Line 948: fnd_message.raise_error;

944: --
945: /*if p_val_2 is not null and l_crit_typ_cd <> 'PPC' then
946: --
947: fnd_message.set_name('BEN','BEN_91913_EXT_INVLD_VAL2');
948: fnd_message.raise_error;
949: --
950: end if;*/
951: --
952: -- make sure val_2 is unique within parent crit_typ_cd.

Line 959: fnd_message.set_name('BEN','BEN_91914_EXT_VAL2_NOT_UNIQUE');

955: open c2;
956: fetch c2 into l_dummy;
957: if c2%found then
958: close c2;
959: fnd_message.set_name('BEN','BEN_91914_EXT_VAL2_NOT_UNIQUE');
960: fnd_message.raise_error;
961: end if;
962: close c2;
963: elsif l_crit_typ_cd = 'REE' then

Line 960: fnd_message.raise_error;

956: fetch c2 into l_dummy;
957: if c2%found then
958: close c2;
959: fnd_message.set_name('BEN','BEN_91914_EXT_VAL2_NOT_UNIQUE');
960: fnd_message.raise_error;
961: end if;
962: close c2;
963: elsif l_crit_typ_cd = 'REE' then
964: open c3;

Line 968: fnd_message.set_name('BEN','BEN_91982_EXT_VAL_NOT_UNIQUE');

964: open c3;
965: fetch c3 into l_dummy;
966: if c3%found then
967: close c3;
968: fnd_message.set_name('BEN','BEN_91982_EXT_VAL_NOT_UNIQUE');
969: fnd_message.raise_error;
970: end if;
971: close c3;
972: --

Line 969: fnd_message.raise_error;

965: fetch c3 into l_dummy;
966: if c3%found then
967: close c3;
968: fnd_message.set_name('BEN','BEN_91982_EXT_VAL_NOT_UNIQUE');
969: fnd_message.raise_error;
970: end if;
971: close c3;
972: --
973: end if;

Line 1045: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');

1041: -- val_2 must be > val_1.
1042: --
1043: if l_crit_typ_cd = 'REE' and p_val_2 is not null and p_val_1 is null then
1044: --
1045: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');
1046: fnd_message.raise_error;
1047: --
1048: end if;
1049: if l_crit_typ_cd = 'PPC' and p_val_2 is not null and p_val_1 >= p_val_2 then

Line 1046: fnd_message.raise_error;

1042: --
1043: if l_crit_typ_cd = 'REE' and p_val_2 is not null and p_val_1 is null then
1044: --
1045: fnd_message.set_name('BEN','BEN_91910_EXT_VAL1_RQD');
1046: fnd_message.raise_error;
1047: --
1048: end if;
1049: if l_crit_typ_cd = 'PPC' and p_val_2 is not null and p_val_1 >= p_val_2 then
1050: --

Line 1051: fnd_message.set_name('BEN','BEN_91915_EXT_VAL1_GT_VAL2');

1047: --
1048: end if;
1049: if l_crit_typ_cd = 'PPC' and p_val_2 is not null and p_val_1 >= p_val_2 then
1050: --
1051: fnd_message.set_name('BEN','BEN_91915_EXT_VAL1_GT_VAL2');
1052: fnd_message.raise_error;
1053: --
1054: end if;
1055: --

Line 1052: fnd_message.raise_error;

1048: end if;
1049: if l_crit_typ_cd = 'PPC' and p_val_2 is not null and p_val_1 >= p_val_2 then
1050: --
1051: fnd_message.set_name('BEN','BEN_91915_EXT_VAL1_GT_VAL2');
1052: fnd_message.raise_error;
1053: --
1054: end if;
1055: --
1056: end if;

Line 1260: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1256: close csr_leg_code;
1257: --
1258: -- The primary key is invalid therefore we must error
1259: --
1260: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1261: fnd_message.raise_error;
1262: --
1263: end if;
1264: --

Line 1261: fnd_message.raise_error;

1257: --
1258: -- The primary key is invalid therefore we must error
1259: --
1260: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1261: fnd_message.raise_error;
1262: --
1263: end if;
1264: --
1265: close csr_leg_code;