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 FND_FILE

Line 1341: fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);

1337: WHERE employee_id=l_person_id
1338: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')) --Bug 5676892
1339: AND ROWNUM =1 ;
1340: if l_request_rec.object_type <> 'LPCL' then
1341: fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);
1342: end if;
1343: IF l_person_full_name IS NOT NULL then
1344: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'EVENT_OWNER',l_user_name);
1345: END IF;

Line 1407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1403: begin
1404: OPEN csr_get_person_name(l_req_member_rec.person_id);
1405: FETCH csr_get_person_name INTO l_person_name;
1406: CLOSE csr_get_person_name;
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1408:
1409: -- call subscribe for each learning path
1410: ota_lp_enrollment_api.subscribe_to_learning_path(
1411: p_learning_path_id => l_request_rec.object_id

Line 1424: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

1420:
1421: l_error_message := fnd_message.get;
1422: fnd_message.clear;
1423: l_error_message := nvl(l_error_message,'Error When creating Learning Path subscription ');
1424: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1425: UPDATE ota_bulk_enr_req_members
1426: SET error_message = l_error_message, enrollment_status = NULL
1427: WHERE person_id = l_req_member_rec.person_id
1428: AND bulk_enr_request_id = p_enr_request_id;

Line 1432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '

1428: AND bulk_enr_request_id = p_enr_request_id;
1429: END;
1430:
1431: IF l_lp_enrollment_id IS NOT NULL THEN
1432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1433: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1434: -- update lpe status to bulk_enr_req_members table
1435: UPDATE ota_bulk_enr_req_members
1436: SET enrollment_status = l_path_status_code, error_message = NULL

Line 1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1478: begin
1479: OPEN csr_get_person_name(l_req_member_rec.person_id);
1480: FETCH csr_get_person_name INTO l_person_name;
1481: CLOSE csr_get_person_name;
1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1483:
1484: -- call subscribe for each learning path
1485: OTA_CERT_ENROLLMENT_API.subscribe_to_certification(
1486: p_certification_id => l_request_rec.object_id

Line 1499: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

1495: when others then
1496: l_error_message := fnd_message.get;
1497: fnd_message.clear;
1498: l_error_message := nvl(l_error_message,'Error When creating Certification subscription ');
1499: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1500: UPDATE ota_bulk_enr_req_members
1501: SET error_message = l_error_message, enrollment_status = NULL
1502: WHERE person_id = l_req_member_rec.person_id
1503: AND bulk_enr_request_id = p_enr_request_id;

Line 1507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '

1503: AND bulk_enr_request_id = p_enr_request_id;
1504: END;
1505:
1506: IF l_cert_enrollment_id IS NOT NULL THEN
1507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1508: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1509: -- update lpe status to bulk_enr_req_members table
1510: UPDATE ota_bulk_enr_req_members
1511: SET enrollment_status = l_certification_status_code, error_message = NULL

Line 1589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1585:
1586: OPEN csr_get_person_name(l_req_member_rec.person_id);
1587: FETCH csr_get_person_name INTO l_person_name;
1588: CLOSE csr_get_person_name;
1589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1590:
1591: OPEN csr_get_assignment_info(l_req_member_rec.assignment_id);
1592: FETCH csr_get_assignment_info INTO l_assignment_info;
1593: CLOSE csr_get_assignment_info;

Line 1627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);

1623: OPEN csr_get_booking_status_id(l_booking_id);
1624: FETCH csr_get_booking_status_id INTO l_booking_status_type_id, l_booking_status;
1625: CLOSE csr_get_booking_status_id;
1626:
1627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1628:
1629: UPDATE ota_bulk_enr_req_members
1630: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1631: WHERE person_id = l_req_member_rec.person_id

Line 1636: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

1632: AND assignment_id = l_req_member_rec.assignment_id
1633: AND bulk_enr_request_id = p_enr_request_id;
1634: ELSE
1635: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1636: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1637: UPDATE ota_bulk_enr_req_members
1638: SET error_message = l_error_message, enrollment_status = NULL
1639: WHERE person_id = l_req_member_rec.person_id
1640: AND bulk_enr_request_id = p_enr_request_id;

Line 1775: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1771:
1772: OPEN csr_get_person_name(l_req_member_rec.person_id);
1773: FETCH csr_get_person_name INTO l_person_name;
1774: CLOSE csr_get_person_name;
1775: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1776:
1777: OPEN csr_get_assignment_info(l_req_member_rec.assignment_id);
1778: FETCH csr_get_assignment_info INTO l_assignment_info;
1779: CLOSE csr_get_assignment_info;

Line 1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1820:
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');

Line 1854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

1850: else
1851: -- Call Process save enrollment
1852: --Need to modify this process to update event_id in lp_member_enrollments for an lp_member_enrollment based on personid,activity_version_id and lp_id
1853: --Write another program which perumal will call for lp and class is called
1854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1855: Create_Enrollment_And_Finance(
1856: p_event_id => l_request_rec.object_id
1857: ,p_cost_centers => l_cost_center_info.cost_allocation_keyflex_id
1858: ,p_assignment_id => l_req_member_rec.assignment_id

Line 1885: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);

1881: OPEN csr_get_booking_status_id(l_booking_id);
1882: FETCH csr_get_booking_status_id INTO l_booking_status_type_id, l_booking_status;
1883: CLOSE csr_get_booking_status_id;
1884:
1885: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1886:
1887: UPDATE ota_bulk_enr_req_members
1888: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1889: WHERE person_id = l_req_member_rec.person_id

Line 1903: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

1899: end loop;
1900:
1901: ELSE
1902: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1904: UPDATE ota_bulk_enr_req_members
1905: SET error_message = l_error_message, enrollment_status = NULL
1906: WHERE person_id = l_req_member_rec.person_id
1907: AND bulk_enr_request_id = p_enr_request_id;

Line 2069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Learning Path - ' || l_object_name);

2065: --fnd_concurrent.set_completion_status('ERROR');
2066: ELSIF l_request_rec.object_type = 'LP' THEN
2067: CLOSE csr_get_request_info;
2068:
2069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Learning Path - ' || l_object_name);
2070:
2071: mass_subscribe_to_lp(
2072: p_enr_request_id => p_enr_request_id
2073: ,p_from_conc_program => true);

Line 2078: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Class - ' || l_object_name);

2074:
2075: ELSIF l_request_rec.object_type = 'CL' THEN
2076: CLOSE csr_get_request_info;
2077:
2078: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Class - ' || l_object_name);
2079: mass_subscribe_to_class(
2080: p_enr_request_id => p_enr_request_id
2081: ,p_from_conc_program => true);
2082:

Line 2086: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Certification - ' || l_object_name);

2082:
2083: ELSIF l_request_rec.object_type = 'CRT' THEN
2084: CLOSE csr_get_request_info;
2085:
2086: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Certification - ' || l_object_name);
2087: mass_subscribe_to_cert(
2088: p_enr_request_id => p_enr_request_id
2089: ,p_from_conc_program => true);
2090: ELSE

Line 2101: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

2097:
2098: /*moved for lp enh changes
2099: EXCEPTION
2100: when others then
2101: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2102: ||','||SUBSTR(SQLERRM, 1, 500));*/
2103:
2104:
2105: elsif (p_enr_request_id_end IS NOT NULL) then

Line 2121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollments for the Learning Path - ' || l_object_name);

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
2125: ,p_from_conc_program => true);

