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

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

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

162:
163: p_booking_status_type := v_enroll_status;
164: p_date_status_changed := v_date_status_changed;
165:
166: hr_utility.set_location(' Step:'|| l_proc, 20);
167:
168: END get_enrollment_status;
169: --
170: -- ---------------------------------------------------------------------------

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

196: l_found BOOLEAN := FALSE;
197:
198: BEGIN
199:
200: hr_utility.set_location(' Step:'|| l_proc, 10);
201:
202: OPEN chk_enr;
203: FETCH chk_enr INTO l_return_val;
204: IF chk_enr%FOUND THEN

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

207: --
208: END IF;
209: CLOSE chk_enr;
210: --
211: hr_utility.set_location('Leaving '||l_proc,10);
212:
213: RETURN l_found;
214:
215: END chk_enrollment_exist;

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

230: l_contact_id ota_learning_paths.contact_id%TYPE;
231:
232: BEGIN
233:
234: hr_utility.set_location('Entering:'|| l_proc, 10);
235:
236: SELECT lpe.person_id, lpe.contact_id
237: INTO l_person_id , l_contact_id
238: FROM ota_lp_enrollments lpe

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

260: p_member_status_code := 'PLANNED';
261: p_completion_date := null;
262: END IF;
263:
264: hr_utility.set_location('LEAVING:'|| l_proc, 20);
265:
266: EXCEPTION
267: WHEN others THEN
268: p_member_status_code := 'PLANNED';

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

