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

Line 49: 457 in hr_utility.

45: load_federal_taxes. Also changed
46: some cursors for performance.
47: 05-FEB-2002 meshah 115.6 Added checkfile entry to the file.
48: 05-MAR-2002 meshah 115.7 removed to_char from 401, 403 and
49: 457 in hr_utility.
50: 06-MAR-2002 meshah 115.8 cursor c_federal_taxes was refered
51: at a wrong place in load_federal_balance.
52: this was causing report to error out
53: with invalid cursor error.

Line 253: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

249: ,p_virtual_date => p_effective_date
250: );
251:
252: elsif p_tax_type in ('FUTA', 'SS ER', 'SS EE') and p_tax_group = 'xXx'then
253: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
254:
255: ln_balance_value := pay_balance_pkg.get_value(
256: p_defined_balance_id => ln_defined_bal_id
257: ,p_assignment_action_id => p_assignment_action_id

Line 266: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

262: ,p_date_earned =>null
263: );
264:
265: elsif p_tax_type in ('401K') then
266: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
267: ln_balance_value := pay_balance_pkg.get_value(
268: p_defined_balance_id => ln_defined_bal_id
269: ,p_assignment_action_id => p_assignment_action_id
270: ,p_tax_unit_id => p_tax_unit_id

Line 282: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));

278: open c_def_bal_id(l_catchup_bal_name);
279: fetch c_def_bal_id into ln_catchup_defined_bal_id;
280: close c_def_bal_id;
281:
282: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
283:
284: ln_catchup_balance_value := pay_balance_pkg.get_value(
285: p_defined_balance_id => ln_catchup_defined_bal_id
286: ,p_assignment_action_id => p_assignment_action_id

Line 300: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

296:
297: ---- Added for bug 4521358
298:
299: elsif p_tax_type in ('401K ROTH') then
300: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
301: ln_balance_value := pay_balance_pkg.get_value(
302: p_defined_balance_id => ln_defined_bal_id
303: ,p_assignment_action_id => p_assignment_action_id
304: ,p_tax_unit_id => p_tax_unit_id

Line 313: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

309: );
310: ------
311:
312: elsif p_tax_type in ('403B') then
313: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
314: ln_balance_value := pay_balance_pkg.get_value(
315: p_defined_balance_id => ln_defined_bal_id
316: ,p_assignment_action_id => p_assignment_action_id
317: ,p_tax_unit_id => p_tax_unit_id

Line 329: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));

325: open c_def_bal_id(l_catchup_bal_name);
326: fetch c_def_bal_id into ln_catchup_defined_bal_id;
327: close c_def_bal_id;
328:
329: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
330:
331: ln_catchup_balance_value := pay_balance_pkg.get_value(
332: p_defined_balance_id => ln_catchup_defined_bal_id
333: ,p_assignment_action_id => p_assignment_action_id

Line 347: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

343:
344: ---- Added for bug 4521358
345:
346: elsif p_tax_type in ('403B ROTH') then
347: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
348: ln_balance_value := pay_balance_pkg.get_value(
349: p_defined_balance_id => ln_defined_bal_id
350: ,p_assignment_action_id => p_assignment_action_id
351: ,p_tax_unit_id => p_tax_unit_id

Line 361: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

357:
358: -----------
359:
360: elsif p_tax_type in ('457') then
361: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
362: ln_balance_value := pay_balance_pkg.get_value(
363: p_defined_balance_id => ln_defined_bal_id
364: ,p_assignment_action_id => p_assignment_action_id
365: ,p_tax_unit_id => p_tax_unit_id

Line 377: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));

373: open c_def_bal_id(l_catchup_bal_name);
374: fetch c_def_bal_id into ln_catchup_defined_bal_id;
375: close c_def_bal_id;
376:
377: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
378:
379: ln_catchup_balance_value := pay_balance_pkg.get_value(
380: p_defined_balance_id => ln_catchup_defined_bal_id
381: ,p_assignment_action_id => p_assignment_action_id

Line 393: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

389: ln_balance_value := nvl(ln_balance_value,0) -
390: nvl(ln_catchup_balance_value,0);
391:
392: elsif p_tax_type in ('SDI ER', 'SDI EE', 'SUI ER', 'SUI EE') then
393: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
394: ln_balance_value := pay_balance_pkg.get_value(
395: p_defined_balance_id => ln_defined_bal_id
396: ,p_assignment_action_id => p_assignment_action_id
397: ,p_tax_unit_id => p_tax_unit_id

Line 406: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));

402: );
403:
404: elsif p_tax_type in ( '401K CATCHUP', '403B CATCHUP', '457 CATCHUP','DCP') then -- #2664340
405:
406: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
407:
408: ln_balance_value := pay_balance_pkg.get_value(
409: p_defined_balance_id => ln_defined_bal_id
410: ,p_assignment_action_id => p_assignment_action_id

Line 456: hr_utility.trace('In get_roth_balance_id, p_tax_type: '|| p_tax_type);

452: and fdi.user_name = cp_balance_name;
453:
454: BEGIN
455:
456: hr_utility.trace('In get_roth_balance_id, p_tax_type: '|| p_tax_type);
457:
458: if p_tax_type = '401K' then
459: open c_def_bal_id (roth_401k_balance_name);
460: fetch c_def_bal_id into ln_balance_id;

Line 463: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);

459: open c_def_bal_id (roth_401k_balance_name);
460: fetch c_def_bal_id into ln_balance_id;
461: close c_def_bal_id;
462:
463: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);
464:
465: elsif p_tax_type = '403B' then
466: open c_def_bal_id (roth_403b_balance_name);
467: fetch c_def_bal_id into ln_balance_id;

Line 470: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);

466: open c_def_bal_id (roth_403b_balance_name);
467: fetch c_def_bal_id into ln_balance_id;
468: close c_def_bal_id;
469:
470: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);
471:
472: elsif p_tax_type = '401K ROTH' then
473: open c_def_bal_id (def_401k_balance_name);
474: fetch c_def_bal_id into ln_balance_id;

Line 477: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);

473: open c_def_bal_id (def_401k_balance_name);
474: fetch c_def_bal_id into ln_balance_id;
475: close c_def_bal_id;
476:
477: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);
478:
479: elsif p_tax_type = '403B ROTH' then
480: open c_def_bal_id (def_403b_balance_name);
481: fetch c_def_bal_id into ln_balance_id;

Line 484: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);

480: open c_def_bal_id (def_403b_balance_name);
481: fetch c_def_bal_id into ln_balance_id;
482: close c_def_bal_id;
483:
484: hr_utility.trace('Balance name: '||roth_401k_balance_name||', balance id: '||ln_balance_id);
485:
486: end if;
487:
488: return (ln_balance_id) ;

Line 515: hr_utility.set_location('IN populate_fed_balance_list ',350);

511: l_count number := 1;
512:
513: begin
514:
515: hr_utility.set_location('IN populate_fed_balance_list ',350);
516:
517: if p_tax_type is null then
518: if p_tax_group = 'xXx' then
519: t_fed_balance_list(1).balance_name := 'FUTA_TAXABLE_PER_GRE_YTD';

Line 639: hr_utility.trace('Inserting fed_balance_list table with balance name ' || t_fed_balance_list(i).balance_name );

635: for i in 1 .. l_count loop
636: open c_def_bal_id (t_fed_balance_list(i).balance_name);
637: fetch c_def_bal_id into t_fed_balance_list(i).balance_id;
638: close c_def_bal_id;
639: hr_utility.trace('Inserting fed_balance_list table with balance name ' || t_fed_balance_list(i).balance_name );
640: hr_utility.trace('Inserting fed_balance_list table with balance id ' || t_fed_balance_list(i).balance_id );
641: end loop;
642: hr_utility.set_location('OUT populate_fed_balance_list ',360);
643: end populate_fed_balance_list;

Line 640: hr_utility.trace('Inserting fed_balance_list table with balance id ' || t_fed_balance_list(i).balance_id );

636: open c_def_bal_id (t_fed_balance_list(i).balance_name);
637: fetch c_def_bal_id into t_fed_balance_list(i).balance_id;
638: close c_def_bal_id;
639: hr_utility.trace('Inserting fed_balance_list table with balance name ' || t_fed_balance_list(i).balance_name );
640: hr_utility.trace('Inserting fed_balance_list table with balance id ' || t_fed_balance_list(i).balance_id );
641: end loop;
642: hr_utility.set_location('OUT populate_fed_balance_list ',360);
643: end populate_fed_balance_list;
644:

Line 642: hr_utility.set_location('OUT populate_fed_balance_list ',360);

638: close c_def_bal_id;
639: hr_utility.trace('Inserting fed_balance_list table with balance name ' || t_fed_balance_list(i).balance_name );
640: hr_utility.trace('Inserting fed_balance_list table with balance id ' || t_fed_balance_list(i).balance_id );
641: end loop;
642: hr_utility.set_location('OUT populate_fed_balance_list ',360);
643: end populate_fed_balance_list;
644:
645: -- end of procedure populate_fed_balance_list
646:

Line 666: hr_utility.set_location('IN populate_state_balance_list ',370);

662: l_count number := 1;
663:
664: begin
665:
666: hr_utility.set_location('IN populate_state_balance_list ',370);
667: if p_tax_type is null then
668: t_state_balance_list(1).balance_name := 'SDI_ER_TAXABLE_PER_JD_GRE_YTD';
669: t_state_balance_list(1).tax_type := 'SDI ER';
670: t_state_balance_list(2).balance_name := 'SDI_EE_TAXABLE_PER_JD_GRE_YTD';

Line 697: hr_utility.trace('Inserting state_balance_list table with balance name ' || t_state_balance_list(i).balance_name );

693: for i in 1 .. l_count loop
694: open c_def_bal_id (t_state_balance_list(i).balance_name);
695: fetch c_def_bal_id into t_state_balance_list(i).balance_id;
696: close c_def_bal_id;
697: hr_utility.trace('Inserting state_balance_list table with balance name ' || t_state_balance_list(i).balance_name );
698: hr_utility.trace('Inserting state_balance_list table with balance id ' || t_state_balance_list(i).balance_id );
699: end loop;
700: hr_utility.set_location('OUT populate_state_balance_list ',380);
701: end populate_state_balance_list;

Line 698: hr_utility.trace('Inserting state_balance_list table with balance id ' || t_state_balance_list(i).balance_id );

694: open c_def_bal_id (t_state_balance_list(i).balance_name);
695: fetch c_def_bal_id into t_state_balance_list(i).balance_id;
696: close c_def_bal_id;
697: hr_utility.trace('Inserting state_balance_list table with balance name ' || t_state_balance_list(i).balance_name );
698: hr_utility.trace('Inserting state_balance_list table with balance id ' || t_state_balance_list(i).balance_id );
699: end loop;
700: hr_utility.set_location('OUT populate_state_balance_list ',380);
701: end populate_state_balance_list;
702:

Line 700: hr_utility.set_location('OUT populate_state_balance_list ',380);

696: close c_def_bal_id;
697: hr_utility.trace('Inserting state_balance_list table with balance name ' || t_state_balance_list(i).balance_name );
698: hr_utility.trace('Inserting state_balance_list table with balance id ' || t_state_balance_list(i).balance_id );
699: end loop;
700: hr_utility.set_location('OUT populate_state_balance_list ',380);
701: end populate_state_balance_list;
702:
703: -- End of the procedure populate_state_balance_list
704:

