eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PEP_BUS dependencies on FND_MESSAGE

Line 52: fnd_message.raise_error;

48: --
49: --The primary key is invalid therefore we must error
50: --
51: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
52: fnd_message.raise_error;
53: --
54: end if;
55: --
56: close csr_leg_code;

Line 188: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');

184: --
185: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
186: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
187: --
188: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
189: fnd_message.raise_error;
190: --
191: end if;
192: --

Line 189: fnd_message.raise_error;

185: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
186: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
187: --
188: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
189: fnd_message.raise_error;
190: --
191: end if;
192: --
193: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or

Line 196: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');

192: --
193: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
194: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
195: --
196: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
197: fnd_message.raise_error;
198: --
199: end if;
200: --

Line 197: fnd_message.raise_error;

193: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
194: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
195: --
196: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
197: fnd_message.raise_error;
198: --
199: end if;
200: --
201: l_api_updating:= ben_pep_shd.api_updating

Line 320: fnd_message.set_name('BEN','BEN_91312_ELIG_PER_PL_PGM');

316: p_pgm_id is null and
317: p_plip_id is null and
318: p_ptip_id is null then
319: --
320: fnd_message.set_name('BEN','BEN_91312_ELIG_PER_PL_PGM');
321: fnd_message.raise_error;
322: --
323: end if;
324: --

Line 321: fnd_message.raise_error;

317: p_plip_id is null and
318: p_ptip_id is null then
319: --
320: fnd_message.set_name('BEN','BEN_91312_ELIG_PER_PL_PGM');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
325: open c1;

Line 332: fnd_message.set_name('BEN','BEN_92121_PL_IN_PGM');

328: --
329: if p_pgm_id is null and l_pgm_id is not null then
330: --
331: close c1;
332: fnd_message.set_name('BEN','BEN_92121_PL_IN_PGM');
333: fnd_message.raise_error;
334: --
335: end if;
336: --

Line 333: fnd_message.raise_error;

329: if p_pgm_id is null and l_pgm_id is not null then
330: --
331: close c1;
332: fnd_message.set_name('BEN','BEN_92121_PL_IN_PGM');
333: fnd_message.raise_error;
334: --
335: end if;
336: --
337: close c1;

Line 384: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');

380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: if (p_pl_wvd_flag = 'N' and p_wv_prtn_rsn_cd is not null) then
383: --
384: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');
385: fnd_message.raise_error;
386: --
387: end if;
388: --

Line 385: fnd_message.raise_error;

381: --
382: if (p_pl_wvd_flag = 'N' and p_wv_prtn_rsn_cd is not null) then
383: --
384: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');
385: fnd_message.raise_error;
386: --
387: end if;
388: --
389: l_api_updating := ben_pep_shd.api_updating

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

404: p_effective_date => p_effective_date) then
405: --
406: -- raise error as does not exist as lookup
407: --
408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
409: fnd_message.set_token('FIELD','p_wv_prtn_rsn_cd');
410: fnd_message.set_token('TYPE','BEN_WV_PRTN_RSN');
411: fnd_message.raise_error;
412: --

Line 409: fnd_message.set_token('FIELD','p_wv_prtn_rsn_cd');

405: --
406: -- raise error as does not exist as lookup
407: --
408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
409: fnd_message.set_token('FIELD','p_wv_prtn_rsn_cd');
410: fnd_message.set_token('TYPE','BEN_WV_PRTN_RSN');
411: fnd_message.raise_error;
412: --
413: end if;

Line 410: fnd_message.set_token('TYPE','BEN_WV_PRTN_RSN');

406: -- raise error as does not exist as lookup
407: --
408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
409: fnd_message.set_token('FIELD','p_wv_prtn_rsn_cd');
410: fnd_message.set_token('TYPE','BEN_WV_PRTN_RSN');
411: fnd_message.raise_error;
412: --
413: end if;
414: --

Line 411: fnd_message.raise_error;

407: --
408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
409: fnd_message.set_token('FIELD','p_wv_prtn_rsn_cd');
410: fnd_message.set_token('TYPE','BEN_WV_PRTN_RSN');
411: fnd_message.raise_error;
412: --
413: end if;
414: --
415: end if;

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('FIELD','p_hrs_wkd_bndry_perd_cd');
482: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
483: fnd_message.raise_error;
484: --

Line 481: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');

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('FIELD','p_hrs_wkd_bndry_perd_cd');
482: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
483: fnd_message.raise_error;
484: --
485: end if;

Line 482: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');

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('FIELD','p_hrs_wkd_bndry_perd_cd');
482: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
483: fnd_message.raise_error;
484: --
485: end if;
486: --

Line 483: fnd_message.raise_error;

479: --
480: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
481: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
482: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
483: fnd_message.raise_error;
484: --
485: end if;
486: --
487: end if;

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

500: p_effective_date => p_effective_date) then
501: --
502: -- raise error as does not exist as lookup
503: --
504: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
505: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
506: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
507: fnd_message.raise_error;
508: --

Line 505: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');

501: --
502: -- raise error as does not exist as lookup
503: --
504: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
505: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
506: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
507: fnd_message.raise_error;
508: --
509: end if;

Line 506: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');

502: -- raise error as does not exist as lookup
503: --
504: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
505: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
506: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
507: fnd_message.raise_error;
508: --
509: end if;
510: --

Line 507: fnd_message.raise_error;

503: --
504: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
505: fnd_message.set_token('FIELD','p_rt_hrs_wkd_bndry_perd_cd');
506: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
507: fnd_message.raise_error;
508: --
509: end if;
510: --
511: end if;

