DBA Data[Home] [Help]

APPS.OTA_CHAT_SWI dependencies on HR_UTILITY

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

33: -- Other variables
34: l_proc varchar2(72) := g_package ||'create_chat';
35: l_chat_id number;
36: Begin
37: hr_utility.set_location(' Entering:' || l_proc,10);
38: --
39: -- Issue a savepoint
40: --
41: savepoint create_chat_swi;

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

86: -- messages of any type exist in the Multiple Message List.
87: -- Also disable Multiple Message Detection.
88: --
89: p_return_status := hr_multi_message.get_return_status_disable;
90: hr_utility.set_location(' Leaving:' || l_proc,20);
91: --
92: exception
93: when hr_multi_message.error_message_exist then
94: --

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

102: --
103: l_chat_id := null;
104: p_object_version_number := null;
105: p_return_status := hr_multi_message.get_return_status_disable;
106: hr_utility.set_location(' Leaving:' || l_proc, 30);
107: when others then
108: --
109: -- When Multiple Message Detection is enabled catch
110: -- any Application specific or other unexpected

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

113: -- error.
114: --
115: rollback to create_chat_swi;
116: if hr_multi_message.unexpected_error_add(l_proc) then
117: hr_utility.set_location(' Leaving:' || l_proc,40);
118: raise;
119: end if;
120: --
121: -- Reset IN OUT and set OUT parameters

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

122: --
123: l_chat_id := null;
124: p_object_version_number := null;
125: p_return_status := hr_multi_message.get_return_status_disable;
126: hr_utility.set_location(' Leaving:' || l_proc,50);
127: end create_chat;
128: -- ----------------------------------------------------------------------------
129: -- |------------------------------< update_chat >-----------------------------|
130: -- ----------------------------------------------------------------------------

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

153: --
154: -- Other variables
155: l_proc varchar2(72) := g_package ||'update_chat';
156: Begin
157: hr_utility.set_location(' Entering:' || l_proc,10);
158: --
159: -- Issue a savepoint
160: --
161: savepoint update_chat_swi;

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

206: -- messages of any type exist in the Multiple Message List.
207: -- Also disable Multiple Message Detection.
208: --
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc,20);
211: --
212: exception
213: when hr_multi_message.error_message_exist then
214: --

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

221: -- Reset IN OUT parameters and set OUT parameters
222: --
223: p_object_version_number := l_object_version_number;
224: p_return_status := hr_multi_message.get_return_status_disable;
225: hr_utility.set_location(' Leaving:' || l_proc, 30);
226: when others then
227: --
228: -- When Multiple Message Detection is enabled catch
229: -- any Application specific or other unexpected

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

232: -- error.
233: --
234: rollback to update_chat_swi;
235: if hr_multi_message.unexpected_error_add(l_proc) then
236: hr_utility.set_location(' Leaving:' || l_proc,40);
237: raise;
238: end if;
239: --
240: -- Reset IN OUT and set OUT parameters

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

240: -- Reset IN OUT and set OUT parameters
241: --
242: p_object_version_number := l_object_version_number;
243: p_return_status := hr_multi_message.get_return_status_disable;
244: hr_utility.set_location(' Leaving:' || l_proc,50);
245: end update_chat;
246: -- ----------------------------------------------------------------------------
247: -- |------------------------------< delete_chat >-----------------------------|
248: -- ----------------------------------------------------------------------------

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

260: --
261: -- Other variables
262: l_proc varchar2(72) := g_package ||'delete_chat';
263: Begin
264: hr_utility.set_location(' Entering:' || l_proc,10);
265: --
266: -- Issue a savepoint
267: --
268: savepoint delete_chat_swi;

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

302: -- messages of any type exist in the Multiple Message List.
303: -- Also disable Multiple Message Detection.
304: --
305: p_return_status := hr_multi_message.get_return_status_disable;
306: hr_utility.set_location(' Leaving:' || l_proc,20);
307: --
308: exception
309: when hr_multi_message.error_message_exist then
310: --

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

316: --
317: -- Reset IN OUT parameters and set OUT parameters
318: --
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc, 30);
321: when others then
322: --
323: -- When Multiple Message Detection is enabled catch
324: -- any Application specific or other unexpected

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

327: -- error.
328: --
329: rollback to delete_chat_swi;
330: if hr_multi_message.unexpected_error_add(l_proc) then
331: hr_utility.set_location(' Leaving:' || l_proc,40);
332: raise;
333: end if;
334: --
335: -- Reset IN OUT and set OUT parameters

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

334: --
335: -- Reset IN OUT and set OUT parameters
336: --
337: p_return_status := hr_multi_message.get_return_status_disable;
338: hr_utility.set_location(' Leaving:' || l_proc,50);
339: end delete_chat;
340: end ota_chat_swi;