65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: -- Ensure that all the mandatory parameter are not null
68: --
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc
71: ,p_argument => 'template_canvas_id'
72: ,p_argument_value => p_template_canvas_id
73: );
71: ,p_argument => 'template_canvas_id'
72: ,p_argument_value => p_template_canvas_id
73: );
74: --
75: if ( nvl(hr_tcn_bus.g_template_canvas_id, hr_api.g_number)
76: = p_template_canvas_id) then
77: --
78: -- The legislation code has already been found with a previous
79: -- call to this function. Just return the value in the global
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)
165: ) THEN
166: l_argument := 'form_canvas_id';
167: RAISE l_error;
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)
165: ) THEN
166: l_argument := 'form_canvas_id';
167: RAISE l_error;
168: END IF;
166: l_argument := 'form_canvas_id';
167: RAISE l_error;
168: END IF;
169: --
170: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>
171: nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number)
172: ) THEN
173: l_argument := 'template_window_id';
174: RAISE l_error;
167: RAISE l_error;
168: END IF;
169: --
170: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>
171: nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number)
172: ) THEN
173: l_argument := 'template_window_id';
174: RAISE l_error;
175: END IF;
175: END IF;
176: --
177: EXCEPTION
178: WHEN l_error THEN
179: hr_api.argument_changed_error
180: (p_api_name => l_proc
181: ,p_argument => l_argument);
182: WHEN OTHERS THEN
183: RAISE;
212: --
213: -- Only proceed with SQL validation if absolutely necessary
214: --
215: if ( ( l_api_updating
216: and nvl(hr_fcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
217: nvl(p_form_canvas_id,hr_api.g_number))
218: or (NOT l_api_updating)) then
219: --
220: hr_utility.set_location(l_proc,30);
213: -- Only proceed with SQL validation if absolutely necessary
214: --
215: if ( ( l_api_updating
216: and nvl(hr_fcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
217: nvl(p_form_canvas_id,hr_api.g_number))
218: or (NOT l_api_updating)) then
219: --
220: hr_utility.set_location(l_proc,30);
221: --
220: hr_utility.set_location(l_proc,30);
221: --
222: -- Check value has been passed
223: --
224: hr_api.mandatory_arg_error
225: (p_api_name => l_proc
226: ,p_argument => 'form_canvas_id'
227: ,p_argument_value => p_form_canvas_id
228: );
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: --
272: -- Check value has been passed
273: --
274: hr_api.mandatory_arg_error
275: (p_api_name => l_proc
276: ,p_argument => 'template_window_id'
277: ,p_argument_value => p_template_window_id
278: );
316: --
317: -- Only proceed with SQL validation if absolutely necessary
318: --
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
317: -- Only proceed with SQL validation if absolutely necessary
318: --
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
325: --
318: --
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
325: --
326: hr_utility.set_location(l_proc,30);
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
325: --
326: hr_utility.set_location(l_proc,30);
327: --
350: close csr_template_window;
351: --
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');
351: --
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;