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

Line 44: app_exception.Raise_Exception;

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

Line 99: App_Exception.Raise_Exception;

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

Line 166: App_Exception.Raise_Exception;

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

Line 177: App_Exception.Raise_Exception;

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

Line 188: App_Exception.Raise_Exception;

184: IF NOT (new_references.unit_grade_points >= 0) THEN
185: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRADE_POINT'));
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191: END Check_Constraints;
192:

Line 213: app_exception.raise_exception;

209: new_references.unit
210: ) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: app_exception.raise_exception;
214: END IF;
215:
216: END Check_Uniqueness ;
217:

Line 243: App_Exception.Raise_Exception;

239: ) THEN
240: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_UNIT_DIFFICULTY'));
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245:
246: IF (((old_references.term_details_id = new_references.term_details_id)) OR
247: ((new_references.term_details_id IS NULL))) THEN

Line 255: App_Exception.Raise_Exception;

251: ) THEN
252: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257:
258: END Check_Parent_Existance;
259:

Line 364: App_Exception.Raise_Exception;

360: IF (cur_rowid%FOUND) THEN
361: Close cur_rowid;
362: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ACDC_FK');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: Return;
366: END IF;
367: Close cur_rowid;
368:

Line 401: App_Exception.Raise_Exception;

397: IF (cur_rowid%FOUND) THEN
398: Close cur_rowid;
399: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ATD_FK');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: Return;
403: END IF;
404: Close cur_rowid;
405:

Line 481: App_Exception.Raise_Exception;

477: IF Get_Pk_For_Validation(
478: new_references.unit_details_id) THEN
479: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
480: IGS_GE_MSG_STACK.ADD;
481: App_Exception.Raise_Exception;
482: END IF;
483: Check_Constraints;
484: Check_Uniqueness;
485: Check_Parent_Existance;

Line 505: App_Exception.Raise_Exception;

501: IF Get_PK_For_Validation (
502: new_references.unit_details_id) THEN
503: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
504: IGS_GE_MSG_STACK.ADD;
505: App_Exception.Raise_Exception;
506: END IF;
507: Check_Constraints;
508: Check_Uniqueness;
509: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 615: app_exception.raise_exception;

611: end if;
612: else
613: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
614: IGS_GE_MSG_STACK.ADD;
615: app_exception.raise_exception;
616: end if;
617:
618: X_UNIT_DETAILS_ID := -1;
619: Before_DML(

Line 703: app_exception.raise_exception;

699: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
700: fnd_message.set_token ('ERR_CD', SQLCODE);
701: igs_ge_msg_stack.add;
702: igs_sc_gen_001.unset_ctx('R');
703: app_exception.raise_exception;
704: ELSE
705: igs_sc_gen_001.unset_ctx('R');
706: RAISE;
707: END IF;

Line 754: app_exception.raise_exception;

750: if (c1%notfound) then
751: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
752: IGS_GE_MSG_STACK.ADD;
753: close c1;
754: app_exception.raise_exception;
755: return;
756: end if;
757: close c1;
758: if ( ( tlinfo.TERM_DETAILS_ID = X_TERM_DETAILS_ID)

Line 782: app_exception.raise_exception;

778: null;
779: else
780: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
781: IGS_GE_MSG_STACK.ADD;
782: app_exception.raise_exception;
783: end if;
784: return;
785: end LOCK_ROW;
786: Procedure UPDATE_ROW (

Line 835: app_exception.raise_exception;

831: end if;
832: else
833: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
834: IGS_GE_MSG_STACK.ADD;
835: app_exception.raise_exception;
836: end if;
837: Before_DML(
838: p_action=>'UPDATE',
839: x_rowid=>X_ROWID,

Line 895: app_exception.raise_exception;

891: if (sql%notfound) then
892: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
893: igs_ge_msg_stack.add;
894: igs_sc_gen_001.unset_ctx('R');
895: app_exception.raise_exception;
896: end if;
897: IF (x_mode = 'S') THEN
898: igs_sc_gen_001.unset_ctx('R');
899: END IF;

Line 912: app_exception.raise_exception;

908: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
909: fnd_message.set_token ('ERR_CD', SQLCODE);
910: igs_ge_msg_stack.add;
911: igs_sc_gen_001.unset_ctx('R');
912: app_exception.raise_exception;
913: ELSE
914: igs_sc_gen_001.unset_ctx('R');
915: RAISE;
916: END IF;

Line 1011: app_exception.raise_exception;

1007: if (sql%notfound) then
1008: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1009: igs_ge_msg_stack.add;
1010: igs_sc_gen_001.unset_ctx('R');
1011: app_exception.raise_exception;
1012: end if;
1013: IF (x_mode = 'S') THEN
1014: igs_sc_gen_001.unset_ctx('R');
1015: END IF;