71: where pos.position_id = p_position_id;
72: --
73:
74: begin
75: hr_utility.set_location('Entering:'|| l_proc, 5);
76: --
77: -- Issue a savepoint.
78: --
79: savepoint create_valid_grade;
97: end if;
98: close csr_pos_start_date;
99:
100: --
101: hr_utility.set_location(l_proc, 6);
102: --
103: -- Get business_group_id using grade_id.
104: --
105: open csr_bus_grp;
107: into l_business_group_id;
108: --
109: if csr_bus_grp%notfound then
110: close csr_bus_grp;
111: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
112: hr_utility.raise_error;
113: end if;
114: --
115: close csr_bus_grp;
108: --
109: if csr_bus_grp%notfound then
110: close csr_bus_grp;
111: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
112: hr_utility.raise_error;
113: end if;
114: --
115: close csr_bus_grp;
116: --
113: end if;
114: --
115: close csr_bus_grp;
116: --
117: hr_utility.set_location(l_proc, 7);
118: --
119: -- Call before Process User Hook point create_valid_grade
120: --
121: begin
198: ,p_object_version_number => l_object_version_number
199: ,p_validate => FALSE
200: );
201: --
202: hr_utility.set_location(l_proc, 8);
203: --
204: -- Call after Process User Hook point create_valid_grade
205: --
206: begin
260: -- When in validation only mode raise the Validate_Enabled exception
261: --
262:
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 11);
265: exception
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised
322: and vg.job_id = p_job_id
323: and nvl(vg.date_to, to_date('12/31/4712','mm/dd/yyyy')) > p_date_to;
324: --
325: if (SQL%NOTFOUND) then
326: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
323: and nvl(vg.date_to, to_date('12/31/4712','mm/dd/yyyy')) > p_date_to;
324: --
325: if (SQL%NOTFOUND) then
326: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: --
324: --
325: if (SQL%NOTFOUND) then
326: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: --
332: --
325: if (SQL%NOTFOUND) then
326: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: --
332: --
333: end update_valid_grades_for_job;
353: and vg.date_from > p_date_to;
354: --
355: --
356: if (SQL%NOTFOUND) then
357: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
358: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
359: hr_utility.set_message_token('STEP','1');
360: hr_utility.raise_error;
361: end if;
354: --
355: --
356: if (SQL%NOTFOUND) then
357: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
358: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
359: hr_utility.set_message_token('STEP','1');
360: hr_utility.raise_error;
361: end if;
362: --
355: --
356: if (SQL%NOTFOUND) then
357: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
358: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
359: hr_utility.set_message_token('STEP','1');
360: hr_utility.raise_error;
361: end if;
362: --
363: end delete_valid_grades_for_job;
356: if (SQL%NOTFOUND) then
357: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
358: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
359: hr_utility.set_message_token('STEP','1');
360: hr_utility.raise_error;
361: end if;
362: --
363: end delete_valid_grades_for_job;
364: end hr_valid_grade_api;