157: p_effective_date => p_effective_date) then
158: --
159: -- raise error as does not exist as lookup
160: --
161: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
162: fnd_message.raise_error;
163: --
164: end if;
165: --
158: --
159: -- raise error as does not exist as lookup
160: --
161: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
162: fnd_message.raise_error;
163: --
164: end if;
165: --
166: -- this value must be unique
171: close chk_unique;
172: --
173: -- raise error as UK1 is violated
174: --
175: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
176: fnd_message.raise_error;
177: --
178: end if;
179: --
172: --
173: -- raise error as UK1 is violated
174: --
175: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
176: fnd_message.raise_error;
177: --
178: end if;
179: --
180: close chk_unique;
263: p_effective_date => p_effective_date) then
264: --
265: -- raise error as does not exist as lookup
266: --
267: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
268:
269: fnd_message.raise_error;
270: --
271: end if;
265: -- raise error as does not exist as lookup
266: --
267: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
268:
269: fnd_message.raise_error;
270: --
271: end if;
272: --
273: -- this value must be unique
278: close chk_unique;
279: --
280: -- raise error as UK1 is violated
281: --
282: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
279: --
280: -- raise error as UK1 is violated
281: --
282: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
287: close chk_unique;
372: close c1;
373: --
374: -- raise error
375: --
376: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
373: --
374: -- raise error
375: --
376: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
381: close c1;
444: p_effective_date => p_effective_date) then
445: --
446: -- raise error as does not exist as lookup
447: --
448: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
449: fnd_message.raise_error;
450: --
451: end if;
452: --
445: --
446: -- raise error as does not exist as lookup
447: --
448: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
449: fnd_message.raise_error;
450: --
451: end if;
452: --
453: end if;
532: p_effective_date => p_effective_date) then
533: --
534: -- raise error as does not exist as lookup
535: --
536: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
537: fnd_message.raise_error;
538: --
539: end if;
540: --
533: --
534: -- raise error as does not exist as lookup
535: --
536: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
537: fnd_message.raise_error;
538: --
539: end if;
540: --
541: -- Only one 'Y' value is allowed within parent
546: close chk_unique;
547: --
548: -- raise error as UK1 is violated
549: --
550: fnd_message.set_name('PAY','Only one record can have a default');
551: fnd_message.raise_error;
552: --
553: end if;
554: --
547: --
548: -- raise error as UK1 is violated
549: --
550: fnd_message.set_name('PAY','Only one record can have a default');
551: fnd_message.raise_error;
552: --
553: end if;
554: --
555: close chk_unique;
663: --
664: -- An unhandled or unexpected error has occurred which
665: -- we must report
666: --
667: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE', l_proc);
669: fnd_message.set_token('STEP','15');
670: fnd_message.raise_error;
671: End dt_update_validate;
664: -- An unhandled or unexpected error has occurred which
665: -- we must report
666: --
667: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE', l_proc);
669: fnd_message.set_token('STEP','15');
670: fnd_message.raise_error;
671: End dt_update_validate;
672: --
665: -- we must report
666: --
667: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE', l_proc);
669: fnd_message.set_token('STEP','15');
670: fnd_message.raise_error;
671: End dt_update_validate;
672: --
673: -- ----------------------------------------------------------------------------
666: --
667: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE', l_proc);
669: fnd_message.set_token('STEP','15');
670: fnd_message.raise_error;
671: End dt_update_validate;
672: --
673: -- ----------------------------------------------------------------------------
674: -- |--------------------------< dt_delete_validate >--------------------------|
765: --
766: -- An unhandled or unexpected error has occurred which
767: -- we must report
768: --
769: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
770: fnd_message.set_token('PROCEDURE', l_proc);
771: fnd_message.set_token('STEP','15');
772: fnd_message.raise_error;
773: End dt_delete_validate;
766: -- An unhandled or unexpected error has occurred which
767: -- we must report
768: --
769: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
770: fnd_message.set_token('PROCEDURE', l_proc);
771: fnd_message.set_token('STEP','15');
772: fnd_message.raise_error;
773: End dt_delete_validate;
774: --
767: -- we must report
768: --
769: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
770: fnd_message.set_token('PROCEDURE', l_proc);
771: fnd_message.set_token('STEP','15');
772: fnd_message.raise_error;
773: End dt_delete_validate;
774: --
775: -- ----------------------------------------------------------------------------
768: --
769: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
770: fnd_message.set_token('PROCEDURE', l_proc);
771: fnd_message.set_token('STEP','15');
772: fnd_message.raise_error;
773: End dt_delete_validate;
774: --
775: -- ----------------------------------------------------------------------------
776: -- |---------------------------< insert_validate >----------------------------|
972: close csr_leg_code;
973: --
974: -- The primary key is invalid therefore we must error
975: --
976: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
977: fnd_message.raise_error;
978: --
979: end if;
980: --
973: --
974: -- The primary key is invalid therefore we must error
975: --
976: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
977: fnd_message.raise_error;
978: --
979: end if;
980: --
981: close csr_leg_code;