122: OPEN c;
123: FETCH c INTO Recinfo;
124: IF ( c%NOTFOUND ) THEN
125: CLOSE c;
126: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
127: APP_EXCEPTION.RAISE_EXCEPTION;
128: END IF;
129: CLOSE C;
130:
143: AND ( x_geography_type IS NULL ) ) )
144: ) THEN
145: RETURN;
146: ELSE
147: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
148: APP_EXCEPTION.RAISE_EXCEPTION;
149: END IF;
150:
151: return;
175: WHERE map_id = x_map_id;
176:
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN
179: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
180: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map dtl');
181: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
176:
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN
179: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
180: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map dtl');
181: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184:
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN
179: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
180: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map dtl');
181: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184:
185: END Select_Row;