170: || p_server_group_name || ' not found';
171: x_msg_count := 1;
172:
173: select server_group_id into l_server_group_id
174: from ieo_svr_groups where group_name = p_server_group_name;
175:
176: x_msg_data := 'GET_DEVICE_LOCATION: device not found '
177: || ' media_type = ' || p_media_type
178: || ' device_type = ' || p_device_type
272: x_msg_count := 1;
273: x_server_id := null;
274:
275: select server_group_id into l_server_group_id
276: from ieo_svr_groups where group_name = p_server_group_name;
277:
278: x_msg_data := 'IEO_SVR_UTIL_PVT.LOCATE_LEAST_LOADED_IN_GROUP failed';
279:
280: IEO_SVR_UTIL_PVT.LOCATE_LEAST_LOADED_IN_GROUP
378: x_msg_count := 1;
379: x_server_id := null;
380:
381: select server_group_id into l_server_group_id
382: from ieo_svr_groups where group_name = p_server_group_name;
383:
384: x_msg_data := 'IEO_SVR_UTIL_PVT.LOCATE_BY_MINOR_LOAD failed';
385:
386: IEO_SVR_UTIL_PVT.LOCATE_BY_MINOR_LOAD
482: x_msg_count := 1;
483: x_server_id := null;
484:
485: select server_group_id into l_server_group_id
486: from ieo_svr_groups where group_name = p_server_group_name;
487:
488: x_msg_data := 'IEO_SVR_UTIL_PVT.LOCATE_BY_MAJOR_LOAD failed';
489:
490: IEO_SVR_UTIL_PVT.LOCATE_BY_MAJOR_LOAD