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 261: g_debug boolean := hr_utility.debug_enabled;

257: */
258: --------------------------------------------------------------------------------
259: --
260: g_package varchar2(30) := 'ben_derive_factors.';
261: g_debug boolean := hr_utility.debug_enabled;
262: --
263: procedure run_rule
264: (p_formula_id in number,
265: p_rule_type in varchar2 default 'NUMBER',

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

290: --
291: begin
292: --
293: if g_debug then
294: hr_utility.set_location ('Entering '||l_package,10);
295: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
296: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
297: end if;
298: --

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

291: begin
292: --
293: if g_debug then
294: hr_utility.set_location ('Entering '||l_package,10);
295: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
296: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
297: end if;
298: --
299: if p_oipl_id is not null then

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

292: --
293: if g_debug then
294: hr_utility.set_location ('Entering '||l_package,10);
295: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
296: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
297: end if;
298: --
299: if p_oipl_id is not null then
300: --

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

405: --
406: else
407: --
408: if g_debug then
409: hr_utility.set_location ('INVALID RULE TYPE PASSED'||l_package,99);
410: end if;
411: --
412: end if;
413: --

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

411: --
412: end if;
413: --
414: if g_debug then
415: hr_utility.set_location ('Leaving '||l_package,99);
416: end if;
417: --
418: exception
419: --

Line 777: g_debug := hr_utility.debug_enabled;

773: l_comp_paid number;
774: l_comp_earned number;
775: BEGIN
776: --
777: g_debug := hr_utility.debug_enabled;
778: if g_debug then
779: hr_utility.set_location('Entering :'||l_proc,10);
780: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
781: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

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

775: BEGIN
776: --
777: g_debug := hr_utility.debug_enabled;
778: if g_debug then
779: hr_utility.set_location('Entering :'||l_proc,10);
780: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
781: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
782: end if;
783: --

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

776: --
777: g_debug := hr_utility.debug_enabled;
778: if g_debug then
779: hr_utility.set_location('Entering :'||l_proc,10);
780: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
781: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
782: end if;
783: --
784: if p_effective_date is null then

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

777: g_debug := hr_utility.debug_enabled;
778: if g_debug then
779: hr_utility.set_location('Entering :'||l_proc,10);
780: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
781: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
782: end if;
783: --
784: if p_effective_date is null then
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

919: --
920: end if;
921: --
922: if g_debug then
923: hr_utility.set_location('l_date :'||l_date,450);
924: end if;
925: if g_debug then
926: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
927: end if;

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

922: if g_debug then
923: hr_utility.set_location('l_date :'||l_date,450);
924: end if;
925: if g_debug then
926: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
927: end if;
928: if g_debug then
929: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
930: end if;

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

925: if g_debug then
926: hr_utility.set_location('l_clf.comp_src_cd :'||l_clf.comp_src_cd,12);
927: end if;
928: if g_debug then
929: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
930: end if;
931: if g_debug then
932: hr_utility.set_location('l_clf.bnfts_bal_id :'||l_clf.bnfts_bal_id,12);
933: end if;

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

928: if g_debug then
929: hr_utility.set_location('p_comp_lvl_fctr_id :'||p_comp_lvl_fctr_id,12);
930: end if;
931: if g_debug then
932: hr_utility.set_location('l_clf.bnfts_bal_id :'||l_clf.bnfts_bal_id,12);
933: end if;
934: --Start Bug 14456969
935: /*
936: If an employee is terminated and re-hired, the l_date should be reset to

Line 943: hr_utility.set_location('Latest Termination Date is '||l_per_lst_term_dt,1178);

939: open c_per_lst_term_dt;
940: fetch c_per_lst_term_dt into l_per_lst_term_dt;
941: close c_per_lst_term_dt;
942: if l_per_lst_term_dt is not null then
943: hr_utility.set_location('Latest Termination Date is '||l_per_lst_term_dt,1178);
944:
945: open c_per_lst_hire_dt;
946: fetch c_per_lst_hire_dt into l_per_lst_hire_dt;
947: close c_per_lst_hire_dt;

Line 949: hr_utility.set_location('Latest Hire Date is '||l_per_lst_hire_dt,1179);

945: open c_per_lst_hire_dt;
946: fetch c_per_lst_hire_dt into l_per_lst_hire_dt;
947: close c_per_lst_hire_dt;
948:
949: hr_utility.set_location('Latest Hire Date is '||l_per_lst_hire_dt,1179);
950: l_date := l_per_lst_hire_dt;
951: end if;
952:
953: --End Bug 14456969

Line 979: hr_utility.set_location('l_value :'||l_value,1171);--Bug 14161081

975: l_value will never return null as the mandatory return parameter is number
976: So, instead of null decided to check for a -ve number so as to decide
977: whether any compnsation value is returned or not
978: */
979: hr_utility.set_location('l_value :'||l_value,1171);--Bug 14161081
980: /*Start AMN Bug 14161081: If the assignment exists as of the current determination date
981: then reset the value from -1 to 0 so as to skip the re-evaluation
982: */
983: if l_value < 0 then

Line 988: hr_utility.set_location('c_exists_ass_as_of_detdt%FOUND',1172);

984: open c_exists_ass_as_of_detdt;
985: fetch c_exists_ass_as_of_detdt into l_exists_ass_as_of_detdt;
986: if c_exists_ass_as_of_detdt%FOUND then
987: l_value := 0;
988: hr_utility.set_location('c_exists_ass_as_of_detdt%FOUND',1172);
989: hr_utility.set_location('l_value reseted to :'||l_value,1173);
990: end if;
991: close c_exists_ass_as_of_detdt;
992: end if;

Line 989: hr_utility.set_location('l_value reseted to :'||l_value,1173);

985: fetch c_exists_ass_as_of_detdt into l_exists_ass_as_of_detdt;
986: if c_exists_ass_as_of_detdt%FOUND then
987: l_value := 0;
988: hr_utility.set_location('c_exists_ass_as_of_detdt%FOUND',1172);
989: hr_utility.set_location('l_value reseted to :'||l_value,1173);
990: end if;
991: close c_exists_ass_as_of_detdt;
992: end if;
993: --End Bug 14161081

Line 995: hr_utility.set_location('l_value :'||l_value,1174);--Bug 14161081

991: close c_exists_ass_as_of_detdt;
992: end if;
993: --End Bug 14161081
994: --
995: hr_utility.set_location('l_value :'||l_value,1174);--Bug 14161081
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);