287: l_contact_id ota_learning_paths.contact_id%TYPE;
288:
289: BEGIN
290:
291: hr_utility.set_location('Entering:'|| l_proc, 10);
292:
293: get_enrollment_status(p_person_id => p_person_id,
294: p_contact_id => p_contact_id,
295: p_activity_version_id => p_activity_version_id,

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

312: l_member_status_code := 'PLANNED';
313:
314: END IF;
315:
316: hr_utility.set_location('LEAVING:'|| l_proc, 20);
317:
318: RETURN l_member_status_code;
319:
320: END get_lme_status;

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

337: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
338:
339: BEGIN
340:
341: hr_utility.set_location(' Step:'|| l_proc, 10);
342: OPEN csr_lpc_comp;
343: FETCH csr_lpc_comp INTO l_completed_courses;
344: CLOSE csr_lpc_comp;
345:

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

342: OPEN csr_lpc_comp;
343: FETCH csr_lpc_comp INTO l_completed_courses;
344: CLOSE csr_lpc_comp;
345:
346: hr_utility.set_location(' Step:'|| l_proc, 20);
347: RETURN l_completed_courses;
348:
349: END get_lpc_completed_courses;
350:

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

366: l_completion_type ota_lp_sections.completion_type_code%TYPE;
367:
368: BEGIN
369:
370: hr_utility.set_location(' Step:'|| l_proc, 10);
371: OPEN csr_lpc_dtl;
372: FETCH csr_lpc_dtl INTO l_completion_type;
373: CLOSE csr_lpc_dtl;
374:

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

371: OPEN csr_lpc_dtl;
372: FETCH csr_lpc_dtl INTO l_completion_type;
373: CLOSE csr_lpc_dtl;
374:
375: hr_utility.set_location(' Step:'|| l_proc, 20);
376: RETURN l_completion_type;
377:
378: END chk_section_completion_type;
379:

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

466: FETCH evt_det
467: INTO l_activity_version_id;
468: CLOSE evt_det;
469:
470: hr_utility.set_location(' Step:'|| l_proc, 20);
471:
472: FOR rec IN csr_lpm_info(l_activity_version_id)
473:
474: LOOP

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

538:
539: END IF;
540: END LOOP;
541:
542: hr_utility.set_location(' Step:'|| l_proc, 30);
543:
544: --MULTI MESSAGE SUPPORT
545:
546:

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

777: WHERE learning_path_section_id = l_learning_path_section_id
778: AND activity_version_id = p_activity_version_id;
779:
780: BEGIN
781: hr_utility.set_location(' Entering:' || l_proc,10);
782: --
783: -- Issue a savepoint
784: --
785: SAVEPOINT create_talent_mgmt_lpm;

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

951: -- messages of any type exist in the Multiple Message List.
952: -- Also disable Multiple Message Detection.
953: --
954: p_return_status := hr_multi_message.get_return_status_disable;
955: hr_utility.set_location(' Leaving:' || l_proc,20);
956: --
957: EXCEPTION
958: WHEN hr_multi_message.error_message_exist THEN
959: --

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

966: -- Reset IN OUT parameters and set OUT parameters
967: --
968: p_object_version_NUMBER := NULL;
969: p_return_status := hr_multi_message.get_return_status_disable;
970: hr_utility.set_location(' Leaving:' || l_proc, 30);
971:
972: WHEN others THEN
973: --
974: -- When Multiple Message Detection is enabled catch

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

978: -- error.
979: --
980: ROLLBACK TO create_talent_mgmt_lpm;
981: IF hr_multi_message.unexpected_error_add(l_proc) THEN
982: hr_utility.set_location(' Leaving:' || l_proc,40);
983: RAISE;
984: END IF;
985: --
986: -- Reset IN OUT and set OUT parameters

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

986: -- Reset IN OUT and set OUT parameters
987: --
988: p_object_version_NUMBER := NULL;
989: p_return_status := hr_multi_message.get_return_status_disable;
990: hr_utility.set_location(' Leaving:' || l_proc,50);
991: END create_talent_mgmt_lpm;
992:
993: -- ----------------------------------------------------------------------------
994: -- ----------------------------------------------------------------------------

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

1075: FROM dual;
1076:
1077:
1078: BEGIN
1079: hr_utility.set_location(' Entering:' || l_proc,10);
1080: --
1081: -- Issue a savepoint
1082: --
1083: SAVEPOINT update_talent_mgmt_lp;

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

1233: -- messages of any type exist in the Multiple Message List.
1234: -- Also disable Multiple Message Detection.
1235: --
1236: p_return_status := hr_multi_message.get_return_status_disable;
1237: hr_utility.set_location(' Leaving:' || l_proc,20);
1238: --
1239: EXCEPTION
1240: WHEN hr_multi_message.error_message_exist THEN
1241: --

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

1247: --
1248: -- Reset IN OUT parameters and set OUT parameters
1249: --
1250: p_return_status := hr_multi_message.get_return_status_disable;
1251: hr_utility.set_location(' Leaving:' || l_proc, 30);
1252:
1253: WHEN others THEN
1254: --
1255: -- When Multiple Message Detection is enabled catch

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

1259: -- error.
1260: --
1261: ROLLBACK TO update_talent_mgmt_lp;
1262: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1263: hr_utility.set_location(' Leaving:' || l_proc,40);
1264: RAISE;
1265: END IF;
1266: --
1267: -- Reset IN OUT and set OUT parameters

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

1266: --
1267: -- Reset IN OUT and set OUT parameters
1268: --
1269: p_return_status := hr_multi_message.get_return_status_disable;
1270: hr_utility.set_location(' Leaving:' || l_proc,50);
1271: END update_talent_mgmt_lp;
1272: -- ----------------------------------------------------------------------------
1273: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
1274: -- ----------------------------------------------------------------------------

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

1301: BEGIN
1302: --
1303:
1304:
1305: hr_utility.set_location(' Step:'|| l_proc, 30);
1306:
1307:
1308: p_return_status := 'S';
1309: OPEN get_section_info;

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

1319: END IF;
1320: END IF;
1321: CLOSE get_section_info;
1322:
1323: hr_utility.set_location(' Leaving:'||l_proc, 90);
1324: END chk_no_of_mandatory_courses;
1325:
1326: END ota_lrng_path_member_util;
1327: