}
// locate the product ID
String productId = null;
try {
List<GenericValue> items = trans.lookupItem(value);
if (items != null) {
ListIterator<GenericValue> it = items.listIterator();
if (it.hasNext()) {
GenericValue product = it.next();
productId = product.getString("productId");