[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:
1479: p_sta_information29,
1480: p_sta_information30);
1481:
1482: if sql%notfound then
1483: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1484: fnd_message.set_token('PROCEDURE',
1485: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1486: fnd_message.set_token('STEP','4');
1487: fnd_message.raise_error;
1480: p_sta_information30);
1481:
1482: if sql%notfound then
1483: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1484: fnd_message.set_token('PROCEDURE',
1485: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1486: fnd_message.set_token('STEP','4');
1487: fnd_message.raise_error;
1488: end if;
1482: if sql%notfound then
1483: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1484: fnd_message.set_token('PROCEDURE',
1485: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1486: fnd_message.set_token('STEP','4');
1487: fnd_message.raise_error;
1488: end if;
1489:
1490: open csr_get_row_id;
1483: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1484: fnd_message.set_token('PROCEDURE',
1485: 'pay_us_emp_dt_tax_rules.insert_state_tax_row');
1486: fnd_message.set_token('STEP','4');
1487: fnd_message.raise_error;
1488: end if;
1489:
1490: open csr_get_row_id;
1491:
1853: p_cnt_information29,
1854: p_cnt_information30);
1855:
1856: if sql%notfound then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE',
1859: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1860: fnd_message.set_token('STEP','4');
1861: fnd_message.raise_error;
1854: p_cnt_information30);
1855:
1856: if sql%notfound then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE',
1859: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1860: fnd_message.set_token('STEP','4');
1861: fnd_message.raise_error;
1862: end if;
1856: if sql%notfound then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE',
1859: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1860: fnd_message.set_token('STEP','4');
1861: fnd_message.raise_error;
1862: end if;
1863:
1864: open csr_get_row_id;
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE',
1859: 'pay_us_emp_dt_tax_rules.insert_county_tax_row');
1860: fnd_message.set_token('STEP','4');
1861: fnd_message.raise_error;
1862: end if;
1863:
1864: open csr_get_row_id;
1865:
2241: p_cty_information30);
2242:
2243: if sql%notfound then
2244:
2245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2246: fnd_message.set_token('PROCEDURE',
2247: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2248: fnd_message.set_token('STEP','4');
2249: fnd_message.raise_error;
2242:
2243: if sql%notfound then
2244:
2245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2246: fnd_message.set_token('PROCEDURE',
2247: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2248: fnd_message.set_token('STEP','4');
2249: fnd_message.raise_error;
2250:
2244:
2245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2246: fnd_message.set_token('PROCEDURE',
2247: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2248: fnd_message.set_token('STEP','4');
2249: fnd_message.raise_error;
2250:
2251: end if;
2252:
2245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2246: fnd_message.set_token('PROCEDURE',
2247: 'pay_us_emp_dt_tax_rules.insert_city_tax_row');
2248: fnd_message.set_token('STEP','4');
2249: fnd_message.raise_error;
2250:
2251: end if;
2252:
2253: open csr_get_row_id;
2503: fed_information30 = p_fed_information30
2504: where rowid = chartorowid(p_row_id);
2505:
2506: if sql%notfound then
2507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2508: fnd_message.set_token('PROCEDURE',
2509: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2510: fnd_message.set_token('STEP','1');
2511: fnd_message.raise_error;
2504: where rowid = chartorowid(p_row_id);
2505:
2506: if sql%notfound then
2507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2508: fnd_message.set_token('PROCEDURE',
2509: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2510: fnd_message.set_token('STEP','1');
2511: fnd_message.raise_error;
2512: end if;
2506: if sql%notfound then
2507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2508: fnd_message.set_token('PROCEDURE',
2509: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2510: fnd_message.set_token('STEP','1');
2511: fnd_message.raise_error;
2512: end if;
2513:
2514: /* Update workers compensation element entry for the sui state in
2507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2508: fnd_message.set_token('PROCEDURE',
2509: 'pay_us_emp_dt_tax_rules.update_fed_tax');
2510: fnd_message.set_token('STEP','1');
2511: fnd_message.raise_error;
2512: end if;
2513:
2514: /* Update workers compensation element entry for the sui state in
2515: the federal record */
2711: sta_information30 = p_sta_information30
2712: where rowid = chartorowid(p_row_id);
2713:
2714: if sql%notfound then
2715: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2716: fnd_message.set_token('PROCEDURE',
2717: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2718: fnd_message.set_token('STEP','1');
2719: fnd_message.raise_error;
2712: where rowid = chartorowid(p_row_id);
2713:
2714: if sql%notfound then
2715: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2716: fnd_message.set_token('PROCEDURE',
2717: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2718: fnd_message.set_token('STEP','1');
2719: fnd_message.raise_error;
2720: end if;
2714: if sql%notfound then
2715: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2716: fnd_message.set_token('PROCEDURE',
2717: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2718: fnd_message.set_token('STEP','1');
2719: fnd_message.raise_error;
2720: end if;
2721:
2722: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2715: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2716: fnd_message.set_token('PROCEDURE',
2717: 'pay_us_emp_dt_tax_rules.update_state_tax_row');
2718: fnd_message.set_token('STEP','1');
2719: fnd_message.raise_error;
2720: end if;
2721:
2722: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2723: ' - updated row', 2);
2916: cnt_information30 = p_cnt_information30
2917: where rowid = chartorowid(p_row_id);
2918:
2919: if sql%notfound then
2920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2921: fnd_message.set_token('PROCEDURE',
2922: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2923: fnd_message.set_token('STEP','2');
2924: fnd_message.raise_error;
2917: where rowid = chartorowid(p_row_id);
2918:
2919: if sql%notfound then
2920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2921: fnd_message.set_token('PROCEDURE',
2922: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2923: fnd_message.set_token('STEP','2');
2924: fnd_message.raise_error;
2925: end if;
2919: if sql%notfound then
2920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2921: fnd_message.set_token('PROCEDURE',
2922: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2923: fnd_message.set_token('STEP','2');
2924: fnd_message.raise_error;
2925: end if;
2926:
2927: if p_school_district_code is not null then
2920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2921: fnd_message.set_token('PROCEDURE',
2922: 'pay_us_emp_dt_tax_rules.update_county_tax_row');
2923: fnd_message.set_token('STEP','2');
2924: fnd_message.raise_error;
2925: end if;
2926:
2927: if p_school_district_code is not null then
2928:
3136: where rowid = chartorowid(p_row_id);
3137:
3138: if sql%notfound then
3139:
3140: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3141: fnd_message.set_token('PROCEDURE',
3142: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3143: fnd_message.set_token('STEP','2');
3144: fnd_message.raise_error;
3137:
3138: if sql%notfound then
3139:
3140: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3141: fnd_message.set_token('PROCEDURE',
3142: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3143: fnd_message.set_token('STEP','2');
3144: fnd_message.raise_error;
3145:
3139:
3140: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3141: fnd_message.set_token('PROCEDURE',
3142: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3143: fnd_message.set_token('STEP','2');
3144: fnd_message.raise_error;
3145:
3146: end if;
3147:
3140: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3141: fnd_message.set_token('PROCEDURE',
3142: 'pay_us_emp_dt_tax_rules.update_city_tax_row');
3143: fnd_message.set_token('STEP','2');
3144: fnd_message.raise_error;
3145:
3146: end if;
3147:
3148: if p_school_district_code is not null then
3235:
3236: fetch csr_get_eff_date into l_effective_start_date;
3237:
3238: if l_effective_start_date is null then
3239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3240: fnd_message.set_token('PROCEDURE',
3241: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3242: fnd_message.set_token('STEP','1');
3243: fnd_message.raise_error;
3236: fetch csr_get_eff_date into l_effective_start_date;
3237:
3238: if l_effective_start_date is null then
3239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3240: fnd_message.set_token('PROCEDURE',
3241: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3242: fnd_message.set_token('STEP','1');
3243: fnd_message.raise_error;
3244: end if;
3238: if l_effective_start_date is null then
3239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3240: fnd_message.set_token('PROCEDURE',
3241: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3242: fnd_message.set_token('STEP','1');
3243: fnd_message.raise_error;
3244: end if;
3245:
3246: close csr_get_eff_date;
3239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3240: fnd_message.set_token('PROCEDURE',
3241: 'pay_us_emp_dt_tax_rules.delete_tax_row');
3242: fnd_message.set_token('STEP','1');
3243: fnd_message.raise_error;
3244: end if;
3245:
3246: close csr_get_eff_date;
3247:
3537: fetch csr_asg_rec into l_assignment_id;
3538:
3539: if csr_asg_rec%NOTFOUND then
3540: close csr_asg_rec;
3541: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3542: fnd_message.raise_error;
3543: end if;
3544:
3545: close csr_asg_rec;
3538:
3539: if csr_asg_rec%NOTFOUND then
3540: close csr_asg_rec;
3541: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
3542: fnd_message.raise_error;
3543: end if;
3544:
3545: close csr_asg_rec;
3546:
3549: fetch csr_fed_rec into fed_rec;
3550:
3551: if csr_fed_rec%NOTFOUND then
3552: close csr_fed_rec;
3553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3554: fnd_message.set_token('PROCEDURE',
3555: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3556: fnd_message.set_token('STEP', '1');
3557: fnd_message.raise_error;
3550:
3551: if csr_fed_rec%NOTFOUND then
3552: close csr_fed_rec;
3553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3554: fnd_message.set_token('PROCEDURE',
3555: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3556: fnd_message.set_token('STEP', '1');
3557: fnd_message.raise_error;
3558: end if;
3552: close csr_fed_rec;
3553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3554: fnd_message.set_token('PROCEDURE',
3555: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3556: fnd_message.set_token('STEP', '1');
3557: fnd_message.raise_error;
3558: end if;
3559:
3560: close csr_fed_rec;
3553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3554: fnd_message.set_token('PROCEDURE',
3555: 'pay_us_emp_dt_tax_rules.lock_fed_tax_row');
3556: fnd_message.set_token('STEP', '1');
3557: fnd_message.raise_error;
3558: end if;
3559:
3560: close csr_fed_rec;
3561:
3897: return;
3898:
3899: else
3900:
3901: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
3902: fnd_message.raise_error;
3903:
3904: end if;
3905:
3898:
3899: else
3900:
3901: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
3902: fnd_message.raise_error;
3903:
3904: end if;
3905:
3906: end lock_fed_tax_row;
4024: fetch csr_asg_rec into l_assignment_id;
4025:
4026: if csr_asg_rec%NOTFOUND then
4027: close csr_asg_rec;
4028: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4029: fnd_message.raise_error;
4030: end if;
4031:
4032: close csr_asg_rec;
4025:
4026: if csr_asg_rec%NOTFOUND then
4027: close csr_asg_rec;
4028: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4029: fnd_message.raise_error;
4030: end if;
4031:
4032: close csr_asg_rec;
4033:
4036: fetch csr_state_rec into state_rec;
4037:
4038: if csr_state_rec%NOTFOUND then
4039: close csr_state_rec;
4040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4041: fnd_message.set_token('PROCEDURE',
4042: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
4043: fnd_message.set_token('STEP', '1');
4044: fnd_message.raise_error;
4037:
4038: if csr_state_rec%NOTFOUND then
4039: close csr_state_rec;
4040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4041: fnd_message.set_token('PROCEDURE',
4042: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
4043: fnd_message.set_token('STEP', '1');
4044: fnd_message.raise_error;
4045: end if;
4039: close csr_state_rec;
4040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4041: fnd_message.set_token('PROCEDURE',
4042: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
4043: fnd_message.set_token('STEP', '1');
4044: fnd_message.raise_error;
4045: end if;
4046:
4047: close csr_state_rec;
4040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4041: fnd_message.set_token('PROCEDURE',
4042: 'pay_us_emp_dt_tax_rules.lock_state_tax_row');
4043: fnd_message.set_token('STEP', '1');
4044: fnd_message.raise_error;
4045: end if;
4046:
4047: close csr_state_rec;
4048:
4385: return;
4386:
4387: else
4388:
4389: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4390: fnd_message.raise_error;
4391:
4392: end if;
4393:
4386:
4387: else
4388:
4389: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4390: fnd_message.raise_error;
4391:
4392: end if;
4393:
4394: end lock_state_tax_row;
4506: fetch csr_asg_rec into l_assignment_id;
4507:
4508: if csr_asg_rec%NOTFOUND then
4509: close csr_asg_rec;
4510: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4511: fnd_message.raise_error;
4512: end if;
4513:
4514: close csr_asg_rec;
4507:
4508: if csr_asg_rec%NOTFOUND then
4509: close csr_asg_rec;
4510: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4511: fnd_message.raise_error;
4512: end if;
4513:
4514: close csr_asg_rec;
4515:
4518: fetch csr_county_rec into county_rec;
4519:
4520: if csr_county_rec%NOTFOUND then
4521: close csr_county_rec;
4522: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4523: fnd_message.set_token('PROCEDURE',
4524: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4525: fnd_message.set_token('STEP', '1');
4526: fnd_message.raise_error;
4519:
4520: if csr_county_rec%NOTFOUND then
4521: close csr_county_rec;
4522: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4523: fnd_message.set_token('PROCEDURE',
4524: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4525: fnd_message.set_token('STEP', '1');
4526: fnd_message.raise_error;
4527: end if;
4521: close csr_county_rec;
4522: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4523: fnd_message.set_token('PROCEDURE',
4524: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4525: fnd_message.set_token('STEP', '1');
4526: fnd_message.raise_error;
4527: end if;
4528:
4529: close csr_county_rec;
4522: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4523: fnd_message.set_token('PROCEDURE',
4524: 'pay_us_emp_dt_tax_rules.lock_county_tax_row');
4525: fnd_message.set_token('STEP', '1');
4526: fnd_message.raise_error;
4527: end if;
4528:
4529: close csr_county_rec;
4530:
4849: return;
4850:
4851: else
4852:
4853: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4854: fnd_message.raise_error;
4855:
4856: end if;
4857:
4850:
4851: else
4852:
4853: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
4854: fnd_message.raise_error;
4855:
4856: end if;
4857:
4858: end lock_county_tax_row;
4972: fetch csr_asg_rec into l_assignment_id;
4973:
4974: if csr_asg_rec%NOTFOUND then
4975: close csr_asg_rec;
4976: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4977: fnd_message.raise_error;
4978: end if;
4979:
4980: close csr_asg_rec;
4973:
4974: if csr_asg_rec%NOTFOUND then
4975: close csr_asg_rec;
4976: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
4977: fnd_message.raise_error;
4978: end if;
4979:
4980: close csr_asg_rec;
4981:
4984: fetch csr_city_rec into city_rec;
4985:
4986: if csr_city_rec%NOTFOUND then
4987: close csr_city_rec;
4988: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4989: fnd_message.set_token('PROCEDURE',
4990: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4991: fnd_message.set_token('STEP', '1');
4992: fnd_message.raise_error;
4985:
4986: if csr_city_rec%NOTFOUND then
4987: close csr_city_rec;
4988: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4989: fnd_message.set_token('PROCEDURE',
4990: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4991: fnd_message.set_token('STEP', '1');
4992: fnd_message.raise_error;
4993: end if;
4987: close csr_city_rec;
4988: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4989: fnd_message.set_token('PROCEDURE',
4990: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4991: fnd_message.set_token('STEP', '1');
4992: fnd_message.raise_error;
4993: end if;
4994:
4995: close csr_city_rec;
4988: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4989: fnd_message.set_token('PROCEDURE',
4990: 'pay_us_emp_dt_tax_rules.lock_city_tax_row');
4991: fnd_message.set_token('STEP', '1');
4992: fnd_message.raise_error;
4993: end if;
4994:
4995: close csr_city_rec;
4996:
5318: return;
5319:
5320: else
5321:
5322: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
5323: fnd_message.raise_error;
5324:
5325: end if;
5326:
5319:
5320: else
5321:
5322: fnd_message.set_name('PAY', 'FORM_RECORD_CHANGED');
5323: fnd_message.raise_error;
5324:
5325: end if;
5326:
5327: end lock_city_tax_row;
5388:
5389: fetch csr_filing_status into l_filing_status_code;
5390:
5391: if csr_filing_status%NOTFOUND then
5392: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5393: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5394: fnd_message.raise_error;
5395: end if;
5396:
5389: fetch csr_filing_status into l_filing_status_code;
5390:
5391: if csr_filing_status%NOTFOUND then
5392: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5393: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5394: fnd_message.raise_error;
5395: end if;
5396:
5397: close csr_filing_status;
5390:
5391: if csr_filing_status%NOTFOUND then
5392: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5393: fnd_message.set_token('LOOKUP_TYPE ','US_FIT_FILING_STATUS');
5394: fnd_message.raise_error;
5395: end if;
5396:
5397: close csr_filing_status;
5398:
5404: fetch csr_eic_fstatus into l_eic_fstatus_code;
5405:
5406: if csr_eic_fstatus%NOTFOUND then
5407:
5408: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5409: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5410: fnd_message.raise_error;
5411:
5412: end if;
5405:
5406: if csr_eic_fstatus%NOTFOUND then
5407:
5408: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5409: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5410: fnd_message.raise_error;
5411:
5412: end if;
5413:
5406: if csr_eic_fstatus%NOTFOUND then
5407:
5408: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5409: fnd_message.set_token('LOOKUP_TYPE ','US_EIC_FILING_STATUS');
5410: fnd_message.raise_error;
5411:
5412: end if;
5413:
5414: close csr_eic_fstatus;
5824: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_def_county_rec',2);
5825:
5826: if csr_filing_status%NOTFOUND then
5827:
5828: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5829: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5830: fnd_message.raise_error;
5831:
5832: end if;
5825:
5826: if csr_filing_status%NOTFOUND then
5827:
5828: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5829: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5830: fnd_message.raise_error;
5831:
5832: end if;
5833:
5826: if csr_filing_status%NOTFOUND then
5827:
5828: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
5829: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
5830: fnd_message.raise_error;
5831:
5832: end if;
5833:
5834: close csr_filing_status;
5997: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_def_city_rec',2);
5998:
5999: if csr_filing_status%NOTFOUND then
6000:
6001: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
6002: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
6003: fnd_message.raise_error;
6004:
6005: end if;
5998:
5999: if csr_filing_status%NOTFOUND then
6000:
6001: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
6002: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
6003: fnd_message.raise_error;
6004:
6005: end if;
6006:
5999: if csr_filing_status%NOTFOUND then
6000:
6001: fnd_message.set_name('PAY','HR_6091_DEF_MISSING_LOOKUPS');
6002: fnd_message.set_token('LOOKUP_TYPE ','US_LIT_FILING_STATUS');
6003: fnd_message.raise_error;
6004:
6005: end if;
6006:
6007: close csr_filing_status;
6704: fetch csr_get_codes into l_state_code, l_county_code,l_city_code,
6705: l_ovrd_state_code, l_ovrd_county_code,
6706: l_ovrd_city_code;
6707: if csr_get_codes%NOTFOUND then
6708: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6709: fnd_message.set_token('PROCEDURE',
6710: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6711: fnd_message.set_token('STEP','2');
6712: fnd_message.raise_error;
6705: l_ovrd_state_code, l_ovrd_county_code,
6706: l_ovrd_city_code;
6707: if csr_get_codes%NOTFOUND then
6708: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6709: fnd_message.set_token('PROCEDURE',
6710: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6711: fnd_message.set_token('STEP','2');
6712: fnd_message.raise_error;
6713: end if;
6707: if csr_get_codes%NOTFOUND then
6708: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6709: fnd_message.set_token('PROCEDURE',
6710: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6711: fnd_message.set_token('STEP','2');
6712: fnd_message.raise_error;
6713: end if;
6714: close csr_get_codes;
6715:
6708: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6709: fnd_message.set_token('PROCEDURE',
6710: 'pay_us_emp_dt_tax_rules.create_new_loc_rec');
6711: fnd_message.set_token('STEP','2');
6712: fnd_message.raise_error;
6713: end if;
6714: close csr_get_codes;
6715:
6716: end if;
6722:
6723: fetch csr_get_eff_date into l_default_date;
6724:
6725: if l_default_date is null then
6726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6727: fnd_message.set_token('PROCEDURE',
6728: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6729: fnd_message.set_token('STEP','1');
6730: fnd_message.raise_error;
6723: fetch csr_get_eff_date into l_default_date;
6724:
6725: if l_default_date is null then
6726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6727: fnd_message.set_token('PROCEDURE',
6728: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6729: fnd_message.set_token('STEP','1');
6730: fnd_message.raise_error;
6731: end if;
6725: if l_default_date is null then
6726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6727: fnd_message.set_token('PROCEDURE',
6728: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6729: fnd_message.set_token('STEP','1');
6730: fnd_message.raise_error;
6731: end if;
6732:
6733: close csr_get_eff_date;
6726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6727: fnd_message.set_token('PROCEDURE',
6728: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6729: fnd_message.set_token('STEP','1');
6730: fnd_message.raise_error;
6731: end if;
6732:
6733: close csr_get_eff_date;
6734:
6753: fetch csr_get_max_assign_end_dt into l_max_assign_end_dt;
6754:
6755:
6756: if csr_get_max_assign_end_dt%NOTFOUND then
6757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6758: fnd_message.set_token('PROCEDURE',
6759: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6760: fnd_message.set_token('STEP','3');
6761: fnd_message.raise_error;
6754:
6755:
6756: if csr_get_max_assign_end_dt%NOTFOUND then
6757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6758: fnd_message.set_token('PROCEDURE',
6759: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6760: fnd_message.set_token('STEP','3');
6761: fnd_message.raise_error;
6762: end if;
6756: if csr_get_max_assign_end_dt%NOTFOUND then
6757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6758: fnd_message.set_token('PROCEDURE',
6759: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6760: fnd_message.set_token('STEP','3');
6761: fnd_message.raise_error;
6762: end if;
6763:
6764: close csr_get_max_assign_end_dt;
6757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6758: fnd_message.set_token('PROCEDURE',
6759: 'pay_us_emp_dt_tax_rules.create_new_location_rec');
6760: fnd_message.set_token('STEP','3');
6761: fnd_message.raise_error;
6762: end if;
6763:
6764: close csr_get_max_assign_end_dt;
6765:
7120:
7121: if l_inp_value_id_table(i) = null or
7122: l_inp_value_id_table(i) = 0
7123: then
7124: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7125: fnd_message.set_token('1','INPUT VALUE');
7126: fnd_message.raise_error;
7127: end if;
7128:
7121: if l_inp_value_id_table(i) = null or
7122: l_inp_value_id_table(i) = 0
7123: then
7124: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7125: fnd_message.set_token('1','INPUT VALUE');
7126: fnd_message.raise_error;
7127: end if;
7128:
7129: end loop;
7122: l_inp_value_id_table(i) = 0
7123: then
7124: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7125: fnd_message.set_token('1','INPUT VALUE');
7126: fnd_message.raise_error;
7127: end if;
7128:
7129: end loop;
7130:
7139: P_session_date => p_session_date);
7140:
7141: if l_element_link_id is null or l_element_link_id = 0
7142: then
7143: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7144: fnd_message.set_token('1','ELEMENT LINK');
7145: fnd_message.raise_error;
7146: end if;
7147:
7140:
7141: if l_element_link_id is null or l_element_link_id = 0
7142: then
7143: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7144: fnd_message.set_token('1','ELEMENT LINK');
7145: fnd_message.raise_error;
7146: end if;
7147:
7148: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_entries_for_dates'
7141: if l_element_link_id is null or l_element_link_id = 0
7142: then
7143: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7144: fnd_message.set_token('1','ELEMENT LINK');
7145: fnd_message.raise_error;
7146: end if;
7147:
7148: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_entries_for_dates'
7149: ,4);
7156:
7157: if csr_ele_entry%NOTFOUND then
7158:
7159: close csr_ele_entry;
7160: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7161: fnd_message.set_token('PROCEDURE',
7162: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7163: '- SQLCODE:'|| to_char(sqlcode));
7164: fnd_message.set_token('STEP',to_char(l_step));
7157: if csr_ele_entry%NOTFOUND then
7158:
7159: close csr_ele_entry;
7160: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7161: fnd_message.set_token('PROCEDURE',
7162: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7163: '- SQLCODE:'|| to_char(sqlcode));
7164: fnd_message.set_token('STEP',to_char(l_step));
7165: fnd_message.raise_error;
7160: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7161: fnd_message.set_token('PROCEDURE',
7162: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7163: '- SQLCODE:'|| to_char(sqlcode));
7164: fnd_message.set_token('STEP',to_char(l_step));
7165: fnd_message.raise_error;
7166:
7167: end if;
7168:
7161: fnd_message.set_token('PROCEDURE',
7162: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7163: '- SQLCODE:'|| to_char(sqlcode));
7164: fnd_message.set_token('STEP',to_char(l_step));
7165: fnd_message.raise_error;
7166:
7167: end if;
7168:
7169: close csr_ele_entry;
7252: end if;
7253:
7254: exception
7255: when others then
7256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7257: fnd_message.set_token('PROCEDURE',
7258: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7259: '- SQLCODE:'|| to_char(sqlcode));
7260: fnd_message.set_token('STEP',to_char(l_step));
7253:
7254: exception
7255: when others then
7256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7257: fnd_message.set_token('PROCEDURE',
7258: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7259: '- SQLCODE:'|| to_char(sqlcode));
7260: fnd_message.set_token('STEP',to_char(l_step));
7261: fnd_message.raise_error;
7256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7257: fnd_message.set_token('PROCEDURE',
7258: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7259: '- SQLCODE:'|| to_char(sqlcode));
7260: fnd_message.set_token('STEP',to_char(l_step));
7261: fnd_message.raise_error;
7262:
7263: end del_updt_entries_for_dates;
7264:
7257: fnd_message.set_token('PROCEDURE',
7258: 'pay_us_emp_dt_tax_rules.del_updt_entries_for_dates' ||
7259: '- SQLCODE:'|| to_char(sqlcode));
7260: fnd_message.set_token('STEP',to_char(l_step));
7261: fnd_message.raise_error;
7262:
7263: end del_updt_entries_for_dates;
7264:
7265: /* Name : upd_del_entries
7461: open csr_tax_element;
7462:
7463: fetch csr_tax_element into l_element_type_id;
7464: if csr_tax_element%NOTFOUND then
7465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7466: fnd_message.set_token('PROCEDURE',
7467: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7468: fnd_message.set_token('STEP',to_char(l_step));
7469: fnd_message.raise_error;
7462:
7463: fetch csr_tax_element into l_element_type_id;
7464: if csr_tax_element%NOTFOUND then
7465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7466: fnd_message.set_token('PROCEDURE',
7467: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7468: fnd_message.set_token('STEP',to_char(l_step));
7469: fnd_message.raise_error;
7470: end if;
7464: if csr_tax_element%NOTFOUND then
7465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7466: fnd_message.set_token('PROCEDURE',
7467: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7468: fnd_message.set_token('STEP',to_char(l_step));
7469: fnd_message.raise_error;
7470: end if;
7471:
7472: close csr_tax_element;
7465: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7466: fnd_message.set_token('PROCEDURE',
7467: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates');
7468: fnd_message.set_token('STEP',to_char(l_step));
7469: fnd_message.raise_error;
7470: end if;
7471:
7472: close csr_tax_element;
7473:
7481: P_session_date => p_session_date);
7482:
7483: if l_element_link_id is null or l_element_link_id = 0
7484: then
7485: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7486: fnd_message.set_token('1','ELEMENT LINK');
7487: fnd_message.raise_error;
7488: end if;
7489:
7482:
7483: if l_element_link_id is null or l_element_link_id = 0
7484: then
7485: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7486: fnd_message.set_token('1','ELEMENT LINK');
7487: fnd_message.raise_error;
7488: end if;
7489:
7490: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ,3);
7483: if l_element_link_id is null or l_element_link_id = 0
7484: then
7485: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7486: fnd_message.set_token('1','ELEMENT LINK');
7487: fnd_message.raise_error;
7488: end if;
7489:
7490: hr_utility.set_location('pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ,3);
7491:
7497:
7498: if csr_wc_ele_entry%NOTFOUND then
7499:
7500: close csr_wc_ele_entry;
7501: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7502: fnd_message.set_token('PROCEDURE',
7503: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7504: '- SQLCODE:'|| to_char(sqlcode));
7505: fnd_message.set_token('STEP',to_char(l_step));
7498: if csr_wc_ele_entry%NOTFOUND then
7499:
7500: close csr_wc_ele_entry;
7501: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7502: fnd_message.set_token('PROCEDURE',
7503: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7504: '- SQLCODE:'|| to_char(sqlcode));
7505: fnd_message.set_token('STEP',to_char(l_step));
7506: fnd_message.raise_error;
7501: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7502: fnd_message.set_token('PROCEDURE',
7503: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7504: '- SQLCODE:'|| to_char(sqlcode));
7505: fnd_message.set_token('STEP',to_char(l_step));
7506: fnd_message.raise_error;
7507:
7508: end if;
7509:
7502: fnd_message.set_token('PROCEDURE',
7503: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7504: '- SQLCODE:'|| to_char(sqlcode));
7505: fnd_message.set_token('STEP',to_char(l_step));
7506: fnd_message.raise_error;
7507:
7508: end if;
7509:
7510: close csr_wc_ele_entry;
7570: end if;
7571:
7572: exception
7573: when others then
7574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7575: fnd_message.set_token('PROCEDURE',
7576: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7577: '- SQLCODE:'|| to_char(sqlcode));
7578: fnd_message.set_token('STEP',to_char(l_step));
7571:
7572: exception
7573: when others then
7574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7575: fnd_message.set_token('PROCEDURE',
7576: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7577: '- SQLCODE:'|| to_char(sqlcode));
7578: fnd_message.set_token('STEP',to_char(l_step));
7579: fnd_message.raise_error;
7574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7575: fnd_message.set_token('PROCEDURE',
7576: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7577: '- SQLCODE:'|| to_char(sqlcode));
7578: fnd_message.set_token('STEP',to_char(l_step));
7579: fnd_message.raise_error;
7580:
7581: end del_updt_wc_entry_for_dates;
7582:
7575: fnd_message.set_token('PROCEDURE',
7576: 'pay_us_emp_dt_tax_rules.del_updt_wc_entry_for_dates' ||
7577: '- SQLCODE:'|| to_char(sqlcode));
7578: fnd_message.set_token('STEP',to_char(l_step));
7579: fnd_message.raise_error;
7580:
7581: end del_updt_wc_entry_for_dates;
7582:
7583:
7777: fetch csr_get_next_location into l_next_location, l_next_end_date;
7778: if csr_get_next_location%NOTFOUND
7779: then
7780: close csr_get_next_location;
7781: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7782: fnd_message.set_token('PROCEDURE',
7783: 'pay_us_emp_dt_tax_rules.pull_percentage');
7784: fnd_message.set_token('STEP','1');
7785: fnd_message.raise_error;
7778: if csr_get_next_location%NOTFOUND
7779: then
7780: close csr_get_next_location;
7781: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7782: fnd_message.set_token('PROCEDURE',
7783: 'pay_us_emp_dt_tax_rules.pull_percentage');
7784: fnd_message.set_token('STEP','1');
7785: fnd_message.raise_error;
7786: end if;
7780: close csr_get_next_location;
7781: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7782: fnd_message.set_token('PROCEDURE',
7783: 'pay_us_emp_dt_tax_rules.pull_percentage');
7784: fnd_message.set_token('STEP','1');
7785: fnd_message.raise_error;
7786: end if;
7787:
7788: close csr_get_next_location;
7781: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7782: fnd_message.set_token('PROCEDURE',
7783: 'pay_us_emp_dt_tax_rules.pull_percentage');
7784: fnd_message.set_token('STEP','1');
7785: fnd_message.raise_error;
7786: end if;
7787:
7788: close csr_get_next_location;
7789:
7863: open csr_tax_element;
7864: fetch csr_tax_element into l_element_type_id;
7865: if csr_tax_element%NOTFOUND then
7866: close csr_tax_element;
7867: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7868: fnd_message.set_token('PROCEDURE',
7869: 'pay_us_emp_dt_tax_rules.pull_percentage');
7870: fnd_message.set_token('STEP','2');
7871: fnd_message.raise_error;
7864: fetch csr_tax_element into l_element_type_id;
7865: if csr_tax_element%NOTFOUND then
7866: close csr_tax_element;
7867: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7868: fnd_message.set_token('PROCEDURE',
7869: 'pay_us_emp_dt_tax_rules.pull_percentage');
7870: fnd_message.set_token('STEP','2');
7871: fnd_message.raise_error;
7872: end if;
7866: close csr_tax_element;
7867: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7868: fnd_message.set_token('PROCEDURE',
7869: 'pay_us_emp_dt_tax_rules.pull_percentage');
7870: fnd_message.set_token('STEP','2');
7871: fnd_message.raise_error;
7872: end if;
7873: close csr_tax_element;
7874:
7867: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7868: fnd_message.set_token('PROCEDURE',
7869: 'pay_us_emp_dt_tax_rules.pull_percentage');
7870: fnd_message.set_token('STEP','2');
7871: fnd_message.raise_error;
7872: end if;
7873: close csr_tax_element;
7874:
7875: /* Get element link */
7879: P_session_date => p_session_date);
7880:
7881: if l_element_link_id is null or l_element_link_id = 0
7882: then
7883: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7884: fnd_message.set_token('1','VERTEX');
7885: fnd_message.raise_error;
7886: end if;
7887:
7880:
7881: if l_element_link_id is null or l_element_link_id = 0
7882: then
7883: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7884: fnd_message.set_token('1','VERTEX');
7885: fnd_message.raise_error;
7886: end if;
7887:
7888: open csr_get_next_date(l_element_link_id, p_default_date);
7881: if l_element_link_id is null or l_element_link_id = 0
7882: then
7883: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
7884: fnd_message.set_token('1','VERTEX');
7885: fnd_message.raise_error;
7886: end if;
7887:
7888: open csr_get_next_date(l_element_link_id, p_default_date);
7889: fetch csr_get_next_date into l_validation_end_date;
7889: fetch csr_get_next_date into l_validation_end_date;
7890: if csr_get_next_date%NOTFOUND
7891: then
7892: close csr_get_next_date;
7893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7894: fnd_message.set_token('PROCEDURE',
7895: 'pay_us_emp_dt_tax_rules.pull_percentage');
7896: fnd_message.set_token('STEP','3');
7897: fnd_message.raise_error;
7890: if csr_get_next_date%NOTFOUND
7891: then
7892: close csr_get_next_date;
7893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7894: fnd_message.set_token('PROCEDURE',
7895: 'pay_us_emp_dt_tax_rules.pull_percentage');
7896: fnd_message.set_token('STEP','3');
7897: fnd_message.raise_error;
7898: end if;
7892: close csr_get_next_date;
7893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7894: fnd_message.set_token('PROCEDURE',
7895: 'pay_us_emp_dt_tax_rules.pull_percentage');
7896: fnd_message.set_token('STEP','3');
7897: fnd_message.raise_error;
7898: end if;
7899:
7900: close csr_get_next_date;
7893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7894: fnd_message.set_token('PROCEDURE',
7895: 'pay_us_emp_dt_tax_rules.pull_percentage');
7896: fnd_message.set_token('STEP','3');
7897: fnd_message.raise_error;
7898: end if;
7899:
7900: close csr_get_next_date;
7901:
8148: open csr_get_prev_date(p_element_link,l_eff_prev_date);
8149: fetch csr_get_prev_date into l_validation_start_date;
8150: if csr_get_prev_date%NOTFOUND then
8151: close csr_get_prev_date;
8152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8153: fnd_message.set_token('PROCEDURE',
8154: 'pay_us_emp_dt_tax_rules.backward_processing');
8155: fnd_message.set_token('STEP','1');
8156: fnd_message.raise_error;
8149: fetch csr_get_prev_date into l_validation_start_date;
8150: if csr_get_prev_date%NOTFOUND then
8151: close csr_get_prev_date;
8152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8153: fnd_message.set_token('PROCEDURE',
8154: 'pay_us_emp_dt_tax_rules.backward_processing');
8155: fnd_message.set_token('STEP','1');
8156: fnd_message.raise_error;
8157: end if;
8151: close csr_get_prev_date;
8152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8153: fnd_message.set_token('PROCEDURE',
8154: 'pay_us_emp_dt_tax_rules.backward_processing');
8155: fnd_message.set_token('STEP','1');
8156: fnd_message.raise_error;
8157: end if;
8158:
8159: /* deleting the previous set */
8152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8153: fnd_message.set_token('PROCEDURE',
8154: 'pay_us_emp_dt_tax_rules.backward_processing');
8155: fnd_message.set_token('STEP','1');
8156: fnd_message.raise_error;
8157: end if;
8158:
8159: /* deleting the previous set */
8160:
8194: fetch csr_get_eff_date into l_default_date;
8195:
8196: if l_default_date is null then
8197: close csr_get_eff_date;
8198: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8199: fnd_message.set_token('PROCEDURE',
8200: 'pay_us_emp_dt_tax_rules.correct_percentage');
8201: fnd_message.set_token('STEP','1');
8202: fnd_message.raise_error;
8195:
8196: if l_default_date is null then
8197: close csr_get_eff_date;
8198: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8199: fnd_message.set_token('PROCEDURE',
8200: 'pay_us_emp_dt_tax_rules.correct_percentage');
8201: fnd_message.set_token('STEP','1');
8202: fnd_message.raise_error;
8203: end if;
8197: close csr_get_eff_date;
8198: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8199: fnd_message.set_token('PROCEDURE',
8200: 'pay_us_emp_dt_tax_rules.correct_percentage');
8201: fnd_message.set_token('STEP','1');
8202: fnd_message.raise_error;
8203: end if;
8204:
8205: close csr_get_eff_date;
8198: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8199: fnd_message.set_token('PROCEDURE',
8200: 'pay_us_emp_dt_tax_rules.correct_percentage');
8201: fnd_message.set_token('STEP','1');
8202: fnd_message.raise_error;
8203: end if;
8204:
8205: close csr_get_eff_date;
8206:
8208: open csr_tax_element;
8209: fetch csr_tax_element into l_element_type_id;
8210: if csr_tax_element%NOTFOUND then
8211: close csr_tax_element;
8212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8213: fnd_message.set_token('PROCEDURE',
8214: 'pay_us_emp_dt_tax_rules.correct_percentage');
8215: fnd_message.set_token('STEP','2');
8216: fnd_message.raise_error;
8209: fetch csr_tax_element into l_element_type_id;
8210: if csr_tax_element%NOTFOUND then
8211: close csr_tax_element;
8212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8213: fnd_message.set_token('PROCEDURE',
8214: 'pay_us_emp_dt_tax_rules.correct_percentage');
8215: fnd_message.set_token('STEP','2');
8216: fnd_message.raise_error;
8217: end if;
8211: close csr_tax_element;
8212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8213: fnd_message.set_token('PROCEDURE',
8214: 'pay_us_emp_dt_tax_rules.correct_percentage');
8215: fnd_message.set_token('STEP','2');
8216: fnd_message.raise_error;
8217: end if;
8218: close csr_tax_element;
8219:
8212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8213: fnd_message.set_token('PROCEDURE',
8214: 'pay_us_emp_dt_tax_rules.correct_percentage');
8215: fnd_message.set_token('STEP','2');
8216: fnd_message.raise_error;
8217: end if;
8218: close csr_tax_element;
8219:
8220: hr_utility.set_location('pay_us_emp_dt_tax_rules.correct_percentage',4);
8224: P_element_type_id => l_element_type_id,
8225: P_session_date => p_session_date);
8226:
8227: if l_element_link_id is null or l_element_link_id = 0 then
8228: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8229: fnd_message.set_token('1','VERTEX');
8230: fnd_message.raise_error;
8231: end if;
8232:
8225: P_session_date => p_session_date);
8226:
8227: if l_element_link_id is null or l_element_link_id = 0 then
8228: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8229: fnd_message.set_token('1','VERTEX');
8230: fnd_message.raise_error;
8231: end if;
8232:
8233:
8226:
8227: if l_element_link_id is null or l_element_link_id = 0 then
8228: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
8229: fnd_message.set_token('1','VERTEX');
8230: fnd_message.raise_error;
8231: end if;
8232:
8233:
8234: /* Let's handle the condition where there is just one set of
8327: l_pef_prev_date;
8328:
8329: if csr_ele_entry%NOTFOUND then
8330: close csr_ele_entry;
8331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8332: fnd_message.set_token('PROCEDURE',
8333: 'pay_us_emp_dt_tax_rules.correct_percentage');
8334: fnd_message.set_token('STEP','2');
8335: fnd_message.raise_error;
8328:
8329: if csr_ele_entry%NOTFOUND then
8330: close csr_ele_entry;
8331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8332: fnd_message.set_token('PROCEDURE',
8333: 'pay_us_emp_dt_tax_rules.correct_percentage');
8334: fnd_message.set_token('STEP','2');
8335: fnd_message.raise_error;
8336: end if;
8330: close csr_ele_entry;
8331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8332: fnd_message.set_token('PROCEDURE',
8333: 'pay_us_emp_dt_tax_rules.correct_percentage');
8334: fnd_message.set_token('STEP','2');
8335: fnd_message.raise_error;
8336: end if;
8337:
8338: close csr_ele_entry;
8331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8332: fnd_message.set_token('PROCEDURE',
8333: 'pay_us_emp_dt_tax_rules.correct_percentage');
8334: fnd_message.set_token('STEP','2');
8335: fnd_message.raise_error;
8336: end if;
8337:
8338: close csr_ele_entry;
8339:
8806: open csr_get_next_date(l_element_link_id,l_pef_next_date);
8807: fetch csr_get_next_date into l_next_loc_end_date;
8808: if csr_get_next_date%NOTFOUND then
8809: close csr_get_next_date;
8810: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8811: fnd_message.set_token('PROCEDURE',
8812: 'pay_us_emp_dt_tax_rules.correct_percentage');
8813: fnd_message.set_token('STEP','4');
8814: fnd_message.raise_error;
8807: fetch csr_get_next_date into l_next_loc_end_date;
8808: if csr_get_next_date%NOTFOUND then
8809: close csr_get_next_date;
8810: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8811: fnd_message.set_token('PROCEDURE',
8812: 'pay_us_emp_dt_tax_rules.correct_percentage');
8813: fnd_message.set_token('STEP','4');
8814: fnd_message.raise_error;
8815: end if;
8809: close csr_get_next_date;
8810: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8811: fnd_message.set_token('PROCEDURE',
8812: 'pay_us_emp_dt_tax_rules.correct_percentage');
8813: fnd_message.set_token('STEP','4');
8814: fnd_message.raise_error;
8815: end if;
8816:
8817: close csr_get_next_date;
8810: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8811: fnd_message.set_token('PROCEDURE',
8812: 'pay_us_emp_dt_tax_rules.correct_percentage');
8813: fnd_message.set_token('STEP','4');
8814: fnd_message.raise_error;
8815: end if;
8816:
8817: close csr_get_next_date;
8818:
8950: open csr_get_next_date(l_element_link_id,l_pef_next_date);
8951: fetch csr_get_next_date into l_next_loc_end_date;
8952: if csr_get_next_date%NOTFOUND then
8953: close csr_get_next_date;
8954: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8955: fnd_message.set_token('PROCEDURE',
8956: 'pay_us_emp_dt_tax_rules.correct_percentage');
8957: fnd_message.set_token('STEP','4');
8958: fnd_message.raise_error;
8951: fetch csr_get_next_date into l_next_loc_end_date;
8952: if csr_get_next_date%NOTFOUND then
8953: close csr_get_next_date;
8954: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8955: fnd_message.set_token('PROCEDURE',
8956: 'pay_us_emp_dt_tax_rules.correct_percentage');
8957: fnd_message.set_token('STEP','4');
8958: fnd_message.raise_error;
8959: end if;
8953: close csr_get_next_date;
8954: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8955: fnd_message.set_token('PROCEDURE',
8956: 'pay_us_emp_dt_tax_rules.correct_percentage');
8957: fnd_message.set_token('STEP','4');
8958: fnd_message.raise_error;
8959: end if;
8960:
8961: close csr_get_next_date;
8954: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8955: fnd_message.set_token('PROCEDURE',
8956: 'pay_us_emp_dt_tax_rules.correct_percentage');
8957: fnd_message.set_token('STEP','4');
8958: fnd_message.raise_error;
8959: end if;
8960:
8961: close csr_get_next_date;
8962:
9188:
9189: if csr_tax_element%NOTFOUND then
9190:
9191: close csr_tax_element;
9192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9193: fnd_message.set_token('PROCEDURE',
9194: 'pay_us_emp_dt_tax_rules.update_percentage');
9195: fnd_message.set_token('STEP','1');
9196: fnd_message.raise_error;
9189: if csr_tax_element%NOTFOUND then
9190:
9191: close csr_tax_element;
9192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9193: fnd_message.set_token('PROCEDURE',
9194: 'pay_us_emp_dt_tax_rules.update_percentage');
9195: fnd_message.set_token('STEP','1');
9196: fnd_message.raise_error;
9197:
9191: close csr_tax_element;
9192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9193: fnd_message.set_token('PROCEDURE',
9194: 'pay_us_emp_dt_tax_rules.update_percentage');
9195: fnd_message.set_token('STEP','1');
9196: fnd_message.raise_error;
9197:
9198: end if;
9199:
9192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9193: fnd_message.set_token('PROCEDURE',
9194: 'pay_us_emp_dt_tax_rules.update_percentage');
9195: fnd_message.set_token('STEP','1');
9196: fnd_message.raise_error;
9197:
9198: end if;
9199:
9200: close csr_tax_element;
9207: P_session_date => p_session_date);
9208:
9209: if l_element_link_id is null or l_element_link_id = 0 then
9210:
9211: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9212: fnd_message.set_token('1','VERTEX');
9213: fnd_message.raise_error;
9214:
9215: end if;
9208:
9209: if l_element_link_id is null or l_element_link_id = 0 then
9210:
9211: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9212: fnd_message.set_token('1','VERTEX');
9213: fnd_message.raise_error;
9214:
9215: end if;
9216:
9209: if l_element_link_id is null or l_element_link_id = 0 then
9210:
9211: fnd_message.set_name('PAY', 'HR_13140_TAX_ELEMENT_ERROR');
9212: fnd_message.set_token('1','VERTEX');
9213: fnd_message.raise_error;
9214:
9215: end if;
9216:
9217: /* Get the effective start date, effective end date and (effective end date + 1)
9223:
9224: if csr_get_dates%NOTFOUND then
9225:
9226: close csr_get_dates;
9227: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9228: fnd_message.set_token('PROCEDURE',
9229: 'pay_us_emp_dt_tax_rules.update_percentage');
9230: fnd_message.set_token('STEP','2');
9231: fnd_message.raise_error;
9224: if csr_get_dates%NOTFOUND then
9225:
9226: close csr_get_dates;
9227: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9228: fnd_message.set_token('PROCEDURE',
9229: 'pay_us_emp_dt_tax_rules.update_percentage');
9230: fnd_message.set_token('STEP','2');
9231: fnd_message.raise_error;
9232:
9226: close csr_get_dates;
9227: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9228: fnd_message.set_token('PROCEDURE',
9229: 'pay_us_emp_dt_tax_rules.update_percentage');
9230: fnd_message.set_token('STEP','2');
9231: fnd_message.raise_error;
9232:
9233: end if;
9234:
9227: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9228: fnd_message.set_token('PROCEDURE',
9229: 'pay_us_emp_dt_tax_rules.update_percentage');
9230: fnd_message.set_token('STEP','2');
9231: fnd_message.raise_error;
9232:
9233: end if;
9234:
9235: close csr_get_dates;
9338:
9339: if csr_get_next_date%NOTFOUND then
9340:
9341: close csr_get_next_date;
9342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9343: fnd_message.set_token('PROCEDURE',
9344: 'pay_us_emp_dt_tax_rules.update_percentage');
9345: fnd_message.set_token('STEP','2');
9346: fnd_message.raise_error;
9339: if csr_get_next_date%NOTFOUND then
9340:
9341: close csr_get_next_date;
9342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9343: fnd_message.set_token('PROCEDURE',
9344: 'pay_us_emp_dt_tax_rules.update_percentage');
9345: fnd_message.set_token('STEP','2');
9346: fnd_message.raise_error;
9347:
9341: close csr_get_next_date;
9342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9343: fnd_message.set_token('PROCEDURE',
9344: 'pay_us_emp_dt_tax_rules.update_percentage');
9345: fnd_message.set_token('STEP','2');
9346: fnd_message.raise_error;
9347:
9348: end if;
9349:
9342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9343: fnd_message.set_token('PROCEDURE',
9344: 'pay_us_emp_dt_tax_rules.update_percentage');
9345: fnd_message.set_token('STEP','2');
9346: fnd_message.raise_error;
9347:
9348: end if;
9349:
9350: /* Pull forward the records as of the session date to
9492: open csr_get_loc_state;
9493: fetch csr_get_loc_state into l_work_state_code;
9494: if csr_get_loc_state%NOTFOUND then
9495: close csr_get_loc_state;
9496: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9497: fnd_message.set_token('PROCEDURE',
9498: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9499: fnd_message.set_token('STEP',to_char(l_step));
9500: fnd_message.raise_error;
9493: fetch csr_get_loc_state into l_work_state_code;
9494: if csr_get_loc_state%NOTFOUND then
9495: close csr_get_loc_state;
9496: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9497: fnd_message.set_token('PROCEDURE',
9498: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9499: fnd_message.set_token('STEP',to_char(l_step));
9500: fnd_message.raise_error;
9501: end if;
9495: close csr_get_loc_state;
9496: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9497: fnd_message.set_token('PROCEDURE',
9498: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9499: fnd_message.set_token('STEP',to_char(l_step));
9500: fnd_message.raise_error;
9501: end if;
9502: close csr_get_loc_state;
9503:
9496: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9497: fnd_message.set_token('PROCEDURE',
9498: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9499: fnd_message.set_token('STEP',to_char(l_step));
9500: fnd_message.raise_error;
9501: end if;
9502: close csr_get_loc_state;
9503:
9504: l_step := 2;
9517: l_step := 5;
9518: fetch csr_lck_fed_row into l_row_id;
9519: if csr_lck_fed_row%NOTFOUND then
9520: close csr_lck_fed_row;
9521: fnd_message.set_name('FND','FORM_UNABLE_TO_RESERVE_RECORD');
9522: fnd_message.raise_error;
9523: end if;
9524: close csr_lck_fed_row;
9525:
9518: fetch csr_lck_fed_row into l_row_id;
9519: if csr_lck_fed_row%NOTFOUND then
9520: close csr_lck_fed_row;
9521: fnd_message.set_name('FND','FORM_UNABLE_TO_RESERVE_RECORD');
9522: fnd_message.raise_error;
9523: end if;
9524: close csr_lck_fed_row;
9525:
9526: /* Update the federal tax record for the SUI state */
9553: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9554: fetch csr_get_fed_details into l_fed_rec;
9555: if csr_get_fed_details%NOTFOUND then
9556: close csr_get_fed_details;
9557: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9558: fnd_message.set_token('PROCEDURE',
9559: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9560: fnd_message.set_token('STEP',to_char(l_step));
9561: fnd_message.raise_error;
9554: fetch csr_get_fed_details into l_fed_rec;
9555: if csr_get_fed_details%NOTFOUND then
9556: close csr_get_fed_details;
9557: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9558: fnd_message.set_token('PROCEDURE',
9559: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9560: fnd_message.set_token('STEP',to_char(l_step));
9561: fnd_message.raise_error;
9562: end if;
9556: close csr_get_fed_details;
9557: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9558: fnd_message.set_token('PROCEDURE',
9559: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9560: fnd_message.set_token('STEP',to_char(l_step));
9561: fnd_message.raise_error;
9562: end if;
9563: close csr_get_fed_details;
9564:
9557: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9558: fnd_message.set_token('PROCEDURE',
9559: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9560: fnd_message.set_token('STEP',to_char(l_step));
9561: fnd_message.raise_error;
9562: end if;
9563: close csr_get_fed_details;
9564:
9565: /* Update the Federal tax record as of the p_effective_start_date */
9785: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9786: fetch csr_get_fed_details into l_fed_rec;
9787: if csr_get_fed_details%NOTFOUND then
9788: close csr_get_fed_details;
9789: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9790: fnd_message.set_token('PROCEDURE',
9791: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9792: fnd_message.set_token('STEP',to_char(l_step));
9793: fnd_message.raise_error;
9786: fetch csr_get_fed_details into l_fed_rec;
9787: if csr_get_fed_details%NOTFOUND then
9788: close csr_get_fed_details;
9789: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9790: fnd_message.set_token('PROCEDURE',
9791: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9792: fnd_message.set_token('STEP',to_char(l_step));
9793: fnd_message.raise_error;
9794: end if;
9788: close csr_get_fed_details;
9789: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9790: fnd_message.set_token('PROCEDURE',
9791: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9792: fnd_message.set_token('STEP',to_char(l_step));
9793: fnd_message.raise_error;
9794: end if;
9795: close csr_get_fed_details;
9796:
9789: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
9790: fnd_message.set_token('PROCEDURE',
9791: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
9792: fnd_message.set_token('STEP',to_char(l_step));
9793: fnd_message.raise_error;
9794: end if;
9795: close csr_get_fed_details;
9796:
9797: /* Update the Federal tax record as of the p_effective_start_date */
10036: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
10037: fetch csr_get_fed_details into l_fed_rec;
10038: if csr_get_fed_details%NOTFOUND then
10039: close csr_get_fed_details;
10040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10041: fnd_message.set_token('PROCEDURE',
10042: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10043: fnd_message.set_token('STEP',to_char(l_step));
10044: fnd_message.raise_error;
10037: fetch csr_get_fed_details into l_fed_rec;
10038: if csr_get_fed_details%NOTFOUND then
10039: close csr_get_fed_details;
10040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10041: fnd_message.set_token('PROCEDURE',
10042: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10043: fnd_message.set_token('STEP',to_char(l_step));
10044: fnd_message.raise_error;
10045: end if;
10039: close csr_get_fed_details;
10040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10041: fnd_message.set_token('PROCEDURE',
10042: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10043: fnd_message.set_token('STEP',to_char(l_step));
10044: fnd_message.raise_error;
10045: end if;
10046: close csr_get_fed_details;
10047:
10040: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10041: fnd_message.set_token('PROCEDURE',
10042: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10043: fnd_message.set_token('STEP',to_char(l_step));
10044: fnd_message.raise_error;
10045: end if;
10046: close csr_get_fed_details;
10047:
10048: /* Update the Federal tax record as of the p_effective_end_date + 1 */
10268: open csr_get_fed_details(l_eff_start_date, p_effective_end_date);
10269: fetch csr_get_fed_details into l_fed_rec;
10270: if csr_get_fed_details%NOTFOUND then
10271: close csr_get_fed_details;
10272: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10273: fnd_message.set_token('PROCEDURE',
10274: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10275: fnd_message.set_token('STEP',to_char(l_step));
10276: fnd_message.raise_error;
10269: fetch csr_get_fed_details into l_fed_rec;
10270: if csr_get_fed_details%NOTFOUND then
10271: close csr_get_fed_details;
10272: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10273: fnd_message.set_token('PROCEDURE',
10274: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10275: fnd_message.set_token('STEP',to_char(l_step));
10276: fnd_message.raise_error;
10277: end if;
10271: close csr_get_fed_details;
10272: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10273: fnd_message.set_token('PROCEDURE',
10274: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10275: fnd_message.set_token('STEP',to_char(l_step));
10276: fnd_message.raise_error;
10277: end if;
10278: close csr_get_fed_details;
10279: */
10272: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10273: fnd_message.set_token('PROCEDURE',
10274: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10275: fnd_message.set_token('STEP',to_char(l_step));
10276: fnd_message.raise_error;
10277: end if;
10278: close csr_get_fed_details;
10279: */
10280:
10482: close csr_get_fed_rows;
10483:
10484: exception
10485: when others then
10486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10487: fnd_message.set_token('PROCEDURE',
10488: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10489: fnd_message.set_token('STEP',to_char(l_step));
10490: fnd_message.raise_error;
10483:
10484: exception
10485: when others then
10486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10487: fnd_message.set_token('PROCEDURE',
10488: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10489: fnd_message.set_token('STEP',to_char(l_step));
10490: fnd_message.raise_error;
10491: end correct_wc_entry;
10485: when others then
10486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10487: fnd_message.set_token('PROCEDURE',
10488: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10489: fnd_message.set_token('STEP',to_char(l_step));
10490: fnd_message.raise_error;
10491: end correct_wc_entry;
10492:
10493:
10486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10487: fnd_message.set_token('PROCEDURE',
10488: 'pay_us_emp_dt_tax_rules.correct_wc_entry');
10489: fnd_message.set_token('STEP',to_char(l_step));
10490: fnd_message.raise_error;
10491: end correct_wc_entry;
10492:
10493:
10494: procedure change_wc_entry (p_assignment_id in number,
10559: where assignment_id = p_assignment_id
10560: and l_ef_date between effective_start_date and effective_end_date;
10561:
10562: if sql%notfound then
10563: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10564: fnd_message.set_token('PROCEDURE',l_proc);
10565: fnd_message.set_token('STEP','2');
10566: fnd_message.raise_error;
10567: end if;
10560: and l_ef_date between effective_start_date and effective_end_date;
10561:
10562: if sql%notfound then
10563: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10564: fnd_message.set_token('PROCEDURE',l_proc);
10565: fnd_message.set_token('STEP','2');
10566: fnd_message.raise_error;
10567: end if;
10568:
10561:
10562: if sql%notfound then
10563: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10564: fnd_message.set_token('PROCEDURE',l_proc);
10565: fnd_message.set_token('STEP','2');
10566: fnd_message.raise_error;
10567: end if;
10568:
10569: update PAY_US_EMP_STATE_TAX_RULES_F
10562: if sql%notfound then
10563: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10564: fnd_message.set_token('PROCEDURE',l_proc);
10565: fnd_message.set_token('STEP','2');
10566: fnd_message.raise_error;
10567: end if;
10568:
10569: update PAY_US_EMP_STATE_TAX_RULES_F
10570: set effective_start_date = p_new_start_date
10571: where assignment_id = p_assignment_id
10572: and l_ef_date between effective_start_date and effective_end_date;
10573:
10574: if sql%notfound then
10575: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10576: fnd_message.set_token('PROCEDURE',l_proc);
10577: fnd_message.set_token('STEP','3');
10578: fnd_message.raise_error;
10579: end if;
10572: and l_ef_date between effective_start_date and effective_end_date;
10573:
10574: if sql%notfound then
10575: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10576: fnd_message.set_token('PROCEDURE',l_proc);
10577: fnd_message.set_token('STEP','3');
10578: fnd_message.raise_error;
10579: end if;
10580:
10573:
10574: if sql%notfound then
10575: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10576: fnd_message.set_token('PROCEDURE',l_proc);
10577: fnd_message.set_token('STEP','3');
10578: fnd_message.raise_error;
10579: end if;
10580:
10581: update PAY_US_EMP_COUNTY_TAX_RULES_F
10574: if sql%notfound then
10575: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10576: fnd_message.set_token('PROCEDURE',l_proc);
10577: fnd_message.set_token('STEP','3');
10578: fnd_message.raise_error;
10579: end if;
10580:
10581: update PAY_US_EMP_COUNTY_TAX_RULES_F
10582: set effective_start_date = p_new_start_date
10583: where assignment_id = p_assignment_id
10584: and l_ef_date between effective_start_date and effective_end_date;
10585:
10586: if sql%notfound then
10587: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10588: fnd_message.set_token('PROCEDURE',l_proc);
10589: fnd_message.set_token('STEP','4');
10590: fnd_message.raise_error;
10591: end if;
10584: and l_ef_date between effective_start_date and effective_end_date;
10585:
10586: if sql%notfound then
10587: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10588: fnd_message.set_token('PROCEDURE',l_proc);
10589: fnd_message.set_token('STEP','4');
10590: fnd_message.raise_error;
10591: end if;
10592:
10585:
10586: if sql%notfound then
10587: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10588: fnd_message.set_token('PROCEDURE',l_proc);
10589: fnd_message.set_token('STEP','4');
10590: fnd_message.raise_error;
10591: end if;
10592:
10593: update PAY_US_EMP_CITY_TAX_RULES_F
10586: if sql%notfound then
10587: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10588: fnd_message.set_token('PROCEDURE',l_proc);
10589: fnd_message.set_token('STEP','4');
10590: fnd_message.raise_error;
10591: end if;
10592:
10593: update PAY_US_EMP_CITY_TAX_RULES_F
10594: set effective_start_date = p_new_start_date
10595: where assignment_id = p_assignment_id
10596: and l_ef_date between effective_start_date and effective_end_date;
10597:
10598: if sql%notfound then
10599: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10600: fnd_message.set_token('PROCEDURE',l_proc);
10601: fnd_message.set_token('STEP','5');
10602: fnd_message.raise_error;
10603: end if;
10596: and l_ef_date between effective_start_date and effective_end_date;
10597:
10598: if sql%notfound then
10599: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10600: fnd_message.set_token('PROCEDURE',l_proc);
10601: fnd_message.set_token('STEP','5');
10602: fnd_message.raise_error;
10603: end if;
10604:
10597:
10598: if sql%notfound then
10599: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10600: fnd_message.set_token('PROCEDURE',l_proc);
10601: fnd_message.set_token('STEP','5');
10602: fnd_message.raise_error;
10603: end if;
10604:
10605: /* Next delete any orphaned rows */
10598: if sql%notfound then
10599: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
10600: fnd_message.set_token('PROCEDURE',l_proc);
10601: fnd_message.set_token('STEP','5');
10602: fnd_message.raise_error;
10603: end if;
10604:
10605: /* Next delete any orphaned rows */
10606: if p_new_start_date > p_default_date then
10792: p_res_city_name => l_res_city_name);
10793:
10794: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',2);
10795: if l_res_state_code is null then
10796: fnd_message.set_name('PER', 'PER_52985_ADD_NO_STATE_SET');
10797: fnd_message.raise_error;
10798: end if;
10799:
10800: if l_res_county_code is null then
10793:
10794: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',2);
10795: if l_res_state_code is null then
10796: fnd_message.set_name('PER', 'PER_52985_ADD_NO_STATE_SET');
10797: fnd_message.raise_error;
10798: end if;
10799:
10800: if l_res_county_code is null then
10801: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10797: fnd_message.raise_error;
10798: end if;
10799:
10800: if l_res_county_code is null then
10801: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10802: fnd_message.raise_error;
10803: end if;
10804:
10805: if l_res_city_code is null then
10798: end if;
10799:
10800: if l_res_county_code is null then
10801: fnd_message.set_name('PER', 'PER_52984_ADD_NO_COUNTY_SET');
10802: fnd_message.raise_error;
10803: end if;
10804:
10805: if l_res_city_code is null then
10806: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10802: fnd_message.raise_error;
10803: end if;
10804:
10805: if l_res_city_code is null then
10806: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10807: fnd_message.raise_error;
10808: end if;
10809:
10810: /* Check to see if the address has an override or not . If there is
10803: end if;
10804:
10805: if l_res_city_code is null then
10806: fnd_message.set_name('PER', 'PER_52986_ADD_NO_CITY_SET');
10807: fnd_message.raise_error;
10808: end if;
10809:
10810: /* Check to see if the address has an override or not . If there is
10811: an override for the address then get the non override address for
10856: );
10857:
10858: if l_work_state_code is null or l_work_county_code is null
10859: or l_work_city_code is null then
10860: fnd_message.set_name('PAY', 'PY_51133_TXADJ_INVALID_CITY');
10861: fnd_message.raise_error;
10862: end if;
10863:
10864: /* Insert the default Federal tax Record */
10857:
10858: if l_work_state_code is null or l_work_county_code is null
10859: or l_work_city_code is null then
10860: fnd_message.set_name('PAY', 'PY_51133_TXADJ_INVALID_CITY');
10861: fnd_message.raise_error;
10862: end if;
10863:
10864: /* Insert the default Federal tax Record */
10865:
11156:
11157: /* message('Future dated location changes exist for which the
11158: defaulting criteria might not be satisfied.') */
11159:
11160: fnd_message.set_name('PAY', 'PAY_52299_TAX_FUT_LOC');
11161: fnd_message.raise_error;
11162:
11163: end if;
11164:
11157: /* message('Future dated location changes exist for which the
11158: defaulting criteria might not be satisfied.') */
11159:
11160: fnd_message.set_name('PAY', 'PAY_52299_TAX_FUT_LOC');
11161: fnd_message.raise_error;
11162:
11163: end if;
11164:
11165: /* Get the max effective end date of the assignment.
11173:
11174: if l_effective_end_date is null then
11175:
11176: close csr_asg_end_date;
11177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11178: fnd_message.set_token('PROCEDURE',
11179: 'pay_us_emp_dt_tax_rules.check_defaulting');
11180: fnd_message.set_token('STEP','1');
11181: fnd_message.raise_error;
11174: if l_effective_end_date is null then
11175:
11176: close csr_asg_end_date;
11177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11178: fnd_message.set_token('PROCEDURE',
11179: 'pay_us_emp_dt_tax_rules.check_defaulting');
11180: fnd_message.set_token('STEP','1');
11181: fnd_message.raise_error;
11182:
11176: close csr_asg_end_date;
11177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11178: fnd_message.set_token('PROCEDURE',
11179: 'pay_us_emp_dt_tax_rules.check_defaulting');
11180: fnd_message.set_token('STEP','1');
11181: fnd_message.raise_error;
11182:
11183: end if;
11184:
11177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11178: fnd_message.set_token('PROCEDURE',
11179: 'pay_us_emp_dt_tax_rules.check_defaulting');
11180: fnd_message.set_token('STEP','1');
11181: fnd_message.raise_error;
11182:
11183: end if;
11184:
11185: close csr_asg_end_date;
11679:
11680: if l_default_date is null then
11681:
11682: close csr_get_default_date;
11683: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11684: fnd_message.set_token('PROCEDURE',
11685: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11686: fnd_message.set_token('STEP','1');
11687: fnd_message.raise_error;
11680: if l_default_date is null then
11681:
11682: close csr_get_default_date;
11683: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11684: fnd_message.set_token('PROCEDURE',
11685: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11686: fnd_message.set_token('STEP','1');
11687: fnd_message.raise_error;
11688:
11682: close csr_get_default_date;
11683: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11684: fnd_message.set_token('PROCEDURE',
11685: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11686: fnd_message.set_token('STEP','1');
11687: fnd_message.raise_error;
11688:
11689: end if;
11690:
11683: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11684: fnd_message.set_token('PROCEDURE',
11685: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11686: fnd_message.set_token('STEP','1');
11687: fnd_message.raise_error;
11688:
11689: end if;
11690:
11691: close csr_get_default_date;
11795:
11796: if csr_get_default_date%NOTFOUND then
11797:
11798: close csr_get_default_date;
11799: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11800: fnd_message.set_token('PROCEDURE',
11801: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11802: fnd_message.set_token('STEP','2');
11803: fnd_message.raise_error;
11796: if csr_get_default_date%NOTFOUND then
11797:
11798: close csr_get_default_date;
11799: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11800: fnd_message.set_token('PROCEDURE',
11801: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11802: fnd_message.set_token('STEP','2');
11803: fnd_message.raise_error;
11804:
11798: close csr_get_default_date;
11799: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11800: fnd_message.set_token('PROCEDURE',
11801: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11802: fnd_message.set_token('STEP','2');
11803: fnd_message.raise_error;
11804:
11805: end if;
11806:
11799: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
11800: fnd_message.set_token('PROCEDURE',
11801: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
11802: fnd_message.set_token('STEP','2');
11803: fnd_message.raise_error;
11804:
11805: end if;
11806:
11807: close csr_get_default_date;
11905:
11906: /* There are some more assignment records without the
11907: tax records. So, error it out */
11908:
11909: fnd_message.set_name('PAY', 'PAY_52292_TAX_DEF_CRT');
11910: fnd_message.raise_error;
11911:
11912: else
11913:
11906: /* There are some more assignment records without the
11907: tax records. So, error it out */
11908:
11909: fnd_message.set_name('PAY', 'PAY_52292_TAX_DEF_CRT');
11910: fnd_message.raise_error;
11911:
11912: else
11913:
11914: /* First update the tax rules records */
12040:
12041: if csr_get_end_date%NOTFOUND then
12042:
12043: close csr_get_end_date;
12044: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12045: fnd_message.set_token('PROCEDURE',
12046: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12047: fnd_message.set_token('STEP','3');
12048: fnd_message.raise_error;
12041: if csr_get_end_date%NOTFOUND then
12042:
12043: close csr_get_end_date;
12044: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12045: fnd_message.set_token('PROCEDURE',
12046: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12047: fnd_message.set_token('STEP','3');
12048: fnd_message.raise_error;
12049:
12043: close csr_get_end_date;
12044: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12045: fnd_message.set_token('PROCEDURE',
12046: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12047: fnd_message.set_token('STEP','3');
12048: fnd_message.raise_error;
12049:
12050: end if;
12051:
12044: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12045: fnd_message.set_token('PROCEDURE',
12046: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12047: fnd_message.set_token('STEP','3');
12048: fnd_message.raise_error;
12049:
12050: end if;
12051:
12052: close csr_get_end_date;
12166: fetch csr_loc_state_code into l_loc_state_code;
12167:
12168: if csr_loc_state_code%NOTFOUND then
12169: close csr_loc_state_code;
12170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12171: fnd_message.set_token('PROCEDURE',
12172: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12173: fnd_message.set_token('STEP','10');
12174: fnd_message.raise_error;
12167:
12168: if csr_loc_state_code%NOTFOUND then
12169: close csr_loc_state_code;
12170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12171: fnd_message.set_token('PROCEDURE',
12172: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12173: fnd_message.set_token('STEP','10');
12174: fnd_message.raise_error;
12175: end if;
12169: close csr_loc_state_code;
12170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12171: fnd_message.set_token('PROCEDURE',
12172: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12173: fnd_message.set_token('STEP','10');
12174: fnd_message.raise_error;
12175: end if;
12176:
12177: close csr_loc_state_code;
12170: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
12171: fnd_message.set_token('PROCEDURE',
12172: 'pay_us_emp_dt_tax_rules.default_tax_with_validation');
12173: fnd_message.set_token('STEP','10');
12174: fnd_message.raise_error;
12175: end if;
12176:
12177: close csr_loc_state_code;
12178:
12472: if p_withholding_allowances > 1 and not
12473: (l_pei_information9 in ('CA','MX','KS') or (l_student_flag ='Yes' and l_pei_information9 = 'IN'))
12474: then
12475: l_warning := 'PAY_US_CHK_NRA_W4_ALLOWANCES';
12476: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_W4_ALLOWANCES');
12477: fnd_message.raise_error;
12478: end if;
12479: if p_filing_status_code <> '01'
12480: then
12473: (l_pei_information9 in ('CA','MX','KS') or (l_student_flag ='Yes' and l_pei_information9 = 'IN'))
12474: then
12475: l_warning := 'PAY_US_CHK_NRA_W4_ALLOWANCES';
12476: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_W4_ALLOWANCES');
12477: fnd_message.raise_error;
12478: end if;
12479: if p_filing_status_code <> '01'
12480: then
12481: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12478: end if;
12479: if p_filing_status_code <> '01'
12480: then
12481: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12482: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FILING_STATUS');
12483: fnd_message.raise_error;
12484: end if;
12485: if (p_fit_exempt = 'Y')
12486: then
12479: if p_filing_status_code <> '01'
12480: then
12481: l_warning := 'PAY_US_CHK_NRA_FILING_STATUS';
12482: fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FILING_STATUS');
12483: fnd_message.raise_error;
12484: end if;
12485: if (p_fit_exempt = 'Y')
12486: then
12487: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12484: end if;
12485: if (p_fit_exempt = 'Y')
12486: then
12487: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12488: /** fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FIT_EXEMPTIONS');
12489: fnd_message.raise_error; **/
12490: end if;
12491: end if;
12492: close csr_chk_nra_status;
12485: if (p_fit_exempt = 'Y')
12486: then
12487: l_warning := 'PAY_US_CHK_NRA_FIT_EXEMPTIONS';
12488: /** fnd_message.set_name('PAY', 'PAY_US_CHK_NRA_FIT_EXEMPTIONS');
12489: fnd_message.raise_error; **/
12490: end if;
12491: end if;
12492: close csr_chk_nra_status;
12493: p_returned_warning := l_warning;