DBA Data[Home] [Help]

APPS.PQH_ROLE_EXTRA_INFO_API dependencies on HR_UTILITY

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

85: l_object_version_number pqh_role_extra_info.object_version_number%type;
86: l_role_extra_info_id pqh_role_extra_info.role_extra_info_id%type;
87: --
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 5);
90: --
91: -- Issue a savepoint
92: --
93: savepoint create_role_extra_info;

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

170: );
171: end;
172: --
173: -- End of Before Process User Hook call
174: hr_utility.set_location(l_proc, 7);
175: --
176: -- Process Logic
177: --
178: pqh_rei_ins.ins

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

246: );
247: p_object_version_number := l_object_version_number;
248: p_role_extra_info_id := l_role_extra_info_id;
249: --
250: hr_utility.set_location(l_proc, 8);
251: --
252: -- Call After Process User Hook
253: --
254: begin

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

334: if p_validate then
335: raise hr_api.validate_enabled;
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 11);
339: exception
340: when hr_api.validate_enabled then
341: --
342: -- As the Validate_Enabled exception has been raised

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

350: --
351: p_role_extra_info_id := null;
352: p_object_version_number := null;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 12);
355: --
356: when others then
357:
358: p_role_extra_info_id := null;

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

445: l_proc varchar2(72) := g_package||'update_role_extra_info';
446: l_object_version_number pqh_role_extra_info.object_version_number%TYPE;
447: --
448: begin
449: hr_utility.set_location('Entering:'|| l_proc, 5);
450: --
451: -- Issue a savepoint
452: --
453: savepoint update_role_extra_info;

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

531: end;
532: --
533: -- End of Before Process User Hook call
534: --
535: hr_utility.set_location(l_proc, 7);
536: --
537: -- Store the original ovn in case we rollback when p_validate is true
538: --
539: l_object_version_number := p_object_version_number;

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

607: ,p_object_version_number => p_object_version_number
608: ,p_validate => false
609: );
610: --
611: hr_utility.set_location(l_proc, 8);
612: --
613: -- Call After Process User Hook
614: --
615: begin

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

693: if p_validate then
694: raise hr_api.validate_enabled;
695: end if;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 11);
698: exception
699: when hr_api.validate_enabled then
700: --
701: -- As the Validate_Enabled exception has been raised

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

708: -- when validation only mode is being used.)
709: --
710: p_object_version_number := l_object_version_number;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 12);
713: --
714: when others then
715:
716: p_object_version_number := l_object_version_number;

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

740: --
741: l_proc varchar2(72) := g_package||'delete_role_extra_info';
742: --
743: begin
744: hr_utility.set_location('Entering:'|| l_proc, 5);
745: --
746: -- Issue a savepoint
747: --
748: savepoint delete_role_extra_info;

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

762: p_hook_type => 'BP'
763: );
764: end;
765: --
766: hr_utility.set_location(l_proc, 7);
767: --
768: -- Process Logic - Delete role Extra Info details
769: --
770: pqh_rei_del.del

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

772: ,p_object_version_number => p_object_version_number
773: ,p_validate => false
774: );
775: --
776: hr_utility.set_location(l_proc, 8);
777: --
778: -- Call After Process User Hook
779: --
780: begin

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

796: if p_validate then
797: raise hr_api.validate_enabled;
798: end if;
799: --
800: hr_utility.set_location(' Leaving:'||l_proc, 11);
801: exception
802: when hr_api.validate_enabled then
803: --
804: -- As the Validate_Enabled exception has been raised

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

805: -- we must rollback to the savepoint
806: --
807: ROLLBACK TO delete_role_extra_info;
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 12);
810: --
811: when others then
812: --
813: -- A validation or unexpected error has occurred