DBA Data[Home] [Help]

APPS.HR_TCN_BUS dependencies on HR_API

Line 69: hr_api.mandatory_arg_error

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: );

Line 75: if ( nvl(hr_tcn_bus.g_template_canvas_id, hr_api.g_number)

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

Line 163: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>

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;

Line 164: nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number)

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;

Line 170: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>

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;

Line 171: nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number)

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;

Line 179: hr_api.argument_changed_error

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;

Line 216: and nvl(hr_fcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

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);

Line 217: nvl(p_form_canvas_id,hr_api.g_number))

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: --

Line 224: hr_api.mandatory_arg_error

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: );

Line 274: hr_api.mandatory_arg_error

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: );

Line 320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

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

Line 321: nvl(p_form_canvas_id,hr_api.g_number)

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: --

Line 322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>

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);

Line 323: nvl(p_template_window_id,hr_api.g_number)))

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: --

Line 354: if nvl(l_canvas_window_id,hr_api.g_number) <>

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');

Line 355: nvl(l_window_window_id,hr_api.g_number) then

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;