71: l_checklist_id number(9);
72: l_proc varchar2(72) := g_package||'Create Checklist';
73:
74: begin
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: --
77: -- Issue a savepoint
78: --
79: savepoint CREATE_CHECKLIST;
311: --p_in_out_parameter :=
312: p_object_version_number := l_object_version_number;
313: --p_some_warning :=
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: exception
317: when hr_api.validate_enabled then
318: --
319: -- As the Validate_Enabled exception has been raised
328: --p_in_out_parameter := l_in_out_parameter;
329: p_checklist_id := null;
330: p_object_version_number := null;
331: --p_some_warning :=
332: hr_utility.set_location(' Leaving:'||l_proc, 80);
333: when others then
334: --
335: -- A validation or unexpected error has occured
336: --
342: --p_in_out_parameter := l_in_out_parameter;
343: p_checklist_id := null;
344: p_object_version_number := null;
345: --p_some_warning := null;
346: hr_utility.set_location(' Leaving:'||l_proc, 90);
347: raise;
348: end CREATE_CHECKLIST;
349: --
350: -- ----------------------------------------------------------------------------
413: l_object_version_number number;
414: l_temp_ovn number;
415:
416: begin
417: hr_utility.set_location('Entering:'|| l_proc, 10);
418: --
419: -- Issue a savepoint
420: --
421: savepoint UPDATE_CHECKLIST;
628: --
629: -- Set all output arguements
630: --
631: p_object_version_number := l_object_version_number;
632: hr_utility.set_location(' Leaving:'||l_proc, 70);
633: exception
634: when hr_Api.validate_enabled then
635: --
636: -- As the Validate_Enabled exception has been raised
641: -- Only set output warning arguments
642: -- (Any key or derived arguments must be set to null
643: -- when validation only mode is being used.)
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 80);
646: when others then
647: --
648: -- A validation or unexpected error has occured
649: --
648: -- A validation or unexpected error has occured
649: --
650: p_object_version_number := l_temp_ovn;
651: rollback to UPDATE_CHECKLIST;
652: hr_utility.set_location(' Leaving:'||l_proc, 90);
653: raise;
654:
655: end UPDATE_CHECKLIST;
656: --
669: l_proc varchar2(72) := g_package||'delete_checklist';
670: l_object_version_number number(9) := p_object_version_number;
671:
672: begin
673: hr_utility.set_location('Entering:'|| l_proc, 10);
674: --
675: -- Issue a savepoint
676: --
677: savepoint DELETE_CHECKLIST;
720: if p_validate then
721: raise hr_Api.validate_enabled;
722: end if;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 70);
725: exception
726: when hr_Api.validate_enabled then
727: --
728: -- As the Validate_Enabled exception has been raised
729: -- we must rollback to the savepoint
730: --
731: rollback to DELETE_CHECKLIST;
732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 80);
734: when others then
735: --
736: -- A validation or unexpected error has occured
737: --
735: --
736: -- A validation or unexpected error has occured
737: --
738: rollback to DELETE_CHECKLIST;
739: hr_utility.set_location(' Leaving:'||l_proc, 90);
740: raise;
741: end DELETE_CHECKLIST;
742: --
743: end PER_CHECKLISTS_API;