DBA Data[Home] [Help]

APPS.HR_TWN_BUS dependencies on HR_API

Line 67: hr_api.mandatory_arg_error

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_window_id'
70: ,p_argument_value => p_template_window_id
71: );

Line 73: if ( nvl(hr_twn_bus.g_template_window_id, hr_api.g_number)

69: ,p_argument => 'template_window_id'
70: ,p_argument_value => p_template_window_id
71: );
72: --
73: if ( nvl(hr_twn_bus.g_template_window_id, hr_api.g_number)
74: = p_template_window_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

Line 161: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>

157: fnd_message.set_token('STEP ', '5');
158: fnd_message.raise_error;
159: END IF;
160: --
161: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>
162: nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number)
163: ) THEN
164: l_argument := 'form_window_id';
165: RAISE l_error;

Line 162: nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number)

158: fnd_message.raise_error;
159: END IF;
160: --
161: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>
162: nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number)
163: ) THEN
164: l_argument := 'form_window_id';
165: RAISE l_error;
166: END IF;

Line 168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>

164: l_argument := 'form_window_id';
165: RAISE l_error;
166: END IF;
167: --
168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
169: nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number)
170: ) THEN
171: l_argument := 'form_template_id';
172: RAISE l_error;

Line 169: nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number)

165: RAISE l_error;
166: END IF;
167: --
168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
169: nvl(hr_twn_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;

Line 178: hr_api.argument_changed_error

174: --
175: --
176: EXCEPTION
177: WHEN l_error THEN
178: hr_api.argument_changed_error
179: (p_api_name => l_proc
180: ,p_argument => l_argument);
181: WHEN OTHERS THEN
182: RAISE;

Line 202: hr_api.mandatory_arg_error

198: hr_utility.set_location('Entering:'||l_proc, 10);
199: --
200: -- Check value has been passed
201: --
202: hr_api.mandatory_arg_error
203: (p_api_name => l_proc
204: ,p_argument => 'form_window_id'
205: ,p_argument_value => p_form_window_id
206: );

Line 228: hr_api.mandatory_arg_error

224: hr_utility.set_location('Entering:'||l_proc, 10);
225: --
226: -- Check value has been passed
227: --
228: hr_api.mandatory_arg_error
229: (p_api_name => l_proc
230: ,p_argument => 'form_template_id'
231: ,p_argument_value => p_form_template_id
232: );

Line 278: and ( nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>

274: --
275: -- Only proceed with SQL validation if absolutely necessary
276: --
277: if ( ( l_api_updating
278: and ( nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>
279: nvl(p_form_window_id,hr_api.g_number)
280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>
281: nvl(p_form_template_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then

Line 279: nvl(p_form_window_id,hr_api.g_number)

275: -- Only proceed with SQL validation if absolutely necessary
276: --
277: if ( ( l_api_updating
278: and ( nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>
279: nvl(p_form_window_id,hr_api.g_number)
280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>
281: nvl(p_form_template_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then
283: --

Line 280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>

276: --
277: if ( ( l_api_updating
278: and ( nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>
279: nvl(p_form_window_id,hr_api.g_number)
280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>
281: nvl(p_form_template_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);

Line 281: nvl(p_form_template_id,hr_api.g_number)))

277: if ( ( l_api_updating
278: and ( nvl(hr_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>
279: nvl(p_form_window_id,hr_api.g_number)
280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>
281: nvl(p_form_template_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);
285: --

Line 312: if nvl(l_window_application_id,hr_api.g_number) <>

308: close csr_form_template;
309: --
310: hr_utility.set_location(l_proc,40);
311: --
312: if nvl(l_window_application_id,hr_api.g_number) <>
313: nvl(l_template_application_id,hr_api.g_number)
314: or nvl(l_window_form_id,hr_api.g_number) <>
315: nvl(l_template_form_id,hr_api.g_number) then
316: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 313: nvl(l_template_application_id,hr_api.g_number)

309: --
310: hr_utility.set_location(l_proc,40);
311: --
312: if nvl(l_window_application_id,hr_api.g_number) <>
313: nvl(l_template_application_id,hr_api.g_number)
314: or nvl(l_window_form_id,hr_api.g_number) <>
315: nvl(l_template_form_id,hr_api.g_number) then
316: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
317: fnd_message.set_token('PROCEDURE', l_proc);

Line 314: or nvl(l_window_form_id,hr_api.g_number) <>

310: hr_utility.set_location(l_proc,40);
311: --
312: if nvl(l_window_application_id,hr_api.g_number) <>
313: nvl(l_template_application_id,hr_api.g_number)
314: or nvl(l_window_form_id,hr_api.g_number) <>
315: nvl(l_template_form_id,hr_api.g_number) then
316: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
317: fnd_message.set_token('PROCEDURE', l_proc);
318: fnd_message.set_token('STEP','30');

Line 315: nvl(l_template_form_id,hr_api.g_number) then

311: --
312: if nvl(l_window_application_id,hr_api.g_number) <>
313: nvl(l_template_application_id,hr_api.g_number)
314: or nvl(l_window_form_id,hr_api.g_number) <>
315: nvl(l_template_form_id,hr_api.g_number) then
316: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
317: fnd_message.set_token('PROCEDURE', l_proc);
318: fnd_message.set_token('STEP','30');
319: fnd_message.raise_error;