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

Line 141: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');

137: p_base_key_value => p_vrbl_rt_prfl_id,
138: p_from_date => p_validation_start_date,
139: p_to_date => p_validation_end_date)) Then
140: --
141: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
142: fnd_message.set_token('RATE_TYPE','Standard Rate');
143: fnd_message.raise_error;
144: --
145: end if;

Line 142: fnd_message.set_token('RATE_TYPE','Standard Rate');

138: p_from_date => p_validation_start_date,
139: p_to_date => p_validation_end_date)) Then
140: --
141: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
142: fnd_message.set_token('RATE_TYPE','Standard Rate');
143: fnd_message.raise_error;
144: --
145: end if;
146: --

Line 143: fnd_message.raise_error;

139: p_to_date => p_validation_end_date)) Then
140: --
141: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
142: fnd_message.set_token('RATE_TYPE','Standard Rate');
143: fnd_message.raise_error;
144: --
145: end if;
146: --
147: End If;

Line 158: fnd_message.set_name ('BEN','BEN_93902_VAPRO_CHILD_EXISTS');

154: p_base_key_value => p_vrbl_rt_prfl_id,
155: p_from_date => p_validation_start_date,
156: p_to_date => p_validation_end_date)) Then
157: --
158: fnd_message.set_name ('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
159: fnd_message.set_token('RATE_TYPE','Coverage');
160: fnd_message.raise_error;
161: --
162: end if;

Line 159: fnd_message.set_token('RATE_TYPE','Coverage');

155: p_from_date => p_validation_start_date,
156: p_to_date => p_validation_end_date)) Then
157: --
158: fnd_message.set_name ('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
159: fnd_message.set_token('RATE_TYPE','Coverage');
160: fnd_message.raise_error;
161: --
162: end if;
163: --

Line 160: fnd_message.raise_error;

156: p_to_date => p_validation_end_date)) Then
157: --
158: fnd_message.set_name ('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
159: fnd_message.set_token('RATE_TYPE','Coverage');
160: fnd_message.raise_error;
161: --
162: end if;
163: --
164: End If;

Line 176: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');

172: p_base_key_value => p_vrbl_rt_prfl_id,
173: p_from_date => p_validation_start_date,
174: p_to_date => p_validation_end_date)) Then
175: --
176: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
177: fnd_message.set_token('RATE_TYPE','Actual Premium');
178: fnd_message.raise_error;
179: --
180: end if;

Line 177: fnd_message.set_token('RATE_TYPE','Actual Premium');

173: p_from_date => p_validation_start_date,
174: p_to_date => p_validation_end_date)) Then
175: --
176: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
177: fnd_message.set_token('RATE_TYPE','Actual Premium');
178: fnd_message.raise_error;
179: --
180: end if;
181: hr_utility.set_location('Reaced here',9999);

Line 178: fnd_message.raise_error;

174: p_to_date => p_validation_end_date)) Then
175: --
176: fnd_message.set_name('BEN','BEN_93902_VAPRO_CHILD_EXISTS');
177: fnd_message.set_token('RATE_TYPE','Actual Premium');
178: fnd_message.raise_error;
179: --
180: end if;
181: hr_utility.set_location('Reaced here',9999);
182: --

Line 222: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

218: begin
219: if p_mn_elcn_val is not null and
220: p_mx_elcn_val is not null and
221: p_mx_elcn_val < p_mn_elcn_val then
222: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
223: fnd_message.raise_error;
224: end if;
225: end chk_mn_mx_elcn_vals;
226: --

Line 223: fnd_message.raise_error;

219: if p_mn_elcn_val is not null and
220: p_mx_elcn_val is not null and
221: p_mx_elcn_val < p_mn_elcn_val then
222: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
223: fnd_message.raise_error;
224: end if;
225: end chk_mn_mx_elcn_vals;
226: --
227: -- ----------------------------------------------------------------------------

Line 257: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');

253: begin
254: if p_lwr_lmt_val is not null and
255: p_upr_lmt_val is not null and
256: p_upr_lmt_val < p_lwr_lmt_val then
257: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
258: fnd_message.raise_error;
259: end if;
260: end chk_lwr_upr_lmt_vals;
261: --

Line 258: fnd_message.raise_error;

254: if p_lwr_lmt_val is not null and
255: p_upr_lmt_val is not null and
256: p_upr_lmt_val < p_lwr_lmt_val then
257: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
258: fnd_message.raise_error;
259: end if;
260: end chk_lwr_upr_lmt_vals;
261: --
262:

Line 274: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');

270: begin
271: if p_ultmt_lwr_lmt is not null and
272: p_ultmt_upr_lmt is not null and
273: p_ultmt_upr_lmt < p_ultmt_lwr_lmt then
274: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
275: fnd_message.raise_error;
276: end if;
277: end chk_ultmt_lwr_upr_lmt;
278:

Line 275: fnd_message.raise_error;

271: if p_ultmt_lwr_lmt is not null and
272: p_ultmt_upr_lmt is not null and
273: p_ultmt_upr_lmt < p_ultmt_lwr_lmt then
274: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
275: fnd_message.raise_error;
276: end if;
277: end chk_ultmt_lwr_upr_lmt;
278:
279:

Line 327: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

323: open c1;
324: fetch c1 into l_dummy;
325: if c1%found then
326: close c1;
327: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
328: fnd_message.raise_error;
329: end if;
330: --
331: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 328: fnd_message.raise_error;

324: fetch c1 into l_dummy;
325: if c1%found then
326: close c1;
327: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
328: fnd_message.raise_error;
329: end if;
330: --
331: hr_utility.set_location('Leaving:'||l_proc, 15);
332: End chk_name_unique;

Line 374: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');

370: -- mutually exclusive.
371: if (p_lwr_lmt_val is not null and p_lwr_lmt_calc_rl is not null)
372: then
373: --
374: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');
375: fnd_message.raise_error;
376: --
377: end if;
378: end chk_lwr_lmt_val_and_rl;

Line 375: fnd_message.raise_error;

371: if (p_lwr_lmt_val is not null and p_lwr_lmt_calc_rl is not null)
372: then
373: --
374: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');
375: fnd_message.raise_error;
376: --
377: end if;
378: end chk_lwr_lmt_val_and_rl;
379:

Line 423: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');

419: -- mutually exclusive.
420: if (p_ultmt_lwr_lmt is not null and p_ultmt_lwr_lmt_calc_rl is not null)
421: then
422: --
423: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');
424: fnd_message.raise_error;
425: --
426: end if;
427: end chk_ultmt_lwr_lmt_val_and_rl;

Line 424: fnd_message.raise_error;

420: if (p_ultmt_lwr_lmt is not null and p_ultmt_lwr_lmt_calc_rl is not null)
421: then
422: --
423: fnd_message.set_name('BEN','BEN_91859_LWR_LMT_VAL_AND_RL');
424: fnd_message.raise_error;
425: --
426: end if;
427: end chk_ultmt_lwr_lmt_val_and_rl;
428:

Line 471: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');

467: -- mutually exclusive.
468: if (p_upr_lmt_val is not null and p_upr_lmt_calc_rl is not null)
469: then
470: --
471: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');
472: fnd_message.raise_error;
473: --
474: end if;
475: end chk_upr_lmt_val_and_rl;

Line 472: fnd_message.raise_error;

468: if (p_upr_lmt_val is not null and p_upr_lmt_calc_rl is not null)
469: then
470: --
471: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');
472: fnd_message.raise_error;
473: --
474: end if;
475: end chk_upr_lmt_val_and_rl;
476:

Line 520: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');

516: -- mutually exclusive.
517: if (p_ultmt_upr_lmt is not null and p_ultmt_upr_lmt_calc_rl is not null)
518: then
519: --
520: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');
521: fnd_message.raise_error;
522: --
523: end if;
524: end chk_ultmt_upr_lmt_val_and_rl;

Line 521: fnd_message.raise_error;

517: if (p_ultmt_upr_lmt is not null and p_ultmt_upr_lmt_calc_rl is not null)
518: then
519: --
520: fnd_message.set_name('BEN','BEN_91860_UPR_LMT_VAL_AND_RL');
521: fnd_message.raise_error;
522: --
523: end if;
524: end chk_ultmt_upr_lmt_val_and_rl;
525:

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

1510: p_effective_date => p_effective_date) then
1511: --
1512: -- raise error as does not exist as lookup
1513: --
1514: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1515: fnd_message.set_token('FIELD', 'p_vrbl_usg_cd');
1516: fnd_message.set_token('TYPE', 'BEN_VRBL_USG_CD');
1517: fnd_message.raise_error;
1518: --

Line 1515: fnd_message.set_token('FIELD', 'p_vrbl_usg_cd');

1511: --
1512: -- raise error as does not exist as lookup
1513: --
1514: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1515: fnd_message.set_token('FIELD', 'p_vrbl_usg_cd');
1516: fnd_message.set_token('TYPE', 'BEN_VRBL_USG_CD');
1517: fnd_message.raise_error;
1518: --
1519: end if;

Line 1516: fnd_message.set_token('TYPE', 'BEN_VRBL_USG_CD');

1512: -- raise error as does not exist as lookup
1513: --
1514: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1515: fnd_message.set_token('FIELD', 'p_vrbl_usg_cd');
1516: fnd_message.set_token('TYPE', 'BEN_VRBL_USG_CD');
1517: fnd_message.raise_error;
1518: --
1519: end if;
1520: --

Line 1517: fnd_message.raise_error;

1513: --
1514: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1515: fnd_message.set_token('FIELD', 'p_vrbl_usg_cd');
1516: fnd_message.set_token('TYPE', 'BEN_VRBL_USG_CD');
1517: fnd_message.raise_error;
1518: --
1519: end if;
1520: --
1521: --

Line 1524: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');

1520: --
1521: --
1522: -- if mlt_cd is 'TPLPC' then defer the action.
1523: if (p_mlt_cd = 'TPLPC') then
1524: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');
1525: fnd_message.raise_error;
1526: end if;
1527: --
1528: end if;

Line 1525: fnd_message.raise_error;

1521: --
1522: -- if mlt_cd is 'TPLPC' then defer the action.
1523: if (p_mlt_cd = 'TPLPC') then
1524: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');
1525: fnd_message.raise_error;
1526: end if;
1527: --
1528: end if;
1529: --

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

1657: p_effective_date => p_effective_date) then
1658: --
1659: -- raise error as does not exist as lookup
1660: --
1661: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1662: fnd_message.set_token('FIELD', 'p_asmt_to_use_cd');
1663: fnd_message.set_token('TYPE', 'BEN_ASMT_TO_USE');
1664: fnd_message.raise_error;
1665: --

Line 1662: fnd_message.set_token('FIELD', 'p_asmt_to_use_cd');

1658: --
1659: -- raise error as does not exist as lookup
1660: --
1661: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1662: fnd_message.set_token('FIELD', 'p_asmt_to_use_cd');
1663: fnd_message.set_token('TYPE', 'BEN_ASMT_TO_USE');
1664: fnd_message.raise_error;
1665: --
1666: end if;

Line 1663: fnd_message.set_token('TYPE', 'BEN_ASMT_TO_USE');

1659: -- raise error as does not exist as lookup
1660: --
1661: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1662: fnd_message.set_token('FIELD', 'p_asmt_to_use_cd');
1663: fnd_message.set_token('TYPE', 'BEN_ASMT_TO_USE');
1664: fnd_message.raise_error;
1665: --
1666: end if;
1667: --

Line 1664: fnd_message.raise_error;

1660: --
1661: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1662: fnd_message.set_token('FIELD', 'p_asmt_to_use_cd');
1663: fnd_message.set_token('TYPE', 'BEN_ASMT_TO_USE');
1664: fnd_message.raise_error;
1665: --
1666: end if;
1667: --
1668: end if;

Line 1785: fnd_message.set_name('BEN','BEN_91732_NO_RNDG_RULE');

1781: -- check dependency of Code and Rule.
1782: --
1783: if (p_rndg_cd <> 'RL' and
1784: p_rndg_rl is not null) then
1785: fnd_message.set_name('BEN','BEN_91732_NO_RNDG_RULE');
1786: fnd_message.raise_error;
1787: end if;
1788:
1789: if (p_rndg_cd = 'RL' and p_rndg_rl is null) then

Line 1786: fnd_message.raise_error;

1782: --
1783: if (p_rndg_cd <> 'RL' and
1784: p_rndg_rl is not null) then
1785: fnd_message.set_name('BEN','BEN_91732_NO_RNDG_RULE');
1786: fnd_message.raise_error;
1787: end if;
1788:
1789: if (p_rndg_cd = 'RL' and p_rndg_rl is null) then
1790: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');

Line 1790: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');

1786: fnd_message.raise_error;
1787: end if;
1788:
1789: if (p_rndg_cd = 'RL' and p_rndg_rl is null) then
1790: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');
1791: fnd_message.raise_error;
1792: end if;
1793:
1794: --

Line 1791: fnd_message.raise_error;

1787: end if;
1788:
1789: if (p_rndg_cd = 'RL' and p_rndg_rl is null) then
1790: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');
1791: fnd_message.raise_error;
1792: end if;
1793:
1794: --
1795: -- Leaving Procedure.

