29: l_object_version_number ben_ext_incl_chg.object_version_number%TYPE;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_EXT_INCL_CHG;
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_EXT_INCL_CHG;
38: --
39: hr_utility.set_location(l_proc, 20);
40: --
41: -- Process Logic
42: --
43: begin
105: -- End of API User Hook for the after hook of create_EXT_INCL_CHG
106: --
107: end;
108: --
109: hr_utility.set_location(l_proc, 60);
110: --
111: -- When in validation only mode raise the Validate_Enabled exception
112: --
113: if p_validate then
118: --
119: p_ext_incl_chg_id := l_ext_incl_chg_id;
120: p_object_version_number := l_object_version_number;
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: --
124: exception
125: --
126: when hr_api.validate_enabled then
135: -- when validation only mode is being used.)
136: --
137: p_ext_incl_chg_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 80);
140: --
141: when others then
142: --
143: -- A validation or unexpected error has occured
169: l_object_version_number ben_ext_incl_chg.object_version_number%TYPE;
170: --
171: begin
172: --
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: -- Issue a savepoint if operating in validation only mode
176: --
177: savepoint update_EXT_INCL_CHG;
175: -- Issue a savepoint if operating in validation only mode
176: --
177: savepoint update_EXT_INCL_CHG;
178: --
179: hr_utility.set_location(l_proc, 20);
180: --
181: -- Process Logic
182: --
183: l_object_version_number := p_object_version_number;
248: -- End of API User Hook for the after hook of update_EXT_INCL_CHG
249: --
250: end;
251: --
252: hr_utility.set_location(l_proc, 60);
253: --
254: -- When in validation only mode raise the Validate_Enabled exception
255: --
256: if p_validate then
260: -- Set all output arguments
261: --
262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: --
266: exception
267: --
268: when hr_api.validate_enabled then
275: -- Only set output warning arguments
276: -- (Any key or derived arguments must be set to null
277: -- when validation only mode is being used.)
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 80);
280: --
281: when others then
282: --
283: -- A validation or unexpected error has occured
304: l_object_version_number ben_ext_incl_chg.object_version_number%TYPE;
305: --
306: begin
307: --
308: hr_utility.set_location('Entering:'|| l_proc, 10);
309: --
310: -- Issue a savepoint if operating in validation only mode
311: --
312: savepoint delete_EXT_INCL_CHG;
310: -- Issue a savepoint if operating in validation only mode
311: --
312: savepoint delete_EXT_INCL_CHG;
313: --
314: hr_utility.set_location(l_proc, 20);
315: --
316: -- Process Logic
317: --
318: l_object_version_number := p_object_version_number;
369: -- End of API User Hook for the after hook of delete_EXT_INCL_CHG
370: --
371: end;
372: --
373: hr_utility.set_location(l_proc, 60);
374: --
375: -- When in validation only mode raise the Validate_Enabled exception
376: --
377: if p_validate then
377: if p_validate then
378: raise hr_api.validate_enabled;
379: end if;
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 70);
382: --
383: exception
384: --
385: when hr_api.validate_enabled then
419: l_proc varchar2(72) := g_package||'lck';
420: --
421: begin
422: --
423: hr_utility.set_location('Entering:'|| l_proc, 10);
424: --
425: ben_xic_shd.lck
426: (
427: p_ext_incl_chg_id => p_ext_incl_chg_id
427: p_ext_incl_chg_id => p_ext_incl_chg_id
428: ,p_object_version_number => p_object_version_number
429: );
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 70);
432: --
433: end lck;
434: --
435: end ben_EXT_INCL_CHG_api;