29: l_object_version_number ben_batch_commu_info.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_batch_commu_info;
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_batch_commu_info;
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_batch_commu_info
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_batch_commu_id := l_batch_commu_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_batch_commu_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
176: l_object_version_number ben_batch_commu_info.object_version_number%TYPE;
177: --
178: begin
179: --
180: hr_utility.set_location('Entering:'|| l_proc, 10);
181: --
182: -- Issue a savepoint if operating in validation only mode
183: --
184: savepoint update_batch_commu_info;
182: -- Issue a savepoint if operating in validation only mode
183: --
184: savepoint update_batch_commu_info;
185: --
186: hr_utility.set_location(l_proc, 20);
187: --
188: -- Process Logic
189: --
190: l_object_version_number := p_object_version_number;
255: -- End of API User Hook for the after hook of update_batch_commu_info
256: --
257: end;
258: --
259: hr_utility.set_location(l_proc, 60);
260: --
261: -- When in validation only mode raise the Validate_Enabled exception
262: --
263: if p_validate then
267: -- Set all output arguments
268: --
269: p_object_version_number := l_object_version_number;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 70);
272: --
273: exception
274: --
275: when hr_api.validate_enabled then
282: -- Only set output warning arguments
283: -- (Any key or derived arguments must be set to null
284: -- when validation only mode is being used.)
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 80);
287: --
288: when others then
289: --
290: -- A validation or unexpected error has occured
309: l_object_version_number ben_batch_commu_info.object_version_number%TYPE;
310: --
311: begin
312: --
313: hr_utility.set_location('Entering:'|| l_proc, 10);
314: --
315: -- Issue a savepoint if operating in validation only mode
316: --
317: savepoint delete_batch_commu_info;
315: -- Issue a savepoint if operating in validation only mode
316: --
317: savepoint delete_batch_commu_info;
318: --
319: hr_utility.set_location(l_proc, 20);
320: --
321: -- Process Logic
322: --
323: l_object_version_number := p_object_version_number;
368: -- End of API User Hook for the after hook of delete_batch_commu_info
369: --
370: end;
371: --
372: hr_utility.set_location(l_proc, 60);
373: --
374: -- When in validation only mode raise the Validate_Enabled exception
375: --
376: if p_validate then
376: if p_validate then
377: raise hr_api.validate_enabled;
378: end if;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 70);
381: --
382: exception
383: --
384: when hr_api.validate_enabled then
418: l_proc varchar2(72) := g_package||'lck';
419: --
420: begin
421: --
422: hr_utility.set_location('Entering:'|| l_proc, 10);
423: --
424: ben_bmi_shd.lck
425: (
426: p_batch_commu_id => p_batch_commu_id
426: p_batch_commu_id => p_batch_commu_id
427: ,p_object_version_number => p_object_version_number
428: );
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 70);
431: --
432: end lck;
433: --
434: end ben_batch_commu_info_api;