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

Line 55: app_exception.raise_exception;

51: IF cur_delete%NOTFOUND THEN
52: CLOSE cur_delete;
53: fnd_message.set_name('IGS','IGS_PS_NO_DEL_ALLOWED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: END IF;
57: CLOSE cur_delete;
58: END beforerowdelete;
59:

Line 106: app_exception.raise_exception;

102: IF cur_check_update%FOUND THEN
103: CLOSE cur_check_update;
104: fnd_message.set_name('IGS','IGS_PS_NO_INACTIVE_PLN');
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END IF;
108: CLOSE cur_check_update;
109: END IF;
110: ELSE

Line 115: app_exception.raise_exception;

111: -- If the program status is not found then the record might have been deleted
112: CLOSE cur_get_status;
113: fnd_message.set_name('FND','FORM_RECORD_DELETED');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117: END beforerowupdate;
118:
119: PROCEDURE set_column_values (

Line 224: app_exception.raise_exception;

220: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
221: CLOSE cur_old_ref_values;
222: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: RETURN;
226: END IF;
227: CLOSE cur_old_ref_values;
228:

Line 350: app_exception.raise_exception;

346: new_references.course_status,
347: v_message_name) = FALSE THEN
348: fnd_message.set_name('IGS',v_message_name);
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: END IF;
353: IF p_inserting OR
354: (p_updating AND

Line 371: app_exception.raise_exception;

367: old_references.course_status,
368: v_message_name) = FALSE THEN
369: fnd_message.set_name('IGS',v_message_name);
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374: END IF;
375:

Line 513: app_exception.raise_exception;

509: THEN
510: CLOSE c_get_s_course_status;
511: fnd_message.set_name('IGS','IGS_PS_CHG_CANNOT_BEMADE_PRG');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515: END IF; -- s_course_status found.
516: CLOSE c_get_s_course_status;
517: END IF;

Line 527: app_exception.raise_exception;

523: old_references.course_status,
524: v_message_name) = FALSE THEN
525: fnd_message.set_name('IGS',v_message_name);
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529: -- Perform a quality check if p_updating to a system status of ACTIVE.
530: -- IGS_GE_NOTE: A IGS_PS_COURSE version can only be created with a status of PLANNED.
531: -- Hence, only need to perform the check if p_updating.

Line 554: app_exception.raise_exception;

550: new_references.course_type,
551: v_message_name) = FALSE THEN
552: fnd_message.set_name('IGS',v_message_name);
553: igs_ge_msg_stack.add;
554: app_exception.raise_exception;
555: END IF;
556: END IF;
557: -- Validate the GOVT special IGS_PS_COURSE type.
558: IF p_inserting OR

Line 566: app_exception.raise_exception;

562: new_references.govt_special_course_type,
563: v_message_name) = FALSE THEN
564: fnd_message.set_name('IGS',v_message_name);
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568: END IF;
569: -- Validate the version dates.
570: IF p_inserting OR

Line 586: app_exception.raise_exception;

582: new_references.expiry_dt,
583: v_message_name,FALSE) = FALSE THEN
584: fnd_message.set_name('IGS',v_message_name);
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588: END IF;
589: IF p_updating AND new_references.end_dt IS NOT NULL THEN
590: IF igs_ps_val_crv.crsp_val_crv_end(new_references.course_cd,

Line 597: app_exception.raise_exception;

593: v_message_name) = FALSE THEN
594: IF v_return_type = cst_error THEN
595: fnd_message.set_name('IGS',v_message_name);
596: igs_ge_msg_stack.add;
597: app_exception.raise_exception;
598: END IF;
599: END IF;
600: END IF;
601: -- Validate the responsible org IGS_PS_UNIT.

Line 613: app_exception.raise_exception;

609: new_references.responsible_ou_start_dt,
610: v_message_name) = FALSE THEN
611: fnd_message.set_name('IGS',v_message_name);
612: igs_ge_msg_stack.add;
613: app_exception.raise_exception;
614: END IF;
615: END IF;
616: -- Validate IGS_PS_COURSE status and end date combination.
617: IF p_inserting OR

Line 628: app_exception.raise_exception;

624: new_references.course_status,
625: v_message_name) = FALSE THEN
626: fnd_message.set_name('IGS',v_message_name);
627: igs_ge_msg_stack.add;
628: app_exception.raise_exception;
629: END IF;
630: END IF;
631:
632: -- Store IGS_PS_COURSE Version History

Line 1065: app_exception.raise_exception;

1061: IF new_references.abbreviation<> UPPER(new_references.abbreviation)
1062: 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: END IF;
1068:
1069: IF UPPER(column_name)= 'COURSE_CD' OR

Line 1075: app_exception.raise_exception;

1071: IF new_references.course_cd <> UPPER(new_references.course_cd )
1072: THEN
1073: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1074: igs_ge_msg_stack.add;
1075: app_exception.raise_exception;
1076: END IF;
1077: END IF;
1078:
1079: IF UPPER(column_name)= 'COURSE_STATUS' OR

Line 1085: app_exception.raise_exception;

1081: IF new_references.course_status <> UPPER(new_references.course_status)
1082: THEN
1083: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1084: igs_ge_msg_stack.add;
1085: app_exception.raise_exception;
1086: END IF;
1087: END IF;
1088: IF UPPER(column_name)= 'COURSE_TYPE' OR
1089: column_name IS NULL THEN

Line 1094: app_exception.raise_exception;

1090: IF new_references.course_type <> UPPER(new_references.course_type)
1091: THEN
1092: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1093: igs_ge_msg_stack.add;
1094: app_exception.raise_exception;
1095: END IF;
1096: END IF;
1097:
1098: IF UPPER(column_name)= 'GOVT_SPECIAL_COURSE_TYPE' OR

Line 1104: app_exception.raise_exception;

1100: IF new_references.govt_special_course_type <> UPPER(new_references.govt_special_course_type )
1101: 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: END IF;
1107:
1108: IF UPPER(column_name)= 'MAX_INTRMSN_DURATION' OR

Line 1115: app_exception.raise_exception;

1111: new_references.max_intrmsn_duration > 999
1112: THEN
1113: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1114: igs_ge_msg_stack.add;
1115: app_exception.raise_exception;
1116: END IF;
1117: END IF;
1118: IF UPPER(column_name)= 'COURSE_TOTAL_EFTSU' OR
1119: column_name IS NULL THEN

Line 1125: app_exception.raise_exception;

1121: new_references.course_total_eftsu > 99.999
1122: THEN
1123: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1124: igs_ge_msg_stack.add;
1125: app_exception.raise_exception;
1126: END IF;
1127: END IF;
1128: IF UPPER(column_name)= 'STD_ANNUAL_LOAD' OR
1129: column_name IS NULL THEN

Line 1135: app_exception.raise_exception;

1131: new_references.std_annual_load > 9999.999
1132: THEN
1133: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1134: igs_ge_msg_stack.add;
1135: app_exception.raise_exception;
1136: END IF;
1137: END IF;
1138: IF UPPER(column_name)= 'GOVT_COURSE_LOAD' OR
1139: column_name IS NULL THEN

Line 1145: app_exception.raise_exception;

1141: new_references.govt_course_load > 99
1142: THEN
1143: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1144: igs_ge_msg_stack.add;
1145: app_exception.raise_exception;
1146: END IF;
1147: END IF;
1148: IF UPPER(column_name)= 'CREDIT_POINTS_REQUIRED' OR
1149: column_name IS NULL THEN

Line 1155: app_exception.raise_exception;

1151: new_references.credit_points_required > 999.999
1152: 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: END IF;
1158: IF UPPER(column_name)= 'CONTACT_HOURS' OR
1159: column_name IS NULL THEN

Line 1165: app_exception.raise_exception;

1161: new_references.contact_hours > 9999.999
1162: THEN
1163: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1164: igs_ge_msg_stack.add;
1165: app_exception.raise_exception;
1166: END IF;
1167: END IF;
1168: IF UPPER(column_name)= 'INTERNAL_ADV_STND_LIMIT' OR
1169: column_name IS NULL THEN

