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

Line 69: App_Exception.Raise_Exception;

65: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
66: Close cur_old_ref_values;
67: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
68: IGS_GE_MSG_STACK.ADD;
69: App_Exception.Raise_Exception;
70: Return;
71: END IF;
72: Close cur_old_ref_values;
73: -- Populate New Values.

Line 130: App_Exception.Raise_Exception;

126: new_references.fee_cat
127: ) THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: End Check_Uniqueness;
133:
134:

Line 210: App_Exception.Raise_Exception;

206: column_name is null Then
207: IF new_references.chg_rate < 0 Then
208: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR
214: column_name is null Then

Line 219: App_Exception.Raise_Exception;

215: IF new_references.fee_ci_sequence_number < 1 OR
216: new_references.fee_ci_sequence_number > 999999 Then
217: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception;
220: END IF;
221: END IF;
222: IF upper(column_name) = 'ORDER_OF_PRECEDENCE' OR
223: column_name is null Then

Line 228: App_Exception.Raise_Exception;

224: IF new_references.order_of_precedence < 1 OR
225: new_references.order_of_precedence > 999999999 Then
226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230: END IF;
231: IF upper(column_name) = 'GOVT_HECS_CNTRBTN_BAND' OR
232: column_name is null Then

Line 237: App_Exception.Raise_Exception;

233: IF new_references.govt_hecs_cntrbtn_band < 1 OR
234: new_references.govt_hecs_cntrbtn_band > 99 Then
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: END IF;
240: IF upper(column_name) = 'RATE_NUMBER' OR
241: column_name is null Then

Line 246: App_Exception.Raise_Exception;

242: IF new_references.rate_number < 1 OR
243: new_references.rate_number > 999999999 Then
244: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END IF;
248: END IF;
249:
250: IF upper(column_name) = 'ATTENDANCE_MODE' OR

Line 256: App_Exception.Raise_Exception;

252: IF new_references.attendance_mode <>
253: UPPER(new_references.attendance_mode) Then
254: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: END IF;
258: END IF;
259: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
260: column_name is null Then

Line 265: App_Exception.Raise_Exception;

261: IF new_references.attendance_type <>
262: UPPER(new_references.attendance_type) Then
263: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;
268: IF upper(column_name) = 'FEE_CAL_TYPE' OR
269: column_name is null Then

Line 274: App_Exception.Raise_Exception;

270: IF new_references.fee_cal_type <>
271: UPPER(new_references.fee_cal_type) Then
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: END IF;
277: IF upper(column_name) = 'GOVT_HECS_PAYMENT_OPTION' OR
278: column_name is null Then

Line 283: App_Exception.Raise_Exception;

279: IF new_references.govt_hecs_payment_option <>
280: UPPER(new_references.govt_hecs_payment_option) Then
281: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286: IF upper(column_name) = 'LOCATION_CD' OR
287: column_name is null Then

Line 292: App_Exception.Raise_Exception;

288: IF new_references.location_cd <>
289: UPPER(new_references.location_cd) Then
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: END IF;
295: IF upper(column_name) = 'S_RELATION_TYPE' OR
296: column_name is null Then

Line 301: App_Exception.Raise_Exception;

297: IF new_references.s_relation_type <>
298: UPPER(new_references.s_relation_type) Then
299: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: END IF;
304: IF upper(column_name) = 'COURSE_CD' OR
305: column_name is null Then

Line 310: App_Exception.Raise_Exception;

306: IF new_references.course_cd <>
307: UPPER(new_references.course_cd) Then
308: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312: END IF;
313: IF upper(column_name) = 'VERSION_NUMBER' OR
314: column_name is null Then

Line 319: App_Exception.Raise_Exception;

315: IF new_references.version_number < 1 OR
316: new_references.version_number > 999 Then
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: END IF;
322: IF upper(column_name) = 'CLASS_STANDING' OR
323: column_name is null Then

Line 328: App_Exception.Raise_Exception;

324: IF new_references.class_standing <>
325: UPPER(new_references.class_standing) Then
326: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330: END IF;
331: IF UPPER(column_name) = 'UNIT_SET_CD' OR column_name IS NULL THEN
332: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN

Line 335: app_exception.raise_exception;

331: IF UPPER(column_name) = 'UNIT_SET_CD' OR column_name IS NULL THEN
332: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
333: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337: END IF;
338: IF UPPER(column_name) = 'US_VERSION_NUMBER' OR column_name IS NULL THEN
339: IF new_references.us_version_number < 1 OR new_references.us_version_number > 999 Then

Line 342: app_exception.raise_exception;

338: IF UPPER(column_name) = 'US_VERSION_NUMBER' OR column_name IS NULL THEN
339: IF new_references.us_version_number < 1 OR new_references.us_version_number > 999 Then
340: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344: END IF;
345:
346: IF ((UPPER(column_name) = 'UNIT_VERSION_NUMBER') OR (column_name IS NULL)) THEN

Line 350: app_exception.raise_exception;

346: IF ((UPPER(column_name) = 'UNIT_VERSION_NUMBER') OR (column_name IS NULL)) THEN
347: IF ((new_references.unit_version_number < 0) OR (new_references.unit_version_number > 999)) THEN
348: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: END IF;
353: IF ((UPPER(column_name) = 'UNIT_TYPE_ID') OR (column_name IS NULL)) THEN
354: IF (new_references.unit_type_id < 0) THEN

Line 357: app_exception.raise_exception;

353: IF ((UPPER(column_name) = 'UNIT_TYPE_ID') OR (column_name IS NULL)) THEN
354: IF (new_references.unit_type_id < 0) THEN
355: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359: END IF;
360: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
361: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN

Line 364: App_Exception.Raise_Exception;

360: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
361: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN
362: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: END IF;
367: IF ((UPPER(column_name) = 'UNIT_LEVEL') OR (column_name IS NULL)) THEN
368: IF (new_references.unit_level <> UPPER(new_references.unit_level)) THEN

Line 371: app_exception.raise_exception;

367: IF ((UPPER(column_name) = 'UNIT_LEVEL') OR (column_name IS NULL)) THEN
368: IF (new_references.unit_level <> UPPER(new_references.unit_level)) THEN
369: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
375: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN

Line 378: App_Exception.Raise_Exception;

374: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
375: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN
376: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: END IF;
381: IF ((UPPER(column_name) = 'UNIT_MODE') OR (column_name IS NULL)) THEN
382: IF (new_references.unit_mode <> UPPER(new_references.unit_mode)) THEN

Line 385: app_exception.raise_exception;

381: IF ((UPPER(column_name) = 'UNIT_MODE') OR (column_name IS NULL)) THEN
382: IF (new_references.unit_mode <> UPPER(new_references.unit_mode)) THEN
383: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387: END IF;
388:
389: END Check_Constraints;

Line 412: App_Exception.Raise_Exception;

408: new_references.fee_type
409: ) THEN
410: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
411: IGS_GE_MSG_STACK.ADD;
412: App_Exception.Raise_Exception;
413: END IF;
414: END IF;
415: IF (((old_references.fee_type = new_references.fee_type) AND
416: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 430: App_Exception.Raise_Exception;

426: new_references.fee_ci_sequence_number
427: ) THEN
428: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
429: IGS_GE_MSG_STACK.ADD;
430: App_Exception.Raise_Exception;
431: END IF;
432: END IF;
433: END Check_Parent_Existance;
434:

Line 603: App_Exception.Raise_Exception;

599: new_references.hist_start_dt
600: ) THEN
601: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
602: IGS_GE_MSG_STACK.ADD;
603: App_Exception.Raise_Exception;
604: END IF;
605: Check_Constraints;
606: Check_Uniqueness;
607: Check_Parent_Existance;

Line 628: App_Exception.Raise_Exception;

624: new_references.hist_start_dt
625: ) THEN
626: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
627: IGS_GE_MSG_STACK.ADD;
628: App_Exception.Raise_Exception;
629: END IF;
630: Check_Constraints;
631: Check_Uniqueness;
632: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 710: app_exception.raise_exception;

706: end if;
707: else
708: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
709: IGS_GE_MSG_STACK.ADD;
710: app_exception.raise_exception;
711: end if;
712: Before_DML(
713: p_action=>'INSERT',
714: x_rowid=>X_ROWID,

Line 911: app_exception.raise_exception;

907: if (c1%notfound) then
908: close c1;
909: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
910: IGS_GE_MSG_STACK.ADD;
911: app_exception.raise_exception;
912: return;
913: end if;
914: close c1;
915: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 967: app_exception.raise_exception;

963: null;
964: else
965: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
966: IGS_GE_MSG_STACK.ADD;
967: app_exception.raise_exception;
968: end if;
969: return;
970: end LOCK_ROW;
971:

Line 1034: app_exception.raise_exception;

1030: end if;
1031: else
1032: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1033: IGS_GE_MSG_STACK.ADD;
1034: app_exception.raise_exception;
1035: end if;
1036: Before_DML(
1037: p_action=>'UPDATE',
1038: x_rowid=>X_ROWID,