eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on HR_UTILITY

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

58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN
61:
62: hr_utility.set_location(' Step:'|| l_proc, 10);
63:
64: IF p_lp_member_enrollment_id IS NOT NULL THEN
65: FOR rec_lp_enr IN csr_lp_enr
66: LOOP

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

84: l_return := l_status_name;
85: ELSE l_return := l_status_type;
86: END IF;
87:
88: hr_utility.set_location(' Step:'|| l_proc, 20);
89: RETURN l_return;
90:
91: END get_enrollment_status;
92:

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

145: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
146: v_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
147: BEGIN
148:
149: hr_utility.set_location(' Step:'|| l_proc, 10);
150: IF p_lp_member_enrollment_id IS NOT NULL THEN
151: FOR rec_lp_enr IN csr_lp_enr
152: LOOP
153: v_enroll_status := rec_lp_enr.status ;

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

168: p_booking_status_type := v_enroll_status;
169: p_date_status_changed := v_date_status_changed;
170: p_successful_attendance_flag := v_successful_attendance_flag;
171:
172: hr_utility.set_location(' Step:'|| l_proc, 20);
173:
174: END get_enrollment_status;
175: --
176: -- ---------------------------------------------------------------------------

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

202: l_found BOOLEAN := FALSE;
203:
204: BEGIN
205:
206: hr_utility.set_location(' Step:'|| l_proc, 10);
207:
208: OPEN chk_enr;
209: FETCH chk_enr INTO l_return_val;
210: IF chk_enr%FOUND THEN

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

213: --
214: END IF;
215: CLOSE chk_enr;
216: --
217: hr_utility.set_location('Leaving '||l_proc,10);
218:
219: RETURN l_found;
220:
221: END chk_enrollment_exist;

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

236: l_contact_id ota_learning_paths.contact_id%TYPE;
237: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
238: BEGIN
239:
240: hr_utility.set_location('Entering:'|| l_proc, 10);
241:
242: SELECT lpe.person_id, lpe.contact_id
243: INTO l_person_id , l_contact_id
244: FROM ota_lp_enrollments lpe

Line 273: hr_utility.set_location('LEAVING:'|| l_proc, 20);

269: p_member_status_code := 'PLANNED';
270: p_completion_date := null;
271: END IF;
272:
273: hr_utility.set_location('LEAVING:'|| l_proc, 20);
274:
275: EXCEPTION
276: WHEN others THEN
277: p_member_status_code := 'PLANNED';

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

