[Home] [Help]
186: --
187: -- Raise error : as there is plan associated with the plan type being updated - which
188: -- is also associated to iRecruitment Reporting Group
189: --
190: fnd_message.set_name('BEN','BEN_93921_PL_RPTG_GRP_IREC');
191: fnd_message.raise_error;
192: --
193: end if;
194: --
187: -- Raise error : as there is plan associated with the plan type being updated - which
188: -- is also associated to iRecruitment Reporting Group
189: --
190: fnd_message.set_name('BEN','BEN_93921_PL_RPTG_GRP_IREC');
191: fnd_message.raise_error;
192: --
193: end if;
194: --
195: close c1;
242: fetch c1 into l_dummy;
243: if c1%found then
244: --
245: close c1;
246: fnd_message.set_name('BEN','BEN_94621_CMPR_CLMS_CD');
247: fnd_message.raise_error;
248: --
249: end if;
250: close c1;
243: if c1%found then
244: --
245: close c1;
246: fnd_message.set_name('BEN','BEN_94621_CMPR_CLMS_CD');
247: fnd_message.raise_error;
248: --
249: end if;
250: close c1;
251: end if;
297: open c_child_exist ;
298: fetch c_child_exist into l_dummy ;
299: if c_child_exist%found then
300: close c_child_exist ;
301: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
302: fnd_message.set_token('NAME', p_name); /* Bug 4057566 */
303: fnd_message.raise_error;
304: end if ;
305: close c_child_exist ;
298: fetch c_child_exist into l_dummy ;
299: if c_child_exist%found then
300: close c_child_exist ;
301: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
302: fnd_message.set_token('NAME', p_name); /* Bug 4057566 */
303: fnd_message.raise_error;
304: end if ;
305: close c_child_exist ;
306: end if ;
299: if c_child_exist%found then
300: close c_child_exist ;
301: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
302: fnd_message.set_token('NAME', p_name); /* Bug 4057566 */
303: fnd_message.raise_error;
304: end if ;
305: close c_child_exist ;
306: end if ;
307: --
355: fetch c_pl_cwb into l_opt_typ_cd ;
356: if c_pl_cwb%found then
357: if p_group_pl_id is null then
358: close c_pl_cwb ;
359: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
360: fnd_message.raise_error;
361: end if ;
362: end if ;
363: close c_pl_cwb ;
356: if c_pl_cwb%found then
357: if p_group_pl_id is null then
358: close c_pl_cwb ;
359: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
360: fnd_message.raise_error;
361: end if ;
362: end if ;
363: close c_pl_cwb ;
364:
367: open c_pl_cwb ;
368: fetch c_pl_cwb into l_opt_typ_cd ;
369: if c_pl_cwb%notfound then
370: close c_pl_cwb ;
371: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
372: fnd_message.raise_error;
373: end if ;
374: close c_pl_cwb ;
375:
368: fetch c_pl_cwb into l_opt_typ_cd ;
369: if c_pl_cwb%notfound then
370: close c_pl_cwb ;
371: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
372: fnd_message.raise_error;
373: end if ;
374: close c_pl_cwb ;
375:
376: -- when the plan is child check the parent is real parent
378: open c_parent_pl ;
379: fetch c_parent_pl into l_dummy ;
380: if c_parent_pl%notfound then
381: close c_parent_pl ;
382: fnd_message.set_name('BEN','BEN_93726_CWB_PRTN_PLN_ERROR');
383: fnd_message.raise_error;
384: end if ;
385: close c_parent_pl ;
386:
379: fetch c_parent_pl into l_dummy ;
380: if c_parent_pl%notfound then
381: close c_parent_pl ;
382: fnd_message.set_name('BEN','BEN_93726_CWB_PRTN_PLN_ERROR');
383: fnd_message.raise_error;
384: end if ;
385: close c_parent_pl ;
386:
387: chk_pl_group_child(p_pl_id => p_pl_id ,
474: close c1;
475: --
476: -- raise an error as this plan name has already been used
477: --
478: fnd_message.set_name('BEN','BEN_93570_PDW_PLAN_NAME_UNIQ');
479: fnd_message.raise_error;
480: --
481: end if;
482: --
475: --
476: -- raise an error as this plan name has already been used
477: --
478: fnd_message.set_name('BEN','BEN_93570_PDW_PLAN_NAME_UNIQ');
479: fnd_message.raise_error;
480: --
481: end if;
482: --
483: close c1;
533: -- "automatic".
534:
535: close c1;
536: --
537: fnd_message.set_name('BEN','BEN_91967_AUTO_ENRT_AND_MTHD');
538: fnd_message.raise_error;
539: --
540: else
541: --
534:
535: close c1;
536: --
537: fnd_message.set_name('BEN','BEN_91967_AUTO_ENRT_AND_MTHD');
538: fnd_message.raise_error;
539: --
540: else
541: --
542: close c1;
598: if c_epe_exist%found then
599: --
600: close c_epe_exist;
601: --
602: fnd_message.set_name('BEN','BEN_91024_PEP_EXISTS');
603: fnd_message.raise_error;
604: --
605: else
606: --
599: --
600: close c_epe_exist;
601: --
602: fnd_message.set_name('BEN','BEN_91024_PEP_EXISTS');
603: fnd_message.raise_error;
604: --
605: else
606: --
607: close c_epe_exist;
716: --
717: close c1;
718: close c2;
719: --
720: fnd_message.set_name('BEN','BEN_93905_GRP_PLN_NAME_UNIQUE');
721: fnd_message.raise_error;
722: --
723: end if;
724: close c2;
717: close c1;
718: close c2;
719: --
720: fnd_message.set_name('BEN','BEN_93905_GRP_PLN_NAME_UNIQUE');
721: fnd_message.raise_error;
722: --
723: end if;
724: close c2;
725: --
731: --
732: close c1;
733: close c3;
734: --
735: fnd_message.set_name('BEN','BEN_93905_GRP_PLN_NAME_UNIQUE');
736: fnd_message.raise_error;
737: --
738: --
739: end if;
732: close c1;
733: close c3;
734: --
735: fnd_message.set_name('BEN','BEN_93905_GRP_PLN_NAME_UNIQUE');
736: fnd_message.raise_error;
737: --
738: --
739: end if;
740: close c3;
793: --
794: -- raise an error as this measures amount code only allows percent
795: -- increments
796: --
797: fnd_message.set_name('BEN','BEN_91617_INCR_AMT_NOT_ALWD');
798: fnd_message.raise_error;
799: --
800: --
801: end if;
794: -- raise an error as this measures amount code only allows percent
795: -- increments
796: --
797: fnd_message.set_name('BEN','BEN_91617_INCR_AMT_NOT_ALWD');
798: fnd_message.raise_error;
799: --
800: --
801: end if;
802: --
805: --
806: -- raise an error as this measures amount code only allows percent
807: -- increments
808: --
809: fnd_message.set_name('BEN','BEN_91617_INCR_AMT_NOT_ALWD');
810: fnd_message.raise_error;
811: --
812: end if;
813: --
806: -- raise an error as this measures amount code only allows percent
807: -- increments
808: --
809: fnd_message.set_name('BEN','BEN_91617_INCR_AMT_NOT_ALWD');
810: fnd_message.raise_error;
811: --
812: end if;
813: --
814: hr_utility.set_location('Leaving:'||l_proc, 10);
884: if c1%found then
885: --
886: close c1;
887: hr_utility.set_location('Inside :'||l_proc, 8);
888: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
889: fnd_message.raise_error;
890: --
891: else
892: --
885: --
886: close c1;
887: hr_utility.set_location('Inside :'||l_proc, 8);
888: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
889: fnd_message.raise_error;
890: --
891: else
892: --
893: close c1;
941: --
942: hr_utility.set_location('Entering:'||l_proc, 5);
943: --
944: if p_flag = 'Y' and p_val is not null then
945: fnd_message.set_name('BEN', p_msg);
946: fnd_message.raise_error;
947: end if;
948: --
949: hr_utility.set_location('Leaving:'||l_proc,10);
942: hr_utility.set_location('Entering:'||l_proc, 5);
943: --
944: if p_flag = 'Y' and p_val is not null then
945: fnd_message.set_name('BEN', p_msg);
946: fnd_message.raise_error;
947: end if;
948: --
949: hr_utility.set_location('Leaving:'||l_proc,10);
950: --
986: hr_utility.set_location('Entering:'||l_proc, 5);
987: --
988: if p_code <> 'RL' and p_rule is not null then
989: --
990: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
991: fnd_message.raise_error;
992: --
993: elsif p_code = 'RL' and p_rule is null then
994: --
987: --
988: if p_code <> 'RL' and p_rule is not null then
989: --
990: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
991: fnd_message.raise_error;
992: --
993: elsif p_code = 'RL' and p_rule is null then
994: --
995: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
991: fnd_message.raise_error;
992: --
993: elsif p_code = 'RL' and p_rule is null then
994: --
995: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
996: fnd_message.raise_error;
997: --
998: end if;
999: --
992: --
993: elsif p_code = 'RL' and p_rule is null then
994: --
995: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
996: fnd_message.raise_error;
997: --
998: end if;
999: --
1000: hr_utility.set_location('Leaving:'||l_proc,10);
1039: --
1040: if p_mn_cvg_rqd_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1041: p_mn_cvg_rl is not null) then
1042: --
1043: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1044: fnd_message.raise_error;
1045: --
1046: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1047: p_mn_cvg_rqd_amt is not null) then
1040: if p_mn_cvg_rqd_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1041: p_mn_cvg_rl is not null) then
1042: --
1043: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1044: fnd_message.raise_error;
1045: --
1046: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1047: p_mn_cvg_rqd_amt is not null) then
1048: --
1045: --
1046: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1047: p_mn_cvg_rqd_amt is not null) then
1048: --
1049: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1050: fnd_message.raise_error;
1051: --
1052: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_rqd_amt is not null or
1053: p_mn_cvg_rl is not null) then
1046: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
1047: p_mn_cvg_rqd_amt is not null) then
1048: --
1049: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1050: fnd_message.raise_error;
1051: --
1052: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_rqd_amt is not null or
1053: p_mn_cvg_rl is not null) then
1054: --
1051: --
1052: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_rqd_amt is not null or
1053: p_mn_cvg_rl is not null) then
1054: --
1055: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1056: fnd_message.raise_error;
1057: --
1058: end if;
1059: --
1052: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_rqd_amt is not null or
1053: p_mn_cvg_rl is not null) then
1054: --
1055: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
1056: fnd_message.raise_error;
1057: --
1058: end if;
1059: --
1060: hr_utility.set_location('Leaving:'||l_proc,10);
1100: p_effective_date => p_effective_date) then
1101: --
1102: -- raise error
1103:
1104: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1105: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1106: fnd_message.set_token('TYPE_ID',-21);
1107: fnd_message.raise_error;
1108: --
1101: --
1102: -- raise error
1103:
1104: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1105: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1106: fnd_message.set_token('TYPE_ID',-21);
1107: fnd_message.raise_error;
1108: --
1109: end if;
1102: -- raise error
1103:
1104: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1105: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1106: fnd_message.set_token('TYPE_ID',-21);
1107: fnd_message.raise_error;
1108: --
1109: end if;
1110: --
1103:
1104: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1105: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
1106: fnd_message.set_token('TYPE_ID',-21);
1107: fnd_message.raise_error;
1108: --
1109: end if;
1110: --
1111: end if;
1156: --
1157: if (p_dpnt_dsgn_cd is not null) and
1158: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
1159:
1160: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
1161: fnd_message.raise_error;
1162: end if;
1163: --
1164:
1157: if (p_dpnt_dsgn_cd is not null) and
1158: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
1159:
1160: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
1161: fnd_message.raise_error;
1162: end if;
1163: --
1164:
1165: if (p_dpnt_dsgn_cd is null) and
1163: --
1164:
1165: if (p_dpnt_dsgn_cd is null) and
1166: (p_dpnt_cvg_strt_dt_cd is not null or p_dpnt_cvg_end_dt_cd is not null) then
1167: fnd_message.set_name('BEN','BEN_91375_PGM_DPNT_DSGN_RQD');
1168: fnd_message.raise_error;
1169: end if;
1170:
1171: --
1164:
1165: if (p_dpnt_dsgn_cd is null) and
1166: (p_dpnt_cvg_strt_dt_cd is not null or p_dpnt_cvg_end_dt_cd is not null) then
1167: fnd_message.set_name('BEN','BEN_91375_PGM_DPNT_DSGN_RQD');
1168: fnd_message.raise_error;
1169: end if;
1170:
1171: --
1172: hr_utility.set_location('Leaving:'||l_proc,10);
1209: p_effective_date => p_effective_date) then
1210: --
1211: -- raise error as does not exist as lookup
1212: --
1213: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1214: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
1215: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
1216: fnd_message.raise_error;
1217: --
1210: --
1211: -- raise error as does not exist as lookup
1212: --
1213: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1214: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
1215: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
1216: fnd_message.raise_error;
1217: --
1218: end if;
1211: -- raise error as does not exist as lookup
1212: --
1213: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1214: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
1215: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
1216: fnd_message.raise_error;
1217: --
1218: end if;
1219: --
1212: --
1213: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1214: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
1215: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
1216: fnd_message.raise_error;
1217: --
1218: end if;
1219: --
1220: end if;
1257: p_effective_date => p_effective_date) then
1258: --
1259: -- raise error as does not exist as lookup
1260: --
1261: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1262: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
1263: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
1264: fnd_message.raise_error;
1265: --
1258: --
1259: -- raise error as does not exist as lookup
1260: --
1261: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1262: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
1263: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
1264: fnd_message.raise_error;
1265: --
1266: end if ;
1259: -- raise error as does not exist as lookup
1260: --
1261: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1262: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
1263: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
1264: fnd_message.raise_error;
1265: --
1266: end if ;
1267: --
1260: --
1261: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1262: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
1263: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
1264: fnd_message.raise_error;
1265: --
1266: end if ;
1267: --
1268: end if;
1267: --
1268: end if;
1269: --
1270: if p_use_csd_rsd_prccng_cd is not null and p_pl_cd <> 'MYNTBPGM' then
1271: fnd_message.set_name('BEN','BEN_93948_CSD_RSD_PLIP');
1272: fnd_message.raise_error;
1273: end if ;
1274:
1275: hr_utility.set_location('Leaving:'||l_proc,10);
1268: end if;
1269: --
1270: if p_use_csd_rsd_prccng_cd is not null and p_pl_cd <> 'MYNTBPGM' then
1271: fnd_message.set_name('BEN','BEN_93948_CSD_RSD_PLIP');
1272: fnd_message.raise_error;
1273: end if ;
1274:
1275: hr_utility.set_location('Leaving:'||l_proc,10);
1276: --
1374: fetch c1 into l_dummy;
1375: if c1%found then
1376: --
1377: close c1;
1378: fnd_message.set_name('BEN','BEN_92524_DELETE_LDC2');
1379: fnd_message.raise_error;
1380: --
1381: else
1382: close c1;
1375: if c1%found then
1376: --
1377: close c1;
1378: fnd_message.set_name('BEN','BEN_92524_DELETE_LDC2');
1379: fnd_message.raise_error;
1380: --
1381: else
1382: close c1;
1383: end if;
1391: fetch c2 into l_dummy;
1392: if c2%found then
1393: --
1394: close c2;
1395: fnd_message.set_name('BEN','BEN_92523_DELETE_ADE2');
1396: fnd_message.raise_error;
1397: --
1398: else
1399: close c2;
1392: if c2%found then
1393: --
1394: close c2;
1395: fnd_message.set_name('BEN','BEN_92523_DELETE_ADE2');
1396: fnd_message.raise_error;
1397: --
1398: else
1399: close c2;
1400: end if;
1408: fetch c3 into l_dummy;
1409: if c3%found then
1410: --
1411: close c3;
1412: fnd_message.set_name('BEN','BEN_92522_DELETE_PND');
1413: fnd_message.raise_error;
1414: --
1415: else
1416: close c3;
1409: if c3%found then
1410: --
1411: close c3;
1412: fnd_message.set_name('BEN','BEN_92522_DELETE_PND');
1413: fnd_message.raise_error;
1414: --
1415: else
1416: close c3;
1417: end if;
1425: fetch c4 into l_dummy;
1426: if c4%found then
1427: --
1428: close c4;
1429: fnd_message.set_name('BEN','BEN_92525_DELETE_PCX');
1430: fnd_message.raise_error;
1431: --
1432: else
1433: close c4;
1426: if c4%found then
1427: --
1428: close c4;
1429: fnd_message.set_name('BEN','BEN_92525_DELETE_PCX');
1430: fnd_message.raise_error;
1431: --
1432: else
1433: close c4;
1434: end if;
1479: --
1480: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1481: p_mx_cvg_rl is not null) then
1482: --
1483: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1484: fnd_message.raise_error;
1485: --
1486: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1487: p_mx_cvg_alwd_amt is not null) then
1480: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1481: p_mx_cvg_rl is not null) then
1482: --
1483: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1484: fnd_message.raise_error;
1485: --
1486: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1487: p_mx_cvg_alwd_amt is not null) then
1488: --
1485: --
1486: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1487: p_mx_cvg_alwd_amt is not null) then
1488: --
1489: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1490: fnd_message.raise_error;
1491: --
1492: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
1493: p_mx_cvg_rl is not null) then
1486: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
1487: p_mx_cvg_alwd_amt is not null) then
1488: --
1489: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1490: fnd_message.raise_error;
1491: --
1492: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
1493: p_mx_cvg_rl is not null) then
1494: --
1491: --
1492: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
1493: p_mx_cvg_rl is not null) then
1494: --
1495: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1496: fnd_message.raise_error;
1497: --
1498: end if;
1499: --
1492: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
1493: p_mx_cvg_rl is not null) then
1494: --
1495: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
1496: fnd_message.raise_error;
1497: --
1498: end if;
1499: --
1500: hr_utility.set_location('Leaving:'||l_proc,10);
1572: p_invk_dcln_prtn_pl_flag = 'Y')) then
1573: --
1574: -- OK flags are not mutaully exclusive so raise an error
1575: --
1576: fnd_message.set_name('BEN','BEN_93882_PLN_FLGS_MUTUAL_EXCL'); --Bug 3424424
1577: fnd_message.raise_error;
1578: --
1579: end if;
1580: --
1573: --
1574: -- OK flags are not mutaully exclusive so raise an error
1575: --
1576: fnd_message.set_name('BEN','BEN_93882_PLN_FLGS_MUTUAL_EXCL'); --Bug 3424424
1577: fnd_message.raise_error;
1578: --
1579: end if;
1580: --
1581: end if;
1637: p_mx_wtg_perd_prte_uom is not null)) then
1638: --
1639: -- OK fields are not mutaully exclusive so raise an error
1640: --
1641: fnd_message.set_name('PAY','PLN_RULE_NUM_MUTUAL_EXCLUSIVE');
1642: fnd_message.raise_error;
1643: --
1644: end if;
1645: --
1638: --
1639: -- OK fields are not mutaully exclusive so raise an error
1640: --
1641: fnd_message.set_name('PAY','PLN_RULE_NUM_MUTUAL_EXCLUSIVE');
1642: fnd_message.raise_error;
1643: --
1644: end if;
1645: --
1646: hr_utility.set_location('Leaving:'||l_proc, 10);
1790: p_effective_date => p_effective_date) then
1791: --
1792: -- raise error as does not exist as lookup
1793: --
1794: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1795: fnd_message.raise_error;
1796: --
1797: end if;
1798: --
1791: --
1792: -- raise error as does not exist as lookup
1793: --
1794: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1795: fnd_message.raise_error;
1796: --
1797: end if;
1798: --
1799: end if;
1812: p_effective_date => p_effective_date) then
1813: --
1814: -- raise error as does not exist as lookup
1815: --
1816: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1817: fnd_message.raise_error;
1818: --
1819: end if;
1820: --
1813: --
1814: -- raise error as does not exist as lookup
1815: --
1816: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1817: fnd_message.raise_error;
1818: --
1819: end if;
1820: --
1821: end if;
1834: p_effective_date => p_effective_date) then
1835: --
1836: -- raise error as does not exist as lookup
1837: --
1838: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1839: fnd_message.raise_error;
1840: --
1841: end if;
1842: --
1835: --
1836: -- raise error as does not exist as lookup
1837: --
1838: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1839: fnd_message.raise_error;
1840: --
1841: end if;
1842: --
1843: end if;
1856: p_effective_date => p_effective_date) then
1857: --
1858: -- raise error as does not exist as lookup
1859: --
1860: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1861: fnd_message.raise_error;
1862: --
1863: end if;
1864: --
1857: --
1858: -- raise error as does not exist as lookup
1859: --
1860: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1861: fnd_message.raise_error;
1862: --
1863: end if;
1864: --
1865: 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('PAY','HR_LOOKUP_DOES_NOT_EXIST');
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('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1883: fnd_message.raise_error;
1884: --
1885: end if;
1886: --
1887: end if;
1900: p_effective_date => p_effective_date) then
1901: --
1902: -- raise error as does not exist as lookup
1903: --
1904: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1905: fnd_message.raise_error;
1906: --
1907: end if;
1908: --
1901: --
1902: -- raise error as does not exist as lookup
1903: --
1904: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1905: fnd_message.raise_error;
1906: --
1907: end if;
1908: --
1909: end if;
1922: p_effective_date => p_effective_date) then
1923: --
1924: -- raise error as does not exist as lookup
1925: --
1926: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1927: fnd_message.raise_error;
1928: --
1929: end if;
1930: --
1923: --
1924: -- raise error as does not exist as lookup
1925: --
1926: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1927: fnd_message.raise_error;
1928: --
1929: end if;
1930: --
1931: end if;
1944: p_effective_date => p_effective_date) then
1945: --
1946: -- raise error as does not exist as lookup
1947: --
1948: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1949: fnd_message.raise_error;
1950: --
1951: end if;
1952: --
1945: --
1946: -- raise error as does not exist as lookup
1947: --
1948: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1949: fnd_message.raise_error;
1950: --
1951: end if;
1952: --
1953: end if;
1966: p_effective_date => p_effective_date) then
1967: --
1968: -- raise error as does not exist as lookup
1969: --
1970: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1971: fnd_message.raise_error;
1972: --
1973: end if;
1974: --
1967: --
1968: -- raise error as does not exist as lookup
1969: --
1970: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1971: fnd_message.raise_error;
1972: --
1973: end if;
1974: --
1975: end if;
1988: p_effective_date => p_effective_date) then
1989: --
1990: -- raise error as does not exist as lookup
1991: --
1992: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1993: fnd_message.raise_error;
1994: --
1995: end if;
1996: --
1989: --
1990: -- raise error as does not exist as lookup
1991: --
1992: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1993: fnd_message.raise_error;
1994: --
1995: end if;
1996: --
1997: end if;
2010: p_effective_date => p_effective_date) then
2011: --
2012: -- raise error as does not exist as lookup
2013: --
2014: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2015: fnd_message.raise_error;
2016: --
2017: end if;
2018: --
2011: --
2012: -- raise error as does not exist as lookup
2013: --
2014: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2015: fnd_message.raise_error;
2016: --
2017: end if;
2018: --
2019: end if;
2032: p_effective_date => p_effective_date) then
2033: --
2034: -- raise error as does not exist as lookup
2035: --
2036: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2037: fnd_message.raise_error;
2038: --
2039: end if;
2040: --
2033: --
2034: -- raise error as does not exist as lookup
2035: --
2036: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2037: fnd_message.raise_error;
2038: --
2039: end if;
2040: --
2041: end if;
2054: p_effective_date => p_effective_date) then
2055: --
2056: -- raise error as does not exist as lookup
2057: --
2058: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2059: fnd_message.raise_error;
2060: --
2061: end if;
2062: --
2055: --
2056: -- raise error as does not exist as lookup
2057: --
2058: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2059: fnd_message.raise_error;
2060: --
2061: end if;
2062: --
2063: end if;
2076: p_effective_date => p_effective_date) then
2077: --
2078: -- raise error as does not exist as lookup
2079: --
2080: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2081: fnd_message.raise_error;
2082: --
2083: end if;
2084: --
2077: --
2078: -- raise error as does not exist as lookup
2079: --
2080: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2081: fnd_message.raise_error;
2082: --
2083: end if;
2084: --
2085: end if;
2098: p_effective_date => p_effective_date) then
2099: --
2100: -- raise error as does not exist as lookup
2101: --
2102: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2103: fnd_message.raise_error;
2104: --
2105: end if;
2106: --
2099: --
2100: -- raise error as does not exist as lookup
2101: --
2102: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2103: fnd_message.raise_error;
2104: --
2105: end if;
2106: --
2107: end if;
2120: p_effective_date => p_effective_date) then
2121: --
2122: -- raise error as does not exist as lookup
2123: --
2124: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2125: fnd_message.raise_error;
2126: --
2127: end if;
2128: --
2121: --
2122: -- raise error as does not exist as lookup
2123: --
2124: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2125: fnd_message.raise_error;
2126: --
2127: end if;
2128: --
2129: end if;
2142: p_effective_date => p_effective_date) then
2143: --
2144: -- raise error as does not exist as lookup
2145: --
2146: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2147: fnd_message.raise_error;
2148: --
2149: end if;
2150: --
2143: --
2144: -- raise error as does not exist as lookup
2145: --
2146: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2147: fnd_message.raise_error;
2148: --
2149: end if;
2150: --
2151: end if;
2164: p_effective_date => p_effective_date) then
2165: --
2166: -- raise error as does not exist as lookup
2167: --
2168: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2169: fnd_message.raise_error;
2170: --
2171: end if;
2172: --
2165: --
2166: -- raise error as does not exist as lookup
2167: --
2168: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2169: fnd_message.raise_error;
2170: --
2171: end if;
2172: --
2173: end if;
2186: p_effective_date => p_effective_date) then
2187: --
2188: -- raise error as does not exist as lookup
2189: --
2190: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2191: fnd_message.raise_error;
2192: --
2193: end if;
2194: --
2187: --
2188: -- raise error as does not exist as lookup
2189: --
2190: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2191: fnd_message.raise_error;
2192: --
2193: end if;
2194: --
2195: end if;
2208: p_effective_date => p_effective_date) then
2209: --
2210: -- raise error as does not exist as lookup
2211: --
2212: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2213: fnd_message.raise_error;
2214: --
2215: end if;
2216: --
2209: --
2210: -- raise error as does not exist as lookup
2211: --
2212: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2213: fnd_message.raise_error;
2214: --
2215: end if;
2216: --
2217: end if;
2230: p_effective_date => p_effective_date) then
2231: --
2232: -- raise error as does not exist as lookup
2233: --
2234: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2231: --
2232: -- raise error as does not exist as lookup
2233: --
2234: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2239: end if;
2252: p_effective_date => p_effective_date) then
2253: --
2254: -- raise error as does not exist as lookup
2255: --
2256: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2257: fnd_message.raise_error;
2258: --
2259: end if;
2260: --
2253: --
2254: -- raise error as does not exist as lookup
2255: --
2256: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2257: fnd_message.raise_error;
2258: --
2259: end if;
2260: --
2261: end if;
2274: p_effective_date => p_effective_date) then
2275: --
2276: -- raise error as does not exist as lookup
2277: --
2278: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2279: fnd_message.raise_error;
2280: --
2281: end if;
2282: --
2275: --
2276: -- raise error as does not exist as lookup
2277: --
2278: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2279: fnd_message.raise_error;
2280: --
2281: end if;
2282: --
2283: end if;
2296: p_effective_date => p_effective_date) then
2297: --
2298: -- raise error as does not exist as lookup
2299: --
2300: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2301: fnd_message.raise_error;
2302: --
2303: end if;
2304: --
2297: --
2298: -- raise error as does not exist as lookup
2299: --
2300: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2301: fnd_message.raise_error;
2302: --
2303: end if;
2304: --
2305: end if;
2318: p_effective_date => p_effective_date) then
2319: --
2320: -- raise error as does not exist as lookup
2321: --
2322: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2323: fnd_message.raise_error;
2324: --
2325: end if;
2326: --
2319: --
2320: -- raise error as does not exist as lookup
2321: --
2322: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2323: fnd_message.raise_error;
2324: --
2325: end if;
2326: --
2327: end if;
2340: p_effective_date => p_effective_date) then
2341: --
2342: -- raise error as does not exist as lookup
2343: --
2344: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2345: fnd_message.raise_error;
2346: --
2347: end if;
2348: --
2341: --
2342: -- raise error as does not exist as lookup
2343: --
2344: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2345: fnd_message.raise_error;
2346: --
2347: end if;
2348: --
2349: end if;
2362: p_effective_date => p_effective_date) then
2363: --
2364: -- raise error as does not exist as lookup
2365: --
2366: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2367: fnd_message.raise_error;
2368: --
2369: end if;
2370: --
2363: --
2364: -- raise error as does not exist as lookup
2365: --
2366: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2367: fnd_message.raise_error;
2368: --
2369: end if;
2370: --
2371: end if;
2384: p_effective_date => p_effective_date) then
2385: --
2386: -- raise error as does not exist as lookup
2387: --
2388: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2389: fnd_message.raise_error;
2390: --
2391: end if;
2392: --
2385: --
2386: -- raise error as does not exist as lookup
2387: --
2388: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2389: fnd_message.raise_error;
2390: --
2391: end if;
2392: --
2393: end if;
2406: p_effective_date => p_effective_date) then
2407: --
2408: -- raise error as does not exist as lookup
2409: --
2410: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2411: fnd_message.raise_error;
2412: --
2413: end if;
2414: --
2407: --
2408: -- raise error as does not exist as lookup
2409: --
2410: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2411: fnd_message.raise_error;
2412: --
2413: end if;
2414: --
2415: end if;
2428: p_effective_date => p_effective_date) then
2429: --
2430: -- raise error as does not exist as lookup
2431: --
2432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2433: fnd_message.raise_error;
2434: --
2435: end if;
2436: --
2429: --
2430: -- raise error as does not exist as lookup
2431: --
2432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2433: fnd_message.raise_error;
2434: --
2435: end if;
2436: --
2437: end if;
2450: p_effective_date => p_effective_date) then
2451: --
2452: -- raise error as does not exist as lookup
2453: --
2454: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2455: fnd_message.raise_error;
2456: --
2457: end if;
2458: --
2451: --
2452: -- raise error as does not exist as lookup
2453: --
2454: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2455: fnd_message.raise_error;
2456: --
2457: end if;
2458: --
2459: end if;
2472: p_effective_date => p_effective_date) then
2473: --
2474: -- raise error as does not exist as lookup
2475: --
2476: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2477: fnd_message.raise_error;
2478: --
2479: end if;
2480: --
2473: --
2474: -- raise error as does not exist as lookup
2475: --
2476: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2477: fnd_message.raise_error;
2478: --
2479: end if;
2480: --
2481: end if;
2494: p_effective_date => p_effective_date) then
2495: --
2496: -- raise error as does not exist as lookup
2497: --
2498: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2499: fnd_message.raise_error;
2500: --
2501: end if;
2502: --
2495: --
2496: -- raise error as does not exist as lookup
2497: --
2498: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2499: fnd_message.raise_error;
2500: --
2501: end if;
2502: --
2503: end if;
2516: p_effective_date => p_effective_date) then
2517: --
2518: -- raise error as does not exist as lookup
2519: --
2520: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2521: fnd_message.raise_error;
2522: --
2523: end if;
2524: --
2517: --
2518: -- raise error as does not exist as lookup
2519: --
2520: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2521: fnd_message.raise_error;
2522: --
2523: end if;
2524: --
2525: end if;
2538: p_effective_date => p_effective_date) then
2539: --
2540: -- raise error as does not exist as lookup
2541: --
2542: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2543: fnd_message.raise_error;
2544: --
2545: end if;
2546: --
2539: --
2540: -- raise error as does not exist as lookup
2541: --
2542: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2543: fnd_message.raise_error;
2544: --
2545: end if;
2546: --
2547: end if;
2560: p_effective_date => p_effective_date) then
2561: --
2562: -- raise error as does not exist as lookup
2563: --
2564: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2565: fnd_message.raise_error;
2566: --
2567: end if;
2568: --
2561: --
2562: -- raise error as does not exist as lookup
2563: --
2564: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2565: fnd_message.raise_error;
2566: --
2567: end if;
2568: --
2569: end if;
2582: p_effective_date => p_effective_date) then
2583: --
2584: -- raise error as does not exist as lookup
2585: --
2586: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
2587: fnd_message.set_token('FIELD', 'p_subj_to_imptd_incm_typ_cd');
2588: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
2589: fnd_message.raise_error;
2590: --
2583: --
2584: -- raise error as does not exist as lookup
2585: --
2586: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
2587: fnd_message.set_token('FIELD', 'p_subj_to_imptd_incm_typ_cd');
2588: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
2589: fnd_message.raise_error;
2590: --
2591: end if;
2584: -- raise error as does not exist as lookup
2585: --
2586: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
2587: fnd_message.set_token('FIELD', 'p_subj_to_imptd_incm_typ_cd');
2588: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
2589: fnd_message.raise_error;
2590: --
2591: end if;
2592: --
2585: --
2586: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
2587: fnd_message.set_token('FIELD', 'p_subj_to_imptd_incm_typ_cd');
2588: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
2589: fnd_message.raise_error;
2590: --
2591: end if;
2592: --
2593: end if;
2606: p_effective_date => p_effective_date) then
2607: --
2608: -- raise error as does not exist as lookup
2609: --
2610: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2611: fnd_message.raise_error;
2612: --
2613: end if;
2614: --
2607: --
2608: -- raise error as does not exist as lookup
2609: --
2610: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2611: fnd_message.raise_error;
2612: --
2613: end if;
2614: --
2615: end if;
2628: p_effective_date => p_effective_date) then
2629: --
2630: -- raise error as does not exist as lookup
2631: --
2632: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2633: fnd_message.raise_error;
2634: --
2635: end if;
2636: --
2629: --
2630: -- raise error as does not exist as lookup
2631: --
2632: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2633: fnd_message.raise_error;
2634: --
2635: end if;
2636: --
2637: end if;
2650: p_effective_date => p_effective_date) then
2651: --
2652: -- raise error as does not exist as lookup
2653: --
2654: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2655: fnd_message.raise_error;
2656: --
2657: end if;
2658: --
2651: --
2652: -- raise error as does not exist as lookup
2653: --
2654: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2655: fnd_message.raise_error;
2656: --
2657: end if;
2658: --
2659: end if;
2672: p_effective_date => p_effective_date) then
2673: --
2674: -- raise error as does not exist as lookup
2675: --
2676: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2673: --
2674: -- raise error as does not exist as lookup
2675: --
2676: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2681: --
2687: p_effective_date => p_effective_date) then
2688: --
2689: -- raise error as does not exist as lookup
2690: --
2691: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2692: fnd_message.raise_error;
2693: --
2694: end if;
2695: --
2688: --
2689: -- raise error as does not exist as lookup
2690: --
2691: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2692: fnd_message.raise_error;
2693: --
2694: end if;
2695: --
2696: --
2702: p_effective_date => p_effective_date) then
2703: --
2704: -- raise error as does not exist as lookup
2705: --
2706: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2707: fnd_message.raise_error;
2708: --
2709: end if;
2710: --
2703: --
2704: -- raise error as does not exist as lookup
2705: --
2706: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2707: fnd_message.raise_error;
2708: --
2709: end if;
2710: --
2711: --
2718: p_effective_date => p_effective_date) then
2719: --
2720: -- raise error as does not exist as lookup
2721: --
2722: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2723: fnd_message.raise_error;
2724: --
2725: end if;
2726: --
2719: --
2720: -- raise error as does not exist as lookup
2721: --
2722: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2723: fnd_message.raise_error;
2724: --
2725: end if;
2726: --
2727: end if;
2850: p_effective_date => p_effective_date) then
2851: --
2852: -- raise error as does not exist as lookup
2853: --
2854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2855: fnd_message.set_token('FIELD', 'p_bnf_dflt_bnf_cd');
2856: fnd_message.set_token('TYPE', 'BEN_BNF_DFLT');
2857: fnd_message.raise_error;
2858: --
2851: --
2852: -- raise error as does not exist as lookup
2853: --
2854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2855: fnd_message.set_token('FIELD', 'p_bnf_dflt_bnf_cd');
2856: fnd_message.set_token('TYPE', 'BEN_BNF_DFLT');
2857: fnd_message.raise_error;
2858: --
2859: end if;
2852: -- raise error as does not exist as lookup
2853: --
2854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2855: fnd_message.set_token('FIELD', 'p_bnf_dflt_bnf_cd');
2856: fnd_message.set_token('TYPE', 'BEN_BNF_DFLT');
2857: fnd_message.raise_error;
2858: --
2859: end if;
2860: --
2853: --
2854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2855: fnd_message.set_token('FIELD', 'p_bnf_dflt_bnf_cd');
2856: fnd_message.set_token('TYPE', 'BEN_BNF_DFLT');
2857: fnd_message.raise_error;
2858: --
2859: end if;
2860: --
2861: end if;
2874: p_effective_date => p_effective_date) then
2875: --
2876: -- raise error as does not exist as lookup
2877: --
2878: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2879: fnd_message.set_token('FIELD', 'p_bnf_pct_amt_alwd_cd');
2880: fnd_message.set_token('TYPE', 'BEN_BNF_PCT_AMT_ALWD');
2881: fnd_message.raise_error;
2882: --
2875: --
2876: -- raise error as does not exist as lookup
2877: --
2878: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2879: fnd_message.set_token('FIELD', 'p_bnf_pct_amt_alwd_cd');
2880: fnd_message.set_token('TYPE', 'BEN_BNF_PCT_AMT_ALWD');
2881: fnd_message.raise_error;
2882: --
2883: end if;
2876: -- raise error as does not exist as lookup
2877: --
2878: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2879: fnd_message.set_token('FIELD', 'p_bnf_pct_amt_alwd_cd');
2880: fnd_message.set_token('TYPE', 'BEN_BNF_PCT_AMT_ALWD');
2881: fnd_message.raise_error;
2882: --
2883: end if;
2884: --
2877: --
2878: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2879: fnd_message.set_token('FIELD', 'p_bnf_pct_amt_alwd_cd');
2880: fnd_message.set_token('TYPE', 'BEN_BNF_PCT_AMT_ALWD');
2881: fnd_message.raise_error;
2882: --
2883: end if;
2884: --
2885: end if;
2898: p_effective_date => p_effective_date) then
2899: --
2900: -- raise error as does not exist as lookup
2901: --
2902: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2903: fnd_message.set_token('FIELD', 'p_dpnt_dsgn_cd');
2904: fnd_message.set_token('TYPE', 'BEN_DPNT_DSGN');
2905: fnd_message.raise_error;
2906: --
2899: --
2900: -- raise error as does not exist as lookup
2901: --
2902: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2903: fnd_message.set_token('FIELD', 'p_dpnt_dsgn_cd');
2904: fnd_message.set_token('TYPE', 'BEN_DPNT_DSGN');
2905: fnd_message.raise_error;
2906: --
2907: end if;
2900: -- raise error as does not exist as lookup
2901: --
2902: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2903: fnd_message.set_token('FIELD', 'p_dpnt_dsgn_cd');
2904: fnd_message.set_token('TYPE', 'BEN_DPNT_DSGN');
2905: fnd_message.raise_error;
2906: --
2907: end if;
2908: --
2901: --
2902: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2903: fnd_message.set_token('FIELD', 'p_dpnt_dsgn_cd');
2904: fnd_message.set_token('TYPE', 'BEN_DPNT_DSGN');
2905: fnd_message.raise_error;
2906: --
2907: end if;
2908: --
2909: end if;
2922: p_effective_date => p_effective_date) then
2923: --
2924: -- raise error as does not exist as lookup
2925: --
2926: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2927: fnd_message.set_token('FIELD', 'p_pl_cd');
2928: fnd_message.set_token('TYPE', 'BEN_PL');
2929: fnd_message.raise_error;
2930: --
2923: --
2924: -- raise error as does not exist as lookup
2925: --
2926: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2927: fnd_message.set_token('FIELD', 'p_pl_cd');
2928: fnd_message.set_token('TYPE', 'BEN_PL');
2929: fnd_message.raise_error;
2930: --
2931: end if;
2924: -- raise error as does not exist as lookup
2925: --
2926: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2927: fnd_message.set_token('FIELD', 'p_pl_cd');
2928: fnd_message.set_token('TYPE', 'BEN_PL');
2929: fnd_message.raise_error;
2930: --
2931: end if;
2932: --
2925: --
2926: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2927: fnd_message.set_token('FIELD', 'p_pl_cd');
2928: fnd_message.set_token('TYPE', 'BEN_PL');
2929: fnd_message.raise_error;
2930: --
2931: end if;
2932: --
2933: end if;
2946: p_effective_date => p_effective_date) then
2947: --
2948: -- raise error as does not exist as lookup
2949: --
2950: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2951: fnd_message.set_token('FIELD', 'p_cmpr_clms_to_cvg_or_bal_cd');
2952: fnd_message.set_token('TYPE', 'BEN_CMPR_CLMS_TO_CVG_OR_BAL');
2953: fnd_message.raise_error;
2954: --
2947: --
2948: -- raise error as does not exist as lookup
2949: --
2950: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2951: fnd_message.set_token('FIELD', 'p_cmpr_clms_to_cvg_or_bal_cd');
2952: fnd_message.set_token('TYPE', 'BEN_CMPR_CLMS_TO_CVG_OR_BAL');
2953: fnd_message.raise_error;
2954: --
2955: end if;
2948: -- raise error as does not exist as lookup
2949: --
2950: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2951: fnd_message.set_token('FIELD', 'p_cmpr_clms_to_cvg_or_bal_cd');
2952: fnd_message.set_token('TYPE', 'BEN_CMPR_CLMS_TO_CVG_OR_BAL');
2953: fnd_message.raise_error;
2954: --
2955: end if;
2956: --
2949: --
2950: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2951: fnd_message.set_token('FIELD', 'p_cmpr_clms_to_cvg_or_bal_cd');
2952: fnd_message.set_token('TYPE', 'BEN_CMPR_CLMS_TO_CVG_OR_BAL');
2953: fnd_message.raise_error;
2954: --
2955: end if;
2956: --
2957: end if;
2970: p_effective_date => p_effective_date) then
2971: --
2972: -- raise error as does not exist as lookup
2973: --
2974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2975: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
2976: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
2977: fnd_message.raise_error;
2978: --
2971: --
2972: -- raise error as does not exist as lookup
2973: --
2974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2975: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
2976: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
2977: fnd_message.raise_error;
2978: --
2979: end if;
2972: -- raise error as does not exist as lookup
2973: --
2974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2975: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
2976: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
2977: fnd_message.raise_error;
2978: --
2979: end if;
2980: --
2973: --
2974: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2975: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
2976: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
2977: fnd_message.raise_error;
2978: --
2979: end if;
2980: --
2981: end if;
2994: p_effective_date => p_effective_date) then
2995: --
2996: -- raise error as does not exist as lookup
2997: --
2998: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2999: fnd_message.set_token('FIELD', 'p_enrt_cd');
3000: fnd_message.set_token('TYPE', 'BEN_ENRT');
3001: fnd_message.raise_error;
3002: --
2995: --
2996: -- raise error as does not exist as lookup
2997: --
2998: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2999: fnd_message.set_token('FIELD', 'p_enrt_cd');
3000: fnd_message.set_token('TYPE', 'BEN_ENRT');
3001: fnd_message.raise_error;
3002: --
3003: end if;
2996: -- raise error as does not exist as lookup
2997: --
2998: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2999: fnd_message.set_token('FIELD', 'p_enrt_cd');
3000: fnd_message.set_token('TYPE', 'BEN_ENRT');
3001: fnd_message.raise_error;
3002: --
3003: end if;
3004: --
2997: --
2998: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2999: fnd_message.set_token('FIELD', 'p_enrt_cd');
3000: fnd_message.set_token('TYPE', 'BEN_ENRT');
3001: fnd_message.raise_error;
3002: --
3003: end if;
3004: --
3005: end if;
3018: p_effective_date => p_effective_date) then
3019: --
3020: -- raise error as does not exist as lookup
3021: --
3022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3023: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
3024: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
3025: fnd_message.raise_error;
3026: --
3019: --
3020: -- raise error as does not exist as lookup
3021: --
3022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3023: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
3024: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
3025: fnd_message.raise_error;
3026: --
3027: end if;
3020: -- raise error as does not exist as lookup
3021: --
3022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3023: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
3024: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
3025: fnd_message.raise_error;
3026: --
3027: end if;
3028: --
3021: --
3022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3023: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
3024: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
3025: fnd_message.raise_error;
3026: --
3027: end if;
3028: --
3029: end if;
3042: p_effective_date => p_effective_date) then
3043: --
3044: -- raise error as does not exist as lookup
3045: --
3046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3047: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
3048: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
3049: fnd_message.raise_error;
3050: --
3043: --
3044: -- raise error as does not exist as lookup
3045: --
3046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3047: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
3048: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
3049: fnd_message.raise_error;
3050: --
3051: end if;
3044: -- raise error as does not exist as lookup
3045: --
3046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3047: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
3048: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
3049: fnd_message.raise_error;
3050: --
3051: end if;
3052: --
3045: --
3046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3047: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
3048: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
3049: fnd_message.raise_error;
3050: --
3051: end if;
3052: --
3053: end if;
3066: p_effective_date => p_effective_date) then
3067: --
3068: -- raise error as does not exist as lookup
3069: --
3070: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3071: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
3072: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
3073: fnd_message.raise_error;
3074: --
3067: --
3068: -- raise error as does not exist as lookup
3069: --
3070: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3071: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
3072: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
3073: fnd_message.raise_error;
3074: --
3075: end if;
3068: -- raise error as does not exist as lookup
3069: --
3070: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3071: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
3072: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
3073: fnd_message.raise_error;
3074: --
3075: end if;
3076: --
3069: --
3070: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3071: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
3072: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
3073: fnd_message.raise_error;
3074: --
3075: end if;
3076: --
3077: end if;
3090: p_effective_date => p_effective_date) then
3091: --
3092: -- raise error as does not exist as lookup
3093: --
3094: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3095: fnd_message.set_token('FIELD', 'p_mx_wtg_perd_prte_uom');
3096: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
3097: fnd_message.raise_error;
3098: --
3091: --
3092: -- raise error as does not exist as lookup
3093: --
3094: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3095: fnd_message.set_token('FIELD', 'p_mx_wtg_perd_prte_uom');
3096: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
3097: fnd_message.raise_error;
3098: --
3099: end if;
3092: -- raise error as does not exist as lookup
3093: --
3094: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3095: fnd_message.set_token('FIELD', 'p_mx_wtg_perd_prte_uom');
3096: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
3097: fnd_message.raise_error;
3098: --
3099: end if;
3100: --
3093: --
3094: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3095: fnd_message.set_token('FIELD', 'p_mx_wtg_perd_prte_uom');
3096: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
3097: fnd_message.raise_error;
3098: --
3099: end if;
3100: --
3101: end if;
3114: p_effective_date => p_effective_date) then
3115: --
3116: -- raise error as does not exist as lookup
3117: --
3118: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3119: fnd_message.set_token('FIELD', 'p_nip_dflt_enrt_cd');
3120: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
3121: fnd_message.raise_error;
3122: --
3115: --
3116: -- raise error as does not exist as lookup
3117: --
3118: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3119: fnd_message.set_token('FIELD', 'p_nip_dflt_enrt_cd');
3120: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
3121: fnd_message.raise_error;
3122: --
3123: end if;
3116: -- raise error as does not exist as lookup
3117: --
3118: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3119: fnd_message.set_token('FIELD', 'p_nip_dflt_enrt_cd');
3120: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
3121: fnd_message.raise_error;
3122: --
3123: end if;
3124: --
3117: --
3118: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3119: fnd_message.set_token('FIELD', 'p_nip_dflt_enrt_cd');
3120: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
3121: fnd_message.raise_error;
3122: --
3123: end if;
3124: --
3125: end if;
3138: p_effective_date => p_effective_date) then
3139: --
3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD', 'p_dpnt_cvg_end_dt_cd');
3144: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_END');
3145: fnd_message.raise_error;
3146: --
3139: --
3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD', 'p_dpnt_cvg_end_dt_cd');
3144: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_END');
3145: fnd_message.raise_error;
3146: --
3147: end if;
3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD', 'p_dpnt_cvg_end_dt_cd');
3144: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_END');
3145: fnd_message.raise_error;
3146: --
3147: end if;
3148: --
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD', 'p_dpnt_cvg_end_dt_cd');
3144: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_END');
3145: fnd_message.raise_error;
3146: --
3147: end if;
3148: --
3149: end if;
3162: p_effective_date => p_effective_date) then
3163: --
3164: -- raise error as does not exist as lookup
3165: --
3166: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3167: fnd_message.set_token('FIELD', 'p_dpnt_cvg_strt_dt_cd');
3168: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_STRT');
3169: fnd_message.raise_error;
3170: --
3163: --
3164: -- raise error as does not exist as lookup
3165: --
3166: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3167: fnd_message.set_token('FIELD', 'p_dpnt_cvg_strt_dt_cd');
3168: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_STRT');
3169: fnd_message.raise_error;
3170: --
3171: end if;
3164: -- raise error as does not exist as lookup
3165: --
3166: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3167: fnd_message.set_token('FIELD', 'p_dpnt_cvg_strt_dt_cd');
3168: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_STRT');
3169: fnd_message.raise_error;
3170: --
3171: end if;
3172: --
3165: --
3166: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3167: fnd_message.set_token('FIELD', 'p_dpnt_cvg_strt_dt_cd');
3168: fnd_message.set_token('TYPE', 'BEN_DPNT_CVG_STRT');
3169: fnd_message.raise_error;
3170: --
3171: end if;
3172: --
3173: end if;
3185: if c1%notfound then
3186: close c1;
3187: -- raise error as currency not found
3188: --
3189: fnd_message.set_name('BEN','BEN_91306_INV_PGM_UOM'); -- same msg for plan
3190: fnd_message.raise_error;
3191: end if;
3192: close c1;
3193: --
3186: close c1;
3187: -- raise error as currency not found
3188: --
3189: fnd_message.set_name('BEN','BEN_91306_INV_PGM_UOM'); -- same msg for plan
3190: fnd_message.raise_error;
3191: end if;
3192: close c1;
3193: --
3194: end if;
3208: p_effective_date => p_effective_date) then
3209: --
3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD', 'p_nip_acty_ref_perd_cd');
3214: fnd_message.set_token('TYPE', 'BEN_ACTY_REF_PERD');
3215: fnd_message.raise_error;
3216: --
3209: --
3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD', 'p_nip_acty_ref_perd_cd');
3214: fnd_message.set_token('TYPE', 'BEN_ACTY_REF_PERD');
3215: fnd_message.raise_error;
3216: --
3217: end if;
3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD', 'p_nip_acty_ref_perd_cd');
3214: fnd_message.set_token('TYPE', 'BEN_ACTY_REF_PERD');
3215: fnd_message.raise_error;
3216: --
3217: end if;
3218: --
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD', 'p_nip_acty_ref_perd_cd');
3214: fnd_message.set_token('TYPE', 'BEN_ACTY_REF_PERD');
3215: fnd_message.raise_error;
3216: --
3217: end if;
3218: --
3219: end if;
3232: p_effective_date => p_effective_date) then
3233: --
3234: -- raise error as does not exist as lookup
3235: --
3236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3237: fnd_message.set_token('FIELD', 'p_nip_enrt_info_rt_freq_cd');
3238: fnd_message.set_token('TYPE', 'BEN_ENRT_INFO_RT_FREQ');
3239: fnd_message.raise_error;
3240: --
3233: --
3234: -- raise error as does not exist as lookup
3235: --
3236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3237: fnd_message.set_token('FIELD', 'p_nip_enrt_info_rt_freq_cd');
3238: fnd_message.set_token('TYPE', 'BEN_ENRT_INFO_RT_FREQ');
3239: fnd_message.raise_error;
3240: --
3241: end if;
3234: -- raise error as does not exist as lookup
3235: --
3236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3237: fnd_message.set_token('FIELD', 'p_nip_enrt_info_rt_freq_cd');
3238: fnd_message.set_token('TYPE', 'BEN_ENRT_INFO_RT_FREQ');
3239: fnd_message.raise_error;
3240: --
3241: end if;
3242: --
3235: --
3236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3237: fnd_message.set_token('FIELD', 'p_nip_enrt_info_rt_freq_cd');
3238: fnd_message.set_token('TYPE', 'BEN_ENRT_INFO_RT_FREQ');
3239: fnd_message.raise_error;
3240: --
3241: end if;
3242: --
3243: end if;
3256: p_effective_date => p_effective_date) then
3257: --
3258: -- raise error as does not exist as lookup
3259: --
3260: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3261: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
3262: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
3263: fnd_message.raise_error;
3264: --
3257: --
3258: -- raise error as does not exist as lookup
3259: --
3260: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3261: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
3262: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
3263: fnd_message.raise_error;
3264: --
3265: end if;
3258: -- raise error as does not exist as lookup
3259: --
3260: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3261: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
3262: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
3263: fnd_message.raise_error;
3264: --
3265: end if;
3266: --
3259: --
3260: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3261: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
3262: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
3263: fnd_message.raise_error;
3264: --
3265: end if;
3266: --
3267: end if;
3280: p_effective_date => p_effective_date) then
3281: --
3282: -- raise error as does not exist as lookup
3283: --
3284: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3285: fnd_message.set_token('FIELD', 'p_hc_svc_typ_cd');
3286: fnd_message.set_token('TYPE', 'BEN_HLTH_CARE_SVC_TYP');
3287: fnd_message.raise_error;
3288: --
3281: --
3282: -- raise error as does not exist as lookup
3283: --
3284: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3285: fnd_message.set_token('FIELD', 'p_hc_svc_typ_cd');
3286: fnd_message.set_token('TYPE', 'BEN_HLTH_CARE_SVC_TYP');
3287: fnd_message.raise_error;
3288: --
3289: end if;
3282: -- raise error as does not exist as lookup
3283: --
3284: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3285: fnd_message.set_token('FIELD', 'p_hc_svc_typ_cd');
3286: fnd_message.set_token('TYPE', 'BEN_HLTH_CARE_SVC_TYP');
3287: fnd_message.raise_error;
3288: --
3289: end if;
3290: --
3283: --
3284: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3285: fnd_message.set_token('FIELD', 'p_hc_svc_typ_cd');
3286: fnd_message.set_token('TYPE', 'BEN_HLTH_CARE_SVC_TYP');
3287: fnd_message.raise_error;
3288: --
3289: end if;
3290: --
3291: end if;
3304: p_effective_date => p_effective_date) then
3305: --
3306: -- raise error as does not exist as lookup
3307: --
3308: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3309: fnd_message.set_token('FIELD', 'p_pl_stat_cd');
3310: fnd_message.set_token('TYPE', 'BEN_STAT');
3311: fnd_message.raise_error;
3312: --
3305: --
3306: -- raise error as does not exist as lookup
3307: --
3308: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3309: fnd_message.set_token('FIELD', 'p_pl_stat_cd');
3310: fnd_message.set_token('TYPE', 'BEN_STAT');
3311: fnd_message.raise_error;
3312: --
3313: end if;
3306: -- raise error as does not exist as lookup
3307: --
3308: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3309: fnd_message.set_token('FIELD', 'p_pl_stat_cd');
3310: fnd_message.set_token('TYPE', 'BEN_STAT');
3311: fnd_message.raise_error;
3312: --
3313: end if;
3314: --
3307: --
3308: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3309: fnd_message.set_token('FIELD', 'p_pl_stat_cd');
3310: fnd_message.set_token('TYPE', 'BEN_STAT');
3311: fnd_message.raise_error;
3312: --
3313: end if;
3314: --
3315: end if;
3328: p_effective_date => p_effective_date) then
3329: --
3330: -- raise error as does not exist as lookup
3331: --
3332: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3333: fnd_message.set_token('FIELD', 'p_prmry_fndg_mthd_cd');
3334: fnd_message.set_token('TYPE', 'BEN_PRMRY_FNDG_MTHD');
3335: fnd_message.raise_error;
3336: --
3329: --
3330: -- raise error as does not exist as lookup
3331: --
3332: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3333: fnd_message.set_token('FIELD', 'p_prmry_fndg_mthd_cd');
3334: fnd_message.set_token('TYPE', 'BEN_PRMRY_FNDG_MTHD');
3335: fnd_message.raise_error;
3336: --
3337: end if;
3330: -- raise error as does not exist as lookup
3331: --
3332: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3333: fnd_message.set_token('FIELD', 'p_prmry_fndg_mthd_cd');
3334: fnd_message.set_token('TYPE', 'BEN_PRMRY_FNDG_MTHD');
3335: fnd_message.raise_error;
3336: --
3337: end if;
3338: --
3331: --
3332: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3333: fnd_message.set_token('FIELD', 'p_prmry_fndg_mthd_cd');
3334: fnd_message.set_token('TYPE', 'BEN_PRMRY_FNDG_MTHD');
3335: fnd_message.raise_error;
3336: --
3337: end if;
3338: --
3339: end if;
3352: p_effective_date => p_effective_date) then
3353: --
3354: -- raise error as does not exist as lookup
3355: --
3356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3357: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
3358: fnd_message.set_token('TYPE', 'BEN_RT_END');
3359: fnd_message.raise_error;
3360: --
3353: --
3354: -- raise error as does not exist as lookup
3355: --
3356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3357: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
3358: fnd_message.set_token('TYPE', 'BEN_RT_END');
3359: fnd_message.raise_error;
3360: --
3361: end if;
3354: -- raise error as does not exist as lookup
3355: --
3356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3357: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
3358: fnd_message.set_token('TYPE', 'BEN_RT_END');
3359: fnd_message.raise_error;
3360: --
3361: end if;
3362: --
3355: --
3356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3357: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
3358: fnd_message.set_token('TYPE', 'BEN_RT_END');
3359: fnd_message.raise_error;
3360: --
3361: end if;
3362: --
3363: end if;
3376: p_effective_date => p_effective_date) then
3377: --
3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
3382: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
3383: fnd_message.raise_error;
3384: --
3377: --
3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
3382: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
3383: fnd_message.raise_error;
3384: --
3385: end if;
3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
3382: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
3383: fnd_message.raise_error;
3384: --
3385: end if;
3386: --
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
3382: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
3383: fnd_message.raise_error;
3384: --
3385: end if;
3386: --
3387: end if;
3400: p_effective_date => p_effective_date) then
3401: --
3402: -- raise error as does not exist as lookup
3403: --
3404: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3405: fnd_message.set_token('FIELD', 'p_bnf_dsgn_cd');
3406: fnd_message.set_token('TYPE', 'BEN_BNF_DSGN');
3407: fnd_message.raise_error;
3408: --
3401: --
3402: -- raise error as does not exist as lookup
3403: --
3404: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3405: fnd_message.set_token('FIELD', 'p_bnf_dsgn_cd');
3406: fnd_message.set_token('TYPE', 'BEN_BNF_DSGN');
3407: fnd_message.raise_error;
3408: --
3409: end if;
3402: -- raise error as does not exist as lookup
3403: --
3404: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3405: fnd_message.set_token('FIELD', 'p_bnf_dsgn_cd');
3406: fnd_message.set_token('TYPE', 'BEN_BNF_DSGN');
3407: fnd_message.raise_error;
3408: --
3409: end if;
3410: --
3403: --
3404: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3405: fnd_message.set_token('FIELD', 'p_bnf_dsgn_cd');
3406: fnd_message.set_token('TYPE', 'BEN_BNF_DSGN');
3407: fnd_message.raise_error;
3408: --
3409: end if;
3410: --
3411: end if;
3424: p_effective_date => p_effective_date) then
3425: --
3426: -- raise error as does not exist as lookup
3427: --
3428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3429: fnd_message.set_token('FIELD', 'p_per_cvrd_cd');
3430: fnd_message.set_token('TYPE', 'BEN_PER_CVRD');
3431: fnd_message.raise_error;
3432: --
3425: --
3426: -- raise error as does not exist as lookup
3427: --
3428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3429: fnd_message.set_token('FIELD', 'p_per_cvrd_cd');
3430: fnd_message.set_token('TYPE', 'BEN_PER_CVRD');
3431: fnd_message.raise_error;
3432: --
3433: end if;
3426: -- raise error as does not exist as lookup
3427: --
3428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3429: fnd_message.set_token('FIELD', 'p_per_cvrd_cd');
3430: fnd_message.set_token('TYPE', 'BEN_PER_CVRD');
3431: fnd_message.raise_error;
3432: --
3433: end if;
3434: --
3427: --
3428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3429: fnd_message.set_token('FIELD', 'p_per_cvrd_cd');
3430: fnd_message.set_token('TYPE', 'BEN_PER_CVRD');
3431: fnd_message.raise_error;
3432: --
3433: end if;
3434: --
3435: end if;
3448: p_effective_date => p_effective_date) then
3449: --
3450: -- raise error as does not exist as lookup
3451: --
3452: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3453: fnd_message.set_token('FIELD', 'p_mx_wtg_dt_to_use_cd');
3454: fnd_message.set_token('TYPE', 'BEN_MX_WTG_DT_TO_USE');
3455: fnd_message.raise_error;
3456: --
3449: --
3450: -- raise error as does not exist as lookup
3451: --
3452: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3453: fnd_message.set_token('FIELD', 'p_mx_wtg_dt_to_use_cd');
3454: fnd_message.set_token('TYPE', 'BEN_MX_WTG_DT_TO_USE');
3455: fnd_message.raise_error;
3456: --
3457: end if;
3450: -- raise error as does not exist as lookup
3451: --
3452: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3453: fnd_message.set_token('FIELD', 'p_mx_wtg_dt_to_use_cd');
3454: fnd_message.set_token('TYPE', 'BEN_MX_WTG_DT_TO_USE');
3455: fnd_message.raise_error;
3456: --
3457: end if;
3458: --
3451: --
3452: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3453: fnd_message.set_token('FIELD', 'p_mx_wtg_dt_to_use_cd');
3454: fnd_message.set_token('TYPE', 'BEN_MX_WTG_DT_TO_USE');
3455: fnd_message.raise_error;
3456: --
3457: end if;
3458: --
3459: end if;
3472: p_effective_date => p_effective_date) then
3473: --
3474: -- raise error as does not exist as lookup
3475: --
3476: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3477: fnd_message.set_token('FIELD', 'p_bnft_or_option_rstrctn_cd');
3478: fnd_message.set_token('TYPE', 'BEN_BNFT_R_OPT_RSTRN');
3479: fnd_message.raise_error;
3480: --
3473: --
3474: -- raise error as does not exist as lookup
3475: --
3476: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3477: fnd_message.set_token('FIELD', 'p_bnft_or_option_rstrctn_cd');
3478: fnd_message.set_token('TYPE', 'BEN_BNFT_R_OPT_RSTRN');
3479: fnd_message.raise_error;
3480: --
3481: end if;
3474: -- raise error as does not exist as lookup
3475: --
3476: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3477: fnd_message.set_token('FIELD', 'p_bnft_or_option_rstrctn_cd');
3478: fnd_message.set_token('TYPE', 'BEN_BNFT_R_OPT_RSTRN');
3479: fnd_message.raise_error;
3480: --
3481: end if;
3482: --
3475: --
3476: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3477: fnd_message.set_token('FIELD', 'p_bnft_or_option_rstrctn_cd');
3478: fnd_message.set_token('TYPE', 'BEN_BNFT_R_OPT_RSTRN');
3479: fnd_message.raise_error;
3480: --
3481: end if;
3482: --
3483: end if;
3495: p_effective_date => p_effective_date) then
3496: --
3497: -- raise error as does not exist as lookup
3498: --
3499: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3500: fnd_message.set_token('FIELD', 'p_cvg_incr_r_decr_only_cd');
3501: fnd_message.set_token('TYPE', 'BEN_CVG_INCR_R_DECR_ONLY');
3502: fnd_message.raise_error;
3503: --
3496: --
3497: -- raise error as does not exist as lookup
3498: --
3499: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3500: fnd_message.set_token('FIELD', 'p_cvg_incr_r_decr_only_cd');
3501: fnd_message.set_token('TYPE', 'BEN_CVG_INCR_R_DECR_ONLY');
3502: fnd_message.raise_error;
3503: --
3504: end if;
3497: -- raise error as does not exist as lookup
3498: --
3499: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3500: fnd_message.set_token('FIELD', 'p_cvg_incr_r_decr_only_cd');
3501: fnd_message.set_token('TYPE', 'BEN_CVG_INCR_R_DECR_ONLY');
3502: fnd_message.raise_error;
3503: --
3504: end if;
3505: --
3498: --
3499: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3500: fnd_message.set_token('FIELD', 'p_cvg_incr_r_decr_only_cd');
3501: fnd_message.set_token('TYPE', 'BEN_CVG_INCR_R_DECR_ONLY');
3502: fnd_message.raise_error;
3503: --
3504: end if;
3505: --
3506: end if;
3518: p_effective_date => p_effective_date) then
3519: --
3520: -- raise error as does not exist as lookup
3521: --
3522: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3523: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
3524: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
3525: fnd_message.raise_error;
3526: --
3519: --
3520: -- raise error as does not exist as lookup
3521: --
3522: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3523: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
3524: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
3525: fnd_message.raise_error;
3526: --
3527: end if;
3520: -- raise error as does not exist as lookup
3521: --
3522: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3523: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
3524: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
3525: fnd_message.raise_error;
3526: --
3527: end if;
3528: --
3521: --
3522: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3523: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
3524: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
3525: fnd_message.raise_error;
3526: --
3527: end if;
3528: --
3529: end if;
3542: p_effective_date => p_effective_date) then
3543: --
3544: -- raise error as does not exist as lookup
3545: --
3546: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3547: fnd_message.set_token('FIELD', 'p_imptd_incm_calc_cd');
3548: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
3549: fnd_message.raise_error;
3550: --
3543: --
3544: -- raise error as does not exist as lookup
3545: --
3546: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3547: fnd_message.set_token('FIELD', 'p_imptd_incm_calc_cd');
3548: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
3549: fnd_message.raise_error;
3550: --
3551: end if;
3544: -- raise error as does not exist as lookup
3545: --
3546: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3547: fnd_message.set_token('FIELD', 'p_imptd_incm_calc_cd');
3548: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
3549: fnd_message.raise_error;
3550: --
3551: end if;
3552: --
3545: --
3546: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3547: fnd_message.set_token('FIELD', 'p_imptd_incm_calc_cd');
3548: fnd_message.set_token('TYPE', 'BEN_IMPTD_INCM_TYP');
3549: fnd_message.raise_error;
3550: --
3551: end if;
3552: --
3553: end if;
3655: close c1;
3656: --
3657: -- raise error
3658: --
3659: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3660: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
3661: fnd_message.set_token('TYPE_ID',-146);
3662: fnd_message.raise_error;
3663: --
3656: --
3657: -- raise error
3658: --
3659: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3660: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
3661: fnd_message.set_token('TYPE_ID',-146);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3657: -- raise error
3658: --
3659: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3660: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
3661: fnd_message.set_token('TYPE_ID',-146);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --
3658: --
3659: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3660: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
3661: fnd_message.set_token('TYPE_ID',-146);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --
3666: close c1;
3686: close c1;
3687: --
3688: -- raise error
3689: --
3690: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3691: fnd_message.set_token('ID',p_mn_cvg_rl);
3692: fnd_message.set_token('TYPE_ID',-164);
3693: fnd_message.raise_error;
3694: --
3687: --
3688: -- raise error
3689: --
3690: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3691: fnd_message.set_token('ID',p_mn_cvg_rl);
3692: fnd_message.set_token('TYPE_ID',-164);
3693: fnd_message.raise_error;
3694: --
3695: end if;
3688: -- raise error
3689: --
3690: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3691: fnd_message.set_token('ID',p_mn_cvg_rl);
3692: fnd_message.set_token('TYPE_ID',-164);
3693: fnd_message.raise_error;
3694: --
3695: end if;
3696: --
3689: --
3690: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3691: fnd_message.set_token('ID',p_mn_cvg_rl);
3692: fnd_message.set_token('TYPE_ID',-164);
3693: fnd_message.raise_error;
3694: --
3695: end if;
3696: --
3697: close c1;
3717: close c1;
3718: --
3719: -- raise error
3720: --
3721: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3722: fnd_message.set_token('ID',p_mx_cvg_rl);
3723: fnd_message.set_token('TYPE_ID',-161);
3724: fnd_message.raise_error;
3725: --
3718: --
3719: -- raise error
3720: --
3721: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3722: fnd_message.set_token('ID',p_mx_cvg_rl);
3723: fnd_message.set_token('TYPE_ID',-161);
3724: fnd_message.raise_error;
3725: --
3726: end if;
3719: -- raise error
3720: --
3721: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3722: fnd_message.set_token('ID',p_mx_cvg_rl);
3723: fnd_message.set_token('TYPE_ID',-161);
3724: fnd_message.raise_error;
3725: --
3726: end if;
3727: --
3720: --
3721: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3722: fnd_message.set_token('ID',p_mx_cvg_rl);
3723: fnd_message.set_token('TYPE_ID',-161);
3724: fnd_message.raise_error;
3725: --
3726: end if;
3727: --
3728: close c1;
3748: close c1;
3749: --
3750: -- raise error
3751: --
3752: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3753: fnd_message.set_token('ID',p_mx_wtg_perd_rl);
3754: fnd_message.set_token('TYPE_ID',-518);
3755: fnd_message.raise_error;
3756: --
3749: --
3750: -- raise error
3751: --
3752: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3753: fnd_message.set_token('ID',p_mx_wtg_perd_rl);
3754: fnd_message.set_token('TYPE_ID',-518);
3755: fnd_message.raise_error;
3756: --
3757: end if;
3750: -- raise error
3751: --
3752: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3753: fnd_message.set_token('ID',p_mx_wtg_perd_rl);
3754: fnd_message.set_token('TYPE_ID',-518);
3755: fnd_message.raise_error;
3756: --
3757: end if;
3758: --
3751: --
3752: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3753: fnd_message.set_token('ID',p_mx_wtg_perd_rl);
3754: fnd_message.set_token('TYPE_ID',-518);
3755: fnd_message.raise_error;
3756: --
3757: end if;
3758: --
3759: close c1;
3779: close c1;
3780: --
3781: -- raise error
3782: --
3783: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3784: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
3785: fnd_message.set_token('TYPE_ID',-513);
3786: fnd_message.raise_error;
3787: --
3780: --
3781: -- raise error
3782: --
3783: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3784: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
3785: fnd_message.set_token('TYPE_ID',-513);
3786: fnd_message.raise_error;
3787: --
3788: end if;
3781: -- raise error
3782: --
3783: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3784: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
3785: fnd_message.set_token('TYPE_ID',-513);
3786: fnd_message.raise_error;
3787: --
3788: end if;
3789: --
3782: --
3783: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3784: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
3785: fnd_message.set_token('TYPE_ID',-513);
3786: fnd_message.raise_error;
3787: --
3788: end if;
3789: --
3790: close c1;
3810: close c1;
3811: --
3812: -- raise error
3813: --
3814: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3815: fnd_message.set_token('ID',p_nip_dflt_enrt_det_rl);
3816: fnd_message.set_token('TYPE_ID',-32);
3817: fnd_message.raise_error;
3818: --
3811: --
3812: -- raise error
3813: --
3814: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3815: fnd_message.set_token('ID',p_nip_dflt_enrt_det_rl);
3816: fnd_message.set_token('TYPE_ID',-32);
3817: fnd_message.raise_error;
3818: --
3819: end if;
3812: -- raise error
3813: --
3814: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3815: fnd_message.set_token('ID',p_nip_dflt_enrt_det_rl);
3816: fnd_message.set_token('TYPE_ID',-32);
3817: fnd_message.raise_error;
3818: --
3819: end if;
3820: --
3813: --
3814: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3815: fnd_message.set_token('ID',p_nip_dflt_enrt_det_rl);
3816: fnd_message.set_token('TYPE_ID',-32);
3817: fnd_message.raise_error;
3818: --
3819: end if;
3820: --
3821: close c1;
3841: close c1;
3842: --
3843: -- raise error
3844: --
3845: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3846: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3847: fnd_message.set_token('TYPE_ID',-28);
3848: fnd_message.raise_error;
3849: --
3842: --
3843: -- raise error
3844: --
3845: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3846: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3847: fnd_message.set_token('TYPE_ID',-28);
3848: fnd_message.raise_error;
3849: --
3850: end if;
3843: -- raise error
3844: --
3845: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3846: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3847: fnd_message.set_token('TYPE_ID',-28);
3848: fnd_message.raise_error;
3849: --
3850: end if;
3851: --
3844: --
3845: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3846: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3847: fnd_message.set_token('TYPE_ID',-28);
3848: fnd_message.raise_error;
3849: --
3850: end if;
3851: --
3852: close c1;
3872: close c1;
3873: --
3874: -- raise error
3875: --
3876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3877: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3878: fnd_message.set_token('TYPE_ID',-27);
3879: fnd_message.raise_error;
3880: --
3873: --
3874: -- raise error
3875: --
3876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3877: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3878: fnd_message.set_token('TYPE_ID',-27);
3879: fnd_message.raise_error;
3880: --
3881: end if;
3874: -- raise error
3875: --
3876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3877: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3878: fnd_message.set_token('TYPE_ID',-27);
3879: fnd_message.raise_error;
3880: --
3881: end if;
3882: --
3875: --
3876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3877: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3878: fnd_message.set_token('TYPE_ID',-27);
3879: fnd_message.raise_error;
3880: --
3881: end if;
3882: --
3883: close c1;
3903: close c1;
3904: --
3905: -- raise error
3906: --
3907: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3908: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
3909: fnd_message.set_token('TYPE_ID',-454);
3910: fnd_message.raise_error;
3911: --
3904: --
3905: -- raise error
3906: --
3907: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3908: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
3909: fnd_message.set_token('TYPE_ID',-454);
3910: fnd_message.raise_error;
3911: --
3912: end if;
3905: -- raise error
3906: --
3907: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3908: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
3909: fnd_message.set_token('TYPE_ID',-454);
3910: fnd_message.raise_error;
3911: --
3912: end if;
3913: --
3906: --
3907: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3908: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
3909: fnd_message.set_token('TYPE_ID',-454);
3910: fnd_message.raise_error;
3911: --
3912: end if;
3913: --
3914: close c1;
3934: close c1;
3935: --
3936: -- raise error
3937: --
3938: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3939: fnd_message.set_token('ID',p_postelcn_edit_rl);
3940: fnd_message.set_token('TYPE_ID',-215);
3941: fnd_message.raise_error;
3942: --
3935: --
3936: -- raise error
3937: --
3938: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3939: fnd_message.set_token('ID',p_postelcn_edit_rl);
3940: fnd_message.set_token('TYPE_ID',-215);
3941: fnd_message.raise_error;
3942: --
3943: end if;
3936: -- raise error
3937: --
3938: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3939: fnd_message.set_token('ID',p_postelcn_edit_rl);
3940: fnd_message.set_token('TYPE_ID',-215);
3941: fnd_message.raise_error;
3942: --
3943: end if;
3944: --
3937: --
3938: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3939: fnd_message.set_token('ID',p_postelcn_edit_rl);
3940: fnd_message.set_token('TYPE_ID',-215);
3941: fnd_message.raise_error;
3942: --
3943: end if;
3944: --
3945: close c1;
3965: close c1;
3966: --
3967: -- raise error
3968: --
3969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3970: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
3971: fnd_message.set_token('TYPE_ID',-166);
3972: fnd_message.raise_error;
3973: --
3966: --
3967: -- raise error
3968: --
3969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3970: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
3971: fnd_message.set_token('TYPE_ID',-166);
3972: fnd_message.raise_error;
3973: --
3974: end if;
3967: -- raise error
3968: --
3969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3970: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
3971: fnd_message.set_token('TYPE_ID',-166);
3972: fnd_message.raise_error;
3973: --
3974: end if;
3975: --
3968: --
3969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3970: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
3971: fnd_message.set_token('TYPE_ID',-166);
3972: fnd_message.raise_error;
3973: --
3974: end if;
3975: --
3976: close c1;
3996: close c1;
3997: --
3998: -- raise error
3999: --
4000: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4001: fnd_message.set_token('ID',p_rt_end_dt_rl);
4002: fnd_message.set_token('TYPE_ID',-67);
4003: fnd_message.raise_error;
4004: --
3997: --
3998: -- raise error
3999: --
4000: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4001: fnd_message.set_token('ID',p_rt_end_dt_rl);
4002: fnd_message.set_token('TYPE_ID',-67);
4003: fnd_message.raise_error;
4004: --
4005: end if;
3998: -- raise error
3999: --
4000: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4001: fnd_message.set_token('ID',p_rt_end_dt_rl);
4002: fnd_message.set_token('TYPE_ID',-67);
4003: fnd_message.raise_error;
4004: --
4005: end if;
4006: --
3999: --
4000: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4001: fnd_message.set_token('ID',p_rt_end_dt_rl);
4002: fnd_message.set_token('TYPE_ID',-67);
4003: fnd_message.raise_error;
4004: --
4005: end if;
4006: --
4007: close c1;
4027: close c1;
4028: --
4029: -- raise error
4030: --
4031: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4032: fnd_message.set_token('ID',p_rt_strt_dt_rl);
4033: fnd_message.set_token('TYPE_ID',-66);
4034: fnd_message.raise_error;
4035: --
4028: --
4029: -- raise error
4030: --
4031: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4032: fnd_message.set_token('ID',p_rt_strt_dt_rl);
4033: fnd_message.set_token('TYPE_ID',-66);
4034: fnd_message.raise_error;
4035: --
4036: end if;
4029: -- raise error
4030: --
4031: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4032: fnd_message.set_token('ID',p_rt_strt_dt_rl);
4033: fnd_message.set_token('TYPE_ID',-66);
4034: fnd_message.raise_error;
4035: --
4036: end if;
4037: --
4030: --
4031: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4032: fnd_message.set_token('ID',p_rt_strt_dt_rl);
4033: fnd_message.set_token('TYPE_ID',-66);
4034: fnd_message.raise_error;
4035: --
4036: end if;
4037: --
4038: close c1;
4058: close c1;
4059: --
4060: -- raise error
4061: --
4062: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4063: fnd_message.set_token('ID',p_mx_wtg_dt_to_use_rl);
4064: fnd_message.set_token('TYPE_ID',-162);
4065: fnd_message.raise_error;
4066: --
4059: --
4060: -- raise error
4061: --
4062: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4063: fnd_message.set_token('ID',p_mx_wtg_dt_to_use_rl);
4064: fnd_message.set_token('TYPE_ID',-162);
4065: fnd_message.raise_error;
4066: --
4067: end if;
4060: -- raise error
4061: --
4062: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4063: fnd_message.set_token('ID',p_mx_wtg_dt_to_use_rl);
4064: fnd_message.set_token('TYPE_ID',-162);
4065: fnd_message.raise_error;
4066: --
4067: end if;
4068: --
4061: --
4062: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4063: fnd_message.set_token('ID',p_mx_wtg_dt_to_use_rl);
4064: fnd_message.set_token('TYPE_ID',-162);
4065: fnd_message.raise_error;
4066: --
4067: end if;
4068: --
4069: close c1;
4089: close c1;
4090: --
4091: -- raise error
4092: --
4093: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4094: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
4095: fnd_message.set_token('TYPE_ID',-29);
4096: fnd_message.raise_error;
4097: --
4090: --
4091: -- raise error
4092: --
4093: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4094: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
4095: fnd_message.set_token('TYPE_ID',-29);
4096: fnd_message.raise_error;
4097: --
4098: end if;
4091: -- raise error
4092: --
4093: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4094: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
4095: fnd_message.set_token('TYPE_ID',-29);
4096: fnd_message.raise_error;
4097: --
4098: end if;
4099: --
4092: --
4093: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4094: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
4095: fnd_message.set_token('TYPE_ID',-29);
4096: fnd_message.raise_error;
4097: --
4098: end if;
4099: --
4100: close c1;
4120: close c1;
4121: --
4122: -- raise error
4123: --
4124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4125: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
4126: fnd_message.set_token('TYPE_ID',-30);
4127: fnd_message.raise_error;
4128: --
4121: --
4122: -- raise error
4123: --
4124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4125: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
4126: fnd_message.set_token('TYPE_ID',-30);
4127: fnd_message.raise_error;
4128: --
4129: end if;
4122: -- raise error
4123: --
4124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4125: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
4126: fnd_message.set_token('TYPE_ID',-30);
4127: fnd_message.raise_error;
4128: --
4129: end if;
4130: --
4123: --
4124: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4125: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
4126: fnd_message.set_token('TYPE_ID',-30);
4127: fnd_message.raise_error;
4128: --
4129: end if;
4130: --
4131: close c1;
4151: close c1;
4152: --
4153: -- raise error
4154: --
4155: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4156: fnd_message.set_token('ID',p_enrt_rl);
4157: fnd_message.set_token('TYPE_ID',-393);
4158: fnd_message.raise_error;
4159: --
4152: --
4153: -- raise error
4154: --
4155: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4156: fnd_message.set_token('ID',p_enrt_rl);
4157: fnd_message.set_token('TYPE_ID',-393);
4158: fnd_message.raise_error;
4159: --
4160: end if;
4153: -- raise error
4154: --
4155: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4156: fnd_message.set_token('ID',p_enrt_rl);
4157: fnd_message.set_token('TYPE_ID',-393);
4158: fnd_message.raise_error;
4159: --
4160: end if;
4161: --
4154: --
4155: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4156: fnd_message.set_token('ID',p_enrt_rl);
4157: fnd_message.set_token('TYPE_ID',-393);
4158: fnd_message.raise_error;
4159: --
4160: end if;
4161: --
4162: close c1;
4227: --
4228:
4229: if (p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
4230: then
4231: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4232: fnd_message.raise_error;
4233: end if;
4234:
4235: if (p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
4228:
4229: if (p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
4230: then
4231: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4232: fnd_message.raise_error;
4233: end if;
4234:
4235: if (p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
4236: then
4233: end if;
4234:
4235: if (p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
4236: then
4237: fnd_message.set_name('BEN','BEN_91731_RULE');
4238: fnd_message.raise_error;
4239: end if;
4240: --
4241: if (p_dpnt_cvg_end_dt_cd <> 'RL' and p_dpnt_cvg_end_dt_rl is not null)
4234:
4235: if (p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
4236: then
4237: fnd_message.set_name('BEN','BEN_91731_RULE');
4238: fnd_message.raise_error;
4239: end if;
4240: --
4241: if (p_dpnt_cvg_end_dt_cd <> 'RL' and p_dpnt_cvg_end_dt_rl is not null)
4242: then
4239: end if;
4240: --
4241: if (p_dpnt_cvg_end_dt_cd <> 'RL' and p_dpnt_cvg_end_dt_rl is not null)
4242: then
4243: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4244: fnd_message.raise_error;
4245: end if;
4246:
4247: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null)
4240: --
4241: if (p_dpnt_cvg_end_dt_cd <> 'RL' and p_dpnt_cvg_end_dt_rl is not null)
4242: then
4243: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4244: fnd_message.raise_error;
4245: end if;
4246:
4247: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null)
4248: then
4245: end if;
4246:
4247: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null)
4248: then
4249: fnd_message.set_name('BEN','BEN_91731_RULE');
4250: fnd_message.raise_error;
4251: end if;
4252: --
4253: if (p_dpnt_cvg_strt_dt_cd <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null)
4246:
4247: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null)
4248: then
4249: fnd_message.set_name('BEN','BEN_91731_RULE');
4250: fnd_message.raise_error;
4251: end if;
4252: --
4253: if (p_dpnt_cvg_strt_dt_cd <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null)
4254: then
4251: end if;
4252: --
4253: if (p_dpnt_cvg_strt_dt_cd <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null)
4254: then
4255: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4256: fnd_message.raise_error;
4257: end if;
4258:
4259: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null)
4252: --
4253: if (p_dpnt_cvg_strt_dt_cd <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null)
4254: then
4255: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4256: fnd_message.raise_error;
4257: end if;
4258:
4259: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null)
4260: then
4257: end if;
4258:
4259: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null)
4260: then
4261: fnd_message.set_name('BEN','BEN_91731_RULE');
4262: fnd_message.raise_error;
4263: end if;
4264: --
4265: if (p_enrt_cvg_end_dt_cd <> 'RL' and p_enrt_cvg_end_dt_rl is not null)
4258:
4259: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null)
4260: then
4261: fnd_message.set_name('BEN','BEN_91731_RULE');
4262: fnd_message.raise_error;
4263: end if;
4264: --
4265: if (p_enrt_cvg_end_dt_cd <> 'RL' and p_enrt_cvg_end_dt_rl is not null)
4266: then
4263: end if;
4264: --
4265: if (p_enrt_cvg_end_dt_cd <> 'RL' and p_enrt_cvg_end_dt_rl is not null)
4266: then
4267: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4268: fnd_message.raise_error;
4269: end if;
4270:
4271: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null)
4264: --
4265: if (p_enrt_cvg_end_dt_cd <> 'RL' and p_enrt_cvg_end_dt_rl is not null)
4266: then
4267: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4268: fnd_message.raise_error;
4269: end if;
4270:
4271: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null)
4272: then
4269: end if;
4270:
4271: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null)
4272: then
4273: fnd_message.set_name('BEN','BEN_91731_RULE');
4274: fnd_message.raise_error;
4275: end if;
4276: --
4277: if (p_enrt_cvg_strt_dt_cd <> 'RL' and p_enrt_cvg_strt_dt_rl is not null)
4270:
4271: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null)
4272: then
4273: fnd_message.set_name('BEN','BEN_91731_RULE');
4274: fnd_message.raise_error;
4275: end if;
4276: --
4277: if (p_enrt_cvg_strt_dt_cd <> 'RL' and p_enrt_cvg_strt_dt_rl is not null)
4278: then
4275: end if;
4276: --
4277: if (p_enrt_cvg_strt_dt_cd <> 'RL' and p_enrt_cvg_strt_dt_rl is not null)
4278: then
4279: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4280: fnd_message.raise_error;
4281: end if;
4282:
4283: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null)
4276: --
4277: if (p_enrt_cvg_strt_dt_cd <> 'RL' and p_enrt_cvg_strt_dt_rl is not null)
4278: then
4279: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4280: fnd_message.raise_error;
4281: end if;
4282:
4283: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null)
4284: then
4281: end if;
4282:
4283: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null)
4284: then
4285: fnd_message.set_name('BEN','BEN_91731_RULE');
4286: fnd_message.raise_error;
4287: end if;
4288: if (p_rt_strt_dt_cd <> 'RL' and p_rt_strt_dt_rl is not null)
4289: then
4282:
4283: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null)
4284: then
4285: fnd_message.set_name('BEN','BEN_91731_RULE');
4286: fnd_message.raise_error;
4287: end if;
4288: if (p_rt_strt_dt_cd <> 'RL' and p_rt_strt_dt_rl is not null)
4289: then
4290: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4286: fnd_message.raise_error;
4287: end if;
4288: if (p_rt_strt_dt_cd <> 'RL' and p_rt_strt_dt_rl is not null)
4289: then
4290: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4291: fnd_message.raise_error;
4292: end if;
4293:
4294: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null)
4287: end if;
4288: if (p_rt_strt_dt_cd <> 'RL' and p_rt_strt_dt_rl is not null)
4289: then
4290: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4291: fnd_message.raise_error;
4292: end if;
4293:
4294: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null)
4295: then
4292: end if;
4293:
4294: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null)
4295: then
4296: fnd_message.set_name('BEN','BEN_91731_RULE');
4297: fnd_message.raise_error;
4298: end if;
4299: --
4300: if (p_rt_end_dt_cd <> 'RL' and p_rt_end_dt_rl is not null)
4293:
4294: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null)
4295: then
4296: fnd_message.set_name('BEN','BEN_91731_RULE');
4297: fnd_message.raise_error;
4298: end if;
4299: --
4300: if (p_rt_end_dt_cd <> 'RL' and p_rt_end_dt_rl is not null)
4301: then
4298: end if;
4299: --
4300: if (p_rt_end_dt_cd <> 'RL' and p_rt_end_dt_rl is not null)
4301: then
4302: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4303: fnd_message.raise_error;
4304: end if;
4305:
4306: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null)
4299: --
4300: if (p_rt_end_dt_cd <> 'RL' and p_rt_end_dt_rl is not null)
4301: then
4302: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
4303: fnd_message.raise_error;
4304: end if;
4305:
4306: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null)
4307: then
4304: end if;
4305:
4306: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null)
4307: then
4308: fnd_message.set_name('BEN','BEN_91731_RULE');
4309: fnd_message.raise_error;
4310: end if;
4311: -- Leaving Procedure.
4312: --
4305:
4306: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null)
4307: then
4308: fnd_message.set_name('BEN','BEN_91731_RULE');
4309: fnd_message.raise_error;
4310: end if;
4311: -- Leaving Procedure.
4312: --
4313: hr_utility.set_location('Leaving:'||l_proc,10);
4358: (p_no_mn_cvg_amt_apls_flag='N' and p_mn_cvg_rqd_amt=0)) then
4359: --
4360: -- raise error as is not a valid combination
4361: --
4362: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
4363: fnd_message.raise_error;
4364: --
4365: end if;
4366: --
4359: --
4360: -- raise error as is not a valid combination
4361: --
4362: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
4363: fnd_message.raise_error;
4364: --
4365: end if;
4366: --
4367: -- check if it is a valid combination
4370: (p_no_mx_cvg_amt_apls_flag='N' and p_mx_cvg_alwd_amt=0)) then
4371: --
4372: -- raise error as is not a valid combination
4373: --
4374: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
4375: fnd_message.raise_error;
4376: --
4377: end if;
4378: --
4371: --
4372: -- raise error as is not a valid combination
4373: --
4374: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
4375: fnd_message.raise_error;
4376: --
4377: end if;
4378: --
4379: hr_utility.set_location('Leaving:'||l_proc,10);
4419: if (p_mn_val >= p_mx_val) then
4420: --
4421: -- raise error as is not a valid combination
4422: --
4423: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
4424: fnd_message.raise_error;
4425: --
4426: end if;
4427: --
4420: --
4421: -- raise error as is not a valid combination
4422: --
4423: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
4424: fnd_message.raise_error;
4425: --
4426: end if;
4427: --
4428: hr_utility.set_location('Leaving:'||l_proc, 5);
4498: close c1;
4499: --
4500: -- raise an error as this actl_prem_id has been assigned to oipl(s).
4501: --
4502: fnd_message.set_name('BEN','BEN_91610_PLAN_OPTION_EXCL1');
4503: fnd_message.raise_error;
4504: --
4505: end if;
4506: --
4499: --
4500: -- raise an error as this actl_prem_id has been assigned to oipl(s).
4501: --
4502: fnd_message.set_name('BEN','BEN_91610_PLAN_OPTION_EXCL1');
4503: fnd_message.raise_error;
4504: --
4505: end if;
4506: --
4507: close c1;
4583: if p_nip_pl_uom is null then
4584: --
4585: -- raise an error as Currency field is null when Option Type code is CWB
4586: --
4587: fnd_message.set_name('BEN','BEN_93115_NIP_UOM_RQD');
4588: fnd_message.raise_error;
4589: null;
4590: end if;
4591: --
4584: --
4585: -- raise an error as Currency field is null when Option Type code is CWB
4586: --
4587: fnd_message.set_name('BEN','BEN_93115_NIP_UOM_RQD');
4588: fnd_message.raise_error;
4589: null;
4590: end if;
4591: --
4592: end if;
4695: --
4696: -- raise error as plan can't be made flex credit or imputed shell
4697: -- once eligibility profiles are attached to it
4698: --
4699: fnd_message.set_name('BEN','BEN_94066_PLN_UPD_VAL');
4700: fnd_message.raise_error;
4701: --
4702: else
4703: close c1;
4696: -- raise error as plan can't be made flex credit or imputed shell
4697: -- once eligibility profiles are attached to it
4698: --
4699: fnd_message.set_name('BEN','BEN_94066_PLN_UPD_VAL');
4700: fnd_message.raise_error;
4701: --
4702: else
4703: close c1;
4704: open c2;
4708: --
4709: -- raise error as plan can't be made flex credit or imputed shell
4710: -- once eligibility rule are attached to it
4711: --
4712: fnd_message.set_name('BEN','BEN_94066_PLN_UPD_VAL');
4713: fnd_message.raise_error;
4714: --
4715: end if;
4716: close c2;
4709: -- raise error as plan can't be made flex credit or imputed shell
4710: -- once eligibility rule are attached to it
4711: --
4712: fnd_message.set_name('BEN','BEN_94066_PLN_UPD_VAL');
4713: fnd_message.raise_error;
4714: --
4715: end if;
4716: close c2;
4717: --
5047: --
5048: -- An unhandled or unexpected error has occurred which
5049: -- we must report
5050: --
5051: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5052: fnd_message.set_token('PROCEDURE', l_proc);
5053: fnd_message.set_token('STEP','15');
5054: fnd_message.raise_error;
5055: End dt_update_validate;
5048: -- An unhandled or unexpected error has occurred which
5049: -- we must report
5050: --
5051: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5052: fnd_message.set_token('PROCEDURE', l_proc);
5053: fnd_message.set_token('STEP','15');
5054: fnd_message.raise_error;
5055: End dt_update_validate;
5056: --
5049: -- we must report
5050: --
5051: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5052: fnd_message.set_token('PROCEDURE', l_proc);
5053: fnd_message.set_token('STEP','15');
5054: fnd_message.raise_error;
5055: End dt_update_validate;
5056: --
5057: -- ----------------------------------------------------------------------------
5050: --
5051: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5052: fnd_message.set_token('PROCEDURE', l_proc);
5053: fnd_message.set_token('STEP','15');
5054: fnd_message.raise_error;
5055: End dt_update_validate;
5056: --
5057: -- ----------------------------------------------------------------------------
5058: -- |--------------------------< dt_delete_validate >--------------------------|
5447: --
5448: -- An unhandled or unexpected error has occurred which
5449: -- we must report
5450: --
5451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5452: fnd_message.set_token('PROCEDURE', l_proc);
5453: fnd_message.set_token('STEP','15');
5454: fnd_message.raise_error;
5455: End dt_delete_validate;
5448: -- An unhandled or unexpected error has occurred which
5449: -- we must report
5450: --
5451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5452: fnd_message.set_token('PROCEDURE', l_proc);
5453: fnd_message.set_token('STEP','15');
5454: fnd_message.raise_error;
5455: End dt_delete_validate;
5456: --
5449: -- we must report
5450: --
5451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5452: fnd_message.set_token('PROCEDURE', l_proc);
5453: fnd_message.set_token('STEP','15');
5454: fnd_message.raise_error;
5455: End dt_delete_validate;
5456: --
5457: -- ----------------------------------------------------------------------------
5450: --
5451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5452: fnd_message.set_token('PROCEDURE', l_proc);
5453: fnd_message.set_token('STEP','15');
5454: fnd_message.raise_error;
5455: End dt_delete_validate;
5456: --
5457: -- ----------------------------------------------------------------------------
5458: -- |---------------------------< insert_validate >----------------------------|
6209: close csr_leg_code;
6210: --
6211: -- The primary key is invalid therefore we must error
6212: --
6213: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
6214: fnd_message.raise_error;
6215: --
6216: end if;
6217: --
6210: --
6211: -- The primary key is invalid therefore we must error
6212: --
6213: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
6214: fnd_message.raise_error;
6215: --
6216: end if;
6217: --
6218: close csr_leg_code;