144: --
145: close c_max_cvg_strt_dt;
146: --
147: --Bug 5109636 : Change of token from END_DATE to START_DATE
148: fnd_message.set_name('BEN', 'BEN_94992_PEN_ROWS_EXIST');
149: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
150: fnd_message.raise_error;
151: --
152: elsif p_datetrack_mode = 'DELETE' AND
145: close c_max_cvg_strt_dt;
146: --
147: --Bug 5109636 : Change of token from END_DATE to START_DATE
148: fnd_message.set_name('BEN', 'BEN_94992_PEN_ROWS_EXIST');
149: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
150: fnd_message.raise_error;
151: --
152: elsif p_datetrack_mode = 'DELETE' AND
153: p_effective_date < l_max_cvg_strt_dt
146: --
147: --Bug 5109636 : Change of token from END_DATE to START_DATE
148: fnd_message.set_name('BEN', 'BEN_94992_PEN_ROWS_EXIST');
149: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
150: fnd_message.raise_error;
151: --
152: elsif p_datetrack_mode = 'DELETE' AND
153: p_effective_date < l_max_cvg_strt_dt
154: then
155: --
156: close c_max_cvg_strt_dt;
157: --
158: --Bug 5109636 : Change of token from END_DATE to START_DATE
159: fnd_message.set_name('BEN', 'BEN_94993_DT_PEN_ROWS_EXIST');
160: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
161: fnd_message.raise_error;
162: --
163: end if;
156: close c_max_cvg_strt_dt;
157: --
158: --Bug 5109636 : Change of token from END_DATE to START_DATE
159: fnd_message.set_name('BEN', 'BEN_94993_DT_PEN_ROWS_EXIST');
160: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
161: fnd_message.raise_error;
162: --
163: end if;
164: --
157: --
158: --Bug 5109636 : Change of token from END_DATE to START_DATE
159: fnd_message.set_name('BEN', 'BEN_94993_DT_PEN_ROWS_EXIST');
160: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));
161: fnd_message.raise_error;
162: --
163: end if;
164: --
165: end if;
230: end if ;
231: close c_pl ;
232: -- whne the any row found then throw the error
233: if l_dummy is not null then
234: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');
235: fnd_message.raise_error;
236: end if;
237: elsif p_oipl_id is not null then
238: -- plan in option levele
231: close c_pl ;
232: -- whne the any row found then throw the error
233: if l_dummy is not null then
234: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');
235: fnd_message.raise_error;
236: end if;
237: elsif p_oipl_id is not null then
238: -- plan in option levele
239: -- check option in plan in rate
246: close c_oiplip ;
247: end if ;
248: close c_oipl ;
249: if l_dummy is not null then
250: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');
251: fnd_message.raise_error;
252: end if ;
253: else
254: --if any other level added
247: end if ;
248: close c_oipl ;
249: if l_dummy is not null then
250: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');
251: fnd_message.raise_error;
252: end if ;
253: else
254: --if any other level added
255: --if any other level added
395: count_them(p_id => p_plip_id) <> 1 then
396: --
397: -- raise error if both arguments are not null
398: --
399: fnd_message.set_name('BEN','BEN_92462_ONE_FK_ONLY');
400: fnd_message.raise_error;
401: --
402: end if;
403: --
396: --
397: -- raise error if both arguments are not null
398: --
399: fnd_message.set_name('BEN','BEN_92462_ONE_FK_ONLY');
400: fnd_message.raise_error;
401: --
402: end if;
403: --
404: hr_utility.set_location('Leaving:'||l_proc, 10);
531: p_effective_date => p_effective_date) then
532: --
533: -- raise error as does not exist as lookup
534: --
535: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
532: --
533: -- raise error as does not exist as lookup
534: --
535: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
540: end if;
600: p_effective_date => p_effective_date) then
601: --
602: -- raise error as does not exist as lookup
603: --
604: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
605: fnd_message.raise_error;
606: --
607: end if;
608: --
601: --
602: -- raise error as does not exist as lookup
603: --
604: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
605: fnd_message.raise_error;
606: --
607: end if;
608: --
609: end if;
967: close c1;
968: --
969: -- raise error
970: --
971: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
972: fnd_message.set_token('ID',p_val_calc_rl);
973: fnd_message.set_token('TYPE_ID',-49);
974: fnd_message.raise_error;
975: --
968: --
969: -- raise error
970: --
971: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
972: fnd_message.set_token('ID',p_val_calc_rl);
973: fnd_message.set_token('TYPE_ID',-49);
974: fnd_message.raise_error;
975: --
976: end if;
969: -- raise error
970: --
971: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
972: fnd_message.set_token('ID',p_val_calc_rl);
973: fnd_message.set_token('TYPE_ID',-49);
974: fnd_message.raise_error;
975: --
976: end if;
977: --
970: --
971: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
972: fnd_message.set_token('ID',p_val_calc_rl);
973: fnd_message.set_token('TYPE_ID',-49);
974: fnd_message.raise_error;
975: --
976: end if;
977: --
978: close c1;
1131: close c1;
1132: --
1133: -- raise error
1134: --
1135: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
1136: fnd_message.raise_error;
1137: --
1138: end if;
1139: --
1132: --
1133: -- raise error
1134: --
1135: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
1136: fnd_message.raise_error;
1137: --
1138: end if;
1139: --
1140: close c1;
1589: --
1590: -- raise error if max value not greater than min value
1591: --
1592: if (p_max_val < p_min_val) then
1593: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1594: fnd_message.raise_error;
1595: end if;
1596: --
1597: --
1590: -- raise error if max value not greater than min value
1591: --
1592: if (p_max_val < p_min_val) then
1593: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1594: fnd_message.raise_error;
1595: end if;
1596: --
1597: --
1598: end if;
1641: if (p_upr_lmt_val is not null and p_lwr_lmt_val is not null) and
1642: (p_upr_lmt_val < p_lwr_lmt_val)
1643: then
1644: --
1645: fnd_message.set_name('BEN','BEN_92505_HIGH_LOW_LMT_VAL');
1646: fnd_message.raise_error;
1647: null;
1648: --
1649: end if;
1642: (p_upr_lmt_val < p_lwr_lmt_val)
1643: then
1644: --
1645: fnd_message.set_name('BEN','BEN_92505_HIGH_LOW_LMT_VAL');
1646: fnd_message.raise_error;
1647: null;
1648: --
1649: end if;
1650: end chk_upr_lwr_lmt_val;
1771: open c1;
1772: fetch c1 into l_dummy;
1773: if c1%found then
1774: close c1;
1775: fnd_message.set_name('BEN','BEN_91615_OIPL_ID_NOT_UNIQUE');
1776: fnd_message.raise_error;
1777: end if;
1778: --
1779: hr_utility.set_location('Leaving:'||l_proc, 15);
1772: fetch c1 into l_dummy;
1773: if c1%found then
1774: close c1;
1775: fnd_message.set_name('BEN','BEN_91615_OIPL_ID_NOT_UNIQUE');
1776: fnd_message.raise_error;
1777: end if;
1778: --
1779: hr_utility.set_location('Leaving:'||l_proc, 15);
1780: End chk_oipl_id_unique;
1852: open c1;
1853: fetch c1 into l_dummy;
1854: if c1%found then
1855: close c1;
1856: fnd_message.set_name('BEN','BEN_91614_PL_ID_NOT_UNIQUE');
1857: fnd_message.raise_error;
1858: end if;
1859: close c1;
1860:
1853: fetch c1 into l_dummy;
1854: if c1%found then
1855: close c1;
1856: fnd_message.set_name('BEN','BEN_91614_PL_ID_NOT_UNIQUE');
1857: fnd_message.raise_error;
1858: end if;
1859: close c1;
1860:
1861: -- if the coverage value is entered at enrollment, you cannot have the
1865: open c2;
1866: fetch c2 into l_dummy;
1867: if c2%found then
1868: close c2;
1869: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1870: fnd_message.raise_error;
1871: end if;
1872: close c2;
1873:
1866: fetch c2 into l_dummy;
1867: if c2%found then
1868: close c2;
1869: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1870: fnd_message.raise_error;
1871: end if;
1872: close c2;
1873:
1874: open c3;
1874: open c3;
1875: fetch c3 into l_dummy;
1876: if c3%found then
1877: close c3;
1878: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1879: fnd_message.raise_error;
1880: end if;
1881: close c3;
1882:
1875: fetch c3 into l_dummy;
1876: if c3%found then
1877: close c3;
1878: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1879: fnd_message.raise_error;
1880: end if;
1881: close c3;
1882:
1883: open c4;
1883: open c4;
1884: fetch c4 into l_dummy;
1885: if c4%found then
1886: close c4;
1887: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1888: fnd_message.raise_error;
1889: end if;
1890: close c4;
1891:
1884: fetch c4 into l_dummy;
1885: if c4%found then
1886: close c4;
1887: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');
1888: fnd_message.raise_error;
1889: end if;
1890: close c4;
1891:
1892: end if;
1966: if c_pln%found
1967: then
1968: --
1969: close c_pln;
1970: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');
1971: fnd_message.raise_error;
1972: --
1973: end if;
1974: close c_pln;
1967: then
1968: --
1969: close c_pln;
1970: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');
1971: fnd_message.raise_error;
1972: --
1973: end if;
1974: close c_pln;
1975: --
1983: if c_oipl%found
1984: then
1985: --
1986: close c_oipl;
1987: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');
1988: fnd_message.raise_error;
1989: --
1990: end if;
1991: close c_oipl;
1984: then
1985: --
1986: close c_oipl;
1987: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');
1988: fnd_message.raise_error;
1989: --
1990: end if;
1991: close c_oipl;
1992: --
2335: if p_entr_val_at_enrt_flag = 'N' and p_cvg_mlt_cd = 'FLFX' then
2336: --
2337: if p_mn_val is not null then
2338: --
2339: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');
2340: fnd_message.raise_error;
2341: --
2342: elsif p_mx_val is not null then
2343: --
2336: --
2337: if p_mn_val is not null then
2338: --
2339: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');
2340: fnd_message.raise_error;
2341: --
2342: elsif p_mx_val is not null then
2343: --
2344: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');
2340: fnd_message.raise_error;
2341: --
2342: elsif p_mx_val is not null then
2343: --
2344: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');
2345: fnd_message.raise_error;
2346: --
2347: elsif p_incrmt_val is not null then
2348: --
2341: --
2342: elsif p_mx_val is not null then
2343: --
2344: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');
2345: fnd_message.raise_error;
2346: --
2347: elsif p_incrmt_val is not null then
2348: --
2349: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');
2345: fnd_message.raise_error;
2346: --
2347: elsif p_incrmt_val is not null then
2348: --
2349: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');
2350: fnd_message.raise_error;
2351: --
2352: elsif p_dflt_val is not null then
2353: --
2346: --
2347: elsif p_incrmt_val is not null then
2348: --
2349: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');
2350: fnd_message.raise_error;
2351: --
2352: elsif p_dflt_val is not null then
2353: --
2354: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');
2350: fnd_message.raise_error;
2351: --
2352: elsif p_dflt_val is not null then
2353: --
2354: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2351: --
2352: elsif p_dflt_val is not null then
2353: --
2354: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2359: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd = 'FLFX' then
2359: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd = 'FLFX' then
2360: --
2361: if p_val is not null then
2362: --
2363: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');
2364: fnd_message.raise_error;
2365: --
2366: end if;
2367: --
2360: --
2361: if p_val is not null then
2362: --
2363: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');
2364: fnd_message.raise_error;
2365: --
2366: end if;
2367: --
2368: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd <> 'FLFX' then
2366: end if;
2367: --
2368: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd <> 'FLFX' then
2369: --
2370: fnd_message.set_name('BEN','BEN_91941_ENTR_AT_ENRT_FLAG');
2371: fnd_message.raise_error;
2372: --
2373: end if;
2374: if p_cvg_mlt_cd is NULL then
2367: --
2368: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd <> 'FLFX' then
2369: --
2370: fnd_message.set_name('BEN','BEN_91941_ENTR_AT_ENRT_FLAG');
2371: fnd_message.raise_error;
2372: --
2373: end if;
2374: if p_cvg_mlt_cd is NULL then
2375: --
2372: --
2373: end if;
2374: if p_cvg_mlt_cd is NULL then
2375: --
2376: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
2377: fnd_message.raise_error;
2378: --
2379: end if;
2380: --
2373: end if;
2374: if p_cvg_mlt_cd is NULL then
2375: --
2376: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
2377: fnd_message.raise_error;
2378: --
2379: end if;
2380: --
2381: if p_val is NULL then
2381: if p_val is NULL then
2382: --
2383: if p_cvg_mlt_cd in ('CL','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2384: --
2385: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
2386: fnd_message.raise_error;
2387: --
2388: end if;
2389: --
2382: --
2383: if p_cvg_mlt_cd in ('CL','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2384: --
2385: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
2386: fnd_message.raise_error;
2387: --
2388: end if;
2389: --
2390: else
2390: else
2391: --
2392: if p_cvg_mlt_cd in ('FLRNG','CLRNG','RL','NSVU') then
2393: --
2394: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');
2395: fnd_message.raise_error;
2396: --
2397: end if;
2398: --
2391: --
2392: if p_cvg_mlt_cd in ('FLRNG','CLRNG','RL','NSVU') then
2393: --
2394: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');
2395: fnd_message.raise_error;
2396: --
2397: end if;
2398: --
2399: end if;
2401: if p_mn_val is NULL then
2402: --
2403: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2404: --
2405: fnd_message.set_name('BEN','BEN_91538_MIN_VAL_RQD');
2406: fnd_message.raise_error;
2407: --
2408: end if;
2409: --
2402: --
2403: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2404: --
2405: fnd_message.set_name('BEN','BEN_91538_MIN_VAL_RQD');
2406: fnd_message.raise_error;
2407: --
2408: end if;
2409: --
2410: else
2410: else
2411: --
2412: if p_cvg_mlt_cd in ('CL','RL','NSVU') then
2413: --
2414: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');
2415: fnd_message.raise_error;
2416: --
2417: end if;
2418: --
2411: --
2412: if p_cvg_mlt_cd in ('CL','RL','NSVU') then
2413: --
2414: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');
2415: fnd_message.raise_error;
2416: --
2417: end if;
2418: --
2419: end if;
2421: if p_mx_val is NULL then
2422: --
2423: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2424: --
2425: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_RQD');
2426: fnd_message.raise_error;
2427: --
2428: end if;
2429: --
2422: --
2423: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2424: --
2425: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_RQD');
2426: fnd_message.raise_error;
2427: --
2428: end if;
2429: --
2430: else
2430: else
2431: --
2432: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2433: --
2434: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');
2435: fnd_message.raise_error;
2436: --
2437: end if;
2438: --
2431: --
2432: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2433: --
2434: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');
2435: fnd_message.raise_error;
2436: --
2437: end if;
2438: --
2439: end if;
2441: if p_incrmt_val is NULL then
2442: --
2443: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2444: --
2445: fnd_message.set_name('BEN','BEN_91542_INCRMT_VAL_RQD');
2446: fnd_message.raise_error;
2447: --
2448: end if;
2449: --
2442: --
2443: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2444: --
2445: fnd_message.set_name('BEN','BEN_91542_INCRMT_VAL_RQD');
2446: fnd_message.raise_error;
2447: --
2448: end if;
2449: --
2450: else
2450: else
2451: --
2452: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2453: --
2454: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');
2455: fnd_message.raise_error;
2456: --
2457: end if;
2458: --
2451: --
2452: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2453: --
2454: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');
2455: fnd_message.raise_error;
2456: --
2457: end if;
2458: --
2459: end if;
2462: if p_dflt_val is NULL then
2463: --
2464: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2465: --
2466: fnd_message.set_name('BEN','BEN_91544_DFLT_VAL_RQD');
2467: fnd_message.raise_error;
2468: --
2469: end if;
2470: --
2463: --
2464: if p_cvg_mlt_cd in ('FLRNG','CLRNG','FLPCLRNG','CLPFLRNG') then
2465: --
2466: fnd_message.set_name('BEN','BEN_91544_DFLT_VAL_RQD');
2467: fnd_message.raise_error;
2468: --
2469: end if;
2470: --
2471: else
2471: else
2472: --
2473: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2474: --
2475: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');
2476: fnd_message.raise_error;
2477: --
2478: end if;
2479: --
2472: --
2473: if p_cvg_mlt_cd in ('CL','FLFXPCL','RL','NSVU') then
2474: --
2475: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');
2476: fnd_message.raise_error;
2477: --
2478: end if;
2479: --
2480: end if;
2482: if p_rt_typ_cd is NULL then
2483: --
2484: if p_cvg_mlt_cd in ('CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2485: --
2486: fnd_message.set_name('BEN','BEN_91546_RT_TYP_CD_RQD');
2487: fnd_message.raise_error;
2488: --
2489: end if;
2490: else
2483: --
2484: if p_cvg_mlt_cd in ('CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2485: --
2486: fnd_message.set_name('BEN','BEN_91546_RT_TYP_CD_RQD');
2487: fnd_message.raise_error;
2488: --
2489: end if;
2490: else
2491: --
2490: else
2491: --
2492: if p_cvg_mlt_cd in ('FLFX','FLRNG','RL','NSVU') then
2493: --
2494: fnd_message.set_name('BEN','BEN_91547_RT_TYP_CD_SPEC');
2495: fnd_message.raise_error;
2496: --
2497: end if;
2498: --
2491: --
2492: if p_cvg_mlt_cd in ('FLFX','FLRNG','RL','NSVU') then
2493: --
2494: fnd_message.set_name('BEN','BEN_91547_RT_TYP_CD_SPEC');
2495: fnd_message.raise_error;
2496: --
2497: end if;
2498: --
2499: end if;
2501: if p_val_calc_rl is NULL then
2502: --
2503: if p_cvg_mlt_cd in ('RL') then
2504: --
2505: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
2506: fnd_message.raise_error;
2507: --
2508: end if;
2509: --
2502: --
2503: if p_cvg_mlt_cd in ('RL') then
2504: --
2505: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
2506: fnd_message.raise_error;
2507: --
2508: end if;
2509: --
2510: else
2510: else
2511: --
2512: if p_cvg_mlt_cd in ('FLFX','FLRNG','CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG','NSVU') then
2513: --
2514: fnd_message.set_name('BEN','BEN_91549_VAL_CALC_RL_SPEC');
2515: fnd_message.raise_error;
2516: --
2517: end if;
2518: end if;
2511: --
2512: if p_cvg_mlt_cd in ('FLFX','FLRNG','CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG','NSVU') then
2513: --
2514: fnd_message.set_name('BEN','BEN_91549_VAL_CALC_RL_SPEC');
2515: fnd_message.raise_error;
2516: --
2517: end if;
2518: end if;
2519: -- begin bug 3191595
2519: -- begin bug 3191595
2520: if p_dflt_val is not null and p_mn_val is not null and p_mx_val is not null then
2521: if p_dflt_val < p_mn_val or p_dflt_val > p_mx_val then
2522: --
2523: fnd_message.set_name('PAY','HR_INPVAL_DEFAULT_INVALID');
2524: fnd_message.raise_error;
2525: --
2526: end if;
2527: end if;
2520: if p_dflt_val is not null and p_mn_val is not null and p_mx_val is not null then
2521: if p_dflt_val < p_mn_val or p_dflt_val > p_mx_val then
2522: --
2523: fnd_message.set_name('PAY','HR_INPVAL_DEFAULT_INVALID');
2524: fnd_message.raise_error;
2525: --
2526: end if;
2527: end if;
2528: -- end bug 3191595
2568: hr_utility.set_location('Entering:'||l_proc, 5);
2569: --
2570: if p_rndg_cd='RL' and p_rndg_rl is null then
2571: --
2572: fnd_message.set_name('BEN', 'BEN_91733_RNDG_RULE');
2573: fnd_message.raise_error;
2574: --
2575: end if;
2576: --
2569: --
2570: if p_rndg_cd='RL' and p_rndg_rl is null then
2571: --
2572: fnd_message.set_name('BEN', 'BEN_91733_RNDG_RULE');
2573: fnd_message.raise_error;
2574: --
2575: end if;
2576: --
2577: hr_utility.set_location('Leaving:'||l_proc,10);