[Home] [Help]
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
151: new_references.cus_id
152: )
153: ) THEN
154: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: END IF;
158: ELSIF (p_action = 'VALIDATE_INSERT') THEN
159: -- Call all the procedures related to Before Insert.
161: new_references.cus_id
162: )
163: ) THEN
164: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168: END IF;
169:
225: x_last_update_login := -1;
226: END IF;
227: ELSE
228: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232:
233: SELECT igs_pt_custm_s.NEXTVAL
354: OPEN c1;
355: FETCH c1 INTO tlinfo;
356: IF (c1%notfound) THEN
357: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
358: igs_ge_msg_stack.add;
359: CLOSE c1;
360: app_exception.raise_exception;
361: RETURN;
362: END IF;
369: ) THEN
370: NULL;
371: ELSE
372: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:
377: -- Initialize API return status to success.
454: x_last_update_login := -1;
455: END IF;
456: ELSE
457: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: END IF;
461:
462: before_dml(