102: IF NOT hr_fdg_shd.api_updating
103: (p_form_data_group_id => p_rec.form_data_group_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_id => p_rec.form_data_group_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.application_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.application_id,hr_api.g_number) <>
113: nvl(hr_fdg_shd.g_old_rec.application_id,hr_api.g_number)
165: FETCH cur_chk_app_id INTO l_check;
166: IF cur_chk_app_id%NOTFOUND THEN
167: CLOSE cur_chk_app_id;
168: -- error message
169: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
170: fnd_message.set_token('PROCEDURE', l_proc);
171: fnd_message.set_token('STEP','10');
172: fnd_message.raise_error;
173: END IF;
166: IF cur_chk_app_id%NOTFOUND THEN
167: CLOSE cur_chk_app_id;
168: -- error message
169: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
170: fnd_message.set_token('PROCEDURE', l_proc);
171: fnd_message.set_token('STEP','10');
172: fnd_message.raise_error;
173: END IF;
174: CLOSE cur_chk_app_id;
167: CLOSE cur_chk_app_id;
168: -- error message
169: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
170: fnd_message.set_token('PROCEDURE', l_proc);
171: fnd_message.set_token('STEP','10');
172: fnd_message.raise_error;
173: END IF;
174: CLOSE cur_chk_app_id;
175:
168: -- error message
169: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
170: fnd_message.set_token('PROCEDURE', l_proc);
171: fnd_message.set_token('STEP','10');
172: fnd_message.raise_error;
173: END IF;
174: CLOSE cur_chk_app_id;
175:
176: hr_utility.set_location('Leaving:'||l_proc, 100);
211: FETCH cur_chk_form_id INTO l_check;
212: IF cur_chk_form_id%NOTFOUND THEN
213: CLOSE cur_chk_form_id;
214: -- error message
215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
216: fnd_message.set_token('PROCEDURE', l_proc);
217: fnd_message.set_token('STEP','10');
218: fnd_message.raise_error;
219: END IF;
212: IF cur_chk_form_id%NOTFOUND THEN
213: CLOSE cur_chk_form_id;
214: -- error message
215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
216: fnd_message.set_token('PROCEDURE', l_proc);
217: fnd_message.set_token('STEP','10');
218: fnd_message.raise_error;
219: END IF;
220: CLOSE cur_chk_form_id;
213: CLOSE cur_chk_form_id;
214: -- error message
215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
216: fnd_message.set_token('PROCEDURE', l_proc);
217: fnd_message.set_token('STEP','10');
218: fnd_message.raise_error;
219: END IF;
220: CLOSE cur_chk_form_id;
221: --
214: -- error message
215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
216: fnd_message.set_token('PROCEDURE', l_proc);
217: fnd_message.set_token('STEP','10');
218: fnd_message.raise_error;
219: END IF;
220: CLOSE cur_chk_form_id;
221: --
222: hr_utility.set_location('Leaving:'||l_proc, 100);
247: --
248: -- Check value is in uppercase
249: --
250: if p_data_group_name <> upper(p_data_group_name) then
251: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
252: fnd_message.set_token('PROCEDURE', l_proc);
253: fnd_message.set_token('STEP','10');
254: fnd_message.raise_error;
255: end if;
248: -- Check value is in uppercase
249: --
250: if p_data_group_name <> upper(p_data_group_name) then
251: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
252: fnd_message.set_token('PROCEDURE', l_proc);
253: fnd_message.set_token('STEP','10');
254: fnd_message.raise_error;
255: end if;
256: --
249: --
250: if p_data_group_name <> upper(p_data_group_name) then
251: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
252: fnd_message.set_token('PROCEDURE', l_proc);
253: fnd_message.set_token('STEP','10');
254: fnd_message.raise_error;
255: end if;
256: --
257: hr_utility.set_location('Leaving:'||l_proc, 100);
250: if p_data_group_name <> upper(p_data_group_name) then
251: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
252: fnd_message.set_token('PROCEDURE', l_proc);
253: fnd_message.set_token('STEP','10');
254: fnd_message.raise_error;
255: end if;
256: --
257: hr_utility.set_location('Leaving:'||l_proc, 100);
258: End chk_data_group_name;