Line 730: hr_utility.trace('Returning tax limit ' || p_tax_type || ' for the state code ' || to_char (p_state_code) ||' with

726:
727: if ln_state_tax_limit is null then
728: ln_state_tax_limit := 0;
729: end if;
730: hr_utility.trace('Returning tax limit ' || p_tax_type || ' for the state code ' || to_char (p_state_code) ||' with
731: the value as ' ||to_char(ln_state_tax_limit));
732: return (ln_state_tax_limit);
733: EXCEPTION
734: when others then

Line 791: hr_utility.set_location('IN load_state_taxes ',300);

787:
788: --
789: --
790: begin
791: hr_utility.set_location('IN load_state_taxes ',300);
792:
793: /* do not execute this procedure if the tax type is for federal */
794:
795: if (( p_tax_type is null ) or

Line 806: hr_utility.trace('Number of STATE TAXES Records fetched = '||to_char(c_state_taxes%ROWCOUNT));

802: l_state_abbrev,
803: l_state_code,
804: l_jurisdiction_code;
805:
806: hr_utility.trace('Number of STATE TAXES Records fetched = '||to_char(c_state_taxes%ROWCOUNT));
807: exit when c_state_taxes%notfound;
808:
809: l_count := t_state_balance_list.count;
810:

Line 822: hr_utility.trace('STATE = '|| l_state_abbrev);

818: if l_state_tax_type in('SDI EE','SDI ER') then
819: l_state_tax_type := 'xx';
820: end if;
821: end if;
822: hr_utility.trace('STATE = '|| l_state_abbrev);
823: hr_utility.trace('Tax Type : ' || l_state_tax_type);
824: hr_utility.trace('Balance Id : ' || l_bal_id);
825:
826: l_state_taxable_value := get_taxable_balance(

Line 823: hr_utility.trace('Tax Type : ' || l_state_tax_type);

819: l_state_tax_type := 'xx';
820: end if;
821: end if;
822: hr_utility.trace('STATE = '|| l_state_abbrev);
823: hr_utility.trace('Tax Type : ' || l_state_tax_type);
824: hr_utility.trace('Balance Id : ' || l_bal_id);
825:
826: l_state_taxable_value := get_taxable_balance(
827: p_asg_id,

Line 824: hr_utility.trace('Balance Id : ' || l_bal_id);

820: end if;
821: end if;
822: hr_utility.trace('STATE = '|| l_state_abbrev);
823: hr_utility.trace('Tax Type : ' || l_state_tax_type);
824: hr_utility.trace('Balance Id : ' || l_bal_id);
825:
826: l_state_taxable_value := get_taxable_balance(
827: p_asg_id,
828: p_as_of_date,

Line 839: hr_utility.trace('State Taxable Value is : '|| to_char(l_state_taxable_value));

835: l_state_tax_limit := get_state_limit( l_state_code,
836: l_state_tax_type);
837:
838: -- calculate the over limit amount
839: hr_utility.trace('State Taxable Value is : '|| to_char(l_state_taxable_value));
840: hr_utility.trace('State Tax Limit is : ' ||to_char(l_state_tax_limit));
841:
842: l_over_limit := nvl(l_state_taxable_value,0) - nvl(l_state_tax_limit,0);
843:

Line 840: hr_utility.trace('State Tax Limit is : ' ||to_char(l_state_tax_limit));

836: l_state_tax_type);
837:
838: -- calculate the over limit amount
839: hr_utility.trace('State Taxable Value is : '|| to_char(l_state_taxable_value));
840: hr_utility.trace('State Tax Limit is : ' ||to_char(l_state_tax_limit));
841:
842: l_over_limit := nvl(l_state_taxable_value,0) - nvl(l_state_tax_limit,0);
843:
844: -- need to insert those rows that have over limit > 0

Line 860: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));

856: into new_asg_act_id
857: from dual;
858:
859: -- insert the action record.
860: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
861: hr_utility.trace('Assignment id: '||to_char(p_asg_id));
862:
863: hr_nonrun_asact.insact(new_asg_act_id,p_asg_id,t_payroll_action_id,p_chnkno,p_tax_unit_id);
864: g_inserted_asg_action_id_flag := 'Y';

Line 861: hr_utility.trace('Assignment id: '||to_char(p_asg_id));

857: from dual;
858:
859: -- insert the action record.
860: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
861: hr_utility.trace('Assignment id: '||to_char(p_asg_id));
862:
863: hr_nonrun_asact.insact(new_asg_act_id,p_asg_id,t_payroll_action_id,p_chnkno,p_tax_unit_id);
864: g_inserted_asg_action_id_flag := 'Y';
865: else

Line 868: hr_utility.trace('Inserted Assignment action id: '||to_char(new_asg_act_id));

864: g_inserted_asg_action_id_flag := 'Y';
865: else
866: g_inserted_asg_action_id_flag := 'N';
867: new_asg_act_id := g_inserted_asg_action_id;
868: hr_utility.trace('Inserted Assignment action id: '||to_char(new_asg_act_id));
869: end if;
870: select paf.assignment_number
871: ,paf.person_id
872: ,ppf.first_name

Line 932: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' ||

928: ,l_last_name
929: ,l_ssn
930: );
931:
932: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' ||
933: l_first_name );
934: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_state_tax_type );
935:
936: end if;

Line 934: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_state_tax_type );

930: );
931:
932: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' ||
933: l_first_name );
934: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_state_tax_type );
935:
936: end if;
937: end loop;
938:

Line 944: hr_utility.set_location('OUT load_state_taxes ',350);

940: close c_state_taxes;
941:
942: end if;
943:
944: hr_utility.set_location('OUT load_state_taxes ',350);
945:
946: exception
947: when others then
948: hr_utility.trace('Error occurred load_state_taxes ...' ||SQLERRM);

Line 948: hr_utility.trace('Error occurred load_state_taxes ...' ||SQLERRM);

944: hr_utility.set_location('OUT load_state_taxes ',350);
945:
946: exception
947: when others then
948: hr_utility.trace('Error occurred load_state_taxes ...' ||SQLERRM);
949: raise;
950: end load_state_taxes;
951: -- -----------------------------------------------------------------------+
952: -- START FEDERAL TAXES +

Line 1096: hr_utility.set_location('IN load_federal_taxes ',400);

1092: l_bal_id number;
1093: --
1094: --
1095: begin
1096: hr_utility.set_location('IN load_federal_taxes ',400);
1097:
1098: /* do not execute this procedure if the tax type is for state */
1099:
1100: if (( p_tax_type is null ) or

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

1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);

Line 1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));

1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);

Line 1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));

1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);
1127: hr_utility.trace('Tax Type : ' || p_tax_type);

Line 1124: hr_utility.trace('401K : ' || l_fed_401k_limit);

1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);
1127: hr_utility.trace('Tax Type : ' || p_tax_type);
1128: --

Line 1125: hr_utility.trace('403B : ' || l_fed_403B_limit);

1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);
1127: hr_utility.trace('Tax Type : ' || p_tax_type);
1128: --
1129:

Line 1126: hr_utility.trace('457 : ' || l_fed_457_limit);

1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);
1127: hr_utility.trace('Tax Type : ' || p_tax_type);
1128: --
1129:
1130: l_count := t_fed_balance_list.count;

Line 1127: hr_utility.trace('Tax Type : ' || p_tax_type);

1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));
1124: hr_utility.trace('401K : ' || l_fed_401k_limit);
1125: hr_utility.trace('403B : ' || l_fed_403B_limit);
1126: hr_utility.trace('457 : ' || l_fed_457_limit);
1127: hr_utility.trace('Tax Type : ' || p_tax_type);
1128: --
1129:
1130: l_count := t_fed_balance_list.count;
1131:

Line 1134: hr_utility.trace('Tax Type : ' || l_fed_tax_type);

1130: l_count := t_fed_balance_list.count;
1131:
1132: for i in 1 .. l_count loop
1133: l_fed_tax_type := t_fed_balance_list(i).tax_type;
1134: hr_utility.trace('Tax Type : ' || l_fed_tax_type);
1135: l_bal_id := t_fed_balance_list(i).balance_id;
1136:
1137: l_fed_taxable_value := get_taxable_balance(
1138: p_asg_id,

Line 1308: hr_utility.trace('Federal Taxable Value is : '|| to_char(l_fed_taxable_value));

1304: l_fed_tax_limit := NVL(l_dcp_limit,0);
1305: l_over_limit := nvl(l_fed_taxable_value,0) - l_fed_tax_limit;
1306: end if;
1307:
1308: hr_utility.trace('Federal Taxable Value is : '|| to_char(l_fed_taxable_value));
1309: hr_utility.trace('Federal Tax Limit is : ' ||to_char(l_fed_tax_limit));
1310:
1311: -- need to insert those rows that have over limit > 0
1312: if nvl(l_over_limit,0) > 0 then

Line 1309: hr_utility.trace('Federal Tax Limit is : ' ||to_char(l_fed_tax_limit));

1305: l_over_limit := nvl(l_fed_taxable_value,0) - l_fed_tax_limit;
1306: end if;
1307:
1308: hr_utility.trace('Federal Taxable Value is : '|| to_char(l_fed_taxable_value));
1309: hr_utility.trace('Federal Tax Limit is : ' ||to_char(l_fed_tax_limit));
1310:
1311: -- need to insert those rows that have over limit > 0
1312: if nvl(l_over_limit,0) > 0 then
1313: if (l_prev_asg_act_id = p_asg_action_id) then

Line 1326: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));

