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_EPO_BUS dependencies on FND_MESSAGE

Line 106: fnd_message.set_name('BEN','BEN_91275_ELIG_PER_OPT_ONP');

102: if c1%notfound then
103: --
104: close c1;
105: --
106: fnd_message.set_name('BEN','BEN_91275_ELIG_PER_OPT_ONP');
107: fnd_message.raise_error;
108: --
109: end if;
110: --

Line 107: fnd_message.raise_error;

103: --
104: close c1;
105: --
106: fnd_message.set_name('BEN','BEN_91275_ELIG_PER_OPT_ONP');
107: fnd_message.raise_error;
108: --
109: end if;
110: --
111: close c1;

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

170: --
171: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
172: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
173: --
174: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
175: fnd_message.raise_error;
176: --
177: end if;
178: --

Line 175: fnd_message.raise_error;

171: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
172: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
173: --
174: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
175: fnd_message.raise_error;
176: --
177: end if;
178: --
179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or

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

178: --
179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
180: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
181: --
182: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
183: fnd_message.raise_error;
184: --
185: end if;
186: --

Line 183: fnd_message.raise_error;

179: if (p_rt_comp_ref_val is null and p_rt_comp_ref_uom is not null) or
180: (p_rt_comp_ref_uom is null and p_rt_comp_ref_val is not null) then
181: --
182: fnd_message.set_name('BEN','BEN_91277_ELIG_PER_PRD_FLD_CMP');
183: fnd_message.raise_error;
184: --
185: end if;
186: --
187: l_api_updating:= ben_epo_shd.api_updating

Line 205: fnd_message.set_name('BEN','MUPPET');

201: fetch c1 into l_dummy;
202: if c1%notfound then
203: --
204: close c1;
205: fnd_message.set_name('BEN','MUPPET');
206: fnd_message.raise_error;
207: --
208: end if;
209: --

Line 206: fnd_message.raise_error;

202: if c1%notfound then
203: --
204: close c1;
205: fnd_message.set_name('BEN','MUPPET');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
210: close c1;

Line 227: fnd_message.set_name('BEN','MUPPET');

223: fetch c2 into l_dummy;
224: if c2%notfound then
225: --
226: close c2;
227: fnd_message.set_name('BEN','MUPPET');
228: fnd_message.raise_error;
229: --
230: end if;
231: --

Line 228: fnd_message.raise_error;

224: if c2%notfound then
225: --
226: close c2;
227: fnd_message.set_name('BEN','MUPPET');
228: fnd_message.raise_error;
229: --
230: end if;
231: --
232: close c2;

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

293: p_effective_date => p_effective_date) then
294: --
295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --

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

294: --
295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;

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

295: -- raise error as does not exist as lookup
296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;
303: --

Line 300: fnd_message.raise_error;

296: --
297: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
298: fnd_message.set_token('FIELD','p_hrs_wkd_bndry_perd_cd');
299: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
300: fnd_message.raise_error;
301: --
302: end if;
303: --
304: end if;

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

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

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

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

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

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

Line 323: fnd_message.raise_error;

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

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

362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
365: --
366: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
367: fnd_message.raise_error;
368: --
369: end if;
370: --

Line 367: fnd_message.raise_error;

363: --
364: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
365: --
366: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
367: fnd_message.raise_error;
368: --
369: end if;
370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then

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

369: end if;
370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
372: --
373: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
374: fnd_message.raise_error;
375: --
376: end if;
377: --

Line 374: fnd_message.raise_error;

370: --
371: if (p_rt_pct_val IS NOT NULL and (p_rt_pct_val < 0 OR p_rt_pct_val > 100)) then
372: --
373: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');
374: fnd_message.raise_error;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);

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

421: --
422: if (p_age_val is null and p_age_uom is not null) or
423: (p_age_uom is null and p_age_val is not null) then
424: --
425: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
426: fnd_message.raise_error;
427: --
428: end if;
429: --

Line 426: fnd_message.raise_error;

422: if (p_age_val is null and p_age_uom is not null) or
423: (p_age_uom is null and p_age_val is not null) then
424: --
425: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
430: if (p_rt_age_val is null and p_rt_age_uom is not null) or

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

