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.

[Home] [Help]

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: /* =====================================================================

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

283: and P_Effective_Date
284: between a.effective_start_date and a.effective_end_date;
285: --
286: begin
287: hr_utility.set_location(l_proc, 5);
288: open csr_assignment_status;
289: fetch csr_assignment_status into l_effective_start_date,
290: l_effective_end_date,
291: l_per_system_status;

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

291: l_per_system_status;
292: if csr_assignment_status%notfound then
293: close csr_assignment_status;
294: --
295: hr_utility.set_location(l_proc, 10);
296: return 1;
297: end if;
298: close csr_assignment_status;
299: --

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

303: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
304: l_error := per_formula_functions.set_text
305: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
306: --
307: hr_utility.set_location(l_proc, 10);
308: return 0;
309: end Get_Assignment_Status;
310: --
311: /* =====================================================================

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

347: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY'));
348:
349: begin
350: --
351: hr_utility.set_location(l_proc, 5);
352:
353: open c_count_periods;
354: fetch c_count_periods into l_periods;
355: close c_count_periods;

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

356:
357: l_error := per_formula_functions.set_number
358: ('PAYROLL_YEAR_NUMBER_OF_PERIODS',l_periods);
359:
360: hr_utility.set_location(l_proc, 10);
361: -- START bug 4956943
362: select max(end_date)
363: into l_max_ed_cur_year
364: from per_time_periods

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

363: into l_max_ed_cur_year
364: from per_time_periods
365: where payroll_id = p_payroll_id
366: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
367: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
368:
369: if l_max_ed_cur_year < p_calculation_date then
370: hr_utility.set_location(l_proc, 100);
371: select min(start_date)

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

366: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
367: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
368:
369: if l_max_ed_cur_year < p_calculation_date then
370: hr_utility.set_location(l_proc, 100);
371: select min(start_date)
372: into l_start_date
373: from per_time_periods
374: where payroll_id = p_payroll_id

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

382:
383: l_error := per_formula_functions.set_date
384: ('PAYROLL_YEAR_FIRST_VALID_DATE', l_start_date);
385:
386: hr_utility.set_location(l_proc, 15);
387:
388: return 0;
389: --
390: end Calculate_Payroll_Periods;

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

513: );
514:
515: begin
516: --
517: hr_utility.set_location(l_proc, 5);
518:
519: /*
520: * First check that a latest balance actually exists. There will
521: * be no balance if no payrolls have yet been run with the new

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

545: open c_get_date;
546: fetch c_get_date into l_date;
547: close c_get_date;
548:
549: hr_utility.set_location(l_proc, 10);
550:
551: return l_date;
552: --
553: end Get_Start_Date;

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

773: l_net_entitlement number;
774:
775: begin
776: --
777: hr_utility.set_location(l_proc, 5);
778:
779: if P_Accrual_Start_Date = hr_api.g_eot then
780: -- The accrual start date database item returned null but Fast
781: -- Formula defaulted it to the end of time. Re-set it back to null.

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

799: ,P_Accrual_End_Date => l_accrual_end_date
800: ,P_Accrual => l_accrual
801: ,P_Net_Entitlement => l_net_entitlement);
802:
803: hr_utility.set_location(l_proc, 10);
804:
805: return round(nvl(l_net_entitlement, 0), 5);
806: --
807: end Get_Net_Accrual;

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

833: --
834: BEGIN -- calculate_hours_worked
835: --
836: -- Check for valid range
837: hr_utility.set_location('calculate_hours_worked', 5);
838: IF p_range_start > p_range_end THEN
839: hr_utility.set_location('calculate_hours_worked', 7);
840: RETURN v_total_hours;
841: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

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

835: --
836: -- Check for valid range
837: hr_utility.set_location('calculate_hours_worked', 5);
838: IF p_range_start > p_range_end THEN
839: hr_utility.set_location('calculate_hours_worked', 7);
840: RETURN v_total_hours;
841: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
842: -- hr_utility.raise_error;
843: END IF;

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

837: hr_utility.set_location('calculate_hours_worked', 5);
838: IF p_range_start > p_range_end THEN
839: hr_utility.set_location('calculate_hours_worked', 7);
840: RETURN v_total_hours;
841: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
842: -- hr_utility.raise_error;
843: END IF;
844: --
845: --

Line 842: -- hr_utility.raise_error;

838: IF p_range_start > p_range_end THEN
839: hr_utility.set_location('calculate_hours_worked', 7);
840: RETURN v_total_hours;
841: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
842: -- hr_utility.raise_error;
843: END IF;
844: --
845: --
846: IF UPPER(p_std_freq) = 'W' THEN

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

854: END IF;
855: --
856: v_curr_date := p_range_start;
857:
858: hr_utility.set_location('calculate_hours_worked', 10);
859:
860: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
861: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
862: LOOP

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

856: v_curr_date := p_range_start;
857:
858: hr_utility.set_location('calculate_hours_worked', 10);
859:
860: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
861: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
862: LOOP
863:
864: v_day_no := TO_CHAR(v_curr_date, 'D');

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

857:
858: hr_utility.set_location('calculate_hours_worked', 10);
859:
860: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
861: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
862: LOOP
863:
864: v_day_no := TO_CHAR(v_curr_date, 'D');
865:

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

862: LOOP
863:
864: v_day_no := TO_CHAR(v_curr_date, 'D');
865:
866: hr_utility.set_location('calculate_hours_worked', 15);
867:
868: IF v_day_no > 1 and v_day_no < 7 then
869:
870: v_total_hours := v_total_hours + v_wrkday_hours;

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

867:
868: IF v_day_no > 1 and v_day_no < 7 then
869:
870: v_total_hours := v_total_hours + v_wrkday_hours;
871: hr_utility.set_location('calculate_hours_worked v_total_hours = ', v_total_hours);
872: END IF;
873: v_curr_date := v_curr_date + 1;
874: EXIT WHEN v_curr_date > p_range_end;
875: END LOOP;

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

873: v_curr_date := v_curr_date + 1;
874: EXIT WHEN v_curr_date > p_range_end;
875: END LOOP;
876: --
877: hr_utility.set_location('v_total_hours is', to_number(v_total_hours));
878: RETURN v_total_hours;
879: --
880: END calculate_hours_worked;
881: --

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

897: --
898: l_error number;
899: --
900: begin
901: hr_utility.set_location(l_proc, 5);
902: --
903: open csr_get_payroll;
904: fetch csr_get_payroll into l_payroll_id;
905: if csr_get_payroll%notfound then

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

903: open csr_get_payroll;
904: fetch csr_get_payroll into l_payroll_id;
905: if csr_get_payroll%notfound then
906: close csr_get_payroll;
907: hr_utility.set_location('Payroll not found '||l_proc, 10);
908: -- Since no payroll found for the assignment, using the context value
909: l_payroll_id := P_Payroll_Id;
910: elsif l_payroll_id is null then
911: close csr_get_payroll;

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

908: -- Since no payroll found for the assignment, using the context value
909: l_payroll_id := P_Payroll_Id;
910: elsif l_payroll_id is null then
911: close csr_get_payroll;
912: hr_utility.set_location('Payroll is null '||l_proc, 12);
913: -- Since no payroll found for the assignment, using the context value
914: l_payroll_id := P_Payroll_Id;
915: end if;
916: if csr_get_payroll%isopen then

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

919: --
920: l_error := per_formula_functions.set_number
921: ('LATEST_PAYROLL_ID',l_payroll_id);
922: --
923: hr_utility.set_location(l_proc, 15);
924: return 0;
925: --
926: end Get_Payroll_ID;
927: --

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

946: --
947: l_error number;
948: --
949: begin
950: hr_utility.set_location(l_proc, 5);
951: --
952: open csr_get_payroll_period;
953: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
954: if csr_get_payroll_period%notfound then

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

952: open csr_get_payroll_period;
953: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
954: if csr_get_payroll_period%notfound then
955: close csr_get_payroll_period;
956: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
957: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
958: return 1;
959: end if;
960: close csr_get_payroll_period;

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

965: ('PAYROLL_PERIOD_END_DATE',l_end_date);
966: l_error := per_formula_functions.set_number
967: ('PAYROLL_PERIOD_NUMBER',l_period_number);
968: --
969: hr_utility.set_location(l_proc, 15);
970: return 0;
971: end Get_Payroll_Details;
972: --
973: --

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

991: l_proc varchar2(80) := g_package||'cache_action_prms';
992: --
993: begin
994: --
995: hr_utility.set_location('Entering: '||l_proc,5);
996:
997: if NOT g_actionPrm_cached then
998: g_actionPrm_cache.sz := 0;
999: end if;

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

1007: end loop;
1008: --
1009: g_actionPrm_cached := TRUE;
1010: --
1011: hr_utility.set_location('Leaving: '||l_proc,88);
1012: --
1013: end cache_action_prms;
1014: /* =====================================================================
1015: Name : Get Cache ActionPrm

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

1028: l_prm_value PAY_ACTION_PARAMETER_VALUES.parameter_value%TYPE;
1029:
1030: begin
1031: --
1032: hr_utility.set_location('Entering: '||l_proc,5);
1033:
1034: for actionPrm_rec in 1..g_actionPrm_cache.sz loop
1035:
1036: if (g_actionPrm_cache.parameter_name(actionPrm_rec) = p_prm_name)

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

1039: end if;
1040:
1041: end loop;
1042: --
1043: hr_utility.set_location('Leaving: '||l_proc,88);
1044: --
1045: return l_prm_value;
1046: --
1047: end get_cache_ActionPrm;

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

1087: l_result PAY_ACTION_PARAMETER_VALUES.parameter_value%TYPE := 'N';
1088: --
1089:
1090: begin
1091: hr_utility.set_location('Entering: '||l_proc, 5);
1092:
1093: if NOT g_reset_pto_cache then
1094: l_result := Get_Action_Parameter('RESET_PTO_ACCRUALS');
1095: if nvl(l_result,'N') = 'Y' then

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

1098: g_reset_pto_accruals := 'FALSE';
1099: end if;
1100: g_reset_pto_cache := true;
1101: end if;
1102: hr_utility.set_location('Leaving: '||l_proc||' => RESET = '||g_reset_pto_accruals, 88);
1103: return g_reset_pto_accruals;
1104:
1105: end Reset_PTO_Accruals;
1106: -- <<

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

1272: --
1273: l_error number;
1274: --
1275: begin
1276: hr_utility.set_location(l_proc, 5);
1277: --
1278: l_Per_date := NULL;
1279: open csr_get_per_term_date;
1280: fetch csr_get_per_term_date into l_Per_date;

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

1291: --changes for bug 5749588 ends here
1292: -- l_Per_date := hr_api.g_eot;
1293: l_error := per_formula_functions.set_date
1294: ('PER_TERMINATION_DATE',l_Per_date);
1295: hr_utility.set_location(l_proc, 10);
1296: -- return 1;
1297: end if;
1298: --
1299: hr_utility.set_location(l_proc, 15);

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

1295: hr_utility.set_location(l_proc, 10);
1296: -- return 1;
1297: end if;
1298: --
1299: hr_utility.set_location(l_proc, 15);
1300: return 0;
1301: end GET_PER_TERMINATION_DATE;
1302: --
1303: --

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

1317: --
1318: l_error number;
1319: --
1320: begin
1321: hr_utility.set_location(l_proc, 5);
1322: --
1323: open csr_get_payroll_range;
1324: fetch csr_get_payroll_range into l_start_date,l_end_date;
1325: close csr_get_payroll_range;

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

1329: ('PAYROLL_MAX_START_DATE',l_start_date);
1330: l_error := per_formula_functions.set_date
1331: ('PAYROLL_MAX_END_DATE',l_end_date);
1332: else
1333: hr_utility.set_location(l_proc, 10);
1334: return 1;
1335: end if;
1336: --
1337: hr_utility.set_location(l_proc, 15);

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

1333: hr_utility.set_location(l_proc, 10);
1334: return 1;
1335: end if;
1336: --
1337: hr_utility.set_location(l_proc, 15);
1338: return 0;
1339: end GET_PAYROLL_DTRANGE;
1340:
1341: --

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

1366: l_event_group_id pay_event_groups.event_group_id%TYPE;
1367: l_legislation_code HR_ORGANIZATION_INFORMATION.org_information9%TYPE;
1368:
1369: BEGIN
1370: hr_utility.set_location('Entering: '||l_proc, 5);
1371:
1372: l_recalc_date := p_recalc_date;
1373: l_legislation_code := get_legislation(p_business_group_id);
1374:

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

1399: END IF;
1400:
1401: END LOOP;
1402: ELSE
1403: hr_utility.set_location(l_proc, 99);
1404: END IF;
1405: END IF;
1406:
1407: hr_utility.set_location('Leaving: '||l_proc, 88);

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

1403: hr_utility.set_location(l_proc, 99);
1404: END IF;
1405: END IF;
1406:
1407: hr_utility.set_location('Leaving: '||l_proc, 88);
1408:
1409: RETURN l_recalc_date;
1410:
1411: END Get_Earliest_AsgChange_Date;