169: --
170: -- An unhandled or unexpected error has occurred which
171: -- we must report
172: --
173: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
174: fnd_message.set_token('PROCEDURE', l_proc);
175: fnd_message.set_token('STEP','15');
176: fnd_message.raise_error;
177: End dt_update_validate;
170: -- An unhandled or unexpected error has occurred which
171: -- we must report
172: --
173: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
174: fnd_message.set_token('PROCEDURE', l_proc);
175: fnd_message.set_token('STEP','15');
176: fnd_message.raise_error;
177: End dt_update_validate;
178: --
171: -- we must report
172: --
173: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
174: fnd_message.set_token('PROCEDURE', l_proc);
175: fnd_message.set_token('STEP','15');
176: fnd_message.raise_error;
177: End dt_update_validate;
178: --
179: -- ----------------------------------------------------------------------------
172: --
173: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
174: fnd_message.set_token('PROCEDURE', l_proc);
175: fnd_message.set_token('STEP','15');
176: fnd_message.raise_error;
177: End dt_update_validate;
178: --
179: -- ----------------------------------------------------------------------------
180: -- |--------------------------< dt_delete_validate >--------------------------|
272: --
273: -- An unhandled or unexpected error has occurred which
274: -- we must report
275: --
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','15');
279: fnd_message.raise_error;
280: End dt_delete_validate;
273: -- An unhandled or unexpected error has occurred which
274: -- we must report
275: --
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','15');
279: fnd_message.raise_error;
280: End dt_delete_validate;
281: --
274: -- we must report
275: --
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','15');
279: fnd_message.raise_error;
280: End dt_delete_validate;
281: --
282: -- ----------------------------------------------------------------------------
275: --
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','15');
279: fnd_message.raise_error;
280: End dt_delete_validate;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |---------------------------< insert_validate >----------------------------|
411: close csr_leg_code;
412: --
413: -- The primary key is invalid therefore we must error
414: --
415: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
416: fnd_message.raise_error;
417: --
418: end if;
419: --
412: --
413: -- The primary key is invalid therefore we must error
414: --
415: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
416: fnd_message.raise_error;
417: --
418: end if;
419: --
420: close csr_leg_code;