72: l_allocated_checklist_id number(9);
73: l_proc varchar2(72) := g_package||'Create_checklist';
74:
75: begin
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint
79: --
80: savepoint CREATE_ALLOC_CHECKLIST;
318: --p_in_out_parameter :=
319: p_object_version_number := l_object_version_number;
320: --p_some_warning :=
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
335: --p_in_out_parameter := l_in_out_parameter;
336: p_allocated_checklist_id := null;
337: p_object_version_number := null;
338: --p_some_warning :=
339: hr_utility.set_location(' Leaving:'||l_proc, 80);
340: when others then
341: --
342: -- A validation or unexpected error has occured
343: --
349: --p_in_out_parameter := l_in_out_parameter;
350: p_allocated_checklist_id := null;
351: p_object_version_number := null;
352: --p_some_warning := null;
353: hr_utility.set_location(' Leaving:'||l_proc, 90);
354: raise;
355: end CREATE_ALLOC_CHECKLIST;
356: --
357: -- ----------------------------------------------------------------------------
422: l_object_version_number number;
423: l_temp_ovn number;
424:
425: begin
426: hr_utility.set_location('Entering:'|| l_proc, 10);
427: --
428: -- Issue a savepoint
429: --
430: savepoint UPDATE_ALLOC_CHECKLIST;
643: --
644: -- Set all output arguements
645: --
646: p_object_version_number := l_object_version_number;
647: hr_utility.set_location(' Leaving:'||l_proc, 70);
648: exception
649: when hr_Api.validate_enabled then
650: --
651: -- As the Validate_Enabled exception has been raised
656: -- Only set output warning arguments
657: -- (Any key or derived arguments must be set to null
658: -- when validation only mode is being used.)
659: --
660: hr_utility.set_location(' Leaving:'||l_proc, 80);
661: when others then
662: --
663: -- A validation or unexpected error has occured
664: --
663: -- A validation or unexpected error has occured
664: --
665: p_object_version_number := l_temp_ovn;
666: rollback to UPDATE_ALLOC_CHECKLIST;
667: hr_utility.set_location(' Leaving:'||l_proc, 90);
668: raise;
669:
670: end UPDATE_ALLOC_CHECKLIST;
671: --
684: l_proc varchar2(72) := g_package||'delete_alloc_checklist';
685: l_object_version_number number(9) := p_object_version_number;
686:
687: begin
688: hr_utility.set_location('Entering:'|| l_proc, 10);
689: --
690: -- Issue a savepoint
691: --
692: savepoint DELETE_ALLOC_CHECKLIST;
735: if p_validate then
736: raise hr_Api.validate_enabled;
737: end if;
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 70);
740: exception
741: when hr_Api.validate_enabled then
742: --
743: -- As the Validate_Enabled exception has been raised
744: -- we must rollback to the savepoint
745: --
746: rollback to DELETE_ALLOC_CHECKLIST;
747: --
748: hr_utility.set_location(' Leaving:'||l_proc, 80);
749: when others then
750: --
751: -- A validation or unexpected error has occured
752: --
750: --
751: -- A validation or unexpected error has occured
752: --
753: rollback to DELETE_ALLOC_CHECKLIST;
754: hr_utility.set_location(' Leaving:'||l_proc, 90);
755: raise;
756: end DELETE_ALLOC_CHECKLIST;
757: --
758: end PER_ALLOCATED_CHECKLIST_API;