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

Line 56: hr_utility.trace('p_dp_mode :'||p_dp_mode);

52: -- Create a batch line for US Emp Fed Tax Rule Information
53:
54: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSFED' then
55:
56: hr_utility.trace('p_dp_mode :'||p_dp_mode);
57:
58: -- check for valid datatrack update modes
59: Dt_Api.Find_DT_Upd_Modes
60: (p_effective_date => l_effective_date

Line 74: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

70:
71: IF l_dt_update THEN
72:
73: l_datetrack_update_mode := 'UPDATE';
74: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
75:
76: ELSIF l_dt_upd_override OR
77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found

Line 80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

76: ELSIF l_dt_upd_override OR
77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found
79: -- NULL;
80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 81: hr_utility.raise_error;

77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found
79: -- NULL;
80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
85: END IF;

Line 84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
85: END IF;
86:
87:
88: ln_ovn := l_pay_us_fedtax_rule_rec.OBJECT_VERSION_NUMBER;

Line 115: hr_utility.trace('call to hrdpp_UPDATE_FED_TAX_RULE.insert_batch_lines done');

111: ,p_effective_start_date => ld_eff_start_date
112: ,p_effective_end_date => ld_eff_end_date
113: );
114:
115: hr_utility.trace('call to hrdpp_UPDATE_FED_TAX_RULE.insert_batch_lines done');
116:
117: end if; -- p_spreadsheet_identifier = 'PAYRIUSFED'
118:
119:

Line 125: hr_utility.trace('p_dp_mode :'||p_dp_mode);

121: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSSTATE' then
122:
123: if p_dp_mode = 'UPDATE' then
124:
125: hr_utility.trace('p_dp_mode :'||p_dp_mode);
126:
127: -- check for valid datatrack update modes
128: Dt_Api.Find_DT_Upd_Modes
129: (p_effective_date => l_effective_date

Line 143: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

139:
140: IF l_dt_update THEN
141:
142: l_datetrack_update_mode := 'UPDATE';
143: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

Line 147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

143: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 148: hr_utility.raise_error;

144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
152: END IF;

Line 151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
152: END IF;
153:
154:
155: ln_ovn := l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER;

Line 157: hr_utility.trace('Calling PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE');

153:
154:
155: ln_ovn := l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER;
156:
157: hr_utility.trace('Calling PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE');
158: PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE
159: (P_EFFECTIVE_DATE => l_effective_date
160: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
161: ,P_EMP_STATE_TAX_RULE_ID => l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID

Line 214: hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');

210: ,p_effective_start_date => ld_eff_start_date
211: ,p_effective_end_date => ld_eff_end_date
212: );
213:
214: hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');
215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line 218: hr_utility.trace('p_dp_mode :'||p_dp_mode);

214: hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');
215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);
219: hr_utility.trace('calling PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE ');
220:
221: PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE
222: (P_EFFECTIVE_DATE => p_effective_date

Line 219: hr_utility.trace('calling PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE ');

215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);
219: hr_utility.trace('calling PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE ');
220:
221: PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE
222: (P_EFFECTIVE_DATE => p_effective_date
223: ,P_ASSIGNMENT_ID => l_pay_us_statetax_rule_rec.ASSIGNMENT_ID

Line 279: hr_utility.trace('emp_state_tax_rule_id : '||to_char(ln_emp_state_tax_rule_id));

275: ,p_effective_start_date => ld_eff_start_date
276: ,p_effective_end_date => ld_eff_end_date
277: );
278:
279: hr_utility.trace('emp_state_tax_rule_id : '||to_char(ln_emp_state_tax_rule_id));
280: hr_utility.trace('call to PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE done');
281: end if; -- end if for p_dp_mode validation for US State Tax
282:
283: end if; -- p_spreadsheet_identifier = 'PAYRIUSSTATE'

Line 280: hr_utility.trace('call to PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE done');

276: ,p_effective_end_date => ld_eff_end_date
277: );
278:
279: hr_utility.trace('emp_state_tax_rule_id : '||to_char(ln_emp_state_tax_rule_id));
280: hr_utility.trace('call to PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE done');
281: end if; -- end if for p_dp_mode validation for US State Tax
282:
283: end if; -- p_spreadsheet_identifier = 'PAYRIUSSTATE'
284:

Line 290: hr_utility.trace('p_dp_mode :'||p_dp_mode);

286: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCOUNTY' then
287:
288: if p_dp_mode = 'UPDATE' then
289:
290: hr_utility.trace('p_dp_mode :'||p_dp_mode);
291:
292:
293: -- check for valid datatrack update modes
294: Dt_Api.Find_DT_Upd_Modes

Line 309: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

305:
306: IF l_dt_update THEN
307:
308: l_datetrack_update_mode := 'UPDATE';
309: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
310:
311: ELSIF l_dt_upd_override OR
312: l_upd_chg_ins THEN
313: -- Need to check if future datetrack records exist

Line 316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

312: l_upd_chg_ins THEN
313: -- Need to check if future datetrack records exist
314: -- if yes then raise error
315: -- NULL;
316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 317: hr_utility.raise_error;

313: -- Need to check if future datetrack records exist
314: -- if yes then raise error
315: -- NULL;
316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
321: END IF;

Line 320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
321: END IF;
322:
323: ln_ovn := l_pay_us_countytax_rule_rec.OBJECT_VERSION_NUMBER;
324:

Line 343: hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');

339: ,p_object_version_number => ln_ovn
340: ,p_effective_date => l_effective_date
341: ,p_datetrack_mode => l_datetrack_update_mode
342: );
343: hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');
344:
345: elsif p_dp_mode = 'INSERT' then
346:
347: hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line 347: hr_utility.trace('p_dp_mode :'||p_dp_mode);

343: hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');
344:
345: elsif p_dp_mode = 'INSERT' then
346:
347: hr_utility.trace('p_dp_mode :'||p_dp_mode);
348:
349: pay_county_tax_rule_api.create_county_tax_rule
350: (p_emp_county_tax_rule_id => ln_emp_county_tax_rule_id
351: ,p_effective_start_date => ld_eff_start_date

Line 371: hr_utility.trace('call to pay_county_tax_rule_api.create_county_tax_rule done');

367: ,p_effective_date => l_effective_date
368: );
369:
370:
371: hr_utility.trace('call to pay_county_tax_rule_api.create_county_tax_rule done');
372: end if; -- end if for p_dp_mode validation for US County Tax
373:
374: end if; -- P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCOUNTY'
375:

Line 381: hr_utility.trace('p_dp_mode :'||p_dp_mode);

377: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCITY' then
378:
379: if p_dp_mode = 'UPDATE' then
380:
381: hr_utility.trace('p_dp_mode :'||p_dp_mode);
382:
383: -- check for valid datatrack update modes
384: Dt_Api.Find_DT_Upd_Modes
385: (p_effective_date => l_effective_date

Line 398: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

394:
395: IF l_dt_update THEN
396:
397: l_datetrack_update_mode := 'UPDATE';
398: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
399:
400: ELSIF l_dt_upd_override OR
401: l_upd_chg_ins THEN
402: -- Need to check if future datetrack records exist

Line 405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

401: l_upd_chg_ins THEN
402: -- Need to check if future datetrack records exist
403: -- if yes then raise error
404: -- NULL;
405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 406: hr_utility.raise_error;

402: -- Need to check if future datetrack records exist
403: -- if yes then raise error
404: -- NULL;
405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
410: END IF;

Line 409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
410: END IF;
411:
412:
413: ln_ovn := l_pay_us_citytax_rule_rec.OBJECT_VERSION_NUMBER;

Line 434: hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');

430: ,p_effective_start_date => ld_eff_start_date
431: ,p_effective_end_date => ld_eff_end_date
432: );
433:
434: hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');
435:
436: elsif p_dp_mode = 'INSERT' then
437:
438: hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line 438: hr_utility.trace('p_dp_mode :'||p_dp_mode);

434: hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');
435:
436: elsif p_dp_mode = 'INSERT' then
437:
438: hr_utility.trace('p_dp_mode :'||p_dp_mode);
439:
440: pay_city_tax_rule_api.create_city_tax_rule
441: (P_ASSIGNMENT_ID => l_pay_us_citytax_rule_rec.ASSIGNMENT_ID
442: ,P_STATE_CODE => l_pay_us_citytax_rule_rec.state_code

Line 462: hr_utility.trace('call to pay_city_tax_rule_api.create_city_tax_rule done');

458: ,p_effective_end_date => ld_eff_end_date
459: ,p_object_version_number => ln_ovn
460: );
461:
462: hr_utility.trace('call to pay_city_tax_rule_api.create_city_tax_rule done');
463: end if; -- end if for p_dp_mode validation for US County Tax
464:
465: end if; -- P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCITY'
466:

Line 471: hr_utility.trace('p_dp_mode :'||p_dp_mode);

467: if P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
468:
469: if p_dp_mode = 'UPDATE' then
470:
471: hr_utility.trace('p_dp_mode :'||p_dp_mode);
472:
473: -- check for valid datatrack update modes
474: Dt_Api.Find_DT_Upd_Modes
475: (p_effective_date => l_effective_date

Line 488: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

484:
485: IF l_dt_update THEN
486:
487: l_datetrack_update_mode := 'UPDATE';
488: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
489:
490: ELSIF l_dt_upd_override OR
491: l_upd_chg_ins THEN
492: -- Need to check if future dated record exists

Line 495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

491: l_upd_chg_ins THEN
492: -- Need to check if future dated record exists
493: -- if yes then raise error
494: -- NULL;
495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 496: hr_utility.raise_error;

492: -- Need to check if future dated record exists
493: -- if yes then raise error
494: -- NULL;
495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
500: END IF;

Line 499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
500: END IF;
501:
502: ln_ovn := l_pay_ca_fedtax_rule_rec.OBJECT_VERSION_NUMBER;
503:

Line 562: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');

558: ,p_effective_start_date => ld_eff_start_date
559: ,p_effective_end_date => ld_eff_end_date
560: ,p_object_version_number => ln_ovn);
561:
562: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');
563:
564: elsif p_dp_mode = 'INSERT' then
565:
566: hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line 566: hr_utility.trace('p_dp_mode :'||p_dp_mode);

562: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');
563:
564: elsif p_dp_mode = 'INSERT' then
565:
566: hr_utility.trace('p_dp_mode :'||p_dp_mode);
567:
568: pay_ca_emp_fedtax_inf_api.create_ca_emp_fedtax_inf
569: (P_ASSIGNMENT_ID => l_pay_ca_fedtax_rule_rec.ASSIGNMENT_ID
570: ,P_LEGISLATION_CODE => l_pay_ca_fedtax_rule_rec.LEGISLATION_CODE

Line 626: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.create_ca_emp_fedtax_inf done');

622: ,p_effective_start_date => ld_eff_start_date
623: ,p_effective_end_date => ld_eff_end_date
624: ,p_object_version_number => ln_ovn);
625:
626: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.create_ca_emp_fedtax_inf done');
627: end if; -- end if for p_dp_mode validation for Canada Federal Tax
628:
629: end if; -- p_spreadsheet_identifier = 'PAYRICAFED'
630:

Line 635: hr_utility.trace('p_dp_mode :'||p_dp_mode);

631: if P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
632:
633: if p_dp_mode = 'UPDATE' then
634:
635: hr_utility.trace('p_dp_mode :'||p_dp_mode);
636:
637: -- check for valid datatrack update modes
638: Dt_Api.Find_DT_Upd_Modes
639: (p_effective_date => l_effective_date

Line 653: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

649:
650: IF l_dt_update THEN
651:
652: l_datetrack_update_mode := 'UPDATE';
653: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
654:
655: ELSIF l_dt_upd_override OR
656: l_upd_chg_ins THEN
657: -- Need to check if future dated record exists

Line 660: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

656: l_upd_chg_ins THEN
657: -- Need to check if future dated record exists
658: -- if yes then raise error
659: -- NULL;
660: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
661: hr_utility.raise_error;
662: ELSE
663: l_datetrack_update_mode := 'CORRECTION';
664: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line 661: hr_utility.raise_error;

657: -- Need to check if future dated record exists
658: -- if yes then raise error
659: -- NULL;
660: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
661: hr_utility.raise_error;
662: ELSE
663: l_datetrack_update_mode := 'CORRECTION';
664: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
665: END IF;

Line 664: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

660: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
661: hr_utility.raise_error;
662: ELSE
663: l_datetrack_update_mode := 'CORRECTION';
664: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
665: END IF;
666:
667: ln_ovn := l_pay_ca_provtax_rule_rec.OBJECT_VERSION_NUMBER;
668:

Line 733: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');

729: ,p_effective_end_date => ld_eff_end_date
730: ,p_object_version_number => ln_ovn
731: ,P_PPIP_EXEMPT_FLAG => l_pay_ca_provtax_rule_rec.PPIP_EXEMPT_FLAG);
732:
733: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');
734:
735: elsif p_dp_mode = 'INSERT' then
736:
737: hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line 737: hr_utility.trace('p_dp_mode :'||p_dp_mode);

733: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');
734:
735: elsif p_dp_mode = 'INSERT' then
736:
737: hr_utility.trace('p_dp_mode :'||p_dp_mode);
738:
739: hr_utility.trace('Calling PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf API ');
740: PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf(
741: p_emp_province_tax_inf_id => ln_ca_emp_prov_tax_inf_id

Line 739: hr_utility.trace('Calling PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf API ');

735: elsif p_dp_mode = 'INSERT' then
736:
737: hr_utility.trace('p_dp_mode :'||p_dp_mode);
738:
739: hr_utility.trace('Calling PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf API ');
740: PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf(
741: p_emp_province_tax_inf_id => ln_ca_emp_prov_tax_inf_id
742: ,P_LEGISLATION_CODE => l_pay_ca_provtax_rule_rec.LEGISLATION_CODE
743: ,p_business_group_id => l_pay_ca_provtax_rule_rec.business_group_id

Line 805: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf done');

801: ,p_object_version_number => ln_ovn
802: ,P_PPIP_EXEMPT_FLAG => l_pay_ca_provtax_rule_rec.PPIP_EXEMPT_FLAG);
803:
804:
805: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf done');
806: end if; -- end if for p_dp_mode validation for Canada Provincial Tax
807:
808:
809: end if; -- p_spreadsheet_identifier = 'PAYRICAPROVINCE'

Line 1075: /hr_utility.trace_on(null,'TESTTAX');/

1071: g_employee := p_employee;
1072: g_assignment := p_assignment;
1073:
1074:
1075: /*hr_utility.trace_on(null,'TESTTAX');*/
1076:
1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));

Line 1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));

1073:
1074:
1075: /*hr_utility.trace_on(null,'TESTTAX');*/
1076:
1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);

Line 1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));

1074:
1075: /*hr_utility.trace_on(null,'TESTTAX');*/
1076:
1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);

Line 1079: hr_utility.trace('p_employee :'||to_char(p_employee));

1075: /*hr_utility.trace_on(null,'TESTTAX');*/
1076:
1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);

Line 1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));

1076:
1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);

Line 1081: hr_utility.trace('p_legislation :'||p_legislation);

1077: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);

Line 1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);

1078: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);

Line 1083: hr_utility.trace('p_sui_state :'||p_sui_state);

1079: hr_utility.trace('p_employee :'||to_char(p_employee));
1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);

Line 1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);

1080: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);

Line 1085: hr_utility.trace('p_county :'||p_county);

1081: hr_utility.trace('p_legislation :'||p_legislation);
1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));

Line 1086: hr_utility.trace('p_city :'||p_city);

1082: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));

Line 1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);

1083: hr_utility.trace('p_sui_state :'||p_sui_state);
1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);

Line 1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);

1084: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));

Line 1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));

1085: hr_utility.trace('p_county :'||p_county);
1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));

Line 1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));

1086: hr_utility.trace('p_city :'||p_city);
1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));

Line 1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);

1087: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));

Line 1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));

1088: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);

Line 1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));

1089: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));

Line 1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));

1090: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));

Line 1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));

1091: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);

Line 1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);

1092: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);

Line 1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));

1093: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);

Line 1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));

1094: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);

Line 1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);

1095: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));

Line 1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);

1096: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));

Line 1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);

1097: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));

Line 1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);

1098: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));

Line 1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));

1099: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));

Line 1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));

1100: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));

Line 1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));

1101: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);

Line 1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));

1102: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);

Line 1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));

1103: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));

Line 1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));

1104: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);

Line 1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);

1105: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);

Line 1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);

1106: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));

Line 1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));

1107: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);

Line 1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);

1108: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));

Line 1113: hr_utility.trace('p_non_resident :'||p_non_resident);

1109: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));

Line 1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));

1110: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);

Line 1115: hr_utility.trace('p_school_district :'||p_school_district);

1111: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);

Line 1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));

1112: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));

Line 1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));

1113: hr_utility.trace('p_non_resident :'||p_non_resident);
1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));

Line 1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);

1114: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);

Line 1119: hr_utility.trace('p_disability_status :'||p_disability_status);

1115: hr_utility.trace('p_school_district :'||p_school_district);
1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);

Line 1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));

1116: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);

Line 1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));

1117: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);

Line 1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);

1118: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);

Line 1123: hr_utility.trace('sta_information1 :'||p_sta_information1);

1119: hr_utility.trace('p_disability_status :'||p_disability_status);
1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);

Line 1124: hr_utility.trace('sta_information2 :'||p_sta_information2);

1120: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);

Line 1125: hr_utility.trace('sta_information3 :'||p_sta_information3);

1121: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);

Line 1126: hr_utility.trace('sta_information4 :'||p_sta_information4);

1122: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);

Line 1127: hr_utility.trace('sta_information5 :'||p_sta_information5);

1123: hr_utility.trace('sta_information1 :'||p_sta_information1);
1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);

Line 1128: hr_utility.trace('sta_information6 :'||p_sta_information6);

1124: hr_utility.trace('sta_information2 :'||p_sta_information2);
1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);

Line 1129: hr_utility.trace('sta_information7 :'||p_sta_information7);

1125: hr_utility.trace('sta_information3 :'||p_sta_information3);
1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);

Line 1130: hr_utility.trace('sta_information8 :'||p_sta_information8);

1126: hr_utility.trace('sta_information4 :'||p_sta_information4);
1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);

Line 1131: hr_utility.trace('sta_information9 :'||p_sta_information9);

1127: hr_utility.trace('sta_information5 :'||p_sta_information5);
1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);

Line 1132: hr_utility.trace('sta_information10 :'||p_sta_information10);

1128: hr_utility.trace('sta_information6 :'||p_sta_information6);
1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);

Line 1133: hr_utility.trace('sta_information11 :'||p_sta_information11);

1129: hr_utility.trace('sta_information7 :'||p_sta_information7);
1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);

Line 1134: hr_utility.trace('sta_information12 :'||p_sta_information12);

1130: hr_utility.trace('sta_information8 :'||p_sta_information8);
1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);

Line 1135: hr_utility.trace('sta_information13 :'||p_sta_information13);

1131: hr_utility.trace('sta_information9 :'||p_sta_information9);
1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);

Line 1136: hr_utility.trace('sta_information14 :'||p_sta_information14);

1132: hr_utility.trace('sta_information10 :'||p_sta_information10);
1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);

Line 1137: hr_utility.trace('sta_information15 :'||p_sta_information15);

1133: hr_utility.trace('sta_information11 :'||p_sta_information11);
1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);

Line 1138: hr_utility.trace('sta_information16 :'||p_sta_information16);

1134: hr_utility.trace('sta_information12 :'||p_sta_information12);
1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);

Line 1139: hr_utility.trace('sta_information17 :'||p_sta_information17);

1135: hr_utility.trace('sta_information13 :'||p_sta_information13);
1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);

Line 1140: hr_utility.trace('sta_information18 :'||p_sta_information18);

1136: hr_utility.trace('sta_information14 :'||p_sta_information14);
1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);

Line 1141: hr_utility.trace('sta_information19 :'||p_sta_information19);

1137: hr_utility.trace('sta_information15 :'||p_sta_information15);
1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);

Line 1142: hr_utility.trace('sta_information20 :'||p_sta_information20);

1138: hr_utility.trace('sta_information16 :'||p_sta_information16);
1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);

Line 1143: hr_utility.trace('sta_information21 :'||p_sta_information21);

1139: hr_utility.trace('sta_information17 :'||p_sta_information17);
1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);

Line 1144: hr_utility.trace('sta_information22 :'||p_sta_information22);

1140: hr_utility.trace('sta_information18 :'||p_sta_information18);
1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);

Line 1145: hr_utility.trace('sta_information23 :'||p_sta_information23);

1141: hr_utility.trace('sta_information19 :'||p_sta_information19);
1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);

Line 1146: hr_utility.trace('sta_information24 :'||p_sta_information24);

1142: hr_utility.trace('sta_information20 :'||p_sta_information20);
1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);

Line 1147: hr_utility.trace('sta_information25 :'||p_sta_information25);

1143: hr_utility.trace('sta_information21 :'||p_sta_information21);
1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);

Line 1148: hr_utility.trace('sta_information26 :'||p_sta_information26);

1144: hr_utility.trace('sta_information22 :'||p_sta_information22);
1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);
1152: hr_utility.trace('sta_information30 :'||p_sta_information30);

Line 1149: hr_utility.trace('sta_information27 :'||p_sta_information27);

1145: hr_utility.trace('sta_information23 :'||p_sta_information23);
1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);
1152: hr_utility.trace('sta_information30 :'||p_sta_information30);
1153:

Line 1150: hr_utility.trace('sta_information28 :'||p_sta_information28);

1146: hr_utility.trace('sta_information24 :'||p_sta_information24);
1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);
1152: hr_utility.trace('sta_information30 :'||p_sta_information30);
1153:
1154: open csr_get_asg_id;

Line 1151: hr_utility.trace('sta_information29 :'||p_sta_information29);

1147: hr_utility.trace('sta_information25 :'||p_sta_information25);
1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);
1152: hr_utility.trace('sta_information30 :'||p_sta_information30);
1153:
1154: open csr_get_asg_id;
1155: fetch csr_get_asg_id into ln_assignment_id;

Line 1152: hr_utility.trace('sta_information30 :'||p_sta_information30);

1148: hr_utility.trace('sta_information26 :'||p_sta_information26);
1149: hr_utility.trace('sta_information27 :'||p_sta_information27);
1150: hr_utility.trace('sta_information28 :'||p_sta_information28);
1151: hr_utility.trace('sta_information29 :'||p_sta_information29);
1152: hr_utility.trace('sta_information30 :'||p_sta_information30);
1153:
1154: open csr_get_asg_id;
1155: fetch csr_get_asg_id into ln_assignment_id;
1156: close csr_get_asg_id;

Line 1157: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));

1153:
1154: open csr_get_asg_id;
1155: fetch csr_get_asg_id into ln_assignment_id;
1156: close csr_get_asg_id;
1157: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));
1158:
1159:
1160: -- ========================================================================
1161: -- US Federal Tax Rule Information

Line 1184: hr_utility.trace('emp_fed_tax_rule_id :'||to_char(ln_fedtax_rule_id));

1180: l_pay_us_fedtax_rule_rec.EXCESSIVE_WA_REJECT_DATE := P_ALLOWANCE_REJECT_DATE;
1181:
1182: open csr_get_fedtax_id(ln_assignment_id);
1183: fetch csr_get_fedtax_id into ln_fedtax_rule_id,ln_ovn2;
1184: hr_utility.trace('emp_fed_tax_rule_id :'||to_char(ln_fedtax_rule_id));
1185: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1186:
1187: if csr_get_fedtax_id%FOUND then
1188: l_pay_us_fedtax_rule_rec.EMP_FED_TAX_RULE_ID := ln_fedtax_rule_id;

Line 1185: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1181:
1182: open csr_get_fedtax_id(ln_assignment_id);
1183: fetch csr_get_fedtax_id into ln_fedtax_rule_id,ln_ovn2;
1184: hr_utility.trace('emp_fed_tax_rule_id :'||to_char(ln_fedtax_rule_id));
1185: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1186:
1187: if csr_get_fedtax_id%FOUND then
1188: l_pay_us_fedtax_rule_rec.EMP_FED_TAX_RULE_ID := ln_fedtax_rule_id;
1189: l_pay_us_fedtax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;

Line 1213: hr_utility.trace('Filing Status Code :'||lv_lookup_code);

1209:
1210: -- Fix for bug#4526310
1211: lv_lookup_code := '0'||lv_lookup_code;
1212:
1213: hr_utility.trace('Filing Status Code :'||lv_lookup_code);
1214: l_pay_us_statetax_rule_rec := null;
1215:
1216: l_pay_us_statetax_rule_rec.state_code := P_STATE_PROV_CODE;
1217: l_pay_us_statetax_rule_rec.FILING_STATUS_CODE := lv_lookup_code;

Line 1269: hr_utility.trace('emp_state_tax_rule_id :'||to_char(ln_statetax_rule_id));

1265:
1266:
1267: open csr_get_statetax_id(ln_assignment_id);
1268: fetch csr_get_statetax_id into ln_statetax_rule_id,ln_ovn2;
1269: hr_utility.trace('emp_state_tax_rule_id :'||to_char(ln_statetax_rule_id));
1270: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1271:
1272: if csr_get_statetax_id%FOUND then
1273: l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID := ln_statetax_rule_id;

Line 1270: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1266:
1267: open csr_get_statetax_id(ln_assignment_id);
1268: fetch csr_get_statetax_id into ln_statetax_rule_id,ln_ovn2;
1269: hr_utility.trace('emp_state_tax_rule_id :'||to_char(ln_statetax_rule_id));
1270: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1271:
1272: if csr_get_statetax_id%FOUND then
1273: l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID := ln_statetax_rule_id;
1274: l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;

Line 1327: hr_utility.trace('emp_county_tax_rule_id :'||to_char(ln_countytax_rule_id));

1323: l_pay_us_countytax_rule_rec.county_code := lv_county_code;
1324:
1325: open csr_get_countytax_id(ln_assignment_id,lv_county_code);
1326: fetch csr_get_countytax_id into ln_countytax_rule_id,ln_ovn2;
1327: hr_utility.trace('emp_county_tax_rule_id :'||to_char(ln_countytax_rule_id));
1328: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1329:
1330: if csr_get_countytax_id%FOUND then
1331: l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID := ln_countytax_rule_id;

Line 1328: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1324:
1325: open csr_get_countytax_id(ln_assignment_id,lv_county_code);
1326: fetch csr_get_countytax_id into ln_countytax_rule_id,ln_ovn2;
1327: hr_utility.trace('emp_county_tax_rule_id :'||to_char(ln_countytax_rule_id));
1328: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1329:
1330: if csr_get_countytax_id%FOUND then
1331: l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID := ln_countytax_rule_id;
1332: l_pay_us_countytax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;

Line 1390: hr_utility.trace('emp_city_tax_rule_id :'||to_char(ln_citytax_rule_id));

1386: l_pay_us_citytax_rule_rec.SCHOOL_DISTRICT_CODE := lv_city_school_distcode;
1387:
1388: open csr_get_citytax_id(ln_assignment_id,lv_county_code,lv_city_code);
1389: fetch csr_get_citytax_id into ln_citytax_rule_id,ln_ovn2;
1390: hr_utility.trace('emp_city_tax_rule_id :'||to_char(ln_citytax_rule_id));
1391: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1392:
1393: if csr_get_citytax_id%FOUND then
1394: l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID := ln_citytax_rule_id;

Line 1391: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1387:
1388: open csr_get_citytax_id(ln_assignment_id,lv_county_code,lv_city_code);
1389: fetch csr_get_citytax_id into ln_citytax_rule_id,ln_ovn2;
1390: hr_utility.trace('emp_city_tax_rule_id :'||to_char(ln_citytax_rule_id));
1391: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1392:
1393: if csr_get_citytax_id%FOUND then
1394: l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID := ln_citytax_rule_id;
1395: l_pay_us_citytax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;

Line 1419: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');

1415:
1416: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
1417:
1418: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is NOT NULL then
1419: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1420: hr_utility.raise_error;
1421: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1422: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1423: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then

Line 1420: hr_utility.raise_error;

1416: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
1417:
1418: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is NOT NULL then
1419: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1420: hr_utility.raise_error;
1421: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1422: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1423: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1424: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := P_TAX_CREDIT;

Line 1482: hr_utility.trace('emp_cafed_tax_inf_id :'||to_char(ln_cafedtax_inf_id));

1478: l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION30 := p_CA_TAX_INFORMATION30;
1479:
1480: open csr_get_cafedtax_id(ln_assignment_id);
1481: fetch csr_get_cafedtax_id into ln_cafedtax_inf_id,ln_ovn2;
1482: hr_utility.trace('emp_cafed_tax_inf_id :'||to_char(ln_cafedtax_inf_id));
1483: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1484:
1485: if csr_get_cafedtax_id%FOUND then
1486: l_pay_ca_fedtax_rule_rec.EMP_FED_TAX_INF_ID := ln_cafedtax_inf_id;

Line 1483: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1479:
1480: open csr_get_cafedtax_id(ln_assignment_id);
1481: fetch csr_get_cafedtax_id into ln_cafedtax_inf_id,ln_ovn2;
1482: hr_utility.trace('emp_cafed_tax_inf_id :'||to_char(ln_cafedtax_inf_id));
1483: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1484:
1485: if csr_get_cafedtax_id%FOUND then
1486: l_pay_ca_fedtax_rule_rec.EMP_FED_TAX_INF_ID := ln_cafedtax_inf_id;
1487: l_pay_ca_fedtax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;

Line 1512: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');

1508:
1509: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
1510:
1511: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is not NULL then
1512: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1513: hr_utility.raise_error;
1514: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1515: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1516: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then

Line 1513: hr_utility.raise_error;

1509: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
1510:
1511: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is not NULL then
1512: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1513: hr_utility.raise_error;
1514: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1515: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1516: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1517: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := P_TAX_CREDIT;

Line 1549: hr_utility.trace('Assigning parameter values to province record ');

1545: l_pay_ca_provtax_rule_rec.ADDITIONAL_TAX := 0;
1546: l_pay_ca_provtax_rule_rec.PPIP_EXEMPT_FLAG := 'N';
1547: end if;
1548:
1549: hr_utility.trace('Assigning parameter values to province record ');
1550: l_pay_ca_provtax_rule_rec.LEGISLATION_CODE := 'CA';
1551: l_pay_ca_provtax_rule_rec.business_group_id := p_business_group;
1552: l_pay_ca_provtax_rule_rec.PROVINCE_CODE := ltrim(rtrim(P_STATE_PROV_CODE));
1553: l_pay_ca_provtax_rule_rec.BASIC_EXEMPTION_FLAG := P_BASIC_AMT_FLAG;

Line 1605: hr_utility.trace('emp_caprov_tax_inf_id :'||to_char(ln_caprovtax_inf_id));

1601: --l_pay_ca_provtax_rule_rec.TAX_CALC_METHOD := ?;
1602:
1603: open csr_get_caprovtax_id(ln_assignment_id);
1604: fetch csr_get_caprovtax_id into ln_caprovtax_inf_id,ln_ovn2;
1605: hr_utility.trace('emp_caprov_tax_inf_id :'||to_char(ln_caprovtax_inf_id));
1606: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1607:
1608:
1609: if csr_get_caprovtax_id%FOUND then

Line 1606: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));

1602:
1603: open csr_get_caprovtax_id(ln_assignment_id);
1604: fetch csr_get_caprovtax_id into ln_caprovtax_inf_id,ln_ovn2;
1605: hr_utility.trace('emp_caprov_tax_inf_id :'||to_char(ln_caprovtax_inf_id));
1606: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1607:
1608:
1609: if csr_get_caprovtax_id%FOUND then
1610: l_pay_ca_provtax_rule_rec.EMP_PROVINCE_TAX_INF_ID := ln_caprovtax_inf_id;

Line 1620: hr_utility.trace('province record not found ');

1616: ,p_effective_date => p_effective_date
1617: ,p_spreadsheet_identifier => p_spreadsheet_identifier
1618: );
1619: else
1620: hr_utility.trace('province record not found ');
1621: l_pay_ca_provtax_rule_rec.ASSIGNMENT_ID := ln_assignment_id;
1622:
1623: close csr_get_caprovtax_id;
1624: HR_DataPump(