1322: into new_asg_act_id
1323: from dual;
1324:
1325: -- insert the action record.
1326: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
1327: hr_utility.trace('Assignment id: '||to_char(p_asg_id));
1328:
1329: hr_nonrun_asact.insact(new_asg_act_id,p_asg_id,t_payroll_action_id,p_chnkno,p_tax_unit_id);
1330: g_inserted_asg_action_id := new_asg_act_id;

Line 1327: hr_utility.trace('Assignment id: '||to_char(p_asg_id));

1323: from dual;
1324:
1325: -- insert the action record.
1326: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
1327: hr_utility.trace('Assignment id: '||to_char(p_asg_id));
1328:
1329: hr_nonrun_asact.insact(new_asg_act_id,p_asg_id,t_payroll_action_id,p_chnkno,p_tax_unit_id);
1330: g_inserted_asg_action_id := new_asg_act_id;
1331: g_inserted_asg_action_id_flag := 'Y';

Line 1392: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' || l_first_name

1388: ,l_middle_name
1389: ,l_last_name
1390: ,l_ssn
1391: );
1392: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' || l_first_name
1393: );
1394: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_fed_tax_type );
1395: end if; -- over limit > 0
1396:

Line 1394: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_fed_tax_type );

1390: ,l_ssn
1391: );
1392: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' || l_first_name
1393: );
1394: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_fed_tax_type );
1395: end if; -- over limit > 0
1396:
1397: end loop;
1398: -- close c_balance_sets;

Line 1401: hr_utility.set_location('OUT load_federal_taxes ',450);

1397: end loop;
1398: -- close c_balance_sets;
1399: end if; /* tax type is null or one of the federal limit tax */
1400:
1401: hr_utility.set_location('OUT load_federal_taxes ',450);
1402:
1403: exception
1404: when others then
1405: hr_utility.trace('Error occurred load_federal_taxes ...' ||SQLERRM);

Line 1405: hr_utility.trace('Error occurred load_federal_taxes ...' ||SQLERRM);

1401: hr_utility.set_location('OUT load_federal_taxes ',450);
1402:
1403: exception
1404: when others then
1405: hr_utility.trace('Error occurred load_federal_taxes ...' ||SQLERRM);
1406: raise;
1407: end load_federal_taxes;
1408: --
1409: --------------------- END FEDERAL TAXES -----------------------------------

Line 1464: --hr_utility.trace_on(null,'oracle');

1460: --
1461: --
1462: --------------------------- M A I N -------------------------------------
1463: begin
1464: --hr_utility.trace_on(null,'oracle');
1465:
1466: hr_utility.set_location('IN load data',500);
1467:
1468: hr_utility.trace('PACTID = '||pactid);

Line 1466: hr_utility.set_location('IN load data',500);

1462: --------------------------- M A I N -------------------------------------
1463: begin
1464: --hr_utility.trace_on(null,'oracle');
1465:
1466: hr_utility.set_location('IN load data',500);
1467:
1468: hr_utility.trace('PACTID = '||pactid);
1469: hr_utility.trace('CHNKNO = '||to_char(chnkno));
1470: begin

Line 1468: hr_utility.trace('PACTID = '||pactid);

1464: --hr_utility.trace_on(null,'oracle');
1465:
1466: hr_utility.set_location('IN load data',500);
1467:
1468: hr_utility.trace('PACTID = '||pactid);
1469: hr_utility.trace('CHNKNO = '||to_char(chnkno));
1470: begin
1471: if g_get_param = 'Y' then
1472: g_get_param := 'N';

Line 1469: hr_utility.trace('CHNKNO = '||to_char(chnkno));

1465:
1466: hr_utility.set_location('IN load data',500);
1467:
1468: hr_utility.trace('PACTID = '||pactid);
1469: hr_utility.trace('CHNKNO = '||to_char(chnkno));
1470: begin
1471: if g_get_param = 'Y' then
1472: g_get_param := 'N';
1473: select ppa.legislative_parameters,

Line 1502: hr_utility.trace('Legislative Details not found...');

