53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
60: CLOSE cur_old_ref_values;
61:
108: new_references.fee_ass_item_id
109: ) THEN
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114:
115: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND
116: (old_references.us_version_number = new_references.us_version_number)) OR
122: new_references.us_version_number
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: IF (((old_references.uoo_id = new_references.uoo_id)) OR
130: ((new_references.uoo_id IS NULL))) THEN
133: new_references.uoo_id
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: END check_parent_existance;
141:
238: )
239: ) THEN
240: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
241: igs_ge_msg_stack.add;
242: app_exception.raise_exception;
243: END IF;
244: check_parent_existance;
245: ELSIF (p_action = 'UPDATE') THEN
246: -- Call all the procedures related to Before Update.
252: )
253: ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
259:
260: END before_dml;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.INSERT_ROW');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:
316: x_fee_as_item_dtl_id := NULL;
317:
433: IF (c1%notfound) THEN
434: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
435: igs_ge_msg_stack.add;
436: CLOSE c1;
437: app_exception.raise_exception;
438: RETURN;
439: END IF;
440: CLOSE c1;
441:
456: NULL;
457: ELSE
458: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:
463: RETURN;
464:
513: ELSE
514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
515: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.UPDATE_ROW');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:
520: before_dml(
521: p_action => 'UPDATE',