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

Line 80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);

76: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
77: pest.effective_start_date AND pest.effective_end_date;
78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:

Line 81: hr_utility.trace('The date earned is : ' || p_date_earned);

77: pest.effective_start_date AND pest.effective_end_date;
78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');

Line 82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));

78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:

Line 83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);

79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));

Line 87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));

83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));
88: hr_utility.trace('The tax type passed is : ' || p_tax_type);
89:
90: IF p_tax_type = 'SDI' THEN
91:

Line 88: hr_utility.trace('The tax type passed is : ' || p_tax_type);

84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));
88: hr_utility.trace('The tax type passed is : ' || p_tax_type);
89:
90: IF p_tax_type = 'SDI' THEN
91:
92: OPEN sdi_exempt;

Line 100: hr_utility.trace('SDI Exempt : ' || l_sdi);

96: l_sdi := 'N';
97: END IF;
98: CLOSE sdi_exempt;
99:
100: hr_utility.trace('SDI Exempt : ' || l_sdi);
101:
102: RETURN(l_sdi);
103:
104: ELSIF p_tax_type = 'SUI' THEN

Line 114: hr_utility.trace('SUI Exempt : ' || l_sui);

110: l_sui := 'N';
111: END IF;
112: CLOSE sui_exempt;
113:
114: hr_utility.trace('SUI Exempt : ' || l_sui);
115:
116: RETURN(l_sui);
117:
118: ELSIF p_tax_type = 'FUTA' THEN

Line 128: hr_utility.trace('FUTA Exempt : ' || l_futa);

124: l_futa := 'N';
125: END IF;
126: CLOSE futa_exempt;
127:
128: hr_utility.trace('FUTA Exempt : ' || l_futa);
129:
130: RETURN(l_futa);
131:
132: ELSIF p_tax_type = 'FICA' THEN

Line 142: hr_utility.trace('FICA Exempt : ' || l_fica);

138: l_fica := 'N';
139: END IF;
140: CLOSE fica_exempt;
141:
142: hr_utility.trace('FICA Exempt : ' || l_fica);
143:
144: RETURN(l_fica);
145:
146: ELSIF p_tax_type = 'MEDICARE' THEN

Line 156: hr_utility.trace('MEDI Exempt : ' || l_medi);

152: l_medi := 'N';
153: END IF;
154: CLOSE medi_exempt;
155:
156: hr_utility.trace('MEDI Exempt : ' || l_medi);
157:
158: RETURN(l_medi);
159:
160: END IF;

Line 196: -- hr_utility.trace_on(null,'TAXEXIST');

192: /*
193: * check to see if there is an override if there is then we do not check
194: * for 1st Jan else see if the default county is valid as of 1st Jan.
195: */
196: -- hr_utility.trace_on(null,'TAXEXIST');
197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');
198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county

Line 197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');

193: * check to see if there is an override if there is then we do not check
194: * for 1st Jan else see if the default county is valid as of 1st Jan.
195: */
196: -- hr_utility.trace_on(null,'TAXEXIST');
197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');
198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county
201: INTO l_rs_county_code;

Line 202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);

198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county
201: INTO l_rs_county_code;
202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);
203: IF c_override_state_county%NOTFOUND THEN
204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');
205: /*{*/
206: /*

Line 204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');

200: FETCH c_override_state_county
201: INTO l_rs_county_code;
202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);
203: IF c_override_state_county%NOTFOUND THEN
204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');
205: /*{*/
206: /*
207: * override does not exists so get the actual address / override as of
208: * 1st Jan .

Line 213: hr_utility.trace('5030 Fetching County Code for Res Jurisdiction ');

209: */
210:
211: BEGIN
212: /*{*/
213: hr_utility.trace('5030 Fetching County Code for Res Jurisdiction ');
214: SELECT puc.state_code || '-' || puc.county_code,
215: pa.date_from
216: INTO l_rs_county_code, l_res_adr_date_start
217: FROM pay_us_counties puc,

Line 232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);

228: AND pus.state_abbrev = pa.region_2 --actual state
229: AND pus.state_code = '15' --for INDIANA
230: AND puc.state_code = pus.state_code
231: AND puc.county_name = pa.region_1; --actual county
232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);
233: hr_utility.trace('5050 Resident County Code Eff Start Date : '
234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))

Line 233: hr_utility.trace('5050 Resident County Code Eff Start Date : '

229: AND pus.state_code = '15' --for INDIANA
230: AND puc.state_code = pus.state_code
231: AND puc.county_name = pa.region_1; --actual county
232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);
233: hr_utility.trace('5050 Resident County Code Eff Start Date : '
234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN

Line 238: hr_utility.trace('5055 Resident County Eff Start Date '||

234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN
238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);

Line 240: hr_utility.trace('5060 As of 1st Jan Date '||

236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN
238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||

Line 242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);

238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||

Line 244: hr_utility.trace('5075 Resident County Eff Start Date '||

240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||

Line 246: hr_utility.trace('5076 As of 1st Jan Date '||

242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');

Line 248: hr_utility.trace('5077 Resident County Code Eff Start Date '||

244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;

Line 250: hr_utility.trace('5080 County Code Returned 00-000 ');

246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;
253: CLOSE c_override_state_county;
254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

Line 254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;
253: CLOSE c_override_state_county;
254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

Line 258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
260: CLOSE c_override_state_county;
261: l_rs_county_code := '00-000';
262: RETURN (l_rs_county_code);

Line 259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
260: CLOSE c_override_state_county;
261: l_rs_county_code := '00-000';
262: RETURN (l_rs_county_code);
263: /*}*/

Line 267: hr_utility.trace('5120 OVERRIDE County Code Found ');

263: /*}*/
264: END;
265: /*}*/
266: ELSE
267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

Line 268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);

264: END;
265: /*}*/
266: ELSE
267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
272: RETURN(l_rs_county_code);

Line 271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
272: RETURN(l_rs_county_code);
273: /*}*/
274: END; --function GET_RESIDENCE_AS_OF_1ST_JAN
275:

Line 335: hr_utility.trace('l_date_earned: ' || l_date_earned);

331: 1st Jan has to be picked*/
332: l_date_earned := TRUNC(TO_DATE(p_effective_date, 'DD-MM-YYYY'),'Y');
333:
334:
335: hr_utility.trace('l_date_earned: ' || l_date_earned);
336: OPEN c_override_location;
337:
338: FETCH c_override_location
339: INTO l_curr_county_code;

Line 345: hr_utility.trace('c_override_location%NOTFOUND ');

341: IF c_override_location%NOTFOUND THEN
342: /*{*/
343: BEGIN
344: /*{*/
345: hr_utility.trace('c_override_location%NOTFOUND ');
346: l_is_valid_location := FALSE ;
347: /*Bug#6768746: Check work location of this current assignment is valid
348: as of 1st January. Check all the active assignments attached with this
349: employee.*/

Line 352: hr_utility.trace('rec_multiassgn.assignment_id: '|| to_char(rec_multiassgn.assignment_id));

348: as of 1st January. Check all the active assignments attached with this
349: employee.*/
350: for rec_multiassgn in c_multiple_assignments
351: LOOP
352: hr_utility.trace('rec_multiassgn.assignment_id: '|| to_char(rec_multiassgn.assignment_id));
353: SELECT count(1)
354: INTO l_is_exist
355: FROM pay_us_counties puc,
356: pay_us_states pus,

Line 375: hr_utility.trace('l_is_exist >0');

371: AND puc.state_code = SUBSTR(p_juri_code, 1, 2)
372: AND puc.county_code = SUBSTR(p_juri_code, 4, 3);
373:
374: IF l_is_exist > 0 then
375: hr_utility.trace('l_is_exist >0');
376: l_is_valid_location := TRUE ;
377: end if;
378: end loop;
379: CLOSE c_override_location;

Line 385: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

381:
382: EXCEPTION
383: WHEN others THEN
384: CLOSE c_override_location;
385: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
386: RETURN (FALSE);
387: /* SELECT count(1)
388: INTO l_is_exist
389: FROM pay_us_counties puc,

Line 410: hr_utility.trace('query count: ' || to_char(l_is_exist));

406: AND puc.county_code = SUBSTR(p_juri_code, 4, 3);
407:
408: CLOSE c_override_location;
409: --RETURN (TRUE);
410: hr_utility.trace('query count: ' || to_char(l_is_exist));
411: IF l_is_exist = 0 then
412: RETURN (FALSE);
413: else
414: return(TRUE);

Line 476: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '

472: 'SIT_RS',
473: p_called_from);
474: /*}*/
475: END IF;
476: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '
477: || l_county_tax_exists);
478: RETURN(l_county_tax_exists);
479: /*}*/
480: ELSE

Line 482: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '

478: RETURN(l_county_tax_exists);
479: /*}*/
480: ELSE
481: /*{*/
482: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '
483: || l_county_tax_exists);
484: RETURN(l_county_tax_exists);
485: /*}*/
486: END IF;

Line 489: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');

485: /*}*/
486: END IF;
487: EXCEPTION
488: WHEN others THEN
489: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');
490: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');
491: RETURN('N');
492: /*}*/
493: END DOES_TAX_EXISTS;

Line 490: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');

486: END IF;
487: EXCEPTION
488: WHEN others THEN
489: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');
490: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');
491: RETURN('N');
492: /*}*/
493: END DOES_TAX_EXISTS;
494:

Line 553: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);

