132: --
133: FETCH crs_cgs INTO l_exists;
134: hr_utility.set_location(l_proc,15);
135: IF crs_cgs%notfound THEN
136: fnd_message.set_name('PER','PER_52810_INVALID_STRUCTURE');
137: CLOSE crs_cgs;
138: fnd_message.raise_error;
139: END IF;
140: CLOSE crs_cgs;
134: hr_utility.set_location(l_proc,15);
135: IF crs_cgs%notfound THEN
136: fnd_message.set_name('PER','PER_52810_INVALID_STRUCTURE');
137: CLOSE crs_cgs;
138: fnd_message.raise_error;
139: END IF;
140: CLOSE crs_cgs;
141: --
142: hr_utility.set_location('Leaving:'||l_proc, 20);
196: --
197: FETCH crs_cgd INTO l_exists;
198: hr_utility.set_location(l_proc,15);
199: IF crs_cgd%notfound THEN
200: fnd_message.set_name('PER','PER_52616_INVALID_GRADE_DEF');
201: CLOSE crs_cgd;
202: fnd_message.raise_error;
203: END IF;
204: CLOSE crs_cgd;
198: hr_utility.set_location(l_proc,15);
199: IF crs_cgd%notfound THEN
200: fnd_message.set_name('PER','PER_52616_INVALID_GRADE_DEF');
201: CLOSE crs_cgd;
202: fnd_message.raise_error;
203: END IF;
204: CLOSE crs_cgd;
205: --
206: hr_utility.set_location('Leaving:'||l_proc, 20);
267: --
268: FETCH c_all_seq INTO l_exists;
269: hr_utility.set_location(l_proc,15);
270: IF c_all_seq%FOUND THEN
271: fnd_message.set_name('PAY','HR_7127_GRADE_DUP_SEQ');
272: CLOSE c_all_seq;
273: fnd_message.raise_error;
274: END IF;
275: CLOSE c_all_seq;
269: hr_utility.set_location(l_proc,15);
270: IF c_all_seq%FOUND THEN
271: fnd_message.set_name('PAY','HR_7127_GRADE_DUP_SEQ');
272: CLOSE c_all_seq;
273: fnd_message.raise_error;
274: END IF;
275: CLOSE c_all_seq;
276: --
277: if p_sequence < 0 then
274: END IF;
275: CLOSE c_all_seq;
276: --
277: if p_sequence < 0 then
278: fnd_message.set_name('PAY','PER_7833_DEF_GRADE_SEQUENCE');
279: fnd_message.raise_error;
280: end if;
281: --
282: hr_utility.set_location('Leaving:'||l_proc, 20);
275: CLOSE c_all_seq;
276: --
277: if p_sequence < 0 then
278: fnd_message.set_name('PAY','PER_7833_DEF_GRADE_SEQUENCE');
279: fnd_message.raise_error;
280: end if;
281: --
282: hr_utility.set_location('Leaving:'||l_proc, 20);
283: --