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

Line 94: hr_utility.trace('ltt_tax_type_values(1) = '||

90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||

Line 96: hr_utility.trace('ltt_tax_type_values(2) = '||

92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||

Line 98: hr_utility.trace('ltt_tax_type_values(3) = '||

94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||

Line 100: hr_utility.trace('ltt_tax_type_values(4) = '||

96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||

Line 102: hr_utility.trace('ltt_tax_type_values(5) = '||

98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||

Line 104: hr_utility.trace('ltt_tax_type_values(6) = '||

100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||

Line 106: hr_utility.trace('ltt_tax_type_values(7) = '||

102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||

Line 108: hr_utility.trace('ltt_tax_type_values(8) = '||

104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||

Line 110: hr_utility.trace('ltt_tax_type_values(9) = '||

106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||

Line 112: hr_utility.trace('ltt_tax_type_values(10) = '||

108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||
115: pay_ac_taxability_wrapper.ltt_tax_type_values(11));
116:

Line 114: hr_utility.trace('ltt_tax_type_values(11) = '||

110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||
115: pay_ac_taxability_wrapper.ltt_tax_type_values(11));
116:
117: END transfer_tax_type_values;
118:

Line 144: hr_utility.trace('No Taxability Rule Date found');

140: open c_taxability_rule_date(p_legislation_code
141: ,p_effective_date);
142: fetch c_taxability_rule_date into ln_taxability_rule_date_id;
143: if c_taxability_rule_date%notfound then
144: hr_utility.trace('No Taxability Rule Date found');
145: hr_utility.raise_error;
146: end if;
147: close c_taxability_rule_date;
148:

Line 145: hr_utility.raise_error;

141: ,p_effective_date);
142: fetch c_taxability_rule_date into ln_taxability_rule_date_id;
143: if c_taxability_rule_date%notfound then
144: hr_utility.trace('No Taxability Rule Date found');
145: hr_utility.raise_error;
146: end if;
147: close c_taxability_rule_date;
148:
149: return (ln_taxability_rule_date_id);

Line 205: hr_utility.trace('In create_us_federal_taxability');

201: ltt_tax_types(5) := 'SS';
202:
203: end if;
204:
205: hr_utility.trace('In create_us_federal_taxability');
206: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
207: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
208:
209: END create_us_federal_taxability;

Line 206: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

202:
203: end if;
204:
205: hr_utility.trace('In create_us_federal_taxability');
206: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
207: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
208:
209: END create_us_federal_taxability;
210:

Line 207: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

203: end if;
204:
205: hr_utility.trace('In create_us_federal_taxability');
206: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
207: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
208:
209: END create_us_federal_taxability;
210:
211: /************************************************************

Line 249: hr_utility.trace('In create_us_state_taxability');

245: ltt_tax_types(4) := 'STEIC';
246:
247: end if;
248:
249: hr_utility.trace('In create_us_state_taxability');
250: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
251: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
252:
253: END create_us_state_taxability;

Line 250: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

246:
247: end if;
248:
249: hr_utility.trace('In create_us_state_taxability');
250: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
251: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
252:
253: END create_us_state_taxability;
254:

Line 251: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

247: end if;
248:
249: hr_utility.trace('In create_us_state_taxability');
250: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
251: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
252:
253: END create_us_state_taxability;
254:
255: /************************************************************

Line 271: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

267: if p_classification in ('Supplemental Earnings',
268: 'Imputed Earnings') then
269: ltt_tax_types(1) := 'NW_COUNTY';
270: ltt_tax_types(2) := 'COUNTY';
271: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
272: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
273: elsif p_classification in ('Pre-Tax Deductions') then
274: ltt_tax_types(1) := 'COUNTY';
275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

Line 272: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));

268: 'Imputed Earnings') then
269: ltt_tax_types(1) := 'NW_COUNTY';
270: ltt_tax_types(2) := 'COUNTY';
271: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
272: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
273: elsif p_classification in ('Pre-Tax Deductions') then
274: ltt_tax_types(1) := 'COUNTY';
275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
276: end if;

Line 275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

271: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
272: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
273: elsif p_classification in ('Pre-Tax Deductions') then
274: ltt_tax_types(1) := 'COUNTY';
275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
276: end if;
277: hr_utility.trace('In create_ca_federal_taxability');
278: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
279:

Line 277: hr_utility.trace('In create_ca_federal_taxability');

273: elsif p_classification in ('Pre-Tax Deductions') then
274: ltt_tax_types(1) := 'COUNTY';
275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
276: end if;
277: hr_utility.trace('In create_ca_federal_taxability');
278: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
279:
280: END create_us_loc_county_tax_rule;
281:

Line 278: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

274: ltt_tax_types(1) := 'COUNTY';
275: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
276: end if;
277: hr_utility.trace('In create_ca_federal_taxability');
278: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
279:
280: END create_us_loc_county_tax_rule;
281:
282:

Line 299: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

295: if p_classification in ('Supplemental Earnings',
296: 'Imputed Earnings') then
297: ltt_tax_types(1) := 'NW_CITY';
298: ltt_tax_types(2) := 'CITY';
299: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
300: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
301: elsif p_classification in ('Pre-Tax Deductions') then
302: hr_utility.trace('In create_ca_federal_taxability');
303: ltt_tax_types(1) := 'CITY';

Line 300: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));

296: 'Imputed Earnings') then
297: ltt_tax_types(1) := 'NW_CITY';
298: ltt_tax_types(2) := 'CITY';
299: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
300: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
301: elsif p_classification in ('Pre-Tax Deductions') then
302: hr_utility.trace('In create_ca_federal_taxability');
303: ltt_tax_types(1) := 'CITY';
304: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

Line 302: hr_utility.trace('In create_ca_federal_taxability');

298: ltt_tax_types(2) := 'CITY';
299: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
300: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
301: elsif p_classification in ('Pre-Tax Deductions') then
302: hr_utility.trace('In create_ca_federal_taxability');
303: ltt_tax_types(1) := 'CITY';
304: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
305: end if;
306: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

Line 304: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

300: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
301: elsif p_classification in ('Pre-Tax Deductions') then
302: hr_utility.trace('In create_ca_federal_taxability');
303: ltt_tax_types(1) := 'CITY';
304: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
305: end if;
306: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
307:
308: END create_us_loc_city_tax_rule;

Line 306: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

302: hr_utility.trace('In create_ca_federal_taxability');
303: ltt_tax_types(1) := 'CITY';
304: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
305: end if;
306: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
307:
308: END create_us_loc_city_tax_rule;
309:
310: /************************************************************

Line 327: hr_utility.trace('In create_ca_federal_taxability');

323: ltt_tax_types(1) := 'FED';
324: ltt_tax_types(2) := 'CPP';
325: ltt_tax_types(3) := 'EIM';
326:
327: hr_utility.trace('In create_ca_federal_taxability');
328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));

Line 328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

324: ltt_tax_types(2) := 'CPP';
325: ltt_tax_types(3) := 'EIM';
326:
327: hr_utility.trace('In create_ca_federal_taxability');
328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
332:

Line 329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

325: ltt_tax_types(3) := 'EIM';
326:
327: hr_utility.trace('In create_ca_federal_taxability');
328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
332:
333: END create_ca_federal_taxability;

Line 330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));

326:
327: hr_utility.trace('In create_ca_federal_taxability');
328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
332:
333: END create_ca_federal_taxability;
334:

Line 331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));

327: hr_utility.trace('In create_ca_federal_taxability');
328: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
329: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
330: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
331: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
332:
333: END create_ca_federal_taxability;
334:
335:

Line 385: hr_utility.trace('Supplemental Earnings');

381: ltt_tax_types(3) := 'PMED';
382: ltt_tax_types(4) := 'WCB';
383: ltt_tax_types(5) := 'VAC';
384: ltt_tax_types(6) := 'PPIP';
385: hr_utility.trace('Supplemental Earnings');
386:
387: elsif p_classification = 'Taxable Benefits' then
388: hr_utility.trace('Taxable Benefits ');
389: ltt_tax_types(1) := 'PRV';

Line 388: hr_utility.trace('Taxable Benefits ');

384: ltt_tax_types(6) := 'PPIP';
385: hr_utility.trace('Supplemental Earnings');
386:
387: elsif p_classification = 'Taxable Benefits' then
388: hr_utility.trace('Taxable Benefits ');
389: ltt_tax_types(1) := 'PRV';
390: ltt_tax_types(2) := 'QPP';
391: ltt_tax_types(3) := 'PMED';
392: ltt_tax_types(4) := 'WCB';

Line 396: hr_utility.trace('Quebec. ltt_tax_types(5) = '||ltt_tax_types(5));

392: ltt_tax_types(4) := 'WCB';
393:
394: if substr(p_jurisdiction,1,2) = 'QC' then
395: ltt_tax_types(5) := 'QST';
396: hr_utility.trace('Quebec. ltt_tax_types(5) = '||ltt_tax_types(5));
397:
398: else
399: ltt_tax_types(5) := 'PST';
400: end if;

Line 417: hr_utility.trace('Quebec. ltt_tax_types(5) = '||ltt_tax_types(5));

413: ltt_tax_types(4) := 'WCB';
414:
415: if substr(p_jurisdiction,1,2) = 'QC' then
416: ltt_tax_types(5) := 'QST';
417: hr_utility.trace('Quebec. ltt_tax_types(5) = '||ltt_tax_types(5));
418: else
419: ltt_tax_types(5) := 'PST';
420: end if;
421:

Line 429: hr_utility.trace('In create_ca_prov_taxability');

425: ltt_tax_types(9) := 'RSTI';
426: ltt_tax_types(10) := 'PPIP';
427: end if;
428:
429: hr_utility.trace('In create_ca_prov_taxability');
430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));

Line 430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

426: ltt_tax_types(10) := 'PPIP';
427: end if;
428:
429: hr_utility.trace('In create_ca_prov_taxability');
430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));

Line 432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));

428:
429: hr_utility.trace('In create_ca_prov_taxability');
430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));

Line 433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));

429: hr_utility.trace('In create_ca_prov_taxability');
430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));

Line 434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));

430: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));

Line 435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));

431: /*
432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));

Line 436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));

432: hr_utility.trace('ltt_tax_types(1) = '||ltt_tax_types(1));
433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));

Line 437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));

433: hr_utility.trace('ltt_tax_types(2) = '||ltt_tax_types(2));
434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));
441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */

Line 438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));

434: hr_utility.trace('ltt_tax_types(3) = '||ltt_tax_types(3));
435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));
441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */
442:

Line 439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));

435: hr_utility.trace('ltt_tax_types(4) = '||ltt_tax_types(4));
436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));
441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */
442:
443: END create_ca_prov_taxability;

Line 440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));

436: hr_utility.trace('ltt_tax_types(5) = '||ltt_tax_types(5));
437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));
441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */
442:
443: END create_ca_prov_taxability;
444:

Line 441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */

437: hr_utility.trace('ltt_tax_types(6) = '||ltt_tax_types(6));
438: hr_utility.trace('ltt_tax_types(7) = '||ltt_tax_types(7));
439: hr_utility.trace('ltt_tax_types(8) = '||ltt_tax_types(8));
440: hr_utility.trace('ltt_tax_types(9) = '||ltt_tax_types(9));
441: hr_utility.trace('ltt_tax_types(10) = '||ltt_tax_types(10)); */
442:
443: END create_ca_prov_taxability;
444:
445: PROCEDURE call_api_for_taxability_rules

Line 459: hr_utility.trace('In call_api_for_taxability_rules');

455: lv_valid_status VARCHAR2(10);
456:
457: BEGIN
458:
459: hr_utility.trace('In call_api_for_taxability_rules');
460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);

Line 460: hr_utility.trace('p_classification_id ' || p_classification_id);

456:
457: BEGIN
458:
459: hr_utility.trace('In call_api_for_taxability_rules');
460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);

Line 461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);

457: BEGIN
458:
459: hr_utility.trace('In call_api_for_taxability_rules');
460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||

Line 462: hr_utility.trace('p_legislation_code ' || p_legislation_code);

458:
459: hr_utility.trace('In call_api_for_taxability_rules');
460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));

Line 463: hr_utility.trace('p_tax_category ' || p_tax_category);

459: hr_utility.trace('In call_api_for_taxability_rules');
460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));
467: hr_utility.trace('ptt_tax_type_values.count = '||

Line 464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);

460: hr_utility.trace('p_classification_id ' || p_classification_id);
461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));
467: hr_utility.trace('ptt_tax_type_values.count = '||
468: to_char(ptt_tax_type_values.count));

Line 465: hr_utility.trace('ptt_tax_types.count = ' ||

461: hr_utility.trace('p_jurisdiction ' || p_jurisdiction);
462: hr_utility.trace('p_legislation_code ' || p_legislation_code);
463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));
467: hr_utility.trace('ptt_tax_type_values.count = '||
468: to_char(ptt_tax_type_values.count));
469: hr_utility.trace('ptt_tax_types(1) = '||ptt_tax_types(1));

Line 467: hr_utility.trace('ptt_tax_type_values.count = '||

463: hr_utility.trace('p_tax_category ' || p_tax_category);
464: hr_utility.trace('p_taxability_rule_date_id ' || p_taxability_rule_date_id);
465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));
467: hr_utility.trace('ptt_tax_type_values.count = '||
468: to_char(ptt_tax_type_values.count));
469: hr_utility.trace('ptt_tax_types(1) = '||ptt_tax_types(1));
470:
471: for i in ptt_tax_types.first .. ptt_tax_types.last loop

Line 469: hr_utility.trace('ptt_tax_types(1) = '||ptt_tax_types(1));

465: hr_utility.trace('ptt_tax_types.count = ' ||
466: to_char(ptt_tax_types.count));
467: hr_utility.trace('ptt_tax_type_values.count = '||
468: to_char(ptt_tax_type_values.count));
469: hr_utility.trace('ptt_tax_types(1) = '||ptt_tax_types(1));
470:
471: for i in ptt_tax_types.first .. ptt_tax_types.last loop
472:
473: hr_utility.trace('In Loop. ptt_tax_types = '||ptt_tax_types(i));

Line 473: hr_utility.trace('In Loop. ptt_tax_types = '||ptt_tax_types(i));

469: hr_utility.trace('ptt_tax_types(1) = '||ptt_tax_types(1));
470:
471: for i in ptt_tax_types.first .. ptt_tax_types.last loop
472:
473: hr_utility.trace('In Loop. ptt_tax_types = '||ptt_tax_types(i));
474:
475: /*****************************************************************
476: ** Only call Taxability Rules API if the use has entered a value
477: *****************************************************************/

Line 492: hr_utility.trace('Do not modify Seed Data for Category: '||

488: );
489:
490: /* Do not touch the row if its a seeded one. */
491: if lv_status = 'S' then /*Seed Row. */
492: hr_utility.trace('Do not modify Seed Data for Category: '||
493: p_tax_category);
494: hr_utility.set_message(801, 'PAY_DATAPUMP_UPD_TAX_SEED_ROW');
495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
496: hr_utility.raise_error;

Line 494: hr_utility.set_message(801, 'PAY_DATAPUMP_UPD_TAX_SEED_ROW');

490: /* Do not touch the row if its a seeded one. */
491: if lv_status = 'S' then /*Seed Row. */
492: hr_utility.trace('Do not modify Seed Data for Category: '||
493: p_tax_category);
494: hr_utility.set_message(801, 'PAY_DATAPUMP_UPD_TAX_SEED_ROW');
495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
496: hr_utility.raise_error;
497:
498: else

Line 495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));

491: if lv_status = 'S' then /*Seed Row. */
492: hr_utility.trace('Do not modify Seed Data for Category: '||
493: p_tax_category);
494: hr_utility.set_message(801, 'PAY_DATAPUMP_UPD_TAX_SEED_ROW');
495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
496: hr_utility.raise_error;
497:
498: else
499: hr_utility.trace('lv_status = '||lv_status);

Line 496: hr_utility.raise_error;

492: hr_utility.trace('Do not modify Seed Data for Category: '||
493: p_tax_category);
494: hr_utility.set_message(801, 'PAY_DATAPUMP_UPD_TAX_SEED_ROW');
495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
496: hr_utility.raise_error;
497:
498: else
499: hr_utility.trace('lv_status = '||lv_status);
500: hr_utility.trace('lv_valid_status = '||lv_valid_status);

Line 499: hr_utility.trace('lv_status = '||lv_status);

495: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
496: hr_utility.raise_error;
497:
498: else
499: hr_utility.trace('lv_status = '||lv_status);
500: hr_utility.trace('lv_valid_status = '||lv_valid_status);
501:
502: /* No row exists. So insert a new row with status Null. */
503: if lv_status = 'N' then /*lv_status Check*/

Line 500: hr_utility.trace('lv_valid_status = '||lv_valid_status);

496: hr_utility.raise_error;
497:
498: else
499: hr_utility.trace('lv_status = '||lv_status);
500: hr_utility.trace('lv_valid_status = '||lv_valid_status);
501:
502: /* No row exists. So insert a new row with status Null. */
503: if lv_status = 'N' then /*lv_status Check*/
504: /* No row exists. So insert a new row with status Null. */

Line 506: hr_utility.trace('No row exists and user has passed Y.

502: /* No row exists. So insert a new row with status Null. */
503: if lv_status = 'N' then /*lv_status Check*/
504: /* No row exists. So insert a new row with status Null. */
505: if ptt_tax_type_values(i) = 'Y' then
506: hr_utility.trace('No row exists and user has passed Y.
507: So insert a new row with status Null.');
508: lv_valid_status := null;
509: elsif ptt_tax_type_values(i) = 'N' then
510:

Line 511: hr_utility.trace('No row exists and user has passed N.

507: So insert a new row with status Null.');
508: lv_valid_status := null;
509: elsif ptt_tax_type_values(i) = 'N' then
510:
511: hr_utility.trace('No row exists and user has passed N.
512: So insert a new row with status D.');
513: lv_valid_status := 'D';
514: end if;
515:

Line 518: hr_utility.trace('p_legislation_code = '||p_legislation_code||'

514: end if;
515:
516: if p_legislation_code = 'US' or nvl(lv_valid_status,'V') <> 'D' then
517:
518: hr_utility.trace('p_legislation_code = '||p_legislation_code||'
519: ptt_tax_types = '||ptt_tax_types(i));
520: pay_taxability_rules_api.create_taxability_rules
521: (p_validate => FALSE
522: ,p_jurisdiction => p_jurisdiction

Line 537: hr_utility.trace('Active row exists. User wanted to delete'||

533:
534: if ptt_tax_type_values(i) = 'N' then
535: /*the user wanted to delete it. So set the status to 'D'. */
536:
537: hr_utility.trace('Active row exists. User wanted to delete'||
538: ' it so set the status to D.');
539: lv_valid_status := 'D';
540:
541: if p_legislation_code = 'US' then

Line 571: hr_utility.trace('In active row exists. User wanted ' ||

567: if ptt_tax_type_values(i) = 'Y' then
568: /* But the user wanted to insert a row.
569: So set the status to null. */
570:
571: hr_utility.trace('In active row exists. User wanted ' ||
572: 'to insert a row. Set the status to null.');
573: lv_valid_status := null;
574: pay_taxability_rules_api.update_taxability_rules
575: (p_validate => FALSE

Line 589: hr_utility.trace('Invalid Value for Column: '||

585: end if;
586: end if; /*lv_status Check*/
587: end if; /*Seed Row. */
588: else
589: hr_utility.trace('Invalid Value for Column: '||
590: ptt_tax_types(i)||' = '||ptt_tax_type_values(i));
591: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
592: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
593: hr_utility.raise_error;

Line 591: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');

587: end if; /*Seed Row. */
588: else
589: hr_utility.trace('Invalid Value for Column: '||
590: ptt_tax_types(i)||' = '||ptt_tax_type_values(i));
591: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
592: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
593: hr_utility.raise_error;
594: end if;
595: end if;

Line 592: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));

588: else
589: hr_utility.trace('Invalid Value for Column: '||
590: ptt_tax_types(i)||' = '||ptt_tax_type_values(i));
591: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
592: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
593: hr_utility.raise_error;
594: end if;
595: end if;
596: end loop;

Line 593: hr_utility.raise_error;

589: hr_utility.trace('Invalid Value for Column: '||
590: ptt_tax_types(i)||' = '||ptt_tax_type_values(i));
591: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
592: hr_utility.set_message_token('COLUMN', ptt_tax_types(i));
593: hr_utility.raise_error;
594: end if;
595: end if;
596: end loop;
597: hr_utility.set_location('outside endloop call_api_for_taxability_rules',100);

Line 597: hr_utility.set_location('outside endloop call_api_for_taxability_rules',100);

593: hr_utility.raise_error;
594: end if;
595: end if;
596: end loop;
597: hr_utility.set_location('outside endloop call_api_for_taxability_rules',100);
598:
599: END call_api_for_taxability_rules;
600:
601:

Line 623: hr_utility.trace('Begin FUNCTION get_tax_category_code');

619: l_lookup_code VARCHAR2(11);
620:
621: BEGIN
622:
623: hr_utility.trace('Begin FUNCTION get_tax_category_code');
624: hr_utility.trace('p_classification : ' || p_classification);
625: hr_utility.trace('p_legislation_code : ' || p_legislation_code);
626: hr_utility.trace('p_tax_category : ' || p_tax_category);
627: l_lookup_type := replace(replace(p_legislation_code || '_' ||

Line 624: hr_utility.trace('p_classification : ' || p_classification);

620:
621: BEGIN
622:
623: hr_utility.trace('Begin FUNCTION get_tax_category_code');
624: hr_utility.trace('p_classification : ' || p_classification);
625: hr_utility.trace('p_legislation_code : ' || p_legislation_code);
626: hr_utility.trace('p_tax_category : ' || p_tax_category);
627: l_lookup_type := replace(replace(p_legislation_code || '_' ||
628: upper(p_classification), ' ', '_'),'-', '_');

Line 625: hr_utility.trace('p_legislation_code : ' || p_legislation_code);

621: BEGIN
622:
623: hr_utility.trace('Begin FUNCTION get_tax_category_code');
624: hr_utility.trace('p_classification : ' || p_classification);
625: hr_utility.trace('p_legislation_code : ' || p_legislation_code);
626: hr_utility.trace('p_tax_category : ' || p_tax_category);
627: l_lookup_type := replace(replace(p_legislation_code || '_' ||
628: upper(p_classification), ' ', '_'),'-', '_');
629:

Line 626: hr_utility.trace('p_tax_category : ' || p_tax_category);

622:
623: hr_utility.trace('Begin FUNCTION get_tax_category_code');
624: hr_utility.trace('p_classification : ' || p_classification);
625: hr_utility.trace('p_legislation_code : ' || p_legislation_code);
626: hr_utility.trace('p_tax_category : ' || p_tax_category);
627: l_lookup_type := replace(replace(p_legislation_code || '_' ||
628: upper(p_classification), ' ', '_'),'-', '_');
629:
630: hr_utility.trace('l_lookup_type : ' || l_lookup_type);

Line 630: hr_utility.trace('l_lookup_type : ' || l_lookup_type);

626: hr_utility.trace('p_tax_category : ' || p_tax_category);
627: l_lookup_type := replace(replace(p_legislation_code || '_' ||
628: upper(p_classification), ' ', '_'),'-', '_');
629:
630: hr_utility.trace('l_lookup_type : ' || l_lookup_type);
631:
632: hr_utility.trace('SELECT lookup_code FROM hr_lookups WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type))) AND upper(meaning) = upper(ltrim(rtrim(cp_lookup_code)))');
633:
634: OPEN c_tax_category_code(l_lookup_type,p_tax_category);

Line 632: hr_utility.trace('SELECT lookup_code FROM hr_lookups WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type))) AND upper(meaning) = upper(ltrim(rtrim(cp_lookup_code)))');

628: upper(p_classification), ' ', '_'),'-', '_');
629:
630: hr_utility.trace('l_lookup_type : ' || l_lookup_type);
631:
632: hr_utility.trace('SELECT lookup_code FROM hr_lookups WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type))) AND upper(meaning) = upper(ltrim(rtrim(cp_lookup_code)))');
633:
634: OPEN c_tax_category_code(l_lookup_type,p_tax_category);
635: FETCH c_tax_category_code INTO l_lookup_code;
636: if c_tax_category_code%NOTFOUND then

Line 637: hr_utility.trace('Lookup Code not found for lookup_type '

633:
634: OPEN c_tax_category_code(l_lookup_type,p_tax_category);
635: FETCH c_tax_category_code INTO l_lookup_code;
636: if c_tax_category_code%NOTFOUND then
637: hr_utility.trace('Lookup Code not found for lookup_type '
638: || l_lookup_type ||
639: ' and for tax category '
640: || p_tax_category);
641: /* Raise error that needs to be send to the sheet. */

Line 643: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');

639: ' and for tax category '
640: || p_tax_category);
641: /* Raise error that needs to be send to the sheet. */
642: -- Bug# 5652699
643: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
644: hr_utility.set_message_token('COLUMN', p_tax_category);
645: hr_utility.raise_error;
646: end if;
647: CLOSE c_tax_category_code;

Line 644: hr_utility.set_message_token('COLUMN', p_tax_category);

640: || p_tax_category);
641: /* Raise error that needs to be send to the sheet. */
642: -- Bug# 5652699
643: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
644: hr_utility.set_message_token('COLUMN', p_tax_category);
645: hr_utility.raise_error;
646: end if;
647: CLOSE c_tax_category_code;
648: hr_utility.trace('returning l_lookup_code : ' || l_lookup_code);

Line 645: hr_utility.raise_error;

641: /* Raise error that needs to be send to the sheet. */
642: -- Bug# 5652699
643: hr_utility.set_message(801, 'PAY_DATAPUMP_INVALID_DATA');
644: hr_utility.set_message_token('COLUMN', p_tax_category);
645: hr_utility.raise_error;
646: end if;
647: CLOSE c_tax_category_code;
648: hr_utility.trace('returning l_lookup_code : ' || l_lookup_code);
649: return(l_lookup_code);

Line 648: hr_utility.trace('returning l_lookup_code : ' || l_lookup_code);

644: hr_utility.set_message_token('COLUMN', p_tax_category);
645: hr_utility.raise_error;
646: end if;
647: CLOSE c_tax_category_code;
648: hr_utility.trace('returning l_lookup_code : ' || l_lookup_code);
649: return(l_lookup_code);
650:
651: END get_tax_category_code;
652:

Line 745: hr_utility.set_location('Entering:'|| lv_procedure, 10);

741: lv_jurisdiction_code VARCHAR2(11);
742:
743: BEGIN
744: lv_procedure := g_package||'create_taxability_rules';
745: hr_utility.set_location('Entering:'|| lv_procedure, 10);
746: lb_is_local := FALSE;
747: lv_jurisdiction_code := p_jurisdiction;
748:
749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));

Line 749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));

745: hr_utility.set_location('Entering:'|| lv_procedure, 10);
746: lb_is_local := FALSE;
747: lv_jurisdiction_code := p_jurisdiction;
748:
749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));
750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);

Line 750: hr_utility.trace('p_tax_category = '||p_tax_category);

746: lb_is_local := FALSE;
747: lv_jurisdiction_code := p_jurisdiction;
748:
749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));
750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);

