133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dflt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dflt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dflt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dflt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
203: p_effective_date => p_effective_date) then
204: --
205: -- raise error as does not exist as lookup
206: --
207: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
208: fnd_message.set_token('FIELD','p_mndtry_flag');
209: fnd_message.set_token('TYPE','YES_NO');
210: fnd_message.raise_error;
211: --
204: --
205: -- raise error as does not exist as lookup
206: --
207: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
208: fnd_message.set_token('FIELD','p_mndtry_flag');
209: fnd_message.set_token('TYPE','YES_NO');
210: fnd_message.raise_error;
211: --
212: end if;
205: -- raise error as does not exist as lookup
206: --
207: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
208: fnd_message.set_token('FIELD','p_mndtry_flag');
209: fnd_message.set_token('TYPE','YES_NO');
210: fnd_message.raise_error;
211: --
212: end if;
213: --
206: --
207: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
208: fnd_message.set_token('FIELD','p_mndtry_flag');
209: fnd_message.set_token('TYPE','YES_NO');
210: fnd_message.raise_error;
211: --
212: end if;
213: --
214: end if;
273: p_effective_date => p_effective_date) then
274: --
275: -- raise error as does not exist as lookup
276: --
277: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
278: fnd_message.set_token('FIELD','p_elig_apls_flag');
279: fnd_message.set_token('TYPE','YES_NO');
280: fnd_message.raise_error;
281: --
274: --
275: -- raise error as does not exist as lookup
276: --
277: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
278: fnd_message.set_token('FIELD','p_elig_apls_flag');
279: fnd_message.set_token('TYPE','YES_NO');
280: fnd_message.raise_error;
281: --
282: end if;
275: -- raise error as does not exist as lookup
276: --
277: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
278: fnd_message.set_token('FIELD','p_elig_apls_flag');
279: fnd_message.set_token('TYPE','YES_NO');
280: fnd_message.raise_error;
281: --
282: end if;
283: --
276: --
277: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
278: fnd_message.set_token('FIELD','p_elig_apls_flag');
279: fnd_message.set_token('TYPE','YES_NO');
280: fnd_message.raise_error;
281: --
282: end if;
283: --
284: end if;
343: p_effective_date => p_effective_date) then
344: --
345: -- raise error as does not exist as lookup
346: --
347: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
348: fnd_message.set_token('FIELD','p_trk_inelig_per_flag');
349: fnd_message.set_token('TYPE','YES_NO');
350: fnd_message.raise_error;
351: --
344: --
345: -- raise error as does not exist as lookup
346: --
347: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
348: fnd_message.set_token('FIELD','p_trk_inelig_per_flag');
349: fnd_message.set_token('TYPE','YES_NO');
350: fnd_message.raise_error;
351: --
352: end if;
345: -- raise error as does not exist as lookup
346: --
347: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
348: fnd_message.set_token('FIELD','p_trk_inelig_per_flag');
349: fnd_message.set_token('TYPE','YES_NO');
350: fnd_message.raise_error;
351: --
352: end if;
353: --
346: --
347: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
348: fnd_message.set_token('FIELD','p_trk_inelig_per_flag');
349: fnd_message.set_token('TYPE','YES_NO');
350: fnd_message.raise_error;
351: --
352: end if;
353: --
354: end if;
414: p_effective_date => p_effective_date) then
415: --
416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD','p_drvbl_fctr_prtn_elig_flag');
420: fnd_message.set_token('TYPE','YES_NO');
421: fnd_message.raise_error;
422: --
415: --
416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD','p_drvbl_fctr_prtn_elig_flag');
420: fnd_message.set_token('TYPE','YES_NO');
421: fnd_message.raise_error;
422: --
423: end if;
416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD','p_drvbl_fctr_prtn_elig_flag');
420: fnd_message.set_token('TYPE','YES_NO');
421: fnd_message.raise_error;
422: --
423: end if;
424: --
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD','p_drvbl_fctr_prtn_elig_flag');
420: fnd_message.set_token('TYPE','YES_NO');
421: fnd_message.raise_error;
422: --
423: end if;
424: --
425: end if;
485: p_effective_date => p_effective_date) then
486: --
487: -- raise error as does not exist as lookup
488: --
489: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
490: fnd_message.set_token('FIELD','p_prtn_elig_ovrid_alwd_flag');
491: fnd_message.set_token('TYPE','YES_NO');
492: fnd_message.raise_error;
493: --
486: --
487: -- raise error as does not exist as lookup
488: --
489: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
490: fnd_message.set_token('FIELD','p_prtn_elig_ovrid_alwd_flag');
491: fnd_message.set_token('TYPE','YES_NO');
492: fnd_message.raise_error;
493: --
494: end if;
487: -- raise error as does not exist as lookup
488: --
489: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
490: fnd_message.set_token('FIELD','p_prtn_elig_ovrid_alwd_flag');
491: fnd_message.set_token('TYPE','YES_NO');
492: fnd_message.raise_error;
493: --
494: end if;
495: --
488: --
489: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
490: fnd_message.set_token('FIELD','p_prtn_elig_ovrid_alwd_flag');
491: fnd_message.set_token('TYPE','YES_NO');
492: fnd_message.raise_error;
493: --
494: end if;
495: --
496: end if;
556: p_effective_date => p_effective_date) then
557: --
558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_drvbl_fctr_apls_rts_flag');
562: fnd_message.set_token('TYPE','YES_NO');
563: fnd_message.raise_error;
564: --
557: --
558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_drvbl_fctr_apls_rts_flag');
562: fnd_message.set_token('TYPE','YES_NO');
563: fnd_message.raise_error;
564: --
565: end if;
558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_drvbl_fctr_apls_rts_flag');
562: fnd_message.set_token('TYPE','YES_NO');
563: fnd_message.raise_error;
564: --
565: end if;
566: --
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_drvbl_fctr_apls_rts_flag');
562: fnd_message.set_token('TYPE','YES_NO');
563: fnd_message.raise_error;
564: --
565: end if;
566: --
567: end if;
626: p_effective_date => p_effective_date) then
627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_oipl_stat_cd');
632: fnd_message.set_token('TYPE','BEN_STAT');
633: fnd_message.raise_error;
634: --
627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_oipl_stat_cd');
632: fnd_message.set_token('TYPE','BEN_STAT');
633: fnd_message.raise_error;
634: --
635: end if;
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_oipl_stat_cd');
632: fnd_message.set_token('TYPE','BEN_STAT');
633: fnd_message.raise_error;
634: --
635: end if;
636: --
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_oipl_stat_cd');
632: fnd_message.set_token('TYPE','BEN_STAT');
633: fnd_message.raise_error;
634: --
635: end if;
636: --
637: end if;
696: p_effective_date => p_effective_date) then
697: --
698: -- raise error as does not exist as lookup
699: --
700: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
701: fnd_message.set_token('FIELD','p_pcp_dsgn_cd');
702: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
703: fnd_message.raise_error;
704: --
697: --
698: -- raise error as does not exist as lookup
699: --
700: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
701: fnd_message.set_token('FIELD','p_pcp_dsgn_cd');
702: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
703: fnd_message.raise_error;
704: --
705: end if;
698: -- raise error as does not exist as lookup
699: --
700: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
701: fnd_message.set_token('FIELD','p_pcp_dsgn_cd');
702: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
703: fnd_message.raise_error;
704: --
705: end if;
706: --
699: --
700: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
701: fnd_message.set_token('FIELD','p_pcp_dsgn_cd');
702: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
703: fnd_message.raise_error;
704: --
705: end if;
706: --
707: end if;
767: p_effective_date => p_effective_date) then
768: --
769: -- raise error as does not exist as lookup
770: --
771: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
772: fnd_message.set_token('FIELD','p_pcp_dpnt_dsgn_cd');
773: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
774: fnd_message.raise_error;
775: --
768: --
769: -- raise error as does not exist as lookup
770: --
771: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
772: fnd_message.set_token('FIELD','p_pcp_dpnt_dsgn_cd');
773: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
774: fnd_message.raise_error;
775: --
776: end if;
769: -- raise error as does not exist as lookup
770: --
771: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
772: fnd_message.set_token('FIELD','p_pcp_dpnt_dsgn_cd');
773: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
774: fnd_message.raise_error;
775: --
776: end if;
777: --
770: --
771: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
772: fnd_message.set_token('FIELD','p_pcp_dpnt_dsgn_cd');
773: fnd_message.set_token('TYPE','BEN_PCP_DSGN');
774: fnd_message.raise_error;
775: --
776: end if;
777: --
778: end if;
837: p_effective_date => p_effective_date) then
838: --
839: -- raise error as does not exist as lookup
840: --
841: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
842: fnd_message.set_token('FIELD','p_auto_enrt_flag');
843: fnd_message.set_token('TYPE','YES_NO');
844: fnd_message.raise_error;
845: --
838: --
839: -- raise error as does not exist as lookup
840: --
841: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
842: fnd_message.set_token('FIELD','p_auto_enrt_flag');
843: fnd_message.set_token('TYPE','YES_NO');
844: fnd_message.raise_error;
845: --
846: end if;
839: -- raise error as does not exist as lookup
840: --
841: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
842: fnd_message.set_token('FIELD','p_auto_enrt_flag');
843: fnd_message.set_token('TYPE','YES_NO');
844: fnd_message.raise_error;
845: --
846: end if;
847: --
840: --
841: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
842: fnd_message.set_token('FIELD','p_auto_enrt_flag');
843: fnd_message.set_token('TYPE','YES_NO');
844: fnd_message.raise_error;
845: --
846: end if;
847: --
848: end if;
908: p_effective_date => p_effective_date) then
909: --
910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_vrfy_fmly_mmbr_cd');
914: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
915: fnd_message.raise_error;
916: --
909: --
910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_vrfy_fmly_mmbr_cd');
914: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
915: fnd_message.raise_error;
916: --
917: end if;
910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_vrfy_fmly_mmbr_cd');
914: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
915: fnd_message.raise_error;
916: --
917: end if;
918: --
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_vrfy_fmly_mmbr_cd');
914: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
915: fnd_message.raise_error;
916: --
917: end if;
918: --
919: end if;
978: p_effective_date => p_effective_date) then
979: --
980: -- raise error as does not exist as lookup
981: --
982: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
983: fnd_message.set_token('FIELD','p_enrt_cd');
984: fnd_message.set_token('TYPE','BEN_ENRT');
985: fnd_message.raise_error;
986: --
979: --
980: -- raise error as does not exist as lookup
981: --
982: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
983: fnd_message.set_token('FIELD','p_enrt_cd');
984: fnd_message.set_token('TYPE','BEN_ENRT');
985: fnd_message.raise_error;
986: --
987: end if;
980: -- raise error as does not exist as lookup
981: --
982: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
983: fnd_message.set_token('FIELD','p_enrt_cd');
984: fnd_message.set_token('TYPE','BEN_ENRT');
985: fnd_message.raise_error;
986: --
987: end if;
988: --
981: --
982: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
983: fnd_message.set_token('FIELD','p_enrt_cd');
984: fnd_message.set_token('TYPE','BEN_ENRT');
985: fnd_message.raise_error;
986: --
987: end if;
988: --
989: end if;
1048: p_effective_date => p_effective_date) then
1049: --
1050: -- raise error as does not exist as lookup
1051: --
1052: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1053: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
1054: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
1055: fnd_message.raise_error;
1056: --
1049: --
1050: -- raise error as does not exist as lookup
1051: --
1052: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1053: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
1054: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
1055: fnd_message.raise_error;
1056: --
1057: end if;
1050: -- raise error as does not exist as lookup
1051: --
1052: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1053: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
1054: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
1055: fnd_message.raise_error;
1056: --
1057: end if;
1058: --
1051: --
1052: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1053: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
1054: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
1055: fnd_message.raise_error;
1056: --
1057: end if;
1058: --
1059: end if;
1120: p_effective_date => p_effective_date) then
1121: --
1122: -- raise error
1123: --
1124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1125: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
1126: fnd_message.set_token('TYPE_ID',-146);
1127: fnd_message.raise_error;
1128: --
1121: --
1122: -- raise error
1123: --
1124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1125: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
1126: fnd_message.set_token('TYPE_ID',-146);
1127: fnd_message.raise_error;
1128: --
1129: end if;
1122: -- raise error
1123: --
1124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1125: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
1126: fnd_message.set_token('TYPE_ID',-146);
1127: fnd_message.raise_error;
1128: --
1129: end if;
1130: --
1123: --
1124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1125: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
1126: fnd_message.set_token('TYPE_ID',-146);
1127: fnd_message.raise_error;
1128: --
1129: end if;
1130: --
1131: end if;
1194: p_effective_date => p_effective_date) then
1195: --
1196: -- raise error
1197: --
1198: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1199: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
1200: fnd_message.set_token('TYPE_ID',-32);
1201: fnd_message.raise_error;
1202: --
1195: --
1196: -- raise error
1197: --
1198: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1199: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
1200: fnd_message.set_token('TYPE_ID',-32);
1201: fnd_message.raise_error;
1202: --
1203: end if;
1196: -- raise error
1197: --
1198: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1199: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
1200: fnd_message.set_token('TYPE_ID',-32);
1201: fnd_message.raise_error;
1202: --
1203: end if;
1204: --
1197: --
1198: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1199: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
1200: fnd_message.set_token('TYPE_ID',-32);
1201: fnd_message.raise_error;
1202: --
1203: end if;
1204: --
1205: end if;
1266: p_effective_date => p_effective_date) then
1267: --
1268: -- raise error
1269: --
1270: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1271: fnd_message.set_token('ID',p_mndtry_rl);
1272: fnd_message.set_token('TYPE_ID',-159);
1273: fnd_message.raise_error;
1274: --
1267: --
1268: -- raise error
1269: --
1270: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1271: fnd_message.set_token('ID',p_mndtry_rl);
1272: fnd_message.set_token('TYPE_ID',-159);
1273: fnd_message.raise_error;
1274: --
1275: end if;
1268: -- raise error
1269: --
1270: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1271: fnd_message.set_token('ID',p_mndtry_rl);
1272: fnd_message.set_token('TYPE_ID',-159);
1273: fnd_message.raise_error;
1274: --
1275: end if;
1276: --
1269: --
1270: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1271: fnd_message.set_token('ID',p_mndtry_rl);
1272: fnd_message.set_token('TYPE_ID',-159);
1273: fnd_message.raise_error;
1274: --
1275: end if;
1276: --
1277: end if;
1338: p_effective_date => p_effective_date) then
1339: --
1340: -- raise error
1341: --
1342: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1343: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
1344: fnd_message.set_token('TYPE_ID',-513);
1345: fnd_message.raise_error;
1346: --
1339: --
1340: -- raise error
1341: --
1342: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1343: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
1344: fnd_message.set_token('TYPE_ID',-513);
1345: fnd_message.raise_error;
1346: --
1347: end if;
1340: -- raise error
1341: --
1342: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1343: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
1344: fnd_message.set_token('TYPE_ID',-513);
1345: fnd_message.raise_error;
1346: --
1347: end if;
1348: --
1341: --
1342: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1343: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
1344: fnd_message.set_token('TYPE_ID',-513);
1345: fnd_message.raise_error;
1346: --
1347: end if;
1348: --
1349: end if;
1410: p_effective_date => p_effective_date) then
1411: --
1412: -- raise error
1413: --
1414: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1415: fnd_message.set_token('ID',p_postelcn_edit_rl);
1416: fnd_message.set_token('TYPE_ID',-215);
1417: fnd_message.raise_error;
1418: --
1411: --
1412: -- raise error
1413: --
1414: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1415: fnd_message.set_token('ID',p_postelcn_edit_rl);
1416: fnd_message.set_token('TYPE_ID',-215);
1417: fnd_message.raise_error;
1418: --
1419: end if;
1412: -- raise error
1413: --
1414: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1415: fnd_message.set_token('ID',p_postelcn_edit_rl);
1416: fnd_message.set_token('TYPE_ID',-215);
1417: fnd_message.raise_error;
1418: --
1419: end if;
1420: --
1413: --
1414: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1415: fnd_message.set_token('ID',p_postelcn_edit_rl);
1416: fnd_message.set_token('TYPE_ID',-215);
1417: fnd_message.raise_error;
1418: --
1419: end if;
1420: --
1421: end if;
1482: p_effective_date => p_effective_date) then
1483: --
1484: -- raise error
1485: --
1486: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1487: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1488: fnd_message.set_token('TYPE_ID',-21);
1489: fnd_message.raise_error;
1490: --
1483: --
1484: -- raise error
1485: --
1486: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1487: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1488: fnd_message.set_token('TYPE_ID',-21);
1489: fnd_message.raise_error;
1490: --
1491: end if;
1484: -- raise error
1485: --
1486: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1487: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1488: fnd_message.set_token('TYPE_ID',-21);
1489: fnd_message.raise_error;
1490: --
1491: end if;
1492: --
1485: --
1486: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1487: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1488: fnd_message.set_token('TYPE_ID',-21);
1489: fnd_message.raise_error;
1490: --
1491: end if;
1492: --
1493: end if;
1555: p_effective_date => p_effective_date) then
1556: --
1557: -- raise error
1558: --
1559: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1560: fnd_message.set_token('ID',p_enrt_rl);
1561: fnd_message.set_token('TYPE_ID',-393);
1562: fnd_message.raise_error;
1563: --
1556: --
1557: -- raise error
1558: --
1559: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1560: fnd_message.set_token('ID',p_enrt_rl);
1561: fnd_message.set_token('TYPE_ID',-393);
1562: fnd_message.raise_error;
1563: --
1564: end if;
1557: -- raise error
1558: --
1559: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1560: fnd_message.set_token('ID',p_enrt_rl);
1561: fnd_message.set_token('TYPE_ID',-393);
1562: fnd_message.raise_error;
1563: --
1564: end if;
1565: --
1558: --
1559: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1560: fnd_message.set_token('ID',p_enrt_rl);
1561: fnd_message.set_token('TYPE_ID',-393);
1562: fnd_message.raise_error;
1563: --
1564: end if;
1565: --
1566: end if;
1603: hr_utility.set_location('Entering:'||l_proc, 5);
1604: --
1605: if (p_dflt_enrt_cd <> 'RL' and p_dflt_enrt_det_rl is not null)
1606: then
1607: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
1608: fnd_message.raise_error;
1609: end if;
1610: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null)
1611: then
1604: --
1605: if (p_dflt_enrt_cd <> 'RL' and p_dflt_enrt_det_rl is not null)
1606: then
1607: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
1608: fnd_message.raise_error;
1609: end if;
1610: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null)
1611: then
1612: fnd_message.set_name('BEN','BEN_91731_RULE');
1608: fnd_message.raise_error;
1609: end if;
1610: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null)
1611: then
1612: fnd_message.set_name('BEN','BEN_91731_RULE');
1613: fnd_message.raise_error;
1614: end if;
1615: --
1616: -- Leaving Procedure.
1609: end if;
1610: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null)
1611: then
1612: fnd_message.set_name('BEN','BEN_91731_RULE');
1613: fnd_message.raise_error;
1614: end if;
1615: --
1616: -- Leaving Procedure.
1617: --
1678: --
1679: -- raise an error as the Enrollment Method Code has a value of
1680: -- "automatic".
1681: --
1682: fnd_message.set_name('BEN','BEN_91967_AUTO_ENRT_AND_MTHD');
1683: fnd_message.raise_error;
1684: --
1685: end if;
1686: --
1679: -- raise an error as the Enrollment Method Code has a value of
1680: -- "automatic".
1681: --
1682: fnd_message.set_name('BEN','BEN_91967_AUTO_ENRT_AND_MTHD');
1683: fnd_message.raise_error;
1684: --
1685: end if;
1686: --
1687: close c1;
1732: --
1733: -- raise an error as the Mandatory Flag or Default Flag has a value
1734: -- of 'Y'.
1735: --
1736: fnd_message.set_name('BEN','BEN_91969_AUTO_ENRT_AND_FLAGS');
1737: fnd_message.raise_error;
1738: --
1739: --
1740: end if;
1733: -- raise an error as the Mandatory Flag or Default Flag has a value
1734: -- of 'Y'.
1735: --
1736: fnd_message.set_name('BEN','BEN_91969_AUTO_ENRT_AND_FLAGS');
1737: fnd_message.raise_error;
1738: --
1739: --
1740: end if;
1741: --
1813: close c1;
1814: --
1815: -- raise an error as there is no ben_pl_pcp row for the corresponding plan.
1816: --
1817: fnd_message.set_name('BEN','BEN_92592_NO_PL_PCP_ROW');
1818: fnd_message.raise_error;
1819: --
1820: end if;
1821: --
1814: --
1815: -- raise an error as there is no ben_pl_pcp row for the corresponding plan.
1816: --
1817: fnd_message.set_name('BEN','BEN_92592_NO_PL_PCP_ROW');
1818: fnd_message.raise_error;
1819: --
1820: end if;
1821: --
1822: close c1;
1897: close c1;
1898: --
1899: -- raise an error as this actl_prem_id has been assigned to plan(s).
1900: --
1901: fnd_message.set_name('BEN','BEN_91611_PLAN_OPTION_EXCL2');
1902: fnd_message.raise_error;
1903: --
1904: end if;
1905: --
1898: --
1899: -- raise an error as this actl_prem_id has been assigned to plan(s).
1900: --
1901: fnd_message.set_name('BEN','BEN_91611_PLAN_OPTION_EXCL2');
1902: fnd_message.raise_error;
1903: --
1904: end if;
1905: --
1906: close c1;
1999: close c1;
2000: --
2001: -- raise error as this beneficiary already exists for this enrt rslt
2002: --
2003: fnd_message.set_name('BEN','BEN_91845_DUP_OPT');
2004: fnd_message.raise_error;
2005: --
2006: end if;
2007: --
2000: --
2001: -- raise error as this beneficiary already exists for this enrt rslt
2002: --
2003: fnd_message.set_name('BEN','BEN_91845_DUP_OPT');
2004: fnd_message.raise_error;
2005: --
2006: end if;
2007: --
2008: close c1;
2086: close c1;
2087: --
2088: -- raise error as this ordr_num already exists for this Plans options
2089: --
2090: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
2091: fnd_message.raise_error;
2092: --
2093: end if;
2094: --
2087: --
2088: -- raise error as this ordr_num already exists for this Plans options
2089: --
2090: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
2091: fnd_message.raise_error;
2092: --
2093: end if;
2094: --
2095: close c1;
2954: close csr_leg_code;
2955: --
2956: -- The primary key is invalid therefore we must error
2957: --
2958: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2959: fnd_message.raise_error;
2960: --
2961: end if;
2962: --
2955: --
2956: -- The primary key is invalid therefore we must error
2957: --
2958: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2959: fnd_message.raise_error;
2960: --
2961: end if;
2962: --
2963: close csr_leg_code;