[Home] [Help]
114: hr_utility.set_location(l_proc, 6);
115: --
116: -- Check that p_spinal_point_id is not null as it is used in the cursor.
117: --
118: hr_api.mandatory_arg_error
119: (p_api_name => l_proc,
120: p_argument => 'spinal_point_id',
121: p_argument_value => p_spinal_point_id);
122: --
160: --
161: -- When in validation only mode raise the Validate_Enabled exception
162: --
163: if p_validate then
164: raise hr_api.validate_enabled;
165: end if;
166: --
167: -- Set out parms.
168: --
172: p_effective_end_date := l_effective_end_date;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 11);
175: exception
176: when hr_api.validate_enabled then
177: --
178: -- As the Validate_Enabled exception has been raised
179: -- we must rollback to the savepoint
180: --
288: --
289: -- When in validation only mode raise the Validate_Enabled exception
290: --
291: if p_validate then
292: raise hr_api.validate_enabled;
293: end if;
294: --
295: -- Set out parms
296: --
299: p_effective_end_date := l_effective_end_date;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 11);
302: exception
303: when hr_api.validate_enabled then
304: --
305: -- As the Validate_Enabled exception has been raised
306: -- we must rollback to the savepoint
307: --
402: --
403: -- When in validation only mode raise the Validate_Enabled exception
404: --
405: if p_validate then
406: raise hr_api.validate_enabled;
407: end if;
408: --
409: p_object_version_number := l_object_version_number;
410: p_effective_start_date := l_effective_start_date;
411: p_effective_end_date := l_effective_end_date;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 11);
414: exception
415: when hr_api.validate_enabled then
416: --
417: -- As the Validate_Enabled exception has been raised
418: -- we must rollback to the savepoint
419: --