59: --
60: open c1;
61: fetch c1 into l_dummy;
62: if c1%found then
63: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
64: fnd_message.raise_error;
65: end if;
66: close c1;
67: --
60: open c1;
61: fetch c1 into l_dummy;
62: if c1%found then
63: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
64: fnd_message.raise_error;
65: end if;
66: close c1;
67: --
68: hr_utility.set_location('Leaving:'||l_proc, 15);
122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then
126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');
127: fnd_message.raise_error;
128: end if;
129: close c1;
130: hr_utility.set_location('Leaving:'||l_proc, 15);
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then
126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');
127: fnd_message.raise_error;
128: end if;
129: close c1;
130: hr_utility.set_location('Leaving:'||l_proc, 15);
131: End chk_duplicate_pl_id_in_pgm;
172: open c1;
173: fetch c1 into l_pl_cd;
174: close c1;
175: if l_pl_cd = 'MYNTBPGM' then
176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');
177: fnd_message.raise_error;
178: end if;
179: hr_utility.set_location('Leaving:'||l_proc, 15);
180: End chk_plan_allowed_in_pgm;
173: fetch c1 into l_pl_cd;
174: close c1;
175: if l_pl_cd = 'MYNTBPGM' then
176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');
177: fnd_message.raise_error;
178: end if;
179: hr_utility.set_location('Leaving:'||l_proc, 15);
180: End chk_plan_allowed_in_pgm;
181: --
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
215: then
216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
217: fnd_message.raise_error;
218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
213: --
214: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
215: then
216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
217: fnd_message.raise_error;
218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then
218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then
222: fnd_message.set_name('BEN','BEN_91731_RULE');
223: fnd_message.raise_error;
224: end if;
225: --
226: --leaving Procedure.
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then
222: fnd_message.set_name('BEN','BEN_91731_RULE');
223: fnd_message.raise_error;
224: end if;
225: --
226: --leaving Procedure.
227: --
379: close c1;
380: --
381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
380: --
381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;
381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;
389: --
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;
389: --
390: close c1;
475: close c1;
476: --
477: -- raise error
478: --
479: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
480: fnd_message.raise_error;
481: --
482: end if;
483: --
476: --
477: -- raise error
478: --
479: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
480: fnd_message.raise_error;
481: --
482: end if;
483: --
484: close c1;
524: p_effective_date => p_effective_date) then
525: --
526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
525: --
526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;
526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;
534: --
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;
534: --
535: end if;
574: p_effective_date => p_effective_date) then
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: end if;
626: p_effective_date => p_effective_date) then
627: --
628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
627: --
628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;
628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;
636: --
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;
636: --
637: end if;
723: close c1;
724: --
725: -- raise error
726: --
727: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
728: fnd_message.raise_error;
729: --
730: end if;
731: --
724: --
725: -- raise error
726: --
727: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
728: fnd_message.raise_error;
729: --
730: end if;
731: --
732: close c1;
817: close c1;
818: --
819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
818: --
819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;
819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;
827: --
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;
827: --
828: close c1;
913: close c1;
914: --
915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
914: --
915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;
915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;
923: --
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;
923: --
924: close c1;
1009: close c1;
1010: --
1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1010: --
1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;
1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --
1020: close c1;
1105: close c1;
1106: --
1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1106: --
1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;
1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;
1115: --
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;
1115: --
1116: close c1;
1178: p_effective_date => p_effective_date) then
1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91216_INV_DFLT_ENRT_MTHD');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91216_INV_DFLT_ENRT_MTHD');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1187: end if;
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('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
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('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
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('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
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('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1257: --
1258: end if;
1318: p_effective_date => p_effective_date) then
1319: --
1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1319: --
1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;
1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --
1329: end if;
1389: p_effective_date => p_effective_date) then
1390: --
1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1390: --
1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;
1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;
1399: --
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;
1399: --
1400: end if;
1460: p_effective_date => p_effective_date) then
1461: --
1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1461: --
1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;
1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;
1470: --
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;
1470: --
1471: end if;
1531: p_effective_date => p_effective_date) then
1532: --
1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1532: --
1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --
1542: end if;
1602: p_effective_date => p_effective_date) then
1603: --
1604: -- raise error as does not exist as lookup
1605: --
1606: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --
1603: --
1604: -- raise error as does not exist as lookup
1605: --
1606: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --
1611: end if;
1671: p_effective_date => p_effective_date) then
1672: --
1673: -- raise error as does not exist as lookup
1674: --
1675: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
1676: fnd_message.raise_error;
1677: --
1678: end if;
1679: --
1672: --
1673: -- raise error as does not exist as lookup
1674: --
1675: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
1676: fnd_message.raise_error;
1677: --
1678: end if;
1679: --
1680: end if;
1740: p_effective_date => p_effective_date) then
1741: --
1742: -- raise error as does not exist as lookup
1743: --
1744: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: --
1741: --
1742: -- raise error as does not exist as lookup
1743: --
1744: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: --
1749: end if;
1809: p_effective_date => p_effective_date) then
1810: --
1811: -- raise error as does not exist as lookup
1812: --
1813: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: --
1810: --
1811: -- raise error as does not exist as lookup
1812: --
1813: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: --
1818: end if;
1878: p_effective_date => p_effective_date) then
1879: --
1880: -- raise error as does not exist as lookup
1881: --
1882: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLAG');
1883: fnd_message.raise_error;
1884: --
1885: end if;
1886: --
1879: --
1880: -- raise error as does not exist as lookup
1881: --
1882: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLAG');
1883: fnd_message.raise_error;
1884: --
1885: end if;
1886: --
1887: end if;
1947: p_effective_date => p_effective_date) then
1948: --
1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1948: --
1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;
1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;
1957: --
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;
1957: --
1958: end if;
2018: p_effective_date => p_effective_date) then
2019: --
2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2019: --
2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;
2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;
2028: --
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;
2028: --
2029: end if;
2089: p_effective_date => p_effective_date) then
2090: --
2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2090: --
2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;
2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;
2099: --
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;
2099: --
2100: end if;
2160: p_effective_date => p_effective_date) then
2161: --
2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2161: --
2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;
2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;
2170: --
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;
2170: --
2171: end if;
2218: (p_no_mn_cvg_amt_apls_flag='N' and p_mn_cvg_amt=0)) then
2219: --
2220: -- raise error as is not a valid combination
2221: --
2222: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --
2219: --
2220: -- raise error as is not a valid combination
2221: --
2222: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --
2227: -- check if it is a valid combination
2230: (p_no_mx_cvg_amt_apls_flag='N' and p_mx_cvg_alwd_amt=0)) then
2231: --
2232: -- raise error as is not a valid combination
2233: --
2234: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2231: --
2232: -- raise error as is not a valid combination
2233: --
2234: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2239: hr_utility.set_location('Leaving:'||l_proc,10);
2278: --
2279: if p_mn_cvg_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2280: p_mn_cvg_rl is not null) then
2281: --
2282: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2283: fnd_message.raise_error;
2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2279: if p_mn_cvg_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2280: p_mn_cvg_rl is not null) then
2281: --
2282: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2283: fnd_message.raise_error;
2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --
2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --
2288: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2289: fnd_message.raise_error;
2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --
2288: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2289: fnd_message.raise_error;
2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --
2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --
2294: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --
2294: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2299: hr_utility.set_location('Leaving:'||l_proc,10);
2338: --
2339: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2340: p_mx_cvg_rl is not null) then
2341: --
2342: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2343: fnd_message.raise_error;
2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2339: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2340: p_mx_cvg_rl is not null) then
2341: --
2342: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2343: fnd_message.raise_error;
2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --
2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --
2348: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2349: fnd_message.raise_error;
2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --
2348: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2349: fnd_message.raise_error;
2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --
2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --
2354: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --
2354: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2359: hr_utility.set_location('Leaving:'||l_proc,10);
2433: if c1%found then
2434: if l_value = 'Y' and p_dflt_enrt_cd = 'A' then
2435: --
2436: close c1;
2437: fnd_message.set_name('BEN','BEN_91219_DFLT_ENRT_MTHD_DPNDC');
2438: fnd_message.raise_error;
2439: --
2440: end if;
2441: end if;
2434: if l_value = 'Y' and p_dflt_enrt_cd = 'A' then
2435: --
2436: close c1;
2437: fnd_message.set_name('BEN','BEN_91219_DFLT_ENRT_MTHD_DPNDC');
2438: fnd_message.raise_error;
2439: --
2440: end if;
2441: end if;
2442: close c1;
2533: p_dflt_enrt_det_rl is not null or
2534: p_dflt_flag = 'Y' ) then -- Bug 2717870
2535: --
2536: close c1;
2537: fnd_message.set_name('BEN','BEN_91224_DFLT_FLAG_DPNDCY');
2538: fnd_message.raise_error;
2539: --
2540: end if;
2541: end if;
2534: p_dflt_flag = 'Y' ) then -- Bug 2717870
2535: --
2536: close c1;
2537: fnd_message.set_name('BEN','BEN_91224_DFLT_FLAG_DPNDCY');
2538: fnd_message.raise_error;
2539: --
2540: end if;
2541: end if;
2542: close c1;
2604: -- check dependency
2605: --
2606: if p_dflt_flag = 'Y' and p_dflt_enrt_cd is null then
2607: --
2608: fnd_message.set_name('BEN','BEN_91221_DFLT_FLAG_DPNDCY2');
2609: fnd_message.raise_error;
2610: --
2611: end if;
2612: --
2605: --
2606: if p_dflt_flag = 'Y' and p_dflt_enrt_cd is null then
2607: --
2608: fnd_message.set_name('BEN','BEN_91221_DFLT_FLAG_DPNDCY2');
2609: fnd_message.raise_error;
2610: --
2611: end if;
2612: --
2613: end if;
2672: or not l_api_updating) then
2673: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then
2675: --
2676: fnd_message.set_name('BEN','BEN_91222_DFLT_ENRT_MTHD_CWOR');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2673: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then
2675: --
2676: fnd_message.set_name('BEN','BEN_91222_DFLT_ENRT_MTHD_CWOR');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2679: end if;
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2682: --
2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');
2684: fnd_message.raise_error;
2685: --
2686: end if;
2687: --
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2682: --
2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');
2684: fnd_message.raise_error;
2685: --
2686: end if;
2687: --
2688: end if;
2768: --
2769: -- Raise error as there is a different Plan with the Invoke
2770: -- Imputed Plan set to ON for this Program
2771: --
2772: fnd_message.set_name('BEN','BEN_91763_INVK_IMPTD_FLAG_PGM');
2773: fnd_message.raise_error;
2774: --
2775: --
2776: end if;
2769: -- Raise error as there is a different Plan with the Invoke
2770: -- Imputed Plan set to ON for this Program
2771: --
2772: fnd_message.set_name('BEN','BEN_91763_INVK_IMPTD_FLAG_PGM');
2773: fnd_message.raise_error;
2774: --
2775: --
2776: end if;
2777: end if;
2868: --
2869: -- Raise error as Flex plans can only be included into
2870: -- programs that are set up as Flex Credit Programs
2871: --
2872: fnd_message.set_name('BEN','BEN_93224_FLXCR_PL_NONFLX_PGM');
2873: fnd_message.raise_error;
2874: end if;
2875: --
2876: open count_plans;
2869: -- Raise error as Flex plans can only be included into
2870: -- programs that are set up as Flex Credit Programs
2871: --
2872: fnd_message.set_name('BEN','BEN_93224_FLXCR_PL_NONFLX_PGM');
2873: fnd_message.raise_error;
2874: end if;
2875: --
2876: open count_plans;
2877: fetch count_plans into l_count;
2880: --
2881: -- Raise error as there is a different Plan with the Flex
2882: -- Credit Plan set to ON for this Program
2883: --
2884: fnd_message.set_name('BEN','BEN_91764_INVK_FLXCR_FLAG_PGM_');
2885: fnd_message.raise_error;
2886: --
2887: --
2888: end if;
2881: -- Raise error as there is a different Plan with the Flex
2882: -- Credit Plan set to ON for this Program
2883: --
2884: fnd_message.set_name('BEN','BEN_91764_INVK_FLXCR_FLAG_PGM_');
2885: fnd_message.raise_error;
2886: --
2887: --
2888: end if;
2889: end if;
2971: close c1;
2972: --
2973: -- raise error
2974: --
2975: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');
2976: fnd_message.raise_error;
2977: --
2978: end if;
2979: --
2972: --
2973: -- raise error
2974: --
2975: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');
2976: fnd_message.raise_error;
2977: --
2978: end if;
2979: --
2980: close c1;
3064: close c1;
3065: --
3066: -- raise error
3067: --
3068: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
3069: fnd_message.raise_error;
3070: --
3071: end if;
3072: --
3065: --
3066: -- raise error
3067: --
3068: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
3069: fnd_message.raise_error;
3070: --
3071: end if;
3072: --
3073: close c1;
3136: p_effective_date => p_effective_date) then
3137: --
3138: -- raise error as does not exist as lookup
3139: --
3140: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3141: fnd_message.raise_error;
3142: --
3143: end if;
3144: end if;
3137: --
3138: -- raise error as does not exist as lookup
3139: --
3140: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3141: fnd_message.raise_error;
3142: --
3143: end if;
3144: end if;
3145: --
3207: p_effective_date => p_effective_date) then
3208: --
3209: -- raise error as does not exist as lookup
3210: --
3211: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3212: fnd_message.raise_error;
3213: --
3214: end if;
3215: end if;
3208: --
3209: -- raise error as does not exist as lookup
3210: --
3211: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3212: fnd_message.raise_error;
3213: --
3214: end if;
3215: end if;
3216: --
3299: close c1;
3300: --
3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3300: --
3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;
3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;
3309: --
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;
3309: --
3310: close c1;
3372: p_effective_date => p_effective_date) then
3373: --
3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3373: --
3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;
3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;
3382: --
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;
3382: --
3383: end if;
3465: close c1;
3466: --
3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3466: --
3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;
3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;
3475: --
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;
3475: --
3476: close c1;
3560: close c1;
3561: --
3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3561: --
3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;
3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;
3570: --
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;
3570: --
3571: close c1;
3633: p_effective_date => p_effective_date) then
3634: --
3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3634: --
3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;
3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;
3643: --
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;
3643: --
3644: end if;
3704: p_effective_date => p_effective_date) then
3705: --
3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3705: --
3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;
3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;
3714: --
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;
3714: --
3715: end if;
3774: p_effective_date => p_effective_date) then
3775: --
3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3775: --
3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;
3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;
3784: --
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;
3784: --
3785: end if;
3845: p_effective_date => p_effective_date) then
3846: --
3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3846: --
3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;
3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;
3855: --
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;
3855: --
3856: end if;
3917: p_effective_date => p_effective_date) then
3918: --
3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3918: --
3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;
3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;
3927: --
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;
3927: --
3928: end if;
3989: p_effective_date => p_effective_date) then
3990: --
3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3990: --
3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;
3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;
3999: --
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;
3999: --
4000: end if;
4076: if c1%found then
4077: --
4078: close c1;
4079: hr_utility.set_location(l_proc, 35);
4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
4081: fnd_message.raise_error;
4082: --
4083: else
4084: --
4077: --
4078: close c1;
4079: hr_utility.set_location(l_proc, 35);
4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
4081: fnd_message.raise_error;
4082: --
4083: else
4084: --
4085: close c1;
4182: if c1%found then
4183:
4184: close c1;
4185:
4186: fnd_message.set_name('BEN','BEN_94109_DELETE_PL_ID');
4187: fnd_message.raise_error;
4188:
4189: end if;
4190: close c1;
4183:
4184: close c1;
4185:
4186: fnd_message.set_name('BEN','BEN_94109_DELETE_PL_ID');
4187: fnd_message.raise_error;
4188:
4189: end if;
4190: close c1;
4191: hr_utility.set_location('Leaving:'||l_proc, 15);
4304: --
4305: -- An unhandled or unexpected error has occurred which
4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4305: -- An unhandled or unexpected error has occurred which
4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --
4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --
4314: -- ----------------------------------------------------------------------------
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --
4314: -- ----------------------------------------------------------------------------
4315: -- |--------------------------< dt_delete_validate >--------------------------|
4423: --
4424: -- An unhandled or unexpected error has occurred which
4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4424: -- An unhandled or unexpected error has occurred which
4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --
4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --
4433: -- ----------------------------------------------------------------------------
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --
4433: -- ----------------------------------------------------------------------------
4434: -- |---------------------------< insert_validate >----------------------------|
5279: close csr_leg_code;
5280: --
5281: -- The primary key is invalid therefore we must error
5282: --
5283: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
5284: fnd_message.raise_error;
5285: --
5286: end if;
5287: --
5280: --
5281: -- The primary key is invalid therefore we must error
5282: --
5283: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
5284: fnd_message.raise_error;
5285: --
5286: end if;
5287: --
5288: close csr_leg_code;