eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_ELM_RANGE_RT_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43: -- Populate New Values.

Line 89: App_Exception.Raise_Exception;

85: new_references.rate_number,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: -- Validate elements range rate can only be created when the parent records
92: -- (elements_range and fee_ass_rate are not logically deleted).
93: IF IGS_FI_VAL_ERR.finp_val_err_create (

Line 104: App_Exception.Raise_Exception;

100: new_references.rate_number,
101: v_message_name) = FALSE THEN
102: Fnd_Message.Set_Name('IGS',v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107: END BeforeRowInsertUpdateDelete1;
108: -- Trigger description :-

Line 132: App_Exception.Raise_Exception;

128: new_references.create_dt,
129: v_message_name) = FALSE THEN
130: Fnd_Message.Set_Name('IGS',v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135: END AfterStmtInsertUpdate3;
136: PROCEDURE Check_Uniqueness AS

Line 149: App_Exception.Raise_Exception;

145: new_references.fee_cat
146: )) THEN
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: IF (Get_UK2_For_Validation (
152: new_references.err_id
153: )) THEN

Line 156: App_Exception.Raise_Exception;

152: new_references.err_id
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: END Check_Uniqueness;
159: PROCEDURE Check_Constraints (
160: column_name IN VARCHAR2 DEFAULT NULL,

Line 192: App_Exception.Raise_Exception;

188: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
189: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN
190: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194: END IF;
195: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
196: IF (new_references.s_relation_type NOT IN ('FCFL', 'FTCI')) THEN

Line 199: App_Exception.Raise_Exception;

195: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
196: IF (new_references.s_relation_type NOT IN ('FCFL', 'FTCI')) THEN
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
203: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN

Line 206: App_Exception.Raise_Exception;

202: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
203: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
204: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209: IF ((UPPER (column_name) = 'RANGE_NUMBER') OR (column_name IS NULL)) THEN
210: IF ((new_references.range_number < 1) OR (new_references.range_number > 999999)) THEN

Line 213: App_Exception.Raise_Exception;

209: IF ((UPPER (column_name) = 'RANGE_NUMBER') OR (column_name IS NULL)) THEN
210: IF ((new_references.range_number < 1) OR (new_references.range_number > 999999)) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216: IF ((UPPER (column_name) = 'RATE_NUMBER') OR (column_name IS NULL)) THEN
217: IF ((new_references.rate_number < 1) OR (new_references.rate_number > 999999999)) THEN

Line 220: App_Exception.Raise_Exception;

216: IF ((UPPER (column_name) = 'RATE_NUMBER') OR (column_name IS NULL)) THEN
217: IF ((new_references.rate_number < 1) OR (new_references.rate_number > 999999999)) THEN
218: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
219: IGS_GE_MSG_STACK.ADD;
220: App_Exception.Raise_Exception;
221: END IF;
222: END IF;
223: END Check_Constraints;
224: PROCEDURE Check_Parent_Existance AS

Line 250: App_Exception.Raise_Exception;

246: new_references.fee_cat
247: ) THEN
248: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;
253: IF (((old_references.fee_type = new_references.fee_type) AND
254: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 277: App_Exception.Raise_Exception;

273: new_references.fee_cat
274: ) THEN
275: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: END IF;
279: END IF;
280: END Check_Parent_Existance;
281: FUNCTION Get_PK_For_Validation (

Line 381: App_Exception.Raise_Exception;

377: IF (cur_rowid%FOUND) THEN
378: Close cur_rowid;
379: Fnd_Message.Set_Name ('IGS', 'IGS_FI_ERR_ER_UK_FK');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: Return;
383: END IF;
384: Close cur_rowid;
385: END GET_UFK_IGS_FI_ELM_RANGE;

Line 411: App_Exception.Raise_Exception;

407: IF (cur_rowid%FOUND) THEN
408: Close cur_rowid;
409: Fnd_Message.Set_Name ('IGS', 'IGS_FI_ERR_FAR_UK_FK');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: Return;
413: END IF;
414: Close cur_rowid;
415: END GET_UFK_IGS_FI_FEE_AS_RATE;

Line 463: App_Exception.Raise_Exception;

459: new_references.err_id
460: )) THEN
461: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
462: IGS_GE_MSG_STACK.ADD;
463: App_Exception.Raise_Exception;
464: END IF;
465: Check_Uniqueness;
466: Check_Constraints;
467: Check_Parent_Existance;

Line 483: App_Exception.Raise_Exception;

479: new_references.err_id
480: )) THEN
481: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception;
484: END IF;
485: Check_Uniqueness;
486: Check_Constraints;
487: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 557: app_exception.raise_exception;

553: end if;
554: else
555: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
556: IGS_GE_MSG_STACK.ADD;
557: app_exception.raise_exception;
558: end if;
559: SELECT IGS_FI_ELM_RANGE_RT_ERR_ID_S.NextVal
560: INTO x_ERR_ID
561: FROM dual;

Line 668: app_exception.raise_exception;

664: if (c1%notfound) then
665: close c1;
666: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
667: IGS_GE_MSG_STACK.ADD;
668: app_exception.raise_exception;
669: return;
670: end if;
671: close c1;
672: if ( (tlinfo.FEE_CAL_TYPE = X_FEE_CAL_TYPE)

Line 690: app_exception.raise_exception;

686: null;
687: else
688: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
689: IGS_GE_MSG_STACK.ADD;
690: app_exception.raise_exception;
691: end if;
692: return;
693: end LOCK_ROW;
694: procedure UPDATE_ROW (

Line 743: app_exception.raise_exception;

739: end if;
740: else
741: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
742: IGS_GE_MSG_STACK.ADD;
743: app_exception.raise_exception;
744: end if;
745: Before_DML(
746: p_action=>'UPDATE',
747: x_rowid=>X_ROWID,