149: AND object_version_number = p_object_version_number;
150:
151: IF (SQL%NOTFOUND) THEN
152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
153: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
154: FND_MSG_PUB.add;
155: END IF;
156: RAISE FND_API.g_exc_error;
157: END IF;
190: AND object_version_number = p_object_version_number;
191:
192: IF (SQL%NOTFOUND) THEN
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: END IF;
238: OPEN c;
239: FETCH c INTO Recinfo;
240: If (c%NOTFOUND) then
241: CLOSE c;
242: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: END IF;
245: CLOSE C;
246: IF (
280: AND ( p_creation_date IS NULL )))
281: ) THEN
282: RETURN;
283: ELSE
284: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
285: APP_EXCEPTION.RAISE_EXCEPTION;
286: END IF;
287: END Lock_Row;
288: