[Home] [Help]
989: l_no number := 0;
990: BEGIN
991:
992: --
993: hr_utility.set_location('Entering:'||l_proc, 5);
994: --
995: For a in csr_cost loop
996: l_no := l_no+1;
997: p_cost_alloc_keyflex_id :=a.cost_allocation_keyflex_id;
1010: p_organization_id :=a.organization_id ;
1011: end loop;
1012: end if;
1013: --
1014: hr_utility.set_location(' Leaving:'||l_proc, 10);
1015:
1016: END check_cost_center;
1017:
1018: Procedure supervisor_exists ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1910:
1911: l_username fnd_user.user_name%TYPE;
1912:
1913: BEGIN
1914: hr_utility.set_location('Entering:'||l_proc, 10);
1915:
1916: savepoint cancel_enrollment;
1917:
1918: --Enable multi messaging
2077: x_return_status := hr_multi_message.get_return_status_disable;
2078:
2079: cancel_finance(p_booking_id);
2080:
2081: hr_utility.set_location('Leaving:'||l_proc, 20);
2082: EXCEPTION
2083: When hr_multi_message.error_message_exist then
2084: --
2085: -- Catch the Multiple Message List exception which
2091: -- Reset IN OUT parameters and set OUT parameters
2092: --
2093:
2094: x_return_status := hr_multi_message.get_return_status_disable;
2095: hr_utility.set_location(' Leaving:' || l_proc, 30);
2096: When others then
2097: --
2098: -- When Multiple Message Detection is enabled catch
2099: -- any Application specific or other unexpected
2102: -- error.
2103: --
2104: rollback to cancel_enrollment;
2105: if hr_multi_message.unexpected_error_add(l_proc) then
2106: hr_utility.set_location(' Leaving:' || l_proc,40);
2107: raise;
2108: end if;
2109: --
2110: -- Reset IN OUT and set OUT parameters
2110: -- Reset IN OUT and set OUT parameters
2111: --
2112:
2113: x_return_status := hr_multi_message.get_return_status_disable;
2114: hr_utility.set_location(' Leaving:' || l_proc,50);
2115: END cancel_enrollment;
2116:
2117: Procedure CHK_UNIQUE_FUNC(p_function_name in varchar2,
2118: p_user_id in number,
2480: WHERE employee_id = p_supervisor_id;
2481:
2482: BEGIN
2483:
2484: hr_utility.set_location('Entering:'||l_proc, 10);
2485: --Enable multi messaging
2486: hr_multi_message.enable_message_list;
2487:
2488: p_current_username := fnd_profile.value('USERNAME');
2521: p_supervisor_username := b.user_name;
2522: END LOOP;
2523:
2524: x_return_status := hr_multi_message.get_return_status_disable;
2525: hr_utility.set_location('Leaving:'||l_proc, 20);
2526: EXCEPTION
2527: When hr_multi_message.error_message_exist then
2528: --
2529: -- Catch the Multiple Message List exception which
2535: -- Reset IN OUT parameters and set OUT parameters
2536: --
2537:
2538: x_return_status := hr_multi_message.get_return_status_disable;
2539: hr_utility.set_location(' Leaving:' || l_proc, 30);
2540: When others then
2541: --
2542: -- When Multiple Message Detection is enabled catch
2543: -- any Application specific or other unexpected
2545: -- Multiple Message List. Otherwise re-raise the
2546: -- error.
2547: --
2548: if hr_multi_message.unexpected_error_add(l_proc) then
2549: hr_utility.set_location(' Leaving:' || l_proc,40);
2550: raise;
2551: end if;
2552: --
2553: -- Reset IN OUT and set OUT parameters
2553: -- Reset IN OUT and set OUT parameters
2554: --
2555:
2556: x_return_status := hr_multi_message.get_return_status_disable;
2557: hr_utility.set_location(' Leaving:' || l_proc,50);
2558: END get_wf_attr_for_cancel_ntf;
2559: --
2560: -- ----------------------------------------------------------------------------
2561: -- |-------------------------< get_booking_status_comments >----------------------------|
2577: --
2578: begin
2579: --
2580: --
2581: hr_utility.set_location('Entering:'|| l_proc, 5);
2582: --
2583: l_comments:=ota_utility.getEnrollmentChangeReason(p_booking_id);
2584:
2585: RETURN l_comments;