return aTranslator.translateToZipDTO(theZipDetails);
}
public String getStateAbbv(String pStateName) throws PersistenceException {
Stateabbv entity = null;
try {
EventLogger.getInstance().info("State is " + pStateName);
String aQuery = "select s from Stateabbv s where upper(trim(s.name)) = '" + pStateName.toUpperCase() + "' " ;
Query aQueryObject = manager.createQuery(aQuery);
entity = (Stateabbv)aQueryObject.getSingleResult();
}
catch(Exception pException) {
throw new PersistenceException("State does not exist");
}
return entity.getAbbv();
}