[Home] [Help]
49: how to handle pay_basis type of PERIOD.
50: For now we are treating it as if it
51: has been annualized already.
52: 12 Jul 99 jcarpent 115.14 Added checks for backed out nocopy pil
53: 20-JUL-99 Gperry 115.15 genutils -> benutils package rename.
54: 04-AUG-99 T Guy 115.16 spouse and dependent age calculation
55: removed nvl() of lf_evt_ocrd_dt for
56: performance issues.
57: 30-AUG-99 pbodla 115.17 If called from what if analysis then
342: */
343: --
344: end if;
345: --
346: l_outputs := benutils.formula
347: (p_formula_id => p_formula_id,
348: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
349: p_assignment_id => l_ass_rec.assignment_id,
350: p_organization_id => l_ass_rec.organization_id,
996: if l_value is null or l_value < 0 then --Bug 14161081
997: --
998: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
999: fnd_message.set_token('DATE',l_date);
1000: benutils.write(p_text=> fnd_message.get);
1001: --Start AMN Bug 14161081
1002: ---if date code is
1003: -- first of year,half year,quarter,month,semi month,previos oct 1
1004: -- then take the first salary
1035: p_value := 0;--Bug 14161081
1036: --
1037: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
1038: fnd_message.set_token('DATE',p_effective_date);
1039: benutils.write(p_text=> fnd_message.get);
1040: return;
1041: --
1042: END IF;
1043: --
1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
1107: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
1108: fnd_message.raise_error;
1109: */
1110: benutils.write(p_text=> substr(l_msg_data,1,100));
1111: l_comp_earned := 0;
1112: l_comp_paid := 0;
1113: --
1114: end if;
1260: p_parmc => fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2),
1261: p_parm1 => p_person_id,
1262: p_person_id => p_person_id);
1263: -- end bug # 4185334
1264: benutils.write(p_text=> fnd_message.get);
1265: return;
1266: --
1267: end if;
1268: --
1496:
1497: if l_value is null then
1498: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1499: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1500: benutils.write(p_text=> fnd_message.get);
1501: return;
1502: end if;
1503:
1504: --
1571: -- Fix for bug 216.
1572: --
1573: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1574: fnd_message.set_token('DATE',l_date);
1575: benutils.write(p_text=> fnd_message.get);
1576: l_value :=
1577: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1578: l_assignment.assignment_id,
1579: p_effective_date);
1581: IF l_value IS NULL THEN
1582: --
1583: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1584: fnd_message.set_token('DATE',p_effective_date);
1585: benutils.write(p_text=> fnd_message.get);
1586: RETURN;
1587: --
1588: END IF;
1589: --
1592: exception
1593: when others then
1594: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1595: fnd_message.set_token('DATE',p_effective_date);
1596: benutils.write(p_text=> fnd_message.get);
1597: RETURN;
1598: end ;
1599:
1600: End If ; */
1677: --
1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1679: fnd_message.set_token('NAME',l_bnb_rec.name);
1680: fnd_message.set_token('DATE',l_date);
1681: benutils.write(p_text=> fnd_message.get);
1682: --
1683: l_date := l_effective_date;
1684: --
1685: open c_person_balance(l_date);
1702: else
1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1704: fnd_message.set_token('NAME',l_bnb_rec.name);
1705: fnd_message.set_token('DATE',p_effective_date);
1706: benutils.write(p_text=> fnd_message.get);
1707: end if;
1708: RETURN;
1709: --
1710: END IF;
1724: l_clf.rndg_rl is not null) and
1725: p_perform_rounding_flg = true
1726: and l_value is not null then
1727: --
1728: p_value := benutils.do_rounding
1729: (p_rounding_cd => l_clf.rndg_cd,
1730: p_rounding_rl => l_clf.rndg_rl,
1731: p_value => l_value,
1732: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date));
2324: l_agf.rndg_rl is not null) and
2325: p_perform_rounding_flg = true
2326: and l_value is not null then
2327: --
2328: p_value := benutils.do_rounding
2329: (p_rounding_cd => l_agf.rndg_cd,
2330: p_rounding_rl => l_agf.rndg_rl,
2331: p_value => l_value,
2332: p_effective_date => l_effective_date);
2733: l_lsf.rndg_rl is not null) and
2734: p_perform_rounding_flg = true
2735: and l_value is not null then
2736:
2737: p_value := benutils.do_rounding
2738: (p_rounding_cd => l_lsf.rndg_cd,
2739: p_rounding_rl => l_lsf.rndg_rl,
2740: p_value => l_value,
2741: p_effective_date => l_effective_date);
3055: fnd_message.set_token('NAME'
3056: ,l_bnb_rec.name);
3057: fnd_message.set_token('DATE'
3058: ,l_start_date);
3059: benutils.write(p_text=> fnd_message.get);
3060: --
3061: ben_person_object.get_object(p_person_id=> p_person_id
3062: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3063: ,p_effective_date)
3077: ,l_bnb_rec.name);
3078: fnd_message.set_token('DATE'
3079: ,NVL(p_lf_evt_ocrd_dt
3080: ,p_effective_date));
3081: benutils.write(p_text=> fnd_message.get);
3082: RETURN;
3083: --
3084: END IF;
3085: --
3159: fnd_message.set_name('BEN'
3160: ,'BEN_92318_BEN_BALANCE_NULL');
3161: fnd_message.set_token('DATE'
3162: ,l_start_date);
3163: benutils.write(p_text=> fnd_message.get);
3164: --
3165: l_result :=
3166: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3167: ,l_assignment.assignment_id
3173: fnd_message.set_name('BEN'
3174: ,'BEN_92318_BEN_BALANCE_NULL');
3175: fnd_message.set_token('DATE'
3176: , l_effective_date);
3177: benutils.write(p_text=> fnd_message.get);
3178: RETURN ;
3179: --
3180: END IF;
3181: --
3188: IF l_hwf.rndg_cd IS NOT NULL
3189: OR l_hwf.rndg_rl IS NOT NULL THEN
3190: --
3191: l_result :=
3192: benutils.do_rounding(p_rounding_cd=> l_hwf.rndg_cd
3193: ,p_rounding_rl => l_hwf.rndg_rl
3194: ,p_value => l_result
3195: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3196: ,p_effective_date));
3299: if l_pff.rndg_cd is not null
3300: or l_pff.rndg_rl is not null then
3301: --
3302: l_result :=
3303: benutils.do_rounding(p_rounding_cd=> l_pff.rndg_cd
3304: ,p_rounding_rl => l_pff.rndg_rl
3305: ,p_value => l_result
3306: ,p_effective_date => l_effective_date);
3307: --