[Home] [Help]
49: OPEN cur_delete (old_references.course_cd,old_references.version_number);
50: FETCH cur_delete INTO l_check;
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;
100: OPEN cur_check_update(old_references.course_cd,old_references.version_number);
101: FETCH cur_check_update INTO l_check;
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
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;
218: OPEN cur_old_ref_values;
219: FETCH cur_old_ref_values INTO old_references;
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;
344: new_references.version_number,
345: new_references.expiry_dt,
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;
365: new_references.course_cd,
366: new_references.version_number,
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;
507: NVL(new_references.annual_instruction_time,99999))
508:
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.
521: IF igs_ps_val_crv.crsp_val_crv_status (
522: new_references.course_status,
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.
548: new_references.course_cd,
549: new_references.version_number,
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;
560: (old_references.govt_special_course_type<> new_references.govt_special_course_type)) THEN
561: IF igs_ps_val_crv.crsp_val_crv_gsct (
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;
580: new_references.start_dt,
581: new_references.end_dt,
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;
591: new_references.version_number,
592: v_return_type,
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;
607: IF igs_ps_val_crv.crsp_val_ou_sys_sts (
608: new_references.responsible_org_unit_cd,
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;
622: IF igs_ps_val_crv.crsp_val_crv_end_sts(
623: new_references.end_dt,
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;
1059: IF UPPER(column_name)= 'ABBREVIATION' OR
1060: column_name IS NULL THEN
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;
1069: IF UPPER(column_name)= 'COURSE_CD' OR
1070: column_name IS NULL THEN
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;
1079: IF UPPER(column_name)= 'COURSE_STATUS' OR
1080: column_name IS NULL THEN
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
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;
1098: IF UPPER(column_name)= 'GOVT_SPECIAL_COURSE_TYPE' OR
1099: column_name IS NULL THEN
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;
1109: column_name IS NULL THEN
1110: IF new_references.max_intrmsn_duration <0 OR
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;
1119: column_name IS NULL THEN
1120: IF new_references.course_total_eftsu < 0 OR
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;
1129: column_name IS NULL THEN
1130: IF new_references.std_annual_load < 0 OR
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;
1139: column_name IS NULL THEN
1140: IF new_references.govt_course_load < 0 OR
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;
1149: column_name IS NULL THEN
1150: IF new_references.credit_points_required < 0 OR
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;
1159: column_name IS NULL THEN
1160: IF new_references.contact_hours < 0 OR
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;
1169: column_name IS NULL THEN
1170: IF new_references.internal_adv_stnd_limit < 0 OR
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;
1179: column_name IS NULL THEN
1180: IF new_references.external_adv_stnd_limit < 0 OR
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;
1189: column_name IS NULL THEN
1190: IF new_references.qualification_recency < 0 OR
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
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
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
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
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
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;
1244: column_name IS NULL THEN
1245: IF new_references.version_number < 1 OR
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;
1254: column_name IS NULL THEN
1255: IF new_references.min_sbmsn_percentage < 0 OR
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;
1264: column_name IS NULL THEN
1265: IF new_references.num_of_units_before_intrmsn < 0 OR
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;
1274: -- The following code checks for check constraints on the Columns.
1275: IF UPPER(column_name) = 'STATE_FINANCIAL_AID' OR
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;
1284: -- The following code checks for check constraints on the Columns.
1285: IF UPPER(column_name) = 'FEDERAL_FINANCIAL_AID' OR
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;
1294: -- The following code checks for check constraints on the Columns.
1295: IF UPPER(column_name) = 'INSTITUTIONAL_FINANCIAL_AID' OR
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;
1302: END IF;
1303:
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;
1310: END IF;
1311:
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;
1338: ELSE
1339: IF NOT IGS_FI_ACC_PKG.Get_PK_For_Validation (
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;
1351: ELSE
1352: IF NOT igs_ps_course_pkg.get_pk_for_validation (
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;
1363: ELSE
1364: IF NOT igs_ps_type_pkg.get_pk_for_validation (
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;
1375: ELSE
1376: IF NOT igs_ps_govt_spl_type_pkg.get_pk_for_validation (
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:
1392: IF NOT igs_or_unit_pkg.get_pk_for_validation (
1393: new_references.responsible_org_unit_cd,
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:
1406: ELSE
1407: IF NOT igs_ps_stat_pkg.get_pk_for_validation (
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:
1772: OPEN cur_rowid;
1773: FETCH cur_rowid INTO lv_rowid;
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;
1808: OPEN cur_rowid;
1809: FETCH cur_rowid INTO lv_rowid;
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;
1846: OPEN cur_rowid;
1847: FETCH cur_rowid INTO lv_rowid;
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;
1882: OPEN cur_rowid;
1883: FETCH cur_rowid INTO lv_rowid;
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;
2063: IF get_pk_for_validation(
2064: new_references.course_cd ,
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;
2091: IF get_pk_for_validation(
2092: new_references.course_cd ,
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;
2331: IF x_last_update_login IS NULL THEN
2332: x_last_update_login := -1;
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:
2715: OPEN c1;
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;
2879: AND (x_annual_instruction_time IS NULL)))
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;
2983: IF x_last_update_login IS NULL THEN
2984: x_last_update_login := -1;
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: