95: --
96: -- The primary key is invalid therefore we must error
97: --
98: close csr_leg_code;
99: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
100: fnd_message.raise_error;
101: end if;
102: hr_utility.set_location(l_proc,30);
103: --
96: -- The primary key is invalid therefore we must error
97: --
98: close csr_leg_code;
99: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
100: fnd_message.raise_error;
101: end if;
102: hr_utility.set_location(l_proc,30);
103: --
104: -- Set the global variables so the values are
155: IF NOT hr_tcp_shd.api_updating
156: (p_template_item_context_page_i => p_rec.template_item_context_page_id
157: ,p_object_version_number => p_rec.object_version_number
158: ) THEN
159: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
160: fnd_message.set_token('PROCEDURE ', l_proc);
161: fnd_message.set_token('STEP ', '5');
162: fnd_message.raise_error;
163: END IF;
156: (p_template_item_context_page_i => p_rec.template_item_context_page_id
157: ,p_object_version_number => p_rec.object_version_number
158: ) THEN
159: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
160: fnd_message.set_token('PROCEDURE ', l_proc);
161: fnd_message.set_token('STEP ', '5');
162: fnd_message.raise_error;
163: END IF;
164: --
157: ,p_object_version_number => p_rec.object_version_number
158: ) THEN
159: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
160: fnd_message.set_token('PROCEDURE ', l_proc);
161: fnd_message.set_token('STEP ', '5');
162: fnd_message.raise_error;
163: END IF;
164: --
165: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>
158: ) THEN
159: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
160: fnd_message.set_token('PROCEDURE ', l_proc);
161: fnd_message.set_token('STEP ', '5');
162: fnd_message.raise_error;
163: END IF;
164: --
165: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>
166: nvl(hr_tcp_shd.g_old_rec.template_item_context_id,hr_api.g_number)
308: open csr_template_item_context;
309: fetch csr_template_item_context into l_context_template_id;
310: if csr_template_item_context%notfound then
311: close csr_template_item_context;
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','10');
315: fnd_message.raise_error;
316: end if;
309: fetch csr_template_item_context into l_context_template_id;
310: if csr_template_item_context%notfound then
311: close csr_template_item_context;
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','10');
315: fnd_message.raise_error;
316: end if;
317: close csr_template_item_context;
310: if csr_template_item_context%notfound then
311: close csr_template_item_context;
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','10');
315: fnd_message.raise_error;
316: end if;
317: close csr_template_item_context;
318: --
311: close csr_template_item_context;
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','10');
315: fnd_message.raise_error;
316: end if;
317: close csr_template_item_context;
318: --
319: open csr_template_tab_page;
319: open csr_template_tab_page;
320: fetch csr_template_tab_page into l_tab_page_template_id;
321: if csr_template_tab_page%notfound then
322: close csr_template_tab_page;
323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
324: fnd_message.set_token('PROCEDURE', l_proc);
325: fnd_message.set_token('STEP','20');
326: fnd_message.raise_error;
327: end if;
320: fetch csr_template_tab_page into l_tab_page_template_id;
321: if csr_template_tab_page%notfound then
322: close csr_template_tab_page;
323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
324: fnd_message.set_token('PROCEDURE', l_proc);
325: fnd_message.set_token('STEP','20');
326: fnd_message.raise_error;
327: end if;
328: close csr_template_tab_page;
321: if csr_template_tab_page%notfound then
322: close csr_template_tab_page;
323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
324: fnd_message.set_token('PROCEDURE', l_proc);
325: fnd_message.set_token('STEP','20');
326: fnd_message.raise_error;
327: end if;
328: close csr_template_tab_page;
329: --
322: close csr_template_tab_page;
323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
324: fnd_message.set_token('PROCEDURE', l_proc);
325: fnd_message.set_token('STEP','20');
326: fnd_message.raise_error;
327: end if;
328: close csr_template_tab_page;
329: --
330: hr_utility.set_location(l_proc,40);
332: -- Check context and tab page reference the same template
333: --
334: if nvl(l_context_template_id,hr_api.g_number) <>
335: nvl(l_tab_page_template_id,hr_api.g_number) then
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','30');
339: fnd_message.raise_error;
340: end if;
333: --
334: if nvl(l_context_template_id,hr_api.g_number) <>
335: nvl(l_tab_page_template_id,hr_api.g_number) then
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','30');
339: fnd_message.raise_error;
340: end if;
341: --
334: if nvl(l_context_template_id,hr_api.g_number) <>
335: nvl(l_tab_page_template_id,hr_api.g_number) then
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','30');
339: fnd_message.raise_error;
340: end if;
341: --
342: hr_utility.set_location(l_proc,50);
335: nvl(l_tab_page_template_id,hr_api.g_number) then
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','30');
339: fnd_message.raise_error;
340: end if;
341: --
342: hr_utility.set_location(l_proc,50);
343: --
346: open csr_tab_stacked_canvas;
347: fetch csr_tab_stacked_canvas into l_dummy;
348: if csr_tab_stacked_canvas%notfound then
349: close csr_tab_stacked_canvas;
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','40');
353: fnd_message.raise_error;
354: end if;
347: fetch csr_tab_stacked_canvas into l_dummy;
348: if csr_tab_stacked_canvas%notfound then
349: close csr_tab_stacked_canvas;
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','40');
353: fnd_message.raise_error;
354: end if;
355: close csr_tab_stacked_canvas;
348: if csr_tab_stacked_canvas%notfound then
349: close csr_tab_stacked_canvas;
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','40');
353: fnd_message.raise_error;
354: end if;
355: close csr_tab_stacked_canvas;
356: --
349: close csr_tab_stacked_canvas;
350: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
351: fnd_message.set_token('PROCEDURE', l_proc);
352: fnd_message.set_token('STEP','40');
353: fnd_message.raise_error;
354: end if;
355: close csr_tab_stacked_canvas;
356: --
357: end if;