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 555: fnd_message.set_name('BEN','BEN_91669_LOS_PRFL_FAIL');

551: not l_ok then
552: --
553: l_score_tab.delete;
554: g_inelg_rsn_cd := 'LOS';
555: fnd_message.set_name('BEN','BEN_91669_LOS_PRFL_FAIL');
556: hr_utility.set_location('Criteria Failed: '||l_proc,20);
557: raise g_criteria_failed;
558: --
559: end if;

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

755: if l_rows_found and
756: not l_ok then
757: --
758: g_inelg_rsn_cd := 'AGE';
759: fnd_message.set_name('BEN','BEN_91670_AGE_PRFL_FAIL');
760: hr_utility.set_location('Criteria Failed: '||l_proc,20);
761: raise g_criteria_failed;
762: --
763: end if;

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

1053: not l_ok then
1054: --
1055: hr_utility.set_location('Failed Elig ',10);
1056: g_inelg_rsn_cd := 'AGL';
1057: fnd_message.set_name('BEN','BEN_91671_AGE_LOS_PRFL_FAIL');
1058: raise g_criteria_failed;
1059: --
1060: end if;
1061: end if;

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

1208: if l_rows_found and
1209: not l_ok then
1210: --
1211: g_inelg_rsn_cd := 'CMP';
1212: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
1213: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1214: raise g_criteria_failed;
1215: --
1216: end if;

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

1271: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1272: --
1273: --if p_per_comp_val is null then
1274: --
1275: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1276: --raise ben_manage_life_events.g_record_error;
1277: --
1278: --end if;
1279: --

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

1358: if l_rows_found and
1359: not l_ok then
1360: --
1361: g_inelg_rsn_cd := 'CMP';
1362: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
1363: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1364: raise g_criteria_failed;
1365: --
1366: end if;

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

1437: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1438: --
1439: --if p_per_hrs_wkd is null then
1440: --
1441: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1442: --raise ben_manage_life_events.g_record_error;
1443: --
1444: --end if;
1445: --

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

1523: if l_rows_found and
1524: not l_ok then
1525: --
1526: g_inelg_rsn_cd := 'HRS';
1527: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1528: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1529: raise g_criteria_failed;
1530: --
1531: end if;

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

1593: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1594: --
1595: --if p_per_hrs_wkd is null then
1596: --
1597: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1598: --raise ben_manage_life_events.g_record_error;
1599: --
1600: --end if;
1601: --

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

1678: if l_rows_found and
1679: not l_ok then
1680: --
1681: g_inelg_rsn_cd := 'HRS';
1682: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1683: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1684: raise g_criteria_failed;
1685: --
1686: end if;

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

1748: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
1749: --
1750: --if p_per_hrs_wkd is null then
1751: --
1752: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1753: --raise ben_manage_life_events.g_record_error;
1754: --
1755: --end if;
1756: --

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

1832: if l_rows_found and
1833: not l_ok then
1834: --
1835: g_inelg_rsn_cd := 'HRS';
1836: fnd_message.set_name('BEN','BEN_91673_HRS_WKD_PRFL_FAIL');
1837: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1838: raise g_criteria_failed;
1839: --
1840: end if;

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

1973: if l_rows_found and
1974: not l_ok then
1975: --
1976: g_inelg_rsn_cd := 'PFT';
1977: fnd_message.set_name('BEN','BEN_91674_PCT_FT_PRFL_FAIL');
1978: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1979: raise g_criteria_failed;
1980: --
1981: end if;

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

2086: if l_rows_found and
2087: not l_ok then
2088: --
2089: g_inelg_rsn_cd := 'GRD';
2090: fnd_message.set_name('BEN','BEN_91675_GRD_PRFL_FAIL');
2091: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2092: raise g_criteria_failed;
2093: --
2094: end if;

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

