[Home] [Help]
77: -- Bug fix 3132479 . Local variable to store information category.
78: l_lei_information_category hr_location_extra_info.lei_information_category%type;
79: --
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 5);
82: --
83: -- Issue a savepoint if operating in validation only mode.
84: --
85: savepoint create_location_extra_info;
164: --
165: -- End of Before Process User Hook call
166: --
167: --
168: hr_utility.set_location(l_proc, 7);
169: --
170: -- Process Logic
171: --
172: hr_lei_ins.ins
230: );
231: p_object_version_number := l_object_version_number;
232: p_location_extra_info_id := l_location_extra_info_id;
233: --
234: hr_utility.set_location(l_proc, 8);
235: --
236: --
237: -- Call After Process User Hook
238: --
312: if p_validate then
313: raise hr_api.validate_enabled;
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 11);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
328: --
329: p_location_extra_info_id := null;
330: p_object_version_number := null;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 12);
333: --
334: when others then
335: --
336: -- A validation or unexpected error has occurred
414: l_object_version_number hr_location_extra_info.object_version_number%TYPE;
415: l_temp_ovn hr_location_extra_info.object_version_number%TYPE;
416: --
417: begin
418: hr_utility.set_location('Entering:'|| l_proc, 5);
419: --
420: -- Issue a savepoint if operating in validation only mode.
421: --
422: savepoint update_location_extra_info;
494: --
495: -- End of Before Process User Hook call
496: --
497: --
498: hr_utility.set_location(l_proc, 7);
499: --
500: -- Store the original ovn in case we rollback when p_validate is true
501: --
502: l_object_version_number := p_object_version_number;
560: ,p_object_version_number => p_object_version_number
561: ,p_validate => false
562: );
563: --
564: hr_utility.set_location(l_proc, 8);
565: --
566: --
567: -- Call After Process User Hook
568: --
638: if p_validate then
639: raise hr_api.validate_enabled;
640: end if;
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 11);
643: exception
644: when hr_api.validate_enabled then
645: --
646: -- As the Validate_Enabled exception has been raised
653: -- when validation only mode is being used.)
654: --
655: p_object_version_number := l_object_version_number;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 12);
658: --
659: when others then
660: --
661: -- A validation or unexpected error has occurred
685: --
686: l_proc varchar2(72) := g_package||'delete_location_extra_info';
687: --
688: begin
689: hr_utility.set_location('Entering:'|| l_proc, 5);
690: --
691: -- Issue a savepoint if operating in validation only mode.
692: --
693: savepoint delete_location_extra_info;
707: );
708: end;
709: --
710: --
711: hr_utility.set_location(l_proc, 7);
712: --
713: -- Process Logic - Delete location Extra Info details
714: --
715: hr_lei_del.del
717: ,p_object_version_number => p_object_version_number
718: ,p_validate => false
719: );
720: --
721: hr_utility.set_location(l_proc, 8);
722: --
723: --
724: -- Call After Process User Hook
725: --
741: if p_validate then
742: raise hr_api.validate_enabled;
743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 11);
746: exception
747: when hr_api.validate_enabled then
748: --
749: -- As the Validate_Enabled exception has been raised
750: -- we must rollback to the savepoint
751: --
752: ROLLBACK TO delete_location_extra_info;
753: --
754: hr_utility.set_location(' Leaving:'||l_proc, 12);
755: --
756: when others then
757: --
758: -- A validation or unexpected error has occurred