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

Line 566: fnd_message.set_name('BEN','BEN_91669_LOS_PRFL_FAIL');

562: not l_ok then
563: --
564: l_score_tab.delete;
565: g_inelg_rsn_cd := 'LOS';
566: fnd_message.set_name('BEN','BEN_91669_LOS_PRFL_FAIL');
567: hr_utility.set_location('Criteria Failed: '||l_proc,20);
568: raise g_criteria_failed;
569: --
570: end if;

Line 770: fnd_message.set_name('BEN','BEN_91670_AGE_PRFL_FAIL');

766: if l_rows_found and
767: not l_ok then
768: --
769: g_inelg_rsn_cd := 'AGE';
770: fnd_message.set_name('BEN','BEN_91670_AGE_PRFL_FAIL');
771: hr_utility.set_location('Criteria Failed: '||l_proc,20);
772: raise g_criteria_failed;
773: --
774: end if;

Line 1068: fnd_message.set_name('BEN','BEN_91671_AGE_LOS_PRFL_FAIL');

1064: not l_ok then
1065: --
1066: hr_utility.set_location('Failed Elig ',10);
1067: g_inelg_rsn_cd := 'AGL';
1068: fnd_message.set_name('BEN','BEN_91671_AGE_LOS_PRFL_FAIL');
1069: raise g_criteria_failed;
1070: --
1071: end if;
1072: end if;

Line 1223: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');

1219: if l_rows_found and
1220: not l_ok then
1221: --
1222: g_inelg_rsn_cd := 'CMP';
1223: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
1224: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1225: raise g_criteria_failed;
1226: --
1227: end if;

Line 1286: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

1282: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1283: --
1284: --if p_per_comp_val is null then
1285: --
1286: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1287: --raise ben_manage_life_events.g_record_error;
1288: --
1289: --end if;
1290: --

Line 1373: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');

1369: if l_rows_found and
1370: not l_ok then
1371: --
1372: g_inelg_rsn_cd := 'CMP';
1373: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
1374: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1375: raise g_criteria_failed;
1376: --
1377: end if;

Line 1452: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

1448: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1449: --
1450: --if p_per_hrs_wkd is null then
1451: --
1452: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1453: --raise ben_manage_life_events.g_record_error;
1454: --
1455: --end if;
1456: --

Line 1538: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');

1534: if l_rows_found and
1535: not l_ok then
1536: --
1537: g_inelg_rsn_cd := 'HRS';
1538: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1539: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1540: raise g_criteria_failed;
1541: --
1542: end if;

Line 1608: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

1604: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1605: --
1606: --if p_per_hrs_wkd is null then
1607: --
1608: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1609: --raise ben_manage_life_events.g_record_error;
1610: --
1611: --end if;
1612: --

Line 1693: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');

1689: if l_rows_found and
1690: not l_ok then
1691: --
1692: g_inelg_rsn_cd := 'HRS';
1693: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1694: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1695: raise g_criteria_failed;
1696: --
1697: end if;

Line 1763: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

1759: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1760: --
1761: --if p_per_hrs_wkd is null then
1762: --
1763: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1764: --raise ben_manage_life_events.g_record_error;
1765: --
1766: --end if;
1767: --

Line 1847: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');

1843: if l_rows_found and
1844: not l_ok then
1845: --
1846: g_inelg_rsn_cd := 'HRS';
1847: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1848: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1849: raise g_criteria_failed;
1850: --
1851: end if;

Line 1988: fnd_message.set_name('BEN','BEN_91674_PCT_FT_PRFL_FAIL');

1984: if l_rows_found and
1985: not l_ok then
1986: --
1987: g_inelg_rsn_cd := 'PFT';
1988: fnd_message.set_name('BEN','BEN_91674_PCT_FT_PRFL_FAIL');
1989: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1990: raise g_criteria_failed;
1991: --
1992: end if;

Line 2101: fnd_message.set_name('BEN','BEN_91675_GRD_PRFL_FAIL');

2097: if l_rows_found and
2098: not l_ok then
2099: --
2100: g_inelg_rsn_cd := 'GRD';
2101: fnd_message.set_name('BEN','BEN_91675_GRD_PRFL_FAIL');
2102: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2103: raise g_criteria_failed;
2104: --
2105: end if;

Line 2209: fnd_message.set_name('BEN','BEN_91675_GND_PRFL_FAIL');

2205: if l_rows_found and
2206: not l_ok then
2207: --
2208: g_inelg_rsn_cd := 'GND';
2209: fnd_message.set_name('BEN','BEN_91675_GND_PRFL_FAIL');
2210: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2211: raise g_criteria_failed;
2212: --
2213: end if;