Line 1008: hr_utility.set_location('Executing the rule with the new dt date :'||l_date,1175);

1004: -- then take the first salary
1005: open c_ass_after_detdt;
1006: fetch c_ass_after_detdt into l_date;
1007: close c_ass_after_detdt;
1008: hr_utility.set_location('Executing the rule with the new dt date :'||l_date,1175);
1009: --End AMN Bug 14161081
1010: if l_date is not null then
1011: run_rule
1012: (p_formula_id => l_clf.comp_calc_rl,

Line 1028: hr_utility.set_location('New date l_value :'||l_value,1176);

1024: p_fonm_cvg_strt_dt => p_fonm_cvg_strt_dt,
1025: p_fonm_rt_strt_dt => p_fonm_rt_strt_dt);
1026: --
1027: l_value := p_value;
1028: hr_utility.set_location('New date l_value :'||l_value,1176);
1029: else
1030: hr_utility.set_location('New Date is Null: Resetting the Value to -1',1177);
1031: l_value := -1;
1032: end if;

Line 1030: hr_utility.set_location('New Date is Null: Resetting the Value to -1',1177);

1026: --
1027: l_value := p_value;
1028: hr_utility.set_location('New date l_value :'||l_value,1176);
1029: else
1030: hr_utility.set_location('New Date is Null: Resetting the Value to -1',1177);
1031: l_value := -1;
1032: end if;
1033: --
1034: IF l_value IS NULL or l_value < 0 THEN--Bug 14161081

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

1044: end if;
1045: --
1046: elsif l_clf.comp_src_cd in ('OICAMTEARNED','OICAMTPAID') then
1047:
1048: hr_utility.set_location('Inside OIC call',20);
1049: declare
1050:
1051: begin
1052: l_start_date := to_date(l_clf.start_day_mo||nvl(l_clf.start_year,to_char(l_date,'YYYY')),'DDMMYYYY');

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