429: --
430: if (p_rt_age_val is null and p_rt_age_uom is not null) or
431: (p_rt_age_uom is null and p_rt_age_val is not null) then
432: --
433: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
434: fnd_message.raise_error;
435: --
436: end if;
437: --

Line 434: fnd_message.raise_error;

430: if (p_rt_age_val is null and p_rt_age_uom is not null) or
431: (p_rt_age_uom is null and p_rt_age_val is not null) then
432: --
433: fnd_message.set_name('BEN','BEN_91276_ELIG_PER_PRD_FLD_AGE');
434: fnd_message.raise_error;
435: --
436: end if;
437: --
438: l_api_updating := ben_epo_shd.api_updating

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

453: p_effective_date => p_effective_date) then
454: --
455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --

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

454: --
455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;

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

455: -- raise error as does not exist as lookup
456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;
463: --

Line 460: fnd_message.raise_error;

456: --
457: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
458: fnd_message.set_token('FIELD','p_age_uom');
459: fnd_message.set_token('TYPE','BEN_TM_UOM');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
464: 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_rt_age_uom');
482: fnd_message.set_token('TYPE','BEN_TM_UOM');
483: fnd_message.raise_error;
484: --

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

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

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

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

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

545: p_effective_date => p_effective_date) then
546: --
547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --

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

546: --
547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;

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

547: -- raise error as does not exist as lookup
548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;
555: --

Line 552: fnd_message.raise_error;

548: --
549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
550: fnd_message.set_token('FIELD','p_once_r_cntug_cd');
551: fnd_message.set_token('TYPE','BEN_ONCE_R_CNTNG');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
556: end if;

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

614: p_effective_date => p_effective_date) then
615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --

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

615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;

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

616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;
624: --

Line 621: fnd_message.raise_error;

617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_inelg_rsn_cd');
620: fnd_message.set_token('TYPE','BEN_INELG_RSN');
621: fnd_message.raise_error;
622: --
623: end if;
624: --
625: end if;

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

670: --
671: if (p_los_val is null and p_los_uom is not null) or
672: (p_los_uom is null and p_los_val is not null) then
673: --
674: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
675: fnd_message.raise_error;
676: --
677: end if;
678: --

Line 675: fnd_message.raise_error;

671: if (p_los_val is null and p_los_uom is not null) or
672: (p_los_uom is null and p_los_val is not null) then
673: --
674: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
679: if (p_rt_los_val is null and p_rt_los_uom is not null) or

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

678: --
679: if (p_rt_los_val is null and p_rt_los_uom is not null) or
680: (p_rt_los_uom is null and p_rt_los_val is not null) then
681: --
682: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
683: fnd_message.raise_error;
684: --
685: end if;
686: --

Line 683: fnd_message.raise_error;

679: if (p_rt_los_val is null and p_rt_los_uom is not null) or
680: (p_rt_los_uom is null and p_rt_los_val is not null) then
681: --
682: fnd_message.set_name('BEN','BEN_91278_ELIG_PER_PRD_FLD_LOS');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
687: l_api_updating := ben_epo_shd.api_updating

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

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

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

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

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

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

Line 709: fnd_message.raise_error;

705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_los_uom');
708: fnd_message.set_token('TYPE','BEN_TM_UOM');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
713: end if;

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

725: p_effective_date => p_effective_date) then
726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --

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

726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;

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

727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;
735: --

Line 732: fnd_message.raise_error;

728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_rt_los_uom');
731: fnd_message.set_token('TYPE','BEN_TM_UOM');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
736: end if;

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

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

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

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

Line 801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');

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

Line 802: fnd_message.raise_error;

798: --
799: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
800: fnd_message.set_token('FIELD','p_prtn_ovridn_rsn_cd');
801: fnd_message.set_token('TYPE','BEN_PRTN_OVRRIDN_RSN');
802: fnd_message.raise_error;
803: --
804: end if;
805: --
806: end if;

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

865: p_effective_date => p_effective_date) then
866: --
867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --

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

866: --
867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;

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

867: -- raise error as does not exist as lookup
868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;
875: --

Line 872: fnd_message.raise_error;

868: --
869: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
870: fnd_message.set_token('FIELD','p_elig_flag');
871: fnd_message.set_token('TYPE','YES_NO');
872: fnd_message.raise_error;
873: --
874: end if;
875: --
876: end if;

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

937: p_effective_date => p_effective_date) then
938: --
939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --

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

938: --
939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;

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

939: -- raise error as does not exist as lookup
940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;
947: --

Line 944: fnd_message.raise_error;

940: --
941: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
942: fnd_message.set_token('FIELD','p_no_mx_prtn_ovrid_thru_flag');
943: fnd_message.set_token('TYPE','YES_NO');
944: fnd_message.raise_error;
945: --
946: end if;
947: --
948: end if;

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

1032: p_effective_date => p_effective_date) then
1033: --
1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --

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

1033: --
1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;

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

1034: -- raise error as does not exist as lookup
1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;
1042: --

Line 1039: fnd_message.raise_error;

1035: --
1036: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1037: fnd_message.set_token('FIELD','p_rt_frz_los_flag');
1038: fnd_message.set_token('TYPE','YES_NO');
1039: fnd_message.raise_error;
1040: --
1041: end if;
1042: --
1043: end if;

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

1056: p_effective_date => p_effective_date) then
1057: --
1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --

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

1057: --
1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;

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

1058: -- raise error as does not exist as lookup
1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;
1066: --

Line 1063: fnd_message.raise_error;

1059: --
1060: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1061: fnd_message.set_token('FIELD','p_rt_frz_age_flag');
1062: fnd_message.set_token('TYPE','YES_NO');
1063: fnd_message.raise_error;
1064: --
1065: end if;
1066: --
1067: end if;

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

1080: p_effective_date => p_effective_date) then
1081: --
1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --

Line 1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');

1081: --
1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;

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

1082: -- raise error as does not exist as lookup
1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --

Line 1087: fnd_message.raise_error;

1083: --
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_rt_cmp_lvl_flag');
1086: fnd_message.set_token('TYPE','YES_NO');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1091: end if;

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

1104: p_effective_date => p_effective_date) then
1105: --
1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --

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

1105: --
1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;

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

1106: -- raise error as does not exist as lookup
1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --

Line 1111: fnd_message.raise_error;

1107: --
1108: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1109: fnd_message.set_token('FIELD','p_rt_frz_pct_fl_tm_flag');
1110: fnd_message.set_token('TYPE','YES_NO');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --
1115: end if;

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

1128: p_effective_date => p_effective_date) then
1129: --
1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --

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

1129: --
1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;

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

1130: -- raise error as does not exist as lookup
1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;
1138: --

Line 1135: fnd_message.raise_error;

1131: --
1132: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1133: fnd_message.set_token('FIELD','p_rt_frz_hrs_wkd_flag');
1134: fnd_message.set_token('TYPE','YES_NO');
1135: fnd_message.raise_error;
1136: --
1137: end if;
1138: --
1139: end if;

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

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

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

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

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

1154: -- raise error as does not exist as lookup
1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --

Line 1159: fnd_message.raise_error;

1155: --
1156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1157: fnd_message.set_token('FIELD','p_rt_frz_comb_age_and_los_flag');
1158: fnd_message.set_token('TYPE','YES_NO');
1159: fnd_message.raise_error;
1160: --
1161: end if;
1162: --
1163: end if;

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

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

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

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

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

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

Line 1183: fnd_message.raise_error;

1179: --
1180: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1181: fnd_message.set_token('FIELD','p_frz_los_flag');
1182: fnd_message.set_token('TYPE','YES_NO');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1187: end if;

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

1200: p_effective_date => p_effective_date) then
1201: --
1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --

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

1201: --
1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;

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

1202: -- raise error as does not exist as lookup
1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --

Line 1207: fnd_message.raise_error;

1203: --
1204: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1205: fnd_message.set_token('FIELD','p_frz_age_flag');
1206: fnd_message.set_token('TYPE','YES_NO');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --
1211: end if;

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

1224: p_effective_date => p_effective_date) then
1225: --
1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --

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

1225: --
1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;

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

1226: -- raise error as does not exist as lookup
1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: --

Line 1231: fnd_message.raise_error;

1227: --
1228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1229: fnd_message.set_token('FIELD','p_frz_cmp_lvl_flag');
1230: fnd_message.set_token('TYPE','YES_NO');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: --
1235: end if;

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

1248: p_effective_date => p_effective_date) then
1249: --
1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --

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

1249: --
1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;

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

1250: -- raise error as does not exist as lookup
1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --

Line 1255: fnd_message.raise_error;

1251: --
1252: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1253: fnd_message.set_token('FIELD','p_frz_pct_fl_tm_flag');
1254: fnd_message.set_token('TYPE','YES_NO');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --
1259: end if;

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

1272: p_effective_date => p_effective_date) then
1273: --
1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --

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

1273: --
1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;

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

1274: -- raise error as does not exist as lookup
1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;
1282: --

Line 1279: fnd_message.raise_error;

1275: --
1276: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1277: fnd_message.set_token('FIELD','p_frz_hrs_wkd_flag');
1278: fnd_message.set_token('TYPE','YES_NO');
1279: fnd_message.raise_error;
1280: --
1281: end if;
1282: --
1283: end if;

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

1341: p_effective_date => p_effective_date) then
1342: --
1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --

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

1342: --
1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;

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

1343: -- raise error as does not exist as lookup
1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;
1351: --

Line 1348: fnd_message.raise_error;

1344: --
1345: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1346: fnd_message.set_token('FIELD','p_prtn_ovridn_flag');
1347: fnd_message.set_token('TYPE','YES_NO');
1348: fnd_message.raise_error;
1349: --
1350: end if;
1351: --
1352: end if;

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

1451: --
1452: -- A referential integrity check was violated therefore
1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --

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

1452: -- A referential integrity check was violated therefore
1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --
1460: -- An unhandled or unexpected error has occurred which

Line 1457: fnd_message.raise_error;

1453: -- we must error
1454: --
1455: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1456: fnd_message.set_token('TABLE_NAME', l_table_name);
1457: fnd_message.raise_error;
1458: When Others Then
1459: --
1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report

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

1459: --
1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;

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

1460: -- An unhandled or unexpected error has occurred which
1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --

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

1461: -- we must report
1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --
1469: -- ----------------------------------------------------------------------------

Line 1466: fnd_message.raise_error;

1462: --
1463: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1464: fnd_message.set_token('PROCEDURE', l_proc);
1465: fnd_message.set_token('STEP','15');
1466: fnd_message.raise_error;
1467: End dt_update_validate;
1468: --
1469: -- ----------------------------------------------------------------------------
1470: -- |--------------------------< dt_delete_validate >--------------------------|

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

1555: --
1556: -- A referential integrity check was violated therefore
1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --

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

1556: -- A referential integrity check was violated therefore
1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --
1564: -- An unhandled or unexpected error has occurred which

Line 1561: fnd_message.raise_error;

1557: -- we must error
1558: --
1559: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1560: fnd_message.set_token('TABLE_NAME', l_table_name);
1561: fnd_message.raise_error;
1562: When Others Then
1563: --
1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report

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

1563: --
1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;

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

1564: -- An unhandled or unexpected error has occurred which
1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --

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

1565: -- we must report
1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --
1573: -- ----------------------------------------------------------------------------

Line 1570: fnd_message.raise_error;

1566: --
1567: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1568: fnd_message.set_token('PROCEDURE', l_proc);
1569: fnd_message.set_token('STEP','15');
1570: fnd_message.raise_error;
1571: End dt_delete_validate;
1572: --
1573: -- ----------------------------------------------------------------------------
1574: -- |---------------------------< insert_validate >----------------------------|

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

1887: close csr_leg_code;
1888: --
1889: -- The primary key is invalid therefore we must error
1890: --
1891: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --

Line 1892: fnd_message.raise_error;

1888: --
1889: -- The primary key is invalid therefore we must error
1890: --
1891: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --
1896: close csr_leg_code;