32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- Issue a savepoint if operating in validation only mode
39: --
40: savepoint create_ELIG_RSLT;
38: -- Issue a savepoint if operating in validation only mode
39: --
40: savepoint create_ELIG_RSLT;
41: --
42: hr_utility.set_location(l_proc, 20);
43: --
44: -- Process Logic
45: --
46: begin
109: -- End of API User Hook for the after hook of create_ELIG_RSLT
110: --
111: end;
112: --
113: hr_utility.set_location(l_proc, 60);
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
124: p_effective_start_date := l_effective_start_date;
125: p_effective_end_date := l_effective_end_date;
126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: --
130: exception
131: --
132: when hr_api.validate_enabled then
143: p_elig_rslt_id := null;
144: p_effective_start_date := null;
145: p_effective_end_date := null;
146: p_object_version_number := null;
147: hr_utility.set_location(' Leaving:'||l_proc, 80);
148: --
149: when others then
150: --
151: -- A validation or unexpected error has occured
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: --
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_ELIG_RSLT;
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_ELIG_RSLT;
190: --
191: hr_utility.set_location(l_proc, 20);
192: --
193: -- Process Logic
194: --
195: l_object_version_number := p_object_version_number;
264: -- End of API User Hook for the after hook of update_ELIG_RSLT
265: --
266: end;
267: --
268: hr_utility.set_location(l_proc, 60);
269: --
270: -- When in validation only mode raise the Validate_Enabled exception
271: --
272: if p_validate then
278: p_object_version_number := l_object_version_number;
279: p_effective_start_date := l_effective_start_date;
280: p_effective_end_date := l_effective_end_date;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: --
284: exception
285: --
286: when hr_api.validate_enabled then
293: -- Only set output warning arguments
294: -- (Any key or derived arguments must be set to null
295: -- when validation only mode is being used.)
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 80);
298: --
299: when others then
300: --
301: -- A validation or unexpected error has occured
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Issue a savepoint if operating in validation only mode
333: --
334: savepoint delete_ELIG_RSLT;
332: -- Issue a savepoint if operating in validation only mode
333: --
334: savepoint delete_ELIG_RSLT;
335: --
336: hr_utility.set_location(l_proc, 20);
337: --
338: -- Process Logic
339: --
340: l_object_version_number := p_object_version_number;
395: -- End of API User Hook for the after hook of delete_ELIG_RSLT
396: --
397: end;
398: --
399: hr_utility.set_location(l_proc, 60);
400: --
401: -- When in validation only mode raise the Validate_Enabled exception
402: --
403: if p_validate then
403: if p_validate then
404: raise hr_api.validate_enabled;
405: end if;
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 70);
408: --
409: exception
410: --
411: when hr_api.validate_enabled then
453: l_validation_end_date date;
454: --
455: begin
456: --
457: hr_utility.set_location('Entering:'|| l_proc, 10);
458: --
459: ben_ber_shd.lck
460: (
461: p_elig_rslt_id => p_elig_rslt_id
465: ,p_effective_date => p_effective_date
466: ,p_datetrack_mode => p_datetrack_mode
467: );
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 70);
470: --
471: end lck;
472: --
473: end ben_ELIG_RSLT_api;