Line 2315: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');

2311: if l_ff_use_asg_id_flag = 'Y'
2312: then
2313: --
2314: g_inelg_rsn_cd := 'ERL';
2315: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2316: hr_utility.set_location('Criteria Failed: '||l_proc,19);
2317: raise g_criteria_failed;
2318: --
2319: end if;

Line 2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

2358: --
2359: -- Account for cases where formula returns an unknown
2360: -- variable name
2361: --
2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2363: fnd_message.set_token('PROC',l_proc);
2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2366: fnd_message.raise_error;

Line 2363: fnd_message.set_token('PROC',l_proc);

2359: -- Account for cases where formula returns an unknown
2360: -- variable name
2361: --
2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2363: fnd_message.set_token('PROC',l_proc);
2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2366: fnd_message.raise_error;
2367: --

Line 2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);

2360: -- variable name
2361: --
2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2363: fnd_message.set_token('PROC',l_proc);
2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2366: fnd_message.raise_error;
2367: --
2368: end if;

Line 2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);

2361: --
2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2363: fnd_message.set_token('PROC',l_proc);
2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2366: fnd_message.raise_error;
2367: --
2368: end if;
2369: --

Line 2366: fnd_message.raise_error;

2362: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2363: fnd_message.set_token('PROC',l_proc);
2364: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2365: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2366: fnd_message.raise_error;
2367: --
2368: end if;
2369: --
2370: -- Code for type casting errors from formula return variables

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

2372: exception
2373: --
2374: when others then
2375: --
2376: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2377: fnd_message.set_token('PROC',l_proc);
2378: fnd_message.set_token('FORMULA',
2379: l_inst_dets(l_insttorrw_num).formula_id);
2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);

Line 2377: fnd_message.set_token('PROC',l_proc);

2373: --
2374: when others then
2375: --
2376: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2377: fnd_message.set_token('PROC',l_proc);
2378: fnd_message.set_token('FORMULA',
2379: l_inst_dets(l_insttorrw_num).formula_id);
2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2381: fnd_message.raise_error;

Line 2378: fnd_message.set_token('FORMULA',

2374: when others then
2375: --
2376: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2377: fnd_message.set_token('PROC',l_proc);
2378: fnd_message.set_token('FORMULA',
2379: l_inst_dets(l_insttorrw_num).formula_id);
2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2381: fnd_message.raise_error;
2382: --

Line 2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);

2376: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2377: fnd_message.set_token('PROC',l_proc);
2378: fnd_message.set_token('FORMULA',
2379: l_inst_dets(l_insttorrw_num).formula_id);
2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2381: fnd_message.raise_error;
2382: --
2383: end;
2384: --

Line 2381: fnd_message.raise_error;

2377: fnd_message.set_token('PROC',l_proc);
2378: fnd_message.set_token('FORMULA',
2379: l_inst_dets(l_insttorrw_num).formula_id);
2380: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2381: fnd_message.raise_error;
2382: --
2383: end;
2384: --
2385: end loop;

Line 2393: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');

2389:
2390: if l_eligible <> 'Y' then
2391: --
2392: g_inelg_rsn_cd := 'ERL';
2393: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2394: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2395: raise g_criteria_failed;
2396: End if ;
2397: Else ---- if the condition is OR and pass then exit

Line 2423: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');

2419: then
2420: if nvl(l_ben_elgy_prfl_rl_Cond,'A') = 'O' and l_eligible <> 'Y' then
2421: hr_utility.set_location('erroring on OR and N ',1963);
2422: g_inelg_rsn_cd := 'ERL';
2423: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2424: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2425: raise g_criteria_failed;
2426: end if ;
2427: end if ;

Line 2532: fnd_message.set_name('BEN','BEN_91676_JOB_PRFL_FAIL');

2528: if l_rows_found and
2529: not l_ok then
2530: --
2531: g_inelg_rsn_cd := 'JOB';
2532: fnd_message.set_name('BEN','BEN_91676_JOB_PRFL_FAIL');
2533: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2534: raise g_criteria_failed;
2535: --
2536: end if;

Line 2662: fnd_message.set_name('BEN','BEN_91677_PER_TYPE_PRFL_FAIL');

2658: if l_rows_found and
2659: not l_ok then
2660: --
2661: g_inelg_rsn_cd := 'PTP';
2662: fnd_message.set_name('BEN','BEN_91677_PER_TYPE_PRFL_FAIL');
2663: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2664: raise g_criteria_failed;
2665: --
2666: end if;

Line 2802: fnd_message.set_name('BEN','BEN_91678_PY_BSS_PRFL_FAIL');

2798: not l_ok then
2799: --
2800: hr_utility.set_location(l_proc,80);
2801: g_inelg_rsn_cd := 'PBS';
2802: fnd_message.set_name('BEN','BEN_91678_PY_BSS_PRFL_FAIL');
2803: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2804: raise g_criteria_failed;
2805: --
2806: end if;

Line 2913: fnd_message.set_name('BEN','BEN_91679_PYRL_PRFL_FAIL');

2909: if l_rows_found and
2910: not l_ok then
2911: --
2912: g_inelg_rsn_cd := 'PYR';
2913: fnd_message.set_name('BEN','BEN_91679_PYRL_PRFL_FAIL');
2914: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2915: raise g_criteria_failed;
2916: --
2917: end if;

Line 3023: fnd_message.set_name('BEN','BEN_91680_BENFTS_GRP_PRFL_FAIL');

3019: if l_rows_found and
3020: not l_ok then
3021: --
3022: g_inelg_rsn_cd := 'BGR';
3023: fnd_message.set_name('BEN','BEN_91680_BENFTS_GRP_PRFL_FAIL');
3024: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3025: raise g_criteria_failed;
3026: --
3027: end if;

Line 3131: fnd_message.set_name('BEN','BEN_91681_WK_LOC_PRFL_FAIL');

3127: if l_rows_found and
3128: not l_ok then
3129: --
3130: g_inelg_rsn_cd := 'LOC';
3131: fnd_message.set_name('BEN','BEN_91681_WK_LOC_PRFL_FAIL');
3132: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3133: raise g_criteria_failed;
3134: --
3135: end if;

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

3559: if l_rows_found and
3560: not l_ok then
3561: --
3562: g_inelg_rsn_cd := 'PEO';
3563: fnd_message.set_name('BEN','BEN_92224_PEO_GROUP_PRFL_FAIL');
3564: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3565: raise g_criteria_failed;
3566: --
3567: end if;

Line 3671: fnd_message.set_name('BEN','BEN_91682_ORG_UNIT_PRFL_FAIL');

3667: if l_rows_found and
3668: not l_ok then
3669: --
3670: g_inelg_rsn_cd := 'ORG';
3671: fnd_message.set_name('BEN','BEN_91682_ORG_UNIT_PRFL_FAIL');
3672: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3673: raise g_criteria_failed;
3674: --
3675: end if;

Line 3780: fnd_message.set_name('BEN','BEN_91683_PY_FREQ_PRFL_FAIL');

3776: if l_rows_found and
3777: not l_ok then
3778: --
3779: g_inelg_rsn_cd := 'PFQ';
3780: fnd_message.set_name('BEN','BEN_91683_PY_FREQ_PRFL_FAIL');
3781: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3782: raise g_criteria_failed;
3783: --
3784: end if;

Line 3919: fnd_message.set_name('BEN','BEN_92225_SVC_AREA_PRFL_FAIL');

3915: ELSIF ( l_rows_found AND l_excld_flag = 'Y' ) then
3916: --
3917: g_inelg_rsn_cd := 'SVC';
3918: l_rows_found := FALSE ;
3919: fnd_message.set_name('BEN','BEN_92225_SVC_AREA_PRFL_FAIL');
3920: exit;
3921: --
3922: END IF;
3923: --

Line 4256: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

4252: -- Account for cases where formula returns an unknown
4253: -- variable name
4254:
4255:
4256: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4257: fnd_message.set_token('PROC',l_proc);
4258: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4259: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4260: -- Handling this particular exception seperately.

Line 4257: fnd_message.set_token('PROC',l_proc);

4253: -- variable name
4254:
4255:
4256: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4257: fnd_message.set_token('PROC',l_proc);
4258: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4259: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4260: -- Handling this particular exception seperately.
4261: raise invalid_param;

Line 4258: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);

4254:
4255:
4256: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4257: fnd_message.set_token('PROC',l_proc);
4258: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4259: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4260: -- Handling this particular exception seperately.
4261: raise invalid_param;
4262: --

Line 4259: fnd_message.set_token('PARAMETER',l_output(l_count).name);

4255:
4256: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4257: fnd_message.set_token('PROC',l_proc);
4258: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4259: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4260: -- Handling this particular exception seperately.
4261: raise invalid_param;
4262: --
4263: end if;

Line 4271: fnd_message.raise_error;

4267: exception
4268: --
4269: -- Code appended for bug# 2620550
4270: when invalid_param then
4271: fnd_message.raise_error;
4272: when others then
4273: --
4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);

Line 4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

4270: when invalid_param then
4271: fnd_message.raise_error;
4272: when others then
4273: --
4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);
4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4278: fnd_message.raise_error;

Line 4275: fnd_message.set_token('PROC',l_proc);

4271: fnd_message.raise_error;
4272: when others then
4273: --
4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);
4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4278: fnd_message.raise_error;
4279: --

Line 4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);

4272: when others then
4273: --
4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);
4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4278: fnd_message.raise_error;
4279: --
4280: end;

Line 4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);

4273: --
4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);
4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4278: fnd_message.raise_error;
4279: --
4280: end;
4281: end loop;

Line 4278: fnd_message.raise_error;

4274: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4275: fnd_message.set_token('PROC',l_proc);
4276: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4277: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4278: fnd_message.raise_error;
4279: --
4280: end;
4281: end loop;
4282: --

Line 4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

4280: end;
4281: end loop;
4282: --
4283: if l_min_hours is null and l_max_hours is null then
4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4285: fnd_message.set_token('PROC',l_proc);
4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4287: fnd_message.set_token('PARAMETER','MIN_HOURS');
4288: fnd_message.raise_error;

Line 4285: fnd_message.set_token('PROC',l_proc);

4281: end loop;
4282: --
4283: if l_min_hours is null and l_max_hours is null then
4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4285: fnd_message.set_token('PROC',l_proc);
4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4287: fnd_message.set_token('PARAMETER','MIN_HOURS');
4288: fnd_message.raise_error;
4289: end if;

Line 4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);

4282: --
4283: if l_min_hours is null and l_max_hours is null then
4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4285: fnd_message.set_token('PROC',l_proc);
4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4287: fnd_message.set_token('PARAMETER','MIN_HOURS');
4288: fnd_message.raise_error;
4289: end if;
4290:

Line 4287: fnd_message.set_token('PARAMETER','MIN_HOURS');

4283: if l_min_hours is null and l_max_hours is null then
4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4285: fnd_message.set_token('PROC',l_proc);
4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4287: fnd_message.set_token('PARAMETER','MIN_HOURS');
4288: fnd_message.raise_error;
4289: end if;
4290:
4291: if l_freq_cd is null then

Line 4288: fnd_message.raise_error;

4284: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4285: fnd_message.set_token('PROC',l_proc);
4286: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4287: fnd_message.set_token('PARAMETER','MIN_HOURS');
4288: fnd_message.raise_error;
4289: end if;
4290:
4291: if l_freq_cd is null then
4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

Line 4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

4288: fnd_message.raise_error;
4289: end if;
4290:
4291: if l_freq_cd is null then
4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4293: fnd_message.set_token('PROC',l_proc);
4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4295: fnd_message.set_token('PARAMETER','FREQUENCY');
4296: fnd_message.raise_error;

Line 4293: fnd_message.set_token('PROC',l_proc);

4289: end if;
4290:
4291: if l_freq_cd is null then
4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4293: fnd_message.set_token('PROC',l_proc);
4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4295: fnd_message.set_token('PARAMETER','FREQUENCY');
4296: fnd_message.raise_error;
4297: end if;

Line 4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);

4290:
4291: if l_freq_cd is null then
4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4293: fnd_message.set_token('PROC',l_proc);
4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4295: fnd_message.set_token('PARAMETER','FREQUENCY');
4296: fnd_message.raise_error;
4297: end if;
4298: else

Line 4295: fnd_message.set_token('PARAMETER','FREQUENCY');

4291: if l_freq_cd is null then
4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4293: fnd_message.set_token('PROC',l_proc);
4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4295: fnd_message.set_token('PARAMETER','FREQUENCY');
4296: fnd_message.raise_error;
4297: end if;
4298: else
4299: l_min_hours := l_inst_dets(l_insttorrw_num).hrs_num;

Line 4296: fnd_message.raise_error;

4292: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4293: fnd_message.set_token('PROC',l_proc);
4294: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4295: fnd_message.set_token('PARAMETER','FREQUENCY');
4296: fnd_message.raise_error;
4297: end if;
4298: else
4299: l_min_hours := l_inst_dets(l_insttorrw_num).hrs_num;
4300: l_max_hours := l_inst_dets(l_insttorrw_num).max_hrs_num;

Line 4456: fnd_message.set_name('BEN','BEN_91685_SCHED_HRS_PRFL_FAIL');

4452: if l_rows_found and
4453: not l_ok then
4454: --
4455: g_inelg_rsn_cd := 'SHR';
4456: fnd_message.set_name('BEN','BEN_91685_SCHED_HRS_PRFL_FAIL');
4457: hr_utility.set_location('Criteria Failed: '||l_proc,60);
4458: raise g_criteria_failed;
4459: --
4460: end if;

Line 4564: fnd_message.set_name('BEN','BEN_91686_BRGNG_UNIT_PRFL_FAIL');

4560: if l_rows_found and
4561: not l_ok then
4562: --
4563: g_inelg_rsn_cd := 'BRG';
4564: fnd_message.set_name('BEN','BEN_91686_BRGNG_UNIT_PRFL_FAIL');
4565: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4566: raise g_criteria_failed;
4567: --
4568: end if;

Line 4672: fnd_message.set_name('BEN','BEN_91687_LBR_MMBR_PRFL_FAIL');

4668: if l_rows_found and
4669: not l_ok then
4670: --
4671: g_inelg_rsn_cd := 'LBR';
4672: fnd_message.set_name('BEN','BEN_91687_LBR_MMBR_PRFL_FAIL');
4673: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4674: raise g_criteria_failed;
4675: --
4676: end if;

Line 4783: fnd_message.set_name('BEN','BEN_91688_EE_STAT_PRFL_FAIL');

4779: if l_rows_found and
4780: not l_ok then
4781: --
4782: g_inelg_rsn_cd := 'STA';
4783: fnd_message.set_name('BEN','BEN_91688_EE_STAT_PRFL_FAIL');
4784: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4785: raise g_criteria_failed;
4786: --
4787: end if;

Line 5033: fnd_message.set_name('BEN','BEN_91689_PER_LOA_PRFL_FAIL');

5029: if l_rows_found and
5030: not l_ok then
5031: --
5032: g_inelg_rsn_cd := 'LOA';
5033: fnd_message.set_name('BEN','BEN_91689_PER_LOA_PRFL_FAIL');
5034: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5035: raise g_criteria_failed;
5036: --
5037: end if;

Line 5145: fnd_message.set_name('BEN','BEN_91690_LGL_ENTY_PRFL_FAIL');

5141: if l_rows_found and
5142: not l_ok then
5143: --
5144: g_inelg_rsn_cd := 'LGL';
5145: fnd_message.set_name('BEN','BEN_91690_LGL_ENTY_PRFL_FAIL');
5146: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5147: raise g_criteria_failed;
5148: --
5149: end if;

Line 5257: fnd_message.set_name('BEN','BEN_91691_PRTN_PL_PRFL_FAIL');

5253: if l_rows_found and
5254: not l_ok then
5255: --
5256: g_inelg_rsn_cd := 'PLN';
5257: fnd_message.set_name('BEN','BEN_91691_PRTN_PL_PRFL_FAIL');
5258: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5259: raise g_criteria_failed;
5260: --
5261: end if;

Line 5362: fnd_message.set_name('BEN','BEN_91692_FL_PT_PRFL_FAIL');

5358: --
5359: -- There were non-excludes and we didn't match any
5360: --
5361: g_inelg_rsn_cd := 'FPT';
5362: fnd_message.set_name('BEN','BEN_91692_FL_PT_PRFL_FAIL');
5363: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5364: raise g_criteria_failed;
5365: --
5366: end if;

Line 5427: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

5423: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
5424: --
5425: --if p_per_comp_val is null then
5426: --
5427: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5428: --raise ben_manage_life_events.g_record_error;
5429: --
5430: --end if;
5431: --

Line 5521: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');

5517: if l_rows_found and
5518: not l_ok then
5519: --
5520: g_inelg_rsn_cd := 'CMP';
5521: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
5522: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5523: raise g_criteria_failed;
5524: --
5525: end if;

Line 5582: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');

5578: -- cause an error. In this case kill the run.
5579: --
5580: if l_inst_dets(l_count).formula_id is null then
5581: --
5582: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5583: fnd_message.set_token('PROC',l_proc);
5584: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5585: fnd_message.raise_error;
5586: --

Line 5583: fnd_message.set_token('PROC',l_proc);

5579: --
5580: if l_inst_dets(l_count).formula_id is null then
5581: --
5582: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5583: fnd_message.set_token('PROC',l_proc);
5584: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5585: fnd_message.raise_error;
5586: --
5587: end if;

Line 5584: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));

5580: if l_inst_dets(l_count).formula_id is null then
5581: --
5582: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5583: fnd_message.set_token('PROC',l_proc);
5584: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5585: fnd_message.raise_error;
5586: --
5587: end if;
5588: --

Line 5585: fnd_message.raise_error;

5581: --
5582: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5583: fnd_message.set_token('PROC',l_proc);
5584: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5585: fnd_message.raise_error;
5586: --
5587: end if;
5588: --
5589: l_outputs := benutils.formula

Line 5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

5606: --
5607: -- Account for cases where formula returns an unknown
5608: -- variable name
5609: --
5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5611: fnd_message.set_token('PROC',l_proc);
5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5614: fnd_message.raise_error;

Line 5611: fnd_message.set_token('PROC',l_proc);

5607: -- Account for cases where formula returns an unknown
5608: -- variable name
5609: --
5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5611: fnd_message.set_token('PROC',l_proc);
5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5614: fnd_message.raise_error;
5615: --

Line 5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);

5608: -- variable name
5609: --
5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5611: fnd_message.set_token('PROC',l_proc);
5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5614: fnd_message.raise_error;
5615: --
5616: end if;

Line 5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

5609: --
5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5611: fnd_message.set_token('PROC',l_proc);
5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5614: fnd_message.raise_error;
5615: --
5616: end if;
5617: --

Line 5614: fnd_message.raise_error;

5610: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5611: fnd_message.set_token('PROC',l_proc);
5612: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5613: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5614: fnd_message.raise_error;
5615: --
5616: end if;
5617: --
5618: -- Code for type casting errors from formula return variables

Line 5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

5620: exception
5621: --
5622: when others then
5623: --
5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5625: fnd_message.set_token('PROC',l_proc);
5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5628: fnd_message.raise_error;

Line 5625: fnd_message.set_token('PROC',l_proc);

5621: --
5622: when others then
5623: --
5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5625: fnd_message.set_token('PROC',l_proc);
5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5628: fnd_message.raise_error;
5629: --

Line 5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);

5622: when others then
5623: --
5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5625: fnd_message.set_token('PROC',l_proc);
5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5628: fnd_message.raise_error;
5629: --
5630: end;

Line 5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

5623: --
5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5625: fnd_message.set_token('PROC',l_proc);
5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5628: fnd_message.raise_error;
5629: --
5630: end;
5631: --

Line 5628: fnd_message.raise_error;

5624: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5625: fnd_message.set_token('PROC',l_proc);
5626: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5627: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5628: fnd_message.raise_error;
5629: --
5630: end;
5631: --
5632: hr_utility.set_location('Include Flag '||l_include_flag,10);

Line 5691: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');

5687: if l_rows_found and
5688: not l_ok then
5689: --
5690: g_inelg_rsn_cd := 'ASS';
5691: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');
5692: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5693: raise g_criteria_failed;
5694: --
5695: end if;

Line 5757: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');

5753: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
5754: --
5755: --if p_per_comp_val is null then
5756: --
5757: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5758: --raise ben_manage_life_events.g_record_error;
5759: --
5760: --end if;
5761: --

Line 5847: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');

5843: if l_rows_found and
5844: not l_ok then
5845: --
5846: g_inelg_rsn_cd := 'CMP';
5847: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
5848: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5849: raise g_criteria_failed;
5850: --
5851: end if;

Line 5922: fnd_message.set_name('BEN','BEN_92227_ENO_ELIG_PRFL_FAIL');

5918: if l_rows_found and
5919: not l_ok then
5920: --
5921: g_inelg_rsn_cd := 'ENO';
5922: fnd_message.set_name('BEN','BEN_92227_ENO_ELIG_PRFL_FAIL');
5923: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5924: raise g_criteria_failed;
5925: --
5926: end if;

Line 6039: fnd_message.set_name('BEN','BEN_92228_ELV_ELIG_PRFL_FAIL');

6035: if l_rows_found and
6036: not l_ok then
6037: --
6038: g_inelg_rsn_cd := 'ELV';
6039: fnd_message.set_name('BEN','BEN_92228_ELV_ELIG_PRFL_FAIL');
6040: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6041: raise g_criteria_failed;
6042: --
6043: end if;

Line 6115: fnd_message.set_name('BEN','BEN_92229_EOM_ELIG_PRFL_FAIL');

6111: if l_rows_found and
6112: not l_ok then
6113: --
6114: g_inelg_rsn_cd := 'EOM';
6115: fnd_message.set_name('BEN','BEN_92229_EOM_ELIG_PRFL_FAIL');
6116: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6117: raise g_criteria_failed;
6118: --
6119: end if;

Line 6231: fnd_message.set_name('BEN','BEN_92230_EEP_ELIG_PRFL_FAIL');

6227: if l_rows_found and
6228: not l_ok then
6229: --
6230: g_inelg_rsn_cd := 'EEP';
6231: fnd_message.set_name('BEN','BEN_92230_EEP_ELIG_PRFL_FAIL');
6232: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6233: raise g_criteria_failed;
6234: --
6235: end if;

Line 6361: fnd_message.set_name('BEN','BEN_92231_EEI_ELIG_PRFL_FAIL');

