DBA Data[Home] [Help]

APPS.HR_VALID_GRADE_API dependencies on HR_UTILITY

Line 75: hr_utility.set_location('Entering:'|| l_proc, 5);

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;

Line 101: hr_utility.set_location(l_proc, 6);

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;

Line 111: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');

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;

Line 112: hr_utility.raise_error;

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: --

Line 117: hr_utility.set_location(l_proc, 7);

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

Line 202: hr_utility.set_location(l_proc, 8);

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

Line 264: hr_utility.set_location(' Leaving:'||l_proc, 11);

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

Line 326: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 327: hr_utility.set_message_token('PROCEDURE','update_valid_grades');

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: --

Line 328: hr_utility.set_message_token('STEP','1');

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: --

Line 329: hr_utility.raise_error;

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;

Line 357: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 358: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');

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: --

Line 359: hr_utility.set_message_token('STEP','1');

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;

Line 360: hr_utility.raise_error;

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;