DBA Data[Home] [Help]

APPS.OTA_OFFERING_API dependencies on HR_UTILITY

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

72: l_object_version_number number;
73: l_effective_date date;
74: l_name varchar2(80);
75: begin
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint
79: --
80: savepoint CREATE_OFFERING;

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

301: p_offering_id := l_offering_id;
302: p_object_version_number := l_object_version_number;
303:
304:
305: hr_utility.set_location(' Leaving:'||l_proc, 70);
306: exception
307: when hr_api.validate_enabled then
308: --
309: -- As the Validate_Enabled exception has been raised

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

316: -- when validation only mode is being used.)
317: --
318: p_offering_id := null;
319: p_object_version_number := null;
320: hr_utility.set_location(' Leaving:'||l_proc, 80);
321: when others then
322: --
323: -- A validation or unexpected error has occured
324: --

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

324: --
325: rollback to CREATE_OFFERING;
326: p_offering_id := null;
327: p_object_version_number := null;
328: hr_utility.set_location(' Leaving:'||l_proc, 90);
329: raise;
330: end create_offering;
331: -- ----------------------------------------------------------------------------
332: -- |----------------------------< update_offering >---------------------------|

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

394: l_effective_date date;
395: l_object_version_number number := p_object_version_number;
396: l_name varchar2(80);
397: begin
398: hr_utility.set_location('Entering:'|| l_proc, 10);
399: --
400: -- Issue a savepoint
401: --
402: savepoint UPDATE_OFFERING;

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

612: end if;
613: --
614: -- Set all output arguments
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: exception
618: when hr_api.validate_enabled then
619: --
620: -- As the Validate_Enabled exception has been raised

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

626: -- (Any key or derived arguments must be set to null
627: -- when validation only mode is being used.)
628: --
629: p_object_version_number := null;
630: hr_utility.set_location(' Leaving:'||l_proc, 80);
631: when others then
632: --
633: -- A validation or unexpected error has occured
634: --

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

633: -- A validation or unexpected error has occured
634: --
635: rollback to UPDATE_OFFERING;
636: p_object_version_number := l_object_version_number;
637: hr_utility.set_location(' Leaving:'||l_proc, 90);
638: raise;
639: end update_offering;
640: --
641: -- ----------------------------------------------------------------------------

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

654: l_object_version_id number;
655: --
656: --
657: begin
658: hr_utility.set_location('Entering:'|| l_proc, 10);
659: --
660: -- Issue a savepoint
661: --
662: savepoint DELETE_OFFERING;

Line 723: hr_utility.set_location(' Leaving:'||l_proc, 170);

719: --
720: -- Set all output arguments
721: --
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 170);
724: exception
725: when hr_api.validate_enabled then
726: --
727: -- As the Validate_Enabled exception has been raised

Line 736: hr_utility.set_location(' Leaving:'||l_proc, 180);

732: -- Only set output warning arguments
733: -- (Any key or derived arguments must be set to null
734: -- when validation only mode is being used.)
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 180);
737: when others then
738: --
739: -- A validation or unexpected error has occured
740: --

Line 742: hr_utility.set_location(' Leaving:'||l_proc, 190);

738: --
739: -- A validation or unexpected error has occured
740: --
741: rollback to DELETE_OFFERING;
742: hr_utility.set_location(' Leaving:'||l_proc, 190);
743: raise;
744: end delete_offering;
745: --
746: