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 179: hr_utility.set_location(l_package||l_procedure, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

241: hr_utility.trace('QTD value = '||l_bal_val);
242:
243: l_cnt := l_cnt + 1;
244: end loop;
245: hr_utility.set_location(l_package||l_procedure, 60);
246: hr_utility.trace('Normal completion of '||l_package||l_procedure);
247:
248: EXCEPTION
249: WHEN others THEN

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

242:
243: l_cnt := l_cnt + 1;
244: end loop;
245: hr_utility.set_location(l_package||l_procedure, 60);
246: hr_utility.trace('Normal completion of '||l_package||l_procedure);
247:
248: EXCEPTION
249: WHEN others THEN
250: hr_utility.set_location(l_package||l_procedure,70);

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

246: hr_utility.trace('Normal completion of '||l_package||l_procedure);
247:
248: EXCEPTION
249: WHEN others THEN
250: hr_utility.set_location(l_package||l_procedure,70);
251: hr_utility.trace('Abormal completion of '||l_package||l_procedure);
252: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
253: END GET_FED;
254:

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

247:
248: EXCEPTION
249: WHEN others THEN
250: hr_utility.set_location(l_package||l_procedure,70);
251: hr_utility.trace('Abormal completion of '||l_package||l_procedure);
252: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
253: END GET_FED;
254:
255:

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

447: l_cnt number := 1;
448: l_procedure varchar2(30) := 'get_state';
449:
450: BEGIN
451: hr_utility.set_location(l_package||l_procedure, 10);
452: --hr_utility.trace_on(null,'tax_bal_summary');
453: if p_ee_er = 'EE' then
454: for state_dt in c_state_dt loop
455: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop

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

448: l_procedure varchar2(30) := 'get_state';
449:
450: BEGIN
451: hr_utility.set_location(l_package||l_procedure, 10);
452: --hr_utility.trace_on(null,'tax_bal_summary');
453: if p_ee_er = 'EE' then
454: for state_dt in c_state_dt loop
455: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop
456: p_state_taxes_tab(l_cnt).prompt := state_ee.prompt;

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

465: p_assignment_id => p_assg_id,
466: p_virtual_date => NULL,
467: p_payroll_action_id => NULL);
468: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
469: hr_utility.set_location(l_package||l_procedure, 20);
470: hr_utility.trace('YTD value = '||l_bal_val);
471:
472: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
473: p_tax_balance_category => state_ee.balance_category_code,

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

466: p_virtual_date => NULL,
467: p_payroll_action_id => NULL);
468: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
469: hr_utility.set_location(l_package||l_procedure, 20);
470: hr_utility.trace('YTD value = '||l_bal_val);
471:
472: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
473: p_tax_balance_category => state_ee.balance_category_code,
474: p_tax_type => state_ee.tax_type_code,

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

480: p_assignment_id => p_assg_id,
481: p_virtual_date => NULL,
482: p_payroll_action_id => NULL);
483: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
484: hr_utility.set_location(l_package||l_procedure, 30);
485: hr_utility.trace('PTD value = '||l_bal_val);
486:
487: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
488: p_tax_balance_category => state_ee.balance_category_code,

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

481: p_virtual_date => NULL,
482: p_payroll_action_id => NULL);
483: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
484: hr_utility.set_location(l_package||l_procedure, 30);
485: hr_utility.trace('PTD value = '||l_bal_val);
486:
487: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
488: p_tax_balance_category => state_ee.balance_category_code,
489: p_tax_type => state_ee.tax_type_code,

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

495: p_assignment_id => p_assg_id,
496: p_virtual_date => NULL,
497: p_payroll_action_id => NULL);
498: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
499: hr_utility.set_location(l_package||l_procedure, 40);
500: hr_utility.trace('MTD value = '||l_bal_val);
501:
502: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
503: p_tax_balance_category => state_ee.balance_category_code,

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

496: p_virtual_date => NULL,
497: p_payroll_action_id => NULL);
498: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
499: hr_utility.set_location(l_package||l_procedure, 40);
500: hr_utility.trace('MTD value = '||l_bal_val);
501:
502: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
503: p_tax_balance_category => state_ee.balance_category_code,
504: p_tax_type => state_ee.tax_type_code,

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

510: p_assignment_id => p_assg_id,
511: p_virtual_date => NULL,
512: p_payroll_action_id => NULL);
513: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
514: hr_utility.set_location(l_package||l_procedure, 50);
515: hr_utility.trace('QTD value = '||l_bal_val);
516:
517: l_cnt := l_cnt + 1;
518: end loop;

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

511: p_virtual_date => NULL,
512: p_payroll_action_id => NULL);
513: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
514: hr_utility.set_location(l_package||l_procedure, 50);
515: hr_utility.trace('QTD value = '||l_bal_val);
516:
517: l_cnt := l_cnt + 1;
518: end loop;
519: end loop;

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

531: p_assignment_id => p_assg_id,
532: p_virtual_date => NULL,
533: p_payroll_action_id => NULL);
534: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
535: hr_utility.set_location(l_package||l_procedure, 60);
536: hr_utility.trace('YTD value = '||l_bal_val);
537:
538: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
539: p_tax_balance_category => state_er.balance_category_code,

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

532: p_virtual_date => NULL,
533: p_payroll_action_id => NULL);
534: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
535: hr_utility.set_location(l_package||l_procedure, 60);
536: hr_utility.trace('YTD value = '||l_bal_val);
537:
538: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
539: p_tax_balance_category => state_er.balance_category_code,
540: p_tax_type => state_er.tax_type_code,

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

546: p_assignment_id => p_assg_id,
547: p_virtual_date => NULL,
548: p_payroll_action_id => NULL);
549: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
550: hr_utility.set_location(l_package||l_procedure, 70);
551: hr_utility.trace('PTD value = '||l_bal_val);
552:
553: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
554: p_tax_balance_category => state_er.balance_category_code,

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

547: p_virtual_date => NULL,
548: p_payroll_action_id => NULL);
549: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
550: hr_utility.set_location(l_package||l_procedure, 70);
551: hr_utility.trace('PTD value = '||l_bal_val);
552:
553: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
554: p_tax_balance_category => state_er.balance_category_code,
555: p_tax_type => state_er.tax_type_code,

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

561: p_assignment_id => p_assg_id,
562: p_virtual_date => NULL,
563: p_payroll_action_id => NULL);
564: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
565: hr_utility.set_location(l_package||l_procedure, 80);
566: hr_utility.trace('MTD value = '||l_bal_val);
567:
568: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
569: p_tax_balance_category => state_er.balance_category_code,

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

562: p_virtual_date => NULL,
563: p_payroll_action_id => NULL);
564: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
565: hr_utility.set_location(l_package||l_procedure, 80);
566: hr_utility.trace('MTD value = '||l_bal_val);
567:
568: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
569: p_tax_balance_category => state_er.balance_category_code,
570: p_tax_type => state_er.tax_type_code,

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

576: p_assignment_id => p_assg_id,
577: p_virtual_date => NULL,
578: p_payroll_action_id => NULL);
579: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
580: hr_utility.set_location(l_package||l_procedure, 90);
581: hr_utility.trace('QTD value = '||l_bal_val);
582:
583: l_cnt := l_cnt + 1;
584: end loop;

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

577: p_virtual_date => NULL,
578: p_payroll_action_id => NULL);
579: p_state_taxes_tab(l_cnt).qtd_val := l_bal_val;
580: hr_utility.set_location(l_package||l_procedure, 90);
581: hr_utility.trace('QTD value = '||l_bal_val);
582:
583: l_cnt := l_cnt + 1;
584: end loop;
585: end if;

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

582:
583: l_cnt := l_cnt + 1;
584: end loop;
585: end if;
586: hr_utility.set_location(l_package||l_procedure, 100);
587: hr_utility.trace('Normal completion of '||l_package||l_procedure);
588: EXCEPTION
589: WHEN others THEN
590: hr_utility.set_location(l_package||l_procedure,110);

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

