211: p_effective_date => p_effective_date) then
212: --
213: -- raise error as does not exist as lookup
214: --
215: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
216: fnd_message.raise_error;
217: --
218: end if;
219: --
212: --
213: -- raise error as does not exist as lookup
214: --
215: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
216: fnd_message.raise_error;
217: --
218: end if;
219: --
220: end if;
298: close c1;
299: --
300: -- raise an error as this acty_base_rt has a record with dflt_flag = 'Y'.
301: --
302: fnd_message.set_name('BEN','BEN_91625_ABR_DFLT_FLG_ERR');
303: fnd_message.raise_error;
304: --
305: end if;
306: --
299: --
300: -- raise an error as this acty_base_rt has a record with dflt_flag = 'Y'.
301: --
302: fnd_message.set_name('BEN','BEN_91625_ABR_DFLT_FLG_ERR');
303: fnd_message.raise_error;
304: --
305: end if;
306: --
307: close c1;
402: --
403: -- An unhandled or unexpected error has occurred which
404: -- we must report
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','15');
409: fnd_message.raise_error;
410: End dt_update_validate;
403: -- An unhandled or unexpected error has occurred which
404: -- we must report
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','15');
409: fnd_message.raise_error;
410: End dt_update_validate;
411: --
404: -- we must report
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','15');
409: fnd_message.raise_error;
410: End dt_update_validate;
411: --
412: -- ----------------------------------------------------------------------------
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','15');
409: fnd_message.raise_error;
410: End dt_update_validate;
411: --
412: -- ----------------------------------------------------------------------------
413: -- |--------------------------< dt_delete_validate >--------------------------|
504: --
505: -- An unhandled or unexpected error has occurred which
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
505: -- An unhandled or unexpected error has occurred which
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------
515: -- |---------------------------< insert_validate >----------------------------|
683: close csr_leg_code;
684: --
685: -- The primary key is invalid therefore we must error
686: --
687: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
688: fnd_message.raise_error;
689: --
690: end if;
691: --
684: --
685: -- The primary key is invalid therefore we must error
686: --
687: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
688: fnd_message.raise_error;
689: --
690: end if;
691: --
692: close csr_leg_code;