32: if X_LAST_UPDATE_LOGIN is NULL then
33: X_LAST_UPDATE_LOGIN := -1;
34: end if;
35: else
36: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
37: app_exception.raise_exception;
38: end if;
39:
40: insert into IGW_PROP_LOCATIONS (
120: if X_LAST_UPDATE_LOGIN is NULL then
121: X_LAST_UPDATE_LOGIN := -1;
122: end if;
123: else
124: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
125: app_exception.raise_exception;
126: end if;
127:
128: update IGW_PROP_LOCATIONS set
136: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
137:
138:
139: if (sql%notfound) then
140: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
141: FND_MSG_PUB.Add;
142: X_RETURN_STATUS := 'E';
143: end if;
144: EXCEPTION
183: where ROWID = L_ROW_ID
184: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
185:
186: if (sql%notfound) then
187: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
188: FND_MSG_PUB.Add;
189: X_RETURN_STATUS := 'E';
190: end if;
191: