135: p_effective_date => p_effective_date) then
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_rt_end_dt_rl);
141: fnd_message.set_token('TYPE_ID',-67);
142: fnd_message.raise_error;
143: --
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_rt_end_dt_rl);
141: fnd_message.set_token('TYPE_ID',-67);
142: fnd_message.raise_error;
143: --
144: end if;
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_rt_end_dt_rl);
141: fnd_message.set_token('TYPE_ID',-67);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_rt_end_dt_rl);
141: fnd_message.set_token('TYPE_ID',-67);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
146: end if;
206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
212: fnd_message.set_token('TYPE','BEN_RT_END');
213: fnd_message.raise_error;
214: --
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
212: fnd_message.set_token('TYPE','BEN_RT_END');
213: fnd_message.raise_error;
214: --
215: end if;
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
212: fnd_message.set_token('TYPE','BEN_RT_END');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
212: fnd_message.set_token('TYPE','BEN_RT_END');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;
279: p_effective_date => p_effective_date) then
280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rt_strt_dt_rl);
285: fnd_message.set_token('TYPE_ID',-66);
286: fnd_message.raise_error;
287: --
280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rt_strt_dt_rl);
285: fnd_message.set_token('TYPE_ID',-66);
286: fnd_message.raise_error;
287: --
288: end if;
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rt_strt_dt_rl);
285: fnd_message.set_token('TYPE_ID',-66);
286: fnd_message.raise_error;
287: --
288: end if;
289: --
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rt_strt_dt_rl);
285: fnd_message.set_token('TYPE_ID',-66);
286: fnd_message.raise_error;
287: --
288: end if;
289: --
290: 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_rt_strt_dt_cd');
356: fnd_message.set_token('TYPE','BEN_RT_STRT');
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_rt_strt_dt_cd');
356: fnd_message.set_token('TYPE','BEN_RT_STRT');
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_rt_strt_dt_cd');
356: fnd_message.set_token('TYPE','BEN_RT_STRT');
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_rt_strt_dt_cd');
356: fnd_message.set_token('TYPE','BEN_RT_STRT');
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
426: --
427: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
428: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
429: fnd_message.set_token('TYPE_ID',-30);
430: fnd_message.raise_error;
431: --
424: --
425: -- raise error
426: --
427: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
428: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
429: fnd_message.set_token('TYPE_ID',-30);
430: fnd_message.raise_error;
431: --
432: end if;
425: -- raise error
426: --
427: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
428: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
429: fnd_message.set_token('TYPE_ID',-30);
430: fnd_message.raise_error;
431: --
432: end if;
433: --
426: --
427: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
428: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
429: fnd_message.set_token('TYPE_ID',-30);
430: fnd_message.raise_error;
431: --
432: end if;
433: --
434: end if;
494: p_effective_date => p_effective_date) then
495: --
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_enrt_cvg_end_dt_cd');
500: fnd_message.set_token('TYPE','BEN_ENRT_CVG_END');
501: fnd_message.raise_error;
502: --
495: --
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_enrt_cvg_end_dt_cd');
500: fnd_message.set_token('TYPE','BEN_ENRT_CVG_END');
501: fnd_message.raise_error;
502: --
503: end if;
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_enrt_cvg_end_dt_cd');
500: fnd_message.set_token('TYPE','BEN_ENRT_CVG_END');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_enrt_cvg_end_dt_cd');
500: fnd_message.set_token('TYPE','BEN_ENRT_CVG_END');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
505: end if;
567: p_effective_date => p_effective_date) then
568: --
569: -- raise error
570: --
571: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
572: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
573: fnd_message.set_token('TYPE_ID',-29);
574: fnd_message.raise_error;
575: --
568: --
569: -- raise error
570: --
571: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
572: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
573: fnd_message.set_token('TYPE_ID',-29);
574: fnd_message.raise_error;
575: --
576: end if;
569: -- raise error
570: --
571: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
572: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
573: fnd_message.set_token('TYPE_ID',-29);
574: fnd_message.raise_error;
575: --
576: end if;
577: --
570: --
571: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
572: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
573: fnd_message.set_token('TYPE_ID',-29);
574: fnd_message.raise_error;
575: --
576: end if;
577: --
578: end if;
638: p_effective_date => p_effective_date) then
639: --
640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
644: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
645: fnd_message.raise_error;
646: --
639: --
640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
644: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
645: fnd_message.raise_error;
646: --
647: end if;
640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
644: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
644: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
649: end if;