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 1336: fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);

1332: FROM fnd_user
1333: WHERE employee_id=l_person_id
1334: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')) --Bug 5676892
1335: AND ROWNUM =1 ;
1336: fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);
1337: IF l_person_full_name IS NOT NULL then
1338: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'EVENT_OWNER',l_user_name);
1339: END IF;
1340: END IF;

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

1397: begin
1398: OPEN csr_get_person_name(l_req_member_rec.person_id);
1399: FETCH csr_get_person_name INTO l_person_name;
1400: CLOSE csr_get_person_name;
1401: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1402:
1403: -- call subscribe for each learning path
1404: ota_lp_enrollment_api.subscribe_to_learning_path(
1405: p_learning_path_id => l_request_rec.object_id

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

1414:
1415: l_error_message := fnd_message.get;
1416: fnd_message.clear;
1417: l_error_message := nvl(l_error_message,'Error When creating Learning Path subscription ');
1418: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1419: UPDATE ota_bulk_enr_req_members
1420: SET error_message = l_error_message, enrollment_status = NULL
1421: WHERE person_id = l_req_member_rec.person_id
1422: AND bulk_enr_request_id = p_enr_request_id;

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

1422: AND bulk_enr_request_id = p_enr_request_id;
1423: END;
1424:
1425: IF l_lp_enrollment_id IS NOT NULL THEN
1426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1427: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1428: -- update lpe status to bulk_enr_req_members table
1429: UPDATE ota_bulk_enr_req_members
1430: SET enrollment_status = l_path_status_code, error_message = NULL

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

1472: begin
1473: OPEN csr_get_person_name(l_req_member_rec.person_id);
1474: FETCH csr_get_person_name INTO l_person_name;
1475: CLOSE csr_get_person_name;
1476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1477:
1478: -- call subscribe for each learning path
1479: OTA_CERT_ENROLLMENT_API.subscribe_to_certification(
1480: p_certification_id => l_request_rec.object_id

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

1489: when others then
1490: l_error_message := fnd_message.get;
1491: fnd_message.clear;
1492: l_error_message := nvl(l_error_message,'Error When creating Certification subscription ');
1493: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1494: UPDATE ota_bulk_enr_req_members
1495: SET error_message = l_error_message, enrollment_status = NULL
1496: WHERE person_id = l_req_member_rec.person_id
1497: AND bulk_enr_request_id = p_enr_request_id;

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

1497: AND bulk_enr_request_id = p_enr_request_id;
1498: END;
1499:
1500: IF l_cert_enrollment_id IS NOT NULL THEN
1501: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1502: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1503: -- update lpe status to bulk_enr_req_members table
1504: UPDATE ota_bulk_enr_req_members
1505: SET enrollment_status = l_certification_status_code, error_message = NULL

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

1577:
1578: OPEN csr_get_person_name(l_req_member_rec.person_id);
1579: FETCH csr_get_person_name INTO l_person_name;
1580: CLOSE csr_get_person_name;
1581: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1582:
1583: OPEN csr_get_assignment_info(l_req_member_rec.assignment_id);
1584: FETCH csr_get_assignment_info INTO l_assignment_info;
1585: CLOSE csr_get_assignment_info;

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

1615: OPEN csr_get_booking_status_id(l_booking_id);
1616: FETCH csr_get_booking_status_id INTO l_booking_status_type_id, l_booking_status;
1617: CLOSE csr_get_booking_status_id;
1618:
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1620:
1621: UPDATE ota_bulk_enr_req_members
1622: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1623: WHERE person_id = l_req_member_rec.person_id

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

1624: AND assignment_id = l_req_member_rec.assignment_id
1625: AND bulk_enr_request_id = p_enr_request_id;
1626: ELSE
1627: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1629: UPDATE ota_bulk_enr_req_members
1630: SET error_message = l_error_message, enrollment_status = NULL
1631: WHERE person_id = l_req_member_rec.person_id
1632: AND bulk_enr_request_id = p_enr_request_id;

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

1729: --fnd_concurrent.set_completion_status('ERROR');
1730: ELSIF l_request_rec.object_type = 'LP' THEN
1731: CLOSE csr_get_request_info;
1732:
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Learning Path - ' || l_object_name);
1734:
1735: mass_subscribe_to_lp(
1736: p_enr_request_id => p_enr_request_id
1737: ,p_from_conc_program => true);

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

1738:
1739: ELSIF l_request_rec.object_type = 'CL' THEN
1740: CLOSE csr_get_request_info;
1741:
1742: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Class - ' || l_object_name);
1743: mass_subscribe_to_class(
1744: p_enr_request_id => p_enr_request_id
1745: ,p_from_conc_program => true);
1746:

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

1746:
1747: ELSIF l_request_rec.object_type = 'CRT' THEN
1748: CLOSE csr_get_request_info;
1749:
1750: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing Bulk Enrollment for the Certification - ' || l_object_name);
1751: mass_subscribe_to_cert(
1752: p_enr_request_id => p_enr_request_id
1753: ,p_from_conc_program => true);
1754: ELSE

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

1760: commit;
1761:
1762: EXCEPTION
1763: when others then
1764: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1765: ||','||SUBSTR(SQLERRM, 1, 500));
1766:
1767: END process_bulk_enrollments;
1768: