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_BULK_ENROLL_UTIL dependencies on OTA_BULK_ENROLL_UTIL

Line 1: package body ota_bulk_enroll_util as

1: package body ota_bulk_enroll_util as
2: /* $Header: otblkenr.pkb 120.24.12020000.4 2012/06/29 12:02:09 rpahune ship $ */
3:
4: g_package varchar2(33) := 'ota_bulk_enroll_util.'; -- Global package name
5:

Line 4: g_package varchar2(33) := 'ota_bulk_enroll_util.'; -- Global package name

1: package body ota_bulk_enroll_util as
2: /* $Header: otblkenr.pkb 120.24.12020000.4 2012/06/29 12:02:09 rpahune ship $ */
3:
4: g_package varchar2(33) := 'ota_bulk_enroll_util.'; -- Global package name
5:
6: Function get_enrollment_status( p_object_type IN VARCHAR2
7: ,p_object_id IN NUMBER
8: ,p_learner_id IN NUMBER

Line 1289: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);

1285: OPEN csr_get_request_info(p_enr_request_id);
1286: FETCH csr_get_request_info INTO l_request_rec;
1287: CLOSE csr_get_request_info;
1288:
1289: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);
1290:
1291: -- Get the next item key from the sequence
1292: select hr_workflow_item_key_s.nextval
1293: into l_item_key

Line 1825: l_class_name := OTA_BULK_ENROLL_UTIL.get_object_name('CL', l_request_rec.object_id);

1821: if l_request_rec.object_type = 'LPCL' and l_existing_booking_id is NOT NULL then
1822: --check if a booking already exists,if so we need to show a different message
1823:
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1825: l_class_name := OTA_BULK_ENROLL_UTIL.get_object_name('CL', l_request_rec.object_id);
1826: l_lp_name := OTA_BULK_ENROLL_UTIL.get_object_name('LP', l_request_rec.parent_object_id);
1827:
1828: fnd_message.set_name ('OTA','OTA_467145_LP_CLASS_ENROLLED');
1829: fnd_message.set_token('LEARNER_NAME',l_person_name);

Line 1826: l_lp_name := OTA_BULK_ENROLL_UTIL.get_object_name('LP', l_request_rec.parent_object_id);

1822: --check if a booking already exists,if so we need to show a different message
1823:
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1825: l_class_name := OTA_BULK_ENROLL_UTIL.get_object_name('CL', l_request_rec.object_id);
1826: l_lp_name := OTA_BULK_ENROLL_UTIL.get_object_name('LP', l_request_rec.parent_object_id);
1827:
1828: fnd_message.set_name ('OTA','OTA_467145_LP_CLASS_ENROLLED');
1829: fnd_message.set_token('LEARNER_NAME',l_person_name);
1830: fnd_message.set_token('CLASS_NAME',l_class_name);

Line 2061: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);

2057: if(p_enr_request_id_end IS NULL and p_enr_request_id IS NOT NULL) then
2058:
2059: OPEN csr_get_request_info(p_enr_request_id);
2060: FETCH csr_get_request_info INTO l_request_rec;
2061: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);
2062:
2063: IF csr_get_request_info%NOTFOUND THEN
2064: CLOSE csr_get_request_info;
2065: --fnd_concurrent.set_completion_status('ERROR');

Line 2120: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);

2116: CLOSE csr_get_request_info;
2117: --fnd_concurrent.set_completion_status('ERROR');
2118: ELSIF l_request_rec.object_type = 'LP' THEN
2119: CLOSE csr_get_request_info;
2120: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollments for the Learning Path - ' || l_object_name);
2122:
2123: mass_subscribe_to_lp(
2124: p_enr_request_id => current_request_id

Line 2131: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);

2127: COMMIT;
2128:
2129: ELSIF l_request_rec.object_type = 'LPCL' THEN
2130: CLOSE csr_get_request_info;
2131: l_object_name := OTA_BULK_ENROLL_UTIL.get_object_name(l_request_rec.object_type, l_request_rec.object_id);
2132: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
2133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollments for the Class - ' || l_object_name);
2134: mass_subscribe_to_class(
2135: p_enr_request_id => current_request_id

Line 2461: end ota_bulk_enroll_util;

2457: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2458: ||','||SUBSTR(SQLERRM, 1, 500));
2459:
2460: END process_bulk_enr_upd;
2461: end ota_bulk_enroll_util;