153: p_effective_date => p_effective_date) then
154: --
155: -- raise error as does not exist as lookup
156: --
157: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
158: fnd_message.raise_error;
159: --
160: end if;
161: --
154: --
155: -- raise error as does not exist as lookup
156: --
157: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
158: fnd_message.raise_error;
159: --
160: end if;
161: --
162: -- this value must be unique
167: close chk_unique;
168: --
169: -- raise error as UK1 is violated
170: --
171: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
172: fnd_message.raise_error;
173: --
174: end if;
175: --
168: --
169: -- raise error as UK1 is violated
170: --
171: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
172: fnd_message.raise_error;
173: --
174: end if;
175: --
176: close chk_unique;
257: p_effective_date => p_effective_date) then
258: --
259: -- raise error as does not exist as lookup
260: --
261: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
262: fnd_message.raise_error;
263: --
264: end if;
265: --
258: --
259: -- raise error as does not exist as lookup
260: --
261: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
262: fnd_message.raise_error;
263: --
264: end if;
265: --
266: -- Only one 'Y' value is allowed within parent
271: close chk_unique;
272: --
273: -- raise error as UK1 is violated
274: --
275: fnd_message.set_name('PAY','Only one record can have a default');
276: fnd_message.raise_error;
277: --
278: end if;
279: --
272: --
273: -- raise error as UK1 is violated
274: --
275: fnd_message.set_name('PAY','Only one record can have a default');
276: fnd_message.raise_error;
277: --
278: end if;
279: --
280: close chk_unique;
342: p_effective_date => p_effective_date) then
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
351: end if;
433: close c1;
434: --
435: -- raise error
436: --
437: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
438: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
439: fnd_message.set_token('TYPE_ID',-26);
440: fnd_message.raise_error;
441: --
434: --
435: -- raise error
436: --
437: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
438: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
439: fnd_message.set_token('TYPE_ID',-26);
440: fnd_message.raise_error;
441: --
442: end if;
435: -- raise error
436: --
437: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
438: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
439: fnd_message.set_token('TYPE_ID',-26);
440: fnd_message.raise_error;
441: --
442: end if;
443: --
436: --
437: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
438: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
439: fnd_message.set_token('TYPE_ID',-26);
440: fnd_message.raise_error;
441: --
442: end if;
443: --
444: close c1;
506: p_effective_date => p_effective_date) then
507: --
508: -- raise error as does not exist as lookup
509: --
510: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
511: fnd_message.raise_error;
512: --
513: end if;
514: --
507: --
508: -- raise error as does not exist as lookup
509: --
510: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
511: fnd_message.raise_error;
512: --
513: end if;
514: --
515: end if;
620: --
621: -- An unhandled or unexpected error has occurred which
622: -- we must report
623: --
624: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
625: fnd_message.set_token('PROCEDURE', l_proc);
626: fnd_message.set_token('STEP','15');
627: fnd_message.raise_error;
628: End dt_update_validate;
621: -- An unhandled or unexpected error has occurred which
622: -- we must report
623: --
624: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
625: fnd_message.set_token('PROCEDURE', l_proc);
626: fnd_message.set_token('STEP','15');
627: fnd_message.raise_error;
628: End dt_update_validate;
629: --
622: -- we must report
623: --
624: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
625: fnd_message.set_token('PROCEDURE', l_proc);
626: fnd_message.set_token('STEP','15');
627: fnd_message.raise_error;
628: End dt_update_validate;
629: --
630: -- ----------------------------------------------------------------------------
623: --
624: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
625: fnd_message.set_token('PROCEDURE', l_proc);
626: fnd_message.set_token('STEP','15');
627: fnd_message.raise_error;
628: End dt_update_validate;
629: --
630: -- ----------------------------------------------------------------------------
631: -- |--------------------------< dt_delete_validate >--------------------------|
722: --
723: -- An unhandled or unexpected error has occurred which
724: -- we must report
725: --
726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
727: fnd_message.set_token('PROCEDURE', l_proc);
728: fnd_message.set_token('STEP','15');
729: fnd_message.raise_error;
730: End dt_delete_validate;
723: -- An unhandled or unexpected error has occurred which
724: -- we must report
725: --
726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
727: fnd_message.set_token('PROCEDURE', l_proc);
728: fnd_message.set_token('STEP','15');
729: fnd_message.raise_error;
730: End dt_delete_validate;
731: --
724: -- we must report
725: --
726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
727: fnd_message.set_token('PROCEDURE', l_proc);
728: fnd_message.set_token('STEP','15');
729: fnd_message.raise_error;
730: End dt_delete_validate;
731: --
732: -- ----------------------------------------------------------------------------
725: --
726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
727: fnd_message.set_token('PROCEDURE', l_proc);
728: fnd_message.set_token('STEP','15');
729: fnd_message.raise_error;
730: End dt_delete_validate;
731: --
732: -- ----------------------------------------------------------------------------
733: -- |---------------------------< insert_validate >----------------------------|
941: close csr_leg_code;
942: --
943: -- The primary key is invalid therefore we must error
944: --
945: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
946: fnd_message.raise_error;
947: --
948: end if;
949: --
942: --
943: -- The primary key is invalid therefore we must error
944: --
945: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
946: fnd_message.raise_error;
947: --
948: end if;
949: --
950: close csr_leg_code;