DBA Data[Home] [Help]

APPS.OTA_CHAT_OBJ_INCLUSION_SWI dependencies on HR_UTILITY

Line 35: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 88: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 103: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 114: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 122: hr_utility.set_location(' Leaving:' || l_proc,50);

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 >----------------------|

Line 156: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 203: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 218: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 229: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 237: hr_utility.set_location(' Leaving:' || l_proc,50);

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 >----------------------|

Line 260: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 304: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 318: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 329: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 336: hr_utility.set_location(' Leaving:' || l_proc,50);

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;