DBA Data[Home] [Help]

APPS.BEN_DCE_BUS dependencies on FND_MESSAGE

Line 159: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

155: close c1;
156: --
157: -- raise error
158: --
159: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
160: fnd_message.set_token('ID',p_dpnt_cvg_elig_det_rl);
161: fnd_message.set_token('TYPE_ID',-35);
162: fnd_message.raise_error;
163: --

Line 160: fnd_message.set_token('ID',p_dpnt_cvg_elig_det_rl);

156: --
157: -- raise error
158: --
159: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
160: fnd_message.set_token('ID',p_dpnt_cvg_elig_det_rl);
161: fnd_message.set_token('TYPE_ID',-35);
162: fnd_message.raise_error;
163: --
164: end if;

Line 161: fnd_message.set_token('TYPE_ID',-35);

157: -- raise error
158: --
159: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
160: fnd_message.set_token('ID',p_dpnt_cvg_elig_det_rl);
161: fnd_message.set_token('TYPE_ID',-35);
162: fnd_message.raise_error;
163: --
164: end if;
165: --

Line 162: fnd_message.raise_error;

158: --
159: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
160: fnd_message.set_token('ID',p_dpnt_cvg_elig_det_rl);
161: fnd_message.set_token('TYPE_ID',-35);
162: fnd_message.raise_error;
163: --
164: end if;
165: --
166: close c1;

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

228: p_effective_date => p_effective_date) then
229: --
230: -- raise error as does not exist as lookup
231: --
232: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
233: fnd_message.raise_error;
234: --
235: end if;
236: --

Line 233: fnd_message.raise_error;

229: --
230: -- raise error as does not exist as lookup
231: --
232: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
233: fnd_message.raise_error;
234: --
235: end if;
236: --
237: end if;

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

383: p_effective_date => p_effective_date) then
384: --
385: -- raise error as does not exist as lookup
386: --
387: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
388: fnd_message.set_token('TYPE','YES_NO');
389: fnd_message.set_token('FIELD','dpnt_rlshp_flag ');
390: fnd_message.raise_error;
391: --

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

384: --
385: -- raise error as does not exist as lookup
386: --
387: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
388: fnd_message.set_token('TYPE','YES_NO');
389: fnd_message.set_token('FIELD','dpnt_rlshp_flag ');
390: fnd_message.raise_error;
391: --
392: end if;

Line 389: fnd_message.set_token('FIELD','dpnt_rlshp_flag ');

385: -- raise error as does not exist as lookup
386: --
387: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
388: fnd_message.set_token('TYPE','YES_NO');
389: fnd_message.set_token('FIELD','dpnt_rlshp_flag ');
390: fnd_message.raise_error;
391: --
392: end if;
393: --

Line 390: fnd_message.raise_error;

386: --
387: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
388: fnd_message.set_token('TYPE','YES_NO');
389: fnd_message.set_token('FIELD','dpnt_rlshp_flag ');
390: fnd_message.raise_error;
391: --
392: end if;
393: --
394:

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

398: p_effective_date => p_effective_date) then
399: --
400: -- raise error as does not exist as lookup
401: --
402: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
403: fnd_message.set_token('TYPE','YES_NO');
404: fnd_message.set_token('FIELD','dpnt_age_flag ');
405: fnd_message.raise_error;
406: --

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

399: --
400: -- raise error as does not exist as lookup
401: --
402: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
403: fnd_message.set_token('TYPE','YES_NO');
404: fnd_message.set_token('FIELD','dpnt_age_flag ');
405: fnd_message.raise_error;
406: --
407: end if;

Line 404: fnd_message.set_token('FIELD','dpnt_age_flag ');

400: -- raise error as does not exist as lookup
401: --
402: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
403: fnd_message.set_token('TYPE','YES_NO');
404: fnd_message.set_token('FIELD','dpnt_age_flag ');
405: fnd_message.raise_error;
406: --
407: end if;
408: if hr_api.not_exists_in_hr_lookups

Line 405: fnd_message.raise_error;

401: --
402: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
403: fnd_message.set_token('TYPE','YES_NO');
404: fnd_message.set_token('FIELD','dpnt_age_flag ');
405: fnd_message.raise_error;
406: --
407: end if;
408: if hr_api.not_exists_in_hr_lookups
409: (p_lookup_type => 'YES_NO',

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

411: p_effective_date => p_effective_date) then
412: --
413: -- raise error as does not exist as lookup
414: --
415: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.set_token('FIELD','dpnt_stud_flag ');
418: fnd_message.raise_error;
419: --

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

412: --
413: -- raise error as does not exist as lookup
414: --
415: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.set_token('FIELD','dpnt_stud_flag ');
418: fnd_message.raise_error;
419: --
420: end if;

Line 417: fnd_message.set_token('FIELD','dpnt_stud_flag ');

413: -- raise error as does not exist as lookup
414: --
415: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.set_token('FIELD','dpnt_stud_flag ');
418: fnd_message.raise_error;
419: --
420: end if;
421: if hr_api.not_exists_in_hr_lookups

Line 418: fnd_message.raise_error;

414: --
415: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.set_token('FIELD','dpnt_stud_flag ');
418: fnd_message.raise_error;
419: --
420: end if;
421: if hr_api.not_exists_in_hr_lookups
422: (p_lookup_type => 'YES_NO',

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

424: p_effective_date => p_effective_date) then
425: --
426: -- raise error as does not exist as lookup
427: --
428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');
431: fnd_message.raise_error;
432: --

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

425: --
426: -- raise error as does not exist as lookup
427: --
428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');
431: fnd_message.raise_error;
432: --
433: end if;

Line 430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');

426: -- raise error as does not exist as lookup
427: --
428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');
431: fnd_message.raise_error;
432: --
433: end if;
434: if hr_api.not_exists_in_hr_lookups

Line 431: fnd_message.raise_error;

427: --
428: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');
431: fnd_message.raise_error;
432: --
433: end if;
434: if hr_api.not_exists_in_hr_lookups
435: (p_lookup_type => 'YES_NO',

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

437: p_effective_date => p_effective_date) then
438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('TYPE','YES_NO');
443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');
444: fnd_message.raise_error;
445: --

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

438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('TYPE','YES_NO');
443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');
444: fnd_message.raise_error;
445: --
446: end if;

Line 443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');

439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('TYPE','YES_NO');
443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');
444: fnd_message.raise_error;
445: --
446: end if;
447: if hr_api.not_exists_in_hr_lookups

Line 444: fnd_message.raise_error;

440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('TYPE','YES_NO');
443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');
444: fnd_message.raise_error;
445: --
446: end if;
447: if hr_api.not_exists_in_hr_lookups
448: (p_lookup_type => 'YES_NO',

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

450: p_effective_date => p_effective_date) then
451: --
452: -- raise error as does not exist as lookup
453: --
454: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');
457: fnd_message.raise_error;
458: --

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

451: --
452: -- raise error as does not exist as lookup
453: --
454: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');
457: fnd_message.raise_error;
458: --
459: end if;

Line 456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');

452: -- raise error as does not exist as lookup
453: --
454: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');
457: fnd_message.raise_error;
458: --
459: end if;
460: if hr_api.not_exists_in_hr_lookups

Line 457: fnd_message.raise_error;

453: --
454: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');
457: fnd_message.raise_error;
458: --
459: end if;
460: if hr_api.not_exists_in_hr_lookups
461: (p_lookup_type => 'YES_NO',

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

463: p_effective_date => p_effective_date) then
464: --
465: -- raise error as does not exist as lookup
466: --
467: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
468: fnd_message.set_token('TYPE','YES_NO');
469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');
470: fnd_message.raise_error;
471: --

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

464: --
465: -- raise error as does not exist as lookup
466: --
467: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
468: fnd_message.set_token('TYPE','YES_NO');
469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');
470: fnd_message.raise_error;
471: --
472: end if;

Line 469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');

465: -- raise error as does not exist as lookup
466: --
467: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
468: fnd_message.set_token('TYPE','YES_NO');
469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');
470: fnd_message.raise_error;
471: --
472: end if;
473: if hr_api.not_exists_in_hr_lookups

Line 470: fnd_message.raise_error;

466: --
467: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
468: fnd_message.set_token('TYPE','YES_NO');
469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');
470: fnd_message.raise_error;
471: --
472: end if;
473: if hr_api.not_exists_in_hr_lookups
474: (p_lookup_type => 'YES_NO',

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

476: p_effective_date => p_effective_date) then
477: --
478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('TYPE','YES_NO');
482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');
483: fnd_message.raise_error;
484: --

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

477: --
478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('TYPE','YES_NO');
482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');
483: fnd_message.raise_error;
484: --
485: end if;

Line 482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');

478: -- raise error as does not exist as lookup
479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('TYPE','YES_NO');
482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');
483: fnd_message.raise_error;
484: --
485: end if;
486: if hr_api.not_exists_in_hr_lookups

Line 483: fnd_message.raise_error;

479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('TYPE','YES_NO');
482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');
483: fnd_message.raise_error;
484: --
485: end if;
486: if hr_api.not_exists_in_hr_lookups
487: (p_lookup_type => 'YES_NO',

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

489: p_effective_date => p_effective_date) then
490: --
491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.set_token('FIELD','dpnt_dsgnt_crntly_enrld_flag ');
496: fnd_message.raise_error;
497: --

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

490: --
491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.set_token('FIELD','dpnt_dsgnt_crntly_enrld_flag ');
496: fnd_message.raise_error;
497: --
498: end if;

Line 495: fnd_message.set_token('FIELD','dpnt_dsgnt_crntly_enrld_flag ');

491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.set_token('FIELD','dpnt_dsgnt_crntly_enrld_flag ');
496: fnd_message.raise_error;
497: --
498: end if;
499:

Line 496: fnd_message.raise_error;

492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.set_token('FIELD','dpnt_dsgnt_crntly_enrld_flag ');
496: fnd_message.raise_error;
497: --
498: end if;
499:
500: hr_utility.set_location(' Leaving:'||l_proc, 5);

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

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

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

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

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

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

Line 597: fnd_message.raise_error;

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

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

778: --
779: -- An unhandled or unexpected error has occurred which
780: -- we must report
781: --
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','15');
785: fnd_message.raise_error;
786: End dt_delete_validate;

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

779: -- An unhandled or unexpected error has occurred which
780: -- we must report
781: --
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','15');
785: fnd_message.raise_error;
786: End dt_delete_validate;
787: --

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

780: -- we must report
781: --
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','15');
785: fnd_message.raise_error;
786: End dt_delete_validate;
787: --
788: -- ----------------------------------------------------------------------------

Line 785: fnd_message.raise_error;

781: --
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','15');
785: fnd_message.raise_error;
786: End dt_delete_validate;
787: --
788: -- ----------------------------------------------------------------------------
789: -- |---------------------------< insert_validate >----------------------------|

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

986: close csr_leg_code;
987: --
988: -- The primary key is invalid therefore we must error
989: --
990: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
991: fnd_message.raise_error;
992: --
993: end if;
994: --

Line 991: fnd_message.raise_error;

987: --
988: -- The primary key is invalid therefore we must error
989: --
990: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
991: fnd_message.raise_error;
992: --
993: end if;
994: --
995: close csr_leg_code;