DBA Data[Home] [Help]

APPS.BEN_VRR_BUS dependencies on FND_MESSAGE

Line 136: fnd_message.set_name('BEN','BEN_91420_VRBL_RT_RL_NOT_ALWD');

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;

Line 137: fnd_message.raise_error;

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: --

Line 195: fnd_message.set_name('BEN','BEN_92987_CHK_FOR_RL_OR_RT');

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;

Line 196: fnd_message.raise_error;

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: --

Line 275: fnd_message.set_name('BEN','BEN_94107_FORMULA_NAME_NULL');

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:

Line 276: fnd_message.raise_error;

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: --

Line 295: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');

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: --

Line 296: fnd_message.raise_error;

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;

Line 367: fnd_message.set_name('BEN','BEN_93367_DUP_VAPRO_RL_FOR_ABR');

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: --

Line 368: fnd_message.raise_error;

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;

Line 475: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

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

Line 476: -- fnd_message.set_token('TABLE_NAME', l_table_name);

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: --

Line 477: -- fnd_message.raise_error;

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

Line 484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 485: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 486: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 487: fnd_message.raise_error;

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 >--------------------------|

Line 580: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

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

Line 581: -- fnd_message.set_token('TABLE_NAME', l_table_name);

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: --

Line 582: -- fnd_message.raise_error;

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

Line 589: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 590: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 591: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 592: fnd_message.raise_error;

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 >----------------------------|

Line 778: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 779: fnd_message.raise_error;

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;