1122: where k.inventory_location_id = p_transfer_to_location_id
1123: and k.organization_id = p_organization_id;
1124: EXCEPTION
1125: WHEN no_data_found THEN
1126: RAISE fnd_api.g_exc_error;
1127: WHEN OTHERS THEN
1128: RAISE fnd_api.g_exc_unexpected_error;
1129: END;
1130: elsif p_wms_task_type = 2 then
1124: EXCEPTION
1125: WHEN no_data_found THEN
1126: RAISE fnd_api.g_exc_error;
1127: WHEN OTHERS THEN
1128: RAISE fnd_api.g_exc_unexpected_error;
1129: END;
1130: elsif p_wms_task_type = 2 then
1131: begin
1132: select concatenated_segments into v_concatenated_segments
1134: where k.inventory_location_id = p_locator_id
1135: and k.organization_id = p_organization_id;
1136: EXCEPTION
1137: WHEN no_data_found THEN
1138: RAISE fnd_api.g_exc_error;
1139: WHEN OTHERS THEN
1140: RAISE fnd_api.g_exc_unexpected_error;
1141: END;
1142: end if;
1136: EXCEPTION
1137: WHEN no_data_found THEN
1138: RAISE fnd_api.g_exc_error;
1139: WHEN OTHERS THEN
1140: RAISE fnd_api.g_exc_unexpected_error;
1141: END;
1142: end if;
1143: end if;
1144: return v_concatenated_segments;