eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on HR_UTILITY

Line 182: hr_utility.set_location(l_package||l_procedure, 10);

178: l_cnt number := 1;
179: l_procedure varchar2(30) := 'get_fed';
180:
181: BEGIN
182: hr_utility.set_location(l_package||l_procedure, 10);
183: --hr_utility.trace_on(null,'tax_bal_summary');
184: for fed_taxes_rec in c_fed_cur loop
185: p_fed_taxes_tab(l_cnt).prompt := fed_taxes_rec.prompt;
186: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

Line 183: --hr_utility.trace_on(null,'tax_bal_summary');

179: l_procedure varchar2(30) := 'get_fed';
180:
181: BEGIN
182: hr_utility.set_location(l_package||l_procedure, 10);
183: --hr_utility.trace_on(null,'tax_bal_summary');
184: for fed_taxes_rec in c_fed_cur loop
185: p_fed_taxes_tab(l_cnt).prompt := fed_taxes_rec.prompt;
186: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
187: p_tax_balance_category => fed_taxes_rec.balance_category_code,

Line 198: hr_utility.set_location(l_package||l_procedure, 20);

194: p_assignment_id => p_assg_id,
195: p_virtual_date => NULL,
196: p_payroll_action_id => NULL);
197: p_fed_taxes_tab(l_cnt).ytd_val := l_bal_val;
198: hr_utility.set_location(l_package||l_procedure, 20);
199: hr_utility.trace('YTD value = '||l_bal_val);
200:
201: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
202: p_tax_balance_category => fed_taxes_rec.balance_category_code,

Line 199: hr_utility.trace('YTD value = '||l_bal_val);

195: p_virtual_date => NULL,
196: p_payroll_action_id => NULL);
197: p_fed_taxes_tab(l_cnt).ytd_val := l_bal_val;
198: hr_utility.set_location(l_package||l_procedure, 20);
199: hr_utility.trace('YTD value = '||l_bal_val);
200:
201: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
202: p_tax_balance_category => fed_taxes_rec.balance_category_code,
203: p_tax_type => fed_taxes_rec.tax_type_code,

Line 213: hr_utility.set_location(l_package||l_procedure, 30);

209: p_assignment_id => p_assg_id,
210: p_virtual_date => NULL,
211: p_payroll_action_id => NULL);
212: p_fed_taxes_tab(l_cnt).ptd_val := l_bal_val;
213: hr_utility.set_location(l_package||l_procedure, 30);
214: hr_utility.trace('PTD value = '||l_bal_val);
215:
216: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
217: p_tax_balance_category => fed_taxes_rec.balance_category_code,

Line 214: hr_utility.trace('PTD value = '||l_bal_val);

210: p_virtual_date => NULL,
211: p_payroll_action_id => NULL);
212: p_fed_taxes_tab(l_cnt).ptd_val := l_bal_val;
213: hr_utility.set_location(l_package||l_procedure, 30);
214: hr_utility.trace('PTD value = '||l_bal_val);
215:
216: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
217: p_tax_balance_category => fed_taxes_rec.balance_category_code,
218: p_tax_type => fed_taxes_rec.tax_type_code,

Line 228: hr_utility.set_location(l_package||l_procedure, 40);

224: p_assignment_id => p_assg_id,
225: p_virtual_date => NULL,
226: p_payroll_action_id => NULL);
227: p_fed_taxes_tab(l_cnt).mtd_val := l_bal_val;
228: hr_utility.set_location(l_package||l_procedure, 40);
229: hr_utility.trace('MTD value = '||l_bal_val);
230:
231: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
232: p_tax_balance_category => fed_taxes_rec.balance_category_code,

Line 229: hr_utility.trace('MTD value = '||l_bal_val);

225: p_virtual_date => NULL,
226: p_payroll_action_id => NULL);
227: p_fed_taxes_tab(l_cnt).mtd_val := l_bal_val;
228: hr_utility.set_location(l_package||l_procedure, 40);
229: hr_utility.trace('MTD value = '||l_bal_val);
230:
231: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
232: p_tax_balance_category => fed_taxes_rec.balance_category_code,
233: p_tax_type => fed_taxes_rec.tax_type_code,

Line 243: hr_utility.set_location(l_package||l_procedure, 50);

239: p_assignment_id => p_assg_id,
240: p_virtual_date => NULL,
241: p_payroll_action_id => NULL);
242: p_fed_taxes_tab(l_cnt).qtd_val := l_bal_val;
243: hr_utility.set_location(l_package||l_procedure, 50);
244: hr_utility.trace('QTD value = '||l_bal_val);
245:
246: l_cnt := l_cnt + 1;
247: end loop;

Line 244: hr_utility.trace('QTD value = '||l_bal_val);

240: p_virtual_date => NULL,
241: p_payroll_action_id => NULL);
242: p_fed_taxes_tab(l_cnt).qtd_val := l_bal_val;
243: hr_utility.set_location(l_package||l_procedure, 50);
244: hr_utility.trace('QTD value = '||l_bal_val);
245:
246: l_cnt := l_cnt + 1;
247: end loop;
248: hr_utility.set_location(l_package||l_procedure, 60);

Line 248: hr_utility.set_location(l_package||l_procedure, 60);

244: hr_utility.trace('QTD value = '||l_bal_val);
245:
246: l_cnt := l_cnt + 1;
247: end loop;
248: hr_utility.set_location(l_package||l_procedure, 60);
249:
250: IF p_ee_er = 'ER' THEN
251: hr_utility.set_location(l_package||l_procedure, 65);
252: -- Need to get the futa credit balances:

Line 251: hr_utility.set_location(l_package||l_procedure, 65);

247: end loop;
248: hr_utility.set_location(l_package||l_procedure, 60);
249:
250: IF p_ee_er = 'ER' THEN
251: hr_utility.set_location(l_package||l_procedure, 65);
252: -- Need to get the futa credit balances:
253: p_fed_taxes_tab(l_cnt).prompt := 'FUTA CREDIT';
254:
255: -- Get YTD Value ;

Line 273: hr_utility.set_location(l_package||l_procedure, 70);

269: p_jurisdiction_code => NULL);
270:
271: p_fed_taxes_tab(l_cnt).ytd_val := l_bal_val;
272:
273: hr_utility.set_location(l_package||l_procedure, 70);
274: hr_utility.trace('FUTA CREDIT YTD value = '||l_bal_val);
275:
276: -- GET PTD Value::
277: l_bal_val := 0;

Line 274: hr_utility.trace('FUTA CREDIT YTD value = '||l_bal_val);

270:
271: p_fed_taxes_tab(l_cnt).ytd_val := l_bal_val;
272:
273: hr_utility.set_location(l_package||l_procedure, 70);
274: hr_utility.trace('FUTA CREDIT YTD value = '||l_bal_val);
275:
276: -- GET PTD Value::
277: l_bal_val := 0;
278:

Line 302: hr_utility.set_location(l_package||l_procedure, 80);

298: p_fed_taxes_tab(l_cnt).ptd_val := NULL;
299:
300: END IF;
301:
302: hr_utility.set_location(l_package||l_procedure, 80);
303: hr_utility.trace('FUTA CREDIT PTD value = '||l_bal_val);
304:
305:
306: -- GET Month Value:

Line 303: hr_utility.trace('FUTA CREDIT PTD value = '||l_bal_val);

299:
300: END IF;
301:
302: hr_utility.set_location(l_package||l_procedure, 80);
303: hr_utility.trace('FUTA CREDIT PTD value = '||l_bal_val);
304:
305:
306: -- GET Month Value:
307: l_bal_val := 0;

Line 323: hr_utility.set_location(l_package||l_procedure, 90);

319: p_jurisdiction_code => NULL);
320:
321: p_fed_taxes_tab(l_cnt).mtd_val := l_bal_val;
322:
323: hr_utility.set_location(l_package||l_procedure, 90);
324: hr_utility.trace('FUTA CREDIT MTD value = '||l_bal_val);
325:
326: -- GET QTD Value
327:

Line 324: hr_utility.trace('FUTA CREDIT MTD value = '||l_bal_val);

320:
321: p_fed_taxes_tab(l_cnt).mtd_val := l_bal_val;
322:
323: hr_utility.set_location(l_package||l_procedure, 90);
324: hr_utility.trace('FUTA CREDIT MTD value = '||l_bal_val);
325:
326: -- GET QTD Value
327:
328: l_bal_val := 0;

Line 344: hr_utility.set_location(l_package||l_procedure, 100);

340: p_jurisdiction_code => NULL);
341:
342: p_fed_taxes_tab(l_cnt).qtd_val := l_bal_val;
343:
344: hr_utility.set_location(l_package||l_procedure, 100);
345: hr_utility.trace('FUTA CREDIT QTD value = '||l_bal_val);
346:
347:
348: END IF;

Line 345: hr_utility.trace('FUTA CREDIT QTD value = '||l_bal_val);

