236: OPEN c;
237: FETCH c INTO Recinfo;
238: IF ( c%NOTFOUND ) THEN
239: CLOSE c;
240: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
241: APP_EXCEPTION.RAISE_EXCEPTION;
242: END IF;
243: CLOSE C;
244:
308: AND ( x_request_id IS NULL ) ) )
309: ) THEN
310: RETURN;
311: ELSE
312: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
313: APP_EXCEPTION.RAISE_EXCEPTION;
314: END IF;
315:
316: END Lock_Row;
364: AND start_date = x_start_date;
365:
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
369: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_ranges_rec');
370: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
365:
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
369: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_ranges_rec');
370: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373:
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
369: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_ranges_rec');
370: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373:
374: END Select_Row;