31:
32: l_mode varchar2(1);
33:
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint CREATE_OPEN_FC_ENROLLMENT;
105: if p_validate then
106: raise hr_api.validate_enabled;
107: end if;
108:
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
110: exception
111: when hr_api.validate_enabled then
112: --
113: -- As the Validate_Enabled exception has been raised
120: -- when validation only mode is being used.)
121: --
122: p_enrollment_id := null;
123: p_object_version_number := null;
124: hr_utility.set_location(' Leaving:'||l_proc, 80);
125: when others then
126: --
127: -- A validation or unexpected error has occured
128: --
128: --
129: rollback to CREATE_OPEN_FC_ENROLLMENT;
130: p_enrollment_id := null;
131: p_object_version_number := null;
132: hr_utility.set_location(' Leaving:'||l_proc, 90);
133: raise;
134: end create_open_fc_enrollment;
135: -- ----------------------------------------------------------------------------
136: -- |-------------------------< UPDATE_OPEN_FC_ENROLLMENT >-------------------------|
156:
157: l_mode varchar2(1);
158:
159: begin
160: hr_utility.set_location('Entering:'|| l_proc, 10);
161: --
162: -- Issue a savepoint
163: --
164: savepoint UPDATE_OPEN_FC_ENROLLMENT;
230: -- Set all output arguments
231: --
232: p_object_version_number := l_object_version_number;
233:
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: exception
236: when hr_api.validate_enabled then
237: --
238: -- As the Validate_Enabled exception has been raised
240: --
241: rollback to UPDATE_OPEN_FC_ENROLLMENT;
242: --
243: p_object_version_number := null;
244: hr_utility.set_location(' Leaving:'||l_proc, 80);
245: when others then
246: --
247: -- A validation or unexpected error has occured
248: --
247: -- A validation or unexpected error has occured
248: --
249: rollback to UPDATE_OPEN_FC_ENROLLMENT;
250: p_object_version_number := l_object_version_number;
251: hr_utility.set_location(' Leaving:'||l_proc, 90);
252: raise;
253: end update_open_fc_enrollment;
254: --
255: -- ----------------------------------------------------------------------------
267: l_proc varchar2(72) := g_package||' delete_open_fc_enrollment';
268: --
269: --
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: -- Issue a savepoint
274: --
275: savepoint DELETE_OPEN_FC_ENROLLMENT ;
324: --
325: -- Set all output arguments
326: --
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 170);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised
337: -- Only set output warning arguments
338: -- (Any key or derived arguments must be set to null
339: -- when validation only mode is being used.)
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 180);
342: when others then
343: --
344: -- A validation or unexpected error has occured
345: --
343: --
344: -- A validation or unexpected error has occured
345: --
346: rollback to DELETE_OPEN_FC_ENROLLMENT ;
347: hr_utility.set_location(' Leaving:'||l_proc, 190);
348: raise;
349: end delete_open_fc_enrollment;
350: --
351: end OTA_OPEN_FC_ENROLLMENT_API;