Line 2132: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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
2136: ,p_from_conc_program => true);

Line 2133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollments for the Class - ' || l_object_name);

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
2136: ,p_from_conc_program => true);
2137:

Line 2157: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

2153: end if;
2154:
2155: EXCEPTION
2156: when others then
2157: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2158: ||','||SUBSTR(SQLERRM, 1, 500));
2159:
2160: END process_bulk_enrollments;
2161:

Line 2241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

2237: OPEN csr_get_person_name(l_req_member_rec.person_id);
2238: FETCH csr_get_person_name INTO l_person_name;
2239: CLOSE csr_get_person_name;
2240: if(p_debug = 'Y') then
2241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2242: end if;
2243:
2244:
2245: if (l_request_rec.object_type = 'CLU') then

Line 2252: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

2248:
2249: -- Call Process save enrollment
2250: --Need to modify this process to update event_id in lp_member_enrollments for an lp_member_enrollment based on personid,activity_version_id and lp_id
2251: --Write another program which perumal will call for lp and class is called
2252: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2253: ota_tdb_api_upd2.update_enrollment(
2254: p_booking_id => l_booking_id,
2255: p_event_id => p_event_id,
2256: p_failure_reason => p_failure_reason,

Line 2284: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);

2280: OPEN csr_get_booking_status_id(l_booking_id);
2281: FETCH csr_get_booking_status_id INTO l_booking_status_type_id, l_booking_status;
2282: CLOSE csr_get_booking_status_id;
2283: if(p_debug = 'Y') then
2284: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
2285: end if;
2286:
2287: UPDATE ota_bulk_enr_req_members
2288: SET enrollment_status = l_booking_status_type_id, error_message = NULL

Line 2295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

2291: AND bulk_enr_request_id = p_enr_request_id;
2292:
2293: ELSE
2294: --l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
2295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2296: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2297: l_error_message := fnd_message.get;
2298: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2299: UPDATE ota_bulk_enr_req_members

Line 2296: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

2292:
2293: ELSE
2294: --l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
2295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2296: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2297: l_error_message := fnd_message.get;
2298: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2299: UPDATE ota_bulk_enr_req_members
2300: SET error_message = l_error_message

Line 2298: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

2294: --l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
2295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2296: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2297: l_error_message := fnd_message.get;
2298: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2299: UPDATE ota_bulk_enr_req_members
2300: SET error_message = l_error_message
2301: WHERE person_id = l_req_member_rec.person_id
2302: AND bulk_enr_request_id = p_enr_request_id;

Line 2421: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - Request not found with specified request id');

2417:
2418: OPEN csr_get_request_info(p_enr_request_id);
2419: FETCH csr_get_request_info INTO l_request_rec;
2420: IF csr_get_request_info%NOTFOUND THEN
2421: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - Request not found with specified request id');
2422: CLOSE csr_get_request_info;
2423: --fnd_concurrent.set_completion_status('ERROR');
2424: ELSE
2425: CLOSE csr_get_request_info;

Line 2444: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - This request cannot be run with this concurrent program');

2440: p_enrollment_priority => l_enrollment_priority,
2441: p_auth_person_id => l_auth_person_id,
2442: p_debug => p_debug);
2443: else
2444: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - This request cannot be run with this concurrent program');
2445: end if;
2446: --fnd_concurrent.set_completion_status('ERROR');
2447: -- Raise error for unknown object type
2448: END IF;

Line 2457: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

2453: end if;
2454:
2455: EXCEPTION
2456: when others then
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;