Line 1175: app_exception.raise_exception;

1171: new_references.internal_adv_stnd_limit > 9999.999
1172: THEN
1173: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1174: igs_ge_msg_stack.add;
1175: app_exception.raise_exception;
1176: END IF;
1177: END IF;
1178: IF UPPER(column_name)= 'EXTERNAL_ADV_STND_LIMIT' OR
1179: column_name IS NULL THEN

Line 1185: app_exception.raise_exception;

1181: new_references.external_adv_stnd_limit > 9999.999
1182: THEN
1183: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1184: igs_ge_msg_stack.add;
1185: app_exception.raise_exception;
1186: END IF;
1187: END IF;
1188: IF UPPER(column_name)= 'QUALIFICATION_RECENCY' OR
1189: column_name IS NULL THEN

Line 1195: app_exception.raise_exception;

1191: new_references.qualification_recency > 99
1192: THEN
1193: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1194: igs_ge_msg_stack.add;
1195: app_exception.raise_exception;
1196: END IF;
1197: END IF;
1198: IF UPPER(column_name)= 'INTRMSN_ALLOWED_IND' OR
1199: column_name IS NULL THEN

Line 1204: app_exception.raise_exception;

1200: IF new_references.intrmsn_allowed_ind NOT IN ( 'Y' , 'N' )
1201: THEN
1202: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;
1205: END IF;
1206: END IF;
1207: IF UPPER(column_name)= 'COUNT_INTRMSN_IN_TIME_IND' OR
1208: column_name IS NULL THEN

Line 1213: app_exception.raise_exception;

1209: IF new_references.count_intrmsn_in_time_ind NOT IN ( 'Y' , 'N' )
1210: THEN
1211: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1212: igs_ge_msg_stack.add;
1213: app_exception.raise_exception;
1214: END IF;
1215: END IF;
1216: IF UPPER(column_name)= 'GRADUATE_STUDENTS_IND' OR
1217: column_name IS NULL THEN

Line 1222: app_exception.raise_exception;

1218: IF new_references.graduate_students_ind NOT IN ( 'Y' , 'N' )
1219: THEN
1220: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1221: igs_ge_msg_stack.add;
1222: app_exception.raise_exception;
1223: END IF;
1224: END IF;
1225: IF UPPER(column_name)= 'GENERIC_COURSE_IND' OR
1226: column_name IS NULL THEN

Line 1231: app_exception.raise_exception;

1227: IF new_references.generic_course_ind NOT IN ( 'Y' , 'N' )
1228: THEN
1229: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1230: igs_ge_msg_stack.add;
1231: app_exception.raise_exception;
1232: END IF;
1233: END IF;
1234: IF UPPER(column_name)= 'SUPP_EXAM_PERMITTED_IND' OR
1235: column_name IS NULL THEN

Line 1240: app_exception.raise_exception;

1236: IF new_references.supp_exam_permitted_ind NOT IN ( 'Y' , 'N' )
1237: THEN
1238: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1239: igs_ge_msg_stack.add;
1240: app_exception.raise_exception;
1241: END IF;
1242: END IF;
1243: IF UPPER(column_name)= 'VERSION_NUMBER' OR
1244: column_name IS NULL THEN

Line 1250: app_exception.raise_exception;

1246: new_references.version_number > 999
1247: THEN
1248: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1249: igs_ge_msg_stack.add;
1250: app_exception.raise_exception;
1251: END IF;
1252: END IF;
1253: IF UPPER(column_name)= 'MIN_SBMSN_PERCENTAGE' OR
1254: column_name IS NULL THEN

Line 1260: app_exception.raise_exception;

1256: new_references.min_sbmsn_percentage > 100.00
1257: THEN
1258: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1259: igs_ge_msg_stack.add;
1260: app_exception.raise_exception;
1261: END IF;
1262: END IF;
1263: IF UPPER(column_name)= 'NUM_OF_UNITS_BEFORE_INTRMSN' OR
1264: column_name IS NULL THEN

