DBA Data[Home] [Help]

APPS.HR_VALID_GRADE_API dependencies on HR_UTILITY

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

63: from per_grades gra
64: where gra.grade_id = p_grade_id;
65: --
66: begin
67: hr_utility.set_location('Entering:'|| l_proc, 5);
68: --
69: -- Issue a savepoint.
70: --
71: savepoint create_valid_grade;

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

79: p_argument => 'grade_id',
80: p_argument_value => p_grade_id);
81: --
82: --
83: hr_utility.set_location(l_proc, 6);
84: --
85: -- Get business_group_id using grade_id.
86: --
87: open csr_bus_grp;

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

89: into l_business_group_id;
90: --
91: if csr_bus_grp%notfound then
92: close csr_bus_grp;
93: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
94: hr_utility.raise_error;
95: end if;
96: --
97: close csr_bus_grp;

Line 94: hr_utility.raise_error;

90: --
91: if csr_bus_grp%notfound then
92: close csr_bus_grp;
93: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
94: hr_utility.raise_error;
95: end if;
96: --
97: close csr_bus_grp;
98: --

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

95: end if;
96: --
97: close csr_bus_grp;
98: --
99: hr_utility.set_location(l_proc, 7);
100: --
101: -- Call before Process User Hook point create_valid_grade
102: --
103: begin

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

180: ,p_object_version_number => l_object_version_number
181: ,p_validate => FALSE
182: );
183: --
184: hr_utility.set_location(l_proc, 8);
185: --
186: -- Call after Process User Hook point create_valid_grade
187: --
188: begin

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

242: -- When in validation only mode raise the Validate_Enabled exception
243: --
244:
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 11);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised

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

304: and vg.job_id = p_job_id
305: and nvl(vg.date_to, to_date('12/31/4712','mm/dd/yyyy')) > p_date_to;
306: --
307: if (SQL%NOTFOUND) then
308: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
309: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
310: hr_utility.set_message_token('STEP','1');
311: hr_utility.raise_error;
312: end if;

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

305: and nvl(vg.date_to, to_date('12/31/4712','mm/dd/yyyy')) > p_date_to;
306: --
307: if (SQL%NOTFOUND) then
308: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
309: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
310: hr_utility.set_message_token('STEP','1');
311: hr_utility.raise_error;
312: end if;
313: --

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

306: --
307: if (SQL%NOTFOUND) then
308: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
309: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
310: hr_utility.set_message_token('STEP','1');
311: hr_utility.raise_error;
312: end if;
313: --
314: --

Line 311: hr_utility.raise_error;

307: if (SQL%NOTFOUND) then
308: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
309: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
310: hr_utility.set_message_token('STEP','1');
311: hr_utility.raise_error;
312: end if;
313: --
314: --
315: end update_valid_grades_for_job;

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

335: and vg.date_from > p_date_to;
336: --
337: --
338: if (SQL%NOTFOUND) then
339: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
340: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
341: hr_utility.set_message_token('STEP','1');
342: hr_utility.raise_error;
343: end if;

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

336: --
337: --
338: if (SQL%NOTFOUND) then
339: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
340: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
341: hr_utility.set_message_token('STEP','1');
342: hr_utility.raise_error;
343: end if;
344: --

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

337: --
338: if (SQL%NOTFOUND) then
339: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
340: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
341: hr_utility.set_message_token('STEP','1');
342: hr_utility.raise_error;
343: end if;
344: --
345: end delete_valid_grades_for_job;

Line 342: hr_utility.raise_error;

338: if (SQL%NOTFOUND) then
339: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
340: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
341: hr_utility.set_message_token('STEP','1');
342: hr_utility.raise_error;
343: end if;
344: --
345: end delete_valid_grades_for_job;
346: end hr_valid_grade_api;