189: OPEN c;
190: FETCH c INTO Recinfo;
191: IF ( c%NOTFOUND ) THEN
192: CLOSE c;
193: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END IF;
196: CLOSE C;
197:
234: AND ( x_application_id IS NULL ) ) )
235: ) THEN
236: RETURN;
237: ELSE
238: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
239: APP_EXCEPTION.RAISE_EXCEPTION;
240: END IF;
241:
242: END Lock_Row;
270: WHERE usage_id = x_usage_id;
271:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
275: FND_MESSAGE.SET_TOKEN('RECORD', 'address_usages_rec');
276: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_usage_id));
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
271:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
275: FND_MESSAGE.SET_TOKEN('RECORD', 'address_usages_rec');
276: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_usage_id));
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
275: FND_MESSAGE.SET_TOKEN('RECORD', 'address_usages_rec');
276: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_usage_id));
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279:
280: END Select_Row;