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_DERIVE_FACTORS dependencies on HR_UTILITY

Line 246: g_debug boolean := hr_utility.debug_enabled;

242: */
243: --------------------------------------------------------------------------------
244: --
245: g_package varchar2(30) := 'ben_derive_factors.';
246: g_debug boolean := hr_utility.debug_enabled;
247: --
248: procedure run_rule
249: (p_formula_id in number,
250: p_rule_type in varchar2 default 'NUMBER',

Line 279: hr_utility.set_location ('Entering '||l_package,10);

275: --
276: begin
277: --
278: if g_debug then
279: hr_utility.set_location ('Entering '||l_package,10);
280: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
281: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
282: end if;
283: --

Line 280: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

276: begin
277: --
278: if g_debug then
279: hr_utility.set_location ('Entering '||l_package,10);
280: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
281: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
282: end if;
283: --
284: if p_oipl_id is not null then

Line 281: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

277: --
278: if g_debug then
279: hr_utility.set_location ('Entering '||l_package,10);
280: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
281: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
282: end if;
283: --
284: if p_oipl_id is not null then
285: --

Line 394: hr_utility.set_location ('INVALID RULE TYPE PASSED'||l_package,99);

390: --
391: else
392: --
393: if g_debug then
394: hr_utility.set_location ('INVALID RULE TYPE PASSED'||l_package,99);
395: end if;
396: --
397: end if;
398: --

Line 400: hr_utility.set_location ('Leaving '||l_package,99);

396: --
397: end if;
398: --
399: if g_debug then
400: hr_utility.set_location ('Leaving '||l_package,99);
401: end if;
402: --
403: exception
404: --

Line 713: g_debug := hr_utility.debug_enabled;

709: l_comp_paid number;
710: l_comp_earned number;
711: BEGIN
712: --
713: g_debug := hr_utility.debug_enabled;
714: if g_debug then
715: hr_utility.set_location('Entering :'||l_proc,10);
716: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

Line 715: hr_utility.set_location('Entering :'||l_proc,10);

711: BEGIN
712: --
713: g_debug := hr_utility.debug_enabled;
714: if g_debug then
715: hr_utility.set_location('Entering :'||l_proc,10);
716: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
718: end if;
719: --

Line 716: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

712: --
713: g_debug := hr_utility.debug_enabled;
714: if g_debug then
715: hr_utility.set_location('Entering :'||l_proc,10);
716: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
718: end if;
719: --
720: if p_effective_date is null then

Line 717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

713: g_debug := hr_utility.debug_enabled;
714: if g_debug then
715: hr_utility.set_location('Entering :'||l_proc,10);
716: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
718: end if;
719: --
720: if p_effective_date is null then
721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

Line 859: hr_utility.set_location('l_date :'||l_date,450);

855: --
856: end if;
857: --
858: if g_debug then
859: hr_utility.set_location('l_date :'||l_date,450);
860: end if;
861: if g_debug then
862: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
863: end if;

Line 862: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);

858: if g_debug then
859: hr_utility.set_location('l_date :'||l_date,450);
860: end if;
861: if g_debug then
862: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
863: end if;
864: if g_debug then
865: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
866: end if;

Line 865: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);

861: if g_debug then
862: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
863: end if;
864: if g_debug then
865: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
866: end if;
867: if g_debug then
868: hr_utility.set_location('l_clf.bnfts_bal_id :'||l_clf.bnfts_bal_id,12);
869: end if;

Line 868: hr_utility.set_location('l_clf.bnfts_bal_id :'||l_clf.bnfts_bal_id,12);

864: if g_debug then
865: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
866: end if;
867: if g_debug then
868: hr_utility.set_location('l_clf.bnfts_bal_id :'||l_clf.bnfts_bal_id,12);
869: end if;
870: --
871: if l_clf.comp_calc_rl is not null then
872: --

Line 930: hr_utility.set_location('Inside OIC call',20);

