[Home] [Help]
137:
138: if l_inp_value_id_table(i) = null or
139: l_inp_value_id_table(i) = 0
140: then
141: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
142: fnd_message.set_token('1','VERTEX');
143: fnd_message.raise_error;
144: end if;
145:
138: if l_inp_value_id_table(i) = null or
139: l_inp_value_id_table(i) = 0
140: then
141: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
142: fnd_message.set_token('1','VERTEX');
143: fnd_message.raise_error;
144: end if;
145:
146: end loop;
139: l_inp_value_id_table(i) = 0
140: then
141: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
142: fnd_message.set_token('1','VERTEX');
143: fnd_message.raise_error;
144: end if;
145:
146: end loop;
147:
155: P_session_date => p_effective_start_date);
156:
157: if l_element_link_id is null or l_element_link_id = 0
158: then
159: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
160: fnd_message.set_token('1','VERTEX');
161: fnd_message.raise_error;
162: end if;
163:
156:
157: if l_element_link_id is null or l_element_link_id = 0
158: then
159: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
160: fnd_message.set_token('1','VERTEX');
161: fnd_message.raise_error;
162: end if;
163:
164: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_element_entry'
157: if l_element_link_id is null or l_element_link_id = 0
158: then
159: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
160: fnd_message.set_token('1','VERTEX');
161: fnd_message.raise_error;
162: end if;
163:
164: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_element_entry'
165: ,4);
218: l_delete_flag := 'N';
219: else
220:
221: close csr_ele_entry;
222: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE',
224: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
225: fnd_message.set_token('STEP','1');
226: fnd_message.raise_error;
219: else
220:
221: close csr_ele_entry;
222: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE',
224: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
225: fnd_message.set_token('STEP','1');
226: fnd_message.raise_error;
227:
221: close csr_ele_entry;
222: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE',
224: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
225: fnd_message.set_token('STEP','1');
226: fnd_message.raise_error;
227:
228: end if;
229:
222: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE',
224: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
225: fnd_message.set_token('STEP','1');
226: fnd_message.raise_error;
227:
228: end if;
229:
230: else /* found the element entry id */
243:
244: if csr_get_curr_percnt%NOTFOUND then
245:
246: close csr_get_curr_percnt;
247: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE',
249: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
250: fnd_message.set_token('STEP','2');
251: fnd_message.raise_error;
244: if csr_get_curr_percnt%NOTFOUND then
245:
246: close csr_get_curr_percnt;
247: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE',
249: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
250: fnd_message.set_token('STEP','2');
251: fnd_message.raise_error;
252:
246: close csr_get_curr_percnt;
247: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE',
249: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
250: fnd_message.set_token('STEP','2');
251: fnd_message.raise_error;
252:
253: end if;
254:
247: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE',
249: 'pay_us_emp_dt_tax_rules.maintain_element_entry');
250: fnd_message.set_token('STEP','2');
251: fnd_message.raise_error;
252:
253: end if;
254:
255: close csr_get_curr_percnt;
407:
408: if l_inp_value_id_table(i) = null or
409: l_inp_value_id_table(i) = 0 then
410:
411: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
412: fnd_message.raise_error;
413:
414: end if;
415:
408: if l_inp_value_id_table(i) = null or
409: l_inp_value_id_table(i) = 0 then
410:
411: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
412: fnd_message.raise_error;
413:
414: end if;
415:
416: end loop;
426:
427: if l_element_link_id is null or l_element_link_id = 0
428: then
429:
430: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
431: fnd_message.raise_error;
432:
433: end if;
434:
427: if l_element_link_id is null or l_element_link_id = 0
428: then
429:
430: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
431: fnd_message.raise_error;
432:
433: end if;
434:
435: hr_utility.set_location('pay_us_emp_dt_tax_rules.maintain_wc_ele_entry'
484: l_delete_flag := 'N';
485: else
486:
487: close csr_wc_ele_entry;
488: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
489: fnd_message.set_token('PROCEDURE',
490: 'pay_us_emp_dt_tax_rules.maintain_wc_ele_entry');
491: fnd_message.set_token('STEP','8');
492: fnd_message.raise_error;
485: else
486:
487: close csr_wc_ele_entry;
488: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
489: fnd_message.set_token('PROCEDURE',
490: 'pay_us_emp_dt_tax_rules.maintain_wc_ele_entry');
491: fnd_message.set_token('STEP','8');
492: fnd_message.raise_error;
493:
487: close csr_wc_ele_entry;
488: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
489: fnd_message.set_token('PROCEDURE',
490: 'pay_us_emp_dt_tax_rules.maintain_wc_ele_entry');
491: fnd_message.set_token('STEP','8');
492: fnd_message.raise_error;
493:
494: end if;
495:
488: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
489: fnd_message.set_token('PROCEDURE',
490: 'pay_us_emp_dt_tax_rules.maintain_wc_ele_entry');
491: fnd_message.set_token('STEP','8');
492: fnd_message.raise_error;
493:
494: end if;
495:
496: else /* found the wc element entry id */
658:
659: if l_default_date is null then
660:
661: close csr_get_eff_date;
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE',
664: 'pay_us_emp_dt_tax_rules.create_tax_percentage');
665: fnd_message.set_token('STEP','1');
666: fnd_message.raise_error;
659: if l_default_date is null then
660:
661: close csr_get_eff_date;
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE',
664: 'pay_us_emp_dt_tax_rules.create_tax_percentage');
665: fnd_message.set_token('STEP','1');
666: fnd_message.raise_error;
667:
661: close csr_get_eff_date;
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE',
664: 'pay_us_emp_dt_tax_rules.create_tax_percentage');
665: fnd_message.set_token('STEP','1');
666: fnd_message.raise_error;
667:
668: end if;
669:
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE',
664: 'pay_us_emp_dt_tax_rules.create_tax_percentage');
665: fnd_message.set_token('STEP','1');
666: fnd_message.raise_error;
667:
668: end if;
669:
670: close csr_get_eff_date;
1132: when others then
1133: l_pos := instr(substr(sqlerrm,1,60),'HR_7713_TAX_ELEMENT_ERROR');
1134:
1135: if l_pos = 0 then
1136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1137: fnd_message.set_token('PROCEDURE',
1138: 'pay_us_emp_dt_tax_rules.insert_fed_tax_row - '|| substr(sqlerrm,1,60));
1139: fnd_message.set_token('STEP',to_char(l_step));
1140: fnd_message.raise_error;
1133: l_pos := instr(substr(sqlerrm,1,60),'HR_7713_TAX_ELEMENT_ERROR');
1134:
1135: if l_pos = 0 then
1136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1137: fnd_message.set_token('PROCEDURE',
1138: 'pay_us_emp_dt_tax_rules.insert_fed_tax_row - '|| substr(sqlerrm,1,60));
1139: fnd_message.set_token('STEP',to_char(l_step));
1140: fnd_message.raise_error;
1141:
1135: if l_pos = 0 then
1136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1137: fnd_message.set_token('PROCEDURE',
1138: 'pay_us_emp_dt_tax_rules.insert_fed_tax_row - '|| substr(sqlerrm,1,60));
1139: fnd_message.set_token('STEP',to_char(l_step));
1140: fnd_message.raise_error;
1141:
1142: else
1143: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
1136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1137: fnd_message.set_token('PROCEDURE',
1138: 'pay_us_emp_dt_tax_rules.insert_fed_tax_row - '|| substr(sqlerrm,1,60));
1139: fnd_message.set_token('STEP',to_char(l_step));
1140: fnd_message.raise_error;
1141:
1142: else
1143: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
1144: fnd_message.raise_error;
1139: fnd_message.set_token('STEP',to_char(l_step));
1140: fnd_message.raise_error;
1141:
1142: else
1143: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
1144: fnd_message.raise_error;
1145: end if;
1146: end insert_fed_tax_row;
1147:
1140: fnd_message.raise_error;
1141:
1142: else
1143: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
1144: fnd_message.raise_error;
1145: end if;
1146: end insert_fed_tax_row;
1147:
1148:
1455: p_sta_information29,
1456: p_sta_information30);
1457:
1458: if sql%notfound then
1459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1460: fnd_message.set_token('PROCEDURE',
1461: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1462: fnd_message.set_token('STEP','4');
1463: fnd_message.raise_error;
1456: p_sta_information30);
1457:
1458: if sql%notfound then
1459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1460: fnd_message.set_token('PROCEDURE',
1461: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1462: fnd_message.set_token('STEP','4');
1463: fnd_message.raise_error;
1464: end if;
1458: if sql%notfound then
1459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1460: fnd_message.set_token('PROCEDURE',
1461: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1462: fnd_message.set_token('STEP','4');
1463: fnd_message.raise_error;
1464: end if;
1465:
1466: open csr_get_row_id;
1459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1460: fnd_message.set_token('PROCEDURE',
1461: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1462: fnd_message.set_token('STEP','4');
1463: fnd_message.raise_error;
1464: end if;
1465:
1466: open csr_get_row_id;
1467:
1805: p_cnt_information29,
1806: p_cnt_information30);
1807:
1808: if sql%notfound then
1809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1810: fnd_message.set_token('PROCEDURE',
1811: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1812: fnd_message.set_token('STEP','4');
1813: fnd_message.raise_error;
1806: p_cnt_information30);
1807:
1808: if sql%notfound then
1809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1810: fnd_message.set_token('PROCEDURE',
1811: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1812: fnd_message.set_token('STEP','4');
1813: fnd_message.raise_error;
1814: end if;
1808: if sql%notfound then
1809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1810: fnd_message.set_token('PROCEDURE',
1811: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1812: fnd_message.set_token('STEP','4');
1813: fnd_message.raise_error;
1814: end if;
1815:
1816: open csr_get_row_id;
1809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1810: fnd_message.set_token('PROCEDURE',
1811: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1812: fnd_message.set_token('STEP','4');
1813: fnd_message.raise_error;
1814: end if;
1815:
1816: open csr_get_row_id;
1817:
2166: p_cty_information30);
2167:
2168: if sql%notfound then
2169:
2170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2171: fnd_message.set_token('PROCEDURE',
2172: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2173: fnd_message.set_token('STEP','4');
2174: fnd_message.raise_error;
2167:
2168: if sql%notfound then
2169:
2170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2171: fnd_message.set_token('PROCEDURE',
2172: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2173: fnd_message.set_token('STEP','4');
2174: fnd_message.raise_error;
2175:
2169:
2170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2171: fnd_message.set_token('PROCEDURE',
2172: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2173: fnd_message.set_token('STEP','4');
2174: fnd_message.raise_error;
2175:
2176: end if;
2177:
2170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2171: fnd_message.set_token('PROCEDURE',
2172: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2173: fnd_message.set_token('STEP','4');
2174: fnd_message.raise_error;
2175:
2176: end if;
2177:
2178: open csr_get_row_id;
2428: fed_information30 = p_fed_information30
2429: where rowid = chartorowid(p_row_id);
2430:
2431: if sql%notfound then
2432: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2433: fnd_message.set_token('PROCEDURE',
2434: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2435: fnd_message.set_token('STEP','1');
2436: fnd_message.raise_error;
2429: where rowid = chartorowid(p_row_id);
2430:
2431: if sql%notfound then
2432: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2433: fnd_message.set_token('PROCEDURE',
2434: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2435: fnd_message.set_token('STEP','1');
2436: fnd_message.raise_error;
2437: end if;
2431: if sql%notfound then
2432: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2433: fnd_message.set_token('PROCEDURE',
2434: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2435: fnd_message.set_token('STEP','1');
2436: fnd_message.raise_error;
2437: end if;
2438:
2439: /* Update workers compensation element entry for the sui state in
2432: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2433: fnd_message.set_token('PROCEDURE',
2434: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2435: fnd_message.set_token('STEP','1');
2436: fnd_message.raise_error;
2437: end if;
2438:
2439: /* Update workers compensation element entry for the sui state in
2440: the federal record */
2636: sta_information30 = p_sta_information30
2637: where rowid = chartorowid(p_row_id);
2638:
2639: if sql%notfound then
2640: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2641: fnd_message.set_token('PROCEDURE',
2642: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2643: fnd_message.set_token('STEP','1');
2644: fnd_message.raise_error;
2637: where rowid = chartorowid(p_row_id);
2638:
2639: if sql%notfound then
2640: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2641: fnd_message.set_token('PROCEDURE',
2642: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2643: fnd_message.set_token('STEP','1');
2644: fnd_message.raise_error;
2645: end if;
2639: if sql%notfound then
2640: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2641: fnd_message.set_token('PROCEDURE',
2642: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2643: fnd_message.set_token('STEP','1');
2644: fnd_message.raise_error;
2645: end if;
2646:
2647: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2640: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2641: fnd_message.set_token('PROCEDURE',
2642: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2643: fnd_message.set_token('STEP','1');
2644: fnd_message.raise_error;
2645: end if;
2646:
2647: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2648: ' - updated row', 2);
2841: cnt_information30 = p_cnt_information30
2842: where rowid = chartorowid(p_row_id);
2843:
2844: if sql%notfound then
2845: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2846: fnd_message.set_token('PROCEDURE',
2847: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2848: fnd_message.set_token('STEP','2');
2849: fnd_message.raise_error;
2842: where rowid = chartorowid(p_row_id);
2843:
2844: if sql%notfound then
2845: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2846: fnd_message.set_token('PROCEDURE',
2847: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2848: fnd_message.set_token('STEP','2');
2849: fnd_message.raise_error;
2850: end if;
2844: if sql%notfound then
2845: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2846: fnd_message.set_token('PROCEDURE',
2847: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2848: fnd_message.set_token('STEP','2');
2849: fnd_message.raise_error;
2850: end if;
2851:
2852: if p_school_district_code is not null then
2845: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2846: fnd_message.set_token('PROCEDURE',
2847: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2848: fnd_message.set_token('STEP','2');
2849: fnd_message.raise_error;
2850: end if;
2851:
2852: if p_school_district_code is not null then
2853:
3060: where rowid = chartorowid(p_row_id);
3061:
3062: if sql%notfound then
3063:
3064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3065: fnd_message.set_token('PROCEDURE',
3066: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3067: fnd_message.set_token('STEP','2');
3068: fnd_message.raise_error;
3061:
3062: if sql%notfound then
3063:
3064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3065: fnd_message.set_token('PROCEDURE',
3066: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3067: fnd_message.set_token('STEP','2');
3068: fnd_message.raise_error;
3069:
3063:
3064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3065: fnd_message.set_token('PROCEDURE',
3066: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3067: fnd_message.set_token('STEP','2');
3068: fnd_message.raise_error;
3069:
3070: end if;
3071:
3064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3065: fnd_message.set_token('PROCEDURE',
3066: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3067: fnd_message.set_token('STEP','2');
3068: fnd_message.raise_error;
3069:
3070: end if;
3071:
3072: if p_school_district_code is not null then
3159:
3160: fetch csr_get_eff_date into l_effective_start_date;
3161:
3162: if l_effective_start_date is null then
3163: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3164: fnd_message.set_token('PROCEDURE',
3165: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3166: fnd_message.set_token('STEP','1');
3167: fnd_message.raise_error;
3160: fetch csr_get_eff_date into l_effective_start_date;
3161:
3162: if l_effective_start_date is null then
3163: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3164: fnd_message.set_token('PROCEDURE',
3165: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3166: fnd_message.set_token('STEP','1');
3167: fnd_message.raise_error;
3168: end if;
3162: if l_effective_start_date is null then
3163: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3164: fnd_message.set_token('PROCEDURE',
3165: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3166: fnd_message.set_token('STEP','1');
3167: fnd_message.raise_error;
3168: end if;
3169:
3170: close csr_get_eff_date;
3163: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3164: fnd_message.set_token('PROCEDURE',
3165: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3166: fnd_message.set_token('STEP','1');
3167: fnd_message.raise_error;
3168: end if;
3169:
3170: close csr_get_eff_date;
3171:
3461: fetch csr_asg_rec into l_assignment_id;
3462:
3463: if csr_asg_rec%NOTFOUND then
3464: close csr_asg_rec;
3465: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3466: fnd_message.raise_error;
3467: end if;
3468:
3469: close csr_asg_rec;
3462:
3463: if csr_asg_rec%NOTFOUND then
3464: close csr_asg_rec;
3465: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3466: fnd_message.raise_error;
3467: end if;
3468:
3469: close csr_asg_rec;
3470:
3473: fetch csr_fed_rec into fed_rec;
3474:
3475: if csr_fed_rec%NOTFOUND then
3476: close csr_fed_rec;
3477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3478: fnd_message.set_token('PROCEDURE',
3479: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3480: fnd_message.set_token('STEP', '1');
3481: fnd_message.raise_error;
3474:
3475: if csr_fed_rec%NOTFOUND then
3476: close csr_fed_rec;
3477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3478: fnd_message.set_token('PROCEDURE',
3479: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3480: fnd_message.set_token('STEP', '1');
3481: fnd_message.raise_error;
3482: end if;
3476: close csr_fed_rec;
3477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3478: fnd_message.set_token('PROCEDURE',
3479: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3480: fnd_message.set_token('STEP', '1');
3481: fnd_message.raise_error;
3482: end if;
3483:
3484: close csr_fed_rec;
3477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3478: fnd_message.set_token('PROCEDURE',
3479: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3480: fnd_message.set_token('STEP', '1');
3481: fnd_message.raise_error;
3482: end if;
3483:
3484: close csr_fed_rec;
3485:
3821: return;
3822:
3823: else
3824:
3825: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
3826: fnd_message.raise_error;
3827:
3828: end if;
3829:
3822:
3823: else
3824:
3825: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
3826: fnd_message.raise_error;
3827:
3828: end if;
3829:
3830: end lock_fed_tax_row;
3948: fetch csr_asg_rec into l_assignment_id;
3949:
3950: if csr_asg_rec%NOTFOUND then
3951: close csr_asg_rec;
3952: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3953: fnd_message.raise_error;
3954: end if;
3955:
3956: close csr_asg_rec;
3949:
3950: if csr_asg_rec%NOTFOUND then
3951: close csr_asg_rec;
3952: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3953: fnd_message.raise_error;
3954: end if;
3955:
3956: close csr_asg_rec;
3957:
3960: fetch csr_state_rec into state_rec;
3961:
3962: if csr_state_rec%NOTFOUND then
3963: close csr_state_rec;
3964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3965: fnd_message.set_token('PROCEDURE',
3966: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
3967: fnd_message.set_token('STEP', '1');
3968: fnd_message.raise_error;
3961:
3962: if csr_state_rec%NOTFOUND then
3963: close csr_state_rec;
3964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3965: fnd_message.set_token('PROCEDURE',
3966: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
3967: fnd_message.set_token('STEP', '1');
3968: fnd_message.raise_error;
3969: end if;
3963: close csr_state_rec;
3964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3965: fnd_message.set_token('PROCEDURE',
3966: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
3967: fnd_message.set_token('STEP', '1');
3968: fnd_message.raise_error;
3969: end if;
3970:
3971: close csr_state_rec;
3964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3965: fnd_message.set_token('PROCEDURE',
3966: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
3967: fnd_message.set_token('STEP', '1');
3968: fnd_message.raise_error;
3969: end if;
3970:
3971: close csr_state_rec;
3972:
4309: return;
4310:
4311: else
4312:
4313: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4314: fnd_message.raise_error;
4315:
4316: end if;
4317:
4310:
4311: else
4312:
4313: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4314: fnd_message.raise_error;
4315:
4316: end if;
4317:
4318: end lock_state_tax_row;
4430: fetch csr_asg_rec into l_assignment_id;
4431:
4432: if csr_asg_rec%NOTFOUND then
4433: close csr_asg_rec;
4434: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4435: fnd_message.raise_error;
4436: end if;
4437:
4438: close csr_asg_rec;
4431:
4432: if csr_asg_rec%NOTFOUND then
4433: close csr_asg_rec;
4434: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4435: fnd_message.raise_error;
4436: end if;
4437:
4438: close csr_asg_rec;
4439:
4442: fetch csr_county_rec into county_rec;
4443:
4444: if csr_county_rec%NOTFOUND then
4445: close csr_county_rec;
4446: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4447: fnd_message.set_token('PROCEDURE',
4448: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4449: fnd_message.set_token('STEP', '1');
4450: fnd_message.raise_error;
4443:
4444: if csr_county_rec%NOTFOUND then
4445: close csr_county_rec;
4446: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4447: fnd_message.set_token('PROCEDURE',
4448: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4449: fnd_message.set_token('STEP', '1');
4450: fnd_message.raise_error;
4451: end if;
4445: close csr_county_rec;
4446: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4447: fnd_message.set_token('PROCEDURE',
4448: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4449: fnd_message.set_token('STEP', '1');
4450: fnd_message.raise_error;
4451: end if;
4452:
4453: close csr_county_rec;
4446: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4447: fnd_message.set_token('PROCEDURE',
4448: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4449: fnd_message.set_token('STEP', '1');
4450: fnd_message.raise_error;
4451: end if;
4452:
4453: close csr_county_rec;
4454:
4773: return;
4774:
4775: else
4776:
4777: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4778: fnd_message.raise_error;
4779:
4780: end if;
4781:
4774:
4775: else
4776:
4777: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4778: fnd_message.raise_error;
4779:
4780: end if;
4781:
4782: end lock_county_tax_row;
4896: fetch csr_asg_rec into l_assignment_id;
4897:
4898: if csr_asg_rec%NOTFOUND then
4899: close csr_asg_rec;
4900: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4901: fnd_message.raise_error;
4902: end if;
4903:
4904: close csr_asg_rec;
4897:
4898: if csr_asg_rec%NOTFOUND then
4899: close csr_asg_rec;
4900: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4901: fnd_message.raise_error;
4902: end if;
4903:
4904: close csr_asg_rec;
4905:
4908: fetch csr_city_rec into city_rec;
4909:
4910: if csr_city_rec%NOTFOUND then
4911: close csr_city_rec;
4912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4913: fnd_message.set_token('PROCEDURE',
4914: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4915: fnd_message.set_token('STEP', '1');
4916: fnd_message.raise_error;
4909:
4910: if csr_city_rec%NOTFOUND then
4911: close csr_city_rec;
4912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4913: fnd_message.set_token('PROCEDURE',
4914: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4915: fnd_message.set_token('STEP', '1');
4916: fnd_message.raise_error;
4917: end if;
4911: close csr_city_rec;
4912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4913: fnd_message.set_token('PROCEDURE',
4914: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4915: fnd_message.set_token('STEP', '1');
4916: fnd_message.raise_error;
4917: end if;
4918:
4919: close csr_city_rec;
4912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4913: fnd_message.set_token('PROCEDURE',
4914: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4915: fnd_message.set_token('STEP', '1');
4916: fnd_message.raise_error;
4917: end if;
4918:
4919: close csr_city_rec;
4920:
5242: return;
5243:
5244: else
5245:
5246: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
5247: fnd_message.raise_error;
5248:
5249: end if;
5250:
5243:
5244: else
5245:
5246: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
5247: fnd_message.raise_error;
5248:
5249: end if;
5250:
5251: end lock_city_tax_row;
5312:
5313: fetch csr_filing_status into l_filing_status_code;
5314:
5315: if csr_filing_status%NOTFOUND then
5316: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5317: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5318: fnd_message.raise_error;
5319: end if;
5320:
5313: fetch csr_filing_status into l_filing_status_code;
5314:
5315: if csr_filing_status%NOTFOUND then
5316: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5317: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5318: fnd_message.raise_error;
5319: end if;
5320:
5321: close csr_filing_status;
5314:
5315: if csr_filing_status%NOTFOUND then
5316: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5317: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5318: fnd_message.raise_error;
5319: end if;
5320:
5321: close csr_filing_status;
5322:
5328: fetch csr_eic_fstatus into l_eic_fstatus_code;
5329:
5330: if csr_eic_fstatus%NOTFOUND then
5331:
5332: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5333: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5334: fnd_message.raise_error;
5335:
5336: end if;
5329:
5330: if csr_eic_fstatus%NOTFOUND then
5331:
5332: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5333: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5334: fnd_message.raise_error;
5335:
5336: end if;
5337:
5330: if csr_eic_fstatus%NOTFOUND then
5331:
5332: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5333: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5334: fnd_message.raise_error;
5335:
5336: end if;
5337:
5338: close csr_eic_fstatus;
5748: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_def_county_rec',2);
5749:
5750: if csr_filing_status%NOTFOUND then
5751:
5752: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5753: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5754: fnd_message.raise_error;
5755:
5756: end if;
5749:
5750: if csr_filing_status%NOTFOUND then
5751:
5752: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5753: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5754: fnd_message.raise_error;
5755:
5756: end if;
5757:
5750: if csr_filing_status%NOTFOUND then
5751:
5752: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5753: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5754: fnd_message.raise_error;
5755:
5756: end if;
5757:
5758: close csr_filing_status;
5921: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_def_city_rec',2);
5922:
5923: if csr_filing_status%NOTFOUND then
5924:
5925: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5926: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5927: fnd_message.raise_error;
5928:
5929: end if;
5922:
5923: if csr_filing_status%NOTFOUND then
5924:
5925: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5926: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5927: fnd_message.raise_error;
5928:
5929: end if;
5930:
5923: if csr_filing_status%NOTFOUND then
5924:
5925: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5926: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5927: fnd_message.raise_error;
5928:
5929: end if;
5930:
5931: close csr_filing_status;
6628: fetch csr_get_codes into l_state_code, l_county_code,l_city_code,
6629: l_ovrd_state_code, l_ovrd_county_code,
6630: l_ovrd_city_code;
6631: if csr_get_codes%NOTFOUND then
6632: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6633: fnd_message.set_token('PROCEDURE',
6634: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6635: fnd_message.set_token('STEP','2');
6636: fnd_message.raise_error;
6629: l_ovrd_state_code, l_ovrd_county_code,
6630: l_ovrd_city_code;
6631: if csr_get_codes%NOTFOUND then
6632: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6633: fnd_message.set_token('PROCEDURE',
6634: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6635: fnd_message.set_token('STEP','2');
6636: fnd_message.raise_error;
6637: end if;
6631: if csr_get_codes%NOTFOUND then
6632: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6633: fnd_message.set_token('PROCEDURE',
6634: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6635: fnd_message.set_token('STEP','2');
6636: fnd_message.raise_error;
6637: end if;
6638: close csr_get_codes;
6639:
6632: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6633: fnd_message.set_token('PROCEDURE',
6634: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6635: fnd_message.set_token('STEP','2');
6636: fnd_message.raise_error;
6637: end if;
6638: close csr_get_codes;
6639:
6640: end if;
6646:
6647: fetch csr_get_eff_date into l_default_date;
6648:
6649: if l_default_date is null then
6650: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6651: fnd_message.set_token('PROCEDURE',
6652: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6653: fnd_message.set_token('STEP','1');
6654: fnd_message.raise_error;
6647: fetch csr_get_eff_date into l_default_date;
6648:
6649: if l_default_date is null then
6650: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6651: fnd_message.set_token('PROCEDURE',
6652: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6653: fnd_message.set_token('STEP','1');
6654: fnd_message.raise_error;
6655: end if;
6649: if l_default_date is null then
6650: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6651: fnd_message.set_token('PROCEDURE',
6652: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6653: fnd_message.set_token('STEP','1');
6654: fnd_message.raise_error;
6655: end if;
6656:
6657: close csr_get_eff_date;
6650: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6651: fnd_message.set_token('PROCEDURE',
6652: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6653: fnd_message.set_token('STEP','1');
6654: fnd_message.raise_error;
6655: end if;
6656:
6657: close csr_get_eff_date;
6658:
6677: fetch csr_get_max_assign_end_dt into l_max_assign_end_dt;
6678:
6679:
6680: if csr_get_max_assign_end_dt%NOTFOUND then
6681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6682: fnd_message.set_token('PROCEDURE',
6683: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6684: fnd_message.set_token('STEP','3');
6685: fnd_message.raise_error;
6678:
6679:
6680: if csr_get_max_assign_end_dt%NOTFOUND then
6681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6682: fnd_message.set_token('PROCEDURE',
6683: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6684: fnd_message.set_token('STEP','3');
6685: fnd_message.raise_error;
6686: end if;
6680: if csr_get_max_assign_end_dt%NOTFOUND then
6681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6682: fnd_message.set_token('PROCEDURE',
6683: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6684: fnd_message.set_token('STEP','3');
6685: fnd_message.raise_error;
6686: end if;
6687:
6688: close csr_get_max_assign_end_dt;
6681: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6682: fnd_message.set_token('PROCEDURE',
6683: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6684: fnd_message.set_token('STEP','3');
6685: fnd_message.raise_error;
6686: end if;
6687:
6688: close csr_get_max_assign_end_dt;
6689:
7044:
7045: if l_inp_value_id_table(i) = null or
7046: l_inp_value_id_table(i) = 0
7047: then
7048: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7049: fnd_message.set_token('1','INPUT VALUE');
7050: fnd_message.raise_error;
7051: end if;
7052:
7045: if l_inp_value_id_table(i) = null or
7046: l_inp_value_id_table(i) = 0
7047: then
7048: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7049: fnd_message.set_token('1','INPUT VALUE');
7050: fnd_message.raise_error;
7051: end if;
7052:
7053: end loop;
7046: l_inp_value_id_table(i) = 0
7047: then
7048: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7049: fnd_message.set_token('1','INPUT VALUE');
7050: fnd_message.raise_error;
7051: end if;
7052:
7053: end loop;
7054:
7063: P_session_date => p_session_date);
7064:
7065: if l_element_link_id is null or l_element_link_id = 0
7066: then
7067: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7068: fnd_message.set_token('1','ELEMENT LINK');
7069: fnd_message.raise_error;
7070: end if;
7071:
7064:
7065: if l_element_link_id is null or l_element_link_id = 0
7066: then
7067: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7068: fnd_message.set_token('1','ELEMENT LINK');
7069: fnd_message.raise_error;
7070: end if;
7071:
7072: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_entries_for_dates'
7065: if l_element_link_id is null or l_element_link_id = 0
7066: then
7067: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7068: fnd_message.set_token('1','ELEMENT LINK');
7069: fnd_message.raise_error;
7070: end if;
7071:
7072: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_entries_for_dates'
7073: ,4);
7080:
7081: if csr_ele_entry%NOTFOUND then
7082:
7083: close csr_ele_entry;
7084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7085: fnd_message.set_token('PROCEDURE',
7086: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7087: '- SQLCODE:'|| to_char(sqlcode));
7088: fnd_message.set_token('STEP',to_char(l_step));
7081: if csr_ele_entry%NOTFOUND then
7082:
7083: close csr_ele_entry;
7084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7085: fnd_message.set_token('PROCEDURE',
7086: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7087: '- SQLCODE:'|| to_char(sqlcode));
7088: fnd_message.set_token('STEP',to_char(l_step));
7089: fnd_message.raise_error;
7084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7085: fnd_message.set_token('PROCEDURE',
7086: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7087: '- SQLCODE:'|| to_char(sqlcode));
7088: fnd_message.set_token('STEP',to_char(l_step));
7089: fnd_message.raise_error;
7090:
7091: end if;
7092:
7085: fnd_message.set_token('PROCEDURE',
7086: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7087: '- SQLCODE:'|| to_char(sqlcode));
7088: fnd_message.set_token('STEP',to_char(l_step));
7089: fnd_message.raise_error;
7090:
7091: end if;
7092:
7093: close csr_ele_entry;
7176: end if;
7177:
7178: exception
7179: when others then
7180: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7181: fnd_message.set_token('PROCEDURE',
7182: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7183: '- SQLCODE:'|| to_char(sqlcode));
7184: fnd_message.set_token('STEP',to_char(l_step));
7177:
7178: exception
7179: when others then
7180: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7181: fnd_message.set_token('PROCEDURE',
7182: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7183: '- SQLCODE:'|| to_char(sqlcode));
7184: fnd_message.set_token('STEP',to_char(l_step));
7185: fnd_message.raise_error;
7180: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7181: fnd_message.set_token('PROCEDURE',
7182: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7183: '- SQLCODE:'|| to_char(sqlcode));
7184: fnd_message.set_token('STEP',to_char(l_step));
7185: fnd_message.raise_error;
7186:
7187: end del_updt_entries_for_dates;
7188:
7181: fnd_message.set_token('PROCEDURE',
7182: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7183: '- SQLCODE:'|| to_char(sqlcode));
7184: fnd_message.set_token('STEP',to_char(l_step));
7185: fnd_message.raise_error;
7186:
7187: end del_updt_entries_for_dates;
7188:
7189: /* Name : upd_del_entries
7385: open csr_tax_element;
7386:
7387: fetch csr_tax_element into l_element_type_id;
7388: if csr_tax_element%NOTFOUND then
7389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7390: fnd_message.set_token('PROCEDURE',
7391: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7392: fnd_message.set_token('STEP',to_char(l_step));
7393: fnd_message.raise_error;
7386:
7387: fetch csr_tax_element into l_element_type_id;
7388: if csr_tax_element%NOTFOUND then
7389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7390: fnd_message.set_token('PROCEDURE',
7391: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7392: fnd_message.set_token('STEP',to_char(l_step));
7393: fnd_message.raise_error;
7394: end if;
7388: if csr_tax_element%NOTFOUND then
7389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7390: fnd_message.set_token('PROCEDURE',
7391: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7392: fnd_message.set_token('STEP',to_char(l_step));
7393: fnd_message.raise_error;
7394: end if;
7395:
7396: close csr_tax_element;
7389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7390: fnd_message.set_token('PROCEDURE',
7391: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7392: fnd_message.set_token('STEP',to_char(l_step));
7393: fnd_message.raise_error;
7394: end if;
7395:
7396: close csr_tax_element;
7397:
7405: P_session_date => p_session_date);
7406:
7407: if l_element_link_id is null or l_element_link_id = 0
7408: then
7409: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7410: fnd_message.set_token('1','ELEMENT LINK');
7411: fnd_message.raise_error;
7412: end if;
7413:
7406:
7407: if l_element_link_id is null or l_element_link_id = 0
7408: then
7409: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7410: fnd_message.set_token('1','ELEMENT LINK');
7411: fnd_message.raise_error;
7412: end if;
7413:
7414: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ,3);
7407: if l_element_link_id is null or l_element_link_id = 0
7408: then
7409: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7410: fnd_message.set_token('1','ELEMENT LINK');
7411: fnd_message.raise_error;
7412: end if;
7413:
7414: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ,3);
7415:
7421:
7422: if csr_wc_ele_entry%NOTFOUND then
7423:
7424: close csr_wc_ele_entry;
7425: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7426: fnd_message.set_token('PROCEDURE',
7427: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7428: '- SQLCODE:'|| to_char(sqlcode));
7429: fnd_message.set_token('STEP',to_char(l_step));
7422: if csr_wc_ele_entry%NOTFOUND then
7423:
7424: close csr_wc_ele_entry;
7425: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7426: fnd_message.set_token('PROCEDURE',
7427: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7428: '- SQLCODE:'|| to_char(sqlcode));
7429: fnd_message.set_token('STEP',to_char(l_step));
7430: fnd_message.raise_error;
7425: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7426: fnd_message.set_token('PROCEDURE',
7427: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7428: '- SQLCODE:'|| to_char(sqlcode));
7429: fnd_message.set_token('STEP',to_char(l_step));
7430: fnd_message.raise_error;
7431:
7432: end if;
7433:
7426: fnd_message.set_token('PROCEDURE',
7427: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7428: '- SQLCODE:'|| to_char(sqlcode));
7429: fnd_message.set_token('STEP',to_char(l_step));
7430: fnd_message.raise_error;
7431:
7432: end if;
7433:
7434: close csr_wc_ele_entry;
7494: end if;
7495:
7496: exception
7497: when others then
7498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7499: fnd_message.set_token('PROCEDURE',
7500: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7501: '- SQLCODE:'|| to_char(sqlcode));
7502: fnd_message.set_token('STEP',to_char(l_step));
7495:
7496: exception
7497: when others then
7498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7499: fnd_message.set_token('PROCEDURE',
7500: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7501: '- SQLCODE:'|| to_char(sqlcode));
7502: fnd_message.set_token('STEP',to_char(l_step));
7503: fnd_message.raise_error;
7498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7499: fnd_message.set_token('PROCEDURE',
7500: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7501: '- SQLCODE:'|| to_char(sqlcode));
7502: fnd_message.set_token('STEP',to_char(l_step));
7503: fnd_message.raise_error;
7504:
7505: end del_updt_wc_entry_for_dates;
7506:
7499: fnd_message.set_token('PROCEDURE',
7500: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7501: '- SQLCODE:'|| to_char(sqlcode));
7502: fnd_message.set_token('STEP',to_char(l_step));
7503: fnd_message.raise_error;
7504:
7505: end del_updt_wc_entry_for_dates;
7506:
7507:
7701: fetch csr_get_next_location into l_next_location, l_next_end_date;
7702: if csr_get_next_location%NOTFOUND
7703: then
7704: close csr_get_next_location;
7705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7706: fnd_message.set_token('PROCEDURE',
7707: 'pay_us_emp_dt_tax_rules.pull_percentage');
7708: fnd_message.set_token('STEP','1');
7709: fnd_message.raise_error;
7702: if csr_get_next_location%NOTFOUND
7703: then
7704: close csr_get_next_location;
7705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7706: fnd_message.set_token('PROCEDURE',
7707: 'pay_us_emp_dt_tax_rules.pull_percentage');
7708: fnd_message.set_token('STEP','1');
7709: fnd_message.raise_error;
7710: end if;
7704: close csr_get_next_location;
7705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7706: fnd_message.set_token('PROCEDURE',
7707: 'pay_us_emp_dt_tax_rules.pull_percentage');
7708: fnd_message.set_token('STEP','1');
7709: fnd_message.raise_error;
7710: end if;
7711:
7712: close csr_get_next_location;
7705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7706: fnd_message.set_token('PROCEDURE',
7707: 'pay_us_emp_dt_tax_rules.pull_percentage');
7708: fnd_message.set_token('STEP','1');
7709: fnd_message.raise_error;
7710: end if;
7711:
7712: close csr_get_next_location;
7713:
7787: open csr_tax_element;
7788: fetch csr_tax_element into l_element_type_id;
7789: if csr_tax_element%NOTFOUND then
7790: close csr_tax_element;
7791: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7792: fnd_message.set_token('PROCEDURE',
7793: 'pay_us_emp_dt_tax_rules.pull_percentage');
7794: fnd_message.set_token('STEP','2');
7795: fnd_message.raise_error;
7788: fetch csr_tax_element into l_element_type_id;
7789: if csr_tax_element%NOTFOUND then
7790: close csr_tax_element;
7791: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7792: fnd_message.set_token('PROCEDURE',
7793: 'pay_us_emp_dt_tax_rules.pull_percentage');
7794: fnd_message.set_token('STEP','2');
7795: fnd_message.raise_error;
7796: end if;
7790: close csr_tax_element;
7791: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7792: fnd_message.set_token('PROCEDURE',
7793: 'pay_us_emp_dt_tax_rules.pull_percentage');
7794: fnd_message.set_token('STEP','2');
7795: fnd_message.raise_error;
7796: end if;
7797: close csr_tax_element;
7798:
7791: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7792: fnd_message.set_token('PROCEDURE',
7793: 'pay_us_emp_dt_tax_rules.pull_percentage');
7794: fnd_message.set_token('STEP','2');
7795: fnd_message.raise_error;
7796: end if;
7797: close csr_tax_element;
7798:
7799: /* Get element link */
7803: P_session_date => p_session_date);
7804:
7805: if l_element_link_id is null or l_element_link_id = 0
7806: then
7807: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7808: fnd_message.set_token('1','VERTEX');
7809: fnd_message.raise_error;
7810: end if;
7811:
7804:
7805: if l_element_link_id is null or l_element_link_id = 0
7806: then
7807: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7808: fnd_message.set_token('1','VERTEX');
7809: fnd_message.raise_error;
7810: end if;
7811:
7812: open csr_get_next_date(l_element_link_id, p_default_date);
7805: if l_element_link_id is null or l_element_link_id = 0
7806: then
7807: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7808: fnd_message.set_token('1','VERTEX');
7809: fnd_message.raise_error;
7810: end if;
7811:
7812: open csr_get_next_date(l_element_link_id, p_default_date);
7813: fetch csr_get_next_date into l_validation_end_date;
7813: fetch csr_get_next_date into l_validation_end_date;
7814: if csr_get_next_date%NOTFOUND
7815: then
7816: close csr_get_next_date;
7817: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7818: fnd_message.set_token('PROCEDURE',
7819: 'pay_us_emp_dt_tax_rules.pull_percentage');
7820: fnd_message.set_token('STEP','3');
7821: fnd_message.raise_error;
7814: if csr_get_next_date%NOTFOUND
7815: then
7816: close csr_get_next_date;
7817: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7818: fnd_message.set_token('PROCEDURE',
7819: 'pay_us_emp_dt_tax_rules.pull_percentage');
7820: fnd_message.set_token('STEP','3');
7821: fnd_message.raise_error;
7822: end if;
7816: close csr_get_next_date;
7817: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7818: fnd_message.set_token('PROCEDURE',
7819: 'pay_us_emp_dt_tax_rules.pull_percentage');
7820: fnd_message.set_token('STEP','3');
7821: fnd_message.raise_error;
7822: end if;
7823:
7824: close csr_get_next_date;
7817: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7818: fnd_message.set_token('PROCEDURE',
7819: 'pay_us_emp_dt_tax_rules.pull_percentage');
7820: fnd_message.set_token('STEP','3');
7821: fnd_message.raise_error;
7822: end if;
7823:
7824: close csr_get_next_date;
7825:
8072: open csr_get_prev_date(p_element_link,l_eff_prev_date);
8073: fetch csr_get_prev_date into l_validation_start_date;
8074: if csr_get_prev_date%NOTFOUND then
8075: close csr_get_prev_date;
8076: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8077: fnd_message.set_token('PROCEDURE',
8078: 'pay_us_emp_dt_tax_rules.backward_processing');
8079: fnd_message.set_token('STEP','1');
8080: fnd_message.raise_error;
8073: fetch csr_get_prev_date into l_validation_start_date;
8074: if csr_get_prev_date%NOTFOUND then
8075: close csr_get_prev_date;
8076: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8077: fnd_message.set_token('PROCEDURE',
8078: 'pay_us_emp_dt_tax_rules.backward_processing');
8079: fnd_message.set_token('STEP','1');
8080: fnd_message.raise_error;
8081: end if;
8075: close csr_get_prev_date;
8076: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8077: fnd_message.set_token('PROCEDURE',
8078: 'pay_us_emp_dt_tax_rules.backward_processing');
8079: fnd_message.set_token('STEP','1');
8080: fnd_message.raise_error;
8081: end if;
8082:
8083: /* deleting the previous set */
8076: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8077: fnd_message.set_token('PROCEDURE',
8078: 'pay_us_emp_dt_tax_rules.backward_processing');
8079: fnd_message.set_token('STEP','1');
8080: fnd_message.raise_error;
8081: end if;
8082:
8083: /* deleting the previous set */
8084:
8118: fetch csr_get_eff_date into l_default_date;
8119:
8120: if l_default_date is null then
8121: close csr_get_eff_date;
8122: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8123: fnd_message.set_token('PROCEDURE',
8124: 'pay_us_emp_dt_tax_rules.correct_percentage');
8125: fnd_message.set_token('STEP','1');
8126: fnd_message.raise_error;
8119:
8120: if l_default_date is null then
8121: close csr_get_eff_date;
8122: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8123: fnd_message.set_token('PROCEDURE',
8124: 'pay_us_emp_dt_tax_rules.correct_percentage');
8125: fnd_message.set_token('STEP','1');
8126: fnd_message.raise_error;
8127: end if;
8121: close csr_get_eff_date;
8122: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8123: fnd_message.set_token('PROCEDURE',
8124: 'pay_us_emp_dt_tax_rules.correct_percentage');
8125: fnd_message.set_token('STEP','1');
8126: fnd_message.raise_error;
8127: end if;
8128:
8129: close csr_get_eff_date;
8122: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8123: fnd_message.set_token('PROCEDURE',
8124: 'pay_us_emp_dt_tax_rules.correct_percentage');
8125: fnd_message.set_token('STEP','1');
8126: fnd_message.raise_error;
8127: end if;
8128:
8129: close csr_get_eff_date;
8130:
8132: open csr_tax_element;
8133: fetch csr_tax_element into l_element_type_id;
8134: if csr_tax_element%NOTFOUND then
8135: close csr_tax_element;
8136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8137: fnd_message.set_token('PROCEDURE',
8138: 'pay_us_emp_dt_tax_rules.correct_percentage');
8139: fnd_message.set_token('STEP','2');
8140: fnd_message.raise_error;
8133: fetch csr_tax_element into l_element_type_id;
8134: if csr_tax_element%NOTFOUND then
8135: close csr_tax_element;
8136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8137: fnd_message.set_token('PROCEDURE',
8138: 'pay_us_emp_dt_tax_rules.correct_percentage');
8139: fnd_message.set_token('STEP','2');
8140: fnd_message.raise_error;
8141: end if;
8135: close csr_tax_element;
8136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8137: fnd_message.set_token('PROCEDURE',
8138: 'pay_us_emp_dt_tax_rules.correct_percentage');
8139: fnd_message.set_token('STEP','2');
8140: fnd_message.raise_error;
8141: end if;
8142: close csr_tax_element;
8143:
8136: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8137: fnd_message.set_token('PROCEDURE',
8138: 'pay_us_emp_dt_tax_rules.correct_percentage');
8139: fnd_message.set_token('STEP','2');
8140: fnd_message.raise_error;
8141: end if;
8142: close csr_tax_element;
8143:
8144: hr_utility.set_location('pay_us_emp_dt_tax_rules.correct_percentage',4);
8148: P_element_type_id => l_element_type_id,
8149: P_session_date => p_session_date);
8150:
8151: if l_element_link_id is null or l_element_link_id = 0 then
8152: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8153: fnd_message.set_token('1','VERTEX');
8154: fnd_message.raise_error;
8155: end if;
8156:
8149: P_session_date => p_session_date);
8150:
8151: if l_element_link_id is null or l_element_link_id = 0 then
8152: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8153: fnd_message.set_token('1','VERTEX');
8154: fnd_message.raise_error;
8155: end if;
8156:
8157:
8150:
8151: if l_element_link_id is null or l_element_link_id = 0 then
8152: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8153: fnd_message.set_token('1','VERTEX');
8154: fnd_message.raise_error;
8155: end if;
8156:
8157:
8158: /* Let's handle the condition where there is just one set of
8251: l_pef_prev_date;
8252:
8253: if csr_ele_entry%NOTFOUND then
8254: close csr_ele_entry;
8255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8256: fnd_message.set_token('PROCEDURE',
8257: 'pay_us_emp_dt_tax_rules.correct_percentage');
8258: fnd_message.set_token('STEP','2');
8259: fnd_message.raise_error;
8252:
8253: if csr_ele_entry%NOTFOUND then
8254: close csr_ele_entry;
8255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8256: fnd_message.set_token('PROCEDURE',
8257: 'pay_us_emp_dt_tax_rules.correct_percentage');
8258: fnd_message.set_token('STEP','2');
8259: fnd_message.raise_error;
8260: end if;
8254: close csr_ele_entry;
8255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8256: fnd_message.set_token('PROCEDURE',
8257: 'pay_us_emp_dt_tax_rules.correct_percentage');
8258: fnd_message.set_token('STEP','2');
8259: fnd_message.raise_error;
8260: end if;
8261:
8262: close csr_ele_entry;
8255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8256: fnd_message.set_token('PROCEDURE',
8257: 'pay_us_emp_dt_tax_rules.correct_percentage');
8258: fnd_message.set_token('STEP','2');
8259: fnd_message.raise_error;
8260: end if;
8261:
8262: close csr_ele_entry;
8263:
8730: open csr_get_next_date(l_element_link_id,l_pef_next_date);
8731: fetch csr_get_next_date into l_next_loc_end_date;
8732: if csr_get_next_date%NOTFOUND then
8733: close csr_get_next_date;
8734: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8735: fnd_message.set_token('PROCEDURE',
8736: 'pay_us_emp_dt_tax_rules.correct_percentage');
8737: fnd_message.set_token('STEP','4');
8738: fnd_message.raise_error;
8731: fetch csr_get_next_date into l_next_loc_end_date;
8732: if csr_get_next_date%NOTFOUND then
8733: close csr_get_next_date;
8734: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8735: fnd_message.set_token('PROCEDURE',
8736: 'pay_us_emp_dt_tax_rules.correct_percentage');
8737: fnd_message.set_token('STEP','4');
8738: fnd_message.raise_error;
8739: end if;
8733: close csr_get_next_date;
8734: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8735: fnd_message.set_token('PROCEDURE',
8736: 'pay_us_emp_dt_tax_rules.correct_percentage');
8737: fnd_message.set_token('STEP','4');
8738: fnd_message.raise_error;
8739: end if;
8740:
8741: close csr_get_next_date;
8734: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8735: fnd_message.set_token('PROCEDURE',
8736: 'pay_us_emp_dt_tax_rules.correct_percentage');
8737: fnd_message.set_token('STEP','4');
8738: fnd_message.raise_error;
8739: end if;
8740:
8741: close csr_get_next_date;
8742:
8874: open csr_get_next_date(l_element_link_id,l_pef_next_date);
8875: fetch csr_get_next_date into l_next_loc_end_date;
8876: if csr_get_next_date%NOTFOUND then
8877: close csr_get_next_date;
8878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8879: fnd_message.set_token('PROCEDURE',
8880: 'pay_us_emp_dt_tax_rules.correct_percentage');
8881: fnd_message.set_token('STEP','4');
8882: fnd_message.raise_error;
8875: fetch csr_get_next_date into l_next_loc_end_date;
8876: if csr_get_next_date%NOTFOUND then
8877: close csr_get_next_date;
8878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8879: fnd_message.set_token('PROCEDURE',
8880: 'pay_us_emp_dt_tax_rules.correct_percentage');
8881: fnd_message.set_token('STEP','4');
8882: fnd_message.raise_error;
8883: end if;
8877: close csr_get_next_date;
8878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8879: fnd_message.set_token('PROCEDURE',
8880: 'pay_us_emp_dt_tax_rules.correct_percentage');
8881: fnd_message.set_token('STEP','4');
8882: fnd_message.raise_error;
8883: end if;
8884:
8885: close csr_get_next_date;
8878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8879: fnd_message.set_token('PROCEDURE',
8880: 'pay_us_emp_dt_tax_rules.correct_percentage');
8881: fnd_message.set_token('STEP','4');
8882: fnd_message.raise_error;
8883: end if;
8884:
8885: close csr_get_next_date;
8886:
9112:
9113: if csr_tax_element%NOTFOUND then
9114:
9115: close csr_tax_element;
9116: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9117: fnd_message.set_token('PROCEDURE',
9118: 'pay_us_emp_dt_tax_rules.update_percentage');
9119: fnd_message.set_token('STEP','1');
9120: fnd_message.raise_error;
9113: if csr_tax_element%NOTFOUND then
9114:
9115: close csr_tax_element;
9116: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9117: fnd_message.set_token('PROCEDURE',
9118: 'pay_us_emp_dt_tax_rules.update_percentage');
9119: fnd_message.set_token('STEP','1');
9120: fnd_message.raise_error;
9121:
9115: close csr_tax_element;
9116: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9117: fnd_message.set_token('PROCEDURE',
9118: 'pay_us_emp_dt_tax_rules.update_percentage');
9119: fnd_message.set_token('STEP','1');
9120: fnd_message.raise_error;
9121:
9122: end if;
9123:
9116: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9117: fnd_message.set_token('PROCEDURE',
9118: 'pay_us_emp_dt_tax_rules.update_percentage');
9119: fnd_message.set_token('STEP','1');
9120: fnd_message.raise_error;
9121:
9122: end if;
9123:
9124: close csr_tax_element;
9131: P_session_date => p_session_date);
9132:
9133: if l_element_link_id is null or l_element_link_id = 0 then
9134:
9135: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9136: fnd_message.set_token('1','VERTEX');
9137: fnd_message.raise_error;
9138:
9139: end if;
9132:
9133: if l_element_link_id is null or l_element_link_id = 0 then
9134:
9135: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9136: fnd_message.set_token('1','VERTEX');
9137: fnd_message.raise_error;
9138:
9139: end if;
9140:
9133: if l_element_link_id is null or l_element_link_id = 0 then
9134:
9135: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9136: fnd_message.set_token('1','VERTEX');
9137: fnd_message.raise_error;
9138:
9139: end if;
9140:
9141: /* Get the effective start date, effective end date and (effective end date + 1)
9147:
9148: if csr_get_dates%NOTFOUND then
9149:
9150: close csr_get_dates;
9151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9152: fnd_message.set_token('PROCEDURE',
9153: 'pay_us_emp_dt_tax_rules.update_percentage');
9154: fnd_message.set_token('STEP','2');
9155: fnd_message.raise_error;
9148: if csr_get_dates%NOTFOUND then
9149:
9150: close csr_get_dates;
9151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9152: fnd_message.set_token('PROCEDURE',
9153: 'pay_us_emp_dt_tax_rules.update_percentage');
9154: fnd_message.set_token('STEP','2');
9155: fnd_message.raise_error;
9156:
9150: close csr_get_dates;
9151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9152: fnd_message.set_token('PROCEDURE',
9153: 'pay_us_emp_dt_tax_rules.update_percentage');
9154: fnd_message.set_token('STEP','2');
9155: fnd_message.raise_error;
9156:
9157: end if;
9158:
9151: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9152: fnd_message.set_token('PROCEDURE',
9153: 'pay_us_emp_dt_tax_rules.update_percentage');
9154: fnd_message.set_token('STEP','2');
9155: fnd_message.raise_error;
9156:
9157: end if;
9158:
9159: close csr_get_dates;
9262:
9263: if csr_get_next_date%NOTFOUND then
9264:
9265: close csr_get_next_date;
9266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9267: fnd_message.set_token('PROCEDURE',
9268: 'pay_us_emp_dt_tax_rules.update_percentage');
9269: fnd_message.set_token('STEP','2');
9270: fnd_message.raise_error;
9263: if csr_get_next_date%NOTFOUND then
9264:
9265: close csr_get_next_date;
9266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9267: fnd_message.set_token('PROCEDURE',
9268: 'pay_us_emp_dt_tax_rules.update_percentage');
9269: fnd_message.set_token('STEP','2');
9270: fnd_message.raise_error;
9271:
9265: close csr_get_next_date;
9266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9267: fnd_message.set_token('PROCEDURE',
9268: 'pay_us_emp_dt_tax_rules.update_percentage');
9269: fnd_message.set_token('STEP','2');
9270: fnd_message.raise_error;
9271:
9272: end if;
9273:
9266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9267: fnd_message.set_token('PROCEDURE',
9268: 'pay_us_emp_dt_tax_rules.update_percentage');
9269: fnd_message.set_token('STEP','2');
9270: fnd_message.raise_error;
9271:
9272: end if;
9273:
9274: /* Pull forward the records as of the session date to
9416: open csr_get_loc_state;
9417: fetch csr_get_loc_state into l_work_state_code;
9418: if csr_get_loc_state%NOTFOUND then
9419: close csr_get_loc_state;
9420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9421: fnd_message.set_token('PROCEDURE',
9422: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9423: fnd_message.set_token('STEP',to_char(l_step));
9424: fnd_message.raise_error;
9417: fetch csr_get_loc_state into l_work_state_code;
9418: if csr_get_loc_state%NOTFOUND then
9419: close csr_get_loc_state;
9420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9421: fnd_message.set_token('PROCEDURE',
9422: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9423: fnd_message.set_token('STEP',to_char(l_step));
9424: fnd_message.raise_error;
9425: end if;
9419: close csr_get_loc_state;
9420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9421: fnd_message.set_token('PROCEDURE',
9422: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9423: fnd_message.set_token('STEP',to_char(l_step));
9424: fnd_message.raise_error;
9425: end if;
9426: close csr_get_loc_state;
9427:
9420: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9421: fnd_message.set_token('PROCEDURE',
9422: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9423: fnd_message.set_token('STEP',to_char(l_step));
9424: fnd_message.raise_error;
9425: end if;
9426: close csr_get_loc_state;
9427:
9428: l_step := 2;
9441: l_step := 5;
9442: fetch csr_lck_fed_row into l_row_id;
9443: if csr_lck_fed_row%NOTFOUND then
9444: close csr_lck_fed_row;
9445: fnd_message.set_name('FND','FORM_UNABLE_TO_RESERVE_RECORD');
9446: fnd_message.raise_error;
9447: end if;
9448: close csr_lck_fed_row;
9449:
9442: fetch csr_lck_fed_row into l_row_id;
9443: if csr_lck_fed_row%NOTFOUND then
9444: close csr_lck_fed_row;
9445: fnd_message.set_name('FND','FORM_UNABLE_TO_RESERVE_RECORD');
9446: fnd_message.raise_error;
9447: end if;
9448: close csr_lck_fed_row;
9449:
9450: /* Update the federal tax record for the SUI state */
9477: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9478: fetch csr_get_fed_details into l_fed_rec;
9479: if csr_get_fed_details%NOTFOUND then
9480: close csr_get_fed_details;
9481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9482: fnd_message.set_token('PROCEDURE',
9483: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9484: fnd_message.set_token('STEP',to_char(l_step));
9485: fnd_message.raise_error;
9478: fetch csr_get_fed_details into l_fed_rec;
9479: if csr_get_fed_details%NOTFOUND then
9480: close csr_get_fed_details;
9481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9482: fnd_message.set_token('PROCEDURE',
9483: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9484: fnd_message.set_token('STEP',to_char(l_step));
9485: fnd_message.raise_error;
9486: end if;
9480: close csr_get_fed_details;
9481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9482: fnd_message.set_token('PROCEDURE',
9483: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9484: fnd_message.set_token('STEP',to_char(l_step));
9485: fnd_message.raise_error;
9486: end if;
9487: close csr_get_fed_details;
9488:
9481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9482: fnd_message.set_token('PROCEDURE',
9483: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9484: fnd_message.set_token('STEP',to_char(l_step));
9485: fnd_message.raise_error;
9486: end if;
9487: close csr_get_fed_details;
9488:
9489: /* Update the Federal tax record as of the p_effective_start_date */
9709: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9710: fetch csr_get_fed_details into l_fed_rec;
9711: if csr_get_fed_details%NOTFOUND then
9712: close csr_get_fed_details;
9713: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9714: fnd_message.set_token('PROCEDURE',
9715: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9716: fnd_message.set_token('STEP',to_char(l_step));
9717: fnd_message.raise_error;
9710: fetch csr_get_fed_details into l_fed_rec;
9711: if csr_get_fed_details%NOTFOUND then
9712: close csr_get_fed_details;
9713: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9714: fnd_message.set_token('PROCEDURE',
9715: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9716: fnd_message.set_token('STEP',to_char(l_step));
9717: fnd_message.raise_error;
9718: end if;
9712: close csr_get_fed_details;
9713: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9714: fnd_message.set_token('PROCEDURE',
9715: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9716: fnd_message.set_token('STEP',to_char(l_step));
9717: fnd_message.raise_error;
9718: end if;
9719: close csr_get_fed_details;
9720:
9713: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9714: fnd_message.set_token('PROCEDURE',
9715: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9716: fnd_message.set_token('STEP',to_char(l_step));
9717: fnd_message.raise_error;
9718: end if;
9719: close csr_get_fed_details;
9720:
9721: /* Update the Federal tax record as of the p_effective_start_date */
9960: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9961: fetch csr_get_fed_details into l_fed_rec;
9962: if csr_get_fed_details%NOTFOUND then
9963: close csr_get_fed_details;
9964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9965: fnd_message.set_token('PROCEDURE',
9966: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9967: fnd_message.set_token('STEP',to_char(l_step));
9968: fnd_message.raise_error;
9961: fetch csr_get_fed_details into l_fed_rec;
9962: if csr_get_fed_details%NOTFOUND then
9963: close csr_get_fed_details;
9964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9965: fnd_message.set_token('PROCEDURE',
9966: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9967: fnd_message.set_token('STEP',to_char(l_step));
9968: fnd_message.raise_error;
9969: end if;
9963: close csr_get_fed_details;
9964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9965: fnd_message.set_token('PROCEDURE',
9966: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9967: fnd_message.set_token('STEP',to_char(l_step));
9968: fnd_message.raise_error;
9969: end if;
9970: close csr_get_fed_details;
9971:
9964: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9965: fnd_message.set_token('PROCEDURE',
9966: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9967: fnd_message.set_token('STEP',to_char(l_step));
9968: fnd_message.raise_error;
9969: end if;
9970: close csr_get_fed_details;
9971:
9972: /* Update the Federal tax record as of the p_effective_end_date + 1 */
10192: open csr_get_fed_details(l_eff_start_date, p_effective_end_date);
10193: fetch csr_get_fed_details into l_fed_rec;
10194: if csr_get_fed_details%NOTFOUND then
10195: close csr_get_fed_details;
10196: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10197: fnd_message.set_token('PROCEDURE',
10198: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10199: fnd_message.set_token('STEP',to_char(l_step));
10200: fnd_message.raise_error;
10193: fetch csr_get_fed_details into l_fed_rec;
10194: if csr_get_fed_details%NOTFOUND then
10195: close csr_get_fed_details;
10196: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10197: fnd_message.set_token('PROCEDURE',
10198: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10199: fnd_message.set_token('STEP',to_char(l_step));
10200: fnd_message.raise_error;
10201: end if;
10195: close csr_get_fed_details;
10196: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10197: fnd_message.set_token('PROCEDURE',
10198: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10199: fnd_message.set_token('STEP',to_char(l_step));
10200: fnd_message.raise_error;
10201: end if;
10202: close csr_get_fed_details;
10203: */
10196: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10197: fnd_message.set_token('PROCEDURE',
10198: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10199: fnd_message.set_token('STEP',to_char(l_step));
10200: fnd_message.raise_error;
10201: end if;
10202: close csr_get_fed_details;
10203: */
10204:
10406: close csr_get_fed_rows;
10407:
10408: exception
10409: when others then
10410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10411: fnd_message.set_token('PROCEDURE',
10412: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10413: fnd_message.set_token('STEP',to_char(l_step));
10414: fnd_message.raise_error;
10407:
10408: exception
10409: when others then
10410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10411: fnd_message.set_token('PROCEDURE',
10412: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10413: fnd_message.set_token('STEP',to_char(l_step));
10414: fnd_message.raise_error;
10415: end correct_wc_entry;
10409: when others then
10410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10411: fnd_message.set_token('PROCEDURE',
10412: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10413: fnd_message.set_token('STEP',to_char(l_step));
10414: fnd_message.raise_error;
10415: end correct_wc_entry;
10416:
10417:
10410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10411: fnd_message.set_token('PROCEDURE',
10412: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10413: fnd_message.set_token('STEP',to_char(l_step));
10414: fnd_message.raise_error;
10415: end correct_wc_entry;
10416:
10417:
10418: procedure change_wc_entry (p_assignment_id in number,
10483: where assignment_id = p_assignment_id
10484: and l_ef_date between effective_start_date and effective_end_date;
10485:
10486: if sql%notfound then
10487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10488: fnd_message.set_token('PROCEDURE',l_proc);
10489: fnd_message.set_token('STEP','2');
10490: fnd_message.raise_error;
10491: end if;
10484: and l_ef_date between effective_start_date and effective_end_date;
10485:
10486: if sql%notfound then
10487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10488: fnd_message.set_token('PROCEDURE',l_proc);
10489: fnd_message.set_token('STEP','2');
10490: fnd_message.raise_error;
10491: end if;
10492:
10485:
10486: if sql%notfound then
10487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10488: fnd_message.set_token('PROCEDURE',l_proc);
10489: fnd_message.set_token('STEP','2');
10490: fnd_message.raise_error;
10491: end if;
10492:
10493: update PAY_US_EMP_STATE_TAX_RULES_F
10486: if sql%notfound then
10487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10488: fnd_message.set_token('PROCEDURE',l_proc);
10489: fnd_message.set_token('STEP','2');
10490: fnd_message.raise_error;
10491: end if;
10492:
10493: update PAY_US_EMP_STATE_TAX_RULES_F
10494: set effective_start_date = p_new_start_date
10495: where assignment_id = p_assignment_id
10496: and l_ef_date between effective_start_date and effective_end_date;
10497:
10498: if sql%notfound then
10499: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10500: fnd_message.set_token('PROCEDURE',l_proc);
10501: fnd_message.set_token('STEP','3');
10502: fnd_message.raise_error;
10503: end if;
10496: and l_ef_date between effective_start_date and effective_end_date;
10497:
10498: if sql%notfound then
10499: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10500: fnd_message.set_token('PROCEDURE',l_proc);
10501: fnd_message.set_token('STEP','3');
10502: fnd_message.raise_error;
10503: end if;
10504:
10497:
10498: if sql%notfound then
10499: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10500: fnd_message.set_token('PROCEDURE',l_proc);
10501: fnd_message.set_token('STEP','3');
10502: fnd_message.raise_error;
10503: end if;
10504:
10505: update PAY_US_EMP_COUNTY_TAX_RULES_F
10498: if sql%notfound then
10499: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10500: fnd_message.set_token('PROCEDURE',l_proc);
10501: fnd_message.set_token('STEP','3');
10502: fnd_message.raise_error;
10503: end if;
10504:
10505: update PAY_US_EMP_COUNTY_TAX_RULES_F
10506: set effective_start_date = p_new_start_date
10507: where assignment_id = p_assignment_id
10508: and l_ef_date between effective_start_date and effective_end_date;
10509:
10510: if sql%notfound then
10511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10512: fnd_message.set_token('PROCEDURE',l_proc);
10513: fnd_message.set_token('STEP','4');
10514: fnd_message.raise_error;
10515: end if;
10508: and l_ef_date between effective_start_date and effective_end_date;
10509:
10510: if sql%notfound then
10511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10512: fnd_message.set_token('PROCEDURE',l_proc);
10513: fnd_message.set_token('STEP','4');
10514: fnd_message.raise_error;
10515: end if;
10516:
10509:
10510: if sql%notfound then
10511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10512: fnd_message.set_token('PROCEDURE',l_proc);
10513: fnd_message.set_token('STEP','4');
10514: fnd_message.raise_error;
10515: end if;
10516:
10517: update PAY_US_EMP_CITY_TAX_RULES_F
10510: if sql%notfound then
10511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10512: fnd_message.set_token('PROCEDURE',l_proc);
10513: fnd_message.set_token('STEP','4');
10514: fnd_message.raise_error;
10515: end if;
10516:
10517: update PAY_US_EMP_CITY_TAX_RULES_F
10518: set effective_start_date = p_new_start_date
10519: where assignment_id = p_assignment_id
10520: and l_ef_date between effective_start_date and effective_end_date;
10521:
10522: if sql%notfound then
10523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10524: fnd_message.set_token('PROCEDURE',l_proc);
10525: fnd_message.set_token('STEP','5');
10526: fnd_message.raise_error;
10527: end if;
10520: and l_ef_date between effective_start_date and effective_end_date;
10521:
10522: if sql%notfound then
10523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10524: fnd_message.set_token('PROCEDURE',l_proc);
10525: fnd_message.set_token('STEP','5');
10526: fnd_message.raise_error;
10527: end if;
10528:
10521:
10522: if sql%notfound then
10523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10524: fnd_message.set_token('PROCEDURE',l_proc);
10525: fnd_message.set_token('STEP','5');
10526: fnd_message.raise_error;
10527: end if;
10528:
10529: /* Next delete any orphaned rows */
10522: if sql%notfound then
10523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10524: fnd_message.set_token('PROCEDURE',l_proc);
10525: fnd_message.set_token('STEP','5');
10526: fnd_message.raise_error;
10527: end if;
10528:
10529: /* Next delete any orphaned rows */
10530: if p_new_start_date > p_default_date then
10716: p_res_city_name => l_res_city_name);
10717:
10718: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',2);
10719: if l_res_state_code is null then
10720: fnd_message.set_name('PER', 'PER_52985_ADD_NO_STATE_SET');
10721: fnd_message.raise_error;
10722: end if;
10723:
10724: if l_res_county_code is null then
10717:
10718: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',2);
10719: if l_res_state_code is null then
10720: fnd_message.set_name('PER', 'PER_52985_ADD_NO_STATE_SET');
10721: fnd_message.raise_error;
10722: end if;
10723:
10724: if l_res_county_code is null then
10725: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10721: fnd_message.raise_error;
10722: end if;
10723:
10724: if l_res_county_code is null then
10725: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10726: fnd_message.raise_error;
10727: end if;
10728:
10729: if l_res_city_code is null then
10722: end if;
10723:
10724: if l_res_county_code is null then
10725: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10726: fnd_message.raise_error;
10727: end if;
10728:
10729: if l_res_city_code is null then
10730: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10726: fnd_message.raise_error;
10727: end if;
10728:
10729: if l_res_city_code is null then
10730: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10731: fnd_message.raise_error;
10732: end if;
10733:
10734: /* Check to see if the address has an override or not . If there is
10727: end if;
10728:
10729: if l_res_city_code is null then
10730: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10731: fnd_message.raise_error;
10732: end if;
10733:
10734: /* Check to see if the address has an override or not . If there is
10735: an override for the address then get the non override address for
10780: );
10781:
10782: if l_work_state_code is null or l_work_county_code is null
10783: or l_work_city_code is null then
10784: fnd_message.set_name('PAY', 'PY_51133_TXADJ_INVALID_CITY');
10785: fnd_message.raise_error;
10786: end if;
10787:
10788: /* Insert the default Federal tax Record */
10781:
10782: if l_work_state_code is null or l_work_county_code is null
10783: or l_work_city_code is null then
10784: fnd_message.set_name('PAY', 'PY_51133_TXADJ_INVALID_CITY');
10785: fnd_message.raise_error;
10786: end if;
10787:
10788: /* Insert the default Federal tax Record */
10789:
11080:
11081: /* message('Future dated location changes exist for which the
11082: defaulting criteria might not be satisfied.') */
11083:
11084: fnd_message.set_name('PAY', 'PAY_52299_TAX_FUT_LOC');
11085: fnd_message.raise_error;
11086:
11087: end if;
11088:
11081: /* message('Future dated location changes exist for which the
11082: defaulting criteria might not be satisfied.') */
11083:
11084: fnd_message.set_name('PAY', 'PAY_52299_TAX_FUT_LOC');
11085: fnd_message.raise_error;
11086:
11087: end if;
11088:
11089: /* Get the max effective end date of the assignment.
11097:
11098: if l_effective_end_date is null then
11099:
11100: close csr_asg_end_date;
11101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11102: fnd_message.set_token('PROCEDURE',
11103: 'pay_us_emp_dt_tax_rules.check_defaulting');
11104: fnd_message.set_token('STEP','1');
11105: fnd_message.raise_error;
11098: if l_effective_end_date is null then
11099:
11100: close csr_asg_end_date;
11101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11102: fnd_message.set_token('PROCEDURE',
11103: 'pay_us_emp_dt_tax_rules.check_defaulting');
11104: fnd_message.set_token('STEP','1');
11105: fnd_message.raise_error;
11106:
11100: close csr_asg_end_date;
11101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11102: fnd_message.set_token('PROCEDURE',
11103: 'pay_us_emp_dt_tax_rules.check_defaulting');
11104: fnd_message.set_token('STEP','1');
11105: fnd_message.raise_error;
11106:
11107: end if;
11108:
11101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11102: fnd_message.set_token('PROCEDURE',
11103: 'pay_us_emp_dt_tax_rules.check_defaulting');
11104: fnd_message.set_token('STEP','1');
11105: fnd_message.raise_error;
11106:
11107: end if;
11108:
11109: close csr_asg_end_date;
11603:
11604: if l_default_date is null then
11605:
11606: close csr_get_default_date;
11607: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11608: fnd_message.set_token('PROCEDURE',
11609: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11610: fnd_message.set_token('STEP','1');
11611: fnd_message.raise_error;
11604: if l_default_date is null then
11605:
11606: close csr_get_default_date;
11607: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11608: fnd_message.set_token('PROCEDURE',
11609: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11610: fnd_message.set_token('STEP','1');
11611: fnd_message.raise_error;
11612:
11606: close csr_get_default_date;
11607: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11608: fnd_message.set_token('PROCEDURE',
11609: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11610: fnd_message.set_token('STEP','1');
11611: fnd_message.raise_error;
11612:
11613: end if;
11614:
11607: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11608: fnd_message.set_token('PROCEDURE',
11609: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11610: fnd_message.set_token('STEP','1');
11611: fnd_message.raise_error;
11612:
11613: end if;
11614:
11615: close csr_get_default_date;
11719:
11720: if csr_get_default_date%NOTFOUND then
11721:
11722: close csr_get_default_date;
11723: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11724: fnd_message.set_token('PROCEDURE',
11725: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11726: fnd_message.set_token('STEP','2');
11727: fnd_message.raise_error;
11720: if csr_get_default_date%NOTFOUND then
11721:
11722: close csr_get_default_date;
11723: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11724: fnd_message.set_token('PROCEDURE',
11725: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11726: fnd_message.set_token('STEP','2');
11727: fnd_message.raise_error;
11728:
11722: close csr_get_default_date;
11723: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11724: fnd_message.set_token('PROCEDURE',
11725: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11726: fnd_message.set_token('STEP','2');
11727: fnd_message.raise_error;
11728:
11729: end if;
11730:
11723: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11724: fnd_message.set_token('PROCEDURE',
11725: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11726: fnd_message.set_token('STEP','2');
11727: fnd_message.raise_error;
11728:
11729: end if;
11730:
11731: close csr_get_default_date;
11829:
11830: /* There are some more assignment records without the
11831: tax records. So, error it out */
11832:
11833: fnd_message.set_name('PAY', 'PAY_52292_TAX_DEF_CRT');
11834: fnd_message.raise_error;
11835:
11836: else
11837:
11830: /* There are some more assignment records without the
11831: tax records. So, error it out */
11832:
11833: fnd_message.set_name('PAY', 'PAY_52292_TAX_DEF_CRT');
11834: fnd_message.raise_error;
11835:
11836: else
11837:
11838: /* First update the tax rules records */
11964:
11965: if csr_get_end_date%NOTFOUND then
11966:
11967: close csr_get_end_date;
11968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11969: fnd_message.set_token('PROCEDURE',
11970: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11971: fnd_message.set_token('STEP','3');
11972: fnd_message.raise_error;
11965: if csr_get_end_date%NOTFOUND then
11966:
11967: close csr_get_end_date;
11968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11969: fnd_message.set_token('PROCEDURE',
11970: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11971: fnd_message.set_token('STEP','3');
11972: fnd_message.raise_error;
11973:
11967: close csr_get_end_date;
11968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11969: fnd_message.set_token('PROCEDURE',
11970: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11971: fnd_message.set_token('STEP','3');
11972: fnd_message.raise_error;
11973:
11974: end if;
11975:
11968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11969: fnd_message.set_token('PROCEDURE',
11970: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11971: fnd_message.set_token('STEP','3');
11972: fnd_message.raise_error;
11973:
11974: end if;
11975:
11976: close csr_get_end_date;
12090: fetch csr_loc_state_code into l_loc_state_code;
12091:
12092: if csr_loc_state_code%NOTFOUND then
12093: close csr_loc_state_code;
12094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12095: fnd_message.set_token('PROCEDURE',
12096: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12097: fnd_message.set_token('STEP','10');
12098: fnd_message.raise_error;
12091:
12092: if csr_loc_state_code%NOTFOUND then
12093: close csr_loc_state_code;
12094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12095: fnd_message.set_token('PROCEDURE',
12096: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12097: fnd_message.set_token('STEP','10');
12098: fnd_message.raise_error;
12099: end if;
12093: close csr_loc_state_code;
12094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12095: fnd_message.set_token('PROCEDURE',
12096: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12097: fnd_message.set_token('STEP','10');
12098: fnd_message.raise_error;
12099: end if;
12100:
12101: close csr_loc_state_code;
12094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12095: fnd_message.set_token('PROCEDURE',
12096: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12097: fnd_message.set_token('STEP','10');
12098: fnd_message.raise_error;
12099: end if;
12100:
12101: close csr_loc_state_code;
12102:
12396: if p_withholding_allowances > 1 and not
12397: (l_pei_information9 in ('CA','MX','KS') or (l_student_flag ='Yes' and l_pei_information9 = 'IN'))
12398: then
12399: l_warning := 'PAY_US_CHK_NRA_W4_ALLOWANCES';
12400: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_W4_ALLOWANCES');
12401: fnd_message.raise_error;
12402: end if;
12403: if p_filing_status_code <> '01'
12404: then
12397: (l_pei_information9 in ('CA','MX','KS') or (l_student_flag ='Yes' and l_pei_information9 = 'IN'))
12398: then
12399: l_warning := 'PAY_US_CHK_NRA_W4_ALLOWANCES';
12400: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_W4_ALLOWANCES');
12401: fnd_message.raise_error;
12402: end if;
12403: if p_filing_status_code <> '01'
12404: then
12405: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12402: end if;
12403: if p_filing_status_code <> '01'
12404: then
12405: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12406: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FILING_STATUS');
12407: fnd_message.raise_error;
12408: end if;
12409: if (p_fit_exempt = 'Y')
12410: then
12403: if p_filing_status_code <> '01'
12404: then
12405: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12406: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FILING_STATUS');
12407: fnd_message.raise_error;
12408: end if;
12409: if (p_fit_exempt = 'Y')
12410: then
12411: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12408: end if;
12409: if (p_fit_exempt = 'Y')
12410: then
12411: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12412: /** fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FIT_EXEMPTIONS');
12413: fnd_message.raise_error; **/
12414: end if;
12415: end if;
12416: close csr_chk_nra_status;
12409: if (p_fit_exempt = 'Y')
12410: then
12411: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12412: /** fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FIT_EXEMPTIONS');
12413: fnd_message.raise_error; **/
12414: end if;
12415: end if;
12416: close csr_chk_nra_status;
12417: p_returned_warning := l_warning;