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: --
404: WHERE lookup_type = 'BEN_BNFT_CAGR_PRTN'
405: AND lookup_code = 'LRNR'
406: AND language = userenv ('lang');
407: else
408: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
409: end if;
410: close c_lrnr_group;
411: --End Enh: 13478736
412: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
408: l_return := fnd_message.get_string('BEN','BEN_94882_CSC_EXISTS');
409: end if;
410: close c_lrnr_group;
411: --End Enh: 13478736
412: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
413: fnd_message.set_token('ENTITY_NAME',l_return);
414: fnd_message.raise_error;
415: end if;
416: close c_eoep_exists;
409: end if;
410: close c_lrnr_group;
411: --End Enh: 13478736
412: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
413: fnd_message.set_token('ENTITY_NAME',l_return);
414: fnd_message.raise_error;
415: end if;
416: close c_eoep_exists;
417: --
410: close c_lrnr_group;
411: --End Enh: 13478736
412: fnd_message.set_name('BEN','BEN_94630_PCE_EXISTS');
413: fnd_message.set_token('ENTITY_NAME',l_return);
414: fnd_message.raise_error;
415: end if;
416: close c_eoep_exists;
417: --
418: hr_utility.set_location('Leaving:'||l_proc, 5);
589: p_effective_date => p_effective_date) then
590: --
591: -- raise error as does not exist as lookup
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('TYPE','YES_NO');
595: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
596: fnd_message.raise_error;
597: --
590: --
591: -- raise error as does not exist as lookup
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('TYPE','YES_NO');
595: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
596: fnd_message.raise_error;
597: --
598: end if;
591: -- raise error as does not exist as lookup
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('TYPE','YES_NO');
595: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
596: fnd_message.raise_error;
597: --
598: end if;
599: --
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('TYPE','YES_NO');
595: fnd_message.set_token('FIELD','p_elig_enrld_plip_flag');
596: fnd_message.raise_error;
597: --
598: end if;
599: --
600: if hr_api.not_exists_in_hr_lookups
603: p_effective_date => p_effective_date) then
604: --
605: -- raise error as does not exist as lookup
606: --
607: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
608: fnd_message.set_token('TYPE','YES_NO');
609: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
610: fnd_message.raise_error;
611: --
604: --
605: -- raise error as does not exist as lookup
606: --
607: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
608: fnd_message.set_token('TYPE','YES_NO');
609: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
610: fnd_message.raise_error;
611: --
612: end if;
605: -- raise error as does not exist as lookup
606: --
607: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
608: fnd_message.set_token('TYPE','YES_NO');
609: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
610: fnd_message.raise_error;
611: --
612: end if;
613: --
606: --
607: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
608: fnd_message.set_token('TYPE','YES_NO');
609: fnd_message.set_token('FIELD','p_elig_cbr_quald_bnf_flag');
610: fnd_message.raise_error;
611: --
612: end if;
613: --
614: if hr_api.not_exists_in_hr_lookups
617: p_effective_date => p_effective_date) then
618: --
619: -- raise error as does not exist as lookup
620: --
621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
622: fnd_message.set_token('TYPE','YES_NO');
623: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
624: fnd_message.raise_error;
625: --
618: --
619: -- raise error as does not exist as lookup
620: --
621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
622: fnd_message.set_token('TYPE','YES_NO');
623: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
624: fnd_message.raise_error;
625: --
626: end if;
619: -- raise error as does not exist as lookup
620: --
621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
622: fnd_message.set_token('TYPE','YES_NO');
623: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
624: fnd_message.raise_error;
625: --
626: end if;
627: --
620: --
621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
622: fnd_message.set_token('TYPE','YES_NO');
623: fnd_message.set_token('FIELD','p_elig_enrld_ptip_flag');
624: fnd_message.raise_error;
625: --
626: end if;
627: --
628: if hr_api.not_exists_in_hr_lookups
631: p_effective_date => p_effective_date) then
632: --
633: -- raise error as does not exist as lookup
634: --
635: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
636: fnd_message.set_token('TYPE','YES_NO');
637: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
638: fnd_message.raise_error;
639: --
632: --
633: -- raise error as does not exist as lookup
634: --
635: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
636: fnd_message.set_token('TYPE','YES_NO');
637: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
638: fnd_message.raise_error;
639: --
640: end if;
633: -- raise error as does not exist as lookup
634: --
635: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
636: fnd_message.set_token('TYPE','YES_NO');
637: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
638: fnd_message.raise_error;
639: --
640: end if;
641: --
634: --
635: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
636: fnd_message.set_token('TYPE','YES_NO');
637: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_plip_flag');
638: fnd_message.raise_error;
639: --
640: end if;
641: --
642: if hr_api.not_exists_in_hr_lookups
645: p_effective_date => p_effective_date) then
646: --
647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('TYPE','YES_NO');
651: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
652: fnd_message.raise_error;
653: --
646: --
647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('TYPE','YES_NO');
651: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
652: fnd_message.raise_error;
653: --
654: end if;
647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('TYPE','YES_NO');
651: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
652: fnd_message.raise_error;
653: --
654: end if;
655: --
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('TYPE','YES_NO');
651: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_ptip_flag');
652: fnd_message.raise_error;
653: --
654: end if;
655: --
656: if hr_api.not_exists_in_hr_lookups
659: p_effective_date => p_effective_date) then
660: --
661: -- raise error as does not exist as lookup
662: --
663: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
664: fnd_message.set_token('TYPE','YES_NO');
665: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
666: fnd_message.raise_error;
667: --
660: --
661: -- raise error as does not exist as lookup
662: --
663: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
664: fnd_message.set_token('TYPE','YES_NO');
665: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
666: fnd_message.raise_error;
667: --
668: end if;
661: -- raise error as does not exist as lookup
662: --
663: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
664: fnd_message.set_token('TYPE','YES_NO');
665: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
666: fnd_message.raise_error;
667: --
668: end if;
669: --
662: --
663: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
664: fnd_message.set_token('TYPE','YES_NO');
665: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pgm_flag');
666: fnd_message.raise_error;
667: --
668: end if;
669: --
670: if hr_api.not_exists_in_hr_lookups
673: p_effective_date => p_effective_date) then
674: --
675: -- raise error as does not exist as lookup
676: --
677: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
678: fnd_message.set_token('TYPE','YES_NO');
679: fnd_message.set_token('FIELD','p_elig_job_flag');
680: fnd_message.raise_error;
681: --
674: --
675: -- raise error as does not exist as lookup
676: --
677: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
678: fnd_message.set_token('TYPE','YES_NO');
679: fnd_message.set_token('FIELD','p_elig_job_flag');
680: fnd_message.raise_error;
681: --
682: end if;
675: -- raise error as does not exist as lookup
676: --
677: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
678: fnd_message.set_token('TYPE','YES_NO');
679: fnd_message.set_token('FIELD','p_elig_job_flag');
680: fnd_message.raise_error;
681: --
682: end if;
683: --
676: --
677: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
678: fnd_message.set_token('TYPE','YES_NO');
679: fnd_message.set_token('FIELD','p_elig_job_flag');
680: fnd_message.raise_error;
681: --
682: end if;
683: --
684: if hr_api.not_exists_in_hr_lookups
687: p_effective_date => p_effective_date) then
688: --
689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('TYPE','YES_NO');
693: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
694: fnd_message.raise_error;
695: --
688: --
689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('TYPE','YES_NO');
693: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
694: fnd_message.raise_error;
695: --
696: end if;
689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('TYPE','YES_NO');
693: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
694: fnd_message.raise_error;
695: --
696: end if;
697: --
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('TYPE','YES_NO');
693: fnd_message.set_token('FIELD','p_elig_hrly_slrd_flag');
694: fnd_message.raise_error;
695: --
696: end if;
697: --
698: if hr_api.not_exists_in_hr_lookups
701: p_effective_date => p_effective_date) then
702: --
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('TYPE','YES_NO');
707: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
708: fnd_message.raise_error;
709: --
702: --
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('TYPE','YES_NO');
707: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
708: fnd_message.raise_error;
709: --
710: end if;
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('TYPE','YES_NO');
707: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
708: fnd_message.raise_error;
709: --
710: end if;
711: --
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('TYPE','YES_NO');
707: fnd_message.set_token('FIELD','p_elig_pstl_cd_flag');
708: fnd_message.raise_error;
709: --
710: end if;
711: --
712: if hr_api.not_exists_in_hr_lookups
715: p_effective_date => p_effective_date) then
716: --
717: -- raise error as does not exist as lookup
718: --
719: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
720: fnd_message.set_token('TYPE','YES_NO');
721: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
722: fnd_message.raise_error;
723: --
716: --
717: -- raise error as does not exist as lookup
718: --
719: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
720: fnd_message.set_token('TYPE','YES_NO');
721: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
722: fnd_message.raise_error;
723: --
724: end if;
717: -- raise error as does not exist as lookup
718: --
719: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
720: fnd_message.set_token('TYPE','YES_NO');
721: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
722: fnd_message.raise_error;
723: --
724: end if;
725: --
718: --
719: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
720: fnd_message.set_token('TYPE','YES_NO');
721: fnd_message.set_token('FIELD','p_elig_lbr_mmbr_flag');
722: fnd_message.raise_error;
723: --
724: end if;
725: --
726: if hr_api.not_exists_in_hr_lookups
729: p_effective_date => p_effective_date) then
730: --
731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('TYPE','YES_NO');
735: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
736: fnd_message.raise_error;
737: --
730: --
731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('TYPE','YES_NO');
735: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
736: fnd_message.raise_error;
737: --
738: end if;
731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('TYPE','YES_NO');
735: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
736: fnd_message.raise_error;
737: --
738: end if;
739: --
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('TYPE','YES_NO');
735: fnd_message.set_token('FIELD','p_elig_lgl_enty_flag');
736: fnd_message.raise_error;
737: --
738: end if;
739: --
740: if hr_api.not_exists_in_hr_lookups
743: p_effective_date => p_effective_date) then
744: --
745: -- raise error as does not exist as lookup
746: --
747: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
748: fnd_message.set_token('TYPE','YES_NO');
749: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
750: fnd_message.raise_error;
751: --
744: --
745: -- raise error as does not exist as lookup
746: --
747: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
748: fnd_message.set_token('TYPE','YES_NO');
749: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
750: fnd_message.raise_error;
751: --
752: end if;
745: -- raise error as does not exist as lookup
746: --
747: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
748: fnd_message.set_token('TYPE','YES_NO');
749: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
746: --
747: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
748: fnd_message.set_token('TYPE','YES_NO');
749: fnd_message.set_token('FIELD','p_elig_benfts_grp_flag');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
754: if hr_api.not_exists_in_hr_lookups
757: p_effective_date => p_effective_date) then
758: --
759: -- raise error as does not exist as lookup
760: --
761: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
762: fnd_message.set_token('TYPE','YES_NO');
763: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
764: fnd_message.raise_error;
765: --
758: --
759: -- raise error as does not exist as lookup
760: --
761: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
762: fnd_message.set_token('TYPE','YES_NO');
763: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
764: fnd_message.raise_error;
765: --
766: end if;
759: -- raise error as does not exist as lookup
760: --
761: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
762: fnd_message.set_token('TYPE','YES_NO');
763: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
764: fnd_message.raise_error;
765: --
766: end if;
767: --
760: --
761: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
762: fnd_message.set_token('TYPE','YES_NO');
763: fnd_message.set_token('FIELD','p_elig_wk_loc_flag');
764: fnd_message.raise_error;
765: --
766: end if;
767: --
768: if hr_api.not_exists_in_hr_lookups
771: p_effective_date => p_effective_date) then
772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('TYPE','YES_NO');
777: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
778: fnd_message.raise_error;
779: --
772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('TYPE','YES_NO');
777: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
778: fnd_message.raise_error;
779: --
780: end if;
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('TYPE','YES_NO');
777: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('TYPE','YES_NO');
777: fnd_message.set_token('FIELD','p_elig_brgng_unit_flag');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
782: if hr_api.not_exists_in_hr_lookups
785: p_effective_date => p_effective_date) then
786: --
787: -- raise error as does not exist as lookup
788: --
789: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
790: fnd_message.set_token('TYPE','YES_NO');
791: fnd_message.set_token('FIELD','p_elig_age_flag');
792: fnd_message.raise_error;
793: --
786: --
787: -- raise error as does not exist as lookup
788: --
789: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
790: fnd_message.set_token('TYPE','YES_NO');
791: fnd_message.set_token('FIELD','p_elig_age_flag');
792: fnd_message.raise_error;
793: --
794: end if;
787: -- raise error as does not exist as lookup
788: --
789: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
790: fnd_message.set_token('TYPE','YES_NO');
791: fnd_message.set_token('FIELD','p_elig_age_flag');
792: fnd_message.raise_error;
793: --
794: end if;
795: --
788: --
789: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
790: fnd_message.set_token('TYPE','YES_NO');
791: fnd_message.set_token('FIELD','p_elig_age_flag');
792: fnd_message.raise_error;
793: --
794: end if;
795: --
796: if hr_api.not_exists_in_hr_lookups
799: p_effective_date => p_effective_date) then
800: --
801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('TYPE','YES_NO');
805: fnd_message.set_token('FIELD','p_elig_los_flag');
806: fnd_message.raise_error;
807: --
800: --
801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('TYPE','YES_NO');
805: fnd_message.set_token('FIELD','p_elig_los_flag');
806: fnd_message.raise_error;
807: --
808: end if;
801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('TYPE','YES_NO');
805: fnd_message.set_token('FIELD','p_elig_los_flag');
806: fnd_message.raise_error;
807: --
808: end if;
809: --
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('TYPE','YES_NO');
805: fnd_message.set_token('FIELD','p_elig_los_flag');
806: fnd_message.raise_error;
807: --
808: end if;
809: --
810: if hr_api.not_exists_in_hr_lookups
813: p_effective_date => p_effective_date) then
814: --
815: -- raise error as does not exist as lookup
816: --
817: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
818: fnd_message.set_token('TYPE','YES_NO');
819: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
820: fnd_message.raise_error;
821: --
814: --
815: -- raise error as does not exist as lookup
816: --
817: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
818: fnd_message.set_token('TYPE','YES_NO');
819: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
820: fnd_message.raise_error;
821: --
822: end if;
815: -- raise error as does not exist as lookup
816: --
817: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
818: fnd_message.set_token('TYPE','YES_NO');
819: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
820: fnd_message.raise_error;
821: --
822: end if;
823: --
816: --
817: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
818: fnd_message.set_token('TYPE','YES_NO');
819: fnd_message.set_token('FIELD','p_elig_per_typ_flag');
820: fnd_message.raise_error;
821: --
822: end if;
823: --
824: if hr_api.not_exists_in_hr_lookups
827: p_effective_date => p_effective_date) then
828: --
829: -- raise error as does not exist as lookup
830: --
831: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
832: fnd_message.set_token('TYPE','YES_NO');
833: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
834: fnd_message.raise_error;
835: --
828: --
829: -- raise error as does not exist as lookup
830: --
831: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
832: fnd_message.set_token('TYPE','YES_NO');
833: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
834: fnd_message.raise_error;
835: --
836: end if;
829: -- raise error as does not exist as lookup
830: --
831: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
832: fnd_message.set_token('TYPE','YES_NO');
833: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
834: fnd_message.raise_error;
835: --
836: end if;
837: --
830: --
831: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
832: fnd_message.set_token('TYPE','YES_NO');
833: fnd_message.set_token('FIELD','p_elig_fl_tm_pt_tm_flag');
834: fnd_message.raise_error;
835: --
836: end if;
837: --
838: if hr_api.not_exists_in_hr_lookups
841: p_effective_date => p_effective_date) then
842: --
843: -- raise error as does not exist as lookup
844: --
845: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
846: fnd_message.set_token('TYPE','YES_NO');
847: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
848: fnd_message.raise_error;
849: --
842: --
843: -- raise error as does not exist as lookup
844: --
845: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
846: fnd_message.set_token('TYPE','YES_NO');
847: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
848: fnd_message.raise_error;
849: --
850: end if;
843: -- raise error as does not exist as lookup
844: --
845: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
846: fnd_message.set_token('TYPE','YES_NO');
847: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
848: fnd_message.raise_error;
849: --
850: end if;
851: --
844: --
845: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
846: fnd_message.set_token('TYPE','YES_NO');
847: fnd_message.set_token('FIELD','p_elig_ee_stat_flag');
848: fnd_message.raise_error;
849: --
850: end if;
851: --
852: if hr_api.not_exists_in_hr_lookups
855: p_effective_date => p_effective_date) then
856: --
857: -- raise error as does not exist as lookup
858: --
859: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
860: fnd_message.set_token('TYPE','YES_NO');
861: fnd_message.set_token('FIELD','p_elig_grd_flag');
862: fnd_message.raise_error;
863: --
856: --
857: -- raise error as does not exist as lookup
858: --
859: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
860: fnd_message.set_token('TYPE','YES_NO');
861: fnd_message.set_token('FIELD','p_elig_grd_flag');
862: fnd_message.raise_error;
863: --
864: end if;
857: -- raise error as does not exist as lookup
858: --
859: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
860: fnd_message.set_token('TYPE','YES_NO');
861: fnd_message.set_token('FIELD','p_elig_grd_flag');
862: fnd_message.raise_error;
863: --
864: end if;
865: --
858: --
859: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
860: fnd_message.set_token('TYPE','YES_NO');
861: fnd_message.set_token('FIELD','p_elig_grd_flag');
862: fnd_message.raise_error;
863: --
864: end if;
865: --
866: if hr_api.not_exists_in_hr_lookups
869: p_effective_date => p_effective_date) then
870: --
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('TYPE','YES_NO');
875: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
876: fnd_message.raise_error;
877: --
870: --
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('TYPE','YES_NO');
875: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
876: fnd_message.raise_error;
877: --
878: end if;
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('TYPE','YES_NO');
875: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
876: fnd_message.raise_error;
877: --
878: end if;
879: --
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('TYPE','YES_NO');
875: fnd_message.set_token('FIELD','p_elig_pct_fl_tm_flag');
876: fnd_message.raise_error;
877: --
878: end if;
879: --
880: if hr_api.not_exists_in_hr_lookups
883: p_effective_date => p_effective_date) then
884: --
885: -- raise error as does not exist as lookup
886: --
887: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
888: fnd_message.set_token('TYPE','YES_NO');
889: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
890: fnd_message.raise_error;
891: --
884: --
885: -- raise error as does not exist as lookup
886: --
887: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
888: fnd_message.set_token('TYPE','YES_NO');
889: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
890: fnd_message.raise_error;
891: --
892: end if;
885: -- raise error as does not exist as lookup
886: --
887: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
888: fnd_message.set_token('TYPE','YES_NO');
889: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
890: fnd_message.raise_error;
891: --
892: end if;
893: --
886: --
887: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
888: fnd_message.set_token('TYPE','YES_NO');
889: fnd_message.set_token('FIELD','p_elig_asnt_set_flag');
890: fnd_message.raise_error;
891: --
892: end if;
893: --
894: if hr_api.not_exists_in_hr_lookups
897: p_effective_date => p_effective_date) then
898: --
899: -- raise error as does not exist as lookup
900: --
901: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
902: fnd_message.set_token('TYPE','YES_NO');
903: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
904: fnd_message.raise_error;
905: --
898: --
899: -- raise error as does not exist as lookup
900: --
901: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
902: fnd_message.set_token('TYPE','YES_NO');
903: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
904: fnd_message.raise_error;
905: --
906: end if;
899: -- raise error as does not exist as lookup
900: --
901: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
902: fnd_message.set_token('TYPE','YES_NO');
903: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
904: fnd_message.raise_error;
905: --
906: end if;
907: --
900: --
901: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
902: fnd_message.set_token('TYPE','YES_NO');
903: fnd_message.set_token('FIELD','p_elig_hrs_wkd_flag');
904: fnd_message.raise_error;
905: --
906: end if;
907: --
908: if hr_api.not_exists_in_hr_lookups
911: p_effective_date => p_effective_date) then
912: --
913: -- raise error as does not exist as lookup
914: --
915: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
916: fnd_message.set_token('TYPE','YES_NO');
917: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
918: fnd_message.raise_error;
919: --
912: --
913: -- raise error as does not exist as lookup
914: --
915: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
916: fnd_message.set_token('TYPE','YES_NO');
917: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
918: fnd_message.raise_error;
919: --
920: end if;
913: -- raise error as does not exist as lookup
914: --
915: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
916: fnd_message.set_token('TYPE','YES_NO');
917: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
918: fnd_message.raise_error;
919: --
920: end if;
921: --
914: --
915: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
916: fnd_message.set_token('TYPE','YES_NO');
917: fnd_message.set_token('FIELD','p_elig_comp_lvl_flag');
918: fnd_message.raise_error;
919: --
920: end if;
921: --
922: if hr_api.not_exists_in_hr_lookups
925: p_effective_date => p_effective_date) then
926: --
927: -- raise error as does not exist as lookup
928: --
929: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
930: fnd_message.set_token('TYPE','YES_NO');
931: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
932: fnd_message.raise_error;
933: --
926: --
927: -- raise error as does not exist as lookup
928: --
929: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
930: fnd_message.set_token('TYPE','YES_NO');
931: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
932: fnd_message.raise_error;
933: --
934: end if;
927: -- raise error as does not exist as lookup
928: --
929: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
930: fnd_message.set_token('TYPE','YES_NO');
931: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
932: fnd_message.raise_error;
933: --
934: end if;
935: --
928: --
929: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
930: fnd_message.set_token('TYPE','YES_NO');
931: fnd_message.set_token('FIELD','p_elig_org_unit_flag');
932: fnd_message.raise_error;
933: --
934: end if;
935: --
936: if hr_api.not_exists_in_hr_lookups
939: p_effective_date => p_effective_date) then
940: --
941: -- raise error as does not exist as lookup
942: --
943: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
944: fnd_message.set_token('TYPE','YES_NO');
945: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
946: fnd_message.raise_error;
947: --
940: --
941: -- raise error as does not exist as lookup
942: --
943: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
944: fnd_message.set_token('TYPE','YES_NO');
945: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
946: fnd_message.raise_error;
947: --
948: end if;
941: -- raise error as does not exist as lookup
942: --
943: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
944: fnd_message.set_token('TYPE','YES_NO');
945: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
946: fnd_message.raise_error;
947: --
948: end if;
949: --
942: --
943: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
944: fnd_message.set_token('TYPE','YES_NO');
945: fnd_message.set_token('FIELD','p_elig_loa_rsn_flag');
946: fnd_message.raise_error;
947: --
948: end if;
949: --
950: if hr_api.not_exists_in_hr_lookups
953: p_effective_date => p_effective_date) then
954: --
955: -- raise error as does not exist as lookup
956: --
957: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
958: fnd_message.set_token('TYPE','YES_NO');
959: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
960: fnd_message.raise_error;
961: --
954: --
955: -- raise error as does not exist as lookup
956: --
957: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
958: fnd_message.set_token('TYPE','YES_NO');
959: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
960: fnd_message.raise_error;
961: --
962: end if;
955: -- raise error as does not exist as lookup
956: --
957: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
958: fnd_message.set_token('TYPE','YES_NO');
959: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
960: fnd_message.raise_error;
961: --
962: end if;
963: --
956: --
957: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
958: fnd_message.set_token('TYPE','YES_NO');
959: fnd_message.set_token('FIELD','p_elig_pyrl_flag');
960: fnd_message.raise_error;
961: --
962: end if;
963: --
964: if hr_api.not_exists_in_hr_lookups
967: p_effective_date => p_effective_date) then
968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('TYPE','YES_NO');
973: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
974: fnd_message.raise_error;
975: --
968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('TYPE','YES_NO');
973: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
974: fnd_message.raise_error;
975: --
976: end if;
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('TYPE','YES_NO');
973: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
974: fnd_message.raise_error;
975: --
976: end if;
977: --
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('TYPE','YES_NO');
973: fnd_message.set_token('FIELD','p_elig_schedd_hrs_flag');
974: fnd_message.raise_error;
975: --
976: end if;
977: --
978: if hr_api.not_exists_in_hr_lookups
981: p_effective_date => p_effective_date) then
982: --
983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('TYPE','YES_NO');
987: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
988: fnd_message.raise_error;
989: --
982: --
983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('TYPE','YES_NO');
987: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
988: fnd_message.raise_error;
989: --
990: end if;
983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('TYPE','YES_NO');
987: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
988: fnd_message.raise_error;
989: --
990: end if;
991: --
984: --
985: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('TYPE','YES_NO');
987: fnd_message.set_token('FIELD','p_elig_py_bss_flag');
988: fnd_message.raise_error;
989: --
990: end if;
991: --
992: if hr_api.not_exists_in_hr_lookups
995: p_effective_date => p_effective_date) then
996: --
997: -- raise error as does not exist as lookup
998: --
999: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1000: fnd_message.set_token('TYPE','YES_NO');
1001: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
1002: fnd_message.raise_error;
1003: --
996: --
997: -- raise error as does not exist as lookup
998: --
999: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1000: fnd_message.set_token('TYPE','YES_NO');
1001: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
1002: fnd_message.raise_error;
1003: --
1004: end if;
997: -- raise error as does not exist as lookup
998: --
999: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1000: fnd_message.set_token('TYPE','YES_NO');
1001: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
1002: fnd_message.raise_error;
1003: --
1004: end if;
1005: --
998: --
999: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1000: fnd_message.set_token('TYPE','YES_NO');
1001: fnd_message.set_token('FIELD','p_eligy_prfl_rl_flag');
1002: fnd_message.raise_error;
1003: --
1004: end if;
1005: --
1006: if hr_api.not_exists_in_hr_lookups
1009: p_effective_date => p_effective_date) then
1010: --
1011: -- raise error as does not exist as lookup
1012: --
1013: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1014: fnd_message.set_token('TYPE','YES_NO');
1015: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
1016: fnd_message.raise_error;
1017: --
1010: --
1011: -- raise error as does not exist as lookup
1012: --
1013: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1014: fnd_message.set_token('TYPE','YES_NO');
1015: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
1016: fnd_message.raise_error;
1017: --
1018: end if;
1011: -- raise error as does not exist as lookup
1012: --
1013: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1014: fnd_message.set_token('TYPE','YES_NO');
1015: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --
1012: --
1013: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1014: fnd_message.set_token('TYPE','YES_NO');
1015: fnd_message.set_token('FIELD','p_elig_cmbn_age_los_flag');
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --
1020: if hr_api.not_exists_in_hr_lookups
1023: p_effective_date => p_effective_date) then
1024: --
1025: -- raise error as does not exist as lookup
1026: --
1027: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1028: fnd_message.set_token('TYPE','YES_NO');
1029: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1030: fnd_message.raise_error;
1031: --
1024: --
1025: -- raise error as does not exist as lookup
1026: --
1027: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1028: fnd_message.set_token('TYPE','YES_NO');
1029: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1030: fnd_message.raise_error;
1031: --
1032: end if;
1025: -- raise error as does not exist as lookup
1026: --
1027: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1028: fnd_message.set_token('TYPE','YES_NO');
1029: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1030: fnd_message.raise_error;
1031: --
1032: end if;
1033: --
1026: --
1027: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1028: fnd_message.set_token('TYPE','YES_NO');
1029: fnd_message.set_token('FIELD','p_cntng_prtn_elig_prfl_flag');
1030: fnd_message.raise_error;
1031: --
1032: end if;
1033: --
1034: if hr_api.not_exists_in_hr_lookups
1037: p_effective_date => p_effective_date) then
1038: --
1039: -- raise error as does not exist as lookup
1040: --
1041: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1042: fnd_message.set_token('TYPE','YES_NO');
1043: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1044: fnd_message.raise_error;
1045: --
1038: --
1039: -- raise error as does not exist as lookup
1040: --
1041: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1042: fnd_message.set_token('TYPE','YES_NO');
1043: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1044: fnd_message.raise_error;
1045: --
1046: end if;
1039: -- raise error as does not exist as lookup
1040: --
1041: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1042: fnd_message.set_token('TYPE','YES_NO');
1043: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1044: fnd_message.raise_error;
1045: --
1046: end if;
1047: --
1040: --
1041: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1042: fnd_message.set_token('TYPE','YES_NO');
1043: fnd_message.set_token('FIELD','p_elig_prtt_pl_flag');
1044: fnd_message.raise_error;
1045: --
1046: end if;
1047: --
1048: if hr_api.not_exists_in_hr_lookups
1051: p_effective_date => p_effective_date) then
1052: --
1053: -- raise error as does not exist as lookup
1054: --
1055: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1056: fnd_message.set_token('TYPE','YES_NO');
1057: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1058: fnd_message.raise_error;
1059: --
1052: --
1053: -- raise error as does not exist as lookup
1054: --
1055: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1056: fnd_message.set_token('TYPE','YES_NO');
1057: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1058: fnd_message.raise_error;
1059: --
1060: end if;
1053: -- raise error as does not exist as lookup
1054: --
1055: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1056: fnd_message.set_token('TYPE','YES_NO');
1057: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1058: fnd_message.raise_error;
1059: --
1060: end if;
1061: --
1054: --
1055: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1056: fnd_message.set_token('TYPE','YES_NO');
1057: fnd_message.set_token('FIELD','p_elig_ppl_grp_flag');
1058: fnd_message.raise_error;
1059: --
1060: end if;
1061: --
1062: if hr_api.not_exists_in_hr_lookups
1065: p_effective_date => p_effective_date) then
1066: --
1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('TYPE','YES_NO');
1071: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1072: fnd_message.raise_error;
1073: --
1066: --
1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('TYPE','YES_NO');
1071: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('TYPE','YES_NO');
1071: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('TYPE','YES_NO');
1071: fnd_message.set_token('FIELD','p_elig_svc_area_flag');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --
1076: if hr_api.not_exists_in_hr_lookups
1079: p_effective_date => p_effective_date) then
1080: --
1081: -- raise error as does not exist as lookup
1082: --
1083: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1084: fnd_message.set_token('TYPE','YES_NO');
1085: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1086: fnd_message.raise_error;
1087: --
1080: --
1081: -- raise error as does not exist as lookup
1082: --
1083: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1084: fnd_message.set_token('TYPE','YES_NO');
1085: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1086: fnd_message.raise_error;
1087: --
1088: end if;
1081: -- raise error as does not exist as lookup
1082: --
1083: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1084: fnd_message.set_token('TYPE','YES_NO');
1085: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1086: fnd_message.raise_error;
1087: --
1088: end if;
1089: --
1082: --
1083: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1084: fnd_message.set_token('TYPE','YES_NO');
1085: fnd_message.set_token('FIELD','p_elig_ptip_prte_flag');
1086: fnd_message.raise_error;
1087: --
1088: end if;
1089: --
1090: if hr_api.not_exists_in_hr_lookups
1093: p_effective_date => p_effective_date) then
1094: --
1095: -- raise error as does not exist as lookup
1096: --
1097: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1098: fnd_message.set_token('TYPE','YES_NO');
1099: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1100: fnd_message.raise_error;
1101: --
1094: --
1095: -- raise error as does not exist as lookup
1096: --
1097: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1098: fnd_message.set_token('TYPE','YES_NO');
1099: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1100: fnd_message.raise_error;
1101: --
1102: end if;
1095: -- raise error as does not exist as lookup
1096: --
1097: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1098: fnd_message.set_token('TYPE','YES_NO');
1099: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1100: fnd_message.raise_error;
1101: --
1102: end if;
1103: --
1096: --
1097: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1098: fnd_message.set_token('TYPE','YES_NO');
1099: fnd_message.set_token('FIELD','p_elig_no_othr_cvg_flag');
1100: fnd_message.raise_error;
1101: --
1102: end if;
1103: --
1104: if hr_api.not_exists_in_hr_lookups
1107: p_effective_date => p_effective_date) then
1108: --
1109: -- raise error as does not exist as lookup
1110: --
1111: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1112: fnd_message.set_token('TYPE','YES_NO');
1113: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1114: fnd_message.raise_error;
1115: --
1108: --
1109: -- raise error as does not exist as lookup
1110: --
1111: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1112: fnd_message.set_token('TYPE','YES_NO');
1113: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1114: fnd_message.raise_error;
1115: --
1116: end if;
1109: -- raise error as does not exist as lookup
1110: --
1111: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1112: fnd_message.set_token('TYPE','YES_NO');
1113: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1114: fnd_message.raise_error;
1115: --
1116: end if;
1117: --
1110: --
1111: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1112: fnd_message.set_token('TYPE','YES_NO');
1113: fnd_message.set_token('FIELD','p_elig_enrld_pl_flag');
1114: fnd_message.raise_error;
1115: --
1116: end if;
1117: --
1118: if hr_api.not_exists_in_hr_lookups
1121: p_effective_date => p_effective_date) then
1122: --
1123: -- raise error as does not exist as lookup
1124: --
1125: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1126: fnd_message.set_token('TYPE','YES_NO');
1127: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1128: fnd_message.raise_error;
1129: --
1122: --
1123: -- raise error as does not exist as lookup
1124: --
1125: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1126: fnd_message.set_token('TYPE','YES_NO');
1127: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1128: fnd_message.raise_error;
1129: --
1130: end if;
1123: -- raise error as does not exist as lookup
1124: --
1125: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1126: fnd_message.set_token('TYPE','YES_NO');
1127: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1128: fnd_message.raise_error;
1129: --
1130: end if;
1131: --
1124: --
1125: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1126: fnd_message.set_token('TYPE','YES_NO');
1127: fnd_message.set_token('FIELD','p_elig_enrld_oipl_flag');
1128: fnd_message.raise_error;
1129: --
1130: end if;
1131: --
1132: if hr_api.not_exists_in_hr_lookups
1135: p_effective_date => p_effective_date) then
1136: --
1137: -- raise error as does not exist as lookup
1138: --
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('TYPE','YES_NO');
1141: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1142: fnd_message.raise_error;
1143: --
1136: --
1137: -- raise error as does not exist as lookup
1138: --
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('TYPE','YES_NO');
1141: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1137: -- raise error as does not exist as lookup
1138: --
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('TYPE','YES_NO');
1141: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --
1138: --
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('TYPE','YES_NO');
1141: fnd_message.set_token('FIELD','p_elig_enrld_pgm_flag');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --
1146: if hr_api.not_exists_in_hr_lookups
1149: p_effective_date => p_effective_date) then
1150: --
1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('TYPE','YES_NO');
1155: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1156: fnd_message.raise_error;
1157: --
1150: --
1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('TYPE','YES_NO');
1155: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1156: fnd_message.raise_error;
1157: --
1158: end if;
1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('TYPE','YES_NO');
1155: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1156: fnd_message.raise_error;
1157: --
1158: end if;
1159: --
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('TYPE','YES_NO');
1155: fnd_message.set_token('FIELD','p_elig_dpnt_cvrd_pl_flag');
1156: fnd_message.raise_error;
1157: --
1158: end if;
1159: --
1160: if hr_api.not_exists_in_hr_lookups
1163: p_effective_date => p_effective_date) then
1164: --
1165: -- raise error as does not exist as lookup
1166: --
1167: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1168: fnd_message.set_token('TYPE','YES_NO');
1169: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1170: fnd_message.raise_error;
1171: --
1164: --
1165: -- raise error as does not exist as lookup
1166: --
1167: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1168: fnd_message.set_token('TYPE','YES_NO');
1169: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1170: fnd_message.raise_error;
1171: --
1172: end if;
1165: -- raise error as does not exist as lookup
1166: --
1167: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1168: fnd_message.set_token('TYPE','YES_NO');
1169: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1170: fnd_message.raise_error;
1171: --
1172: end if;
1173: --
1166: --
1167: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1168: fnd_message.set_token('TYPE','YES_NO');
1169: fnd_message.set_token('FIELD','p_elig_lvg_rsn_flag');
1170: fnd_message.raise_error;
1171: --
1172: end if;
1173: --
1174: if hr_api.not_exists_in_hr_lookups
1177: p_effective_date => p_effective_date) then
1178: --
1179: -- raise error as does not exist as lookup
1180: --
1181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1184: fnd_message.raise_error;
1185: --
1178: --
1179: -- raise error as does not exist as lookup
1180: --
1181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1184: fnd_message.raise_error;
1185: --
1186: end if;
1179: -- raise error as does not exist as lookup
1180: --
1181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1184: fnd_message.raise_error;
1185: --
1186: end if;
1187: --
1180: --
1181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.set_token('FIELD','p_elig_optd_mdcr_flag');
1184: fnd_message.raise_error;
1185: --
1186: end if;
1187: --
1188: if hr_api.not_exists_in_hr_lookups
1191: p_effective_date => p_effective_date) then
1192: --
1193: -- raise error as does not exist as lookup
1194: --
1195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1196: fnd_message.set_token('TYPE','YES_NO');
1197: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1198: fnd_message.raise_error;
1199: --
1192: --
1193: -- raise error as does not exist as lookup
1194: --
1195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1196: fnd_message.set_token('TYPE','YES_NO');
1197: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1198: fnd_message.raise_error;
1199: --
1200: end if;
1193: -- raise error as does not exist as lookup
1194: --
1195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1196: fnd_message.set_token('TYPE','YES_NO');
1197: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1198: fnd_message.raise_error;
1199: --
1200: end if;
1201: --
1194: --
1195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1196: fnd_message.set_token('TYPE','YES_NO');
1197: fnd_message.set_token('FIELD','p_elig_tbco_use_flag');
1198: fnd_message.raise_error;
1199: --
1200: end if;
1201: --
1202: if hr_api.not_exists_in_hr_lookups
1205: p_effective_date => p_effective_date) then
1206: --
1207: -- raise error as does not exist as lookup
1208: --
1209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1210: fnd_message.set_token('TYPE','YES_NO');
1211: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1212: fnd_message.raise_error;
1213: --
1206: --
1207: -- raise error as does not exist as lookup
1208: --
1209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1210: fnd_message.set_token('TYPE','YES_NO');
1211: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1212: fnd_message.raise_error;
1213: --
1214: end if;
1207: -- raise error as does not exist as lookup
1208: --
1209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1210: fnd_message.set_token('TYPE','YES_NO');
1211: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1212: fnd_message.raise_error;
1213: --
1214: end if;
1215: --
1208: --
1209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1210: fnd_message.set_token('TYPE','YES_NO');
1211: fnd_message.set_token('FIELD','p_elig_dpnt_othr_ptip_flag');
1212: fnd_message.raise_error;
1213: --
1214: end if;
1215: --
1216: if hr_api.not_exists_in_hr_lookups
1219: p_effective_date => p_effective_date) then
1220: --
1221: -- raise error as does not exist as lookup
1222: --
1223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1224: fnd_message.set_token('TYPE','YES_NO');
1225: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1226: fnd_message.raise_error;
1227: --
1220: --
1221: -- raise error as does not exist as lookup
1222: --
1223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1224: fnd_message.set_token('TYPE','YES_NO');
1225: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1226: fnd_message.raise_error;
1227: --
1228: end if;
1221: -- raise error as does not exist as lookup
1222: --
1223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1224: fnd_message.set_token('TYPE','YES_NO');
1225: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1226: fnd_message.raise_error;
1227: --
1228: end if;
1229: --
1222: --
1223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1224: fnd_message.set_token('TYPE','YES_NO');
1225: fnd_message.set_token('FIELD','p_elig_dsbld_flag');
1226: fnd_message.raise_error;
1227: --
1228: end if;
1229: --
1230: if hr_api.not_exists_in_hr_lookups
1233: p_effective_date => p_effective_date) then
1234: --
1235: -- raise error as does not exist as lookup
1236: --
1237: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1238: fnd_message.set_token('TYPE','YES_NO');
1239: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1240: fnd_message.raise_error;
1241: --
1234: --
1235: -- raise error as does not exist as lookup
1236: --
1237: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1238: fnd_message.set_token('TYPE','YES_NO');
1239: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1240: fnd_message.raise_error;
1241: --
1242: end if;
1235: -- raise error as does not exist as lookup
1236: --
1237: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1238: fnd_message.set_token('TYPE','YES_NO');
1239: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1240: fnd_message.raise_error;
1241: --
1242: end if;
1243: --
1236: --
1237: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1238: fnd_message.set_token('TYPE','YES_NO');
1239: fnd_message.set_token('FIELD','p_elig_ttl_cvg_vol_flag');
1240: fnd_message.raise_error;
1241: --
1242: end if;
1243: --
1244: if hr_api.not_exists_in_hr_lookups
1247: p_effective_date => p_effective_date) then
1248: --
1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('TYPE','YES_NO');
1253: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1254: fnd_message.raise_error;
1255: --
1248: --
1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('TYPE','YES_NO');
1253: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('TYPE','YES_NO');
1253: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1257: --
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('TYPE','YES_NO');
1253: fnd_message.set_token('FIELD','p_elig_ttl_prtt_flag');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1257: --
1258: if hr_api.not_exists_in_hr_lookups
1261: p_effective_date => p_effective_date) then
1262: --
1263: -- raise error as does not exist as lookup
1264: --
1265: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1266: fnd_message.set_token('TYPE','YES_NO');
1267: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1268: fnd_message.raise_error;
1269: --
1262: --
1263: -- raise error as does not exist as lookup
1264: --
1265: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1266: fnd_message.set_token('TYPE','YES_NO');
1267: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1268: fnd_message.raise_error;
1269: --
1270: end if;
1263: -- raise error as does not exist as lookup
1264: --
1265: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1266: fnd_message.set_token('TYPE','YES_NO');
1267: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1268: fnd_message.raise_error;
1269: --
1270: end if;
1271: --
1264: --
1265: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1266: fnd_message.set_token('TYPE','YES_NO');
1267: fnd_message.set_token('FIELD','p_elig_comptncy_flag');
1268: fnd_message.raise_error;
1269: --
1270: end if;
1271: --
1272: if hr_api.not_exists_in_hr_lookups
1275: p_effective_date => p_effective_date) then
1276: --
1277: -- raise error as does not exist as lookup
1278: --
1279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1280: fnd_message.set_token('TYPE','YES_NO');
1281: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1282: fnd_message.raise_error;
1283: --
1276: --
1277: -- raise error as does not exist as lookup
1278: --
1279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1280: fnd_message.set_token('TYPE','YES_NO');
1281: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1282: fnd_message.raise_error;
1283: --
1284: end if;
1277: -- raise error as does not exist as lookup
1278: --
1279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1280: fnd_message.set_token('TYPE','YES_NO');
1281: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1282: fnd_message.raise_error;
1283: --
1284: end if;
1285: --
1278: --
1279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1280: fnd_message.set_token('TYPE','YES_NO');
1281: fnd_message.set_token('FIELD','p_elig_hlth_cvg_flag');
1282: fnd_message.raise_error;
1283: --
1284: end if;
1285: --
1286: if hr_api.not_exists_in_hr_lookups
1289: p_effective_date => p_effective_date) then
1290: --
1291: -- raise error as does not exist as lookup
1292: --
1293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1294: fnd_message.set_token('TYPE','YES_NO');
1295: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1296: fnd_message.raise_error;
1297: --
1290: --
1291: -- raise error as does not exist as lookup
1292: --
1293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1294: fnd_message.set_token('TYPE','YES_NO');
1295: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1296: fnd_message.raise_error;
1297: --
1298: end if;
1291: -- raise error as does not exist as lookup
1292: --
1293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1294: fnd_message.set_token('TYPE','YES_NO');
1295: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1296: fnd_message.raise_error;
1297: --
1298: end if;
1299: --
1292: --
1293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1294: fnd_message.set_token('TYPE','YES_NO');
1295: fnd_message.set_token('FIELD','p_elig_anthr_pl_flag');
1296: fnd_message.raise_error;
1297: --
1298: end if;
1299: --
1300: if hr_api.not_exists_in_hr_lookups
1303: p_effective_date => p_effective_date) then
1304: --
1305: -- raise error as does not exist as lookup
1306: --
1307: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1308: fnd_message.set_token('TYPE','YES_NO');
1309: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1310: fnd_message.raise_error;
1311: --
1304: --
1305: -- raise error as does not exist as lookup
1306: --
1307: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1308: fnd_message.set_token('TYPE','YES_NO');
1309: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1310: fnd_message.raise_error;
1311: --
1312: end if;
1305: -- raise error as does not exist as lookup
1306: --
1307: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1308: fnd_message.set_token('TYPE','YES_NO');
1309: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1310: fnd_message.raise_error;
1311: --
1312: end if;
1313: --
1306: --
1307: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1308: fnd_message.set_token('TYPE','YES_NO');
1309: fnd_message.set_token('FIELD','p_elig_qua_in_gr_flag');
1310: fnd_message.raise_error;
1311: --
1312: end if;
1313: --
1314: if hr_api.not_exists_in_hr_lookups
1317: p_effective_date => p_effective_date) then
1318: --
1319: -- raise error as does not exist as lookup
1320: --
1321: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1322: fnd_message.set_token('TYPE','YES_NO');
1323: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1324: fnd_message.raise_error;
1325: --
1318: --
1319: -- raise error as does not exist as lookup
1320: --
1321: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1322: fnd_message.set_token('TYPE','YES_NO');
1323: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1324: fnd_message.raise_error;
1325: --
1326: end if;
1319: -- raise error as does not exist as lookup
1320: --
1321: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1322: fnd_message.set_token('TYPE','YES_NO');
1323: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1324: fnd_message.raise_error;
1325: --
1326: end if;
1327: --
1320: --
1321: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1322: fnd_message.set_token('TYPE','YES_NO');
1323: fnd_message.set_token('FIELD','p_elig_perf_rtng_flag');
1324: fnd_message.raise_error;
1325: --
1326: end if;
1327: --
1328: --
1332: p_effective_date => p_effective_date) then
1333: --
1334: -- raise error as does not exist as lookup
1335: --
1336: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1337: fnd_message.set_token('TYPE','YES_NO');
1338: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1339: fnd_message.raise_error;
1340: --
1333: --
1334: -- raise error as does not exist as lookup
1335: --
1336: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1337: fnd_message.set_token('TYPE','YES_NO');
1338: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1339: fnd_message.raise_error;
1340: --
1341: end if;
1334: -- raise error as does not exist as lookup
1335: --
1336: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1337: fnd_message.set_token('TYPE','YES_NO');
1338: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1339: fnd_message.raise_error;
1340: --
1341: end if;
1342: hr_utility.set_location('Leaving:'||l_proc,10);
1335: --
1336: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1337: fnd_message.set_token('TYPE','YES_NO');
1338: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1339: fnd_message.raise_error;
1340: --
1341: end if;
1342: hr_utility.set_location('Leaving:'||l_proc,10);
1343: --
1417: --
1418: -- A referential integrity check was violated therefore
1419: -- we must error
1420: --
1421: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1422: fnd_message.set_token('TABLE_NAME', l_table_name);
1423: fnd_message.raise_error;
1424: When Others Then
1425: --
1418: -- A referential integrity check was violated therefore
1419: -- we must error
1420: --
1421: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1422: fnd_message.set_token('TABLE_NAME', l_table_name);
1423: fnd_message.raise_error;
1424: When Others Then
1425: --
1426: -- An unhandled or unexpected error has occurred which
1419: -- we must error
1420: --
1421: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1422: fnd_message.set_token('TABLE_NAME', l_table_name);
1423: fnd_message.raise_error;
1424: When Others Then
1425: --
1426: -- An unhandled or unexpected error has occurred which
1427: -- we must report
1425: --
1426: -- An unhandled or unexpected error has occurred which
1427: -- we must report
1428: --
1429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1430: fnd_message.set_token('PROCEDURE', l_proc);
1431: fnd_message.set_token('STEP','15');
1432: fnd_message.raise_error;
1433: End dt_update_validate;
1426: -- An unhandled or unexpected error has occurred which
1427: -- we must report
1428: --
1429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1430: fnd_message.set_token('PROCEDURE', l_proc);
1431: fnd_message.set_token('STEP','15');
1432: fnd_message.raise_error;
1433: End dt_update_validate;
1434: --
1427: -- we must report
1428: --
1429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1430: fnd_message.set_token('PROCEDURE', l_proc);
1431: fnd_message.set_token('STEP','15');
1432: fnd_message.raise_error;
1433: End dt_update_validate;
1434: --
1435: -- ----------------------------------------------------------------------------
1428: --
1429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1430: fnd_message.set_token('PROCEDURE', l_proc);
1431: fnd_message.set_token('STEP','15');
1432: fnd_message.raise_error;
1433: End dt_update_validate;
1434: --
1435: -- ----------------------------------------------------------------------------
1436: -- |--------------------------< dt_delete_validate >--------------------------|
1540: --
1541: -- An unhandled or unexpected error has occurred which
1542: -- we must report
1543: --
1544: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1545: fnd_message.set_token('PROCEDURE', l_proc);
1546: fnd_message.set_token('STEP','15');
1547: fnd_message.raise_error;
1548: End dt_delete_validate;
1541: -- An unhandled or unexpected error has occurred which
1542: -- we must report
1543: --
1544: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1545: fnd_message.set_token('PROCEDURE', l_proc);
1546: fnd_message.set_token('STEP','15');
1547: fnd_message.raise_error;
1548: End dt_delete_validate;
1549: --
1542: -- we must report
1543: --
1544: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1545: fnd_message.set_token('PROCEDURE', l_proc);
1546: fnd_message.set_token('STEP','15');
1547: fnd_message.raise_error;
1548: End dt_delete_validate;
1549: --
1550: -- ----------------------------------------------------------------------------
1543: --
1544: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1545: fnd_message.set_token('PROCEDURE', l_proc);
1546: fnd_message.set_token('STEP','15');
1547: fnd_message.raise_error;
1548: End dt_delete_validate;
1549: --
1550: -- ----------------------------------------------------------------------------
1551: -- |---------------------------< insert_validate >----------------------------|
1843: close csr_leg_code;
1844: --
1845: -- The primary key is invalid therefore we must error
1846: --
1847: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1848: fnd_message.raise_error;
1849: --
1850: end if;
1851: --
1844: --
1845: -- The primary key is invalid therefore we must error
1846: --
1847: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1848: fnd_message.raise_error;
1849: --
1850: end if;
1851: --
1852: close csr_leg_code;