63: hr_utility.set_location('Entering:'|| l_proc, 10);
64: --
65: -- Ensure that all the mandatory parameter are not null
66: --
67: hr_api.mandatory_arg_error
68: (p_api_name => l_proc
69: ,p_argument => 'template_item_id'
70: ,p_argument_value => p_template_item_id
71: );
69: ,p_argument => 'template_item_id'
70: ,p_argument_value => p_template_item_id
71: );
72: --
73: if ( nvl(hr_tim_bus.g_template_item_id, hr_api.g_number)
74: = p_template_item_id) then
75: --
76: -- The legislation code has already been found with a previous
77: -- call to this function. Just return the value in the global
157: fnd_message.set_token('STEP ', '5');
158: fnd_message.raise_error;
159: END IF;
160: --
161: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
162: nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number)
163: ) THEN
164: l_argument := 'form_item_id';
165: RAISE l_error;
158: fnd_message.raise_error;
159: END IF;
160: --
161: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
162: nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number)
163: ) THEN
164: l_argument := 'form_item_id';
165: RAISE l_error;
166: END IF;
164: l_argument := 'form_item_id';
165: RAISE l_error;
166: END IF;
167: --
168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
169: nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number)
170: ) THEN
171: l_argument := 'form_template_id';
172: RAISE l_error;
165: RAISE l_error;
166: END IF;
167: --
168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
169: nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number)
170: ) THEN
171: l_argument := 'form_template_id';
172: RAISE l_error;
173: END IF;
173: END IF;
174: --
175: EXCEPTION
176: WHEN l_error THEN
177: hr_api.argument_changed_error
178: (p_api_name => l_proc
179: ,p_argument => l_argument);
180: WHEN OTHERS THEN
181: RAISE;
197: hr_utility.set_location('Entering:'||l_proc, 10);
198: --
199: -- Check value has been passed
200: --
201: hr_api.mandatory_arg_error
202: (p_api_name => l_proc
203: ,p_argument => 'form_item_id'
204: ,p_argument_value => p_form_item_id
205: );
223: hr_utility.set_location('Entering:'||l_proc, 10);
224: --
225: -- Check value has been passed
226: --
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc
229: ,p_argument => 'form_template_id'
230: ,p_argument_value => p_form_template_id
231: );
273: --
274: -- Only proceed with SQL validation if absolutely necessary
275: --
276: if ( ( l_api_updating
277: and ( nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number) <>
278: nvl(p_form_item_id,hr_api.g_number)
279: or nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then
274: -- Only proceed with SQL validation if absolutely necessary
275: --
276: if ( ( l_api_updating
277: and ( nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number) <>
278: nvl(p_form_item_id,hr_api.g_number)
279: or nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then
282: --
275: --
276: if ( ( l_api_updating
277: and ( nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number) <>
278: nvl(p_form_item_id,hr_api.g_number)
279: or nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then
282: --
283: hr_utility.set_location(l_proc,30);
276: if ( ( l_api_updating
277: and ( nvl(hr_tim_shd.g_old_rec.form_item_id,hr_api.g_number) <>
278: nvl(p_form_item_id,hr_api.g_number)
279: or nvl(hr_tim_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then
282: --
283: hr_utility.set_location(l_proc,30);
284: --
307: close csr_form_template;
308: --
309: hr_utility.set_location(l_proc,40);
310: --
311: if nvl(l_item_application_id,hr_api.g_number) <>
312: nvl(l_template_application_id,hr_api.g_number)
313: or nvl(l_item_form_id,hr_api.g_number) <>
314: nvl(l_template_form_id,hr_api.g_number) then
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
308: --
309: hr_utility.set_location(l_proc,40);
310: --
311: if nvl(l_item_application_id,hr_api.g_number) <>
312: nvl(l_template_application_id,hr_api.g_number)
313: or nvl(l_item_form_id,hr_api.g_number) <>
314: nvl(l_template_form_id,hr_api.g_number) then
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
309: hr_utility.set_location(l_proc,40);
310: --
311: if nvl(l_item_application_id,hr_api.g_number) <>
312: nvl(l_template_application_id,hr_api.g_number)
313: or nvl(l_item_form_id,hr_api.g_number) <>
314: nvl(l_template_form_id,hr_api.g_number) then
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','30');
310: --
311: if nvl(l_item_application_id,hr_api.g_number) <>
312: nvl(l_template_application_id,hr_api.g_number)
313: or nvl(l_item_form_id,hr_api.g_number) <>
314: nvl(l_template_form_id,hr_api.g_number) then
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','30');
318: fnd_message.raise_error;
387: hr_utility.set_location('Entering:'||l_proc, 10);
388: --
389: -- Check value has been passed
390: --
391: hr_api.mandatory_arg_error
392: (p_api_name => l_proc
393: ,p_argument => 'form_item_id'
394: ,p_argument_value => p_form_item_id
395: );