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

Line 52: App_Exception.Raise_Exception;

48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
55: Close cur_old_ref_values;
56:

Line 98: App_Exception.Raise_Exception;

94: IF IGS_RE_VAL_SCH.resp_val_scht_closed ( new_references.scholarship_type,
95: v_message_name) = FALSE THEN
96: Fnd_Message.Set_Name ('IGS', v_message_name);
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101: -- Validate that inserts/updates are allowed
102: IF p_inserting OR p_updating THEN

Line 109: App_Exception.Raise_Exception;

105: new_references.end_dt,
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: END IF;
113:

Line 137: App_Exception.Raise_Exception;

133: new_references.end_dt,
134: v_message_name) = FALSE THEN
135: Fnd_Message.Set_Name ('IGS', v_message_name);
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
140: END AfterRowInsertUpdate2;
141:

Line 162: App_Exception.Raise_Exception ;

158: IF upper(column_name) = 'SCHOLARSHIP_TYPE' OR COLUMN_NAME IS NULL THEN
159: IF new_references.SCHOLARSHIP_TYPE <> upper(NEW_REFERENCES.SCHOLARSHIP_TYPE) then
160: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception ;
163: END IF;
164: END IF;
165: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
166: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then

Line 169: App_Exception.Raise_Exception ;

165: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
166: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
167: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception ;
170: END IF;
171: END IF;
172: IF upper(column_name) = 'DOLLAR_VALUE' OR COLUMN_NAME IS NULL THEN
173: IF new_references.DOLLAR_VALUE < 0 OR new_references.DOLLAR_VALUE > 999999.99 then

Line 176: App_Exception.Raise_Exception ;

172: IF upper(column_name) = 'DOLLAR_VALUE' OR COLUMN_NAME IS NULL THEN
173: IF new_references.DOLLAR_VALUE < 0 OR new_references.DOLLAR_VALUE > 999999.99 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: END Check_Constraints ;
180:

Line 197: App_Exception.Raise_Exception;

193: new_references.ca_sequence_number
194: ) THEN
195: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199:
200: END IF;
201:

Line 211: App_Exception.Raise_Exception;

207: new_references.scholarship_type
208: ) THEN
209: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213:
214: END IF;
215:

Line 272: App_Exception.Raise_Exception;

268: IF (cur_rowid%FOUND) THEN
269: Close cur_rowid;
270: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCH_CA_FK');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: Return;
274: END IF;
275: Close cur_rowid;
276:

Line 298: App_Exception.Raise_Exception;

294: IF (cur_rowid%FOUND) THEN
295: Close cur_rowid;
296: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCH_SCHT_FK');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: Return;
300: END IF;
301: Close cur_rowid;
302:

Line 357: App_Exception.Raise_Exception;

353: new_references.start_dt
354: ) THEN
355: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: END IF;
359: Check_Constraints;
360: Check_Parent_Existance;
361: ELSIF (p_action = 'UPDATE') THEN

Line 375: App_Exception.Raise_Exception;

371: new_references.start_dt
372: ) THEN
373: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
378: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
379: Check_Constraints;

Line 436: app_exception.raise_exception;

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

Line 521: app_exception.raise_exception;

517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
518: fnd_message.set_token ('ERR_CD', SQLCODE);
519: igs_ge_msg_stack.add;
520: igs_sc_gen_001.unset_ctx('R');
521: app_exception.raise_exception;
522: ELSE
523: igs_sc_gen_001.unset_ctx('R');
524: RAISE;
525: END IF;

Line 558: app_exception.raise_exception;

554: fetch c1 into tlinfo;
555: if (c1%notfound) then
556: close c1;
557: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
558: app_exception.raise_exception;
559: return;
560: end if;
561: close c1;
562:

Line 583: app_exception.raise_exception;

579: ) then
580: null;
581: else
582: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583: app_exception.raise_exception;
584: end if;
585: return;
586: end LOCK_ROW;
587:

Line 621: app_exception.raise_exception;

617: end if;
618: else
619: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
620: IGS_GE_MSG_STACK.ADD;
621: app_exception.raise_exception;
622: end if;
623:
624: Before_DML (
625: p_action => 'UPDATE',

Line 660: app_exception.raise_exception;

656: if (sql%notfound) then
657: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: end if;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');
664: END IF;

Line 674: app_exception.raise_exception;

670: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
671: fnd_message.set_token ('ERR_CD', SQLCODE);
672: igs_ge_msg_stack.add;
673: igs_sc_gen_001.unset_ctx('R');
674: app_exception.raise_exception;
675: ELSE
676: igs_sc_gen_001.unset_ctx('R');
677: RAISE;
678: END IF;

Line 757: app_exception.raise_exception;

753: if (sql%notfound) then
754: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
755: igs_ge_msg_stack.add;
756: igs_sc_gen_001.unset_ctx('R');
757: app_exception.raise_exception;
758: end if;
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.unset_ctx('R');
761: END IF;