1088: ,x_comp_paid => l_comp_paid
1089: ,x_new_start_date => l_dummy_date
1090: ,x_new_end_date => l_dummy_date);
1091:
1092: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);

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

1089: ,x_new_start_date => l_dummy_date
1090: ,x_new_end_date => l_dummy_date);
1091:
1092: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
1097: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);

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

1090: ,x_new_end_date => l_dummy_date);
1091:
1092: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
1097: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
1098: if l_ret_status in ('E','U') then

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

1091:
1092: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
1097: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
1098: if l_ret_status in ('E','U') then
1099: -- Bug 4509422 : Even if the oic code errors still we need to

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

1092: hr_utility.set_location('msg = '||substr(l_msg_data,1,100), 999);
1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
1097: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
1098: if l_ret_status in ('E','U') then
1099: -- Bug 4509422 : Even if the oic code errors still we need to
1100: -- continue with 0 values populated to l_comp_earned, l_comp_paid

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

1093: hr_utility.set_location('l_start_date = '||l_start_date, 999);
1094: hr_utility.set_location('l_end_date = '||l_end_date, 999);
1095: hr_utility.set_location('l_clf.comp_lvl_uom = '||l_clf.comp_lvl_uom, 999);
1096: hr_utility.set_location('l_clf.proration_flag = '||l_clf.proration_flag, 999);
1097: hr_utility.set_location('l_msg_count = '||l_msg_count, 999);
1098: if l_ret_status in ('E','U') then
1099: -- Bug 4509422 : Even if the oic code errors still we need to
1100: -- continue with 0 values populated to l_comp_earned, l_comp_paid
1101: -- This is temp fix, once iic code is changed to handle no person data

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

1120: end if;
1121: --
1122: IF l_value IS NULL THEN
1123: --
1124: hr_utility.set_location('null value returned ',20);
1125: return;
1126: --
1127: END IF;
1128: --

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

1164: open c_ass_after_detdt;
1165: fetch c_ass_after_detdt into l_date;
1166: close c_ass_after_detdt;
1167: --
1168: hr_utility.set_location('next date after det date is:'||l_date, 233);
1169:
1170: --
1171: -- there is an assignment after the det dt, find the sal as of that date
1172: -- else, l_not_found would anyway remain true and it would call c_ass

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

1173:
1174: if l_date is not null then
1175: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1176: fetch c_stated_salary into l_salary;
1177: hr_utility.set_location('l_salary with nxt dt is:'||l_salary.proposed_salary, 234);
1178: if c_stated_salary%NOTFOUND then
1179: l_not_found := true;
1180: --
1181: else

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

1184: close c_stated_salary;
1185: end if;
1186:
1187: if l_not_found then
1188: hr_utility.set_location('no sal found - resort to old means:'||l_salary.proposed_salary, 234);
1189: -- end 3752107
1190: open c_ass ;
1191: fetch c_ass into l_date ;
1192: close c_ass ;

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

1189: -- end 3752107
1190: open c_ass ;
1191: fetch c_ass into l_date ;
1192: close c_ass ;
1193: hr_utility.set_location('min l_date is:'||l_date, 234);
1194:
1195: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1196: fetch c_stated_salary into l_salary;
1197: hr_utility.set_location('l_salary with min dt is:'||l_salary.proposed_salary, 234);

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

1193: hr_utility.set_location('min l_date is:'||l_date, 234);
1194:
1195: open c_stated_salary (l_primary_flag, l_assignment.assignment_id);
1196: fetch c_stated_salary into l_salary;
1197: hr_utility.set_location('l_salary with min dt is:'||l_salary.proposed_salary, 234);
1198: if c_stated_salary%NOTFOUND then
1199: -- then take current salary
1200: l_not_found := true;
1201: --

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

1272: --
1273: end if;
1274: --
1275: if g_debug then
1276: hr_utility.set_location('Primary flag'||l_primary_flag,100);
1277: end if;
1278: if g_debug then
1279: hr_utility.set_location('l_effective_date'||l_effective_date,101);
1280: end if;

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

1275: if g_debug then
1276: hr_utility.set_location('Primary flag'||l_primary_flag,100);
1277: end if;
1278: if g_debug then
1279: hr_utility.set_location('l_effective_date'||l_effective_date,101);
1280: end if;
1281: for i in c_stated_salary (l_primary_flag, null)
1282: loop
1283: --

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

1284: exit when l_salary.proposed_salary = 0;
1285: --
1286: if i.assignment_id <> l_assignment_id then
1287: if g_debug then
1288: hr_utility.set_location('Pay basis'|| i.pay_basis, 102);
1289: end if;
1290: if i.pay_basis is not null then
1291: --
1292: -- Assumption no multi assignment for annualization factor

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

1373: --
1374: -- Per Week
1375: --
1376: if g_debug then
1377: hr_utility.set_location('l_clf.sttd_sal_prdcty_cd :'||l_clf.sttd_sal_prdcty_cd,18);
1378: end if;
1379: if l_clf.sttd_sal_prdcty_cd = 'PWK' then
1380: --
1381: l_value := l_value/52;

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

1547: open c_ass ;
1548: fetch c_ass into l_date ;
1549: close c_ass ;
1550: if g_debug then
1551: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);
1552: end if;
1553: l_value := pay_balance_pkg.get_value
1554: (l_clf.defined_balance_id,
1555: l_assignment.assignment_id,

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

1613: --
1614: else
1615: --
1616: if g_debug then
1617: hr_utility.set_location( ' calc_bal_date ' || p_calc_bal_to_date,450) ;
1618: end if;
1619: if g_debug then
1620: hr_utility.set_location( ' l_date ' || l_date,450) ;
1621: end if;

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

1616: if g_debug then
1617: hr_utility.set_location( ' calc_bal_date ' || p_calc_bal_to_date,450) ;
1618: end if;
1619: if g_debug then
1620: hr_utility.set_location( ' l_date ' || l_date,450) ;
1621: end if;
1622: open c_person_balance(nvl(p_calc_bal_to_date,l_date));
1623: --
1624: fetch c_person_balance into l_person_balance;

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

1655: open c_ass ;
1656: fetch c_ass into l_date ;
1657: close c_ass ;
1658: if g_debug then
1659: hr_utility.set_location( ' in first of year ' || l_clf.comp_lvl_det_cd || l_date, 450);
1660: end if;
1661: open c_person_balance(l_date);
1662: --
1663: fetch c_person_balance into l_person_balance;

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

1737: --
1738: end if;
1739: --
1740: if g_debug then
1741: hr_utility.set_location('p_value :'||p_value,10);
1742: end if;
1743: if g_debug then
1744: hr_utility.set_location('Leaving :'||l_proc,10);
1745: end if;

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

1740: if g_debug then
1741: hr_utility.set_location('p_value :'||p_value,10);
1742: end if;
1743: if g_debug then
1744: hr_utility.set_location('Leaving :'||l_proc,10);
1745: end if;
1746: --
1747: exception
1748: --

Line 1959: g_debug := hr_utility.debug_enabled;

1955: --
1956: l_per_dob date;
1957: begin
1958: --
1959: g_debug := hr_utility.debug_enabled;
1960: if g_debug then
1961: hr_utility.set_location('Entering: '||l_proc,10);
1962: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1963: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

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

1957: begin
1958: --
1959: g_debug := hr_utility.debug_enabled;
1960: if g_debug then
1961: hr_utility.set_location('Entering: '||l_proc,10);
1962: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1963: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1964: end if;
1965: --

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

1958: --
1959: g_debug := hr_utility.debug_enabled;
1960: if g_debug then
1961: hr_utility.set_location('Entering: '||l_proc,10);
1962: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1963: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1964: end if;
1965: --
1966: l_per_dob := p_per_dob;

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

1959: g_debug := hr_utility.debug_enabled;
1960: if g_debug then
1961: hr_utility.set_location('Entering: '||l_proc,10);
1962: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
1963: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
1964: end if;
1965: --
1966: l_per_dob := p_per_dob;
1967: --

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

2048: fnd_message.raise_error;
2049: end if;
2050: close c_agf;
2051: --
2052: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);
2053: -- hr_utility.set_location('p_person_id -> '||p_person_id,511);
2054: --
2055: if l_agf.age_to_use_cd = 'P' and l_agf.age_calc_rl is null then
2056: --

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

2049: end if;
2050: close c_agf;
2051: --
2052: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);
2053: -- hr_utility.set_location('p_person_id -> '||p_person_id,511);
2054: --
2055: if l_agf.age_to_use_cd = 'P' and l_agf.age_calc_rl is null then
2056: --
2057: -- Check if the date of birth is passed in

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

2104: --End RCHASE
2105: end if;
2106: --
2107: if g_debug then
2108: hr_utility.set_location(l_per.date_of_birth,10);
2109: end if;
2110: --
2111: elsif l_agf.age_to_use_cd = 'PS' then
2112: --

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

2243: end if;
2244: --
2245: end if;
2246: --
2247: -- hr_utility.set_location('l_per.date_of_birth -> '||l_per.date_of_birth ,511);
2248: -- hr_utility.set_location('l_agf.age_det_cd -> '||l_agf.age_det_cd,511);
2249: --
2250: if l_agf.age_to_use_cd <> 'IA' or l_agf.age_calc_rl is not null then
2251: --

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

2244: --
2245: end if;
2246: --
2247: -- hr_utility.set_location('l_per.date_of_birth -> '||l_per.date_of_birth ,511);
2248: -- hr_utility.set_location('l_agf.age_det_cd -> '||l_agf.age_det_cd,511);
2249: --
2250: if l_agf.age_to_use_cd <> 'IA' or l_agf.age_calc_rl is not null then
2251: --
2252: ben_determine_date.main

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

2278: --
2279: -- Calculate in form of UOM
2280: --
2281: if g_debug then
2282: hr_utility.set_location('DOB'||l_per.date_of_birth,10);
2283: end if;
2284: if g_debug then
2285: hr_utility.set_location('DATE'||l_date,10);
2286: end if;

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

2281: if g_debug then
2282: hr_utility.set_location('DOB'||l_per.date_of_birth,10);
2283: end if;
2284: if g_debug then
2285: hr_utility.set_location('DATE'||l_date,10);
2286: end if;
2287: if l_agf.age_uom = 'YR' then
2288: l_value := months_between(l_date,l_per.date_of_birth)/12;
2289: elsif l_agf.age_uom = 'MO' then

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

2313: --
2314: end if;
2315: --
2316: if g_debug then
2317: hr_utility.set_location('VALUE is '||l_value,10);
2318: end if;
2319: -- perform appropriate rounding based on the source table.
2320: -- rounding_cd or rule cannot both be null, perform_rounding_flag
2321: -- must be true....

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

2336: --
2337: end if;
2338: --
2339: if g_debug then
2340: hr_utility.set_location('Leaving: '||l_proc,10);
2341: end if;
2342: --
2343: exception
2344: --

Line 2456: g_debug := hr_utility.debug_enabled;

2452: --
2453: l_person_extra c_person_extra%rowtype;
2454: --
2455: begin
2456: g_debug := hr_utility.debug_enabled;
2457: if g_debug then
2458: hr_utility.set_location('Entering: '||l_proc,10);
2459: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2460: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

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

2454: --
2455: begin
2456: g_debug := hr_utility.debug_enabled;
2457: if g_debug then
2458: hr_utility.set_location('Entering: '||l_proc,10);
2459: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2460: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2461:
2462: end if;

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

2455: begin
2456: g_debug := hr_utility.debug_enabled;
2457: if g_debug then
2458: hr_utility.set_location('Entering: '||l_proc,10);
2459: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2460: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2461:
2462: end if;
2463: if p_effective_date is null then

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

2456: g_debug := hr_utility.debug_enabled;
2457: if g_debug then
2458: hr_utility.set_location('Entering: '||l_proc,10);
2459: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2460: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2461:
2462: end if;
2463: if p_effective_date is null then
2464: if g_debug then

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

2461:
2462: end if;
2463: if p_effective_date is null then
2464: if g_debug then
2465: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2466: end if;
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');

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

2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2472: elsif p_person_id is null then
2473: if g_debug then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');

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

2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2481: elsif p_los_fctr_id is null then
2482: if g_debug then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2484: end if;
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');

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

2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2490: elsif p_business_group_id is null then
2491: if g_debug then
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2493: end if;
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');

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

2500: --
2501: /*
2502: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
2503: if g_debug then
2504: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2505: end if;
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);

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

2538: fetch c_lsf into l_lsf;
2539: if c_lsf%notfound then
2540: close c_lsf;
2541: if g_debug then
2542: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2543: end if;
2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2545: fnd_message.set_token('PACKAGE',l_proc);
2546: fnd_message.set_token('CURSOR','c_lsf');

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

2572: fetch c_person into l_person;
2573: if c_person%notfound then
2574: close c_person;
2575: if g_debug then
2576: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2577: end if;
2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2579: fnd_message.set_token('PACKAGE',l_proc);
2580: fnd_message.set_token('CURSOR','c_person');

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

2685: p_fonm_cvg_strt_dt => p_fonm_cvg_strt_dt,
2686: p_fonm_rt_strt_dt => p_fonm_rt_strt_dt);
2687: else
2688: if g_debug then
2689: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2690: end if;
2691: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2692: fnd_message.set_token('PROC',l_proc);
2693: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);

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

2743: p_value := l_value;
2744: end if;
2745: end if;
2746: if g_debug then
2747: hr_utility.set_location('Leaving: '||l_proc,99);
2748: end if;
2749: exception
2750: --
2751: when others then

Line 2796: g_debug := hr_utility.debug_enabled;

2792: l_cla_elig1 c_cla_elig1%rowtype;
2793: --
2794: begin
2795: --
2796: g_debug := hr_utility.debug_enabled;
2797: if g_debug then
2798: hr_utility.set_location ('Entering '||l_proc,10);
2799: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2800: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);

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

2794: begin
2795: --
2796: g_debug := hr_utility.debug_enabled;
2797: if g_debug then
2798: hr_utility.set_location ('Entering '||l_proc,10);
2799: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2800: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2801: end if;
2802: --

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

2795: --
2796: g_debug := hr_utility.debug_enabled;
2797: if g_debug then
2798: hr_utility.set_location ('Entering '||l_proc,10);
2799: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2800: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2801: end if;
2802: --
2803: open c_cla_elig1;

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

2796: g_debug := hr_utility.debug_enabled;
2797: if g_debug then
2798: hr_utility.set_location ('Entering '||l_proc,10);
2799: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2800: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2801: end if;
2802: --
2803: open c_cla_elig1;
2804: --

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

2855: l_result := l_age_val + l_los_val;
2856: p_value := l_result;
2857: --
2858: if g_debug then
2859: hr_utility.set_location('Leaving: '||l_proc,10);
2860: end if;
2861: --
2862: exception
2863: --

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

2938: --
2939: BEGIN
2940: --
2941: if g_debug then
2942: hr_utility.set_location('Entering ' || l_package,10);
2943: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2944: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2945: end if;
2946:

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

2939: BEGIN
2940: --
2941: if g_debug then
2942: hr_utility.set_location('Entering ' || l_package,10);
2943: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2944: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2945: end if;
2946:
2947: -- tilak : new fonm paramter passes the value no more overring the dates

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

2940: --
2941: if g_debug then
2942: hr_utility.set_location('Entering ' || l_package,10);
2943: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
2944: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
2945: end if;
2946:
2947: -- tilak : new fonm paramter passes the value no more overring the dates
2948: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);

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

2983: ,p_fonm_rt_strt_dt => p_fonm_rt_strt_dt
2984: );
2985: --
2986: if g_debug then
2987: hr_utility.set_location('l_hwf.hrs_src_cd '||l_hwf.hrs_src_cd ,20);
2988: end if;
2989: IF l_hwf.hrs_src_cd = 'BNFTBALTYP' THEN
2990: --
2991: IF ben_whatif_elig.g_bnft_bal_hwf_val IS NOT NULL THEN

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

3000: ELSE
3001: --
3002: -- Get the persons balance
3003: if g_debug then
3004: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
3005: hr_utility.set_location(' p_person_id '||p_person_id , 30);
3006: hr_utility.set_location(' l_start_date '||l_start_date, 30);
3007: end if;
3008: --

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

3001: --
3002: -- Get the persons balance
3003: if g_debug then
3004: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
3005: hr_utility.set_location(' p_person_id '||p_person_id , 30);
3006: hr_utility.set_location(' l_start_date '||l_start_date, 30);
3007: end if;
3008: --
3009: ben_person_object.get_object(p_person_id=> p_person_id

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

3002: -- Get the persons balance
3003: if g_debug then
3004: hr_utility.set_location(' l_hwf.bnfts_bal_id '||l_hwf.bnfts_bal_id , 30);
3005: hr_utility.set_location(' p_person_id '||p_person_id , 30);
3006: hr_utility.set_location(' l_start_date '||l_start_date, 30);
3007: end if;
3008: --
3009: ben_person_object.get_object(p_person_id=> p_person_id
3010: ,p_effective_date => l_start_date

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

3022: fetch c_ass into l_min_ass_date ;
3023: close c_ass ;
3024:
3025: if g_debug then
3026: hr_utility.set_location('l_min_ass_date ' || l_min_ass_date,19);
3027: end if;
3028: if l_min_ass_date is not null then
3029: ben_person_object.get_object(p_person_id=> p_person_id
3030: ,p_effective_date => l_min_ass_date

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

3039:
3040: IF l_result IS NULL THEN
3041: --
3042: if g_debug then
3043: hr_utility.set_location(' Person does not have a balance ',40);
3044: end if;
3045: --
3046: -- Person does not have a balance, recheck if they have a balance
3047: -- as of the life event occurred date or effective date.

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

3065: ,p_rec => l_bal_rec);
3066: --
3067: l_result := l_bal_rec.val;
3068: if g_debug then
3069: hr_utility.set_location(' Person does not l_bal_rec.val '||l_bal_rec.val ,50);
3070: end if;
3071: --
3072: IF l_result IS NULL THEN
3073: --

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

3138: open c_ass ;
3139: fetch c_ass into l_min_ass_date ;
3140: close c_ass ;
3141: if g_debug then
3142: hr_utility.set_location (' l_min_ass_date ' || l_min_ass_date, 1999);
3143: end if;
3144: l_result :=
3145: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3146: ,l_assignment.assignment_id

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

3199: --
3200: p_value := l_result;
3201:
3202: if g_debug then
3203: hr_utility.set_location(' End of hours_calculation l_result '||l_result, 50);
3204: end if;
3205: --
3206: --
3207: end determine_hours_worked;

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

3249: l_pff c_pff%rowtype;
3250:
3251: begin
3252: --
3253: hr_utility.set_location('Entering ' || l_package,10);
3254: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3255: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3256: --
3257: -- tilak : new fonm paramter passes the value no more overring the dates

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

3250:
3251: begin
3252: --
3253: hr_utility.set_location('Entering ' || l_package,10);
3254: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3255: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3256: --
3257: -- tilak : new fonm paramter passes the value no more overring the dates
3258: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);

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

3251: begin
3252: --
3253: hr_utility.set_location('Entering ' || l_package,10);
3254: hr_utility.set_location('fonm_cvg :'||p_fonm_cvg_strt_dt ,10);
3255: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
3256: --
3257: -- tilak : new fonm paramter passes the value no more overring the dates
3258: l_effective_date := nvl(nvl(p_fonm_rt_Strt_dt, p_fonm_cvg_strt_dt), p_lf_evt_ocrd_dt);
3259: --

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

3311:
3312: p_value := l_result;
3313:
3314: if g_debug then
3315: hr_utility.set_location('Leaving ' || l_package,10);
3316: end if;
3317: --
3318: end determine_pct_fulltime;
3319: end ben_derive_factors;