102: IF NOT hr_sft_shd.api_updating
103: (p_source_form_template_id => p_rec.source_form_template_id
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
103: (p_source_form_template_id => p_rec.source_form_template_id
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>
113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)
225: --
226: -- From and to templates must not be equal
227: --
228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: end if;
226: -- From and to templates must not be equal
227: --
228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: end if;
234: --
227: --
228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: end if;
234: --
235: -- If both templates are specified they must reference the same form
228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: end if;
234: --
235: -- If both templates are specified they must reference the same form
236: --
239: open csr_form_template(p_form_template_id_from);
240: fetch csr_form_template into l_from_application_id, l_from_form_id;
241: if csr_form_template%notfound then
242: close csr_form_template;
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','20');
246: fnd_message.raise_error;
247: end if;
240: fetch csr_form_template into l_from_application_id, l_from_form_id;
241: if csr_form_template%notfound then
242: close csr_form_template;
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','20');
246: fnd_message.raise_error;
247: end if;
248: close csr_form_template;
241: if csr_form_template%notfound then
242: close csr_form_template;
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','20');
246: fnd_message.raise_error;
247: end if;
248: close csr_form_template;
249: --
242: close csr_form_template;
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','20');
246: fnd_message.raise_error;
247: end if;
248: close csr_form_template;
249: --
250: open csr_form_template(p_form_template_id_to);
250: open csr_form_template(p_form_template_id_to);
251: fetch csr_form_template into l_to_application_id, l_to_form_id;
252: if csr_form_template%notfound then
253: close csr_form_template;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE', l_proc);
256: fnd_message.set_token('STEP','30');
257: fnd_message.raise_error;
258: end if;
251: fetch csr_form_template into l_to_application_id, l_to_form_id;
252: if csr_form_template%notfound then
253: close csr_form_template;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE', l_proc);
256: fnd_message.set_token('STEP','30');
257: fnd_message.raise_error;
258: end if;
259: close csr_form_template;
252: if csr_form_template%notfound then
253: close csr_form_template;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE', l_proc);
256: fnd_message.set_token('STEP','30');
257: fnd_message.raise_error;
258: end if;
259: close csr_form_template;
260: --
253: close csr_form_template;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE', l_proc);
256: fnd_message.set_token('STEP','30');
257: fnd_message.raise_error;
258: end if;
259: close csr_form_template;
260: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
259: close csr_form_template;
260: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');
266: fnd_message.raise_error;
267: end if;
260: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');
266: fnd_message.raise_error;
267: end if;
268: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');
266: fnd_message.raise_error;
267: end if;
268: --
269: end if;
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');
266: fnd_message.raise_error;
267: end if;
268: --
269: end if;
270: --