31: l_object_type varchar2(30);
32: l_chat_id number;
33: l_proc varchar2(72) := g_package ||'create_chat_obj_inclusion';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_chat_obj_inclusion_swi;
84: -- messages of any type exist in the Multiple Message List.
85: -- Also disable Multiple Message Detection.
86: --
87: p_return_status := hr_multi_message.get_return_status_disable;
88: hr_utility.set_location(' Leaving:' || l_proc,20);
89: --
90: exception
91: when hr_multi_message.error_message_exist then
92: --
99: -- Reset IN OUT parameters and set OUT parameters
100: --
101: p_object_version_number := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc, 30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
107: -- any Application specific or other unexpected
110: -- error.
111: --
112: rollback to create_chat_obj_inclusion_swi;
113: if hr_multi_message.unexpected_error_add(l_proc) then
114: hr_utility.set_location(' Leaving:' || l_proc,40);
115: raise;
116: end if;
117: --
118: -- Reset IN OUT and set OUT parameters
118: -- Reset IN OUT and set OUT parameters
119: --
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,50);
123: end create_chat_obj_inclusion;
124: --
125: -- ----------------------------------------------------------------------------
126: -- |-----------------------< update_chat_obj_inclusion >----------------------|
152:
153:
154: l_proc varchar2(72) := g_package ||'update_chat_obj_inclusion';
155: Begin
156: hr_utility.set_location(' Entering:' || l_proc,10);
157: --
158: -- Issue a savepoint
159: --
160: savepoint create_chat_obj_inclusion_swi;
199: -- messages of any type exist in the Multiple Message List.
200: -- Also disable Multiple Message Detection.
201: --
202: p_return_status := hr_multi_message.get_return_status_disable;
203: hr_utility.set_location(' Leaving:' || l_proc,20);
204: --
205: exception
206: when hr_multi_message.error_message_exist then
207: --
214: -- Reset IN OUT parameters and set OUT parameters
215: --
216: p_object_version_number := l_object_version_number;
217: p_return_status := hr_multi_message.get_return_status_disable;
218: hr_utility.set_location(' Leaving:' || l_proc, 30);
219: when others then
220: --
221: -- When Multiple Message Detection is enabled catch
222: -- any Application specific or other unexpected
225: -- error.
226: --
227: rollback to update_chat_obj_inclusion_swi;
228: if hr_multi_message.unexpected_error_add(l_proc) then
229: hr_utility.set_location(' Leaving:' || l_proc,40);
230: raise;
231: end if;
232: --
233: -- Reset IN OUT and set OUT parameters
233: -- Reset IN OUT and set OUT parameters
234: --
235: p_object_version_number := l_object_version_number;
236: p_return_status := hr_multi_message.get_return_status_disable;
237: hr_utility.set_location(' Leaving:' || l_proc,50);
238: end update_chat_obj_inclusion;
239:
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------< delete_chat_obj_inclusion >----------------------|
256: --
257: -- Other variables
258: l_proc varchar2(72) := g_package ||'delete_chat_obj_inclusion';
259: Begin
260: hr_utility.set_location(' Entering:' || l_proc,10);
261: --
262: -- Issue a savepoint
263: --
264: savepoint delete_chat_obj_inclusion_swi;
300: -- messages of any type exist in the Multiple Message List.
301: -- Also disable Multiple Message Detection.
302: --
303: p_return_status := hr_multi_message.get_return_status_disable;
304: hr_utility.set_location(' Leaving:' || l_proc,20);
305: --
306: exception
307: when hr_multi_message.error_message_exist then
308: --
314: --
315: -- Reset IN OUT parameters and set OUT parameters
316: --
317: p_return_status := hr_multi_message.get_return_status_disable;
318: hr_utility.set_location(' Leaving:' || l_proc, 30);
319: when others then
320: --
321: -- When Multiple Message Detection is enabled catch
322: -- any Application specific or other unexpected
325: -- error.
326: --
327: rollback to delete_chat_obj_inclusion_swi;
328: if hr_multi_message.unexpected_error_add(l_proc) then
329: hr_utility.set_location(' Leaving:' || l_proc,40);
330: raise;
331: end if;
332: --
333: -- Reset IN OUT and set OUT parameters
332: --
333: -- Reset IN OUT and set OUT parameters
334: --
335: p_return_status := hr_multi_message.get_return_status_disable;
336: hr_utility.set_location(' Leaving:' || l_proc,50);
337: end delete_chat_obj_inclusion;
338: end ota_chat_obj_inclusion_swi;