Line 751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);

747: lv_jurisdiction_code := p_jurisdiction;
748:
749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));
750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);

Line 752: hr_utility.trace('p_legislation_code = '||p_legislation_code);

748:
749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));
750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);

Line 753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);

749: hr_utility.trace('p_classification_id = '||to_char(p_classification_id));
750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);

Line 754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);

750: hr_utility.trace('p_tax_category = '||p_tax_category);
751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);
758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);

Line 755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);

751: hr_utility.trace('p_jurisdiction = '||p_jurisdiction);
752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);
758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);
759:

Line 756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);

752: hr_utility.trace('p_legislation_code = '||p_legislation_code);
753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);
758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);
759:
760: transfer_tax_type_values

Line 757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);

753: hr_utility.trace('p_input_tax_type_value1 = '||p_input_tax_type_value1);
754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);
758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);
759:
760: transfer_tax_type_values
761: (p_input_tax_type_value1 => p_input_tax_type_value1

Line 758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);

754: hr_utility.trace('p_input_tax_type_value2 = '||p_input_tax_type_value2);
755: hr_utility.trace('p_input_tax_type_value3 = '||p_input_tax_type_value3);
756: hr_utility.trace('p_input_tax_type_value4 = '||p_input_tax_type_value4);
757: hr_utility.trace('p_input_tax_type_value5 = '||p_input_tax_type_value5);
758: hr_utility.trace('p_input_tax_type_value6 = '||p_input_tax_type_value6);
759:
760: transfer_tax_type_values
761: (p_input_tax_type_value1 => p_input_tax_type_value1
762: ,p_input_tax_type_value2 => p_input_tax_type_value2

Line 780: hr_utility.trace('Before checking p_jurisdiction = '||p_jurisdiction);

776: (p_legislation_code => p_legislation_code
777: ,p_effective_date => sysdate);
778: end if;
779:
780: hr_utility.trace('Before checking p_jurisdiction = '||p_jurisdiction);
781: hr_utility.trace('p_legislation_code = '||p_legislation_code);
782:
783: open c_classification(p_classification_id,
784: p_legislation_code);

Line 781: hr_utility.trace('p_legislation_code = '||p_legislation_code);

777: ,p_effective_date => sysdate);
778: end if;
779:
780: hr_utility.trace('Before checking p_jurisdiction = '||p_jurisdiction);
781: hr_utility.trace('p_legislation_code = '||p_legislation_code);
782:
783: open c_classification(p_classification_id,
784: p_legislation_code);
785: fetch c_classification INTO lv_classification_name;

