280: SELECT
281: TERRITORY_SHORT_NAME
282: INTO L_SHIP_TO_COUNTRY_NAME
283: FROM
284: FND_TERRITORIES_VL
285: WHERE TERRITORY_CODE = SHIP_TO_COUNTRY;
286: RETURN L_SHIP_TO_COUNTRY_NAME;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
295: SELECT
296: TERRITORY_SHORT_NAME
297: INTO L_DEL_TO_COUNTRY_NAME
298: FROM
299: FND_TERRITORIES_VL
300: WHERE TERRITORY_CODE = DEL_TO_COUNTRY;
301: RETURN L_DEL_TO_COUNTRY_NAME;
302: EXCEPTION
303: WHEN NO_DATA_FOUND THEN