260: OPEN c;
261: FETCH c INTO Recinfo;
262: IF ( c%NOTFOUND ) THEN
263: CLOSE c;
264: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
265: APP_EXCEPTION.RAISE_EXCEPTION;
266: END IF;
267: CLOSE C;
268:
317: AND ( x_request_id IS NULL ) ) )
318: ) THEN
319: RETURN;
320: ELSE
321: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
322: APP_EXCEPTION.RAISE_EXCEPTION;
323: END IF;
324:
325: for tlinfo in c1 loop
328: OR ((tlinfo.GEOGRAPHY_TYPE_NAME is null) AND (X_GEOGRAPHY_TYPE_NAME is null)))
329: ) then
330: null;
331: else
332: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
333: app_exception.raise_exception;
334: end if;
335: end if;
336: end loop;
369: WHERE geography_type = x_geography_type;
370:
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
374: FND_MESSAGE.SET_TOKEN('RECORD', 'geography');
375: FND_MESSAGE.SET_TOKEN('VALUE', x_geography_type);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
370:
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
374: FND_MESSAGE.SET_TOKEN('RECORD', 'geography');
375: FND_MESSAGE.SET_TOKEN('VALUE', x_geography_type);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378:
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
374: FND_MESSAGE.SET_TOKEN('RECORD', 'geography');
375: FND_MESSAGE.SET_TOKEN('VALUE', x_geography_type);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378:
379: END Select_Row;