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

Line 443: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 10);

439: l_found boolean;
440: begin
441: -- Look to see if the group level balance is in our cache.
442: --
443: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 10);
444: pay_us_balance_view_pkg.debug_msg( '===========================================');
445: pay_us_balance_view_pkg.debug_msg('get_asg_for_grp_lvl entry:');
446: pay_us_balance_view_pkg.debug_msg(' p_grp_dvl_dimension: ' || p_grp_dvl_dimension);
447: --

Line 454: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 20);

450: while ((l_count < g_nxt_free_dim) AND (l_found = FALSE)) loop
451: pay_us_balance_view_pkg.debug_msg(' checking internal dim tables, count: '
452: || l_count);
453: if (p_grp_dvl_dimension = g_dim_tbl_grp(l_count)) then
454: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 20);
455: --
456: p_asg_lvl_dimension := g_dim_tbl_asg(l_count);
457: p_asg_cursor := g_dim_tbl_crs(l_count);
458: p_asg_vdate_cursor := g_dim_tbl_vtd(l_count);

Line 475: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 30);

471: end if;
472: l_count := l_count + 1;
473: end loop;
474: --
475: --hr_utility.set_location('bh_taxbal.get_asg_for_grp_lvl', 30);
476: p_found := l_found;
477: --
478: end;
479: --

Line 565: --hr_utility.set_location('bh_taxbal.get_virtual_date', 10);

561: begin
562: --
563: -- Is the assignment on a payroll.
564: --
565: --hr_utility.set_location('bh_taxbal.get_virtual_date', 10);
566: select ''
567: into l_dummy
568: from per_assignments_f paf
569: where paf.assignment_id = p_assignment_id

Line 575: --hr_utility.set_location('bh_taxbal.get_virtual_date', 20);

571: and paf.effective_end_date
572: and paf.payroll_id is not null;
573:
574: --
575: --hr_utility.set_location('bh_taxbal.get_virtual_date', 20);
576: return p_virtual_date;
577: exception
578: when no_data_found then
579: --

Line 585: --hr_utility.set_location('bh_taxbal.get_virtual_date', 30);

581: --
582: declare
583: l_rows number;
584: begin
585: --hr_utility.set_location('bh_taxbal.get_virtual_date', 30);
586: l_rows := run_asg_vdate_cursor( p_asg_vdate_cursor,
587: p_assignment_id,
588: p_virtual_date,
589: p_virtual_date,

Line 592: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 40);

588: p_virtual_date,
589: p_virtual_date,
590: l_virtual_date );
591: if l_rows > 0 then
592: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 40);
593: --
594: select max(ppf.effective_end_date)
595: into l_virtual_date2
596: from per_assignments_f paf,

Line 608: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 60);

604: -- Now work out which date is needed
605: --
606: if l_virtual_date is null then
607: if l_virtual_date2 is null then
608: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 60);
609: local_error('get_virtual_date', 2);
610: else
611: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 70);
612: l_res_date := l_virtual_date2;

Line 611: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 70);

607: if l_virtual_date2 is null then
608: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 60);
609: local_error('get_virtual_date', 2);
610: else
611: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 70);
612: l_res_date := l_virtual_date2;
613: end if;
614: else
615: if l_virtual_date2 is null then

Line 616: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 80);

612: l_res_date := l_virtual_date2;
613: end if;
614: else
615: if l_virtual_date2 is null then
616: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 80);
617: l_res_date := l_virtual_date;
618: else
619: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 90);
620: l_res_date := least(l_virtual_date, l_virtual_date2);

Line 619: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 90);

615: if l_virtual_date2 is null then
616: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 80);
617: l_res_date := l_virtual_date;
618: else
619: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 90);
620: l_res_date := least(l_virtual_date, l_virtual_date2);
621: end if;
622: end if;
623: --

Line 625: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 50);

621: end if;
622: end if;
623: --
624: else
625: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 50);
626: local_error('get_virtual_date', 1);
627: end if;
628: --
629: end;

Line 725: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 10);

