39: if l_last_update_login is NULL then
40: l_last_update_login := -1;
41: end if;
42: else
43: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
44: app_exception.raise_exception;
45: end if;
46:
47: insert into igw_prop_user_roles (
119: if l_last_update_login is NULL then
120: l_last_update_login := -1;
121: end if;
122: else
123: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
124: app_exception.raise_exception;
125: end if;
126:
127: update IGW_PROP_USER_ROLES set
135: where rowid = x_rowid
136: and record_version_number = p_record_version_number;
137:
138: if (sql%notfound) then
139: fnd_message.set_name('IGW', 'IGW_SS_RECORD_CHANGED');
140: fnd_msg_pub.Add;
141: x_return_status := 'E';
142: end if;
143:
165: where rowid = x_rowid
166: and record_version_number = p_record_version_number;
167:
168: if (sql%notfound) then
169: fnd_message.set_name('IGW', 'IGW_SS_RECORD_CHANGED');
170: fnd_msg_pub.Add;
171: x_return_status := 'E';
172: end if;
173:
257: begin
258: open c1;
259: fetch c1 into tlinfo;
260: if (c1%notfound) then
261: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
262: app_exception.raise_exception;
263: close c1;
264: return;
265: end if;
285: AND (X_END_DATE_ACTIVE is null)))
286: ) then
287: null;
288: else
289: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
290: app_exception.raise_exception;
291: end if;
292: return;
293: end LOCK_ROW;