29: BEGIN
30:
31:
32:
33: hr_utility.set_location('Entering:'||l_proc,5);
34:
35: --
36: -- Issue a savepoint if operating in validation only mode
37: --
63: --
64: --
65:
66:
67: hr_utility.set_location(l_proc,6);
68:
69: -- Validation in Addition to Row Handlers:
70:
71: IF p_position_description_id is NULL THEN
69: -- Validation in Addition to Row Handlers:
70:
71: IF p_position_description_id is NULL THEN
72:
73: hr_utility.set_message(8301,'GHR_POS_DESC_ID_INVALID');
74: hr_utility.raise_error;
75: END IF;
76:
77: -- Process Logic
70:
71: IF p_position_description_id is NULL THEN
72:
73: hr_utility.set_message(8301,'GHR_POS_DESC_ID_INVALID');
74: hr_utility.raise_error;
75: END IF;
76:
77: -- Process Logic
78: -- Insert a row into GHR_PD_CLASSIFICATIONS using the row handler.
127: p_pdc_object_version_number := l_pdc_object_version_number;
128: p_pd_classification_id := l_pd_classification_id;
129:
130:
131: hr_utility.set_location ('Leaving:'|| l_proc,11);
132:
133: EXCEPTION
134:
135: WHEN hr_api.validate_enabled THEN
150: --
151: when others then
152: rollback to create_pdc;
153: raise;
154: hr_utility.set_location('Leaving:' || l_proc,12);
155: --
156: END create_pdc;
157:
158:
175:
176:
177: BEGIN
178:
179: hr_utility.set_location('Entering:'||l_proc,5);
180:
181: --
182: -- Issue a savepoint if operating in validation only mode
183: -- Bug # 671537
209: -- End of Before Process User Hook call
210: --
211: --
212:
213: hr_utility.set_location(l_proc,6);
214:
215: -- Validation in Addition to Row Handlers:
216:
217: IF (p_pd_classification_id is NULL )
217: IF (p_pd_classification_id is NULL )
218: AND (p_position_description_id is NULL OR p_class_grade_by is NULL)
219: THEN
220:
221: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');
222: END IF;
223:
224: -- Process Logic
225:
235: p_grade_level => p_grade_level,
236: p_object_version_number => l_object_version_number);
237:
238:
239: hr_utility.set_location(l_proc,8);
240:
241: --When in validation only mode raise the Validate_Enabled exception.
242: --
243:
277:
278: p_pdc_object_version_number := l_object_version_number;
279:
280: --
281: hr_utility.set_location('Leaving:'|| l_proc,11);
282:
283: EXCEPTION
284:
285: WHEN hr_api.validate_enabled THEN
292: --
293: when others then
294: rollback to update_pdc;
295: raise;
296: hr_utility.set_location('Leaving:' || l_proc,12);
297: --
298: hr_utility.set_location('Leaving:'||l_proc,12);
299: end update_pdc;
300:
294: rollback to update_pdc;
295: raise;
296: hr_utility.set_location('Leaving:' || l_proc,12);
297: --
298: hr_utility.set_location('Leaving:'||l_proc,12);
299: end update_pdc;
300:
301: PROCEDURE delete_pdc
302: ( p_validate IN BOOLEAN default false,
310:
311:
312: BEGIN
313:
314: hr_utility.set_location('Entering:'||l_proc,5);
315:
316: SAVEPOINT delete_pdc;
317: --
318: -- Call Before Process User Hook
332: --
333: -- End of Before Process User Hook call
334: --
335:
336: hr_utility.set_location(l_proc,6);
337:
338: -- Validation in Addition to Row Handlers:
339:
340: IF (p_pd_classification_id is NULL )
340: IF (p_pd_classification_id is NULL )
341: AND (p_pdc_object_version_number is NULL)
342: THEN
343:
344: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');
345: END IF;
346:
347: -- Process Logic
348:
352: ( p_pd_classification_id => p_pd_classification_id,
353: p_object_version_number => l_object_version_number);
354:
355:
356: hr_utility.set_location(l_proc,8);
357:
358: --When in validation only mode raise the Validate_Enabled exception.
359: --
360:
383: END IF;
384:
385:
386: --
387: hr_utility.set_location('Leaving:'|| l_proc,11);
388:
389: EXCEPTION
390:
391: WHEN hr_api.validate_enabled THEN
398: --
399: when others then
400: rollback to delete_pdc;
401: raise;
402: hr_utility.set_location('Leaving:' || l_proc,12);
403: --
404: hr_utility.set_location('Leaving:'||l_proc,12);
405: end delete_pdc;
406:
400: rollback to delete_pdc;
401: raise;
402: hr_utility.set_location('Leaving:' || l_proc,12);
403: --
404: hr_utility.set_location('Leaving:'||l_proc,12);
405: end delete_pdc;
406:
407: end ghr_pdc_api;