DBA Data[Home] [Help]

APPS.HR_SFT_BUS dependencies on HR_API

Line 112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>

108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>
113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_template_id_from';
116: RAISE l_error;

Line 113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)

109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>
113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_template_id_from';
116: RAISE l_error;
117: END IF;

Line 119: IF (nvl(p_rec.form_template_id_to,hr_api.g_number) <>

115: l_argument := 'form_template_id_from';
116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_template_id_to,hr_api.g_number) <>
120: nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_template_id_to';
123: RAISE l_error;

Line 120: nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number)

116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_template_id_to,hr_api.g_number) <>
120: nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_template_id_to';
123: RAISE l_error;
124: END IF;

Line 128: hr_api.argument_changed_error

124: END IF;
125: --
126: EXCEPTION
127: WHEN l_error THEN
128: hr_api.argument_changed_error
129: (p_api_name => l_proc
130: ,p_argument => l_argument);
131: WHEN OTHERS THEN
132: RAISE;

Line 172: hr_api.mandatory_arg_error

168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: -- Check value has been passed
171: --
172: hr_api.mandatory_arg_error
173: (p_api_name => l_proc
174: ,p_argument => 'form_template_id_to'
175: ,p_argument_value => p_form_template_id_to
176: );

Line 218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>

214: --
215: -- Only proceed with SQL validation if absolutely necessary
216: --
217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then

Line 219: nvl(p_form_template_id_from,hr_api.g_number)

215: -- Only proceed with SQL validation if absolutely necessary
216: --
217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then
223: --

Line 220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>

216: --
217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then
223: --
224: hr_utility.set_location(l_proc,30);

Line 221: nvl(p_form_template_id_to,hr_api.g_number)))

217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then
223: --
224: hr_utility.set_location(l_proc,30);
225: --

Line 228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then

224: hr_utility.set_location(l_proc,30);
225: --
226: -- From and to templates must not be equal
227: --
228: if nvl(p_form_template_id_from,hr_api.g_number) = nvl(p_form_template_id_to,hr_api.g_number) then
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;

Line 261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)

257: fnd_message.raise_error;
258: end if;
259: close csr_form_template;
260: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');

Line 262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then

258: end if;
259: close csr_form_template;
260: --
261: if nvl(l_from_application_id,hr_api.g_number) <> nvl(l_to_application_id,hr_api.g_number)
262: or nvl(l_from_form_id,hr_api.g_number) <> nvl(l_to_form_id,hr_api.g_number) then
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','40');
266: fnd_message.raise_error;