DBA Data[Home] [Help]

APPS.OTA_OFFERING_SWI dependencies on HR_UTILITY

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

74: -- Other variables
75: l_offering_id number;
76: l_proc varchar2(72) := g_package ||'create_offering';
77: Begin
78: hr_utility.set_location(' Entering:' || l_proc,10);
79: --
80: -- Issue a savepoint
81: --
82: savepoint create_offering_swi;

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

167: -- messages of any type exist in the Multiple Message List.
168: -- Also disable Multiple Message Detection.
169: --
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then
175: --

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

182: -- Reset IN OUT parameters and set OUT parameters
183: --
184: p_object_version_number := null;
185: p_return_status := hr_multi_message.get_return_status_disable;
186: hr_utility.set_location(' Leaving:' || l_proc, 30);
187: when others then
188: --
189: -- When Multiple Message Detection is enabled catch
190: -- any Application specific or other unexpected

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

193: -- error.
194: --
195: rollback to create_offering_swi;
196: if hr_multi_message.unexpected_error_add(l_proc) then
197: hr_utility.set_location(' Leaving:' || l_proc,40);
198: raise;
199: end if;
200: --
201: -- Reset IN OUT and set OUT parameters

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

201: -- Reset IN OUT and set OUT parameters
202: --
203: p_object_version_number := null;
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc,50);
206: end create_offering;
207: -- ----------------------------------------------------------------------------
208: -- |----------------------------< delete_offering >---------------------------|
209: -- ----------------------------------------------------------------------------

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

221: --
222: -- Other variables
223: l_proc varchar2(72) := g_package ||'delete_offering';
224: Begin
225: hr_utility.set_location(' Entering:' || l_proc,10);
226: --
227: -- Issue a savepoint
228: --
229: savepoint delete_offering_swi;

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

263: -- messages of any type exist in the Multiple Message List.
264: -- Also disable Multiple Message Detection.
265: --
266: p_return_status := hr_multi_message.get_return_status_disable;
267: hr_utility.set_location(' Leaving:' || l_proc,20);
268: --
269: exception
270: when hr_multi_message.error_message_exist then
271: --

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

277: --
278: -- Reset IN OUT parameters and set OUT parameters
279: --
280: p_return_status := hr_multi_message.get_return_status_disable;
281: hr_utility.set_location(' Leaving:' || l_proc, 30);
282: when others then
283: --
284: -- When Multiple Message Detection is enabled catch
285: -- any Application specific or other unexpected

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

288: -- error.
289: --
290: rollback to delete_offering_swi;
291: if hr_multi_message.unexpected_error_add(l_proc) then
292: hr_utility.set_location(' Leaving:' || l_proc,40);
293: raise;
294: end if;
295: --
296: -- Reset IN OUT and set OUT parameters

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

295: --
296: -- Reset IN OUT and set OUT parameters
297: --
298: p_return_status := hr_multi_message.get_return_status_disable;
299: hr_utility.set_location(' Leaving:' || l_proc,50);
300: end delete_offering;
301: -- ----------------------------------------------------------------------------
302: -- |----------------------------< update_offering >---------------------------|
303: -- ----------------------------------------------------------------------------

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

367: --
368: -- Other variables
369: l_proc varchar2(72) := g_package ||'update_offering';
370: Begin
371: hr_utility.set_location(' Entering:' || l_proc,10);
372: --
373: -- Issue a savepoint
374: --
375: savepoint update_offering_swi;

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

460: -- messages of any type exist in the Multiple Message List.
461: -- Also disable Multiple Message Detection.
462: --
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,20);
465: --
466: exception
467: when hr_multi_message.error_message_exist then
468: --

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

475: -- Reset IN OUT parameters and set OUT parameters
476: --
477: p_object_version_number := l_object_version_number;
478: p_return_status := hr_multi_message.get_return_status_disable;
479: hr_utility.set_location(' Leaving:' || l_proc, 30);
480: when others then
481: --
482: -- When Multiple Message Detection is enabled catch
483: -- any Application specific or other unexpected

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

486: -- error.
487: --
488: rollback to update_offering_swi;
489: if hr_multi_message.unexpected_error_add(l_proc) then
490: hr_utility.set_location(' Leaving:' || l_proc,40);
491: raise;
492: end if;
493: --
494: -- Reset IN OUT and set OUT parameters

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

494: -- Reset IN OUT and set OUT parameters
495: --
496: p_object_version_number := l_object_version_number;
497: p_return_status := hr_multi_message.get_return_status_disable;
498: hr_utility.set_location(' Leaving:' || l_proc,50);
499: end update_offering;
500: end ota_offering_swi;