211: --
212: close c1;
213: --
214: -- raise error
215: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
216: fnd_message.raise_error;
217: --
218: end if;
219: --
212: close c1;
213: --
214: -- raise error
215: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
216: fnd_message.raise_error;
217: --
218: end if;
219: --
220: close c1;
364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91095_INVLD_QUALIFIED_FLAG');
369: fnd_message.raise_error;
370: --
371: end if;
372: --
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91095_INVLD_QUALIFIED_FLAG');
369: fnd_message.raise_error;
370: --
371: end if;
372: --
373: end if;
525: --
526: -- A referential integrity check was violated therefore
527: -- we must error
528: --
529: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
530: fnd_message.set_token('TABLE_NAME', l_table_name);
531: fnd_message.raise_error;
532: When Others Then
533: --
526: -- A referential integrity check was violated therefore
527: -- we must error
528: --
529: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
530: fnd_message.set_token('TABLE_NAME', l_table_name);
531: fnd_message.raise_error;
532: When Others Then
533: --
534: -- An unhandled or unexpected error has occurred which
527: -- we must error
528: --
529: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
530: fnd_message.set_token('TABLE_NAME', l_table_name);
531: fnd_message.raise_error;
532: When Others Then
533: --
534: -- An unhandled or unexpected error has occurred which
535: -- we must report
533: --
534: -- An unhandled or unexpected error has occurred which
535: -- we must report
536: --
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','15');
540: fnd_message.raise_error;
541: End dt_update_validate;
534: -- An unhandled or unexpected error has occurred which
535: -- we must report
536: --
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','15');
540: fnd_message.raise_error;
541: End dt_update_validate;
542: --
535: -- we must report
536: --
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','15');
540: fnd_message.raise_error;
541: End dt_update_validate;
542: --
543: -- ----------------------------------------------------------------------------
536: --
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','15');
540: fnd_message.raise_error;
541: End dt_update_validate;
542: --
543: -- ----------------------------------------------------------------------------
544: -- |--------------------------< dt_delete_validate >--------------------------|
633: --
634: -- A referential integrity check was violated therefore
635: -- we must error
636: --
637: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
638: fnd_message.set_token('TABLE_NAME', l_table_name);
639: fnd_message.raise_error; */
640: ben_utility.child_exists_error(p_table_name => l_table_name);
641: When Others Then
634: -- A referential integrity check was violated therefore
635: -- we must error
636: --
637: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
638: fnd_message.set_token('TABLE_NAME', l_table_name);
639: fnd_message.raise_error; */
640: ben_utility.child_exists_error(p_table_name => l_table_name);
641: When Others Then
642: --
635: -- we must error
636: --
637: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
638: fnd_message.set_token('TABLE_NAME', l_table_name);
639: fnd_message.raise_error; */
640: ben_utility.child_exists_error(p_table_name => l_table_name);
641: When Others Then
642: --
643: -- An unhandled or unexpected error has occurred which
642: --
643: -- An unhandled or unexpected error has occurred which
644: -- we must report
645: --
646: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
647: fnd_message.set_token('PROCEDURE', l_proc);
648: fnd_message.set_token('STEP','15');
649: fnd_message.raise_error;
650: End dt_delete_validate;
643: -- An unhandled or unexpected error has occurred which
644: -- we must report
645: --
646: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
647: fnd_message.set_token('PROCEDURE', l_proc);
648: fnd_message.set_token('STEP','15');
649: fnd_message.raise_error;
650: End dt_delete_validate;
651: --
644: -- we must report
645: --
646: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
647: fnd_message.set_token('PROCEDURE', l_proc);
648: fnd_message.set_token('STEP','15');
649: fnd_message.raise_error;
650: End dt_delete_validate;
651: --
652: -- ----------------------------------------------------------------------------
645: --
646: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
647: fnd_message.set_token('PROCEDURE', l_proc);
648: fnd_message.set_token('STEP','15');
649: fnd_message.raise_error;
650: End dt_delete_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< insert_validate >----------------------------|
837: close csr_leg_code;
838: --
839: -- The primary key is invalid therefore we must error
840: --
841: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
842: fnd_message.raise_error;
843: --
844: end if;
845: */
838: --
839: -- The primary key is invalid therefore we must error
840: --
841: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
842: fnd_message.raise_error;
843: --
844: end if;
845: */
846: --