DBA Data[Home] [Help]

APPS.OTA_ACTIVITY_CATEGORY_SWI dependencies on HR_UTILITY

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

52: l_activity_version_id number;
53: l_category_usage_id number;
54: l_proc varchar2(72) := g_package ||'create_act_cat_inclusion';
55: Begin
56: hr_utility.set_location(' Entering:' || l_proc,10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_act_cat_inclusion_swi;

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

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

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

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

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

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

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

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

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

181: --
182: -- Other variables
183: l_proc varchar2(72) := g_package ||'delete_act_cat_inclusion';
184: Begin
185: hr_utility.set_location(' Entering:' || l_proc,10);
186: --
187: -- Issue a savepoint
188: --
189: savepoint delete_act_cat_inclusion_swi;

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

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

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

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

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

249: -- error.
250: --
251: rollback to delete_act_cat_inclusion_swi;
252: if hr_multi_message.unexpected_error_add(l_proc) then
253: hr_utility.set_location(' Leaving:' || l_proc,40);
254: raise;
255: end if;
256: --
257: -- Reset IN OUT and set OUT parameters

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

256: --
257: -- Reset IN OUT and set OUT parameters
258: --
259: p_return_status := hr_multi_message.get_return_status_disable;
260: hr_utility.set_location(' Leaving:' || l_proc,50);
261: end delete_act_cat_inclusion;
262: -- ----------------------------------------------------------------------------
263: -- |-----------------------< update_act_cat_inclusion >-----------------------|
264: -- ----------------------------------------------------------------------------

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

305: --
306: -- Other variables
307: l_proc varchar2(72) := g_package ||'update_act_cat_inclusion';
308: Begin
309: hr_utility.set_location(' Entering:' || l_proc,10);
310: --
311: -- Issue a savepoint
312: --
313: savepoint update_act_cat_inclusion_swi;

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

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

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

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

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

402: -- error.
403: --
404: rollback to update_act_cat_inclusion_swi;
405: if hr_multi_message.unexpected_error_add(l_proc) then
406: hr_utility.set_location(' Leaving:' || l_proc,40);
407: raise;
408: end if;
409: --
410: -- Reset IN OUT and set OUT parameters

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

410: -- Reset IN OUT and set OUT parameters
411: --
412: p_object_version_number := l_object_version_number;
413: p_return_status := hr_multi_message.get_return_status_disable;
414: hr_utility.set_location(' Leaving:' || l_proc,50);
415: end update_act_cat_inclusion;
416: -- ----------------------------------------------------------------------------
417: -- |------------------------< validate_delete_aci >-----------------------|
418: -- ----------------------------------------------------------------------------

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

426: --
427: -- Other variables
428: l_proc varchar2(72) := g_package ||'validate_delete_aci';
429: Begin
430: hr_utility.set_location(' Entering:' || l_proc,10);
431: --
432: -- Issue a savepoint
433: --
434: savepoint validate_delete_aci_swi;

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

448:
449: --
450: --
451: p_return_status := hr_multi_message.get_return_status_disable;
452: hr_utility.set_location(' Leaving:' || l_proc,20);
453: --
454: exception
455: when hr_multi_message.error_message_exist then
456: --

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

462: --
463: -- Reset IN OUT parameters and set OUT parameters
464: --
465: p_return_status := hr_multi_message.get_return_status_disable;
466: hr_utility.set_location(' Leaving:' || l_proc, 30);
467: when others then
468: --
469: -- When Multiple Message Detection is enabled catch
470: -- any Application specific or other unexpected

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

473: -- error.
474: --
475: rollback to validate_delete_aci_swi;
476: if hr_multi_message.unexpected_error_add(l_proc) then
477: hr_utility.set_location(' Leaving:' || l_proc,40);
478: raise;
479: end if;
480: --
481: -- Reset IN OUT and set OUT parameters

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

480: --
481: -- Reset IN OUT and set OUT parameters
482: --
483: p_return_status := hr_multi_message.get_return_status_disable;
484: hr_utility.set_location(' Leaving:' || l_proc,50);
485: end validate_delete_aci;
486:
487: end ota_activity_category_swi;