121: l_wh_update_date
122: , l_actual_content_source
123: , l_date_validated
124: , l_validation_status_code
125: FROM HZ_LOCATIONS
126: WHERE location_id = p_location_id
127: FOR UPDATE OF location_id NOWAIT;
128:
129: EXCEPTION WHEN NO_DATA_FOUND THEN
127: FOR UPDATE OF location_id NOWAIT;
128:
129: EXCEPTION WHEN NO_DATA_FOUND THEN
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
131: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
132: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
133: FND_MSG_PUB.ADD;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
148: l_attribute1,l_attribute2,l_attribute3,l_attribute4,l_attribute5,
149: l_attribute6,l_attribute7,l_attribute8,l_attribute9,l_attribute10,
150: l_wh_update_date
151: , l_actual_content_source
152: FROM HZ_LOCATIONS
153: WHERE location_id = p_location_id;
154:
155: EXCEPTION WHEN NO_DATA_FOUND THEN
156: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
153: WHERE location_id = p_location_id;
154:
155: EXCEPTION WHEN NO_DATA_FOUND THEN
156: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
157: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
158: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
159: FND_MSG_PUB.ADD;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161:
258: AND db_attribute10 = l_attribute10 THEN
259:
260: NULL;
261: ELSE
262: UPDATE hz_locations SET
263: country = l_country,
264: city = l_city ,
265: state = l_state ,
266: county = l_county ,