Line 1908: fnd_message.set_name('BEN','BEN_92439_REF_PERD_USAGE');

1904: if p_acty_ref_perd_cd <> 'MO' then
1905: --
1906: -- raise error as does not exist as lookup
1907: --
1908: fnd_message.set_name('BEN','BEN_92439_REF_PERD_USAGE');
1909: fnd_message.raise_error;
1910: --
1911: end if;
1912: --

Line 1909: fnd_message.raise_error;

1905: --
1906: -- raise error as does not exist as lookup
1907: --
1908: fnd_message.set_name('BEN','BEN_92439_REF_PERD_USAGE');
1909: fnd_message.raise_error;
1910: --
1911: end if;
1912: --
1913: end if;

Line 1965: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');

1961: p_dflt_elcn_val is not null then
1962: --
1963: -- raise error as does not exist as lookup
1964: --
1965: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --

Line 1966: fnd_message.raise_error;

1962: --
1963: -- raise error as does not exist as lookup
1964: --
1965: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --
1970: end if;

Line 1978: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');

1974: if p_val is not null and p_mlt_cd <> 'FLFXPCL' then
1975: --
1976: -- raise error as does not exist as lookup
1977: --
1978: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');
1979: fnd_message.raise_error;
1980: --
1981: end if;
1982: --

Line 1979: fnd_message.raise_error;

1975: --
1976: -- raise error as does not exist as lookup
1977: --
1978: fnd_message.set_name('BEN','BEN_92440_VAL_VS_OTHERS');
1979: fnd_message.raise_error;
1980: --
1981: end if;
1982: --
1983: end if;

Line 2386: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');

2382: open c1;
2383: fetch c1 into l_dummy;
2384: if c1%notfound then
2385: close c1;
2386: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');
2387: fnd_message.raise_error;
2388: end if;
2389: --
2390: close c1;

Line 2387: fnd_message.raise_error;

2383: fetch c1 into l_dummy;
2384: if c1%notfound then
2385: close c1;
2386: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');
2387: fnd_message.raise_error;
2388: end if;
2389: --
2390: close c1;
2391: --

Line 2455: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');

2451: open c1;
2452: fetch c1 into l_dummy;
2453: if c1%notfound then
2454: close c1;
2455: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');
2456: fnd_message.raise_error;
2457: end if;
2458: --
2459: close c1;

Line 2456: fnd_message.raise_error;

2452: fetch c1 into l_dummy;
2453: if c1%notfound then
2454: close c1;
2455: fnd_message.set_name('BEN','BEN_92265_PRTT_CRIT_NOTDEF');
2456: fnd_message.raise_error;
2457: end if;
2458: --
2459: close c1;
2460: --

Line 2519: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');

2515: open c1;
2516: fetch c1 into l_dummy;
2517: if c1%notfound then
2518: close c1;
2519: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');
2520: fnd_message.raise_error;
2521: end if;
2522: --
2523: close c1;

Line 2520: fnd_message.raise_error;

2516: fetch c1 into l_dummy;
2517: if c1%notfound then
2518: close c1;
2519: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');
2520: fnd_message.raise_error;
2521: end if;
2522: --
2523: close c1;
2524: --

Line 2587: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');

2583: open c1;
2584: fetch c1 into l_dummy;
2585: if c1%notfound then
2586: close c1;
2587: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');
2588: fnd_message.raise_error;
2589: end if;
2590: --
2591: close c1;

Line 2588: fnd_message.raise_error;

2584: fetch c1 into l_dummy;
2585: if c1%notfound then
2586: close c1;
2587: fnd_message.set_name('BEN','BEN_92266_CVG_CRIT_NOTDEF');
2588: fnd_message.raise_error;
2589: end if;
2590: --
2591: close c1;
2592: --

Line 2639: fnd_message.set_name('BEN','BEN_92260_TX_TYP_MUST_NOTAPP');

2635: hr_utility.set_location('Entering:'||l_proc, 5);
2636: --
2637: If p_vrbl_usg_cd = 'ACP' then
2638: if p_tx_typ_cd <> 'NOTAPPLICABLE' then
2639: fnd_message.set_name('BEN','BEN_92260_TX_TYP_MUST_NOTAPP');
2640: fnd_message.raise_error;
2641: end if;
2642: elsif p_acty_typ_cd is null then
2643: fnd_message.set_name('BEN','BEN_92261_ACTY_TYP_RQD');

Line 2640: fnd_message.raise_error;

2636: --
2637: If p_vrbl_usg_cd = 'ACP' then
2638: if p_tx_typ_cd <> 'NOTAPPLICABLE' then
2639: fnd_message.set_name('BEN','BEN_92260_TX_TYP_MUST_NOTAPP');
2640: fnd_message.raise_error;
2641: end if;
2642: elsif p_acty_typ_cd is null then
2643: fnd_message.set_name('BEN','BEN_92261_ACTY_TYP_RQD');
2644: fnd_message.raise_error;

Line 2643: fnd_message.set_name('BEN','BEN_92261_ACTY_TYP_RQD');

2639: fnd_message.set_name('BEN','BEN_92260_TX_TYP_MUST_NOTAPP');
2640: fnd_message.raise_error;
2641: end if;
2642: elsif p_acty_typ_cd is null then
2643: fnd_message.set_name('BEN','BEN_92261_ACTY_TYP_RQD');
2644: fnd_message.raise_error;
2645: end if;
2646: --
2647: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2644: fnd_message.raise_error;

2640: fnd_message.raise_error;
2641: end if;
2642: elsif p_acty_typ_cd is null then
2643: fnd_message.set_name('BEN','BEN_92261_ACTY_TYP_RQD');
2644: fnd_message.raise_error;
2645: end if;
2646: --
2647: hr_utility.set_location('Leaving:'||l_proc,10);
2648: --

Line 2686: fnd_message.set_name('BEN','BEN_92262_ONE_FLAG_ALWD_SET');

2682: hr_utility.set_location('Entering:'||l_proc, 5);
2683: --
2684: If p_alwys_cnt_all_prtts_flag = 'Y' and p_alwys_sum_all_cvg_flag = 'Y' then
2685: -- Only one flag can be set to Y
2686: fnd_message.set_name('BEN','BEN_92262_ONE_FLAG_ALWD_SET');
2687: fnd_message.raise_error;
2688: --
2689: end if;
2690: --

Line 2687: fnd_message.raise_error;

2683: --
2684: If p_alwys_cnt_all_prtts_flag = 'Y' and p_alwys_sum_all_cvg_flag = 'Y' then
2685: -- Only one flag can be set to Y
2686: fnd_message.set_name('BEN','BEN_92262_ONE_FLAG_ALWD_SET');
2687: fnd_message.raise_error;
2688: --
2689: end if;
2690: --
2691: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2768: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');

2764: --
2765: -- raise an error as mlt_cd can't be changed when prtt criteria set up.
2766: --
2767: --
2768: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
2769: fnd_message.raise_error;
2770: --
2771: end if;
2772: --

Line 2769: fnd_message.raise_error;

2765: -- raise an error as mlt_cd can't be changed when prtt criteria set up.
2766: --
2767: --
2768: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
2769: fnd_message.raise_error;
2770: --
2771: end if;
2772: --
2773: close c2;

Line 2791: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');

2787: --
2788: -- raise an error as mlt_cd can't be changed when cvg criteria set up.
2789: --
2790: --
2791: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
2792: fnd_message.raise_error;
2793: --
2794: end if;
2795: --

Line 2792: fnd_message.raise_error;

2788: -- raise an error as mlt_cd can't be changed when cvg criteria set up.
2789: --
2790: --
2791: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
2792: fnd_message.raise_error;
2793: --
2794: end if;
2795: --
2796: close c1;

Line 2878: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');

2874: if c2%found then
2875: --
2876: close c2;
2877: -- raise an error as mlt_cd can't be changed when prtt criteria set up.
2878: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
2879: fnd_message.raise_error;
2880: --
2881: end if;
2882: --

Line 2879: fnd_message.raise_error;

2875: --
2876: close c2;
2877: -- raise an error as mlt_cd can't be changed when prtt criteria set up.
2878: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
2879: fnd_message.raise_error;
2880: --
2881: end if;
2882: --
2883: close c2;

Line 2896: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');

2892: if c1%found then
2893: --
2894: close c1;
2895: -- raise an error as mlt_cd can't be changed when cvg criteria set up.
2896: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
2897: fnd_message.raise_error;
2898: --
2899: end if;
2900: --

Line 2897: fnd_message.raise_error;

2893: --
2894: close c1;
2895: -- raise an error as mlt_cd can't be changed when cvg criteria set up.
2896: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
2897: fnd_message.raise_error;
2898: --
2899: end if;
2900: --
2901: close c1;

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

3040: p_effective_date => p_effective_date) then
3041: --
3042: -- raise error as does not exist as lookup
3043: --
3044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3045: fnd_message.set_token('FIELD',p_rt_hrly_slrd_flag);
3046: fnd_message.set_token('TYPE','YES_NO');
3047: fnd_message.raise_error;
3048: --

Line 3045: fnd_message.set_token('FIELD',p_rt_hrly_slrd_flag);

3041: --
3042: -- raise error as does not exist as lookup
3043: --
3044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3045: fnd_message.set_token('FIELD',p_rt_hrly_slrd_flag);
3046: fnd_message.set_token('TYPE','YES_NO');
3047: fnd_message.raise_error;
3048: --
3049: end if;

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

3042: -- raise error as does not exist as lookup
3043: --
3044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3045: fnd_message.set_token('FIELD',p_rt_hrly_slrd_flag);
3046: fnd_message.set_token('TYPE','YES_NO');
3047: fnd_message.raise_error;
3048: --
3049: end if;
3050: --

Line 3047: fnd_message.raise_error;

3043: --
3044: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3045: fnd_message.set_token('FIELD',p_rt_hrly_slrd_flag);
3046: fnd_message.set_token('TYPE','YES_NO');
3047: fnd_message.raise_error;
3048: --
3049: end if;
3050: --
3051: if hr_api.not_exists_in_hr_lookups

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

3054: p_effective_date => p_effective_date) then
3055: --
3056: -- raise error as does not exist as lookup
3057: --
3058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3059: fnd_message.set_token('FIELD',p_rt_pstl_cd_flag);
3060: fnd_message.set_token('TYPE','YES_NO');
3061: fnd_message.raise_error;
3062: --

Line 3059: fnd_message.set_token('FIELD',p_rt_pstl_cd_flag);

3055: --
3056: -- raise error as does not exist as lookup
3057: --
3058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3059: fnd_message.set_token('FIELD',p_rt_pstl_cd_flag);
3060: fnd_message.set_token('TYPE','YES_NO');
3061: fnd_message.raise_error;
3062: --
3063: end if;

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

3056: -- raise error as does not exist as lookup
3057: --
3058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3059: fnd_message.set_token('FIELD',p_rt_pstl_cd_flag);
3060: fnd_message.set_token('TYPE','YES_NO');
3061: fnd_message.raise_error;
3062: --
3063: end if;
3064: --

Line 3061: fnd_message.raise_error;

3057: --
3058: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3059: fnd_message.set_token('FIELD',p_rt_pstl_cd_flag);
3060: fnd_message.set_token('TYPE','YES_NO');
3061: fnd_message.raise_error;
3062: --
3063: end if;
3064: --
3065: if hr_api.not_exists_in_hr_lookups

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

3068: p_effective_date => p_effective_date) then
3069: --
3070: -- raise error as does not exist as lookup
3071: --
3072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3073: fnd_message.set_token('FIELD',p_rt_lbr_mmbr_flag);
3074: fnd_message.set_token('TYPE','YES_NO');
3075: fnd_message.raise_error;
3076: --

Line 3073: fnd_message.set_token('FIELD',p_rt_lbr_mmbr_flag);

3069: --
3070: -- raise error as does not exist as lookup
3071: --
3072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3073: fnd_message.set_token('FIELD',p_rt_lbr_mmbr_flag);
3074: fnd_message.set_token('TYPE','YES_NO');
3075: fnd_message.raise_error;
3076: --
3077: end if;

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

3070: -- raise error as does not exist as lookup
3071: --
3072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3073: fnd_message.set_token('FIELD',p_rt_lbr_mmbr_flag);
3074: fnd_message.set_token('TYPE','YES_NO');
3075: fnd_message.raise_error;
3076: --
3077: end if;
3078: --

Line 3075: fnd_message.raise_error;

3071: --
3072: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3073: fnd_message.set_token('FIELD',p_rt_lbr_mmbr_flag);
3074: fnd_message.set_token('TYPE','YES_NO');
3075: fnd_message.raise_error;
3076: --
3077: end if;
3078: --
3079: if hr_api.not_exists_in_hr_lookups

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

3082: p_effective_date => p_effective_date) then
3083: --
3084: -- raise error as does not exist as lookup
3085: --
3086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3087: fnd_message.set_token('FIELD',p_rt_lgl_enty_flag);
3088: fnd_message.set_token('TYPE','YES_NO');
3089: fnd_message.raise_error;
3090: --

Line 3087: fnd_message.set_token('FIELD',p_rt_lgl_enty_flag);

