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 818: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');

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

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

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

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

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

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

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

Line 1127: p_message_name := fnd_message.get;

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

Line 1415: l_error_message := fnd_message.get;

1411: ,p_path_status_code => l_path_status_code);
1412: EXCEPTION
1413: when others then
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

Line 1416: fnd_message.clear;

1412: EXCEPTION
1413: when others then
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

Line 1490: l_error_message := fnd_message.get;

1486: ,p_certification_status_code => l_certification_status_code);
1487:
1488: EXCEPTION
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

Line 1491: fnd_message.clear;

1487:
1488: EXCEPTION
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