6357: if l_rows_found and
6358: not l_ok then
6359: --
6360: g_inelg_rsn_cd := 'EEI';
6361: fnd_message.set_name('BEN','BEN_92231_EEI_ELIG_PRFL_FAIL');
6362: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6363: raise g_criteria_failed;
6364: --
6365: end if;

Line 6485: fnd_message.set_name('BEN','BEN_92232_EEG_ELIG_PRFL_FAIL');

6481: if l_rows_found and
6482: not l_ok then
6483: --
6484: g_inelg_rsn_cd := 'EEG';
6485: fnd_message.set_name('BEN','BEN_92232_EEG_ELIG_PRFL_FAIL');
6486: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6487: raise g_criteria_failed;
6488: --
6489: end if;

Line 6604: fnd_message.set_name('BEN','BEN_92233_EDP_ELIG_PRFL_FAIL');

6600: if l_rows_found and
6601: not l_ok then
6602: --
6603: g_inelg_rsn_cd := 'EDP';
6604: fnd_message.set_name('BEN','BEN_92233_EDP_ELIG_PRFL_FAIL');
6605: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6606: raise g_criteria_failed;
6607: --
6608: end if;

Line 6724: fnd_message.set_name('BEN','BEN_92420_EAI_ELIG_PRFL_FAIL');

6720: if l_rows_found and
6721: not l_ok then
6722: --
6723: g_inelg_rsn_cd := 'EAI';
6724: fnd_message.set_name('BEN','BEN_92420_EAI_ELIG_PRFL_FAIL');
6725: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6726: raise g_criteria_failed;
6727: --
6728: end if;

Line 6853: fnd_message.set_name('BEN','BEN_92421_EDI_ELIG_PRFL_FAIL');

6849: if l_rows_found and
6850: not l_ok then
6851: --
6852: g_inelg_rsn_cd := 'EDI';
6853: fnd_message.set_name('BEN','BEN_92421_EDI_ELIG_PRFL_FAIL');
6854: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6855: raise g_criteria_failed;
6856: --
6857: end if;

Line 7043: fnd_message.set_name('BEN','BEN_92422_EET_ELIG_PRFL_FAIL');

7039: if l_rows_found and
7040: not l_ok then
7041: --
7042: g_inelg_rsn_cd := 'EET';
7043: fnd_message.set_name('BEN','BEN_92422_EET_ELIG_PRFL_FAIL');
7044: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7045: raise g_criteria_failed;
7046: --
7047: end if;

Line 7200: fnd_message.set_name('BEN','BEN_92423_EDT_ELIG_PRFL_FAIL');

7196: if l_rows_found and
7197: not l_ok then
7198: --
7199: g_inelg_rsn_cd := 'EDT';
7200: fnd_message.set_name('BEN','BEN_92423_EDT_ELIG_PRFL_FAIL');
7201: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7202: raise g_criteria_failed;
7203: --
7204: end if;

Line 7318: fnd_message.set_name('BEN','BEN_92424_EDG_ELIG_PRFL_FAIL');

7314: if l_rows_found and
7315: not l_ok then
7316: --
7317: g_inelg_rsn_cd := 'EDG';
7318: fnd_message.set_name('BEN','BEN_92424_EDG_ELIG_PRFL_FAIL');
7319: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7320: raise g_criteria_failed;
7321: --
7322: end if;

Line 7427: fnd_message.set_name('BEN','BEN_92425_ECQ_ELIG_PRFL_FAIL');

7423: if l_rows_found and
7424: not l_ok then
7425: --
7426: g_inelg_rsn_cd := 'ECQ';
7427: fnd_message.set_name('BEN','BEN_92425_ECQ_ELIG_PRFL_FAIL');
7428: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7429: raise g_criteria_failed;
7430: --
7431: end if;

Line 7532: fnd_message.set_name('BEN','BEN_93080_DSBLD_PRFL_FAIL');

7528: and not l_ok
7529: then
7530: --
7531: g_inelg_rsn_cd := 'DSB';
7532: fnd_message.set_name('BEN','BEN_93080_DSBLD_PRFL_FAIL');
7533: hr_utility.set_location('Criteria Failed: '||l_proc,40);
7534: raise g_criteria_failed;
7535: --
7536: end if;

Line 7644: fnd_message.set_name('BEN','BEN_93081_TBCO_USE_PRFL_FAIL');

7640: and not l_ok
7641: then
7642: --
7643: g_inelg_rsn_cd := 'ETU';
7644: fnd_message.set_name('BEN','BEN_93081_TBCO_USE_PRFL_FAIL');
7645: hr_utility.set_location('Criteria Failed: '||l_proc,40);
7646: raise g_criteria_failed;
7647: --
7648: end if;

