DBA Data[Home] [Help]

APPS.GHR_PDC_API dependencies on HR_UTILITY

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

24: l_position_description_id number;
25: l_pd_classification_id number;
26: BEGIN
27: l_proc := g_package||' create_pdc';
28: hr_utility.set_location('Entering:'||l_proc,5);
29: --
30: -- Issue a savepoint if operating in validation only mode
31: --
32: -- IF p_validate THEN

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

56: --
57: --
58:
59:
60: hr_utility.set_location(l_proc,6);
61:
62: -- Validation in Addition to Row Handlers:
63:
64: IF p_position_description_id is NULL THEN

Line 66: hr_utility.set_message(8301,'GHR_POS_DESC_ID_INVALID');

62: -- Validation in Addition to Row Handlers:
63:
64: IF p_position_description_id is NULL THEN
65:
66: hr_utility.set_message(8301,'GHR_POS_DESC_ID_INVALID');
67: hr_utility.raise_error;
68: END IF;
69:
70: -- Process Logic

Line 67: hr_utility.raise_error;

63:
64: IF p_position_description_id is NULL THEN
65:
66: hr_utility.set_message(8301,'GHR_POS_DESC_ID_INVALID');
67: hr_utility.raise_error;
68: END IF;
69:
70: -- Process Logic
71: -- Insert a row into GHR_PD_CLASSIFICATIONS using the row handler.

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

120: p_pdc_object_version_number := l_pdc_object_version_number;
121: p_pd_classification_id := l_pd_classification_id;
122:
123:
124: hr_utility.set_location ('Leaving:'|| l_proc,11);
125:
126: EXCEPTION
127:
128: WHEN hr_api.validate_enabled THEN

Line 149: hr_utility.set_location('Leaving:' || l_proc,12);

145: rollback to create_pdc;
146: p_pdc_object_version_number := NULL;
147: p_pd_classification_id := NULL;
148: raise;
149: hr_utility.set_location('Leaving:' || l_proc,12);
150: --
151: END create_pdc;
152:
153:

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

169: l_pdc_object_version_number NUMBER;
170:
171: BEGIN
172: l_proc := g_package||'Update_pdc';
173: hr_utility.set_location('Entering:'||l_proc,5);
174: l_pdc_object_version_number := p_pdc_object_version_number;
175: --
176: -- Issue a savepoint if operating in validation only mode
177: -- Bug # 671537

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

204: -- End of Before Process User Hook call
205: --
206: --
207:
208: hr_utility.set_location(l_proc,6);
209:
210: -- Validation in Addition to Row Handlers:
211:
212: IF (p_pd_classification_id is NULL )

Line 216: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');

212: IF (p_pd_classification_id is NULL )
213: AND (p_position_description_id is NULL OR p_class_grade_by is NULL)
214: THEN
215:
216: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');
217: END IF;
218:
219: -- Process Logic
220:

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

230: p_grade_level => p_grade_level,
231: p_object_version_number => l_object_version_number);
232:
233:
234: hr_utility.set_location(l_proc,8);
235:
236: --When in validation only mode raise the Validate_Enabled exception.
237: --
238:

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

273:
274: p_pdc_object_version_number := l_object_version_number;
275:
276: --
277: hr_utility.set_location('Leaving:'|| l_proc,11);
278:
279: EXCEPTION
280:
281: WHEN hr_api.validate_enabled THEN

Line 294: hr_utility.set_location('Leaving:' || l_proc,12);

290: when others then
291: rollback to update_pdc;
292: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
293: raise;
294: hr_utility.set_location('Leaving:' || l_proc,12);
295: --
296: hr_utility.set_location('Leaving:'||l_proc,12);
297: end update_pdc;
298:

Line 296: hr_utility.set_location('Leaving:'||l_proc,12);

292: p_pdc_object_version_number := l_pdc_object_version_number; -- Nocopy changes
293: raise;
294: hr_utility.set_location('Leaving:' || l_proc,12);
295: --
296: hr_utility.set_location('Leaving:'||l_proc,12);
297: end update_pdc;
298:
299: PROCEDURE delete_pdc
300: ( p_validate IN BOOLEAN default false,

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

308:
309:
310: BEGIN
311: l_proc := g_package||'Delete_pdc';
312: hr_utility.set_location('Entering:'||l_proc,5);
313:
314: SAVEPOINT delete_pdc;
315: --
316: -- Call Before Process User Hook

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

330: --
331: -- End of Before Process User Hook call
332: --
333:
334: hr_utility.set_location(l_proc,6);
335:
336: -- Validation in Addition to Row Handlers:
337:
338: IF (p_pd_classification_id is NULL )

Line 342: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');

338: IF (p_pd_classification_id is NULL )
339: AND (p_pdc_object_version_number is NULL)
340: THEN
341:
342: hr_utility.set_message(8301,'GHR_INSUFFICIENT_INFORMATION');
343: END IF;
344:
345: -- Process Logic
346:

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

350: ( p_pd_classification_id => p_pd_classification_id,
351: p_object_version_number => l_object_version_number);
352:
353:
354: hr_utility.set_location(l_proc,8);
355:
356: --When in validation only mode raise the Validate_Enabled exception.
357: --
358:

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

381: END IF;
382:
383:
384: --
385: hr_utility.set_location('Leaving:'|| l_proc,11);
386:
387: EXCEPTION
388:
389: WHEN hr_api.validate_enabled THEN

Line 399: hr_utility.set_location('Leaving:' || l_proc,12);

395: --
396: when others then
397: rollback to delete_pdc;
398: raise;
399: hr_utility.set_location('Leaving:' || l_proc,12);
400: --
401: hr_utility.set_location('Leaving:'||l_proc,12);
402: end delete_pdc;
403:

Line 401: hr_utility.set_location('Leaving:'||l_proc,12);

397: rollback to delete_pdc;
398: raise;
399: hr_utility.set_location('Leaving:' || l_proc,12);
400: --
401: hr_utility.set_location('Leaving:'||l_proc,12);
402: end delete_pdc;
403:
404: end ghr_pdc_api;