341:
342: p_fed_taxes_tab(l_cnt).qtd_val := l_bal_val;
343:
344: hr_utility.set_location(l_package||l_procedure, 100);
345: hr_utility.trace('FUTA CREDIT QTD value = '||l_bal_val);
346:
347:
348: END IF;
349:

Line 353: hr_utility.set_location(l_package||l_procedure,70);

349:
350:
351: EXCEPTION
352: WHEN others THEN
353: hr_utility.set_location(l_package||l_procedure,70);
354: hr_utility.trace('Abormal completion of '||l_package||l_procedure);
355: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
356: END GET_FED;
357:

Line 354: hr_utility.trace('Abormal completion of '||l_package||l_procedure);

350:
351: EXCEPTION
352: WHEN others THEN
353: hr_utility.set_location(l_package||l_procedure,70);
354: hr_utility.trace('Abormal completion of '||l_package||l_procedure);
355: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
356: END GET_FED;
357:
358:

Line 554: hr_utility.set_location(l_package||l_procedure, 10);

550: l_cnt number := 1;
551: l_procedure varchar2(30) := 'get_state';
552:
553: BEGIN
554: hr_utility.set_location(l_package||l_procedure, 10);
555: --hr_utility.trace_on(null,'tax_bal_summary');
556: if p_ee_er = 'EE' then
557: for state_dt in c_state_dt loop
558: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop

Line 555: --hr_utility.trace_on(null,'tax_bal_summary');

551: l_procedure varchar2(30) := 'get_state';
552:
553: BEGIN
554: hr_utility.set_location(l_package||l_procedure, 10);
555: --hr_utility.trace_on(null,'tax_bal_summary');
556: if p_ee_er = 'EE' then
557: for state_dt in c_state_dt loop
558: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop
559: p_state_taxes_tab(l_cnt).prompt := state_ee.prompt;

Line 572: hr_utility.set_location(l_package||l_procedure, 20);

568: p_assignment_id => p_assg_id,
569: p_virtual_date => NULL,
570: p_payroll_action_id => NULL);
571: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
572: hr_utility.set_location(l_package||l_procedure, 20);
573: hr_utility.trace('YTD value = '||l_bal_val);
574:
575: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
576: p_tax_balance_category => state_ee.balance_category_code,

Line 573: hr_utility.trace('YTD value = '||l_bal_val);

569: p_virtual_date => NULL,
570: p_payroll_action_id => NULL);
571: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
572: hr_utility.set_location(l_package||l_procedure, 20);
573: hr_utility.trace('YTD value = '||l_bal_val);
574:
575: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
576: p_tax_balance_category => state_ee.balance_category_code,
577: p_tax_type => state_ee.tax_type_code,

Line 587: hr_utility.set_location(l_package||l_procedure, 30);

583: p_assignment_id => p_assg_id,
584: p_virtual_date => NULL,
585: p_payroll_action_id => NULL);
586: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
587: hr_utility.set_location(l_package||l_procedure, 30);
588: hr_utility.trace('PTD value = '||l_bal_val);
589:
590: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
591: p_tax_balance_category => state_ee.balance_category_code,

Line 588: hr_utility.trace('PTD value = '||l_bal_val);

584: p_virtual_date => NULL,
585: p_payroll_action_id => NULL);
586: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
587: hr_utility.set_location(l_package||l_procedure, 30);
588: hr_utility.trace('PTD value = '||l_bal_val);
589:
590: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
591: p_tax_balance_category => state_ee.balance_category_code,
592: p_tax_type => state_ee.tax_type_code,

Line 602: hr_utility.set_location(l_package||l_procedure, 40);

598: p_assignment_id => p_assg_id,
599: p_virtual_date => NULL,
600: p_payroll_action_id => NULL);
601: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
602: hr_utility.set_location(l_package||l_procedure, 40);
603: hr_utility.trace('MTD value = '||l_bal_val);
604:
605: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
606: p_tax_balance_category => state_ee.balance_category_code,

Line 603: hr_utility.trace('MTD value = '||l_bal_val);

599: p_virtual_date => NULL,
600: p_payroll_action_id => NULL);
601: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
602: hr_utility.set_location(l_package||l_procedure, 40);
603: hr_utility.trace('MTD value = '||l_bal_val);
604:
605: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
606: p_tax_balance_category => state_ee.balance_category_code,
607: p_tax_type => state_ee.tax_type_code,

Line 617: hr_utility.set_location(l_package||l_procedure, 50);

613: p_assignment_id => p_assg_id,
614: p_virtual_date => NULL,
615: p_payroll_action_id => NULL);
616: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
617: hr_utility.set_location(l_package||l_procedure, 50);
618: hr_utility.trace('QTD value = '||l_bal_val);
619:
620: l_cnt := l_cnt + 1;
621: end loop;

