106: OPEN C;
107: FETCH C INTO Recinfo;
108: IF ( C%NOTFOUND ) THEN
109: CLOSE C;
110: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113: CLOSE C;
114:
115: IF ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
116: THEN
117: RETURN;
118: ELSE
119: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122:
123: END Lock_Row;
159: WHERE RULE_DETAIL_ID = X_RULE_DETAIL_ID;
160:
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
164: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_details_rec');
165: FND_MESSAGE.SET_TOKEN( 'VALUE', X_RULE_NAME );
166: FND_MSG_PUB.ADD;
167: RAISE FND_API.G_EXC_ERROR;
160:
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
164: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_details_rec');
165: FND_MESSAGE.SET_TOKEN( 'VALUE', X_RULE_NAME );
166: FND_MSG_PUB.ADD;
167: RAISE FND_API.G_EXC_ERROR;
168: END Select_Row;
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_NO_RECORD' );
164: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_rule_details_rec');
165: FND_MESSAGE.SET_TOKEN( 'VALUE', X_RULE_NAME );
166: FND_MSG_PUB.ADD;
167: RAISE FND_API.G_EXC_ERROR;
168: END Select_Row;
169: