DBA Data[Home] [Help]

APPS.PER_HIERARCHY_NODES_SWI dependencies on HR_UTILITY

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

95: --
96: -- Other variables
97: l_proc varchar2(72) := g_package ||'create_hierarchy_nodes';
98: Begin
99: hr_utility.set_location(' Entering:' || l_proc,10);
100: --
101: -- Issue a savepoint
102: --
103: savepoint create_hierarchy_nodes_swi;

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

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

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

226: --
227: p_hierarchy_node_id := null;
228: p_object_version_number := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc, 30);
231: when others then
232: --
233: -- When Multiple Message Detection is enabled catch
234: -- any Application specific or other unexpected

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

237: -- error.
238: --
239: rollback to create_hierarchy_nodes_swi;
240: if hr_multi_message.unexpected_error_add(l_proc) then
241: hr_utility.set_location(' Leaving:' || l_proc,40);
242: raise;
243: end if;
244: --
245: -- Reset IN OUT and set OUT parameters

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

246: --
247: p_hierarchy_node_id := null;
248: p_object_version_number := null;
249: p_return_status := hr_multi_message.get_return_status_disable;
250: hr_utility.set_location(' Leaving:' || l_proc,50);
251: end create_hierarchy_nodes;
252: -- ----------------------------------------------------------------------------
253: -- |------------------------< delete_hierarchy_nodes >------------------------|
254: -- ----------------------------------------------------------------------------

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

267: --
268: -- Other variables
269: l_proc varchar2(72) := g_package ||'delete_hierarchy_nodes';
270: Begin
271: hr_utility.set_location(' Entering:' || l_proc,10);
272: --
273: -- Issue a savepoint
274: --
275: savepoint delete_hierarchy_nodes_swi;

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

310: -- messages of any type exist in the Multiple Message List.
311: -- Also disable Multiple Message Detection.
312: --
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc,20);
315: --
316: exception
317: when hr_multi_message.error_message_exist then
318: --

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

325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_object_version_number := l_object_version_number;
328: p_return_status := hr_multi_message.get_return_status_disable;
329: hr_utility.set_location(' Leaving:' || l_proc, 30);
330: when others then
331: --
332: -- When Multiple Message Detection is enabled catch
333: -- any Application specific or other unexpected

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

336: -- error.
337: --
338: rollback to delete_hierarchy_nodes_swi;
339: if hr_multi_message.unexpected_error_add(l_proc) then
340: hr_utility.set_location(' Leaving:' || l_proc,40);
341: raise;
342: end if;
343: --
344: -- Reset IN OUT and set OUT parameters

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

344: -- Reset IN OUT and set OUT parameters
345: --
346: p_object_version_number := l_object_version_number;
347: p_return_status := hr_multi_message.get_return_status_disable;
348: hr_utility.set_location(' Leaving:' || l_proc,50);
349: end delete_hierarchy_nodes;
350: -- ----------------------------------------------------------------------------
351: -- |----------------------------------< lck >---------------------------------|
352: -- ----------------------------------------------------------------------------

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

362: --
363: -- Other variables
364: l_proc varchar2(72) := g_package ||'lck';
365: Begin
366: hr_utility.set_location(' Entering:' || l_proc,10);
367: --
368: -- Issue a savepoint
369: --
370: savepoint lck_swi;

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

400: -- messages of any type exist in the Multiple Message List.
401: -- Also disable Multiple Message Detection.
402: --
403: p_return_status := hr_multi_message.get_return_status_disable;
404: hr_utility.set_location(' Leaving:' || l_proc,20);
405: --
406: exception
407: when hr_multi_message.error_message_exist then
408: --

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

414: --
415: -- Reset IN OUT parameters and set OUT parameters
416: --
417: p_return_status := hr_multi_message.get_return_status_disable;
418: hr_utility.set_location(' Leaving:' || l_proc, 30);
419: when others then
420: --
421: -- When Multiple Message Detection is enabled catch
422: -- any Application specific or other unexpected

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

425: -- error.
426: --
427: rollback to lck_swi;
428: if hr_multi_message.unexpected_error_add(l_proc) then
429: hr_utility.set_location(' Leaving:' || l_proc,40);
430: raise;
431: end if;
432: --
433: -- Reset IN OUT and set OUT parameters

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

432: --
433: -- Reset IN OUT and set OUT parameters
434: --
435: p_return_status := hr_multi_message.get_return_status_disable;
436: hr_utility.set_location(' Leaving:' || l_proc,50);
437: end lck;
438: -- ----------------------------------------------------------------------------
439: -- |------------------------< update_hierarchy_nodes >------------------------|
440: -- ----------------------------------------------------------------------------

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

524: --
525: -- Other variables
526: l_proc varchar2(72) := g_package ||'update_hierarchy_nodes';
527: Begin
528: hr_utility.set_location(' Entering:' || l_proc,10);
529: --
530: -- Issue a savepoint
531: --
532: savepoint update_hierarchy_nodes_swi;

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

638: -- messages of any type exist in the Multiple Message List.
639: -- Also disable Multiple Message Detection.
640: --
641: p_return_status := hr_multi_message.get_return_status_disable;
642: hr_utility.set_location(' Leaving:' || l_proc,20);
643: --
644: exception
645: when hr_multi_message.error_message_exist then
646: --

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

653: -- Reset IN OUT parameters and set OUT parameters
654: --
655: p_object_version_number := l_object_version_number;
656: p_return_status := hr_multi_message.get_return_status_disable;
657: hr_utility.set_location(' Leaving:' || l_proc, 30);
658: when others then
659: --
660: -- When Multiple Message Detection is enabled catch
661: -- any Application specific or other unexpected

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

664: -- error.
665: --
666: rollback to update_hierarchy_nodes_swi;
667: if hr_multi_message.unexpected_error_add(l_proc) then
668: hr_utility.set_location(' Leaving:' || l_proc,40);
669: raise;
670: end if;
671: --
672: -- Reset IN OUT and set OUT parameters

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

672: -- Reset IN OUT and set OUT parameters
673: --
674: p_object_version_number := l_object_version_number;
675: p_return_status := hr_multi_message.get_return_status_disable;
676: hr_utility.set_location(' Leaving:' || l_proc,50);
677: end update_hierarchy_nodes;
678: end per_hierarchy_nodes_swi;