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

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

40: l_outputs ff_exec.outputs_t;
41:
42: begin
43: --
44: hr_utility.set_location('Entering '||l_proc, 5);
45: --
46: l_inputs(1).name := 'ASSIGNMENT_ID';
47: l_inputs(1).value := p_assignment_id;
48: l_inputs(2).name := 'DATE_EARNED';

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

80: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
81: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
82: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
83: --
84: hr_utility.set_location('Leaving '||l_proc, 10);
85: --
86: end Calculate_Accrual;
87:
88: --

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

114: l_enrolled_in_plan boolean;
115:
116: begin
117: --
118: hr_utility.set_location('Entering '||l_proc, 5);
119:
120: l_accrual_plan_rec := get_accrual_plan(p_plan_id);
121:
122: l_Enrolled_In_Plan := check_assignment_enrollment(

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

159: p_accrual := 0;
160: --
161: end if;
162: --
163: hr_utility.set_location('Leaving '||l_proc, 10);
164: --
165: end Get_Accrual;
166:
167: --

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

183: l_accrual_plan_rec g_accrual_plan_rec_type;
184:
185: begin
186: --
187: hr_utility.set_location('Entering '||l_proc, 5);
188:
189: hr_utility.trace('plan_id = '||to_char(p_plan_id));
190: open c_accrual_plan_details;
191: fetch c_accrual_plan_details into l_accrual_plan_rec.accrual_plan_element_type_id,

Line 189: hr_utility.trace('plan_id = '||to_char(p_plan_id));

185: begin
186: --
187: hr_utility.set_location('Entering '||l_proc, 5);
188:
189: hr_utility.trace('plan_id = '||to_char(p_plan_id));
190: open c_accrual_plan_details;
191: fetch c_accrual_plan_details into l_accrual_plan_rec.accrual_plan_element_type_id,
192: l_accrual_plan_rec.accrual_formula_id;
193: close c_accrual_plan_details;

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

191: fetch c_accrual_plan_details into l_accrual_plan_rec.accrual_plan_element_type_id,
192: l_accrual_plan_rec.accrual_formula_id;
193: close c_accrual_plan_details;
194:
195: hr_utility.set_location('Leaving '||l_proc, 10);
196:
197: return l_accrual_plan_rec;
198: --
199: end Get_Accrual_Plan;

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

227: l_dummy c_enrolled%rowtype;
228:
229: begin
230: --
231: hr_utility.set_location('Entering '||l_proc, 5);
232:
233: open c_enrolled;
234: fetch c_enrolled into l_dummy;
235:

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

236: l_enrolled := c_enrolled%found;
237:
238: close c_enrolled;
239:
240: hr_utility.set_location('Leaving '||l_proc, 10);
241:
242: return l_enrolled;
243: --
244: end Check_Assignment_Enrollment;

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

282: -- Code change for the bug 6354665 ends here
283:
284: begin
285: --
286: hr_utility.set_location('Entering '||l_proc, 5);
287:
288:
289:
290: l_inputs(1).name := 'ASSIGNMENT_ID';

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

345:
346: p_effective_date := fnd_date.canonical_to_date(l_outputs(2).value);
347: p_expiry_date := fnd_date.canonical_to_date(l_outputs(3).value);
348:
349: hr_utility.set_location('Leaving '||l_proc, 10);
350: --
351: end Get_Carry_Over_Values;
352: --
353: /* =====================================================================

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

419: and abs.date_start between p_start_date and p_calculation_date;
420: --
421: begin
422: --
423: hr_utility.set_location('Entering '||l_proc, 5);
424: --
425: if p_absence_attendance_type_id is not null then
426: hr_utility.set_location(l_proc, 6);
427: open c_get_abs_per_type;

Line 426: hr_utility.set_location(l_proc, 6);

422: --
423: hr_utility.set_location('Entering '||l_proc, 5);
424: --
425: if p_absence_attendance_type_id is not null then
426: hr_utility.set_location(l_proc, 6);
427: open c_get_abs_per_type;
428: fetch c_get_abs_per_type into l_total_absence;
429: close c_get_abs_per_type;
430: elsif p_pto_input_value_id is not null then

Line 431: hr_utility.set_location(l_proc, 7);

427: open c_get_abs_per_type;
428: fetch c_get_abs_per_type into l_total_absence;
429: close c_get_abs_per_type;
430: elsif p_pto_input_value_id is not null then
431: hr_utility.set_location(l_proc, 7);
432: open c_get_abs_per_iv;
433: fetch c_get_abs_per_iv into l_total_absence;
434: close c_get_abs_per_iv;
435: else

Line 436: hr_utility.set_location(l_proc, 8);

432: open c_get_abs_per_iv;
433: fetch c_get_abs_per_iv into l_total_absence;
434: close c_get_abs_per_iv;
435: else
436: hr_utility.set_location(l_proc, 8);
437: open c_get_total_absence;
438: fetch c_get_total_absence into l_total_absence;
439: close c_get_total_absence;
440: end if;

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

437: open c_get_total_absence;
438: fetch c_get_total_absence into l_total_absence;
439: close c_get_total_absence;
440: end if;
441: hr_utility.set_location('Leaving '||l_proc, 10);
442:
443: return nvl(l_total_absence, 0);
444: --
445: end Get_Absence;

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

514: between p_start_date and p_calculation_date);
515: --
516: begin
517: --
518: hr_utility.set_location('Entering '||l_proc, 5);
519: --
520: open c_get_contribution;
521: --
522: loop

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

560: l_contribution := abs(l_contribution);
561: end if;
562: */
563: --
564: hr_utility.set_location('Leaving '||l_proc, 10);
565: --
566: return nvl(l_contribution, 0);
567: --
568: --

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

650: order by expiry_date;
651: --
652: begin
653: --
654: hr_utility.set_location('Entering '||l_proc, 5);
655: --
656: -- Getting entire records into a PL/SQL table
657: --
658: open c_get_carryover;

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

789: end loop;
790: --
791: end if;
792: --
793: hr_utility.set_location('Leaving '||l_proc, 10);
794: --
795: return l_carryover;
796: --
797: -- End of fix 3222662

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

837: where accrual_plan_id = p_plan_id;
838:
839: begin
840: --
841: hr_utility.set_location('Entering '||l_proc, 5);
842:
843: --
844: -- Pipe the parameters for ease of debugging.
845: --

Line 846: hr_utility.trace(' ');

842:
843: --
844: -- Pipe the parameters for ease of debugging.
845: --
846: hr_utility.trace(' ');
847: hr_utility.trace(' --------------------------------'||
848: '---------------------------------');
849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));

Line 847: hr_utility.trace(' --------------------------------'||

843: --
844: -- Pipe the parameters for ease of debugging.
845: --
846: hr_utility.trace(' ');
847: hr_utility.trace(' --------------------------------'||
848: '---------------------------------');
849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
851: hr_utility.trace(' --------------------------------'||

Line 849: hr_utility.trace(' ENTERING '||upper(l_proc));

845: --
846: hr_utility.trace(' ');
847: hr_utility.trace(' --------------------------------'||
848: '---------------------------------');
849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
851: hr_utility.trace(' --------------------------------'||
852: '+--------------------------------');
853: hr_utility.trace(' p_assignment_id '||

Line 850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));

846: hr_utility.trace(' ');
847: hr_utility.trace(' --------------------------------'||
848: '---------------------------------');
849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
851: hr_utility.trace(' --------------------------------'||
852: '+--------------------------------');
853: hr_utility.trace(' p_assignment_id '||
854: to_char(p_assignment_id));

Line 851: hr_utility.trace(' --------------------------------'||

847: hr_utility.trace(' --------------------------------'||
848: '---------------------------------');
849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
851: hr_utility.trace(' --------------------------------'||
852: '+--------------------------------');
853: hr_utility.trace(' p_assignment_id '||
854: to_char(p_assignment_id));
855: hr_utility.trace(' p_plan_id '||

Line 853: hr_utility.trace(' p_assignment_id '||

849: hr_utility.trace(' ENTERING '||upper(l_proc));
850: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
851: hr_utility.trace(' --------------------------------'||
852: '+--------------------------------');
853: hr_utility.trace(' p_assignment_id '||
854: to_char(p_assignment_id));
855: hr_utility.trace(' p_plan_id '||
856: to_char(p_plan_id));
857: hr_utility.trace(' p_payroll_id '||

Line 855: hr_utility.trace(' p_plan_id '||

851: hr_utility.trace(' --------------------------------'||
852: '+--------------------------------');
853: hr_utility.trace(' p_assignment_id '||
854: to_char(p_assignment_id));
855: hr_utility.trace(' p_plan_id '||
856: to_char(p_plan_id));
857: hr_utility.trace(' p_payroll_id '||
858: to_char(p_payroll_id));
859: hr_utility.trace(' p_business_group_id '||

Line 857: hr_utility.trace(' p_payroll_id '||

853: hr_utility.trace(' p_assignment_id '||
854: to_char(p_assignment_id));
855: hr_utility.trace(' p_plan_id '||
856: to_char(p_plan_id));
857: hr_utility.trace(' p_payroll_id '||
858: to_char(p_payroll_id));
859: hr_utility.trace(' p_business_group_id '||
860: to_char(p_business_group_id));
861: hr_utility.trace(' p_assignment_action_id '||

Line 859: hr_utility.trace(' p_business_group_id '||

855: hr_utility.trace(' p_plan_id '||
856: to_char(p_plan_id));
857: hr_utility.trace(' p_payroll_id '||
858: to_char(p_payroll_id));
859: hr_utility.trace(' p_business_group_id '||
860: to_char(p_business_group_id));
861: hr_utility.trace(' p_assignment_action_id '||
862: to_char(p_assignment_action_id));
863: hr_utility.trace(' p_calculation_date '||

Line 861: hr_utility.trace(' p_assignment_action_id '||

857: hr_utility.trace(' p_payroll_id '||
858: to_char(p_payroll_id));
859: hr_utility.trace(' p_business_group_id '||
860: to_char(p_business_group_id));
861: hr_utility.trace(' p_assignment_action_id '||
862: to_char(p_assignment_action_id));
863: hr_utility.trace(' p_calculation_date '||
864: to_char(p_calculation_date));
865: hr_utility.trace(' p_accrual_start_date '||

Line 863: hr_utility.trace(' p_calculation_date '||

859: hr_utility.trace(' p_business_group_id '||
860: to_char(p_business_group_id));
861: hr_utility.trace(' p_assignment_action_id '||
862: to_char(p_assignment_action_id));
863: hr_utility.trace(' p_calculation_date '||
864: to_char(p_calculation_date));
865: hr_utility.trace(' p_accrual_start_date '||
866: to_char(p_accrual_start_date));
867: hr_utility.trace(' p_accrual_latest_balance '||

Line 865: hr_utility.trace(' p_accrual_start_date '||

861: hr_utility.trace(' p_assignment_action_id '||
862: to_char(p_assignment_action_id));
863: hr_utility.trace(' p_calculation_date '||
864: to_char(p_calculation_date));
865: hr_utility.trace(' p_accrual_start_date '||
866: to_char(p_accrual_start_date));
867: hr_utility.trace(' p_accrual_latest_balance '||
868: to_char(p_accrual_latest_balance));
869: hr_utility.trace(' p_calling_point '||

Line 867: hr_utility.trace(' p_accrual_latest_balance '||

863: hr_utility.trace(' p_calculation_date '||
864: to_char(p_calculation_date));
865: hr_utility.trace(' p_accrual_start_date '||
866: to_char(p_accrual_start_date));
867: hr_utility.trace(' p_accrual_latest_balance '||
868: to_char(p_accrual_latest_balance));
869: hr_utility.trace(' p_calling_point '||
870: p_calling_point);
871: hr_utility.trace(' --------------------------------'||

Line 869: hr_utility.trace(' p_calling_point '||

865: hr_utility.trace(' p_accrual_start_date '||
866: to_char(p_accrual_start_date));
867: hr_utility.trace(' p_accrual_latest_balance '||
868: to_char(p_accrual_latest_balance));
869: hr_utility.trace(' p_calling_point '||
870: p_calling_point);
871: hr_utility.trace(' --------------------------------'||
872: '---------------------------------');
873: hr_utility.trace(' ');

Line 871: hr_utility.trace(' --------------------------------'||

867: hr_utility.trace(' p_accrual_latest_balance '||
868: to_char(p_accrual_latest_balance));
869: hr_utility.trace(' p_calling_point '||
870: p_calling_point);
871: hr_utility.trace(' --------------------------------'||
872: '---------------------------------');
873: hr_utility.trace(' ');
874:
875: open c_get_balance;

Line 873: hr_utility.trace(' ');

869: hr_utility.trace(' p_calling_point '||
870: p_calling_point);
871: hr_utility.trace(' --------------------------------'||
872: '---------------------------------');
873: hr_utility.trace(' ');
874:
875: open c_get_balance;
876: fetch c_get_balance into l_defined_balance_id;
877: close c_get_balance;

Line 939: hr_utility.trace(' ');

935:
936: --
937: -- Pipe the parameters for ease of debugging.
938: --
939: hr_utility.trace(' ');
940: hr_utility.trace(' --------------------------------'||
941: '---------------------------------');
942: hr_utility.trace(' LEAVING '||upper(l_proc));
943: hr_utility.trace(' --------------------------------'||

Line 940: hr_utility.trace(' --------------------------------'||

936: --
937: -- Pipe the parameters for ease of debugging.
938: --
939: hr_utility.trace(' ');
940: hr_utility.trace(' --------------------------------'||
941: '---------------------------------');
942: hr_utility.trace(' LEAVING '||upper(l_proc));
943: hr_utility.trace(' --------------------------------'||
944: '+--------------------------------');

Line 942: hr_utility.trace(' LEAVING '||upper(l_proc));

938: --
939: hr_utility.trace(' ');
940: hr_utility.trace(' --------------------------------'||
941: '---------------------------------');
942: hr_utility.trace(' LEAVING '||upper(l_proc));
943: hr_utility.trace(' --------------------------------'||
944: '+--------------------------------');
945: hr_utility.trace(' p_start_date '||
946: to_char(p_start_date));

Line 943: hr_utility.trace(' --------------------------------'||

939: hr_utility.trace(' ');
940: hr_utility.trace(' --------------------------------'||
941: '---------------------------------');
942: hr_utility.trace(' LEAVING '||upper(l_proc));
943: hr_utility.trace(' --------------------------------'||
944: '+--------------------------------');
945: hr_utility.trace(' p_start_date '||
946: to_char(p_start_date));
947: hr_utility.trace(' p_end_date '||

Line 945: hr_utility.trace(' p_start_date '||

941: '---------------------------------');
942: hr_utility.trace(' LEAVING '||upper(l_proc));
943: hr_utility.trace(' --------------------------------'||
944: '+--------------------------------');
945: hr_utility.trace(' p_start_date '||
946: to_char(p_start_date));
947: hr_utility.trace(' p_end_date '||
948: to_char(p_end_date));
949: hr_utility.trace(' p_accrual_end_date '||

Line 947: hr_utility.trace(' p_end_date '||

943: hr_utility.trace(' --------------------------------'||
944: '+--------------------------------');
945: hr_utility.trace(' p_start_date '||
946: to_char(p_start_date));
947: hr_utility.trace(' p_end_date '||
948: to_char(p_end_date));
949: hr_utility.trace(' p_accrual_end_date '||
950: to_char(p_accrual_end_date));
951: hr_utility.trace(' p_accrual '||

Line 949: hr_utility.trace(' p_accrual_end_date '||

945: hr_utility.trace(' p_start_date '||
946: to_char(p_start_date));
947: hr_utility.trace(' p_end_date '||
948: to_char(p_end_date));
949: hr_utility.trace(' p_accrual_end_date '||
950: to_char(p_accrual_end_date));
951: hr_utility.trace(' p_accrual '||
952: to_char(p_accrual));
953: hr_utility.trace(' p_net_entitlement '||

Line 951: hr_utility.trace(' p_accrual '||

947: hr_utility.trace(' p_end_date '||
948: to_char(p_end_date));
949: hr_utility.trace(' p_accrual_end_date '||
950: to_char(p_accrual_end_date));
951: hr_utility.trace(' p_accrual '||
952: to_char(p_accrual));
953: hr_utility.trace(' p_net_entitlement '||
954: to_char(p_net_entitlement));
955: hr_utility.trace(' --------------------------------'||

Line 953: hr_utility.trace(' p_net_entitlement '||

949: hr_utility.trace(' p_accrual_end_date '||
950: to_char(p_accrual_end_date));
951: hr_utility.trace(' p_accrual '||
952: to_char(p_accrual));
953: hr_utility.trace(' p_net_entitlement '||
954: to_char(p_net_entitlement));
955: hr_utility.trace(' --------------------------------'||
956: '---------------------------------');
957: hr_utility.trace(' ');

Line 955: hr_utility.trace(' --------------------------------'||

951: hr_utility.trace(' p_accrual '||
952: to_char(p_accrual));
953: hr_utility.trace(' p_net_entitlement '||
954: to_char(p_net_entitlement));
955: hr_utility.trace(' --------------------------------'||
956: '---------------------------------');
957: hr_utility.trace(' ');
958:
959: --

Line 957: hr_utility.trace(' ');

953: hr_utility.trace(' p_net_entitlement '||
954: to_char(p_net_entitlement));
955: hr_utility.trace(' --------------------------------'||
956: '---------------------------------');
957: hr_utility.trace(' ');
958:
959: --
960: end Get_Net_Accrual;
961: --

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

990: l_asg_inactive_days NUMBER := 0;
991:
992: BEGIN
993: --
994: hr_utility.set_location('Entering '||l_proc, 10);
995:
996: -- Loop each inactive assignment record for the period and count the inactive days
997: OPEN csr_period_asg_status;
998: LOOP

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

1007: LEAST(l_assignment_ed, p_period_ed));
1008: END LOOP;
1009: CLOSE csr_period_asg_status;
1010:
1011: hr_utility.set_location('Leaving '||l_proc, 20);
1012:
1013: RETURN l_asg_inactive_days;
1014:
1015: END get_asg_inactive_days;

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

1032: l_diff_days NUMBER;
1033:
1034: BEGIN
1035: --
1036: hr_utility.set_location('Entering '||l_proc, 10);
1037:
1038: -- Check for a valid range
1039: IF p_start_date > p_end_date THEN
1040: RETURN l_working_days;

Line 1050: hr_utility.trace('l_ref_day = '||to_char(l_ref_day));

1046: -- Start of 3222662
1047: l_ref_day := to_number(to_char(to_date('01/01/2000', 'dd/mm/yyyy'), 'D'));
1048: -- End of 3222662
1049:
1050: hr_utility.trace('l_ref_day = '||to_char(l_ref_day));
1051:
1052: -- A non-zero difference here indicates the week does not begin
1053: -- on Sunday and provides the adjustment we must consider when
1054: -- determining whether or not a day is a work day.

Line 1057: hr_utility.trace('l_diff_days = '||to_char(l_diff_days));

1053: -- on Sunday and provides the adjustment we must consider when
1054: -- determining whether or not a day is a work day.
1055: l_diff_days := 7 - l_ref_day;
1056:
1057: hr_utility.trace('l_diff_days = '||to_char(l_diff_days));
1058:
1059: -- Loop each day in period and count working days
1060:
1061: l_curr_date := p_start_date;

Line 1067: hr_utility.trace('l_curr_day = '||to_char(l_curr_day));

1063: LOOP
1064:
1065: l_curr_day := to_number(to_char(l_curr_date, 'D'));
1066:
1067: hr_utility.trace('l_curr_day = '||to_char(l_curr_day));
1068:
1069: -- Find the adjusted day of week
1070: -- Start of 3222662
1071: if mod(l_curr_day+l_diff_days,7) = 0 then

Line 1078: hr_utility.trace('l_adj_day = '||to_char(l_adj_day));

1074: l_adj_day := mod(l_curr_day+l_diff_days,7);
1075: end if;
1076: -- End of 3222662
1077:
1078: hr_utility.trace('l_adj_day = '||to_char(l_adj_day));
1079:
1080: IF l_adj_day > 1 AND l_adj_day < 7 THEN
1081: l_working_days := l_working_days + 1;
1082: END IF;

Line 1087: hr_utility.set_location('Leaving '||l_proc, 20);

1083: l_curr_date := l_curr_date + 1;
1084: EXIT WHEN l_curr_date > p_end_date;
1085: END LOOP;
1086:
1087: hr_utility.set_location('Leaving '||l_proc, 20);
1088:
1089: RETURN l_working_days;
1090:
1091: END get_working_days;