DBA Data[Home] [Help]

APPS.GHR_COMPLAINANT_APPEALS_API dependencies on HR_UTILITY

Line 58: hr_utility.set_location('Entering:'|| l_proc, 10);

54: l_proc varchar2(72) := g_package||'create_complaint_appeal';
55: l_compl_appeal_id number;
56: l_object_version_number number;
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_complainant_appeal;

Line 63: hr_utility.set_location(l_proc, 20);

59: --
60: -- Issue a savepoint
61: --
62: savepoint create_complainant_appeal;
63: hr_utility.set_location(l_proc, 20);
64: -- Truncate the time portion from all IN date parameters
65: --
66: --
67: -- Call Before Process User Hook

Line 115: hr_utility.set_location(l_proc, 40);

111: --
112: -- Validation in addition to Row Handlers
113: --
114:
115: hr_utility.set_location(l_proc, 40);
116: --
117: -- Process Logic
118: --
119: ghr_cca_ins.ins

Line 157: hr_utility.set_location(l_proc, 50);

153: ,p_compl_appeal_id => l_compl_appeal_id
154: ,p_object_version_number => l_object_version_number
155: );
156:
157: hr_utility.set_location(l_proc, 50);
158: --
159: --
160: -- Call After Process User Hook
161: --

Line 218: hr_utility.set_location(' Leaving:'||l_proc, 70);

214: --
215: p_compl_appeal_id := l_compl_appeal_id;
216: p_object_version_number := l_object_version_number;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 70);
219: exception
220: when hr_api.validate_enabled then
221: --
222: -- As the Validate_Enabled exception has been raised

Line 234: hr_utility.set_location(' Leaving:'||l_proc, 80);

230: --
231: -- RESET In/Out Params and SET Out Params
232: p_compl_appeal_id := null;
233: p_object_version_number := null;
234: hr_utility.set_location(' Leaving:'||l_proc, 80);
235: when others then
236: --
237: -- A validation or unexpected error has occured
238: --

Line 243: hr_utility.set_location(' Leaving:'||l_proc, 90);

239: rollback to create_complainant_appeal;
240: -- RESET In/Out Params and SET Out Params
241: p_compl_appeal_id := null;
242: p_object_version_number := null;
243: hr_utility.set_location(' Leaving:'||l_proc, 90);
244: raise;
245: end create_complainant_appeal;
246: --
247:

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

287: is
288: l_proc varchar2(72) := g_package||'update_complaint_appeal';
289: l_object_version_number number;
290: begin
291: hr_utility.set_location('Entering:'|| l_proc, 5);
292: --
293: savepoint update_complainant_appeal;
294: -- Store the original ovn in case we rollback when p_validate is true
295:

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

348: -- Validation in addition to Row Handlers
349:
350: l_object_version_number := p_object_version_number;
351:
352: hr_utility.set_location(l_proc, 6);
353:
354: ghr_cca_upd.upd
355: (p_effective_date => p_effective_date
356: ,p_complaint_id => p_complaint_id

Line 449: hr_utility.set_location(' Leaving:'||l_proc, 70);

445: --
446:
447: p_object_version_number := l_object_version_number;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised

Line 464: hr_utility.set_location(' Leaving:'||l_proc, 80);

460: -- Only set output warning arguments
461: -- (Any key or derived arguments must be set to null
462: -- when validation only mode is being used.)
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 80);
465: when others then
466: --
467: -- A validation or unexpected error has occured
468: --

Line 472: hr_utility.set_location(' Leaving:'||l_proc, 90);

468: --
469: rollback to update_complainant_appeal;
470: -- Reset In/Out Params and SET Out Params
471: p_object_version_number:=l_object_version_number;
472: hr_utility.set_location(' Leaving:'||l_proc, 90);
473: raise;
474:
475: end update_complainant_appeal;
476:

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

489: l_proc varchar2(72) := g_package||'delete_complaint_appeal';
490: l_exists boolean := false;
491:
492: begin
493: hr_utility.set_location('Entering:'|| l_proc, 5);
494: --
495: --
496: savepoint delete_complainant_appeal;
497: --

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

520: (p_compl_appeal_id => p_compl_appeal_id
521: ,p_object_version_number => p_object_version_number
522: );
523: --
524: hr_utility.set_location(l_proc, 8);
525: --
526: -- Call After Process User Hook
527: --
528: begin

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

544: if p_validate then
545: raise hr_api.validate_enabled;
546: end if;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 11);
549: exception
550: when hr_api.validate_enabled then
551: -- we must rollback to the savepoint
552: --

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

555: When Others then
556: ROLLBACK TO delete_complainant_appeal;
557: raise;
558:
559: hr_utility.set_location(' Leaving:'||l_proc, 12);
560: end delete_complainant_appeal;
561: end ghr_complainant_appeals_api;