50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:
176: )
177: ) THEN
178: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182: ELSIF (p_action = 'VALIDATE_INSERT') THEN
183: -- Call all the procedures related to Before Insert.
184: IF ( get_pk_for_validation (
186: )
187: ) THEN
188: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: END IF;
192: END IF;
193:
194: END before_dml;
256: ELSE
257: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
258: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.INSERT_ROW');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262:
263: x_awdh_id := NULL;
264:
373: IF (c1%notfound) THEN
374: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
375: igs_ge_msg_stack.add;
376: CLOSE c1;
377: app_exception.raise_exception;
378: RETURN;
379: END IF;
380: CLOSE c1;
381:
393: NULL;
394: ELSE
395: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: RETURN;
401:
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: before_dml(
459: p_action => 'UPDATE',