DBA Data[Home] [Help]

APPS.BEN_EDP_BUS dependencies on FND_MESSAGE

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

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

Line 180: fnd_message.raise_error;

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

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

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

Line 249: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');

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

Line 250: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');

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

Line 251: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 322: fnd_message.raise_error;

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

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

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

Line 384: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 496: fnd_message.raise_error;

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

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

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

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

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

Line 591: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 600: fnd_message.raise_error;

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

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

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

Line 793: fnd_message.raise_error;

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