156: close c1;
157: --
158: -- raise error
159: --
160: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
161: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
162: fnd_message.set_token('TYPE_ID',-146);
163: fnd_message.raise_error;
164: --
157: --
158: -- raise error
159: --
160: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
161: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
162: fnd_message.set_token('TYPE_ID',-146);
163: fnd_message.raise_error;
164: --
165: end if;
158: -- raise error
159: --
160: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
161: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
162: fnd_message.set_token('TYPE_ID',-146);
163: fnd_message.raise_error;
164: --
165: end if;
166: --
159: --
160: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
161: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
162: fnd_message.set_token('TYPE_ID',-146);
163: fnd_message.raise_error;
164: --
165: end if;
166: --
167: close c1;
229: p_effective_date => p_effective_date) then
230: --
231: -- raise error as does not exist as lookup
232: --
233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
234: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
235: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
236: fnd_message.raise_error;
237: --
230: --
231: -- raise error as does not exist as lookup
232: --
233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
234: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
235: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
236: fnd_message.raise_error;
237: --
238: end if;
231: -- raise error as does not exist as lookup
232: --
233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
234: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
235: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
236: fnd_message.raise_error;
237: --
238: end if;
239: --
232: --
233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
234: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
235: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
236: fnd_message.raise_error;
237: --
238: end if;
239: --
240: end if;
300: p_effective_date => p_effective_date) then
301: --
302: -- raise error as does not exist as lookup
303: --
304: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
305: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
306: fnd_message.set_token('TYPE','YES_NO');
307: fnd_message.raise_error;
308: --
301: --
302: -- raise error as does not exist as lookup
303: --
304: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
305: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
306: fnd_message.set_token('TYPE','YES_NO');
307: fnd_message.raise_error;
308: --
309: end if;
302: -- raise error as does not exist as lookup
303: --
304: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
305: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
306: fnd_message.set_token('TYPE','YES_NO');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
303: --
304: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
305: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
306: fnd_message.set_token('TYPE','YES_NO');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
311: end if;
371: p_effective_date => p_effective_date) then
372: --
373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_enrt_cd');
377: fnd_message.set_token('TYPE','BEN_ENRT');
378: fnd_message.raise_error;
379: --
372: --
373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_enrt_cd');
377: fnd_message.set_token('TYPE','BEN_ENRT');
378: fnd_message.raise_error;
379: --
380: end if;
373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_enrt_cd');
377: fnd_message.set_token('TYPE','BEN_ENRT');
378: fnd_message.raise_error;
379: --
380: end if;
381: --
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_enrt_cd');
377: fnd_message.set_token('TYPE','BEN_ENRT');
378: fnd_message.raise_error;
379: --
380: end if;
381: --
382: end if;
465: close c1;
466: --
467: -- raise error
468: --
469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
470: fnd_message.set_token('ID',p_enrt_rl);
471: fnd_message.set_token('TYPE_ID',-393);
472: fnd_message.raise_error;
473: --
466: --
467: -- raise error
468: --
469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
470: fnd_message.set_token('ID',p_enrt_rl);
471: fnd_message.set_token('TYPE_ID',-393);
472: fnd_message.raise_error;
473: --
474: end if;
467: -- raise error
468: --
469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
470: fnd_message.set_token('ID',p_enrt_rl);
471: fnd_message.set_token('TYPE_ID',-393);
472: fnd_message.raise_error;
473: --
474: end if;
475: --
468: --
469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
470: fnd_message.set_token('ID',p_enrt_rl);
471: fnd_message.set_token('TYPE_ID',-393);
472: fnd_message.raise_error;
473: --
474: end if;
475: --
476: close c1;
538: p_effective_date => p_effective_date) then
539: --
540: -- raise error as does not exist as lookup
541: --
542: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
543: fnd_message.set_token('FIELD','p_dflt_flag');
544: fnd_message.set_token('TYPE','YES_NO');
545: fnd_message.raise_error;
546: --
539: --
540: -- raise error as does not exist as lookup
541: --
542: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
543: fnd_message.set_token('FIELD','p_dflt_flag');
544: fnd_message.set_token('TYPE','YES_NO');
545: fnd_message.raise_error;
546: --
547: end if;
540: -- raise error as does not exist as lookup
541: --
542: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
543: fnd_message.set_token('FIELD','p_dflt_flag');
544: fnd_message.set_token('TYPE','YES_NO');
545: fnd_message.raise_error;
546: --
547: end if;
548: --
541: --
542: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
543: fnd_message.set_token('FIELD','p_dflt_flag');
544: fnd_message.set_token('TYPE','YES_NO');
545: fnd_message.raise_error;
546: --
547: end if;
548: --
549: end if;
632: close c1;
633: --
634: -- raise error
635: --
636: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
637: fnd_message.set_token('ID',p_dflt_enrt_rl);
638: fnd_message.set_token('TYPE_ID',-32);
639: fnd_message.raise_error;
640: --
633: --
634: -- raise error
635: --
636: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
637: fnd_message.set_token('ID',p_dflt_enrt_rl);
638: fnd_message.set_token('TYPE_ID',-32);
639: fnd_message.raise_error;
640: --
641: end if;
634: -- raise error
635: --
636: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
637: fnd_message.set_token('ID',p_dflt_enrt_rl);
638: fnd_message.set_token('TYPE_ID',-32);
639: fnd_message.raise_error;
640: --
641: end if;
642: --
635: --
636: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
637: fnd_message.set_token('ID',p_dflt_enrt_rl);
638: fnd_message.set_token('TYPE_ID',-32);
639: fnd_message.raise_error;
640: --
641: end if;
642: --
643: close c1;
705: p_effective_date => p_effective_date) then
706: --
707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
711: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
712: fnd_message.raise_error;
713: --
706: --
707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
711: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
712: fnd_message.raise_error;
713: --
714: end if;
707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
711: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
712: fnd_message.raise_error;
713: --
714: end if;
715: --
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
711: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
712: fnd_message.raise_error;
713: --
714: end if;
715: --
716: end if;
776: p_effective_date => p_effective_date) then
777: --
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
777: --
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
786: --
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
786: --
787: end if;
848: p_effective_date => p_effective_date) then
849: --
850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
854: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
855: fnd_message.raise_error;
856: --
849: --
850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
854: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
855: fnd_message.raise_error;
856: --
857: end if;
850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
854: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
855: fnd_message.raise_error;
856: --
857: end if;
858: --
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
854: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
855: fnd_message.raise_error;
856: --
857: end if;
858: --
859: end if;