DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_SS dependencies on HR_UTILITY

Line 992: hr_utility.set_location('Entering:'||l_proc, 5);

988: l_no number := 0;
989: BEGIN
990:
991: --
992: hr_utility.set_location('Entering:'||l_proc, 5);
993: --
994: For a in csr_cost loop
995: l_no := l_no+1;
996: p_cost_alloc_keyflex_id :=a.cost_allocation_keyflex_id;

Line 1013: hr_utility.set_location(' Leaving:'||l_proc, 10);

1009: p_organization_id :=a.organization_id ;
1010: end loop;
1011: end if;
1012: --
1013: hr_utility.set_location(' Leaving:'||l_proc, 10);
1014:
1015: END check_cost_center;
1016:
1017: Procedure supervisor_exists ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

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

1909:
1910: l_username fnd_user.user_name%TYPE;
1911:
1912: BEGIN
1913: hr_utility.set_location('Entering:'||l_proc, 10);
1914:
1915: savepoint cancel_enrollment;
1916:
1917: --Enable multi messaging

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

2076: x_return_status := hr_multi_message.get_return_status_disable;
2077:
2078: cancel_finance(p_booking_id);
2079:
2080: hr_utility.set_location('Leaving:'||l_proc, 20);
2081: EXCEPTION
2082: When hr_multi_message.error_message_exist then
2083: --
2084: -- Catch the Multiple Message List exception which

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

2090: -- Reset IN OUT parameters and set OUT parameters
2091: --
2092:
2093: x_return_status := hr_multi_message.get_return_status_disable;
2094: hr_utility.set_location(' Leaving:' || l_proc, 30);
2095: When others then
2096: --
2097: -- When Multiple Message Detection is enabled catch
2098: -- any Application specific or other unexpected

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

2101: -- error.
2102: --
2103: rollback to cancel_enrollment;
2104: if hr_multi_message.unexpected_error_add(l_proc) then
2105: hr_utility.set_location(' Leaving:' || l_proc,40);
2106: raise;
2107: end if;
2108: --
2109: -- Reset IN OUT and set OUT parameters

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

2109: -- Reset IN OUT and set OUT parameters
2110: --
2111:
2112: x_return_status := hr_multi_message.get_return_status_disable;
2113: hr_utility.set_location(' Leaving:' || l_proc,50);
2114: END cancel_enrollment;
2115:
2116: Procedure CHK_UNIQUE_FUNC(p_function_name in varchar2,
2117: p_user_id in number,

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

2472: WHERE employee_id = p_supervisor_id;
2473:
2474: BEGIN
2475:
2476: hr_utility.set_location('Entering:'||l_proc, 10);
2477: --Enable multi messaging
2478: hr_multi_message.enable_message_list;
2479:
2480: p_current_username := fnd_profile.value('USERNAME');

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

2513: p_supervisor_username := b.user_name;
2514: END LOOP;
2515:
2516: x_return_status := hr_multi_message.get_return_status_disable;
2517: hr_utility.set_location('Leaving:'||l_proc, 20);
2518: EXCEPTION
2519: When hr_multi_message.error_message_exist then
2520: --
2521: -- Catch the Multiple Message List exception which

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

2527: -- Reset IN OUT parameters and set OUT parameters
2528: --
2529:
2530: x_return_status := hr_multi_message.get_return_status_disable;
2531: hr_utility.set_location(' Leaving:' || l_proc, 30);
2532: When others then
2533: --
2534: -- When Multiple Message Detection is enabled catch
2535: -- any Application specific or other unexpected

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

2537: -- Multiple Message List. Otherwise re-raise the
2538: -- error.
2539: --
2540: if hr_multi_message.unexpected_error_add(l_proc) then
2541: hr_utility.set_location(' Leaving:' || l_proc,40);
2542: raise;
2543: end if;
2544: --
2545: -- Reset IN OUT and set OUT parameters

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

2545: -- Reset IN OUT and set OUT parameters
2546: --
2547:
2548: x_return_status := hr_multi_message.get_return_status_disable;
2549: hr_utility.set_location(' Leaving:' || l_proc,50);
2550: END get_wf_attr_for_cancel_ntf;
2551: --
2552: -- ----------------------------------------------------------------------------
2553: -- |-------------------------< get_booking_status_comments >----------------------------|

Line 2573: hr_utility.set_location('Entering:'|| l_proc, 5);

2569: --
2570: begin
2571: --
2572: --
2573: hr_utility.set_location('Entering:'|| l_proc, 5);
2574: --
2575: l_comments:=ota_utility.getEnrollmentChangeReason(p_booking_id);
2576:
2577: RETURN l_comments;