[Home] [Help]
24: Description : This package holds building blocks used in maintenace
25: of US employee tax rule using PER_ASSIGNMENT_EXTRA_INFO
26: table.
27:
28: Uses : hr_utility
29:
30: Change List
31: -----------
32: Date Name Vers Description
251: AND assignment_extra_info_id <> X_assignment_extra_info_id;
252:
253: BEGIN
254: --
255: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',1);
256: X_ret := check_unique(X_Assignment_Id, X_Information_Type,
257: X_Aei_Information1, X_Aei_Information2);
258: --
259: -- if row exist raise error
260: -- otherwise continue
261: --
262: if X_ret = 0
263: then
264: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',2);
265: X_User_Id := FND_PROFILE.Value('USER_ID');
266: X_Login_Id := FND_PROFILE.Value('LOGIN_ID');
267: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',3);
268: if (X_Assignment_Extra_Info_Id is NULL) then
263: then
264: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',2);
265: X_User_Id := FND_PROFILE.Value('USER_ID');
266: X_Login_Id := FND_PROFILE.Value('LOGIN_ID');
267: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',3);
268: if (X_Assignment_Extra_Info_Id is NULL) then
269: OPEN C2;
270: FETCH C2 INTO X_Assignment_Extra_Info_Id;
271: CLOSE C2;
272: end if;
273:
274: OPEN check_sd;
275:
276: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',4);
277: INSERT INTO PER_ASSIGNMENT_EXTRA_INFO(
278: creation_date,
279: created_by,
280: last_update_date,
335: X_Aei_Information19,
336: X_Aei_Information20
337: );
338: --
339: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',5);
340: --
341: if sql%notfound then
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
338: --
339: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',5);
340: --
341: if sql%notfound then
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
344: hr_utility.set_message_token('STEP','1');
345: hr_utility.raise_error;
346: end if;
339: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',5);
340: --
341: if sql%notfound then
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
344: hr_utility.set_message_token('STEP','1');
345: hr_utility.raise_error;
346: end if;
347: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',6);
340: --
341: if sql%notfound then
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
344: hr_utility.set_message_token('STEP','1');
345: hr_utility.raise_error;
346: end if;
347: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',6);
348: OPEN C;
341: if sql%notfound then
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
344: hr_utility.set_message_token('STEP','1');
345: hr_utility.raise_error;
346: end if;
347: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',6);
348: OPEN C;
349: FETCH C INTO X_Rowid;
343: hr_utility.set_message_token('PROCEDURE','US_EMP_TAX.INSERT_ROW');
344: hr_utility.set_message_token('STEP','1');
345: hr_utility.raise_error;
346: end if;
347: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',6);
348: OPEN C;
349: FETCH C INTO X_Rowid;
350: if (C%NOTFOUND) then
351: CLOSE C;
349: FETCH C INTO X_Rowid;
350: if (C%NOTFOUND) then
351: CLOSE C;
352: RAISE NO_DATA_FOUND;
353: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',7);
354: end if;
355: --
356: if X_information_type = 'FEDERAL' then
357: pay_us_emp_tax_rules_pkg.create_wc_ele_entry(
384: END IF; -- School district not null
385:
386:
387: end if; --Locality
388: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_row',9);
389: CLOSE C;
390: --
391: -- RAISE error of unique check failure
392: -- message set in check_unique
390: --
391: -- RAISE error of unique check failure
392: -- message set in check_unique
393: else
394: hr_utility.raise_error;
395: end if;
396: CLOSE check_sd;
397: --
398: END Insert_Row;
538: AND (X_Aei_Information20 IS NULL)))
539: ) then
540: return;
541: else
542: hr_utility.set_message(801, 'FORM_RECORD_CHANGED');
543: hr_utility.raise_error;
544: end if;
545: END Lock_Row;
546: --
539: ) then
540: return;
541: else
542: hr_utility.set_message(801, 'FORM_RECORD_CHANGED');
543: hr_utility.raise_error;
544: end if;
545: END Lock_Row;
546: --
547: ------------------------------- Update_Row -----------------------------
715: and Aei_Information1 = X_state_code
716: and Aei_Information2 = X_locality_code;
717: --
718: begin
719: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',1);
720: if X_information_type = 'FEDERAL'
721: then
722: OPEN csr_federal;
723: fetch csr_federal into ret;
728: end if;
729: CLOSE csr_federal;
730: elsif X_information_type = 'STATE'
731: then
732: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',2);
733: OPEN csr_state;
734: fetch csr_state into ret;
735: if csr_state%FOUND then
736: hr_utility.set_message(801,'HR_7719_TAX_ONE_RULE_ONLY');
732: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',2);
733: OPEN csr_state;
734: fetch csr_state into ret;
735: if csr_state%FOUND then
736: hr_utility.set_message(801,'HR_7719_TAX_ONE_RULE_ONLY');
737: RETURN 1;
738: else
739: RETURN 0;
740: end if;
740: end if;
741: CLOSE csr_state;
742: elsif X_information_type = 'LOCALITY'
743: then
744: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',3);
745: OPEN csr_local;
746: fetch csr_local into ret;
747: if csr_local%FOUND then
748: hr_utility.set_message(801,'HR_7720_TAX_ONE_RULE_ONLY');
744: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',3);
745: OPEN csr_local;
746: fetch csr_local into ret;
747: if csr_local%FOUND then
748: hr_utility.set_message(801,'HR_7720_TAX_ONE_RULE_ONLY');
749: RETURN 1;
750: else
751: RETURN 0;
752: end if;
749: RETURN 1;
750: else
751: RETURN 0;
752: end if;
753: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',4);
754: CLOSE csr_local;
755: end if;
756: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',5);
757: --
752: end if;
753: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',4);
754: CLOSE csr_local;
755: end if;
756: hr_utility.set_location('pay_us_emp_tax_rules_pkg.check_unique',5);
757: --
758: END check_unique;
759:
760: --
934: and paf.location_id = hl.location_id
935: and psr.state_code = hl.region_2;
936:
937: begin
938: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_state',1);
939: OPEN csr_get_res_state;
940: FETCH csr_get_res_state into P_res_state,
941: P_res_state_code,
942: l_res_state_code,
954: -- get resident locality i.e. geo code
955: --
956: p_resident_county_name := l_county;
957: --
958: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_state',2);
959: P_res_locality := hr_us_ff_udfs.addr_val (
960: p_state_abbrev => l_res_state_code,
961: p_county_name => l_county,
962: p_city_name => l_res_loc_name,
961: p_county_name => l_county,
962: p_city_name => l_res_loc_name,
963: p_zip_code => l_zip_code);
964: END IF;
965: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_state',3);
966: CLOSE csr_get_res_state;
967: --
968: OPEN csr_get_work_state;
969: FETCH csr_get_work_state into P_work_state,
985: --
986: p_work_county_name := l_county;
987: --
988:
989: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_state',4);
990: P_work_locality := hr_us_ff_udfs.addr_val (
991: p_state_abbrev => l_work_state_code,
992: p_county_name => l_county,
993: p_city_name => l_work_loc_name,
992: p_county_name => l_county,
993: p_city_name => l_work_loc_name,
994: p_zip_code => l_zip_code);
995: END IF;
996: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_state',5);
997: CLOSE csr_get_work_state;
998: --
999: END get_def_state_local;
1000: --
1025:
1026: begin
1027: --
1028: OPEN csr_filing_status;
1029: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_feder',1);
1030: FETCH csr_filing_status into p_filing_status;
1031: IF csr_filing_status%NOTFOUND then
1032: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1033: hr_utility.set_message_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
1028: OPEN csr_filing_status;
1029: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_feder',1);
1030: FETCH csr_filing_status into p_filing_status;
1031: IF csr_filing_status%NOTFOUND then
1032: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1033: hr_utility.set_message_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
1034: hr_utility.raise_error;
1035: end if;
1036: CLOSE csr_filing_status;
1029: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_feder',1);
1030: FETCH csr_filing_status into p_filing_status;
1031: IF csr_filing_status%NOTFOUND then
1032: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1033: hr_utility.set_message_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
1034: hr_utility.raise_error;
1035: end if;
1036: CLOSE csr_filing_status;
1037: --
1030: FETCH csr_filing_status into p_filing_status;
1031: IF csr_filing_status%NOTFOUND then
1032: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1033: hr_utility.set_message_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
1034: hr_utility.raise_error;
1035: end if;
1036: CLOSE csr_filing_status;
1037: --
1038: --
1035: end if;
1036: CLOSE csr_filing_status;
1037: --
1038: --
1039: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_feder',1);
1040: OPEN csr_eic_fstatus;
1041: FETCH csr_eic_fstatus into P_eic_fstatus;
1042: IF csr_eic_fstatus%NOTFOUND then
1043: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1039: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_feder',1);
1040: OPEN csr_eic_fstatus;
1041: FETCH csr_eic_fstatus into P_eic_fstatus;
1042: IF csr_eic_fstatus%NOTFOUND then
1043: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1044: hr_utility.set_message_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
1045: hr_utility.raise_error;
1046: end if;
1047: CLOSE csr_eic_fstatus;
1040: OPEN csr_eic_fstatus;
1041: FETCH csr_eic_fstatus into P_eic_fstatus;
1042: IF csr_eic_fstatus%NOTFOUND then
1043: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1044: hr_utility.set_message_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
1045: hr_utility.raise_error;
1046: end if;
1047: CLOSE csr_eic_fstatus;
1048: --
1041: FETCH csr_eic_fstatus into P_eic_fstatus;
1042: IF csr_eic_fstatus%NOTFOUND then
1043: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1044: hr_utility.set_message_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
1045: hr_utility.raise_error;
1046: end if;
1047: CLOSE csr_eic_fstatus;
1048: --
1049: -- Insert Federal Tax record
1047: CLOSE csr_eic_fstatus;
1048: --
1049: -- Insert Federal Tax record
1050: --
1051: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_feder',4);
1052: PAY_US_EMP_TAX_RULES_PKG.Insert_Row(
1053: X_Rowid => P_temp,
1054: X_Assignment_Extra_Info_Id => P_id,
1055: X_Assignment_Id => P_assignment_id,
1077: X_Aei_Information18 => P_sui_state,
1078: X_Aei_Information19 => Null,
1079: X_Aei_Information20 => Null);
1080: --
1081: hr_utility.set_location('pay_us_emp_tax_rules_pkg.get_def_feder',5);
1082: --
1083: RETURN P_id;
1084: --
1085: END insert_def_fed_rec;
1140: and sr.jurisdiction_code = substr(p_jurisdiction,1,2)||'-000-0000';
1141:
1142: begin
1143: --
1144: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1);
1145: OPEN csr_get_jurisdiction;
1146: FETCH csr_get_jurisdiction into P_jurisdiction;
1147: IF csr_get_jurisdiction%NOTFOUND then
1148: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1144: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1);
1145: OPEN csr_get_jurisdiction;
1146: FETCH csr_get_jurisdiction into P_jurisdiction;
1147: IF csr_get_jurisdiction%NOTFOUND then
1148: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');
1150: hr_utility.raise_error;
1151: end if;
1152: CLOSE csr_get_jurisdiction;
1145: OPEN csr_get_jurisdiction;
1146: FETCH csr_get_jurisdiction into P_jurisdiction;
1147: IF csr_get_jurisdiction%NOTFOUND then
1148: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');
1150: hr_utility.raise_error;
1151: end if;
1152: CLOSE csr_get_jurisdiction;
1153: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.3);
1146: FETCH csr_get_jurisdiction into P_jurisdiction;
1147: IF csr_get_jurisdiction%NOTFOUND then
1148: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');
1150: hr_utility.raise_error;
1151: end if;
1152: CLOSE csr_get_jurisdiction;
1153: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.3);
1154:
1149: hr_utility.set_message_token('LOOKUP_TYPE ','pay_state_rules');
1150: hr_utility.raise_error;
1151: end if;
1152: CLOSE csr_get_jurisdiction;
1153: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.3);
1154:
1155: OPEN csr_fed_or_def;
1156: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.4);
1157: FETCH csr_fed_or_def into l_def_pref;
1152: CLOSE csr_get_jurisdiction;
1153: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.3);
1154:
1155: OPEN csr_fed_or_def;
1156: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.4);
1157: FETCH csr_fed_or_def into l_def_pref;
1158: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.5);
1159: IF csr_fed_or_def%NOTFOUND
1160: OR l_def_pref = 'SINGLE_ZERO'
1154:
1155: OPEN csr_fed_or_def;
1156: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.4);
1157: FETCH csr_fed_or_def into l_def_pref;
1158: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.5);
1159: IF csr_fed_or_def%NOTFOUND
1160: OR l_def_pref = 'SINGLE_ZERO'
1161: OR l_def_pref IS NULL then
1162: l_def_pref := 'SINGLE_ZERO';
1162: l_def_pref := 'SINGLE_ZERO';
1163: l_filing_status := '1';
1164: l_allowances := 0;
1165: end if;
1166: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.6);
1167: CLOSE csr_fed_or_def;
1168:
1169: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.7);
1170: IF l_def_pref = 'FED_DEF' then
1165: end if;
1166: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.6);
1167: CLOSE csr_fed_or_def;
1168:
1169: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',1.7);
1170: IF l_def_pref = 'FED_DEF' then
1171: OPEN csr_filing_status;
1172: FETCH csr_filing_status into l_filing_status, l_allowances;
1173: IF csr_filing_status%NOTFOUND then
1178: end if;
1179: --
1180: -- Insert State Tax record
1181: --
1182: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',2);
1183: PAY_US_EMP_TAX_RULES_PKG.Insert_Row(
1184: X_Rowid => P_temp,
1185: X_Assignment_Extra_Info_Id => P_id,
1186: X_Assignment_Id => P_assignment_id,
1208: X_Aei_Information18 => '0', /*316663 Supp Override rate =0*/
1209: X_Aei_Information19 => Null,
1210: X_Aei_Information20 => Null);
1211: --
1212: hr_utility.set_location('pay_us_emp_tax_rules_pkg.ins_def_state',3);
1213: --
1214: -- NOTE: do not call create_vertex_entry here since we NEVER want to create
1215: -- an entry for either the resident or work state since this will
1216: -- be covered when we default the associated city record for resident
1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1271: --
1272: begin
1273: --
1274: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',1);
1275: OPEN csr_filing_status;
1276: FETCH csr_filing_status into l_filing_status;
1277: IF csr_filing_status%NOTFOUND then
1278: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1274: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',1);
1275: OPEN csr_filing_status;
1276: FETCH csr_filing_status into l_filing_status;
1277: IF csr_filing_status%NOTFOUND then
1278: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1279: hr_utility.set_message_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
1280: hr_utility.raise_error;
1281: end if;
1282: CLOSE csr_filing_status;
1275: OPEN csr_filing_status;
1276: FETCH csr_filing_status into l_filing_status;
1277: IF csr_filing_status%NOTFOUND then
1278: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1279: hr_utility.set_message_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
1280: hr_utility.raise_error;
1281: end if;
1282: CLOSE csr_filing_status;
1283: --
1276: FETCH csr_filing_status into l_filing_status;
1277: IF csr_filing_status%NOTFOUND then
1278: hr_utility.set_message(801,'HR_6091_DEF_MISSING_LOOKUPS');
1279: hr_utility.set_message_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
1280: hr_utility.raise_error;
1281: end if;
1282: CLOSE csr_filing_status;
1283: --
1284: -- check if entering resident record which will require default
1304: --
1305: -- get county school district /* Why? if it is going to be at
1306: -- the city level then there is no point. No longer defaulting.
1307: --
1308: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',2);
1309: --OPEN csr_get_county_sd;
1310: --FETCH csr_get_county_sd INTO l_county_sd_code;
1311: --CLOSE csr_get_county_sd;
1312: --
1314:
1315: --
1316: -- Insert Local County Tax record
1317: --
1318: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',3);
1319: PAY_US_EMP_TAX_RULES_PKG.Insert_Row(
1320: X_Rowid => l_temp,
1321: X_Assignment_Extra_Info_Id => l_id,
1322: X_Assignment_Id => P_assignment_id,
1370: THEN
1371: --
1372: -- get city school district
1373: --
1374: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',4);
1375: /* Commenting out the defaulting of school district to take care of
1376: Bug 643121 */
1377: -- OPEN csr_get_city_sd;
1378: -- FETCH csr_get_city_sd INTO l_city_sd_code;
1380: --
1381: --
1382: -- Insert Local Tax record
1383: --
1384: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',5);
1385: PAY_US_EMP_TAX_RULES_PKG.Insert_Row(
1386: X_Rowid => l_temp,
1387: X_Assignment_Extra_Info_Id => l_id,
1388: X_Assignment_Id => P_assignment_id,
1410: X_Aei_Information18 => Null,
1411: X_Aei_Information19 => Null,
1412: X_Aei_Information20 => Null);
1413: --
1414: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',6);
1415: --
1416: END IF; -- IF (SUBSTR(p_locality_code, 8,4) <> '0000')
1417: --
1418: pay_us_emp_tax_rules_pkg.create_vertex_entry(
1423: P_jurisdiction => P_locality_code,
1424: P_time_in_locality => P_time_in_local,
1425: P_remainder_percent => NULL);
1426: --
1427: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',7);
1428: --
1429: RETURN l_id;
1430: --
1431: END insert_def_loc_rec;
1437: BEGIN
1438: --
1439: -- Get State code and Locality from the Address
1440: --
1441: -- hr_utility.trace_on;
1442: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',1);
1443: X_error := 'Y';
1444: get_def_state_local(P_assignment_id => X_assignment_id,
1445: P_session_date => X_session_date,
1438: --
1439: -- Get State code and Locality from the Address
1440: --
1441: -- hr_utility.trace_on;
1442: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',1);
1443: X_error := 'Y';
1444: get_def_state_local(P_assignment_id => X_assignment_id,
1445: P_session_date => X_session_date,
1446: P_res_state => X_resident_state,
1453: P_work_loc_name => X_work_loc_name,
1454: P_resident_loc_name => X_resident_loc_name,
1455: P_work_county_name => l_work_county_name,/*391886*/
1456: P_resident_county_name => l_resident_county_name);
1457: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',2);
1458: -- Check
1459: --
1460: --
1461: IF (X_res_state_code is not null AND
1511: END IF;
1512: --
1513: -- Locality
1514: --
1515: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',3);
1516: --
1517: -- if PW locality and PR locality are different insert one
1518: -- locality record for each
1519: --
1543: l_resident_county_name,
1544: 100,
1545: p_resident_flag => 'Y');
1546: END IF;
1547: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',4);
1548: --
1549: ELSE -- (IF csr_check_federal%NOTFOUND)
1550: --
1551: -- Check whether states exist
1553: OPEN csr_check_state (X_work_state_code);
1554: FETCH csr_check_state INTO l_ret;
1555: IF csr_check_state%NOTFOUND
1556: THEN
1557: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',5);
1558: l_time_in_state := '0';
1559: l_ret := insert_def_state_rec(X_assignment_id,
1560: X_work_state_code,
1561: X_session_date,
1563: '0');
1564: END IF;
1565: CLOSE csr_check_state;
1566: --
1567: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',6);
1568: IF X_work_state_code <> X_res_state_code
1569: THEN
1570: OPEN csr_check_state (X_res_state_code);
1571: FETCH csr_check_state INTO l_ret;
1578: '0');
1579: END IF;
1580: CLOSE csr_check_state;
1581: END IF;
1582: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',7);
1583: --
1584: IF X_resident_locality is not null
1585: THEN
1586: OPEN csr_check_local(X_res_state_code, X_resident_locality);
1597: p_resident_flag => 'Y');
1598: END IF;
1599: CLOSE csr_check_local;
1600: END IF;
1601: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',8);
1602: --
1603: IF (X_work_locality is not null AND
1604: (X_work_locality <> X_resident_locality))
1605: THEN
1616: '0');
1617: END IF;
1618: CLOSE csr_check_local;
1619: END IF;
1620: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',9);
1621: --
1622: END IF;
1623: CLOSE csr_check_federal;
1624: X_error := 'N';
1631: --
1632: ELSE
1633: X_error := 'Y';
1634: END IF;
1635: hr_utility.set_location('pay_us_emp_tax_rules_pkg.main_proc',10);
1636: --
1637: END default_tax;
1638:
1639: --
1712: -- MAIN Procedure
1713: --
1714: begin
1715: --
1716: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',1);
1717: --
1718: -- set p_time
1719: --
1720: IF (p_information_type = 'LOCALITY')
1743: --
1744: END LOOP;
1745: --
1746: CLOSE csr_tax_element;
1747: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',4);
1748: --
1749: IF P_inp_2 is null OR P_inp_3 is null OR P_inp_1 is null OR
1750: P_inp_2 = 0 OR P_inp_3 = 0 OR P_inp_1 = 0
1751: THEN
1748: --
1749: IF P_inp_2 is null OR P_inp_3 is null OR P_inp_1 is null OR
1750: P_inp_2 = 0 OR P_inp_3 = 0 OR P_inp_1 = 0
1751: THEN
1752: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1753: hr_utility.set_message_token('1','VERTEX');
1754: hr_utility.raise_error;
1755: END IF;
1756: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',6);
1749: IF P_inp_2 is null OR P_inp_3 is null OR P_inp_1 is null OR
1750: P_inp_2 = 0 OR P_inp_3 = 0 OR P_inp_1 = 0
1751: THEN
1752: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1753: hr_utility.set_message_token('1','VERTEX');
1754: hr_utility.raise_error;
1755: END IF;
1756: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',6);
1757: --
1750: P_inp_2 = 0 OR P_inp_3 = 0 OR P_inp_1 = 0
1751: THEN
1752: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1753: hr_utility.set_message_token('1','VERTEX');
1754: hr_utility.raise_error;
1755: END IF;
1756: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',6);
1757: --
1758: -- Get element link
1752: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1753: hr_utility.set_message_token('1','VERTEX');
1754: hr_utility.raise_error;
1755: END IF;
1756: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',6);
1757: --
1758: -- Get element link
1759: P_element_link_id := hr_entry_api.get_link(
1760: P_assignment_id => P_assignment_id,
1762: P_session_date => P_session_date);
1763: --
1764: IF P_element_link_id is null OR P_element_link_id = 0
1765: THEN
1766: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1767: hr_utility.set_message_token('1','VERTEX');
1768: hr_utility.raise_error;
1769: END IF;
1770: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',7);
1763: --
1764: IF P_element_link_id is null OR P_element_link_id = 0
1765: THEN
1766: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1767: hr_utility.set_message_token('1','VERTEX');
1768: hr_utility.raise_error;
1769: END IF;
1770: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',7);
1771: --
1764: IF P_element_link_id is null OR P_element_link_id = 0
1765: THEN
1766: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1767: hr_utility.set_message_token('1','VERTEX');
1768: hr_utility.raise_error;
1769: END IF;
1770: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',7);
1771: --
1772: -- Store Input value ID into table
1766: hr_utility.set_message(801, 'HR_13140_TAX_ELEMENT_ERROR');
1767: hr_utility.set_message_token('1','VERTEX');
1768: hr_utility.raise_error;
1769: END IF;
1770: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',7);
1771: --
1772: -- Store Input value ID into table
1773: --
1774: inp_value_id_tbl(1) := P_inp_1;
1784: --
1785: OPEN csr_get_eff_date;
1786: FETCH csr_get_eff_date into P_effective_stdt;
1787: if csr_get_eff_date%NOTFOUND then
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1790: hr_utility.set_message_token('STEP','10');
1791: hr_utility.raise_error;
1792: end if;
1785: OPEN csr_get_eff_date;
1786: FETCH csr_get_eff_date into P_effective_stdt;
1787: if csr_get_eff_date%NOTFOUND then
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1790: hr_utility.set_message_token('STEP','10');
1791: hr_utility.raise_error;
1792: end if;
1793: CLOSE csr_get_eff_date;
1786: FETCH csr_get_eff_date into P_effective_stdt;
1787: if csr_get_eff_date%NOTFOUND then
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1790: hr_utility.set_message_token('STEP','10');
1791: hr_utility.raise_error;
1792: end if;
1793: CLOSE csr_get_eff_date;
1794: --
1787: if csr_get_eff_date%NOTFOUND then
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1790: hr_utility.set_message_token('STEP','10');
1791: hr_utility.raise_error;
1792: end if;
1793: CLOSE csr_get_eff_date;
1794: --
1795: OPEN csr_chk_entry;
1802: p_ins_or_upd := 'U';
1803: END IF;
1804: CLOSE csr_chk_entry;
1805:
1806: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',8);
1807: elsif P_mode = 'U' OR p_ins_or_upd = 'U' then
1808: --
1809: -- Get Element entry id
1810: --
1807: elsif P_mode = 'U' OR p_ins_or_upd = 'U' then
1808: --
1809: -- Get Element entry id
1810: --
1811: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',10);
1812: OPEN csr_chk_entry;
1813: FETCH csr_chk_entry into p_element_entry_id, P_effective_stdt;
1814: if csr_chk_entry%NOTFOUND then
1815: --
1815: --
1816: OPEN csr_get_eff_date;
1817: FETCH csr_get_eff_date into P_effective_stdt;
1818: if csr_get_eff_date%NOTFOUND then
1819: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1820: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1821: hr_utility.set_message_token('STEP','12');
1822: hr_utility.raise_error;
1823: end if;
1816: OPEN csr_get_eff_date;
1817: FETCH csr_get_eff_date into P_effective_stdt;
1818: if csr_get_eff_date%NOTFOUND then
1819: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1820: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1821: hr_utility.set_message_token('STEP','12');
1822: hr_utility.raise_error;
1823: end if;
1824: CLOSE csr_get_eff_date;
1817: FETCH csr_get_eff_date into P_effective_stdt;
1818: if csr_get_eff_date%NOTFOUND then
1819: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1820: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1821: hr_utility.set_message_token('STEP','12');
1822: hr_utility.raise_error;
1823: end if;
1824: CLOSE csr_get_eff_date;
1825: p_ins_or_upd := 'I';
1818: if csr_get_eff_date%NOTFOUND then
1819: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1820: hr_utility.set_message_token('PROCEDURE','ASG ELE ENTRY CREATION');
1821: hr_utility.set_message_token('STEP','12');
1822: hr_utility.raise_error;
1823: end if;
1824: CLOSE csr_get_eff_date;
1825: p_ins_or_upd := 'I';
1826: else
1845: --
1846: -- Check whether to insert or Update
1847: --
1848: if P_ins_or_upd = 'I' then
1849: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',14);
1850: hr_entry_api.insert_element_entry(
1851: p_effective_start_date => P_effective_stdt,
1852: p_effective_end_date => p_effective_end_date,
1853: p_element_entry_id => p_element_entry_id,
1858: p_num_entry_values => 3,
1859: p_input_value_id_tbl => inp_value_id_tbl,
1860: p_entry_value_tbl => scr_valuetbl);
1861: elsif P_ins_or_upd = 'U' then
1862: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',16);
1863: hr_entry_api.update_element_entry(
1864: p_dt_update_mode => 'CORRECTION',
1865: p_session_date => P_effective_stdt,
1866: p_element_entry_id => p_element_entry_id,
1931: -- MAIN Procedure
1932: --
1933: begin
1934: --
1935: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_ele_ent',1);
1936: OPEN csr_wc_element;
1937: LOOP
1938: FETCH csr_wc_element INTO p_element_type_id,
1939: P_inp, P_iname;
1948: --
1949: END LOOP;
1950: --
1951: CLOSE csr_wc_element;
1952: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',4);
1953: --
1954: IF P_inp_1 = 0 OR P_inp_2 = 0 OR P_inp_2 is null OR P_inp_1 is null
1955: THEN
1956: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1952: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',4);
1953: --
1954: IF P_inp_1 = 0 OR P_inp_2 = 0 OR P_inp_2 is null OR P_inp_1 is null
1955: THEN
1956: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1957: hr_utility.raise_error;
1958: END IF;
1959: --
1960: -- Get element link
1953: --
1954: IF P_inp_1 = 0 OR P_inp_2 = 0 OR P_inp_2 is null OR P_inp_1 is null
1955: THEN
1956: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1957: hr_utility.raise_error;
1958: END IF;
1959: --
1960: -- Get element link
1961: --
1965: P_session_date => P_session_date);
1966: --
1967: IF P_element_link_id is null OR P_element_link_id = 0
1968: THEN
1969: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1970: hr_utility.raise_error;
1971: END IF;
1972: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',5);
1973: --
1966: --
1967: IF P_element_link_id is null OR P_element_link_id = 0
1968: THEN
1969: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1970: hr_utility.raise_error;
1971: END IF;
1972: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',5);
1973: --
1974: -- Store Input value ID into table
1968: THEN
1969: hr_utility.set_message(801, 'HR_7713_TAX_ELEMENT_ERROR');
1970: hr_utility.raise_error;
1971: END IF;
1972: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.Ele_entry',5);
1973: --
1974: -- Store Input value ID into table
1975: --
1976: inp_value_id_tbl(1) := P_inp_1;
1996: if P_effective_stdt is null OR p_ins_or_upd = 'I' then
1997: OPEN csr_get_eff_date;
1998: FETCH csr_get_eff_date into P_effective_stdt;
1999: if csr_get_eff_date%NOTFOUND then
2000: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2001: hr_utility.set_message_token('PROCEDURE','ASG WC ELE ENTRY CREATION');
2002: hr_utility.set_message_token('STEP','10');
2003: hr_utility.raise_error;
2004: end if;
1997: OPEN csr_get_eff_date;
1998: FETCH csr_get_eff_date into P_effective_stdt;
1999: if csr_get_eff_date%NOTFOUND then
2000: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2001: hr_utility.set_message_token('PROCEDURE','ASG WC ELE ENTRY CREATION');
2002: hr_utility.set_message_token('STEP','10');
2003: hr_utility.raise_error;
2004: end if;
2005: CLOSE csr_get_eff_date;
1998: FETCH csr_get_eff_date into P_effective_stdt;
1999: if csr_get_eff_date%NOTFOUND then
2000: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2001: hr_utility.set_message_token('PROCEDURE','ASG WC ELE ENTRY CREATION');
2002: hr_utility.set_message_token('STEP','10');
2003: hr_utility.raise_error;
2004: end if;
2005: CLOSE csr_get_eff_date;
2006: end if;
1999: if csr_get_eff_date%NOTFOUND then
2000: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2001: hr_utility.set_message_token('PROCEDURE','ASG WC ELE ENTRY CREATION');
2002: hr_utility.set_message_token('STEP','10');
2003: hr_utility.raise_error;
2004: end if;
2005: CLOSE csr_get_eff_date;
2006: end if;
2007: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',8);
2003: hr_utility.raise_error;
2004: end if;
2005: CLOSE csr_get_eff_date;
2006: end if;
2007: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',8);
2008: --
2009: --
2010: -- Check whether to insert or Update
2011: --
2009: --
2010: -- Check whether to insert or Update
2011: --
2012: if P_ins_or_upd = 'I' then
2013: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',14);
2014: hr_entry_api.insert_element_entry(
2015: p_effective_start_date => P_effective_stdt,
2016: p_effective_end_date => p_effective_end_date,
2017: p_element_entry_id => p_element_entry_id,
2022: p_num_entry_values => 2,
2023: p_input_value_id_tbl => inp_value_id_tbl,
2024: p_entry_value_tbl => scr_valuetbl);
2025: elsif P_ins_or_upd = 'U' then
2026: hr_utility.set_location('PAY_US_EMP_TAX_RULES_PKG.WC_Ele_entry',16);
2027: hr_entry_api.update_element_entry(
2028: p_dt_update_mode => 'CORRECTION',
2029: p_session_date => P_effective_stdt,
2030: p_element_entry_id => p_element_entry_id,
2093: X_Aei_Information18 => p_Aei_Information18 ,
2094: X_Aei_Information19 => p_Aei_Information19 ,
2095: X_Aei_Information20 => p_Aei_Information20);
2096: --
2097: hr_utility.set_location('pay_us_emp_tax_rules_pkg.on_insert',11);
2098: pay_us_emp_tax_rules_pkg.create_vertex_entry(
2099: P_mode => 'I',
2100: P_assignment_id => p_assignment_id,
2101: P_information_type => p_information_type,
2246: IS
2247:
2248: BEGIN
2249: --
2250: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute '||p_assignment_id||' '||p_jurisdiction,0);
2251: IF p_attribute_type = 'SCHOOL' THEN
2252: UPDATE per_assignment_extra_info
2253: SET aei_information9 = p_new_value
2254: where rowid = p_rowid;
2251: IF p_attribute_type = 'SCHOOL' THEN
2252: UPDATE per_assignment_extra_info
2253: SET aei_information9 = p_new_value
2254: where rowid = p_rowid;
2255: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute',1);
2256: --
2257: ELSIF p_attribute_type = 'PERCENT TIME' THEN
2258: /* for Locality */
2259: UPDATE per_assignment_extra_info
2267: SET aei_information13 = p_new_value
2268: WHERE information_type = 'STATE'
2269: AND aei_information1 = p_state_abbrev
2270: AND assignment_id = p_assignment_id;
2271: hr_utility.set_location('pay_us_emp_tax_rules_pkg.update_attribute',2);
2272: --
2273: /* for Federal update the SUI state */
2274: UPDATE per_assignment_extra_info
2275: SET aei_information18 = substr(p_jurisdiction,1,2)||'-000-0000'
2377:
2378: --
2379: BEGIN /* BEGIN DEFAULT TAX WITH VALIDATION */
2380: --
2381: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',0);
2382: IF p_from_form = 'Address' THEN
2383: --
2384: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',1);
2385: --
2380: --
2381: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',0);
2382: IF p_from_form = 'Address' THEN
2383: --
2384: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',1);
2385: --
2386: -- Check for primary assignment
2387: --
2388: OPEN csr_qualify_info(p_person_id);
2387: --
2388: OPEN csr_qualify_info(p_person_id);
2389: FETCH csr_qualify_info INTO l_assignment_id;
2390:
2391: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',1.5);
2392: -- If one doesn't exist, or person is not an employee
2393: -- then quit and return to address form(No message)
2394: IF csr_qualify_info%NOTFOUND THEN
2395: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',2);
2391: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',1.5);
2392: -- If one doesn't exist, or person is not an employee
2393: -- then quit and return to address form(No message)
2394: IF csr_qualify_info%NOTFOUND THEN
2395: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',2);
2396: l_return_code := 'No Assignment';
2397: END IF;
2398: --
2399: CLOSE csr_qualify_info;
2399: CLOSE csr_qualify_info;
2400: END IF; /* End of address form specific */
2401: --
2402: IF p_from_form = 'Assignment' OR l_return_code = 'Continue' THEN
2403: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',3);
2404: -- Now check for all information: Payroll, home address
2405: OPEN csr_person_info(p_person_id);
2406: FETCH csr_person_info INTO l_verified;
2407: --
2410: END IF;
2411: -- If one or more of these things does not exist then do not create
2412: -- tax records
2413: IF csr_person_info%NOTFOUND THEN
2414: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',4);
2415: l_return_code := 'Incomplete';
2416: END IF;
2417: CLOSE csr_person_info;
2418: --
2435: X_default_or_get => l_d_or_g,
2436: X_error => l_error,
2437: X_from_form => p_from_form );
2438: --
2439: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',5);
2440: --
2441: -- Check for unvalidated Locations
2442: --
2443: IF l_res_locality is null then
2440: --
2441: -- Check for unvalidated Locations
2442: --
2443: IF l_res_locality is null then
2444: hr_utility.set_message(801,'HR_7556_TAY_NO_RES_ADDRESS');
2445: hr_utility.raise_error;
2446: END IF;
2447:
2448: IF l_work_state IS NULL OR l_error = 'Y' THEN
2441: -- Check for unvalidated Locations
2442: --
2443: IF l_res_locality is null then
2444: hr_utility.set_message(801,'HR_7556_TAY_NO_RES_ADDRESS');
2445: hr_utility.raise_error;
2446: END IF;
2447:
2448: IF l_work_state IS NULL OR l_error = 'Y' THEN
2449: hr_utility.set_message(801, 'HR_7557_TAY_NO_WOK_ADDRESS');
2445: hr_utility.raise_error;
2446: END IF;
2447:
2448: IF l_work_state IS NULL OR l_error = 'Y' THEN
2449: hr_utility.set_message(801, 'HR_7557_TAY_NO_WOK_ADDRESS');
2450: hr_utility.raise_error;
2451: END IF;
2452: --
2453: -- Now if calling form was the assignment then need to set the
2446: END IF;
2447:
2448: IF l_work_state IS NULL OR l_error = 'Y' THEN
2449: hr_utility.set_message(801, 'HR_7557_TAY_NO_WOK_ADDRESS');
2450: hr_utility.raise_error;
2451: END IF;
2452: --
2453: -- Now if calling form was the assignment then need to set the
2454: -- work state and locality to 100%
2452: --
2453: -- Now if calling form was the assignment then need to set the
2454: -- work state and locality to 100%
2455: IF p_from_form = 'Assignment' THEN
2456: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default',6);
2457: -- First check that time in state is less set to zero
2458: --
2459: OPEN csr_chk_percent_state;
2460: FETCH csr_chk_percent_state INTO l_time;
2485: p_jurisdiction => l_work_jurisdiction,
2486: p_state_abbrev => l_work_state_code,
2487: p_assignment_id => l_assignment_id);
2488: --
2489: hr_utility.set_location('pay_us_emp_tax_rules_pkg.validate_default '||l_work_jurisdiction,7);
2490:
2491: --
2492: -- Update the vertex element entry
2493: --
2508: P_jurisdiction => substr(l_work_jurisdiction,1,2)||'-000-0000');
2509: ELSE /* NO tax records exists */
2510: /* Note: This is the same error raised */
2511: /* if there is not location address */
2512: hr_utility.set_message(801, 'HR_7557_TAY_NO_WOK_ADDRESS');
2513: hr_utility.raise_error;
2514: END IF; /* end confirm tax record exists */
2515: END IF; /*Percent time = 0 */
2516: CLOSE csr_chk_percent_state;
2509: ELSE /* NO tax records exists */
2510: /* Note: This is the same error raised */
2511: /* if there is not location address */
2512: hr_utility.set_message(801, 'HR_7557_TAY_NO_WOK_ADDRESS');
2513: hr_utility.raise_error;
2514: END IF; /* end confirm tax record exists */
2515: END IF; /*Percent time = 0 */
2516: CLOSE csr_chk_percent_state;
2517: --
2554: --
2555: l_information_type VARCHAR2(50);
2556:
2557: BEGIN /* Zero out time */
2558: -- hr_utility.trace_on('Y');
2559: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',1);
2560: /* Set all tax records to zero percent time in state */
2561: --
2562: -- Localities
2555: l_information_type VARCHAR2(50);
2556:
2557: BEGIN /* Zero out time */
2558: -- hr_utility.trace_on('Y');
2559: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',1);
2560: /* Set all tax records to zero percent time in state */
2561: --
2562: -- Localities
2563: --
2564: UPDATE per_assignment_extra_info
2565: SET aei_information10 = 0
2566: WHERE assignment_id = p_assignment_id
2567: AND INFORMATION_TYPE = 'LOCALITY';
2568: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',5);
2569: --
2570: -- States
2571: --
2572: UPDATE per_assignment_extra_info
2615: P_remainder_percent => '0');
2616: --
2617: END LOOP;
2618: --
2619: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',10);
2620: -- hr_utility.trace_off;
2621: END; /* zero out time */
2622: --
2623: END pay_us_emp_tax_rules_pkg;
2616: --
2617: END LOOP;
2618: --
2619: hr_utility.set_location('pay_us_emp_tax_rules_pkg.zero_out',10);
2620: -- hr_utility.trace_off;
2621: END; /* zero out time */
2622: --
2623: END pay_us_emp_tax_rules_pkg;