131: AND object_version_number = p_object_version_number;
132:
133: IF (SQL%NOTFOUND) THEN
134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
135: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
136: FND_MSG_PUB.add;
137: END IF;
138: RAISE FND_API.g_exc_error;
139: END IF;
167: AND object_version_number = p_object_version_number;
168:
169: IF (SQL%NOTFOUND) THEN
170: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
171: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
172: FND_MSG_PUB.add;
173: END IF;
174: RAISE FND_API.g_exc_error;
175: END IF;
217: OPEN c;
218: FETCH c INTO Recinfo;
219: If (c%NOTFOUND) then
220: CLOSE c;
221: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
222: APP_EXCEPTION.RAISE_EXCEPTION;
223: END IF;
224: CLOSE C;
225: IF (
256: AND ( px_object_version_number IS NULL )))
257: ) THEN
258: RETURN;
259: ELSE
260: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
261: APP_EXCEPTION.RAISE_EXCEPTION;
262: END IF;
263: END Lock_Row;
264: