150: close chk_unique;
151: --
152: -- raise error as UK1 is violated
153: --
154: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
151: --
152: -- raise error as UK1 is violated
153: --
154: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
159: close chk_unique;
240: close chk_unique;
241: --
242: -- raise error as UK1 is violated
243: --
244: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
245: fnd_message.raise_error;
246: --
247: end if;
248: --
241: --
242: -- raise error as UK1 is violated
243: --
244: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
245: fnd_message.raise_error;
246: --
247: end if;
248: --
249: close chk_unique;
346: --
347: -- An unhandled or unexpected error has occurred which
348: -- we must report
349: --
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','15');
353: fnd_message.raise_error;
354: End dt_update_validate;
347: -- An unhandled or unexpected error has occurred which
348: -- we must report
349: --
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','15');
353: fnd_message.raise_error;
354: End dt_update_validate;
355: --
348: -- we must report
349: --
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','15');
353: fnd_message.raise_error;
354: End dt_update_validate;
355: --
356: -- ----------------------------------------------------------------------------
349: --
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','15');
353: fnd_message.raise_error;
354: End dt_update_validate;
355: --
356: -- ----------------------------------------------------------------------------
357: -- |--------------------------< dt_delete_validate >--------------------------|
448: --
449: -- An unhandled or unexpected error has occurred which
450: -- we must report
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','15');
455: fnd_message.raise_error;
456: End dt_delete_validate;
449: -- An unhandled or unexpected error has occurred which
450: -- we must report
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','15');
455: fnd_message.raise_error;
456: End dt_delete_validate;
457: --
450: -- we must report
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','15');
455: fnd_message.raise_error;
456: End dt_delete_validate;
457: --
458: -- ----------------------------------------------------------------------------
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','15');
455: fnd_message.raise_error;
456: End dt_delete_validate;
457: --
458: -- ----------------------------------------------------------------------------
459: -- |---------------------------< insert_validate >----------------------------|
627: close csr_leg_code;
628: --
629: -- The primary key is invalid therefore we must error
630: --
631: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
632: fnd_message.raise_error;
633: --
634: end if;
635: --
628: --
629: -- The primary key is invalid therefore we must error
630: --
631: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
632: fnd_message.raise_error;
633: --
634: end if;
635: --
636: close csr_leg_code;