926: end if;
927: --
928: elsif l_clf.comp_src_cd in ('OICAMTEARNED','OICAMTPAID') then
929:
930: hr_utility.set_location('Inside OIC call',20);
931: declare
932:
933: begin
934: l_start_date := to_date(l_clf.start_day_mo||nvl(l_clf.start_year,to_char(l_date,'YYYY')),'DDMMYYYY');

Line 974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);

970: ,x_comp_paid => l_comp_paid
971: ,x_new_start_date => l_dummy_date
972: ,x_new_end_date => l_dummy_date);
973:
974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);

Line 975: hr_utility.set_location('l_start_date = '||l_start_date, 999);

971: ,x_new_start_date => l_dummy_date
972: ,x_new_end_date => l_dummy_date);
973:
974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);

Line 976: hr_utility.set_location('l_end_date = '||l_end_date, 999);

972: ,x_new_end_date => l_dummy_date);
973:
974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
980: if l_ret_status in ('E','U') then

Line 977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);

973:
974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
980: if l_ret_status in ('E','U') then
981: -- Bug 4509422 : Even if the oic code errors still we need to

Line 978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);

974: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
980: if l_ret_status in ('E','U') then
981: -- Bug 4509422 : Even if the oic code errors still we need to
982: -- continue with 0 values populated to l_comp_earned, l_comp_paid

Line 979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);

975: hr_utility.set_location('l_start_date = '||l_start_date, 999);
976: hr_utility.set_location('l_end_date = '||l_end_date, 999);
977: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
978: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
979: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
980: if l_ret_status in ('E','U') then
981: -- Bug 4509422 : Even if the oic code errors still we need to
982: -- continue with 0 values populated to l_comp_earned, l_comp_paid
983: -- This is temp fix, once iic code is changed to handle no person data

Line 1006: hr_utility.set_location('null value returned ',20);

1002: end if;
1003: --
1004: IF l_value IS NULL THEN
1005: --
1006: hr_utility.set_location('null value returned ',20);
1007: return;
1008: --
1009: END IF;
1010: --

Line 1050: hr_utility.set_location('next date after det date is:'||l_date, 233);

1046: open c_ass_after_detdt;
1047: fetch c_ass_after_detdt into l_date;
1048: close c_ass_after_detdt;
1049: --
1050: hr_utility.set_location('next date after det date is:'||l_date, 233);
1051:
1052: --
1053: -- there is an assignment after the det dt, find the sal as of that date
1054: -- else, l_not_found would anyway remain true and it would call c_ass

Line 1059: hr_utility.set_location('l_salary with nxt dt is:'||l_salary.proposed_salary, 234);

1055:
1056: if l_date is not null then
1057: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1058: fetch c_stated_salary into l_salary;
1059: hr_utility.set_location('l_salary with nxt dt is:'||l_salary.proposed_salary, 234);
1060: if c_stated_salary%NOTFOUND then
1061: l_not_found := true;
1062: --
1063: else

Line 1070: hr_utility.set_location('no sal found - resort to old means:'||l_salary.proposed_salary, 234);

1066: close c_stated_salary;
1067: end if;
1068:
1069: if l_not_found then
1070: hr_utility.set_location('no sal found - resort to old means:'||l_salary.proposed_salary, 234);
1071: -- end 3752107
1072: open c_ass ;
1073: fetch c_ass into l_date ;
1074: close c_ass ;

Line 1075: hr_utility.set_location('min l_date is:'||l_date, 234);

1071: -- end 3752107
1072: open c_ass ;
1073: fetch c_ass into l_date ;
1074: close c_ass ;
1075: hr_utility.set_location('min l_date is:'||l_date, 234);
1076:
1077: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1078: fetch c_stated_salary into l_salary;
1079: hr_utility.set_location('l_salary with min dt is:'||l_salary.proposed_salary, 234);

Line 1079: hr_utility.set_location('l_salary with min dt is:'||l_salary.proposed_salary, 234);

1075: hr_utility.set_location('min l_date is:'||l_date, 234);
1076:
1077: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1078: fetch c_stated_salary into l_salary;
1079: hr_utility.set_location('l_salary with min dt is:'||l_salary.proposed_salary, 234);
1080: if c_stated_salary%NOTFOUND then
1081: -- then take current salary
1082: l_not_found := true;
1083: --

Line 1158: hr_utility.set_location('Primary flag'||l_primary_flag,100);

1154: --
1155: end if;
1156: --
1157: if g_debug then
1158: hr_utility.set_location('Primary flag'||l_primary_flag,100);
1159: end if;
1160: if g_debug then
1161: hr_utility.set_location('l_effective_date'||l_effective_date,101);
1162: end if;

Line 1161: hr_utility.set_location('l_effective_date'||l_effective_date,101);

1157: if g_debug then
1158: hr_utility.set_location('Primary flag'||l_primary_flag,100);
1159: end if;
1160: if g_debug then
1161: hr_utility.set_location('l_effective_date'||l_effective_date,101);
1162: end if;
1163: for i in c_stated_salary (l_primary_flag, null)
1164: loop
1165: --

Line 1170: hr_utility.set_location('Pay basis'|| i.pay_basis, 102);

1166: exit when l_salary.proposed_salary = 0;
1167: --
1168: if i.assignment_id <> l_assignment_id then
1169: if g_debug then
1170: hr_utility.set_location('Pay basis'|| i.pay_basis, 102);
1171: end if;
1172: if i.pay_basis is not null then
1173: --
1174: -- Assumption no multi assignment for annualization factor

Line 1259: hr_utility.set_location('l_clf.sttd_sal_prdcty_cd :'||l_clf.sttd_sal_prdcty_cd,18);

1255: --
1256: -- Per Week
1257: --
1258: if g_debug then
1259: hr_utility.set_location('l_clf.sttd_sal_prdcty_cd :'||l_clf.sttd_sal_prdcty_cd,18);
1260: end if;
1261: if l_clf.sttd_sal_prdcty_cd = 'PWK' then
1262: --
1263: l_value := l_value/52;

Line 1433: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);

1429: open c_ass ;
1430: fetch c_ass into l_date ;
1431: close c_ass ;
1432: if g_debug then
1433: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);
1434: end if;
1435: l_value := pay_balance_pkg.get_value
1436: (l_clf.defined_balance_id,
1437: l_assignment.assignment_id,

Line 1499: hr_utility.set_location( ' calc_bal_date ' || p_calc_bal_to_date,450) ;

1495: --
1496: else
1497: --
1498: if g_debug then
1499: hr_utility.set_location( ' calc_bal_date ' || p_calc_bal_to_date,450) ;
1500: end if;
1501: if g_debug then
1502: hr_utility.set_location( ' l_date ' || l_date,450) ;
1503: end if;

Line 1502: hr_utility.set_location( ' l_date ' || l_date,450) ;

1498: if g_debug then
1499: hr_utility.set_location( ' calc_bal_date ' || p_calc_bal_to_date,450) ;
1500: end if;
1501: if g_debug then
1502: hr_utility.set_location( ' l_date ' || l_date,450) ;
1503: end if;
1504: open c_person_balance(nvl(p_calc_bal_to_date,l_date));
1505: --
1506: fetch c_person_balance into l_person_balance;

Line 1541: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);

1537: open c_ass ;
1538: fetch c_ass into l_date ;
1539: close c_ass ;
1540: if g_debug then
1541: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);
1542: end if;
1543: open c_person_balance(l_date);
1544: --
1545: fetch c_person_balance into l_person_balance;

Line 1623: hr_utility.set_location('p_value :'||p_value,10);

1619: --
1620: end if;
1621: --
1622: if g_debug then
1623: hr_utility.set_location('p_value :'||p_value,10);
1624: end if;
1625: if g_debug then
1626: hr_utility.set_location('Leaving :'||l_proc,10);
1627: end if;

Line 1626: hr_utility.set_location('Leaving :'||l_proc,10);

1622: if g_debug then
1623: hr_utility.set_location('p_value :'||p_value,10);
1624: end if;
1625: if g_debug then
1626: hr_utility.set_location('Leaving :'||l_proc,10);
1627: end if;
1628: --
1629: exception
1630: --

Line 1841: g_debug := hr_utility.debug_enabled;

1837: --
1838: l_per_dob date;
1839: begin
1840: --
1841: g_debug := hr_utility.debug_enabled;
1842: if g_debug then
1843: hr_utility.set_location('Entering: '||l_proc,10);
1844: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1845: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

Line 1843: hr_utility.set_location('Entering: '||l_proc,10);

1839: begin
1840: --
1841: g_debug := hr_utility.debug_enabled;
1842: if g_debug then
1843: hr_utility.set_location('Entering: '||l_proc,10);
1844: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1845: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1846: end if;
1847: --

Line 1844: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

1840: --
1841: g_debug := hr_utility.debug_enabled;
1842: if g_debug then
1843: hr_utility.set_location('Entering: '||l_proc,10);
1844: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1845: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1846: end if;
1847: --
1848: l_per_dob := p_per_dob;

Line 1845: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

1841: g_debug := hr_utility.debug_enabled;
1842: if g_debug then
1843: hr_utility.set_location('Entering: '||l_proc,10);
1844: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1845: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1846: end if;
1847: --
1848: l_per_dob := p_per_dob;
1849: --

Line 1932: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);

1928: fnd_message.raise_error;
1929: end if;
1930: close c_agf;
1931: --
1932: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);
1933: -- hr_utility.set_location('p_person_id -> '||p_person_id,511);
1934: --
1935: if l_agf.age_to_use_cd = 'P' and l_agf.age_calc_rl is null then
1936: --

Line 1933: -- hr_utility.set_location('p_person_id -> '||p_person_id,511);

1929: end if;
1930: close c_agf;
1931: --
1932: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);
1933: -- hr_utility.set_location('p_person_id -> '||p_person_id,511);
1934: --
1935: if l_agf.age_to_use_cd = 'P' and l_agf.age_calc_rl is null then
1936: --
1937: -- Check if the date of birth is passed in

Line 1988: hr_utility.set_location(l_per.date_of_birth,10);

1984: --End RCHASE
1985: end if;
1986: --
1987: if g_debug then
1988: hr_utility.set_location(l_per.date_of_birth,10);
1989: end if;
1990: --
1991: elsif l_agf.age_to_use_cd = 'PS' then
1992: --

Line 2127: -- hr_utility.set_location('l_per.date_of_birth -> '||l_per.date_of_birth ,511);

2123: end if;
2124: --
2125: end if;
2126: --
2127: -- hr_utility.set_location('l_per.date_of_birth -> '||l_per.date_of_birth ,511);
2128: -- hr_utility.set_location('l_agf.age_det_cd -> '||l_agf.age_det_cd,511);
2129: --
2130: if l_agf.age_to_use_cd <> 'IA' or l_agf.age_calc_rl is not null then
2131: --

Line 2128: -- hr_utility.set_location('l_agf.age_det_cd -> '||l_agf.age_det_cd,511);

2124: --
2125: end if;
2126: --
2127: -- hr_utility.set_location('l_per.date_of_birth -> '||l_per.date_of_birth ,511);
2128: -- hr_utility.set_location('l_agf.age_det_cd -> '||l_agf.age_det_cd,511);
2129: --
2130: if l_agf.age_to_use_cd <> 'IA' or l_agf.age_calc_rl is not null then
2131: --
2132: ben_determine_date.main

Line 2162: hr_utility.set_location('DOB'||l_per.date_of_birth,10);

2158: --
2159: -- Calculate in form of UOM
2160: --
2161: if g_debug then
2162: hr_utility.set_location('DOB'||l_per.date_of_birth,10);
2163: end if;
2164: if g_debug then
2165: hr_utility.set_location('DATE'||l_date,10);
2166: end if;

Line 2165: hr_utility.set_location('DATE'||l_date,10);

2161: if g_debug then
2162: hr_utility.set_location('DOB'||l_per.date_of_birth,10);
2163: end if;
2164: if g_debug then
2165: hr_utility.set_location('DATE'||l_date,10);
2166: end if;
2167: if l_agf.age_uom = 'YR' then
2168: l_value := months_between(l_date,l_per.date_of_birth)/12;
2169: elsif l_agf.age_uom = 'MO' then

Line 2197: hr_utility.set_location('VALUE is '||l_value,10);

2193: --
2194: end if;
2195: --
2196: if g_debug then
2197: hr_utility.set_location('VALUE is '||l_value,10);
2198: end if;
2199: -- perform appropriate rounding based on the source table.
2200: -- rounding_cd or rule cannot both be null, perform_rounding_flag
2201: -- must be true....

Line 2220: hr_utility.set_location('Leaving: '||l_proc,10);

2216: --
2217: end if;
2218: --
2219: if g_debug then
2220: hr_utility.set_location('Leaving: '||l_proc,10);
2221: end if;
2222: --
2223: exception
2224: --

Line 2336: g_debug := hr_utility.debug_enabled;

2332: --
2333: l_person_extra c_person_extra%rowtype;
2334: --
2335: begin
2336: g_debug := hr_utility.debug_enabled;
2337: if g_debug then
2338: hr_utility.set_location('Entering: '||l_proc,10);
2339: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2340: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

Line 2338: hr_utility.set_location('Entering: '||l_proc,10);

2334: --
2335: begin
2336: g_debug := hr_utility.debug_enabled;
2337: if g_debug then
2338: hr_utility.set_location('Entering: '||l_proc,10);
2339: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2340: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2341:
2342: end if;

Line 2339: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

2335: begin
2336: g_debug := hr_utility.debug_enabled;
2337: if g_debug then
2338: hr_utility.set_location('Entering: '||l_proc,10);
2339: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2340: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2341:
2342: end if;
2343: if p_effective_date is null then

Line 2340: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

2336: g_debug := hr_utility.debug_enabled;
2337: if g_debug then
2338: hr_utility.set_location('Entering: '||l_proc,10);
2339: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2340: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2341:
2342: end if;
2343: if p_effective_date is null then
2344: if g_debug then

Line 2345: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

2341:
2342: end if;
2343: if p_effective_date is null then
2344: if g_debug then
2345: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2346: end if;
2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');

Line 2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;
2352: elsif p_person_id is null then
2353: if g_debug then
2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2355: end if;
2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');

Line 2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;
2361: elsif p_los_fctr_id is null then
2362: if g_debug then
2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2364: end if;
2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');

Line 2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;
2370: elsif p_business_group_id is null then
2371: if g_debug then
2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2373: end if;
2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');

Line 2384: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);

2380: --
2381: /*
2382: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
2383: if g_debug then
2384: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2385: end if;
2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);

Line 2421: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);

2417: fetch c_lsf into l_lsf;
2418: if c_lsf%notfound then
2419: close c_lsf;
2420: if g_debug then
2421: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2422: end if;
2423: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2424: fnd_message.set_token('PACKAGE',l_proc);
2425: fnd_message.set_token('CURSOR','c_lsf');

Line 2455: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);

2451: fetch c_person into l_person;
2452: if c_person%notfound then
2453: close c_person;
2454: if g_debug then
2455: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2456: end if;
2457: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2458: fnd_message.set_token('PACKAGE',l_proc);
2459: fnd_message.set_token('CURSOR','c_person');

Line 2568: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);

2564: p_fonm_cvg_strt_dt => p_fonm_cvg_strt_dt,
2565: p_fonm_rt_strt_dt => p_fonm_rt_strt_dt);
2566: else
2567: if g_debug then
2568: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2569: end if;
2570: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2571: fnd_message.set_token('PROC',l_proc);
2572: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);

Line 2626: hr_utility.set_location('Leaving: '||l_proc,99);

2622: p_value := l_value;
2623: end if;
2624: end if;
2625: if g_debug then
2626: hr_utility.set_location('Leaving: '||l_proc,99);
2627: end if;
2628: exception
2629: --
2630: when others then

Line 2675: g_debug := hr_utility.debug_enabled;

2671: l_cla_elig1 c_cla_elig1%rowtype;
2672: --
2673: begin
2674: --
2675: g_debug := hr_utility.debug_enabled;
2676: if g_debug then
2677: hr_utility.set_location ('Entering '||l_proc,10);
2678: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2679: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

Line 2677: hr_utility.set_location ('Entering '||l_proc,10);

2673: begin
2674: --
2675: g_debug := hr_utility.debug_enabled;
2676: if g_debug then
2677: hr_utility.set_location ('Entering '||l_proc,10);
2678: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2679: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2680: end if;
2681: --

Line 2678: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

2674: --
2675: g_debug := hr_utility.debug_enabled;
2676: if g_debug then
2677: hr_utility.set_location ('Entering '||l_proc,10);
2678: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2679: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2680: end if;
2681: --
2682: open c_cla_elig1;

Line 2679: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

2675: g_debug := hr_utility.debug_enabled;
2676: if g_debug then
2677: hr_utility.set_location ('Entering '||l_proc,10);
2678: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2679: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2680: end if;
2681: --
2682: open c_cla_elig1;
2683: --

Line 2738: hr_utility.set_location('Leaving: '||l_proc,10);

2734: l_result := l_age_val + l_los_val;
2735: p_value := l_result;
2736: --
2737: if g_debug then
2738: hr_utility.set_location('Leaving: '||l_proc,10);
2739: end if;
2740: --
2741: exception
2742: --

Line 2821: hr_utility.set_location('Entering ' || l_package,10);

2817: --
2818: BEGIN
2819: --
2820: if g_debug then
2821: hr_utility.set_location('Entering ' || l_package,10);
2822: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2823: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2824: end if;
2825:

Line 2822: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

2818: BEGIN
2819: --
2820: if g_debug then
2821: hr_utility.set_location('Entering ' || l_package,10);
2822: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2823: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2824: end if;
2825:
2826: -- tilak : new fonm paramter passes the value no more overring the dates

Line 2823: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

2819: --
2820: if g_debug then
2821: hr_utility.set_location('Entering ' || l_package,10);
2822: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2823: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2824: end if;
2825:
2826: -- tilak : new fonm paramter passes the value no more overring the dates
2827: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);

Line 2866: hr_utility.set_location('l_hwf.hrs_src_cd '||l_hwf.hrs_src_cd ,20);

2862: ,p_fonm_rt_strt_dt => p_fonm_rt_strt_dt
2863: );
2864: --
2865: if g_debug then
2866: hr_utility.set_location('l_hwf.hrs_src_cd '||l_hwf.hrs_src_cd ,20);
2867: end if;
2868: IF l_hwf.hrs_src_cd = 'BNFTBALTYP' THEN
2869: --
2870: IF ben_whatif_elig.g_bnft_bal_hwf_val IS NOT NULL THEN

Line 2883: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);

2879: ELSE
2880: --
2881: -- Get the persons balance
2882: if g_debug then
2883: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
2884: hr_utility.set_location(' p_person_id '||p_person_id , 30);
2885: hr_utility.set_location(' l_start_date '||l_start_date, 30);
2886: end if;
2887: --

Line 2884: hr_utility.set_location(' p_person_id '||p_person_id , 30);

2880: --
2881: -- Get the persons balance
2882: if g_debug then
2883: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
2884: hr_utility.set_location(' p_person_id '||p_person_id , 30);
2885: hr_utility.set_location(' l_start_date '||l_start_date, 30);
2886: end if;
2887: --
2888: ben_person_object.get_object(p_person_id=> p_person_id

Line 2885: hr_utility.set_location(' l_start_date '||l_start_date, 30);

2881: -- Get the persons balance
2882: if g_debug then
2883: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
2884: hr_utility.set_location(' p_person_id '||p_person_id , 30);
2885: hr_utility.set_location(' l_start_date '||l_start_date, 30);
2886: end if;
2887: --
2888: ben_person_object.get_object(p_person_id=> p_person_id
2889: ,p_effective_date => l_start_date

Line 2905: hr_utility.set_location('l_min_ass_date ' || l_min_ass_date,19);

2901: fetch c_ass into l_min_ass_date ;
2902: close c_ass ;
2903:
2904: if g_debug then
2905: hr_utility.set_location('l_min_ass_date ' || l_min_ass_date,19);
2906: end if;
2907: if l_min_ass_date is not null then
2908: ben_person_object.get_object(p_person_id=> p_person_id
2909: ,p_effective_date => l_min_ass_date

Line 2922: hr_utility.set_location(' Person does not have a balance ',40);

2918:
2919: IF l_result IS NULL THEN
2920: --
2921: if g_debug then
2922: hr_utility.set_location(' Person does not have a balance ',40);
2923: end if;
2924: --
2925: -- Person does not have a balance, recheck if they have a balance
2926: -- as of the life event occurred date or effective date.

Line 2948: hr_utility.set_location(' Person does not l_bal_rec.val '||l_bal_rec.val ,50);

2944: ,p_rec => l_bal_rec);
2945: --
2946: l_result := l_bal_rec.val;
2947: if g_debug then
2948: hr_utility.set_location(' Person does not l_bal_rec.val '||l_bal_rec.val ,50);
2949: end if;
2950: --
2951: IF l_result IS NULL THEN
2952: --

Line 3021: hr_utility.set_location (' l_min_ass_date ' || l_min_ass_date, 1999);

3017: open c_ass ;
3018: fetch c_ass into l_min_ass_date ;
3019: close c_ass ;
3020: if g_debug then
3021: hr_utility.set_location (' l_min_ass_date ' || l_min_ass_date, 1999);
3022: end if;
3023: l_result :=
3024: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3025: ,l_assignment.assignment_id

Line 3082: hr_utility.set_location(' End of hours_calculation l_result '||l_result, 50);

3078: --
3079: p_value := l_result;
3080:
3081: if g_debug then
3082: hr_utility.set_location(' End of hours_calculation l_result '||l_result, 50);
3083: end if;
3084: --
3085: --
3086: end determine_hours_worked;

Line 3132: hr_utility.set_location('Entering ' || l_package,10);

3128: l_pff c_pff%rowtype;
3129:
3130: begin
3131: --
3132: hr_utility.set_location('Entering ' || l_package,10);
3133: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3134: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3135: --
3136: -- tilak : new fonm paramter passes the value no more overring the dates

Line 3133: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);

3129:
3130: begin
3131: --
3132: hr_utility.set_location('Entering ' || l_package,10);
3133: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3134: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3135: --
3136: -- tilak : new fonm paramter passes the value no more overring the dates
3137: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);

Line 3134: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

3130: begin
3131: --
3132: hr_utility.set_location('Entering ' || l_package,10);
3133: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3134: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3135: --
3136: -- tilak : new fonm paramter passes the value no more overring the dates
3137: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);
3138: --

Line 3194: hr_utility.set_location('Leaving ' || l_package,10);

3190:
3191: p_value := l_result;
3192:
3193: if g_debug then
3194: hr_utility.set_location('Leaving ' || l_package,10);
3195: end if;
3196: --
3197: end determine_pct_fulltime;
3198: end ben_derive_factors;