[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
327: */
328: --
329: end if;
330: --
331: l_outputs := benutils.formula
332: (p_formula_id => p_formula_id,
333: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
334: p_assignment_id => l_ass_rec.assignment_id,
335: p_organization_id => l_ass_rec.organization_id,
891: if l_value is null then
892: --
893: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
894: fnd_message.set_token('DATE',l_date);
895: benutils.write(p_text=> fnd_message.get);
896: --
897: -- try with todays date
898: --
899: run_rule
917: IF l_value IS NULL THEN
918: --
919: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
920: fnd_message.set_token('DATE',p_effective_date);
921: benutils.write(p_text=> fnd_message.get);
922: return;
923: --
924: END IF;
925: --
988: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
990: fnd_message.raise_error;
991: */
992: benutils.write(p_text=> substr(l_msg_data,1,100));
993: l_comp_earned := 0;
994: l_comp_paid := 0;
995: --
996: end if;
1142: p_parmc => fnd_date.date_to_displaydate(p_effective_date),
1143: p_parm1 => p_person_id,
1144: p_person_id => p_person_id);
1145: -- end bug # 4185334
1146: benutils.write(p_text=> fnd_message.get);
1147: return;
1148: --
1149: end if;
1150: --
1378:
1379: if l_value is null then
1380: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1381: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1382: benutils.write(p_text=> fnd_message.get);
1383: return;
1384: end if;
1385:
1386: --
1453: -- Fix for bug 216.
1454: --
1455: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1456: fnd_message.set_token('DATE',l_date);
1457: benutils.write(p_text=> fnd_message.get);
1458: l_value :=
1459: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1460: l_assignment.assignment_id,
1461: p_effective_date);
1463: IF l_value IS NULL THEN
1464: --
1465: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1466: fnd_message.set_token('DATE',p_effective_date);
1467: benutils.write(p_text=> fnd_message.get);
1468: RETURN;
1469: --
1470: END IF;
1471: --
1474: exception
1475: when others then
1476: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1477: fnd_message.set_token('DATE',p_effective_date);
1478: benutils.write(p_text=> fnd_message.get);
1479: RETURN;
1480: end ;
1481:
1482: End If ; */
1559: --
1560: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1561: fnd_message.set_token('NAME',l_bnb_rec.name);
1562: fnd_message.set_token('DATE',l_date);
1563: benutils.write(p_text=> fnd_message.get);
1564: --
1565: l_date := l_effective_date;
1566: --
1567: open c_person_balance(l_date);
1584: else
1585: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1586: fnd_message.set_token('NAME',l_bnb_rec.name);
1587: fnd_message.set_token('DATE',p_effective_date);
1588: benutils.write(p_text=> fnd_message.get);
1589: end if;
1590: RETURN;
1591: --
1592: END IF;
1606: l_clf.rndg_rl is not null) and
1607: p_perform_rounding_flg = true
1608: and l_value is not null then
1609: --
1610: p_value := benutils.do_rounding
1611: (p_rounding_cd => l_clf.rndg_cd,
1612: p_rounding_rl => l_clf.rndg_rl,
1613: p_value => l_value,
1614: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date));
2204: l_agf.rndg_rl is not null) and
2205: p_perform_rounding_flg = true
2206: and l_value is not null then
2207: --
2208: p_value := benutils.do_rounding
2209: (p_rounding_cd => l_agf.rndg_cd,
2210: p_rounding_rl => l_agf.rndg_rl,
2211: p_value => l_value,
2212: p_effective_date => l_effective_date);
2612: l_lsf.rndg_rl is not null) and
2613: p_perform_rounding_flg = true
2614: and l_value is not null then
2615:
2616: p_value := benutils.do_rounding
2617: (p_rounding_cd => l_lsf.rndg_cd,
2618: p_rounding_rl => l_lsf.rndg_rl,
2619: p_value => l_value,
2620: p_effective_date => l_effective_date);
2934: fnd_message.set_token('NAME'
2935: ,l_bnb_rec.name);
2936: fnd_message.set_token('DATE'
2937: ,l_start_date);
2938: benutils.write(p_text=> fnd_message.get);
2939: --
2940: ben_person_object.get_object(p_person_id=> p_person_id
2941: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
2942: ,p_effective_date)
2956: ,l_bnb_rec.name);
2957: fnd_message.set_token('DATE'
2958: ,NVL(p_lf_evt_ocrd_dt
2959: ,p_effective_date));
2960: benutils.write(p_text=> fnd_message.get);
2961: RETURN;
2962: --
2963: END IF;
2964: --
3038: fnd_message.set_name('BEN'
3039: ,'BEN_92318_BEN_BALANCE_NULL');
3040: fnd_message.set_token('DATE'
3041: ,l_start_date);
3042: benutils.write(p_text=> fnd_message.get);
3043: --
3044: l_result :=
3045: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3046: ,l_assignment.assignment_id
3052: fnd_message.set_name('BEN'
3053: ,'BEN_92318_BEN_BALANCE_NULL');
3054: fnd_message.set_token('DATE'
3055: , l_effective_date);
3056: benutils.write(p_text=> fnd_message.get);
3057: RETURN ;
3058: --
3059: END IF;
3060: --
3067: IF l_hwf.rndg_cd IS NOT NULL
3068: OR l_hwf.rndg_rl IS NOT NULL THEN
3069: --
3070: l_result :=
3071: benutils.do_rounding(p_rounding_cd=> l_hwf.rndg_cd
3072: ,p_rounding_rl => l_hwf.rndg_rl
3073: ,p_value => l_result
3074: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3075: ,p_effective_date));
3178: if l_pff.rndg_cd is not null
3179: or l_pff.rndg_rl is not null then
3180: --
3181: l_result :=
3182: benutils.do_rounding(p_rounding_cd=> l_pff.rndg_cd
3183: ,p_rounding_rl => l_pff.rndg_rl
3184: ,p_value => l_result
3185: ,p_effective_date => l_effective_date);
3186: --