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

Line 40: App_Exception.Raise_Exception;

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

Line 87: App_Exception.Raise_Exception;

83: new_references.fee_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: IF p_inserting OR
91: (p_updating AND new_references.end_dt IS NOT NULL AND

Line 99: App_Exception.Raise_Exception;

95: new_references.end_dt,
96: v_message_name) = FALSE THEN
97: Fnd_Message.Set_Name('IGS',v_message_name);
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102: IF p_inserting OR (p_updating AND
103: new_references.fee_type <> old_references.fee_type) THEN

Line 109: App_Exception.Raise_Exception;

105: new_references.fee_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112: IF p_inserting OR (p_updating AND
113: new_references.attendance_type <> old_references.attendance_type) THEN

Line 119: App_Exception.Raise_Exception;

115: new_references.attendance_type,
116: v_message_name) = FALSE THEN
117: Fnd_Message.Set_Name('IGS',v_message_name);
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122: IF p_inserting OR (p_updating AND
123: new_references.attendance_mode <> old_references.attendance_mode) THEN

Line 129: App_Exception.Raise_Exception;

125: new_references.attendance_mode,
126: v_message_name) = FALSE THEN
127: Fnd_Message.Set_Name('IGS',v_message_name);
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132: IF p_inserting OR (p_updating AND
133: new_references.location_cd <> old_references.location_cd) THEN

Line 139: App_Exception.Raise_Exception;

135: new_references.location_cd,
136: v_message_name) = FALSE THEN
137: Fnd_Message.Set_Name('IGS',v_message_name);
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142: END BeforeRowInsertUpdate1;
143: -- Trigger description :-

Line 198: App_Exception.Raise_Exception;

194: new_references.start_dt,
195: v_message_name) = FALSE THEN
196: Fnd_Message.Set_Name('IGS',v_message_name);
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
201: IF IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (
202: new_references.person_id,

Line 210: App_Exception.Raise_Exception;

206: new_references.end_dt,
207: v_message_name) = FALSE THEN
208: Fnd_Message.Set_Name('IGS',v_message_name);
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213: END AfterStmtInsertUpdate4;
214: PROCEDURE Check_Constraints (

Line 251: App_Exception.Raise_Exception;

247: column_name is null Then
248: IF new_references.chg_rate < 0 Then
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254:
255: IF upper(column_name) = 'ATTENDANCE_MODE' OR

Line 261: App_Exception.Raise_Exception;

257: IF new_references.attendance_mode <>
258: UPPER(new_references.attendance_mode) Then
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:
265: IF upper(column_name) = 'ATTENDANCE_TYPE' OR

Line 271: App_Exception.Raise_Exception;

267: IF new_references.ATTENDANCE_TYPE <>
268: UPPER(new_references.ATTENDANCE_TYPE) Then
269: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;
274:
275: IF upper(column_name) = 'COURSE_CD' OR

Line 281: App_Exception.Raise_Exception;

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

Line 291: App_Exception.Raise_Exception;

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

Line 301: App_Exception.Raise_Exception;

297: IF new_references.LOWER_NRML_RATE_OVRD_IND <>
298: UPPER(new_references.LOWER_NRML_RATE_OVRD_IND) 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:
305: IF upper(column_name) = 'LOWER_NRML_RATE_OVRD_IND' OR

Line 310: App_Exception.Raise_Exception;

306: column_name is null Then
307: IF (new_references.lower_nrml_rate_ovrd_ind not in ('Y', 'N')) 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: END Check_Constraints;
314: PROCEDURE Check_Parent_Existance AS

Line 325: App_Exception.Raise_Exception;

321: new_references.attendance_mode
322: ) THEN
323: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
324: IGS_GE_MSG_STACK.ADD;
325: App_Exception.Raise_Exception;
326: END IF;
327: END IF;
328: IF (((old_references.attendance_type = new_references.attendance_type)) OR
329: ((new_references.attendance_type IS NULL))) THEN

Line 337: App_Exception.Raise_Exception;

333: new_references.attendance_type
334: ) THEN
335: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: END IF;
340: IF (((old_references.fee_type = new_references.fee_type)) OR
341: ((new_references.fee_type IS NULL))) THEN

Line 349: App_Exception.Raise_Exception;

345: new_references.fee_type
346: ) THEN
347: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: END IF;
351: END IF;
352: IF (((old_references.location_cd = new_references.location_cd)) OR
353: ((new_references.location_cd IS NULL))) THEN

Line 362: App_Exception.Raise_Exception;

358: 'N'
359: ) THEN
360: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception;
363: END IF;
364: END IF;
365: IF (((old_references.person_id = new_references.person_id) AND
366: (old_references.course_cd = new_references.course_cd)) OR

Line 377: App_Exception.Raise_Exception;

373: new_references.course_cd
374: ) THEN
375: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: END IF;
379: END IF;
380: END Check_Parent_Existance;
381: Function Get_PK_For_Validation (

Line 423: App_Exception.Raise_Exception;

419: IF (cur_rowid%FOUND) THEN
420: Close cur_rowid;
421: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFAR_AM_FK');
422: IGS_GE_MSG_STACK.ADD;
423: App_Exception.Raise_Exception;
424: Return;
425: END IF;
426: Close cur_rowid;
427: END GET_FK_IGS_EN_ATD_MODE;

Line 443: App_Exception.Raise_Exception;

439: IF (cur_rowid%FOUND) THEN
440: Close cur_rowid;
441: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFAR_ATT_FK');
442: IGS_GE_MSG_STACK.ADD;
443: App_Exception.Raise_Exception;
444: Return;
445: END IF;
446: Close cur_rowid;
447: END GET_FK_IGS_EN_ATD_TYPE;

Line 464: App_Exception.Raise_Exception;

460: IF (cur_rowid%FOUND) THEN
461: Close cur_rowid;
462: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFAR_LOC_FK');
463: IGS_GE_MSG_STACK.ADD;
464: App_Exception.Raise_Exception;
465: Return;
466: END IF;
467: Close cur_rowid;
468: END GET_FK_IGS_AD_LOCATION;

Line 486: App_Exception.Raise_Exception;

482: IF (cur_rowid%FOUND) THEN
483: Close cur_rowid;
484: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFAR_SCA_FK');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: Return;
488: END IF;
489: Close cur_rowid;
490: END GET_FK_IGS_EN_STDNT_PS_ATT;

Line 541: App_Exception.Raise_Exception;

537: new_references.start_dt
538: ) THEN
539: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CONTRACT_EXISTS_FEETYP');
540: IGS_GE_MSG_STACK.ADD;
541: App_Exception.Raise_Exception;
542: END IF;
543: Check_Constraints;
544: Check_Parent_Existance;
545: ELSIF (p_action = 'UPDATE') THEN

Line 562: App_Exception.Raise_Exception;

558: new_references.start_dt
559: ) THEN
560: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CONTRACT_EXISTS_FEETYP');
561: IGS_GE_MSG_STACK.ADD;
562: App_Exception.Raise_Exception;
563: END IF;
564: Check_Constraints;
565: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
566: Check_Constraints;

Line 643: app_exception.raise_exception;

639: end if;
640: else
641: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
642: IGS_GE_MSG_STACK.ADD;
643: app_exception.raise_exception;
644: end if;
645: Before_DML(
646: p_action=>'INSERT',
647: x_rowid=>X_ROWID,

Line 730: app_exception.raise_exception;

726: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
727: fnd_message.set_token ('ERR_CD', SQLCODE);
728: igs_ge_msg_stack.add;
729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: ELSE
732: igs_sc_gen_001.unset_ctx('R');
733: RAISE;
734: END IF;

Line 768: app_exception.raise_exception;

764: if (c1%notfound) then
765: close c1;
766: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
767: IGS_GE_MSG_STACK.ADD;
768: app_exception.raise_exception;
769: return;
770: end if;
771: close c1;
772: if ( ((tlinfo.END_DT = X_END_DT)

Line 791: app_exception.raise_exception;

787: null;
788: else
789: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
790: IGS_GE_MSG_STACK.ADD;
791: app_exception.raise_exception;
792: end if;
793: return;
794: end LOCK_ROW;
795: procedure UPDATE_ROW (

Line 863: app_exception.raise_exception;

859: end if;
860: else
861: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
862: IGS_GE_MSG_STACK.ADD;
863: app_exception.raise_exception;
864: end if;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.set_ctx('R');
867: END IF;

Line 887: app_exception.raise_exception;

883: if (sql%notfound) then
884: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
885: igs_ge_msg_stack.add;
886: igs_sc_gen_001.unset_ctx('R');
887: app_exception.raise_exception;
888: end if;
889: IF (x_mode = 'S') THEN
890: igs_sc_gen_001.unset_ctx('R');
891: END IF;

Line 904: app_exception.raise_exception;

900: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
901: fnd_message.set_token ('ERR_CD', SQLCODE);
902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;
905: ELSE
906: igs_sc_gen_001.unset_ctx('R');
907: RAISE;
908: END IF;

Line 984: app_exception.raise_exception;

980: if (sql%notfound) then
981: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
982: igs_ge_msg_stack.add;
983: igs_sc_gen_001.unset_ctx('R');
984: app_exception.raise_exception;
985: end if;
986: IF (x_mode = 'S') THEN
987: igs_sc_gen_001.unset_ctx('R');
988: END IF;