31: --
32: -- Other variables
33: l_proc varchar2(72) := g_package ||'create_workbench_item';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_workbench_item_swi;
82: -- messages of any type exist in the Multiple Message List.
83: -- Also disable Multiple Message Detection.
84: --
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
90: --
97: -- Reset IN OUT parameters and set OUT parameters
98: --
99: p_object_version_number := null;
100: p_return_status := hr_multi_message.get_return_status_disable;
101: hr_utility.set_location(' Leaving:' || l_proc, 30);
102: when others then
103: --
104: -- When Multiple Message Detection is enabled catch
105: -- any Application specific or other unexpected
108: -- error.
109: --
110: rollback to create_workbench_item_swi;
111: if hr_multi_message.unexpected_error_add(l_proc) then
112: hr_utility.set_location(' Leaving:' || l_proc,40);
113: raise;
114: end if;
115: --
116: -- Reset IN OUT and set OUT parameters
116: -- Reset IN OUT and set OUT parameters
117: --
118: p_object_version_number := null;
119: p_return_status := hr_multi_message.get_return_status_disable;
120: hr_utility.set_location(' Leaving:' || l_proc,50);
121: end create_workbench_item;
122: -- ----------------------------------------------------------------------------
123: -- |-------------------------< delete_workbench_item >------------------------|
124: -- ----------------------------------------------------------------------------
136: --
137: -- Other variables
138: l_proc varchar2(72) := g_package ||'delete_workbench_item';
139: Begin
140: hr_utility.set_location(' Entering:' || l_proc,10);
141: --
142: -- Issue a savepoint
143: --
144: savepoint delete_workbench_item_swi;
178: -- messages of any type exist in the Multiple Message List.
179: -- Also disable Multiple Message Detection.
180: --
181: p_return_status := hr_multi_message.get_return_status_disable;
182: hr_utility.set_location(' Leaving:' || l_proc,20);
183: --
184: exception
185: when hr_multi_message.error_message_exist then
186: --
192: --
193: -- Reset IN OUT parameters and set OUT parameters
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc, 30);
197: when others then
198: --
199: -- When Multiple Message Detection is enabled catch
200: -- any Application specific or other unexpected
203: -- error.
204: --
205: rollback to delete_workbench_item_swi;
206: if hr_multi_message.unexpected_error_add(l_proc) then
207: hr_utility.set_location(' Leaving:' || l_proc,40);
208: raise;
209: end if;
210: --
211: -- Reset IN OUT and set OUT parameters
210: --
211: -- Reset IN OUT and set OUT parameters
212: --
213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc,50);
215: end delete_workbench_item;
216: -- ----------------------------------------------------------------------------
217: -- |-------------------------< update_workbench_item >------------------------|
218: -- ----------------------------------------------------------------------------
240: --
241: -- Other variables
242: l_proc varchar2(72) := g_package ||'update_workbench_item';
243: Begin
244: hr_utility.set_location(' Entering:' || l_proc,10);
245: --
246: -- Issue a savepoint
247: --
248: savepoint update_workbench_item_swi;
292: -- messages of any type exist in the Multiple Message List.
293: -- Also disable Multiple Message Detection.
294: --
295: p_return_status := hr_multi_message.get_return_status_disable;
296: hr_utility.set_location(' Leaving:' || l_proc,20);
297: --
298: exception
299: when hr_multi_message.error_message_exist then
300: --
307: -- Reset IN OUT parameters and set OUT parameters
308: --
309: p_object_version_number := l_object_version_number;
310: p_return_status := hr_multi_message.get_return_status_disable;
311: hr_utility.set_location(' Leaving:' || l_proc, 30);
312: when others then
313: --
314: -- When Multiple Message Detection is enabled catch
315: -- any Application specific or other unexpected
318: -- error.
319: --
320: rollback to update_workbench_item_swi;
321: if hr_multi_message.unexpected_error_add(l_proc) then
322: hr_utility.set_location(' Leaving:' || l_proc,40);
323: raise;
324: end if;
325: --
326: -- Reset IN OUT and set OUT parameters
326: -- Reset IN OUT and set OUT parameters
327: --
328: p_object_version_number := l_object_version_number;
329: p_return_status := hr_multi_message.get_return_status_disable;
330: hr_utility.set_location(' Leaving:' || l_proc,50);
331: end update_workbench_item;
332: end per_ri_workbench_item_swi;