28: l_object_version_number number;
29: l_effective_date date;
30: l_end_date date;
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Issue a savepoint
35: --
36: savepoint CREATE_FORUM_THREAD;
113: p_forum_thread_id := l_forum_thread_id;
114: p_object_version_number := l_object_version_number;
115:
116:
117: hr_utility.set_location(' Leaving:'||l_proc, 70);
118: exception
119: when hr_api.validate_enabled then
120: --
121: -- As the Validate_Enabled exception has been raised
128: -- when validation only mode is being used.)
129: --
130: p_forum_thread_id := null;
131: p_object_version_number := null;
132: hr_utility.set_location(' Leaving:'||l_proc, 80);
133: when others then
134: --
135: -- A validation or unexpected error has occured
136: --
136: --
137: rollback to CREATE_FORUM_THREAD;
138: p_forum_thread_id := null;
139: p_object_version_number := null;
140: hr_utility.set_location(' Leaving:'||l_proc, 90);
141: raise;
142: end create_forum_thread;
143: --
144: --
164: l_object_version_number number := p_object_version_number;
165: l_effective_date date;
166: l_end_date date;
167: begin
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --
170: -- Issue a savepoint
171: --
172: savepoint UPDATE_FORUM_THREAD;
249: --
250: p_object_version_number := l_object_version_number;
251:
252:
253: hr_utility.set_location(' Leaving:'||l_proc, 70);
254: exception
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised
263: -- (Any key or derived arguments must be set to null
264: -- when validation only mode is being used.)
265: --
266: p_object_version_number := null;
267: hr_utility.set_location(' Leaving:'||l_proc, 80);
268: when others then
269: --
270: -- A validation or unexpected error has occured
271: --
270: -- A validation or unexpected error has occured
271: --
272: rollback to UPDATE_FORUM_THREAD;
273: p_object_version_number := null;
274: hr_utility.set_location(' Leaving:'||l_proc, 90);
275: raise;
276: end update_forum_thread;
277: -- ----------------------------------------------------------------------------
278: -- |-------------------------< DELETE_FORUM_THREAD > --------------------------|
300: v_object_version_number number;
301: --
302: --
303: begin
304: hr_utility.set_location('Entering:'|| l_proc, 10);
305: --
306: -- Issue a savepoint
307: --
308: savepoint DELETE_FORUM_THREAD;
378: --
379: -- Set all output arguments
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 170);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
391: -- Only set output warning arguments
392: -- (Any key or derived arguments must be set to null
393: -- when validation only mode is being used.)
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 180);
396: when others then
397: --
398: -- A validation or unexpected error has occured
399: --
397: --
398: -- A validation or unexpected error has occured
399: --
400: rollback to DELETE_FORUM_THREAD;
401: hr_utility.set_location(' Leaving:'||l_proc, 190);
402: raise;
403: end delete_forum_thread;
404: --
405: end ota_forum_thread_api;