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_no_mx_cvg_incr_apls_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_no_mx_cvg_incr_apls_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_no_mx_cvg_incr_apls_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_no_mx_cvg_incr_apls_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_no_mn_cvg_incr_apls_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_no_mn_cvg_incr_apls_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_no_mn_cvg_incr_apls_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_no_mn_cvg_incr_apls_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
275: p_effective_date => p_effective_date) then
276: --
277: -- raise error as does not exist as lookup
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
276: --
277: -- raise error as does not exist as lookup
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
284: end if;
277: -- raise error as does not exist as lookup
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
284: end if;
285: --
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
284: end if;
285: --
286: end if;
346: p_effective_date => p_effective_date) then
347: --
348: -- raise error as does not exist as lookup
349: --
350: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
351: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
352: fnd_message.set_token('TYPE','BEN_CVG_INCR_R_DECR_ONLY');
353: fnd_message.raise_error;
354: --
347: --
348: -- raise error as does not exist as lookup
349: --
350: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
351: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
352: fnd_message.set_token('TYPE','BEN_CVG_INCR_R_DECR_ONLY');
353: fnd_message.raise_error;
354: --
355: end if;
348: -- raise error as does not exist as lookup
349: --
350: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
351: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
352: fnd_message.set_token('TYPE','BEN_CVG_INCR_R_DECR_ONLY');
353: fnd_message.raise_error;
354: --
355: end if;
356: --
349: --
350: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
351: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
352: fnd_message.set_token('TYPE','BEN_CVG_INCR_R_DECR_ONLY');
353: fnd_message.raise_error;
354: --
355: end if;
356: --
357: end if;
417: p_effective_date => p_effective_date) then
418: --
419: -- raise error as does not exist as lookup
420: --
421: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
422: fnd_message.set_token('FIELD','p_unsspnd_enrt_cd');
423: fnd_message.set_token('TYPE','BEN_UNSSPND_ENRT');
424: fnd_message.raise_error;
425: --
418: --
419: -- raise error as does not exist as lookup
420: --
421: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
422: fnd_message.set_token('FIELD','p_unsspnd_enrt_cd');
423: fnd_message.set_token('TYPE','BEN_UNSSPND_ENRT');
424: fnd_message.raise_error;
425: --
426: end if;
419: -- raise error as does not exist as lookup
420: --
421: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
422: fnd_message.set_token('FIELD','p_unsspnd_enrt_cd');
423: fnd_message.set_token('TYPE','BEN_UNSSPND_ENRT');
424: fnd_message.raise_error;
425: --
426: end if;
427: --
420: --
421: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
422: fnd_message.set_token('FIELD','p_unsspnd_enrt_cd');
423: fnd_message.set_token('TYPE','BEN_UNSSPND_ENRT');
424: fnd_message.raise_error;
425: --
426: end if;
427: --
428: end if;
488: p_effective_date => p_effective_date) then
489: --
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD','p_dflt_to_asn_pndg_ctfn_cd');
494: fnd_message.set_token('TYPE','BEN_DFLT_TO_ASN_PNDG_CTFN');
495: fnd_message.raise_error;
496: --
489: --
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD','p_dflt_to_asn_pndg_ctfn_cd');
494: fnd_message.set_token('TYPE','BEN_DFLT_TO_ASN_PNDG_CTFN');
495: fnd_message.raise_error;
496: --
497: end if;
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD','p_dflt_to_asn_pndg_ctfn_cd');
494: fnd_message.set_token('TYPE','BEN_DFLT_TO_ASN_PNDG_CTFN');
495: fnd_message.raise_error;
496: --
497: end if;
498: --
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD','p_dflt_to_asn_pndg_ctfn_cd');
494: fnd_message.set_token('TYPE','BEN_DFLT_TO_ASN_PNDG_CTFN');
495: fnd_message.raise_error;
496: --
497: end if;
498: --
499: end if;
562: p_effective_date => p_effective_date) then
563: --
564: -- raise error
565: --
566: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
567: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
568: fnd_message.set_token('TYPE_ID',-454);
569: fnd_message.raise_error;
570: --
563: --
564: -- raise error
565: --
566: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
567: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
568: fnd_message.set_token('TYPE_ID',-454);
569: fnd_message.raise_error;
570: --
571: end if;
564: -- raise error
565: --
566: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
567: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
568: fnd_message.set_token('TYPE_ID',-454);
569: fnd_message.raise_error;
570: --
571: end if;
572: --
565: --
566: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
567: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
568: fnd_message.set_token('TYPE_ID',-454);
569: fnd_message.raise_error;
570: --
571: end if;
572: --
573: end if;
635: p_effective_date => p_effective_date) then
636: --
637: -- raise error
638: --
639: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
640: fnd_message.set_token('ID',p_mn_cvg_rl);
641: fnd_message.set_token('TYPE_ID',-164);
642: fnd_message.raise_error;
643: --
636: --
637: -- raise error
638: --
639: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
640: fnd_message.set_token('ID',p_mn_cvg_rl);
641: fnd_message.set_token('TYPE_ID',-164);
642: fnd_message.raise_error;
643: --
644: end if;
637: -- raise error
638: --
639: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
640: fnd_message.set_token('ID',p_mn_cvg_rl);
641: fnd_message.set_token('TYPE_ID',-164);
642: fnd_message.raise_error;
643: --
644: end if;
645: --
638: --
639: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
640: fnd_message.set_token('ID',p_mn_cvg_rl);
641: fnd_message.set_token('TYPE_ID',-164);
642: fnd_message.raise_error;
643: --
644: end if;
645: --
646: end if;
708: p_effective_date => p_effective_date) then
709: --
710: -- raise error
711: --
712: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
713: fnd_message.set_token('ID',p_mx_cvg_rl);
714: fnd_message.set_token('TYPE_ID',-161);
715: fnd_message.raise_error;
716: --
709: --
710: -- raise error
711: --
712: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
713: fnd_message.set_token('ID',p_mx_cvg_rl);
714: fnd_message.set_token('TYPE_ID',-161);
715: fnd_message.raise_error;
716: --
717: end if;
710: -- raise error
711: --
712: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
713: fnd_message.set_token('ID',p_mx_cvg_rl);
714: fnd_message.set_token('TYPE_ID',-161);
715: fnd_message.raise_error;
716: --
717: end if;
718: --
711: --
712: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
713: fnd_message.set_token('ID',p_mx_cvg_rl);
714: fnd_message.set_token('TYPE_ID',-161);
715: fnd_message.raise_error;
716: --
717: end if;
718: --
719: end if;
815: if c1%found then
816: --
817: close c1;
818: hr_utility.set_location('Inside :'||l_proc, 10);
819: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
820: fnd_message.raise_error;
821: --
822: else
823: --
816: --
817: close c1;
818: hr_utility.set_location('Inside :'||l_proc, 10);
819: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
820: fnd_message.raise_error;
821: --
822: else
823: --
824: close c1;
832: if c2%found then
833: --
834: close c2;
835: hr_utility.set_location('Inside :'||l_proc, 15);
836: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
837: fnd_message.raise_error;
838: --
839: else
840: --
833: --
834: close c2;
835: hr_utility.set_location('Inside :'||l_proc, 15);
836: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
837: fnd_message.raise_error;
838: --
839: else
840: --
841: close c2;