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.

[Home] [Help]

APPS.PAY_US_TAX_BALANCE_PERF dependencies on HR_UTILITY

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

44: PROCEDURE local_error(p_procedure varchar2,
45: p_step number) IS
46: BEGIN
47: --
48: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE',
50: 'pay_us_tax_balance_perf.'||p_procedure);
51: hr_utility.set_message_token('STEP',p_step);
52: hr_utility.raise_error;

Line 49: hr_utility.set_message_token('PROCEDURE',

45: p_step number) IS
46: BEGIN
47: --
48: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE',
50: 'pay_us_tax_balance_perf.'||p_procedure);
51: hr_utility.set_message_token('STEP',p_step);
52: hr_utility.raise_error;
53: --

Line 51: hr_utility.set_message_token('STEP',p_step);

47: --
48: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE',
50: 'pay_us_tax_balance_perf.'||p_procedure);
51: hr_utility.set_message_token('STEP',p_step);
52: hr_utility.raise_error;
53: --
54: END local_error;
55: -------------------------------------------------------------------------------

Line 52: hr_utility.raise_error;

48: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE',
50: 'pay_us_tax_balance_perf.'||p_procedure);
51: hr_utility.set_message_token('STEP',p_step);
52: hr_utility.raise_error;
53: --
54: END local_error;
55: -------------------------------------------------------------------------------
56: --

Line 95: hr_utility.trace('Looking for def_bal: ' || p_balance_name ||

91: --
92: if (l_found = FALSE) then
93: BEGIN
94: --
95: hr_utility.trace('Looking for def_bal: ' || p_balance_name ||
96: ' : ' || p_dimension_suffix);
97: --
98: SELECT creator_id
99: INTO l_defined_balance_id

Line 110: hr_utility.trace('Calling core balance user exit');

106: --
107: g_defbal_tbl_name(g_nxt_free_defbal) := l_defbal_name;
108: g_defbal_tbl_id(g_nxt_free_defbal) := l_defined_balance_id;
109: g_nxt_free_defbal := g_nxt_free_defbal + 1;
110: hr_utility.trace('Calling core balance user exit');
111: --
112: EXCEPTION WHEN no_data_found THEN
113: hr_utility.trace('Error: Failure to find defined balance');
114: local_error('call_balance_user_exit',1);

Line 113: hr_utility.trace('Error: Failure to find defined balance');

109: g_nxt_free_defbal := g_nxt_free_defbal + 1;
110: hr_utility.trace('Calling core balance user exit');
111: --
112: EXCEPTION WHEN no_data_found THEN
113: hr_utility.trace('Error: Failure to find defined balance');
114: local_error('call_balance_user_exit',1);
115: --
116: END;
117: --

Line 170: hr_utility.trace('Error: Invalid tax balance category');

166: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
167: AND lookup_code = p_tax_balance_category;
168: --
169: IF l_valid = 0 THEN
170: hr_utility.trace('Error: Invalid tax balance category');
171: local_error('us_tax_balance',1);
172: END IF;
173: --
174: SELECT count(*)

Line 181: hr_utility.trace('Error: Invalid tax type');

177: WHERE lookup_type = 'US_TAX_TYPE'
178: AND lookup_code = p_tax_type;
179: --
180: IF l_valid = 0 THEN
181: hr_utility.trace('Error: Invalid tax type');
182: local_error('us_tax_balance',2);
183: END IF;
184: --
185: SELECT count(*)

Line 191: hr_utility.trace('Error: Invalid asg_type parameter');

187: FROM dual
188: WHERE p_asg_type in ('ASG','PER','GRE');
189: --
190: IF l_valid = 0 THEN
191: hr_utility.trace('Error: Invalid asg_type parameter');
192: local_error('us_tax_balance',3);
193: END IF;
194: --
195: SELECT count(*)

Line 201: hr_utility.trace('Error: Invalid time_type parameter');

197: FROM dual
198: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE');
199: --
200: IF l_valid = 0 THEN
201: hr_utility.trace('Error: Invalid time_type parameter');
202: local_error('us_tax_balance',4);
203: END IF;
204: --
205: -- Set the contexts used in the bal user exit. Same throughout, so set

Line 208: hr_utility.set_location('pay_tax_bals_pkg',30);

204: --
205: -- Set the contexts used in the bal user exit. Same throughout, so set
206: -- them up front
207: --
208: hr_utility.set_location('pay_tax_bals_pkg',30);
209: --
210: IF p_jd_context IS NOT NULL THEN
211: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
212: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||

Line 219: hr_utility.set_location('pay_tax_bals_pkg',40);

215: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
216: END IF;
217: END IF;
218: --
219: hr_utility.set_location('pay_tax_bals_pkg',40);
220: --
221: l_assignment_id := p_assignment_id;
222: l_assignment_action_id := p_assignment_action_id;
223: l_tax_type := p_tax_type;

Line 229: hr_utility.set_location('pay_tax_bals_pkg',50);

225: l_virtual_date := p_virtual_date;
226: --
227: -- Check if assignment exists at l_virtual_date, if using date mode
228: --
229: hr_utility.set_location('pay_tax_bals_pkg',50);
230: --
231: --
232: -- Convert "WITHHELD" to proper balance categories;
233: --

Line 234: hr_utility.set_location('pay_tax_bals_pkg',80);

230: --
231: --
232: -- Convert "WITHHELD" to proper balance categories;
233: --
234: hr_utility.set_location('pay_tax_bals_pkg',80);
235: --
236: IF l_tax_balance_category = 'WITHHELD' THEN
237: IF p_ee_or_er = 'ER' or l_tax_type = 'FUTA' or l_tax_type = 'HT' THEN
238: l_tax_balance_category := 'LIABILITY';

Line 249: hr_utility.set_location('pay_tax_bals_pkg',90);

245: END IF;
246: --
247: -- Check if illegal tax combo (FIT and TAXABLE, FUTA and SUBJ_NWHABLE, etc.)
248: --
249: hr_utility.set_location('pay_tax_bals_pkg',90);
250: --
251: IF (l_tax_type = 'FIT' or l_tax_type = 'SIT' or l_tax_type = 'COUNTY' or
252: l_tax_type = 'CITY' or l_tax_type = 'EIC' or l_tax_type = 'HT' or
253: l_tax_type = 'SCHOOL') THEN -- income tax

Line 256: hr_utility.trace('Error: Illegal tax category for tax type');

252: l_tax_type = 'CITY' or l_tax_type = 'EIC' or l_tax_type = 'HT' or
253: l_tax_type = 'SCHOOL') THEN -- income tax
254: IF (l_tax_balance_category = 'TAXABLE' or
255: l_tax_balance_category = 'EXCESS') THEN
256: hr_utility.trace('Error: Illegal tax category for tax type');
257: local_error('us_tax_balance',5);
258: END IF;
259: --
260: -- return 0 for currently unsupported EIC balances.

Line 278: hr_utility.set_location('pay_tax_bals_pkg',100);

274: return 0;
275: END IF;
276: END IF;
277: --
278: hr_utility.set_location('pay_tax_bals_pkg',100);
279: --
280: l_ee_or_er := ltrim(rtrim(p_ee_or_er));
281: --
282: --------------- Some Error Checking -------------

Line 288: hr_utility.trace('Error: ER not allowed for tax type');

284: --
285: if (l_tax_type = 'FIT' or l_tax_type = 'SIT' or l_tax_type = 'CITY' or
286: l_tax_type = 'COUNTY' or l_tax_type = 'EIC' or l_tax_type = 'SCHOOL') THEN
287: if l_ee_or_er = 'ER' THEN
288: hr_utility.trace('Error: ER not allowed for tax type');
289: local_error('us_tax_balance',6);
290: else
291: l_ee_or_er := NULL;
292: end if;

Line 295: hr_utility.trace('Error: EE not allowed for tax type');

291: l_ee_or_er := NULL;
292: end if;
293: elsif (l_tax_type = 'FUTA' or l_tax_type = 'HT') THEN
294: if l_ee_or_er = 'EE' THEN
295: hr_utility.trace('Error: EE not allowed for tax type');
296: local_error('us_tax_balance',7);
297: else
298: l_ee_or_er := NULL;
299: end if;

Line 303: hr_utility.trace('Error: EE or ER required for tax type');

299: end if;
300: elsif (l_tax_type = 'SS' or l_tax_type = 'MEDICARE' or l_tax_type = 'SDI' or
301: l_tax_type = 'SUI') THEN
302: if (l_ee_or_er <> 'EE' and l_ee_or_er <> 'ER') THEN
303: hr_utility.trace('Error: EE or ER required for tax type');
304: local_error('us_tax_balance',8);
305: end if;
306: end if;
307: --

Line 308: hr_utility.set_location('pay_tax_bals_pkg',110);

304: local_error('us_tax_balance',8);
305: end if;
306: end if;
307: --
308: hr_utility.set_location('pay_tax_bals_pkg',110);
309: --
310: -- Force space at end of this parameter if necessary
311: --
312: hr_utility.set_location('pay_tax_bals_pkg',120);

Line 312: hr_utility.set_location('pay_tax_bals_pkg',120);

308: hr_utility.set_location('pay_tax_bals_pkg',110);
309: --
310: -- Force space at end of this parameter if necessary
311: --
312: hr_utility.set_location('pay_tax_bals_pkg',120);
313: --
314: IF l_ee_or_er IS NOT NULL THEN
315: l_ee_or_er := rtrim(l_ee_or_er)||' ';
316: END IF;

Line 785: hr_utility.trace('Returning : ' || l_return_value);

781: p_business_group_id);
782: END IF;
783: END IF;
784: --
785: hr_utility.trace('Returning : ' || l_return_value);
786: --
787: return l_return_value;
788: --
789: END us_tax_balance;