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_FEE_AS_RT_HT_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 112: App_Exception.Raise_Exception;

108: column_name is NULL THEN
109: IF new_references.attendance_mode <> UPPER(new_references.attendance_mode) THEN
110: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:
116: IF upper(Column_Name) = 'ATTENDANCE_TYPE' OR

Line 121: App_Exception.Raise_Exception;

117: column_name is NULL THEN
118: IF new_references.attendance_type <> UPPER(new_references.attendance_type) THEN
119: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124: IF upper(Column_Name) = 'COURSE_CD' OR
125: column_name is NULL THEN

Line 129: App_Exception.Raise_Exception;

125: column_name is NULL THEN
126: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132: IF upper(Column_Name) = 'LOCATION_CD' OR
133: column_name is NULL THEN

Line 137: App_Exception.Raise_Exception;

133: column_name is NULL THEN
134: IF new_references.location_cd <> UPPER(new_references.location_cd) 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:
141: IF upper(Column_Name) = 'LOWER_NRML_RATE_OVRD_IND' OR

Line 146: App_Exception.Raise_Exception;

142: column_name is NULL THEN
143: IF new_references.lower_nrml_rate_ovrd_ind <> 'Y' AND new_references.lower_nrml_rate_ovrd_ind <> 'N'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) = 'CHG_RATE' OR

Line 155: App_Exception.Raise_Exception;

151: column_name is NULL THEN
152: IF new_references.chg_rate < 0 OR new_references.chg_rate > 99999.99 THEN
153: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158:
159: END Check_Constraints;

Line 170: App_Exception.Raise_Exception;

166: NULL;
167: ELSIF NOT IGS_FI_FEE_TYPE_PKG.Get_PK_For_Validation ( new_references.fee_type ) THEN
168: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172:
173: IF (((old_references.person_id = new_references.person_id)) OR
174: ((new_references.person_id IS NULL))) THEN

Line 179: App_Exception.Raise_Exception;

175: NULL;
176: ELSIF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation ( new_references.person_id ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181:
182: END Check_Parent_Existance;
183:

Line 230: App_Exception.Raise_Exception;

226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFARH_PE_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;
233: Close cur_rowid;
234: END GET_FK_IGS_PE_PERSON;

Line 292: App_Exception.Raise_Exception;

288: new_references.start_dt,
289: new_references.hist_start_dt ) THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: Check_Constraints;
295: Check_Parent_Existance;
296: ELSIF (p_action = 'UPDATE') THEN

Line 309: App_Exception.Raise_Exception;

305: new_references.start_dt,
306: new_references.hist_start_dt ) THEN
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: Check_Constraints;
312: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
313: Check_Constraints;

Line 360: app_exception.raise_exception;

356: end if;
357: else
358: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362: Before_DML(
363: p_action=>'INSERT',
364: x_rowid=>X_ROWID,

Line 470: app_exception.raise_exception;

466: if (c1%notfound) then
467: close c1;
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: IGS_GE_MSG_STACK.ADD;
470: app_exception.raise_exception;
471: return;
472: end if;
473: close c1;
474: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 499: app_exception.raise_exception;

495: null;
496: else
497: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
498: IGS_GE_MSG_STACK.ADD;
499: app_exception.raise_exception;
500: end if;
501: return;
502: end LOCK_ROW;
503: procedure UPDATE_ROW (

Line 540: app_exception.raise_exception;

536: end if;
537: else
538: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
539: IGS_GE_MSG_STACK.ADD;
540: app_exception.raise_exception;
541: end if;
542: Before_DML(
543: p_action=>'UPDATE',
544: x_rowid=>X_ROWID,