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.PER_UTILITY_FUNCTIONS dependencies on HR_UTILITY

Line 78: hr_utility.set_location(l_proc, 5);

74: --
75: l_error number;
76: --
77: begin
78: hr_utility.set_location(l_proc, 5);
79: --
80: open csr_get_payroll_period;
81: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
82: if csr_get_payroll_period%notfound then

Line 84: hr_utility.set_location('Payroll Period not found '||l_proc, 10);

80: open csr_get_payroll_period;
81: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
82: if csr_get_payroll_period%notfound then
83: close csr_get_payroll_period;
84: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
85: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
86: return 1;
87: end if;
88: close csr_get_payroll_period;

Line 97: hr_utility.set_location(l_proc, 15);

93: ('PAYROLL_PERIOD_END_DATE',l_end_date);
94: l_error := per_formula_functions.set_number
95: ('PAYROLL_PERIOD_NUMBER',l_period_number);
96: --
97: hr_utility.set_location(l_proc, 15);
98: return 0;
99: end Get_Payroll_Period;
100: --
101: /* =====================================================================

Line 133: hr_utility.set_location(l_proc, 5);

129: --
130: l_error number;
131: --
132: begin
133: hr_utility.set_location(l_proc, 5);
134: l_annual_rate := 0;
135: l_upper_limit := 0;
136: l_ceiling := 0;
137: l_max_carry_over := 0;

Line 145: hr_utility.set_location(l_proc, 10);

141: l_upper_limit,
142: l_ceiling,
143: l_max_carry_over;
144: if csr_get_accrual_band%notfound then
145: hr_utility.set_location(l_proc, 10);
146: return 1;
147: end if;
148: close csr_get_accrual_band;
149: --

Line 155: hr_utility.set_location(l_proc, 15);

151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);
152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);
153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);
154: --
155: hr_utility.set_location(l_proc, 15);
156: return 0;
157: exception
158: when others then
159: hr_utility.set_location(l_proc, 20);

Line 159: hr_utility.set_location(l_proc, 20);

155: hr_utility.set_location(l_proc, 15);
156: return 0;
157: exception
158: when others then
159: hr_utility.set_location(l_proc, 20);
160: return 1;
161: end Get_Accrual_Band;
162: --
163: /* =====================================================================

Line 187: hr_utility.set_location(l_proc, 5);

183: l_months number;
184: --
185: begin
186:
187: hr_utility.set_location(l_proc, 5);
188:
189: if P_Date_In_Period >= P_Base_Start_Date then
190: --
191: l_start_date := P_Base_Start_Date;

Line 249: hr_utility.set_location(l_proc, 10);

245: end loop;
246: --
247: end if;
248:
249: hr_utility.set_location(l_proc, 10);
250: return 0;
251: exception
252: when others then
253: hr_utility.set_location(l_proc, 15);

Line 253: hr_utility.set_location(l_proc, 15);

249: hr_utility.set_location(l_proc, 10);
250: return 0;
251: exception
252: when others then
253: hr_utility.set_location(l_proc, 15);
254: return 1;
255: end Get_Period_Dates;
256:
257: -- Fix for the bug 13935707

Line 275: hr_utility.set_location(l_proc, 5);

271: l_hire_date date;
272: --
273: begin
274:
275: hr_utility.set_location(l_proc, 5);
276:
277: if P_Date_In_Period >= P_Base_Start_Date then
278: --
279: l_start_date := P_Base_Start_Date;

Line 345: hr_utility.set_location(l_proc, 10);

341: end loop;
342: --
343: end if;
344:
345: hr_utility.set_location(l_proc, 10);
346: return 0;
347: exception
348: when others then
349: hr_utility.set_location(l_proc, 15);

Line 349: hr_utility.set_location(l_proc, 15);

345: hr_utility.set_location(l_proc, 10);
346: return 0;
347: exception
348: when others then
349: hr_utility.set_location(l_proc, 15);
350: return 1;
351: end Get_Period_Dates_hd;
352: --
353: /* =====================================================================

Line 383: hr_utility.set_location(l_proc, 5);

379: and P_Effective_Date
380: between a.effective_start_date and a.effective_end_date;
381: --
382: begin
383: hr_utility.set_location(l_proc, 5);
384: open csr_assignment_status;
385: fetch csr_assignment_status into l_effective_start_date,
386: l_effective_end_date,
387: l_per_system_status;

Line 391: hr_utility.set_location(l_proc, 10);

387: l_per_system_status;
388: if csr_assignment_status%notfound then
389: close csr_assignment_status;
390: --
391: hr_utility.set_location(l_proc, 10);
392: return 1;
393: end if;
394: close csr_assignment_status;
395: --

Line 403: hr_utility.set_location(l_proc, 10);

399: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
400: l_error := per_formula_functions.set_text
401: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
402: --
403: hr_utility.set_location(l_proc, 10);
404: return 0;
405: end Get_Assignment_Status;
406: --
407: /* =====================================================================

Line 447: hr_utility.set_location(l_proc, 5);

443: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY'));
444:
445: begin
446: --
447: hr_utility.set_location(l_proc, 5);
448:
449: open c_count_periods;
450: fetch c_count_periods into l_periods;
451: close c_count_periods;

Line 456: hr_utility.set_location(l_proc, 10);

452:
453: l_error := per_formula_functions.set_number
454: ('PAYROLL_YEAR_NUMBER_OF_PERIODS',l_periods);
455:
456: hr_utility.set_location(l_proc, 10);
457: -- START bug 4956943
458: select max(end_date)
459: into l_max_ed_cur_year
460: from per_time_periods

Line 463: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);

459: into l_max_ed_cur_year
460: from per_time_periods
461: where payroll_id = p_payroll_id
462: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
463: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
464:
465: if l_max_ed_cur_year < p_calculation_date then
466: hr_utility.set_location(l_proc, 100);
467: select min(start_date)

Line 466: hr_utility.set_location(l_proc, 100);

462: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
463: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
464:
465: if l_max_ed_cur_year < p_calculation_date then
466: hr_utility.set_location(l_proc, 100);
467: select min(start_date)
468: into l_start_date
469: from per_time_periods
470: where payroll_id = p_payroll_id

Line 482: hr_utility.set_location(l_proc, 15);

478:
479: l_error := per_formula_functions.set_date
480: ('PAYROLL_YEAR_FIRST_VALID_DATE', l_start_date);
481:
482: hr_utility.set_location(l_proc, 15);
483:
484: return 0;
485: --
486: end Calculate_Payroll_Periods;

Line 613: hr_utility.set_location(l_proc, 5);

609: );
610:
611: begin
612: --
613: hr_utility.set_location(l_proc, 5);
614:
615: /*
616: * First check that a latest balance actually exists. There will
617: * be no balance if no payrolls have yet been run with the new

Line 645: hr_utility.set_location(l_proc, 10);

641: open c_get_date;
642: fetch c_get_date into l_date;
643: close c_get_date;
644:
645: hr_utility.set_location(l_proc, 10);
646:
647: return l_date;
648: --
649: end Get_Start_Date;

Line 873: hr_utility.set_location(l_proc, 5);

869: l_net_entitlement number;
870:
871: begin
872: --
873: hr_utility.set_location(l_proc, 5);
874:
875: if P_Accrual_Start_Date = hr_api.g_eot then
876: -- The accrual start date database item returned null but Fast
877: -- Formula defaulted it to the end of time. Re-set it back to null.

Line 899: hr_utility.set_location(l_proc, 10);

895: ,P_Accrual_End_Date => l_accrual_end_date
896: ,P_Accrual => l_accrual
897: ,P_Net_Entitlement => l_net_entitlement);
898:
899: hr_utility.set_location(l_proc, 10);
900:
901: return round(nvl(l_net_entitlement, 0), 5);
902: --
903: end Get_Net_Accrual;

Line 933: hr_utility.set_location('calculate_hours_worked', 5);

929: --
930: BEGIN -- calculate_hours_worked
931: --
932: -- Check for valid range
933: hr_utility.set_location('calculate_hours_worked', 5);
934: IF p_range_start > p_range_end THEN
935: hr_utility.set_location('calculate_hours_worked', 7);
936: RETURN v_total_hours;
937: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

Line 935: hr_utility.set_location('calculate_hours_worked', 7);

931: --
932: -- Check for valid range
933: hr_utility.set_location('calculate_hours_worked', 5);
934: IF p_range_start > p_range_end THEN
935: hr_utility.set_location('calculate_hours_worked', 7);
936: RETURN v_total_hours;
937: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
938: -- hr_utility.raise_error;
939: END IF;

Line 937: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

933: hr_utility.set_location('calculate_hours_worked', 5);
934: IF p_range_start > p_range_end THEN
935: hr_utility.set_location('calculate_hours_worked', 7);
936: RETURN v_total_hours;
937: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
938: -- hr_utility.raise_error;
939: END IF;
940: --
941: --

Line 938: -- hr_utility.raise_error;

934: IF p_range_start > p_range_end THEN
935: hr_utility.set_location('calculate_hours_worked', 7);
936: RETURN v_total_hours;
937: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
938: -- hr_utility.raise_error;
939: END IF;
940: --
941: --
942: IF UPPER(p_std_freq) = 'W' THEN

Line 954: hr_utility.set_location('calculate_hours_worked', 10);

950: END IF;
951: --
952: v_curr_date := p_range_start;
953:
954: hr_utility.set_location('calculate_hours_worked', 10);
955:
956: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
957: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
958: LOOP

Line 956: hr_utility.trace('p_range_start is'|| to_char(p_range_start));

952: v_curr_date := p_range_start;
953:
954: hr_utility.set_location('calculate_hours_worked', 10);
955:
956: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
957: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
958: LOOP
959:
960: v_day_no := TO_CHAR(v_curr_date, 'D');

Line 957: hr_utility.trace('p_range_end is'|| to_char(p_range_end));

953:
954: hr_utility.set_location('calculate_hours_worked', 10);
955:
956: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
957: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
958: LOOP
959:
960: v_day_no := TO_CHAR(v_curr_date, 'D');
961:

Line 962: hr_utility.set_location('calculate_hours_worked', 15);

958: LOOP
959:
960: v_day_no := TO_CHAR(v_curr_date, 'D');
961:
962: hr_utility.set_location('calculate_hours_worked', 15);
963:
964: IF v_day_no > 1 and v_day_no < 7 then
965:
966: v_total_hours := v_total_hours + v_wrkday_hours;

Line 967: hr_utility.set_location('calculate_hours_worked v_total_hours = ', v_total_hours);

963:
964: IF v_day_no > 1 and v_day_no < 7 then
965:
966: v_total_hours := v_total_hours + v_wrkday_hours;
967: hr_utility.set_location('calculate_hours_worked v_total_hours = ', v_total_hours);
968: END IF;
969: v_curr_date := v_curr_date + 1;
970: EXIT WHEN v_curr_date > p_range_end;
971: END LOOP;

Line 973: hr_utility.set_location('v_total_hours is', to_number(v_total_hours));

969: v_curr_date := v_curr_date + 1;
970: EXIT WHEN v_curr_date > p_range_end;
971: END LOOP;
972: --
973: hr_utility.set_location('v_total_hours is', to_number(v_total_hours));
974: RETURN v_total_hours;
975: --
976: END calculate_hours_worked;
977: --

Line 997: hr_utility.set_location(l_proc, 5);

993: --
994: l_error number;
995: --
996: begin
997: hr_utility.set_location(l_proc, 5);
998: --
999: open csr_get_payroll;
1000: fetch csr_get_payroll into l_payroll_id;
1001: if csr_get_payroll%notfound then

Line 1003: hr_utility.set_location('Payroll not found '||l_proc, 10);

999: open csr_get_payroll;
1000: fetch csr_get_payroll into l_payroll_id;
1001: if csr_get_payroll%notfound then
1002: close csr_get_payroll;
1003: hr_utility.set_location('Payroll not found '||l_proc, 10);
1004: -- Since no payroll found for the assignment, using the context value
1005: l_payroll_id := P_Payroll_Id;
1006: elsif l_payroll_id is null then
1007: close csr_get_payroll;

Line 1008: hr_utility.set_location('Payroll is null '||l_proc, 12);

1004: -- Since no payroll found for the assignment, using the context value
1005: l_payroll_id := P_Payroll_Id;
1006: elsif l_payroll_id is null then
1007: close csr_get_payroll;
1008: hr_utility.set_location('Payroll is null '||l_proc, 12);
1009: -- Since no payroll found for the assignment, using the context value
1010: l_payroll_id := P_Payroll_Id;
1011: end if;
1012: if csr_get_payroll%isopen then

Line 1019: hr_utility.set_location(l_proc, 15);

1015: --
1016: l_error := per_formula_functions.set_number
1017: ('LATEST_PAYROLL_ID',l_payroll_id);
1018: --
1019: hr_utility.set_location(l_proc, 15);
1020: return 0;
1021: --
1022: end Get_Payroll_ID;
1023: --

Line 1046: hr_utility.set_location(l_proc, 5);

1042: --
1043: l_error number;
1044: --
1045: begin
1046: hr_utility.set_location(l_proc, 5);
1047: --
1048: open csr_get_payroll_period;
1049: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
1050: if csr_get_payroll_period%notfound then

Line 1052: hr_utility.set_location('Payroll Period not found '||l_proc, 10);

1048: open csr_get_payroll_period;
1049: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
1050: if csr_get_payroll_period%notfound then
1051: close csr_get_payroll_period;
1052: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
1053: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
1054: return 1;
1055: end if;
1056: close csr_get_payroll_period;

Line 1065: hr_utility.set_location(l_proc, 15);

1061: ('PAYROLL_PERIOD_END_DATE',l_end_date);
1062: l_error := per_formula_functions.set_number
1063: ('PAYROLL_PERIOD_NUMBER',l_period_number);
1064: --
1065: hr_utility.set_location(l_proc, 15);
1066: return 0;
1067: end Get_Payroll_Details;
1068: --
1069: --

Line 1091: hr_utility.set_location('Entering: '||l_proc,5);

1087: l_proc varchar2(80) := g_package||'cache_action_prms';
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering: '||l_proc,5);
1092:
1093: if NOT g_actionPrm_cached then
1094: g_actionPrm_cache.sz := 0;
1095: end if;

Line 1107: hr_utility.set_location('Leaving: '||l_proc,88);

1103: end loop;
1104: --
1105: g_actionPrm_cached := TRUE;
1106: --
1107: hr_utility.set_location('Leaving: '||l_proc,88);
1108: --
1109: end cache_action_prms;
1110: /* =====================================================================
1111: Name : Get Cache ActionPrm

Line 1128: hr_utility.set_location('Entering: '||l_proc,5);

1124: l_prm_value PAY_ACTION_PARAMETER_VALUES.parameter_value%TYPE;
1125:
1126: begin
1127: --
1128: hr_utility.set_location('Entering: '||l_proc,5);
1129:
1130: for actionPrm_rec in 1..g_actionPrm_cache.sz loop
1131:
1132: if (g_actionPrm_cache.parameter_name(actionPrm_rec) = p_prm_name)

Line 1139: hr_utility.set_location('Leaving: '||l_proc,88);

1135: end if;
1136:
1137: end loop;
1138: --
1139: hr_utility.set_location('Leaving: '||l_proc,88);
1140: --
1141: return l_prm_value;
1142: --
1143: end get_cache_ActionPrm;

Line 1187: hr_utility.set_location('Entering: '||l_proc, 5);

1183: l_result PAY_ACTION_PARAMETER_VALUES.parameter_value%TYPE := 'N';
1184: --
1185:
1186: begin
1187: hr_utility.set_location('Entering: '||l_proc, 5);
1188:
1189: if NOT g_reset_pto_cache then
1190: l_result := Get_Action_Parameter('RESET_PTO_ACCRUALS');
1191: if nvl(l_result,'N') = 'Y' then

Line 1198: hr_utility.set_location('Leaving: '||l_proc||' => RESET = '||g_reset_pto_accruals, 88);

1194: g_reset_pto_accruals := 'FALSE';
1195: end if;
1196: g_reset_pto_cache := true;
1197: end if;
1198: hr_utility.set_location('Leaving: '||l_proc||' => RESET = '||g_reset_pto_accruals, 88);
1199: return g_reset_pto_accruals;
1200:
1201: end Reset_PTO_Accruals;
1202: -- <<

Line 1372: hr_utility.set_location(l_proc, 5);

1368: --
1369: l_error number;
1370: --
1371: begin
1372: hr_utility.set_location(l_proc, 5);
1373: --
1374: l_Per_date := NULL;
1375: open csr_get_per_term_date;
1376: fetch csr_get_per_term_date into l_Per_date;

Line 1391: hr_utility.set_location(l_proc, 10);

1387: --changes for bug 5749588 ends here
1388: -- l_Per_date := hr_api.g_eot;
1389: l_error := per_formula_functions.set_date
1390: ('PER_TERMINATION_DATE',l_Per_date);
1391: hr_utility.set_location(l_proc, 10);
1392: -- return 1;
1393: end if;
1394: --
1395: hr_utility.set_location(l_proc, 15);

Line 1395: hr_utility.set_location(l_proc, 15);

1391: hr_utility.set_location(l_proc, 10);
1392: -- return 1;
1393: end if;
1394: --
1395: hr_utility.set_location(l_proc, 15);
1396: return 0;
1397: end GET_PER_TERMINATION_DATE;
1398: --
1399: --

Line 1417: hr_utility.set_location(l_proc, 5);

1413: --
1414: l_error number;
1415: --
1416: begin
1417: hr_utility.set_location(l_proc, 5);
1418: --
1419: open csr_get_payroll_range;
1420: fetch csr_get_payroll_range into l_start_date,l_end_date;
1421: close csr_get_payroll_range;

Line 1429: hr_utility.set_location(l_proc, 10);

1425: ('PAYROLL_MAX_START_DATE',l_start_date);
1426: l_error := per_formula_functions.set_date
1427: ('PAYROLL_MAX_END_DATE',l_end_date);
1428: else
1429: hr_utility.set_location(l_proc, 10);
1430: return 1;
1431: end if;
1432: --
1433: hr_utility.set_location(l_proc, 15);

Line 1433: hr_utility.set_location(l_proc, 15);

1429: hr_utility.set_location(l_proc, 10);
1430: return 1;
1431: end if;
1432: --
1433: hr_utility.set_location(l_proc, 15);
1434: return 0;
1435: end GET_PAYROLL_DTRANGE;
1436:
1437: --

Line 1466: hr_utility.set_location('Entering: '||l_proc, 5);

1462: l_event_group_id pay_event_groups.event_group_id%TYPE;
1463: l_legislation_code HR_ORGANIZATION_INFORMATION.org_information9%TYPE;
1464:
1465: BEGIN
1466: hr_utility.set_location('Entering: '||l_proc, 5);
1467:
1468: l_recalc_date := p_recalc_date;
1469: l_legislation_code := get_legislation(p_business_group_id);
1470:

Line 1499: hr_utility.set_location(l_proc, 99);

1495: END IF;
1496:
1497: END LOOP;
1498: ELSE
1499: hr_utility.set_location(l_proc, 99);
1500: END IF;
1501: END IF;
1502:
1503: hr_utility.set_location('Leaving: '||l_proc, 88);

Line 1503: hr_utility.set_location('Leaving: '||l_proc, 88);

1499: hr_utility.set_location(l_proc, 99);
1500: END IF;
1501: END IF;
1502:
1503: hr_utility.set_location('Leaving: '||l_proc, 88);
1504:
1505: RETURN l_recalc_date;
1506:
1507: END Get_Earliest_AsgChange_Date;