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_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
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_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
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_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
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_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
206: p_effective_date => p_effective_date) then
207: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
207: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
215: end if;
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
215: end if;
216: --
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: 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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: end if;
348: p_effective_date => p_effective_date) then
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
357: end if;
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
359: end if;
421: p_effective_date => p_effective_date) then
422: --
423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
422: --
423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
430: end if;
423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
430: end if;
431: --
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
430: end if;
431: --
432: end if;
492: p_effective_date => p_effective_date) then
493: --
494: -- raise error as does not exist as lookup
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --
493: --
494: -- raise error as does not exist as lookup
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;
494: -- raise error as does not exist as lookup
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;
502: --
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;
502: --
503: end if;
563: p_effective_date => p_effective_date) then
564: --
565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
564: --
565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
574: end if;
634: p_effective_date => p_effective_date) then
635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: end if;
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_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
712: fnd_message.raise_error;
713: --
714: end if;
715: --
716: end if;
821: --
822: -- An unhandled or unexpected error has occurred which
823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
822: -- An unhandled or unexpected error has occurred which
823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --
823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --
831: -- ----------------------------------------------------------------------------
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --
831: -- ----------------------------------------------------------------------------
832: -- |--------------------------< dt_delete_validate >--------------------------|
917: --
918: -- A referential integrity check was violated therefore
919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --
918: -- A referential integrity check was violated therefore
919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --
926: -- An unhandled or unexpected error has occurred which
919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --
926: -- An unhandled or unexpected error has occurred which
927: -- we must report
925: --
926: -- An unhandled or unexpected error has occurred which
927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
926: -- An unhandled or unexpected error has occurred which
927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --
927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --
935: -- ----------------------------------------------------------------------------
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --
935: -- ----------------------------------------------------------------------------
936: -- |---------------------------< insert_validate >----------------------------|
1176: close csr_leg_code;
1177: --
1178: -- The primary key is invalid therefore we must error
1179: --
1180: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1181: fnd_message.raise_error;
1182: --
1183: end if;
1184: --
1177: --
1178: -- The primary key is invalid therefore we must error
1179: --
1180: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1181: fnd_message.raise_error;
1182: --
1183: end if;
1184: --
1185: close csr_leg_code;