DBA Data[Home] [Help]

APPS.HR_FGI_BUS dependencies on HR_API

Line 112: IF (nvl(p_rec.form_data_group_id,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_data_group_id,hr_api.g_number) <>
113: nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_data_group_id';
116: RAISE l_error;

Line 113: nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number)

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

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

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

Line 120: nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number)

116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
120: nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_data_group_id';
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 152: hr_api.mandatory_arg_error

148: hr_utility.set_location('Entering:'||l_proc, 10);
149: --
150: -- Check value has been passed
151: --
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'form_data_group_id'
155: ,p_argument_value => p_form_data_group_id
156: );

Line 178: hr_api.mandatory_arg_error

174: hr_utility.set_location('Entering:'||l_proc, 10);
175: --
176: -- Check value has been passed
177: --
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc
180: ,p_argument => 'form_item_id'
181: ,p_argument_value => p_form_item_id
182: );

Line 228: and ( (nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>

224: --
225: -- Only proceed with SQL validation if absolutely necessary
226: --
227: if ( ( l_api_updating
228: and ( (nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
229: nvl(p_form_data_group_id,hr_api.g_number))
230: or (nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number) <>
231: nvl(p_form_item_id,hr_api.g_number))))
232: or (NOT l_api_updating)) then

Line 229: nvl(p_form_data_group_id,hr_api.g_number))

225: -- Only proceed with SQL validation if absolutely necessary
226: --
227: if ( ( l_api_updating
228: and ( (nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
229: nvl(p_form_data_group_id,hr_api.g_number))
230: or (nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number) <>
231: nvl(p_form_item_id,hr_api.g_number))))
232: or (NOT l_api_updating)) then
233: --

Line 230: or (nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number) <>

226: --
227: if ( ( l_api_updating
228: and ( (nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
229: nvl(p_form_data_group_id,hr_api.g_number))
230: or (nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number) <>
231: nvl(p_form_item_id,hr_api.g_number))))
232: or (NOT l_api_updating)) then
233: --
234: hr_utility.set_location(l_proc,30);

Line 231: nvl(p_form_item_id,hr_api.g_number))))

227: if ( ( l_api_updating
228: and ( (nvl(hr_fgi_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
229: nvl(p_form_data_group_id,hr_api.g_number))
230: or (nvl(hr_fgi_shd.g_old_rec.form_item_id,hr_api.g_number) <>
231: nvl(p_form_item_id,hr_api.g_number))))
232: or (NOT l_api_updating)) then
233: --
234: hr_utility.set_location(l_proc,30);
235: --

Line 264: if ( nvl(l_data_group_application_id,hr_api.g_number) <> nvl(l_item_application_id,hr_api.g_number)

260: close csr_item;
261: --
262: hr_utility.set_location(l_proc,50);
263: --
264: if ( nvl(l_data_group_application_id,hr_api.g_number) <> nvl(l_item_application_id,hr_api.g_number)
265: or nvl(l_data_group_form_id,hr_api.g_number) <> nvl(l_item_form_id,hr_api.g_number)) then
266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
267: fnd_message.set_token('PROCEDURE', l_proc);
268: fnd_message.set_token('STEP','30');

Line 265: or nvl(l_data_group_form_id,hr_api.g_number) <> nvl(l_item_form_id,hr_api.g_number)) then

261: --
262: hr_utility.set_location(l_proc,50);
263: --
264: if ( nvl(l_data_group_application_id,hr_api.g_number) <> nvl(l_item_application_id,hr_api.g_number)
265: or nvl(l_data_group_form_id,hr_api.g_number) <> nvl(l_item_form_id,hr_api.g_number)) then
266: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
267: fnd_message.set_token('PROCEDURE', l_proc);
268: fnd_message.set_token('STEP','30');
269: fnd_message.raise_error;