67: OPEN c;
68: FETCH c INTO Recinfo;
69: IF ( c%NOTFOUND ) THEN
70: CLOSE c;
71: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
72: APP_EXCEPTION.RAISE_EXCEPTION;
73: END IF;
74: CLOSE C;
75:
88: AND ( x_address_style IS NULL ) ) )
89: ) THEN
90: RETURN;
91: ELSE
92: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
93: APP_EXCEPTION.RAISE_EXCEPTION;
94: END IF;
95:
96: return;
119: WHERE map_id = x_map_id;
120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
124: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map');
125: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
126: FND_MSG_PUB.ADD;
127: RAISE FND_API.G_EXC_ERROR;
120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
124: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map');
125: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
126: FND_MSG_PUB.ADD;
127: RAISE FND_API.G_EXC_ERROR;
128:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
124: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map');
125: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
126: FND_MSG_PUB.ADD;
127: RAISE FND_API.G_EXC_ERROR;
128:
129: END Select_Row;