Line 787: hr_utility.trace('No classification id found.');

783: open c_classification(p_classification_id,
784: p_legislation_code);
785: fetch c_classification INTO lv_classification_name;
786: if c_classification%NOTFOUND then
787: hr_utility.trace('No classification id found.');
788: hr_utility.raise_error;
789: end if;
790: close c_classification;
791:

Line 788: hr_utility.raise_error;

784: p_legislation_code);
785: fetch c_classification INTO lv_classification_name;
786: if c_classification%NOTFOUND then
787: hr_utility.trace('No classification id found.');
788: hr_utility.raise_error;
789: end if;
790: close c_classification;
791:
792: hr_utility.trace('lv_classification_name = '|| lv_classification_name);

Line 792: hr_utility.trace('lv_classification_name = '|| lv_classification_name);

788: hr_utility.raise_error;
789: end if;
790: close c_classification;
791:
792: hr_utility.trace('lv_classification_name = '|| lv_classification_name);
793: initialize;
794:
795: if p_legislation_code = 'US' then
796: if ltrim(rtrim(p_jurisdiction)) = '00-000-0000' then

Line 797: hr_utility.trace('p_jurisdiction is Federal');

793: initialize;
794:
795: if p_legislation_code = 'US' then
796: if ltrim(rtrim(p_jurisdiction)) = '00-000-0000' then
797: hr_utility.trace('p_jurisdiction is Federal');
798: create_us_federal_taxability(
799: p_classification => lv_classification_name);
800:
801: elsif substr(p_jurisdiction,1 ,2) <> '00' and

Line 840: hr_utility.trace('Local Earnings. Tax type value1 = '||

836: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
837: := null;
838: pay_ac_taxability_wrapper.ltt_tax_type_values(4)
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
841: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
843: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
844:

Line 842: hr_utility.trace('Local Earnings. Tax type value 2= '||

838: pay_ac_taxability_wrapper.ltt_tax_type_values(4)
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
841: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
843: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
844:
845: elsif lv_classification_name in ('Pre-Tax Deductions') then
846: pay_ac_taxability_wrapper.ltt_tax_type_values(1)

Line 852: hr_utility.trace('Local Earnings. Tax type value1 = '||

848: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
849: := null;
850: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
851: := null;
852: hr_utility.trace('Local Earnings. Tax type value1 = '||
853: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
854:
855: end if;
856: end if;

Line 861: hr_utility.trace('p_jurisdiction is Federal');

857:
858: elsif p_legislation_code = 'CA' then
859:
860: if ltrim(rtrim(p_jurisdiction)) = '00-000-0000' then
861: hr_utility.trace('p_jurisdiction is Federal');
862: create_ca_federal_taxability;
863: elsif substr(p_jurisdiction,4,3) = '000' and
864: substr(p_jurisdiction,8,4) = '0000' then
865:

Line 872: hr_utility.trace('Before call_api_for_taxability_rules');

868: ,p_jurisdiction => p_jurisdiction);
869: end if;
870: end if;
871:
872: hr_utility.trace('Before call_api_for_taxability_rules');
873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||
874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||

Line 873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||

869: end if;
870: end if;
871:
872: hr_utility.trace('Before call_api_for_taxability_rules');
873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||
874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));

Line 876: hr_utility.trace('ltt_tax_type_values(1) = '||

872: hr_utility.trace('Before call_api_for_taxability_rules');
873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||
874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));
878: hr_utility.trace('ltt_tax_type_values.count = '||
879: to_char(ltt_tax_type_values.count));
880: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

Line 878: hr_utility.trace('ltt_tax_type_values.count = '||

874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));
878: hr_utility.trace('ltt_tax_type_values.count = '||
879: to_char(ltt_tax_type_values.count));
880: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
881:
882: lv_tax_category := get_tax_category_code(

Line 880: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));

876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));
878: hr_utility.trace('ltt_tax_type_values.count = '||
879: to_char(ltt_tax_type_values.count));
880: hr_utility.trace('ltt_tax_types.count = '||to_char(ltt_tax_types.count));
881:
882: lv_tax_category := get_tax_category_code(
883: p_classification => lv_classification_name
884: ,p_legislation_code => p_legislation_code

Line 900: hr_utility.set_location(' Leaving:'||lv_procedure, 80);

896:
897: EXCEPTION
898:
899: WHEN OTHERS THEN
900: hr_utility.set_location(' Leaving:'||lv_procedure, 80);
901: RAISE;
902:
903: END create_taxability_rules;
904:

Line 930: hr_utility.set_location('Entering:'|| lv_procedure, 10);

926:
927: BEGIN
928: lv_procedure := g_package||'update_taxability_rules';
929: savepoint upd_taxability_rule;
930: hr_utility.set_location('Entering:'|| lv_procedure, 10);
931:
932: hr_utility.set_location('Leaving:'|| lv_procedure, 20);
933:
934: EXCEPTION

Line 932: hr_utility.set_location('Leaving:'|| lv_procedure, 20);

928: lv_procedure := g_package||'update_taxability_rules';
929: savepoint upd_taxability_rule;
930: hr_utility.set_location('Entering:'|| lv_procedure, 10);
931:
932: hr_utility.set_location('Leaving:'|| lv_procedure, 20);
933:
934: EXCEPTION
935:
936: WHEN OTHERS THEN

Line 937: hr_utility.set_location(' Leaving:'||lv_procedure, 80);

933:
934: EXCEPTION
935:
936: WHEN OTHERS THEN
937: hr_utility.set_location(' Leaving:'||lv_procedure, 80);
938: raise;
939:
940: END update_taxability_rules;
941:

Line 944: --hr_utility.trace_on(null,'ram');

940: END update_taxability_rules;
941:
942: BEGIN
943: g_package := 'pay_ac_taxability_rules_wrapper.';
944: --hr_utility.trace_on(null,'ram');
945: end pay_ac_taxability_wrapper;