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

Line 37: hr_utility.trace('Entering: ' || l_proc);

33: and pee.assignment_id = p_asg_id;
34:
35: BEGIN
36:
37: hr_utility.trace('Entering: ' || l_proc);
38: open csr_tax_defaulting(p_assignment_id);
39: fetch csr_tax_defaulting into l_default_date;
40:
41: if csr_tax_defaulting%NOTFOUND then

Line 51: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

47: close csr_tax_defaulting;
48:
49: if (p_process_date is null) then
50: if (p_actual_termination_date is null) then
51: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE','PROCESS_US_TAX_RULES');
53: hr_utility.set_message_token('STEP',1);
54: hr_utility.raise_error;
55:

Line 52: hr_utility.set_message_token('PROCEDURE','PROCESS_US_TAX_RULES');

48:
49: if (p_process_date is null) then
50: if (p_actual_termination_date is null) then
51: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE','PROCESS_US_TAX_RULES');
53: hr_utility.set_message_token('STEP',1);
54: hr_utility.raise_error;
55:
56: else

Line 53: hr_utility.set_message_token('STEP',1);

49: if (p_process_date is null) then
50: if (p_actual_termination_date is null) then
51: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE','PROCESS_US_TAX_RULES');
53: hr_utility.set_message_token('STEP',1);
54: hr_utility.raise_error;
55:
56: else
57: l_new_end_date := hr_api.g_eot;

Line 54: hr_utility.raise_error;

50: if (p_actual_termination_date is null) then
51: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE','PROCESS_US_TAX_RULES');
53: hr_utility.set_message_token('STEP',1);
54: hr_utility.raise_error;
55:
56: else
57: l_new_end_date := hr_api.g_eot;
58: l_ef_date := p_actual_termination_date;

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

64: end if;
65:
66: if hr_general.chk_maintain_tax_records = 'Y' then
67:
68: hr_utility.set_location(l_proc,6);
69: UPDATE pay_us_emp_fed_tax_rules_f peft
70: SET peft.effective_end_date = l_new_end_date
71: WHERE peft.assignment_id = p_assignment_id
72: AND l_ef_date

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

75: DELETE pay_us_emp_fed_tax_rules_f peft
76: WHERE peft.assignment_id = p_assignment_id
77: AND peft.effective_start_date > l_ef_date;
78: --
79: hr_utility.set_location(l_proc,7);
80: UPDATE pay_us_emp_state_tax_rules_f pest
81: SET pest.effective_end_date = l_new_end_date
82: WHERE pest.assignment_id = p_assignment_id
83: AND l_ef_date

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

86: DELETE pay_us_emp_state_tax_rules_f pest
87: WHERE pest.assignment_id = p_assignment_id
88: AND pest.effective_start_date > l_ef_date;
89: --
90: hr_utility.set_location(l_proc,8);
91: UPDATE pay_us_emp_county_tax_rules_f pect
92: SET pect.effective_end_date = l_new_end_date
93: WHERE pect.assignment_id = p_assignment_id
94: AND l_ef_date

Line 101: hr_utility.set_location(l_proc,9);

97: DELETE pay_us_emp_county_tax_rules_f pect
98: WHERE pect.assignment_id = p_assignment_id
99: AND pect.effective_start_date > l_ef_date;
100: --
101: hr_utility.set_location(l_proc,9);
102: UPDATE pay_us_emp_city_tax_rules_f pecit
103: SET pecit.effective_end_date = l_new_end_date
104: WHERE pecit.assignment_id = p_assignment_id
105: AND l_ef_date

Line 114: if hr_utility.chk_product_install(p_product =>'Oracle Payroll',

110: AND pecit.effective_start_date > l_ef_date;
111: --
112: end if; -- maintaining tax records
113:
114: if hr_utility.chk_product_install(p_product =>'Oracle Payroll',
115: p_legislation => 'US')
116: and p_process_date is null then
117:
118: -- We need to clean out the Vertex Element Entries.

Line 133: hr_utility.set_location(l_proc,10);

129: else
130: l_dt_mode := hr_api.g_future_change;
131: end if;
132:
133: hr_utility.set_location(l_proc,10);
134: for c_ele_rec in csr_tax_entries(p_assignment_id,l_ef_date)
135: loop
136:
137: hr_entry_api.delete_element_entry(

Line 148: hr_utility.trace(' Leaving: ' || l_proc);

144: end loop;
145:
146: end if; -- payroll installed
147:
148: hr_utility.trace(' Leaving: ' || l_proc);
149:
150:
151: EXCEPTION
152: when NO_DATA_FOUND then

Line 163: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||

159: ,p_process_date DATE)
160: IS
161: BEGIN
162: --
163: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||
164: p_assignment_id );
165: --
166: hr_utility.set_location
167: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);

Line 166: hr_utility.set_location

162: --
163: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||
164: p_assignment_id );
165: --
166: hr_utility.set_location
167: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);
168: UPDATE pay_us_emp_fed_tax_rules_f peft
169: SET peft.effective_end_date =
170: to_date('31/12/4712','DD/MM/YYYY')

Line 174: hr_utility.set_location

170: to_date('31/12/4712','DD/MM/YYYY')
171: WHERE peft.assignment_id = p_assignment_id
172: AND peft.effective_end_date = p_process_date;
173: --
174: hr_utility.set_location
175: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',6);
176: UPDATE pay_us_emp_state_tax_rules_f pest
177: SET pest.effective_end_date =
178: to_date('31/12/4712','DD/MM/YYYY')

Line 182: hr_utility.set_location

178: to_date('31/12/4712','DD/MM/YYYY')
179: WHERE pest.assignment_id = p_assignment_id
180: AND pest.effective_end_date = p_process_date;
181: --
182: hr_utility.set_location
183: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',7);
184: UPDATE pay_us_emp_county_tax_rules_f pect
185: SET pect.effective_end_date =
186: to_date('31/12/4712','DD/MM/YYYY')

Line 190: hr_utility.set_location

186: to_date('31/12/4712','DD/MM/YYYY')
187: WHERE pect.assignment_id = p_assignment_id
188: AND pect.effective_end_date = p_process_date;
189: --
190: hr_utility.set_location
191: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',8);
192: UPDATE pay_us_emp_city_tax_rules_f pecit
193: SET pecit.effective_end_date =
194: to_date('31/12/4712','DD/MM/YYYY')