Line 551: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');

547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
550: --
551: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
552: fnd_message.raise_error;
553: --
554: end if;
555: --

Line 552: fnd_message.raise_error;

548: --
549: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
550: --
551: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
556: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then

Line 558: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');

554: end if;
555: --
556: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
557: --
558: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
559: fnd_message.raise_error;
560: --
561: end if;
562: --

Line 559: fnd_message.raise_error;

555: --
556: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
557: --
558: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
559: fnd_message.raise_error;
560: --
561: end if;
562: --
563: hr_utility.set_location('Leaving:'||l_proc,10);

Line 606: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');

602: --
603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: if (p_pl_wvd_flag = 'N' and p_wv_ctfn_typ_cd is not null) then
606: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');
607: fnd_message.raise_error;
608: end if;
609: --
610: l_api_updating := ben_pep_shd.api_updating

Line 607: fnd_message.raise_error;

603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: if (p_pl_wvd_flag = 'N' and p_wv_ctfn_typ_cd is not null) then
606: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');
607: fnd_message.raise_error;
608: end if;
609: --
610: l_api_updating := ben_pep_shd.api_updating
611: (p_elig_per_id => p_elig_per_id,

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

626: p_effective_date => p_effective_date) then
627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_wv_ctfn_typ_cd');
632: fnd_message.set_token('TYPE','BEN_WV_PRTN_CTFN_TYP');
633: fnd_message.raise_error;
634: --

Line 631: fnd_message.set_token('FIELD','p_wv_ctfn_typ_cd');

627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_wv_ctfn_typ_cd');
632: fnd_message.set_token('TYPE','BEN_WV_PRTN_CTFN_TYP');
633: fnd_message.raise_error;
634: --
635: end if;

Line 632: fnd_message.set_token('TYPE','BEN_WV_PRTN_CTFN_TYP');

628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_wv_ctfn_typ_cd');
632: fnd_message.set_token('TYPE','BEN_WV_PRTN_CTFN_TYP');
633: fnd_message.raise_error;
634: --
635: end if;
636: --

Line 633: fnd_message.raise_error;

629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_wv_ctfn_typ_cd');
632: fnd_message.set_token('TYPE','BEN_WV_PRTN_CTFN_TYP');
633: fnd_message.raise_error;
634: --
635: end if;
636: --
637: end if;

Line 685: fnd_message.set_name('BEN','BEN_91279_ELIG_PER_PRD_FLD_OVR');

681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: /*if (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_rsn_cd is not null) or
684: (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_thru_dt is not null) then
685: fnd_message.set_name('BEN','BEN_91279_ELIG_PER_PRD_FLD_OVR');
686: fnd_message.raise_error;
687: end if;*/
688: --
689: l_api_updating := ben_pep_shd.api_updating

Line 686: fnd_message.raise_error;

682: --
683: /*if (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_rsn_cd is not null) or
684: (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_thru_dt is not null) then
685: fnd_message.set_name('BEN','BEN_91279_ELIG_PER_PRD_FLD_OVR');
686: fnd_message.raise_error;
687: end if;*/
688: --
689: l_api_updating := ben_pep_shd.api_updating
690: (p_elig_per_id => p_elig_per_id,

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

704: p_effective_date => p_effective_date) then
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');
710: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
711: fnd_message.raise_error;
712: --

Line 709: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');

705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');
710: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
711: fnd_message.raise_error;
712: --
713: end if;

Line 710: fnd_message.set_token('TYPE','BEN_OVRID_RSN');

706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');
710: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
711: fnd_message.raise_error;
712: --
713: end if;
714: --

Line 711: fnd_message.raise_error;

707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');
710: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
715: end if;

Line 765: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');

761: --
762: if (p_age_val is null and p_age_uom is not null) or
763: (p_age_uom is null and p_age_val is not null) then
764: --
765: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
766: fnd_message.raise_error;
767: --
768: end if;
769: --

Line 766: fnd_message.raise_error;

762: if (p_age_val is null and p_age_uom is not null) or
763: (p_age_uom is null and p_age_val is not null) then
764: --
765: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
766: fnd_message.raise_error;
767: --
768: end if;
769: --
770: if (p_rt_age_val is null and p_rt_age_uom is not null) or

Line 773: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');

769: --
770: if (p_rt_age_val is null and p_rt_age_uom is not null) or
771: (p_rt_age_uom is null and p_rt_age_val is not null) then
772: --
773: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
774: fnd_message.raise_error;
775: --
776: end if;
777: --

Line 774: fnd_message.raise_error;

770: if (p_rt_age_val is null and p_rt_age_uom is not null) or
771: (p_rt_age_uom is null and p_rt_age_val is not null) then
772: --
773: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
774: fnd_message.raise_error;
775: --
776: end if;
777: --
778: l_api_updating := ben_pep_shd.api_updating

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

793: p_effective_date => p_effective_date) then
794: --
795: -- raise error as does not exist as lookup
796: --
797: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
798: fnd_message.set_token('FIELD','p_age_uom');
799: fnd_message.set_token('TYPE','BEN_TM_UOM');
800: fnd_message.raise_error;
801: --

Line 798: fnd_message.set_token('FIELD','p_age_uom');

794: --
795: -- raise error as does not exist as lookup
796: --
797: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
798: fnd_message.set_token('FIELD','p_age_uom');
799: fnd_message.set_token('TYPE','BEN_TM_UOM');
800: fnd_message.raise_error;
801: --
802: end if;

Line 799: fnd_message.set_token('TYPE','BEN_TM_UOM');

795: -- raise error as does not exist as lookup
796: --
797: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
798: fnd_message.set_token('FIELD','p_age_uom');
799: fnd_message.set_token('TYPE','BEN_TM_UOM');
800: fnd_message.raise_error;
801: --
802: end if;
803: --

Line 800: fnd_message.raise_error;

796: --
797: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
798: fnd_message.set_token('FIELD','p_age_uom');
799: fnd_message.set_token('TYPE','BEN_TM_UOM');
800: fnd_message.raise_error;
801: --
802: end if;
803: --
804: end if;

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

816: p_effective_date => p_effective_date) then
817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_rt_age_uom');
822: fnd_message.set_token('TYPE','BEN_TM_UOM');
823: fnd_message.raise_error;
824: --

Line 821: fnd_message.set_token('FIELD','p_rt_age_uom');

817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_rt_age_uom');
822: fnd_message.set_token('TYPE','BEN_TM_UOM');
823: fnd_message.raise_error;
824: --
825: end if;

Line 822: fnd_message.set_token('TYPE','BEN_TM_UOM');

818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_rt_age_uom');
822: fnd_message.set_token('TYPE','BEN_TM_UOM');
823: fnd_message.raise_error;
824: --
825: end if;
826: --

Line 823: fnd_message.raise_error;

819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_rt_age_uom');
822: fnd_message.set_token('TYPE','BEN_TM_UOM');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
827: end if;

Line 877: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');

873: --
874: if (p_los_val is null and p_los_uom is not null) or
875: (p_los_uom is null and p_los_val is not null) then
876: --
877: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
878: fnd_message.raise_error;
879: --
880: end if;
881: --

Line 878: fnd_message.raise_error;

874: if (p_los_val is null and p_los_uom is not null) or
875: (p_los_uom is null and p_los_val is not null) then
876: --
877: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
878: fnd_message.raise_error;
879: --
880: end if;
881: --
882: if (p_rt_los_val is null and p_rt_los_uom is not null) or

Line 885: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');

881: --
882: if (p_rt_los_val is null and p_rt_los_uom is not null) or
883: (p_rt_los_uom is null and p_rt_los_val is not null) then
884: --
885: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
886: fnd_message.raise_error;
887: --
888: end if;
889: --

Line 886: fnd_message.raise_error;

882: if (p_rt_los_val is null and p_rt_los_uom is not null) or
883: (p_rt_los_uom is null and p_rt_los_val is not null) then
884: --
885: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
886: fnd_message.raise_error;
887: --
888: end if;
889: --
890: l_api_updating := ben_pep_shd.api_updating

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

905: p_effective_date => p_effective_date) then
906: --
907: -- raise error as does not exist as lookup
908: --
909: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
910: fnd_message.set_token('FIELD','p_los_uom');
911: fnd_message.set_token('TYPE','BEN_TM_UOM');
912: fnd_message.raise_error;
913: --

Line 910: fnd_message.set_token('FIELD','p_los_uom');

906: --
907: -- raise error as does not exist as lookup
908: --
909: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
910: fnd_message.set_token('FIELD','p_los_uom');
911: fnd_message.set_token('TYPE','BEN_TM_UOM');
912: fnd_message.raise_error;
913: --
914: end if;

Line 911: fnd_message.set_token('TYPE','BEN_TM_UOM');

907: -- raise error as does not exist as lookup
908: --
909: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
910: fnd_message.set_token('FIELD','p_los_uom');
911: fnd_message.set_token('TYPE','BEN_TM_UOM');
912: fnd_message.raise_error;
913: --
914: end if;
915: --

Line 912: fnd_message.raise_error;

908: --
909: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
910: fnd_message.set_token('FIELD','p_los_uom');
911: fnd_message.set_token('TYPE','BEN_TM_UOM');
912: fnd_message.raise_error;
913: --
914: end if;
915: --
916: end if;

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

928: p_effective_date => p_effective_date) then
929: --
930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('FIELD','p_rt_los_uom');
934: fnd_message.set_token('TYPE','BEN_TM_UOM');
935: fnd_message.raise_error;
936: --

Line 933: fnd_message.set_token('FIELD','p_rt_los_uom');

929: --
930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('FIELD','p_rt_los_uom');
934: fnd_message.set_token('TYPE','BEN_TM_UOM');
935: fnd_message.raise_error;
936: --
937: end if;

Line 934: fnd_message.set_token('TYPE','BEN_TM_UOM');

930: -- raise error as does not exist as lookup
931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('FIELD','p_rt_los_uom');
934: fnd_message.set_token('TYPE','BEN_TM_UOM');
935: fnd_message.raise_error;
936: --
937: end if;
938: --

Line 935: fnd_message.raise_error;

931: --
932: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
933: fnd_message.set_token('FIELD','p_rt_los_uom');
934: fnd_message.set_token('TYPE','BEN_TM_UOM');
935: fnd_message.raise_error;
936: --
937: end if;
938: --
939: end if;

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

1000: p_effective_date => p_effective_date) then
1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1005: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
1006: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
1007: fnd_message.raise_error;
1008: --

Line 1005: fnd_message.set_token('FIELD','p_once_r_cntug_cd');

1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1005: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
1006: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
1007: fnd_message.raise_error;
1008: --
1009: end if;

Line 1006: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');

1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1005: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
1006: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
1007: fnd_message.raise_error;
1008: --
1009: end if;
1010: --

Line 1007: fnd_message.raise_error;

1003: --
1004: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1005: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
1006: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
1007: fnd_message.raise_error;
1008: --
1009: end if;
1010: --
1011: end if;

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

1071: p_effective_date => p_effective_date) then
1072: --
1073: -- raise error as does not exist as lookup
1074: --
1075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1076: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
1077: fnd_message.set_token('TYPE','YES_NO');
1078: fnd_message.raise_error;
1079: --

Line 1076: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');

1072: --
1073: -- raise error as does not exist as lookup
1074: --
1075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1076: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
1077: fnd_message.set_token('TYPE','YES_NO');
1078: fnd_message.raise_error;
1079: --
1080: end if;

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

1073: -- raise error as does not exist as lookup
1074: --
1075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1076: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
1077: fnd_message.set_token('TYPE','YES_NO');
1078: fnd_message.raise_error;
1079: --
1080: end if;
1081: --

Line 1078: fnd_message.raise_error;

1074: --
1075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1076: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
1077: fnd_message.set_token('TYPE','YES_NO');
1078: fnd_message.raise_error;
1079: --
1080: end if;
1081: --
1082: end if;

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

1149: p_effective_date => p_effective_date) then
1150: --
1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('FIELD','p_frz_comb_age_and_los_flag');
1155: fnd_message.set_token('TYPE','YES_NO');
1156: fnd_message.raise_error;
1157: --

Line 1154: fnd_message.set_token('FIELD','p_frz_comb_age_and_los_flag');

1150: --
1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('FIELD','p_frz_comb_age_and_los_flag');
1155: fnd_message.set_token('TYPE','YES_NO');
1156: fnd_message.raise_error;
1157: --
1158: end if;

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

