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.37.12020000.2 2012/07/05 02:49:37 amnaraya 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 556: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3171: END pay_get_tax_exists_pkg;

3167: BEGIN
3168: RETURN fnd_profile.value(p_profile_name);
3169: END get_profile_value;
3170:
3171: END pay_get_tax_exists_pkg;