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

Line 124: hr_utility.trace('Entering HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');

120: l_dummy varchar2(1) ;
121:
122: begin
123:
124: hr_utility.trace('Entering HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');
125: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
126: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
127:
128: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712

Line 125: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;

121:
122: begin
123:
124: hr_utility.trace('Entering HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');
125: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
126: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
127:
128: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712
129: If p_final_process_date IS NULL OR p_final_process_date = hr_api.g_date Then

Line 126: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;

122: begin
123:
124: hr_utility.trace('Entering HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');
125: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
126: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
127:
128: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712
129: If p_final_process_date IS NULL OR p_final_process_date = hr_api.g_date Then
130: l_final_process_date := fnd_date.canonical_to_date('4712/12/31 00:00:00') ;

Line 134: hr_utility.trace('l_final_process_date := '||to_char(l_final_process_date,'dd/mon/yyyy')) ;

130: l_final_process_date := fnd_date.canonical_to_date('4712/12/31 00:00:00') ;
131: Else
132: l_final_process_date := p_final_process_date ;
133: End If ;
134: hr_utility.trace('l_final_process_date := '||to_char(l_final_process_date,'dd/mon/yyyy')) ;
135:
136: open c_get_person_oldfpd(p_period_of_service_id) ;
137: loop
138: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;

Line 141: hr_utility.trace('l_person_id := '||l_person_id) ;

137: loop
138: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;
139: exit when c_get_person_oldfpd%NOTFOUND ;
140:
141: hr_utility.trace('l_person_id := '||l_person_id) ;
142: hr_utility.trace('l_old_fpd := '||l_old_fpd) ;
143:
144: If l_old_fpd IS NOT NULL Then
145: -- If Old FPD is Null proper End-Dating of Tax records will happen

Line 142: hr_utility.trace('l_old_fpd := '||l_old_fpd) ;

138: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;
139: exit when c_get_person_oldfpd%NOTFOUND ;
140:
141: hr_utility.trace('l_person_id := '||l_person_id) ;
142: hr_utility.trace('l_old_fpd := '||l_old_fpd) ;
143:
144: If l_old_fpd IS NOT NULL Then
145: -- If Old FPD is Null proper End-Dating of Tax records will happen
146: -- by HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_B so we are not updating Tax Records here

Line 152: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');

148: OPEN c_compl_pay_act(l_final_process_date) ;
149: FETCH c_compl_pay_act INTO l_dummy;
150: IF c_compl_pay_act%FOUND THEN
151: CLOSE c_compl_pay_act;
152: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
153: hr_utility.raise_error;
154: ELSE -- No Future Dated Payroll Action exists after the new Final Process Date
155:
156: open c_get_assignments(l_person_id) ;

Line 153: hr_utility.raise_error;

149: FETCH c_compl_pay_act INTO l_dummy;
150: IF c_compl_pay_act%FOUND THEN
151: CLOSE c_compl_pay_act;
152: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
153: hr_utility.raise_error;
154: ELSE -- No Future Dated Payroll Action exists after the new Final Process Date
155:
156: open c_get_assignments(l_person_id) ;
157: loop

Line 159: hr_utility.trace('l_assignment_id := '||l_assignment_id) ;

155:
156: open c_get_assignments(l_person_id) ;
157: loop
158: fetch c_get_assignments into l_assignment_id ;
159: hr_utility.trace('l_assignment_id := '||l_assignment_id) ;
160: exit when c_get_assignments%NOTFOUND ;
161:
162: open c_get_fedtax_rules(l_assignment_id, l_final_process_date ) ;
163: loop

Line 166: hr_utility.trace('l_emp_fed_tax_inf_id := '||l_emp_fed_tax_inf_id) ;

162: open c_get_fedtax_rules(l_assignment_id, l_final_process_date ) ;
163: loop
164: fetch c_get_fedtax_rules into l_emp_fed_tax_inf_id, l_eff_st_dt, l_eff_end_dt ;
165: exit when c_get_fedtax_rules%NOTFOUND ;
166: hr_utility.trace('l_emp_fed_tax_inf_id := '||l_emp_fed_tax_inf_id) ;
167:
168: -- Updating Fed Tax Rules
169: update pay_ca_emp_fed_tax_info_f
170: set effective_end_date = l_final_process_date

Line 182: hr_utility.trace('l_emp_prov_tax_inf_id := '||l_emp_prov_tax_inf_id) ;

178: open c_get_provtax_rules(l_assignment_id, l_final_process_date) ;
179: loop
180: fetch c_get_provtax_rules into l_emp_prov_tax_inf_id, l_eff_st_dt, l_eff_end_dt ;
181: exit when c_get_provtax_rules%NOTFOUND ;
182: hr_utility.trace('l_emp_prov_tax_inf_id := '||l_emp_prov_tax_inf_id) ;
183:
184: -- Updating State Tax Rules
185: update pay_ca_emp_prov_tax_info_f
186: set effective_end_date = l_final_process_date

Line 204: hr_utility.trace('Leaving HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');

200: end loop ;
201:
202: close c_get_person_oldfpd ;
203:
204: hr_utility.trace('Leaving HR_CA_PERSON_TERM_LEG_HOOK.update_tax_rules');
205: end update_tax_rules ;
206:
207: end HR_CA_PERSON_TERM_LEG_HOOK ;