721: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' || p_gre_id);
722: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' || p_jurisdiction_code);
723: --
724: l_balance_value := 0;
725: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 10);
726: --
727: -- Get the assignment level version.
728: --
729: get_asg_for_grp_lvl(p_database_suffix,

Line 756: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 20);

752: end if;
753: --
754: -- Are there latest balances available.
755: --
756: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 20);
757: l_defined_balance_id := get_defined_balance(p_balance_name,
758: l_asg_data_suffix);
759: pay_us_balance_view_pkg.debug_msg(' got defbalid: '
760: || l_defined_balance_id

Line 798: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 30);

794: -- OK, we can sum the values of the assignment balances to get the
795: -- group balance.
796: --
797: pay_us_balance_view_pkg.debug_msg(' summing latest balance values');
798: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 30);
799: begin
800: --
801: -- Does the cursor require the jurisdiction code. Hence balance
802: -- type.

Line 843: --hr_utility.set_location( 'bh_taxbal.get_grp_asg_value', 40);

839: fetch asg_cur2 into l_asg_id;
840: exit when asg_cur2%notfound;
841: end if;
842:
843: --hr_utility.set_location( 'bh_taxbal.get_grp_asg_value', 40);
844: l_virtual_date := get_virtual_date(l_asg_id, p_virtual_date,
845: l_asg_balance_time,
846: l_asg_vdate_cursor);
847: pay_us_balance_view_pkg.debug_msg(' got l_virtual_date: '

Line 886: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 50);

882: --
883: -- No latest balances available. Run the route.
884: --
885: pay_us_balance_view_pkg.debug_msg(' no latest bals, running route');
886: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 50);
887: l_defined_balance_id := get_defined_balance(p_balance_name,
888: p_database_suffix);
889: pay_us_balance_view_pkg.debug_msg(' def bal id: ' || l_defined_balance_id);
890: l_balance_value := pay_us_balance_view_pkg.get_value( p_assignment_id,

Line 901: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 60);

897: -- Can not sum the assignment level balances, thus run group
898: -- level route.
899: pay_us_balance_view_pkg.debug_msg(' Can not sum the assignment level balances, running route');
900: --
901: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 60);
902: l_defined_balance_id := get_defined_balance(p_balance_name,
903: p_database_suffix);
904: pay_us_balance_view_pkg.debug_msg(' def bal id: ' || l_defined_balance_id);
905: l_balance_value := pay_us_balance_view_pkg.get_value

Line 913: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 70);

909: p_virtual_date
910: );
911: end if;
912: --
913: --hr_utility.set_location('bh_taxbal.get_grp_asg_value', 70);
914: pay_us_balance_view_pkg.debug_msg(' *** get_grp_asg_value returning l_balance_value: '
915: || l_balance_value);
916: return l_balance_value;
917: --

Line 933: --hr_utility.set_location('bh_taxbal.get_grp_act_value', 10);

929: return number is
930: l_defined_balance_id number;
931: l_balance_value number;
932: begin
933: --hr_utility.set_location('bh_taxbal.get_grp_act_value', 10);
934: --
935: pay_us_balance_view_pkg.debug_msg( '===========================================');
936: pay_us_balance_view_pkg.debug_msg('get_grp_act_value entry:');
937: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' || p_assignment_action_id);

Line 952: --hr_utility.set_location('bh_taxbal.get_grp_act_value', 20);

948: p_assignment_action_id,
949: l_defined_balance_id
950: );
951: --
952: --hr_utility.set_location('bh_taxbal.get_grp_act_value', 20);
953: return l_balance_value;
954: --
955: end;
956: --

Line 969: --hr_utility.set_location('bh_taxbal.get_grp_value', 10);

965: p_jurisdiction_code varchar2,
966: p_assignment_action_id number default null)
967: return number is
968: begin
969: --hr_utility.set_location('bh_taxbal.get_grp_value', 10);
970: pay_us_balance_view_pkg.debug_msg( '===========================================');
971: pay_us_balance_view_pkg.debug_msg('get_grp_value entry:');
972: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' || p_assignment_id);
973: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' || p_virtual_date);

Line 981: --hr_utility.set_location('bh_taxbal.get_grp_value', 20);

977: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' || p_jurisdiction_code);
978: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' || p_assignment_action_id);
979:
980: if p_assignment_action_id is null then
981: --hr_utility.set_location('bh_taxbal.get_grp_value', 20);
982: return get_grp_asg_value(p_assignment_id,
983: p_virtual_date,
984: p_balance_name,
985: p_database_suffix,

Line 989: --hr_utility.set_location('bh_taxbal.get_grp_value', 30);

985: p_database_suffix,
986: p_gre_id,
987: p_jurisdiction_code);
988: else
989: --hr_utility.set_location('bh_taxbal.get_grp_value', 30);
990: return get_grp_act_value(p_assignment_action_id,
991: p_virtual_date,
992: p_balance_name,
993: p_database_suffix,

Line 1029: hr_utility.trace('Entered into us_entry_itd_balance');

1025:
1026: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1027:
1028: BEGIN
1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);

Line 1030: hr_utility.trace('p_balance_name := ' || p_balance_name);

1026: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1027:
1028: BEGIN
1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);
1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);

Line 1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);

1027:
1028: BEGIN
1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);
1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);
1035:

Line 1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);

1028: BEGIN
1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);
1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);
1035:
1036: open csr_get_def_balance(p_balance_name

Line 1033: hr_utility.trace('p_source_id := ' || p_source_id);

1029: hr_utility.trace('Entered into us_entry_itd_balance');
1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);
1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);
1035:
1036: open csr_get_def_balance(p_balance_name
1037: ,p_dimension_suffix

Line 1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);

1030: hr_utility.trace('p_balance_name := ' || p_balance_name);
1031: hr_utility.trace('p_dimension_suffix := ' || p_dimension_suffix);
1032: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1033: hr_utility.trace('p_source_id := ' || p_source_id);
1034: hr_utility.trace('p_business_group_id := ' || p_business_group_id);
1035:
1036: open csr_get_def_balance(p_balance_name
1037: ,p_dimension_suffix
1038: ,p_business_group_id);

Line 1042: hr_utility.trace('ln_defined_balance_id := ' || ln_defined_balance_id);

1038: ,p_business_group_id);
1039: fetch csr_get_def_balance into ln_defined_balance_id;
1040: close csr_get_def_balance;
1041:
1042: hr_utility.trace('ln_defined_balance_id := ' || ln_defined_balance_id);
1043: hr_utility.trace('Before calling pay_balance_pkg.get_value');
1044:
1045: IF NVL(ln_defined_balance_id, -9999) = -9999 THEN
1046: RETURN 0;

Line 1043: hr_utility.trace('Before calling pay_balance_pkg.get_value');

1039: fetch csr_get_def_balance into ln_defined_balance_id;
1040: close csr_get_def_balance;
1041:
1042: hr_utility.trace('ln_defined_balance_id := ' || ln_defined_balance_id);
1043: hr_utility.trace('Before calling pay_balance_pkg.get_value');
1044:
1045: IF NVL(ln_defined_balance_id, -9999) = -9999 THEN
1046: RETURN 0;
1047:

Line 1096: --hr_utility.set_location('bh_taxbal.balance_name'||p_balance_name, 9);

1092: pay_us_balance_view_pkg.debug_msg(' p_asg_type: ' || p_asg_type);
1093: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' || p_gre_id);
1094: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' || p_jurisdiction_code);
1095:
1096: --hr_utility.set_location('bh_taxbal.balance_name'||p_balance_name, 9);
1097:
1098: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 10);
1099: IF p_assignment_action_id IS NOT NULL THEN
1100: -- If group level balance, call the group level balance code.

Line 1098: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 10);

1094: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' || p_jurisdiction_code);
1095:
1096: --hr_utility.set_location('bh_taxbal.balance_name'||p_balance_name, 9);
1097:
1098: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 10);
1099: IF p_assignment_action_id IS NOT NULL THEN
1100: -- If group level balance, call the group level balance code.
1101: pay_us_balance_view_pkg.debug_msg(' assignment_action_id not NULL: '
1102: || p_assignment_action_id);

Line 1105: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 20);

1101: pay_us_balance_view_pkg.debug_msg(' assignment_action_id not NULL: '
1102: || p_assignment_action_id);
1103: if p_asg_type = 'GRE' then
1104: pay_us_balance_view_pkg.debug_msg(', p_asg_type GRE, calling get_grp_value');
1105: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 20);
1106: return get_grp_value(p_assignment_id,
1107: p_virtual_date,
1108: p_balance_name,
1109: p_dimension_suffix,

Line 1119: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 30);

1115: pay_us_balance_view_pkg.debug_msg(' p_asg_type *not* GRE, calling get_defined_balance and get_value');
1116: l_defined_balance_id := get_defined_balance(p_balance_name,
1117: p_dimension_suffix);
1118: IF p_dimension_suffix not like '%PAY%' THEN
1119: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 30);
1120: -- BHOMAN -- this is where pmadore's test case calls get_value
1121: -- if asg_type = PER, def_bal_id is 3167; if ASG then 3157,
1122: -- if GRE then doesn't call here
1123: -- assact_id is fathful to whatever we pass

Line 1137: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 40);

1133: return pay_us_balance_view_pkg.get_value (p_assignment_action_id,
1134: l_defined_balance_id
1135: );
1136: ELSE /* If payments dimension then must execute DB item 395029 */
1137: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 40);
1138: pay_us_balance_view_pkg.debug_msg(' dimension *is* like PAY, calling get_value with *NO* caching');
1139: return pay_us_balance_view_pkg.get_value (
1140: p_assignment_action_id,
1141: l_defined_balance_id,

Line 1152: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 50);

1148: -- If group level balance, call the group level balance code.
1149: pay_us_balance_view_pkg.debug_msg(' assignment_action_id *is* NULL: ');
1150: if p_asg_type = 'GRE' then
1151: pay_us_balance_view_pkg.debug_msg(' p_asg_type is GRE, calling get_grp_value');
1152: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 50);
1153: return get_grp_value(p_assignment_id,
1154: p_virtual_date,
1155: p_balance_name,
1156: p_dimension_suffix,

Line 1165: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 60);

1161: else
1162: pay_us_balance_view_pkg.debug_msg(' p_asg_type is *not* GRE, calling get_defined_balance and get_value');
1163: l_defined_balance_id := get_defined_balance(p_balance_name,
1164: p_dimension_suffix);
1165: --hr_utility.set_location('bh_taxbal.call_balance_user_exit', 60);
1166: return pay_us_balance_view_pkg.get_value (
1167: p_assignment_id,
1168: l_defined_balance_id,
1169: p_virtual_date

Line 1712: hr_utility.trace('Within us_named_balance_vm. p_classification_name := ' || p_classification_name);

1708:
1709: IF p_classification_name IS NOT NULL
1710: AND p_accrued_dimension IS NOT NULL THEN
1711:
1712: hr_utility.trace('Within us_named_balance_vm. p_classification_name := ' || p_classification_name);
1713: hr_utility.trace('p_accrued_dimension := ' || p_accrued_dimension);
1714: hr_utility.trace('p_source_id := ' || p_source_id);
1715:
1716: IF p_classification_name IN ('Voluntary Deductions', 'Involuntary Deductions')

Line 1713: hr_utility.trace('p_accrued_dimension := ' || p_accrued_dimension);

1709: IF p_classification_name IS NOT NULL
1710: AND p_accrued_dimension IS NOT NULL THEN
1711:
1712: hr_utility.trace('Within us_named_balance_vm. p_classification_name := ' || p_classification_name);
1713: hr_utility.trace('p_accrued_dimension := ' || p_accrued_dimension);
1714: hr_utility.trace('p_source_id := ' || p_source_id);
1715:
1716: IF p_classification_name IN ('Voluntary Deductions', 'Involuntary Deductions')
1717: AND instr(upper(p_balance_name), ' ACCRUED') <> 0 THEN

Line 1714: hr_utility.trace('p_source_id := ' || p_source_id);

1710: AND p_accrued_dimension IS NOT NULL THEN
1711:
1712: hr_utility.trace('Within us_named_balance_vm. p_classification_name := ' || p_classification_name);
1713: hr_utility.trace('p_accrued_dimension := ' || p_accrued_dimension);
1714: hr_utility.trace('p_source_id := ' || p_source_id);
1715:
1716: IF p_classification_name IN ('Voluntary Deductions', 'Involuntary Deductions')
1717: AND instr(upper(p_balance_name), ' ACCRUED') <> 0 THEN
1718:

Line 1719: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);

