102: IF NOT hr_fsc_shd.api_updating
103: (p_form_tab_stacked_canvas_id => p_rec.form_tab_stacked_canvas_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_form_tab_stacked_canvas_id => p_rec.form_tab_stacked_canvas_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_tab_page_id,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_tab_page_id,hr_api.g_number) <>
113: nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
236: open csr_form_tab_page;
237: fetch csr_form_tab_page into l_tab_page_window_id;
238: if csr_form_tab_page%notfound then
239: close csr_form_tab_page;
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: end if;
237: fetch csr_form_tab_page into l_tab_page_window_id;
238: if csr_form_tab_page%notfound then
239: close csr_form_tab_page;
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: end if;
245: close csr_form_tab_page;
238: if csr_form_tab_page%notfound then
239: close csr_form_tab_page;
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: end if;
245: close csr_form_tab_page;
246: --
239: close csr_form_tab_page;
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: end if;
245: close csr_form_tab_page;
246: --
247: hr_utility.set_location(l_proc,40);
249: open csr_form_canvas;
250: fetch csr_form_canvas into l_canvas_window_id, l_canvas_type;
251: if csr_form_canvas%notfound then
252: close csr_form_canvas;
253: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
254: fnd_message.set_token('PROCEDURE', l_proc);
255: fnd_message.set_token('STEP','20');
256: fnd_message.raise_error;
257: end if;
250: fetch csr_form_canvas into l_canvas_window_id, l_canvas_type;
251: if csr_form_canvas%notfound then
252: close csr_form_canvas;
253: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
254: fnd_message.set_token('PROCEDURE', l_proc);
255: fnd_message.set_token('STEP','20');
256: fnd_message.raise_error;
257: end if;
258: close csr_form_canvas;
251: if csr_form_canvas%notfound then
252: close csr_form_canvas;
253: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
254: fnd_message.set_token('PROCEDURE', l_proc);
255: fnd_message.set_token('STEP','20');
256: fnd_message.raise_error;
257: end if;
258: close csr_form_canvas;
259: --
252: close csr_form_canvas;
253: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
254: fnd_message.set_token('PROCEDURE', l_proc);
255: fnd_message.set_token('STEP','20');
256: fnd_message.raise_error;
257: end if;
258: close csr_form_canvas;
259: --
260: hr_utility.set_location(l_proc,50);
261: --
262: -- Check the canvas is of type TAB_STACKED
263: --
264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then
265: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE', l_proc);
267: fnd_message.set_token('STEP','30');
268: fnd_message.raise_error;
269: end if;
262: -- Check the canvas is of type TAB_STACKED
263: --
264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then
265: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE', l_proc);
267: fnd_message.set_token('STEP','30');
268: fnd_message.raise_error;
269: end if;
270: --
263: --
264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then
265: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE', l_proc);
267: fnd_message.set_token('STEP','30');
268: fnd_message.raise_error;
269: end if;
270: --
271: hr_utility.set_location(l_proc,60);
264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then
265: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE', l_proc);
267: fnd_message.set_token('STEP','30');
268: fnd_message.raise_error;
269: end if;
270: --
271: hr_utility.set_location(l_proc,60);
272: --
273: -- Check the tab page and canvas reference the same window
274: --
275: if nvl(l_tab_page_window_id,hr_api.g_number) <>
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');
280: fnd_message.raise_error;
281: end if;
274: --
275: if nvl(l_tab_page_window_id,hr_api.g_number) <>
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');
280: fnd_message.raise_error;
281: end if;
282: --
275: if nvl(l_tab_page_window_id,hr_api.g_number) <>
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');
280: fnd_message.raise_error;
281: end if;
282: --
283: end if;
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');
280: fnd_message.raise_error;
281: end if;
282: --
283: end if;
284: --