[Home] [Help]
96: ln_step NUMBER;
97:
98: BEGIN
99: lv_procedure_name := '.get_payroll_action_info';
100: hr_utility.set_location(gv_package || lv_procedure_name, 10);
101: ln_step := 1;
102: open c_payroll_action_info(p_payroll_action_id);
103: fetch c_payroll_action_info into ld_end_date,
104: ld_start_date,
107: ln_cons_set_id,
108: ln_payroll_id;
109: close c_payroll_action_info;
110:
111: hr_utility.set_location(gv_package || lv_procedure_name, 30);
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;
114: p_business_group_id := ln_business_group_id;
115: p_cons_set_id := ln_cons_set_id;
114: p_business_group_id := ln_business_group_id;
115: p_cons_set_id := ln_cons_set_id;
116: p_state_abbrev := lv_state_abbrev;
117: p_payroll_id := ln_payroll_id;
118: hr_utility.set_location(gv_package || lv_procedure_name, 50);
119: ln_step := 2;
120:
121: EXCEPTION
122: when others then
122: when others then
123: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
124: gv_package || lv_procedure_name;
125:
126: hr_utility.trace(lv_error_message || '-' || sqlerrm);
127:
128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
130: hr_utility.raise_error;
124: gv_package || lv_procedure_name;
125:
126: hr_utility.trace(lv_error_message || '-' || sqlerrm);
127:
128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
130: hr_utility.raise_error;
131:
132: END get_payroll_action_info;
125:
126: hr_utility.trace(lv_error_message || '-' || sqlerrm);
127:
128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
130: hr_utility.raise_error;
131:
132: END get_payroll_action_info;
133:
126: hr_utility.trace(lv_error_message || '-' || sqlerrm);
127:
128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
130: hr_utility.raise_error;
131:
132: END get_payroll_action_info;
133:
134:
543: ,p_effective_date => p_effective_date);
544:
545: if ltr_sit_tax_bal.count > 0 then
546: for i in ltr_sit_tax_bal.first .. ltr_sit_tax_bal.last loop
547: hr_utility.trace('balance name='||ltr_sit_tax_bal(i).balance_name);
548: hr_utility.trace('input name='||ltr_sit_tax_bal(i).input_value_id);
549: hr_utility.trace('YTD Def Bal ='||ltr_sit_tax_bal(i).ytd_def_bal_id);
550: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
551: hr_utility.raise_error;
544:
545: if ltr_sit_tax_bal.count > 0 then
546: for i in ltr_sit_tax_bal.first .. ltr_sit_tax_bal.last loop
547: hr_utility.trace('balance name='||ltr_sit_tax_bal(i).balance_name);
548: hr_utility.trace('input name='||ltr_sit_tax_bal(i).input_value_id);
549: hr_utility.trace('YTD Def Bal ='||ltr_sit_tax_bal(i).ytd_def_bal_id);
550: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
551: hr_utility.raise_error;
552: end if;
545: if ltr_sit_tax_bal.count > 0 then
546: for i in ltr_sit_tax_bal.first .. ltr_sit_tax_bal.last loop
547: hr_utility.trace('balance name='||ltr_sit_tax_bal(i).balance_name);
548: hr_utility.trace('input name='||ltr_sit_tax_bal(i).input_value_id);
549: hr_utility.trace('YTD Def Bal ='||ltr_sit_tax_bal(i).ytd_def_bal_id);
550: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
551: hr_utility.raise_error;
552: end if;
553: end loop;
547: hr_utility.trace('balance name='||ltr_sit_tax_bal(i).balance_name);
548: hr_utility.trace('input name='||ltr_sit_tax_bal(i).input_value_id);
549: hr_utility.trace('YTD Def Bal ='||ltr_sit_tax_bal(i).ytd_def_bal_id);
550: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
551: hr_utility.raise_error;
552: end if;
553: end loop;
554: end if;
555: if ltr_sdi_er_tax_bal.count > 0 then
553: end loop;
554: end if;
555: if ltr_sdi_er_tax_bal.count > 0 then
556: for i in ltr_sdi_er_tax_bal.first .. ltr_sdi_er_tax_bal.last loop
557: hr_utility.trace('balance name='||ltr_sdi_er_tax_bal(i).balance_name);
558: hr_utility.trace('input name='||ltr_sdi_er_tax_bal(i).input_value_id);
559: hr_utility.trace('YTD Def Bal ='||ltr_sdi_er_tax_bal(i).ytd_def_bal_id);
560: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
561: hr_utility.raise_error;
554: end if;
555: if ltr_sdi_er_tax_bal.count > 0 then
556: for i in ltr_sdi_er_tax_bal.first .. ltr_sdi_er_tax_bal.last loop
557: hr_utility.trace('balance name='||ltr_sdi_er_tax_bal(i).balance_name);
558: hr_utility.trace('input name='||ltr_sdi_er_tax_bal(i).input_value_id);
559: hr_utility.trace('YTD Def Bal ='||ltr_sdi_er_tax_bal(i).ytd_def_bal_id);
560: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
561: hr_utility.raise_error;
562: end if;
555: if ltr_sdi_er_tax_bal.count > 0 then
556: for i in ltr_sdi_er_tax_bal.first .. ltr_sdi_er_tax_bal.last loop
557: hr_utility.trace('balance name='||ltr_sdi_er_tax_bal(i).balance_name);
558: hr_utility.trace('input name='||ltr_sdi_er_tax_bal(i).input_value_id);
559: hr_utility.trace('YTD Def Bal ='||ltr_sdi_er_tax_bal(i).ytd_def_bal_id);
560: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
561: hr_utility.raise_error;
562: end if;
563: end loop;
557: hr_utility.trace('balance name='||ltr_sdi_er_tax_bal(i).balance_name);
558: hr_utility.trace('input name='||ltr_sdi_er_tax_bal(i).input_value_id);
559: hr_utility.trace('YTD Def Bal ='||ltr_sdi_er_tax_bal(i).ytd_def_bal_id);
560: if ltr_sit_tax_bal(i).ytd_def_bal_id is null then
561: hr_utility.raise_error;
562: end if;
563: end loop;
564: end if;
565:
636: lv_procedure_name VARCHAR2(100);
637:
638: BEGIN
639: lv_procedure_name := '.range_cursor';
640: hr_utility.set_location(gv_package || lv_procedure_name, 10);
641: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
642: ,p_start_date => ld_start_date
643: ,p_end_date => ld_end_date
644: ,p_business_group_id => ln_business_group_id
644: ,p_business_group_id => ln_business_group_id
645: ,p_state_Abbrev => lv_state_abbrev
646: ,p_cons_set_id => lv_cons_set_id
647: ,p_payroll_id => lv_payroll_id);
648: hr_utility.set_location(gv_package || lv_procedure_name, 20);
649: if lv_cons_set_id is null then
650: lv_cons_set_id := '%';
651: end if;
652:
697: and paa.source_action_id is null
698: and :payroll_action_id is not null
699: order by paf.person_id';
700:
701: hr_utility.set_location(gv_package || lv_procedure_name, 30);
702: p_sqlstr := lv_sql_string;
703: hr_utility.set_location(gv_package || lv_procedure_name, 50);
704:
705: END range_cursor;
699: order by paf.person_id';
700:
701: hr_utility.set_location(gv_package || lv_procedure_name, 30);
702: p_sqlstr := lv_sql_string;
703: hr_utility.set_location(gv_package || lv_procedure_name, 50);
704:
705: END range_cursor;
706:
707:
877: ln_run_prv_tax_unit_id := -1;
878: lv_adj_flag := 'N';
879:
880: ln_step := 1;
881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
883: ,p_start_date => ld_adj_start_date
884: ,p_end_date => ld_adj_end_date
885: ,p_business_group_id => ln_adj_business_group_id
885: ,p_business_group_id => ln_adj_business_group_id
886: ,p_state_abbrev => lv_state_abbrev
887: ,p_cons_set_id => lv_adj_cons_set_id
888: ,p_payroll_id => lv_adj_payroll_id);
889: hr_utility.set_location(gv_package || lv_procedure_name, 20);
890:
891: if lv_adj_cons_set_id is null then
892: lv_adj_cons_set_id := '%';
893: end if;
926: end if;
927:
928:
929: -- Loop for all rows returned for SQL statement.
930: hr_utility.set_location(gv_package || lv_procedure_name, 30);
931: loop
932: if lv_state_abbrev is null then
933: fetch c_get_emp into ln_run_tax_unit_id,
934: ln_run_assignment_id,
942:
943: exit when c_get_emp_state%notfound;
944: end if;
945:
946: hr_utility.set_location(gv_package || lv_procedure_name, 40);
947: hr_utility.trace('Adj Flag = ' || lv_adj_flag);
948: hr_utility.trace('AsgID = ' ||
949: ln_run_assignment_id||'/'||ln_run_prv_assignment_id);
950: hr_utility.trace('Tax Unit ID = ' ||
943: exit when c_get_emp_state%notfound;
944: end if;
945:
946: hr_utility.set_location(gv_package || lv_procedure_name, 40);
947: hr_utility.trace('Adj Flag = ' || lv_adj_flag);
948: hr_utility.trace('AsgID = ' ||
949: ln_run_assignment_id||'/'||ln_run_prv_assignment_id);
950: hr_utility.trace('Tax Unit ID = ' ||
951: ln_run_tax_unit_id||'/'||ln_run_prv_tax_unit_id);
944: end if;
945:
946: hr_utility.set_location(gv_package || lv_procedure_name, 40);
947: hr_utility.trace('Adj Flag = ' || lv_adj_flag);
948: hr_utility.trace('AsgID = ' ||
949: ln_run_assignment_id||'/'||ln_run_prv_assignment_id);
950: hr_utility.trace('Tax Unit ID = ' ||
951: ln_run_tax_unit_id||'/'||ln_run_prv_tax_unit_id);
952: hr_utility.trace('Payroll ID = ' || ln_run_payroll_id);
946: hr_utility.set_location(gv_package || lv_procedure_name, 40);
947: hr_utility.trace('Adj Flag = ' || lv_adj_flag);
948: hr_utility.trace('AsgID = ' ||
949: ln_run_assignment_id||'/'||ln_run_prv_assignment_id);
950: hr_utility.trace('Tax Unit ID = ' ||
951: ln_run_tax_unit_id||'/'||ln_run_prv_tax_unit_id);
952: hr_utility.trace('Payroll ID = ' || ln_run_payroll_id);
953:
954: if (ln_run_assignment_id = ln_run_prv_assignment_id and
948: hr_utility.trace('AsgID = ' ||
949: ln_run_assignment_id||'/'||ln_run_prv_assignment_id);
950: hr_utility.trace('Tax Unit ID = ' ||
951: ln_run_tax_unit_id||'/'||ln_run_prv_tax_unit_id);
952: hr_utility.trace('Payroll ID = ' || ln_run_payroll_id);
953:
954: if (ln_run_assignment_id = ln_run_prv_assignment_id and
955: ln_run_tax_unit_id = ln_run_prv_tax_unit_id) then
956:
953:
954: if (ln_run_assignment_id = ln_run_prv_assignment_id and
955: ln_run_tax_unit_id = ln_run_prv_tax_unit_id) then
956:
957: hr_utility.set_location(gv_package || lv_procedure_name, 41);
958:
959: else
960:
961: hr_utility.set_location(gv_package || lv_procedure_name, 45);
957: hr_utility.set_location(gv_package || lv_procedure_name, 41);
958:
959: else
960:
961: hr_utility.set_location(gv_package || lv_procedure_name, 45);
962: lv_adj_flag := 'N';
963: ln_run_prv_assignment_id := ln_run_assignment_id;
964: ln_run_prv_tax_unit_id := ln_run_tax_unit_id;
965:
971: if c_get_jurisduction_code%notfound then
972: exit;
973: end if;
974:
975: hr_utility.trace('SIT Exists = ' ||
976: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists);
977: hr_utility.trace('SDI ER Exists = ' ||
978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);
979: /* Create an action if the employee is in a state which does not
973: end if;
974:
975: hr_utility.trace('SIT Exists = ' ||
976: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists);
977: hr_utility.trace('SDI ER Exists = ' ||
978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);
979: /* Create an action if the employee is in a state which does not
980: have SIT or SDI Er taxes or if the employee is in MA */
981: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
982: = 'N' or
983: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
984: is null or
985: lv_state_code = '22' then
986: hr_utility.set_location(gv_package || lv_procedure_name, 50);
987: lv_adj_flag := 'Y';
988: exit;
989: end if;
990: end loop;
992: else
993: lv_adj_flag := 'Y';
994: end if;
995:
996: hr_utility.trace('Adj Flag = '||lv_adj_flag );
997: if lv_adj_flag = 'Y' then
998: hr_utility.set_location(gv_package || lv_procedure_name, 60);
999:
1000: select pay_assignment_actions_s.nextval
994: end if;
995:
996: hr_utility.trace('Adj Flag = '||lv_adj_flag );
997: if lv_adj_flag = 'Y' then
998: hr_utility.set_location(gv_package || lv_procedure_name, 60);
999:
1000: select pay_assignment_actions_s.nextval
1001: into ln_adj_action_id
1002: from dual;
1009: ln_run_tax_unit_id,
1010: null,
1011: 'U',
1012: null);
1013: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1010: null,
1011: 'U',
1012: null);
1013: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1018: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1011: 'U',
1012: null);
1013: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1018: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1019:
1012: null);
1013: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1018: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1019:
1020: open c_get_latest_action(ln_run_assignment_id
1013: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1018: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1019:
1020: open c_get_latest_action(ln_run_assignment_id
1021: ,ln_run_tax_unit_id);
1014: hr_utility.trace('ln_run_action_id = ' || ln_run_action_id);
1015: hr_utility.trace('ln_adj_action_id = ' || ln_adj_action_id);
1016: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
1017: hr_utility.trace('ln_run_tax_unit_id = ' || ln_run_tax_unit_id);
1018: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1019:
1020: open c_get_latest_action(ln_run_assignment_id
1021: ,ln_run_tax_unit_id);
1022: fetch c_get_latest_action into ln_max_run_action_id
1027:
1028: lv_serial_number := to_char(ld_run_effective_Date,'ddmmyyyy') ||
1029: ln_max_run_action_id;
1030:
1031: hr_utility.trace('Update Serail Number = ' || lv_serial_number);
1032: update pay_assignment_actions
1033: set serial_number = lv_serial_number
1034: where assignment_action_id = ln_adj_action_id;
1035:
1032: update pay_assignment_actions
1033: set serial_number = lv_serial_number
1034: where assignment_action_id = ln_adj_action_id;
1035:
1036: hr_utility.trace('Insert into temp table ');
1037: insert into pay_us_rpt_totals
1038: (location_id, organization_id, tax_unit_id,
1039: value1, value3)
1040: select
1063: close c_get_emp_state;
1064: end if;
1065:
1066: ln_step := 5;
1067: hr_utility.set_location(gv_package || lv_procedure_name, 300);
1068:
1069: EXCEPTION
1070: when others then
1071: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1070: when others then
1071: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1072: gv_package || lv_procedure_name;
1073:
1074: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1075:
1076: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1077: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1078: hr_utility.raise_error;
1072: gv_package || lv_procedure_name;
1073:
1074: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1075:
1076: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1077: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1078: hr_utility.raise_error;
1079:
1080: END action_creation;
1073:
1074: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1075:
1076: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1077: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1078: hr_utility.raise_error;
1079:
1080: END action_creation;
1081:
1074: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1075:
1076: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1077: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1078: hr_utility.raise_error;
1079:
1080: END action_creation;
1081:
1082:
1121: and action_context_type = 'PPA';
1122: --
1123: BEGIN
1124: --
1125: hr_utility.set_location(gv_package || lv_procedure_name, 1);
1126: lv_procedure_name := '.process_min_chunk';
1127: ld_run_prv_effective_date := to_date('1800/01/01', 'yyyy/mm/dd');
1128: ln_run_prv_payroll_id := -1;
1129: ln_run_prv_consolidation_id := -1;
1145:
1146: if (g_proc_init = FALSE) then
1147:
1148: if p_chunk_number = g_min_chunk then
1149: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1150: open c_get_adj_dates(p_payroll_action_id);
1151: loop
1152: fetch c_get_adj_dates into lr_rowid,
1153: ld_run_effective_date,
1156: if c_get_adj_dates%notfound then
1157: exit;
1158: end if;
1159:
1160: hr_utility.trace('Effective Date = ' ||
1161: ld_run_effective_date||'/'||ld_run_prv_effective_date);
1162: hr_utility.trace('Payroll ID = ' ||
1163: ln_run_payroll_id||'/'||ln_run_prv_payroll_id);
1164: hr_utility.trace('Consolidation Set ID = ' ||
1158: end if;
1159:
1160: hr_utility.trace('Effective Date = ' ||
1161: ld_run_effective_date||'/'||ld_run_prv_effective_date);
1162: hr_utility.trace('Payroll ID = ' ||
1163: ln_run_payroll_id||'/'||ln_run_prv_payroll_id);
1164: hr_utility.trace('Consolidation Set ID = ' ||
1165: ln_run_consolidation_id||'/'||ln_run_prv_consolidation_id);
1166: if (ld_run_effective_date <> ld_run_prv_effective_date or
1160: hr_utility.trace('Effective Date = ' ||
1161: ld_run_effective_date||'/'||ld_run_prv_effective_date);
1162: hr_utility.trace('Payroll ID = ' ||
1163: ln_run_payroll_id||'/'||ln_run_prv_payroll_id);
1164: hr_utility.trace('Consolidation Set ID = ' ||
1165: ln_run_consolidation_id||'/'||ln_run_prv_consolidation_id);
1166: if (ld_run_effective_date <> ld_run_prv_effective_date or
1167: ln_run_prv_payroll_id <> ln_run_payroll_id or
1168: ln_run_prv_consolidation_id <> ln_run_consolidation_id) then
1166: if (ld_run_effective_date <> ld_run_prv_effective_date or
1167: ln_run_prv_payroll_id <> ln_run_payroll_id or
1168: ln_run_prv_consolidation_id <> ln_run_consolidation_id) then
1169:
1170: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1171: ld_run_prv_effective_date := ld_run_effective_date;
1172: ln_run_prv_payroll_id := ln_run_payroll_id;
1173: ln_run_prv_consolidation_id := ln_run_consolidation_id;
1174:
1182: update pay_us_rpt_totals
1183: set value2 = ln_payroll_action_id
1184: where rowid = lr_rowid;
1185: else
1186: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1187: delete from pay_us_rpt_totals
1188: where rowid = lr_rowid;
1189: end if;
1190: end loop;
1263: where ppa.payroll_action_id = paa.payroll_Action_id
1264: and ppa.payroll_action_id = cp_payroll_action_id;
1265:
1266: BEGIN
1267: hr_utility.set_location(gv_package || lv_procedure_name, 1);
1268: lv_procedure_name := '.initialize';
1269: ln_step := 1;
1270:
1271: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1283: open c_get_chunk_date(p_payroll_action_id);
1284: fetch c_get_chunk_date into g_min_chunk;
1285: ln_step := 2;
1286: if c_get_chunk_date%notfound then
1287: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1288: lv_error_message := 'No Assignment Actions were picked by ' ||
1289: 'the Process.';
1290:
1291: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1287: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1288: lv_error_message := 'No Assignment Actions were picked by ' ||
1289: 'the Process.';
1290:
1291: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1292: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
1293: end if;
1294: close c_get_chunk_date;
1295:
1288: lv_error_message := 'No Assignment Actions were picked by ' ||
1289: 'the Process.';
1290:
1291: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1292: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
1293: end if;
1294: close c_get_chunk_date;
1295:
1296: -- initialize pl/sql table
1299:
1300: /* Populate JIT information which is used when doing
1301: balance adjustment */
1302: ln_step := 5;
1303: hr_utility.set_location(gv_package || lv_procedure_name, 15);
1304: pay_us_payroll_utils.populate_jit_information(
1305: p_effective_date => ld_adj_start_date
1306: ,p_get_state => 'Y');
1307:
1308: ln_step := 8;
1309:
1310: exception
1311: when others then
1312: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1313: lv_error_message := 'Error at step ' || ln_step ||
1314: ' in ' || gv_package || lv_procedure_name;
1315: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1316:
1311: when others then
1312: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1313: lv_error_message := 'Error at step ' || ln_step ||
1314: ' in ' || gv_package || lv_procedure_name;
1315: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1316:
1317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1318: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1319: hr_utility.raise_error;
1313: lv_error_message := 'Error at step ' || ln_step ||
1314: ' in ' || gv_package || lv_procedure_name;
1315: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1316:
1317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1318: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1319: hr_utility.raise_error;
1320:
1321: END initialize;
1314: ' in ' || gv_package || lv_procedure_name;
1315: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1316:
1317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1318: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1319: hr_utility.raise_error;
1320:
1321: END initialize;
1322:
1315: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1316:
1317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1318: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1319: hr_utility.raise_error;
1320:
1321: END initialize;
1322:
1323:
1515: lv_sub2_jd_flag VARCHAR2(1) ;
1516: lv_sub_jd_flag VARCHAR2(1) ;
1517: lv_misc_jd_flag VARCHAR2(1) ;
1518: BEGIN
1519: hr_utility.set_location(gv_package || lv_procedure_name, 5);
1520: lv_procedure_name := '.preprocess_run';
1521: ln_bal_value := 0;
1522: ln_badj_bal_value := 0;
1523:
1537: where assignment_action_id = p_assignment_action_id;
1538: --
1539: process_min_chunk(p_payroll_action_id => l_payroll_action_id,
1540: p_chunk_number => l_chunk_number);
1541: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1542:
1543: --
1544: -- The data in pay_us_rpt_totals has been cleanup, so start
1545: -- the balance adjustment process
1558:
1559: open get_asg_run_info(ln_bal_asg_action_id);
1560: fetch get_asg_run_info into ln_run_payroll_id, ln_run_consolidation_id;
1561: if get_asg_run_info%notfound then
1562: hr_utility.trace('Payroll and Consolidation Set Not Found for Run');
1563: hr_utility.raise_error;
1564: end if;
1565: close get_asg_run_info;
1566:
1559: open get_asg_run_info(ln_bal_asg_action_id);
1560: fetch get_asg_run_info into ln_run_payroll_id, ln_run_consolidation_id;
1561: if get_asg_run_info%notfound then
1562: hr_utility.trace('Payroll and Consolidation Set Not Found for Run');
1563: hr_utility.raise_error;
1564: end if;
1565: close get_asg_run_info;
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1563: hr_utility.raise_error;
1564: end if;
1565: close get_asg_run_info;
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1568: hr_utility.trace('ln_assignment_id = ' || ln_assignment_id);
1569: hr_utility.trace('ln_run_payroll_id = '|| ln_run_payroll_id);
1570: hr_utility.trace('ln_run_consolidation_id = '
1571: || ln_run_consolidation_id);
1564: end if;
1565: close get_asg_run_info;
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1568: hr_utility.trace('ln_assignment_id = ' || ln_assignment_id);
1569: hr_utility.trace('ln_run_payroll_id = '|| ln_run_payroll_id);
1570: hr_utility.trace('ln_run_consolidation_id = '
1571: || ln_run_consolidation_id);
1572:
1565: close get_asg_run_info;
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1568: hr_utility.trace('ln_assignment_id = ' || ln_assignment_id);
1569: hr_utility.trace('ln_run_payroll_id = '|| ln_run_payroll_id);
1570: hr_utility.trace('ln_run_consolidation_id = '
1571: || ln_run_consolidation_id);
1572:
1573: -- get New Payroll Action ID and Business Group ID
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1568: hr_utility.trace('ln_assignment_id = ' || ln_assignment_id);
1569: hr_utility.trace('ln_run_payroll_id = '|| ln_run_payroll_id);
1570: hr_utility.trace('ln_run_consolidation_id = '
1571: || ln_run_consolidation_id);
1572:
1573: -- get New Payroll Action ID and Business Group ID
1574: -- for the given sort_date, Payroll and Consolidation Set
1578: ,ln_run_consolidation_id);
1579: fetch csr_get_badj_action into ln_badj_payroll_action_id,
1580: ln_business_group_id;
1581: if csr_get_badj_action%notfound then
1582: hr_utility.trace('ERROR:No Payrol_action_ID found for Sort_Date');
1583: hr_utility.raise_error;
1584: end if;
1585: close csr_get_badj_action;
1586:
1579: fetch csr_get_badj_action into ln_badj_payroll_action_id,
1580: ln_business_group_id;
1581: if csr_get_badj_action%notfound then
1582: hr_utility.trace('ERROR:No Payrol_action_ID found for Sort_Date');
1583: hr_utility.raise_error;
1584: end if;
1585: close csr_get_badj_action;
1586:
1587: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1583: hr_utility.raise_error;
1584: end if;
1585: close csr_get_badj_action;
1586:
1587: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1588: hr_utility.trace('ln_badj_payroll_action_id = ' ||
1589: ln_badj_payroll_action_id);
1590: hr_utility.trace('ln_business_group_id = ' ||
1591: ln_business_group_id);
1584: end if;
1585: close csr_get_badj_action;
1586:
1587: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1588: hr_utility.trace('ln_badj_payroll_action_id = ' ||
1589: ln_badj_payroll_action_id);
1590: hr_utility.trace('ln_business_group_id = ' ||
1591: ln_business_group_id);
1592:
1586:
1587: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1588: hr_utility.trace('ln_badj_payroll_action_id = ' ||
1589: ln_badj_payroll_action_id);
1590: hr_utility.trace('ln_business_group_id = ' ||
1591: ln_business_group_id);
1592:
1593: -- get assignment derived jurisdiction for state
1594: if g_adj_state_code is null then
1595: lv_where_state_code := '%';
1596: else
1597: lv_where_state_code := g_adj_state_code;
1598: end if;
1599: hr_utility.set_location(gv_package || lv_procedure_name, 51);
1600: open csr_chk_state(ln_assignment_id,
1601: ld_run_effective_date,
1602: lv_where_state_code);
1603: loop
1600: open csr_chk_state(ln_assignment_id,
1601: ld_run_effective_date,
1602: lv_where_state_code);
1603: loop
1604: hr_utility.set_location(gv_package || lv_procedure_name, 52);
1605: fetch csr_chk_state into lv_state_code,
1606: lv_jurisdiction;
1607:
1608: exit when csr_chk_state%NOTFOUND;
1612: lv_misc_jd_flag := 'N';
1613: lv_sub2_jd_flag := 'N';
1614: lv_sub_jd_flag := 'N';
1615:
1616: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1617: hr_utility.trace('lv_state_code = ' || lv_state_code);
1618: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1619:
1620: -- Set Context : TAX_UNIT_ID
1613: lv_sub2_jd_flag := 'N';
1614: lv_sub_jd_flag := 'N';
1615:
1616: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1617: hr_utility.trace('lv_state_code = ' || lv_state_code);
1618: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1619:
1620: -- Set Context : TAX_UNIT_ID
1621: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
1614: lv_sub_jd_flag := 'N';
1615:
1616: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1617: hr_utility.trace('lv_state_code = ' || lv_state_code);
1618: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1619:
1620: -- Set Context : TAX_UNIT_ID
1621: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
1622: -- Set Context : JURISDICTION_CODE
1634: ,p_tax_unit_id => ln_tax_unit_id
1635: ,p_assign_id => ln_assignment_id
1636: ,p_type => 'SIT_RS');
1637: end if;
1638: hr_utility.trace('SIT_Exists = ' || lv_sit_exists);
1639:
1640: if lv_sit_exists = 'N' then
1641: if pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.count > 0 then
1642: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1638: hr_utility.trace('SIT_Exists = ' || lv_sit_exists);
1639:
1640: if lv_sit_exists = 'N' then
1641: if pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.count > 0 then
1642: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1643: lv_balance_name
1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;
1645: ln_ytd_def_bal_id
1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;
1651: lv_input_name
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);
1659: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);
1659: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1660:
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);
1659: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1660:
1661: ln_bal_value := 0;
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);
1659: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1660:
1661: ln_bal_value := 0;
1662: ln_bal_value := get_balance_value(
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);
1659: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1660:
1661: ln_bal_value := 0;
1662: ln_bal_value := get_balance_value(
1663: p_defined_balance_id => ln_ytd_def_bal_id
1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;
1681: ln_input_value_id
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);
1687: hr_utility.trace('lv_input_name=' || lv_input_name);
1688: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1681: ln_input_value_id
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);
1687: hr_utility.trace('lv_input_name=' || lv_input_name);
1688: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1689:
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);
1687: hr_utility.trace('lv_input_name=' || lv_input_name);
1688: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1689:
1690: ln_bal_value := 0;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);
1687: hr_utility.trace('lv_input_name=' || lv_input_name);
1688: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1689:
1690: ln_bal_value := 0;
1691: ln_bal_value := get_balance_value(
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);
1687: hr_utility.trace('lv_input_name=' || lv_input_name);
1688: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1689:
1690: ln_bal_value := 0;
1691: ln_bal_value := get_balance_value(
1692: p_defined_balance_id => ln_ytd_def_bal_id
1717: ln_count2 := sub2_input_value_table.count+1;
1718: sub2_input_value_table(ln_count2) := ln_input_value_id;
1719: sub2_entry_value_table(ln_count2) := ln_badj_bal_value;
1720:
1721: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1722: ln_sub2_ele_link_id := hr_entry_api.get_link(
1723: p_assignment_id => ln_assignment_id,
1724: p_element_type_id => ln_element_type_id,
1725: p_session_date => ld_run_effective_date);
1722: ln_sub2_ele_link_id := hr_entry_api.get_link(
1723: p_assignment_id => ln_assignment_id,
1724: p_element_type_id => ln_element_type_id,
1725: p_session_date => ld_run_effective_date);
1726: hr_utility.trace('Link SIT SUBJ 2 ='||ln_sub2_ele_link_id);
1727:
1728: IF (ln_sub2_ele_link_id IS NULL) THEN
1729: hr_utility.set_location(gv_package||lv_procedure_name, 110);
1730: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1725: p_session_date => ld_run_effective_date);
1726: hr_utility.trace('Link SIT SUBJ 2 ='||ln_sub2_ele_link_id);
1727:
1728: IF (ln_sub2_ele_link_id IS NULL) THEN
1729: hr_utility.set_location(gv_package||lv_procedure_name, 110);
1730: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1731: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1732: hr_utility.raise_error;
1733: END IF;
1726: hr_utility.trace('Link SIT SUBJ 2 ='||ln_sub2_ele_link_id);
1727:
1728: IF (ln_sub2_ele_link_id IS NULL) THEN
1729: hr_utility.set_location(gv_package||lv_procedure_name, 110);
1730: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1731: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1732: hr_utility.raise_error;
1733: END IF;
1734:
1727:
1728: IF (ln_sub2_ele_link_id IS NULL) THEN
1729: hr_utility.set_location(gv_package||lv_procedure_name, 110);
1730: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1731: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1732: hr_utility.raise_error;
1733: END IF;
1734:
1735:
1728: IF (ln_sub2_ele_link_id IS NULL) THEN
1729: hr_utility.set_location(gv_package||lv_procedure_name, 110);
1730: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1731: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1732: hr_utility.raise_error;
1733: END IF;
1734:
1735:
1736: else -- SIT_SUBJECT
1733: END IF;
1734:
1735:
1736: else -- SIT_SUBJECT
1737: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1738: if lv_sub_jd_flag = 'N' then
1739: ln_count1 := sub_input_value_table.count+1;
1740: --Set Input Value of Jurisdiction
1741: sub_input_value_table(ln_count1)
1749: ln_count1 := sub_input_value_table.count+1;
1750: sub_input_value_table(ln_count1) := ln_input_value_id;
1751: sub_entry_value_table(ln_count1) := ln_badj_bal_value;
1752:
1753: hr_utility.set_location(gv_package ||
1754: lv_procedure_name, 130);
1755: ln_sub_ele_link_id
1756: := hr_entry_api.get_link(
1757: p_assignment_id => ln_assignment_id,
1756: := hr_entry_api.get_link(
1757: p_assignment_id => ln_assignment_id,
1758: p_element_type_id => ln_element_type_id,
1759: p_session_date => ld_run_effective_date);
1760: hr_utility.trace('Link SIT SUBJ ='||
1761: ln_sub_ele_link_id);
1762: IF ln_sub_ele_link_id IS NULL THEN
1763: hr_utility.set_location(gv_package||
1764: lv_procedure_name,140);
1759: p_session_date => ld_run_effective_date);
1760: hr_utility.trace('Link SIT SUBJ ='||
1761: ln_sub_ele_link_id);
1762: IF ln_sub_ele_link_id IS NULL THEN
1763: hr_utility.set_location(gv_package||
1764: lv_procedure_name,140);
1765: hr_utility.set_message(
1766: 801, 'PY_51132_TXADJ_LINK_MISSING');
1767: hr_utility.set_message_token('ELEMENT',
1761: ln_sub_ele_link_id);
1762: IF ln_sub_ele_link_id IS NULL THEN
1763: hr_utility.set_location(gv_package||
1764: lv_procedure_name,140);
1765: hr_utility.set_message(
1766: 801, 'PY_51132_TXADJ_LINK_MISSING');
1767: hr_utility.set_message_token('ELEMENT',
1768: lv_element_name);
1769: hr_utility.raise_error;
1763: hr_utility.set_location(gv_package||
1764: lv_procedure_name,140);
1765: hr_utility.set_message(
1766: 801, 'PY_51132_TXADJ_LINK_MISSING');
1767: hr_utility.set_message_token('ELEMENT',
1768: lv_element_name);
1769: hr_utility.raise_error;
1770: END IF;
1771:
1765: hr_utility.set_message(
1766: 801, 'PY_51132_TXADJ_LINK_MISSING');
1767: hr_utility.set_message_token('ELEMENT',
1768: lv_element_name);
1769: hr_utility.raise_error;
1770: END IF;
1771:
1772: end if;
1773:
1775: END IF; -- (ln_gross <> 0)
1776: end if;
1777:
1778:
1779: hr_utility.set_location(gv_package||lv_procedure_name, 150);
1780: if sub2_entry_value_table.count > 0 then
1781: for i in sub2_entry_value_table.first ..
1782: sub2_entry_value_table.last loop
1783: hr_utility.trace('SIT2 entry' ||i||' = '||
1779: hr_utility.set_location(gv_package||lv_procedure_name, 150);
1780: if sub2_entry_value_table.count > 0 then
1781: for i in sub2_entry_value_table.first ..
1782: sub2_entry_value_table.last loop
1783: hr_utility.trace('SIT2 entry' ||i||' = '||
1784: sub2_entry_value_table(i));
1785: end loop;
1786: for i in sub2_input_value_table.first ..
1787: sub2_input_value_table.last loop
1784: sub2_entry_value_table(i));
1785: end loop;
1786: for i in sub2_input_value_table.first ..
1787: sub2_input_value_table.last loop
1788: hr_utility.trace('SIT2 input'||i||' = '||
1789: sub2_input_value_table(i));
1790: end loop;
1791:
1792: hr_utility.set_location(gv_package ||
1788: hr_utility.trace('SIT2 input'||i||' = '||
1789: sub2_input_value_table(i));
1790: end loop;
1791:
1792: hr_utility.set_location(gv_package ||
1793: lv_procedure_name, 160);
1794: pay_bal_adjust.adjust_balance(
1795: p_batch_id => ln_badj_payroll_action_id,
1796: p_assignment_id => ln_assignment_id,
1802: end if;
1803: if sub_input_value_table.count > 0 then
1804: for i in sub_entry_value_table.first ..
1805: sub_entry_value_table.last loop
1806: hr_utility.trace('SIT entry' ||i||' = '||
1807: sub_entry_value_table(i));
1808: end loop;
1809: for i in sub_input_value_table.first ..
1810: sub_input_value_table.last loop
1807: sub_entry_value_table(i));
1808: end loop;
1809: for i in sub_input_value_table.first ..
1810: sub_input_value_table.last loop
1811: hr_utility.trace('SIT input'||i||' = '||
1812: sub_input_value_table(i));
1813: end loop;
1814: hr_utility.set_location(gv_package ||
1815: lv_procedure_name, 170);
1810: sub_input_value_table.last loop
1811: hr_utility.trace('SIT input'||i||' = '||
1812: sub_input_value_table(i));
1813: end loop;
1814: hr_utility.set_location(gv_package ||
1815: lv_procedure_name, 170);
1816: pay_bal_adjust.adjust_balance(
1817: p_batch_id => ln_badj_payroll_action_id,
1818: p_assignment_id => ln_assignment_id,
1822: p_input_value_id_tbl => sub_input_value_table,
1823: p_balance_adj_cost_flag => 'N');
1824: end if;
1825:
1826: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1827:
1828: -- initialize tables
1829: sub_input_value_table.delete;
1830: sub2_input_value_table.delete;
1845: lv_sub_jd_flag := 'N';
1846: lv_sub2_jd_flag := 'N';
1847: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
1848: is null then
1849: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1850: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then
1852: lv_balance_name
1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1846: lv_sub2_jd_flag := 'N';
1847: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
1848: is null then
1849: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1850: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then
1852: lv_balance_name
1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1854: ln_ytd_def_bal_id
1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;
1862: ln_input_value_id
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);
1868: hr_utility.trace('lv_input_name=' || lv_input_name);
1869: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1862: ln_input_value_id
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);
1868: hr_utility.trace('lv_input_name=' || lv_input_name);
1869: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1870:
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);
1868: hr_utility.trace('lv_input_name=' || lv_input_name);
1869: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1870:
1871: ln_bal_value := 0;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);
1868: hr_utility.trace('lv_input_name=' || lv_input_name);
1869: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1870:
1871: ln_bal_value := 0;
1872: ln_bal_value := get_balance_value(
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);
1868: hr_utility.trace('lv_input_name=' || lv_input_name);
1869: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1870:
1871: ln_bal_value := 0;
1872: ln_bal_value := get_balance_value(
1873: p_defined_balance_id => ln_ytd_def_bal_id
1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;
1890: ln_input_value_id
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);
1896: hr_utility.trace('lv_input_name=' || lv_input_name);
1897: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1890: ln_input_value_id
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);
1896: hr_utility.trace('lv_input_name=' || lv_input_name);
1897: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1898:
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);
1896: hr_utility.trace('lv_input_name=' || lv_input_name);
1897: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1898:
1899: ln_bal_value := 0;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);
1896: hr_utility.trace('lv_input_name=' || lv_input_name);
1897: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1898:
1899: ln_bal_value := 0;
1900: ln_bal_value := get_balance_value(
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);
1896: hr_utility.trace('lv_input_name=' || lv_input_name);
1897: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
1898:
1899: ln_bal_value := 0;
1900: ln_bal_value := get_balance_value(
1901: p_defined_balance_id => ln_ytd_def_bal_id
1920: ln_count2 := sub2_input_value_table.count+1;
1921: sub2_input_value_table(ln_count2) := ln_input_value_id;
1922: sub2_entry_value_table(ln_count2) := ln_badj_bal_value;
1923:
1924: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1925:
1926: ln_sub2_ele_link_id := hr_entry_api.get_link(
1927: p_assignment_id => ln_assignment_id,
1928: p_element_type_id => ln_element_type_id,
1926: ln_sub2_ele_link_id := hr_entry_api.get_link(
1927: p_assignment_id => ln_assignment_id,
1928: p_element_type_id => ln_element_type_id,
1929: p_session_date => ld_run_effective_date);
1930: hr_utility.trace('Link SDI ER SUBJ 2 ='||ln_sub2_ele_link_id);
1931:
1932: IF (ln_sub2_ele_link_id IS NULL) THEN
1933: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1934: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1929: p_session_date => ld_run_effective_date);
1930: hr_utility.trace('Link SDI ER SUBJ 2 ='||ln_sub2_ele_link_id);
1931:
1932: IF (ln_sub2_ele_link_id IS NULL) THEN
1933: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1934: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1935: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1936: hr_utility.raise_error;
1937: END IF;
1930: hr_utility.trace('Link SDI ER SUBJ 2 ='||ln_sub2_ele_link_id);
1931:
1932: IF (ln_sub2_ele_link_id IS NULL) THEN
1933: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1934: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1935: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1936: hr_utility.raise_error;
1937: END IF;
1938:
1931:
1932: IF (ln_sub2_ele_link_id IS NULL) THEN
1933: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1934: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1935: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1936: hr_utility.raise_error;
1937: END IF;
1938:
1939:
1932: IF (ln_sub2_ele_link_id IS NULL) THEN
1933: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1934: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1935: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1936: hr_utility.raise_error;
1937: END IF;
1938:
1939:
1940: else
1952: ln_count1 := sub_input_value_table.count+1;
1953: sub_input_value_table(ln_count1) := ln_input_value_id;
1954: sub_entry_value_table(ln_count1) := ln_badj_bal_value;
1955:
1956: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1957: ln_sub_ele_link_id := hr_entry_api.get_link(
1958: p_assignment_id => ln_assignment_id,
1959: p_element_type_id => ln_element_type_id,
1960: p_session_date => ld_run_effective_date);
1957: ln_sub_ele_link_id := hr_entry_api.get_link(
1958: p_assignment_id => ln_assignment_id,
1959: p_element_type_id => ln_element_type_id,
1960: p_session_date => ld_run_effective_date);
1961: hr_utility.trace('Link SDI ER SUBJ ='||ln_sub_ele_link_id);
1962: IF (ln_sub_ele_link_id IS NULL) THEN
1963: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1964: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1965: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1959: p_element_type_id => ln_element_type_id,
1960: p_session_date => ld_run_effective_date);
1961: hr_utility.trace('Link SDI ER SUBJ ='||ln_sub_ele_link_id);
1962: IF (ln_sub_ele_link_id IS NULL) THEN
1963: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1964: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1965: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1966: hr_utility.raise_error;
1967: END IF;
1960: p_session_date => ld_run_effective_date);
1961: hr_utility.trace('Link SDI ER SUBJ ='||ln_sub_ele_link_id);
1962: IF (ln_sub_ele_link_id IS NULL) THEN
1963: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1964: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1965: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1966: hr_utility.raise_error;
1967: END IF;
1968:
1961: hr_utility.trace('Link SDI ER SUBJ ='||ln_sub_ele_link_id);
1962: IF (ln_sub_ele_link_id IS NULL) THEN
1963: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1964: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1965: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1966: hr_utility.raise_error;
1967: END IF;
1968:
1969: end if;
1962: IF (ln_sub_ele_link_id IS NULL) THEN
1963: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1964: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1965: hr_utility.set_message_token ('ELEMENT', lv_element_name);
1966: hr_utility.raise_error;
1967: END IF;
1968:
1969: end if;
1970:
1971: end loop; -- of ltr_sdi_er_tax_bal)
1972: END IF; -- (ln_gross <> 0)
1973: end if;
1974:
1975: hr_utility.set_location(gv_package||lv_procedure_name, 240);
1976: if sub2_entry_value_table.count > 0 then
1977: for i in sub2_entry_value_table.first ..
1978: sub2_entry_value_table.last loop
1979: hr_utility.trace('SDI2 entry' ||i||'='||
1975: hr_utility.set_location(gv_package||lv_procedure_name, 240);
1976: if sub2_entry_value_table.count > 0 then
1977: for i in sub2_entry_value_table.first ..
1978: sub2_entry_value_table.last loop
1979: hr_utility.trace('SDI2 entry' ||i||'='||
1980: sub2_entry_value_table(i));
1981: end loop;
1982: for i in sub2_input_value_table.first ..
1983: sub2_input_value_table.last loop
1980: sub2_entry_value_table(i));
1981: end loop;
1982: for i in sub2_input_value_table.first ..
1983: sub2_input_value_table.last loop
1984: hr_utility.trace('SDI2 input'||i||'='||
1985: sub2_input_value_table(i));
1986: end loop;
1987: hr_utility.set_location(gv_package||lv_procedure_name,250);
1988:
1983: sub2_input_value_table.last loop
1984: hr_utility.trace('SDI2 input'||i||'='||
1985: sub2_input_value_table(i));
1986: end loop;
1987: hr_utility.set_location(gv_package||lv_procedure_name,250);
1988:
1989: pay_bal_adjust.adjust_balance(
1990: p_batch_id => ln_badj_payroll_action_id,
1991: p_assignment_id => ln_assignment_id,
1998:
1999: if sub_input_value_table.count > 0 then
2000: for i in sub_entry_value_table.first ..
2001: sub_entry_value_table.last loop
2002: hr_utility.trace('SDI entry'||i||'='||
2003: sub_entry_value_table(i));
2004: end loop;
2005: for i in sub_input_value_table.first ..
2006: sub_input_value_table.last loop
2003: sub_entry_value_table(i));
2004: end loop;
2005: for i in sub_input_value_table.first ..
2006: sub_input_value_table.last loop
2007: hr_utility.trace('SDI input'||i||'='||
2008: sub_input_value_table(i));
2009: end loop;
2010: hr_utility.set_location(gv_package||lv_procedure_name,260);
2011: pay_bal_adjust.adjust_balance(
2006: sub_input_value_table.last loop
2007: hr_utility.trace('SDI input'||i||'='||
2008: sub_input_value_table(i));
2009: end loop;
2010: hr_utility.set_location(gv_package||lv_procedure_name,260);
2011: pay_bal_adjust.adjust_balance(
2012: p_batch_id => ln_badj_payroll_action_id,
2013: p_assignment_id => ln_assignment_id,
2014: p_element_link_id => ln_sub_ele_link_id,
2018: p_balance_adj_cost_flag => 'N');
2019: end if;
2020:
2021:
2022: hr_utility.set_location(gv_package || lv_procedure_name, 270);
2023:
2024:
2025: -- initialize tables
2026: sub_input_value_table.delete;
2028:
2029: sub_entry_value_table.delete;
2030: sub2_entry_value_table.delete;
2031: end if; -- sdi er exists
2032: hr_utility.set_location(gv_package || lv_procedure_name, 300);
2033:
2034: else
2035: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2036: -- For 'MA'
2031: end if; -- sdi er exists
2032: hr_utility.set_location(gv_package || lv_procedure_name, 300);
2033:
2034: else
2035: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2036: -- For 'MA'
2037: -- Compare Work Location Jurisdiction to SUI Jurisdiction
2038: -- IF equal then do balance call and adjust the balance as follow
2039: -- If not then push message into message lines.
2047: lv_sub_jd_flag := 'N';
2048: ln_badj_bal_value := 0;
2049: ln_redu_subj_bal_value := 0;
2050: ln_sdi_er_wage_limit := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
2051: hr_utility.trace('SDI ER Wage Limit = ' || ln_sdi_er_wage_limit);
2052:
2053: open c_get_per_latest_action(ln_assignment_id
2054: ,ln_tax_unit_id);
2055: fetch c_get_per_latest_action into ln_per_max_run_action_id;
2053: open c_get_per_latest_action(ln_assignment_id
2054: ,ln_tax_unit_id);
2055: fetch c_get_per_latest_action into ln_per_max_run_action_id;
2056: close c_get_per_latest_action;
2057: hr_utility.trace('ln_per_max_run_action_id = ' || ln_per_max_run_action_id);
2058:
2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
2060: is not null then
2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2057: hr_utility.trace('ln_per_max_run_action_id = ' || ln_per_max_run_action_id);
2058:
2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
2060: is not null then
2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2062: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then
2064: lv_balance_name
2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2058:
2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
2060: is not null then
2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2062: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then
2064: lv_balance_name
2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2066: ln_ytd_def_bal_id
2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;
2074: ln_input_value_id
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);
2080: hr_utility.trace('lv_input_name=' || lv_input_name);
2081: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2074: ln_input_value_id
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);
2080: hr_utility.trace('lv_input_name=' || lv_input_name);
2081: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2082:
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);
2080: hr_utility.trace('lv_input_name=' || lv_input_name);
2081: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2082:
2083: ln_subj_bal_value := 0;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);
2080: hr_utility.trace('lv_input_name=' || lv_input_name);
2081: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2082:
2083: ln_subj_bal_value := 0;
2084: ln_subj_bal_value := get_balance_value(
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);
2080: hr_utility.trace('lv_input_name=' || lv_input_name);
2081: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2082:
2083: ln_subj_bal_value := 0;
2084: ln_subj_bal_value := get_balance_value(
2085: p_defined_balance_id => ln_ytd_def_bal_id
2083: ln_subj_bal_value := 0;
2084: ln_subj_bal_value := get_balance_value(
2085: p_defined_balance_id => ln_ytd_def_bal_id
2086: ,p_balcall_aaid => ln_per_max_run_action_id);
2087: hr_utility.trace('ln_subj_bal_value =' || ln_subj_bal_value);
2088:
2089: IF ln_subj_bal_value <> 0 THEN
2090: lv_balance_name
2091: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).balance_name;
2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;
2100: ln_input_value_id
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);
2106: hr_utility.trace('lv_input_name=' || lv_input_name);
2107: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2100: ln_input_value_id
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);
2106: hr_utility.trace('lv_input_name=' || lv_input_name);
2107: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2108:
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);
2106: hr_utility.trace('lv_input_name=' || lv_input_name);
2107: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2108:
2109: ln_pre_tax_bal_value := 0;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);
2106: hr_utility.trace('lv_input_name=' || lv_input_name);
2107: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2108:
2109: ln_pre_tax_bal_value := 0;
2110: ln_pre_tax_bal_value := get_balance_value(
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);
2106: hr_utility.trace('lv_input_name=' || lv_input_name);
2107: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2108:
2109: ln_pre_tax_bal_value := 0;
2110: ln_pre_tax_bal_value := get_balance_value(
2111: p_defined_balance_id => ln_ytd_def_bal_id
2109: ln_pre_tax_bal_value := 0;
2110: ln_pre_tax_bal_value := get_balance_value(
2111: p_defined_balance_id => ln_ytd_def_bal_id
2112: ,p_balcall_aaid => ln_per_max_run_action_id);
2113: hr_utility.trace('ln_pre_tax_bal_value =' || ln_pre_tax_bal_value);
2114:
2115: -- Reduced Subject
2116: ln_redu_subj_bal_value := ln_subj_bal_value - ln_pre_tax_bal_value;
2117: hr_utility.trace('ln_redu_subj_bal_value ='||ln_redu_subj_bal_value);
2113: hr_utility.trace('ln_pre_tax_bal_value =' || ln_pre_tax_bal_value);
2114:
2115: -- Reduced Subject
2116: ln_redu_subj_bal_value := ln_subj_bal_value - ln_pre_tax_bal_value;
2117: hr_utility.trace('ln_redu_subj_bal_value ='||ln_redu_subj_bal_value);
2118: lv_balance_name
2119: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).balance_name;
2120: ln_ytd_def_bal_id
2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;
2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;
2128: ln_input_value_id
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);
2134: hr_utility.trace('lv_input_name=' || lv_input_name);
2135: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2128: ln_input_value_id
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);
2134: hr_utility.trace('lv_input_name=' || lv_input_name);
2135: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2136:
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);
2134: hr_utility.trace('lv_input_name=' || lv_input_name);
2135: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2136:
2137: ln_taxable_bal_value := 0;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);
2134: hr_utility.trace('lv_input_name=' || lv_input_name);
2135: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2136:
2137: ln_taxable_bal_value := 0;
2138: ln_taxable_bal_value := get_balance_value(
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);
2134: hr_utility.trace('lv_input_name=' || lv_input_name);
2135: hr_utility.trace('ln_input_value_id =' || ln_input_value_id);
2136:
2137: ln_taxable_bal_value := 0;
2138: ln_taxable_bal_value := get_balance_value(
2139: p_defined_balance_id => ln_ytd_def_bal_id
2137: ln_taxable_bal_value := 0;
2138: ln_taxable_bal_value := get_balance_value(
2139: p_defined_balance_id => ln_ytd_def_bal_id
2140: ,p_balcall_aaid => ln_per_max_run_action_id);
2141: hr_utility.trace('ln_taxable_bal_value =' || ln_taxable_bal_value);
2142: END IF; -- (ln_sub whable <> 0)
2143: end if; --count > 0
2144:
2145:
2142: END IF; -- (ln_sub whable <> 0)
2143: end if; --count > 0
2144:
2145:
2146: hr_utility.trace('TAXXABLE = ' || ln_taxable_bal_value);
2147: hr_utility.trace('WAGE LIMIT = ' || ln_sdi_er_wage_limit);
2148: hr_utility.trace('RED SUBJ = ' || ln_redu_subj_bal_value);
2149: if ln_taxable_bal_value < ln_sdi_er_wage_limit then
2150: ln_badj_bal_value := (least(ln_sdi_er_wage_limit,
2143: end if; --count > 0
2144:
2145:
2146: hr_utility.trace('TAXXABLE = ' || ln_taxable_bal_value);
2147: hr_utility.trace('WAGE LIMIT = ' || ln_sdi_er_wage_limit);
2148: hr_utility.trace('RED SUBJ = ' || ln_redu_subj_bal_value);
2149: if ln_taxable_bal_value < ln_sdi_er_wage_limit then
2150: ln_badj_bal_value := (least(ln_sdi_er_wage_limit,
2151: ln_redu_subj_bal_value)
2144:
2145:
2146: hr_utility.trace('TAXXABLE = ' || ln_taxable_bal_value);
2147: hr_utility.trace('WAGE LIMIT = ' || ln_sdi_er_wage_limit);
2148: hr_utility.trace('RED SUBJ = ' || ln_redu_subj_bal_value);
2149: if ln_taxable_bal_value < ln_sdi_er_wage_limit then
2150: ln_badj_bal_value := (least(ln_sdi_er_wage_limit,
2151: ln_redu_subj_bal_value)
2152: - ln_taxable_bal_value);
2170: ln_count3 := misc_input_value_table.count+1;
2171: misc_input_value_table(ln_count3) := ln_input_value_id;
2172: misc_entry_value_table(ln_count3) := ln_badj_bal_value;
2173:
2174: hr_utility.set_location(gv_package||lv_procedure_name,180);
2175:
2176: ln_misc_ele_link_id := hr_entry_api.get_link(
2177: p_assignment_id => ln_assignment_id,
2178: p_element_type_id => ln_element_type_id,
2176: ln_misc_ele_link_id := hr_entry_api.get_link(
2177: p_assignment_id => ln_assignment_id,
2178: p_element_type_id => ln_element_type_id,
2179: p_session_date => ld_run_effective_date);
2180: hr_utility.trace('Link MISC1 ER ='||ln_misc_ele_link_id);
2181:
2182: IF (ln_misc_ele_link_id IS NULL) THEN
2183: hr_utility.set_location(gv_package ||
2184: lv_procedure_name, 40);
2179: p_session_date => ld_run_effective_date);
2180: hr_utility.trace('Link MISC1 ER ='||ln_misc_ele_link_id);
2181:
2182: IF (ln_misc_ele_link_id IS NULL) THEN
2183: hr_utility.set_location(gv_package ||
2184: lv_procedure_name, 40);
2185: hr_utility.set_message(801,
2186: 'PY_51132_TXADJ_LINK_MISSING');
2187: hr_utility.set_message_token ('ELEMENT',
2181:
2182: IF (ln_misc_ele_link_id IS NULL) THEN
2183: hr_utility.set_location(gv_package ||
2184: lv_procedure_name, 40);
2185: hr_utility.set_message(801,
2186: 'PY_51132_TXADJ_LINK_MISSING');
2187: hr_utility.set_message_token ('ELEMENT',
2188: lv_element_name);
2189: hr_utility.raise_error;
2183: hr_utility.set_location(gv_package ||
2184: lv_procedure_name, 40);
2185: hr_utility.set_message(801,
2186: 'PY_51132_TXADJ_LINK_MISSING');
2187: hr_utility.set_message_token ('ELEMENT',
2188: lv_element_name);
2189: hr_utility.raise_error;
2190: END IF;
2191:
2185: hr_utility.set_message(801,
2186: 'PY_51132_TXADJ_LINK_MISSING');
2187: hr_utility.set_message_token ('ELEMENT',
2188: lv_element_name);
2189: hr_utility.raise_error;
2190: END IF;
2191:
2192: end if;
2193:
2190: END IF;
2191:
2192: end if;
2193:
2194: hr_utility.set_location(gv_package||lv_procedure_name, 150);
2195: if misc_entry_value_table.count > 0 then
2196: for i in misc_entry_value_table.first ..
2197: misc_entry_value_table.last loop
2198: hr_utility.trace('SDI entry' ||i||'='||
2194: hr_utility.set_location(gv_package||lv_procedure_name, 150);
2195: if misc_entry_value_table.count > 0 then
2196: for i in misc_entry_value_table.first ..
2197: misc_entry_value_table.last loop
2198: hr_utility.trace('SDI entry' ||i||'='||
2199: misc_entry_value_table(i));
2200: end loop;
2201: end if;
2202: if misc_input_value_table.count > 0 then
2201: end if;
2202: if misc_input_value_table.count > 0 then
2203: for i in misc_input_value_table.first ..
2204: misc_input_value_table.last loop
2205: hr_utility.trace('SDI input'||i||'='|| misc_input_value_table(i));
2206: end loop;
2207: end if;
2208:
2209: if ln_badj_bal_value <> 0 then
2215: p_entry_value_tbl => misc_entry_value_table,
2216: p_input_value_id_tbl => misc_input_value_table,
2217: p_balance_adj_cost_flag => 'N');
2218:
2219: hr_utility.set_location(gv_package || lv_procedure_name, 200);
2220: end if;
2221: end if;
2222: end if; --misc1 tax er
2223: end if; -- end of State if
2224:
2225:
2226: end loop; --) state jurisdiction loop
2227: close csr_chk_state;
2228: hr_utility.set_location(gv_package || lv_procedure_name, 300);
2229:
2230: ln_step := 5;
2231:
2232: EXCEPTION
2233: when others then
2234: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
2235: gv_package || lv_procedure_name;
2236:
2237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2238:
2239: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2240: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2241: hr_utility.raise_error;
2235: gv_package || lv_procedure_name;
2236:
2237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2238:
2239: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2240: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2241: hr_utility.raise_error;
2242:
2243: END run_preprocess;
2236:
2237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2238:
2239: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2240: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2241: hr_utility.raise_error;
2242:
2243: END run_preprocess;
2244:
2237: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2238:
2239: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2240: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2241: hr_utility.raise_error;
2242:
2243: END run_preprocess;
2244:
2245: begin
2242:
2243: END run_preprocess;
2244:
2245: begin
2246: --hr_utility.trace_on (null, 'BAL');
2247:
2248: gv_package := 'pay_us_emp_baladj_cleanup';
2249: g_proc_init := FALSE;
2250: g_min_chunk := -1;