1498: l_tax_type := replace(l_tax_type,'_',' ');
1499:
1500: end if;
1501: exception when no_data_found then
1502: hr_utility.trace('Legislative Details not found...');
1503: raise;
1504: end;
1505:
1506: g_inserted_asg_action_id_flag := 'N';

Line 1510: hr_utility.trace('Inserting Limit Values using utilities package');

1506: g_inserted_asg_action_id_flag := 'N';
1507: l_as_of_date := to_date(l_date_prm,'YYYY/MM/DD');
1508:
1509: if (pay_us_payroll_utils.ltr_fed_tax_info.count < 1 or pay_us_payroll_utils.ltr_state_tax_info.count < 1 ) THEN
1510: hr_utility.trace('Inserting Limit Values using utilities package');
1511: pay_us_payroll_utils.populate_jit_information(p_effective_date => l_as_of_date
1512: ,p_get_federal => 'Y'
1513: ,p_get_state => 'Y');
1514: end if;

Line 1539: hr_utility.trace('Chunk No = '||to_char(chnkno));

1535: l_bal_date;
1536:
1537:
1538:
1539: hr_utility.trace('Chunk No = '||to_char(chnkno));
1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

Line 1540: hr_utility.trace('Start Date = '||to_char(l_start_date));

1536:
1537:
1538:
1539: hr_utility.trace('Chunk No = '||to_char(chnkno));
1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);

Line 1541: hr_utility.trace('End Date = '||to_char(l_end_date));

1537:
1538:
1539: hr_utility.trace('Chunk No = '||to_char(chnkno));
1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));

Line 1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));

1538:
1539: hr_utility.trace('Chunk No = '||to_char(chnkno));
1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

Line 1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

1539: hr_utility.trace('Chunk No = '||to_char(chnkno));
1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

Line 1544: hr_utility.trace('Action Type = '||l_action_type);

1540: hr_utility.trace('Start Date = '||to_char(l_start_date));
1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
1548: hr_utility.trace('GRE Name = '||l_gre_name);

Line 1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));

1541: hr_utility.trace('End Date = '||to_char(l_end_date));
1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
1548: hr_utility.trace('GRE Name = '||l_gre_name);
1549:

Line 1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

1542: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
1548: hr_utility.trace('GRE Name = '||l_gre_name);
1549:
1550: l_tax_group := Tax_group(l_tax_unit_id);

Line 1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

1543: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
1548: hr_utility.trace('GRE Name = '||l_gre_name);
1549:
1550: l_tax_group := Tax_group(l_tax_unit_id);
1551:

Line 1548: hr_utility.trace('GRE Name = '||l_gre_name);

1544: hr_utility.trace('Action Type = '||l_action_type);
1545: hr_utility.trace('Asg Act ID = '||to_char(p_assignment_action_id));
1546: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1547: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
1548: hr_utility.trace('GRE Name = '||l_gre_name);
1549:
1550: l_tax_group := Tax_group(l_tax_unit_id);
1551:
1552: hr_utility.trace('Tax Group = '||l_tax_group);

Line 1552: hr_utility.trace('Tax Group = '||l_tax_group);

1548: hr_utility.trace('GRE Name = '||l_gre_name);
1549:
1550: l_tax_group := Tax_group(l_tax_unit_id);
1551:
1552: hr_utility.trace('Tax Group = '||l_tax_group);
1553:
1554: -- Insert a dummy assignment action to enable the report to be fired in case of
1555: -- no employee is found.
1556:

Line 1623: hr_utility.trace('End of LOAD DATA');

1619: ,l_tax_type
1620: ,l_tax_group
1621: ,chnkno);
1622:
1623: hr_utility.trace('End of LOAD DATA');
1624: hr_utility.set_location('OUT load data',550);
1625:
1626: -----------------------------------------------
1627: --Bug # 3118107

Line 1624: hr_utility.set_location('OUT load data',550);

1620: ,l_tax_group
1621: ,chnkno);
1622:
1623: hr_utility.trace('End of LOAD DATA');
1624: hr_utility.set_location('OUT load data',550);
1625:
1626: -----------------------------------------------
1627: --Bug # 3118107
1628: -----------------------------------------------

Line 1642: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);

1638: end if;
1639: close sel_aaid;
1640: exception
1641: when others then
1642: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);
1643: raise;
1644:
1645: end load_data;
1646: --------------------------end load data-----------------------------