[Home] [Help]
50: --
51: lv_object_version_number number := p_object_version_number ;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 5);
55: --
56: -- Issue a savepoint.
57: --
58: savepoint update_apl_details;
61: --
62: l_object_version_number := p_object_version_number;
63: l_projected_hire_date := trunc(p_projected_hire_date);
64: l_effective_date := trunc(p_effective_date);
65: hr_utility.set_location(l_proc, 10);
66: --
67: begin
68: --
69: -- Start of the before process hook of update_apl_details
189: -- End of of the before process hook for update_apl_details
190: --
191: end;
192: --
193: hr_utility.set_location(l_proc, 15);
194: --
195: -- When in validation only mode raise the Validate_Enabled exception
196: --
197: if p_validate then
201: -- Set all output arguments
202: --
203: p_object_version_number := l_object_version_number;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 20);
206: --
207: exception
208: --
209: when hr_api.validate_enabled then
216: -- Only set output warning arguments
217: -- (Any key or derived arguments must be set to null
218: -- when validation only mode is being used.)
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 25);
221: --
222: when others then
223: --
224: -- A validation or unexpected error has occurred
228: p_object_version_number := lv_object_version_number ;
229:
230: ROLLBACK TO update_apl_details;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 30);
233: raise;
234: --
235: -- End of fix.
236: --