22: --
23: -- Other variables
24: l_proc varchar2(72) := g_package ||'delete_vldtn_vern';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_vldtn_vern_swi;
64: -- messages of any type exist in the Multiple Message List.
65: -- Also disable Multiple Message Detection.
66: --
67: p_return_status := hr_multi_message.get_return_status_disable;
68: hr_utility.set_location(' Leaving:' || l_proc,20);
69: --
70: exception
71: when hr_multi_message.error_message_exist then
72: --
78: --
79: -- Reset IN OUT parameters and set OUT parameters
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc, 30);
83: when others then
84: --
85: -- When Multiple Message Detection is enabled catch
86: -- any Application specific or other unexpected
89: -- error.
90: --
91: rollback to delete_vldtn_vern_swi;
92: if hr_multi_message.unexpected_error_add(l_proc) then
93: hr_utility.set_location(' Leaving:' || l_proc,40);
94: raise;
95: end if;
96: --
97: -- Reset IN OUT and set OUT parameters
96: --
97: -- Reset IN OUT and set OUT parameters
98: --
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc,50);
101: end delete_vldtn_vern;
102: -- ----------------------------------------------------------------------------
103: -- |---------------------------< insert_vldtn_vern >--------------------------|
104: -- ----------------------------------------------------------------------------
132: --
133: -- Other variables
134: l_proc varchar2(72) := g_package ||'insert_vldtn_vern';
135: Begin
136: hr_utility.set_location(' Entering:' || l_proc,10);
137: --
138: -- Issue a savepoint
139: --
140: savepoint insert_vldtn_vern_swi;
193: -- messages of any type exist in the Multiple Message List.
194: -- Also disable Multiple Message Detection.
195: --
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc,20);
198: --
199: exception
200: when hr_multi_message.error_message_exist then
201: --
209: --
210: p_wrkplc_vldtn_ver_id := null;
211: p_object_version_number := null;
212: p_return_status := hr_multi_message.get_return_status_disable;
213: hr_utility.set_location(' Leaving:' || l_proc, 30);
214: when others then
215: --
216: -- When Multiple Message Detection is enabled catch
217: -- any Application specific or other unexpected
220: -- error.
221: --
222: rollback to insert_vldtn_vern_swi;
223: if hr_multi_message.unexpected_error_add(l_proc) then
224: hr_utility.set_location(' Leaving:' || l_proc,40);
225: raise;
226: end if;
227: --
228: -- Reset IN OUT and set OUT parameters
229: --
230: p_wrkplc_vldtn_ver_id := null;
231: p_object_version_number := null;
232: p_return_status := hr_multi_message.get_return_status_disable;
233: hr_utility.set_location(' Leaving:' || l_proc,50);
234: end insert_vldtn_vern;
235: -- ----------------------------------------------------------------------------
236: -- |---------------------------< update_vldtn_vern >--------------------------|
237: -- ----------------------------------------------------------------------------
266: --
267: -- Other variables
268: l_proc varchar2(72) := g_package ||'update_vldtn_vern';
269: Begin
270: hr_utility.set_location(' Entering:' || l_proc,10);
271: --
272: -- Issue a savepoint
273: --
274: savepoint update_vldtn_vern_swi;
325: -- messages of any type exist in the Multiple Message List.
326: -- Also disable Multiple Message Detection.
327: --
328: p_return_status := hr_multi_message.get_return_status_disable;
329: hr_utility.set_location(' Leaving:' || l_proc,20);
330: --
331: exception
332: when hr_multi_message.error_message_exist then
333: --
340: -- Reset IN OUT parameters and set OUT parameters
341: --
342: p_object_version_number := l_object_version_number;
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc, 30);
345: when others then
346: --
347: -- When Multiple Message Detection is enabled catch
348: -- any Application specific or other unexpected
351: -- error.
352: --
353: rollback to update_vldtn_vern_swi;
354: if hr_multi_message.unexpected_error_add(l_proc) then
355: hr_utility.set_location(' Leaving:' || l_proc,40);
356: raise;
357: end if;
358: --
359: -- Reset IN OUT and set OUT parameters
359: -- Reset IN OUT and set OUT parameters
360: --
361: p_object_version_number := l_object_version_number;
362: p_return_status := hr_multi_message.get_return_status_disable;
363: hr_utility.set_location(' Leaving:' || l_proc,50);
364: end update_vldtn_vern;
365: end pqh_de_vldver_swi;