Line 7787: fnd_message.set_name('BEN','BEN_93082_TTLCVGVOL_PRFL_FAIL');

7783: and not l_ok
7784: then
7785: --
7786: g_inelg_rsn_cd := 'ETC';
7787: fnd_message.set_name('BEN','BEN_93082_TTLCVGVOL_PRFL_FAIL');
7788: hr_utility.set_location('Criteria Failed: '||l_proc,60);
7789: raise g_criteria_failed;
7790: --
7791: end if;

Line 7924: fnd_message.set_name('BEN','BEN_93083_TTL_PRTT_PRFL_FAIL');

7920: and not l_ok
7921: then
7922: --
7923: g_inelg_rsn_cd := 'ETP';
7924: fnd_message.set_name('BEN','BEN_93083_TTL_PRTT_PRFL_FAIL');
7925: hr_utility.set_location('Criteria Failed: '||l_proc,60);
7926: raise g_criteria_failed;
7927: --
7928: end if;

Line 8034: fnd_message.set_name('BEN','BEN_93084_ANTHR_PL_PRFL_FAIL');

8030: and not l_ok
8031: then
8032: --
8033: g_inelg_rsn_cd := 'EOP';
8034: fnd_message.set_name('BEN','BEN_93084_ANTHR_PL_PRFL_FAIL');
8035: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8036: raise g_criteria_failed;
8037: --
8038: end if;

Line 8153: fnd_message.set_name('BEN','BEN_93085_HLTH_CVG_PRFL_FAIL');

8149: and not l_ok
8150: then
8151: --
8152: g_inelg_rsn_cd := 'EHC';
8153: fnd_message.set_name('BEN','BEN_93085_HLTH_CVG_PRFL_FAIL');
8154: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8155: raise g_criteria_failed;
8156: --
8157: end if;

Line 8300: fnd_message.set_name('BEN','BEN_93086_COMPTNCY_PRFL_FAIL');

8296: and not l_ok
8297: then
8298: --
8299: g_inelg_rsn_cd := 'ECY';
8300: fnd_message.set_name('BEN','BEN_93086_COMPTNCY_PRFL_FAIL');
8301: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8302: raise g_criteria_failed;
8303: --
8304: end if;

Line 8546: fnd_message.set_name('BEN','BEN_93108_PERF_RTNG_PRFL_FAIL');

8542: if l_rows_found and not l_ok
8543: then
8544: --
8545: g_inelg_rsn_cd := 'ERG';
8546: fnd_message.set_name('BEN','BEN_93108_PERF_RTNG_PRFL_FAIL');
8547: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8548: raise g_criteria_failed;
8549: --
8550: end if;

Line 8823: fnd_message.set_name('BEN','BEN_93107_QUA_IN_GR_PRFL_FAIL');

8819: if l_rows_found and not l_ok
8820: then
8821: --
8822: g_inelg_rsn_cd := 'EQG';
8823: fnd_message.set_name('BEN','BEN_93107_QUA_IN_GR_PRFL_FAIL');
8824: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8825: raise g_criteria_failed;
8826: --
8827: end if;

Line 9391: fnd_message.set_name('BEN','BEN_92844_NOCAGRELP_NOT_ELIG');

9387: --
9388: if l_cagrelig_cnt = 1 then
9389: --
9390: g_inelg_rsn_cd := 'NOCAGRELP';
9391: fnd_message.set_name('BEN','BEN_92844_NOCAGRELP_NOT_ELIG');
9392: return false;
9393: --
9394: end if;
9395: hr_utility.set_location('l_cagrelig_cnt = '|| l_cagrelig_cnt,1687);

Line 9698: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');

9694: --
9695: /*Start Enh: 13478736 - Learner Access Eligibility Enhancement*/
9696: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd in ('CWAO','EAAO','ECWA') then
9697: if p_assignment_id is null then
9698: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');
9699: hr_utility.set_location('Criteria Failed: Assignment Type',67);
9700: raise g_criteria_failed;
9701: end if;
9702: hr_utility.set_location('asmt_to_use_cd '||l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd,67);

Line 9736: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');

9732: if (l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd <> 'ANY' and
9733: l_ass_rec.assignment_id is null) then
9734: --
9735: g_inelg_rsn_cd := 'AST';
9736: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');
9737: hr_utility.set_location('Criteria Failed: Assignment Type',20);
9738: raise g_criteria_failed;
9739: --
9740: end if;

Line 9773: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');

9769:
9770: if not l_asg_found then
9771: --
9772: g_inelg_rsn_cd := 'AST';
9773: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');
9774: hr_utility.set_location('Criteria Failed: Assignment Type',20);
9775: raise g_criteria_failed;
9776: --
9777: end if;