Line 618: hr_utility.trace('QTD value = '||l_bal_val);

614: p_virtual_date => NULL,
615: p_payroll_action_id => NULL);
616: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
617: hr_utility.set_location(l_package||l_procedure, 50);
618: hr_utility.trace('QTD value = '||l_bal_val);
619:
620: l_cnt := l_cnt + 1;
621: end loop;
622: end loop;

Line 638: hr_utility.set_location(l_package||l_procedure, 60);

634: p_assignment_id => p_assg_id,
635: p_virtual_date => NULL,
636: p_payroll_action_id => NULL);
637: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
638: hr_utility.set_location(l_package||l_procedure, 60);
639: hr_utility.trace('YTD value = '||l_bal_val);
640:
641: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
642: p_tax_balance_category => state_er.balance_category_code,

Line 639: hr_utility.trace('YTD value = '||l_bal_val);

635: p_virtual_date => NULL,
636: p_payroll_action_id => NULL);
637: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
638: hr_utility.set_location(l_package||l_procedure, 60);
639: hr_utility.trace('YTD value = '||l_bal_val);
640:
641: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
642: p_tax_balance_category => state_er.balance_category_code,
643: p_tax_type => state_er.tax_type_code,

Line 653: hr_utility.set_location(l_package||l_procedure, 70);

649: p_assignment_id => p_assg_id,
650: p_virtual_date => NULL,
651: p_payroll_action_id => NULL);
652: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
653: hr_utility.set_location(l_package||l_procedure, 70);
654: hr_utility.trace('PTD value = '||l_bal_val);
655:
656: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
657: p_tax_balance_category => state_er.balance_category_code,

Line 654: hr_utility.trace('PTD value = '||l_bal_val);

650: p_virtual_date => NULL,
651: p_payroll_action_id => NULL);
652: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
653: hr_utility.set_location(l_package||l_procedure, 70);
654: hr_utility.trace('PTD value = '||l_bal_val);
655:
656: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
657: p_tax_balance_category => state_er.balance_category_code,
658: p_tax_type => state_er.tax_type_code,

Line 668: hr_utility.set_location(l_package||l_procedure, 80);

664: p_assignment_id => p_assg_id,
665: p_virtual_date => NULL,
666: p_payroll_action_id => NULL);
667: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
668: hr_utility.set_location(l_package||l_procedure, 80);
669: hr_utility.trace('MTD value = '||l_bal_val);
670:
671: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
672: p_tax_balance_category => state_er.balance_category_code,

Line 669: hr_utility.trace('MTD value = '||l_bal_val);

665: p_virtual_date => NULL,
666: p_payroll_action_id => NULL);
667: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
668: hr_utility.set_location(l_package||l_procedure, 80);
669: hr_utility.trace('MTD value = '||l_bal_val);
670:
671: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
672: p_tax_balance_category => state_er.balance_category_code,
673: p_tax_type => state_er.tax_type_code,

Line 683: hr_utility.set_location(l_package||l_procedure, 90);

679: p_assignment_id => p_assg_id,
680: p_virtual_date => NULL,
681: p_payroll_action_id => NULL);
682: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
683: hr_utility.set_location(l_package||l_procedure, 90);
684: hr_utility.trace('QTD value = '||l_bal_val);
685:
686: l_cnt := l_cnt + 1;
687: end loop;

Line 684: hr_utility.trace('QTD value = '||l_bal_val);

680: p_virtual_date => NULL,
681: p_payroll_action_id => NULL);
682: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
683: hr_utility.set_location(l_package||l_procedure, 90);
684: hr_utility.trace('QTD value = '||l_bal_val);
685:
686: l_cnt := l_cnt + 1;
687: end loop;
688: end if;

Line 689: hr_utility.set_location(l_package||l_procedure, 100);

685:
686: l_cnt := l_cnt + 1;
687: end loop;
688: end if;
689: hr_utility.set_location(l_package||l_procedure, 100);
690: hr_utility.trace('Normal completion of '||l_package||l_procedure);
691: EXCEPTION
692: WHEN others THEN
693: hr_utility.set_location(l_package||l_procedure,110);

Line 690: hr_utility.trace('Normal completion of '||l_package||l_procedure);

686: l_cnt := l_cnt + 1;
687: end loop;
688: end if;
689: hr_utility.set_location(l_package||l_procedure, 100);
690: hr_utility.trace('Normal completion of '||l_package||l_procedure);
691: EXCEPTION
692: WHEN others THEN
693: hr_utility.set_location(l_package||l_procedure,110);
694: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

Line 693: hr_utility.set_location(l_package||l_procedure,110);

689: hr_utility.set_location(l_package||l_procedure, 100);
690: hr_utility.trace('Normal completion of '||l_package||l_procedure);
691: EXCEPTION
692: WHEN others THEN
693: hr_utility.set_location(l_package||l_procedure,110);
694: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
695: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
696: END GET_STATE;
697:

Line 694: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

690: hr_utility.trace('Normal completion of '||l_package||l_procedure);
691: EXCEPTION
692: WHEN others THEN
693: hr_utility.set_location(l_package||l_procedure,110);
694: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
695: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
696: END GET_STATE;
697:
698:

Line 1252: hr_utility.set_location(l_package||l_procedure, 130);

1248: )
1249: IS
1250: l_procedure varchar2(30) := 'get_local_balances';
1251: BEGIN
1252: hr_utility.set_location(l_package||l_procedure, 130);
1253: p_local_taxes_tab(l_cnt).prompt := p_prompt;
1254: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1255: p_tax_balance_category => p_balance_category_code,
1256: p_tax_type => p_tax_type_code,

Line 1266: hr_utility.set_location(l_package||l_procedure, 140);

1262: p_assignment_id => p_assg_id,
1263: p_virtual_date => NULL,
1264: p_payroll_action_id => NULL);
1265: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1266: hr_utility.set_location(l_package||l_procedure, 140);
1267: hr_utility.trace('YTD value = '||l_bal_val);
1268:
1269: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1270: p_tax_balance_category => p_balance_category_code,

Line 1267: hr_utility.trace('YTD value = '||l_bal_val);

1263: p_virtual_date => NULL,
1264: p_payroll_action_id => NULL);
1265: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1266: hr_utility.set_location(l_package||l_procedure, 140);
1267: hr_utility.trace('YTD value = '||l_bal_val);
1268:
1269: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1270: p_tax_balance_category => p_balance_category_code,
1271: p_tax_type => p_tax_type_code,

Line 1281: hr_utility.set_location(l_package||l_procedure, 150);

1277: p_assignment_id => p_assg_id,
1278: p_virtual_date => NULL,
1279: p_payroll_action_id => NULL);
1280: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1281: hr_utility.set_location(l_package||l_procedure, 150);
1282: hr_utility.trace('PTD value = '||l_bal_val);
1283:
1284: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1285: p_tax_balance_category => p_balance_category_code,

Line 1282: hr_utility.trace('PTD value = '||l_bal_val);

1278: p_virtual_date => NULL,
1279: p_payroll_action_id => NULL);
1280: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1281: hr_utility.set_location(l_package||l_procedure, 150);
1282: hr_utility.trace('PTD value = '||l_bal_val);
1283:
1284: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1285: p_tax_balance_category => p_balance_category_code,
1286: p_tax_type => p_tax_type_code,

Line 1296: hr_utility.set_location(l_package||l_procedure, 160);

1292: p_assignment_id => p_assg_id,
1293: p_virtual_date => NULL,
1294: p_payroll_action_id => NULL);
1295: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1296: hr_utility.set_location(l_package||l_procedure, 160);
1297: hr_utility.trace('MTD value = '||l_bal_val);
1298:
1299: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1300: p_tax_balance_category => p_balance_category_code,

Line 1297: hr_utility.trace('MTD value = '||l_bal_val);

1293: p_virtual_date => NULL,
1294: p_payroll_action_id => NULL);
1295: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1296: hr_utility.set_location(l_package||l_procedure, 160);
1297: hr_utility.trace('MTD value = '||l_bal_val);
1298:
1299: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1300: p_tax_balance_category => p_balance_category_code,
1301: p_tax_type => p_tax_type_code,

Line 1311: hr_utility.set_location(l_package||l_procedure, 170);

1307: p_assignment_id => p_assg_id,
1308: p_virtual_date => NULL,
1309: p_payroll_action_id => NULL);
1310: p_local_taxes_tab(l_cnt).qtd_val := l_bal_val;
1311: hr_utility.set_location(l_package||l_procedure, 170);
1312: hr_utility.trace('QTD value = '||l_bal_val);
1313:
1314: EXCEPTION
1315: WHEN others THEN

Line 1312: hr_utility.trace('QTD value = '||l_bal_val);

1308: p_virtual_date => NULL,
1309: p_payroll_action_id => NULL);
1310: p_local_taxes_tab(l_cnt).qtd_val := l_bal_val;
1311: hr_utility.set_location(l_package||l_procedure, 170);
1312: hr_utility.trace('QTD value = '||l_bal_val);
1313:
1314: EXCEPTION
1315: WHEN others THEN
1316: hr_utility.set_location(l_package||l_procedure,180);