2194: if l_rows_found and
2195: not l_ok then
2196: --
2197: g_inelg_rsn_cd := 'GND';
2198: fnd_message.set_name('BEN','BEN_91675_GND_PRFL_FAIL');
2199: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2200: raise g_criteria_failed;
2201: --
2202: end if;

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

2300: if l_ff_use_asg_id_flag = 'Y'
2301: then
2302: --
2303: g_inelg_rsn_cd := 'ERL';
2304: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2305: hr_utility.set_location('Criteria Failed: '||l_proc,19);
2306: raise g_criteria_failed;
2307: --
2308: end if;

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

2347: --
2348: -- Account for cases where formula returns an unknown
2349: -- variable name
2350: --
2351: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2352: fnd_message.set_token('PROC',l_proc);
2353: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2354: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2355: fnd_message.raise_error;

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

2348: -- Account for cases where formula returns an unknown
2349: -- variable name
2350: --
2351: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2352: fnd_message.set_token('PROC',l_proc);
2353: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2354: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2355: fnd_message.raise_error;
2356: --

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

2349: -- variable name
2350: --
2351: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2352: fnd_message.set_token('PROC',l_proc);
2353: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2354: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2355: fnd_message.raise_error;
2356: --
2357: end if;

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

2350: --
2351: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2352: fnd_message.set_token('PROC',l_proc);
2353: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2354: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --

Line 2355: fnd_message.raise_error;

2351: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2352: fnd_message.set_token('PROC',l_proc);
2353: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).formula_id);
2354: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2359: -- Code for type casting errors from formula return variables

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

2361: exception
2362: --
2363: when others then
2364: --
2365: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2366: fnd_message.set_token('PROC',l_proc);
2367: fnd_message.set_token('FORMULA',
2368: l_inst_dets(l_insttorrw_num).formula_id);
2369: fnd_message.set_token('PARAMETER',l_output(l_count).name);

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

2362: --
2363: when others then
2364: --
2365: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2366: fnd_message.set_token('PROC',l_proc);
2367: fnd_message.set_token('FORMULA',
2368: l_inst_dets(l_insttorrw_num).formula_id);
2369: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2370: fnd_message.raise_error;

Line 2367: fnd_message.set_token('FORMULA',

2363: when others then
2364: --
2365: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2366: fnd_message.set_token('PROC',l_proc);
2367: fnd_message.set_token('FORMULA',
2368: l_inst_dets(l_insttorrw_num).formula_id);
2369: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2370: fnd_message.raise_error;
2371: --

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

2365: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2366: fnd_message.set_token('PROC',l_proc);
2367: fnd_message.set_token('FORMULA',
2368: l_inst_dets(l_insttorrw_num).formula_id);
2369: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2370: fnd_message.raise_error;
2371: --
2372: end;
2373: --

Line 2370: fnd_message.raise_error;

2366: fnd_message.set_token('PROC',l_proc);
2367: fnd_message.set_token('FORMULA',
2368: l_inst_dets(l_insttorrw_num).formula_id);
2369: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2370: fnd_message.raise_error;
2371: --
2372: end;
2373: --
2374: end loop;

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

2378:
2379: if l_eligible <> 'Y' then
2380: --
2381: g_inelg_rsn_cd := 'ERL';
2382: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2383: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2384: raise g_criteria_failed;
2385: End if ;
2386: Else ---- if the condition is OR and pass then exit

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

2408: then
2409: if nvl(l_ben_elgy_prfl_rl_Cond,'A') = 'O' and l_eligible <> 'Y' then
2410: hr_utility.set_location('erroring on OR and N ',1963);
2411: g_inelg_rsn_cd := 'ERL';
2412: fnd_message.set_name('BEN','BEN_92445_ERL_PRFL_FAIL');
2413: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2414: raise g_criteria_failed;
2415: end if ;
2416: end if ;

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

2517: if l_rows_found and
2518: not l_ok then
2519: --
2520: g_inelg_rsn_cd := 'JOB';
2521: fnd_message.set_name('BEN','BEN_91676_JOB_PRFL_FAIL');
2522: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2523: raise g_criteria_failed;
2524: --
2525: end if;

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

2647: if l_rows_found and
2648: not l_ok then
2649: --
2650: g_inelg_rsn_cd := 'PTP';
2651: fnd_message.set_name('BEN','BEN_91677_PER_TYPE_PRFL_FAIL');
2652: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2653: raise g_criteria_failed;
2654: --
2655: end if;

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

2787: not l_ok then
2788: --
2789: hr_utility.set_location(l_proc,80);
2790: g_inelg_rsn_cd := 'PBS';
2791: fnd_message.set_name('BEN','BEN_91678_PY_BSS_PRFL_FAIL');
2792: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2793: raise g_criteria_failed;
2794: --
2795: end if;

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

2898: if l_rows_found and
2899: not l_ok then
2900: --
2901: g_inelg_rsn_cd := 'PYR';
2902: fnd_message.set_name('BEN','BEN_91679_PYRL_PRFL_FAIL');
2903: hr_utility.set_location('Criteria Failed: '||l_proc,20);
2904: raise g_criteria_failed;
2905: --
2906: end if;

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

3008: if l_rows_found and
3009: not l_ok then
3010: --
3011: g_inelg_rsn_cd := 'BGR';
3012: fnd_message.set_name('BEN','BEN_91680_BENFTS_GRP_PRFL_FAIL');
3013: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3014: raise g_criteria_failed;
3015: --
3016: end if;

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

3116: if l_rows_found and
3117: not l_ok then
3118: --
3119: g_inelg_rsn_cd := 'LOC';
3120: fnd_message.set_name('BEN','BEN_91681_WK_LOC_PRFL_FAIL');
3121: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3122: raise g_criteria_failed;
3123: --
3124: end if;

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

3548: if l_rows_found and
3549: not l_ok then
3550: --
3551: g_inelg_rsn_cd := 'PEO';
3552: fnd_message.set_name('BEN','BEN_92224_PEO_GROUP_PRFL_FAIL');
3553: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3554: raise g_criteria_failed;
3555: --
3556: end if;

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

3656: if l_rows_found and
3657: not l_ok then
3658: --
3659: g_inelg_rsn_cd := 'ORG';
3660: fnd_message.set_name('BEN','BEN_91682_ORG_UNIT_PRFL_FAIL');
3661: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3662: raise g_criteria_failed;
3663: --
3664: end if;

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

3765: if l_rows_found and
3766: not l_ok then
3767: --
3768: g_inelg_rsn_cd := 'PFQ';
3769: fnd_message.set_name('BEN','BEN_91683_PY_FREQ_PRFL_FAIL');
3770: hr_utility.set_location('Criteria Failed: '||l_proc,20);
3771: raise g_criteria_failed;
3772: --
3773: end if;

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

3904: ELSIF ( l_rows_found AND l_excld_flag = 'Y' ) then
3905: --
3906: g_inelg_rsn_cd := 'SVC';
3907: l_rows_found := FALSE ;
3908: fnd_message.set_name('BEN','BEN_92225_SVC_AREA_PRFL_FAIL');
3909: exit;
3910: --
3911: END IF;
3912: --

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

4241: -- Account for cases where formula returns an unknown
4242: -- variable name
4243:
4244:
4245: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4246: fnd_message.set_token('PROC',l_proc);
4247: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4248: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4249: -- Handling this particular exception seperately.

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

4242: -- variable name
4243:
4244:
4245: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4246: fnd_message.set_token('PROC',l_proc);
4247: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4248: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4249: -- Handling this particular exception seperately.
4250: raise invalid_param;

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

4243:
4244:
4245: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4246: fnd_message.set_token('PROC',l_proc);
4247: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4248: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4249: -- Handling this particular exception seperately.
4250: raise invalid_param;
4251: --

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

4244:
4245: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4246: fnd_message.set_token('PROC',l_proc);
4247: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4248: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4249: -- Handling this particular exception seperately.
4250: raise invalid_param;
4251: --
4252: end if;

Line 4260: fnd_message.raise_error;

4256: exception
4257: --
4258: -- Code appended for bug# 2620550
4259: when invalid_param then
4260: fnd_message.raise_error;
4261: when others then
4262: --
4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);

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

4259: when invalid_param then
4260: fnd_message.raise_error;
4261: when others then
4262: --
4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);
4265: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4266: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4267: fnd_message.raise_error;

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

4260: fnd_message.raise_error;
4261: when others then
4262: --
4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);
4265: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4266: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4267: fnd_message.raise_error;
4268: --

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

4261: when others then
4262: --
4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);
4265: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4266: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4267: fnd_message.raise_error;
4268: --
4269: end;

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

4262: --
4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);
4265: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4266: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4267: fnd_message.raise_error;
4268: --
4269: end;
4270: end loop;

Line 4267: fnd_message.raise_error;

4263: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4264: fnd_message.set_token('PROC',l_proc);
4265: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4266: fnd_message.set_token('PARAMETER',l_output(l_count).name);
4267: fnd_message.raise_error;
4268: --
4269: end;
4270: end loop;
4271: --

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

4269: end;
4270: end loop;
4271: --
4272: if l_min_hours is null and l_max_hours is null then
4273: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4274: fnd_message.set_token('PROC',l_proc);
4275: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4276: fnd_message.set_token('PARAMETER','MIN_HOURS');
4277: fnd_message.raise_error;

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

4270: end loop;
4271: --
4272: if l_min_hours is null and l_max_hours is null then
4273: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4274: fnd_message.set_token('PROC',l_proc);
4275: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4276: fnd_message.set_token('PARAMETER','MIN_HOURS');
4277: fnd_message.raise_error;
4278: end if;

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

4271: --
4272: if l_min_hours is null and l_max_hours is null then
4273: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4274: fnd_message.set_token('PROC',l_proc);
4275: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4276: fnd_message.set_token('PARAMETER','MIN_HOURS');
4277: fnd_message.raise_error;
4278: end if;
4279:

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

4272: if l_min_hours is null and l_max_hours is null then
4273: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4274: fnd_message.set_token('PROC',l_proc);
4275: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4276: fnd_message.set_token('PARAMETER','MIN_HOURS');
4277: fnd_message.raise_error;
4278: end if;
4279:
4280: if l_freq_cd is null then

Line 4277: fnd_message.raise_error;

4273: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4274: fnd_message.set_token('PROC',l_proc);
4275: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4276: fnd_message.set_token('PARAMETER','MIN_HOURS');
4277: fnd_message.raise_error;
4278: end if;
4279:
4280: if l_freq_cd is null then
4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

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

4277: fnd_message.raise_error;
4278: end if;
4279:
4280: if l_freq_cd is null then
4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4282: fnd_message.set_token('PROC',l_proc);
4283: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4284: fnd_message.set_token('PARAMETER','FREQUENCY');
4285: fnd_message.raise_error;

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

4278: end if;
4279:
4280: if l_freq_cd is null then
4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4282: fnd_message.set_token('PROC',l_proc);
4283: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4284: fnd_message.set_token('PARAMETER','FREQUENCY');
4285: fnd_message.raise_error;
4286: end if;

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

4279:
4280: if l_freq_cd is null then
4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4282: fnd_message.set_token('PROC',l_proc);
4283: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4284: fnd_message.set_token('PARAMETER','FREQUENCY');
4285: fnd_message.raise_error;
4286: end if;
4287: else

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

4280: if l_freq_cd is null then
4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4282: fnd_message.set_token('PROC',l_proc);
4283: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4284: fnd_message.set_token('PARAMETER','FREQUENCY');
4285: fnd_message.raise_error;
4286: end if;
4287: else
4288: l_min_hours := l_inst_dets(l_insttorrw_num).hrs_num;

