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_GET_TAX_EXISTS_PKG dependencies on PAY_GET_TAX_EXISTS_PKG

Line 1: PACKAGE BODY pay_get_tax_exists_pkg AS

1: PACKAGE BODY pay_get_tax_exists_pkg AS
2: /* $Header: pytaxexi.pkb 120.23.12010000.6 2008/10/14 10:07:16 emunisek ship $ */
3:
4: /*
5: We are using the contexts JURISDICTION_CODE, DATE_EARNED, TAX_UNIT_ID

Line 80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);

76: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
77: pest.effective_start_date AND pest.effective_end_date;
78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:

Line 553: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);

549: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||'-0000';
550: /* Bug 2934494
551: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||' - 0000';
552: */
553: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);
554: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);
555: RETURN(l_local_level_tax_exists);
556:
557: EXCEPTION

Line 561: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);

557: EXCEPTION
558: WHEN OTHERS THEN
559: -- If there is no value then return l_state_level_tax_exists
560: hr_utility.set_location(
561: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);
562: hr_utility.trace(
563: 'No rexord defined in Local Tax rules for this Locality : '
564: || l_local_level_tax_exists);
565: /*

Line 735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);

731: IF l_payroll_installed THEN
732: /*{*/
733:
734: -- hr_utility.trace_on(null,'TAXEXIST');
735: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
736: hr_utility.trace('We are changing the date format, the before date is: '
737: ||p_date_earned);
738: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
739:

Line 844: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);

840: WHERE hoi.ORG_INFORMATION_CONTEXT = 'State Tax Rules'
841: AND hoi.organization_id = p_tax_unit_id
842: AND hoi.org_information1 = l_state_abbrev;
843:
844: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);
845: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
846:
847: IF l_sit_rs_exists = 'N' THEN
848:

Line 862: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);

858: WHEN NO_DATA_FOUND THEN
859: /*
860: * If there is no value then return the value of l_org_info2
861: */
862: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);
863: hr_utility.trace('SIT Exists : ' || l_org_info2);
864:
865: IF l_org_info2 = 'N' THEN
866:

Line 879: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);

875: END;
876: /*}*/
877: ELSE /* 2 */
878: /*{*/
879: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);
880: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
881:
882: RETURN l_sit_rs_exists;
883: /*

Line 893: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);

889: EXCEPTION
890: WHEN others THEN
891:
892: l_sit_rs_exists := 'Y';
893: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);
894: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
895:
896: RETURN l_sit_rs_exists;
897:

Line 914: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);

910: effective_start_date AND effective_end_date;
911:
912: IF l_sit_wk_exists = 'Y' THEN /* 2 */
913: /*{*/
914: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);
915: hr_utility.trace('SIT_WK Exists at the jit level, '
916: ||' now we check if the NR certificate is filed');
917: IF p_call = 'F' THEN
918: /*{*/

Line 926: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);

922: p_assign_id,
923: p_pact_id,
924: 'NR');
925:
926: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);
927: hr_utility.trace('Do we take out sit based on the NR check? '
928: || l_sit_wk_exists);
929: /*}*/
930: END IF;

Line 941: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);

937: /*{*/
938: /*
939: * jit level, this will be N, no sit for the state
940: */
941: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);
942: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
943: RETURN l_sit_wk_exists;
944:
945: /*}*/

Line 951: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

947:
948: EXCEPTION
949: WHEN others THEN
950: l_sit_wk_exists := 'Y';
951: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
952: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
953: RETURN l_sit_wk_exists;
954: /*}*/
955: END; /* SIT_WK */

Line 978: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);

974:
975:
976: IF l_wc_exists = 'Y' THEN /* 2 */
977: /*{*/
978: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);
979: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '
980: ||' now check if this assignment is WC exempt');
981: IF p_call = 'F' THEN
982: /*{*/

Line 994: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);

990: AND str.assignment_id = p_assign_id /* 5772548 */
991: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
992: str.effective_start_date AND str.effective_end_date;
993:
994: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);
995: hr_utility.trace(' check for wc exemption ' || l_wc_exists);
996: /*}*/
997: END IF;
998: /*

Line 1008: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);

1004:
1005: EXCEPTION
1006: WHEN others THEN
1007: l_wc_exists := 'Y';
1008: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);
1009: hr_utility.trace('WC Exists : ' || l_wc_exists);
1010: RETURN l_wc_exists;
1011: /*}*/
1012: END; /* WC */

