DBA Data[Home] [Help]

APPS.BEN_AVR_BUS dependencies on FND_MESSAGE

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

129: open c1;
130: fetch c1 into l_dummy;
131: if c1%found then
132: close c1;
133: fnd_message.set_name('BEN','BEN_91420_VRBL_RT_RL_NOT_ALWD');
134: fnd_message.raise_error;
135: end if;
136: close c1;
137: end if;

Line 134: fnd_message.raise_error;

130: fetch c1 into l_dummy;
131: if c1%found then
132: close c1;
133: fnd_message.set_name('BEN','BEN_91420_VRBL_RT_RL_NOT_ALWD');
134: fnd_message.raise_error;
135: end if;
136: close c1;
137: end if;
138: --

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

188: open c1;
189: fetch c1 into l_dummy;
190: if c1%found then
191: close c1;
192: fnd_message.set_name('BEN','BEN_92987_CHK_FOR_RL_OR_RT');
193: fnd_message.raise_error;
194: end if;
195: close c1;
196: end if;

Line 193: fnd_message.raise_error;

189: fetch c1 into l_dummy;
190: if c1%found then
191: close c1;
192: fnd_message.set_name('BEN','BEN_92987_CHK_FOR_RL_OR_RT');
193: fnd_message.raise_error;
194: end if;
195: close c1;
196: end if;
197: --

Line 258: fnd_message.set_name('BEN','BEN_94106_VRBL_RT_PRFL_NULL');

254: or not l_api_updating) and p_vrbl_rt_prfl_id is null
255:
256: then
257: --
258: fnd_message.set_name('BEN','BEN_94106_VRBL_RT_PRFL_NULL');
259: fnd_message.raise_error;
260:
261: --
262: end if;

Line 259: fnd_message.raise_error;

255:
256: then
257: --
258: fnd_message.set_name('BEN','BEN_94106_VRBL_RT_PRFL_NULL');
259: fnd_message.raise_error;
260:
261: --
262: end if;
263: --

Line 320: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

316: open c1;
317: fetch c1 into l_dummy;
318: if c1%found then
319: close c1;
320: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
321: fnd_message.raise_error;
322: end if;
323: --
324: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 321: fnd_message.raise_error;

317: fetch c1 into l_dummy;
318: if c1%found then
319: close c1;
320: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
321: fnd_message.raise_error;
322: end if;
323: --
324: hr_utility.set_location('Leaving:'||l_proc, 15);
325: End chk_ordr_num_unique;

Line 393: fnd_message.set_name('BEN','BEN_93476_IMPUT_NOT_VAPRO');

389: close c1;
390: close c2;
391: -- raise error
392: --
393: fnd_message.set_name('BEN','BEN_93476_IMPUT_NOT_VAPRO');
394: fnd_message.raise_error;
395: --
396: end if;
397: close c2;

Line 394: fnd_message.raise_error;

390: close c2;
391: -- raise error
392: --
393: fnd_message.set_name('BEN','BEN_93476_IMPUT_NOT_VAPRO');
394: fnd_message.raise_error;
395: --
396: end if;
397: close c2;
398: end if;

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

460: close c_dup_vrbl_rt_prfl;
461: --
462: -- raise error as duplicate criteria has been entered
463: --
464: fnd_message.set_name('BEN','BEN_93367_DUP_VAPRO_RL_FOR_ABR');
465: fnd_message.raise_error;
466: --
467: end if;
468: --

Line 465: fnd_message.raise_error;

461: --
462: -- raise error as duplicate criteria has been entered
463: --
464: fnd_message.set_name('BEN','BEN_93367_DUP_VAPRO_RL_FOR_ABR');
465: fnd_message.raise_error;
466: --
467: end if;
468: --
469: close c_dup_vrbl_rt_prfl;

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

568: --
569: -- A referential integrity check was violated therefore
570: -- we must error
571: --
572: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
573: -- fnd_message.set_token('TABLE_NAME', l_table_name);
574: -- fnd_message.raise_error;
575: ben_utility.parent_integrity_error(p_table_name => l_table_name);
576: When Others Then

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

569: -- A referential integrity check was violated therefore
570: -- we must error
571: --
572: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
573: -- fnd_message.set_token('TABLE_NAME', l_table_name);
574: -- fnd_message.raise_error;
575: ben_utility.parent_integrity_error(p_table_name => l_table_name);
576: When Others Then
577: --

Line 574: -- fnd_message.raise_error;

570: -- we must error
571: --
572: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
573: -- fnd_message.set_token('TABLE_NAME', l_table_name);
574: -- fnd_message.raise_error;
575: ben_utility.parent_integrity_error(p_table_name => l_table_name);
576: When Others Then
577: --
578: -- An unhandled or unexpected error has occurred which

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

577: --
578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;

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

578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --

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

579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------

Line 584: fnd_message.raise_error;

580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |--------------------------< dt_delete_validate >--------------------------|

Line 677: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

673: --
674: -- A referential integrity check was violated therefore
675: -- we must error
676: --
677: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
678: fnd_message.set_token('TABLE_NAME', l_table_name);
679: fnd_message.raise_error; */
680: ben_utility.child_exists_error(p_table_name => l_table_name);
681: When Others Then

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

674: -- A referential integrity check was violated therefore
675: -- we must error
676: --
677: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
678: fnd_message.set_token('TABLE_NAME', l_table_name);
679: fnd_message.raise_error; */
680: ben_utility.child_exists_error(p_table_name => l_table_name);
681: When Others Then
682: --

Line 679: fnd_message.raise_error; */

675: -- we must error
676: --
677: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
678: fnd_message.set_token('TABLE_NAME', l_table_name);
679: fnd_message.raise_error; */
680: ben_utility.child_exists_error(p_table_name => l_table_name);
681: When Others Then
682: --
683: -- An unhandled or unexpected error has occurred which

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

682: --
683: -- An unhandled or unexpected error has occurred which
684: -- we must report
685: --
686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
687: fnd_message.set_token('PROCEDURE', l_proc);
688: fnd_message.set_token('STEP','15');
689: fnd_message.raise_error;
690: End dt_delete_validate;

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

683: -- An unhandled or unexpected error has occurred which
684: -- we must report
685: --
686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
687: fnd_message.set_token('PROCEDURE', l_proc);
688: fnd_message.set_token('STEP','15');
689: fnd_message.raise_error;
690: End dt_delete_validate;
691: --

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

684: -- we must report
685: --
686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
687: fnd_message.set_token('PROCEDURE', l_proc);
688: fnd_message.set_token('STEP','15');
689: fnd_message.raise_error;
690: End dt_delete_validate;
691: --
692: -- ----------------------------------------------------------------------------

Line 689: fnd_message.raise_error;

685: --
686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
687: fnd_message.set_token('PROCEDURE', l_proc);
688: fnd_message.set_token('STEP','15');
689: fnd_message.raise_error;
690: End dt_delete_validate;
691: --
692: -- ----------------------------------------------------------------------------
693: -- |---------------------------< insert_validate >----------------------------|

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

898: close csr_leg_code;
899: --
900: -- The primary key is invalid therefore we must error
901: --
902: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
903: fnd_message.raise_error;
904: --
905: end if;
906: --

Line 903: fnd_message.raise_error;

899: --
900: -- The primary key is invalid therefore we must error
901: --
902: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
903: fnd_message.raise_error;
904: --
905: end if;
906: --
907: close csr_leg_code;