233: OPEN C;
234: FETCH C INTO Recinfo;
235: IF ( C%NOTFOUND ) THEN
236: CLOSE C;
237: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
238: APP_EXCEPTION.RAISE_EXCEPTION;
239: END IF;
240: CLOSE C;
241:
317: AND ( X_ACTUAL_CONTENT_SOURCE IS NULL ) ) )
318: ) THEN
319: RETURN;
320: ELSE
321: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
322: APP_EXCEPTION.RAISE_EXCEPTION;
323: END IF;
324:
325: END Lock_Row;
393: WHERE CODE_ASSIGNMENT_ID = X_CODE_ASSIGNMENT_ID;
394:
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
398: FND_MESSAGE.SET_TOKEN( 'RECORD', 'code_assignment_rec');
399: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CODE_ASSIGNMENT_ID ) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
394:
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
398: FND_MESSAGE.SET_TOKEN( 'RECORD', 'code_assignment_rec');
399: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CODE_ASSIGNMENT_ID ) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402:
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
398: FND_MESSAGE.SET_TOKEN( 'RECORD', 'code_assignment_rec');
399: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CODE_ASSIGNMENT_ID ) );
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402:
403: END Select_Row;