135: fetch c1 into v_dummy;
136: --
137: if c1%found then
138: close c1;
139: fnd_message.set_name('BEN','BEN_91697_PER_ID_BNFT_BAL_ID_U');
140: fnd_message.raise_error;
141: end if;
142: --
143: close c1;
136: --
137: if c1%found then
138: close c1;
139: fnd_message.set_name('BEN','BEN_91697_PER_ID_BNFT_BAL_ID_U');
140: fnd_message.raise_error;
141: end if;
142: --
143: close c1;
144: --
237: --
238: -- An unhandled or unexpected error has occurred which
239: -- we must report
240: --
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','15');
244: fnd_message.raise_error;
245: End dt_update_validate;
238: -- An unhandled or unexpected error has occurred which
239: -- we must report
240: --
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','15');
244: fnd_message.raise_error;
245: End dt_update_validate;
246: --
239: -- we must report
240: --
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','15');
244: fnd_message.raise_error;
245: End dt_update_validate;
246: --
247: -- ----------------------------------------------------------------------------
240: --
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','15');
244: fnd_message.raise_error;
245: End dt_update_validate;
246: --
247: -- ----------------------------------------------------------------------------
248: -- |--------------------------< dt_delete_validate >--------------------------|
340: --
341: -- An unhandled or unexpected error has occurred which
342: -- we must report
343: --
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','15');
347: fnd_message.raise_error;
348: End dt_delete_validate;
341: -- An unhandled or unexpected error has occurred which
342: -- we must report
343: --
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','15');
347: fnd_message.raise_error;
348: End dt_delete_validate;
349: --
342: -- we must report
343: --
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','15');
347: fnd_message.raise_error;
348: End dt_delete_validate;
349: --
350: -- ----------------------------------------------------------------------------
343: --
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','15');
347: fnd_message.raise_error;
348: End dt_delete_validate;
349: --
350: -- ----------------------------------------------------------------------------
351: -- |---------------------------< insert_validate >----------------------------|
496: close csr_leg_code;
497: --
498: -- The primary key is invalid therefore we must error
499: --
500: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
497: --
498: -- The primary key is invalid therefore we must error
499: --
500: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
505: close csr_leg_code;