2213: for i in 1..2 loop
2214: if l_inp_value_id_table(i) = null or
2215: l_inp_value_id_table(i) = 0 then
2216:
2217: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
2218: fnd_message.raise_error;
2219: end if;
2220: end loop;
2221: hr_utility.set_location('Entering:'|| l_proc, 30);
2214: if l_inp_value_id_table(i) = null or
2215: l_inp_value_id_table(i) = 0 then
2216:
2217: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
2218: fnd_message.raise_error;
2219: end if;
2220: end loop;
2221: hr_utility.set_location('Entering:'|| l_proc, 30);
2222:
2226: P_element_type_id => l_element_type_id,
2227: P_session_date => l_get_old_value_date);
2228:
2229: if l_element_link_id is null or l_element_link_id = 0 then
2230: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
2231: fnd_message.raise_error;
2232: end if;
2233: hr_utility.set_location('Entering:'|| l_proc, 40);
2234:
2227: P_session_date => l_get_old_value_date);
2228:
2229: if l_element_link_id is null or l_element_link_id = 0 then
2230: fnd_message.set_name('PAY', 'HR_7713_TAX_ELEMENT_ERROR');
2231: fnd_message.raise_error;
2232: end if;
2233: hr_utility.set_location('Entering:'|| l_proc, 40);
2234:
2235: /* Store screen entry value in the table */
2270: if p_datetrack_mode in('DELETE_NEXT_CHANGE','FUTURE_CHANGE') then
2271: l_delete_flag := 'N';
2272: else
2273: close csr_wc_ele_entry;
2274: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','8');
2277: fnd_message.raise_error;
2278: end if;
2271: l_delete_flag := 'N';
2272: else
2273: close csr_wc_ele_entry;
2274: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','8');
2277: fnd_message.raise_error;
2278: end if;
2279: else /* found the wc element entry id */
2272: else
2273: close csr_wc_ele_entry;
2274: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','8');
2277: fnd_message.raise_error;
2278: end if;
2279: else /* found the wc element entry id */
2280: l_delete_flag := 'Y';
2273: close csr_wc_ele_entry;
2274: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','8');
2277: fnd_message.raise_error;
2278: end if;
2279: else /* found the wc element entry id */
2280: l_delete_flag := 'Y';
2281: end if;