DBA Data[Home] [Help]

APPS.BEN_ABR_EXTRA_INFO_API dependencies on HR_UTILITY

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

75: l_object_version_number ben_abr_extra_info.object_version_number%type;
76: l_abr_extra_info_id ben_abr_extra_info.abr_extra_info_id%type;
77: --
78: begin
79: hr_utility.set_location('Entering:'|| l_proc, 5);
80: --
81: -- Issue a savepoint
82: --
83: savepoint create_abr_extra_info;

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

151: );
152: end;
153: --
154: -- End of Before Process User Hook call
155: hr_utility.set_location(l_proc, 7);
156: --
157: -- Process Logic
158: --
159: ben_abi_ins.ins

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

217: );
218: p_object_version_number := l_object_version_number;
219: p_abr_extra_info_id := l_abr_extra_info_id;
220: --
221: hr_utility.set_location(l_proc, 8);
222: --
223: -- Call After Process User Hook
224: --
225: begin

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

295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 11);
300: exception
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised

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

311: --
312: p_abr_extra_info_id := null;
313: p_object_version_number := null;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 12);
316: --
317: when others then
318: --
319: -- A validation or unexpected error has occurred

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

399: l_object_version_number ben_abr_extra_info.object_version_number%TYPE;
400: l_ovn ben_abr_extra_info.object_version_number%TYPE := p_object_version_number;
401: --
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 5);
404: --
405: -- Issue a savepoint
406: --
407: savepoint update_abr_extra_info;

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

475: end;
476: --
477: -- End of Before Process User Hook call
478: --
479: hr_utility.set_location(l_proc, 7);
480: --
481: -- Store the original ovn in case we rollback when p_validate is true
482: --
483: l_object_version_number := p_object_version_number;

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

541: ,p_object_version_number => p_object_version_number
542: ,p_validate => false
543: );
544: --
545: hr_utility.set_location(l_proc, 8);
546: --
547: -- Call After Process User Hook
548: --
549: begin

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

617: if p_validate then
618: raise hr_api.validate_enabled;
619: end if;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 11);
622: exception
623: when hr_api.validate_enabled then
624: --
625: -- As the Validate_Enabled exception has been raised

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

632: -- when validation only mode is being used.)
633: --
634: p_object_version_number := l_object_version_number;
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 12);
637: --
638: when others then
639: --
640: -- A validation or unexpected error has occurred

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

666: --
667: l_proc varchar2(72) := g_package||'delete_abr_extra_info';
668: --
669: begin
670: hr_utility.set_location('Entering:'|| l_proc, 5);
671: --
672: -- Issue a savepoint
673: --
674: savepoint delete_abr_extra_info;

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

688: p_hook_type => 'BP'
689: );
690: end;
691: --
692: hr_utility.set_location(l_proc, 7);
693: --
694: -- Process Logic - Delete abr Extra Info details
695: --
696: ben_abi_del.del

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

698: ,p_object_version_number => p_object_version_number
699: ,p_validate => false
700: );
701: --
702: hr_utility.set_location(l_proc, 8);
703: --
704: -- Call After Process User Hook
705: --
706: begin

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

722: if p_validate then
723: raise hr_api.validate_enabled;
724: end if;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 11);
727: exception
728: when hr_api.validate_enabled then
729: --
730: -- As the Validate_Enabled exception has been raised

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

731: -- we must rollback to the savepoint
732: --
733: ROLLBACK TO delete_abr_extra_info;
734: --
735: hr_utility.set_location(' Leaving:'||l_proc, 12);
736: --
737: when others then
738: --
739: -- A validation or unexpected error has occurred