59: OPEN cur_old_ref_values;
60: FETCH cur_old_ref_values INTO old_references;
61: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
62: CLOSE cur_old_ref_values;
63: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
64: igs_ge_msg_stack.add;
65: app_exception.raise_exception;
66: RETURN;
67: END IF;
220: FETCH cur_impchgs_lines INTO l_var;
221: IF cur_impchgs_lines%FOUND THEN
222: IF NOT l_bool THEN
223: CLOSE cur_impchgs_lines;
224: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMPCHGS_LINES_EXISTS');
225: --'Update of this record is not allowed since Ancillary Charges exist for these attributes and rate'
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
253: );
254: FETCH cur_impchgs_lines INTO l_var;
255: IF cur_impchgs_lines%FOUND THEN
256: CLOSE cur_impchgs_lines;
257: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMP_CHGS_EXISTS');
258: --'Deletion of this record is not allowed since Ancillary Charges exist for these attributes'
259: IGS_GE_MSG_STACK.ADD;
260: APP_EXCEPTION.RAISE_EXCEPTION;
261: END IF;
297: new_references.ancillary_attribute15,
298: new_references.enabled_flag
299: )
300: ) THEN
301: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
329: new_references.fee_type,
330: new_references.fee_cal_type,
331: new_references.fee_ci_sequence_number
332: ) THEN
333: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
521: IF ( get_pk_for_validation(
522: new_references.ancillary_rate_id
523: )
524: ) THEN
525: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529: check_uniqueness;
538: IF ( get_pk_for_validation (
539: new_references.ancillary_rate_id
540: )
541: ) THEN
542: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546: check_uniqueness;
614: IF (x_last_update_login IS NULL) THEN
615: x_last_update_login := -1;
616: END IF;
617: ELSE
618: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
619: igs_ge_msg_stack.add;
620: app_exception.raise_exception;
621: END IF;
622: SELECT IGS_FI_ANC_RATES_S.NEXTVAL INTO x_ancillary_rate_id FROM DUAL;
786:
787: OPEN c1;
788: FETCH c1 INTO tlinfo;
789: IF (c1%notfound) THEN
790: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
791: igs_ge_msg_stack.add;
792: CLOSE c1;
793: app_exception.raise_exception;
794: RETURN;
818: AND ((tlinfo.enabled_flag = x_enabled_flag) OR ((tlinfo.enabled_flag IS NULL) AND (X_enabled_flag IS NULL)))
819: ) THEN
820: NULL;
821: ELSE
822: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
823: igs_ge_msg_stack.add;
824: app_exception.raise_exception;
825: END IF;
826:
883: IF (x_last_update_login IS NULL) THEN
884: x_last_update_login := -1;
885: END IF;
886: ELSE
887: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
888: igs_ge_msg_stack.add;
889: app_exception.raise_exception;
890: END IF;
891: