[Home] [Help]
105: --
106: -- Other variables
107: l_proc varchar2(72) := g_package ||'create_payroll';
108: Begin
109: hr_utility.set_location(' Entering:' || l_proc,10);
110: --
111: -- Issue a savepoint
112: --
113: savepoint create_payroll_swi;
232: -- messages of any type exist in the Multiple Message List.
233: -- Also disable Multiple Message Detection.
234: --
235: p_return_status := hr_multi_message.get_return_status_disable;
236: hr_utility.set_location(' Leaving:' || l_proc,20);
237: --
238: exception
239: when hr_multi_message.error_message_exist then
240: --
254: p_opm_effective_start_date := null;
255: p_opm_effective_end_date := null;
256: p_comment_id := null;
257: p_return_status := hr_multi_message.get_return_status_disable;
258: hr_utility.set_location(' Leaving:' || l_proc, 30);
259: when others then
260: --
261: -- When Multiple Message Detection is enabled catch
262: -- any Application specific or other unexpected
265: -- error.
266: --
267: rollback to create_payroll_swi;
268: if hr_multi_message.unexpected_error_add(l_proc) then
269: hr_utility.set_location(' Leaving:' || l_proc,40);
270: raise;
271: end if;
272: --
273: -- Reset IN OUT and set OUT parameters
280: p_opm_effective_start_date := null;
281: p_opm_effective_end_date := null;
282: p_comment_id := null;
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc,50);
285: end create_payroll;
286: -- ----------------------------------------------------------------------------
287: -- |----------------------------< delete_payroll >----------------------------|
288: -- ----------------------------------------------------------------------------
305: --
306: -- Other variables
307: l_proc varchar2(72) := g_package ||'delete_payroll';
308: Begin
309: hr_utility.set_location(' Entering:' || l_proc,10);
310: --
311: -- Issue a savepoint
312: --
313: savepoint delete_payroll_swi;
352: -- messages of any type exist in the Multiple Message List.
353: -- Also disable Multiple Message Detection.
354: --
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,20);
357: --
358: exception
359: when hr_multi_message.error_message_exist then
360: --
369: p_object_version_number := l_object_version_number;
370: p_effective_start_date := null;
371: p_effective_end_date := null;
372: p_return_status := hr_multi_message.get_return_status_disable;
373: hr_utility.set_location(' Leaving:' || l_proc, 30);
374: when others then
375: --
376: -- When Multiple Message Detection is enabled catch
377: -- any Application specific or other unexpected
380: -- error.
381: --
382: rollback to delete_payroll_swi;
383: if hr_multi_message.unexpected_error_add(l_proc) then
384: hr_utility.set_location(' Leaving:' || l_proc,40);
385: raise;
386: end if;
387: --
388: -- Reset IN OUT and set OUT parameters
390: p_object_version_number := l_object_version_number;
391: p_effective_start_date := null;
392: p_effective_end_date := null;
393: p_return_status := hr_multi_message.get_return_status_disable;
394: hr_utility.set_location(' Leaving:' || l_proc,50);
395: end delete_payroll;
396: -- ----------------------------------------------------------------------------
397: -- |----------------------------< update_payroll >----------------------------|
398: -- ----------------------------------------------------------------------------
480: --
481: -- Other variables
482: l_proc varchar2(72) := g_package ||'update_payroll';
483: Begin
484: hr_utility.set_location(' Entering:' || l_proc,10);
485: --
486: -- Issue a savepoint
487: --
488: savepoint update_payroll_swi;
592: -- messages of any type exist in the Multiple Message List.
593: -- Also disable Multiple Message Detection.
594: --
595: p_return_status := hr_multi_message.get_return_status_disable;
596: hr_utility.set_location(' Leaving:' || l_proc,20);
597: --
598: exception
599: when hr_multi_message.error_message_exist then
600: --
611: p_prl_effective_start_date := null;
612: p_prl_effective_end_date := null;
613: p_comment_id := null;
614: p_return_status := hr_multi_message.get_return_status_disable;
615: hr_utility.set_location(' Leaving:' || l_proc, 30);
616: when others then
617: --
618: -- When Multiple Message Detection is enabled catch
619: -- any Application specific or other unexpected
622: -- error.
623: --
624: rollback to update_payroll_swi;
625: if hr_multi_message.unexpected_error_add(l_proc) then
626: hr_utility.set_location(' Leaving:' || l_proc,40);
627: raise;
628: end if;
629: --
630: -- Reset IN OUT and set OUT parameters
634: p_prl_effective_start_date := null;
635: p_prl_effective_end_date := null;
636: p_comment_id := null;
637: p_return_status := hr_multi_message.get_return_status_disable;
638: hr_utility.set_location(' Leaving:' || l_proc,50);
639: end update_payroll;
640: end pay_payroll_swi;