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_tcn_shd.api_updating
154: (p_template_canvas_id => p_rec.template_canvas_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_canvas_id => p_rec.template_canvas_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.form_canvas_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.form_canvas_id,hr_api.g_number) <>
164: nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number)
232: open csr_form_canvas;
233: fetch csr_form_canvas into l_canvas_type;
234: if csr_form_canvas%notfound then
235: close csr_form_canvas;
236: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
237: fnd_message.set_token('PROCEDURE', l_proc);
238: fnd_message.set_token('STEP','10');
239: fnd_message.raise_error;
240: end if;
233: fetch csr_form_canvas into l_canvas_type;
234: if csr_form_canvas%notfound then
235: close csr_form_canvas;
236: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
237: fnd_message.set_token('PROCEDURE', l_proc);
238: fnd_message.set_token('STEP','10');
239: fnd_message.raise_error;
240: end if;
241: close csr_form_canvas;
234: if csr_form_canvas%notfound then
235: close csr_form_canvas;
236: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
237: fnd_message.set_token('PROCEDURE', l_proc);
238: fnd_message.set_token('STEP','10');
239: fnd_message.raise_error;
240: end if;
241: close csr_form_canvas;
242: --
235: close csr_form_canvas;
236: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
237: fnd_message.set_token('PROCEDURE', l_proc);
238: fnd_message.set_token('STEP','10');
239: fnd_message.raise_error;
240: end if;
241: close csr_form_canvas;
242: --
243: /*
241: close csr_form_canvas;
242: --
243: /*
244: if l_canvas_type not in ('CONTENT','TAB') then
245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE', l_proc);
247: fnd_message.set_token('STEP','20');
248: fnd_message.raise_error;
249: end if;
242: --
243: /*
244: if l_canvas_type not in ('CONTENT','TAB') then
245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE', l_proc);
247: fnd_message.set_token('STEP','20');
248: fnd_message.raise_error;
249: end if;
250: */
243: /*
244: if l_canvas_type not in ('CONTENT','TAB') then
245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE', l_proc);
247: fnd_message.set_token('STEP','20');
248: fnd_message.raise_error;
249: end if;
250: */
251: --
244: if l_canvas_type not in ('CONTENT','TAB') then
245: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE', l_proc);
247: fnd_message.set_token('STEP','20');
248: fnd_message.raise_error;
249: end if;
250: */
251: --
252: end if;
330: open csr_form_canvas;
331: fetch csr_form_canvas into l_canvas_window_id;
332: if csr_form_canvas%notfound then
333: close csr_form_canvas;
334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE', l_proc);
336: fnd_message.set_token('STEP','10');
337: fnd_message.raise_error;
338: end if;
331: fetch csr_form_canvas into l_canvas_window_id;
332: if csr_form_canvas%notfound then
333: close csr_form_canvas;
334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE', l_proc);
336: fnd_message.set_token('STEP','10');
337: fnd_message.raise_error;
338: end if;
339: close csr_form_canvas;
332: if csr_form_canvas%notfound then
333: close csr_form_canvas;
334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE', l_proc);
336: fnd_message.set_token('STEP','10');
337: fnd_message.raise_error;
338: end if;
339: close csr_form_canvas;
340: --
333: close csr_form_canvas;
334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE', l_proc);
336: fnd_message.set_token('STEP','10');
337: fnd_message.raise_error;
338: end if;
339: close csr_form_canvas;
340: --
341: open csr_template_window;
341: open csr_template_window;
342: fetch csr_template_window into l_window_window_id;
343: if csr_template_window%notfound then
344: close csr_template_window;
345: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
346: fnd_message.set_token('PROCEDURE', l_proc);
347: fnd_message.set_token('STEP','20');
348: fnd_message.raise_error;
349: end if;
342: fetch csr_template_window into l_window_window_id;
343: if csr_template_window%notfound then
344: close csr_template_window;
345: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
346: fnd_message.set_token('PROCEDURE', l_proc);
347: fnd_message.set_token('STEP','20');
348: fnd_message.raise_error;
349: end if;
350: close csr_template_window;
343: if csr_template_window%notfound then
344: close csr_template_window;
345: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
346: fnd_message.set_token('PROCEDURE', l_proc);
347: fnd_message.set_token('STEP','20');
348: fnd_message.raise_error;
349: end if;
350: close csr_template_window;
351: --
344: close csr_template_window;
345: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
346: fnd_message.set_token('PROCEDURE', l_proc);
347: fnd_message.set_token('STEP','20');
348: fnd_message.raise_error;
349: end if;
350: close csr_template_window;
351: --
352: hr_utility.set_location(l_proc,40);
352: hr_utility.set_location(l_proc,40);
353: --
354: if nvl(l_canvas_window_id,hr_api.g_number) <>
355: nvl(l_window_window_id,hr_api.g_number) then
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','30');
359: fnd_message.raise_error;
360: end if;
353: --
354: if nvl(l_canvas_window_id,hr_api.g_number) <>
355: nvl(l_window_window_id,hr_api.g_number) then
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','30');
359: fnd_message.raise_error;
360: end if;
361: --
354: if nvl(l_canvas_window_id,hr_api.g_number) <>
355: nvl(l_window_window_id,hr_api.g_number) then
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','30');
359: fnd_message.raise_error;
360: end if;
361: --
362: end if;
355: nvl(l_window_window_id,hr_api.g_number) then
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
357: fnd_message.set_token('PROCEDURE', l_proc);
358: fnd_message.set_token('STEP','30');
359: fnd_message.raise_error;
360: end if;
361: --
362: end if;
363: --