3083: --
3084: -- raise error as does not exist as lookup
3085: --
3086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3087: fnd_message.set_token('FIELD',p_rt_lgl_enty_flag);
3088: fnd_message.set_token('TYPE','YES_NO');
3089: fnd_message.raise_error;
3090: --
3091: end if;

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

3084: -- raise error as does not exist as lookup
3085: --
3086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3087: fnd_message.set_token('FIELD',p_rt_lgl_enty_flag);
3088: fnd_message.set_token('TYPE','YES_NO');
3089: fnd_message.raise_error;
3090: --
3091: end if;
3092: --

Line 3089: fnd_message.raise_error;

3085: --
3086: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3087: fnd_message.set_token('FIELD',p_rt_lgl_enty_flag);
3088: fnd_message.set_token('TYPE','YES_NO');
3089: fnd_message.raise_error;
3090: --
3091: end if;
3092: --
3093: if hr_api.not_exists_in_hr_lookups

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

3096: p_effective_date => p_effective_date) then
3097: --
3098: -- raise error as does not exist as lookup
3099: --
3100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3101: fnd_message.set_token('FIELD',p_rt_benfts_grp_flag);
3102: fnd_message.set_token('TYPE','YES_NO');
3103: fnd_message.raise_error;
3104: --

Line 3101: fnd_message.set_token('FIELD',p_rt_benfts_grp_flag);

3097: --
3098: -- raise error as does not exist as lookup
3099: --
3100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3101: fnd_message.set_token('FIELD',p_rt_benfts_grp_flag);
3102: fnd_message.set_token('TYPE','YES_NO');
3103: fnd_message.raise_error;
3104: --
3105: end if;

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

3098: -- raise error as does not exist as lookup
3099: --
3100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3101: fnd_message.set_token('FIELD',p_rt_benfts_grp_flag);
3102: fnd_message.set_token('TYPE','YES_NO');
3103: fnd_message.raise_error;
3104: --
3105: end if;
3106: --

Line 3103: fnd_message.raise_error;

3099: --
3100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3101: fnd_message.set_token('FIELD',p_rt_benfts_grp_flag);
3102: fnd_message.set_token('TYPE','YES_NO');
3103: fnd_message.raise_error;
3104: --
3105: end if;
3106: --
3107: if hr_api.not_exists_in_hr_lookups

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

3110: p_effective_date => p_effective_date) then
3111: --
3112: -- raise error as does not exist as lookup
3113: --
3114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3115: fnd_message.set_token('FIELD',p_rt_wk_loc_flag);
3116: fnd_message.set_token('TYPE','YES_NO');
3117: fnd_message.raise_error;
3118: --

Line 3115: fnd_message.set_token('FIELD',p_rt_wk_loc_flag);

3111: --
3112: -- raise error as does not exist as lookup
3113: --
3114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3115: fnd_message.set_token('FIELD',p_rt_wk_loc_flag);
3116: fnd_message.set_token('TYPE','YES_NO');
3117: fnd_message.raise_error;
3118: --
3119: end if;

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

3112: -- raise error as does not exist as lookup
3113: --
3114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3115: fnd_message.set_token('FIELD',p_rt_wk_loc_flag);
3116: fnd_message.set_token('TYPE','YES_NO');
3117: fnd_message.raise_error;
3118: --
3119: end if;
3120: --

Line 3117: fnd_message.raise_error;

3113: --
3114: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3115: fnd_message.set_token('FIELD',p_rt_wk_loc_flag);
3116: fnd_message.set_token('TYPE','YES_NO');
3117: fnd_message.raise_error;
3118: --
3119: end if;
3120: --
3121: if hr_api.not_exists_in_hr_lookups

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

3124: p_effective_date => p_effective_date) then
3125: --
3126: -- raise error as does not exist as lookup
3127: --
3128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3129: fnd_message.set_token('FIELD',p_rt_brgng_unit_flag);
3130: fnd_message.set_token('TYPE','YES_NO');
3131: fnd_message.raise_error;
3132: --

Line 3129: fnd_message.set_token('FIELD',p_rt_brgng_unit_flag);

3125: --
3126: -- raise error as does not exist as lookup
3127: --
3128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3129: fnd_message.set_token('FIELD',p_rt_brgng_unit_flag);
3130: fnd_message.set_token('TYPE','YES_NO');
3131: fnd_message.raise_error;
3132: --
3133: end if;

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

3126: -- raise error as does not exist as lookup
3127: --
3128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3129: fnd_message.set_token('FIELD',p_rt_brgng_unit_flag);
3130: fnd_message.set_token('TYPE','YES_NO');
3131: fnd_message.raise_error;
3132: --
3133: end if;
3134: --

Line 3131: fnd_message.raise_error;

3127: --
3128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3129: fnd_message.set_token('FIELD',p_rt_brgng_unit_flag);
3130: fnd_message.set_token('TYPE','YES_NO');
3131: fnd_message.raise_error;
3132: --
3133: end if;
3134: --
3135: if hr_api.not_exists_in_hr_lookups

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

3138: p_effective_date => p_effective_date) then
3139: --
3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD',p_rt_age_flag);
3144: fnd_message.set_token('TYPE','YES_NO');
3145: fnd_message.raise_error;
3146: --

Line 3143: fnd_message.set_token('FIELD',p_rt_age_flag);

3139: --
3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD',p_rt_age_flag);
3144: fnd_message.set_token('TYPE','YES_NO');
3145: fnd_message.raise_error;
3146: --
3147: end if;

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

3140: -- raise error as does not exist as lookup
3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD',p_rt_age_flag);
3144: fnd_message.set_token('TYPE','YES_NO');
3145: fnd_message.raise_error;
3146: --
3147: end if;
3148: --

Line 3145: fnd_message.raise_error;

3141: --
3142: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3143: fnd_message.set_token('FIELD',p_rt_age_flag);
3144: fnd_message.set_token('TYPE','YES_NO');
3145: fnd_message.raise_error;
3146: --
3147: end if;
3148: --
3149: if hr_api.not_exists_in_hr_lookups

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

3152: p_effective_date => p_effective_date) then
3153: --
3154: -- raise error as does not exist as lookup
3155: --
3156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3157: fnd_message.set_token('FIELD',p_rt_los_flag);
3158: fnd_message.set_token('TYPE','YES_NO');
3159: fnd_message.raise_error;
3160: --

Line 3157: fnd_message.set_token('FIELD',p_rt_los_flag);

3153: --
3154: -- raise error as does not exist as lookup
3155: --
3156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3157: fnd_message.set_token('FIELD',p_rt_los_flag);
3158: fnd_message.set_token('TYPE','YES_NO');
3159: fnd_message.raise_error;
3160: --
3161: end if;

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

3154: -- raise error as does not exist as lookup
3155: --
3156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3157: fnd_message.set_token('FIELD',p_rt_los_flag);
3158: fnd_message.set_token('TYPE','YES_NO');
3159: fnd_message.raise_error;
3160: --
3161: end if;
3162: --

Line 3159: fnd_message.raise_error;

3155: --
3156: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3157: fnd_message.set_token('FIELD',p_rt_los_flag);
3158: fnd_message.set_token('TYPE','YES_NO');
3159: fnd_message.raise_error;
3160: --
3161: end if;
3162: --
3163: if hr_api.not_exists_in_hr_lookups

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

3166: p_effective_date => p_effective_date) then
3167: --
3168: -- raise error as does not exist as lookup
3169: --
3170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3171: fnd_message.set_token('FIELD',p_rt_per_typ_flag);
3172: fnd_message.set_token('TYPE','YES_NO');
3173: fnd_message.raise_error;
3174: --

Line 3171: fnd_message.set_token('FIELD',p_rt_per_typ_flag);

3167: --
3168: -- raise error as does not exist as lookup
3169: --
3170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3171: fnd_message.set_token('FIELD',p_rt_per_typ_flag);
3172: fnd_message.set_token('TYPE','YES_NO');
3173: fnd_message.raise_error;
3174: --
3175: end if;

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

3168: -- raise error as does not exist as lookup
3169: --
3170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3171: fnd_message.set_token('FIELD',p_rt_per_typ_flag);
3172: fnd_message.set_token('TYPE','YES_NO');
3173: fnd_message.raise_error;
3174: --
3175: end if;
3176: --

Line 3173: fnd_message.raise_error;

3169: --
3170: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3171: fnd_message.set_token('FIELD',p_rt_per_typ_flag);
3172: fnd_message.set_token('TYPE','YES_NO');
3173: fnd_message.raise_error;
3174: --
3175: end if;
3176: --
3177: if hr_api.not_exists_in_hr_lookups

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

3180: p_effective_date => p_effective_date) then
3181: --
3182: -- raise error as does not exist as lookup
3183: --
3184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3185: fnd_message.set_token('FIELD',p_rt_fl_tm_pt_tm_flag);
3186: fnd_message.set_token('TYPE','YES_NO');
3187: fnd_message.raise_error;
3188: --

Line 3185: fnd_message.set_token('FIELD',p_rt_fl_tm_pt_tm_flag);

3181: --
3182: -- raise error as does not exist as lookup
3183: --
3184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3185: fnd_message.set_token('FIELD',p_rt_fl_tm_pt_tm_flag);
3186: fnd_message.set_token('TYPE','YES_NO');
3187: fnd_message.raise_error;
3188: --
3189: end if;

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

3182: -- raise error as does not exist as lookup
3183: --
3184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3185: fnd_message.set_token('FIELD',p_rt_fl_tm_pt_tm_flag);
3186: fnd_message.set_token('TYPE','YES_NO');
3187: fnd_message.raise_error;
3188: --
3189: end if;
3190: --

Line 3187: fnd_message.raise_error;

3183: --
3184: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3185: fnd_message.set_token('FIELD',p_rt_fl_tm_pt_tm_flag);
3186: fnd_message.set_token('TYPE','YES_NO');
3187: fnd_message.raise_error;
3188: --
3189: end if;
3190: --
3191: if hr_api.not_exists_in_hr_lookups

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

3194: p_effective_date => p_effective_date) then
3195: --
3196: -- raise error as does not exist as lookup
3197: --
3198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3199: fnd_message.set_token('FIELD',p_rt_ee_stat_flag);
3200: fnd_message.set_token('TYPE','YES_NO');
3201: fnd_message.raise_error;
3202: --

Line 3199: fnd_message.set_token('FIELD',p_rt_ee_stat_flag);

3195: --
3196: -- raise error as does not exist as lookup
3197: --
3198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3199: fnd_message.set_token('FIELD',p_rt_ee_stat_flag);
3200: fnd_message.set_token('TYPE','YES_NO');
3201: fnd_message.raise_error;
3202: --
3203: end if;

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

3196: -- raise error as does not exist as lookup
3197: --
3198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3199: fnd_message.set_token('FIELD',p_rt_ee_stat_flag);
3200: fnd_message.set_token('TYPE','YES_NO');
3201: fnd_message.raise_error;
3202: --
3203: end if;
3204: --

Line 3201: fnd_message.raise_error;

3197: --
3198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3199: fnd_message.set_token('FIELD',p_rt_ee_stat_flag);
3200: fnd_message.set_token('TYPE','YES_NO');
3201: fnd_message.raise_error;
3202: --
3203: end if;
3204: --
3205: if hr_api.not_exists_in_hr_lookups

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

3208: p_effective_date => p_effective_date) then
3209: --
3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD',p_rt_grd_flag);
3214: fnd_message.set_token('TYPE','YES_NO');
3215: fnd_message.raise_error;
3216: --

Line 3213: fnd_message.set_token('FIELD',p_rt_grd_flag);

3209: --
3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD',p_rt_grd_flag);
3214: fnd_message.set_token('TYPE','YES_NO');
3215: fnd_message.raise_error;
3216: --
3217: end if;

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

3210: -- raise error as does not exist as lookup
3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD',p_rt_grd_flag);
3214: fnd_message.set_token('TYPE','YES_NO');
3215: fnd_message.raise_error;
3216: --
3217: end if;
3218: --

Line 3215: fnd_message.raise_error;

3211: --
3212: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3213: fnd_message.set_token('FIELD',p_rt_grd_flag);
3214: fnd_message.set_token('TYPE','YES_NO');
3215: fnd_message.raise_error;
3216: --
3217: end if;
3218: --
3219: if hr_api.not_exists_in_hr_lookups

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

3222: p_effective_date => p_effective_date) then
3223: --
3224: -- raise error as does not exist as lookup
3225: --
3226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3227: fnd_message.set_token('FIELD',p_rt_pct_fl_tm_flag);
3228: fnd_message.set_token('TYPE','YES_NO');
3229: fnd_message.raise_error;
3230: --

Line 3227: fnd_message.set_token('FIELD',p_rt_pct_fl_tm_flag);

3223: --
3224: -- raise error as does not exist as lookup
3225: --
3226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3227: fnd_message.set_token('FIELD',p_rt_pct_fl_tm_flag);
3228: fnd_message.set_token('TYPE','YES_NO');
3229: fnd_message.raise_error;
3230: --
3231: end if;

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