549: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||'-0000';
550: /* Bug 2934494
551: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||' - 0000';
552: */
553: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);
554: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);
555: RETURN(l_local_level_tax_exists);
556:
557: EXCEPTION

Line 554: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);

550: /* Bug 2934494
551: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||' - 0000';
552: */
553: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);
554: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);
555: RETURN(l_local_level_tax_exists);
556:
557: EXCEPTION
558: WHEN OTHERS THEN

Line 560: hr_utility.set_location(

556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: -- If there is no value then return l_state_level_tax_exists
560: hr_utility.set_location(
561: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);
562: hr_utility.trace(
563: 'No rexord defined in Local Tax rules for this Locality : '
564: || l_local_level_tax_exists);

Line 562: hr_utility.trace(

558: WHEN OTHERS THEN
559: -- If there is no value then return l_state_level_tax_exists
560: hr_utility.set_location(
561: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);
562: hr_utility.trace(
563: 'No rexord defined in Local Tax rules for this Locality : '
564: || l_local_level_tax_exists);
565: /*
566: * This will return Y, if ALL Localities are selected under State Tax Rules

Line 582: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);

578: If Employer setup for State's Resident Tax is Only Withhold Tax
579: at Work Location return No, so that Resident tax is not withhold
580: for the resident jurisdiction
581: */
582: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);
583: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);
584: --
585: -- This is added to tax a jurisdiction if it is tagged OR
586: -- resident jurisdiction is same Work

Line 583: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);

579: at Work Location return No, so that Resident tax is not withhold
580: for the resident jurisdiction
581: */
582: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);
583: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);
584: --
585: -- This is added to tax a jurisdiction if it is tagged OR
586: -- resident jurisdiction is same Work
587: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

Line 588: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

584: --
585: -- This is added to tax a jurisdiction if it is tagged OR
586: -- resident jurisdiction is same Work
587: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
588: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
589: if (nvl(l_jd_type,'NL') = 'RT' OR
590: nvl(l_jd_type,'NL') = 'RW' OR
591: nvl(l_jd_type,'NL') = 'HW' -- added to fix bug # 4463475
592: ) then

Line 594: hr_utility.trace('COUNTY Tax to be withheld : Y');

590: nvl(l_jd_type,'NL') = 'RW' OR
591: nvl(l_jd_type,'NL') = 'HW' -- added to fix bug # 4463475
592: ) then
593: --{
594: hr_utility.trace('COUNTY Tax to be withheld : Y');
595: return('Y');
596: --}
597: else
598: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);

Line 598: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);

594: hr_utility.trace('COUNTY Tax to be withheld : Y');
595: return('Y');
596: --}
597: else
598: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);
599: RETURN l_wh_work_localities;
600: end if;
601: --}
602: END IF;

Line 607: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);

603: END;
604: EXCEPTION /* The ct has nothing at the EI level set up */
605: WHEN OTHERS THEN
606: l_local_level_tax_exists := 'Y';
607: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);
608: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);
609: RETURN l_local_level_tax_exists;
610: --}
611: END STATE_LOCAL_LEVEL_TAX;

Line 608: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);

604: EXCEPTION /* The ct has nothing at the EI level set up */
605: WHEN OTHERS THEN
606: l_local_level_tax_exists := 'Y';
607: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);
608: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);
609: RETURN l_local_level_tax_exists;
610: --}
611: END STATE_LOCAL_LEVEL_TAX;
612:

Line 643: -- hr_utility.trace_on(null,'EXIST');

639: RETURN VARCHAR2 IS
640:
641: BEGIN
642: /*{*/
643: -- hr_utility.trace_on(null,'EXIST');
644: RETURN get_tax_exists(p_juri_code,
645: p_date_earned,
646: p_tax_unit_id,
647: p_assign_id,

Line 728: l_payroll_installed := hr_utility.chk_product_install(

724: /*
725: * Check to see if US Payroll is installed
726: */
727:
728: l_payroll_installed := hr_utility.chk_product_install(
729: p_product =>'Oracle Payroll',
730: p_legislation => 'US');
731: IF l_payroll_installed THEN
732: /*{*/

Line 734: -- hr_utility.trace_on(null,'TAXEXIST');

730: p_legislation => 'US');
731: IF l_payroll_installed THEN
732: /*{*/
733:
734: -- hr_utility.trace_on(null,'TAXEXIST');
735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
736: hr_utility.trace('We are changing the date format, the before date is: '
737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');

Line 735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);

731: IF l_payroll_installed THEN
732: /*{*/
733:
734: -- hr_utility.trace_on(null,'TAXEXIST');
735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
736: hr_utility.trace('We are changing the date format, the before date is: '
737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:

Line 736: hr_utility.trace('We are changing the date format, the before date is: '

732: /*{*/
733:
734: -- hr_utility.trace_on(null,'TAXEXIST');
735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
736: hr_utility.trace('We are changing the date format, the before date is: '
737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:
740: hr_utility.trace('The tax we are determining is : '|| p_type);

Line 740: hr_utility.trace('The tax we are determining is : '|| p_type);

736: hr_utility.trace('We are changing the date format, the before date is: '
737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:
740: hr_utility.trace('The tax we are determining is : '|| p_type);
741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
742: hr_utility.trace('The date earned after change of format is : '
743: || l_date_earned);
744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);

Line 741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);

737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:
740: hr_utility.trace('The tax we are determining is : '|| p_type);
741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
742: hr_utility.trace('The date earned after change of format is : '
743: || l_date_earned);
744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
745: hr_utility.trace('The assignment id is : ' || p_assign_id);

Line 742: hr_utility.trace('The date earned after change of format is : '

738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:
740: hr_utility.trace('The tax we are determining is : '|| p_type);
741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
742: hr_utility.trace('The date earned after change of format is : '
743: || l_date_earned);
744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
745: hr_utility.trace('The assignment id is : ' || p_assign_id);
746:

Line 744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);

740: hr_utility.trace('The tax we are determining is : '|| p_type);
741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
742: hr_utility.trace('The date earned after change of format is : '
743: || l_date_earned);
744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
745: hr_utility.trace('The assignment id is : ' || p_assign_id);
746:
747: /*
748: * Let's take the jurisdiction code and get a state abbrev

Line 745: hr_utility.trace('The assignment id is : ' || p_assign_id);

741: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
742: hr_utility.trace('The date earned after change of format is : '
743: || l_date_earned);
744: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
745: hr_utility.trace('The assignment id is : ' || p_assign_id);
746:
747: /*
748: * Let's take the jurisdiction code and get a state abbrev
749: */

Line 756: hr_utility.trace('The state abbrev is:' || l_state_abbrev);

752: INTO l_state_abbrev
753: FROM pay_us_states pus
754: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
755:
756: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
757:
758:
759: /*
760: * Let's only allow the function to work if date_earned is in 1999

Line 771: hr_utility.trace('The year of the date earned is: '

767: IF SUBSTR(l_date_earned, 7) < 1999 THEN
768: /*{*/
769: BEGIN
770: /*{*/
771: hr_utility.trace('The year of the date earned is: '
772: || SUBSTR(l_date_earned, 7));
773: l_exists := 'Y';
774: hr_utility.trace('The year is before 1999 so we will say tax exists '
775: ||' =Y');

Line 774: hr_utility.trace('The year is before 1999 so we will say tax exists '

770: /*{*/
771: hr_utility.trace('The year of the date earned is: '
772: || SUBSTR(l_date_earned, 7));
773: l_exists := 'Y';
774: hr_utility.trace('The year is before 1999 so we will say tax exists '
775: ||' =Y');
776: RETURN l_exists;
777: /*}*/
778: END;

Line 782: hr_utility.trace('The year of the date earned is after 1998 so we will '

778: END;
779: /*}*/
780: ELSE
781: /*{*/
782: hr_utility.trace('The year of the date earned is after 1998 so we will '
783: || ' allow the function to calc');
784: NULL;
785: /*}*/
786: END IF;

Line 844: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);

840: WHERE hoi.ORG_INFORMATION_CONTEXT = 'State Tax Rules'
841: AND hoi.organization_id = p_tax_unit_id
842: AND hoi.org_information1 = l_state_abbrev;
843:
844: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);
845: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
846:
847: IF l_sit_rs_exists = 'N' THEN
848:

Line 845: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

841: AND hoi.organization_id = p_tax_unit_id
842: AND hoi.org_information1 = l_state_abbrev;
843:
844: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);
845: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
846:
847: IF l_sit_rs_exists = 'N' THEN
848:
849: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

Line 862: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);

858: WHEN NO_DATA_FOUND THEN
859: /*
860: * If there is no value then return the value of l_org_info2
861: */
862: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);
863: hr_utility.trace('SIT Exists : ' || l_org_info2);
864:
865: IF l_org_info2 = 'N' THEN
866:

Line 863: hr_utility.trace('SIT Exists : ' || l_org_info2);

859: /*
860: * If there is no value then return the value of l_org_info2
861: */
862: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);
863: hr_utility.trace('SIT Exists : ' || l_org_info2);
864:
865: IF l_org_info2 = 'N' THEN
866:
867: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

Line 879: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);

875: END;
876: /*}*/
877: ELSE /* 2 */
878: /*{*/
879: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);
880: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
881:
882: RETURN l_sit_rs_exists;
883: /*

Line 880: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

876: /*}*/
877: ELSE /* 2 */
878: /*{*/
879: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);
880: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
881:
882: RETURN l_sit_rs_exists;
883: /*
884: * jit level, this will be N, no sit for the state

Line 893: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);

889: EXCEPTION
890: WHEN others THEN
891:
892: l_sit_rs_exists := 'Y';
893: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);
894: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
895:
896: RETURN l_sit_rs_exists;
897:

Line 894: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

890: WHEN others THEN
891:
892: l_sit_rs_exists := 'Y';
893: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);
894: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
895:
896: RETURN l_sit_rs_exists;
897:
898: /*}*/

Line 914: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);

910: effective_start_date AND effective_end_date;
911:
912: IF l_sit_wk_exists = 'Y' THEN /* 2 */
913: /*{*/
914: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);
915: hr_utility.trace('SIT_WK Exists at the jit level, '
916: ||' now we check if the NR certificate is filed');
917: IF p_call = 'F' THEN
918: /*{*/

Line 915: hr_utility.trace('SIT_WK Exists at the jit level, '

911:
912: IF l_sit_wk_exists = 'Y' THEN /* 2 */
913: /*{*/
914: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);
915: hr_utility.trace('SIT_WK Exists at the jit level, '
916: ||' now we check if the NR certificate is filed');
917: IF p_call = 'F' THEN
918: /*{*/
919: l_sit_wk_exists := get_tax_exists(p_juri_code,

Line 926: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);

922: p_assign_id,
923: p_pact_id,
924: 'NR');
925:
926: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);
927: hr_utility.trace('Do we take out sit based on the NR check? '
928: || l_sit_wk_exists);
929: /*}*/
930: END IF;

Line 927: hr_utility.trace('Do we take out sit based on the NR check? '

923: p_pact_id,
924: 'NR');
925:
926: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);
927: hr_utility.trace('Do we take out sit based on the NR check? '
928: || l_sit_wk_exists);
929: /*}*/
930: END IF;
931: /*

Line 941: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);

937: /*{*/
938: /*
939: * jit level, this will be N, no sit for the state
940: */
941: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);
942: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
943: RETURN l_sit_wk_exists;
944:
945: /*}*/

Line 942: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);

938: /*
939: * jit level, this will be N, no sit for the state
940: */
941: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);
942: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
943: RETURN l_sit_wk_exists;
944:
945: /*}*/
946: END IF; /* 2 */

Line 951: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

947:
948: EXCEPTION
949: WHEN others THEN
950: l_sit_wk_exists := 'Y';
951: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
952: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
953: RETURN l_sit_wk_exists;
954: /*}*/
955: END; /* SIT_WK */

Line 952: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);

948: EXCEPTION
949: WHEN others THEN
950: l_sit_wk_exists := 'Y';
951: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
952: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
953: RETURN l_sit_wk_exists;
954: /*}*/
955: END; /* SIT_WK */
956: /*}*/

Line 978: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);

974:
975:
976: IF l_wc_exists = 'Y' THEN /* 2 */
977: /*{*/
978: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);
979: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '
980: ||' now check if this assignment is WC exempt');
981: IF p_call = 'F' THEN
982: /*{*/

Line 979: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '

975:
976: IF l_wc_exists = 'Y' THEN /* 2 */
977: /*{*/
978: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);
979: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '
980: ||' now check if this assignment is WC exempt');
981: IF p_call = 'F' THEN
982: /*{*/
983:

Line 994: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);

990: AND str.assignment_id = p_assign_id /* 5772548 */
991: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
992: str.effective_start_date AND str.effective_end_date;
993:
994: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);
995: hr_utility.trace(' check for wc exemption ' || l_wc_exists);
996: /*}*/
997: END IF;
998: /*

Line 995: hr_utility.trace(' check for wc exemption ' || l_wc_exists);

991: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
992: str.effective_start_date AND str.effective_end_date;
993:
994: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);
995: hr_utility.trace(' check for wc exemption ' || l_wc_exists);
996: /*}*/
997: END IF;
998: /*
999: * if yes then NR is not checked, if no then NR is checked

Line 1008: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);

1004:
1005: EXCEPTION
1006: WHEN others THEN
1007: l_wc_exists := 'Y';
1008: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);
1009: hr_utility.trace('WC Exists : ' || l_wc_exists);
1010: RETURN l_wc_exists;
1011: /*}*/
1012: END; /* WC */

Line 1009: hr_utility.trace('WC Exists : ' || l_wc_exists);

1005: EXCEPTION
1006: WHEN others THEN
1007: l_wc_exists := 'Y';
1008: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);
1009: hr_utility.trace('WC Exists : ' || l_wc_exists);
1010: RETURN l_wc_exists;
1011: /*}*/
1012: END; /* WC */
1013: /*}*/

Line 1028: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);

1024: effective_start_date AND effective_end_date;
1025:
1026: IF l_misc1_state_tax = 'Y' THEN /* 2 */
1027: /*{*/
1028: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);
1029: hr_utility.trace('MISC1_TAX Exists at the jit level, '
1030: ||' now we check if the NR certificate is filed');
1031: /*Bug 4344763, For SHI(MA) NR Certificate should not be checked*/
1032: /* IF p_call = 'F' THEN

Line 1029: hr_utility.trace('MISC1_TAX Exists at the jit level, '

1025:
1026: IF l_misc1_state_tax = 'Y' THEN /* 2 */
1027: /*{*/
1028: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);
1029: hr_utility.trace('MISC1_TAX Exists at the jit level, '
1030: ||' now we check if the NR certificate is filed');
1031: /*Bug 4344763, For SHI(MA) NR Certificate should not be checked*/
1032: /* IF p_call = 'F' THEN
1033: l_misc1_state_tax := get_tax_exists(p_juri_code,

Line 1039: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);

1035: p_tax_unit_id,
1036: p_assign_id,
1037: 'NR');
1038:
1039: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);
1040: hr_utility.trace('Do we take out sit based on the NR check? '
1041: || l_sit_wk_exists);
1042:
1043: END IF;*/

Line 1040: hr_utility.trace('Do we take out sit based on the NR check? '

1036: p_assign_id,
1037: 'NR');
1038:
1039: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);
1040: hr_utility.trace('Do we take out sit based on the NR check? '
1041: || l_sit_wk_exists);
1042:
1043: END IF;*/
1044:

Line 1056: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);

1052: /*
1053: * jit level, this will be N, no misc1 tax for the state
1054: */
1055: l_misc1_state_tax := 'N';
1056: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);
1057: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1058: RETURN l_misc1_state_tax;
1059:
1060: /*}*/

Line 1057: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);

1053: * jit level, this will be N, no misc1 tax for the state
1054: */
1055: l_misc1_state_tax := 'N';
1056: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);
1057: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1058: RETURN l_misc1_state_tax;
1059:
1060: /*}*/
1061: END IF; /* 2 */

Line 1066: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);

1062:
1063: EXCEPTION
1064: WHEN others THEN
1065: l_misc1_state_tax := 'N';
1066: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);
1067: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1068: RETURN l_misc1_state_tax;
1069: /*}*/
1070: END; /* MISC1_TAX */

Line 1067: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);

1063: EXCEPTION
1064: WHEN others THEN
1065: l_misc1_state_tax := 'N';
1066: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);
1067: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1068: RETURN l_misc1_state_tax;
1069: /*}*/
1070: END; /* MISC1_TAX */
1071: /*}*/

Line 1103: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);

1099: AND SES.session_id = USERENV('SESSIONID')
1100: AND SES.effective_date BETWEEN
1101: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1102:
1103: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);
1104: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1105:
1106: IF l_sdi_ee_exists = 'N' THEN /* 2 */
1107: /*

Line 1104: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1100: AND SES.effective_date BETWEEN
1101: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1102:
1103: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);
1104: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1105:
1106: IF l_sdi_ee_exists = 'N' THEN /* 2 */
1107: /*
1108: * see if their is a period limit

Line 1113: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1109: */
1110: /*{*/
1111: BEGIN
1112: /*{*/
1113: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1114: 31);
1115: hr_utility.trace('No SDI wage limit, check for period limit');
1116:
1117: SELECT DISTINCT DECODE(STATETAX.STA_INFORMATION1,

Line 1115: hr_utility.trace('No SDI wage limit, check for period limit');

1111: BEGIN
1112: /*{*/
1113: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1114: 31);
1115: hr_utility.trace('No SDI wage limit, check for period limit');
1116:
1117: SELECT DISTINCT DECODE(STATETAX.STA_INFORMATION1,
1118: NULL, 'N',
1119: 0, 'N',

Line 1129: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1125: AND SES.session_id = USERENV('SESSIONID')
1126: AND SES.effective_date BETWEEN
1127: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1128:
1129: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1130: 32);
1131: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);
1132: RETURN l_sdi_ee_exists;
1133:

Line 1131: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);

1127: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1128:
1129: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1130: 32);
1131: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);
1132: RETURN l_sdi_ee_exists;
1133:
1134: EXCEPTION
1135: WHEN OTHERS THEN

Line 1137: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1133:
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: l_sdi_ee_exists := 'N';
1137: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1138: 33);
1139: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1140: RETURN l_sdi_ee_exists;
1141:

Line 1139: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1135: WHEN OTHERS THEN
1136: l_sdi_ee_exists := 'N';
1137: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1138: 33);
1139: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1140: RETURN l_sdi_ee_exists;
1141:
1142: /*}*/
1143: END;

Line 1147: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1143: END;
1144: /*}*/
1145: ELSE /* 2 */
1146: /*{*/
1147: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1148: 34);
1149: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1150: RETURN l_sdi_ee_exists;
1151: /*}*/

Line 1149: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1145: ELSE /* 2 */
1146: /*{*/
1147: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1148: 34);
1149: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1150: RETURN l_sdi_ee_exists;
1151: /*}*/
1152: END IF; /* 2 */
1153:

Line 1157: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: l_sdi_ee_exists := 'Y';
1157: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1158: 35);
1159: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1160: RETURN l_sdi_ee_exists;
1161: /*}*/

Line 1159: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1155: WHEN OTHERS THEN
1156: l_sdi_ee_exists := 'Y';
1157: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1158: 35);
1159: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1160: RETURN l_sdi_ee_exists;
1161: /*}*/
1162: END; /* p_type = SDI_EE */
1163: /*}*/

Line 1190: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);

1186: AND SES.session_id = USERENV('SESSIONID')
1187: AND SES.effective_date BETWEEN
1188: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1189:
1190: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);
1191: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);
1192:
1193: RETURN l_sdi_er_exists;
1194:

Line 1191: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);

1187: AND SES.effective_date BETWEEN
1188: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1189:
1190: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);
1191: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);
1192:
1193: RETURN l_sdi_er_exists;
1194:
1195: /*}*/

Line 1209: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1205: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1206: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1207: effective_start_date AND effective_end_date;
1208:
1209: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1210: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1211:
1212: RETURN l_eic_rs_exists;
1213:

Line 1210: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);

1206: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1207: effective_start_date AND effective_end_date;
1208:
1209: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1210: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1211:
1212: RETURN l_eic_rs_exists;
1213:
1214: EXCEPTION

Line 1217: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1213:
1214: EXCEPTION
1215: WHEN others THEN
1216: l_eic_rs_exists := 'N';
1217: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1218: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1219:
1220: RETURN l_eic_rs_exists;
1221:

Line 1218: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);

1214: EXCEPTION
1215: WHEN others THEN
1216: l_eic_rs_exists := 'N';
1217: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1218: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1219:
1220: RETURN l_eic_rs_exists;
1221:
1222: /*}*/

Line 1236: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1232: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1233: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1234: effective_start_date AND effective_end_date;
1235:
1236: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1237: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1238:
1239: RETURN l_eic_wk_exists;
1240:

Line 1237: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);

1233: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1234: effective_start_date AND effective_end_date;
1235:
1236: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1237: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1238:
1239: RETURN l_eic_wk_exists;
1240:
1241: EXCEPTION

Line 1244: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1240:
1241: EXCEPTION
1242: WHEN others THEN
1243: l_eic_wk_exists := 'N';
1244: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1245: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1246:
1247: RETURN l_eic_wk_exists;
1248:

Line 1245: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);

1241: EXCEPTION
1242: WHEN others THEN
1243: l_eic_wk_exists := 'N';
1244: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1245: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1246:
1247: RETURN l_eic_wk_exists;
1248:
1249: /*}*/

Line 1256: hr_utility.trace('BEGIN TAX TYPE COUNTY_RS');

1252: ELSIF p_type = 'COUNTY_RS' THEN /* 1 */
1253:
1254: BEGIN
1255:
1256: hr_utility.trace('BEGIN TAX TYPE COUNTY_RS');
1257:
1258: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */
1259:
1260: if p_pact_id is not null then

Line 1265: hr_utility.trace('l_indiana_override '||l_indiana_override);

1261:
1262: open override_state;
1263: fetch override_state into l_indiana_override;
1264:
1265: hr_utility.trace('l_indiana_override '||l_indiana_override);
1266: if override_state%found then
1267:
1268: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1269:

Line 1270: hr_utility.trace('l_across_years '||l_across_years);

1266: if override_state%found then
1267:
1268: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1269:
1270: hr_utility.trace('l_across_years '||l_across_years);
1271: if (l_indiana_override = 'IN' and
1272: l_across_years = 'Y') then
1273:
1274: select to_char(effective_date,'dd-mm-yyyy')

Line 1279: hr_utility.trace('l_date '||to_char(l_date));

1275: into l_date
1276: from pay_payroll_actions
1277: where payroll_action_id = p_pact_id;
1278:
1279: hr_utility.trace('l_date '||to_char(l_date));
1280: else
1281: l_date := l_date_earned;
1282: end if;
1283:

Line 1294: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);

1290: else
1291: l_date := l_date_earned;
1292: end if;
1293:
1294: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
1295:
1296: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1297: l_date);
1298:

Line 1299: hr_utility.trace('Resident JD Code as of 1st Jan '||

1295:
1296: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1297: l_date);
1298:
1299: hr_utility.trace('Resident JD Code as of 1st Jan '||
1300: l_rs_county_as_of_1st_jan);
1301: IF l_rs_county_as_of_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
1302: /* 1st Jan */
1303: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');

Line 1303: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');

1299: hr_utility.trace('Resident JD Code as of 1st Jan '||
1300: l_rs_county_as_of_1st_jan);
1301: IF l_rs_county_as_of_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
1302: /* 1st Jan */
1303: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');
1304: l_county_tax_exists := does_tax_exists(p_juri_code,
1305: l_date,
1306: p_tax_unit_id,
1307: p_assign_id,

Line 1310: hr_utility.trace('County Tax exist for JD code '||l_county_tax_exists);

1306: p_tax_unit_id,
1307: p_assign_id,
1308: p_pact_id,
1309: 'COUNTY_RS');
1310: hr_utility.trace('County Tax exist for JD code '||l_county_tax_exists);
1311: IF l_county_tax_exists = 'Y' THEN /* tax exists */
1312: /*{*/
1313: l_state_local_level_tax := state_local_level_tax(p_tax_unit_id,
1314: l_state_abbrev,

Line 1326: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');

1322: END IF; /* tax exists */
1323: /*}*/
1324: ELSE /* 1st Jan */
1325: /*{*/
1326: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
1327: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1328: RETURN('N'); /* the county is not as of 1st Jan */
1329: /*}*/
1330: END IF; /* 1st Jan */

Line 1327: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');

1323: /*}*/
1324: ELSE /* 1st Jan */
1325: /*{*/
1326: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
1327: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1328: RETURN('N'); /* the county is not as of 1st Jan */
1329: /*}*/
1330: END IF; /* 1st Jan */
1331: /*} END Indiana State Check */

Line 1346: hr_utility.trace('COUNTY_RS Tax Withheld = '||l_state_local_level_tax);

1342: /*{*/
1343: l_state_local_level_tax := state_local_level_tax(p_tax_unit_id,
1344: l_state_abbrev,
1345: p_juri_code);
1346: hr_utility.trace('COUNTY_RS Tax Withheld = '||l_state_local_level_tax);
1347: RETURN(l_state_local_level_tax);
1348:
1349: ELSE /* tax does not exists */
1350:

Line 1351: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');

1347: RETURN(l_state_local_level_tax);
1348:
1349: ELSE /* tax does not exists */
1350:
1351: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1352: RETURN('N');
1353:
1354: END IF; /* tax exists */
1355:

Line 1376: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');

1372: * please sure that all the conditions are satisfied.
1373: */
1374: ELSIF p_type = 'COUNTY_WK' THEN /* 1 */
1375: /*{*/
1376: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');
1377: BEGIN
1378: /*{*/
1379: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);
1380: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */

Line 1379: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);

1375: /*{*/
1376: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');
1377: BEGIN
1378: /*{*/
1379: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);
1380: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */
1381: /*{ Changed for Bug 1366176 */
1382: /*
1383: * get RS county and check taxes exists there or no

Line 1385: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');

1381: /*{ Changed for Bug 1366176 */
1382: /*
1383: * get RS county and check taxes exists there or no
1384: */
1385: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');
1386: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1387: l_date_earned);
1388: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);
1389: /*

Line 1388: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);

1384: */
1385: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');
1386: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1387: l_date_earned);
1388: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);
1389: /*
1390: * we need to check if residence state - county is same as
1391: * work state - county. If yes then we calculate taxes at work else we
1392: * need to check the following.

Line 1396: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');

1392: * need to check the following.
1393: */
1394: IF SUBSTR(p_juri_code, 1, 6) = l_rs_county_as_of_1st_jan THEN
1395: /*{*/
1396: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');
1397: IF l_rs_county_as_of_1st_jan <> '00-000' THEN
1398: /*{*/
1399: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);
1400: l_does_tax_exists := does_tax_exists(l_rs_county_as_of_1st_jan,

Line 1399: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);

1395: /*{*/
1396: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');
1397: IF l_rs_county_as_of_1st_jan <> '00-000' THEN
1398: /*{*/
1399: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);
1400: l_does_tax_exists := does_tax_exists(l_rs_county_as_of_1st_jan,
1401: l_date_earned,
1402: p_tax_unit_id,
1403: p_assign_id,

Line 1406: hr_utility.trace('5360 COUNTY_WK Does tax exist for COUNTY RS '

1402: p_tax_unit_id,
1403: p_assign_id,
1404: p_pact_id,
1405: 'COUNTY_RS');
1406: hr_utility.trace('5360 COUNTY_WK Does tax exist for COUNTY RS '
1407: || l_does_tax_exists);
1408: /*
1409: * If residence county has tax, which is same as work county in
1410: * this case. So we will withhold taxes at work county itself

Line 1433: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');

1429: * that is it is not an Indiana county as of 1st Jan
1430: * so we have to withhold work county taxes.
1431: */
1432: /*{*/
1433: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');
1434: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '
1435: || l_does_tax_exists);
1436:
1437: RETURN('Y') ;

Line 1434: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '

1430: * so we have to withhold work county taxes.
1431: */
1432: /*{*/
1433: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');
1434: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '
1435: || l_does_tax_exists);
1436:
1437: RETURN('Y') ;
1438: /*}*/

Line 1443: hr_utility.trace('5390 Work County_Code <> Resident County_Code as of 1st Jan');

1439: END IF; /* l_rs_county_as_of_1st_jan < > '00-000' */
1440: /*}*/
1441: ELSE /* if substr(p_juri_code,1,6) <> l_rs_county_as_of_1st_jan */
1442: /*{*/
1443: hr_utility.trace('5390 Work County_Code <> Resident County_Code as of 1st Jan');
1444: /*Bug#6742101: If payroll period ends in one calendar year and
1445: the check date is in the next following year then date paid should be
1446: used. */
1447: if p_pact_id is not null then

Line 1451: hr_utility.trace('l_across_years '||l_across_years);

1447: if p_pact_id is not null then
1448:
1449: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1450:
1451: hr_utility.trace('l_across_years '||l_across_years);
1452: if (l_across_years = 'Y') then
1453:
1454: select to_char(effective_date,'dd-mm-yyyy')
1455: into l_date

Line 1459: hr_utility.trace('l_date '||to_char(l_date));

1455: into l_date
1456: from pay_payroll_actions
1457: where payroll_action_id = p_pact_id;
1458:
1459: hr_utility.trace('l_date '||to_char(l_date));
1460: else
1461: l_date := l_date_earned;
1462: end if;
1463:

Line 1473: hr_utility.trace('5390 COUNTY_WK Work Location as of 1st Jan '|| p_juri_code);

1469: l_date_earned,
1470: l_date, --l_date_earned,
1471: p_juri_code) THEN
1472: /*Bug#6742101: Changes ends here */
1473: hr_utility.trace('5390 COUNTY_WK Work Location as of 1st Jan '|| p_juri_code);
1474: /*{*/
1475: /*
1476: * Indiana county as of 1st Jan
1477: */

Line 1485: hr_utility.trace('5400 COUNTY_WK returned '

1481: p_assign_id,
1482: p_pact_id,
1483: 'COUNTY_WK' );
1484:
1485: hr_utility.trace('5400 COUNTY_WK returned '
1486: || l_does_tax_exists);
1487: IF l_does_tax_exists = 'Y' THEN
1488: /*{*/
1489: /* get RS county and check taxes exists there or no

Line 1510: hr_utility.trace('5410 COUNTY_WK returned '

1506: p_tax_unit_id,
1507: p_assign_id,
1508: p_pact_id,
1509: 'COUNTY_RS');
1510: hr_utility.trace('5410 COUNTY_WK returned '
1511: || l_does_tax_exists);
1512: /*
1513: * if the residence county has tax then return flase to work
1514: * county because we will withhold tax at residence and not at

Line 1521: hr_utility.trace('5420 COUNTY_WK County Tax Exist Returned ');

1517: * work.
1518: */
1519: IF l_does_tax_exists = 'N' THEN
1520: /*{*/
1521: hr_utility.trace('5420 COUNTY_WK County Tax Exist Returned ');
1522: RETURN('Y');
1523: /*}*/
1524: ELSE
1525: /*{*/

Line 1526: hr_utility.trace('5430 COUNTY_WK County Tax Exist Returned ');

1522: RETURN('Y');
1523: /*}*/
1524: ELSE
1525: /*{*/
1526: hr_utility.trace('5430 COUNTY_WK County Tax Exist Returned ');
1527: RETURN('N');
1528: /*}*/
1529: END IF;
1530: /*}*/

Line 1537: hr_utility.trace('5440 COUNTY_WK As CountyCode 00-000 Tax Exist returned ');

1533: /*
1534: * that is it is not an Indiana county as of 1st Jan
1535: * so we have to withhold work county taxes.
1536: */
1537: hr_utility.trace('5440 COUNTY_WK As CountyCode 00-000 Tax Exist returned ');
1538: RETURN('Y') ;
1539: /*}*/
1540: END IF; /* l_rs_county_as_of_1st_jan '00-000' */
1541: /*}*/

Line 1547: hr_utility.trace('5450 COUNTY_WK There are No Work County Tax So Tax Exist returned '

1543: /*{*/
1544: /*
1545: * there are no work county taxes
1546: */
1547: hr_utility.trace('5450 COUNTY_WK There are No Work County Tax So Tax Exist returned '
1548: ||l_does_tax_exists );
1549: RETURN(l_does_tax_exists);
1550: /*}*/
1551: END IF; /* l_does_tax_exists = 'Y' */

Line 1559: hr_utility.trace('5460 COUNTY_WK As WorkCounty As of 1st Jan is Not-Taxable Tax Exist returned ');

1555: /*
1556: * this is not the county as of 1st Jan so return false to
1557: * COUNTY_WK
1558: */
1559: hr_utility.trace('5460 COUNTY_WK As WorkCounty As of 1st Jan is Not-Taxable Tax Exist returned ');
1560: l_county_wk_exists := 'N';
1561: RETURN l_county_wk_exists;
1562: /*}*/
1563: END IF; /* Indiana county as of 1st Jan */

Line 1569: hr_utility.trace('5470 COUNTY_WK County is not in Indiana ');

1565: END IF; /* substr(p_juri_code,1,6) = l_rs_county_as_of_1st_jan */
1566: /*}*/
1567: ELSE /* check for state Other than Indiana */
1568: /*{*/
1569: hr_utility.trace('5470 COUNTY_WK County is not in Indiana ');
1570: l_county_wk_exists := does_tax_exists(p_juri_code,
1571: l_date_earned,
1572: p_tax_unit_id,
1573: p_assign_id,

Line 1576: hr_utility.trace('5480 COUNTY_WK returned '

1572: p_tax_unit_id,
1573: p_assign_id,
1574: p_pact_id,
1575: 'COUNTY_WK');
1576: hr_utility.trace('5480 COUNTY_WK returned '
1577: ||l_county_wk_exists);
1578: RETURN (l_county_wk_exists);
1579: /*}*/
1580: END IF; /* check for Indiana state */

Line 1584: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);

1580: END IF; /* check for Indiana state */
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: l_county_wk_exists := 'N';
1584: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);
1585: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);
1586: RETURN l_county_wk_exists;
1587: /*}*/
1588: END; /* COUNTY_WK */

Line 1585: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);

1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: l_county_wk_exists := 'N';
1584: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);
1585: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);
1586: RETURN l_county_wk_exists;
1587: /*}*/
1588: END; /* COUNTY_WK */
1589: /*}*/

