[Home] [Help]
64: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Initialize environment
71: --
72: if fnd_global.conc_request_id = -1 then
85: -- Issue a savepoint if operating in validation only mode
86: --
87: savepoint create_prv_ctfn_prvdd;
88: --
89: hr_utility.set_location(l_proc, 20);
90: --
91: -- Process Logic
92: --
93: begin
257: -- End of API User Hook for the after hook of create_prv_ctfn_prvdd
258: --
259: end;
260: --
261: hr_utility.set_location(l_proc, 60);
262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
270: --
271: p_prtt_rt_val_ctfn_prvdd_id := l_prtt_rt_val_ctfn_prvdd_id;
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
287: -- when validation only mode is being used.)
288: --
289: p_prtt_rt_val_ctfn_prvdd_id := null;
290: p_object_version_number := null;
291: hr_utility.set_location(' Leaving:'||l_proc, 80);
292: --
293: when others then
294: --
295: -- A validation or unexpected error has occured
375: l_dummy_number number;
376: --
377: begin
378: --
379: hr_utility.set_location('Entering:'|| l_proc, 10);
380: --
381: -- Initialize environment
382: --
383: if fnd_global.conc_request_id = -1 then
396: -- Issue a savepoint if operating in validation only mode
397: --
398: savepoint update_prv_ctfn_prvdd;
399: --
400: hr_utility.set_location(l_proc, 20);
401: --
402: -- Process Logic
403: --
404: l_object_version_number := p_object_version_number;
616: --
617: -- end if;
618: --
619: end if;
620: hr_utility.set_location(' Leaving:'||l_proc, 64);
621: --
622: -- When in validation only mode raise the Validate_Enabled exception
623: --
624: if p_validate then
629: --
630: p_object_version_number := l_object_version_number;
631:
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 70);
634: --
635: exception
636: --
637: when hr_api.validate_enabled then
644: -- Only set output warning arguments
645: -- (Any key or derived arguments must be set to null
646: -- when validation only mode is being used.)
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 80);
649: --
650: when others then
651: --
652: -- A validation or unexpected error has occured
679: l_exist varchar2(1) := 'N';
680: --
681: begin
682: --
683: hr_utility.set_location('Entering:'|| l_proc, 10);
684: --
685: -- Get action item id and the business group id.
686: --
687: -- Initialize environment
702: -- Issue a savepoint if operating in validation only mode
703: --
704: savepoint delete_prv_ctfn_prvdd;
705: --
706: hr_utility.set_location(l_proc, 20);
707: --
708: -- Process Logic
709: --
710: l_object_version_number := p_object_version_number;
756: -- End of API User Hook for the after hook of delete_prv_ctfn_prvdd
757: --
758: end;
759: --
760: hr_utility.set_location(l_proc, 60);
761: --
762: -- When in validation only mode raise the Validate_Enabled exception
763: --
764: if p_validate then
764: if p_validate then
765: raise hr_api.validate_enabled;
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 70);
769: --
770: exception
771: --
772: when hr_api.validate_enabled then
806: l_proc varchar2(72) := g_package||'lck';
807: --
808: begin
809: --
810: hr_utility.set_location('Entering:'|| l_proc, 10);
811: --
812: ben_rvc_shd.lck
813: (
814: p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id
814: p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id
815: ,p_object_version_number => p_object_version_number
816: );
817: --
818: hr_utility.set_location(' Leaving:'||l_proc, 70);
819: --
820: end lck;
821: --
822: end ben_prv_ctfn_prvdd_api;