DBA Data[Home] [Help]

APPS.PSP_EFF_REPORT_APPROVALS_SWI dependencies on HR_UTILITY

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

24: --
25: -- Other variables
26: l_proc varchar2(72) := g_package ||'delete_eff_report_approvals';
27: Begin
28: hr_utility.set_location(' Entering:' || l_proc,10);
29: --
30: -- Issue a savepoint
31: --
32: savepoint delete_eff_report_approval_swi;

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

75: -- messages of any type exist in the Multiple Message List.
76: -- Also disable Multiple Message Detection.
77: --
78: p_return_status := hr_multi_message.get_return_status_disable;
79: hr_utility.set_location(' Leaving:' || l_proc,20);
80: --
81: exception
82: when hr_multi_message.error_message_exist then
83: --

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

91: --
92: p_object_version_number := l_object_version_number;
93: p_return_status := null;
94: p_return_status := hr_multi_message.get_return_status_disable;
95: hr_utility.set_location(' Leaving:' || l_proc, 30);
96: when others then
97: --
98: -- When Multiple Message Detection is enabled catch
99: -- any Application specific or other unexpected

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

102: -- error.
103: --
104: rollback to delete_eff_report_approval_swi;
105: if hr_multi_message.unexpected_error_add(l_proc) then
106: hr_utility.set_location(' Leaving:' || l_proc,40);
107: raise;
108: end if;
109: --
110: -- Reset IN OUT and set OUT parameters

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

111: --
112: p_object_version_number := l_object_version_number;
113: p_return_status := null;
114: p_return_status := hr_multi_message.get_return_status_disable;
115: hr_utility.set_location(' Leaving:' || l_proc,50);
116: end delete_eff_report_approvals;
117: -- ----------------------------------------------------------------------------
118: -- |----------------------< insert_eff_report_approvals >---------------------|
119: -- ----------------------------------------------------------------------------

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

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

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

283: -- messages of any type exist in the Multiple Message List.
284: -- Also disable Multiple Message Detection.
285: --
286: p_return_status := hr_multi_message.get_return_status_disable;
287: hr_utility.set_location(' Leaving:' || l_proc,20);
288: --
289: exception
290: when hr_multi_message.error_message_exist then
291: --

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

300: p_effort_report_approval_id := null;
301: p_object_version_number := null;
302: p_return_status := null;
303: p_return_status := hr_multi_message.get_return_status_disable;
304: hr_utility.set_location(' Leaving:' || l_proc, 30);
305: when others then
306: --
307: -- When Multiple Message Detection is enabled catch
308: -- any Application specific or other unexpected

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

311: -- error.
312: --
313: rollback to insert_eff_report_approval_swi;
314: if hr_multi_message.unexpected_error_add(l_proc) then
315: hr_utility.set_location(' Leaving:' || l_proc,40);
316: raise;
317: end if;
318: --
319: -- Reset IN OUT and set OUT parameters

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

321: p_effort_report_approval_id := null;
322: p_object_version_number := null;
323: p_return_status := null;
324: p_return_status := hr_multi_message.get_return_status_disable;
325: hr_utility.set_location(' Leaving:' || l_proc,50);
326: end insert_eff_report_approvals;
327: -- ----------------------------------------------------------------------------
328: -- |----------------------< update_eff_report_approvals >---------------------|
329: -- ----------------------------------------------------------------------------

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

392: --
393: -- Other variables
394: l_proc varchar2(72) := g_package ||'update_eff_report_approvals';
395: Begin
396: hr_utility.set_location(' Entering:' || l_proc,10);
397: --
398: -- Issue a savepoint
399: --
400: savepoint update_eff_report_approval_swi;

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

492: -- messages of any type exist in the Multiple Message List.
493: -- Also disable Multiple Message Detection.
494: --
495: p_return_status := hr_multi_message.get_return_status_disable;
496: hr_utility.set_location(' Leaving:' || l_proc,20);
497: --
498: exception
499: when hr_multi_message.error_message_exist then
500: --

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

508: --
509: p_object_version_number := l_object_version_number;
510: p_return_status := null;
511: p_return_status := hr_multi_message.get_return_status_disable;
512: hr_utility.set_location(' Leaving:' || l_proc, 30);
513: when others then
514: --
515: -- When Multiple Message Detection is enabled catch
516: -- any Application specific or other unexpected

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

519: -- error.
520: --
521: rollback to update_eff_report_approval_swi;
522: if hr_multi_message.unexpected_error_add(l_proc) then
523: hr_utility.set_location(' Leaving:' || l_proc,40);
524: raise;
525: end if;
526: --
527: -- Reset IN OUT and set OUT parameters

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

528: --
529: p_object_version_number := l_object_version_number;
530: p_return_status := null;
531: p_return_status := hr_multi_message.get_return_status_disable;
532: hr_utility.set_location(' Leaving:' || l_proc,50);
533: end update_eff_report_approvals;
534: end psp_eff_report_approvals_swi;