218: p_effective_date => p_effective_date) then
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('BEN','BEN_91626_STATUS_CD_INVALID');
223: fnd_message.raise_error;
224: --
225: end if;
226: --
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('BEN','BEN_91626_STATUS_CD_INVALID');
223: fnd_message.raise_error;
224: --
225: end if;
226: --
227: end if;
287: p_effective_date => p_effective_date) then
288: --
289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD','p_asmt_to_use_cd');
293: fnd_message.set_token('TYPE','BEN_ASMT_TO_USE');
294: fnd_message.raise_error;
295: --
288: --
289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD','p_asmt_to_use_cd');
293: fnd_message.set_token('TYPE','BEN_ASMT_TO_USE');
294: fnd_message.raise_error;
295: --
296: end if;
289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD','p_asmt_to_use_cd');
293: fnd_message.set_token('TYPE','BEN_ASMT_TO_USE');
294: fnd_message.raise_error;
295: --
296: end if;
297: --
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD','p_asmt_to_use_cd');
293: fnd_message.set_token('TYPE','BEN_ASMT_TO_USE');
294: fnd_message.raise_error;
295: --
296: end if;
297: --
298: end if;
335: --
336: if c_cagr_exists%found then
337: close c_cagr_exists;
338: --Start Bug 5753149
339: l_return := fnd_message.get_string('BEN','BEN_94881_PCE_EXISTS');
340: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
341: fnd_message.set_token('ENTITY_NAME',l_return);
342: --End Bug 5753149
343: fnd_message.raise_error;
336: if c_cagr_exists%found then
337: close c_cagr_exists;
338: --Start Bug 5753149
339: l_return := fnd_message.get_string('BEN','BEN_94881_PCE_EXISTS');
340: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
341: fnd_message.set_token('ENTITY_NAME',l_return);
342: --End Bug 5753149
343: fnd_message.raise_error;
344:
337: close c_cagr_exists;
338: --Start Bug 5753149
339: l_return := fnd_message.get_string('BEN','BEN_94881_PCE_EXISTS');
340: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
341: fnd_message.set_token('ENTITY_NAME',l_return);
342: --End Bug 5753149
343: fnd_message.raise_error;
344:
345: end if;
339: l_return := fnd_message.get_string('BEN','BEN_94881_PCE_EXISTS');
340: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
341: fnd_message.set_token('ENTITY_NAME',l_return);
342: --End Bug 5753149
343: fnd_message.raise_error;
344:
345: end if;
346: close c_cagr_exists;
347: --
382: fetch c_eoep_exists into l_eoep_exists;
383: --
384: if c_eoep_exists%found then
385: close c_eoep_exists;
386: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
387: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
388: fnd_message.set_token('ENTITY_NAME',l_return);
389: fnd_message.raise_error;
390: end if;
383: --
384: if c_eoep_exists%found then
385: close c_eoep_exists;
386: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
387: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
388: fnd_message.set_token('ENTITY_NAME',l_return);
389: fnd_message.raise_error;
390: end if;
391: close c_eoep_exists;
384: if c_eoep_exists%found then
385: close c_eoep_exists;
386: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
387: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
388: fnd_message.set_token('ENTITY_NAME',l_return);
389: fnd_message.raise_error;
390: end if;
391: close c_eoep_exists;
392: --
385: close c_eoep_exists;
386: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
387: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
388: fnd_message.set_token('ENTITY_NAME',l_return);
389: fnd_message.raise_error;
390: end if;
391: close c_eoep_exists;
392: --
393: hr_utility.set_location('Leaving:'||l_proc, 5);
564: p_effective_date => p_effective_date) then
565: --
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
571: fnd_message.raise_error;
572: --
565: --
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
571: fnd_message.raise_error;
572: --
573: end if;
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
571: fnd_message.raise_error;
572: --
573: end if;
574: --
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
571: fnd_message.raise_error;
572: --
573: end if;
574: --
575: if hr_api.not_exists_in_hr_lookups
578: p_effective_date => p_effective_date) then
579: --
580: -- raise error as does not exist as lookup
581: --
582: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
583: fnd_message.set_token('TYPE','YES_NO');
584: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
585: fnd_message.raise_error;
586: --
579: --
580: -- raise error as does not exist as lookup
581: --
582: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
583: fnd_message.set_token('TYPE','YES_NO');
584: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
585: fnd_message.raise_error;
586: --
587: end if;
580: -- raise error as does not exist as lookup
581: --
582: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
583: fnd_message.set_token('TYPE','YES_NO');
584: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
585: fnd_message.raise_error;
586: --
587: end if;
588: --
581: --
582: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
583: fnd_message.set_token('TYPE','YES_NO');
584: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
585: fnd_message.raise_error;
586: --
587: end if;
588: --
589: if hr_api.not_exists_in_hr_lookups
592: p_effective_date => p_effective_date) then
593: --
594: -- raise error as does not exist as lookup
595: --
596: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
597: fnd_message.set_token('TYPE','YES_NO');
598: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
599: fnd_message.raise_error;
600: --
593: --
594: -- raise error as does not exist as lookup
595: --
596: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
597: fnd_message.set_token('TYPE','YES_NO');
598: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
599: fnd_message.raise_error;
600: --
601: end if;
594: -- raise error as does not exist as lookup
595: --
596: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
597: fnd_message.set_token('TYPE','YES_NO');
598: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
599: fnd_message.raise_error;
600: --
601: end if;
602: --
595: --
596: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
597: fnd_message.set_token('TYPE','YES_NO');
598: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
599: fnd_message.raise_error;
600: --
601: end if;
602: --
603: if hr_api.not_exists_in_hr_lookups
606: p_effective_date => p_effective_date) then
607: --
608: -- raise error as does not exist as lookup
609: --
610: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
611: fnd_message.set_token('TYPE','YES_NO');
612: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
613: fnd_message.raise_error;
614: --
607: --
608: -- raise error as does not exist as lookup
609: --
610: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
611: fnd_message.set_token('TYPE','YES_NO');
612: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
613: fnd_message.raise_error;
614: --
615: end if;
608: -- raise error as does not exist as lookup
609: --
610: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
611: fnd_message.set_token('TYPE','YES_NO');
612: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
613: fnd_message.raise_error;
614: --
615: end if;
616: --
609: --
610: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
611: fnd_message.set_token('TYPE','YES_NO');
612: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
613: fnd_message.raise_error;
614: --
615: end if;
616: --
617: if hr_api.not_exists_in_hr_lookups
620: p_effective_date => p_effective_date) then
621: --
622: -- raise error as does not exist as lookup
623: --
624: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
625: fnd_message.set_token('TYPE','YES_NO');
626: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
627: fnd_message.raise_error;
628: --
621: --
622: -- raise error as does not exist as lookup
623: --
624: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
625: fnd_message.set_token('TYPE','YES_NO');
626: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
627: fnd_message.raise_error;
628: --
629: end if;
622: -- raise error as does not exist as lookup
623: --
624: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
625: fnd_message.set_token('TYPE','YES_NO');
626: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
627: fnd_message.raise_error;
628: --
629: end if;
630: --
623: --
624: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
625: fnd_message.set_token('TYPE','YES_NO');
626: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
627: fnd_message.raise_error;
628: --
629: end if;
630: --
631: if hr_api.not_exists_in_hr_lookups
634: p_effective_date => p_effective_date) then
635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('TYPE','YES_NO');
640: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
641: fnd_message.raise_error;
642: --
635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('TYPE','YES_NO');
640: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
641: fnd_message.raise_error;
642: --
643: end if;
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('TYPE','YES_NO');
640: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('TYPE','YES_NO');
640: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: if hr_api.not_exists_in_hr_lookups
648: p_effective_date => p_effective_date) then
649: --
650: -- raise error as does not exist as lookup
651: --
652: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
653: fnd_message.set_token('TYPE','YES_NO');
654: fnd_message.set_token('FIELD','p_elig_job_flag');
655: fnd_message.raise_error;
656: --
649: --
650: -- raise error as does not exist as lookup
651: --
652: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
653: fnd_message.set_token('TYPE','YES_NO');
654: fnd_message.set_token('FIELD','p_elig_job_flag');
655: fnd_message.raise_error;
656: --
657: end if;
650: -- raise error as does not exist as lookup
651: --
652: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
653: fnd_message.set_token('TYPE','YES_NO');
654: fnd_message.set_token('FIELD','p_elig_job_flag');
655: fnd_message.raise_error;
656: --
657: end if;
658: --
651: --
652: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
653: fnd_message.set_token('TYPE','YES_NO');
654: fnd_message.set_token('FIELD','p_elig_job_flag');
655: fnd_message.raise_error;
656: --
657: end if;
658: --
659: if hr_api.not_exists_in_hr_lookups
662: p_effective_date => p_effective_date) then
663: --
664: -- raise error as does not exist as lookup
665: --
666: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
667: fnd_message.set_token('TYPE','YES_NO');
668: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
669: fnd_message.raise_error;
670: --
663: --
664: -- raise error as does not exist as lookup
665: --
666: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
667: fnd_message.set_token('TYPE','YES_NO');
668: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
669: fnd_message.raise_error;
670: --
671: end if;
664: -- raise error as does not exist as lookup
665: --
666: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
667: fnd_message.set_token('TYPE','YES_NO');
668: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
669: fnd_message.raise_error;
670: --
671: end if;
672: --
665: --
666: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
667: fnd_message.set_token('TYPE','YES_NO');
668: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
669: fnd_message.raise_error;
670: --
671: end if;
672: --
673: if hr_api.not_exists_in_hr_lookups
676: p_effective_date => p_effective_date) then
677: --
678: -- raise error as does not exist as lookup
679: --
680: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
681: fnd_message.set_token('TYPE','YES_NO');
682: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
683: fnd_message.raise_error;
684: --
677: --
678: -- raise error as does not exist as lookup
679: --
680: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
681: fnd_message.set_token('TYPE','YES_NO');
682: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
683: fnd_message.raise_error;
684: --
685: end if;
678: -- raise error as does not exist as lookup
679: --
680: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
681: fnd_message.set_token('TYPE','YES_NO');
682: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
679: --
680: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
681: fnd_message.set_token('TYPE','YES_NO');
682: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
687: if hr_api.not_exists_in_hr_lookups
690: p_effective_date => p_effective_date) then
691: --
692: -- raise error as does not exist as lookup
693: --
694: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
695: fnd_message.set_token('TYPE','YES_NO');
696: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
697: fnd_message.raise_error;
698: --
691: --
692: -- raise error as does not exist as lookup
693: --
694: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
695: fnd_message.set_token('TYPE','YES_NO');
696: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
697: fnd_message.raise_error;
698: --
699: end if;
692: -- raise error as does not exist as lookup
693: --
694: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
695: fnd_message.set_token('TYPE','YES_NO');
696: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
697: fnd_message.raise_error;
698: --
699: end if;
700: --
693: --
694: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
695: fnd_message.set_token('TYPE','YES_NO');
696: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
697: fnd_message.raise_error;
698: --
699: end if;
700: --
701: if hr_api.not_exists_in_hr_lookups
704: p_effective_date => p_effective_date) then
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('TYPE','YES_NO');
710: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
711: fnd_message.raise_error;
712: --
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('TYPE','YES_NO');
710: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
711: fnd_message.raise_error;
712: --
713: end if;
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('TYPE','YES_NO');
710: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('TYPE','YES_NO');
710: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
715: if hr_api.not_exists_in_hr_lookups
718: p_effective_date => p_effective_date) then
719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('TYPE','YES_NO');
724: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
725: fnd_message.raise_error;
726: --
719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('TYPE','YES_NO');
724: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
725: fnd_message.raise_error;
726: --
727: end if;
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('TYPE','YES_NO');
724: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
725: fnd_message.raise_error;
726: --
727: end if;
728: --
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('TYPE','YES_NO');
724: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
725: fnd_message.raise_error;
726: --
727: end if;
728: --
729: if hr_api.not_exists_in_hr_lookups
732: p_effective_date => p_effective_date) then
733: --
734: -- raise error as does not exist as lookup
735: --
736: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
737: fnd_message.set_token('TYPE','YES_NO');
738: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
739: fnd_message.raise_error;
740: --
733: --
734: -- raise error as does not exist as lookup
735: --
736: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
737: fnd_message.set_token('TYPE','YES_NO');
738: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
739: fnd_message.raise_error;
740: --
741: end if;
734: -- raise error as does not exist as lookup
735: --
736: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
737: fnd_message.set_token('TYPE','YES_NO');
738: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
739: fnd_message.raise_error;
740: --
741: end if;
742: --
735: --
736: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
737: fnd_message.set_token('TYPE','YES_NO');
738: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
739: fnd_message.raise_error;
740: --
741: end if;
742: --
743: if hr_api.not_exists_in_hr_lookups
746: p_effective_date => p_effective_date) then
747: --
748: -- raise error as does not exist as lookup
749: --
750: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
751: fnd_message.set_token('TYPE','YES_NO');
752: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
753: fnd_message.raise_error;
754: --
747: --
748: -- raise error as does not exist as lookup
749: --
750: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
751: fnd_message.set_token('TYPE','YES_NO');
752: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
753: fnd_message.raise_error;
754: --
755: end if;
748: -- raise error as does not exist as lookup
749: --
750: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
751: fnd_message.set_token('TYPE','YES_NO');
752: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
753: fnd_message.raise_error;
754: --
755: end if;
756: --
749: --
750: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
751: fnd_message.set_token('TYPE','YES_NO');
752: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
753: fnd_message.raise_error;
754: --
755: end if;
756: --
757: if hr_api.not_exists_in_hr_lookups
760: p_effective_date => p_effective_date) then
761: --
762: -- raise error as does not exist as lookup
763: --
764: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
765: fnd_message.set_token('TYPE','YES_NO');
766: fnd_message.set_token('FIELD','p_elig_age_flag');
767: fnd_message.raise_error;
768: --
761: --
762: -- raise error as does not exist as lookup
763: --
764: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
765: fnd_message.set_token('TYPE','YES_NO');
766: fnd_message.set_token('FIELD','p_elig_age_flag');
767: fnd_message.raise_error;
768: --
769: end if;
762: -- raise error as does not exist as lookup
763: --
764: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
765: fnd_message.set_token('TYPE','YES_NO');
766: fnd_message.set_token('FIELD','p_elig_age_flag');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
763: --
764: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
765: fnd_message.set_token('TYPE','YES_NO');
766: fnd_message.set_token('FIELD','p_elig_age_flag');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
771: if hr_api.not_exists_in_hr_lookups
774: p_effective_date => p_effective_date) then
775: --
776: -- raise error as does not exist as lookup
777: --
778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
779: fnd_message.set_token('TYPE','YES_NO');
780: fnd_message.set_token('FIELD','p_elig_los_flag');
781: fnd_message.raise_error;
782: --
775: --
776: -- raise error as does not exist as lookup
777: --
778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
779: fnd_message.set_token('TYPE','YES_NO');
780: fnd_message.set_token('FIELD','p_elig_los_flag');
781: fnd_message.raise_error;
782: --
783: end if;
776: -- raise error as does not exist as lookup
777: --
778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
779: fnd_message.set_token('TYPE','YES_NO');
780: fnd_message.set_token('FIELD','p_elig_los_flag');
781: fnd_message.raise_error;
782: --
783: end if;
784: --
777: --
778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
779: fnd_message.set_token('TYPE','YES_NO');
780: fnd_message.set_token('FIELD','p_elig_los_flag');
781: fnd_message.raise_error;
782: --
783: end if;
784: --
785: if hr_api.not_exists_in_hr_lookups
788: p_effective_date => p_effective_date) then
789: --
790: -- raise error as does not exist as lookup
791: --
792: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
795: fnd_message.raise_error;
796: --
789: --
790: -- raise error as does not exist as lookup
791: --
792: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
795: fnd_message.raise_error;
796: --
797: end if;
790: -- raise error as does not exist as lookup
791: --
792: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
795: fnd_message.raise_error;
796: --
797: end if;
798: --
791: --
792: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
795: fnd_message.raise_error;
796: --
797: end if;
798: --
799: if hr_api.not_exists_in_hr_lookups
802: p_effective_date => p_effective_date) then
803: --
804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('TYPE','YES_NO');
808: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
809: fnd_message.raise_error;
810: --
803: --
804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('TYPE','YES_NO');
808: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
809: fnd_message.raise_error;
810: --
811: end if;
804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('TYPE','YES_NO');
808: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
809: fnd_message.raise_error;
810: --
811: end if;
812: --
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('TYPE','YES_NO');
808: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
809: fnd_message.raise_error;
810: --
811: end if;
812: --
813: if hr_api.not_exists_in_hr_lookups
816: p_effective_date => p_effective_date) then
817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('TYPE','YES_NO');
822: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
823: fnd_message.raise_error;
824: --
817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('TYPE','YES_NO');
822: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
823: fnd_message.raise_error;
824: --
825: end if;
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('TYPE','YES_NO');
822: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('TYPE','YES_NO');
822: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
827: if hr_api.not_exists_in_hr_lookups
830: p_effective_date => p_effective_date) then
831: --
832: -- raise error as does not exist as lookup
833: --
834: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
835: fnd_message.set_token('TYPE','YES_NO');
836: fnd_message.set_token('FIELD','p_elig_grd_flag');
837: fnd_message.raise_error;
838: --
831: --
832: -- raise error as does not exist as lookup
833: --
834: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
835: fnd_message.set_token('TYPE','YES_NO');
836: fnd_message.set_token('FIELD','p_elig_grd_flag');
837: fnd_message.raise_error;
838: --
839: end if;
832: -- raise error as does not exist as lookup
833: --
834: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
835: fnd_message.set_token('TYPE','YES_NO');
836: fnd_message.set_token('FIELD','p_elig_grd_flag');
837: fnd_message.raise_error;
838: --
839: end if;
840: --
833: --
834: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
835: fnd_message.set_token('TYPE','YES_NO');
836: fnd_message.set_token('FIELD','p_elig_grd_flag');
837: fnd_message.raise_error;
838: --
839: end if;
840: --
841: if hr_api.not_exists_in_hr_lookups
844: p_effective_date => p_effective_date) then
845: --
846: -- raise error as does not exist as lookup
847: --
848: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
849: fnd_message.set_token('TYPE','YES_NO');
850: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
851: fnd_message.raise_error;
852: --
845: --
846: -- raise error as does not exist as lookup
847: --
848: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
849: fnd_message.set_token('TYPE','YES_NO');
850: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
851: fnd_message.raise_error;
852: --
853: end if;
846: -- raise error as does not exist as lookup
847: --
848: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
849: fnd_message.set_token('TYPE','YES_NO');
850: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
851: fnd_message.raise_error;
852: --
853: end if;
854: --
847: --
848: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
849: fnd_message.set_token('TYPE','YES_NO');
850: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
851: fnd_message.raise_error;
852: --
853: end if;
854: --
855: if hr_api.not_exists_in_hr_lookups
858: p_effective_date => p_effective_date) then
859: --
860: -- raise error as does not exist as lookup
861: --
862: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
863: fnd_message.set_token('TYPE','YES_NO');
864: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
865: fnd_message.raise_error;
866: --
859: --
860: -- raise error as does not exist as lookup
861: --
862: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
863: fnd_message.set_token('TYPE','YES_NO');
864: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
865: fnd_message.raise_error;
866: --
867: end if;
860: -- raise error as does not exist as lookup
861: --
862: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
863: fnd_message.set_token('TYPE','YES_NO');
864: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
865: fnd_message.raise_error;
866: --
867: end if;
868: --
861: --
862: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
863: fnd_message.set_token('TYPE','YES_NO');
864: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
865: fnd_message.raise_error;
866: --
867: end if;
868: --
869: if hr_api.not_exists_in_hr_lookups
872: p_effective_date => p_effective_date) then
873: --
874: -- raise error as does not exist as lookup
875: --
876: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
877: fnd_message.set_token('TYPE','YES_NO');
878: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
879: fnd_message.raise_error;
880: --
873: --
874: -- raise error as does not exist as lookup
875: --
876: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
877: fnd_message.set_token('TYPE','YES_NO');
878: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
879: fnd_message.raise_error;
880: --
881: end if;
874: -- raise error as does not exist as lookup
875: --
876: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
877: fnd_message.set_token('TYPE','YES_NO');
878: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
879: fnd_message.raise_error;
880: --
881: end if;
882: --
875: --
876: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
877: fnd_message.set_token('TYPE','YES_NO');
878: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
879: fnd_message.raise_error;
880: --
881: end if;
882: --
883: if hr_api.not_exists_in_hr_lookups
886: p_effective_date => p_effective_date) then
887: --
888: -- raise error as does not exist as lookup
889: --
890: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
891: fnd_message.set_token('TYPE','YES_NO');
892: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
893: fnd_message.raise_error;
894: --
887: --
888: -- raise error as does not exist as lookup
889: --
890: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
891: fnd_message.set_token('TYPE','YES_NO');
892: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
893: fnd_message.raise_error;
894: --
895: end if;
888: -- raise error as does not exist as lookup
889: --
890: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
891: fnd_message.set_token('TYPE','YES_NO');
892: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
893: fnd_message.raise_error;
894: --
895: end if;
896: --
889: --
890: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
891: fnd_message.set_token('TYPE','YES_NO');
892: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
893: fnd_message.raise_error;
894: --
895: end if;
896: --
897: if hr_api.not_exists_in_hr_lookups
900: p_effective_date => p_effective_date) then
901: --
902: -- raise error as does not exist as lookup
903: --
904: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
905: fnd_message.set_token('TYPE','YES_NO');
906: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
907: fnd_message.raise_error;
908: --
901: --
902: -- raise error as does not exist as lookup
903: --
904: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
905: fnd_message.set_token('TYPE','YES_NO');
906: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
907: fnd_message.raise_error;
908: --
909: end if;
902: -- raise error as does not exist as lookup
903: --
904: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
905: fnd_message.set_token('TYPE','YES_NO');
906: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
907: fnd_message.raise_error;
908: --
909: end if;
910: --
903: --
904: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
905: fnd_message.set_token('TYPE','YES_NO');
906: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
907: fnd_message.raise_error;
908: --
909: end if;
910: --
911: if hr_api.not_exists_in_hr_lookups
914: p_effective_date => p_effective_date) then
915: --
916: -- raise error as does not exist as lookup
917: --
918: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
919: fnd_message.set_token('TYPE','YES_NO');
920: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
921: fnd_message.raise_error;
922: --
915: --
916: -- raise error as does not exist as lookup
917: --
918: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
919: fnd_message.set_token('TYPE','YES_NO');
920: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
921: fnd_message.raise_error;
922: --
923: end if;
916: -- raise error as does not exist as lookup
917: --
918: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
919: fnd_message.set_token('TYPE','YES_NO');
920: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
921: fnd_message.raise_error;
922: --
923: end if;
924: --
917: --
918: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
919: fnd_message.set_token('TYPE','YES_NO');
920: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
921: fnd_message.raise_error;
922: --
923: end if;
924: --
925: if hr_api.not_exists_in_hr_lookups
928: p_effective_date => p_effective_date) then
929: --
930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('TYPE','YES_NO');
934: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
935: fnd_message.raise_error;
936: --
929: --
930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('TYPE','YES_NO');
934: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
935: fnd_message.raise_error;
936: --
937: end if;
930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('TYPE','YES_NO');
934: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
935: fnd_message.raise_error;
936: --
937: end if;
938: --
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('TYPE','YES_NO');
934: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
935: fnd_message.raise_error;
936: --
937: end if;
938: --
939: if hr_api.not_exists_in_hr_lookups
942: p_effective_date => p_effective_date) then
943: --
944: -- raise error as does not exist as lookup
945: --
946: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
947: fnd_message.set_token('TYPE','YES_NO');
948: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
949: fnd_message.raise_error;
950: --
943: --
944: -- raise error as does not exist as lookup
945: --
946: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
947: fnd_message.set_token('TYPE','YES_NO');
948: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
949: fnd_message.raise_error;
950: --
951: end if;
944: -- raise error as does not exist as lookup
945: --
946: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
947: fnd_message.set_token('TYPE','YES_NO');
948: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
949: fnd_message.raise_error;
950: --
951: end if;
952: --
945: --
946: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
947: fnd_message.set_token('TYPE','YES_NO');
948: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
949: fnd_message.raise_error;
950: --
951: end if;
952: --
953: if hr_api.not_exists_in_hr_lookups
956: p_effective_date => p_effective_date) then
957: --
958: -- raise error as does not exist as lookup
959: --
960: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
961: fnd_message.set_token('TYPE','YES_NO');
962: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
963: fnd_message.raise_error;
964: --
957: --
958: -- raise error as does not exist as lookup
959: --
960: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
961: fnd_message.set_token('TYPE','YES_NO');
962: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
963: fnd_message.raise_error;
964: --
965: end if;
958: -- raise error as does not exist as lookup
959: --
960: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
961: fnd_message.set_token('TYPE','YES_NO');
962: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
963: fnd_message.raise_error;
964: --
965: end if;
966: --
959: --
960: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
961: fnd_message.set_token('TYPE','YES_NO');
962: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
963: fnd_message.raise_error;
964: --
965: end if;
966: --
967: if hr_api.not_exists_in_hr_lookups
970: p_effective_date => p_effective_date) then
971: --
972: -- raise error as does not exist as lookup
973: --
974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
975: fnd_message.set_token('TYPE','YES_NO');
976: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
977: fnd_message.raise_error;
978: --
971: --
972: -- raise error as does not exist as lookup
973: --
974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
975: fnd_message.set_token('TYPE','YES_NO');
976: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
977: fnd_message.raise_error;
978: --
979: end if;
972: -- raise error as does not exist as lookup
973: --
974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
975: fnd_message.set_token('TYPE','YES_NO');
976: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
977: fnd_message.raise_error;
978: --
979: end if;
980: --
973: --
974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
975: fnd_message.set_token('TYPE','YES_NO');
976: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
977: fnd_message.raise_error;
978: --
979: end if;
980: --
981: if hr_api.not_exists_in_hr_lookups
984: p_effective_date => p_effective_date) then
985: --
986: -- raise error as does not exist as lookup
987: --
988: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
989: fnd_message.set_token('TYPE','YES_NO');
990: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
991: fnd_message.raise_error;
992: --
985: --
986: -- raise error as does not exist as lookup
987: --
988: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
989: fnd_message.set_token('TYPE','YES_NO');
990: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
991: fnd_message.raise_error;
992: --
993: end if;
986: -- raise error as does not exist as lookup
987: --
988: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
989: fnd_message.set_token('TYPE','YES_NO');
990: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
991: fnd_message.raise_error;
992: --
993: end if;
994: --
987: --
988: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
989: fnd_message.set_token('TYPE','YES_NO');
990: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
991: fnd_message.raise_error;
992: --
993: end if;
994: --
995: if hr_api.not_exists_in_hr_lookups
998: p_effective_date => p_effective_date) then
999: --
1000: -- raise error as does not exist as lookup
1001: --
1002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1003: fnd_message.set_token('TYPE','YES_NO');
1004: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1005: fnd_message.raise_error;
1006: --
999: --
1000: -- raise error as does not exist as lookup
1001: --
1002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1003: fnd_message.set_token('TYPE','YES_NO');
1004: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1000: -- raise error as does not exist as lookup
1001: --
1002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1003: fnd_message.set_token('TYPE','YES_NO');
1004: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --
1001: --
1002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1003: fnd_message.set_token('TYPE','YES_NO');
1004: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --
1009: if hr_api.not_exists_in_hr_lookups
1012: p_effective_date => p_effective_date) then
1013: --
1014: -- raise error as does not exist as lookup
1015: --
1016: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1017: fnd_message.set_token('TYPE','YES_NO');
1018: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1019: fnd_message.raise_error;
1020: --
1013: --
1014: -- raise error as does not exist as lookup
1015: --
1016: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1017: fnd_message.set_token('TYPE','YES_NO');
1018: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1019: fnd_message.raise_error;
1020: --
1021: end if;
1014: -- raise error as does not exist as lookup
1015: --
1016: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1017: fnd_message.set_token('TYPE','YES_NO');
1018: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1019: fnd_message.raise_error;
1020: --
1021: end if;
1022: --
1015: --
1016: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1017: fnd_message.set_token('TYPE','YES_NO');
1018: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1019: fnd_message.raise_error;
1020: --
1021: end if;
1022: --
1023: if hr_api.not_exists_in_hr_lookups
1026: p_effective_date => p_effective_date) then
1027: --
1028: -- raise error as does not exist as lookup
1029: --
1030: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1031: fnd_message.set_token('TYPE','YES_NO');
1032: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1033: fnd_message.raise_error;
1034: --
1027: --
1028: -- raise error as does not exist as lookup
1029: --
1030: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1031: fnd_message.set_token('TYPE','YES_NO');
1032: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1033: fnd_message.raise_error;
1034: --
1035: end if;
1028: -- raise error as does not exist as lookup
1029: --
1030: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1031: fnd_message.set_token('TYPE','YES_NO');
1032: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1033: fnd_message.raise_error;
1034: --
1035: end if;
1036: --
1029: --
1030: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1031: fnd_message.set_token('TYPE','YES_NO');
1032: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1033: fnd_message.raise_error;
1034: --
1035: end if;
1036: --
1037: if hr_api.not_exists_in_hr_lookups
1040: p_effective_date => p_effective_date) then
1041: --
1042: -- raise error as does not exist as lookup
1043: --
1044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1045: fnd_message.set_token('TYPE','YES_NO');
1046: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1047: fnd_message.raise_error;
1048: --
1041: --
1042: -- raise error as does not exist as lookup
1043: --
1044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1045: fnd_message.set_token('TYPE','YES_NO');
1046: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1047: fnd_message.raise_error;
1048: --
1049: end if;
1042: -- raise error as does not exist as lookup
1043: --
1044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1045: fnd_message.set_token('TYPE','YES_NO');
1046: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1047: fnd_message.raise_error;
1048: --
1049: end if;
1050: --
1043: --
1044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1045: fnd_message.set_token('TYPE','YES_NO');
1046: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1047: fnd_message.raise_error;
1048: --
1049: end if;
1050: --
1051: if hr_api.not_exists_in_hr_lookups
1054: p_effective_date => p_effective_date) then
1055: --
1056: -- raise error as does not exist as lookup
1057: --
1058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1059: fnd_message.set_token('TYPE','YES_NO');
1060: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1061: fnd_message.raise_error;
1062: --
1055: --
1056: -- raise error as does not exist as lookup
1057: --
1058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1059: fnd_message.set_token('TYPE','YES_NO');
1060: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1056: -- raise error as does not exist as lookup
1057: --
1058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1059: fnd_message.set_token('TYPE','YES_NO');
1060: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --
1057: --
1058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1059: fnd_message.set_token('TYPE','YES_NO');
1060: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --
1065: if hr_api.not_exists_in_hr_lookups
1068: p_effective_date => p_effective_date) then
1069: --
1070: -- raise error as does not exist as lookup
1071: --
1072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1073: fnd_message.set_token('TYPE','YES_NO');
1074: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1075: fnd_message.raise_error;
1076: --
1069: --
1070: -- raise error as does not exist as lookup
1071: --
1072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1073: fnd_message.set_token('TYPE','YES_NO');
1074: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1070: -- raise error as does not exist as lookup
1071: --
1072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1073: fnd_message.set_token('TYPE','YES_NO');
1074: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1071: --
1072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1073: fnd_message.set_token('TYPE','YES_NO');
1074: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1079: if hr_api.not_exists_in_hr_lookups
1082: p_effective_date => p_effective_date) then
1083: --
1084: -- raise error as does not exist as lookup
1085: --
1086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1087: fnd_message.set_token('TYPE','YES_NO');
1088: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1089: fnd_message.raise_error;
1090: --
1083: --
1084: -- raise error as does not exist as lookup
1085: --
1086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1087: fnd_message.set_token('TYPE','YES_NO');
1088: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1089: fnd_message.raise_error;
1090: --
1091: end if;
1084: -- raise error as does not exist as lookup
1085: --
1086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1087: fnd_message.set_token('TYPE','YES_NO');
1088: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1089: fnd_message.raise_error;
1090: --
1091: end if;
1092: --
1085: --
1086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1087: fnd_message.set_token('TYPE','YES_NO');
1088: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1089: fnd_message.raise_error;
1090: --
1091: end if;
1092: --
1093: if hr_api.not_exists_in_hr_lookups
1096: p_effective_date => p_effective_date) then
1097: --
1098: -- raise error as does not exist as lookup
1099: --
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('TYPE','YES_NO');
1102: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1103: fnd_message.raise_error;
1104: --
1097: --
1098: -- raise error as does not exist as lookup
1099: --
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('TYPE','YES_NO');
1102: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1098: -- raise error as does not exist as lookup
1099: --
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('TYPE','YES_NO');
1102: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --
1099: --
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('TYPE','YES_NO');
1102: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --
1107: if hr_api.not_exists_in_hr_lookups
1110: p_effective_date => p_effective_date) then
1111: --
1112: -- raise error as does not exist as lookup
1113: --
1114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1115: fnd_message.set_token('TYPE','YES_NO');
1116: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1117: fnd_message.raise_error;
1118: --
1111: --
1112: -- raise error as does not exist as lookup
1113: --
1114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1115: fnd_message.set_token('TYPE','YES_NO');
1116: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1117: fnd_message.raise_error;
1118: --
1119: end if;
1112: -- raise error as does not exist as lookup
1113: --
1114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1115: fnd_message.set_token('TYPE','YES_NO');
1116: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1117: fnd_message.raise_error;
1118: --
1119: end if;
1120: --
1113: --
1114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1115: fnd_message.set_token('TYPE','YES_NO');
1116: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1117: fnd_message.raise_error;
1118: --
1119: end if;
1120: --
1121: if hr_api.not_exists_in_hr_lookups
1124: p_effective_date => p_effective_date) then
1125: --
1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('TYPE','YES_NO');
1130: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1131: fnd_message.raise_error;
1132: --
1125: --
1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('TYPE','YES_NO');
1130: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1131: fnd_message.raise_error;
1132: --
1133: end if;
1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('TYPE','YES_NO');
1130: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1131: fnd_message.raise_error;
1132: --
1133: end if;
1134: --
1127: --
1128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('TYPE','YES_NO');
1130: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1131: fnd_message.raise_error;
1132: --
1133: end if;
1134: --
1135: if hr_api.not_exists_in_hr_lookups
1138: p_effective_date => p_effective_date) then
1139: --
1140: -- raise error as does not exist as lookup
1141: --
1142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1143: fnd_message.set_token('TYPE','YES_NO');
1144: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1145: fnd_message.raise_error;
1146: --
1139: --
1140: -- raise error as does not exist as lookup
1141: --
1142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1143: fnd_message.set_token('TYPE','YES_NO');
1144: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1145: fnd_message.raise_error;
1146: --
1147: end if;
1140: -- raise error as does not exist as lookup
1141: --
1142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1143: fnd_message.set_token('TYPE','YES_NO');
1144: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1145: fnd_message.raise_error;
1146: --
1147: end if;
1148: --
1141: --
1142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1143: fnd_message.set_token('TYPE','YES_NO');
1144: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1145: fnd_message.raise_error;
1146: --
1147: end if;
1148: --
1149: if hr_api.not_exists_in_hr_lookups
1152: p_effective_date => p_effective_date) then
1153: --
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('TYPE','YES_NO');
1158: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1159: fnd_message.raise_error;
1160: --
1153: --
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('TYPE','YES_NO');
1158: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('TYPE','YES_NO');
1158: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('TYPE','YES_NO');
1158: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --
1163: if hr_api.not_exists_in_hr_lookups
1166: p_effective_date => p_effective_date) then
1167: --
1168: -- raise error as does not exist as lookup
1169: --
1170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1171: fnd_message.set_token('TYPE','YES_NO');
1172: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1173: fnd_message.raise_error;
1174: --
1167: --
1168: -- raise error as does not exist as lookup
1169: --
1170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1171: fnd_message.set_token('TYPE','YES_NO');
1172: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1173: fnd_message.raise_error;
1174: --
1175: end if;
1168: -- raise error as does not exist as lookup
1169: --
1170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1171: fnd_message.set_token('TYPE','YES_NO');
1172: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1173: fnd_message.raise_error;
1174: --
1175: end if;
1176: --
1169: --
1170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1171: fnd_message.set_token('TYPE','YES_NO');
1172: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1173: fnd_message.raise_error;
1174: --
1175: end if;
1176: --
1177: if hr_api.not_exists_in_hr_lookups
1180: p_effective_date => p_effective_date) then
1181: --
1182: -- raise error as does not exist as lookup
1183: --
1184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1185: fnd_message.set_token('TYPE','YES_NO');
1186: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1187: fnd_message.raise_error;
1188: --
1181: --
1182: -- raise error as does not exist as lookup
1183: --
1184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1185: fnd_message.set_token('TYPE','YES_NO');
1186: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1187: fnd_message.raise_error;
1188: --
1189: end if;
1182: -- raise error as does not exist as lookup
1183: --
1184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1185: fnd_message.set_token('TYPE','YES_NO');
1186: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1187: fnd_message.raise_error;
1188: --
1189: end if;
1190: --
1183: --
1184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1185: fnd_message.set_token('TYPE','YES_NO');
1186: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1187: fnd_message.raise_error;
1188: --
1189: end if;
1190: --
1191: if hr_api.not_exists_in_hr_lookups
1194: p_effective_date => p_effective_date) then
1195: --
1196: -- raise error as does not exist as lookup
1197: --
1198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1199: fnd_message.set_token('TYPE','YES_NO');
1200: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1201: fnd_message.raise_error;
1202: --
1195: --
1196: -- raise error as does not exist as lookup
1197: --
1198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1199: fnd_message.set_token('TYPE','YES_NO');
1200: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1201: fnd_message.raise_error;
1202: --
1203: end if;
1196: -- raise error as does not exist as lookup
1197: --
1198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1199: fnd_message.set_token('TYPE','YES_NO');
1200: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1201: fnd_message.raise_error;
1202: --
1203: end if;
1204: --
1197: --
1198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1199: fnd_message.set_token('TYPE','YES_NO');
1200: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1201: fnd_message.raise_error;
1202: --
1203: end if;
1204: --
1205: if hr_api.not_exists_in_hr_lookups
1208: p_effective_date => p_effective_date) then
1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1213: fnd_message.set_token('TYPE','YES_NO');
1214: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1215: fnd_message.raise_error;
1216: --
1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1213: fnd_message.set_token('TYPE','YES_NO');
1214: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1215: fnd_message.raise_error;
1216: --
1217: end if;
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1213: fnd_message.set_token('TYPE','YES_NO');
1214: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1215: fnd_message.raise_error;
1216: --
1217: end if;
1218: --
1211: --
1212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1213: fnd_message.set_token('TYPE','YES_NO');
1214: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1215: fnd_message.raise_error;
1216: --
1217: end if;
1218: --
1219: if hr_api.not_exists_in_hr_lookups
1222: p_effective_date => p_effective_date) then
1223: --
1224: -- raise error as does not exist as lookup
1225: --
1226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1227: fnd_message.set_token('TYPE','YES_NO');
1228: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1229: fnd_message.raise_error;
1230: --
1223: --
1224: -- raise error as does not exist as lookup
1225: --
1226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1227: fnd_message.set_token('TYPE','YES_NO');
1228: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1229: fnd_message.raise_error;
1230: --
1231: end if;
1224: -- raise error as does not exist as lookup
1225: --
1226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1227: fnd_message.set_token('TYPE','YES_NO');
1228: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1229: fnd_message.raise_error;
1230: --
1231: end if;
1232: --
1225: --
1226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1227: fnd_message.set_token('TYPE','YES_NO');
1228: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1229: fnd_message.raise_error;
1230: --
1231: end if;
1232: --
1233: if hr_api.not_exists_in_hr_lookups
1236: p_effective_date => p_effective_date) then
1237: --
1238: -- raise error as does not exist as lookup
1239: --
1240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1241: fnd_message.set_token('TYPE','YES_NO');
1242: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1243: fnd_message.raise_error;
1244: --
1237: --
1238: -- raise error as does not exist as lookup
1239: --
1240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1241: fnd_message.set_token('TYPE','YES_NO');
1242: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1243: fnd_message.raise_error;
1244: --
1245: end if;
1238: -- raise error as does not exist as lookup
1239: --
1240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1241: fnd_message.set_token('TYPE','YES_NO');
1242: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1243: fnd_message.raise_error;
1244: --
1245: end if;
1246: --
1239: --
1240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1241: fnd_message.set_token('TYPE','YES_NO');
1242: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1243: fnd_message.raise_error;
1244: --
1245: end if;
1246: --
1247: if hr_api.not_exists_in_hr_lookups
1250: p_effective_date => p_effective_date) then
1251: --
1252: -- raise error as does not exist as lookup
1253: --
1254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1255: fnd_message.set_token('TYPE','YES_NO');
1256: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1257: fnd_message.raise_error;
1258: --
1251: --
1252: -- raise error as does not exist as lookup
1253: --
1254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1255: fnd_message.set_token('TYPE','YES_NO');
1256: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1257: fnd_message.raise_error;
1258: --
1259: end if;
1252: -- raise error as does not exist as lookup
1253: --
1254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1255: fnd_message.set_token('TYPE','YES_NO');
1256: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1257: fnd_message.raise_error;
1258: --
1259: end if;
1260: --
1253: --
1254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1255: fnd_message.set_token('TYPE','YES_NO');
1256: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1257: fnd_message.raise_error;
1258: --
1259: end if;
1260: --
1261: if hr_api.not_exists_in_hr_lookups
1264: p_effective_date => p_effective_date) then
1265: --
1266: -- raise error as does not exist as lookup
1267: --
1268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1269: fnd_message.set_token('TYPE','YES_NO');
1270: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1271: fnd_message.raise_error;
1272: --
1265: --
1266: -- raise error as does not exist as lookup
1267: --
1268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1269: fnd_message.set_token('TYPE','YES_NO');
1270: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1271: fnd_message.raise_error;
1272: --
1273: end if;
1266: -- raise error as does not exist as lookup
1267: --
1268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1269: fnd_message.set_token('TYPE','YES_NO');
1270: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1271: fnd_message.raise_error;
1272: --
1273: end if;
1274: --
1267: --
1268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1269: fnd_message.set_token('TYPE','YES_NO');
1270: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1271: fnd_message.raise_error;
1272: --
1273: end if;
1274: --
1275: if hr_api.not_exists_in_hr_lookups
1278: p_effective_date => p_effective_date) then
1279: --
1280: -- raise error as does not exist as lookup
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('TYPE','YES_NO');
1284: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1285: fnd_message.raise_error;
1286: --
1279: --
1280: -- raise error as does not exist as lookup
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('TYPE','YES_NO');
1284: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1285: fnd_message.raise_error;
1286: --
1287: end if;
1280: -- raise error as does not exist as lookup
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('TYPE','YES_NO');
1284: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1285: fnd_message.raise_error;
1286: --
1287: end if;
1288: --
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('TYPE','YES_NO');
1284: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1285: fnd_message.raise_error;
1286: --
1287: end if;
1288: --
1289: if hr_api.not_exists_in_hr_lookups
1292: p_effective_date => p_effective_date) then
1293: --
1294: -- raise error as does not exist as lookup
1295: --
1296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1297: fnd_message.set_token('TYPE','YES_NO');
1298: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1299: fnd_message.raise_error;
1300: --
1293: --
1294: -- raise error as does not exist as lookup
1295: --
1296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1297: fnd_message.set_token('TYPE','YES_NO');
1298: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1299: fnd_message.raise_error;
1300: --
1301: end if;
1294: -- raise error as does not exist as lookup
1295: --
1296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1297: fnd_message.set_token('TYPE','YES_NO');
1298: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1299: fnd_message.raise_error;
1300: --
1301: end if;
1302: --
1295: --
1296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1297: fnd_message.set_token('TYPE','YES_NO');
1298: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1299: fnd_message.raise_error;
1300: --
1301: end if;
1302: --
1303: --
1307: p_effective_date => p_effective_date) then
1308: --
1309: -- raise error as does not exist as lookup
1310: --
1311: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1312: fnd_message.set_token('TYPE','YES_NO');
1313: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1314: fnd_message.raise_error;
1315: --
1308: --
1309: -- raise error as does not exist as lookup
1310: --
1311: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1312: fnd_message.set_token('TYPE','YES_NO');
1313: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1309: -- raise error as does not exist as lookup
1310: --
1311: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1312: fnd_message.set_token('TYPE','YES_NO');
1313: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: hr_utility.set_location('Leaving:'||l_proc,10);
1310: --
1311: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1312: fnd_message.set_token('TYPE','YES_NO');
1313: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: hr_utility.set_location('Leaving:'||l_proc,10);
1318: --
1392: --
1393: -- A referential integrity check was violated therefore
1394: -- we must error
1395: --
1396: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1397: fnd_message.set_token('TABLE_NAME', l_table_name);
1398: fnd_message.raise_error;
1399: When Others Then
1400: --
1393: -- A referential integrity check was violated therefore
1394: -- we must error
1395: --
1396: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1397: fnd_message.set_token('TABLE_NAME', l_table_name);
1398: fnd_message.raise_error;
1399: When Others Then
1400: --
1401: -- An unhandled or unexpected error has occurred which
1394: -- we must error
1395: --
1396: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1397: fnd_message.set_token('TABLE_NAME', l_table_name);
1398: fnd_message.raise_error;
1399: When Others Then
1400: --
1401: -- An unhandled or unexpected error has occurred which
1402: -- we must report
1400: --
1401: -- An unhandled or unexpected error has occurred which
1402: -- we must report
1403: --
1404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1405: fnd_message.set_token('PROCEDURE', l_proc);
1406: fnd_message.set_token('STEP','15');
1407: fnd_message.raise_error;
1408: End dt_update_validate;
1401: -- An unhandled or unexpected error has occurred which
1402: -- we must report
1403: --
1404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1405: fnd_message.set_token('PROCEDURE', l_proc);
1406: fnd_message.set_token('STEP','15');
1407: fnd_message.raise_error;
1408: End dt_update_validate;
1409: --
1402: -- we must report
1403: --
1404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1405: fnd_message.set_token('PROCEDURE', l_proc);
1406: fnd_message.set_token('STEP','15');
1407: fnd_message.raise_error;
1408: End dt_update_validate;
1409: --
1410: -- ----------------------------------------------------------------------------
1403: --
1404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1405: fnd_message.set_token('PROCEDURE', l_proc);
1406: fnd_message.set_token('STEP','15');
1407: fnd_message.raise_error;
1408: End dt_update_validate;
1409: --
1410: -- ----------------------------------------------------------------------------
1411: -- |--------------------------< dt_delete_validate >--------------------------|
1515: --
1516: -- An unhandled or unexpected error has occurred which
1517: -- we must report
1518: --
1519: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1520: fnd_message.set_token('PROCEDURE', l_proc);
1521: fnd_message.set_token('STEP','15');
1522: fnd_message.raise_error;
1523: End dt_delete_validate;
1516: -- An unhandled or unexpected error has occurred which
1517: -- we must report
1518: --
1519: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1520: fnd_message.set_token('PROCEDURE', l_proc);
1521: fnd_message.set_token('STEP','15');
1522: fnd_message.raise_error;
1523: End dt_delete_validate;
1524: --
1517: -- we must report
1518: --
1519: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1520: fnd_message.set_token('PROCEDURE', l_proc);
1521: fnd_message.set_token('STEP','15');
1522: fnd_message.raise_error;
1523: End dt_delete_validate;
1524: --
1525: -- ----------------------------------------------------------------------------
1518: --
1519: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1520: fnd_message.set_token('PROCEDURE', l_proc);
1521: fnd_message.set_token('STEP','15');
1522: fnd_message.raise_error;
1523: End dt_delete_validate;
1524: --
1525: -- ----------------------------------------------------------------------------
1526: -- |---------------------------< insert_validate >----------------------------|
1818: close csr_leg_code;
1819: --
1820: -- The primary key is invalid therefore we must error
1821: --
1822: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1823: fnd_message.raise_error;
1824: --
1825: end if;
1826: --
1819: --
1820: -- The primary key is invalid therefore we must error
1821: --
1822: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1823: fnd_message.raise_error;
1824: --
1825: end if;
1826: --
1827: close csr_leg_code;