23: l_proc varchar2(72) := g_package||'CREATE_VARIABLE_COMPENSATION';
24: l_object_version_number number;
25: l_effective_date date;
26: begin
27: hr_utility.set_location('Entering:'|| l_proc, 10);
28: --
29: -- Issue a savepoint
30: --
31: savepoint CREATE_VARIABLE_COMPENSATION;
86: --
87: -- Set all output arguments
88: p_object_version_number := l_object_version_number;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 70);
91: exception
92: when hr_api.validate_enabled then
93: --
94: -- As the Validate_Enabled exception has been raised
100: -- (Any key or derived arguments must be set to null
101: -- when validation only mode is being used.)
102: p_object_version_number := null;
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 80);
105: when others then
106: --
107: -- A validation or unexpected error has occured
108: --
107: -- A validation or unexpected error has occured
108: --
109: p_object_version_number := null;
110: rollback to CREATE_VARIABLE_COMPENSATION;
111: hr_utility.set_location(' Leaving:'||l_proc, 90);
112: raise;
113: end CREATE_VARIABLE_COMPENSATION;
114: --
115: -- ----------------------------------------------------------------------------
126: -- Declare cursors and local variables
127: --
128: l_proc varchar2(72) := g_package||'DELETE_VARIABLE_COMPENSATION';
129: begin
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Issue a savepoint
133: --
134: savepoint DELETE_VARIABLE_COMPENSATION;
185: --
186: -- Set all output arguments
187: -- No output Parameters.
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 70);
190: exception
191: when hr_api.validate_enabled then
192: --
193: -- As the Validate_Enabled exception has been raised
198: -- Only set output warning arguments
199: -- (Any key or derived arguments must be set to null
200: -- when validation only mode is being used.)
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 80);
203: when others then
204: --
205: -- A validation or unexpected error has occured
206: --
204: --
205: -- A validation or unexpected error has occured
206: --
207: rollback to DELETE_VARIABLE_COMPENSATION;
208: hr_utility.set_location(' Leaving:'||l_proc, 90);
209: raise;
210: end DELETE_VARIABLE_COMPENSATION;
211: --
212: end IRC_VARIABLE_COMP_ELEMENT_API;