Line 1618: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1614: IF l_city_rs_exists = 'Y' THEN /* 2 jit level */
1615: --{
1616: BEGIN /* see if the state has taxes in the ct setup */
1617: --{
1618: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1619: 70);
1620: hr_utility.trace('determining if the state is set up by the ct');
1621: l_city_rs_exists := get_tax_exists(p_juri_code,
1622: p_date_earned,

Line 1620: hr_utility.trace('determining if the state is set up by the ct');

1616: BEGIN /* see if the state has taxes in the ct setup */
1617: --{
1618: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1619: 70);
1620: hr_utility.trace('determining if the state is set up by the ct');
1621: l_city_rs_exists := get_tax_exists(p_juri_code,
1622: p_date_earned,
1623: p_tax_unit_id,
1624: p_assign_id,

Line 1627: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1623: p_tax_unit_id,
1624: p_assign_id,
1625: p_pact_id,
1626: 'SIT_RS');
1627: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1628: 71);
1629: hr_utility.trace('Is the state withholding taxes ? '
1630: ||l_city_rs_exists);
1631: IF l_city_rs_exists = 'Y' THEN /* 3 */

Line 1629: hr_utility.trace('Is the state withholding taxes ? '

1625: p_pact_id,
1626: 'SIT_RS');
1627: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1628: 71);
1629: hr_utility.trace('Is the state withholding taxes ? '
1630: ||l_city_rs_exists);
1631: IF l_city_rs_exists = 'Y' THEN /* 3 */
1632: --
1633: -- The state is taking taxes

Line 1677: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'

1673: FROM HR_ORGANIZATION_INFORMATION hoi
1674: WHERE hoi.ORG_INFORMATION_CONTEXT = 'Local Tax Rules'
1675: AND hoi.organization_id = p_tax_unit_id
1676: AND hoi.org_information1 = p_juri_code;
1677: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1678: , 72);
1679: hr_utility.trace('City Income Tax Exists : ' ||
1680: l_city_rs_exists);
1681: RETURN l_city_rs_exists;

Line 1679: hr_utility.trace('City Income Tax Exists : ' ||

1675: AND hoi.organization_id = p_tax_unit_id
1676: AND hoi.org_information1 = p_juri_code;
1677: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1678: , 72);
1679: hr_utility.trace('City Income Tax Exists : ' ||
1680: l_city_rs_exists);
1681: RETURN l_city_rs_exists;
1682: EXCEPTION
1683: WHEN OTHERS THEN

Line 1687: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'

1683: WHEN OTHERS THEN
1684: /*
1685: * If there is no value then return l_city_rs_exists = 'Y'
1686: */
1687: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1688: , 73);
1689: -- added for Bug # 4711572
1690: if l_local_tax_rules_type = 'LOCALITIES'
1691: then

Line 1693: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);

1689: -- added for Bug # 4711572
1690: if l_local_tax_rules_type = 'LOCALITIES'
1691: then
1692: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1693: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1694: -- if (nvl(l_jd_type,'NL') = 'RW')
1695: /*Modified for bug 7353397 to include Work at home scenario
1696: for caluclating taxes when 'Only Locatlites Under Local Tax Rules'
1697: is selected at GRE level */

Line 1700: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

1696: for caluclating taxes when 'Only Locatlites Under Local Tax Rules'
1697: is selected at GRE level */
1698: if (nvl(l_jd_type,'NL') = 'RW' or nvl(l_jd_type,'NL') = 'HW' )
1699: then
1700: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1701: return('Y');
1702: else
1703: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1704: l_wh_work_localities);

Line 1703: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||

1699: then
1700: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1701: return('Y');
1702: else
1703: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1704: l_wh_work_localities);
1705: RETURN l_org_info19;
1706: end if;
1707: else

Line 1708: hr_utility.trace('City Income Tax Exists : ' || l_org_info19);

1704: l_wh_work_localities);
1705: RETURN l_org_info19;
1706: end if;
1707: else
1708: hr_utility.trace('City Income Tax Exists : ' || l_org_info19);
1709: RETURN l_org_info19;
1710: end if;
1711: --}
1712: END; /* end check for locality exemption */

Line 1717: hr_utility.set_location(

1713: ELSE /* 3.1 */
1714: /* If Employer setup for State's Resident Tax is Only Withhold Tax at Work Location
1715: return No, so that Resident tax is not withhold for the resident jurisdiction
1716: */
1717: hr_utility.set_location(
1718: 'py_gt_tax_exists_pkg.get_tax_exists', 75);
1719: -- This is added to tax a jurisdiction if it is tagged OR
1720: -- resident jurisdiction is same Work
1721: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

Line 1722: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);

1718: 'py_gt_tax_exists_pkg.get_tax_exists', 75);
1719: -- This is added to tax a jurisdiction if it is tagged OR
1720: -- resident jurisdiction is same Work
1721: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1722: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1723: if (nvl(l_jd_type,'NL') = 'RT' OR
1724: nvl(l_jd_type,'NL') = 'RW' OR
1725: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1726: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

Line 1726: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

1722: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1723: if (nvl(l_jd_type,'NL') = 'RT' OR
1724: nvl(l_jd_type,'NL') = 'RW' OR
1725: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1726: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1727: return('Y');
1728: else
1729: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1730: l_wh_work_localities);

Line 1729: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||

1725: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1726: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1727: return('Y');
1728: else
1729: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1730: l_wh_work_localities);
1731: RETURN l_wh_work_localities;
1732: end if;
1733: END IF; /* 3.1 */

Line 1738: hr_utility.set_location(

1734: END;
1735: EXCEPTION /* The ct has nothing at the EI level set up */
1736: WHEN OTHERS THEN
1737: l_city_rs_exists := 'Y';
1738: hr_utility.set_location(
1739: 'py_gt_tax_exists_pkg.get_tax_exists', 76);
1740: hr_utility.trace(
1741: 'City Income Tax Exists : ' || l_city_rs_exists);
1742: RETURN l_city_rs_exists;

Line 1740: hr_utility.trace(

1736: WHEN OTHERS THEN
1737: l_city_rs_exists := 'Y';
1738: hr_utility.set_location(
1739: 'py_gt_tax_exists_pkg.get_tax_exists', 76);
1740: hr_utility.trace(
1741: 'City Income Tax Exists : ' || l_city_rs_exists);
1742: RETURN l_city_rs_exists;
1743: --}
1744: END; /* end for city_exists = Y */

Line 1751: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1747: /*
1748: * The state is not withholding or is not setup no city tax
1749: */
1750: --{
1751: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1752: 77);
1753: hr_utility.trace('City Income Tax Exists : ' ||
1754: l_city_rs_exists);
1755: RETURN l_city_rs_exists;

Line 1753: hr_utility.trace('City Income Tax Exists : ' ||

1749: */
1750: --{
1751: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1752: 77);
1753: hr_utility.trace('City Income Tax Exists : ' ||
1754: l_city_rs_exists);
1755: RETURN l_city_rs_exists;
1756: --}
1757: END IF; /* 3 */

Line 1769: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);

1765: END IF; /* 2 jit level */
1766: EXCEPTION /* No rows in the city jit table */
1767: WHEN OTHERS THEN
1768: l_city_rs_exists := 'N';
1769: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);
1770: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);
1771: RETURN l_city_rs_exists;
1772: --}
1773: END; /* CITY_RS */

Line 1770: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);

1766: EXCEPTION /* No rows in the city jit table */
1767: WHEN OTHERS THEN
1768: l_city_rs_exists := 'N';
1769: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);
1770: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);
1771: RETURN l_city_rs_exists;
1772: --}
1773: END; /* CITY_RS */
1774: --}

Line 1799: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1795: IF l_ht_wk_exists = 'Y' THEN /* 2 jit level */
1796: /*{*/
1797: BEGIN /* see if the state has taxes in the ct setup */
1798: /*{*/
1799: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1800: 180);
1801: hr_utility.trace('determining if the state is set up by the ct');
1802:
1803: l_ht_wk_exists := get_tax_exists(p_juri_code,

Line 1801: hr_utility.trace('determining if the state is set up by the ct');

1797: BEGIN /* see if the state has taxes in the ct setup */
1798: /*{*/
1799: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1800: 180);
1801: hr_utility.trace('determining if the state is set up by the ct');
1802:
1803: l_ht_wk_exists := get_tax_exists(p_juri_code,
1804: p_date_earned,
1805: p_tax_unit_id,

Line 1810: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1806: p_assign_id,
1807: p_pact_id,
1808: 'SIT_WK');
1809:
1810: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1811: 181);
1812: hr_utility.trace('Is the state withholding taxes ? '||
1813: l_ht_wk_exists);
1814:

Line 1812: hr_utility.trace('Is the state withholding taxes ? '||

1808: 'SIT_WK');
1809:
1810: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1811: 181);
1812: hr_utility.trace('Is the state withholding taxes ? '||
1813: l_ht_wk_exists);
1814:
1815: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1816: /*{*/

