APPS.IGS_FI_SUB_ELM_RNG_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
54: CLOSE cur_old_ref_values;
55:

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 124: app_exception.raise_exception;

120: new_references.er_id
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: END check_parent_existance;
128:

Line 255: app_exception.raise_exception;

251: )
252: ) THEN
253: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257: check_uniqueness;
258: check_parent_existance;
259: ELSIF (p_action = 'UPDATE') THEN

Line 271: app_exception.raise_exception;

267: )
268: ) THEN
269: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273: check_uniqueness;
274: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
275: check_uniqueness;

Line 325: app_exception.raise_exception;

321: ELSE
322: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
323: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ELM_RNG_PKG.INSERT_ROW');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: END IF;
327:
328: x_sub_er_id := NULL;
329:

Line 419: app_exception.raise_exception;

415: IF (c1%notfound) THEN
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: igs_ge_msg_stack.add;
418: CLOSE c1;
419: app_exception.raise_exception;
420: RETURN;
421: END IF;
422: CLOSE c1;
423:

Line 436: app_exception.raise_exception;

432: NULL;
433: ELSE
434: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438:
439: RETURN;
440:

Line 487: app_exception.raise_exception;

483: ELSE
484: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
485: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ELM_RNG_PKG.UPDATE_ROW');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:
490: before_dml(
491: p_action => 'UPDATE',

Line 618: App_Exception.Raise_Exception;

614: IF ((UPPER (column_name) = 'SUB_RANGE_NUM') OR (column_name IS NULL)) THEN
615: IF ((new_references.SUB_RANGE_NUM < 1) OR (new_references.SUB_RANGE_NUM > 999999)) THEN
616: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
617: IGS_GE_MSG_STACK.ADD;
618: App_Exception.Raise_Exception;
619: END IF;
620: END IF;
621: IF ((UPPER (column_name) = 'SUB_UPPER_RANGE') OR (column_name IS NULL)) THEN
622: IF ((new_references.SUB_UPPER_RANGE < 0) OR (new_references.SUB_UPPER_RANGE > 9999.999)) THEN

Line 625: App_Exception.Raise_Exception;

621: IF ((UPPER (column_name) = 'SUB_UPPER_RANGE') OR (column_name IS NULL)) THEN
622: IF ((new_references.SUB_UPPER_RANGE < 0) OR (new_references.SUB_UPPER_RANGE > 9999.999)) THEN
623: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
624: IGS_GE_MSG_STACK.ADD;
625: App_Exception.Raise_Exception;
626: END IF;
627: END IF;
628: IF ((UPPER (column_name) = 'SUB_CHG_METHOD_CODE') OR (column_name IS NULL)) THEN
629: IF (new_references.sub_chg_method_code NOT IN ('FLATRATE')) THEN

Line 632: App_Exception.Raise_Exception;

628: IF ((UPPER (column_name) = 'SUB_CHG_METHOD_CODE') OR (column_name IS NULL)) THEN
629: IF (new_references.sub_chg_method_code NOT IN ('FLATRATE')) THEN
630: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
631: IGS_GE_MSG_STACK.ADD;
632: App_Exception.Raise_Exception;
633: END IF;
634: END IF;
635: IF ((UPPER (column_name) = 'SUB_LOWER_RANGE') OR (column_name IS NULL)) THEN
636: IF ((new_references.SUB_LOWER_RANGE < 0) OR (new_references.SUB_LOWER_RANGE > 9999.999)) THEN

Line 639: App_Exception.Raise_Exception;

635: IF ((UPPER (column_name) = 'SUB_LOWER_RANGE') OR (column_name IS NULL)) THEN
636: IF ((new_references.SUB_LOWER_RANGE < 0) OR (new_references.SUB_LOWER_RANGE > 9999.999)) THEN
637: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
638: IGS_GE_MSG_STACK.ADD;
639: App_Exception.Raise_Exception;
640: END IF;
641: END IF;
642: END Check_Constraints;
643: