133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_ignr_prtn_ovrid_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_ignr_prtn_ovrid_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_ignr_prtn_ovrid_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_ignr_prtn_ovrid_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
204: p_effective_date => p_effective_date) then
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_prtn_ovridbl_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_prtn_ovridbl_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_prtn_ovridbl_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_prtn_ovridbl_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
277: p_effective_date => p_effective_date) then
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
283: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
284: fnd_message.raise_error;
285: --
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
283: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
284: fnd_message.raise_error;
285: --
286: end if;
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
283: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
283: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: end if;
350: p_effective_date => p_effective_date) then
351: --
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD', 'p_elig_inelig_cd');
356: fnd_message.set_token('TYPE','BEN_ELIG_INELIG');
357: fnd_message.raise_error;
358: --
351: --
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD', 'p_elig_inelig_cd');
356: fnd_message.set_token('TYPE','BEN_ELIG_INELIG');
357: fnd_message.raise_error;
358: --
359: end if;
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD', 'p_elig_inelig_cd');
356: fnd_message.set_token('TYPE','BEN_ELIG_INELIG');
357: fnd_message.raise_error;
358: --
359: end if;
360: --
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD', 'p_elig_inelig_cd');
356: fnd_message.set_token('TYPE','BEN_ELIG_INELIG');
357: fnd_message.raise_error;
358: --
359: end if;
360: --
361: end if;
423: p_effective_date => p_effective_date) then
424: --
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD', 'p_prtn_eff_strt_dt_cd');
429: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_STRT');
430: fnd_message.raise_error;
431: --
424: --
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD', 'p_prtn_eff_strt_dt_cd');
429: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_STRT');
430: fnd_message.raise_error;
431: --
432: end if;
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD', 'p_prtn_eff_strt_dt_cd');
429: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_STRT');
430: fnd_message.raise_error;
431: --
432: end if;
433: --
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD', 'p_prtn_eff_strt_dt_cd');
429: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_STRT');
430: fnd_message.raise_error;
431: --
432: end if;
433: --
434: end if;
498: p_effective_date => p_effective_date) then
499: --
500: -- raise error
501: --
502: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
503: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
504: fnd_message.set_token('TYPE_ID',-21);
505: fnd_message.raise_error;
506: --
499: --
500: -- raise error
501: --
502: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
503: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
504: fnd_message.set_token('TYPE_ID',-21);
505: fnd_message.raise_error;
506: --
507: end if;
500: -- raise error
501: --
502: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
503: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
504: fnd_message.set_token('TYPE_ID',-21);
505: fnd_message.raise_error;
506: --
507: end if;
508: --
501: --
502: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
503: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
504: fnd_message.set_token('TYPE_ID',-21);
505: fnd_message.raise_error;
506: --
507: end if;
508: --
509: end if;
573: p_effective_date => p_effective_date) then
574: --
575: -- raise error
576: --
577: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
578: fnd_message.set_token('ID',p_prtn_eff_strt_dt_rl);
579: fnd_message.set_token('TYPE_ID',-82);
580: fnd_message.raise_error;
581: --
574: --
575: -- raise error
576: --
577: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
578: fnd_message.set_token('ID',p_prtn_eff_strt_dt_rl);
579: fnd_message.set_token('TYPE_ID',-82);
580: fnd_message.raise_error;
581: --
582: end if;
575: -- raise error
576: --
577: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
578: fnd_message.set_token('ID',p_prtn_eff_strt_dt_rl);
579: fnd_message.set_token('TYPE_ID',-82);
580: fnd_message.raise_error;
581: --
582: end if;
583: --
576: --
577: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
578: fnd_message.set_token('ID',p_prtn_eff_strt_dt_rl);
579: fnd_message.set_token('TYPE_ID',-82);
580: fnd_message.raise_error;
581: --
582: end if;
583: --
584: end if;
646: p_effective_date => p_effective_date) then
647: --
648: -- raise error as does not exist as lookup
649: --
650: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
651: fnd_message.set_token('FIELD', 'p_prtn_eff_end_dt_cd');
652: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_END');
653: fnd_message.raise_error;
654: --
647: --
648: -- raise error as does not exist as lookup
649: --
650: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
651: fnd_message.set_token('FIELD', 'p_prtn_eff_end_dt_cd');
652: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_END');
653: fnd_message.raise_error;
654: --
655: end if;
648: -- raise error as does not exist as lookup
649: --
650: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
651: fnd_message.set_token('FIELD', 'p_prtn_eff_end_dt_cd');
652: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_END');
653: fnd_message.raise_error;
654: --
655: end if;
656: --
649: --
650: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
651: fnd_message.set_token('FIELD', 'p_prtn_eff_end_dt_cd');
652: fnd_message.set_token('TYPE','BEN_PRTN_ELIG_END');
653: fnd_message.raise_error;
654: --
655: end if;
656: --
657: end if;
719: p_effective_date => p_effective_date) then
720: --
721: -- raise error
722: --
723: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
724: fnd_message.set_token('ID',p_prtn_eff_end_dt_rl);
725: fnd_message.set_token('TYPE_ID',-83);
726: fnd_message.raise_error;
727: --
720: --
721: -- raise error
722: --
723: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
724: fnd_message.set_token('ID',p_prtn_eff_end_dt_rl);
725: fnd_message.set_token('TYPE_ID',-83);
726: fnd_message.raise_error;
727: --
728: end if;
721: -- raise error
722: --
723: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
724: fnd_message.set_token('ID',p_prtn_eff_end_dt_rl);
725: fnd_message.set_token('TYPE_ID',-83);
726: fnd_message.raise_error;
727: --
728: end if;
729: --
722: --
723: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
724: fnd_message.set_token('ID',p_prtn_eff_end_dt_rl);
725: fnd_message.set_token('TYPE_ID',-83);
726: fnd_message.raise_error;
727: --
728: end if;
729: --
730: end if;
795: then
796: --
797: -- raise error as does not exist as lookup
798: --
799: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
800: fnd_message.set_token('FIELD', 'p_wait_perd_dt_to_use_cd');
801: fnd_message.set_token('TYPE','BEN_MX_WTG_DT_TO_USE');
802: fnd_message.raise_error;
803: --
796: --
797: -- raise error as does not exist as lookup
798: --
799: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
800: fnd_message.set_token('FIELD', 'p_wait_perd_dt_to_use_cd');
801: fnd_message.set_token('TYPE','BEN_MX_WTG_DT_TO_USE');
802: fnd_message.raise_error;
803: --
804: end if;
797: -- raise error as does not exist as lookup
798: --
799: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
800: fnd_message.set_token('FIELD', 'p_wait_perd_dt_to_use_cd');
801: fnd_message.set_token('TYPE','BEN_MX_WTG_DT_TO_USE');
802: fnd_message.raise_error;
803: --
804: end if;
805: --
798: --
799: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
800: fnd_message.set_token('FIELD', 'p_wait_perd_dt_to_use_cd');
801: fnd_message.set_token('TYPE','BEN_MX_WTG_DT_TO_USE');
802: fnd_message.raise_error;
803: --
804: end if;
805: --
806: end if;
842: hr_utility.set_location('Entering:'||l_proc, 5);
843: --
844: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
845: then
846: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
847: fnd_message.raise_error;
848: end if;
849:
850: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
843: --
844: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
845: then
846: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
847: fnd_message.raise_error;
848: end if;
849:
850: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
851: then
848: end if;
849:
850: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
851: then
852: fnd_message.set_name('BEN','BEN_91731_RULE');
853: fnd_message.raise_error;
854: end if;
855: --
856: --leaving Procedure.
849:
850: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
851: then
852: fnd_message.set_name('BEN','BEN_91731_RULE');
853: fnd_message.raise_error;
854: end if;
855: --
856: --leaving Procedure.
857: --
922: p_effective_date => p_effective_date) then
923: --
924: -- raise error
925: --
926: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
927: fnd_message.set_token('ID',p_wait_perd_dt_to_use_rl);
928: fnd_message.set_token('TYPE_ID',-162);
929: fnd_message.raise_error;
930: --
923: --
924: -- raise error
925: --
926: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
927: fnd_message.set_token('ID',p_wait_perd_dt_to_use_rl);
928: fnd_message.set_token('TYPE_ID',-162);
929: fnd_message.raise_error;
930: --
931: end if;
924: -- raise error
925: --
926: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
927: fnd_message.set_token('ID',p_wait_perd_dt_to_use_rl);
928: fnd_message.set_token('TYPE_ID',-162);
929: fnd_message.raise_error;
930: --
931: end if;
932: --
925: --
926: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
927: fnd_message.set_token('ID',p_wait_perd_dt_to_use_rl);
928: fnd_message.set_token('TYPE_ID',-162);
929: fnd_message.raise_error;
930: --
931: end if;
932: --
933: end if;
993: p_effective_date => p_effective_date) then
994: --
995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_wait_perd_uom');
999: fnd_message.set_token('TYPE','BEN_TM_UOM');
1000: fnd_message.raise_error;
1001: --
994: --
995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_wait_perd_uom');
999: fnd_message.set_token('TYPE','BEN_TM_UOM');
1000: fnd_message.raise_error;
1001: --
1002: end if;
995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_wait_perd_uom');
999: fnd_message.set_token('TYPE','BEN_TM_UOM');
1000: fnd_message.raise_error;
1001: --
1002: end if;
1003: --
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_wait_perd_uom');
999: fnd_message.set_token('TYPE','BEN_TM_UOM');
1000: fnd_message.raise_error;
1001: --
1002: end if;
1003: --
1004: end if;
1068: p_effective_date => p_effective_date) then
1069: --
1070: -- raise error
1071: --
1072: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1073: fnd_message.set_token('ID',p_wait_perd_rl);
1074: fnd_message.set_token('TYPE_ID',-518);
1075: fnd_message.raise_error;
1076: --
1069: --
1070: -- raise error
1071: --
1072: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1073: fnd_message.set_token('ID',p_wait_perd_rl);
1074: fnd_message.set_token('TYPE_ID',-518);
1075: fnd_message.raise_error;
1076: --
1077: end if;
1070: -- raise error
1071: --
1072: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1073: fnd_message.set_token('ID',p_wait_perd_rl);
1074: fnd_message.set_token('TYPE_ID',-518);
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1071: --
1072: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1073: fnd_message.set_token('ID',p_wait_perd_rl);
1074: fnd_message.set_token('TYPE_ID',-518);
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1079: end if;
1141: p_effective_date => p_effective_date) then
1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_mx_poe_uom');
1147: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
1148: fnd_message.raise_error;
1149: --
1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_mx_poe_uom');
1147: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_mx_poe_uom');
1147: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_mx_poe_uom');
1147: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --
1152: end if;
1216: p_effective_date => p_effective_date) then
1217: --
1218: -- raise error
1219: --
1220: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1221: fnd_message.set_token('ID',p_mx_poe_det_dt_rl);
1222: fnd_message.set_token('TYPE_ID',-527);
1223: fnd_message.raise_error;
1224: --
1217: --
1218: -- raise error
1219: --
1220: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1221: fnd_message.set_token('ID',p_mx_poe_det_dt_rl);
1222: fnd_message.set_token('TYPE_ID',-527);
1223: fnd_message.raise_error;
1224: --
1225: end if;
1218: -- raise error
1219: --
1220: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1221: fnd_message.set_token('ID',p_mx_poe_det_dt_rl);
1222: fnd_message.set_token('TYPE_ID',-527);
1223: fnd_message.raise_error;
1224: --
1225: end if;
1226: --
1219: --
1220: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1221: fnd_message.set_token('ID',p_mx_poe_det_dt_rl);
1222: fnd_message.set_token('TYPE_ID',-527);
1223: fnd_message.raise_error;
1224: --
1225: end if;
1226: --
1227: end if;
1291: p_effective_date => p_effective_date) then
1292: --
1293: -- raise error
1294: --
1295: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1296: fnd_message.set_token('ID',p_mx_poe_rl);
1297: fnd_message.set_token('TYPE_ID',-526);
1298: fnd_message.raise_error;
1299: --
1292: --
1293: -- raise error
1294: --
1295: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1296: fnd_message.set_token('ID',p_mx_poe_rl);
1297: fnd_message.set_token('TYPE_ID',-526);
1298: fnd_message.raise_error;
1299: --
1300: end if;
1293: -- raise error
1294: --
1295: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1296: fnd_message.set_token('ID',p_mx_poe_rl);
1297: fnd_message.set_token('TYPE_ID',-526);
1298: fnd_message.raise_error;
1299: --
1300: end if;
1301: --
1294: --
1295: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1296: fnd_message.set_token('ID',p_mx_poe_rl);
1297: fnd_message.set_token('TYPE_ID',-526);
1298: fnd_message.raise_error;
1299: --
1300: end if;
1301: --
1302: --
1365: p_effective_date => p_effective_date) then
1366: --
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD', 'p_mx_poe_det_dt_cd');
1371: fnd_message.set_token('TYPE','BEN_MX_POE_DET_DT');
1372: fnd_message.raise_error;
1373: --
1366: --
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD', 'p_mx_poe_det_dt_cd');
1371: fnd_message.set_token('TYPE','BEN_MX_POE_DET_DT');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD', 'p_mx_poe_det_dt_cd');
1371: fnd_message.set_token('TYPE','BEN_MX_POE_DET_DT');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1375: --
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD', 'p_mx_poe_det_dt_cd');
1371: fnd_message.set_token('TYPE','BEN_MX_POE_DET_DT');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1375: --
1376: end if;
1438: p_effective_date => p_effective_date) then
1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1443: fnd_message.set_token('FIELD', 'p_mx_poe_apls_cd');
1444: fnd_message.set_token('TYPE','BEN_MX_POE_APLS');
1445: fnd_message.raise_error;
1446: --
1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1443: fnd_message.set_token('FIELD', 'p_mx_poe_apls_cd');
1444: fnd_message.set_token('TYPE','BEN_MX_POE_APLS');
1445: fnd_message.raise_error;
1446: --
1447: end if;
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1443: fnd_message.set_token('FIELD', 'p_mx_poe_apls_cd');
1444: fnd_message.set_token('TYPE','BEN_MX_POE_APLS');
1445: fnd_message.raise_error;
1446: --
1447: end if;
1448: --
1441: --
1442: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1443: fnd_message.set_token('FIELD', 'p_mx_poe_apls_cd');
1444: fnd_message.set_token('TYPE','BEN_MX_POE_APLS');
1445: fnd_message.raise_error;
1446: --
1447: end if;
1448: --
1449: end if;
1513: count_them(p_id => p_oipl_id) +
1514: count_them(p_id => p_ptip_id) +
1515: count_them(p_id => p_plip_id) <> 1 then
1516: --
1517: fnd_message.set_name('BEN','BEN_92146_ONLY_ONE_FK');
1518: fnd_message.raise_error;
1519: --
1520: end if;
1521: --
1514: count_them(p_id => p_ptip_id) +
1515: count_them(p_id => p_plip_id) <> 1 then
1516: --
1517: fnd_message.set_name('BEN','BEN_92146_ONLY_ONE_FK');
1518: fnd_message.raise_error;
1519: --
1520: end if;
1521: --
1522: hr_utility.set_location('Leaving:'||l_proc, 5);