262: RAISE no_data_found;
263: ELSE
264: IF (rec.object_version_number <> X_OBJECT_VERSION_NUMBER ) THEN
265: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
266: fnd_msg_pub.add;
267: raise fnd_api.g_exc_unexpected_error;
268: END IF;
269: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
270: rec.role_id,Ltrim(Rtrim(X_role_id)))