DBA Data[Home] [Help]

APPS.BEN_CCM_BUS dependencies on FND_MESSAGE

Line 148: fnd_message.set_name('BEN', 'BEN_94992_PEN_ROWS_EXIST');

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

Line 149: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));

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

Line 150: fnd_message.raise_error;

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

Line 159: fnd_message.set_name('BEN', 'BEN_94993_DT_PEN_ROWS_EXIST');

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;

Line 160: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_max_cvg_strt_dt));

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: --

Line 161: fnd_message.raise_error;

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;

Line 234: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');

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

Line 235: fnd_message.raise_error;

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

Line 250: fnd_message.set_name('BEN','BEN_92653_ENTR_VAL_RATE_CVG');

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

Line 251: fnd_message.raise_error;

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

Line 399: fnd_message.set_name('BEN','BEN_92462_ONE_FK_ONLY');

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: --

Line 400: fnd_message.raise_error;

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);

Line 535: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

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: --

Line 536: fnd_message.raise_error;

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;

Line 604: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');

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: --

Line 605: fnd_message.raise_error;

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;

Line 971: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

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: --

Line 972: fnd_message.set_token('ID',p_val_calc_rl);

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;

Line 973: fnd_message.set_token('TYPE_ID',-49);

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: --

Line 974: fnd_message.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: --
978: close c1;

Line 1135: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');

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: --

Line 1136: fnd_message.raise_error;

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;

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

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: --

Line 1594: fnd_message.raise_error;

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;

Line 1645: fnd_message.set_name('BEN','BEN_92505_HIGH_LOW_LMT_VAL');

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;

Line 1646: fnd_message.raise_error;

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;

Line 1775: fnd_message.set_name('BEN','BEN_91615_OIPL_ID_NOT_UNIQUE');

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);

Line 1776: fnd_message.raise_error;

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;

Line 1856: fnd_message.set_name('BEN','BEN_91614_PL_ID_NOT_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:

Line 1857: fnd_message.raise_error;

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

Line 1869: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');

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:

Line 1870: fnd_message.raise_error;

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;

Line 1878: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');

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:

Line 1879: fnd_message.raise_error;

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;

Line 1887: fnd_message.set_name('BEN','BEN_92553_CVG_CANNOT_ENTR');

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:

Line 1888: fnd_message.raise_error;

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;

Line 1970: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');

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;

Line 1971: fnd_message.raise_error;

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: --

Line 1987: fnd_message.set_name('BEN', 'BEN_94035_CVG_ATTACH_SVGS_PLAN');

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;

Line 1988: fnd_message.raise_error;

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: --

Line 2339: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');

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: --

Line 2340: fnd_message.raise_error;

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

Line 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: --

Line 2345: 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: --
2349: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');

Line 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: --

Line 2350: 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: --
2354: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');

Line 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: --

Line 2355: 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: --
2359: elsif p_entr_val_at_enrt_flag = 'Y' and p_cvg_mlt_cd = 'FLFX' then

Line 2363: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');

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: --

Line 2364: fnd_message.raise_error;

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

Line 2370: fnd_message.set_name('BEN','BEN_91941_ENTR_AT_ENRT_FLAG');

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

Line 2371: fnd_message.raise_error;

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: --

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

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: --

Line 2377: fnd_message.raise_error;

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

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

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: --

Line 2386: fnd_message.raise_error;

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

Line 2394: fnd_message.set_name('BEN','BEN_91537_VAL_SPEC');

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: --

Line 2395: fnd_message.raise_error;

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;

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

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: --

Line 2406: fnd_message.raise_error;

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

Line 2414: fnd_message.set_name('BEN','BEN_91539_MIN_VAL_SPEC');

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: --

Line 2415: fnd_message.raise_error;

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;

Line 2425: fnd_message.set_name('BEN','BEN_91540_MAX_VAL_RQD');

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: --

Line 2426: fnd_message.raise_error;

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

Line 2434: fnd_message.set_name('BEN','BEN_91541_MAX_VAL_SPEC');

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: --

Line 2435: fnd_message.raise_error;

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;

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

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: --

Line 2446: fnd_message.raise_error;

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

Line 2454: fnd_message.set_name('BEN','BEN_91543_INCRMT_VAL_SPEC');

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: --

Line 2455: fnd_message.raise_error;

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;

Line 2466: fnd_message.set_name('BEN','BEN_91544_DFLT_VAL_RQD');

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: --

Line 2467: fnd_message.raise_error;

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

Line 2475: fnd_message.set_name('BEN','BEN_91545_DFLT_VAL_SPEC');

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: --

Line 2476: fnd_message.raise_error;

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;

Line 2486: fnd_message.set_name('BEN','BEN_91546_RT_TYP_CD_RQD');

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

Line 2487: fnd_message.raise_error;

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: --

Line 2494: fnd_message.set_name('BEN','BEN_91547_RT_TYP_CD_SPEC');

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: --

Line 2495: fnd_message.raise_error;

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;

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

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: --

Line 2506: fnd_message.raise_error;

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

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

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;

Line 2515: fnd_message.raise_error;

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

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

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;

Line 2524: fnd_message.raise_error;

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

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

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: --

Line 2573: fnd_message.raise_error;

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);