117: OPEN C;
118: FETCH C INTO Recinfo;
119: IF ( C%NOTFOUND ) THEN
120: CLOSE C;
121: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
122: APP_EXCEPTION.RAISE_EXCEPTION;
123: END IF;
124: CLOSE C;
125:
171: AND ( X_APPLICATION_ID IS NULL ) ) )
172: ) THEN
173: RETURN;
174: ELSE
175: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
176: APP_EXCEPTION.RAISE_EXCEPTION;
177: END IF;
178:
179: END Lock_Row;
206: AND ORG_ID = X_ORG_ID;
207:
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
211: FND_MESSAGE.SET_TOKEN( 'RECORD', 'loc_assignment_rec');
212: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_LOCATION_ID ) );
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
207:
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
211: FND_MESSAGE.SET_TOKEN( 'RECORD', 'loc_assignment_rec');
212: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_LOCATION_ID ) );
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215:
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
211: FND_MESSAGE.SET_TOKEN( 'RECORD', 'loc_assignment_rec');
212: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_LOCATION_ID ) );
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215:
216: END Select_Row;