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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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:
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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
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',
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: --
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;
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:
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);
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >--------------------------|
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >----------------------------|
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: --
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;