72: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_EXT_DATA_ELMT;
78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_EXT_DATA_ELMT;
81: --
82: hr_utility.set_location(l_proc, 20);
83: --
84: -- Process Logic
85: --
86: begin
277: -- End of API User Hook for the after hook of create_EXT_DATA_ELMT
278: --
279: end;
280: --
281: hr_utility.set_location(l_proc, 60);
282: --
283: -- When in validation only mode raise the Validate_Enabled exception
284: --
285: if p_validate then
290: --
291: p_ext_data_elmt_id := l_ext_data_elmt_id;
292: p_object_version_number := l_object_version_number;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: --
296: exception
297: --
298: when hr_api.validate_enabled then
307: -- when validation only mode is being used.)
308: --
309: p_ext_data_elmt_id := null;
310: p_object_version_number := null;
311: hr_utility.set_location(' Leaving:'||l_proc, 80);
312: --
313: when others then
314: --
315: -- A validation or unexpected error has occured
384: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
385: --
386: begin
387: --
388: hr_utility.set_location('Entering:'|| l_proc, 10);
389: --
390: -- Issue a savepoint if operating in validation only mode
391: --
392: savepoint update_EXT_DATA_ELMT;
390: -- Issue a savepoint if operating in validation only mode
391: --
392: savepoint update_EXT_DATA_ELMT;
393: --
394: hr_utility.set_location(l_proc, 20);
395: --
396: -- Process Logic
397: --
398: l_object_version_number := p_object_version_number;
592: -- End of API User Hook for the after hook of update_EXT_DATA_ELMT
593: --
594: end;
595: --
596: hr_utility.set_location(l_proc, 60);
597: --
598: -- When in validation only mode raise the Validate_Enabled exception
599: --
600: if p_validate then
604: -- Set all output arguments
605: --
606: p_object_version_number := l_object_version_number;
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 70);
609: --
610: exception
611: --
612: when hr_api.validate_enabled then
619: -- Only set output warning arguments
620: -- (Any key or derived arguments must be set to null
621: -- when validation only mode is being used.)
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 80);
624: --
625: when others then
626: --
627: -- A validation or unexpected error has occured
648: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
649: --
650: begin
651: --
652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: -- Issue a savepoint if operating in validation only mode
655: --
656: savepoint delete_EXT_DATA_ELMT;
654: -- Issue a savepoint if operating in validation only mode
655: --
656: savepoint delete_EXT_DATA_ELMT;
657: --
658: hr_utility.set_location(l_proc, 20);
659: --
660: -- Process Logic
661: --
662: l_object_version_number := p_object_version_number;
713: -- End of API User Hook for the after hook of delete_EXT_DATA_ELMT
714: --
715: end;
716: --
717: hr_utility.set_location(l_proc, 60);
718: --
719: -- When in validation only mode raise the Validate_Enabled exception
720: --
721: if p_validate then
721: if p_validate then
722: raise hr_api.validate_enabled;
723: end if;
724: --
725: hr_utility.set_location(' Leaving:'||l_proc, 70);
726: --
727: exception
728: --
729: when hr_api.validate_enabled then
763: l_proc varchar2(72) := g_package||'lck';
764: --
765: begin
766: --
767: hr_utility.set_location('Entering:'|| l_proc, 10);
768: --
769: ben_xel_shd.lck
770: (
771: p_ext_data_elmt_id => p_ext_data_elmt_id
771: p_ext_data_elmt_id => p_ext_data_elmt_id
772: ,p_object_version_number => p_object_version_number
773: );
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 70);
776: --
777: end lck;
778: --
779: end ben_EXT_DATA_ELMT_api;