Line 4285: fnd_message.raise_error;

4281: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
4282: fnd_message.set_token('PROC',l_proc);
4283: fnd_message.set_token('FORMULA', l_inst_dets(l_insttorrw_num).schedd_hrs_rl);
4284: fnd_message.set_token('PARAMETER','FREQUENCY');
4285: fnd_message.raise_error;
4286: end if;
4287: else
4288: l_min_hours := l_inst_dets(l_insttorrw_num).hrs_num;
4289: l_max_hours := l_inst_dets(l_insttorrw_num).max_hrs_num;

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

4441: if l_rows_found and
4442: not l_ok then
4443: --
4444: g_inelg_rsn_cd := 'SHR';
4445: fnd_message.set_name('BEN','BEN_91685_SCHED_HRS_PRFL_FAIL');
4446: hr_utility.set_location('Criteria Failed: '||l_proc,60);
4447: raise g_criteria_failed;
4448: --
4449: end if;

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

4549: if l_rows_found and
4550: not l_ok then
4551: --
4552: g_inelg_rsn_cd := 'BRG';
4553: fnd_message.set_name('BEN','BEN_91686_BRGNG_UNIT_PRFL_FAIL');
4554: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4555: raise g_criteria_failed;
4556: --
4557: end if;

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

4657: if l_rows_found and
4658: not l_ok then
4659: --
4660: g_inelg_rsn_cd := 'LBR';
4661: fnd_message.set_name('BEN','BEN_91687_LBR_MMBR_PRFL_FAIL');
4662: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4663: raise g_criteria_failed;
4664: --
4665: end if;

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

4768: if l_rows_found and
4769: not l_ok then
4770: --
4771: g_inelg_rsn_cd := 'STA';
4772: fnd_message.set_name('BEN','BEN_91688_EE_STAT_PRFL_FAIL');
4773: hr_utility.set_location('Criteria Failed: '||l_proc,20);
4774: raise g_criteria_failed;
4775: --
4776: end if;

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

5018: if l_rows_found and
5019: not l_ok then
5020: --
5021: g_inelg_rsn_cd := 'LOA';
5022: fnd_message.set_name('BEN','BEN_91689_PER_LOA_PRFL_FAIL');
5023: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5024: raise g_criteria_failed;
5025: --
5026: end if;

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

5130: if l_rows_found and
5131: not l_ok then
5132: --
5133: g_inelg_rsn_cd := 'LGL';
5134: fnd_message.set_name('BEN','BEN_91690_LGL_ENTY_PRFL_FAIL');
5135: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5136: raise g_criteria_failed;
5137: --
5138: end if;

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

5241: if l_rows_found and
5242: not l_ok then
5243: --
5244: g_inelg_rsn_cd := 'PLN';
5245: fnd_message.set_name('BEN','BEN_91691_PRTN_PL_PRFL_FAIL');
5246: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5247: raise g_criteria_failed;
5248: --
5249: end if;

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

5346: --
5347: -- There were non-excludes and we didn't match any
5348: --
5349: g_inelg_rsn_cd := 'FPT';
5350: fnd_message.set_name('BEN','BEN_91692_FL_PT_PRFL_FAIL');
5351: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5352: raise g_criteria_failed;
5353: --
5354: end if;

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

5411: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
5412: --
5413: --if p_per_comp_val is null then
5414: --
5415: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5416: --raise ben_manage_life_events.g_record_error;
5417: --
5418: --end if;
5419: --

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

5505: if l_rows_found and
5506: not l_ok then
5507: --
5508: g_inelg_rsn_cd := 'CMP';
5509: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
5510: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5511: raise g_criteria_failed;
5512: --
5513: end if;

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

5566: -- cause an error. In this case kill the run.
5567: --
5568: if l_inst_dets(l_count).formula_id is null then
5569: --
5570: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5571: fnd_message.set_token('PROC',l_proc);
5572: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5573: fnd_message.raise_error;
5574: --

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

