241: OPEN c;
242: FETCH c INTO Recinfo;
243: IF ( c%NOTFOUND ) THEN
244: CLOSE c;
245: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
246: APP_EXCEPTION.RAISE_EXCEPTION;
247: END IF;
248: CLOSE C;
249:
313: AND ( x_request_id IS NULL ) ) )
314: ) THEN
315: RETURN;
316: ELSE
317: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
318: APP_EXCEPTION.RAISE_EXCEPTION;
319: END IF;
320:
321: END Lock_Row;
372:
373:
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN
376: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
377: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_identifiers_rec');
378: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
373:
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN
376: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
377: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_identifiers_rec');
378: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381:
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN
376: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
377: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_identifiers_rec');
378: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381:
382: END Select_Row;