DBA Data[Home] [Help]

APPS.BEN_PRR_BUS dependencies on FND_MESSAGE

Line 138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

134: p_effective_date => p_effective_date) then
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --

Line 139: fnd_message.set_token('FIELD','p_excld_flag');

135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --

Line 140: fnd_message.set_token('TYPE','YES_NO');

136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
144: end if;

Line 141: fnd_message.raise_error;

137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
144: end if;
145: --

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

389: close c1;
390: --
391: -- raise error as this pl already exists for this profile
392: --
393: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
394: fnd_message.set_token('VAR1','Performance Rating criteria');
395: fnd_message.set_token('VAR2','Variable Rate Profile');
396: fnd_message.raise_error;
397: --

Line 394: fnd_message.set_token('VAR1','Performance Rating criteria');

390: --
391: -- raise error as this pl already exists for this profile
392: --
393: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
394: fnd_message.set_token('VAR1','Performance Rating criteria');
395: fnd_message.set_token('VAR2','Variable Rate Profile');
396: fnd_message.raise_error;
397: --
398: end if;

Line 395: fnd_message.set_token('VAR2','Variable Rate Profile');

391: -- raise error as this pl already exists for this profile
392: --
393: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
394: fnd_message.set_token('VAR1','Performance Rating criteria');
395: fnd_message.set_token('VAR2','Variable Rate Profile');
396: fnd_message.raise_error;
397: --
398: end if;
399: close c1;

Line 396: fnd_message.raise_error;

392: --
393: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
394: fnd_message.set_token('VAR1','Performance Rating criteria');
395: fnd_message.set_token('VAR2','Variable Rate Profile');
396: fnd_message.raise_error;
397: --
398: end if;
399: close c1;
400: --

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

460: open c1;
461: fetch c1 into l_dummy;
462: --
463: if c1%found then
464: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --

Line 465: fnd_message.raise_error;

461: fetch c1 into l_dummy;
462: --
463: if c1%found then
464: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --
469: hr_utility.set_location('Leaving:'||l_proc, 15);

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

565: --
566: -- An unhandled or unexpected error has occurred which
567: -- we must report
568: --
569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
570: fnd_message.set_token('PROCEDURE', l_proc);
571: fnd_message.set_token('STEP','15');
572: fnd_message.raise_error;
573: End dt_update_validate;

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

566: -- An unhandled or unexpected error has occurred which
567: -- we must report
568: --
569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
570: fnd_message.set_token('PROCEDURE', l_proc);
571: fnd_message.set_token('STEP','15');
572: fnd_message.raise_error;
573: End dt_update_validate;
574: --

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

567: -- we must report
568: --
569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
570: fnd_message.set_token('PROCEDURE', l_proc);
571: fnd_message.set_token('STEP','15');
572: fnd_message.raise_error;
573: End dt_update_validate;
574: --
575: -- ----------------------------------------------------------------------------

Line 572: fnd_message.raise_error;

568: --
569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
570: fnd_message.set_token('PROCEDURE', l_proc);
571: fnd_message.set_token('STEP','15');
572: fnd_message.raise_error;
573: End dt_update_validate;
574: --
575: -- ----------------------------------------------------------------------------
576: -- |--------------------------< dt_delete_validate >--------------------------|

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

661: --
662: -- A referential integrity check was violated therefore
663: -- we must error
664: --
665: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
666: fnd_message.set_token('TABLE_NAME', l_table_name);
667: fnd_message.raise_error;
668: When Others Then
669: --

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

662: -- A referential integrity check was violated therefore
663: -- we must error
664: --
665: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
666: fnd_message.set_token('TABLE_NAME', l_table_name);
667: fnd_message.raise_error;
668: When Others Then
669: --
670: -- An unhandled or unexpected error has occurred which

Line 667: fnd_message.raise_error;

663: -- we must error
664: --
665: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
666: fnd_message.set_token('TABLE_NAME', l_table_name);
667: fnd_message.raise_error;
668: When Others Then
669: --
670: -- An unhandled or unexpected error has occurred which
671: -- we must report

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

669: --
670: -- An unhandled or unexpected error has occurred which
671: -- we must report
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','15');
676: fnd_message.raise_error;
677: End dt_delete_validate;

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

670: -- An unhandled or unexpected error has occurred which
671: -- we must report
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','15');
676: fnd_message.raise_error;
677: End dt_delete_validate;
678: --

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

671: -- we must report
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','15');
676: fnd_message.raise_error;
677: End dt_delete_validate;
678: --
679: -- ----------------------------------------------------------------------------

Line 676: fnd_message.raise_error;

672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','15');
676: fnd_message.raise_error;
677: End dt_delete_validate;
678: --
679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< insert_validate >----------------------------|

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

885: close csr_leg_code;
886: --
887: -- The primary key is invalid therefore we must error
888: --
889: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
890: fnd_message.raise_error;
891: --
892: end if;
893: --

Line 890: fnd_message.raise_error;

886: --
887: -- The primary key is invalid therefore we must error
888: --
889: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
890: fnd_message.raise_error;
891: --
892: end if;
893: --
894: close csr_leg_code;