APPS.OTA_LRNG_PATH_UTIL dependencies on HR_UTILITY

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

61: l_completed_course_count number := 0;
62:
63: Begin
64:
65: hr_utility.set_location(' Entering:' || l_proc,10);
66:
67: -- Added for Bug#4052408
68: -- Return F for Talent Management learning paths whose status is AWAITING_APPROVAL
69: OPEN csr_get_path_details;

Line 150: hr_utility.set_location(' Step:'|| l_proc, 10);

146: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';
147:
148: BEGIN
149:
150: hr_utility.set_location(' Step:'|| l_proc, 10);
151:
152: SELECT lpe.person_id,
153: lpe.contact_id
154: INTO l_person_id,

Line 166: hr_utility.set_location(' Step:'|| l_proc, 20);

162: l_login_customer
163: FROM fnd_user
164: WHERE user_id = fnd_profile.value('USER_ID');
165:
166: hr_utility.set_location(' Step:'|| l_proc, 20);
167: IF l_login_person IS NOT NULL THEN
168: IF l_login_person = l_person_id THEN
169: RETURN 'E';
170: ELSE

Line 179: hr_utility.set_location(' Step:'|| l_proc, 30);

175: END IF;
176:
177:
178:
179: hr_utility.set_location(' Step:'|| l_proc, 30);
180: END chk_login_person;
181:
182: -- ----------------------------------------------------------------------------
183: -- |---------------------------< get_person_id >----------------------------|

Line 635: hr_utility.set_location(' Step:'|| l_proc, 10);

631: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := 0;
632:
633: BEGIN
634:
635: hr_utility.set_location(' Step:'|| l_proc, 10);
636:
637: OPEN csr_get_lp ;
638: FETCH csr_get_lp INTO l_learning_path_id;
639: CLOSE csr_get_lp;