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

Line 87: App_Exception.Raise_Exception;

83: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
84: Close cur_old_ref_values;
85: Fnd_Message.Set_Name ('IGS', 'FORM_RECORD_DELETED');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: Return;
89: END IF;
90: Close cur_old_ref_values;
91:

Line 190: App_Exception.Raise_Exception;

186: TRUNC(new_references.score_report_date) < TRUNC(new_references.test_date) THEN
187: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SCORE_RPT_DATE'));
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193:
194: -- The following code checks for check constraints on the Columns.

Line 201: App_Exception.Raise_Exception;

197: IF NOT (new_references.non_standard_admin in ('Y','N')) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NON_STANDARD_ADMIN'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204:
205: END Check_Constraints;

Line 232: App_Exception.Raise_Exception;

228: ) THEN
229: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EDU_LEVEL'));
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234:
235: IF (((old_references.admission_test_type = new_references.admission_test_type)) OR
236: ((new_references.admission_test_type IS NULL))) THEN

Line 245: App_Exception.Raise_Exception;

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

Line 272: App_Exception.Raise_Exception;

268: ) THEN
269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SCORE_SOURCE'));
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274:
275: IF (((old_references.person_id = new_references.person_id)) OR
276: ((new_references.person_id IS NULL))) THEN

Line 284: App_Exception.Raise_Exception;

280: ) THEN
281: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286:
287: IF (((old_references.score_type = new_references.score_type)) OR
288: ((new_references.score_type IS NULL))) THEN

Line 298: App_Exception.Raise_Exception;

294: ) THEN
295: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SCORE_TYPE'));
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: END IF;
301:
302: IF (((old_references.special_code = new_references.special_code)) OR

Line 313: App_Exception.Raise_Exception;

309: ) THEN
310: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_GE_SPECIAL'));
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: END IF;
316:
317: END Check_Parent_Existance;

Line 370: App_Exception.Raise_Exception;

366: IF (cur_rowid%FOUND) THEN
367: Close cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATR_UPD_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: Return;
372: END IF;
373: Close cur_rowid;
374: END IF;

Line 384: App_Exception.Raise_Exception;

380: IF (new_references.test_date > TRUNC(SYSDATE)) THEN
381: Close cur_rowid;
382: Fnd_Message.Set_Name ('IGS', 'IGS_SS_AD_SEG_NOT_IN_FUTURE');
383: IGS_GE_MSG_STACK.ADD;
384: App_Exception.Raise_Exception;
385: END IF;
386: END IF;
387: Close cur_rowid;
388: END IF;

Line 419: APP_EXCEPTION.RAISE_EXCEPTION;

415: IF l_birth_dt IS NOT NULL AND new_references.test_date IS NOT NULL THEN
416: IF l_birth_dt > new_references.test_date THEN
417: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');
418: IGS_GE_MSG_STACK.ADD;
419: APP_EXCEPTION.RAISE_EXCEPTION;
420: END IF;
421: END IF;
422: END IF;
423: END beforerowinsertupdate;

Line 501: App_Exception.Raise_Exception;

497: IF (cur_rowid%FOUND) THEN
498: Close cur_rowid;
499: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_ACDC_FK2');
500: IGS_GE_MSG_STACK.ADD;
501: App_Exception.Raise_Exception;
502: Return;
503: END IF;
504: Close cur_rowid;
505:

Line 512: App_Exception.Raise_Exception;

508: IF (cur_rowid2%FOUND) THEN
509: Close cur_rowid2;
510: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_ACDC_FK3');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: Return;
514: END IF;
515: Close cur_rowid2;
516:

Line 523: App_Exception.Raise_Exception;

519: IF (cur_rowid3%FOUND) THEN
520: Close cur_rowid3;
521: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_ACDC_FK');
522: IGS_GE_MSG_STACK.ADD;
523: App_Exception.Raise_Exception;
524: Return;
525: END IF;
526: Close cur_rowid3;
527: END Get_FK_Igs_Ad_Code_Classes;

Line 559: App_Exception.Raise_Exception;

555: IF (cur_rowid%FOUND) THEN
556: Close cur_rowid;
557: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_ADMTT_FK');
558: IGS_GE_MSG_STACK.ADD;
559: App_Exception.Raise_Exception;
560: Return;
561: END IF;
562: Close cur_rowid;
563:

Line 597: App_Exception.Raise_Exception;

593: IF (cur_rowid%FOUND) THEN
594: Close cur_rowid;
595: Fnd_Message.Set_Name ('IGS', 'IGS_AD_PE_PERSON_FK');
596: IGS_GE_MSG_STACK.ADD;
597: App_Exception.Raise_Exception;
598: Return;
599: END IF;
600: Close cur_rowid;
601:

Line 716: App_Exception.Raise_Exception;

712: IF Get_Pk_For_Validation(
713: new_references.test_results_id) THEN
714: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
715: IGS_GE_MSG_STACK.ADD;
716: App_Exception.Raise_Exception;
717: END IF;
718: Check_Constraints;
719: Check_Parent_Existance;
720: ELSIF (p_action = 'UPDATE') THEN

Line 738: App_Exception.Raise_Exception;

734: IF Get_PK_For_Validation (
735: new_references.test_results_id) THEN
736: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
737: IGS_GE_MSG_STACK.ADD;
738: App_Exception.Raise_Exception;
739: END IF;
740: Check_Constraints;
741: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
742: Check_Constraints;

Line 897: app_exception.raise_exception;

893: end if;
894: else
895: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
896: IGS_GE_MSG_STACK.ADD;
897: app_exception.raise_exception;
898: end if;
899:
900: X_TEST_RESULTS_ID := -1;
901: Before_DML(

Line 1061: app_exception.raise_exception;

1057: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1058: fnd_message.set_token ('ERR_CD', SQLCODE);
1059: igs_ge_msg_stack.add;
1060: igs_sc_gen_001.unset_ctx('R');
1061: app_exception.raise_exception;
1062: ELSE
1063: igs_sc_gen_001.unset_ctx('R');
1064: RAISE;
1065: END IF;

Line 1163: app_exception.raise_exception;

1159: if (c1%notfound) then
1160: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1161: IGS_GE_MSG_STACK.ADD;
1162: close c1;
1163: app_exception.raise_exception;
1164: return;
1165: end if;
1166: close c1;
1167: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 1268: app_exception.raise_exception;

1264: null;
1265: else
1266: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1267: IGS_GE_MSG_STACK.ADD;
1268: app_exception.raise_exception;
1269: end if;
1270: return;
1271: end LOCK_ROW;
1272: Procedure UPDATE_ROW (

Line 1355: app_exception.raise_exception;

1351: end if;
1352: else
1353: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1354: IGS_GE_MSG_STACK.ADD;
1355: app_exception.raise_exception;
1356: end if;
1357: Before_DML(
1358: p_action=>'UPDATE',
1359: x_rowid=>X_ROWID,

Line 1465: app_exception.raise_exception;

1461: if (sql%notfound) then
1462: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1463: igs_ge_msg_stack.add;
1464: igs_sc_gen_001.unset_ctx('R');
1465: app_exception.raise_exception;
1466: end if;
1467: IF (x_mode = 'S') THEN
1468: igs_sc_gen_001.unset_ctx('R');
1469: END IF;

Line 1483: app_exception.raise_exception;

1479: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1480: fnd_message.set_token ('ERR_CD', SQLCODE);
1481: igs_ge_msg_stack.add;
1482: igs_sc_gen_001.unset_ctx('R');
1483: app_exception.raise_exception;
1484: ELSE
1485: igs_sc_gen_001.unset_ctx('R');
1486: RAISE;
1487: END IF;

Line 1662: app_exception.raise_exception;

1658: if (sql%notfound) then
1659: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1660: igs_ge_msg_stack.add;
1661: igs_sc_gen_001.unset_ctx('R');
1662: app_exception.raise_exception;
1663: end if;
1664: IF (x_mode = 'S') THEN
1665: igs_sc_gen_001.unset_ctx('R');
1666: END IF;