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

Line 41: app_exception.Raise_Exception;

37: IF l_temp IS NOT NULL THEN
38:
39: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');
40: IGS_GE_MSG_STACK.ADD;
41: app_exception.Raise_Exception;
42:
43: END IF;
44:
45: END Check_Status;

Line 95: App_Exception.Raise_Exception;

91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;
98: Close cur_old_ref_values;
99:

Line 167: App_Exception.Raise_Exception;

163: IF NOT (new_references.total_cp_earned >=0) THEN
164: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_EARNED'));
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170:
171: -- The following code checks for check constraints on the Columns.

Line 178: App_Exception.Raise_Exception;

174: IF NOT (new_references.total_gpa_units >=0) THEN
175: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_GPA_UNITS'));
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
181:
182: -- The following code checks for check constraints on the Columns.

Line 189: App_Exception.Raise_Exception;

185: IF NOT (new_references.total_unit_gp >= 0) THEN
186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_UNIT_GP'));
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
193: -- The following code checks for check constraints on the Columns.

Line 199: App_Exception.Raise_Exception;

195: Column_Name IS NULL THEN
196: IF ( NOT (new_references.end_date > new_references.start_date) OR new_references.start_date > SYSDATE ) THEN
197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ST_DT_ED_DT');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:
203: -- The following code checks for check constraints on the Columns.

Line 210: App_Exception.Raise_Exception;

206: IF NOT (new_references.total_cp_attempted >=0) THEN
207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_ATTEMPTED'));
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213:
214:

Line 240: App_Exception.Raise_Exception;

236: ) THEN
237: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT'));
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242:
243: END Check_Parent_Existance;
244:

Line 331: App_Exception.Raise_Exception;

327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATD_ATRN_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
335:

Line 397: App_Exception.Raise_Exception;

393: IF Get_Pk_For_Validation(
394: new_references.term_details_id) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;
400: Check_Parent_Existance;
401: Check_Status; --jchin Bug 4629226

Line 418: App_Exception.Raise_Exception;

414: IF Get_PK_For_Validation (
415: new_references.term_details_id) THEN
416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Constraints;
421: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
422: Check_Constraints;

Line 525: app_exception.raise_exception;

521: end if;
522: else
523: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
524: IGS_GE_MSG_STACK.ADD;
525: app_exception.raise_exception;
526: end if;
527:
528: X_TERM_DETAILS_ID := -1;
529: Before_DML(

Line 612: app_exception.raise_exception;

608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
609: fnd_message.set_token ('ERR_CD', SQLCODE);
610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;
613: ELSE
614: igs_sc_gen_001.unset_ctx('R');
615: RAISE;
616: END IF;

Line 663: app_exception.raise_exception;

659: if (c1%notfound) then
660: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
661: IGS_GE_MSG_STACK.ADD;
662: close c1;
663: app_exception.raise_exception;
664: return;
665: end if;
666: close c1;
667: if ( ( tlinfo.TRANSCRIPT_ID = X_TRANSCRIPT_ID)

Line 691: app_exception.raise_exception;

687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;
694: end LOCK_ROW;
695: Procedure UPDATE_ROW (

Line 744: app_exception.raise_exception;

740: end if;
741: else
742: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
743: IGS_GE_MSG_STACK.ADD;
744: app_exception.raise_exception;
745: end if;
746: Before_DML(
747: p_action=>'UPDATE',
748: x_rowid=>X_ROWID,

Line 804: app_exception.raise_exception;

800: if (sql%notfound) then
801: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
802: igs_ge_msg_stack.add;
803: igs_sc_gen_001.unset_ctx('R');
804: app_exception.raise_exception;
805: end if;
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.unset_ctx('R');
808: END IF;

Line 822: app_exception.raise_exception;

818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
819: fnd_message.set_token ('ERR_CD', SQLCODE);
820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;
823: ELSE
824: igs_sc_gen_001.unset_ctx('R');
825: RAISE;
826: END IF;

Line 921: app_exception.raise_exception;

917: if (sql%notfound) then
918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: end if;
923: IF (x_mode = 'S') THEN
924: igs_sc_gen_001.unset_ctx('R');
925: END IF;