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_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
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_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
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_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
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_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
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_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
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_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
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_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
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_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: end if;
350: p_effective_date => p_effective_date) then
351: --
352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
351: --
352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;
352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;
360: --
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;
360: --
361: end if;
421: p_effective_date => p_effective_date) then
422: --
423: -- raise error as does not exist as lookup
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --
422: --
423: -- raise error as does not exist as lookup
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --
430: end if;
423: -- raise error as does not exist as lookup
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --
430: end if;
431: --
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_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_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_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_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_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_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_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_stl_elig_cant_chg_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_stl_elig_cant_chg_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_stl_elig_cant_chg_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_stl_elig_cant_chg_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
574: end if;
636: p_effective_date => p_effective_date) then
637: --
638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
637: --
638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;
638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;
646: --
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;
646: --
647: end if;
711: or not l_api_updating) then
712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then
714: --
715: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
716: fnd_message.raise_error;
717: --
718: end if;
719: --
712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then
714: --
715: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
716: fnd_message.raise_error;
717: --
718: end if;
719: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
719: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
721: not null then
722: --
723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
724: fnd_message.raise_error;
725: --
726: end if;
727: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
721: not null then
722: --
723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
724: fnd_message.raise_error;
725: --
726: end if;
727: --
728: end if;
737: or not l_api_updating) then
738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then
740: --
741: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
742: fnd_message.raise_error;
743: --
744: end if;
745: --
738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then
740: --
741: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
742: fnd_message.raise_error;
743: --
744: end if;
745: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
745: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
747: not null then
748: --
749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
747: not null then
748: --
749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
754: end if;
859: --
860: -- An unhandled or unexpected error has occurred which
861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
860: -- An unhandled or unexpected error has occurred which
861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --
861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --
869: -- ----------------------------------------------------------------------------
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --
869: -- ----------------------------------------------------------------------------
870: -- |--------------------------< dt_delete_validate >--------------------------|
955: --
956: -- A referential integrity check was violated therefore
957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --
956: -- A referential integrity check was violated therefore
957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --
964: -- An unhandled or unexpected error has occurred which
957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --
964: -- An unhandled or unexpected error has occurred which
965: -- we must report
963: --
964: -- An unhandled or unexpected error has occurred which
965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
964: -- An unhandled or unexpected error has occurred which
965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --
965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --
973: -- ----------------------------------------------------------------------------
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --
973: -- ----------------------------------------------------------------------------
974: -- |---------------------------< insert_validate >----------------------------|
1222: close csr_leg_code;
1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1227: fnd_message.raise_error;
1228: --
1229: end if;
1230: --
1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1227: fnd_message.raise_error;
1228: --
1229: end if;
1230: --
1231: close csr_leg_code;