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_prtn_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_PRTN_CTFN_TYP');
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_prtn_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_PRTN_CTFN_TYP');
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_prtn_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_PRTN_CTFN_TYP');
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_prtn_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_PRTN_CTFN_TYP');
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_ctfn_rqd_when_rl);
212: fnd_message.set_token('TYPE_ID',-143);
213: fnd_message.raise_error;
214: end if;
207: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
212: fnd_message.set_token('TYPE_ID',-143);
213: fnd_message.raise_error;
214: end if;
215: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
212: fnd_message.set_token('TYPE_ID',-143);
213: fnd_message.raise_error;
214: end if;
215: --
216: end if;
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
212: fnd_message.set_token('TYPE_ID',-143);
213: fnd_message.raise_error;
214: end if;
215: --
216: end if;
217: --
276: p_effective_date => p_effective_date) then
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_lack_ctfn_sspnd_elig_flag');
282: fnd_message.set_token('TYPE','YES_NO');
283: fnd_message.raise_error;
284: --
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_lack_ctfn_sspnd_elig_flag');
282: fnd_message.set_token('TYPE','YES_NO');
283: fnd_message.raise_error;
284: --
285: end if;
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_lack_ctfn_sspnd_elig_flag');
282: fnd_message.set_token('TYPE','YES_NO');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_lack_ctfn_sspnd_elig_flag');
282: fnd_message.set_token('TYPE','YES_NO');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
287: end if;
347: p_effective_date => p_effective_date) then
348: --
349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_pfd_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
348: --
349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_pfd_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;
349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_pfd_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;
357: --
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_pfd_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;
357: --
358: end if;
446: --
447: -- A referential integrity check was violated therefore
448: -- we must error
449: --
450: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
451: fnd_message.set_token('TABLE_NAME', l_table_name);
452: fnd_message.raise_error;
453: When Others Then
454: --
447: -- A referential integrity check was violated therefore
448: -- we must error
449: --
450: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
451: fnd_message.set_token('TABLE_NAME', l_table_name);
452: fnd_message.raise_error;
453: When Others Then
454: --
455: -- An unhandled or unexpected error has occurred which
448: -- we must error
449: --
450: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
451: fnd_message.set_token('TABLE_NAME', l_table_name);
452: fnd_message.raise_error;
453: When Others Then
454: --
455: -- An unhandled or unexpected error has occurred which
456: -- we must report
454: --
455: -- An unhandled or unexpected error has occurred which
456: -- we must report
457: --
458: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
459: fnd_message.set_token('PROCEDURE', l_proc);
460: fnd_message.set_token('STEP','15');
461: fnd_message.raise_error;
462: End dt_update_validate;
455: -- An unhandled or unexpected error has occurred which
456: -- we must report
457: --
458: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
459: fnd_message.set_token('PROCEDURE', l_proc);
460: fnd_message.set_token('STEP','15');
461: fnd_message.raise_error;
462: End dt_update_validate;
463: --
456: -- we must report
457: --
458: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
459: fnd_message.set_token('PROCEDURE', l_proc);
460: fnd_message.set_token('STEP','15');
461: fnd_message.raise_error;
462: End dt_update_validate;
463: --
464: -- ----------------------------------------------------------------------------
457: --
458: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
459: fnd_message.set_token('PROCEDURE', l_proc);
460: fnd_message.set_token('STEP','15');
461: fnd_message.raise_error;
462: End dt_update_validate;
463: --
464: -- ----------------------------------------------------------------------------
465: -- |--------------------------< dt_delete_validate >--------------------------|
550: --
551: -- A referential integrity check was violated therefore
552: -- we must error
553: --
554: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
555: fnd_message.set_token('TABLE_NAME', l_table_name);
556: fnd_message.raise_error;
557: When Others Then
558: --
551: -- A referential integrity check was violated therefore
552: -- we must error
553: --
554: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
555: fnd_message.set_token('TABLE_NAME', l_table_name);
556: fnd_message.raise_error;
557: When Others Then
558: --
559: -- An unhandled or unexpected error has occurred which
552: -- we must error
553: --
554: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
555: fnd_message.set_token('TABLE_NAME', l_table_name);
556: fnd_message.raise_error;
557: When Others Then
558: --
559: -- An unhandled or unexpected error has occurred which
560: -- we must report
558: --
559: -- An unhandled or unexpected error has occurred which
560: -- we must report
561: --
562: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
563: fnd_message.set_token('PROCEDURE', l_proc);
564: fnd_message.set_token('STEP','15');
565: fnd_message.raise_error;
566: End dt_delete_validate;
559: -- An unhandled or unexpected error has occurred which
560: -- we must report
561: --
562: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
563: fnd_message.set_token('PROCEDURE', l_proc);
564: fnd_message.set_token('STEP','15');
565: fnd_message.raise_error;
566: End dt_delete_validate;
567: --
560: -- we must report
561: --
562: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
563: fnd_message.set_token('PROCEDURE', l_proc);
564: fnd_message.set_token('STEP','15');
565: fnd_message.raise_error;
566: End dt_delete_validate;
567: --
568: -- ----------------------------------------------------------------------------
561: --
562: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
563: fnd_message.set_token('PROCEDURE', l_proc);
564: fnd_message.set_token('STEP','15');
565: fnd_message.raise_error;
566: End dt_delete_validate;
567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< insert_validate >----------------------------|
746: close csr_leg_code;
747: --
748: -- The primary key is invalid therefore we must error
749: --
750: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
751: fnd_message.raise_error;
752: --
753: end if;
754: --
747: --
748: -- The primary key is invalid therefore we must error
749: --
750: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
751: fnd_message.raise_error;
752: --
753: end if;
754: --
755: close csr_leg_code;