1151: -- raise error as does not exist as lookup
1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('FIELD','p_frz_comb_age_and_los_flag');
1155: fnd_message.set_token('TYPE','YES_NO');
1156: fnd_message.raise_error;
1157: --
1158: end if;
1159: /*

Line 1156: fnd_message.raise_error;

1152: --
1153: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1154: fnd_message.set_token('FIELD','p_frz_comb_age_and_los_flag');
1155: fnd_message.set_token('TYPE','YES_NO');
1156: fnd_message.raise_error;
1157: --
1158: end if;
1159: /*
1160: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1178: p_effective_date => p_effective_date) then
1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1183: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1184: fnd_message.set_token('TYPE','YES_NO');
1185: fnd_message.raise_error;
1186: --

Line 1183: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');

1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1183: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1184: fnd_message.set_token('TYPE','YES_NO');
1185: fnd_message.raise_error;
1186: --
1187: end if;

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

1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1183: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1184: fnd_message.set_token('TYPE','YES_NO');
1185: fnd_message.raise_error;
1186: --
1187: end if;
1188: /*

Line 1185: fnd_message.raise_error;

1181: --
1182: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1183: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1184: fnd_message.set_token('TYPE','YES_NO');
1185: fnd_message.raise_error;
1186: --
1187: end if;
1188: /*
1189: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1258: p_effective_date => p_effective_date) then
1259: --
1260: -- raise error as does not exist as lookup
1261: --
1262: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1263: fnd_message.set_token('FIELD','p_dpnt_othr_pl_cvrd_rl_flag');
1264: fnd_message.set_token('TYPE','YES_NO');
1265: fnd_message.raise_error;
1266: --

Line 1263: fnd_message.set_token('FIELD','p_dpnt_othr_pl_cvrd_rl_flag');

1259: --
1260: -- raise error as does not exist as lookup
1261: --
1262: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1263: fnd_message.set_token('FIELD','p_dpnt_othr_pl_cvrd_rl_flag');
1264: fnd_message.set_token('TYPE','YES_NO');
1265: fnd_message.raise_error;
1266: --
1267: end if;

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

1260: -- raise error as does not exist as lookup
1261: --
1262: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1263: fnd_message.set_token('FIELD','p_dpnt_othr_pl_cvrd_rl_flag');
1264: fnd_message.set_token('TYPE','YES_NO');
1265: fnd_message.raise_error;
1266: --
1267: end if;
1268: --

Line 1265: fnd_message.raise_error;

1261: --
1262: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1263: fnd_message.set_token('FIELD','p_dpnt_othr_pl_cvrd_rl_flag');
1264: fnd_message.set_token('TYPE','YES_NO');
1265: fnd_message.raise_error;
1266: --
1267: end if;
1268: --
1269: end if;

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

1330: p_effective_date => p_effective_date) then
1331: --
1332: -- raise error as does not exist as lookup
1333: --
1334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1335: fnd_message.set_token('FIELD','p_pl_key_ee_flag');
1336: fnd_message.set_token('TYPE','YES_NO');
1337: fnd_message.raise_error;
1338: --

Line 1335: fnd_message.set_token('FIELD','p_pl_key_ee_flag');

1331: --
1332: -- raise error as does not exist as lookup
1333: --
1334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1335: fnd_message.set_token('FIELD','p_pl_key_ee_flag');
1336: fnd_message.set_token('TYPE','YES_NO');
1337: fnd_message.raise_error;
1338: --
1339: end if;

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

1332: -- raise error as does not exist as lookup
1333: --
1334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1335: fnd_message.set_token('FIELD','p_pl_key_ee_flag');
1336: fnd_message.set_token('TYPE','YES_NO');
1337: fnd_message.raise_error;
1338: --
1339: end if;
1340: --

Line 1337: fnd_message.raise_error;

1333: --
1334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1335: fnd_message.set_token('FIELD','p_pl_key_ee_flag');
1336: fnd_message.set_token('TYPE','YES_NO');
1337: fnd_message.raise_error;
1338: --
1339: end if;
1340: --
1341: end if;

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

1402: p_effective_date => p_effective_date) then
1403: --
1404: -- raise error as does not exist as lookup
1405: --
1406: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1407: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1408: fnd_message.set_token('TYPE','YES_NO');
1409: fnd_message.raise_error;
1410: --

Line 1407: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');

1403: --
1404: -- raise error as does not exist as lookup
1405: --
1406: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1407: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1408: fnd_message.set_token('TYPE','YES_NO');
1409: fnd_message.raise_error;
1410: --
1411: end if;

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

1404: -- raise error as does not exist as lookup
1405: --
1406: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1407: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1408: fnd_message.set_token('TYPE','YES_NO');
1409: fnd_message.raise_error;
1410: --
1411: end if;
1412: --

Line 1409: fnd_message.raise_error;

1405: --
1406: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1407: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1408: fnd_message.set_token('TYPE','YES_NO');
1409: fnd_message.raise_error;
1410: --
1411: end if;
1412: --
1413: end if;

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

1475: p_effective_date => p_effective_date) then
1476: --
1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_pl_hghly_compd_flag');
1481: fnd_message.set_token('TYPE','YES_NO');
1482: fnd_message.raise_error;
1483: --

Line 1480: fnd_message.set_token('FIELD','p_pl_hghly_compd_flag');

1476: --
1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_pl_hghly_compd_flag');
1481: fnd_message.set_token('TYPE','YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;

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

1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_pl_hghly_compd_flag');
1481: fnd_message.set_token('TYPE','YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1485: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

Line 1482: fnd_message.raise_error;

1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_pl_hghly_compd_flag');
1481: fnd_message.set_token('TYPE','YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1485: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1486: --

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

1554: p_effective_date => p_effective_date) then
1555: --
1556: -- raise error as does not exist as lookup
1557: --
1558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1559: fnd_message.set_token('FIELD','p_frz_los_flag');
1560: fnd_message.set_token('TYPE','YES_NO');
1561: fnd_message.raise_error;
1562: --

Line 1559: fnd_message.set_token('FIELD','p_frz_los_flag');

1555: --
1556: -- raise error as does not exist as lookup
1557: --
1558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1559: fnd_message.set_token('FIELD','p_frz_los_flag');
1560: fnd_message.set_token('TYPE','YES_NO');
1561: fnd_message.raise_error;
1562: --
1563: end if;

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

1556: -- raise error as does not exist as lookup
1557: --
1558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1559: fnd_message.set_token('FIELD','p_frz_los_flag');
1560: fnd_message.set_token('TYPE','YES_NO');
1561: fnd_message.raise_error;
1562: --
1563: end if;
1564: /*

Line 1561: fnd_message.raise_error;

1557: --
1558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1559: fnd_message.set_token('FIELD','p_frz_los_flag');
1560: fnd_message.set_token('TYPE','YES_NO');
1561: fnd_message.raise_error;
1562: --
1563: end if;
1564: /*
1565: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1583: p_effective_date => p_effective_date) then
1584: --
1585: -- raise error as does not exist as lookup
1586: --
1587: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1588: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1589: fnd_message.set_token('TYPE','YES_NO');
1590: fnd_message.raise_error;
1591: --

Line 1588: fnd_message.set_token('FIELD','p_rt_frz_los_flag');

1584: --
1585: -- raise error as does not exist as lookup
1586: --
1587: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1588: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1589: fnd_message.set_token('TYPE','YES_NO');
1590: fnd_message.raise_error;
1591: --
1592: end if;

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

1585: -- raise error as does not exist as lookup
1586: --
1587: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1588: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1589: fnd_message.set_token('TYPE','YES_NO');
1590: fnd_message.raise_error;
1591: --
1592: end if;
1593: /*

Line 1590: fnd_message.raise_error;

1586: --
1587: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1588: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1589: fnd_message.set_token('TYPE','YES_NO');
1590: fnd_message.raise_error;
1591: --
1592: end if;
1593: /*
1594: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1666: p_effective_date => p_effective_date) then
1667: --
1668: -- raise error as does not exist as lookup
1669: --
1670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1671: fnd_message.set_token('FIELD','p_frz_age_flag');
1672: fnd_message.set_token('TYPE','YES_NO');
1673: fnd_message.raise_error;
1674: --

Line 1671: fnd_message.set_token('FIELD','p_frz_age_flag');

1667: --
1668: -- raise error as does not exist as lookup
1669: --
1670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1671: fnd_message.set_token('FIELD','p_frz_age_flag');
1672: fnd_message.set_token('TYPE','YES_NO');
1673: fnd_message.raise_error;
1674: --
1675: end if;

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

1668: -- raise error as does not exist as lookup
1669: --
1670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1671: fnd_message.set_token('FIELD','p_frz_age_flag');
1672: fnd_message.set_token('TYPE','YES_NO');
1673: fnd_message.raise_error;
1674: --
1675: end if;
1676: /*

Line 1673: fnd_message.raise_error;

1669: --
1670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1671: fnd_message.set_token('FIELD','p_frz_age_flag');
1672: fnd_message.set_token('TYPE','YES_NO');
1673: fnd_message.raise_error;
1674: --
1675: end if;
1676: /*
1677: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1695: p_effective_date => p_effective_date) then
1696: --
1697: -- raise error as does not exist as lookup
1698: --
1699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1700: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1701: fnd_message.set_token('TYPE','YES_NO');
1702: fnd_message.raise_error;
1703: --

Line 1700: fnd_message.set_token('FIELD','p_rt_frz_age_flag');

1696: --
1697: -- raise error as does not exist as lookup
1698: --
1699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1700: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1701: fnd_message.set_token('TYPE','YES_NO');
1702: fnd_message.raise_error;
1703: --
1704: end if;

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

1697: -- raise error as does not exist as lookup
1698: --
1699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1700: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1701: fnd_message.set_token('TYPE','YES_NO');
1702: fnd_message.raise_error;
1703: --
1704: end if;
1705: /*

Line 1702: fnd_message.raise_error;

1698: --
1699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1700: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1701: fnd_message.set_token('TYPE','YES_NO');
1702: fnd_message.raise_error;
1703: --
1704: end if;
1705: /*
1706: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1778: p_effective_date => p_effective_date) then
1779: --
1780: -- raise error as does not exist as lookup
1781: --
1782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1783: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1784: fnd_message.set_token('TYPE','YES_NO');
1785: fnd_message.raise_error;
1786: --

Line 1783: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');

1779: --
1780: -- raise error as does not exist as lookup
1781: --
1782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1783: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1784: fnd_message.set_token('TYPE','YES_NO');
1785: fnd_message.raise_error;
1786: --
1787: end if;

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

1780: -- raise error as does not exist as lookup
1781: --
1782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1783: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1784: fnd_message.set_token('TYPE','YES_NO');
1785: fnd_message.raise_error;
1786: --
1787: end if;
1788: /*

Line 1785: fnd_message.raise_error;

1781: --
1782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1783: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1784: fnd_message.set_token('TYPE','YES_NO');
1785: fnd_message.raise_error;
1786: --
1787: end if;
1788: /*
1789: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1807: p_effective_date => p_effective_date) then
1808: --
1809: -- raise error as does not exist as lookup
1810: --
1811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1812: fnd_message.set_token('FIELD','p_rt_frz_cmp_lvl_flag');
1813: fnd_message.set_token('TYPE','YES_NO');
1814: fnd_message.raise_error;
1815: --

Line 1812: fnd_message.set_token('FIELD','p_rt_frz_cmp_lvl_flag');

1808: --
1809: -- raise error as does not exist as lookup
1810: --
1811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1812: fnd_message.set_token('FIELD','p_rt_frz_cmp_lvl_flag');
1813: fnd_message.set_token('TYPE','YES_NO');
1814: fnd_message.raise_error;
1815: --
1816: end if;

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

1809: -- raise error as does not exist as lookup
1810: --
1811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1812: fnd_message.set_token('FIELD','p_rt_frz_cmp_lvl_flag');
1813: fnd_message.set_token('TYPE','YES_NO');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: /*

Line 1814: fnd_message.raise_error;

1810: --
1811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1812: fnd_message.set_token('FIELD','p_rt_frz_cmp_lvl_flag');
1813: fnd_message.set_token('TYPE','YES_NO');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: /*
1818: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1890: p_effective_date => p_effective_date) then
1891: --
1892: -- raise error as does not exist as lookup
1893: --
1894: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1895: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1896: fnd_message.set_token('TYPE','YES_NO');
1897: fnd_message.raise_error;
1898: --

Line 1895: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');

1891: --
1892: -- raise error as does not exist as lookup
1893: --
1894: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1895: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1896: fnd_message.set_token('TYPE','YES_NO');
1897: fnd_message.raise_error;
1898: --
1899: end if;

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

1892: -- raise error as does not exist as lookup
1893: --
1894: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1895: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1896: fnd_message.set_token('TYPE','YES_NO');
1897: fnd_message.raise_error;
1898: --
1899: end if;
1900: /*

Line 1897: fnd_message.raise_error;

1893: --
1894: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1895: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1896: fnd_message.set_token('TYPE','YES_NO');
1897: fnd_message.raise_error;
1898: --
1899: end if;
1900: /*
1901: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1919: p_effective_date => p_effective_date) then
1920: --
1921: -- raise error as does not exist as lookup
1922: --
1923: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1924: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1925: fnd_message.set_token('TYPE','YES_NO');
1926: fnd_message.raise_error;
1927: --

Line 1924: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');

1920: --
1921: -- raise error as does not exist as lookup
1922: --
1923: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1924: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1925: fnd_message.set_token('TYPE','YES_NO');
1926: fnd_message.raise_error;
1927: --
1928: end if;

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

1921: -- raise error as does not exist as lookup
1922: --
1923: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1924: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1925: fnd_message.set_token('TYPE','YES_NO');
1926: fnd_message.raise_error;
1927: --
1928: end if;
1929: /*

Line 1926: fnd_message.raise_error;

1922: --
1923: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1924: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1925: fnd_message.set_token('TYPE','YES_NO');
1926: fnd_message.raise_error;
1927: --
1928: end if;
1929: /*
1930: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

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

1998: p_effective_date => p_effective_date) then
1999: --
2000: -- raise error as does not exist as lookup
2001: --
2002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2003: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
2004: fnd_message.set_token('TYPE','YES_NO');
2005: fnd_message.raise_error;
2006: --

Line 2003: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');

1999: --
2000: -- raise error as does not exist as lookup
2001: --
2002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2003: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
2004: fnd_message.set_token('TYPE','YES_NO');
2005: fnd_message.raise_error;
2006: --
2007: end if;

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

2000: -- raise error as does not exist as lookup
2001: --
2002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2003: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
2004: fnd_message.set_token('TYPE','YES_NO');
2005: fnd_message.raise_error;
2006: --
2007: end if;
2008: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

Line 2005: fnd_message.raise_error;

2001: --
2002: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2003: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
2004: fnd_message.set_token('TYPE','YES_NO');
2005: fnd_message.raise_error;
2006: --
2007: end if;
2008: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
2009: --

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

2022: p_effective_date => p_effective_date) then
2023: --
2024: -- raise error as does not exist as lookup
2025: --
2026: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2027: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
2028: fnd_message.set_token('TYPE','YES_NO');
2029: fnd_message.raise_error;
2030: --

Line 2027: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');

2023: --
2024: -- raise error as does not exist as lookup
2025: --
2026: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2027: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
2028: fnd_message.set_token('TYPE','YES_NO');
2029: fnd_message.raise_error;
2030: --
2031: end if;

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

2024: -- raise error as does not exist as lookup
2025: --
2026: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2027: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
2028: fnd_message.set_token('TYPE','YES_NO');
2029: fnd_message.raise_error;
2030: --
2031: end if;
2032: --

Line 2029: fnd_message.raise_error;

2025: --
2026: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2027: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
2028: fnd_message.set_token('TYPE','YES_NO');
2029: fnd_message.raise_error;
2030: --
2031: end if;
2032: --
2033: end if;

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

2094: p_effective_date => p_effective_date) then
2095: --
2096: -- raise error as does not exist as lookup
2097: --
2098: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2099: fnd_message.set_token('FIELD','p_dstr_rstrn_flag');
2100: fnd_message.set_token('TYPE','YES_NO');
2101: fnd_message.raise_error;
2102: --

Line 2099: fnd_message.set_token('FIELD','p_dstr_rstrn_flag');

2095: --
2096: -- raise error as does not exist as lookup
2097: --
2098: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2099: fnd_message.set_token('FIELD','p_dstr_rstrn_flag');
2100: fnd_message.set_token('TYPE','YES_NO');
2101: fnd_message.raise_error;
2102: --
2103: end if;

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

2096: -- raise error as does not exist as lookup
2097: --
2098: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2099: fnd_message.set_token('FIELD','p_dstr_rstrn_flag');
2100: fnd_message.set_token('TYPE','YES_NO');
2101: fnd_message.raise_error;
2102: --
2103: end if;
2104: --

Line 2101: fnd_message.raise_error;

2097: --
2098: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2099: fnd_message.set_token('FIELD','p_dstr_rstrn_flag');
2100: fnd_message.set_token('TYPE','YES_NO');
2101: fnd_message.raise_error;
2102: --
2103: end if;
2104: --
2105: end if;

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

2166: p_effective_date => p_effective_date) then
2167: --
2168: -- raise error as does not exist as lookup
2169: --
2170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2171: fnd_message.set_token('FIELD','p_elig_flag');
2172: fnd_message.set_token('TYPE','YES_NO');
2173: fnd_message.raise_error;
2174: --

Line 2171: fnd_message.set_token('FIELD','p_elig_flag');

2167: --
2168: -- raise error as does not exist as lookup
2169: --
2170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2171: fnd_message.set_token('FIELD','p_elig_flag');
2172: fnd_message.set_token('TYPE','YES_NO');
2173: fnd_message.raise_error;
2174: --
2175: end if;

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

2168: -- raise error as does not exist as lookup
2169: --
2170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2171: fnd_message.set_token('FIELD','p_elig_flag');
2172: fnd_message.set_token('TYPE','YES_NO');
2173: fnd_message.raise_error;
2174: --
2175: end if;
2176: --

Line 2173: fnd_message.raise_error;

2169: --
2170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2171: fnd_message.set_token('FIELD','p_elig_flag');
2172: fnd_message.set_token('TYPE','YES_NO');
2173: fnd_message.raise_error;
2174: --
2175: end if;
2176: --
2177: end if;

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

2238: p_effective_date => p_effective_date) then
2239: --
2240: -- raise error as does not exist as lookup
2241: --
2242: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2243: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
2244: fnd_message.set_token('TYPE','BEN_INELG_RSN');
2245: fnd_message.raise_error;
2246: --

Line 2243: fnd_message.set_token('FIELD','p_inelg_rsn_cd');

2239: --
2240: -- raise error as does not exist as lookup
2241: --
2242: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2243: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
2244: fnd_message.set_token('TYPE','BEN_INELG_RSN');
2245: fnd_message.raise_error;
2246: --
2247: end if;

Line 2244: fnd_message.set_token('TYPE','BEN_INELG_RSN');

2240: -- raise error as does not exist as lookup
2241: --
2242: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2243: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
2244: fnd_message.set_token('TYPE','BEN_INELG_RSN');
2245: fnd_message.raise_error;
2246: --
2247: end if;
2248: --

Line 2245: fnd_message.raise_error;

2241: --
2242: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2243: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
2244: fnd_message.set_token('TYPE','BEN_INELG_RSN');
2245: fnd_message.raise_error;
2246: --
2247: end if;
2248: --
2249: end if;

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

2310: p_effective_date => p_effective_date) then
2311: --
2312: -- raise error as does not exist as lookup
2313: --
2314: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2315: fnd_message.set_token('FIELD','p_pl_wvd_flag');
2316: fnd_message.set_token('TYPE','YES_NO');
2317: fnd_message.raise_error;
2318: --

Line 2315: fnd_message.set_token('FIELD','p_pl_wvd_flag');

2311: --
2312: -- raise error as does not exist as lookup
2313: --
2314: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2315: fnd_message.set_token('FIELD','p_pl_wvd_flag');
2316: fnd_message.set_token('TYPE','YES_NO');
2317: fnd_message.raise_error;
2318: --
2319: end if;

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

2312: -- raise error as does not exist as lookup
2313: --
2314: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2315: fnd_message.set_token('FIELD','p_pl_wvd_flag');
2316: fnd_message.set_token('TYPE','YES_NO');
2317: fnd_message.raise_error;
2318: --
2319: end if;
2320: --

Line 2317: fnd_message.raise_error;

2313: --
2314: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2315: fnd_message.set_token('FIELD','p_pl_wvd_flag');
2316: fnd_message.set_token('TYPE','YES_NO');
2317: fnd_message.raise_error;
2318: --
2319: end if;
2320: --
2321: end if;

Line 2457: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

2453: --
2454: -- A referential integrity check was violated therefore
2455: -- we must error
2456: --
2457: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2458: fnd_message.set_token('TABLE_NAME', l_table_name);
2459: fnd_message.raise_error;
2460: When Others Then
2461: --

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

2454: -- A referential integrity check was violated therefore
2455: -- we must error
2456: --
2457: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2458: fnd_message.set_token('TABLE_NAME', l_table_name);
2459: fnd_message.raise_error;
2460: When Others Then
2461: --
2462: -- An unhandled or unexpected error has occurred which

Line 2459: fnd_message.raise_error;

2455: -- we must error
2456: --
2457: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2458: fnd_message.set_token('TABLE_NAME', l_table_name);
2459: fnd_message.raise_error;
2460: When Others Then
2461: --
2462: -- An unhandled or unexpected error has occurred which
2463: -- we must report

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

2461: --
2462: -- An unhandled or unexpected error has occurred which
2463: -- we must report
2464: --
2465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2466: fnd_message.set_token('PROCEDURE', l_proc);
2467: fnd_message.set_token('STEP','15');
2468: fnd_message.raise_error;
2469: End dt_update_validate;

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

2462: -- An unhandled or unexpected error has occurred which
2463: -- we must report
2464: --
2465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2466: fnd_message.set_token('PROCEDURE', l_proc);
2467: fnd_message.set_token('STEP','15');
2468: fnd_message.raise_error;
2469: End dt_update_validate;
2470: --

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

2463: -- we must report
2464: --
2465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2466: fnd_message.set_token('PROCEDURE', l_proc);
2467: fnd_message.set_token('STEP','15');
2468: fnd_message.raise_error;
2469: End dt_update_validate;
2470: --
2471: -- ----------------------------------------------------------------------------

Line 2468: fnd_message.raise_error;

2464: --
2465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2466: fnd_message.set_token('PROCEDURE', l_proc);
2467: fnd_message.set_token('STEP','15');
2468: fnd_message.raise_error;
2469: End dt_update_validate;
2470: --
2471: -- ----------------------------------------------------------------------------
2472: -- |--------------------------< dt_delete_validate >--------------------------|

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

2565: --
2566: -- A referential integrity check was violated therefore
2567: -- we must error
2568: --
2569: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2570: fnd_message.set_token('TABLE_NAME', l_table_name);
2571: fnd_message.raise_error;
2572: When Others Then
2573: --

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

2566: -- A referential integrity check was violated therefore
2567: -- we must error
2568: --
2569: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2570: fnd_message.set_token('TABLE_NAME', l_table_name);
2571: fnd_message.raise_error;
2572: When Others Then
2573: --
2574: -- An unhandled or unexpected error has occurred which

Line 2571: fnd_message.raise_error;

2567: -- we must error
2568: --
2569: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2570: fnd_message.set_token('TABLE_NAME', l_table_name);
2571: fnd_message.raise_error;
2572: When Others Then
2573: --
2574: -- An unhandled or unexpected error has occurred which
2575: -- we must report

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

2573: --
2574: -- An unhandled or unexpected error has occurred which
2575: -- we must report
2576: --
2577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2578: fnd_message.set_token('PROCEDURE', l_proc);
2579: fnd_message.set_token('STEP','15');
2580: fnd_message.raise_error;
2581: End dt_delete_validate;

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

2574: -- An unhandled or unexpected error has occurred which
2575: -- we must report
2576: --
2577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2578: fnd_message.set_token('PROCEDURE', l_proc);
2579: fnd_message.set_token('STEP','15');
2580: fnd_message.raise_error;
2581: End dt_delete_validate;
2582: --

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

2575: -- we must report
2576: --
2577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2578: fnd_message.set_token('PROCEDURE', l_proc);
2579: fnd_message.set_token('STEP','15');
2580: fnd_message.raise_error;
2581: End dt_delete_validate;
2582: --
2583: -- ----------------------------------------------------------------------------

Line 2580: fnd_message.raise_error;

2576: --
2577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2578: fnd_message.set_token('PROCEDURE', l_proc);
2579: fnd_message.set_token('STEP','15');
2580: fnd_message.raise_error;
2581: End dt_delete_validate;
2582: --
2583: -- ----------------------------------------------------------------------------
2584: -- |---------------------------< insert_validate >----------------------------|