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_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 350: hr_utility.set_location('Leaving '||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

657:
658: --
659: begin
660: --
661: hr_utility.set_location('Entering '||l_proc, 5);
662: --
663: -- Getting entire records into a PL/SQL table
664:
665: l_leap_year := to_char(p_start_date,'ddmm');

Line 673: hr_utility.set_location('l_st_date '|| l_st_date , 5);

669: else
670: l_st_date :=p_start_date;
671: end if;
672:
673: hr_utility.set_location('l_st_date '|| l_st_date , 5);
674: --
675: open c_get_carryover;
676: --
677: loop

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

806: end loop;
807: --
808: end if;
809: --
810: hr_utility.set_location('Leaving '||l_proc, 10);
811: --
812: return l_carryover;
813: --
814: -- End of fix 3222662

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

866:
867:
868: begin
869: --
870: hr_utility.set_location('Entering '||l_proc, 5);
871:
872: --
873: -- Pipe the parameters for ease of debugging.
874: --

Line 875: hr_utility.trace(' ');

871:
872: --
873: -- Pipe the parameters for ease of debugging.
874: --
875: hr_utility.trace(' ');
876: hr_utility.trace(' --------------------------------'||
877: '---------------------------------');
878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));

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

872: --
873: -- Pipe the parameters for ease of debugging.
874: --
875: hr_utility.trace(' ');
876: hr_utility.trace(' --------------------------------'||
877: '---------------------------------');
878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
880: hr_utility.trace(' --------------------------------'||

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

874: --
875: hr_utility.trace(' ');
876: hr_utility.trace(' --------------------------------'||
877: '---------------------------------');
878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
880: hr_utility.trace(' --------------------------------'||
881: '+--------------------------------');
882: hr_utility.trace(' p_assignment_id '||

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

875: hr_utility.trace(' ');
876: hr_utility.trace(' --------------------------------'||
877: '---------------------------------');
878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
880: hr_utility.trace(' --------------------------------'||
881: '+--------------------------------');
882: hr_utility.trace(' p_assignment_id '||
883: to_char(p_assignment_id));

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

876: hr_utility.trace(' --------------------------------'||
877: '---------------------------------');
878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
880: hr_utility.trace(' --------------------------------'||
881: '+--------------------------------');
882: hr_utility.trace(' p_assignment_id '||
883: to_char(p_assignment_id));
884: hr_utility.trace(' p_plan_id '||

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

878: hr_utility.trace(' ENTERING '||upper(l_proc));
879: hr_utility.trace(' for assignment '||to_char(p_assignment_id));
880: hr_utility.trace(' --------------------------------'||
881: '+--------------------------------');
882: hr_utility.trace(' p_assignment_id '||
883: to_char(p_assignment_id));
884: hr_utility.trace(' p_plan_id '||
885: to_char(p_plan_id));
886: hr_utility.trace(' p_payroll_id '||

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

880: hr_utility.trace(' --------------------------------'||
881: '+--------------------------------');
882: hr_utility.trace(' p_assignment_id '||
883: to_char(p_assignment_id));
884: hr_utility.trace(' p_plan_id '||
885: to_char(p_plan_id));
886: hr_utility.trace(' p_payroll_id '||
887: to_char(p_payroll_id));
888: hr_utility.trace(' p_business_group_id '||

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

882: hr_utility.trace(' p_assignment_id '||
883: to_char(p_assignment_id));
884: hr_utility.trace(' p_plan_id '||
885: to_char(p_plan_id));
886: hr_utility.trace(' p_payroll_id '||
887: to_char(p_payroll_id));
888: hr_utility.trace(' p_business_group_id '||
889: to_char(p_business_group_id));
890: hr_utility.trace(' p_assignment_action_id '||

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

884: hr_utility.trace(' p_plan_id '||
885: to_char(p_plan_id));
886: hr_utility.trace(' p_payroll_id '||
887: to_char(p_payroll_id));
888: hr_utility.trace(' p_business_group_id '||
889: to_char(p_business_group_id));
890: hr_utility.trace(' p_assignment_action_id '||
891: to_char(p_assignment_action_id));
892: hr_utility.trace(' p_calculation_date '||

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

886: hr_utility.trace(' p_payroll_id '||
887: to_char(p_payroll_id));
888: hr_utility.trace(' p_business_group_id '||
889: to_char(p_business_group_id));
890: hr_utility.trace(' p_assignment_action_id '||
891: to_char(p_assignment_action_id));
892: hr_utility.trace(' p_calculation_date '||
893: to_char(p_calculation_date));
894: hr_utility.trace(' p_accrual_start_date '||

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

888: hr_utility.trace(' p_business_group_id '||
889: to_char(p_business_group_id));
890: hr_utility.trace(' p_assignment_action_id '||
891: to_char(p_assignment_action_id));
892: hr_utility.trace(' p_calculation_date '||
893: to_char(p_calculation_date));
894: hr_utility.trace(' p_accrual_start_date '||
895: to_char(p_accrual_start_date));
896: hr_utility.trace(' p_accrual_latest_balance '||

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

890: hr_utility.trace(' p_assignment_action_id '||
891: to_char(p_assignment_action_id));
892: hr_utility.trace(' p_calculation_date '||
893: to_char(p_calculation_date));
894: hr_utility.trace(' p_accrual_start_date '||
895: to_char(p_accrual_start_date));
896: hr_utility.trace(' p_accrual_latest_balance '||
897: to_char(p_accrual_latest_balance));
898: hr_utility.trace(' p_calling_point '||

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

892: hr_utility.trace(' p_calculation_date '||
893: to_char(p_calculation_date));
894: hr_utility.trace(' p_accrual_start_date '||
895: to_char(p_accrual_start_date));
896: hr_utility.trace(' p_accrual_latest_balance '||
897: to_char(p_accrual_latest_balance));
898: hr_utility.trace(' p_calling_point '||
899: p_calling_point);
900: hr_utility.trace(' --------------------------------'||

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

894: hr_utility.trace(' p_accrual_start_date '||
895: to_char(p_accrual_start_date));
896: hr_utility.trace(' p_accrual_latest_balance '||
897: to_char(p_accrual_latest_balance));
898: hr_utility.trace(' p_calling_point '||
899: p_calling_point);
900: hr_utility.trace(' --------------------------------'||
901: '---------------------------------');
902: hr_utility.trace(' ');

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

896: hr_utility.trace(' p_accrual_latest_balance '||
897: to_char(p_accrual_latest_balance));
898: hr_utility.trace(' p_calling_point '||
899: p_calling_point);
900: hr_utility.trace(' --------------------------------'||
901: '---------------------------------');
902: hr_utility.trace(' ');
903:
904: open c_get_balance;

Line 902: hr_utility.trace(' ');

898: hr_utility.trace(' p_calling_point '||
899: p_calling_point);
900: hr_utility.trace(' --------------------------------'||
901: '---------------------------------');
902: hr_utility.trace(' ');
903:
904: open c_get_balance;
905: fetch c_get_balance into l_defined_balance_id;
906: close c_get_balance;

Line 1014: hr_utility.trace(' ');

1010:
1011: --
1012: -- Pipe the parameters for ease of debugging.
1013: --
1014: hr_utility.trace(' ');
1015: hr_utility.trace(' --------------------------------'||
1016: '---------------------------------');
1017: hr_utility.trace(' LEAVING '||upper(l_proc));
1018: hr_utility.trace(' --------------------------------'||

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

1011: --
1012: -- Pipe the parameters for ease of debugging.
1013: --
1014: hr_utility.trace(' ');
1015: hr_utility.trace(' --------------------------------'||
1016: '---------------------------------');
1017: hr_utility.trace(' LEAVING '||upper(l_proc));
1018: hr_utility.trace(' --------------------------------'||
1019: '+--------------------------------');

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

1013: --
1014: hr_utility.trace(' ');
1015: hr_utility.trace(' --------------------------------'||
1016: '---------------------------------');
1017: hr_utility.trace(' LEAVING '||upper(l_proc));
1018: hr_utility.trace(' --------------------------------'||
1019: '+--------------------------------');
1020: hr_utility.trace(' p_start_date '||
1021: to_char(p_start_date));

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

1014: hr_utility.trace(' ');
1015: hr_utility.trace(' --------------------------------'||
1016: '---------------------------------');
1017: hr_utility.trace(' LEAVING '||upper(l_proc));
1018: hr_utility.trace(' --------------------------------'||
1019: '+--------------------------------');
1020: hr_utility.trace(' p_start_date '||
1021: to_char(p_start_date));
1022: hr_utility.trace(' p_end_date '||

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

1016: '---------------------------------');
1017: hr_utility.trace(' LEAVING '||upper(l_proc));
1018: hr_utility.trace(' --------------------------------'||
1019: '+--------------------------------');
1020: hr_utility.trace(' p_start_date '||
1021: to_char(p_start_date));
1022: hr_utility.trace(' p_end_date '||
1023: to_char(p_end_date));
1024: hr_utility.trace(' p_accrual_end_date '||

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

1018: hr_utility.trace(' --------------------------------'||
1019: '+--------------------------------');
1020: hr_utility.trace(' p_start_date '||
1021: to_char(p_start_date));
1022: hr_utility.trace(' p_end_date '||
1023: to_char(p_end_date));
1024: hr_utility.trace(' p_accrual_end_date '||
1025: to_char(p_accrual_end_date));
1026: hr_utility.trace(' p_accrual '||

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

1020: hr_utility.trace(' p_start_date '||
1021: to_char(p_start_date));
1022: hr_utility.trace(' p_end_date '||
1023: to_char(p_end_date));
1024: hr_utility.trace(' p_accrual_end_date '||
1025: to_char(p_accrual_end_date));
1026: hr_utility.trace(' p_accrual '||
1027: to_char(p_accrual));
1028: hr_utility.trace(' p_net_entitlement '||

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

1022: hr_utility.trace(' p_end_date '||
1023: to_char(p_end_date));
1024: hr_utility.trace(' p_accrual_end_date '||
1025: to_char(p_accrual_end_date));
1026: hr_utility.trace(' p_accrual '||
1027: to_char(p_accrual));
1028: hr_utility.trace(' p_net_entitlement '||
1029: to_char(p_net_entitlement));
1030: hr_utility.trace(' --------------------------------'||

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

1024: hr_utility.trace(' p_accrual_end_date '||
1025: to_char(p_accrual_end_date));
1026: hr_utility.trace(' p_accrual '||
1027: to_char(p_accrual));
1028: hr_utility.trace(' p_net_entitlement '||
1029: to_char(p_net_entitlement));
1030: hr_utility.trace(' --------------------------------'||
1031: '---------------------------------');
1032: hr_utility.trace(' ');

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

1026: hr_utility.trace(' p_accrual '||
1027: to_char(p_accrual));
1028: hr_utility.trace(' p_net_entitlement '||
1029: to_char(p_net_entitlement));
1030: hr_utility.trace(' --------------------------------'||
1031: '---------------------------------');
1032: hr_utility.trace(' ');
1033:
1034: --

Line 1032: hr_utility.trace(' ');

1028: hr_utility.trace(' p_net_entitlement '||
1029: to_char(p_net_entitlement));
1030: hr_utility.trace(' --------------------------------'||
1031: '---------------------------------');
1032: hr_utility.trace(' ');
1033:
1034: --
1035: end Get_Net_Accrual;
1036: --

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

1065: l_asg_inactive_days NUMBER := 0;
1066:
1067: BEGIN
1068: --
1069: hr_utility.set_location('Entering '||l_proc, 10);
1070:
1071: -- Loop each inactive assignment record for the period and count the inactive days
1072: OPEN csr_period_asg_status;
1073: LOOP

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

1082: LEAST(l_assignment_ed, p_period_ed));
1083: END LOOP;
1084: CLOSE csr_period_asg_status;
1085:
1086: hr_utility.set_location('Leaving '||l_proc, 20);
1087:
1088: RETURN l_asg_inactive_days;
1089:
1090: END get_asg_inactive_days;

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

1107: l_diff_days NUMBER;
1108:
1109: BEGIN
1110: --
1111: hr_utility.set_location('Entering '||l_proc, 10);
1112:
1113: -- Check for a valid range
1114: IF p_start_date > p_end_date THEN
1115: RETURN l_working_days;

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

1121: -- Start of 3222662
1122: l_ref_day := to_number(to_char(to_date('01/01/2000', 'dd/mm/yyyy'), 'D'));
1123: -- End of 3222662
1124:
1125: hr_utility.trace('l_ref_day = '||to_char(l_ref_day));
1126:
1127: -- A non-zero difference here indicates the week does not begin
1128: -- on Sunday and provides the adjustment we must consider when
1129: -- determining whether or not a day is a work day.

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

1128: -- on Sunday and provides the adjustment we must consider when
1129: -- determining whether or not a day is a work day.
1130: l_diff_days := 7 - l_ref_day;
1131:
1132: hr_utility.trace('l_diff_days = '||to_char(l_diff_days));
1133:
1134: -- Loop each day in period and count working days
1135:
1136: l_curr_date := p_start_date;

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

1138: LOOP
1139:
1140: l_curr_day := to_number(to_char(l_curr_date, 'D'));
1141:
1142: hr_utility.trace('l_curr_day = '||to_char(l_curr_day));
1143:
1144: -- Find the adjusted day of week
1145: -- Start of 3222662
1146: if mod(l_curr_day+l_diff_days,7) = 0 then

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

1149: l_adj_day := mod(l_curr_day+l_diff_days,7);
1150: end if;
1151: -- End of 3222662
1152:
1153: hr_utility.trace('l_adj_day = '||to_char(l_adj_day));
1154:
1155: IF l_adj_day > 1 AND l_adj_day < 7 THEN
1156: l_working_days := l_working_days + 1;
1157: END IF;

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

1158: l_curr_date := l_curr_date + 1;
1159: EXIT WHEN l_curr_date > p_end_date;
1160: END LOOP;
1161:
1162: hr_utility.set_location('Leaving '||l_proc, 20);
1163:
1164: RETURN l_working_days;
1165:
1166: END get_working_days;