583: l_cnt := l_cnt + 1;
584: end loop;
585: end if;
586: hr_utility.set_location(l_package||l_procedure, 100);
587: hr_utility.trace('Normal completion of '||l_package||l_procedure);
588: EXCEPTION
589: WHEN others THEN
590: hr_utility.set_location(l_package||l_procedure,110);
591: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

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

586: hr_utility.set_location(l_package||l_procedure, 100);
587: hr_utility.trace('Normal completion of '||l_package||l_procedure);
588: EXCEPTION
589: WHEN others THEN
590: hr_utility.set_location(l_package||l_procedure,110);
591: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
592: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
593: END GET_STATE;
594:

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

587: hr_utility.trace('Normal completion of '||l_package||l_procedure);
588: EXCEPTION
589: WHEN others THEN
590: hr_utility.set_location(l_package||l_procedure,110);
591: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
592: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
593: END GET_STATE;
594:
595:

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

1145: )
1146: IS
1147: l_procedure varchar2(30) := 'get_local_balances';
1148: BEGIN
1149: hr_utility.set_location(l_package||l_procedure, 130);
1150: p_local_taxes_tab(l_cnt).prompt := p_prompt;
1151: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1152: p_tax_balance_category => p_balance_category_code,
1153: p_tax_type => p_tax_type_code,

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

1159: p_assignment_id => p_assg_id,
1160: p_virtual_date => NULL,
1161: p_payroll_action_id => NULL);
1162: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1163: hr_utility.set_location(l_package||l_procedure, 140);
1164: hr_utility.trace('YTD value = '||l_bal_val);
1165:
1166: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1167: p_tax_balance_category => p_balance_category_code,

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

1160: p_virtual_date => NULL,
1161: p_payroll_action_id => NULL);
1162: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1163: hr_utility.set_location(l_package||l_procedure, 140);
1164: hr_utility.trace('YTD value = '||l_bal_val);
1165:
1166: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1167: p_tax_balance_category => p_balance_category_code,
1168: p_tax_type => p_tax_type_code,

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

1174: p_assignment_id => p_assg_id,
1175: p_virtual_date => NULL,
1176: p_payroll_action_id => NULL);
1177: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1178: hr_utility.set_location(l_package||l_procedure, 150);
1179: hr_utility.trace('PTD value = '||l_bal_val);
1180:
1181: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1182: p_tax_balance_category => p_balance_category_code,

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

1175: p_virtual_date => NULL,
1176: p_payroll_action_id => NULL);
1177: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1178: hr_utility.set_location(l_package||l_procedure, 150);
1179: hr_utility.trace('PTD value = '||l_bal_val);
1180:
1181: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1182: p_tax_balance_category => p_balance_category_code,
1183: p_tax_type => p_tax_type_code,

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

1189: p_assignment_id => p_assg_id,
1190: p_virtual_date => NULL,
1191: p_payroll_action_id => NULL);
1192: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1193: hr_utility.set_location(l_package||l_procedure, 160);
1194: hr_utility.trace('MTD value = '||l_bal_val);
1195:
1196: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1197: p_tax_balance_category => p_balance_category_code,

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

1190: p_virtual_date => NULL,
1191: p_payroll_action_id => NULL);
1192: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1193: hr_utility.set_location(l_package||l_procedure, 160);
1194: hr_utility.trace('MTD value = '||l_bal_val);
1195:
1196: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1197: p_tax_balance_category => p_balance_category_code,
1198: p_tax_type => p_tax_type_code,

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

1204: p_assignment_id => p_assg_id,
1205: p_virtual_date => NULL,
1206: p_payroll_action_id => NULL);
1207: p_local_taxes_tab(l_cnt).qtd_val := l_bal_val;
1208: hr_utility.set_location(l_package||l_procedure, 170);
1209: hr_utility.trace('QTD value = '||l_bal_val);
1210:
1211: EXCEPTION
1212: WHEN others THEN

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

1205: p_virtual_date => NULL,
1206: p_payroll_action_id => NULL);
1207: p_local_taxes_tab(l_cnt).qtd_val := l_bal_val;
1208: hr_utility.set_location(l_package||l_procedure, 170);
1209: hr_utility.trace('QTD value = '||l_bal_val);
1210:
1211: EXCEPTION
1212: WHEN others THEN
1213: hr_utility.set_location(l_package||l_procedure,180);

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

1209: hr_utility.trace('QTD value = '||l_bal_val);
1210:
1211: EXCEPTION
1212: WHEN others THEN
1213: hr_utility.set_location(l_package||l_procedure,180);
1214: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1215: END get_local_balances;
1216:
1217: BEGIN

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

1214: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1215: END get_local_balances;
1216:
1217: BEGIN
1218: hr_utility.set_location(l_package||l_procedure, 10);
1219: --hr_utility.trace_on(null,'tax_bal_summary');
1220: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1221: FOR localrec in c_local1 LOOP
1222: get_local_balances (

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

1215: END get_local_balances;
1216:
1217: BEGIN
1218: hr_utility.set_location(l_package||l_procedure, 10);
1219: --hr_utility.trace_on(null,'tax_bal_summary');
1220: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1221: FOR localrec in c_local1 LOOP
1222: get_local_balances (
1223: p_prompt => localrec.prompt,

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

1216:
1217: BEGIN
1218: hr_utility.set_location(l_package||l_procedure, 10);
1219: --hr_utility.trace_on(null,'tax_bal_summary');
1220: hr_utility.trace('opening cursor for city tax, tax_type_code <> SCHOOL');
1221: FOR localrec in c_local1 LOOP
1222: get_local_balances (
1223: p_prompt => localrec.prompt,
1224: p_tax_type_code => localrec.tax_type_code,

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

1226: p_jurisdiction_code => localrec.jurisdiction_code);
1227: l_cnt := l_cnt + 1;
1228: END LOOP;
1229:
1230: hr_utility.set_location(l_package||l_procedure, 20);
1231: hr_utility.trace('opening cursor for county tax, tax_type_code <> SCHOOL');
1232:
1233: FOR local_dt_rec in c_local_dt2 LOOP
1234: FOR localrec in c_local2 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

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

1227: l_cnt := l_cnt + 1;
1228: END LOOP;
1229:
1230: hr_utility.set_location(l_package||l_procedure, 20);
1231: hr_utility.trace('opening cursor for county tax, tax_type_code <> SCHOOL');
1232:
1233: FOR local_dt_rec in c_local_dt2 LOOP
1234: FOR localrec in c_local2 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1235: get_local_balances (

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

1240: l_cnt := l_cnt + 1;
1241: END LOOP;
1242: END LOOP;
1243:
1244: hr_utility.set_location(l_package||l_procedure, 30);
1245: hr_utility.trace('opening cursor for school tax, tax_type_code <> SCHOOL');
1246:
1247: FOR local_dt_rec in c_local_dt3 LOOP
1248: FOR localrec in c_local3 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

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

1241: END LOOP;
1242: END LOOP;
1243:
1244: hr_utility.set_location(l_package||l_procedure, 30);
1245: hr_utility.trace('opening cursor for school tax, tax_type_code <> SCHOOL');
1246:
1247: FOR local_dt_rec in c_local_dt3 LOOP
1248: FOR localrec in c_local3 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1249: get_local_balances (

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

1254: l_cnt := l_cnt + 1;
1255: END LOOP;
1256: END LOOP;
1257:
1258: hr_utility.set_location(l_package||l_procedure, 40);
1259: hr_utility.trace('opening cursor for city EE wages, tax_type_code <> SCHOOL');
1260: FOR localrec in c_local4 LOOP
1261: get_local_balances (
1262: p_prompt => localrec.prompt,

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

1255: END LOOP;
1256: END LOOP;
1257:
1258: hr_utility.set_location(l_package||l_procedure, 40);
1259: hr_utility.trace('opening cursor for city EE wages, tax_type_code <> SCHOOL');
1260: FOR localrec in c_local4 LOOP
1261: get_local_balances (
1262: p_prompt => localrec.prompt,
1263: p_tax_type_code => localrec.tax_type_code,

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

1265: p_jurisdiction_code => localrec.jurisdiction_code);
1266: l_cnt := l_cnt + 1;
1267: END LOOP;
1268:
1269: hr_utility.set_location(l_package||l_procedure, 50);
1270: hr_utility.trace('opening cursor for county EE wages, tax_type_code <> SCHOOL');
1271: FOR localrec in c_local5 LOOP
1272: get_local_balances (
1273: p_prompt => localrec.prompt,

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

1266: l_cnt := l_cnt + 1;
1267: END LOOP;
1268:
1269: hr_utility.set_location(l_package||l_procedure, 50);
1270: hr_utility.trace('opening cursor for county EE wages, tax_type_code <> SCHOOL');
1271: FOR localrec in c_local5 LOOP
1272: get_local_balances (
1273: p_prompt => localrec.prompt,
1274: p_tax_type_code => localrec.tax_type_code,

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

1276: p_jurisdiction_code => localrec.jurisdiction_code);
1277: l_cnt := l_cnt + 1;
1278: END LOOP;
1279:
1280: hr_utility.set_location(l_package||l_procedure, 60);
1281: hr_utility.trace('opening cursor for school EE wages, tax_type_code <> SCHOOL');
1282:
1283: FOR local_dt_rec in c_local_dt6 LOOP
1284: FOR localrec in c_local6 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

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

1277: l_cnt := l_cnt + 1;
1278: END LOOP;
1279:
1280: hr_utility.set_location(l_package||l_procedure, 60);
1281: hr_utility.trace('opening cursor for school EE wages, tax_type_code <> SCHOOL');
1282:
1283: FOR local_dt_rec in c_local_dt6 LOOP
1284: FOR localrec in c_local6 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1285: get_local_balances (

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

1290: l_cnt := l_cnt + 1;
1291: END LOOP;
1292: END LOOP;
1293:
1294: hr_utility.set_location(l_package||l_procedure, 70);
1295: hr_utility.trace('opening cursor for city tax, tax_type_code = SCHOOL');
1296: FOR localrec in c_local7 LOOP
1297: get_local_balances (
1298: p_prompt => localrec.prompt,

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

1291: END LOOP;
1292: END LOOP;
1293:
1294: hr_utility.set_location(l_package||l_procedure, 70);
1295: hr_utility.trace('opening cursor for city tax, tax_type_code = SCHOOL');
1296: FOR localrec in c_local7 LOOP
1297: get_local_balances (
1298: p_prompt => localrec.prompt,
1299: p_tax_type_code => localrec.tax_type_code,

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

1301: p_jurisdiction_code => localrec.jurisdiction_code);
1302: l_cnt := l_cnt + 1;
1303: END LOOP;
1304:
1305: hr_utility.set_location(l_package||l_procedure, 80);
1306: hr_utility.trace('opening cursor for county tax, tax_type_code = SCHOOL');
1307: FOR local_dt_rec in c_local_dt8 LOOP
1308: FOR localrec in c_local8 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1309: get_local_balances (

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

1302: l_cnt := l_cnt + 1;
1303: END LOOP;
1304:
1305: hr_utility.set_location(l_package||l_procedure, 80);
1306: hr_utility.trace('opening cursor for county tax, tax_type_code = SCHOOL');
1307: FOR local_dt_rec in c_local_dt8 LOOP
1308: FOR localrec in c_local8 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1309: get_local_balances (
1310: p_prompt => localrec.prompt,

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

1314: l_cnt := l_cnt + 1;
1315: END LOOP;
1316: END LOOP;
1317:
1318: hr_utility.set_location(l_package||l_procedure, 90);
1319: hr_utility.trace('opening cursor for school tax, tax_type_code = SCHOOL');
1320: FOR localrec in c_local9 LOOP
1321: get_local_balances (
1322: p_prompt => localrec.prompt,

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

1315: END LOOP;
1316: END LOOP;
1317:
1318: hr_utility.set_location(l_package||l_procedure, 90);
1319: hr_utility.trace('opening cursor for school tax, tax_type_code = SCHOOL');
1320: FOR localrec in c_local9 LOOP
1321: get_local_balances (
1322: p_prompt => localrec.prompt,
1323: p_tax_type_code => localrec.tax_type_code,

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

1325: p_jurisdiction_code => localrec.jurisdiction_code);
1326: l_cnt := l_cnt + 1;
1327: END LOOP;
1328:
1329: hr_utility.set_location(l_package||l_procedure, 100);
1330: hr_utility.trace('opening cursor for city EE wages, tax_type_code = SCHOOL');
1331: FOR localrec in c_local10 LOOP
1332: get_local_balances (
1333: p_prompt => localrec.prompt,

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

1326: l_cnt := l_cnt + 1;
1327: END LOOP;
1328:
1329: hr_utility.set_location(l_package||l_procedure, 100);
1330: hr_utility.trace('opening cursor for city EE wages, tax_type_code = SCHOOL');
1331: FOR localrec in c_local10 LOOP
1332: get_local_balances (
1333: p_prompt => localrec.prompt,
1334: p_tax_type_code => localrec.tax_type_code,

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

1336: p_jurisdiction_code => localrec.jurisdiction_code);
1337: l_cnt := l_cnt + 1;
1338: END LOOP;
1339:
1340: hr_utility.set_location(l_package||l_procedure, 110);
1341: hr_utility.trace('opening cursor for county EE wages, tax_type_code = SCHOOL');
1342: FOR localrec in c_local11 LOOP
1343: get_local_balances (
1344: p_prompt => localrec.prompt,

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

1337: l_cnt := l_cnt + 1;
1338: END LOOP;
1339:
1340: hr_utility.set_location(l_package||l_procedure, 110);
1341: hr_utility.trace('opening cursor for county EE wages, tax_type_code = SCHOOL');
1342: FOR localrec in c_local11 LOOP
1343: get_local_balances (
1344: p_prompt => localrec.prompt,
1345: p_tax_type_code => localrec.tax_type_code,

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

1347: p_jurisdiction_code => localrec.jurisdiction_code);
1348: l_cnt := l_cnt + 1;
1349: END LOOP;
1350:
1351: hr_utility.set_location(l_package||l_procedure, 120);
1352: hr_utility.trace('opening cursor for school EE wages, tax_type_code = SCHOOL');
1353:
1354: FOR local_dt_rec in c_local_dt12 LOOP
1355: FOR localrec in c_local12 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP

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

1348: l_cnt := l_cnt + 1;
1349: END LOOP;
1350:
1351: hr_utility.set_location(l_package||l_procedure, 120);
1352: hr_utility.trace('opening cursor for school EE wages, tax_type_code = SCHOOL');
1353:
1354: FOR local_dt_rec in c_local_dt12 LOOP
1355: FOR localrec in c_local12 (local_dt_rec.effective_date, local_dt_rec.jurisdiction_code) LOOP
1356: get_local_balances (

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

1361: l_cnt := l_cnt + 1;
1362: END LOOP;
1363: END LOOP;
1364:
1365: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1366: EXCEPTION
1367: WHEN others THEN
1368: hr_utility.set_location(l_package||l_procedure,190);
1369: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);

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

1364:
1365: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1366: EXCEPTION
1367: WHEN others THEN
1368: hr_utility.set_location(l_package||l_procedure,190);
1369: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
1370: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1371: END get_local;
1372:

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

1365: hr_utility.trace('Normal completion of '||l_package||l_procedure);
1366: EXCEPTION
1367: WHEN others THEN
1368: hr_utility.set_location(l_package||l_procedure,190);
1369: hr_utility.trace('Abnormal completion of '||l_package||l_procedure);
1370: raise_application_error(-20101, 'Error in ' || l_package||l_procedure || ' - ' || sqlerrm);
1371: END get_local;
1372:
1373: END pay_us_tax_bal_summary_pkg;