35: OPEN cur_old_ref_values;
36: FETCH cur_old_ref_values INTO old_references;
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;
146: new_references.responsibility_id,
147: new_references.form_code
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:
161: new_references.responsibility_id,
162: new_references.form_code
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
203: IF (x_last_update_login IS NULL) THEN
204: x_last_update_login := -1;
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(
265: BEGIN
266: OPEN c1;
267: FETCH c1 INTO tlinfo;
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;
277: (tlinfo.query_only_ind = x_query_only_ind)
278: ) THEN
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;
317: IF (x_last_update_login IS NULL) THEN
318: x_last_update_login := -1;
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(