72: if X_LAST_UPDATE_LOGIN is NULL then
73: X_LAST_UPDATE_LOGIN := -1;
74: end if;
75: else
76: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
77: app_exception.raise_exception;
78: end if;
79: insert into IGW_PROPOSALS_ALL (
80: SPONSOR_ACTION_CODE,
234: where rowid = l_row_id
235: and record_version_number = p_record_version_number;
236:
237: if (sql%notfound) then
238: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
239: FND_MSG_PUB.Add;
240: end if;
241: EXCEPTION
242: WHEN OTHERS THEN
293: if X_LAST_UPDATE_LOGIN is NULL then
294: X_LAST_UPDATE_LOGIN := -1;
295: end if;
296: else
297: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
298: app_exception.raise_exception;
299: end if;
300:
301: update IGW_PROPOSALS_ALL set
309: where rowid = l_row_id
310: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
311:
312: if (sql%notfound) then
313: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
314: FND_MSG_PUB.Add;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: end if;
317: