DBA Data[Home] [Help]

APPS.BEN_EEP_BUS dependencies on FND_MESSAGE

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

174: close c3;
175: --
176: -- raise error as this pl already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
179: fnd_message.raise_error;
180: --
181: end if;
182: close c3;

Line 179: fnd_message.raise_error;

175: --
176: -- raise error as this pl already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
179: fnd_message.raise_error;
180: --
181: end if;
182: close c3;
183: --

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

243: p_effective_date => p_effective_date) then
244: --
245: -- raise error as does not exist as lookup
246: --
247: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
248: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
249: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
250: fnd_message.raise_error;
251: --

Line 248: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');

244: --
245: -- raise error as does not exist as lookup
246: --
247: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
248: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
249: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
250: fnd_message.raise_error;
251: --
252: end if;

Line 249: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');

245: -- raise error as does not exist as lookup
246: --
247: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
248: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
249: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
250: fnd_message.raise_error;
251: --
252: end if;
253: --

Line 250: fnd_message.raise_error;

246: --
247: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
248: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
249: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
250: fnd_message.raise_error;
251: --
252: end if;
253: --
254: end if;

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

314: p_effective_date => p_effective_date) then
315: --
316: -- raise error as does not exist as lookup
317: --
318: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
319: fnd_message.set_token('FIELD','p_excld_flag');
320: fnd_message.set_token('TYPE','YES_NO');
321: fnd_message.raise_error;
322: --

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

315: --
316: -- raise error as does not exist as lookup
317: --
318: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
319: fnd_message.set_token('FIELD','p_excld_flag');
320: fnd_message.set_token('TYPE','YES_NO');
321: fnd_message.raise_error;
322: --
323: end if;

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

316: -- raise error as does not exist as lookup
317: --
318: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
319: fnd_message.set_token('FIELD','p_excld_flag');
320: fnd_message.set_token('TYPE','YES_NO');
321: fnd_message.raise_error;
322: --
323: end if;
324: --

Line 321: fnd_message.raise_error;

317: --
318: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
319: fnd_message.set_token('FIELD','p_excld_flag');
320: fnd_message.set_token('TYPE','YES_NO');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
325: end if;

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

378: open c1;
379: fetch c1 into l_dummy;
380: if c1%found then
381: close c1;
382: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
383: fnd_message.raise_error;
384: end if;
385: close c1;
386: --

Line 383: fnd_message.raise_error;

379: fetch c1 into l_dummy;
380: if c1%found then
381: close c1;
382: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
383: fnd_message.raise_error;
384: end if;
385: close c1;
386: --
387: hr_utility.set_location('Leaving:'||l_proc, 15);

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

488: --
489: -- An unhandled or unexpected error has occurred which
490: -- we must report
491: --
492: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
493: fnd_message.set_token('PROCEDURE', l_proc);
494: fnd_message.set_token('STEP','15');
495: fnd_message.raise_error;
496: End dt_update_validate;

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

489: -- An unhandled or unexpected error has occurred which
490: -- we must report
491: --
492: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
493: fnd_message.set_token('PROCEDURE', l_proc);
494: fnd_message.set_token('STEP','15');
495: fnd_message.raise_error;
496: End dt_update_validate;
497: --

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

490: -- we must report
491: --
492: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
493: fnd_message.set_token('PROCEDURE', l_proc);
494: fnd_message.set_token('STEP','15');
495: fnd_message.raise_error;
496: End dt_update_validate;
497: --
498: -- ----------------------------------------------------------------------------

Line 495: fnd_message.raise_error;

491: --
492: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
493: fnd_message.set_token('PROCEDURE', l_proc);
494: fnd_message.set_token('STEP','15');
495: fnd_message.raise_error;
496: End dt_update_validate;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |--------------------------< dt_delete_validate >--------------------------|

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

584: --
585: -- A referential integrity check was violated therefore
586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --

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

585: -- A referential integrity check was violated therefore
586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --
593: -- An unhandled or unexpected error has occurred which

Line 590: fnd_message.raise_error;

586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --
593: -- An unhandled or unexpected error has occurred which
594: -- we must report

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

592: --
593: -- An unhandled or unexpected error has occurred which
594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;

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

593: -- An unhandled or unexpected error has occurred which
594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --

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

594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --
602: -- ----------------------------------------------------------------------------

Line 599: fnd_message.raise_error;

595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --
602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< insert_validate >----------------------------|

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

787: close csr_leg_code;
788: --
789: -- The primary key is invalid therefore we must error
790: --
791: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
792: fnd_message.raise_error;
793: --
794: end if;
795: --

Line 792: fnd_message.raise_error;

788: --
789: -- The primary key is invalid therefore we must error
790: --
791: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
792: fnd_message.raise_error;
793: --
794: end if;
795: --
796: close csr_leg_code;