1192: where k.inventory_location_id = p_transfer_to_location_id
1193: and k.organization_id = p_organization_id;
1194: EXCEPTION
1195: WHEN no_data_found THEN
1196: RAISE fnd_api.g_exc_error;
1197: WHEN OTHERS THEN
1198: RAISE fnd_api.g_exc_unexpected_error;
1199: END;
1200: elsif p_wms_task_type = 2 then
1194: EXCEPTION
1195: WHEN no_data_found THEN
1196: RAISE fnd_api.g_exc_error;
1197: WHEN OTHERS THEN
1198: RAISE fnd_api.g_exc_unexpected_error;
1199: END;
1200: elsif p_wms_task_type = 2 then
1201: begin
1202: select concatenated_segments into v_concatenated_segments
1204: where k.inventory_location_id = p_locator_id
1205: and k.organization_id = p_organization_id;
1206: EXCEPTION
1207: WHEN no_data_found THEN
1208: RAISE fnd_api.g_exc_error;
1209: WHEN OTHERS THEN
1210: RAISE fnd_api.g_exc_unexpected_error;
1211: END;
1212: end if;
1206: EXCEPTION
1207: WHEN no_data_found THEN
1208: RAISE fnd_api.g_exc_error;
1209: WHEN OTHERS THEN
1210: RAISE fnd_api.g_exc_unexpected_error;
1211: END;
1212: end if;
1213: end if;
1214: return v_concatenated_segments;