DBA Data[Home] [Help]

APPS.BEN_EDB_BUS dependencies on FND_MESSAGE

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

125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then
128: close c1;
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --

Line 130: fnd_message.raise_error;

126: fetch c1 into l_dummy;
127: if c1%found then
128: close c1;
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 195: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

191: p_effective_date => p_effective_date) then
192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
196: fnd_message.raise_error;
197: --
198: end if;
199: --

Line 196: fnd_message.raise_error;

192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
196: fnd_message.raise_error;
197: --
198: end if;
199: --
200: end if;

Line 264: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

260: p_effective_date => p_effective_date) then
261: --
262: -- raise error as does not exist as lookup
263: --
264: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
265: fnd_message.raise_error;
266: --
267: end if;
268: --

Line 265: fnd_message.raise_error;

261: --
262: -- raise error as does not exist as lookup
263: --
264: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
265: fnd_message.raise_error;
266: --
267: end if;
268: --
269: end if;

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

333: hr_utility.set_location(l_proc, 7);
334: --
335: -- raise error as duplicate criteria has been entered
336: --
337: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
338: fnd_message.raise_error;
339: --
340: end if;
341: --

Line 338: fnd_message.raise_error;

334: --
335: -- raise error as duplicate criteria has been entered
336: --
337: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
338: fnd_message.raise_error;
339: --
340: end if;
341: --
342: close c_elig_dsbld_prte;

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

437: --
438: -- An unhandled or unexpected error has occurred which
439: -- we must report
440: --
441: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
442: fnd_message.set_token('PROCEDURE', l_proc);
443: fnd_message.set_token('STEP','15');
444: fnd_message.raise_error;
445: End dt_update_validate;

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

438: -- An unhandled or unexpected error has occurred which
439: -- we must report
440: --
441: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
442: fnd_message.set_token('PROCEDURE', l_proc);
443: fnd_message.set_token('STEP','15');
444: fnd_message.raise_error;
445: End dt_update_validate;
446: --

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

439: -- we must report
440: --
441: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
442: fnd_message.set_token('PROCEDURE', l_proc);
443: fnd_message.set_token('STEP','15');
444: fnd_message.raise_error;
445: End dt_update_validate;
446: --
447: -- ----------------------------------------------------------------------------

Line 444: fnd_message.raise_error;

440: --
441: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
442: fnd_message.set_token('PROCEDURE', l_proc);
443: fnd_message.set_token('STEP','15');
444: fnd_message.raise_error;
445: End dt_update_validate;
446: --
447: -- ----------------------------------------------------------------------------
448: -- |--------------------------< dt_delete_validate >--------------------------|

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

533: --
534: -- A referential integrity check was violated therefore
535: -- we must error
536: --
537: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
538: fnd_message.set_token('TABLE_NAME', l_table_name);
539: fnd_message.raise_error;
540: When Others Then
541: --

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

534: -- A referential integrity check was violated therefore
535: -- we must error
536: --
537: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
538: fnd_message.set_token('TABLE_NAME', l_table_name);
539: fnd_message.raise_error;
540: When Others Then
541: --
542: -- An unhandled or unexpected error has occurred which

Line 539: fnd_message.raise_error;

535: -- we must error
536: --
537: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
538: fnd_message.set_token('TABLE_NAME', l_table_name);
539: fnd_message.raise_error;
540: When Others Then
541: --
542: -- An unhandled or unexpected error has occurred which
543: -- we must report

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

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

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

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

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

543: -- we must report
544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------

Line 548: fnd_message.raise_error;

544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< insert_validate >----------------------------|

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

727: close csr_leg_code;
728: --
729: -- The primary key is invalid therefore we must error
730: --
731: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
732: fnd_message.raise_error;
733: --
734: end if;
735: --

Line 732: fnd_message.raise_error;

728: --
729: -- The primary key is invalid therefore we must error
730: --
731: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
736: close csr_leg_code;