29: l_object_version_number number;
30: l_effective_date date;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_pvt_frm_thread_user;
116: --
117: --
118: p_object_version_number := l_object_version_number;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: exception
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
130: -- (Any key or derived arguments must be set to null
131: -- when validation only mode is being used.)
132: --
133: p_object_version_number := null;
134: hr_utility.set_location(' Leaving:'||l_proc, 80);
135: when others then
136: --
137: -- A validation or unexpected error has occured
138: --
137: -- A validation or unexpected error has occured
138: --
139: rollback to create_pvt_frm_thread_user;
140: p_object_version_number := null;
141: hr_utility.set_location(' Leaving:'||l_proc, 90);
142: raise;
143: end create_pvt_frm_thread_user ;
144: --
145: -- ----------------------------------------------------------------------------
166: l_object_version_number number:= p_object_version_number;
167: l_effective_date date;
168:
169: begin
170: hr_utility.set_location('Entering:'|| l_proc, 10);
171: --
172: -- Issue a savepoint
173: --
174: savepoint update_pvt_frm_thread_user;
253: --
254: --
255: p_object_version_number := l_object_version_number;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
267: -- (Any key or derived arguments must be set to null
268: -- when validation only mode is being used.)
269: --
270: p_object_version_number := null;
271: hr_utility.set_location(' Leaving:'||l_proc, 80);
272: when others then
273: --
274: -- A validation or unexpected error has occured
275: --
274: -- A validation or unexpected error has occured
275: --
276: rollback to update_pvt_frm_thread_user;
277: p_object_version_number := null;
278: hr_utility.set_location(' Leaving:'||l_proc, 90);
279: raise;
280: end update_pvt_frm_thread_user ;
281: --
282: -- ----------------------------------------------------------------------------
297: --
298: l_proc varchar2(72) := g_package||' delete_pvt_frm_thread_user ';
299: --
300: begin
301: hr_utility.set_location('Entering:'|| l_proc, 10);
302: --
303: -- Issue a savepoint
304: --
305: savepoint delete_pvt_frm_thread_user ;
364: --
365: -- Set all output arguments
366: --
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 170);
369: exception
370: when hr_api.validate_enabled then
371: --
372: -- As the Validate_Enabled exception has been raised
377: -- Only set output warning arguments
378: -- (Any key or derived arguments must be set to null
379: -- when validation only mode is being used.)
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 180);
382: when others then
383: --
384: -- A validation or unexpected error has occured
385: --
383: --
384: -- A validation or unexpected error has occured
385: --
386: rollback to delete_pvt_frm_thread_user ;
387: hr_utility.set_location(' Leaving:'||l_proc, 190);
388: raise;
389: end delete_pvt_frm_thread_user;
390: --
391: end OTA_PVT_FRM_THREAD_USERS_API;