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_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_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_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_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_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_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_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
206: open c1;
207: fetch c1 into l_dummy;
208: if c1%found then
209: close c1;
210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
211: fnd_message.raise_error;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'||l_proc, 15);
207: fetch c1 into l_dummy;
208: if c1%found then
209: close c1;
210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
211: fnd_message.raise_error;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'||l_proc, 15);
215: End chk_enrt_ctfn_typ_cd_unique;
271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;
281: --
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;
281: --
282: end if;
344: p_effective_date => p_effective_date) then
345: --
346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
345: --
346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;
346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;
354: --
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;
354: --
355: end if;
454: --
455: -- A referential integrity check was violated therefore
456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --
455: -- A referential integrity check was violated therefore
456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --
463: -- An unhandled or unexpected error has occurred which
456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --
463: -- An unhandled or unexpected error has occurred which
464: -- we must report
462: --
463: -- An unhandled or unexpected error has occurred which
464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
463: -- An unhandled or unexpected error has occurred which
464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --
464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --
472: -- ----------------------------------------------------------------------------
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --
472: -- ----------------------------------------------------------------------------
473: -- |--------------------------< dt_delete_validate >--------------------------|
558: --
559: -- A referential integrity check was violated therefore
560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --
559: -- A referential integrity check was violated therefore
560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --
567: -- An unhandled or unexpected error has occurred which
560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --
567: -- An unhandled or unexpected error has occurred which
568: -- we must report
566: --
567: -- An unhandled or unexpected error has occurred which
568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
567: -- An unhandled or unexpected error has occurred which
568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --
568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --
576: -- ----------------------------------------------------------------------------
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |---------------------------< insert_validate >----------------------------|
761: close csr_leg_code;
762: --
763: -- The primary key is invalid therefore we must error
764: --
765: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
766: fnd_message.raise_error;
767: --
768: end if;
769: --
762: --
763: -- The primary key is invalid therefore we must error
764: --
765: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
766: fnd_message.raise_error;
767: --
768: end if;
769: --
770: close csr_leg_code;