192: -- check date_from > date_to
193: --
194: IF p_org_information1 > p_org_information2
195: THEN
196: fnd_message.set_name('PER','PER_289697_START_BEFORE_END');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- Get the organization_id if update
193: --
194: IF p_org_information1 > p_org_information2
195: THEN
196: fnd_message.set_name('PER','PER_289697_START_BEFORE_END');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- Get the organization_id if update
201: --
224: l_org_info3, l_sot, l_eot);
225: fetch csr_chk_overlaps into l_overlap;
226: if csr_chk_overlaps%FOUND then
227: IF p_org_info_type_code = 'FR_ESTAB_TRANSPORT_TAX'
228: THEN fnd_message.set_name('PAY','PER_75066_TSPORT_TAX_OVERLAP');
229: ELSIF p_org_info_type_code = 'FR_ESTAB_WORK_ACCIDENT'
230: THEN fnd_message.set_name('PAY','PER_75067_WORK_ACCI_OVERLAP');
231: ELSE fnd_message.set_name('PAY','PER_75068_START_END_OVERLAP');
232: END IF;
226: if csr_chk_overlaps%FOUND then
227: IF p_org_info_type_code = 'FR_ESTAB_TRANSPORT_TAX'
228: THEN fnd_message.set_name('PAY','PER_75066_TSPORT_TAX_OVERLAP');
229: ELSIF p_org_info_type_code = 'FR_ESTAB_WORK_ACCIDENT'
230: THEN fnd_message.set_name('PAY','PER_75067_WORK_ACCI_OVERLAP');
231: ELSE fnd_message.set_name('PAY','PER_75068_START_END_OVERLAP');
232: END IF;
233: close csr_chk_overlaps;
234: fnd_message.raise_error;
227: IF p_org_info_type_code = 'FR_ESTAB_TRANSPORT_TAX'
228: THEN fnd_message.set_name('PAY','PER_75066_TSPORT_TAX_OVERLAP');
229: ELSIF p_org_info_type_code = 'FR_ESTAB_WORK_ACCIDENT'
230: THEN fnd_message.set_name('PAY','PER_75067_WORK_ACCI_OVERLAP');
231: ELSE fnd_message.set_name('PAY','PER_75068_START_END_OVERLAP');
232: END IF;
233: close csr_chk_overlaps;
234: fnd_message.raise_error;
235: END IF; -- if csr_chk_overlaps%FOUND
230: THEN fnd_message.set_name('PAY','PER_75067_WORK_ACCI_OVERLAP');
231: ELSE fnd_message.set_name('PAY','PER_75068_START_END_OVERLAP');
232: END IF;
233: close csr_chk_overlaps;
234: fnd_message.raise_error;
235: END IF; -- if csr_chk_overlaps%FOUND
236: close csr_chk_overlaps;
237: END IF; -- p_org_info_type_code in ...
238: hr_utility.set_location('Leaving '||l_proc,800);