3224: -- raise error as does not exist as lookup
3225: --
3226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3227: fnd_message.set_token('FIELD',p_rt_pct_fl_tm_flag);
3228: fnd_message.set_token('TYPE','YES_NO');
3229: fnd_message.raise_error;
3230: --
3231: end if;
3232: --

Line 3229: fnd_message.raise_error;

3225: --
3226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3227: fnd_message.set_token('FIELD',p_rt_pct_fl_tm_flag);
3228: fnd_message.set_token('TYPE','YES_NO');
3229: fnd_message.raise_error;
3230: --
3231: end if;
3232: --
3233: if hr_api.not_exists_in_hr_lookups

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

3236: p_effective_date => p_effective_date) then
3237: --
3238: -- raise error as does not exist as lookup
3239: --
3240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3241: fnd_message.set_token('FIELD',p_rt_asnt_set_flag);
3242: fnd_message.set_token('TYPE','YES_NO');
3243: fnd_message.raise_error;
3244: --

Line 3241: fnd_message.set_token('FIELD',p_rt_asnt_set_flag);

3237: --
3238: -- raise error as does not exist as lookup
3239: --
3240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3241: fnd_message.set_token('FIELD',p_rt_asnt_set_flag);
3242: fnd_message.set_token('TYPE','YES_NO');
3243: fnd_message.raise_error;
3244: --
3245: end if;

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

3238: -- raise error as does not exist as lookup
3239: --
3240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3241: fnd_message.set_token('FIELD',p_rt_asnt_set_flag);
3242: fnd_message.set_token('TYPE','YES_NO');
3243: fnd_message.raise_error;
3244: --
3245: end if;
3246: --

Line 3243: fnd_message.raise_error;

3239: --
3240: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3241: fnd_message.set_token('FIELD',p_rt_asnt_set_flag);
3242: fnd_message.set_token('TYPE','YES_NO');
3243: fnd_message.raise_error;
3244: --
3245: end if;
3246: --
3247: if hr_api.not_exists_in_hr_lookups

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

3250: p_effective_date => p_effective_date) then
3251: --
3252: -- raise error as does not exist as lookup
3253: --
3254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3255: fnd_message.set_token('FIELD',p_rt_hrs_wkd_flag);
3256: fnd_message.set_token('TYPE','YES_NO');
3257: fnd_message.raise_error;
3258: --

Line 3255: fnd_message.set_token('FIELD',p_rt_hrs_wkd_flag);

3251: --
3252: -- raise error as does not exist as lookup
3253: --
3254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3255: fnd_message.set_token('FIELD',p_rt_hrs_wkd_flag);
3256: fnd_message.set_token('TYPE','YES_NO');
3257: fnd_message.raise_error;
3258: --
3259: end if;

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

3252: -- raise error as does not exist as lookup
3253: --
3254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3255: fnd_message.set_token('FIELD',p_rt_hrs_wkd_flag);
3256: fnd_message.set_token('TYPE','YES_NO');
3257: fnd_message.raise_error;
3258: --
3259: end if;
3260: --

Line 3257: fnd_message.raise_error;

3253: --
3254: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3255: fnd_message.set_token('FIELD',p_rt_hrs_wkd_flag);
3256: fnd_message.set_token('TYPE','YES_NO');
3257: fnd_message.raise_error;
3258: --
3259: end if;
3260: --
3261: if hr_api.not_exists_in_hr_lookups

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

3264: p_effective_date => p_effective_date) then
3265: --
3266: -- raise error as does not exist as lookup
3267: --
3268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3269: fnd_message.set_token('FIELD',p_rt_comp_lvl_flag);
3270: fnd_message.set_token('TYPE','YES_NO');
3271: fnd_message.raise_error;
3272: --

Line 3269: fnd_message.set_token('FIELD',p_rt_comp_lvl_flag);

3265: --
3266: -- raise error as does not exist as lookup
3267: --
3268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3269: fnd_message.set_token('FIELD',p_rt_comp_lvl_flag);
3270: fnd_message.set_token('TYPE','YES_NO');
3271: fnd_message.raise_error;
3272: --
3273: end if;

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

3266: -- raise error as does not exist as lookup
3267: --
3268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3269: fnd_message.set_token('FIELD',p_rt_comp_lvl_flag);
3270: fnd_message.set_token('TYPE','YES_NO');
3271: fnd_message.raise_error;
3272: --
3273: end if;
3274: --

Line 3271: fnd_message.raise_error;

3267: --
3268: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3269: fnd_message.set_token('FIELD',p_rt_comp_lvl_flag);
3270: fnd_message.set_token('TYPE','YES_NO');
3271: fnd_message.raise_error;
3272: --
3273: end if;
3274: --
3275: if hr_api.not_exists_in_hr_lookups

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

3278: p_effective_date => p_effective_date) then
3279: --
3280: -- raise error as does not exist as lookup
3281: --
3282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3283: fnd_message.set_token('FIELD',p_rt_org_unit_flag);
3284: fnd_message.set_token('TYPE','YES_NO');
3285: fnd_message.raise_error;
3286: --

Line 3283: fnd_message.set_token('FIELD',p_rt_org_unit_flag);

3279: --
3280: -- raise error as does not exist as lookup
3281: --
3282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3283: fnd_message.set_token('FIELD',p_rt_org_unit_flag);
3284: fnd_message.set_token('TYPE','YES_NO');
3285: fnd_message.raise_error;
3286: --
3287: end if;

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

3280: -- raise error as does not exist as lookup
3281: --
3282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3283: fnd_message.set_token('FIELD',p_rt_org_unit_flag);
3284: fnd_message.set_token('TYPE','YES_NO');
3285: fnd_message.raise_error;
3286: --
3287: end if;
3288: --

Line 3285: fnd_message.raise_error;

3281: --
3282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3283: fnd_message.set_token('FIELD',p_rt_org_unit_flag);
3284: fnd_message.set_token('TYPE','YES_NO');
3285: fnd_message.raise_error;
3286: --
3287: end if;
3288: --
3289: if hr_api.not_exists_in_hr_lookups

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

3292: p_effective_date => p_effective_date) then
3293: --
3294: -- raise error as does not exist as lookup
3295: --
3296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3297: fnd_message.set_token('FIELD',p_rt_loa_rsn_flag);
3298: fnd_message.set_token('TYPE','YES_NO');
3299: fnd_message.raise_error;
3300: --

Line 3297: fnd_message.set_token('FIELD',p_rt_loa_rsn_flag);

3293: --
3294: -- raise error as does not exist as lookup
3295: --
3296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3297: fnd_message.set_token('FIELD',p_rt_loa_rsn_flag);
3298: fnd_message.set_token('TYPE','YES_NO');
3299: fnd_message.raise_error;
3300: --
3301: end if;

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

3294: -- raise error as does not exist as lookup
3295: --
3296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3297: fnd_message.set_token('FIELD',p_rt_loa_rsn_flag);
3298: fnd_message.set_token('TYPE','YES_NO');
3299: fnd_message.raise_error;
3300: --
3301: end if;
3302: --

Line 3299: fnd_message.raise_error;

3295: --
3296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3297: fnd_message.set_token('FIELD',p_rt_loa_rsn_flag);
3298: fnd_message.set_token('TYPE','YES_NO');
3299: fnd_message.raise_error;
3300: --
3301: end if;
3302: --
3303: if hr_api.not_exists_in_hr_lookups

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

3306: p_effective_date => p_effective_date) then
3307: --
3308: -- raise error as does not exist as lookup
3309: --
3310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3311: fnd_message.set_token('FIELD',p_rt_pyrl_flag);
3312: fnd_message.set_token('TYPE','YES_NO');
3313: fnd_message.raise_error;
3314: --

Line 3311: fnd_message.set_token('FIELD',p_rt_pyrl_flag);

3307: --
3308: -- raise error as does not exist as lookup
3309: --
3310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3311: fnd_message.set_token('FIELD',p_rt_pyrl_flag);
3312: fnd_message.set_token('TYPE','YES_NO');
3313: fnd_message.raise_error;
3314: --
3315: end if;

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

3308: -- raise error as does not exist as lookup
3309: --
3310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3311: fnd_message.set_token('FIELD',p_rt_pyrl_flag);
3312: fnd_message.set_token('TYPE','YES_NO');
3313: fnd_message.raise_error;
3314: --
3315: end if;
3316: --

Line 3313: fnd_message.raise_error;

3309: --
3310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3311: fnd_message.set_token('FIELD',p_rt_pyrl_flag);
3312: fnd_message.set_token('TYPE','YES_NO');
3313: fnd_message.raise_error;
3314: --
3315: end if;
3316: --
3317: if hr_api.not_exists_in_hr_lookups

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

3320: p_effective_date => p_effective_date) then
3321: --
3322: -- raise error as does not exist as lookup
3323: --
3324: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3325: fnd_message.set_token('FIELD',p_rt_schedd_hrs_flag);
3326: fnd_message.set_token('TYPE','YES_NO');
3327: fnd_message.raise_error;
3328: --

Line 3325: fnd_message.set_token('FIELD',p_rt_schedd_hrs_flag);

3321: --
3322: -- raise error as does not exist as lookup
3323: --
3324: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3325: fnd_message.set_token('FIELD',p_rt_schedd_hrs_flag);
3326: fnd_message.set_token('TYPE','YES_NO');
3327: fnd_message.raise_error;
3328: --
3329: end if;

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

3322: -- raise error as does not exist as lookup
3323: --
3324: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3325: fnd_message.set_token('FIELD',p_rt_schedd_hrs_flag);
3326: fnd_message.set_token('TYPE','YES_NO');
3327: fnd_message.raise_error;
3328: --
3329: end if;
3330: --

Line 3327: fnd_message.raise_error;

3323: --
3324: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3325: fnd_message.set_token('FIELD',p_rt_schedd_hrs_flag);
3326: fnd_message.set_token('TYPE','YES_NO');
3327: fnd_message.raise_error;
3328: --
3329: end if;
3330: --
3331: if hr_api.not_exists_in_hr_lookups

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

3334: p_effective_date => p_effective_date) then
3335: --
3336: -- raise error as does not exist as lookup
3337: --
3338: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3339: fnd_message.set_token('FIELD',p_rt_py_bss_flag);
3340: fnd_message.set_token('TYPE','YES_NO');
3341: fnd_message.raise_error;
3342: --

Line 3339: fnd_message.set_token('FIELD',p_rt_py_bss_flag);

3335: --
3336: -- raise error as does not exist as lookup
3337: --
3338: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3339: fnd_message.set_token('FIELD',p_rt_py_bss_flag);
3340: fnd_message.set_token('TYPE','YES_NO');
3341: fnd_message.raise_error;
3342: --
3343: end if;

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

3336: -- raise error as does not exist as lookup
3337: --
3338: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3339: fnd_message.set_token('FIELD',p_rt_py_bss_flag);
3340: fnd_message.set_token('TYPE','YES_NO');
3341: fnd_message.raise_error;
3342: --
3343: end if;
3344: --

Line 3341: fnd_message.raise_error;

3337: --
3338: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3339: fnd_message.set_token('FIELD',p_rt_py_bss_flag);
3340: fnd_message.set_token('TYPE','YES_NO');
3341: fnd_message.raise_error;
3342: --
3343: end if;
3344: --
3345: if hr_api.not_exists_in_hr_lookups

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

3348: p_effective_date => p_effective_date) then
3349: --
3350: -- raise error as does not exist as lookup
3351: --
3352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3353: fnd_message.set_token('FIELD',p_rt_prfl_rl_flag);
3354: fnd_message.set_token('TYPE','YES_NO');
3355: fnd_message.raise_error;
3356: --

Line 3353: fnd_message.set_token('FIELD',p_rt_prfl_rl_flag);

3349: --
3350: -- raise error as does not exist as lookup
3351: --
3352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3353: fnd_message.set_token('FIELD',p_rt_prfl_rl_flag);
3354: fnd_message.set_token('TYPE','YES_NO');
3355: fnd_message.raise_error;
3356: --
3357: end if;

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

3350: -- raise error as does not exist as lookup
3351: --
3352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3353: fnd_message.set_token('FIELD',p_rt_prfl_rl_flag);
3354: fnd_message.set_token('TYPE','YES_NO');
3355: fnd_message.raise_error;
3356: --
3357: end if;
3358: --

Line 3355: fnd_message.raise_error;

3351: --
3352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3353: fnd_message.set_token('FIELD',p_rt_prfl_rl_flag);
3354: fnd_message.set_token('TYPE','YES_NO');
3355: fnd_message.raise_error;
3356: --
3357: end if;
3358: --
3359: if hr_api.not_exists_in_hr_lookups

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

3362: p_effective_date => p_effective_date) then
3363: --
3364: -- raise error as does not exist as lookup
3365: --
3366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3367: fnd_message.set_token('FIELD',p_rt_cmbn_age_los_flag);
3368: fnd_message.set_token('TYPE','YES_NO');
3369: fnd_message.raise_error;
3370: --

Line 3367: fnd_message.set_token('FIELD',p_rt_cmbn_age_los_flag);

3363: --
3364: -- raise error as does not exist as lookup
3365: --
3366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3367: fnd_message.set_token('FIELD',p_rt_cmbn_age_los_flag);
3368: fnd_message.set_token('TYPE','YES_NO');
3369: fnd_message.raise_error;
3370: --
3371: end if;

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

3364: -- raise error as does not exist as lookup
3365: --
3366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3367: fnd_message.set_token('FIELD',p_rt_cmbn_age_los_flag);
3368: fnd_message.set_token('TYPE','YES_NO');
3369: fnd_message.raise_error;
3370: --
3371: end if;
3372: --

Line 3369: fnd_message.raise_error;

3365: --
3366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3367: fnd_message.set_token('FIELD',p_rt_cmbn_age_los_flag);
3368: fnd_message.set_token('TYPE','YES_NO');
3369: fnd_message.raise_error;
3370: --
3371: end if;
3372: --
3373: if hr_api.not_exists_in_hr_lookups

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

3376: p_effective_date => p_effective_date) then
3377: --
3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD',p_rt_prtt_pl_flag);
3382: fnd_message.set_token('TYPE','YES_NO');
3383: fnd_message.raise_error;
3384: --

Line 3381: fnd_message.set_token('FIELD',p_rt_prtt_pl_flag);

3377: --
3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD',p_rt_prtt_pl_flag);
3382: fnd_message.set_token('TYPE','YES_NO');
3383: fnd_message.raise_error;
3384: --
3385: end if;

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

3378: -- raise error as does not exist as lookup
3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD',p_rt_prtt_pl_flag);
3382: fnd_message.set_token('TYPE','YES_NO');
3383: fnd_message.raise_error;
3384: --
3385: end if;
3386: --

Line 3383: fnd_message.raise_error;

3379: --
3380: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3381: fnd_message.set_token('FIELD',p_rt_prtt_pl_flag);
3382: fnd_message.set_token('TYPE','YES_NO');
3383: fnd_message.raise_error;
3384: --
3385: end if;
3386: --
3387: if hr_api.not_exists_in_hr_lookups

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

3390: p_effective_date => p_effective_date) then
3391: --
3392: -- raise error as does not exist as lookup
3393: --
3394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3395: fnd_message.set_token('FIELD',p_rt_svc_area_flag);
3396: fnd_message.set_token('TYPE','YES_NO');
3397: fnd_message.raise_error;
3398: --

Line 3395: fnd_message.set_token('FIELD',p_rt_svc_area_flag);

3391: --
3392: -- raise error as does not exist as lookup
3393: --
3394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3395: fnd_message.set_token('FIELD',p_rt_svc_area_flag);
3396: fnd_message.set_token('TYPE','YES_NO');
3397: fnd_message.raise_error;
3398: --
3399: end if;

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

3392: -- raise error as does not exist as lookup
3393: --
3394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3395: fnd_message.set_token('FIELD',p_rt_svc_area_flag);
3396: fnd_message.set_token('TYPE','YES_NO');
3397: fnd_message.raise_error;
3398: --
3399: end if;
3400: --

Line 3397: fnd_message.raise_error;

3393: --
3394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3395: fnd_message.set_token('FIELD',p_rt_svc_area_flag);
3396: fnd_message.set_token('TYPE','YES_NO');
3397: fnd_message.raise_error;
3398: --
3399: end if;
3400: --
3401: if hr_api.not_exists_in_hr_lookups

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

3404: p_effective_date => p_effective_date) then
3405: --
3406: -- raise error as does not exist as lookup
3407: --
3408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3409: fnd_message.set_token('FIELD',p_rt_ppl_grp_flag);
3410: fnd_message.set_token('TYPE','YES_NO');
3411: fnd_message.raise_error;
3412: --

Line 3409: fnd_message.set_token('FIELD',p_rt_ppl_grp_flag);

3405: --
3406: -- raise error as does not exist as lookup
3407: --
3408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3409: fnd_message.set_token('FIELD',p_rt_ppl_grp_flag);
3410: fnd_message.set_token('TYPE','YES_NO');
3411: fnd_message.raise_error;
3412: --
3413: end if;

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

3406: -- raise error as does not exist as lookup
3407: --
3408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3409: fnd_message.set_token('FIELD',p_rt_ppl_grp_flag);
3410: fnd_message.set_token('TYPE','YES_NO');
3411: fnd_message.raise_error;
3412: --
3413: end if;
3414: --

Line 3411: fnd_message.raise_error;

3407: --
3408: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3409: fnd_message.set_token('FIELD',p_rt_ppl_grp_flag);
3410: fnd_message.set_token('TYPE','YES_NO');
3411: fnd_message.raise_error;
3412: --
3413: end if;
3414: --
3415: if hr_api.not_exists_in_hr_lookups

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

3418: p_effective_date => p_effective_date) then
3419: --
3420: -- raise error as does not exist as lookup
3421: --
3422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3423: fnd_message.set_token('FIELD',p_rt_dsbld_flag);
3424: fnd_message.set_token('TYPE','YES_NO');
3425: fnd_message.raise_error;
3426: --

Line 3423: fnd_message.set_token('FIELD',p_rt_dsbld_flag);

3419: --
3420: -- raise error as does not exist as lookup
3421: --
3422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3423: fnd_message.set_token('FIELD',p_rt_dsbld_flag);
3424: fnd_message.set_token('TYPE','YES_NO');
3425: fnd_message.raise_error;
3426: --
3427: end if;

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

3420: -- raise error as does not exist as lookup
3421: --
3422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3423: fnd_message.set_token('FIELD',p_rt_dsbld_flag);
3424: fnd_message.set_token('TYPE','YES_NO');
3425: fnd_message.raise_error;
3426: --
3427: end if;
3428: --

Line 3425: fnd_message.raise_error;

3421: --
3422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3423: fnd_message.set_token('FIELD',p_rt_dsbld_flag);
3424: fnd_message.set_token('TYPE','YES_NO');
3425: fnd_message.raise_error;
3426: --
3427: end if;
3428: --
3429: if hr_api.not_exists_in_hr_lookups

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

3432: p_effective_date => p_effective_date) then
3433: --
3434: -- raise error as does not exist as lookup
3435: --
3436: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3437: fnd_message.set_token('FIELD',p_rt_hlth_cvg_flag);
3438: fnd_message.set_token('TYPE','YES_NO');
3439: fnd_message.raise_error;
3440: --

Line 3437: fnd_message.set_token('FIELD',p_rt_hlth_cvg_flag);

3433: --
3434: -- raise error as does not exist as lookup
3435: --
3436: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3437: fnd_message.set_token('FIELD',p_rt_hlth_cvg_flag);
3438: fnd_message.set_token('TYPE','YES_NO');
3439: fnd_message.raise_error;
3440: --
3441: end if;

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

3434: -- raise error as does not exist as lookup
3435: --
3436: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3437: fnd_message.set_token('FIELD',p_rt_hlth_cvg_flag);
3438: fnd_message.set_token('TYPE','YES_NO');
3439: fnd_message.raise_error;
3440: --
3441: end if;
3442: --

Line 3439: fnd_message.raise_error;

3435: --
3436: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3437: fnd_message.set_token('FIELD',p_rt_hlth_cvg_flag);
3438: fnd_message.set_token('TYPE','YES_NO');
3439: fnd_message.raise_error;
3440: --
3441: end if;
3442: --
3443: if hr_api.not_exists_in_hr_lookups

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

3446: p_effective_date => p_effective_date) then
3447: --
3448: -- raise error as does not exist as lookup
3449: --
3450: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3451: fnd_message.set_token('FIELD',p_rt_poe_flag);
3452: fnd_message.set_token('TYPE','YES_NO');
3453: fnd_message.raise_error;
3454: --

Line 3451: fnd_message.set_token('FIELD',p_rt_poe_flag);

3447: --
3448: -- raise error as does not exist as lookup
3449: --
3450: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3451: fnd_message.set_token('FIELD',p_rt_poe_flag);
3452: fnd_message.set_token('TYPE','YES_NO');
3453: fnd_message.raise_error;
3454: --
3455: end if;

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

3448: -- raise error as does not exist as lookup
3449: --
3450: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3451: fnd_message.set_token('FIELD',p_rt_poe_flag);
3452: fnd_message.set_token('TYPE','YES_NO');
3453: fnd_message.raise_error;
3454: --
3455: end if;
3456: --

Line 3453: fnd_message.raise_error;

3449: --
3450: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3451: fnd_message.set_token('FIELD',p_rt_poe_flag);
3452: fnd_message.set_token('TYPE','YES_NO');
3453: fnd_message.raise_error;
3454: --
3455: end if;
3456: --
3457: if hr_api.not_exists_in_hr_lookups

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

3460: p_effective_date => p_effective_date) then
3461: --
3462: -- raise error as does not exist as lookup
3463: --
3464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3465: fnd_message.set_token('FIELD',p_rt_ttl_cvg_vol_flag);
3466: fnd_message.set_token('TYPE','YES_NO');
3467: fnd_message.raise_error;
3468: --

Line 3465: fnd_message.set_token('FIELD',p_rt_ttl_cvg_vol_flag);

3461: --
3462: -- raise error as does not exist as lookup
3463: --
3464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3465: fnd_message.set_token('FIELD',p_rt_ttl_cvg_vol_flag);
3466: fnd_message.set_token('TYPE','YES_NO');
3467: fnd_message.raise_error;
3468: --
3469: end if;

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

3462: -- raise error as does not exist as lookup
3463: --
3464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3465: fnd_message.set_token('FIELD',p_rt_ttl_cvg_vol_flag);
3466: fnd_message.set_token('TYPE','YES_NO');
3467: fnd_message.raise_error;
3468: --
3469: end if;
3470: --

Line 3467: fnd_message.raise_error;

3463: --
3464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3465: fnd_message.set_token('FIELD',p_rt_ttl_cvg_vol_flag);
3466: fnd_message.set_token('TYPE','YES_NO');
3467: fnd_message.raise_error;
3468: --
3469: end if;
3470: --
3471: if hr_api.not_exists_in_hr_lookups

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

3474: p_effective_date => p_effective_date) then
3475: --
3476: -- raise error as does not exist as lookup
3477: --
3478: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3479: fnd_message.set_token('FIELD',p_rt_ttl_prtt_flag);
3480: fnd_message.set_token('TYPE','YES_NO');
3481: fnd_message.raise_error;
3482: --

Line 3479: fnd_message.set_token('FIELD',p_rt_ttl_prtt_flag);

3475: --
3476: -- raise error as does not exist as lookup
3477: --
3478: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3479: fnd_message.set_token('FIELD',p_rt_ttl_prtt_flag);
3480: fnd_message.set_token('TYPE','YES_NO');
3481: fnd_message.raise_error;
3482: --
3483: end if;

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

3476: -- raise error as does not exist as lookup
3477: --
3478: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3479: fnd_message.set_token('FIELD',p_rt_ttl_prtt_flag);
3480: fnd_message.set_token('TYPE','YES_NO');
3481: fnd_message.raise_error;
3482: --
3483: end if;
3484: --

Line 3481: fnd_message.raise_error;

3477: --
3478: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3479: fnd_message.set_token('FIELD',p_rt_ttl_prtt_flag);
3480: fnd_message.set_token('TYPE','YES_NO');
3481: fnd_message.raise_error;
3482: --
3483: end if;
3484: --
3485: if hr_api.not_exists_in_hr_lookups

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

3488: p_effective_date => p_effective_date) then
3489: --
3490: -- raise error as does not exist as lookup
3491: --
3492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3493: fnd_message.set_token('FIELD',p_rt_gndr_flag);
3494: fnd_message.set_token('TYPE','YES_NO');
3495: fnd_message.raise_error;
3496: --

Line 3493: fnd_message.set_token('FIELD',p_rt_gndr_flag);

3489: --
3490: -- raise error as does not exist as lookup
3491: --
3492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3493: fnd_message.set_token('FIELD',p_rt_gndr_flag);
3494: fnd_message.set_token('TYPE','YES_NO');
3495: fnd_message.raise_error;
3496: --
3497: end if;

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

3490: -- raise error as does not exist as lookup
3491: --
3492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3493: fnd_message.set_token('FIELD',p_rt_gndr_flag);
3494: fnd_message.set_token('TYPE','YES_NO');
3495: fnd_message.raise_error;
3496: --
3497: end if;
3498: --

Line 3495: fnd_message.raise_error;

3491: --
3492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3493: fnd_message.set_token('FIELD',p_rt_gndr_flag);
3494: fnd_message.set_token('TYPE','YES_NO');
3495: fnd_message.raise_error;
3496: --
3497: end if;
3498: --
3499: if hr_api.not_exists_in_hr_lookups

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

3502: p_effective_date => p_effective_date) then
3503: --
3504: -- raise error as does not exist as lookup
3505: --
3506: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3507: fnd_message.set_token('FIELD',p_rt_tbco_use_flag);
3508: fnd_message.set_token('TYPE','YES_NO');
3509: fnd_message.raise_error;
3510: --

Line 3507: fnd_message.set_token('FIELD',p_rt_tbco_use_flag);

3503: --
3504: -- raise error as does not exist as lookup
3505: --
3506: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3507: fnd_message.set_token('FIELD',p_rt_tbco_use_flag);
3508: fnd_message.set_token('TYPE','YES_NO');
3509: fnd_message.raise_error;
3510: --
3511: end if;

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

3504: -- raise error as does not exist as lookup
3505: --
3506: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3507: fnd_message.set_token('FIELD',p_rt_tbco_use_flag);
3508: fnd_message.set_token('TYPE','YES_NO');
3509: fnd_message.raise_error;
3510: --
3511: end if;
3512:

Line 3509: fnd_message.raise_error;

3505: --
3506: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3507: fnd_message.set_token('FIELD',p_rt_tbco_use_flag);
3508: fnd_message.set_token('TYPE','YES_NO');
3509: fnd_message.raise_error;
3510: --
3511: end if;
3512:
3513:

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

3517: p_effective_date => p_effective_date) then
3518: --
3519: -- raise error as does not exist as lookup
3520: --
3521: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3522: fnd_message.set_token('FIELD',p_rt_cntng_prtn_prfl_flag);
3523: fnd_message.set_token('TYPE','YES_NO');
3524: fnd_message.raise_error;
3525: --

Line 3522: fnd_message.set_token('FIELD',p_rt_cntng_prtn_prfl_flag);

3518: --
3519: -- raise error as does not exist as lookup
3520: --
3521: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3522: fnd_message.set_token('FIELD',p_rt_cntng_prtn_prfl_flag);
3523: fnd_message.set_token('TYPE','YES_NO');
3524: fnd_message.raise_error;
3525: --
3526: end if;

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

3519: -- raise error as does not exist as lookup
3520: --
3521: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3522: fnd_message.set_token('FIELD',p_rt_cntng_prtn_prfl_flag);
3523: fnd_message.set_token('TYPE','YES_NO');
3524: fnd_message.raise_error;
3525: --
3526: end if;
3527:

Line 3524: fnd_message.raise_error;

3520: --
3521: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3522: fnd_message.set_token('FIELD',p_rt_cntng_prtn_prfl_flag);
3523: fnd_message.set_token('TYPE','YES_NO');
3524: fnd_message.raise_error;
3525: --
3526: end if;
3527:
3528: if hr_api.not_exists_in_hr_lookups

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

3531: p_effective_date => p_effective_date) then
3532: --
3533: -- raise error as does not exist as lookup
3534: --
3535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3536: fnd_message.set_token('FIELD',p_rt_cbr_quald_bnf_flag);
3537: fnd_message.set_token('TYPE','YES_NO');
3538: fnd_message.raise_error;
3539: --

Line 3536: fnd_message.set_token('FIELD',p_rt_cbr_quald_bnf_flag);

3532: --
3533: -- raise error as does not exist as lookup
3534: --
3535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3536: fnd_message.set_token('FIELD',p_rt_cbr_quald_bnf_flag);
3537: fnd_message.set_token('TYPE','YES_NO');
3538: fnd_message.raise_error;
3539: --
3540: end if;

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

3533: -- raise error as does not exist as lookup
3534: --
3535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3536: fnd_message.set_token('FIELD',p_rt_cbr_quald_bnf_flag);
3537: fnd_message.set_token('TYPE','YES_NO');
3538: fnd_message.raise_error;
3539: --
3540: end if;
3541:

Line 3538: fnd_message.raise_error;

3534: --
3535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3536: fnd_message.set_token('FIELD',p_rt_cbr_quald_bnf_flag);
3537: fnd_message.set_token('TYPE','YES_NO');
3538: fnd_message.raise_error;
3539: --
3540: end if;
3541:
3542: if hr_api.not_exists_in_hr_lookups

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

3545: p_effective_date => p_effective_date) then
3546: --
3547: -- raise error as does not exist as lookup
3548: --
3549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3550: fnd_message.set_token('FIELD',p_rt_optd_mdcr_flag);
3551: fnd_message.set_token('TYPE','YES_NO');
3552: fnd_message.raise_error;
3553: --

Line 3550: fnd_message.set_token('FIELD',p_rt_optd_mdcr_flag);

3546: --
3547: -- raise error as does not exist as lookup
3548: --
3549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3550: fnd_message.set_token('FIELD',p_rt_optd_mdcr_flag);
3551: fnd_message.set_token('TYPE','YES_NO');
3552: fnd_message.raise_error;
3553: --
3554: end if;

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

3547: -- raise error as does not exist as lookup
3548: --
3549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3550: fnd_message.set_token('FIELD',p_rt_optd_mdcr_flag);
3551: fnd_message.set_token('TYPE','YES_NO');
3552: fnd_message.raise_error;
3553: --
3554: end if;
3555:

Line 3552: fnd_message.raise_error;

3548: --
3549: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3550: fnd_message.set_token('FIELD',p_rt_optd_mdcr_flag);
3551: fnd_message.set_token('TYPE','YES_NO');
3552: fnd_message.raise_error;
3553: --
3554: end if;
3555:
3556: if hr_api.not_exists_in_hr_lookups

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

3559: p_effective_date => p_effective_date) then
3560: --
3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD',p_rt_lvg_rsn_flag);
3565: fnd_message.set_token('TYPE','YES_NO');
3566: fnd_message.raise_error;
3567: --

Line 3564: fnd_message.set_token('FIELD',p_rt_lvg_rsn_flag);

3560: --
3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD',p_rt_lvg_rsn_flag);
3565: fnd_message.set_token('TYPE','YES_NO');
3566: fnd_message.raise_error;
3567: --
3568: end if;

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

3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD',p_rt_lvg_rsn_flag);
3565: fnd_message.set_token('TYPE','YES_NO');
3566: fnd_message.raise_error;
3567: --
3568: end if;
3569:

Line 3566: fnd_message.raise_error;

3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD',p_rt_lvg_rsn_flag);
3565: fnd_message.set_token('TYPE','YES_NO');
3566: fnd_message.raise_error;
3567: --
3568: end if;
3569:
3570: if hr_api.not_exists_in_hr_lookups

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

3573: p_effective_date => p_effective_date) then
3574: --
3575: -- raise error as does not exist as lookup
3576: --
3577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3578: fnd_message.set_token('FIELD',p_rt_pstn_flag);
3579: fnd_message.set_token('TYPE','YES_NO');
3580: fnd_message.raise_error;
3581: --

Line 3578: fnd_message.set_token('FIELD',p_rt_pstn_flag);

3574: --
3575: -- raise error as does not exist as lookup
3576: --
3577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3578: fnd_message.set_token('FIELD',p_rt_pstn_flag);
3579: fnd_message.set_token('TYPE','YES_NO');
3580: fnd_message.raise_error;
3581: --
3582: end if;

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

3575: -- raise error as does not exist as lookup
3576: --
3577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3578: fnd_message.set_token('FIELD',p_rt_pstn_flag);
3579: fnd_message.set_token('TYPE','YES_NO');
3580: fnd_message.raise_error;
3581: --
3582: end if;
3583:

Line 3580: fnd_message.raise_error;

3576: --
3577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3578: fnd_message.set_token('FIELD',p_rt_pstn_flag);
3579: fnd_message.set_token('TYPE','YES_NO');
3580: fnd_message.raise_error;
3581: --
3582: end if;
3583:
3584: if hr_api.not_exists_in_hr_lookups

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

3587: p_effective_date => p_effective_date) then
3588: --
3589: -- raise error as does not exist as lookup
3590: --
3591: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3592: fnd_message.set_token('FIELD',p_rt_comptncy_flag);
3593: fnd_message.set_token('TYPE','YES_NO');
3594: fnd_message.raise_error;
3595: --

Line 3592: fnd_message.set_token('FIELD',p_rt_comptncy_flag);

3588: --
3589: -- raise error as does not exist as lookup
3590: --
3591: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3592: fnd_message.set_token('FIELD',p_rt_comptncy_flag);
3593: fnd_message.set_token('TYPE','YES_NO');
3594: fnd_message.raise_error;
3595: --
3596: end if;

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

3589: -- raise error as does not exist as lookup
3590: --
3591: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3592: fnd_message.set_token('FIELD',p_rt_comptncy_flag);
3593: fnd_message.set_token('TYPE','YES_NO');
3594: fnd_message.raise_error;
3595: --
3596: end if;
3597:

Line 3594: fnd_message.raise_error;

3590: --
3591: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3592: fnd_message.set_token('FIELD',p_rt_comptncy_flag);
3593: fnd_message.set_token('TYPE','YES_NO');
3594: fnd_message.raise_error;
3595: --
3596: end if;
3597:
3598: if hr_api.not_exists_in_hr_lookups

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

3601: p_effective_date => p_effective_date) then
3602: --
3603: -- raise error as does not exist as lookup
3604: --
3605: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3606: fnd_message.set_token('FIELD',p_rt_job_flag);
3607: fnd_message.set_token('TYPE','YES_NO');
3608: fnd_message.raise_error;
3609: --

Line 3606: fnd_message.set_token('FIELD',p_rt_job_flag);

3602: --
3603: -- raise error as does not exist as lookup
3604: --
3605: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3606: fnd_message.set_token('FIELD',p_rt_job_flag);
3607: fnd_message.set_token('TYPE','YES_NO');
3608: fnd_message.raise_error;
3609: --
3610: end if;

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

3603: -- raise error as does not exist as lookup
3604: --
3605: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3606: fnd_message.set_token('FIELD',p_rt_job_flag);
3607: fnd_message.set_token('TYPE','YES_NO');
3608: fnd_message.raise_error;
3609: --
3610: end if;
3611:

Line 3608: fnd_message.raise_error;

3604: --
3605: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3606: fnd_message.set_token('FIELD',p_rt_job_flag);
3607: fnd_message.set_token('TYPE','YES_NO');
3608: fnd_message.raise_error;
3609: --
3610: end if;
3611:
3612: if hr_api.not_exists_in_hr_lookups

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

3615: p_effective_date => p_effective_date) then
3616: --
3617: -- raise error as does not exist as lookup
3618: --
3619: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3620: fnd_message.set_token('FIELD',p_rt_qual_titl_flag);
3621: fnd_message.set_token('TYPE','YES_NO');
3622: fnd_message.raise_error;
3623: --

Line 3620: fnd_message.set_token('FIELD',p_rt_qual_titl_flag);

3616: --
3617: -- raise error as does not exist as lookup
3618: --
3619: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3620: fnd_message.set_token('FIELD',p_rt_qual_titl_flag);
3621: fnd_message.set_token('TYPE','YES_NO');
3622: fnd_message.raise_error;
3623: --
3624: end if;

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

3617: -- raise error as does not exist as lookup
3618: --
3619: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3620: fnd_message.set_token('FIELD',p_rt_qual_titl_flag);
3621: fnd_message.set_token('TYPE','YES_NO');
3622: fnd_message.raise_error;
3623: --
3624: end if;
3625:

Line 3622: fnd_message.raise_error;

3618: --
3619: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3620: fnd_message.set_token('FIELD',p_rt_qual_titl_flag);
3621: fnd_message.set_token('TYPE','YES_NO');
3622: fnd_message.raise_error;
3623: --
3624: end if;
3625:
3626: if hr_api.not_exists_in_hr_lookups

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

3629: p_effective_date => p_effective_date) then
3630: --
3631: -- raise error as does not exist as lookup
3632: --
3633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3634: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pl_flag);
3635: fnd_message.set_token('TYPE','YES_NO');
3636: fnd_message.raise_error;
3637: --

Line 3634: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pl_flag);

3630: --
3631: -- raise error as does not exist as lookup
3632: --
3633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3634: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pl_flag);
3635: fnd_message.set_token('TYPE','YES_NO');
3636: fnd_message.raise_error;
3637: --
3638: end if;

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

3631: -- raise error as does not exist as lookup
3632: --
3633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3634: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pl_flag);
3635: fnd_message.set_token('TYPE','YES_NO');
3636: fnd_message.raise_error;
3637: --
3638: end if;
3639:

Line 3636: fnd_message.raise_error;

3632: --
3633: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3634: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pl_flag);
3635: fnd_message.set_token('TYPE','YES_NO');
3636: fnd_message.raise_error;
3637: --
3638: end if;
3639:
3640: if hr_api.not_exists_in_hr_lookups

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

3643: p_effective_date => p_effective_date) then
3644: --
3645: -- raise error as does not exist as lookup
3646: --
3647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3648: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_plip_flag);
3649: fnd_message.set_token('TYPE','YES_NO');
3650: fnd_message.raise_error;
3651: --

Line 3648: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_plip_flag);

3644: --
3645: -- raise error as does not exist as lookup
3646: --
3647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3648: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_plip_flag);
3649: fnd_message.set_token('TYPE','YES_NO');
3650: fnd_message.raise_error;
3651: --
3652: end if;

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

3645: -- raise error as does not exist as lookup
3646: --
3647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3648: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_plip_flag);
3649: fnd_message.set_token('TYPE','YES_NO');
3650: fnd_message.raise_error;
3651: --
3652: end if;
3653:

Line 3650: fnd_message.raise_error;

3646: --
3647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3648: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_plip_flag);
3649: fnd_message.set_token('TYPE','YES_NO');
3650: fnd_message.raise_error;
3651: --
3652: end if;
3653:
3654: if hr_api.not_exists_in_hr_lookups

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

3657: p_effective_date => p_effective_date) then
3658: --
3659: -- raise error as does not exist as lookup
3660: --
3661: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3662: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_ptip_flag);
3663: fnd_message.set_token('TYPE','YES_NO');
3664: fnd_message.raise_error;
3665: --

Line 3662: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_ptip_flag);

3658: --
3659: -- raise error as does not exist as lookup
3660: --
3661: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3662: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_ptip_flag);
3663: fnd_message.set_token('TYPE','YES_NO');
3664: fnd_message.raise_error;
3665: --
3666: end if;

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

3659: -- raise error as does not exist as lookup
3660: --
3661: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3662: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_ptip_flag);
3663: fnd_message.set_token('TYPE','YES_NO');
3664: fnd_message.raise_error;
3665: --
3666: end if;
3667:

Line 3664: fnd_message.raise_error;

3660: --
3661: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3662: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_ptip_flag);
3663: fnd_message.set_token('TYPE','YES_NO');
3664: fnd_message.raise_error;
3665: --
3666: end if;
3667:
3668: if hr_api.not_exists_in_hr_lookups

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

3671: p_effective_date => p_effective_date) then
3672: --
3673: -- raise error as does not exist as lookup
3674: --
3675: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3676: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pgm_flag);
3677: fnd_message.set_token('TYPE','YES_NO');
3678: fnd_message.raise_error;
3679: --

Line 3676: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pgm_flag);

3672: --
3673: -- raise error as does not exist as lookup
3674: --
3675: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3676: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pgm_flag);
3677: fnd_message.set_token('TYPE','YES_NO');
3678: fnd_message.raise_error;
3679: --
3680: end if;

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

3673: -- raise error as does not exist as lookup
3674: --
3675: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3676: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pgm_flag);
3677: fnd_message.set_token('TYPE','YES_NO');
3678: fnd_message.raise_error;
3679: --
3680: end if;
3681:

Line 3678: fnd_message.raise_error;

3674: --
3675: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3676: fnd_message.set_token('FIELD',p_rt_dpnt_cvrd_pgm_flag);
3677: fnd_message.set_token('TYPE','YES_NO');
3678: fnd_message.raise_error;
3679: --
3680: end if;
3681:
3682: if hr_api.not_exists_in_hr_lookups

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

3685: p_effective_date => p_effective_date) then
3686: --
3687: -- raise error as does not exist as lookup
3688: --
3689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3690: fnd_message.set_token('FIELD',p_rt_enrld_oipl_flag);
3691: fnd_message.set_token('TYPE','YES_NO');
3692: fnd_message.raise_error;
3693: --

Line 3690: fnd_message.set_token('FIELD',p_rt_enrld_oipl_flag);

3686: --
3687: -- raise error as does not exist as lookup
3688: --
3689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3690: fnd_message.set_token('FIELD',p_rt_enrld_oipl_flag);
3691: fnd_message.set_token('TYPE','YES_NO');
3692: fnd_message.raise_error;
3693: --
3694: end if;

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

3687: -- raise error as does not exist as lookup
3688: --
3689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3690: fnd_message.set_token('FIELD',p_rt_enrld_oipl_flag);
3691: fnd_message.set_token('TYPE','YES_NO');
3692: fnd_message.raise_error;
3693: --
3694: end if;
3695:

Line 3692: fnd_message.raise_error;

3688: --
3689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3690: fnd_message.set_token('FIELD',p_rt_enrld_oipl_flag);
3691: fnd_message.set_token('TYPE','YES_NO');
3692: fnd_message.raise_error;
3693: --
3694: end if;
3695:
3696: if hr_api.not_exists_in_hr_lookups

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

3699: p_effective_date => p_effective_date) then
3700: --
3701: -- raise error as does not exist as lookup
3702: --
3703: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3704: fnd_message.set_token('FIELD',p_rt_enrld_pl_flag);
3705: fnd_message.set_token('TYPE','YES_NO');
3706: fnd_message.raise_error;
3707: --

Line 3704: fnd_message.set_token('FIELD',p_rt_enrld_pl_flag);

3700: --
3701: -- raise error as does not exist as lookup
3702: --
3703: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3704: fnd_message.set_token('FIELD',p_rt_enrld_pl_flag);
3705: fnd_message.set_token('TYPE','YES_NO');
3706: fnd_message.raise_error;
3707: --
3708: end if;

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

3701: -- raise error as does not exist as lookup
3702: --
3703: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3704: fnd_message.set_token('FIELD',p_rt_enrld_pl_flag);
3705: fnd_message.set_token('TYPE','YES_NO');
3706: fnd_message.raise_error;
3707: --
3708: end if;
3709:

Line 3706: fnd_message.raise_error;

3702: --
3703: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3704: fnd_message.set_token('FIELD',p_rt_enrld_pl_flag);
3705: fnd_message.set_token('TYPE','YES_NO');
3706: fnd_message.raise_error;
3707: --
3708: end if;
3709:
3710: if hr_api.not_exists_in_hr_lookups

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

3713: p_effective_date => p_effective_date) then
3714: --
3715: -- raise error as does not exist as lookup
3716: --
3717: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3718: fnd_message.set_token('FIELD',p_rt_enrld_plip_flag);
3719: fnd_message.set_token('TYPE','YES_NO');
3720: fnd_message.raise_error;
3721: --

Line 3718: fnd_message.set_token('FIELD',p_rt_enrld_plip_flag);

3714: --
3715: -- raise error as does not exist as lookup
3716: --
3717: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3718: fnd_message.set_token('FIELD',p_rt_enrld_plip_flag);
3719: fnd_message.set_token('TYPE','YES_NO');
3720: fnd_message.raise_error;
3721: --
3722: end if;

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

3715: -- raise error as does not exist as lookup
3716: --
3717: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3718: fnd_message.set_token('FIELD',p_rt_enrld_plip_flag);
3719: fnd_message.set_token('TYPE','YES_NO');
3720: fnd_message.raise_error;
3721: --
3722: end if;
3723:

Line 3720: fnd_message.raise_error;

3716: --
3717: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3718: fnd_message.set_token('FIELD',p_rt_enrld_plip_flag);
3719: fnd_message.set_token('TYPE','YES_NO');
3720: fnd_message.raise_error;
3721: --
3722: end if;
3723:
3724: if hr_api.not_exists_in_hr_lookups

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

3727: p_effective_date => p_effective_date) then
3728: --
3729: -- raise error as does not exist as lookup
3730: --
3731: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3732: fnd_message.set_token('FIELD',p_rt_enrld_ptip_flag);
3733: fnd_message.set_token('TYPE','YES_NO');
3734: fnd_message.raise_error;
3735: --

Line 3732: fnd_message.set_token('FIELD',p_rt_enrld_ptip_flag);

3728: --
3729: -- raise error as does not exist as lookup
3730: --
3731: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3732: fnd_message.set_token('FIELD',p_rt_enrld_ptip_flag);
3733: fnd_message.set_token('TYPE','YES_NO');
3734: fnd_message.raise_error;
3735: --
3736: end if;

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

3729: -- raise error as does not exist as lookup
3730: --
3731: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3732: fnd_message.set_token('FIELD',p_rt_enrld_ptip_flag);
3733: fnd_message.set_token('TYPE','YES_NO');
3734: fnd_message.raise_error;
3735: --
3736: end if;
3737:

Line 3734: fnd_message.raise_error;

3730: --
3731: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3732: fnd_message.set_token('FIELD',p_rt_enrld_ptip_flag);
3733: fnd_message.set_token('TYPE','YES_NO');
3734: fnd_message.raise_error;
3735: --
3736: end if;
3737:
3738: if hr_api.not_exists_in_hr_lookups

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

3741: p_effective_date => p_effective_date) then
3742: --
3743: -- raise error as does not exist as lookup
3744: --
3745: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3746: fnd_message.set_token('FIELD',p_rt_enrld_pgm_flag);
3747: fnd_message.set_token('TYPE','YES_NO');
3748: fnd_message.raise_error;
3749: --

Line 3746: fnd_message.set_token('FIELD',p_rt_enrld_pgm_flag);

3742: --
3743: -- raise error as does not exist as lookup
3744: --
3745: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3746: fnd_message.set_token('FIELD',p_rt_enrld_pgm_flag);
3747: fnd_message.set_token('TYPE','YES_NO');
3748: fnd_message.raise_error;
3749: --
3750: end if;

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

3743: -- raise error as does not exist as lookup
3744: --
3745: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3746: fnd_message.set_token('FIELD',p_rt_enrld_pgm_flag);
3747: fnd_message.set_token('TYPE','YES_NO');
3748: fnd_message.raise_error;
3749: --
3750: end if;
3751:

Line 3748: fnd_message.raise_error;

3744: --
3745: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3746: fnd_message.set_token('FIELD',p_rt_enrld_pgm_flag);
3747: fnd_message.set_token('TYPE','YES_NO');
3748: fnd_message.raise_error;
3749: --
3750: end if;
3751:
3752: if hr_api.not_exists_in_hr_lookups

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

3755: p_effective_date => p_effective_date) then
3756: --
3757: -- raise error as does not exist as lookup
3758: --
3759: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3760: fnd_message.set_token('FIELD',p_rt_prtt_anthr_pl_flag);
3761: fnd_message.set_token('TYPE','YES_NO');
3762: fnd_message.raise_error;
3763: --

Line 3760: fnd_message.set_token('FIELD',p_rt_prtt_anthr_pl_flag);

3756: --
3757: -- raise error as does not exist as lookup
3758: --
3759: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3760: fnd_message.set_token('FIELD',p_rt_prtt_anthr_pl_flag);
3761: fnd_message.set_token('TYPE','YES_NO');
3762: fnd_message.raise_error;
3763: --
3764: end if;

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

3757: -- raise error as does not exist as lookup
3758: --
3759: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3760: fnd_message.set_token('FIELD',p_rt_prtt_anthr_pl_flag);
3761: fnd_message.set_token('TYPE','YES_NO');
3762: fnd_message.raise_error;
3763: --
3764: end if;
3765:

Line 3762: fnd_message.raise_error;

3758: --
3759: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3760: fnd_message.set_token('FIELD',p_rt_prtt_anthr_pl_flag);
3761: fnd_message.set_token('TYPE','YES_NO');
3762: fnd_message.raise_error;
3763: --
3764: end if;
3765:
3766: if hr_api.not_exists_in_hr_lookups

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

3769: p_effective_date => p_effective_date) then
3770: --
3771: -- raise error as does not exist as lookup
3772: --
3773: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3774: fnd_message.set_token('FIELD',p_rt_othr_ptip_flag);
3775: fnd_message.set_token('TYPE','YES_NO');
3776: fnd_message.raise_error;
3777: --

Line 3774: fnd_message.set_token('FIELD',p_rt_othr_ptip_flag);

3770: --
3771: -- raise error as does not exist as lookup
3772: --
3773: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3774: fnd_message.set_token('FIELD',p_rt_othr_ptip_flag);
3775: fnd_message.set_token('TYPE','YES_NO');
3776: fnd_message.raise_error;
3777: --
3778: end if;

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

3771: -- raise error as does not exist as lookup
3772: --
3773: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3774: fnd_message.set_token('FIELD',p_rt_othr_ptip_flag);
3775: fnd_message.set_token('TYPE','YES_NO');
3776: fnd_message.raise_error;
3777: --
3778: end if;
3779:

Line 3776: fnd_message.raise_error;

3772: --
3773: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3774: fnd_message.set_token('FIELD',p_rt_othr_ptip_flag);
3775: fnd_message.set_token('TYPE','YES_NO');
3776: fnd_message.raise_error;
3777: --
3778: end if;
3779:
3780: if hr_api.not_exists_in_hr_lookups

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

3783: p_effective_date => p_effective_date) then
3784: --
3785: -- raise error as does not exist as lookup
3786: --
3787: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3788: fnd_message.set_token('FIELD',p_rt_no_othr_cvg_flag);
3789: fnd_message.set_token('TYPE','YES_NO');
3790: fnd_message.raise_error;
3791: --

Line 3788: fnd_message.set_token('FIELD',p_rt_no_othr_cvg_flag);

3784: --
3785: -- raise error as does not exist as lookup
3786: --
3787: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3788: fnd_message.set_token('FIELD',p_rt_no_othr_cvg_flag);
3789: fnd_message.set_token('TYPE','YES_NO');
3790: fnd_message.raise_error;
3791: --
3792: end if;

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

3785: -- raise error as does not exist as lookup
3786: --
3787: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3788: fnd_message.set_token('FIELD',p_rt_no_othr_cvg_flag);
3789: fnd_message.set_token('TYPE','YES_NO');
3790: fnd_message.raise_error;
3791: --
3792: end if;
3793:

Line 3790: fnd_message.raise_error;

3786: --
3787: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3788: fnd_message.set_token('FIELD',p_rt_no_othr_cvg_flag);
3789: fnd_message.set_token('TYPE','YES_NO');
3790: fnd_message.raise_error;
3791: --
3792: end if;
3793:
3794: if hr_api.not_exists_in_hr_lookups

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

3797: p_effective_date => p_effective_date) then
3798: --
3799: -- raise error as does not exist as lookup
3800: --
3801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3802: fnd_message.set_token('FIELD',p_rt_dpnt_othr_ptip_flag);
3803: fnd_message.set_token('TYPE','YES_NO');
3804: fnd_message.raise_error;
3805: --

Line 3802: fnd_message.set_token('FIELD',p_rt_dpnt_othr_ptip_flag);

3798: --
3799: -- raise error as does not exist as lookup
3800: --
3801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3802: fnd_message.set_token('FIELD',p_rt_dpnt_othr_ptip_flag);
3803: fnd_message.set_token('TYPE','YES_NO');
3804: fnd_message.raise_error;
3805: --
3806: end if;

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

3799: -- raise error as does not exist as lookup
3800: --
3801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3802: fnd_message.set_token('FIELD',p_rt_dpnt_othr_ptip_flag);
3803: fnd_message.set_token('TYPE','YES_NO');
3804: fnd_message.raise_error;
3805: --
3806: end if;
3807:

Line 3804: fnd_message.raise_error;

3800: --
3801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3802: fnd_message.set_token('FIELD',p_rt_dpnt_othr_ptip_flag);
3803: fnd_message.set_token('TYPE','YES_NO');
3804: fnd_message.raise_error;
3805: --
3806: end if;
3807:
3808: if hr_api.not_exists_in_hr_lookups

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

3811: p_effective_date => p_effective_date) then
3812: --
3813: -- raise error as does not exist as lookup
3814: --
3815: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3816: fnd_message.set_token('FIELD',p_rt_qua_in_gr_flag);
3817: fnd_message.set_token('TYPE','YES_NO');
3818: fnd_message.raise_error;
3819: --

Line 3816: fnd_message.set_token('FIELD',p_rt_qua_in_gr_flag);

3812: --
3813: -- raise error as does not exist as lookup
3814: --
3815: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3816: fnd_message.set_token('FIELD',p_rt_qua_in_gr_flag);
3817: fnd_message.set_token('TYPE','YES_NO');
3818: fnd_message.raise_error;
3819: --
3820: end if;

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

3813: -- raise error as does not exist as lookup
3814: --
3815: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3816: fnd_message.set_token('FIELD',p_rt_qua_in_gr_flag);
3817: fnd_message.set_token('TYPE','YES_NO');
3818: fnd_message.raise_error;
3819: --
3820: end if;
3821:

Line 3818: fnd_message.raise_error;

3814: --
3815: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3816: fnd_message.set_token('FIELD',p_rt_qua_in_gr_flag);
3817: fnd_message.set_token('TYPE','YES_NO');
3818: fnd_message.raise_error;
3819: --
3820: end if;
3821:
3822: if hr_api.not_exists_in_hr_lookups

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

3825: p_effective_date => p_effective_date) then
3826: --
3827: -- raise error as does not exist as lookup
3828: --
3829: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3830: fnd_message.set_token('FIELD',p_rt_perf_rtng_flag);
3831: fnd_message.set_token('TYPE','YES_NO');
3832: fnd_message.raise_error;
3833: --

Line 3830: fnd_message.set_token('FIELD',p_rt_perf_rtng_flag);

3826: --
3827: -- raise error as does not exist as lookup
3828: --
3829: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3830: fnd_message.set_token('FIELD',p_rt_perf_rtng_flag);
3831: fnd_message.set_token('TYPE','YES_NO');
3832: fnd_message.raise_error;
3833: --
3834: end if;

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

3827: -- raise error as does not exist as lookup
3828: --
3829: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3830: fnd_message.set_token('FIELD',p_rt_perf_rtng_flag);
3831: fnd_message.set_token('TYPE','YES_NO');
3832: fnd_message.raise_error;
3833: --
3834: end if;
3835:

Line 3832: fnd_message.raise_error;

3828: --
3829: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3830: fnd_message.set_token('FIELD',p_rt_perf_rtng_flag);
3831: fnd_message.set_token('TYPE','YES_NO');
3832: fnd_message.raise_error;
3833: --
3834: end if;
3835:
3836: if hr_api.not_exists_in_hr_lookups

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

3839: p_effective_date => p_effective_date) then
3840: --
3841: -- raise error as does not exist as lookup
3842: --
3843: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3844: fnd_message.set_token('FIELD',p_rt_elig_prfl_flag);
3845: fnd_message.set_token('TYPE','YES_NO');
3846: fnd_message.raise_error;
3847: --

Line 3844: fnd_message.set_token('FIELD',p_rt_elig_prfl_flag);

3840: --
3841: -- raise error as does not exist as lookup
3842: --
3843: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3844: fnd_message.set_token('FIELD',p_rt_elig_prfl_flag);
3845: fnd_message.set_token('TYPE','YES_NO');
3846: fnd_message.raise_error;
3847: --
3848: end if;

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

3841: -- raise error as does not exist as lookup
3842: --
3843: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3844: fnd_message.set_token('FIELD',p_rt_elig_prfl_flag);
3845: fnd_message.set_token('TYPE','YES_NO');
3846: fnd_message.raise_error;
3847: --
3848: end if;
3849: --

Line 3846: fnd_message.raise_error;

3842: --
3843: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3844: fnd_message.set_token('FIELD',p_rt_elig_prfl_flag);
3845: fnd_message.set_token('TYPE','YES_NO');
3846: fnd_message.raise_error;
3847: --
3848: end if;
3849: --
3850: hr_utility.set_location('Leaving:'||l_proc,10);

Line 4790: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');

4786: not l_api_updating then
4787: --
4788: if p_mlt_cd is NULL then
4789: --
4790: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
4791: fnd_message.raise_error;
4792: --
4793: end if;
4794: --

Line 4791: fnd_message.raise_error;

4787: --
4788: if p_mlt_cd is NULL then
4789: --
4790: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
4791: fnd_message.raise_error;
4792: --
4793: end if;
4794: --
4795: -- the following is just not true. you can't have a value

Line 4803: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');

4799:
4800: if p_mlt_cd in ('FLFX','FLFXPCL','CL','AP','CVG','CLANDCVG','APANDCVG')
4801: and p_no_mn_elcn_val_dfnd_flag = 'N' then
4802: --
4803: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
4804: fnd_message.raise_error;
4805: --
4806: end if;
4807: --

Line 4804: fnd_message.raise_error;

4800: if p_mlt_cd in ('FLFX','FLFXPCL','CL','AP','CVG','CLANDCVG','APANDCVG')
4801: and p_no_mn_elcn_val_dfnd_flag = 'N' then
4802: --
4803: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
4804: fnd_message.raise_error;
4805: --
4806: end if;
4807: --
4808: end if;

Line 4817: fnd_message.set_name('BEN','BEN_91538_MIN_VAL_RQD');

4813: if (p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG')
4814: and p_no_mn_elcn_val_dfnd_flag = 'Y')
4815: or p_mlt_cd = 'FLFXPCL' then
4816: --
4817: fnd_message.set_name('BEN','BEN_91538_MIN_VAL_RQD');
4818: fnd_message.raise_error;
4819: --
4820: end if;
4821: --

Line 4818: fnd_message.raise_error;

4814: and p_no_mn_elcn_val_dfnd_flag = 'Y')
4815: or p_mlt_cd = 'FLFXPCL' then
4816: --
4817: fnd_message.set_name('BEN','BEN_91538_MIN_VAL_RQD');
4818: fnd_message.raise_error;
4819: --
4820: end if;
4821: --
4822: end if;

Line 4829: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_REQ');

4825: --
4826: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG')
4827: and p_no_mn_elcn_val_dfnd_flag = 'Y' then
4828: --
4829: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_REQ');
4830: fnd_message.raise_error;
4831: --
4832: end if;
4833: --

Line 4830: fnd_message.raise_error;

4826: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG')
4827: and p_no_mn_elcn_val_dfnd_flag = 'Y' then
4828: --
4829: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_REQ');
4830: fnd_message.raise_error;
4831: --
4832: end if;
4833: --
4834: end if;

Line 4841: fnd_message.set_name('BEN','BEN_91542_INCRMT_VAL_RQD');

4837: --
4838: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG')
4839: and p_no_mn_elcn_val_dfnd_flag = 'Y' then
4840: --
4841: fnd_message.set_name('BEN','BEN_91542_INCRMT_VAL_RQD');
4842: fnd_message.raise_error;
4843: --
4844: end if;
4845: end if;

Line 4842: fnd_message.raise_error;

4838: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG')
4839: and p_no_mn_elcn_val_dfnd_flag = 'Y' then
4840: --
4841: fnd_message.set_name('BEN','BEN_91542_INCRMT_VAL_RQD');
4842: fnd_message.raise_error;
4843: --
4844: end if;
4845: end if;
4846: -- Bug: 4237447

Line 4849: fnd_message.set_name('PAY','HR_INPVAL_DEFAULT_INVALID');

4845: end if;
4846: -- Bug: 4237447
4847: if p_dflt_elcn_val is not NULL then
4848: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG') and p_no_mn_elcn_val_dfnd_flag = 'Y' and (p_dflt_elcn_val < p_mn_elcn_val or p_dflt_elcn_val > p_mx_elcn_val) then
4849: fnd_message.set_name('PAY','HR_INPVAL_DEFAULT_INVALID');
4850: fnd_message.raise_error;
4851: end if;
4852: end if;
4853: --End Bug: 4237447

Line 4850: fnd_message.raise_error;

4846: -- Bug: 4237447
4847: if p_dflt_elcn_val is not NULL then
4848: if p_mlt_cd in ('FLFX','CL','CVG','CLANDCVG') and p_no_mn_elcn_val_dfnd_flag = 'Y' and (p_dflt_elcn_val < p_mn_elcn_val or p_dflt_elcn_val > p_mx_elcn_val) then
4849: fnd_message.set_name('PAY','HR_INPVAL_DEFAULT_INVALID');
4850: fnd_message.raise_error;
4851: end if;
4852: end if;
4853: --End Bug: 4237447
4854: if p_rt_typ_cd is NULL then

Line 4858: fnd_message.set_name('BEN','BEN_91544_RT_TYP_CD_RQD');

4854: if p_rt_typ_cd is NULL then
4855: --
4856: if p_mlt_cd in ('CL','AP','CLANDCVG','APANDCVG','FLFXPCL') then
4857: --
4858: fnd_message.set_name('BEN','BEN_91544_RT_TYP_CD_RQD');
4859: fnd_message.raise_error;
4860: --
4861: end if;
4862: --

Line 4859: fnd_message.raise_error;

4855: --
4856: if p_mlt_cd in ('CL','AP','CLANDCVG','APANDCVG','FLFXPCL') then
4857: --
4858: fnd_message.set_name('BEN','BEN_91544_RT_TYP_CD_RQD');
4859: fnd_message.raise_error;
4860: --
4861: end if;
4862: --
4863: end if;

Line 4869: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');

4865: if p_bnft_rt_typ_cd is NULL then
4866: --
4867: if p_mlt_cd in ('CVG','CLANDCVG','APANDCVG') then
4868: --
4869: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');
4870: fnd_message.raise_error;
4871: --
4872: end if;
4873: --

Line 4870: fnd_message.raise_error;

4866: --
4867: if p_mlt_cd in ('CVG','CLANDCVG','APANDCVG') then
4868: --
4869: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');
4870: fnd_message.raise_error;
4871: --
4872: end if;
4873: --
4874: --

Line 4881: fnd_message.set_name('BEN','BEN_92472_COMP_FCTR_RQD');

4877: if p_comp_lvl_fctr_id is NULL then
4878: --
4879: if p_mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
4880: --
4881: fnd_message.set_name('BEN','BEN_92472_COMP_FCTR_RQD');
4882: fnd_message.raise_error;
4883: --
4884: end if;
4885: --

Line 4882: fnd_message.raise_error;

4878: --
4879: if p_mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
4880: --
4881: fnd_message.set_name('BEN','BEN_92472_COMP_FCTR_RQD');
4882: fnd_message.raise_error;
4883: --
4884: end if;
4885: --
4886: --

Line 4893: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');

4889: if p_val_calc_rl is NULL then
4890: --
4891: if p_mlt_cd in ('RL') then
4892: --
4893: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
4894: fnd_message.raise_error;
4895: --
4896: end if;
4897: --

Line 4894: fnd_message.raise_error;

4890: --
4891: if p_mlt_cd in ('RL') then
4892: --
4893: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
4894: fnd_message.raise_error;
4895: --
4896: end if;
4897: --
4898: else

Line 4903: fnd_message.set_name('BEN','BEN_91549_VAL_CALC_RL_SPEC');

4899: --
4900: if p_mlt_cd not in ('RL')
4901: then
4902: --
4903: fnd_message.set_name('BEN','BEN_91549_VAL_CALC_RL_SPEC');
4904: fnd_message.raise_error;
4905: --
4906: end if;
4907: end if;

Line 4904: fnd_message.raise_error;

4900: if p_mlt_cd not in ('RL')
4901: then
4902: --
4903: fnd_message.set_name('BEN','BEN_91549_VAL_CALC_RL_SPEC');
4904: fnd_message.raise_error;
4905: --
4906: end if;
4907: end if;
4908: --