DBA Data[Home] [Help]

APPS.OTA_CHAT_USER_SWI dependencies on HR_UTILITY

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

30: l_person_id number;
31: l_contact_id number;
32: l_proc varchar2(72) := g_package ||'create_chat_user';
33: Begin
34: hr_utility.set_location(' Entering:' || l_proc,10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint create_chat_user_swi;

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

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

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

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

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

108: -- error.
109: --
110: rollback to create_chat_user_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

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

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_chat_user;
122: --
123: -- ----------------------------------------------------------------------------
124: -- |---------------------------< update_chat_user >---------------------------|

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

147: l_object_version_number number := p_object_version_number;
148: l_effective_date date := trunc(p_effective_date);
149: l_proc varchar2(72) := g_package ||'update_chat_user';
150: Begin
151: hr_utility.set_location(' Entering:' || l_proc,10);
152: --
153: -- Issue a savepoint
154: --
155: savepoint update_chat_user_swi;

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

191: -- messages of any type exist in the Multiple Message List.
192: -- Also disable Multiple Message Detection.
193: --
194: p_return_status := hr_multi_message.get_return_status_disable;
195: hr_utility.set_location(' Leaving:' || l_proc,20);
196: --
197: exception
198: when hr_multi_message.error_message_exist then
199: --

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

206: -- Reset IN OUT parameters and set OUT parameters
207: --
208: p_object_version_number := l_object_version_number;
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc, 30);
211: when others then
212: --
213: -- When Multiple Message Detection is enabled catch
214: -- any Application specific or other unexpected

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

217: -- error.
218: --
219: rollback to update_chat_user_swi;
220: if hr_multi_message.unexpected_error_add(l_proc) then
221: hr_utility.set_location(' Leaving:' || l_proc,40);
222: raise;
223: end if;
224: --
225: -- Reset IN OUT and set OUT parameters

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

225: -- Reset IN OUT and set OUT parameters
226: --
227: p_object_version_number := l_object_version_number;
228: p_return_status := hr_multi_message.get_return_status_disable;
229: hr_utility.set_location(' Leaving:' || l_proc,50);
230: end update_chat_user;
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------< delete_chat_user >---------------------------|
233: -- ----------------------------------------------------------------------------

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

247: --
248: -- Other variables
249: l_proc varchar2(72) := g_package ||'delete_chat_user';
250: Begin
251: hr_utility.set_location(' Entering:' || l_proc,10);
252: --
253: -- Issue a savepoint
254: --
255: savepoint delete_chat_user_swi;

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

291: -- messages of any type exist in the Multiple Message List.
292: -- Also disable Multiple Message Detection.
293: --
294: p_return_status := hr_multi_message.get_return_status_disable;
295: hr_utility.set_location(' Leaving:' || l_proc,20);
296: --
297: exception
298: when hr_multi_message.error_message_exist then
299: --

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

305: --
306: -- Reset IN OUT parameters and set OUT parameters
307: --
308: p_return_status := hr_multi_message.get_return_status_disable;
309: hr_utility.set_location(' Leaving:' || l_proc, 30);
310: when others then
311: --
312: -- When Multiple Message Detection is enabled catch
313: -- any Application specific or other unexpected

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

316: -- error.
317: --
318: rollback to delete_chat_user_swi;
319: if hr_multi_message.unexpected_error_add(l_proc) then
320: hr_utility.set_location(' Leaving:' || l_proc,40);
321: raise;
322: end if;
323: --
324: -- Reset IN OUT and set OUT parameters

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

323: --
324: -- Reset IN OUT and set OUT parameters
325: --
326: p_return_status := hr_multi_message.get_return_status_disable;
327: hr_utility.set_location(' Leaving:' || l_proc,50);
328: end delete_chat_user;
329: end ota_chat_user_swi;