DBA Data[Home] [Help]

APPS.BEN_ELR_BUS dependencies on FND_MESSAGE

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

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

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

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

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

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

Line 140: fnd_message.raise_error;

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

Line 379: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');

375: close c1;
376: --
377: -- raise error as this pl already exists for this profile
378: --
379: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
380: fnd_message.raise_error;
381: --
382: end if;
383: close c1;

Line 380: fnd_message.raise_error;

376: --
377: -- raise error as this pl already exists for this profile
378: --
379: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
380: fnd_message.raise_error;
381: --
382: end if;
383: close c1;
384: --

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

437: open c1;
438: fetch c1 into l_dummy;
439: if c1%found then
440: close c1;
441: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
442: fnd_message.raise_error;
443: end if;
444: close c1;
445: --

Line 442: fnd_message.raise_error;

438: fetch c1 into l_dummy;
439: if c1%found then
440: close c1;
441: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
442: fnd_message.raise_error;
443: end if;
444: close c1;
445: --
446: hr_utility.set_location('Leaving:'||l_proc, 15);

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

538: --
539: -- An unhandled or unexpected error has occurred which
540: -- we must report
541: --
542: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
543: fnd_message.set_token('PROCEDURE', l_proc);
544: fnd_message.set_token('STEP','15');
545: fnd_message.raise_error;
546: End dt_update_validate;

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

539: -- An unhandled or unexpected error has occurred which
540: -- we must report
541: --
542: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
543: fnd_message.set_token('PROCEDURE', l_proc);
544: fnd_message.set_token('STEP','15');
545: fnd_message.raise_error;
546: End dt_update_validate;
547: --

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

540: -- we must report
541: --
542: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
543: fnd_message.set_token('PROCEDURE', l_proc);
544: fnd_message.set_token('STEP','15');
545: fnd_message.raise_error;
546: End dt_update_validate;
547: --
548: -- ----------------------------------------------------------------------------

Line 545: fnd_message.raise_error;

541: --
542: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
543: fnd_message.set_token('PROCEDURE', l_proc);
544: fnd_message.set_token('STEP','15');
545: fnd_message.raise_error;
546: End dt_update_validate;
547: --
548: -- ----------------------------------------------------------------------------
549: -- |--------------------------< dt_delete_validate >--------------------------|

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

634: --
635: -- A referential integrity check was violated therefore
636: -- we must error
637: --
638: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
639: fnd_message.set_token('TABLE_NAME', l_table_name);
640: fnd_message.raise_error;
641: When Others Then
642: --

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

635: -- A referential integrity check was violated therefore
636: -- we must error
637: --
638: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
639: fnd_message.set_token('TABLE_NAME', l_table_name);
640: fnd_message.raise_error;
641: When Others Then
642: --
643: -- An unhandled or unexpected error has occurred which

Line 640: fnd_message.raise_error;

636: -- we must error
637: --
638: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
639: fnd_message.set_token('TABLE_NAME', l_table_name);
640: fnd_message.raise_error;
641: When Others Then
642: --
643: -- An unhandled or unexpected error has occurred which
644: -- we must report

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

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;

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

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

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

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

Line 649: fnd_message.raise_error;

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

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

851: close csr_leg_code;
852: --
853: -- The primary key is invalid therefore we must error
854: --
855: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
856: fnd_message.raise_error;
857: --
858: end if;
859: --

Line 856: fnd_message.raise_error;

852: --
853: -- The primary key is invalid therefore we must error
854: --
855: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
856: fnd_message.raise_error;
857: --
858: end if;
859: --
860: close csr_leg_code;