92: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
93: --
94: begin
95: --
96: hr_utility.set_location('Entering:'|| l_proc, 10);
97: --
98: -- Issue a savepoint if operating in validation only mode
99: --
100: savepoint create_hierarchy;
98: -- Issue a savepoint if operating in validation only mode
99: --
100: savepoint create_hierarchy;
101: --
102: hr_utility.set_location(l_proc, 20);
103: --
104: -- Process Logic
105: --
106: begin
357: -- End of API User Hook for the after hook of create_hierarchy
358: --
359: end;
360: --
361: hr_utility.set_location(l_proc, 60);
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
370: --
371: p_hierarchy_id := l_hierarchy_id;
372: p_object_version_number := l_object_version_number;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: --
376: exception
377: --
378: when hr_api.validate_enabled then
387: -- when validation only mode is being used.)
388: --
389: p_hierarchy_id := null;
390: p_object_version_number := null;
391: hr_utility.set_location(' Leaving:'||l_proc, 80);
392: --
393: when others then
394: --
395: -- A validation or unexpected error has occured
485: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
486: --
487: begin
488: --
489: hr_utility.set_location('Entering:'|| l_proc, 10);
490: --
491: -- Issue a savepoint if operating in validation only mode
492: --
493: savepoint update_hierarchy;
491: -- Issue a savepoint if operating in validation only mode
492: --
493: savepoint update_hierarchy;
494: --
495: hr_utility.set_location(l_proc, 20);
496: --
497: -- Process Logic
498: --
499: l_object_version_number := p_object_version_number;
747: -- End of API User Hook for the after hook of update_hierarchy
748: --
749: end;
750: --
751: hr_utility.set_location(l_proc, 60);
752: --
753: -- When in validation only mode raise the Validate_Enabled exception
754: --
755: if p_validate then
759: -- Set all output arguments
760: --
761: p_object_version_number := l_object_version_number;
762: --
763: hr_utility.set_location(' Leaving:'||l_proc, 70);
764: --
765: exception
766: --
767: when hr_api.validate_enabled then
774: -- Only set output warning arguments
775: -- (Any key or derived arguments must be set to null
776: -- when validation only mode is being used.)
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 80);
779: --
780: when others then
781: --
782: -- A validation or unexpected error has occured
803: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
804: --
805: begin
806: --
807: hr_utility.set_location('Entering:'|| l_proc, 10);
808: --
809: -- Issue a savepoint if operating in validation only mode
810: --
811: savepoint delete_hierarchy;
809: -- Issue a savepoint if operating in validation only mode
810: --
811: savepoint delete_hierarchy;
812: --
813: hr_utility.set_location(l_proc, 20);
814: --
815: -- Process Logic
816: --
817: l_object_version_number := p_object_version_number;
862: -- End of API User Hook for the after hook of delete_hierarchy
863: --
864: end;
865: --
866: hr_utility.set_location(l_proc, 60);
867: --
868: -- When in validation only mode raise the Validate_Enabled exception
869: --
870: if p_validate then
870: if p_validate then
871: raise hr_api.validate_enabled;
872: end if;
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 70);
875: --
876: exception
877: --
878: when hr_api.validate_enabled then
914: l_proc varchar2(72) := g_package||'lck';
915: --
916: begin
917: --
918: hr_utility.set_location('Entering:'|| l_proc, 10);
919: --
920: per_pgh_shd.lck
921: (
922: p_hierarchy_id => p_hierarchy_id
922: p_hierarchy_id => p_hierarchy_id
923: ,p_object_version_number => p_object_version_number
924: );
925: --
926: hr_utility.set_location(' Leaving:'||l_proc, 70);
927: --
928: end lck;
929: --
930: end per_hierarchy_api;