296: l_contact_id ota_learning_paths.contact_id%TYPE;
297: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
298: BEGIN
299:
300: hr_utility.set_location('Entering:'|| l_proc, 10);
301:
302: get_enrollment_status(p_person_id => p_person_id,
303: p_contact_id => p_contact_id,
304: p_activity_version_id => p_activity_version_id,

Line 327: hr_utility.set_location('LEAVING:'|| l_proc, 20);

323: l_member_status_code := 'PLANNED';
324:
325: END IF;
326:
327: hr_utility.set_location('LEAVING:'|| l_proc, 20);
328:
329: RETURN l_member_status_code;
330:
331: END get_lme_status;

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

348: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
349:
350: BEGIN
351:
352: hr_utility.set_location(' Step:'|| l_proc, 10);
353: OPEN csr_lpc_comp;
354: FETCH csr_lpc_comp INTO l_completed_courses;
355: CLOSE csr_lpc_comp;
356:

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

353: OPEN csr_lpc_comp;
354: FETCH csr_lpc_comp INTO l_completed_courses;
355: CLOSE csr_lpc_comp;
356:
357: hr_utility.set_location(' Step:'|| l_proc, 20);
358: RETURN l_completed_courses;
359:
360: END get_lpc_completed_courses;
361:

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

377: l_completion_type ota_lp_sections.completion_type_code%TYPE;
378:
379: BEGIN
380:
381: hr_utility.set_location(' Step:'|| l_proc, 10);
382: OPEN csr_lpc_dtl;
383: FETCH csr_lpc_dtl INTO l_completion_type;
384: CLOSE csr_lpc_dtl;
385:

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

382: OPEN csr_lpc_dtl;
383: FETCH csr_lpc_dtl INTO l_completion_type;
384: CLOSE csr_lpc_dtl;
385:
386: hr_utility.set_location(' Step:'|| l_proc, 20);
387: RETURN l_completion_type;
388:
389: END chk_section_completion_type;
390:

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

479: FETCH evt_det
480: INTO l_activity_version_id;
481: CLOSE evt_det;
482:
483: hr_utility.set_location(' Step:'|| l_proc, 20);
484:
485: FOR rec IN csr_lpm_info(l_activity_version_id)
486:
487: LOOP

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

559:
560: END IF;
561: END LOOP;
562:
563: hr_utility.set_location(' Step:'|| l_proc, 30);
564:
565: --MULTI MESSAGE SUPPORT
566:
567:

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

799: WHERE learning_path_section_id = l_learning_path_section_id
800: AND activity_version_id = p_activity_version_id;
801:
802: BEGIN
803: hr_utility.set_location(' Entering:' || l_proc,10);
804: --
805: -- Issue a savepoint
806: --
807: SAVEPOINT create_talent_mgmt_lpm;

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

973: -- messages of any type exist in the Multiple Message List.
974: -- Also disable Multiple Message Detection.
975: --
976: p_return_status := hr_multi_message.get_return_status_disable;
977: hr_utility.set_location(' Leaving:' || l_proc,20);
978: --
979: EXCEPTION
980: WHEN hr_multi_message.error_message_exist THEN
981: --

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

988: -- Reset IN OUT parameters and set OUT parameters
989: --
990: p_object_version_NUMBER := NULL;
991: p_return_status := hr_multi_message.get_return_status_disable;
992: hr_utility.set_location(' Leaving:' || l_proc, 30);
993:
994: WHEN others THEN
995: --
996: -- When Multiple Message Detection is enabled catch

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

1000: -- error.
1001: --
1002: ROLLBACK TO create_talent_mgmt_lpm;
1003: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1004: hr_utility.set_location(' Leaving:' || l_proc,40);
1005: RAISE;
1006: END IF;
1007: --
1008: -- Reset IN OUT and set OUT parameters

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

1008: -- Reset IN OUT and set OUT parameters
1009: --
1010: p_object_version_NUMBER := NULL;
1011: p_return_status := hr_multi_message.get_return_status_disable;
1012: hr_utility.set_location(' Leaving:' || l_proc,50);
1013: END create_talent_mgmt_lpm;
1014:
1015: -- ----------------------------------------------------------------------------
1016: -- ----------------------------------------------------------------------------

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

1097: FROM dual;
1098:
1099:
1100: BEGIN
1101: hr_utility.set_location(' Entering:' || l_proc,10);
1102: --
1103: -- Issue a savepoint
1104: --
1105: SAVEPOINT update_talent_mgmt_lp;

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

1255: -- messages of any type exist in the Multiple Message List.
1256: -- Also disable Multiple Message Detection.
1257: --
1258: p_return_status := hr_multi_message.get_return_status_disable;
1259: hr_utility.set_location(' Leaving:' || l_proc,20);
1260: --
1261: EXCEPTION
1262: WHEN hr_multi_message.error_message_exist THEN
1263: --

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

1269: --
1270: -- Reset IN OUT parameters and set OUT parameters
1271: --
1272: p_return_status := hr_multi_message.get_return_status_disable;
1273: hr_utility.set_location(' Leaving:' || l_proc, 30);
1274:
1275: WHEN others THEN
1276: --
1277: -- When Multiple Message Detection is enabled catch

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

1281: -- error.
1282: --
1283: ROLLBACK TO update_talent_mgmt_lp;
1284: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1285: hr_utility.set_location(' Leaving:' || l_proc,40);
1286: RAISE;
1287: END IF;
1288: --
1289: -- Reset IN OUT and set OUT parameters

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

1288: --
1289: -- Reset IN OUT and set OUT parameters
1290: --
1291: p_return_status := hr_multi_message.get_return_status_disable;
1292: hr_utility.set_location(' Leaving:' || l_proc,50);
1293: END update_talent_mgmt_lp;
1294: -- ----------------------------------------------------------------------------
1295: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
1296: -- ----------------------------------------------------------------------------

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

1323: BEGIN
1324: --
1325:
1326:
1327: hr_utility.set_location(' Step:'|| l_proc, 30);
1328:
1329:
1330: p_return_status := 'S';
1331: OPEN get_section_info;

Line 1345: hr_utility.set_location(' Leaving:'||l_proc, 90);

1341: END IF;
1342: END IF;
1343: CLOSE get_section_info;
1344:
1345: hr_utility.set_location(' Leaving:'||l_proc, 90);
1346: END chk_no_of_mandatory_courses;
1347:
1348: FUNCTION get_class_completion_date(p_event_id IN ota_events.event_id%type,
1349: p_person_id IN NUMBER,