Line 1270: app_exception.raise_exception;

1266: new_references.num_of_units_before_intrmsn > 999
1267: THEN
1268: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1269: igs_ge_msg_stack.add;
1270: app_exception.raise_exception;
1271: END IF;
1272: END IF;
1273:
1274: -- The following code checks for check constraints on the Columns.

Line 1280: app_exception.raise_exception;

1276: column_name IS NULL THEN
1277: IF NOT (new_references.state_financial_aid IN ('Y', 'N')) THEN
1278: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1279: igs_ge_msg_stack.add;
1280: app_exception.raise_exception;
1281: END IF;
1282: END IF;
1283:
1284: -- The following code checks for check constraints on the Columns.

Line 1290: app_exception.raise_exception;

1286: column_name IS NULL THEN
1287: IF NOT (new_references.federal_financial_aid IN ('Y', 'N')) THEN
1288: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1289: igs_ge_msg_stack.add;
1290: app_exception.raise_exception;
1291: END IF;
1292: END IF;
1293:
1294: -- The following code checks for check constraints on the Columns.

Line 1300: app_exception.raise_exception;

1296: column_name IS NULL THEN
1297: IF NOT (new_references.institutional_financial_aid IN ('Y', 'N')) THEN
1298: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1299: igs_ge_msg_stack.add;
1300: app_exception.raise_exception;
1301: END IF;
1302: END IF;
1303:
1304: IF UPPER(column_name)= 'MAX_WLST_PER_STUD' OR column_name IS NULL THEN

Line 1308: app_exception.raise_exception;

1304: IF UPPER(column_name)= 'MAX_WLST_PER_STUD' OR column_name IS NULL THEN
1305: IF new_references.max_wlst_per_stud < 0 OR new_references.max_wlst_per_stud > 9999 THEN
1306: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1307: igs_ge_msg_stack.add;
1308: app_exception.raise_exception;
1309: END IF;
1310: END IF;
1311:
1312: IF UPPER(column_name)= 'ANNUAL_INSTRUCTION_TIME' OR column_name IS NULL THEN

Line 1316: app_exception.raise_exception;

1312: IF UPPER(column_name)= 'ANNUAL_INSTRUCTION_TIME' OR column_name IS NULL THEN
1313: IF new_references.annual_instruction_time < 1 OR new_references.annual_instruction_time > 99.99 THEN
1314: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1315: igs_ge_msg_stack.add;
1316: app_exception.raise_exception;
1317: END IF;
1318: END IF;
1319:
1320: END check_constraints;

Line 1344: App_Exception.Raise_Exception;

1340: new_references.rev_account_cd
1341: ) THEN
1342: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
1343: IGS_GE_MSG_STACK.ADD;
1344: App_Exception.Raise_Exception;
1345: END IF;
1346: END IF;
1347:
1348: IF (((old_references.course_cd = new_references.course_cd)) OR

Line 1357: app_exception.raise_exception;

1353: new_references.course_cd
1354: )THEN
1355: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1356: igs_ge_msg_stack.add;
1357: app_exception.raise_exception;
1358: END IF;
1359: END IF;
1360: IF (((old_references.course_type = new_references.course_type)) OR
1361: ((new_references.course_type IS NULL))) THEN

Line 1369: app_exception.raise_exception;

1365: new_references.course_type
1366: )THEN
1367: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1368: igs_ge_msg_stack.add;
1369: app_exception.raise_exception;
1370: END IF;
1371: END IF;
1372: IF (((old_references.govt_special_course_type = new_references.govt_special_course_type)) OR
1373: ((new_references.govt_special_course_type IS NULL))) THEN

Line 1381: app_exception.raise_exception;

1377: new_references.govt_special_course_type
1378: )THEN
1379: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1380: igs_ge_msg_stack.add;
1381: app_exception.raise_exception;
1382: END IF;
1383:
1384: END IF;
1385:

Line 1398: app_exception.raise_exception;

