102: IF NOT hr_fgi_shd.api_updating
103: (p_form_data_group_item_id => p_rec.form_data_group_item_id
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
103: (p_form_data_group_item_id => p_rec.form_data_group_item_id
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
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) <>
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE ', l_proc);
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)
238: open csr_data_group;
239: fetch csr_data_group into l_data_group_application_id, l_data_group_form_id;
240: if not csr_data_group%found then
241: close csr_data_group;
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: end if;
239: fetch csr_data_group into l_data_group_application_id, l_data_group_form_id;
240: if not csr_data_group%found then
241: close csr_data_group;
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: end if;
247: close csr_data_group;
240: if not csr_data_group%found then
241: close csr_data_group;
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: end if;
247: close csr_data_group;
248: --
241: close csr_data_group;
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: end if;
247: close csr_data_group;
248: --
249: hr_utility.set_location(l_proc,40);
251: open csr_item;
252: fetch csr_item into l_item_application_id, l_item_form_id;
253: if not csr_item%found then
254: close csr_item;
255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
256: fnd_message.set_token('PROCEDURE', l_proc);
257: fnd_message.set_token('STEP','20');
258: fnd_message.raise_error;
259: end if;
252: fetch csr_item into l_item_application_id, l_item_form_id;
253: if not csr_item%found then
254: close csr_item;
255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
256: fnd_message.set_token('PROCEDURE', l_proc);
257: fnd_message.set_token('STEP','20');
258: fnd_message.raise_error;
259: end if;
260: close csr_item;
253: if not csr_item%found then
254: close csr_item;
255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
256: fnd_message.set_token('PROCEDURE', l_proc);
257: fnd_message.set_token('STEP','20');
258: fnd_message.raise_error;
259: end if;
260: close csr_item;
261: --
254: close csr_item;
255: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
256: fnd_message.set_token('PROCEDURE', l_proc);
257: fnd_message.set_token('STEP','20');
258: fnd_message.raise_error;
259: end if;
260: close csr_item;
261: --
262: hr_utility.set_location(l_proc,50);
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;
270: end if;
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;
270: end if;
271: --
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;
270: end if;
271: --
272: end if;
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;
270: end if;
271: --
272: end if;
273: --