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_H_PKG dependencies on APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

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

Line 85: App_Exception.Raise_Exception;

81: new_references.fee_cat
82: ) THEN
83: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: End Check_Uniqueness;
88:
89: PROCEDURE Check_Constraints (

Line 128: App_Exception.Raise_Exception;

124: IF new_references.FEE_CAL_TYPE <>
125: UPPER(new_references.FEE_CAL_TYPE) Then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131: IF upper(column_name) = 'S_CHG_METHOD_TYPE' OR
132: column_name is null Then

Line 137: App_Exception.Raise_Exception;

133: IF new_references.S_CHG_METHOD_TYPE <>
134: UPPER(new_references.S_CHG_METHOD_TYPE) Then
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
140: IF upper(column_name) = 'S_RELATION_TYPE' OR
141: column_name is null Then

Line 146: App_Exception.Raise_Exception;

142: IF new_references.S_RELATION_TYPE <>
143: UPPER(new_references.S_RELATION_TYPE) Then
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: IF upper(column_name) = 'RANGE_NUMBER' OR

Line 156: App_Exception.Raise_Exception;

152: IF new_references.range_number < 1 OR
153: new_references.range_number > 999999 Then
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:
160: IF upper(column_name) = 'UPPER_RANGE' OR

Line 166: App_Exception.Raise_Exception;

162: IF new_references.upper_range < 0 OR
163: new_references.upper_range > 9999.999 Then
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:
170: IF upper(column_name) = 'LOWER_RANGE' OR

Line 176: App_Exception.Raise_Exception;

172: IF new_references.lower_range < 0 OR
173: new_references.lower_range > 9999.999 Then
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
179:
180: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR

Line 186: App_Exception.Raise_Exception;

182: IF new_references.fee_ci_sequence_number < 1 OR
183: new_references.fee_ci_sequence_number > 999999 Then
184: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188: END IF;
189: END Check_Constraints;
190: PROCEDURE Check_Parent_Existance AS

Line 210: App_Exception.Raise_Exception;

206: new_references.fee_type
207: ) THEN
208: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213: IF (((old_references.fee_type = new_references.fee_type) AND
214: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 228: App_Exception.Raise_Exception;

224: new_references.fee_ci_sequence_number
225: ) THEN
226: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230: END IF;
231: END Check_Parent_Existance;
232: Function Get_PK_For_Validation (

Line 354: App_Exception.Raise_Exception;

350: new_references.hist_start_dt
351: ) THEN
352: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception;
355: END IF;
356: Check_Constraints;
357: Check_Uniqueness;
358: Check_Parent_Existance;

Line 379: App_Exception.Raise_Exception;

375: new_references.hist_start_dt
376: ) THEN
377: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;
381: Check_Constraints;
382: Check_Uniqueness;
383: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 434: app_exception.raise_exception;

430: end if;
431: else
432: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: end if;
436: Before_DML (
437: p_action => 'INSERT',
438: x_rowid => x_rowid,

Line 538: app_exception.raise_exception;

534: if (c1%notfound) then
535: close c1;
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: IGS_GE_MSG_STACK.ADD;
538: app_exception.raise_exception;
539: return;
540: end if;
541: close c1;
542: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 561: app_exception.raise_exception;

557: null;
558: else
559: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
560: IGS_GE_MSG_STACK.ADD;
561: app_exception.raise_exception;
562: end if;
563: return;
564: end LOCK_ROW;
565: procedure UPDATE_ROW (

Line 601: app_exception.raise_exception;

597: end if;
598: else
599: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;
603: Before_DML (
604: p_action => 'UPDATE',
605: x_rowid => x_rowid,