Line 1316: hr_utility.set_location(l_package||l_procedure,180);

1312: hr_utility.trace('QTD value = '||l_bal_val);
1313:
1314: EXCEPTION
1315: WHEN others THEN
1316: hr_utility.set_location(l_package||l_procedure,180);
1317: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1318: END get_local_balances;
1319:
1320: BEGIN

Line 1321: hr_utility.set_location(l_package||l_procedure, 10);

1317: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1318: END get_local_balances;
1319:
1320: BEGIN
1321: hr_utility.set_location(l_package||l_procedure, 10);
1322: --hr_utility.trace_on(null,'tax_bal_summary');
1323: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1324: FOR localrec in c_local1 LOOP
1325: get_local_balances (

Line 1322: --hr_utility.trace_on(null,'tax_bal_summary');

1318: END get_local_balances;
1319:
1320: BEGIN
1321: hr_utility.set_location(l_package||l_procedure, 10);
1322: --hr_utility.trace_on(null,'tax_bal_summary');
1323: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1324: FOR localrec in c_local1 LOOP
1325: get_local_balances (
1326: p_prompt => localrec.prompt,

Line 1323: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');

1319:
1320: BEGIN
1321: hr_utility.set_location(l_package||l_procedure, 10);
1322: --hr_utility.trace_on(null,'tax_bal_summary');
1323: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1324: FOR localrec in c_local1 LOOP
1325: get_local_balances (
1326: p_prompt => localrec.prompt,
1327: p_tax_type_code => localrec.tax_type_code,

Line 1333: hr_utility.set_location(l_package||l_procedure, 20);

1329: p_jurisdiction_code => localrec.jurisdiction_code);
1330: l_cnt := l_cnt + 1;
1331: END LOOP;
1332:
1333: hr_utility.set_location(l_package||l_procedure, 20);
1334: hr_utility.trace('opening cursor for county tax, tax_type_code <> SCHOOL');
1335:
1336: FOR local_dt_rec in c_local_dt2 LOOP
1337: FOR localrec in c_local2 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

Line 1334: hr_utility.trace('opening cursor for county tax, tax_type_code <> SCHOOL');

1330: l_cnt := l_cnt + 1;
1331: END LOOP;
1332:
1333: hr_utility.set_location(l_package||l_procedure, 20);
1334: hr_utility.trace('opening cursor for county tax, tax_type_code <> SCHOOL');
1335:
1336: FOR local_dt_rec in c_local_dt2 LOOP
1337: FOR localrec in c_local2 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1338: get_local_balances (

Line 1347: hr_utility.set_location(l_package||l_procedure, 30);

1343: l_cnt := l_cnt + 1;
1344: END LOOP;
1345: END LOOP;
1346:
1347: hr_utility.set_location(l_package||l_procedure, 30);
1348: hr_utility.trace('opening cursor for school tax, tax_type_code <> SCHOOL');
1349:
1350: FOR local_dt_rec in c_local_dt3 LOOP
1351: FOR localrec in c_local3 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

Line 1348: hr_utility.trace('opening cursor for school tax, tax_type_code <> SCHOOL');

1344: END LOOP;
1345: END LOOP;
1346:
1347: hr_utility.set_location(l_package||l_procedure, 30);
1348: hr_utility.trace('opening cursor for school tax, tax_type_code <> SCHOOL');
1349:
1350: FOR local_dt_rec in c_local_dt3 LOOP
1351: FOR localrec in c_local3 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1352: get_local_balances (

Line 1361: hr_utility.set_location(l_package||l_procedure, 40);

1357: l_cnt := l_cnt + 1;
1358: END LOOP;
1359: END LOOP;
1360:
1361: hr_utility.set_location(l_package||l_procedure, 40);
1362: hr_utility.trace('opening cursor for city EE wages, tax_type_code <> SCHOOL');
1363: FOR localrec in c_local4 LOOP
1364: get_local_balances (
1365: p_prompt => localrec.prompt,

Line 1362: hr_utility.trace('opening cursor for city EE wages, tax_type_code <> SCHOOL');

1358: END LOOP;
1359: END LOOP;
1360:
1361: hr_utility.set_location(l_package||l_procedure, 40);
1362: hr_utility.trace('opening cursor for city EE wages, tax_type_code <> SCHOOL');
1363: FOR localrec in c_local4 LOOP
1364: get_local_balances (
1365: p_prompt => localrec.prompt,
1366: p_tax_type_code => localrec.tax_type_code,

Line 1372: hr_utility.set_location(l_package||l_procedure, 50);

1368: p_jurisdiction_code => localrec.jurisdiction_code);
1369: l_cnt := l_cnt + 1;
1370: END LOOP;
1371:
1372: hr_utility.set_location(l_package||l_procedure, 50);
1373: hr_utility.trace('opening cursor for county EE wages, tax_type_code <> SCHOOL');
1374: FOR localrec in c_local5 LOOP
1375: get_local_balances (
1376: p_prompt => localrec.prompt,

Line 1373: hr_utility.trace('opening cursor for county EE wages, tax_type_code <> SCHOOL');

1369: l_cnt := l_cnt + 1;
1370: END LOOP;
1371:
1372: hr_utility.set_location(l_package||l_procedure, 50);
1373: hr_utility.trace('opening cursor for county EE wages, tax_type_code <> SCHOOL');
1374: FOR localrec in c_local5 LOOP
1375: get_local_balances (
1376: p_prompt => localrec.prompt,
1377: p_tax_type_code => localrec.tax_type_code,

Line 1383: hr_utility.set_location(l_package||l_procedure, 60);

1379: p_jurisdiction_code => localrec.jurisdiction_code);
1380: l_cnt := l_cnt + 1;
1381: END LOOP;
1382:
1383: hr_utility.set_location(l_package||l_procedure, 60);
1384: hr_utility.trace('opening cursor for school EE wages, tax_type_code <> SCHOOL');
1385:
1386: FOR local_dt_rec in c_local_dt6 LOOP
1387: FOR localrec in c_local6 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

Line 1384: hr_utility.trace('opening cursor for school EE wages, tax_type_code <> SCHOOL');

1380: l_cnt := l_cnt + 1;
1381: END LOOP;
1382:
1383: hr_utility.set_location(l_package||l_procedure, 60);
1384: hr_utility.trace('opening cursor for school EE wages, tax_type_code <> SCHOOL');
1385:
1386: FOR local_dt_rec in c_local_dt6 LOOP
1387: FOR localrec in c_local6 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1388: get_local_balances (

Line 1397: hr_utility.set_location(l_package||l_procedure, 70);

1393: l_cnt := l_cnt + 1;
1394: END LOOP;
1395: END LOOP;
1396:
1397: hr_utility.set_location(l_package||l_procedure, 70);
1398: hr_utility.trace('opening cursor for city tax, tax_type_code = SCHOOL');
1399: FOR localrec in c_local7 LOOP
1400: get_local_balances (
1401: p_prompt => localrec.prompt,

Line 1398: hr_utility.trace('opening cursor for city tax, tax_type_code = SCHOOL');

1394: END LOOP;
1395: END LOOP;
1396:
1397: hr_utility.set_location(l_package||l_procedure, 70);
1398: hr_utility.trace('opening cursor for city tax, tax_type_code = SCHOOL');
1399: FOR localrec in c_local7 LOOP
1400: get_local_balances (
1401: p_prompt => localrec.prompt,
1402: p_tax_type_code => localrec.tax_type_code,

Line 1408: hr_utility.set_location(l_package||l_procedure, 80);

1404: p_jurisdiction_code => localrec.jurisdiction_code);
1405: l_cnt := l_cnt + 1;
1406: END LOOP;
1407:
1408: hr_utility.set_location(l_package||l_procedure, 80);
1409: hr_utility.trace('opening cursor for county tax, tax_type_code = SCHOOL');
1410: FOR local_dt_rec in c_local_dt8 LOOP
1411: FOR localrec in c_local8 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1412: get_local_balances (

Line 1409: hr_utility.trace('opening cursor for county tax, tax_type_code = SCHOOL');

1405: l_cnt := l_cnt + 1;
1406: END LOOP;
1407:
1408: hr_utility.set_location(l_package||l_procedure, 80);
1409: hr_utility.trace('opening cursor for county tax, tax_type_code = SCHOOL');
1410: FOR local_dt_rec in c_local_dt8 LOOP
1411: FOR localrec in c_local8 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1412: get_local_balances (
1413: p_prompt => localrec.prompt,

Line 1421: hr_utility.set_location(l_package||l_procedure, 90);

1417: l_cnt := l_cnt + 1;
1418: END LOOP;
1419: END LOOP;
1420:
1421: hr_utility.set_location(l_package||l_procedure, 90);
1422: hr_utility.trace('opening cursor for school tax, tax_type_code = SCHOOL');
1423: FOR localrec in c_local9 LOOP
1424: get_local_balances (
1425: p_prompt => localrec.prompt,

Line 1422: hr_utility.trace('opening cursor for school tax, tax_type_code = SCHOOL');

1418: END LOOP;
1419: END LOOP;
1420:
1421: hr_utility.set_location(l_package||l_procedure, 90);
1422: hr_utility.trace('opening cursor for school tax, tax_type_code = SCHOOL');
1423: FOR localrec in c_local9 LOOP
1424: get_local_balances (
1425: p_prompt => localrec.prompt,
1426: p_tax_type_code => localrec.tax_type_code,

Line 1432: hr_utility.set_location(l_package||l_procedure, 100);

1428: p_jurisdiction_code => localrec.jurisdiction_code);
1429: l_cnt := l_cnt + 1;
1430: END LOOP;
1431:
1432: hr_utility.set_location(l_package||l_procedure, 100);
1433: hr_utility.trace('opening cursor for city EE wages, tax_type_code = SCHOOL');
1434: FOR localrec in c_local10 LOOP
1435: get_local_balances (
1436: p_prompt => localrec.prompt,

Line 1433: hr_utility.trace('opening cursor for city EE wages, tax_type_code = SCHOOL');

1429: l_cnt := l_cnt + 1;
1430: END LOOP;
1431:
1432: hr_utility.set_location(l_package||l_procedure, 100);
1433: hr_utility.trace('opening cursor for city EE wages, tax_type_code = SCHOOL');
1434: FOR localrec in c_local10 LOOP
1435: get_local_balances (
1436: p_prompt => localrec.prompt,
1437: p_tax_type_code => localrec.tax_type_code,

Line 1443: hr_utility.set_location(l_package||l_procedure, 110);

1439: p_jurisdiction_code => localrec.jurisdiction_code);
1440: l_cnt := l_cnt + 1;
1441: END LOOP;
1442:
1443: hr_utility.set_location(l_package||l_procedure, 110);
1444: hr_utility.trace('opening cursor for county EE wages, tax_type_code = SCHOOL');
1445: FOR localrec in c_local11 LOOP
1446: get_local_balances (
1447: p_prompt => localrec.prompt,

Line 1444: hr_utility.trace('opening cursor for county EE wages, tax_type_code = SCHOOL');

1440: l_cnt := l_cnt + 1;
1441: END LOOP;
1442:
1443: hr_utility.set_location(l_package||l_procedure, 110);
1444: hr_utility.trace('opening cursor for county EE wages, tax_type_code = SCHOOL');
1445: FOR localrec in c_local11 LOOP
1446: get_local_balances (
1447: p_prompt => localrec.prompt,
1448: p_tax_type_code => localrec.tax_type_code,

Line 1454: hr_utility.set_location(l_package||l_procedure, 120);

1450: p_jurisdiction_code => localrec.jurisdiction_code);
1451: l_cnt := l_cnt + 1;
1452: END LOOP;
1453:
1454: hr_utility.set_location(l_package||l_procedure, 120);
1455: hr_utility.trace('opening cursor for school EE wages, tax_type_code = SCHOOL');
1456:
1457: FOR local_dt_rec in c_local_dt12 LOOP
1458: FOR localrec in c_local12 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

Line 1455: hr_utility.trace('opening cursor for school EE wages, tax_type_code = SCHOOL');

1451: l_cnt := l_cnt + 1;
1452: END LOOP;
1453:
1454: hr_utility.set_location(l_package||l_procedure, 120);
1455: hr_utility.trace('opening cursor for school EE wages, tax_type_code = SCHOOL');
1456:
1457: FOR local_dt_rec in c_local_dt12 LOOP
1458: FOR localrec in c_local12 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1459: get_local_balances (

Line 1468: hr_utility.trace('Normal completion of '||l_package||l_procedure);

1464: l_cnt := l_cnt + 1;
1465: END LOOP;
1466: END LOOP;
1467:
1468: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1469: EXCEPTION
1470: WHEN others THEN
1471: hr_utility.set_location(l_package||l_procedure,190);
1472: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

Line 1471: hr_utility.set_location(l_package||l_procedure,190);

1467:
1468: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1469: EXCEPTION
1470: WHEN others THEN
1471: hr_utility.set_location(l_package||l_procedure,190);
1472: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
1473: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1474: END get_local;
1475:

Line 1472: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

1468: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1469: EXCEPTION
1470: WHEN others THEN
1471: hr_utility.set_location(l_package||l_procedure,190);
1472: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
1473: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1474: END get_local;
1475:
1476: END pay_us_tax_bal_summary_pkg;