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

Line 55: app_exception.raise_exception;

51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
58: CLOSE cur_old_ref_values;
59:

Line 240: App_Exception.Raise_Exception;

236: CLOSE cur_pers_type;
237: IF l_person_type IS NULL THEN
238: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242:
243: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
244: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;

Line 306: App_Exception.Raise_Exception;

302: CLOSE cur_pers_type;
303: IF l_person_type IS NULL THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308:
309: -- Check any active record found for this student program, with System Person Type,FORMER_STUDENT
310: OPEN cur_per_typ_dt( new_references.person_id,

Line 377: App_Exception.Raise_Exception;

373: CLOSE cur_pers_type;
374: IF l_person_type IS NULL THEN
375: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: END IF;
379:
380: -- Check any active record found for this student program, with System Person Type,GRADUATE
381: OPEN cur_pe_typ_inst( new_references.person_id,

Line 421: App_Exception.Raise_Exception;

417: CLOSE cur_pers_type;
418: IF l_person_type IS NULL THEN
419: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423:
424: IF l_date = SYSDATE THEN
425: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);

Line 493: App_Exception.Raise_Exception;

489: CLOSE cur_pers_type;
490: IF l_person_type IS NULL THEN
491: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
492: IGS_GE_MSG_STACK.ADD;
493: App_Exception.Raise_Exception;
494: END IF;
495:
496: OPEN cur_conf_dt(p_rowid);
497: FETCH cur_conf_dt INTO cur_conf_dt_rec;

Line 538: App_Exception.Raise_Exception;

534: CLOSE cur_pers_type;
535: IF l_person_type IS NULL THEN
536: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
537: IGS_GE_MSG_STACK.ADD;
538: App_Exception.Raise_Exception;
539: END IF;
540: IF l_date = SYSDATE THEN
541: OPEN cur_typ_id_inst(cur_conf_dt_rec.PERSON_ID,cur_conf_dt_rec.COURSE_CD,l_person_type);
542: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;

Line 625: app_exception.raise_exception;

621: new_references.course_cd
622: ) THEN
623: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:
628: IF (((old_references.award_cd = new_references.award_cd)) OR
629: ((new_references.award_cd IS NULL))) THEN

Line 636: app_exception.raise_exception;

632: new_references.award_cd
633: ) THEN
634: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:
639: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND
640: (old_references.gs_version_number = new_references.gs_version_number)) OR

Line 650: app_exception.raise_exception;

646: new_references.gs_version_number
647: ) THEN
648: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
649: igs_ge_msg_stack.add;
650: app_exception.raise_exception;
651: END IF;
652:
653: END check_parent_existance;
654:

Line 741: app_exception.raise_exception;

737: IF (cur_rowid%FOUND) THEN
738: CLOSE cur_rowid;
739: fnd_message.set_name ('IGS', 'IGS_EN_ESAA_SCA_FK');
740: igs_ge_msg_stack.add;
741: app_exception.raise_exception;
742: RETURN;
743: END IF;
744: CLOSE cur_rowid;
745:

Line 780: app_exception.raise_exception;

776: IF (cur_rowid%FOUND) THEN
777: CLOSE cur_rowid;
778: fnd_message.set_name ('IGS', 'IGS_AS_GSG_GS_FK');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: RETURN;
782: END IF;
783: CLOSE cur_rowid;
784:

Line 870: app_exception.raise_exception;

866: )
867: ) THEN
868: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
869: igs_ge_msg_stack.add;
870: app_exception.raise_exception;
871: END IF;
872: check_parent_existance;
873: ELSIF (p_action = 'UPDATE') THEN
874: -- Call all the procedures related to Before Update.

Line 898: app_exception.raise_exception;

894: )
895: ) THEN
896: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
897: igs_ge_msg_stack.add;
898: app_exception.raise_exception;
899: END IF;
900: END IF;
901:
902: END before_dml;

Line 975: app_exception.raise_exception;

971: END IF;
972: ELSE
973: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:
978: before_dml(
979: p_action => 'INSERT',

Line 1058: app_exception.raise_exception;

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

Line 1111: app_exception.raise_exception;

1107: IF (c1%notfound) THEN
1108: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1109: igs_ge_msg_stack.add;
1110: CLOSE c1;
1111: app_exception.raise_exception;
1112: RETURN;
1113: END IF;
1114: CLOSE c1;
1115: -- TRUNCs added in the code by Nishikant - bug#2386592 - 24MAY2002.

Line 1126: app_exception.raise_exception;

1122: NULL;
1123: ELSE
1124: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1125: igs_ge_msg_stack.add;
1126: app_exception.raise_exception;
1127: END IF;
1128:
1129: RETURN;
1130:

Line 1183: app_exception.raise_exception;

1179: END IF;
1180: ELSE
1181: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1182: igs_ge_msg_stack.add;
1183: app_exception.raise_exception;
1184: END IF;
1185:
1186: before_dml(
1187: p_action => 'UPDATE',

Line 1231: app_exception.raise_exception;

1227: IF (SQL%NOTFOUND) THEN
1228: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1229: igs_ge_msg_stack.add;
1230: igs_sc_gen_001.unset_ctx('R');
1231: app_exception.raise_exception;
1232: END IF;
1233: IF (x_mode = 'S') THEN
1234: igs_sc_gen_001.unset_ctx('R');
1235: END IF;

Line 1251: app_exception.raise_exception;

1247: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1248: fnd_message.set_token ('ERR_CD', SQLCODE);
1249: igs_ge_msg_stack.add;
1250: igs_sc_gen_001.unset_ctx('R');
1251: app_exception.raise_exception;
1252: ELSE
1253: igs_sc_gen_001.unset_ctx('R');
1254: RAISE;
1255: END IF;

Line 1366: app_exception.raise_exception;

1362: IF (SQL%NOTFOUND) THEN
1363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1364: igs_ge_msg_stack.add;
1365: igs_sc_gen_001.unset_ctx('R');
1366: app_exception.raise_exception;
1367: END IF;
1368: IF (x_mode = 'S') THEN
1369: igs_sc_gen_001.unset_ctx('R');
1370: END IF;