207: OPEN c;
208: FETCH c INTO Recinfo;
209: IF ( c%NOTFOUND ) THEN
210: CLOSE c;
211: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
212: APP_EXCEPTION.RAISE_EXCEPTION;
213: END IF;
214: CLOSE C;
215:
270: AND ( x_request_id IS NULL ) ) )
271: ) THEN
272: RETURN;
273: ELSE
274: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
275: APP_EXCEPTION.RAISE_EXCEPTION;
276: END IF;
277:
278: END Lock_Row;
317: AND parent_geography_type = x_parent_geography_type;
318:
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'geo_structure_levels_rec');
323: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
318:
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'geo_structure_levels_rec');
323: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326:
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'geo_structure_levels_rec');
323: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326:
327: END Select_Row;