1715:
1716: IF p_classification_name IN ('Voluntary Deductions', 'Involuntary Deductions')
1717: AND instr(upper(p_balance_name), ' ACCRUED') <> 0 THEN
1718:
1719: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1720: hr_utility.trace('p_ele_typ_id := ' || p_ele_typ_id);
1721:
1722: IF p_source_id IS NULL THEN
1723:

Line 1720: hr_utility.trace('p_ele_typ_id := ' || p_ele_typ_id);

1716: IF p_classification_name IN ('Voluntary Deductions', 'Involuntary Deductions')
1717: AND instr(upper(p_balance_name), ' ACCRUED') <> 0 THEN
1718:
1719: hr_utility.trace('p_assignment_action_id := ' || p_assignment_action_id);
1720: hr_utility.trace('p_ele_typ_id := ' || p_ele_typ_id);
1721:
1722: IF p_source_id IS NULL THEN
1723:
1724: OPEN c_get_source_id(cp_asg_act_id => p_assignment_action_id

Line 1728: hr_utility.trace('ln_source_id := ' || ln_source_id);

1724: OPEN c_get_source_id(cp_asg_act_id => p_assignment_action_id
1725: ,cp_ele_typ_id => p_ele_typ_id);
1726: FETCH c_get_source_id INTO ln_source_id;
1727: CLOSE c_get_source_id;
1728: hr_utility.trace('ln_source_id := ' || ln_source_id);
1729:
1730: END IF;
1731:
1732: l_dimension_suffix := p_accrued_dimension;

Line 1740: hr_utility.trace('ln_accrued_bal_val := ' || ln_accrued_bal_val);

1736: ,p_assignment_action_id => l_assignment_action_id
1737: ,p_source_id => NVL(p_source_id, ln_source_id)
1738: ,p_business_group_id => p_business_group_id);
1739:
1740: hr_utility.trace('ln_accrued_bal_val := ' || ln_accrued_bal_val);
1741:
1742: IF NVL(ln_accrued_bal_val,0) = 0 THEN
1743: -- ENTRY_ITD dimension is not attached to Accrued balance
1744:

Line 2080: hr_utility.trace('Year from Assignment Action ID: '||l_year);

2076: OPEN get_year(p_assignment_action_id);
2077: FETCH get_year INTO l_year;
2078: CLOSE get_year;
2079:
2080: hr_utility.trace('Year from Assignment Action ID: '||l_year);
2081:
2082: ELSE
2083:
2084: l_year := TO_CHAR(p_virtual_date,'YYYY');

Line 2086: hr_utility.trace('Year from Virtual Date: '||l_year);

2082: ELSE
2083:
2084: l_year := TO_CHAR(p_virtual_date,'YYYY');
2085:
2086: hr_utility.trace('Year from Virtual Date: '||l_year);
2087:
2088: END IF;
2089:
2090: l_direct_bal_year := NVL(fnd_profile.value('PAY_US_DIRECT_BALANCE_START_YEAR'),'0001');

Line 2098: hr_utility.trace('US Federal Balances will be fetched from Direct Values');

2094: l_direct_fed_bal_call := 'N';
2095:
2096: ELSE
2097:
2098: hr_utility.trace('US Federal Balances will be fetched from Direct Values');
2099:
2100: END IF;
2101:
2102: END IF;

Line 2158: --hr_utility.set_location('pay_tax_bals_pkg',30);

2154: --
2155: -- Set the contexts used in the bal user exit. Same throughout, so set
2156: -- them up front
2157: --
2158: --hr_utility.set_location('pay_tax_bals_pkg',30);
2159: --
2160: pay_us_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
2161: IF p_jd_context IS NOT NULL THEN
2162: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN

Line 2170: --hr_utility.set_location('pay_tax_bals_pkg',40);

2166: pay_us_balance_view_pkg.set_context('JURISDICTION_CODE',p_jd_context);
2167: END IF;
2168: END IF;
2169: --
2170: --hr_utility.set_location('pay_tax_bals_pkg',40);
2171: --
2172: l_assignment_id := p_assignment_id;
2173: l_assignment_action_id := p_assignment_action_id;
2174: l_tax_type := p_tax_type;

Line 2180: --hr_utility.set_location('pay_tax_bals_pkg',50);

2176: l_virtual_date := p_virtual_date;
2177: --
2178: -- Check if assignment exists at l_virtual_date, if using date mode
2179: --
2180: --hr_utility.set_location('pay_tax_bals_pkg',50);
2181: --
2182: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
2183: --
2184: select count(0)

Line 2192: --hr_utility.set_location('pay_tax_bals_pkg',60);

2188: and l_virtual_date between effective_start_date and effective_end_date;
2189: --
2190: -- if assignment doesn't exist ...
2191: --
2192: --hr_utility.set_location('pay_tax_bals_pkg',60);
2193: --
2194: IF l_asg_exists = 0 THEN
2195: --
2196: -- get the termination date ...

Line 2205: --hr_utility.set_location('pay_tax_bals_pkg',70);

2201: where assignment_id = l_assignment_id;
2202: --
2203: -- get the date of the start of the time period in question
2204: --
2205: --hr_utility.set_location('pay_tax_bals_pkg',70);
2206: --
2207: IF p_time_type = 'QTD' THEN
2208: l_bal_start_date := trunc(l_virtual_date,'Q');
2209: ELSIF p_time_type = 'MONTH' THEN

Line 2244: --hr_utility.set_location('pay_tax_bals_pkg',80);

2240: END IF;
2241: --
2242: -- Convert "WITHHELD" to proper balance categories;
2243: --
2244: --hr_utility.set_location('pay_tax_bals_pkg',80);
2245: --
2246: IF l_tax_balance_category = 'WITHHELD' THEN
2247: IF p_ee_or_er = 'ER' or l_tax_type = 'FUTA' THEN
2248: l_tax_balance_category := 'LIABILITY';

Line 2260: --hr_utility.set_location('pay_tax_bals_pkg',90);

2256: END IF;
2257: --
2258: -- Check if illegal tax combo (FIT and TAXABLE, FUTA and SUBJ_NWHABLE, etc.)
2259: --
2260: --hr_utility.set_location('pay_tax_bals_pkg',90);
2261: --
2262: IF (l_tax_type = 'FIT' or l_tax_type = 'SIT' or l_tax_type = 'COUNTY' or
2263: l_tax_type = 'CITY' or l_tax_type = 'EIC' or l_tax_type = 'HT' or
2264: l_tax_type = 'SCHOOL' or l_tax_type = 'STEIC' ) THEN -- income tax

Line 2294: --hr_utility.set_location('pay_tax_bals_pkg',100);

2290: return 0;
2291: END IF;
2292: END IF;
2293: --
2294: --hr_utility.set_location('pay_tax_bals_pkg',100);
2295: --
2296: l_ee_or_er := ltrim(rtrim(p_ee_or_er));
2297: --
2298: --------------- Some Error Checking -------------

Line 2351: --hr_utility.set_location('pay_tax_bals_pkg',110);

2347: ) THEN
2348: return 0;
2349: END IF;
2350: --
2351: --hr_utility.set_location('pay_tax_bals_pkg',110);
2352: --
2353: -- Force space at end of this parameter if necessary
2354: --
2355: --hr_utility.set_location('pay_tax_bals_pkg',120);

Line 2355: --hr_utility.set_location('pay_tax_bals_pkg',120);

2351: --hr_utility.set_location('pay_tax_bals_pkg',110);
2352: --
2353: -- Force space at end of this parameter if necessary
2354: --
2355: --hr_utility.set_location('pay_tax_bals_pkg',120);
2356: --
2357: IF l_ee_or_er IS NOT NULL THEN
2358: l_ee_or_er := rtrim(l_ee_or_er)||' ';
2359: END IF;