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

Line 162: hr_utility.trace('Entering HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');

158: l_dummy varchar2(1) ;
159:
160: begin
161:
162: hr_utility.trace('Entering HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');
163: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
164: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
165:
166: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712

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

159:
160: begin
161:
162: hr_utility.trace('Entering HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');
163: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
164: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
165:
166: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712
167: If p_final_process_date IS NULL OR p_final_process_date = hr_api.g_date Then

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

160: begin
161:
162: hr_utility.trace('Entering HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');
163: hr_utility.trace('p_period_of_service_id := '|| p_period_of_service_id) ;
164: hr_utility.trace('p_final_process_date := '||to_char(p_final_process_date,'dd/mon/yyyy')) ;
165:
166: -- If FPD is entered NULL we need to end date Tax records as of 31st Dec,4712
167: If p_final_process_date IS NULL OR p_final_process_date = hr_api.g_date Then
168: l_final_process_date := fnd_date.canonical_to_date('4712/12/31 00:00:00') ;

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

168: l_final_process_date := fnd_date.canonical_to_date('4712/12/31 00:00:00') ;
169: Else
170: l_final_process_date := p_final_process_date ;
171: End If ;
172: hr_utility.trace('l_final_process_date := '||to_char(l_final_process_date,'dd/mon/yyyy')) ;
173:
174: open c_get_person_oldfpd(p_period_of_service_id) ;
175: loop
176: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;

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

175: loop
176: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;
177: exit when c_get_person_oldfpd%NOTFOUND ;
178:
179: hr_utility.trace('l_person_id := '||l_person_id) ;
180: hr_utility.trace('l_old_fpd := '||l_old_fpd) ;
181:
182: If l_old_fpd IS NOT NULL Then
183: -- If Old FPD is Null proper End-Dating of Tax records will happen

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

176: fetch c_get_person_oldfpd into l_person_id, l_old_fpd ;
177: exit when c_get_person_oldfpd%NOTFOUND ;
178:
179: hr_utility.trace('l_person_id := '||l_person_id) ;
180: hr_utility.trace('l_old_fpd := '||l_old_fpd) ;
181:
182: If l_old_fpd IS NOT NULL Then
183: -- If Old FPD is Null proper End-Dating of Tax records will happen
184: -- by HR_EX_EMPLOYEE_BK2.FINAL_PROCESS_EMP_B so we are not updating Tax Records here

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

186: OPEN c_compl_pay_act(l_final_process_date) ;
187: FETCH c_compl_pay_act INTO l_dummy;
188: IF c_compl_pay_act%FOUND THEN
189: CLOSE c_compl_pay_act;
190: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
191: hr_utility.raise_error;
192: ELSE -- No Future Dated Payroll Action exists after the new Final Process Date
193:
194: open c_get_assignments(l_person_id) ;

Line 191: hr_utility.raise_error;

187: FETCH c_compl_pay_act INTO l_dummy;
188: IF c_compl_pay_act%FOUND THEN
189: CLOSE c_compl_pay_act;
190: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
191: hr_utility.raise_error;
192: ELSE -- No Future Dated Payroll Action exists after the new Final Process Date
193:
194: open c_get_assignments(l_person_id) ;
195: loop

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

193:
194: open c_get_assignments(l_person_id) ;
195: loop
196: fetch c_get_assignments into l_assignment_id ;
197: hr_utility.trace('l_assignment_id := '||l_assignment_id) ;
198: exit when c_get_assignments%NOTFOUND ;
199:
200: open c_get_fedtax_rules(l_assignment_id, l_final_process_date ) ;
201: loop

Line 204: hr_utility.trace('l_emp_fed_tax_rule_id := '||l_emp_fed_tax_rule_id) ;

200: open c_get_fedtax_rules(l_assignment_id, l_final_process_date ) ;
201: loop
202: fetch c_get_fedtax_rules into l_emp_fed_tax_rule_id, l_eff_st_dt, l_eff_end_dt ;
203: exit when c_get_fedtax_rules%NOTFOUND ;
204: hr_utility.trace('l_emp_fed_tax_rule_id := '||l_emp_fed_tax_rule_id) ;
205:
206: -- Updating Fed Tax Rules
207: update pay_us_emp_fed_tax_rules_f
208: set effective_end_date = l_final_process_date

Line 219: hr_utility.trace('l_emp_st_tax_rule_id := '||l_emp_st_tax_rule_id) ;

215: open c_get_statetax_rules(l_assignment_id, l_final_process_date) ;
216: loop
217: fetch c_get_statetax_rules into l_emp_st_tax_rule_id, l_eff_st_dt, l_eff_end_dt ;
218: exit when c_get_statetax_rules%NOTFOUND ;
219: hr_utility.trace('l_emp_st_tax_rule_id := '||l_emp_st_tax_rule_id) ;
220:
221: -- Updating State Tax Rules
222: update pay_us_emp_state_tax_rules_f
223: set effective_end_date = l_final_process_date

Line 234: hr_utility.trace('l_emp_county_tax_rule_id := '||l_emp_county_tax_rule_id) ;

230: open c_get_countytax_rules(l_assignment_id, l_final_process_date) ;
231: loop
232: fetch c_get_countytax_rules into l_emp_county_tax_rule_id, l_eff_st_dt, l_eff_end_dt ;
233: exit when c_get_countytax_rules%NOTFOUND ;
234: hr_utility.trace('l_emp_county_tax_rule_id := '||l_emp_county_tax_rule_id) ;
235:
236: -- Updating County Tax Rules
237: update pay_us_emp_county_tax_rules_f
238: set effective_end_date = l_final_process_date

Line 250: hr_utility.trace('l_emp_city_tax_rule_id := '||l_emp_city_tax_rule_id) ;

246: open c_get_citytax_rules(l_assignment_id, l_final_process_date) ;
247: loop
248: fetch c_get_citytax_rules into l_emp_city_tax_rule_id, l_eff_st_dt, l_eff_end_dt ;
249: exit when c_get_citytax_rules%NOTFOUND ;
250: hr_utility.trace('l_emp_city_tax_rule_id := '||l_emp_city_tax_rule_id) ;
251:
252: -- Updating City Tax Rules
253: update pay_us_emp_city_tax_rules_f
254: set effective_end_date = l_final_process_date

Line 267: hr_utility.trace('Leaving HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');

263: CLOSE c_compl_pay_act ;
264: END IF ; -- Old FPD is not Null
265: end loop ;
266: close c_get_person_oldfpd ;
267: hr_utility.trace('Leaving HR_US_PERSON_TERM_LEG_HOOK.update_tax_rules');
268: end update_tax_rules ;
269:
270: end HR_US_PERSON_TERM_LEG_HOOK ;