[Home] [Help]
37: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
38: CLOSE cur_old_ref_values;
39: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
40: igs_ge_msg_stack.add;
41: app_exception.raise_exception;
42: RETURN;
43: END IF;
44: CLOSE cur_old_ref_values;
45: -- Populate New Values.
148: )
149: ) THEN
150: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
151: igs_ge_msg_stack.add;
152: app_exception.raise_exception;
153: END IF;
154:
155: ELSIF (p_action = 'DELETE') THEN
156: -- Call all the procedures related to Before Delete.
163: )
164: ) THEN
165: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169: ELSIF (p_action = 'VALIDATE_DELETE') THEN
170: check_child_existance;
171: END IF;
205: END IF;
206: ELSE
207: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211: before_dml(
212: p_action => 'INSERT',
213: x_rowid => x_rowid,
268: IF (c1%notfound) THEN
269: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
270: igs_ge_msg_stack.add;
271: CLOSE c1;
272: app_exception.raise_exception;
273: RETURN;
274: END IF;
275: CLOSE c1;
276: IF (
279: NULL;
280: ELSE
281: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285: RETURN;
286: END lock_row;
287: PROCEDURE update_row (
319: END IF;
320: ELSE
321: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: before_dml(
326: p_action => 'UPDATE',
327: x_rowid => x_rowid,