Line 1028: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);

1024: effective_start_date AND effective_end_date;
1025:
1026: IF l_misc1_state_tax = 'Y' THEN /* 2 */
1027: /*{*/
1028: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);
1029: hr_utility.trace('MISC1_TAX Exists at the jit level, '
1030: ||' now we check if the NR certificate is filed');
1031: /*Bug 4344763, For SHI(MA) NR Certificate should not be checked*/
1032: /* IF p_call = 'F' THEN

Line 1039: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);

1035: p_tax_unit_id,
1036: p_assign_id,
1037: 'NR');
1038:
1039: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);
1040: hr_utility.trace('Do we take out sit based on the NR check? '
1041: || l_sit_wk_exists);
1042:
1043: END IF;*/

Line 1056: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);

1052: /*
1053: * jit level, this will be N, no misc1 tax for the state
1054: */
1055: l_misc1_state_tax := 'N';
1056: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);
1057: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1058: RETURN l_misc1_state_tax;
1059:
1060: /*}*/

Line 1066: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);

1062:
1063: EXCEPTION
1064: WHEN others THEN
1065: l_misc1_state_tax := 'N';
1066: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);
1067: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1068: RETURN l_misc1_state_tax;
1069: /*}*/
1070: END; /* MISC1_TAX */

Line 1103: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);

1099: AND SES.session_id = USERENV('SESSIONID')
1100: AND SES.effective_date BETWEEN
1101: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1102:
1103: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);
1104: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1105:
1106: IF l_sdi_ee_exists = 'N' THEN /* 2 */
1107: /*

Line 1113: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1109: */
1110: /*{*/
1111: BEGIN
1112: /*{*/
1113: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1114: 31);
1115: hr_utility.trace('No SDI wage limit, check for period limit');
1116:
1117: SELECT DISTINCT DECODE(STATETAX.STA_INFORMATION1,

Line 1129: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1125: AND SES.session_id = USERENV('SESSIONID')
1126: AND SES.effective_date BETWEEN
1127: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1128:
1129: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1130: 32);
1131: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);
1132: RETURN l_sdi_ee_exists;
1133:

Line 1137: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1133:
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: l_sdi_ee_exists := 'N';
1137: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1138: 33);
1139: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1140: RETURN l_sdi_ee_exists;
1141:

Line 1147: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1143: END;
1144: /*}*/
1145: ELSE /* 2 */
1146: /*{*/
1147: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1148: 34);
1149: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1150: RETURN l_sdi_ee_exists;
1151: /*}*/

Line 1157: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: l_sdi_ee_exists := 'Y';
1157: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1158: 35);
1159: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1160: RETURN l_sdi_ee_exists;
1161: /*}*/

Line 1190: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);

1186: AND SES.session_id = USERENV('SESSIONID')
1187: AND SES.effective_date BETWEEN
1188: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1189:
1190: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);
1191: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);
1192:
1193: RETURN l_sdi_er_exists;
1194:

Line 1209: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1205: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1206: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1207: effective_start_date AND effective_end_date;
1208:
1209: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1210: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1211:
1212: RETURN l_eic_rs_exists;
1213:

Line 1217: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1213:
1214: EXCEPTION
1215: WHEN others THEN
1216: l_eic_rs_exists := 'N';
1217: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1218: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1219:
1220: RETURN l_eic_rs_exists;
1221:

Line 1236: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1232: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1233: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1234: effective_start_date AND effective_end_date;
1235:
1236: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1237: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1238:
1239: RETURN l_eic_wk_exists;
1240:

Line 1244: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1240:
1241: EXCEPTION
1242: WHEN others THEN
1243: l_eic_wk_exists := 'N';
1244: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1245: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1246:
1247: RETURN l_eic_wk_exists;
1248:

Line 1584: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);

1580: END IF; /* check for Indiana state */
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: l_county_wk_exists := 'N';
1584: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);
1585: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);
1586: RETURN l_county_wk_exists;
1587: /*}*/
1588: END; /* COUNTY_WK */

Line 1618: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1614: IF l_city_rs_exists = 'Y' THEN /* 2 jit level */
1615: --{
1616: BEGIN /* see if the state has taxes in the ct setup */
1617: --{
1618: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1619: 70);
1620: hr_utility.trace('determining if the state is set up by the ct');
1621: l_city_rs_exists := get_tax_exists(p_juri_code,
1622: p_date_earned,

Line 1627: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1623: p_tax_unit_id,
1624: p_assign_id,
1625: p_pact_id,
1626: 'SIT_RS');
1627: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1628: 71);
1629: hr_utility.trace('Is the state withholding taxes ? '
1630: ||l_city_rs_exists);
1631: IF l_city_rs_exists = 'Y' THEN /* 3 */

Line 1751: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1747: /*
1748: * The state is not withholding or is not setup no city tax
1749: */
1750: --{
1751: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1752: 77);
1753: hr_utility.trace('City Income Tax Exists : ' ||
1754: l_city_rs_exists);
1755: RETURN l_city_rs_exists;

Line 1769: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);

1765: END IF; /* 2 jit level */
1766: EXCEPTION /* No rows in the city jit table */
1767: WHEN OTHERS THEN
1768: l_city_rs_exists := 'N';
1769: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);
1770: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);
1771: RETURN l_city_rs_exists;
1772: --}
1773: END; /* CITY_RS */

Line 1799: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1795: IF l_ht_wk_exists = 'Y' THEN /* 2 jit level */
1796: /*{*/
1797: BEGIN /* see if the state has taxes in the ct setup */
1798: /*{*/
1799: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1800: 180);
1801: hr_utility.trace('determining if the state is set up by the ct');
1802:
1803: l_ht_wk_exists := get_tax_exists(p_juri_code,

Line 1810: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1806: p_assign_id,
1807: p_pact_id,
1808: 'SIT_WK');
1809:
1810: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1811: 181);
1812: hr_utility.trace('Is the state withholding taxes ? '||
1813: l_ht_wk_exists);
1814:

Line 1817: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1813: l_ht_wk_exists);
1814:
1815: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1816: /*{*/
1817: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1818: 182);
1819: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1820: RETURN l_ht_wk_exists;
1821: /*}*/

Line 1827: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1823: /*
1824: * The state is not withholding or is not setup no head tax
1825: */
1826: /*{*/
1827: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1828: 183);
1829: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1830:
1831: RETURN l_ht_wk_exists;

Line 1845: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);

1841: END IF; /* 2 jit level */
1842: EXCEPTION /* No rows in the city jit table */
1843: WHEN OTHERS THEN
1844: l_ht_wk_exists := 'N';
1845: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);
1846: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1847: RETURN l_ht_wk_exists;
1848: /*}*/
1849: END; /* HT_WK */

Line 1874: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1870: IF l_city_wk_exists = 'Y' THEN /* 2 jit level */
1871: /*{*/
1872: BEGIN /* see if the state has taxes in the ct setup */
1873: /*{*/
1874: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1875: 80);
1876: hr_utility.trace('determining if the state is set up by the ct');
1877:
1878: l_city_wk_exists := get_tax_exists(p_juri_code,

Line 1886: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1882: p_pact_id,
1883: 'SIT_WK',
1884: 'CITY_WK');
1885:
1886: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1887: 81);
1888: hr_utility.trace('Is the state withholding taxes ? '
1889: ||l_city_wk_exists);
1890:

Line 1957: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1953: /*
1954: * we do not withhold, have to switch this to N for return to SIT
1955: */
1956: /*{*/
1957: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1958: 90);
1959: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1960: ||l_nr_exists);
1961: l_sit_rs_exists := 'N';

Line 2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);

2074: END IF; /* chk_product_install */
2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: l_exists := 'Y';
2078: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2079: hr_utility.trace('The main Exception handler was called and returns '
2080: ||'tax exists: '||l_exists);
2081: RETURN l_exists;
2082: -- hr_utility.trace_off;

Line 3039: END pay_get_tax_exists_pkg;

3035: END IF;
3036:
3037: END reset_stored_balance;
3038:
3039: END pay_get_tax_exists_pkg;