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

Line 54: App_Exception.Raise_Exception;

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

Line 105: App_Exception.Raise_Exception;

101: NEW_REFERENCES.rank)
102: THEN
103: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106:
107: END IF;
108: end Check_Uniqueness;
109:

Line 123: App_Exception.Raise_Exception;

119: new_references.restricted_attendance_type
120: ) THEN
121: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125:
126: END IF;
127:

Line 137: App_Exception.Raise_Exception;

133: new_references.encmb_course_group_cd
134: ) THEN
135: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139:
140: END IF;
141:

Line 151: App_Exception.Raise_Exception;

147: new_references.progression_outcome_type
148: ) THEN
149: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
154: END IF;
155:

Line 168: App_Exception.Raise_Exception;

164: new_references.pra_sequence_number
165: ) THEN
166: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:
171: END IF;
172:

Line 183: App_Exception.Raise_Exception;

179: new_references.prg_rule_repeat_fail_type
180: ) THEN
181: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185:
186: END IF;
187:

Line 285: App_Exception.Raise_Exception;

281: IF (cur_rowid%FOUND) THEN
282: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_ATT_FK');
283: IGS_GE_MSG_STACK.ADD;
284: Close cur_rowid;
285: App_Exception.Raise_Exception;
286:
287: Return;
288: END IF;
289: Close cur_rowid;

Line 312: App_Exception.Raise_Exception;

308: IF (cur_rowid%FOUND) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_POT_FK');
310: IGS_GE_MSG_STACK.ADD;
311: Close cur_rowid;
312: App_Exception.Raise_Exception;
313:
314: Return;
315: END IF;
316: Close cur_rowid;

Line 341: App_Exception.Raise_Exception;

337: IF (cur_rowid%FOUND) THEN
338: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_PRA_FK');
339: IGS_GE_MSG_STACK.ADD;
340: Close cur_rowid;
341: App_Exception.Raise_Exception;
342:
343: Return;
344: END IF;
345: Close cur_rowid;

Line 368: App_Exception.Raise_Exception;

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

Line 444: App_Exception.Raise_Exception;

440: new_references.pra_sequence_number,
441: new_references.sequence_number) THEN
442: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445:
446: END IF;
447: CHECK_UNIQUENESS;
448: CHECK_CONSTRAINTS;

Line 466: App_Exception.Raise_Exception;

462: new_references.pra_sequence_number,
463: new_references.sequence_number) THEN
464: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467:
468: END IF;
469: CHECK_UNIQUENESS;
470: CHECK_CONSTRAINTS;

Line 560: app_exception.raise_exception;

556: end if;
557: else
558: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: end if;
562: Before_DML (
563: p_action => 'INSERT',
564: x_rowid => x_rowid ,

Line 704: app_exception.raise_exception;

700: if (c1%notfound) then
701: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
702: IGS_GE_MSG_STACK.ADD;
703: close c1;
704: app_exception.raise_exception;
705:
706: return;
707: end if;
708: close c1;

Line 753: app_exception.raise_exception;

749: null;
750: else
751: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
752: IGS_GE_MSG_STACK.ADD;
753: app_exception.raise_exception;
754: end if;
755: return;
756: end LOCK_ROW;
757:

Line 800: app_exception.raise_exception;

796: end if;
797: else
798: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
799: IGS_GE_MSG_STACK.ADD;
800: app_exception.raise_exception;
801: end if;
802: Before_DML (
803: p_action => 'UPDATE',
804: x_rowid => x_rowid ,

Line 1032: App_Exception.Raise_Exception ;

1028: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1029: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
1030: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1031: IGS_GE_MSG_STACK.ADD;
1032: App_Exception.Raise_Exception ;
1033: END IF;
1034:
1035: END IF ;
1036:

Line 1041: App_Exception.Raise_Exception ;

1037: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1038: IF new_references.SEQUENCE_NUMBER < 1 or new_references.SEQUENCE_NUMBER > 999999 then
1039: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1040: IGS_GE_MSG_STACK.ADD;
1041: App_Exception.Raise_Exception ;
1042: END IF;
1043:
1044: END IF ;
1045:

Line 1050: App_Exception.Raise_Exception ;

1046: IF upper(Column_name) = 'APPLY_AUTOMATICALLY_IND' OR COLUMN_NAME IS NULL THEN
1047: IF new_references.APPLY_AUTOMATICALLY_IND<> upper(new_references.APPLY_AUTOMATICALLY_IND) then
1048: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1049: IGS_GE_MSG_STACK.ADD;
1050: App_Exception.Raise_Exception ;
1051: END IF;
1052:
1053: IF new_references.APPLY_AUTOMATICALLY_IND not in ('Y','N') then
1054: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1056: App_Exception.Raise_Exception ;

1052:
1053: IF new_references.APPLY_AUTOMATICALLY_IND not in ('Y','N') then
1054: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1055: IGS_GE_MSG_STACK.ADD;
1056: App_Exception.Raise_Exception ;
1057: END IF;
1058:
1059: END IF ;
1060:

Line 1065: App_Exception.Raise_Exception ;

1061: IF upper(Column_name) = 'OVERRIDE_SHOW_CAUSE_IND' OR COLUMN_NAME IS NULL THEN
1062: IF new_references.OVERRIDE_SHOW_CAUSE_IND<> upper(new_references.OVERRIDE_SHOW_CAUSE_IND) then
1063: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1064: IGS_GE_MSG_STACK.ADD;
1065: App_Exception.Raise_Exception ;
1066: END IF;
1067:
1068: IF new_references.OVERRIDE_SHOW_CAUSE_IND not in ('Y','N') then
1069: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1071: App_Exception.Raise_Exception ;

1067:
1068: IF new_references.OVERRIDE_SHOW_CAUSE_IND not in ('Y','N') then
1069: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1070: IGS_GE_MSG_STACK.ADD;
1071: App_Exception.Raise_Exception ;
1072: END IF;
1073:
1074: END IF ;
1075:

Line 1080: App_Exception.Raise_Exception ;

1076: IF upper(Column_name) = 'OVERRIDE_APPEAL_IND' OR COLUMN_NAME IS NULL THEN
1077: IF new_references.OVERRIDE_APPEAL_IND<> upper(new_references.OVERRIDE_APPEAL_IND) then
1078: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1079: IGS_GE_MSG_STACK.ADD;
1080: App_Exception.Raise_Exception ;
1081: END IF;
1082:
1083: IF new_references.OVERRIDE_APPEAL_IND not in ('Y','N') then
1084: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1086: App_Exception.Raise_Exception ;

1082:
1083: IF new_references.OVERRIDE_APPEAL_IND not in ('Y','N') then
1084: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1085: IGS_GE_MSG_STACK.ADD;
1086: App_Exception.Raise_Exception ;
1087: END IF;
1088:
1089: END IF ;
1090:

Line 1095: App_Exception.Raise_Exception ;

1091: IF upper(Column_name) = 'DURATION' OR COLUMN_NAME IS NULL THEN
1092: IF new_references.DURATION < 1 or new_references.DURATION > 999 then
1093: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1094: IGS_GE_MSG_STACK.ADD;
1095: App_Exception.Raise_Exception ;
1096: END IF;
1097:
1098: END IF ;
1099:

Line 1104: App_Exception.Raise_Exception ;

1100: IF upper(Column_name) = 'DURATION_TYPE' OR COLUMN_NAME IS NULL THEN
1101: IF new_references.DURATION_TYPE<> upper(new_references.DURATION_TYPE) then
1102: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1103: IGS_GE_MSG_STACK.ADD;
1104: App_Exception.Raise_Exception ;
1105: END IF;
1106:
1107: IF new_references.DURATION_TYPE not in ( 'NORMAL' , 'EFFECTIVE' ) then
1108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1110: App_Exception.Raise_Exception ;

1106:
1107: IF new_references.DURATION_TYPE not in ( 'NORMAL' , 'EFFECTIVE' ) then
1108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1109: IGS_GE_MSG_STACK.ADD;
1110: App_Exception.Raise_Exception ;
1111: END IF;
1112:
1113: END IF ;
1114:

Line 1119: App_Exception.Raise_Exception ;

1115: IF upper(Column_name) = 'ENCMB_COURSE_GROUP_CD' OR COLUMN_NAME IS NULL THEN
1116: IF new_references.ENCMB_COURSE_GROUP_CD<> upper(new_references.ENCMB_COURSE_GROUP_CD) then
1117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1118: IGS_GE_MSG_STACK.ADD;
1119: App_Exception.Raise_Exception ;
1120: END IF;
1121:
1122: END IF ;
1123:

Line 1128: App_Exception.Raise_Exception ;

1124: IF upper(Column_name) = 'PRG_RULE_REPEAT_FAIL_TYPE' OR COLUMN_NAME IS NULL THEN
1125: IF new_references.PRG_RULE_REPEAT_FAIL_TYPE<> upper(new_references.PRG_RULE_REPEAT_FAIL_TYPE) then
1126: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1127: IGS_GE_MSG_STACK.ADD;
1128: App_Exception.Raise_Exception ;
1129: END IF;
1130:
1131: END IF ;
1132:

Line 1137: App_Exception.Raise_Exception ;

1133: IF upper(Column_name) = 'PROGRESSION_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN
1134: IF new_references.PROGRESSION_OUTCOME_TYPE<> upper(new_references.PROGRESSION_OUTCOME_TYPE) then
1135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1136: IGS_GE_MSG_STACK.ADD;
1137: App_Exception.Raise_Exception ;
1138: END IF;
1139:
1140: END IF ;
1141:

Line 1146: App_Exception.Raise_Exception ;

1142: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1143: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
1144: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1145: IGS_GE_MSG_STACK.ADD;
1146: App_Exception.Raise_Exception ;
1147: END IF;
1148:
1149: END IF ;
1150:

Line 1155: App_Exception.Raise_Exception ;

1151: IF upper(Column_name) = 'RESTRICTED_ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
1152: IF new_references.RESTRICTED_ATTENDANCE_TYPE<> upper(new_references.RESTRICTED_ATTENDANCE_TYPE) then
1153: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1154: IGS_GE_MSG_STACK.ADD;
1155: App_Exception.Raise_Exception ;
1156: END IF;
1157:
1158: END IF ;
1159:

Line 1164: App_Exception.Raise_Exception ;

1160: IF upper(Column_name) = 'RANK' OR COLUMN_NAME IS NULL THEN
1161: IF new_references.RANK < 0 or new_references.RANK > 99 then
1162: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1163: IGS_GE_MSG_STACK.ADD;
1164: App_Exception.Raise_Exception ;
1165: END IF;
1166:
1167: END IF ;
1168:

Line 1173: App_Exception.Raise_Exception ;

1169: IF upper(Column_name) = 'RESTRICTED_ENROLMENT_CP' OR COLUMN_NAME IS NULL THEN
1170: IF new_references.RESTRICTED_ENROLMENT_CP < 0 or new_references.RESTRICTED_ENROLMENT_CP > 999.999 then
1171: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1172: IGS_GE_MSG_STACK.ADD;
1173: App_Exception.Raise_Exception ;
1174: END IF;
1175:
1176: END IF ;
1177: