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 146: hr_utility.set_location(' Step:'|| l_proc, 10);

142: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';
143:
144: BEGIN
145:
146: hr_utility.set_location(' Step:'|| l_proc, 10);
147:
148: SELECT lpe.person_id,
149: lpe.contact_id
150: INTO l_person_id,

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

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

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

171: END IF;
172:
173:
174:
175: hr_utility.set_location(' Step:'|| l_proc, 30);
176: END chk_login_person;
177:
178: -- ----------------------------------------------------------------------------
179: -- |---------------------------< get_person_id >----------------------------|

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

627: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := 0;
628:
629: BEGIN
630:
631: hr_utility.set_location(' Step:'|| l_proc, 10);
632:
633: OPEN csr_get_lp ;
634: FETCH csr_get_lp INTO l_learning_path_id;
635: CLOSE csr_get_lp;