DBA Data[Home] [Help]

APPS.PQH_SITUATIONS_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_situation';
98: Begin
99: hr_utility.set_location(' Entering:' || l_proc,10);
100: --
101: -- Issue a savepoint
102: --
103: savepoint create_situation_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_situation_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_situation_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_situation_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_situation;
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------< delete_situation >---------------------------|
254: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

340: --
341: -- Reset IN OUT and set OUT parameters
342: --
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc,50);
345: end delete_situation;
346: -- ----------------------------------------------------------------------------
347: -- |---------------------------< update_situation >---------------------------|
348: -- ----------------------------------------------------------------------------

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

434: --
435: -- Other variables
436: l_proc varchar2(72) := g_package ||'update_situation';
437: Begin
438: hr_utility.set_location(' Entering:' || l_proc,10);
439: --
440: -- Issue a savepoint
441: --
442: savepoint update_situation_swi;

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

550: -- messages of any type exist in the Multiple Message List.
551: -- Also disable Multiple Message Detection.
552: --
553: p_return_status := hr_multi_message.get_return_status_disable;
554: hr_utility.set_location(' Leaving:' || l_proc,20);
555: --
556: exception
557: when hr_multi_message.error_message_exist then
558: --

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

565: -- Reset IN OUT parameters and set OUT parameters
566: --
567: p_object_version_number := l_object_version_number;
568: p_return_status := hr_multi_message.get_return_status_disable;
569: hr_utility.set_location(' Leaving:' || l_proc, 30);
570: when others then
571: --
572: -- When Multiple Message Detection is enabled catch
573: -- any Application specific or other unexpected

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

576: -- error.
577: --
578: rollback to update_situation_swi;
579: if hr_multi_message.unexpected_error_add(l_proc) then
580: hr_utility.set_location(' Leaving:' || l_proc,40);
581: raise;
582: end if;
583: --
584: -- Reset IN OUT and set OUT parameters

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

584: -- Reset IN OUT and set OUT parameters
585: --
586: p_object_version_number := l_object_version_number;
587: p_return_status := hr_multi_message.get_return_status_disable;
588: hr_utility.set_location(' Leaving:' || l_proc,50);
589: end update_situation;
590: end pqh_situations_swi;