132: open c1;
133: fetch c1 into l_dummy;
134: if c1%found then
135: close c1;
136: fnd_message.set_name('BEN','BEN_91420_VRBL_RT_RL_NOT_ALWD');
137: fnd_message.raise_error;
138: end if;
139: close c1;
140: end if;
133: fetch c1 into l_dummy;
134: if c1%found then
135: close c1;
136: fnd_message.set_name('BEN','BEN_91420_VRBL_RT_RL_NOT_ALWD');
137: fnd_message.raise_error;
138: end if;
139: close c1;
140: end if;
141: --
191: open c1;
192: fetch c1 into l_dummy;
193: if c1%found then
194: close c1;
195: fnd_message.set_name('BEN','BEN_92987_CHK_FOR_RL_OR_RT');
196: fnd_message.raise_error;
197: end if;
198: close c1;
199: end if;
192: fetch c1 into l_dummy;
193: if c1%found then
194: close c1;
195: fnd_message.set_name('BEN','BEN_92987_CHK_FOR_RL_OR_RT');
196: fnd_message.raise_error;
197: end if;
198: close c1;
199: end if;
200: --
271:
272: --bug 3960415
273: if p_formula_id is null then
274:
275: fnd_message.set_name('BEN','BEN_94107_FORMULA_NAME_NULL');
276: fnd_message.raise_error;
277:
278: else
279:
272: --bug 3960415
273: if p_formula_id is null then
274:
275: fnd_message.set_name('BEN','BEN_94107_FORMULA_NAME_NULL');
276: fnd_message.raise_error;
277:
278: else
279:
280: --
291: close c1;
292: --
293: -- raise error
294: --
295: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
296: fnd_message.raise_error;
297: --
298: end if;
299: --
292: --
293: -- raise error
294: --
295: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
296: fnd_message.raise_error;
297: --
298: end if;
299: --
300: end if;
363: close c_chk_dup_vrbl_rt_rl;
364: --
365: -- raise error as duplicate rule has been entered
366: --
367: fnd_message.set_name('BEN','BEN_93367_DUP_VAPRO_RL_FOR_ABR');
368: fnd_message.raise_error;
369: --
370: end if;
371: --
364: --
365: -- raise error as duplicate rule has been entered
366: --
367: fnd_message.set_name('BEN','BEN_93367_DUP_VAPRO_RL_FOR_ABR');
368: fnd_message.raise_error;
369: --
370: end if;
371: --
372: close c_chk_dup_vrbl_rt_rl;
471: --
472: -- A referential integrity check was violated therefore
473: -- we must error
474: --
475: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
476: -- fnd_message.set_token('TABLE_NAME', l_table_name);
477: -- fnd_message.raise_error;
478: ben_utility.parent_integrity_error(p_table_name =>l_table_name);
479: When Others Then
472: -- A referential integrity check was violated therefore
473: -- we must error
474: --
475: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
476: -- fnd_message.set_token('TABLE_NAME', l_table_name);
477: -- fnd_message.raise_error;
478: ben_utility.parent_integrity_error(p_table_name =>l_table_name);
479: When Others Then
480: --
473: -- we must error
474: --
475: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
476: -- fnd_message.set_token('TABLE_NAME', l_table_name);
477: -- fnd_message.raise_error;
478: ben_utility.parent_integrity_error(p_table_name =>l_table_name);
479: When Others Then
480: --
481: -- An unhandled or unexpected error has occurred which
480: --
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |--------------------------< dt_delete_validate >--------------------------|
576: --
577: -- A referential integrity check was violated therefore
578: -- we must error
579: --
580: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: -- fnd_message.set_token('TABLE_NAME', l_table_name);
582: -- fnd_message.raise_error;
583: ben_utility.child_exists_error(p_table_name =>l_table_name);
584: When Others Then
577: -- A referential integrity check was violated therefore
578: -- we must error
579: --
580: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: -- fnd_message.set_token('TABLE_NAME', l_table_name);
582: -- fnd_message.raise_error;
583: ben_utility.child_exists_error(p_table_name =>l_table_name);
584: When Others Then
585: --
578: -- we must error
579: --
580: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: -- fnd_message.set_token('TABLE_NAME', l_table_name);
582: -- fnd_message.raise_error;
583: ben_utility.child_exists_error(p_table_name =>l_table_name);
584: When Others Then
585: --
586: -- An unhandled or unexpected error has occurred which
585: --
586: -- An unhandled or unexpected error has occurred which
587: -- we must report
588: --
589: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
590: fnd_message.set_token('PROCEDURE', l_proc);
591: fnd_message.set_token('STEP','15');
592: fnd_message.raise_error;
593: End dt_delete_validate;
586: -- An unhandled or unexpected error has occurred which
587: -- we must report
588: --
589: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
590: fnd_message.set_token('PROCEDURE', l_proc);
591: fnd_message.set_token('STEP','15');
592: fnd_message.raise_error;
593: End dt_delete_validate;
594: --
587: -- we must report
588: --
589: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
590: fnd_message.set_token('PROCEDURE', l_proc);
591: fnd_message.set_token('STEP','15');
592: fnd_message.raise_error;
593: End dt_delete_validate;
594: --
595: -- ----------------------------------------------------------------------------
588: --
589: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
590: fnd_message.set_token('PROCEDURE', l_proc);
591: fnd_message.set_token('STEP','15');
592: fnd_message.raise_error;
593: End dt_delete_validate;
594: --
595: -- ----------------------------------------------------------------------------
596: -- |---------------------------< insert_validate >----------------------------|
774: close csr_leg_code;
775: --
776: -- The primary key is invalid therefore we must error
777: --
778: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
779: fnd_message.raise_error;
780: --
781: end if;
782: --
775: --
776: -- The primary key is invalid therefore we must error
777: --
778: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
779: fnd_message.raise_error;
780: --
781: end if;
782: --
783: close csr_leg_code;