5567: --
5568: if l_inst_dets(l_count).formula_id is null then
5569: --
5570: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5571: fnd_message.set_token('PROC',l_proc);
5572: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5573: fnd_message.raise_error;
5574: --
5575: end if;

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

5568: if l_inst_dets(l_count).formula_id is null then
5569: --
5570: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5571: fnd_message.set_token('PROC',l_proc);
5572: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5573: fnd_message.raise_error;
5574: --
5575: end if;
5576: --

Line 5573: fnd_message.raise_error;

5569: --
5570: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
5571: fnd_message.set_token('PROC',l_proc);
5572: fnd_message.set_token('ELIGY_PRFL_ID',to_char(p_eligy_prfl_id));
5573: fnd_message.raise_error;
5574: --
5575: end if;
5576: --
5577: l_outputs := benutils.formula

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

5594: --
5595: -- Account for cases where formula returns an unknown
5596: -- variable name
5597: --
5598: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5599: fnd_message.set_token('PROC',l_proc);
5600: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5601: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5602: fnd_message.raise_error;

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

5595: -- Account for cases where formula returns an unknown
5596: -- variable name
5597: --
5598: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5599: fnd_message.set_token('PROC',l_proc);
5600: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5601: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5602: fnd_message.raise_error;
5603: --

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

5596: -- variable name
5597: --
5598: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5599: fnd_message.set_token('PROC',l_proc);
5600: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5601: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5602: fnd_message.raise_error;
5603: --
5604: end if;

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

5597: --
5598: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5599: fnd_message.set_token('PROC',l_proc);
5600: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5601: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5602: fnd_message.raise_error;
5603: --
5604: end if;
5605: --

Line 5602: fnd_message.raise_error;

5598: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
5599: fnd_message.set_token('PROC',l_proc);
5600: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5601: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5602: fnd_message.raise_error;
5603: --
5604: end if;
5605: --
5606: -- Code for type casting errors from formula return variables

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

5608: exception
5609: --
5610: when others then
5611: --
5612: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5613: fnd_message.set_token('PROC',l_proc);
5614: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5615: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5616: fnd_message.raise_error;

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

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

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

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

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

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

Line 5616: fnd_message.raise_error;

5612: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
5613: fnd_message.set_token('PROC',l_proc);
5614: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
5615: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
5616: fnd_message.raise_error;
5617: --
5618: end;
5619: --
5620: hr_utility.set_location('Include Flag '||l_include_flag,10);

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

5675: if l_rows_found and
5676: not l_ok then
5677: --
5678: g_inelg_rsn_cd := 'ASS';
5679: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');
5680: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5681: raise g_criteria_failed;
5682: --
5683: end if;

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

5741: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
5742: --
5743: --if p_per_comp_val is null then
5744: --
5745: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5746: --raise ben_manage_life_events.g_record_error;
5747: --
5748: --end if;
5749: --

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

5831: if l_rows_found and
5832: not l_ok then
5833: --
5834: g_inelg_rsn_cd := 'CMP';
5835: fnd_message.set_name('BEN','BEN_91672_COMP_LVL_PRFL_FAIL');
5836: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5837: raise g_criteria_failed;
5838: --
5839: end if;

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

5906: if l_rows_found and
5907: not l_ok then
5908: --
5909: g_inelg_rsn_cd := 'ENO';
5910: fnd_message.set_name('BEN','BEN_92227_ENO_ELIG_PRFL_FAIL');
5911: hr_utility.set_location('Criteria Failed: '||l_proc,20);
5912: raise g_criteria_failed;
5913: --
5914: end if;

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

6023: if l_rows_found and
6024: not l_ok then
6025: --
6026: g_inelg_rsn_cd := 'ELV';
6027: fnd_message.set_name('BEN','BEN_92228_ELV_ELIG_PRFL_FAIL');
6028: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6029: raise g_criteria_failed;
6030: --
6031: end if;

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

6099: if l_rows_found and
6100: not l_ok then
6101: --
6102: g_inelg_rsn_cd := 'EOM';
6103: fnd_message.set_name('BEN','BEN_92229_EOM_ELIG_PRFL_FAIL');
6104: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6105: raise g_criteria_failed;
6106: --
6107: end if;

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

6215: if l_rows_found and
6216: not l_ok then
6217: --
6218: g_inelg_rsn_cd := 'EEP';
6219: fnd_message.set_name('BEN','BEN_92230_EEP_ELIG_PRFL_FAIL');
6220: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6221: raise g_criteria_failed;
6222: --
6223: end if;

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

6345: if l_rows_found and
6346: not l_ok then
6347: --
6348: g_inelg_rsn_cd := 'EEI';
6349: fnd_message.set_name('BEN','BEN_92231_EEI_ELIG_PRFL_FAIL');
6350: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6351: raise g_criteria_failed;
6352: --
6353: end if;

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

6469: if l_rows_found and
6470: not l_ok then
6471: --
6472: g_inelg_rsn_cd := 'EEG';
6473: fnd_message.set_name('BEN','BEN_92232_EEG_ELIG_PRFL_FAIL');
6474: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6475: raise g_criteria_failed;
6476: --
6477: end if;

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

6588: if l_rows_found and
6589: not l_ok then
6590: --
6591: g_inelg_rsn_cd := 'EDP';
6592: fnd_message.set_name('BEN','BEN_92233_EDP_ELIG_PRFL_FAIL');
6593: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6594: raise g_criteria_failed;
6595: --
6596: end if;

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

6708: if l_rows_found and
6709: not l_ok then
6710: --
6711: g_inelg_rsn_cd := 'EAI';
6712: fnd_message.set_name('BEN','BEN_92420_EAI_ELIG_PRFL_FAIL');
6713: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6714: raise g_criteria_failed;
6715: --
6716: end if;

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

6837: if l_rows_found and
6838: not l_ok then
6839: --
6840: g_inelg_rsn_cd := 'EDI';
6841: fnd_message.set_name('BEN','BEN_92421_EDI_ELIG_PRFL_FAIL');
6842: hr_utility.set_location('Criteria Failed: '||l_proc,20);
6843: raise g_criteria_failed;
6844: --
6845: end if;

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

7027: if l_rows_found and
7028: not l_ok then
7029: --
7030: g_inelg_rsn_cd := 'EET';
7031: fnd_message.set_name('BEN','BEN_92422_EET_ELIG_PRFL_FAIL');
7032: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7033: raise g_criteria_failed;
7034: --
7035: end if;

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

7184: if l_rows_found and
7185: not l_ok then
7186: --
7187: g_inelg_rsn_cd := 'EDT';
7188: fnd_message.set_name('BEN','BEN_92423_EDT_ELIG_PRFL_FAIL');
7189: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7190: raise g_criteria_failed;
7191: --
7192: end if;

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

7302: if l_rows_found and
7303: not l_ok then
7304: --
7305: g_inelg_rsn_cd := 'EDG';
7306: fnd_message.set_name('BEN','BEN_92424_EDG_ELIG_PRFL_FAIL');
7307: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7308: raise g_criteria_failed;
7309: --
7310: end if;

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

7405: if l_rows_found and
7406: not l_ok then
7407: --
7408: g_inelg_rsn_cd := 'ECQ';
7409: fnd_message.set_name('BEN','BEN_92425_ECQ_ELIG_PRFL_FAIL');
7410: hr_utility.set_location('Criteria Failed: '||l_proc,20);
7411: raise g_criteria_failed;
7412: --
7413: end if;

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

7510: and not l_ok
7511: then
7512: --
7513: g_inelg_rsn_cd := 'DSB';
7514: fnd_message.set_name('BEN','BEN_93080_DSBLD_PRFL_FAIL');
7515: hr_utility.set_location('Criteria Failed: '||l_proc,40);
7516: raise g_criteria_failed;
7517: --
7518: end if;

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

7622: and not l_ok
7623: then
7624: --
7625: g_inelg_rsn_cd := 'ETU';
7626: fnd_message.set_name('BEN','BEN_93081_TBCO_USE_PRFL_FAIL');
7627: hr_utility.set_location('Criteria Failed: '||l_proc,40);
7628: raise g_criteria_failed;
7629: --
7630: end if;

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

7765: and not l_ok
7766: then
7767: --
7768: g_inelg_rsn_cd := 'ETC';
7769: fnd_message.set_name('BEN','BEN_93082_TTLCVGVOL_PRFL_FAIL');
7770: hr_utility.set_location('Criteria Failed: '||l_proc,60);
7771: raise g_criteria_failed;
7772: --
7773: end if;

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

7902: and not l_ok
7903: then
7904: --
7905: g_inelg_rsn_cd := 'ETP';
7906: fnd_message.set_name('BEN','BEN_93083_TTL_PRTT_PRFL_FAIL');
7907: hr_utility.set_location('Criteria Failed: '||l_proc,60);
7908: raise g_criteria_failed;
7909: --
7910: end if;

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

8012: and not l_ok
8013: then
8014: --
8015: g_inelg_rsn_cd := 'EOP';
8016: fnd_message.set_name('BEN','BEN_93084_ANTHR_PL_PRFL_FAIL');
8017: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8018: raise g_criteria_failed;
8019: --
8020: end if;

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

8131: and not l_ok
8132: then
8133: --
8134: g_inelg_rsn_cd := 'EHC';
8135: fnd_message.set_name('BEN','BEN_93085_HLTH_CVG_PRFL_FAIL');
8136: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8137: raise g_criteria_failed;
8138: --
8139: end if;

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

8278: and not l_ok
8279: then
8280: --
8281: g_inelg_rsn_cd := 'ECY';
8282: fnd_message.set_name('BEN','BEN_93086_COMPTNCY_PRFL_FAIL');
8283: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8284: raise g_criteria_failed;
8285: --
8286: end if;

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

8524: if l_rows_found and not l_ok
8525: then
8526: --
8527: g_inelg_rsn_cd := 'ERG';
8528: fnd_message.set_name('BEN','BEN_93108_PERF_RTNG_PRFL_FAIL');
8529: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8530: raise g_criteria_failed;
8531: --
8532: end if;

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

8801: if l_rows_found and not l_ok
8802: then
8803: --
8804: g_inelg_rsn_cd := 'EQG';
8805: fnd_message.set_name('BEN','BEN_93107_QUA_IN_GR_PRFL_FAIL');
8806: hr_utility.set_location('Criteria Failed: '||l_proc,40);
8807: raise g_criteria_failed;
8808: --
8809: end if;

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

9368: --
9369: if l_cagrelig_cnt = 1 then
9370: --
9371: g_inelg_rsn_cd := 'NOCAGRELP';
9372: fnd_message.set_name('BEN','BEN_92844_NOCAGRELP_NOT_ELIG');
9373: return false;
9374: --
9375: end if;
9376: hr_utility.set_location('l_cagrelig_cnt = '|| l_cagrelig_cnt,1687);

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

9697: if (l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd <> 'ANY' and
9698: l_ass_rec.assignment_id is null) then
9699: --
9700: g_inelg_rsn_cd := 'AST';
9701: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');
9702: hr_utility.set_location('Criteria Failed: Assignment Type',20);
9703: raise g_criteria_failed;
9704: --
9705: end if;

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

9729:
9730: if not l_asg_found then
9731: --
9732: g_inelg_rsn_cd := 'AST';
9733: fnd_message.set_name('BEN','BEN_93193_ASGN_TYPE_PRFL_FAIL');
9734: hr_utility.set_location('Criteria Failed: Assignment Type',20);
9735: raise g_criteria_failed;
9736: --
9737: end if;