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

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

102: AND pap.accrual_plan_element_type_id = pet.element_type_id
103: AND pap.accrual_category = p_plan_category ;
104:
105: BEGIN
106: hr_utility.set_location(' Entering::'||l_proc,5);
107:
108: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
109:
110: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;

Line 115: hr_utility.set_location('Plan Not Found '||l_proc,10);

111:
112: IF csr_get_accrual_plan_id%NOTFOUND
113: THEN
114: CLOSE csr_get_accrual_plan_id;
115: hr_utility.set_location('Plan Not Found '||l_proc,10);
116: hr_utility.set_message(801, 'HR_AU_ACCRUAL_PLAN_NOT_FOUND');
117: hr_utility.raise_error;
118: end if ;
119:

Line 116: hr_utility.set_message(801, 'HR_AU_ACCRUAL_PLAN_NOT_FOUND');

112: IF csr_get_accrual_plan_id%NOTFOUND
113: THEN
114: CLOSE csr_get_accrual_plan_id;
115: hr_utility.set_location('Plan Not Found '||l_proc,10);
116: hr_utility.set_message(801, 'HR_AU_ACCRUAL_PLAN_NOT_FOUND');
117: hr_utility.raise_error;
118: end if ;
119:
120: FETCH csr_get_accrual_plan_id INTO l_dummy ;

Line 117: hr_utility.raise_error;

113: THEN
114: CLOSE csr_get_accrual_plan_id;
115: hr_utility.set_location('Plan Not Found '||l_proc,10);
116: hr_utility.set_message(801, 'HR_AU_ACCRUAL_PLAN_NOT_FOUND');
117: hr_utility.raise_error;
118: end if ;
119:
120: FETCH csr_get_accrual_plan_id INTO l_dummy ;
121:

Line 125: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);

121:
122: IF csr_get_accrual_plan_id%FOUND
123: THEN
124: CLOSE csr_get_accrual_plan_id;
125: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
126: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
127: hr_utility.raise_error;
128: END IF;
129:

Line 126: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');

122: IF csr_get_accrual_plan_id%FOUND
123: THEN
124: CLOSE csr_get_accrual_plan_id;
125: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
126: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
127: hr_utility.raise_error;
128: END IF;
129:
130: CLOSE csr_get_accrual_plan_id;

Line 127: hr_utility.raise_error;

123: THEN
124: CLOSE csr_get_accrual_plan_id;
125: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
126: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
127: hr_utility.raise_error;
128: END IF;
129:
130: CLOSE csr_get_accrual_plan_id;
131: hr_utility.set_location('Leaving:'||l_proc,20);

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

127: hr_utility.raise_error;
128: END IF;
129:
130: CLOSE csr_get_accrual_plan_id;
131: hr_utility.set_location('Leaving:'||l_proc,20);
132:
133: RETURN l_accrual_plan_id;
134:
135: -- EXCEPTION

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

133: RETURN l_accrual_plan_id;
134:
135: -- EXCEPTION
136: -- WHEN OTHERS THEN
137: -- hr_utility.set_location('Leaving:'||l_proc,99);
138: -- RETURN NULL;
139: END get_accrual_plan_by_category;
140:
141:

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

180: -- Bug No : 2132299 End
181: --------------------------------------
182:
183: BEGIN
184: hr_utility.set_location('Entering: '||l_proc,10) ;
185: l_assignment_id := p_assignment_id ;
186: l_plan_id := p_plan_id ;
187: l_payroll_id := p_payroll_id ;
188: l_business_group_id := p_business_group_id ;

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

235: --------------------------------------
236: -- Bug No : 2132299 End
237: --------------------------------------
238:
239: hr_utility.set_location('Leaving '||l_proc,20);
240: RETURN l_net_entitlement ;
241:
242: END get_net_accrual ;
243:

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

