102: if c1%notfound then
103: --
104: close c1;
105: --
106: fnd_message.set_name('BEN','BEN_91275_ELIG_PER_OPT_ONP');
107: fnd_message.raise_error;
108: --
109: end if;
110: --
103: --
104: close c1;
105: --
106: fnd_message.set_name('BEN','BEN_91275_ELIG_PER_OPT_ONP');
107: fnd_message.raise_error;
108: --
109: end if;
110: --
111: close c1;
170: --
171: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
172: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
173: --
174: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
175: fnd_message.raise_error;
176: --
177: end if;
178: --
171: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
172: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
173: --
174: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
175: fnd_message.raise_error;
176: --
177: end if;
178: --
179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
178: --
179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
180: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
181: --
182: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
183: fnd_message.raise_error;
184: --
185: end if;
186: --
179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
180: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
181: --
182: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
183: fnd_message.raise_error;
184: --
185: end if;
186: --
187: l_api_updating:= ben_epo_shd.api_updating
201: fetch c1 into l_dummy;
202: if c1%notfound then
203: --
204: close c1;
205: fnd_message.set_name('BEN','MUPPET');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
202: if c1%notfound then
203: --
204: close c1;
205: fnd_message.set_name('BEN','MUPPET');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
210: close c1;
223: fetch c2 into l_dummy;
224: if c2%notfound then
225: --
226: close c2;
227: fnd_message.set_name('BEN','MUPPET');
228: fnd_message.raise_error;
229: --
230: end if;
231: --
224: if c2%notfound then
225: --
226: close c2;
227: fnd_message.set_name('BEN','MUPPET');
228: fnd_message.raise_error;
229: --
230: end if;
231: --
232: close c2;
293: p_effective_date => p_effective_date) then
294: --
295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
294: --
295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;
295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;
303: --
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;
303: --
304: end if;
316: p_effective_date => p_effective_date) then
317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
322: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
323: fnd_message.raise_error;
324: --
317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
322: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
323: fnd_message.raise_error;
324: --
325: end if;
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
322: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
322: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
327: end if;
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
365: --
366: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
367: fnd_message.raise_error;
368: --
369: end if;
370: --
363: --
364: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
365: --
366: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
367: fnd_message.raise_error;
368: --
369: end if;
370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
369: end if;
370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
372: --
373: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
374: fnd_message.raise_error;
375: --
376: end if;
377: --
370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
372: --
373: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
374: fnd_message.raise_error;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);
421: --
422: if (p_age_val is null and p_age_uom is not null) or
423: (p_age_uom is null and p_age_val is not null) then
424: --
425: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
422: if (p_age_val is null and p_age_uom is not null) or
423: (p_age_uom is null and p_age_val is not null) then
424: --
425: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
430: if (p_rt_age_val is null and p_rt_age_uom is not null) or
429: --
430: if (p_rt_age_val is null and p_rt_age_uom is not null) or
431: (p_rt_age_uom is null and p_rt_age_val is not null) then
432: --
433: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
434: fnd_message.raise_error;
435: --
436: end if;
437: --
430: if (p_rt_age_val is null and p_rt_age_uom is not null) or
431: (p_rt_age_uom is null and p_rt_age_val is not null) then
432: --
433: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
434: fnd_message.raise_error;
435: --
436: end if;
437: --
438: l_api_updating := ben_epo_shd.api_updating
453: p_effective_date => p_effective_date) then
454: --
455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
454: --
455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;
455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
464: end if;
476: p_effective_date => p_effective_date) then
477: --
478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('FIELD','p_rt_age_uom');
482: fnd_message.set_token('TYPE','BEN_TM_UOM');
483: fnd_message.raise_error;
484: --
477: --
478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('FIELD','p_rt_age_uom');
482: fnd_message.set_token('TYPE','BEN_TM_UOM');
483: fnd_message.raise_error;
484: --
485: end if;
478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('FIELD','p_rt_age_uom');
482: fnd_message.set_token('TYPE','BEN_TM_UOM');
483: fnd_message.raise_error;
484: --
485: end if;
486: --
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('FIELD','p_rt_age_uom');
482: fnd_message.set_token('TYPE','BEN_TM_UOM');
483: fnd_message.raise_error;
484: --
485: end if;
486: --
487: end if;
545: p_effective_date => p_effective_date) then
546: --
547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
546: --
547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;
547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
556: end if;
614: p_effective_date => p_effective_date) then
615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;
624: --
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;
624: --
625: end if;
670: --
671: if (p_los_val is null and p_los_uom is not null) or
672: (p_los_uom is null and p_los_val is not null) then
673: --
674: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
671: if (p_los_val is null and p_los_uom is not null) or
672: (p_los_uom is null and p_los_val is not null) then
673: --
674: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
679: if (p_rt_los_val is null and p_rt_los_uom is not null) or
678: --
679: if (p_rt_los_val is null and p_rt_los_uom is not null) or
680: (p_rt_los_uom is null and p_rt_los_val is not null) then
681: --
682: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
679: if (p_rt_los_val is null and p_rt_los_uom is not null) or
680: (p_rt_los_uom is null and p_rt_los_val is not null) then
681: --
682: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
687: l_api_updating := ben_epo_shd.api_updating
702: p_effective_date => p_effective_date) then
703: --
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_los_uom');
708: fnd_message.set_token('TYPE','BEN_TM_UOM');
709: fnd_message.raise_error;
710: --
703: --
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_los_uom');
708: fnd_message.set_token('TYPE','BEN_TM_UOM');
709: fnd_message.raise_error;
710: --
711: end if;
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_los_uom');
708: fnd_message.set_token('TYPE','BEN_TM_UOM');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_los_uom');
708: fnd_message.set_token('TYPE','BEN_TM_UOM');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
713: end if;
725: p_effective_date => p_effective_date) then
726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
736: end if;
795: p_effective_date => p_effective_date) 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_prtn_ovridn_rsn_cd');
801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');
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_prtn_ovridn_rsn_cd');
801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');
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_prtn_ovridn_rsn_cd');
801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');
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_prtn_ovridn_rsn_cd');
801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');
802: fnd_message.raise_error;
803: --
804: end if;
805: --
806: end if;
865: p_effective_date => p_effective_date) then
866: --
867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
866: --
867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;
867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;
875: --
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;
875: --
876: end if;
937: p_effective_date => p_effective_date) then
938: --
939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
938: --
939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;
939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;
947: --
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;
947: --
948: end if;
1032: p_effective_date => p_effective_date) then
1033: --
1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1033: --
1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;
1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;
1042: --
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;
1042: --
1043: end if;
1056: p_effective_date => p_effective_date) then
1057: --
1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1057: --
1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;
1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;
1066: --
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;
1066: --
1067: end if;
1080: p_effective_date => p_effective_date) then
1081: --
1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1081: --
1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1091: end if;
1104: p_effective_date => p_effective_date) then
1105: --
1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1105: --
1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --
1115: end if;
1128: p_effective_date => p_effective_date) then
1129: --
1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1129: --
1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;
1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;
1138: --
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;
1138: --
1139: end if;
1152: p_effective_date => p_effective_date) then
1153: --
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1153: --
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --
1163: end if;
1176: p_effective_date => p_effective_date) then
1177: --
1178: -- raise error as does not exist as lookup
1179: --
1180: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1181: fnd_message.set_token('FIELD','p_frz_los_flag');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.raise_error;
1184: --
1177: --
1178: -- raise error as does not exist as lookup
1179: --
1180: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1181: fnd_message.set_token('FIELD','p_frz_los_flag');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1178: -- raise error as does not exist as lookup
1179: --
1180: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1181: fnd_message.set_token('FIELD','p_frz_los_flag');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1179: --
1180: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1181: fnd_message.set_token('FIELD','p_frz_los_flag');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1187: end if;
1200: p_effective_date => p_effective_date) then
1201: --
1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1201: --
1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --
1211: end if;
1224: p_effective_date => p_effective_date) then
1225: --
1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1225: --
1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: --
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: --
1235: end if;
1248: p_effective_date => p_effective_date) then
1249: --
1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1249: --
1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --
1259: end if;
1272: p_effective_date => p_effective_date) then
1273: --
1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1273: --
1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;
1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;
1282: --
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;
1282: --
1283: end if;
1341: p_effective_date => p_effective_date) then
1342: --
1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1342: --
1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;
1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;
1351: --
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;
1351: --
1352: end if;
1451: --
1452: -- A referential integrity check was violated therefore
1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --
1452: -- A referential integrity check was violated therefore
1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --
1460: -- An unhandled or unexpected error has occurred which
1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --
1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report
1459: --
1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --
1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --
1469: -- ----------------------------------------------------------------------------
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --
1469: -- ----------------------------------------------------------------------------
1470: -- |--------------------------< dt_delete_validate >--------------------------|
1555: --
1556: -- A referential integrity check was violated therefore
1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --
1556: -- A referential integrity check was violated therefore
1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --
1564: -- An unhandled or unexpected error has occurred which
1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --
1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report
1563: --
1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --
1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --
1573: -- ----------------------------------------------------------------------------
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --
1573: -- ----------------------------------------------------------------------------
1574: -- |---------------------------< insert_validate >----------------------------|
1887: close csr_leg_code;
1888: --
1889: -- The primary key is invalid therefore we must error
1890: --
1891: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --
1888: --
1889: -- The primary key is invalid therefore we must error
1890: --
1891: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --
1896: close csr_leg_code;