DBA Data[Home] [Help]

APPS.OTA_ANNOUNCEMENT_SWI dependencies on HR_UTILITY

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

51: -- Other variables
52: l_announcement_id number;
53: l_proc varchar2(72) := g_package ||'create_announcement';
54: Begin
55: hr_utility.set_location(' Entering:' || l_proc,10);
56: --
57: -- Issue a savepoint
58: --
59: savepoint create_announcement_swi;

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

124: -- messages of any type exist in the Multiple Message List.
125: -- Also disable Multiple Message Detection.
126: --
127: p_return_status := hr_multi_message.get_return_status_disable;
128: hr_utility.set_location(' Leaving:' || l_proc,20);
129: --
130: exception
131: when hr_multi_message.error_message_exist then
132: --

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

139: -- Reset IN OUT parameters and set OUT parameters
140: --
141: p_object_version_number := null;
142: p_return_status := hr_multi_message.get_return_status_disable;
143: hr_utility.set_location(' Leaving:' || l_proc, 30);
144: when others then
145: --
146: -- When Multiple Message Detection is enabled catch
147: -- any Application specific or other unexpected

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

150: -- error.
151: --
152: rollback to create_announcement_swi;
153: if hr_multi_message.unexpected_error_add(l_proc) then
154: hr_utility.set_location(' Leaving:' || l_proc,40);
155: raise;
156: end if;
157: --
158: -- Reset IN OUT and set OUT parameters

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

158: -- Reset IN OUT and set OUT parameters
159: --
160: p_object_version_number := null;
161: p_return_status := hr_multi_message.get_return_status_disable;
162: hr_utility.set_location(' Leaving:' || l_proc,50);
163: end create_announcement;
164: -- ----------------------------------------------------------------------------
165: -- |--------------------------< delete_announcement >-------------------------|
166: -- ----------------------------------------------------------------------------

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

178: --
179: -- Other variables
180: l_proc varchar2(72) := g_package ||'delete_announcement';
181: Begin
182: hr_utility.set_location(' Entering:' || l_proc,10);
183: --
184: -- Issue a savepoint
185: --
186: savepoint delete_announcement_swi;

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

220: -- messages of any type exist in the Multiple Message List.
221: -- Also disable Multiple Message Detection.
222: --
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,20);
225: --
226: exception
227: when hr_multi_message.error_message_exist then
228: --

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

234: --
235: -- Reset IN OUT parameters and set OUT parameters
236: --
237: p_return_status := hr_multi_message.get_return_status_disable;
238: hr_utility.set_location(' Leaving:' || l_proc, 30);
239: when others then
240: --
241: -- When Multiple Message Detection is enabled catch
242: -- any Application specific or other unexpected

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

245: -- error.
246: --
247: rollback to delete_announcement_swi;
248: if hr_multi_message.unexpected_error_add(l_proc) then
249: hr_utility.set_location(' Leaving:' || l_proc,40);
250: raise;
251: end if;
252: --
253: -- Reset IN OUT and set OUT parameters

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

252: --
253: -- Reset IN OUT and set OUT parameters
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,50);
257: end delete_announcement;
258: -- ----------------------------------------------------------------------------
259: -- |--------------------------< update_announcement >-------------------------|
260: -- ----------------------------------------------------------------------------

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

301: --
302: -- Other variables
303: l_proc varchar2(72) := g_package ||'update_announcement';
304: Begin
305: hr_utility.set_location(' Entering:' || l_proc,10);
306: --
307: -- Issue a savepoint
308: --
309: savepoint update_announcement_swi;

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

372: -- messages of any type exist in the Multiple Message List.
373: -- Also disable Multiple Message Detection.
374: --
375: p_return_status := hr_multi_message.get_return_status_disable;
376: hr_utility.set_location(' Leaving:' || l_proc,20);
377: --
378: exception
379: when hr_multi_message.error_message_exist then
380: --

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

387: -- Reset IN OUT parameters and set OUT parameters
388: --
389: p_object_version_number := l_object_version_number;
390: p_return_status := hr_multi_message.get_return_status_disable;
391: hr_utility.set_location(' Leaving:' || l_proc, 30);
392: when others then
393: --
394: -- When Multiple Message Detection is enabled catch
395: -- any Application specific or other unexpected

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

398: -- error.
399: --
400: rollback to update_announcement_swi;
401: if hr_multi_message.unexpected_error_add(l_proc) then
402: hr_utility.set_location(' Leaving:' || l_proc,40);
403: raise;
404: end if;
405: --
406: -- Reset IN OUT and set OUT parameters

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

406: -- Reset IN OUT and set OUT parameters
407: --
408: p_object_version_number := l_object_version_number;
409: p_return_status := hr_multi_message.get_return_status_disable;
410: hr_utility.set_location(' Leaving:' || l_proc,50);
411: end update_announcement;
412: end ota_announcement_swi;