[Home] [Help]
667: FETCH cur_reconsider INTO l_is_inst_reconsidered;
668: CLOSE cur_reconsider;
669: --- end apadegal ADTD001 RE-OPEN Build igs.m
670: --
671: IF IGS_AD_VAL_ACAI.admp_val_acai_update (
672: v_adm_appl_status,
673: new_references.person_id,
674: new_references.admission_appl_number,
675: new_references.nominated_course_cd,
762: --
763: -- Validate change of preference.
764: IF v_pref_allowed_ind = 'Y' AND
765: NVL(old_references.preference_number, -1) <> NVL(new_references.preference_number, -1) THEN
766: IF IGS_AD_VAL_ACAI.admp_val_chg_of_pref (
767: v_adm_cal_type,
768: v_adm_ci_sequence_number,
769: v_admission_cat,
770: v_s_admission_process_type,
783: END IF; -- p_updating
784: IF NVL(p_inserting,FALSE) THEN
785: -- Validate insert of a preference.
786: IF v_pref_allowed_ind = 'Y' THEN
787: IF IGS_AD_VAL_ACAI.admp_val_chg_of_pref (
788: v_adm_cal_type,
789: v_adm_ci_sequence_number,
790: v_admission_cat,
791: v_s_admission_process_type,
848: NVL(old_references.crv_version_number, -1) <> new_references.crv_version_number OR
849: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
850: NVL(old_references.adm_ci_sequence_number, -1) <>
851: NVL(new_references.adm_ci_sequence_number, -1))THEN
852: IF IGS_AD_VAL_ACAI.admp_val_acai_course (
853: new_references.course_cd,
854: new_references.crv_version_number,
855: v_admission_cat,
856: v_s_admission_process_type,
878: (NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
879: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
880: NVL(old_references.adm_ci_sequence_number, -1) <>
881: NVL(new_references.adm_ci_sequence_number, -1))THEN
882: IF IGS_AD_VAL_ACAI.admp_val_acai_encmb (
883: new_references.person_id,
884: new_references.course_cd,
885: v_adm_cal_type,
886: v_adm_ci_sequence_number,
898: --
899: -- Validate against current student IGS_PS_COURSE attempt.
900: --
901: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd THEN
902: IF IGS_AD_VAL_ACAI.admp_val_aca_sca (
903: new_references.person_id,
904: new_references.course_cd,
905: v_appl_dt,
906: v_admission_cat,
932: new_references.admission_appl_number,
933: new_references.nominated_course_cd);
934: FETCH c_aca INTO v_transfer_course_cd;
935: CLOSE c_aca;
936: IF IGS_AD_VAL_ACA.admp_val_aca_trnsfr (
937: new_references.person_id,
938: new_references.course_cd,
939: new_references.crv_version_number,
940: v_transfer_course_cd,
961: NVL(old_references.attendance_type, '-1') <> NVL(new_references.attendance_type, '-1') OR
962: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
963: NVL(old_references.adm_ci_sequence_number, -1) <>
964: NVL(new_references.adm_ci_sequence_number, -1))THEN
965: IF IGS_AD_VAL_ACAI.admp_val_acai_cop (
966: new_references.course_cd,
967: new_references.crv_version_number,
968: new_references.location_cd,
969: new_references.attendance_mode,
1001: NVL(old_references.attendance_type, '-1') <> NVL(new_references.attendance_type, '-1') OR
1002: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1003: NVL(old_references.adm_ci_sequence_number, -1) <>
1004: NVL(new_references.adm_ci_sequence_number, -1) )THEN
1005: IF IGS_AD_VAL_ACAI.admp_val_acai_opt (
1006: new_references.course_cd,
1007: new_references.crv_version_number,
1008: v_acad_cal_type,
1009: v_acad_ci_sequence_number,
1035: NVL(old_references.attendance_type, '-1') <> NVL(new_references.attendance_type, '-1') OR
1036: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1037: NVL(old_references.adm_ci_sequence_number, -1) <>
1038: NVL(new_references.adm_ci_sequence_number, -1)THEN
1039: IF IGS_AD_VAL_ACAI.admp_val_acai_us (
1040: new_references.unit_set_cd,
1041: new_references.us_version_number,
1042: new_references.course_cd,
1043: new_references.crv_version_number,
1066: (NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1067: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1068: NVL(old_references.adm_ci_sequence_number, -1) <>
1069: NVL(new_references.adm_ci_sequence_number, -1))THEN
1070: IF IGS_AD_VAL_ACAI.admp_val_us_encmb (
1071: new_references.person_id,
1072: new_references.course_cd,
1073: new_references.unit_set_cd,
1074: new_references.us_version_number,
1088: --
1089: -- Validate the preference number.
1090: --
1091: IF NVL(old_references.preference_number, -1) <> NVL(new_references.preference_number, -1) THEN
1092: IF IGS_AD_VAL_ACAI.admp_val_acai_pref (
1093: new_references.preference_number,
1094: v_pref_allowed_ind ,
1095: v_pref_limit,
1096: v_s_admission_process_type,
1108: --
1109: -- Validate admission entry qualification status.
1110: --
1111: IF NVL(old_references.adm_entry_qual_status, '-1') <> new_references.adm_entry_qual_status THEN
1112: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aeqs (
1113: new_references.adm_entry_qual_status,
1114: new_references.adm_outcome_status,
1115: v_s_admission_process_type,
1116: v_message_name) = FALSE THEN
1122: --
1123: -- Validate admission documentation status.
1124: --
1125: IF NVL(old_references.adm_doc_status, '-1') <> new_references.adm_doc_status THEN
1126: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ads (
1127: new_references.adm_doc_status,
1128: new_references.adm_outcome_status,
1129: new_references.adm_cndtnl_offer_status,
1130: v_s_admission_process_type,
1146: NVL(old_references.attendance_mode, '-1') <> NVL(new_references.attendance_type, '-1') OR
1147: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1148: NVL(old_references.adm_ci_sequence_number, -1) <>
1149: NVL(new_references.adm_ci_sequence_number, -1) THEN
1150: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_lafs (
1151: new_references.late_adm_fee_status,
1152: v_late_appl_allowed_ind,
1153: v_late_fees_required_ind,
1154: v_cond_offer_fee_allowed_ind,
1187: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status AND
1188: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'SUSPENDED' AND
1189: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'WITHDRAWN') --nshee bug 2630217
1190: THEN
1191: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
1192: new_references.person_id,
1193: new_references.admission_appl_number,
1194: new_references.nominated_course_cd,
1195: new_references.sequence_number,
1240: END IF;
1241: END IF;
1242: IF NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1243: -- Validate update of admission outcome status.
1244: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aos_update (
1245: new_references.person_id,
1246: new_references.admission_appl_number,
1247: new_references.adm_outcome_status,
1248: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),
1259:
1260: ---validate application instance status
1261: IF NVL(old_references.appl_inst_status, '-1') <> NVL(new_references.appl_inst_status,'-1') THEN --arvsrini igsm
1262:
1263: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ais (
1264: new_references.appl_inst_status,
1265: new_references.ais_reason ,
1266: new_references.adm_outcome_status,
1267: v_message_name)= FALSE THEN
1280: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1281: NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status OR
1282: NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1283: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1284: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
1285: new_references.person_id,
1286: new_references.admission_appl_number,
1287: new_references.nominated_course_cd,
1288: new_references.sequence_number,
1318: -- Validate admission conditional offer.
1319: --
1320: IF NVL(old_references.adm_cndtnl_offer_status, '-1') <> new_references.adm_cndtnl_offer_status OR
1321: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1322: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_acos (
1323: new_references.adm_cndtnl_offer_status,
1324: NVL(old_references.adm_cndtnl_offer_status, IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),
1325: new_references.adm_outcome_status,
1326: new_references.adm_outcome_status,
1341: -- Validate admission offer deferment status.
1342: --
1343: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1344: NVL(old_references.adm_offer_dfrmnt_status, '-1') <> new_references.adm_offer_dfrmnt_status THEN
1345: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aods (
1346: new_references.person_id,
1347: new_references.admission_appl_number,
1348: new_references.nominated_course_cd,
1349: new_references.sequence_number,
1367: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status OR
1368: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1369: NVL(old_references.adm_ci_sequence_number, -1) <>
1370: NVL(new_references.adm_ci_sequence_number, -1)) THEN
1371: IF IGS_AD_VAL_ACAI.admp_val_offer_dt (
1372: new_references.offer_dt,
1373: new_references.adm_outcome_status,
1374: v_adm_cal_type,
1375: v_adm_ci_sequence_number,
1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1387: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status) OR
1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1390: IF IGS_AD_VAL_ACAI.admp_val_off_resp_dt (
1391: new_references.offer_response_dt,
1392: new_references.adm_outcome_status,
1393: new_references.offer_dt,
1394: v_message_name) = FALSE THEN
1427: --
1428: IF (NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1429: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1430: (NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status) THEN
1431: IF IGS_AD_VAL_ACAI.admp_val_act_resp_dt (
1432: new_references.actual_response_dt,
1433: new_references.adm_offer_resp_status,
1434: new_references.offer_dt,
1435: v_message_name) = FALSE THEN
1446: NVL(new_references.cndtnl_offer_satisfied_dt,
1447: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1448: (NVL(old_references.adm_cndtnl_offer_status, '-1') <>
1449: new_references.adm_cndtnl_offer_status) THEN
1450: IF IGS_AD_VAL_ACAI.admp_val_stsfd_dt (
1451: new_references.cndtnl_offer_satisfied_dt,
1452: new_references.adm_cndtnl_offer_status,
1453: v_message_name) = FALSE THEN
1454: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1462: IF new_references.applicant_acptnce_cndtn IS NOT NULL AND
1463: (NVL(old_references.applicant_acptnce_cndtn, '-1') <> new_references.applicant_acptnce_cndtn OR
1464: NVL(old_references.adm_offer_resp_status, '-1') <>
1465: new_references.adm_offer_resp_status) THEN
1466: IF IGS_AD_VAL_ACAI.admp_val_acpt_cndtn (
1467: new_references.applicant_acptnce_cndtn,
1468: new_references.adm_offer_resp_status,
1469: v_message_name) = FALSE THEN
1470: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1478: IF new_references.cndtnl_offer_cndtn IS NOT NULL AND
1479: (NVL(old_references.cndtnl_offer_cndtn, '-1') <> new_references.cndtnl_offer_cndtn OR
1480: NVL(old_references.adm_cndtnl_offer_status, '-1') <>
1481: new_references.adm_cndtnl_offer_status) THEN
1482: IF IGS_AD_VAL_ACAI.admp_val_offer_cndtn (
1483: new_references.cndtnl_offer_cndtn,
1484: new_references.adm_cndtnl_offer_status,
1485: v_message_name) = FALSE THEN
1486: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1494: IF NVL(old_references.cndtnl_offer_must_be_stsfd_ind, '-') <>
1495: NVL(new_references.cndtnl_offer_must_be_stsfd_ind, '-') OR
1496: NVL(old_references.adm_cndtnl_offer_status, '-1') <>
1497: new_references.adm_cndtnl_offer_status THEN
1498: IF IGS_AD_VAL_ACAI.admp_val_must_stsfd (
1499: new_references.cndtnl_offer_must_be_stsfd_ind,
1500: new_references.adm_cndtnl_offer_status,
1501: new_references.adm_offer_resp_status,
1502: new_references.cndtnl_offer_satisfied_dt,
1510: -- Validate the fee category.
1511: --
1512: IF (new_references.fee_cat IS NOT NULL AND
1513: (NVL(old_references.fee_cat, '-1') <> new_references.fee_cat)) THEN
1514: IF IGS_AD_VAL_ACAI.admp_val_acai_fc (
1515: v_admission_cat,
1516: new_references.fee_cat,
1517: v_message_name) = FALSE THEN
1518: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1524: -- Validate the HECS payment option.
1525: --
1526: IF (new_references.hecs_payment_option IS NOT NULL AND
1527: (NVL(old_references.hecs_payment_option, '-1') <> new_references.hecs_payment_option)) THEN
1528: IF IGS_AD_VAL_ACAI.admp_val_acai_hpo (
1529: v_admission_cat,
1530: new_references.hecs_payment_option,
1531: v_message_name) = FALSE THEN
1532: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1538: -- Validate the correspondence category.
1539: --
1540: IF (new_references.correspondence_cat IS NOT NULL AND
1541: (NVL(old_references.correspondence_cat, '-1') <> new_references.correspondence_cat)) THEN
1542: IF IGS_AD_VAL_ACAI.admp_val_acai_cc (
1543: v_admission_cat,
1544: new_references.correspondence_cat,
1545: v_message_name) = FALSE THEN
1546: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1552: -- Validate the enrolment category.
1553: --
1554: IF (new_references.enrolment_cat IS NOT NULL AND
1555: (NVL(old_references.enrolment_cat, '-1') <> new_references.enrolment_cat)) THEN
1556: IF IGS_AD_VAL_ACAI.admp_val_acai_ec (
1557: v_admission_cat,
1558: new_references.enrolment_cat,
1559: v_message_name) = FALSE THEN
1560: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1566: -- Validate the funding source.
1567: --
1568: IF (new_references.funding_source IS NOT NULL AND
1569: (NVL(old_references.funding_source, '-1') <> new_references.funding_source)) THEN
1570: IF IGS_AD_VAL_ACAI.admp_val_acai_fs (
1571: new_references.course_cd,
1572: new_references.crv_version_number,
1573: new_references.funding_source,
1574: v_message_name) = FALSE THEN
1583: IF (NVL(old_references.expected_completion_yr, -1) <>
1584: NVL(new_references.expected_completion_yr, -1)) OR
1585: (NVL(old_references.expected_completion_perd, '-') <>
1586: NVL(new_references.expected_completion_perd, '-')) THEN
1587: IF IGS_AD_VAL_ACAI.admp_val_expctd_comp (
1588: new_references.expected_completion_yr,
1589: new_references.expected_completion_perd,
1590: v_message_name) = FALSE THEN
1591: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1607: NVL(old_references.attendance_mode, '-1') <> NVL(new_references.attendance_mode, '-1') OR
1608: NVL(old_references.attendance_type, '-1') <> NVL(new_references.attendance_type, '-1') OR
1609: NVL(old_references.unit_set_cd, '-1') <> NVL(new_references.unit_set_cd, '-1') OR
1610: NVL(old_references.us_version_number, -1) <> NVL(new_references.us_version_number, -1) ) THEN
1611: IF IGS_AD_VAL_ACAI.admp_val_dfrmnt_cal (
1612: new_references.deferred_adm_cal_type,
1613: new_references.deferred_adm_ci_sequence_num,
1614: new_references.def_acad_cal_type,
1615: new_references.adm_offer_resp_status,
1642: IF NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1643: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1644: NVL(new_references.adm_outcome_status_auth_dt,
1645: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1646: IF IGS_AD_VAL_ACAI.admp_val_ovrd_dt (
1647: new_references.adm_outcome_status_auth_dt,
1648: v_override_outcome_allowed_ind,
1649: v_message_name) = FALSE THEN
1650: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1660: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1661: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1662: NVL(new_references.adm_outcome_status_auth_dt,
1663: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1664: IF IGS_AD_VAL_ACAI.admp_val_ovrd_person (
1665: new_references.adm_otcm_status_auth_person_id,
1666: new_references.adm_outcome_status_auth_dt,
1667: v_override_outcome_allowed_ind,
1668: v_message_name) = FALSE THEN
1679: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1680: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1681: NVL(new_references.adm_outcome_status_auth_dt,
1682: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1683: IF IGS_AD_VAL_ACAI.admp_val_ovrd_reason (
1684: new_references.adm_outcome_status_reason,
1685: new_references.adm_outcome_status_auth_dt,
1686: v_override_outcome_allowed_ind,
1687: v_message_name) = FALSE THEN
1693: END IF; -- p_inserting or p_updating
1694: IF NVL(p_deleting,FALSE) THEN
1695:
1696: -- Validate delete of the admission IGS_PS_COURSE application instance record.
1697: IF IGS_AD_VAL_ACAI.admp_val_acai_delete (
1698: old_references.person_id,
1699: old_references.admission_appl_number,
1700: old_references.adm_outcome_status,
1701: v_message_name,
1749: END IF;
1750: END LOOP;
1751: -- Validate delete of a preference.
1752: IF v_pref_allowed_ind = 'Y' THEN
1753: IF IGS_AD_VAL_ACAI.admp_val_chg_of_pref (
1754: v_adm_cal_type,
1755: v_adm_ci_sequence_number,
1756: v_admission_cat,
1757: v_s_admission_process_type,
2113: -- by rrengara on 13-SEP-2002
2114: IF NVL(p_inserting,FALSE) THEN
2115: --Should be called only in case of an insert
2116: -- Validate insert of admission course application instance.
2117: IF IGS_AD_VAL_ACAI.admp_val_acai_insert (
2118: new_references.person_id,
2119: new_references.admission_appl_number,
2120: new_references.nominated_course_cd,
2121: new_references.sequence_number,
2142: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) THEN
2143: --
2144: -- Validate admission outcome status.
2145: --
2146: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
2147: new_references.person_id,
2148: new_references.admission_appl_number,
2149: new_references.nominated_course_cd,
2150: new_references.sequence_number,
2195: END IF;
2196: --
2197: -- Validate admission offer response status.
2198: --
2199: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
2200: new_references.person_id,
2201: new_references.admission_appl_number,
2202: new_references.nominated_course_cd,
2203: new_references.sequence_number,
2230: END IF;
2231: --
2232: -- Validate multiple offers across admission process categories.
2233: --
2234: IF IGS_AD_VAL_ACAI_STATUS.admp_val_offer_x_apc (
2235: new_references.person_id,
2236: new_references.admission_appl_number,
2237: new_references.nominated_course_cd,
2238: new_references.sequence_number,