340:
341:
342: BEGIN
343:
344: hr_utility.set_location('Entering: '||l_proc,10) ;
345: l_assignment_id := p_assignment_id ;
346: l_plan_id := p_plan_id ;
347: l_payroll_id := p_payroll_id ;
348: l_business_group_id := p_business_group_id ;

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

507: p_calc_start_date := l_start_date;
508: p_last_accrual := l_accrual_end_date;
509: p_next_period_end := l_accrual_period_end_date - 1;
510:
511: hr_utility.set_location('Leaving '||l_proc,20);
512: RETURN (0);
513:
514: -- EXCEPTION
515: -- WHEN OTHERS

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

513:
514: -- EXCEPTION
515: -- WHEN OTHERS
516: -- THEN
517: -- hr_utility.set_location('Leaving:'||l_proc,99);
518: -- RETURN -99;
519:
520: END get_accrual_entitlement ;
521:

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

556: WHERE lookup_type = 'ABSENCE_CATEGORY'
557: AND meaning = 'Annual Leave');
558:
559: BEGIN
560: hr_utility.set_location('Entering: '||l_proc,5);
561: OPEN csr_annual_leave_accrual_plan (p_business_group_id
562: ,p_calculation_date
563: ,p_assignment_id);
564:

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

563: ,p_assignment_id);
564:
565: FETCH csr_annual_leave_accrual_plan INTO l_plan_id;
566: CLOSE csr_annual_leave_accrual_plan;
567: hr_utility.set_location('Leaving:'||l_proc,10);
568: RETURN l_plan_id;
569:
570: -- EXCEPTION
571: -- WHEN OTHERS

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

569:
570: -- EXCEPTION
571: -- WHEN OTHERS
572: -- THEN
573: -- hr_utility.set_location('Leaving:'||l_proc,99);
574: -- RETURN NULL;
575: END;
576:
577:

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

624: AND hrl.lookup_type = 'NAME_TRANSLATIONS'
625: AND hrl.lookup_code = 'PTO_CONTINUOUS_SD';
626:
627: BEGIN
628: hr_utility.set_location('Entering:'||l_proc,5);
629: OPEN csr_continuous_service_date (p_business_group_id
630: ,p_accrual_plan_id
631: ,p_calculation_date
632: ,p_assignment_id);

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

631: ,p_calculation_date
632: ,p_assignment_id);
633: FETCH csr_continuous_service_date INTO l_csd;
634: CLOSE csr_continuous_service_date;
635: hr_utility.set_location('Leaving:'||l_proc,10);
636: RETURN l_csd;
637:
638: -- EXCEPTION
639: -- WHEN OTHERS

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

637:
638: -- EXCEPTION
639: -- WHEN OTHERS
640: -- THEN
641: -- hr_utility.set_location('Leaving:'||l_proc,99);
642: -- RETURN NULL;
643: END;
644:
645:

Line 753: hr_utility.trace(' In: ' || l_procedure_name) ;

749: l_band_notfound_flag boolean := true ;
750:
751: begin
752:
753: hr_utility.trace(' In: ' || l_procedure_name) ;
754:
755: -- loop through the PL/SQL table looking for a likely accrual band
756: while l_accrual_band_cache.count > 0
757: and l_band_notfound_flag

Line 782: hr_utility.trace(' Out: ' || l_procedure_name ||' '|| l_annual_accrual) ;

778: raise e_accrual_function_failure ;
779:
780: end if ;
781:
782: hr_utility.trace(' Out: ' || l_procedure_name ||' '|| l_annual_accrual) ;
783: return l_annual_accrual ;
784:
785: end accrual_annual_rate ;
786:

Line 799: hr_utility.trace(' In: ' || l_procedure_name) ;

795: l_hours_notfound_flag boolean := true ;
796:
797: begin
798:
799: hr_utility.trace(' In: ' || l_procedure_name) ;
800: hr_utility.trace('p_effective_date = '||to_char(p_effective_date, 'DD-MON-YYYY'));
801:
802: -- loop through the PL/SQL table looking for a likely accrual band
803: while l_asg_work_day_info_cache.count > 0

Line 800: hr_utility.trace('p_effective_date = '||to_char(p_effective_date, 'DD-MON-YYYY'));

796:
797: begin
798:
799: hr_utility.trace(' In: ' || l_procedure_name) ;
800: hr_utility.trace('p_effective_date = '||to_char(p_effective_date, 'DD-MON-YYYY'));
801:
802: -- loop through the PL/SQL table looking for a likely accrual band
803: while l_asg_work_day_info_cache.count > 0
804: and l_hours_notfound_flag

Line 826: hr_utility.trace(' Failed_mk: ' || l_procedure_name ) ;

822: -- raise error if no working hours found
823: if l_hours_notfound_flag
824: then
825:
826: hr_utility.trace(' Failed_mk: ' || l_procedure_name ) ;
827: hr_utility.trace(' End Date: ' || to_char(l_asg_work_day_info_cache(l_counter).effective_end_date, 'DD-MON-YYYY'));
828: raise e_accrual_function_failure ;
829:
830: end if ;

Line 827: hr_utility.trace(' End Date: ' || to_char(l_asg_work_day_info_cache(l_counter).effective_end_date, 'DD-MON-YYYY'));

823: if l_hours_notfound_flag
824: then
825:
826: hr_utility.trace(' Failed_mk: ' || l_procedure_name ) ;
827: hr_utility.trace(' End Date: ' || to_char(l_asg_work_day_info_cache(l_counter).effective_end_date, 'DD-MON-YYYY'));
828: raise e_accrual_function_failure ;
829:
830: end if ;
831:

Line 832: hr_utility.trace(' Out: ' || l_procedure_name) ;

828: raise e_accrual_function_failure ;
829:
830: end if ;
831:
832: hr_utility.trace(' Out: ' || l_procedure_name) ;
833: return l_asg_working_hours ;
834:
835:
836:

Line 841: hr_utility.trace('In: ' || l_procedure_name) ;

837: end asg_working_hours ;
838:
839: begin
840:
841: hr_utility.trace('In: ' || l_procedure_name) ;
842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;

Line 842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;

838:
839: begin
840:
841: hr_utility.trace('In: ' || l_procedure_name) ;
842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;

Line 843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;

839: begin
840:
841: hr_utility.trace('In: ' || l_procedure_name) ;
842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;

Line 844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;

840:
841: hr_utility.trace('In: ' || l_procedure_name) ;
842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;

Line 845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;

841: hr_utility.trace('In: ' || l_procedure_name) ;
842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;

Line 846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;

842: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
850:

Line 847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;

843: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
850:
851: -- cache the assignment's work day history

Line 848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;

844: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
850:
851: -- cache the assignment's work day history
852:

Line 849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;

845: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'DD-MM-YYYY')) ;
846: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'DD-MM-YYYY')) ;
847: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'DD-MM-YYYY')) ;
848: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
849: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
850:
851: -- cache the assignment's work day history
852:
853: l_counter := 1 ;

Line 1035: hr_utility.trace('Out: ' || l_procedure_name) ;

1031: l_accrual := l_accrual + l_period_accrual ;
1032:
1033: end loop ; -- c_periods
1034:
1035: hr_utility.trace('Out: ' || l_procedure_name) ;
1036: return l_accrual ;
1037:
1038: -- exception
1039: -- when e_accrual_function_failure

Line 1041: -- hr_utility.set_message(801, 'HR_AU_ACCRUAL_FUNCTION_FAILURE') ;

1037:
1038: -- exception
1039: -- when e_accrual_function_failure
1040: -- then
1041: -- hr_utility.set_message(801, 'HR_AU_ACCRUAL_FUNCTION_FAILURE') ;
1042: -- hr_utility.raise_error ;
1043:
1044: end accrual_daily_basis ;
1045:

Line 1042: -- hr_utility.raise_error ;

1038: -- exception
1039: -- when e_accrual_function_failure
1040: -- then
1041: -- hr_utility.set_message(801, 'HR_AU_ACCRUAL_FUNCTION_FAILURE') ;
1042: -- hr_utility.raise_error ;
1043:
1044: end accrual_daily_basis ;
1045:
1046:

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

1082: l_days_suspended NUMBER := 0;
1083:
1084: BEGIN
1085:
1086: hr_utility.set_location('Entering'||l_proc,5);
1087: -- hr_utility.trace(TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '
1088: -- ||TO_CHAR(p_end_date,'DD-MM-YYYY'));
1089:
1090: IF (p_start_date > p_end_date) THEN

Line 1087: -- hr_utility.trace(TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '

1083:
1084: BEGIN
1085:
1086: hr_utility.set_location('Entering'||l_proc,5);
1087: -- hr_utility.trace(TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '
1088: -- ||TO_CHAR(p_end_date,'DD-MM-YYYY'));
1089:
1090: IF (p_start_date > p_end_date) THEN
1091: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');

Line 1091: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');

1087: -- hr_utility.trace(TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '
1088: -- ||TO_CHAR(p_end_date,'DD-MM-YYYY'));
1089:
1090: IF (p_start_date > p_end_date) THEN
1091: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
1092: hr_utility.raise_error;
1093: END IF;
1094:
1095: OPEN csr_days_suspended(p_assignment_id

Line 1092: hr_utility.raise_error;

1088: -- ||TO_CHAR(p_end_date,'DD-MM-YYYY'));
1089:
1090: IF (p_start_date > p_end_date) THEN
1091: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
1092: hr_utility.raise_error;
1093: END IF;
1094:
1095: OPEN csr_days_suspended(p_assignment_id
1096: ,p_start_date

Line 1101: hr_utility.trace('Days Suspended between '

1097: ,p_end_date);
1098: FETCH csr_days_suspended INTO l_days_suspended;
1099: CLOSE csr_days_suspended;
1100:
1101: hr_utility.trace('Days Suspended between '
1102: ||TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '
1103: ||TO_CHAR(p_end_date,'DD-MM-YYYY')||' = '
1104: ||TO_CHAR(l_days_suspended));
1105: hr_utility.set_location('Leaving:'||l_proc,10);

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

1101: hr_utility.trace('Days Suspended between '
1102: ||TO_CHAR(p_start_date,'DD-MM-YYYY')||' and '
1103: ||TO_CHAR(p_end_date,'DD-MM-YYYY')||' = '
1104: ||TO_CHAR(l_days_suspended));
1105: hr_utility.set_location('Leaving:'||l_proc,10);
1106:
1107: RETURN l_days_suspended;
1108:
1109: -- EXCEPTION

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

1107: RETURN l_days_suspended;
1108:
1109: -- EXCEPTION
1110: -- WHEN others THEN
1111: -- hr_utility.set_location('Leaving:'||l_proc,99);
1112: -- RETURN NULL;
1113:
1114: END days_suspended;
1115:

Line 1138: hr_utility.set_location(' In: ' || l_proc,5) ;

1134: from per_time_periods tp
1135: where tp.payroll_id = p_payroll_id;
1136: begin
1137:
1138: hr_utility.set_location(' In: ' || l_proc,5) ;
1139:
1140: -- check payroll periods exist up to calculation_end_date
1141:
1142: open c_last_period ( p_payroll_id );

Line 1146: hr_utility.set_location(' Out: ' || l_proc,10) ;

1142: open c_last_period ( p_payroll_id );
1143: fetch c_last_period into l_end_date;
1144: close c_last_period;
1145:
1146: hr_utility.set_location(' Out: ' || l_proc,10) ;
1147:
1148: return(l_end_date);
1149:
1150: -- EXCEPTION

Line 1152: -- hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));

1148: return(l_end_date);
1149:
1150: -- EXCEPTION
1151: -- WHEN others THEN
1152: -- hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));
1153: -- hr_utility.set_location('Leaving:'||l_proc,99);
1154: -- RETURN NULL;
1155:
1156: end check_periods ;

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

1149:
1150: -- EXCEPTION
1151: -- WHEN others THEN
1152: -- hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));
1153: -- hr_utility.set_location('Leaving:'||l_proc,99);
1154: -- RETURN NULL;
1155:
1156: end check_periods ;
1157:

Line 1180: hr_utility.set_location(' In: ' || l_proc,5) ;

1176: l_adjust_date date := p_adjust_date;
1177:
1178: begin
1179:
1180: hr_utility.set_location(' In: ' || l_proc,5) ;
1181:
1182: -- loop to check each new period added on for suspended assignments
1183:
1184: while (l_days_suspended > 0) and (l_adjust_date < p_end_date) loop

Line 1198: hr_utility.set_location(' Out: ' || l_proc,10) ;

1194: if l_adjust_date > p_end_date then
1195: l_adjust_date := p_end_date;
1196: end if;
1197:
1198: hr_utility.set_location(' Out: ' || l_proc,10) ;
1199:
1200: return (l_adjust_date);
1201:
1202: -- EXCEPTION

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

1200: return (l_adjust_date);
1201:
1202: -- EXCEPTION
1203: -- WHEN others THEN
1204: -- hr_utility.set_location('Leaving:'||l_proc,99);
1205: -- RETURN NULL;
1206:
1207: end adjust_for_suspend_assign ;
1208:

Line 1275: hr_utility.set_location(' In: ' || l_proc,5) ;

1271: and pee.effective_start_date between v_start_date and v_end_date;
1272:
1273: begin
1274:
1275: hr_utility.set_location(' In: ' || l_proc,5) ;
1276:
1277: -- find total leave initialise - should return zero if none entered
1278:
1279: open c_get_initialise (p_assignment_id

Line 1288: hr_utility.trace('Initialise : '||to_char(l_initialise));

1284: ,p_end_date );
1285: fetch c_get_initialise into l_initialise;
1286: close c_get_initialise;
1287:
1288: hr_utility.trace('Initialise : '||to_char(l_initialise));
1289: hr_utility.set_location(' Out: ' || l_proc,10) ;
1290:
1291: return(nvl(l_initialise,0));
1292:

Line 1289: hr_utility.set_location(' Out: ' || l_proc,10) ;

1285: fetch c_get_initialise into l_initialise;
1286: close c_get_initialise;
1287:
1288: hr_utility.trace('Initialise : '||to_char(l_initialise));
1289: hr_utility.set_location(' Out: ' || l_proc,10) ;
1290:
1291: return(nvl(l_initialise,0));
1292:
1293: end get_leave_initialise ;

Line 1338: hr_utility.set_location(' In: ' || l_proc, 5) ;

1334: ab.lower_limit ;
1335:
1336: begin
1337:
1338: hr_utility.set_location(' In: ' || l_proc, 5) ;
1339:
1340: open c_accrual_bands (p_accrual_plan_id);
1341: fetch c_accrual_bands into l_first_period;
1342: fetch c_accrual_bands into l_subsequent_periods;

Line 1345: hr_utility.trace('First : '||to_char(l_first_period) );

1341: fetch c_accrual_bands into l_first_period;
1342: fetch c_accrual_bands into l_subsequent_periods;
1343: close c_accrual_bands;
1344:
1345: hr_utility.trace('First : '||to_char(l_first_period) );
1346: hr_utility.trace('Subsequent : '||to_char(l_subsequent_periods) );
1347:
1348: if (l_first_period <= 0) OR (l_subsequent_periods <= 0) then
1349: hr_utility.set_message(801,'HR_AU_INVALID_LSL_PERIODS');

Line 1346: hr_utility.trace('Subsequent : '||to_char(l_subsequent_periods) );

1342: fetch c_accrual_bands into l_subsequent_periods;
1343: close c_accrual_bands;
1344:
1345: hr_utility.trace('First : '||to_char(l_first_period) );
1346: hr_utility.trace('Subsequent : '||to_char(l_subsequent_periods) );
1347:
1348: if (l_first_period <= 0) OR (l_subsequent_periods <= 0) then
1349: hr_utility.set_message(801,'HR_AU_INVALID_LSL_PERIODS');
1350: hr_utility.raise_error;

Line 1349: hr_utility.set_message(801,'HR_AU_INVALID_LSL_PERIODS');

1345: hr_utility.trace('First : '||to_char(l_first_period) );
1346: hr_utility.trace('Subsequent : '||to_char(l_subsequent_periods) );
1347:
1348: if (l_first_period <= 0) OR (l_subsequent_periods <= 0) then
1349: hr_utility.set_message(801,'HR_AU_INVALID_LSL_PERIODS');
1350: hr_utility.raise_error;
1351: end if;
1352:
1353: -- set entitlement date to end of first period plus any suspension

Line 1350: hr_utility.raise_error;

1346: hr_utility.trace('Subsequent : '||to_char(l_subsequent_periods) );
1347:
1348: if (l_first_period <= 0) OR (l_subsequent_periods <= 0) then
1349: hr_utility.set_message(801,'HR_AU_INVALID_LSL_PERIODS');
1350: hr_utility.raise_error;
1351: end if;
1352:
1353: -- set entitlement date to end of first period plus any suspension
1354: -- adjustment

Line 1381: hr_utility.set_location(' Out: ' || l_proc, 10) ;

1377: ,l_eot);
1378:
1379: end loop;
1380:
1381: hr_utility.set_location(' Out: ' || l_proc, 10) ;
1382:
1383: return (l_entitlement_date);
1384:
1385: -- EXCEPTION

Line 1387: -- hr_utility.trace('Error - cursor c_accrual_bands failed - Accrual Plan ID: '||to_char(p_accrual_plan_id) );

1383: return (l_entitlement_date);
1384:
1385: -- EXCEPTION
1386: -- WHEN others THEN
1387: -- hr_utility.trace('Error - cursor c_accrual_bands failed - Accrual Plan ID: '||to_char(p_accrual_plan_id) );
1388: -- hr_utility.set_location('Leaving: '||l_proc,99);
1389: -- RETURN (p_service_start_date - 1);
1390:
1391: end get_lsl_entitlement_date;

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

1384:
1385: -- EXCEPTION
1386: -- WHEN others THEN
1387: -- hr_utility.trace('Error - cursor c_accrual_bands failed - Accrual Plan ID: '||to_char(p_accrual_plan_id) );
1388: -- hr_utility.set_location('Leaving: '||l_proc,99);
1389: -- RETURN (p_service_start_date - 1);
1390:
1391: end get_lsl_entitlement_date;
1392:

Line 1418: hr_utility.set_location(' In: ' || l_proc, 5) ;

1414: and pap.accrual_plan_name = v_entry_value;
1415:
1416: begin
1417:
1418: hr_utility.set_location(' In: ' || l_proc, 5) ;
1419:
1420: open c_plan_name ( p_business_group_id
1421: ,p_entry_value);
1422: fetch c_plan_name into l_plan_exists;

Line 1430: hr_utility.set_location(' Out: ' || l_proc, 10) ;

1426: end if;
1427:
1428: close c_plan_name;
1429:
1430: hr_utility.set_location(' Out: ' || l_proc, 10) ;
1431:
1432: return (l_plan_exists);
1433:
1434: --EXCEPTION

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

1432: return (l_plan_exists);
1433:
1434: --EXCEPTION
1435: -- WHEN others THEN
1436: -- hr_utility.set_location('Leaving: '||l_proc,99);
1437: -- RETURN (99);
1438:
1439: end validate_accrual_plan_name;
1440: