135: p_effective_date => p_effective_date) then
136: --
137: -- raise error as does not exist as lookup
138: --
139: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: -- raise error as does not exist as lookup
138: --
139: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
205: open c1;
206: fetch c1 into l_dummy;
207: if c1%found then
208: close c1;
209: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
210: fnd_message.raise_error;
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc, 15);
206: fetch c1 into l_dummy;
207: if c1%found then
208: close c1;
209: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
210: fnd_message.raise_error;
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc, 15);
214: --
272: p_effective_date => p_effective_date) then
273: --
274: -- raise error as does not exist as lookup
275: --
276: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
277: fnd_message.raise_error;
278: --
279: end if;
280: --
273: --
274: -- raise error as does not exist as lookup
275: --
276: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
277: fnd_message.raise_error;
278: --
279: end if;
280: --
281: 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',-26);
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',-26);
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',-26);
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',-26);
351: fnd_message.raise_error;
352: --
353: end if;
354: --
355: end if;
449: --
450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: End dt_update_validate;
450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: End dt_update_validate;
458: --
451: -- we must report
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: End dt_update_validate;
458: --
459: -- ----------------------------------------------------------------------------
452: --
453: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
454: fnd_message.set_token('PROCEDURE', l_proc);
455: fnd_message.set_token('STEP','15');
456: fnd_message.raise_error;
457: End dt_update_validate;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |--------------------------< dt_delete_validate >--------------------------|
551: --
552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --
561: -- ----------------------------------------------------------------------------
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< insert_validate >----------------------------|
745: close csr_leg_code;
746: --
747: -- The primary key is invalid therefore we must error
748: --
749: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
746: --
747: -- The primary key is invalid therefore we must error
748: --
749: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
754: close csr_leg_code;