1394: new_references.responsible_ou_start_dt
1395: )THEN
1396: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1397: igs_ge_msg_stack.add;
1398: app_exception.raise_exception;
1399: END IF;
1400:
1401: END IF;
1402:

Line 1412: app_exception.raise_exception;

1408: new_references.course_status
1409: )THEN
1410: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1411: igs_ge_msg_stack.add;
1412: app_exception.raise_exception;
1413: END IF;
1414:
1415: END IF;
1416:

Line 1778: app_exception.raise_exception;

1774: IF (cur_rowid%FOUND) THEN
1775: CLOSE cur_rowid;
1776: fnd_message.set_name ('IGS', 'IGS_PS_CRV_CRS_FK');
1777: igs_ge_msg_stack.add;
1778: app_exception.raise_exception;
1779: RETURN;
1780: END IF;
1781: CLOSE cur_rowid;
1782:

Line 1814: app_exception.raise_exception;

1810: IF (cur_rowid%FOUND) THEN
1811: CLOSE cur_rowid;
1812: fnd_message.set_name ('IGS', 'IGS_PS_CRV_GSCT_FK');
1813: igs_ge_msg_stack.add;
1814: app_exception.raise_exception;
1815: RETURN;
1816: END IF;
1817: CLOSE cur_rowid;
1818:

Line 1852: app_exception.raise_exception;

1848: IF (cur_rowid%FOUND) THEN
1849: CLOSE cur_rowid;
1850: fnd_message.set_name ('IGS', 'IGS_PS_CRV_OU_FK');
1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;
1853: RETURN;
1854: END IF;
1855: CLOSE cur_rowid;
1856:

Line 1888: app_exception.raise_exception;

1884: IF (cur_rowid%FOUND) THEN
1885: CLOSE cur_rowid;
1886: fnd_message.set_name ('IGS', 'IGS_PS_CRV_CRST_FK');
1887: igs_ge_msg_stack.add;
1888: app_exception.raise_exception;
1889: RETURN;
1890: END IF;
1891: CLOSE cur_rowid;
1892:

Line 2069: app_exception.raise_exception;

2065: new_references.version_number
2066: ) THEN
2067: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
2068: igs_ge_msg_stack.add;
2069: app_exception.raise_exception;
2070: END IF;
2071: check_constraints;
2072: check_parent_existance;
2073: ELSIF (p_action = 'UPDATE') THEN

Line 2097: app_exception.raise_exception;

2093: new_references.version_number
2094: ) THEN
2095: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
2096: igs_ge_msg_stack.add;
2097: app_exception.raise_exception;
2098: END IF;
2099: check_constraints;
2100: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
2101: check_constraints;

Line 2178: app_exception.raise_exception;

2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: -- If an error occurs during insertion in igs_ps_ref_cd then raise an exception.
2177: igs_ge_msg_stack.add;
2178: app_exception.raise_exception;
2179: RETURN;
2180: END dflt_prgm_ref_code;
2181:
2182: PROCEDURE after_dml (

Line 2337: app_exception.raise_exception;

2333: END IF;
2334: ELSE
2335: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2336: igs_ge_msg_stack.add;
2337: app_exception.raise_exception;
2338: END IF;
2339:
2340: before_dml( p_action => 'INSERT',
2341: x_rowid => x_rowid,

Line 2720: app_exception.raise_exception;

2716: FETCH c1 INTO tlinfo;
2717: IF (c1%NOTFOUND) THEN
2718: CLOSE c1;
2719: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2720: app_exception.raise_exception;
2721: RETURN;
2722: END IF;
2723: CLOSE c1;
2724:

Line 2884: app_exception.raise_exception;

2880: ) THEN
2881: NULL;
2882: ELSE
2883: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2884: app_exception.raise_exception;
2885: END IF;
2886: RETURN;
2887: END lock_row;
2888:

Line 2989: app_exception.raise_exception;

2985: END IF;
2986: ELSE
2987: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
2988: igs_ge_msg_stack.add;
2989: app_exception.raise_exception;
2990: END IF;
2991:
2992: before_dml( p_action => 'UPDATE',
2993: x_rowid => x_rowid,