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_MESSAGE

Line 700: fnd_message.set_name ('OTA','OTA_NO_DELEGATE_INFORMATION');

696: OPEN csr_get_assignment_details;
697: FETCH csr_get_assignment_details INTO l_person_details;
698: IF csr_get_assignment_details%NOTFOUND THEN
699: CLOSE csr_get_assignment_details;
700: fnd_message.set_name ('OTA','OTA_NO_DELEGATE_INFORMATION');
701: --
702: -- Raise the error for the main procedure exception handler
703: -- to handle
704: p_message_name := SUBSTR(SQLERRM, 1,300);

Line 819: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');

815:
816: END IF;
817: END IF;
818: IF l_booking_status_row.booking_Status_type_id is null then
819: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
820: RAISE ota_learner_enroll_ss.g_mesg_on_stack_exception ;
821: END IF ;
822: END IF;
823:

Line 839: fnd_message.set_name ('OTA','OTA_WEB_INCORRECT_CONF');

835: IF (hr_message.last_message_name = 'OTA_13667_WEB_STATUS_NOT_SEEDE') THEN
836: --
837: -- Seed the user friendly message
838: --
839: fnd_message.set_name ('OTA','OTA_WEB_INCORRECT_CONF');
840: --
841: -- Raise the error for the main procedure exception handler
842: -- to handle
843: --

Line 851: fnd_message.set_name ('OTA','OTA_NO_DELEGATE_INFORMATION');

847: ELSIF (hr_message.last_message_name = 'HR_51396_WEB_PERSON_NOT_FND') THEN
848: --
849: -- Seed the user friendly message
850: --
851: fnd_message.set_name ('OTA','OTA_NO_DELEGATE_INFORMATION');
852: --
853: -- Raise the error for the main procedure exception handler
854: -- to handle
855: p_message_name := 'OTA_NO_DELEGATE_INFORMATION';

Line 876: fnd_message.set_name ('OTA','OTA_WEB_ERR_GETTING_INFO');

872: hr_message.provide_error;
873: --
874: -- Seed the user friendly message
875: --
876: fnd_message.set_name ('OTA','OTA_WEB_ERR_GETTING_INFO');
877: --
878: --
879: -- Raise the error for the main procedure exception handler
880: -- to handle

Line 1130: p_message_name := fnd_message.get;

1126: -- It is OK to use hr_message.provide_error as an application
1127: -- error will have been raised which will have put an error onto
1128: -- the stack
1129: --
1130: p_message_name := fnd_message.get;
1131: --
1132: END; -- End of if p_message is not null
1133:
1134: END IF;

Line 1421: l_error_message := fnd_message.get;

1417: ,p_path_status_code => l_path_status_code);
1418: EXCEPTION
1419: when others then
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

Line 1422: fnd_message.clear;

1418: EXCEPTION
1419: when others then
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

Line 1496: l_error_message := fnd_message.get;

1492: ,p_certification_status_code => l_certification_status_code);
1493:
1494: EXCEPTION
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

Line 1497: fnd_message.clear;

1493:
1494: EXCEPTION
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

Line 1828: fnd_message.set_name ('OTA','OTA_467145_LP_CLASS_ENROLLED');

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);
1831: fnd_message.set_token('LP_NAME',l_lp_name);
1832: l_error_message := fnd_message.get();

Line 1829: fnd_message.set_token('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);
1831: fnd_message.set_token('LP_NAME',l_lp_name);
1832: l_error_message := fnd_message.get();
1833:

Line 1830: fnd_message.set_token('CLASS_NAME',l_class_name);

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);
1831: fnd_message.set_token('LP_NAME',l_lp_name);
1832: l_error_message := fnd_message.get();
1833:
1834:

Line 1831: fnd_message.set_token('LP_NAME',l_lp_name);

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);
1831: fnd_message.set_token('LP_NAME',l_lp_name);
1832: l_error_message := fnd_message.get();
1833:
1834:
1835: -- l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');

Line 1832: l_error_message := fnd_message.get();

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);
1831: fnd_message.set_token('LP_NAME',l_lp_name);
1832: l_error_message := fnd_message.get();
1833:
1834:
1835: -- l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1836: UPDATE ota_bulk_enr_req_members

Line 2297: l_error_message := fnd_message.get;

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
2301: WHERE person_id = l_req_member_rec.person_id