93: --
94: -- The primary key is invalid therefore we must error
95: --
96: close csr_leg_code;
97: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
98: fnd_message.raise_error;
99: end if;
100: hr_utility.set_location(l_proc,30);
101: --
94: -- The primary key is invalid therefore we must error
95: --
96: close csr_leg_code;
97: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
98: fnd_message.raise_error;
99: end if;
100: hr_utility.set_location(l_proc,30);
101: --
102: -- Set the global variables so the values are
153: IF NOT hr_tip_shd.api_updating
154: (p_template_item_tab_page_id => p_rec.template_item_tab_page_id
155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
154: (p_template_item_tab_page_id => p_rec.template_item_tab_page_id
155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --
155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --
163: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --
163: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
164: nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number)
302: open csr_template_item;
303: fetch csr_template_item into l_item_template_id;
304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
303: fetch csr_template_item into l_item_template_id;
304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;
304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;
312: --
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;
312: --
313: open csr_template_tab_page;
313: open csr_template_tab_page;
314: fetch csr_template_tab_page into l_tab_page_template_id;
315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
314: fetch csr_template_tab_page into l_tab_page_template_id;
315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
323: --
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
323: --
324: hr_utility.set_location(l_proc,40);
326: -- Check item and tab page reference the same template
327: --
328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
327: --
328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
336: hr_utility.set_location(l_proc,50);
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
336: hr_utility.set_location(l_proc,50);
337: --
340: open csr_tab_stacked_canvas;
341: fetch csr_tab_stacked_canvas into l_dummy;
342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
341: fetch csr_tab_stacked_canvas into l_dummy;
342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;
342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;
350: --
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;
350: --
351: end if;