Line 1817: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1813: l_ht_wk_exists);
1814:
1815: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1816: /*{*/
1817: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1818: 182);
1819: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1820: RETURN l_ht_wk_exists;
1821: /*}*/

Line 1819: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1815: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1816: /*{*/
1817: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1818: 182);
1819: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1820: RETURN l_ht_wk_exists;
1821: /*}*/
1822: ELSE /* 3 */
1823: /*

Line 1827: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1823: /*
1824: * The state is not withholding or is not setup no head tax
1825: */
1826: /*{*/
1827: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1828: 183);
1829: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1830:
1831: RETURN l_ht_wk_exists;

Line 1829: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1825: */
1826: /*{*/
1827: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1828: 183);
1829: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1830:
1831: RETURN l_ht_wk_exists;
1832: /*}*/
1833: END IF; /* 3 */

Line 1845: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);

1841: END IF; /* 2 jit level */
1842: EXCEPTION /* No rows in the city jit table */
1843: WHEN OTHERS THEN
1844: l_ht_wk_exists := 'N';
1845: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);
1846: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1847: RETURN l_ht_wk_exists;
1848: /*}*/
1849: END; /* HT_WK */

Line 1846: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1842: EXCEPTION /* No rows in the city jit table */
1843: WHEN OTHERS THEN
1844: l_ht_wk_exists := 'N';
1845: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);
1846: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1847: RETURN l_ht_wk_exists;
1848: /*}*/
1849: END; /* HT_WK */
1850: /*}*/

Line 1874: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1870: IF l_city_wk_exists = 'Y' THEN /* 2 jit level */
1871: /*{*/
1872: BEGIN /* see if the state has taxes in the ct setup */
1873: /*{*/
1874: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1875: 80);
1876: hr_utility.trace('determining if the state is set up by the ct');
1877:
1878: l_city_wk_exists := get_tax_exists(p_juri_code,

Line 1876: hr_utility.trace('determining if the state is set up by the ct');

1872: BEGIN /* see if the state has taxes in the ct setup */
1873: /*{*/
1874: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1875: 80);
1876: hr_utility.trace('determining if the state is set up by the ct');
1877:
1878: l_city_wk_exists := get_tax_exists(p_juri_code,
1879: p_date_earned,
1880: p_tax_unit_id,

Line 1886: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1882: p_pact_id,
1883: 'SIT_WK',
1884: 'CITY_WK');
1885:
1886: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1887: 81);
1888: hr_utility.trace('Is the state withholding taxes ? '
1889: ||l_city_wk_exists);
1890:

Line 1888: hr_utility.trace('Is the state withholding taxes ? '

1884: 'CITY_WK');
1885:
1886: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1887: 81);
1888: hr_utility.trace('Is the state withholding taxes ? '
1889: ||l_city_wk_exists);
1890:
1891: IF l_city_wk_exists = 'Y' THEN /* 3 */
1892: /*

Line 1896: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',

1892: /*
1893: * The state is taking taxes
1894: */
1895: /*{*/
1896: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
1897: 82);
1898: hr_utility.trace('City Income Tax Exists : ' ||
1899: l_city_wk_exists);
1900: RETURN l_city_wk_exists;

Line 1898: hr_utility.trace('City Income Tax Exists : ' ||

1894: */
1895: /*{*/
1896: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
1897: 82);
1898: hr_utility.trace('City Income Tax Exists : ' ||
1899: l_city_wk_exists);
1900: RETURN l_city_wk_exists;
1901:
1902: /*}*/

Line 1908: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',

1904: /*
1905: * The state is not withholding or is not setup no city tax
1906: */
1907: /*{*/
1908: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',
1909: 83);
1910: hr_utility.trace('City Income Tax Exists : '
1911: || l_city_wk_exists);
1912:

Line 1910: hr_utility.trace('City Income Tax Exists : '

1906: */
1907: /*{*/
1908: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',
1909: 83);
1910: hr_utility.trace('City Income Tax Exists : '
1911: || l_city_wk_exists);
1912:
1913: RETURN l_city_wk_exists;
1914:

Line 1928: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);

1924: END IF; /* 2 jit level */
1925: EXCEPTION /* No rows in the city jit table */
1926: WHEN OTHERS THEN
1927: l_city_wk_exists := 'N';
1928: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);
1929: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);
1930: RETURN l_city_wk_exists;
1931: /*}*/
1932: END; /* CITY_WK */

Line 1929: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);

1925: EXCEPTION /* No rows in the city jit table */
1926: WHEN OTHERS THEN
1927: l_city_wk_exists := 'N';
1928: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);
1929: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);
1930: RETURN l_city_wk_exists;
1931: /*}*/
1932: END; /* CITY_WK */
1933: /*}*/

Line 1957: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1953: /*
1954: * we do not withhold, have to switch this to N for return to SIT
1955: */
1956: /*{*/
1957: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1958: 90);
1959: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1960: ||l_nr_exists);
1961: l_sit_rs_exists := 'N';

Line 1959: hr_utility.trace('NR Exists before need to return opp. to SIT : '

1955: */
1956: /*{*/
1957: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1958: 90);
1959: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1960: ||l_nr_exists);
1961: l_sit_rs_exists := 'N';
1962:
1963: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);

Line 1963: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);

1959: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1960: ||l_nr_exists);
1961: l_sit_rs_exists := 'N';
1962:
1963: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);
1964: hr_utility.trace('SIT Exists after switched the return from NR : '
1965: ||l_sit_rs_exists);
1966:
1967: RETURN l_sit_rs_exists;

Line 1964: hr_utility.trace('SIT Exists after switched the return from NR : '

1960: ||l_nr_exists);
1961: l_sit_rs_exists := 'N';
1962:
1963: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);
1964: hr_utility.trace('SIT Exists after switched the return from NR : '
1965: ||l_sit_rs_exists);
1966:
1967: RETURN l_sit_rs_exists;
1968:

Line 1975: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);

1971: /*
1972: * the nr cert is not checked, the value stored is N in the table
1973: */
1974: /*{*/
1975: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);
1976: hr_utility.trace('NR Exist before need to return opp. to SIT: '
1977: ||l_nr_exists);
1978:
1979: l_sit_rs_exists := 'Y';

Line 1976: hr_utility.trace('NR Exist before need to return opp. to SIT: '

1972: * the nr cert is not checked, the value stored is N in the table
1973: */
1974: /*{*/
1975: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);
1976: hr_utility.trace('NR Exist before need to return opp. to SIT: '
1977: ||l_nr_exists);
1978:
1979: l_sit_rs_exists := 'Y';
1980:

Line 1981: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);

1977: ||l_nr_exists);
1978:
1979: l_sit_rs_exists := 'Y';
1980:
1981: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);
1982: hr_utility.trace('SIT Exists after we switched the ret. from NR: '
1983: ||l_sit_rs_exists);
1984:
1985: RETURN l_sit_rs_exists;

Line 1982: hr_utility.trace('SIT Exists after we switched the ret. from NR: '

1978:
1979: l_sit_rs_exists := 'Y';
1980:
1981: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);
1982: hr_utility.trace('SIT Exists after we switched the ret. from NR: '
1983: ||l_sit_rs_exists);
1984:
1985: RETURN l_sit_rs_exists;
1986:

Line 1992: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);

1988: END IF; /* 2 */
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: l_nr_exists := 'N';
1992: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);
1993: hr_utility.trace('NR Exists before need to return opp. to SIT: '
1994: ||l_nr_exists);
1995:
1996: l_sit_rs_exists := 'Y';

Line 1993: hr_utility.trace('NR Exists before need to return opp. to SIT: '

1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: l_nr_exists := 'N';
1992: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);
1993: hr_utility.trace('NR Exists before need to return opp. to SIT: '
1994: ||l_nr_exists);
1995:
1996: l_sit_rs_exists := 'Y';
1997:

Line 1998: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);

1994: ||l_nr_exists);
1995:
1996: l_sit_rs_exists := 'Y';
1997:
1998: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);
1999: hr_utility.trace('SIT Exists after we switched the ret. from NR : '
2000: ||l_sit_rs_exists);
2001:
2002: RETURN l_sit_rs_exists;

Line 1999: hr_utility.trace('SIT Exists after we switched the ret. from NR : '

1995:
1996: l_sit_rs_exists := 'Y';
1997:
1998: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);
1999: hr_utility.trace('SIT Exists after we switched the ret. from NR : '
2000: ||l_sit_rs_exists);
2001:
2002: RETURN l_sit_rs_exists;
2003: /*}*/

Line 2033: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',

2029: AND hoi.org_information2 IS NOT NULL;
2030:
2031: IF l_sui_exists = 'N' THEN /* 2 */
2032: /*{*/
2033: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2034: 100);
2035: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2036:
2037: RETURN l_sui_exists;

Line 2035: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2031: IF l_sui_exists = 'N' THEN /* 2 */
2032: /*{*/
2033: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2034: 100);
2035: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2036:
2037: RETURN l_sui_exists;
2038: /*}*/
2039: ELSE /* 2 */

Line 2042: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',

2038: /*}*/
2039: ELSE /* 2 */
2040: /*{*/
2041: l_sui_exists := 'Y';
2042: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2043: 101);
2044: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2045:
2046: RETURN l_sui_exists;

Line 2044: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2040: /*{*/
2041: l_sui_exists := 'Y';
2042: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2043: 101);
2044: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2045:
2046: RETURN l_sui_exists;
2047:
2048: /*}*/

Line 2053: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',

2049: END IF; /* 2 */
2050: EXCEPTION
2051: WHEN NO_DATA_FOUND THEN
2052: l_sui_exists := 'Y';
2053: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
2054: 102);
2055: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2056: RETURN l_sui_exists;
2057: /*}*/

Line 2055: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2051: WHEN NO_DATA_FOUND THEN
2052: l_sui_exists := 'Y';
2053: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
2054: 102);
2055: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2056: RETURN l_sui_exists;
2057: /*}*/
2058: END;
2059: /*}*/

Line 2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);

2074: END IF; /* chk_product_install */
2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: l_exists := 'Y';
2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2079: hr_utility.trace('The main Exception handler was called and returns '
2080: ||'tax exists: '||l_exists);
2081: RETURN l_exists;
2082: -- hr_utility.trace_off;

Line 2079: hr_utility.trace('The main Exception handler was called and returns '

2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: l_exists := 'Y';
2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2079: hr_utility.trace('The main Exception handler was called and returns '
2080: ||'tax exists: '||l_exists);
2081: RETURN l_exists;
2082: -- hr_utility.trace_off;
2083: /*}*/

Line 2082: -- hr_utility.trace_off;

2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2079: hr_utility.trace('The main Exception handler was called and returns '
2080: ||'tax exists: '||l_exists);
2081: RETURN l_exists;
2082: -- hr_utility.trace_off;
2083: /*}*/
2084: END get_tax_exists;
2085:
2086:

Line 2212: hr_utility.trace('The tax type : '|| p_type);

2208: l_jit8_rule_nobypass := 'NOBYPASS'; /* Do not bypass the tax - pass JIT
2209: 08 along with earnings to Vertex */
2210: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2211:
2212: hr_utility.trace('The tax type : '|| p_type);
2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2214: hr_utility.trace('The date earned : '|| l_date_earned);
2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));

Line 2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);

2209: 08 along with earnings to Vertex */
2210: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2211:
2212: hr_utility.trace('The tax type : '|| p_type);
2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2214: hr_utility.trace('The date earned : '|| l_date_earned);
2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2217:

Line 2214: hr_utility.trace('The date earned : '|| l_date_earned);

2210: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2211:
2212: hr_utility.trace('The tax type : '|| p_type);
2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2214: hr_utility.trace('The date earned : '|| l_date_earned);
2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2217:
2218: SELECT DISTINCT pus.state_abbrev

Line 2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));

2211:
2212: hr_utility.trace('The tax type : '|| p_type);
2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2214: hr_utility.trace('The date earned : '|| l_date_earned);
2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2217:
2218: SELECT DISTINCT pus.state_abbrev
2219: INTO l_state_abbrev

Line 2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));

2212: hr_utility.trace('The tax type : '|| p_type);
2213: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2214: hr_utility.trace('The date earned : '|| l_date_earned);
2215: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2216: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2217:
2218: SELECT DISTINCT pus.state_abbrev
2219: INTO l_state_abbrev
2220: FROM pay_us_states pus

Line 2223: hr_utility.trace('The state abbrev is:' || l_state_abbrev);

2219: INTO l_state_abbrev
2220: FROM pay_us_states pus
2221: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
2222:
2223: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
2224:
2225: IF p_type = 'SIT_RS' THEN
2226: BEGIN
2227:

Line 2325: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2321: CLOSE local_rule;
2322: IF l_state_rule_for_local = 'L' THEN
2323:
2324: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2325: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2326:
2327: IF (nvl(l_jd_type,'NL') = 'RT' OR
2328: nvl(l_jd_type,'NL') = 'RW' OR
2329: nvl(l_jd_type,'NL') = 'HW' OR

Line 2356: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2352:
2353: IF l_local_rule = 'Y' THEN
2354:
2355: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2356: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2357:
2358: IF (nvl(l_jd_type,'NL') = 'RT' OR
2359: nvl(l_jd_type,'NL') = 'RW' OR
2360: nvl(l_jd_type,'NL') = 'HW' OR

Line 2402: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2398:
2399: IF l_local_rule = 'Y' THEN
2400:
2401: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2402: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2403:
2404: IF (nvl(l_jd_type,'NL') = 'RT' OR
2405: nvl(l_jd_type,'NL') = 'RW' OR
2406: nvl(l_jd_type,'NL') = 'HW' OR

Line 2454: hr_utility.trace('l_indiana_override '||l_indiana_override);

2450:
2451: OPEN override_state;
2452: FETCH override_state INTO l_indiana_override;
2453:
2454: hr_utility.trace('l_indiana_override '||l_indiana_override);
2455: IF override_state%found THEN
2456:
2457: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
2458:

Line 2459: hr_utility.trace('l_across_years '||l_across_years);

2455: IF override_state%found THEN
2456:
2457: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
2458:
2459: hr_utility.trace('l_across_years '||l_across_years);
2460: IF (l_indiana_override = 'IN' AND
2461: l_across_years = 'Y') THEN
2462:
2463: SELECT to_char(effective_date,'dd-mm-yyyy')

Line 2468: hr_utility.trace('l_date '||to_char(l_date));

2464: INTO l_date
2465: FROM pay_payroll_actions
2466: WHERE payroll_action_id = p_pact_id;
2467:
2468: hr_utility.trace('l_date '||to_char(l_date));
2469: ELSE
2470: l_date := l_date_earned;
2471: END IF;
2472:

Line 2486: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);

2482:
2483: l_rs_coty_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
2484: l_date);
2485:
2486: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
2487: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);
2488:
2489: IF l_rs_coty_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
2490:

Line 2487: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);

2483: l_rs_coty_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
2484: l_date);
2485:
2486: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
2487: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);
2488:
2489: IF l_rs_coty_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
2490:
2491: OPEN county_exists;

Line 2512: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');

2508: END IF;
2509:
2510: ELSE /* 1st Jan */
2511:
2512: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
2513:
2514: RETURN l_jit8_rule; /* the county is not as of 1st Jan */
2515:
2516: END IF; /* 1st Jan */

Line 2903: hr_utility.trace('p_location ='||p_location);

2899: p_gross := tax_balances(i).amount;
2900:
2901: ELSIF (p_location = 'RS') THEN
2902:
2903: hr_utility.trace('p_location ='||p_location);
2904: hr_utility.trace('p_tax_type ='||p_tax_type);
2905: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
2906: hr_utility.trace('p_subj='||p_subj);
2907:

Line 2904: hr_utility.trace('p_tax_type ='||p_tax_type);

2900:
2901: ELSIF (p_location = 'RS') THEN
2902:
2903: hr_utility.trace('p_location ='||p_location);
2904: hr_utility.trace('p_tax_type ='||p_tax_type);
2905: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
2906: hr_utility.trace('p_subj='||p_subj);
2907:
2908: IF l_subj_reduced > 0 THEN

Line 2905: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);

2901: ELSIF (p_location = 'RS') THEN
2902:
2903: hr_utility.trace('p_location ='||p_location);
2904: hr_utility.trace('p_tax_type ='||p_tax_type);
2905: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
2906: hr_utility.trace('p_subj='||p_subj);
2907:
2908: IF l_subj_reduced > 0 THEN
2909:

Line 2906: hr_utility.trace('p_subj='||p_subj);

2902:
2903: hr_utility.trace('p_location ='||p_location);
2904: hr_utility.trace('p_tax_type ='||p_tax_type);
2905: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
2906: hr_utility.trace('p_subj='||p_subj);
2907:
2908: IF l_subj_reduced > 0 THEN
2909:
2910: l_ratio := p_subj/l_subj_reduced;

Line 2945: hr_utility.trace('p_gross ='||p_gross);

2941: get_stored_balance(p_juri_code,
2942: p_tax_type||'_125_REDNS',
2943: p_location)) );
2944:
2945: hr_utility.trace('p_gross ='||p_gross);
2946: hr_utility.trace('l_ratio ='||l_ratio);
2947:
2948: END IF;
2949:

Line 2946: hr_utility.trace('l_ratio ='||l_ratio);

2942: p_tax_type||'_125_REDNS',
2943: p_location)) );
2944:
2945: hr_utility.trace('p_gross ='||p_gross);
2946: hr_utility.trace('l_ratio ='||l_ratio);
2947:
2948: END IF;
2949:
2950: END IF;