[Home] [Help]
166: Open cur_old_ref_values;
167: Fetch cur_old_ref_values INTO old_references;
168: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
169: Close cur_old_ref_values;
170: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
171: IGS_AD_GEN_001.SET_TOKEN('From Table IGS_AD_PS_APPL_INST_ALL P_action NOT IN INSERT or VALiDATE_INSERT' );
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
505: CLOSE c_appl_dt;
506:
507: IF (new_references.adm_outcome_status_auth_dt IS NOT NULL
508: AND new_references.adm_outcome_status_auth_dt < l_appl_dt ) THEN
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
510: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_OS_AUTH_DT'));
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
506:
507: IF (new_references.adm_outcome_status_auth_dt IS NOT NULL
508: AND new_references.adm_outcome_status_auth_dt < l_appl_dt ) THEN
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
510: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_OS_AUTH_DT'));
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
514: IF ( new_references.offer_dt IS NOT NULL AND new_references.offer_dt < l_appl_dt ) THEN
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
514: IF ( new_references.offer_dt IS NOT NULL AND new_references.offer_dt < l_appl_dt ) THEN
515: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OFRDT_APPLDT');
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: IF ( new_references.offer_dt IS NOT NULL AND new_references.offer_dt > SYSDATE ) THEN
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: IF ( new_references.offer_dt IS NOT NULL AND new_references.offer_dt > SYSDATE ) THEN
520: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OFFER_DATE_INVALID');
521: IGS_GE_MSG_STACK.ADD;
522: APP_EXCEPTION.RAISE_EXCEPTION;
523: END IF;
524:
522: APP_EXCEPTION.RAISE_EXCEPTION;
523: END IF;
524:
525: IF (new_references.idx_calc_date IS NOT NULL AND new_references.idx_calc_date < l_appl_dt ) THEN
526: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
527: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_CALC_DATE'));
528: IGS_GE_MSG_STACK.ADD;
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: ELSIF new_references.idx_calc_date > SYSDATE THEN
523: END IF;
524:
525: IF (new_references.idx_calc_date IS NOT NULL AND new_references.idx_calc_date < l_appl_dt ) THEN
526: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
527: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_CALC_DATE'));
528: IGS_GE_MSG_STACK.ADD;
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: ELSIF new_references.idx_calc_date > SYSDATE THEN
531: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
527: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_CALC_DATE'));
528: IGS_GE_MSG_STACK.ADD;
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: ELSIF new_references.idx_calc_date > SYSDATE THEN
531: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CALC_DATE'));
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
528: IGS_GE_MSG_STACK.ADD;
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: ELSIF new_references.idx_calc_date > SYSDATE THEN
531: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CALC_DATE'));
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
536:
537: --stammine
538: IF NVL(new_references.decline_ofr_reason,'-1*$') <> NVL(old_references.decline_ofr_reason,'-1*$') THEN
539: FOR c_decl_ofr_rsn_rec IN c_decl_ofr_rsn(new_references.decline_ofr_reason)
540: LOOP
541: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DCL_OFR_RS_CLD');
542: IGS_GE_MSG_STACK.ADD;
543: App_Exception.Raise_Exception;
544: END LOOP;
545: END IF;
581: FETCH get_alternate_code INTO l_adm_alt_code;
582: CLOSE get_alternate_code;
583:
584:
585: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
586: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
587: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
588: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
589: IGS_GE_MSG_STACK.ADD;
582: CLOSE get_alternate_code;
583:
584:
585: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
586: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
587: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
588: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
589: IGS_GE_MSG_STACK.ADD;
590: APP_EXCEPTION.RAISE_EXCEPTION;
583:
584:
585: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
586: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
587: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
588: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
589: IGS_GE_MSG_STACK.ADD;
590: APP_EXCEPTION.RAISE_EXCEPTION;
591: ELSE
584:
585: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SINGLE_OFFRESP_EXISTS');
586: FND_MESSAGE.SET_TOKEN ('PROG_CODE',l_nominated_course_cd);
587: FND_MESSAGE.SET_TOKEN ('APPL_ID', TO_CHAR(l_application_id));
588: FND_MESSAGE.SET_TOKEN ('ACAD_ADM_PRD', l_acad_alt_code||'/'||l_adm_alt_code);
589: IGS_GE_MSG_STACK.ADD;
590: APP_EXCEPTION.RAISE_EXCEPTION;
591: ELSE
592: CLOSE get_aplinst_response_accepted;
720: NVL(old_references.correspondence_cat, '-1') <>
721: NVL(new_references.correspondence_cat, '-1') OR
722: NVL(old_references.enrolment_cat, '-1') <>
723: NVL(new_references.enrolment_cat, '-1') THEN
724: FND_MESSAGE.SET_NAME('IGS',v_message_name);
725: IGS_GE_MSG_STACK.ADD;
726: APP_EXCEPTION.RAISE_EXCEPTION;
727: END IF;
728: ELSE
734: AND old_references.def_appl_sequence_num IS NULL
735: )
736: OR check_non_updateable_list() THEN -- tried to update the fields which are not supposed to be updated in proced phase
737: IF IGS_AD_GEN_007.ADMP_GET_SAAS(old_references.appl_inst_status) = cst_withdrawn THEN
738: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_WITHD');
739: IGS_GE_MSG_STACK.ADD;
740: APP_EXCEPTION.RAISE_EXCEPTION;
741: ELSE
742: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_COMPL');
738: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_WITHD');
739: IGS_GE_MSG_STACK.ADD;
740: APP_EXCEPTION.RAISE_EXCEPTION;
741: ELSE
742: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_COMPL');
743: IGS_GE_MSG_STACK.ADD;
744: APP_EXCEPTION.RAISE_EXCEPTION;
745: END IF;
746: END IF;
754: -- Cannot update the IGS_PS_COURSE Version.
755: --
756: IF ((old_references.course_cd <> new_references.course_cd) OR
757: (old_references.crv_version_number <> new_references.crv_version_number)) THEN
758: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UPD_PRGVER_NOTALLOW');
759: IGS_GE_MSG_STACK.ADD;
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END IF;
762: --
774: new_references.location_cd,
775: new_references.attendance_mode,
776: new_references.attendance_type,
777: v_message_name) = FALSE THEN
778: FND_MESSAGE.SET_NAME('IGS',v_message_name);
779: IGS_GE_MSG_STACK.ADD;
780: APP_EXCEPTION.RAISE_EXCEPTION;
781: END IF;
782: END IF;
795: new_references.location_cd,
796: new_references.attendance_mode,
797: new_references.attendance_type,
798: v_message_name) = FALSE THEN
799: FND_MESSAGE.SET_NAME('IGS',v_message_name);
800: IGS_GE_MSG_STACK.ADD;
801: APP_EXCEPTION.RAISE_EXCEPTION;
802: END IF;
803: END IF;
807: -- If either calendar component is set, then both must be set.
808: --
809: IF new_references.adm_cal_type IS NOT NULL AND
810: new_references.adm_ci_sequence_number IS NULL THEN
811: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ADMCAL_SET_ADMCAL_SET');
812: IGS_GE_MSG_STACK.ADD;
813: APP_EXCEPTION.RAISE_EXCEPTION;
814: END IF;
815: IF new_references.adm_ci_sequence_number IS NOT NULL AND
813: APP_EXCEPTION.RAISE_EXCEPTION;
814: END IF;
815: IF new_references.adm_ci_sequence_number IS NOT NULL AND
816: new_references.adm_cal_type IS NULL THEN
817: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ADMCAL_SET_ADMCAL_SET');
818: IGS_GE_MSG_STACK.ADD;
819: APP_EXCEPTION.RAISE_EXCEPTION;
820: END IF;
821: IF new_references.adm_cal_type IS NOT NULL AND
828: v_acad_ci_sequence_number,
829: v_admission_cat,
830: v_s_admission_process_type,
831: v_message_name) = FALSE THEN
832: FND_MESSAGE.SET_NAME('IGS',v_message_name);
833: IGS_GE_MSG_STACK.ADD;
834: APP_EXCEPTION.RAISE_EXCEPTION;
835: END IF;
836: END IF;
864: v_crv_version_number,
865: v_message_name,
866: v_return_type) = FALSE THEN
867: IF NVL(v_return_type, '-1') = cst_error THEN
868: FND_MESSAGE.SET_NAME('IGS',v_message_name);
869: IGS_GE_MSG_STACK.ADD;
870: APP_EXCEPTION.RAISE_EXCEPTION;
871: END IF;
872: END IF;
888: v_offer_ind,
889: v_message_name,
890: v_return_type) = FALSE THEN
891: IF NVL(v_return_type, '-1') = cst_error THEN
892: FND_MESSAGE.SET_NAME('IGS',v_message_name);
893: IGS_GE_MSG_STACK.ADD;
894: APP_EXCEPTION.RAISE_EXCEPTION;
895: END IF;
896: END IF;
911: v_offer_ind,
912: v_message_name,
913: v_return_type) = FALSE THEN
914: IF NVL(v_return_type, '-1') = cst_error THEN
915: FND_MESSAGE.SET_NAME('IGS',v_message_name);
916: IGS_GE_MSG_STACK.ADD;
917: APP_EXCEPTION.RAISE_EXCEPTION;
918: END IF;
919: END IF;
944: v_adm_ci_sequence_number,
945: v_message_name,
946: v_return_type) = FALSE THEN
947: IF NVL(v_return_type, '-1') = cst_error THEN
948: FND_MESSAGE.SET_NAME('IGS',v_message_name);
949: IGS_GE_MSG_STACK.ADD;
950: APP_EXCEPTION.RAISE_EXCEPTION;
951: END IF;
952: END IF;
981: v_message_name,
982: v_return_type,
983: v_late_ind) = FALSE THEN
984: IF NVL(v_return_type, '-1') = cst_error THEN
985: FND_MESSAGE.SET_NAME('IGS',v_message_name);
986: IGS_GE_MSG_STACK.ADD;
987: APP_EXCEPTION.RAISE_EXCEPTION;
988: END IF;
989: END IF;
1017: v_offer_ind,
1018: v_appl_dt,
1019: v_late_appl_allowed_ind,
1020: v_message_name) = FALSE THEN
1021: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1022: IGS_GE_MSG_STACK.ADD;
1023: APP_EXCEPTION.RAISE_EXCEPTION;
1024: END IF;
1025: END IF;
1050: v_unit_set_appl_ind,
1051: v_message_name,
1052: v_return_type) = FALSE THEN
1053: IF NVL(v_return_type, '-1') = cst_error THEN
1054: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1055: IGS_GE_MSG_STACK.ADD;
1056: APP_EXCEPTION.RAISE_EXCEPTION;
1057: END IF;
1058: END IF;
1078: v_offer_ind,
1079: v_message_name,
1080: v_return_type) = FALSE THEN
1081: IF NVL(v_return_type, '-1') = cst_error THEN
1082: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1083: IGS_GE_MSG_STACK.ADD;
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1085: END IF;
1086: END IF;
1094: v_pref_allowed_ind ,
1095: v_pref_limit,
1096: v_s_admission_process_type,
1097: v_message_name) = FALSE THEN
1098: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1099: IGS_GE_MSG_STACK.ADD;
1100: APP_EXCEPTION.RAISE_EXCEPTION;
1101: END IF;
1102: END IF;
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
1117: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1118: IGS_GE_MSG_STACK.ADD;
1119: APP_EXCEPTION.RAISE_EXCEPTION;
1120: END IF;
1121: END IF;
1129: new_references.adm_cndtnl_offer_status,
1130: v_s_admission_process_type,
1131: v_cond_offer_doc_allowed_ind,
1132: v_message_name) = FALSE THEN
1133: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1134: IGS_GE_MSG_STACK.ADD;
1135: APP_EXCEPTION.RAISE_EXCEPTION;
1136: END IF;
1137: END IF;
1165: v_s_admission_process_type,
1166: new_references.adm_outcome_status,
1167: new_references.adm_cndtnl_offer_status,
1168: v_message_name) = FALSE THEN
1169: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1170: IGS_GE_MSG_STACK.ADD;
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172: END IF;
1173: END IF;
1233: v_check_person_encumb,
1234: v_check_course_encumb,
1235: 'TRG_BR', -- Called From.
1236: v_message_name) = FALSE THEN
1237: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1238: IGS_GE_MSG_STACK.ADD;
1239: APP_EXCEPTION.RAISE_EXCEPTION;
1240: END IF;
1241: END IF;
1248: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),
1249: v_message_name,
1250: v_return_type) = FALSE THEN
1251: IF NVL(v_return_type, '-1') = cst_error THEN
1252: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1253: IGS_GE_MSG_STACK.ADD;
1254: APP_EXCEPTION.RAISE_EXCEPTION;
1255: END IF;
1256: END IF;
1264: new_references.appl_inst_status,
1265: new_references.ais_reason ,
1266: new_references.adm_outcome_status,
1267: v_message_name)= FALSE THEN
1268: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1269: IGS_GE_MSG_STACK.ADD;
1270: APP_EXCEPTION.RAISE_EXCEPTION;
1271: END IF;
1272: END IF;
1308: v_message_name,
1309: new_references.decline_ofr_reason , -- IGSM
1310: new_references.attent_other_inst_cd -- igsm
1311: ) = FALSE THEN
1312: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1313: IGS_GE_MSG_STACK.ADD;
1314: APP_EXCEPTION.RAISE_EXCEPTION;
1315: END IF;
1316: END IF;
1331: v_cond_offer_ass_allowed_ind,
1332: v_cond_offer_fee_allowed_ind,
1333: v_cond_offer_doc_allowed_ind,
1334: v_message_name) = FALSE THEN
1335: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1336: IGS_GE_MSG_STACK.ADD;
1337: APP_EXCEPTION.RAISE_EXCEPTION;
1338: END IF;
1339: END IF;
1353: new_references.adm_offer_resp_status,
1354: v_deferral_allowed_ind,
1355: v_s_admission_process_type,
1356: v_message_name) = FALSE THEN
1357: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1358: IGS_GE_MSG_STACK.ADD;
1359: APP_EXCEPTION.RAISE_EXCEPTION;
1360: END IF;
1361: END IF;
1373: new_references.adm_outcome_status,
1374: v_adm_cal_type,
1375: v_adm_ci_sequence_number,
1376: v_message_name) = FALSE THEN
1377: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1378: IGS_GE_MSG_STACK.ADD;
1379: APP_EXCEPTION.RAISE_EXCEPTION;
1380: END IF;
1381: END IF;
1391: new_references.offer_response_dt,
1392: new_references.adm_outcome_status,
1393: new_references.offer_dt,
1394: v_message_name) = FALSE THEN
1395: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1396: IGS_GE_MSG_STACK.ADD;
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: END IF;
1399: END IF;
1416: NULL, -- Minimum submission date.
1417: v_ca_sequence_number,
1418: 'ACAI', -- Parent.
1419: v_message_name) = FALSE THEN
1420: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1421: IGS_GE_MSG_STACK.ADD;
1422: APP_EXCEPTION.RAISE_EXCEPTION;
1423: END IF;
1424: END IF;
1432: new_references.actual_response_dt,
1433: new_references.adm_offer_resp_status,
1434: new_references.offer_dt,
1435: v_message_name) = FALSE THEN
1436: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1437: IGS_GE_MSG_STACK.ADD;
1438: APP_EXCEPTION.RAISE_EXCEPTION;
1439: END IF;
1440: END IF;
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);
1455: IGS_GE_MSG_STACK.ADD;
1456: APP_EXCEPTION.RAISE_EXCEPTION;
1457: END IF;
1458: END IF;
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);
1471: IGS_GE_MSG_STACK.ADD;
1472: APP_EXCEPTION.RAISE_EXCEPTION;
1473: END IF;
1474: END IF;
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);
1487: IGS_GE_MSG_STACK.ADD;
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489: END IF;
1490: END IF;
1500: new_references.adm_cndtnl_offer_status,
1501: new_references.adm_offer_resp_status,
1502: new_references.cndtnl_offer_satisfied_dt,
1503: v_message_name) = FALSE THEN
1504: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1505: IGS_GE_MSG_STACK.ADD;
1506: APP_EXCEPTION.RAISE_EXCEPTION;
1507: END IF;
1508: END IF;
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);
1519: IGS_GE_MSG_STACK.ADD;
1520: APP_EXCEPTION.RAISE_EXCEPTION;
1521: END IF;
1522: END IF;
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);
1533: IGS_GE_MSG_STACK.ADD;
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1535: END IF;
1536: END IF;
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);
1547: IGS_GE_MSG_STACK.ADD;
1548: APP_EXCEPTION.RAISE_EXCEPTION;
1549: END IF;
1550: END IF;
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);
1561: IGS_GE_MSG_STACK.ADD;
1562: APP_EXCEPTION.RAISE_EXCEPTION;
1563: END IF;
1564: END IF;
1571: new_references.course_cd,
1572: new_references.crv_version_number,
1573: new_references.funding_source,
1574: v_message_name) = FALSE THEN
1575: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1576: IGS_GE_MSG_STACK.ADD;
1577: APP_EXCEPTION.RAISE_EXCEPTION;
1578: END IF;
1579: END IF;
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);
1592: IGS_GE_MSG_STACK.ADD;
1593: APP_EXCEPTION.RAISE_EXCEPTION;
1594: END IF;
1595: END IF;
1629: v_return_type,
1630: new_references.def_acad_ci_sequence_num --added the parameter as the signature of the function is changed (rghosh-bug#2765260)
1631: ) = FALSE THEN
1632: IF NVL(v_return_type, '-1') = cst_error THEN
1633: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1634: IGS_GE_MSG_STACK.ADD;
1635: APP_EXCEPTION.RAISE_EXCEPTION;
1636: END IF;
1637: END IF;
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);
1651: IGS_GE_MSG_STACK.ADD;
1652: APP_EXCEPTION.RAISE_EXCEPTION;
1653: END IF;
1654: END IF;
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
1669: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1670: IGS_GE_MSG_STACK.ADD;
1671: APP_EXCEPTION.RAISE_EXCEPTION;
1672: END IF;
1673: END IF;
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
1688: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1689: IGS_GE_MSG_STACK.ADD;
1690: APP_EXCEPTION.RAISE_EXCEPTION;
1691: END IF;
1692: END IF;
1700: old_references.adm_outcome_status,
1701: v_message_name,
1702: v_return_type) = FALSE THEN
1703: IF NVL(v_return_type, '-1') = cst_error THEN
1704: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1705: IGS_GE_MSG_STACK.ADD;
1706: APP_EXCEPTION.RAISE_EXCEPTION;
1707: END IF;
1708: END IF;
1761: old_references.location_cd,
1762: old_references.attendance_mode,
1763: old_references.attendance_type,
1764: v_message_name) = FALSE THEN
1765: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1766: IGS_GE_MSG_STACK.ADD;
1767: APP_EXCEPTION.RAISE_EXCEPTION;
1768: END IF;
1769: END IF;
2132: FALSE, -- Validate AA Only
2133: v_message_name,
2134: v_return_type) = FALSE THEN
2135: IF NVL(v_return_type, '-1') = cst_error THEN
2136: FND_MESSAGE.SET_NAME('IGS',v_message_name);
2137: IGS_GE_MSG_STACK.ADD;
2138: APP_EXCEPTION.RAISE_EXCEPTION;
2139: END IF;
2140: END IF;
2188: v_check_person_encumb,
2189: v_check_course_encumb,
2190: 'TRG_AS', -- Called From.
2191: v_message_name) = FALSE THEN
2192: FND_MESSAGE.SET_NAME('IGS',v_message_name);
2193: IGS_GE_MSG_STACK.ADD;
2194: APP_EXCEPTION.RAISE_EXCEPTION;
2195: END IF;
2196: --
2223: v_message_name,
2224: new_references.decline_ofr_reason , -- IGSM
2225: new_references.attent_other_inst_cd -- igsm
2226: ) = FALSE THEN
2227: FND_MESSAGE.SET_NAME('IGS',v_message_name);
2228: IGS_GE_MSG_STACK.ADD;
2229: APP_EXCEPTION.RAISE_EXCEPTION;
2230: END IF;
2231: --
2244: v_s_admission_process_type,
2245: v_message_name,
2246: v_return_type) = FALSE THEN
2247: IF NVL(v_return_type, '-1') = cst_error THEN
2248: FND_MESSAGE.SET_NAME('IGS',v_message_name);
2249: IGS_GE_MSG_STACK.ADD;
2250: APP_EXCEPTION.RAISE_EXCEPTION;
2251: END IF;
2252: END IF;
2407: old_references.admission_appl_number,
2408: old_references.nominated_course_cd,
2409: old_references.sequence_number,
2410: v_message_name) = FALSE THEN
2411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
2412: IGS_GE_MSG_STACK.ADD;
2413: APP_EXCEPTION.RAISE_EXCEPTION;
2414: END IF ;
2415: END IF;
2537: new_references.appl_inst_status := column_value;
2538: END IF;
2539: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR column_name IS NULL THEN
2540: IF (new_references.expected_completion_perd) NOT IN ('E','M','S') THEN
2541: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
2543: IGS_GE_MSG_STACK.ADD;
2544: APP_EXCEPTION.RAISE_EXCEPTION;
2545: END IF;
2538: END IF;
2539: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR column_name IS NULL THEN
2540: IF (new_references.expected_completion_perd) NOT IN ('E','M','S') THEN
2541: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
2543: IGS_GE_MSG_STACK.ADD;
2544: APP_EXCEPTION.RAISE_EXCEPTION;
2545: END IF;
2546: END IF;
2545: END IF;
2546: END IF;
2547: IF upper(column_name) = 'EXPECTED_COMPLETION_YR' OR column_name IS NULL THEN
2548: IF new_references.expected_completion_yr < 0 OR new_references.expected_completion_yr > 9999 THEN
2549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
2551: IGS_GE_MSG_STACK.ADD;
2552: APP_EXCEPTION.RAISE_EXCEPTION;
2553: END IF;
2546: END IF;
2547: IF upper(column_name) = 'EXPECTED_COMPLETION_YR' OR column_name IS NULL THEN
2548: IF new_references.expected_completion_yr < 0 OR new_references.expected_completion_yr > 9999 THEN
2549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
2551: IGS_GE_MSG_STACK.ADD;
2552: APP_EXCEPTION.RAISE_EXCEPTION;
2553: END IF;
2554: END IF;
2553: END IF;
2554: END IF;
2555: IF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' OR column_name IS NULL THEN
2556: IF new_references.intrntnl_acceptance_advice_num < 0 OR new_references.intrntnl_acceptance_advice_num > 999999999999999 THEN
2557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
2559: IGS_GE_MSG_STACK.ADD;
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2561: END IF;
2554: END IF;
2555: IF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' OR column_name IS NULL THEN
2556: IF new_references.intrntnl_acceptance_advice_num < 0 OR new_references.intrntnl_acceptance_advice_num > 999999999999999 THEN
2557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
2559: IGS_GE_MSG_STACK.ADD;
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2561: END IF;
2562: END IF;
2561: END IF;
2562: END IF;
2563: IF upper(column_name) = 'SECONDARY_ASS_RANK' OR column_name IS NULL THEN
2564: IF new_references.secondary_ass_rank < 1 OR new_references.secondary_ass_rank > 999 THEN
2565: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASSESSMENT_RANK'));
2567: IGS_GE_MSG_STACK.ADD;
2568: APP_EXCEPTION.RAISE_EXCEPTION;
2569: END IF;
2562: END IF;
2563: IF upper(column_name) = 'SECONDARY_ASS_RANK' OR column_name IS NULL THEN
2564: IF new_references.secondary_ass_rank < 1 OR new_references.secondary_ass_rank > 999 THEN
2565: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASSESSMENT_RANK'));
2567: IGS_GE_MSG_STACK.ADD;
2568: APP_EXCEPTION.RAISE_EXCEPTION;
2569: END IF;
2570: END IF;
2569: END IF;
2570: END IF;
2571: IF upper(column_name) = 'ASS_RANK' OR column_name IS NULL THEN
2572: IF new_references.ass_rank < 1 OR new_references.ass_rank > 999 THEN
2573: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2574: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASSESSMENT_RANK'));
2575: IGS_GE_MSG_STACK.ADD;
2576: APP_EXCEPTION.RAISE_EXCEPTION;
2577: END IF;
2570: END IF;
2571: IF upper(column_name) = 'ASS_RANK' OR column_name IS NULL THEN
2572: IF new_references.ass_rank < 1 OR new_references.ass_rank > 999 THEN
2573: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2574: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASSESSMENT_RANK'));
2575: IGS_GE_MSG_STACK.ADD;
2576: APP_EXCEPTION.RAISE_EXCEPTION;
2577: END IF;
2578: END IF;
2577: END IF;
2578: END IF;
2579: IF upper(column_name) = 'DEFERRED_ADM_CI_SEQUENCE_NUM' OR column_name IS NULL THEN
2580: IF new_references.deferred_adm_ci_sequence_num < 1 OR new_references.deferred_adm_ci_sequence_num > 999999 THEN
2581: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2583: IGS_GE_MSG_STACK.ADD;
2584: APP_EXCEPTION.RAISE_EXCEPTION;
2585: END IF;
2578: END IF;
2579: IF upper(column_name) = 'DEFERRED_ADM_CI_SEQUENCE_NUM' OR column_name IS NULL THEN
2580: IF new_references.deferred_adm_ci_sequence_num < 1 OR new_references.deferred_adm_ci_sequence_num > 999999 THEN
2581: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2583: IGS_GE_MSG_STACK.ADD;
2584: APP_EXCEPTION.RAISE_EXCEPTION;
2585: END IF;
2586: END IF;
2586: END IF;
2587: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' OR column_name IS NULL THEN
2588: IF new_references.cndtnl_offer_must_be_stsfd_ind NOT IN ('Y','N')
2589: THEN
2590: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
2592: IGS_GE_MSG_STACK.ADD;
2593: APP_EXCEPTION.RAISE_EXCEPTION;
2594: END IF;
2587: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' OR column_name IS NULL THEN
2588: IF new_references.cndtnl_offer_must_be_stsfd_ind NOT IN ('Y','N')
2589: THEN
2590: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
2592: IGS_GE_MSG_STACK.ADD;
2593: APP_EXCEPTION.RAISE_EXCEPTION;
2594: END IF;
2595: END IF;
2594: END IF;
2595: END IF;
2596: IF upper(column_name) = 'PREFERENCE_NUMBER' OR column_name IS NULL THEN
2597: IF new_references.preference_number < 1 OR new_references.preference_number > 99 THEN
2598: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PREFERANCE_NUM'));
2600: IGS_GE_MSG_STACK.ADD;
2601: APP_EXCEPTION.RAISE_EXCEPTION;
2602: END IF;
2595: END IF;
2596: IF upper(column_name) = 'PREFERENCE_NUMBER' OR column_name IS NULL THEN
2597: IF new_references.preference_number < 1 OR new_references.preference_number > 99 THEN
2598: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PREFERANCE_NUM'));
2600: IGS_GE_MSG_STACK.ADD;
2601: APP_EXCEPTION.RAISE_EXCEPTION;
2602: END IF;
2603: END IF;
2602: END IF;
2603: END IF;
2604: IF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' OR column_name IS NULL THEN
2605: IF new_references.adm_ci_sequence_number < 1 OR new_references.adm_ci_sequence_number > 999999 THEN
2606: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2608: IGS_GE_MSG_STACK.ADD;
2609: APP_EXCEPTION.RAISE_EXCEPTION;
2610: END IF;
2603: END IF;
2604: IF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' OR column_name IS NULL THEN
2605: IF new_references.adm_ci_sequence_number < 1 OR new_references.adm_ci_sequence_number > 999999 THEN
2606: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2608: IGS_GE_MSG_STACK.ADD;
2609: APP_EXCEPTION.RAISE_EXCEPTION;
2610: END IF;
2611: END IF;
2610: END IF;
2611: END IF;
2612: IF upper(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL THEN
2613: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN
2614: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2616: IGS_GE_MSG_STACK.ADD;
2617: APP_EXCEPTION.RAISE_EXCEPTION;
2618: END IF;
2611: END IF;
2612: IF upper(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL THEN
2613: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN
2614: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2616: IGS_GE_MSG_STACK.ADD;
2617: APP_EXCEPTION.RAISE_EXCEPTION;
2618: END IF;
2619: END IF;
2618: END IF;
2619: END IF;
2620: IF upper(column_name) = 'ADM_CAL_TYPE' OR column_name IS NULL THEN
2621: IF new_references.adm_cal_type <> UPPER(new_references.adm_cal_type) THEN
2622: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2623: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2624: IGS_GE_MSG_STACK.ADD;
2625: APP_EXCEPTION.RAISE_EXCEPTION;
2626: END IF;
2619: END IF;
2620: IF upper(column_name) = 'ADM_CAL_TYPE' OR column_name IS NULL THEN
2621: IF new_references.adm_cal_type <> UPPER(new_references.adm_cal_type) THEN
2622: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2623: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2624: IGS_GE_MSG_STACK.ADD;
2625: APP_EXCEPTION.RAISE_EXCEPTION;
2626: END IF;
2627: END IF;
2626: END IF;
2627: END IF;
2628: IF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' OR column_name IS NULL THEN
2629: IF new_references.adm_cndtnl_offer_status <> UPPER(new_references.adm_cndtnl_offer_status) THEN
2630: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
2632: IGS_GE_MSG_STACK.ADD;
2633: APP_EXCEPTION.RAISE_EXCEPTION;
2634: END IF;
2627: END IF;
2628: IF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' OR column_name IS NULL THEN
2629: IF new_references.adm_cndtnl_offer_status <> UPPER(new_references.adm_cndtnl_offer_status) THEN
2630: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
2632: IGS_GE_MSG_STACK.ADD;
2633: APP_EXCEPTION.RAISE_EXCEPTION;
2634: END IF;
2635: END IF;
2634: END IF;
2635: END IF;
2636: IF upper(column_name) = 'ADM_DOC_STATUS' OR column_name IS NULL THEN
2637: IF new_references.adm_doc_status <> UPPER(new_references.adm_doc_status) THEN
2638: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_DOC_STAT'));
2640: IGS_GE_MSG_STACK.ADD;
2641: APP_EXCEPTION.RAISE_EXCEPTION;
2642: END IF;
2635: END IF;
2636: IF upper(column_name) = 'ADM_DOC_STATUS' OR column_name IS NULL THEN
2637: IF new_references.adm_doc_status <> UPPER(new_references.adm_doc_status) THEN
2638: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_DOC_STAT'));
2640: IGS_GE_MSG_STACK.ADD;
2641: APP_EXCEPTION.RAISE_EXCEPTION;
2642: END IF;
2643: END IF;
2642: END IF;
2643: END IF;
2644: IF upper(column_name) = 'ADM_ENTRY_QUAL_STATUS' OR column_name IS NULL THEN
2645: IF new_references.adm_entry_qual_status <> UPPER(new_references.adm_entry_qual_status) THEN
2646: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_ENTRY_QUAL_STATUS'));
2648: IGS_GE_MSG_STACK.ADD;
2649: APP_EXCEPTION.RAISE_EXCEPTION;
2650: END IF;
2643: END IF;
2644: IF upper(column_name) = 'ADM_ENTRY_QUAL_STATUS' OR column_name IS NULL THEN
2645: IF new_references.adm_entry_qual_status <> UPPER(new_references.adm_entry_qual_status) THEN
2646: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_ENTRY_QUAL_STATUS'));
2648: IGS_GE_MSG_STACK.ADD;
2649: APP_EXCEPTION.RAISE_EXCEPTION;
2650: END IF;
2651: END IF;
2650: END IF;
2651: END IF;
2652: IF upper(column_name) = 'ADM_OFFER_DFRMNT_STATUS' OR column_name IS NULL THEN
2653: IF new_references.adm_offer_dfrmnt_status <> UPPER(new_references.adm_offer_dfrmnt_status) THEN
2654: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_DFRMNT_STATUS'));
2656: IGS_GE_MSG_STACK.ADD;
2657: APP_EXCEPTION.RAISE_EXCEPTION;
2658: END IF;
2651: END IF;
2652: IF upper(column_name) = 'ADM_OFFER_DFRMNT_STATUS' OR column_name IS NULL THEN
2653: IF new_references.adm_offer_dfrmnt_status <> UPPER(new_references.adm_offer_dfrmnt_status) THEN
2654: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_DFRMNT_STATUS'));
2656: IGS_GE_MSG_STACK.ADD;
2657: APP_EXCEPTION.RAISE_EXCEPTION;
2658: END IF;
2659: END IF;
2658: END IF;
2659: END IF;
2660: IF upper(column_name) = 'ADM_OFFER_RESP_STATUS' OR column_name IS NULL THEN
2661: IF new_references.adm_offer_resp_status <> UPPER(new_references.adm_offer_resp_status) THEN
2662: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
2664: IGS_GE_MSG_STACK.ADD;
2665: APP_EXCEPTION.RAISE_EXCEPTION;
2666: END IF;
2659: END IF;
2660: IF upper(column_name) = 'ADM_OFFER_RESP_STATUS' OR column_name IS NULL THEN
2661: IF new_references.adm_offer_resp_status <> UPPER(new_references.adm_offer_resp_status) THEN
2662: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
2664: IGS_GE_MSG_STACK.ADD;
2665: APP_EXCEPTION.RAISE_EXCEPTION;
2666: END IF;
2667: END IF;
2666: END IF;
2667: END IF;
2668: IF upper(column_name) = 'ADM_OUTCOME_STATUS' OR column_name IS NULL THEN
2669: IF new_references.adm_outcome_status <> UPPER(new_references.adm_outcome_status) THEN
2670: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2671: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
2672: IGS_GE_MSG_STACK.ADD;
2673: APP_EXCEPTION.RAISE_EXCEPTION;
2674: END IF;
2667: END IF;
2668: IF upper(column_name) = 'ADM_OUTCOME_STATUS' OR column_name IS NULL THEN
2669: IF new_references.adm_outcome_status <> UPPER(new_references.adm_outcome_status) THEN
2670: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2671: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
2672: IGS_GE_MSG_STACK.ADD;
2673: APP_EXCEPTION.RAISE_EXCEPTION;
2674: END IF;
2675: END IF;
2674: END IF;
2675: END IF;
2676: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSTD_IND' OR column_name IS NULL THEN
2677: IF new_references.cndtnl_offer_must_be_stsfd_ind <> UPPER(new_references.cndtnl_offer_must_be_stsfd_ind) THEN
2678: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2679: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
2680: IGS_GE_MSG_STACK.ADD;
2681: APP_EXCEPTION.RAISE_EXCEPTION;
2682: END IF;
2675: END IF;
2676: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSTD_IND' OR column_name IS NULL THEN
2677: IF new_references.cndtnl_offer_must_be_stsfd_ind <> UPPER(new_references.cndtnl_offer_must_be_stsfd_ind) THEN
2678: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2679: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
2680: IGS_GE_MSG_STACK.ADD;
2681: APP_EXCEPTION.RAISE_EXCEPTION;
2682: END IF;
2683: END IF;
2682: END IF;
2683: END IF;
2684: IF upper(column_name) = 'CORRESPONDENCE_CAT' OR column_name IS NULL THEN
2685: IF new_references.correspondence_cat <> UPPER(new_references.correspondence_cat) THEN
2686: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRSPOND_CAT'));
2688: IGS_GE_MSG_STACK.ADD;
2689: APP_EXCEPTION.RAISE_EXCEPTION;
2690: END IF;
2683: END IF;
2684: IF upper(column_name) = 'CORRESPONDENCE_CAT' OR column_name IS NULL THEN
2685: IF new_references.correspondence_cat <> UPPER(new_references.correspondence_cat) THEN
2686: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRSPOND_CAT'));
2688: IGS_GE_MSG_STACK.ADD;
2689: APP_EXCEPTION.RAISE_EXCEPTION;
2690: END IF;
2691: END IF;
2690: END IF;
2691: END IF;
2692: IF upper(column_name) = 'COURSE_CD' OR column_name IS NULL THEN
2693: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
2694: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2696: IGS_GE_MSG_STACK.ADD;
2697: APP_EXCEPTION.RAISE_EXCEPTION;
2698: END IF;
2691: END IF;
2692: IF upper(column_name) = 'COURSE_CD' OR column_name IS NULL THEN
2693: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
2694: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2696: IGS_GE_MSG_STACK.ADD;
2697: APP_EXCEPTION.RAISE_EXCEPTION;
2698: END IF;
2699: END IF;
2698: END IF;
2699: END IF;
2700: IF upper(column_name) = 'DEFERRED_ADM_CAL_TYPE' OR column_name IS NULL THEN
2701: IF new_references.deferred_adm_cal_type <> UPPER(new_references.deferred_adm_cal_type) THEN
2702: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2704: IGS_GE_MSG_STACK.ADD;
2705: APP_EXCEPTION.RAISE_EXCEPTION;
2706: END IF;
2699: END IF;
2700: IF upper(column_name) = 'DEFERRED_ADM_CAL_TYPE' OR column_name IS NULL THEN
2701: IF new_references.deferred_adm_cal_type <> UPPER(new_references.deferred_adm_cal_type) THEN
2702: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2704: IGS_GE_MSG_STACK.ADD;
2705: APP_EXCEPTION.RAISE_EXCEPTION;
2706: END IF;
2707: END IF;
2706: END IF;
2707: END IF;
2708: IF upper(column_name) = 'ENROLMENT_CAT' OR column_name IS NULL THEN
2709: IF new_references.enrolment_cat <> UPPER(new_references.enrolment_cat) THEN
2710: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
2712: IGS_GE_MSG_STACK.ADD;
2713: APP_EXCEPTION.RAISE_EXCEPTION;
2714: END IF;
2707: END IF;
2708: IF upper(column_name) = 'ENROLMENT_CAT' OR column_name IS NULL THEN
2709: IF new_references.enrolment_cat <> UPPER(new_references.enrolment_cat) THEN
2710: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
2712: IGS_GE_MSG_STACK.ADD;
2713: APP_EXCEPTION.RAISE_EXCEPTION;
2714: END IF;
2715: END IF;
2714: END IF;
2715: END IF;
2716: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR column_name IS NULL THEN
2717: IF new_references.expected_completion_perd <> UPPER(new_references.expected_completion_perd) THEN
2718: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
2720: IGS_GE_MSG_STACK.ADD;
2721: APP_EXCEPTION.RAISE_EXCEPTION;
2722: END IF;
2715: END IF;
2716: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR column_name IS NULL THEN
2717: IF new_references.expected_completion_perd <> UPPER(new_references.expected_completion_perd) THEN
2718: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
2720: IGS_GE_MSG_STACK.ADD;
2721: APP_EXCEPTION.RAISE_EXCEPTION;
2722: END IF;
2723: END IF;
2722: END IF;
2723: END IF;
2724: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
2725: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
2726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
2728: IGS_GE_MSG_STACK.ADD;
2729: APP_EXCEPTION.RAISE_EXCEPTION;
2730: END IF;
2723: END IF;
2724: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
2725: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
2726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
2728: IGS_GE_MSG_STACK.ADD;
2729: APP_EXCEPTION.RAISE_EXCEPTION;
2730: END IF;
2731: END IF;
2730: END IF;
2731: END IF;
2732: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
2733: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option) THEN
2734: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HECS_PAY_OPT'));
2736: IGS_GE_MSG_STACK.ADD;
2737: APP_EXCEPTION.RAISE_EXCEPTION;
2738: END IF;
2731: END IF;
2732: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
2733: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option) THEN
2734: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HECS_PAY_OPT'));
2736: IGS_GE_MSG_STACK.ADD;
2737: APP_EXCEPTION.RAISE_EXCEPTION;
2738: END IF;
2739: END IF;
2738: END IF;
2739: END IF;
2740: IF upper(column_name) = 'LATE_ADM_FEE_STATUS' OR column_name IS NULL THEN
2741: IF new_references.late_adm_fee_status <> UPPER(new_references.late_adm_fee_status) THEN
2742: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_LATE_ADM_FEE_STATUS'));
2744: IGS_GE_MSG_STACK.ADD;
2745: APP_EXCEPTION.RAISE_EXCEPTION;
2746: END IF;
2739: END IF;
2740: IF upper(column_name) = 'LATE_ADM_FEE_STATUS' OR column_name IS NULL THEN
2741: IF new_references.late_adm_fee_status <> UPPER(new_references.late_adm_fee_status) THEN
2742: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_LATE_ADM_FEE_STATUS'));
2744: IGS_GE_MSG_STACK.ADD;
2745: APP_EXCEPTION.RAISE_EXCEPTION;
2746: END IF;
2747: END IF;
2746: END IF;
2747: END IF;
2748: IF upper(column_name) = 'NOMINATED_COURSE_CD' OR column_name IS NULL THEN
2749: IF new_references.nominated_course_cd <> UPPER(new_references.nominated_course_cd) THEN
2750: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE'));
2752: IGS_GE_MSG_STACK.ADD;
2753: APP_EXCEPTION.RAISE_EXCEPTION;
2754: END IF;
2747: END IF;
2748: IF upper(column_name) = 'NOMINATED_COURSE_CD' OR column_name IS NULL THEN
2749: IF new_references.nominated_course_cd <> UPPER(new_references.nominated_course_cd) THEN
2750: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE'));
2752: IGS_GE_MSG_STACK.ADD;
2753: APP_EXCEPTION.RAISE_EXCEPTION;
2754: END IF;
2755: END IF;
2754: END IF;
2755: END IF;
2756: IF upper(column_name) = 'UNIT_SET_CD' OR column_name IS NULL THEN
2757: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
2758: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
2760: IGS_GE_MSG_STACK.ADD;
2761: APP_EXCEPTION.RAISE_EXCEPTION;
2762: END IF;
2755: END IF;
2756: IF upper(column_name) = 'UNIT_SET_CD' OR column_name IS NULL THEN
2757: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
2758: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
2760: IGS_GE_MSG_STACK.ADD;
2761: APP_EXCEPTION.RAISE_EXCEPTION;
2762: END IF;
2763: END IF;
2762: END IF;
2763: END IF;
2764: IF upper(column_name) = 'APPL_INST_STATUS' OR column_name IS NULL THEN --arvsrini igsm
2765: IF new_references.appl_inst_status <> UPPER(new_references.appl_inst_status) THEN
2766: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
2768: IGS_GE_MSG_STACK.ADD;
2769: APP_EXCEPTION.RAISE_EXCEPTION;
2770: END IF;
2763: END IF;
2764: IF upper(column_name) = 'APPL_INST_STATUS' OR column_name IS NULL THEN --arvsrini igsm
2765: IF new_references.appl_inst_status <> UPPER(new_references.appl_inst_status) THEN
2766: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
2768: IGS_GE_MSG_STACK.ADD;
2769: APP_EXCEPTION.RAISE_EXCEPTION;
2770: END IF;
2771: END IF;
2772: /*IF upper(column_name) = 'PRPSD_COMMENCEMENT_DT' OR column_name IS NULL THEN
2773: IF new_references.prpsd_commencement_dt IS NOT NULL
2774: AND TRUNC(new_references.prpsd_commencement_dt) > TRUNC(SYSDATE)
2775: OR TRUNC(new_references.prpsd_commencement_dt) < TRUNC(new_references.offer_dt) THEN
2776: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRPSD_CMCMNT_DT_INVALID');
2777: IGS_GE_MSG_STACK.ADD;
2778: APP_EXCEPTION.RAISE_EXCEPTION;
2779: END IF;
2780: END IF;*/
2800: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
2801: new_references.edu_goal_prior_enroll_id,
2802: 'EDU_GOALS', 'N'
2803: ) THEN
2804: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
2806: IGS_GE_MSG_STACK.ADD;
2807: App_Exception.Raise_Exception;
2808: END IF;
2801: new_references.edu_goal_prior_enroll_id,
2802: 'EDU_GOALS', 'N'
2803: ) THEN
2804: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
2806: IGS_GE_MSG_STACK.ADD;
2807: App_Exception.Raise_Exception;
2808: END IF;
2809: IF (((old_references.attent_other_inst_cd = new_references.attent_other_inst_cd)) OR
2811: NULL;
2812: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
2813: new_references.attent_other_inst_cd
2814: ) THEN
2815: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_AT_OTH_INST'));
2817: IGS_GE_MSG_STACK.ADD;
2818: App_Exception.Raise_Exception;
2819: END IF;
2812: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
2813: new_references.attent_other_inst_cd
2814: ) THEN
2815: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_AT_OTH_INST'));
2817: IGS_GE_MSG_STACK.ADD;
2818: App_Exception.Raise_Exception;
2819: END IF;
2820: IF (((old_references.app_source_id = new_references.app_source_id)) OR
2823: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
2824: new_references.app_source_id,
2825: 'SYS_APPL_SOURCE', 'N'
2826: ) THEN
2827: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APP_SOURCE'));
2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END IF;
2824: new_references.app_source_id,
2825: 'SYS_APPL_SOURCE', 'N'
2826: ) THEN
2827: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APP_SOURCE'));
2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END IF;
2832: IF (((old_references.decision_make_id = new_references.decision_make_id)) OR
2834: NULL;
2835: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
2836: new_references.decision_make_id
2837: ) THEN
2838: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2839: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_MAKE'));
2840: IGS_GE_MSG_STACK.ADD;
2841: App_Exception.Raise_Exception;
2842: END IF;
2835: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
2836: new_references.decision_make_id
2837: ) THEN
2838: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2839: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_MAKE'));
2840: IGS_GE_MSG_STACK.ADD;
2841: App_Exception.Raise_Exception;
2842: END IF;
2843: IF (((old_references.decision_reason_id = new_references.decision_reason_id)) OR
2846: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
2847: new_references.decision_reason_id,
2848: 'DECISION_REASON', 'N'
2849: ) THEN
2850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_REASON'));
2852: IGS_GE_MSG_STACK.ADD;
2853: App_Exception.Raise_Exception;
2854: END IF;
2847: new_references.decision_reason_id,
2848: 'DECISION_REASON', 'N'
2849: ) THEN
2850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_REASON'));
2852: IGS_GE_MSG_STACK.ADD;
2853: App_Exception.Raise_Exception;
2854: END IF;
2855: IF (((old_references.pending_reason_id = new_references.pending_reason_id)) OR
2858: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
2859: new_references.pending_reason_id,
2860: 'PENDING_REASON','N'
2861: ) THEN
2862: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PEND_REASON'));
2864: IGS_GE_MSG_STACK.ADD;
2865: App_Exception.Raise_Exception;
2866: END IF;
2859: new_references.pending_reason_id,
2860: 'PENDING_REASON','N'
2861: ) THEN
2862: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PEND_REASON'));
2864: IGS_GE_MSG_STACK.ADD;
2865: App_Exception.Raise_Exception;
2866: END IF;
2867: IF (((old_references.attendance_mode = new_references.attendance_mode)) OR
2870: ELSE
2871: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
2872: new_references.attendance_mode
2873: )THEN
2874: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_MODE'));
2876: IGS_GE_MSG_STACK.ADD;
2877: APP_EXCEPTION.RAISE_EXCEPTION;
2878: END IF;
2871: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
2872: new_references.attendance_mode
2873: )THEN
2874: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_MODE'));
2876: IGS_GE_MSG_STACK.ADD;
2877: APP_EXCEPTION.RAISE_EXCEPTION;
2878: END IF;
2879: END IF;
2883: ELSE
2884: IF NOT IGS_AD_OFRDFRMT_STAT_PKG.Get_PK_For_Validation (
2885: new_references.adm_offer_dfrmnt_status
2886: )THEN
2887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_DFRMNT_STATUS'));
2889: IGS_GE_MSG_STACK.ADD;
2890: APP_EXCEPTION.RAISE_EXCEPTION;
2891: END IF;
2884: IF NOT IGS_AD_OFRDFRMT_STAT_PKG.Get_PK_For_Validation (
2885: new_references.adm_offer_dfrmnt_status
2886: )THEN
2887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_DFRMNT_STATUS'));
2889: IGS_GE_MSG_STACK.ADD;
2890: APP_EXCEPTION.RAISE_EXCEPTION;
2891: END IF;
2892: END IF;
2896: ELSE
2897: IF NOT IGS_AD_OFR_RESP_STAT_PKG.Get_PK_For_Validation (
2898: new_references.adm_offer_resp_status
2899: )THEN
2900: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
2902: IGS_GE_MSG_STACK.ADD;
2903: APP_EXCEPTION.RAISE_EXCEPTION;
2904: END IF;
2897: IF NOT IGS_AD_OFR_RESP_STAT_PKG.Get_PK_For_Validation (
2898: new_references.adm_offer_resp_status
2899: )THEN
2900: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
2902: IGS_GE_MSG_STACK.ADD;
2903: APP_EXCEPTION.RAISE_EXCEPTION;
2904: END IF;
2905: END IF;
2909: ELSE
2910: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (
2911: new_references.adm_outcome_status
2912: )THEN
2913: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
2915: IGS_GE_MSG_STACK.ADD;
2916: APP_EXCEPTION.RAISE_EXCEPTION;
2917: END IF;
2910: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (
2911: new_references.adm_outcome_status
2912: )THEN
2913: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
2915: IGS_GE_MSG_STACK.ADD;
2916: APP_EXCEPTION.RAISE_EXCEPTION;
2917: END IF;
2918: END IF;
2922: ELSE
2923: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
2924: new_references.attendance_type
2925: )THEN
2926: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2927: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_TYPE'));
2928: IGS_GE_MSG_STACK.ADD;
2929: APP_EXCEPTION.RAISE_EXCEPTION;
2930: END IF;
2923: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
2924: new_references.attendance_type
2925: )THEN
2926: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2927: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_TYPE'));
2928: IGS_GE_MSG_STACK.ADD;
2929: APP_EXCEPTION.RAISE_EXCEPTION;
2930: END IF;
2931: END IF;
2941: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
2942: new_references.deferred_adm_cal_type,
2943: new_references.deferred_adm_ci_sequence_num
2944: )THEN
2945: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2947: IGS_GE_MSG_STACK.ADD;
2948: APP_EXCEPTION.RAISE_EXCEPTION;
2949: END IF;
2942: new_references.deferred_adm_cal_type,
2943: new_references.deferred_adm_ci_sequence_num
2944: )THEN
2945: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
2947: IGS_GE_MSG_STACK.ADD;
2948: APP_EXCEPTION.RAISE_EXCEPTION;
2949: END IF;
2950: END IF;
2957: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
2958: new_references.adm_cal_type,
2959: new_references.adm_ci_sequence_number
2960: )THEN
2961: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2963: IGS_GE_MSG_STACK.ADD;
2964: APP_EXCEPTION.RAISE_EXCEPTION;
2965: END IF;
2958: new_references.adm_cal_type,
2959: new_references.adm_ci_sequence_number
2960: )THEN
2961: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
2963: IGS_GE_MSG_STACK.ADD;
2964: APP_EXCEPTION.RAISE_EXCEPTION;
2965: END IF;
2966: END IF;
2976: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
2977: new_references.course_cd,
2978: new_references.crv_version_number
2979: )THEN
2980: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2982: IGS_GE_MSG_STACK.ADD;
2983: APP_EXCEPTION.RAISE_EXCEPTION;
2984: END IF;
2977: new_references.course_cd,
2978: new_references.crv_version_number
2979: )THEN
2980: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
2982: IGS_GE_MSG_STACK.ADD;
2983: APP_EXCEPTION.RAISE_EXCEPTION;
2984: END IF;
2985: END IF;
2989: ELSE
2990: IF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
2991: new_references.enrolment_cat
2992: )THEN
2993: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
2995: IGS_GE_MSG_STACK.ADD;
2996: APP_EXCEPTION.RAISE_EXCEPTION;
2997: END IF;
2990: IF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
2991: new_references.enrolment_cat
2992: )THEN
2993: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
2995: IGS_GE_MSG_STACK.ADD;
2996: APP_EXCEPTION.RAISE_EXCEPTION;
2997: END IF;
2998: END IF;
3002: ELSE
3003: IF NOT IGS_FI_FEE_CAT_PKG.Get_PK_For_Validation (
3004: new_references.fee_cat
3005: )THEN
3006: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
3008: IGS_GE_MSG_STACK.ADD;
3009: APP_EXCEPTION.RAISE_EXCEPTION;
3010: END IF;
3003: IF NOT IGS_FI_FEE_CAT_PKG.Get_PK_For_Validation (
3004: new_references.fee_cat
3005: )THEN
3006: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
3008: IGS_GE_MSG_STACK.ADD;
3009: APP_EXCEPTION.RAISE_EXCEPTION;
3010: END IF;
3011: END IF;
3015: ELSE
3016: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
3017: new_references.funding_source
3018: ) THEN
3019: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
3021: IGS_GE_MSG_STACK.ADD;
3022: APP_EXCEPTION.RAISE_EXCEPTION;
3023: END IF;
3016: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
3017: new_references.funding_source
3018: ) THEN
3019: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
3021: IGS_GE_MSG_STACK.ADD;
3022: APP_EXCEPTION.RAISE_EXCEPTION;
3023: END IF;
3024: END IF;
3028: ELSE
3029: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
3030: new_references.hecs_payment_option
3031: )THEN
3032: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HECS_PAY_OPT'));
3034: IGS_GE_MSG_STACK.ADD;
3035: APP_EXCEPTION.RAISE_EXCEPTION;
3036: END IF;
3029: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
3030: new_references.hecs_payment_option
3031: )THEN
3032: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HECS_PAY_OPT'));
3034: IGS_GE_MSG_STACK.ADD;
3035: APP_EXCEPTION.RAISE_EXCEPTION;
3036: END IF;
3037: END IF;
3041: ELSE
3042: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
3043: new_references.location_cd
3044: )THEN
3045: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3046: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_EN_LOCATION'));
3047: IGS_GE_MSG_STACK.ADD;
3048: APP_EXCEPTION.RAISE_EXCEPTION;
3049: END IF;
3042: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
3043: new_references.location_cd
3044: )THEN
3045: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3046: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_EN_LOCATION'));
3047: IGS_GE_MSG_STACK.ADD;
3048: APP_EXCEPTION.RAISE_EXCEPTION;
3049: END IF;
3050: END IF;
3054: ELSE
3055: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
3056: new_references.person_id
3057: )THEN
3058: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3059: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
3060: IGS_GE_MSG_STACK.ADD;
3061: APP_EXCEPTION.RAISE_EXCEPTION;
3062: END IF;
3055: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
3056: new_references.person_id
3057: )THEN
3058: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3059: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
3060: IGS_GE_MSG_STACK.ADD;
3061: APP_EXCEPTION.RAISE_EXCEPTION;
3062: END IF;
3063: END IF;
3067: ELSE
3068: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
3069: new_references.ass_tracking_id
3070: )THEN
3071: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASS_TRACKING_ID'));
3073: IGS_GE_MSG_STACK.ADD;
3074: APP_EXCEPTION.RAISE_EXCEPTION;
3075: END IF;
3068: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
3069: new_references.ass_tracking_id
3070: )THEN
3071: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASS_TRACKING_ID'));
3073: IGS_GE_MSG_STACK.ADD;
3074: APP_EXCEPTION.RAISE_EXCEPTION;
3075: END IF;
3076: END IF;
3080: ELSE
3081: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
3082: new_references.deferred_tracking_id
3083: )THEN
3084: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEF_TRACKING_ID'));
3086: IGS_GE_MSG_STACK.ADD;
3087: APP_EXCEPTION.RAISE_EXCEPTION;
3088: END IF;
3081: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
3082: new_references.deferred_tracking_id
3083: )THEN
3084: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEF_TRACKING_ID'));
3086: IGS_GE_MSG_STACK.ADD;
3087: APP_EXCEPTION.RAISE_EXCEPTION;
3088: END IF;
3089: END IF;
3096: IF NOT IGS_EN_UNIT_SET_PKG.Get_PK_For_Validation (
3097: new_references.unit_set_cd,
3098: new_references.us_version_number
3099: )THEN
3100: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
3102: IGS_GE_MSG_STACK.ADD;
3103: APP_EXCEPTION.RAISE_EXCEPTION;
3104: END IF;
3097: new_references.unit_set_cd,
3098: new_references.us_version_number
3099: )THEN
3100: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
3102: IGS_GE_MSG_STACK.ADD;
3103: APP_EXCEPTION.RAISE_EXCEPTION;
3104: END IF;
3105: END IF;
3112: IF NOT IGS_AD_APPL_PKG.Get_PK_For_Validation (
3113: new_references.person_id,
3114: new_references.admission_appl_number
3115: )THEN
3116: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
3118: IGS_GE_MSG_STACK.ADD;
3119: APP_EXCEPTION.RAISE_EXCEPTION;
3120: END IF;
3113: new_references.person_id,
3114: new_references.admission_appl_number
3115: )THEN
3116: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
3118: IGS_GE_MSG_STACK.ADD;
3119: APP_EXCEPTION.RAISE_EXCEPTION;
3120: END IF;
3121: END IF;
3131: new_references.person_id,
3132: new_references.admission_appl_number,
3133: new_references.nominated_course_cd
3134: )THEN
3135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
3137: IGS_GE_MSG_STACK.ADD;
3138: APP_EXCEPTION.RAISE_EXCEPTION;
3139: END IF;
3132: new_references.admission_appl_number,
3133: new_references.nominated_course_cd
3134: )THEN
3135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
3137: IGS_GE_MSG_STACK.ADD;
3138: APP_EXCEPTION.RAISE_EXCEPTION;
3139: END IF;
3140: END IF;
3144: ELSE
3145: IF NOT IGS_AD_CNDNL_OFRSTAT_PKG.Get_PK_For_Validation (
3146: new_references.adm_cndtnl_offer_status
3147: )THEN
3148: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
3150: IGS_GE_MSG_STACK.ADD;
3151: APP_EXCEPTION.RAISE_EXCEPTION;
3152: END IF;
3145: IF NOT IGS_AD_CNDNL_OFRSTAT_PKG.Get_PK_For_Validation (
3146: new_references.adm_cndtnl_offer_status
3147: )THEN
3148: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
3150: IGS_GE_MSG_STACK.ADD;
3151: APP_EXCEPTION.RAISE_EXCEPTION;
3152: END IF;
3153: END IF;
3157: ELSE
3158: IF NOT IGS_AD_DOC_STAT_PKG.Get_PK_For_Validation (
3159: new_references.adm_doc_status
3160: )THEN
3161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_DOC_STAT'));
3163: IGS_GE_MSG_STACK.ADD;
3164: APP_EXCEPTION.RAISE_EXCEPTION;
3165: END IF;
3158: IF NOT IGS_AD_DOC_STAT_PKG.Get_PK_For_Validation (
3159: new_references.adm_doc_status
3160: )THEN
3161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_DOC_STAT'));
3163: IGS_GE_MSG_STACK.ADD;
3164: APP_EXCEPTION.RAISE_EXCEPTION;
3165: END IF;
3166: END IF;
3170: ELSE
3171: IF NOT IGS_AD_ENT_QF_STAT_PKG.Get_PK_For_Validation (
3172: new_references.adm_entry_qual_status
3173: )THEN
3174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_ENTRY_QUAL_STATUS'));
3176: IGS_GE_MSG_STACK.ADD;
3177: APP_EXCEPTION.RAISE_EXCEPTION;
3178: END IF;
3171: IF NOT IGS_AD_ENT_QF_STAT_PKG.Get_PK_For_Validation (
3172: new_references.adm_entry_qual_status
3173: )THEN
3174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_ENTRY_QUAL_STATUS'));
3176: IGS_GE_MSG_STACK.ADD;
3177: APP_EXCEPTION.RAISE_EXCEPTION;
3178: END IF;
3179: END IF;
3183: ELSE
3184: IF NOT IGS_AD_FEE_STAT_PKG.Get_PK_For_Validation (
3185: new_references.late_adm_fee_status
3186: )THEN
3187: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_LATE_ADM_FEE_STATUS'));
3189: IGS_GE_MSG_STACK.ADD;
3190: APP_EXCEPTION.RAISE_EXCEPTION;
3191: END IF;
3184: IF NOT IGS_AD_FEE_STAT_PKG.Get_PK_For_Validation (
3185: new_references.late_adm_fee_status
3186: )THEN
3187: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_LATE_ADM_FEE_STATUS'));
3189: IGS_GE_MSG_STACK.ADD;
3190: APP_EXCEPTION.RAISE_EXCEPTION;
3191: END IF;
3192: END IF;
3200: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
3201: new_references.future_acad_cal_type,
3202: new_references.future_acad_ci_sequence_number
3203: )THEN
3204: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ACAD_CAL'));
3206: IGS_GE_MSG_STACK.ADD;
3207: APP_EXCEPTION.RAISE_EXCEPTION;
3208: END IF;
3201: new_references.future_acad_cal_type,
3202: new_references.future_acad_ci_sequence_number
3203: )THEN
3204: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ACAD_CAL'));
3206: IGS_GE_MSG_STACK.ADD;
3207: APP_EXCEPTION.RAISE_EXCEPTION;
3208: END IF;
3209: END IF;
3217: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
3218: new_references.future_adm_cal_type,
3219: new_references.future_adm_ci_sequence_number
3220: )THEN
3221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ADM_CAL'));
3223: IGS_GE_MSG_STACK.ADD;
3224: APP_EXCEPTION.RAISE_EXCEPTION;
3225: END IF;
3218: new_references.future_adm_cal_type,
3219: new_references.future_adm_ci_sequence_number
3220: )THEN
3221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ADM_CAL'));
3223: IGS_GE_MSG_STACK.ADD;
3224: APP_EXCEPTION.RAISE_EXCEPTION;
3225: END IF;
3226: END IF;
3239: new_references.def_prev_term_adm_appl_num,
3240: new_references.nominated_course_cd,
3241: new_references.def_prev_appl_sequence_num
3242: )THEN
3243: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFER_APPL_INST'));
3245: IGS_GE_MSG_STACK.ADD;
3246: APP_EXCEPTION.RAISE_EXCEPTION;
3247: END IF;
3240: new_references.nominated_course_cd,
3241: new_references.def_prev_appl_sequence_num
3242: )THEN
3243: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFER_APPL_INST'));
3245: IGS_GE_MSG_STACK.ADD;
3246: APP_EXCEPTION.RAISE_EXCEPTION;
3247: END IF;
3248: END IF;
3262: new_references.def_term_adm_appl_num,
3263: new_references.nominated_course_cd,
3264: new_references.def_appl_sequence_num
3265: )THEN
3266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFER_APPL_INST'));
3268: IGS_GE_MSG_STACK.ADD;
3269: APP_EXCEPTION.RAISE_EXCEPTION;
3270: END IF;
3263: new_references.nominated_course_cd,
3264: new_references.def_appl_sequence_num
3265: )THEN
3266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFER_APPL_INST'));
3268: IGS_GE_MSG_STACK.ADD;
3269: APP_EXCEPTION.RAISE_EXCEPTION;
3270: END IF;
3271: END IF;
3277: ELSE
3278: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
3279: new_references.appl_inst_status ,'N'
3280: )THEN
3281: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
3283: IGS_GE_MSG_STACK.ADD;
3284: APP_EXCEPTION.RAISE_EXCEPTION;
3285: END IF;
3278: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
3279: new_references.appl_inst_status ,'N'
3280: )THEN
3281: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
3283: IGS_GE_MSG_STACK.ADD;
3284: APP_EXCEPTION.RAISE_EXCEPTION;
3285: END IF;
3286: END IF;
3544: Open cur_rowid1;
3545: Fetch cur_rowid1 INTO lv_rowid;
3546: IF (cur_rowid1%FOUND) THEN
3547: Close cur_rowid1;
3548: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK1');
3549: IGS_GE_MSG_STACK.ADD;
3550: App_Exception.Raise_Exception;
3551: Return;
3552: END IF;
3554: Open cur_rowid2;
3555: Fetch cur_rowid2 INTO lv_rowid;
3556: IF (cur_rowid2%FOUND) THEN
3557: Close cur_rowid2;
3558: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK2');
3559: IGS_GE_MSG_STACK.ADD;
3560: App_Exception.Raise_Exception;
3561: Return;
3562: END IF;
3564: Open cur_rowid3;
3565: Fetch cur_rowid3 INTO lv_rowid;
3566: IF (cur_rowid3%FOUND) THEN
3567: Close cur_rowid3;
3568: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK3');
3569: IGS_GE_MSG_STACK.ADD;
3570: App_Exception.Raise_Exception;
3571: Return;
3572: END IF;
3574: Open cur_rowid5;
3575: Fetch cur_rowid5 INTO lv_rowid;
3576: IF (cur_rowid5%FOUND) THEN
3577: Close cur_rowid5;
3578: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK5');
3579: IGS_GE_MSG_STACK.ADD;
3580: App_Exception.Raise_Exception;
3581: Return;
3582: END IF;
3584: Open cur_rowid6;
3585: Fetch cur_rowid6 INTO lv_rowid;
3586: IF (cur_rowid6%FOUND) THEN
3587: Close cur_rowid6;
3588: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK6');
3589: IGS_GE_MSG_STACK.ADD;
3590: App_Exception.Raise_Exception;
3591: Return;
3592: END IF;
3594: Open cur_rowid7;
3595: Fetch cur_rowid7 INTO lv_rowid;
3596: IF (cur_rowid7%FOUND) THEN
3597: Close cur_rowid7;
3598: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACDC_FK7');
3599: IGS_GE_MSG_STACK.ADD;
3600: App_Exception.Raise_Exception;
3601: Return;
3602: END IF;
3624: Open cur_rowid;
3625: Fetch cur_rowid INTO lv_rowid;
3626: IF (cur_rowid%FOUND) THEN
3627: Close cur_rowid;
3628: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_OI_FK');
3629: IGS_GE_MSG_STACK.ADD;
3630: App_Exception.Raise_Exception;
3631: Return;
3632: END IF;
3658: Open cur_rowid1;
3659: Fetch cur_rowid1 INTO lv_rowid;
3660: IF (cur_rowid1%FOUND) THEN
3661: Close cur_rowid1;
3662: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_PE_FK');
3663: IGS_GE_MSG_STACK.ADD;
3664: App_Exception.Raise_Exception;
3665: Return;
3666: END IF;
3668: Open cur_rowid2;
3669: Fetch cur_rowid2 INTO lv_rowid;
3670: IF (cur_rowid2%FOUND) THEN
3671: Close cur_rowid2;
3672: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_PE_FK');
3673: IGS_GE_MSG_STACK.ADD;
3674: App_Exception.Raise_Exception;
3675: Return;
3676: END IF;
3689: Open cur_rowid;
3690: Fetch cur_rowid INTO lv_rowid;
3691: IF (cur_rowid%FOUND) THEN
3692: Close cur_rowid;
3693: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AM_FK');
3694: IGS_GE_MSG_STACK.ADD;
3695: App_Exception.Raise_Exception;
3696: Return;
3697: END IF;
3711: Open cur_rowid;
3712: Fetch cur_rowid INTO lv_rowid;
3713: IF (cur_rowid%FOUND) THEN
3714: Close cur_rowid;
3715: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AODS_FK');
3716: IGS_GE_MSG_STACK.ADD;
3717: App_Exception.Raise_Exception;
3718: Return;
3719: END IF;
3733: Open cur_rowid;
3734: Fetch cur_rowid INTO lv_rowid;
3735: IF (cur_rowid%FOUND) THEN
3736: Close cur_rowid;
3737: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AORS_FK');
3738: IGS_GE_MSG_STACK.ADD;
3739: App_Exception.Raise_Exception;
3740: Return;
3741: END IF;
3755: Open cur_rowid;
3756: Fetch cur_rowid INTO lv_rowid;
3757: IF (cur_rowid%FOUND) THEN
3758: Close cur_rowid;
3759: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AOS_FK');
3760: IGS_GE_MSG_STACK.ADD;
3761: App_Exception.Raise_Exception;
3762: Return;
3763: END IF;
3776: Open cur_rowid;
3777: Fetch cur_rowid INTO lv_rowid;
3778: IF (cur_rowid%FOUND) THEN
3779: Close cur_rowid;
3780: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ATT_FK');
3781: IGS_GE_MSG_STACK.ADD;
3782: App_Exception.Raise_Exception;
3783: Return;
3784: END IF;
3797: Open cur_rowid;
3798: Fetch cur_rowid INTO lv_rowid;
3799: IF (cur_rowid%FOUND) THEN
3800: Close cur_rowid;
3801: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_CC_FK');
3802: IGS_GE_MSG_STACK.ADD;
3803: App_Exception.Raise_Exception;
3804: Return;
3805: END IF;
3834: Open cur_rowid;
3835: Fetch cur_rowid INTO lv_rowid;
3836: IF (cur_rowid%FOUND) THEN
3837: Close cur_rowid;
3838: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_CI_FK');
3839: IGS_GE_MSG_STACK.ADD;
3840: App_Exception.Raise_Exception;
3841: Return;
3842: END IF;
3855: Open cur_rowid;
3856: Fetch cur_rowid INTO lv_rowid;
3857: IF (cur_rowid%FOUND) THEN
3858: Close cur_rowid;
3859: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_CRS_FK');
3860: IGS_GE_MSG_STACK.ADD;
3861: App_Exception.Raise_Exception;
3862: Return;
3863: END IF;
3878: Open cur_rowid;
3879: Fetch cur_rowid INTO lv_rowid;
3880: IF (cur_rowid%FOUND) THEN
3881: Close cur_rowid;
3882: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_CRV_FK');
3883: IGS_GE_MSG_STACK.ADD;
3884: App_Exception.Raise_Exception;
3885: Return;
3886: END IF;
3899: Open cur_rowid;
3900: Fetch cur_rowid INTO lv_rowid;
3901: IF (cur_rowid%FOUND) THEN
3902: Close cur_rowid;
3903: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_EC_FK');
3904: IGS_GE_MSG_STACK.ADD;
3905: App_Exception.Raise_Exception;
3906: Return;
3907: END IF;
3920: Open cur_rowid;
3921: Fetch cur_rowid INTO lv_rowid;
3922: IF (cur_rowid%FOUND) THEN
3923: Close cur_rowid;
3924: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_FC_FK');
3925: IGS_GE_MSG_STACK.ADD;
3926: App_Exception.Raise_Exception;
3927: Return;
3928: END IF;
3941: Open cur_rowid;
3942: Fetch cur_rowid INTO lv_rowid;
3943: IF (cur_rowid%FOUND) THEN
3944: Close cur_rowid;
3945: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_FS_FK');
3946: IGS_GE_MSG_STACK.ADD;
3947: App_Exception.Raise_Exception;
3948: Return;
3949: END IF;
3962: Open cur_rowid;
3963: Fetch cur_rowid INTO lv_rowid;
3964: IF (cur_rowid%FOUND) THEN
3965: Close cur_rowid;
3966: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_HPO_FK');
3967: IGS_GE_MSG_STACK.ADD;
3968: App_Exception.Raise_Exception;
3969: Return;
3970: END IF;
3983: Open cur_rowid;
3984: Fetch cur_rowid INTO lv_rowid;
3985: IF (cur_rowid%FOUND) THEN
3986: Close cur_rowid;
3987: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_LOC_FK');
3988: IGS_GE_MSG_STACK.ADD;
3989: App_Exception.Raise_Exception;
3990: Return;
3991: END IF;
4005: Open cur_rowid;
4006: Fetch cur_rowid INTO lv_rowid;
4007: IF (cur_rowid%FOUND) THEN
4008: Close cur_rowid;
4009: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_TRI_ASS_FK');
4010: IGS_GE_MSG_STACK.ADD;
4011: App_Exception.Raise_Exception;
4012: Return;
4013: END IF;
4028: Open cur_rowid;
4029: Fetch cur_rowid INTO lv_rowid;
4030: IF (cur_rowid%FOUND) THEN
4031: Close cur_rowid;
4032: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_US_FK');
4033: IGS_GE_MSG_STACK.ADD;
4034: App_Exception.Raise_Exception;
4035: Return;
4036: END IF;
4061: Open cur_rowid;
4062: Fetch cur_rowid INTO lv_rowid;
4063: IF (cur_rowid%FOUND) THEN
4064: Close cur_rowid;
4065: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_US_FK');
4066: IGS_GE_MSG_STACK.ADD;
4067: App_Exception.Raise_Exception;
4068: Return;
4069: END IF;
4087: Open cur_rowid;
4088: Fetch cur_rowid INTO lv_rowid;
4089: IF (cur_rowid%FOUND) THEN
4090: Close cur_rowid;
4091: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AA_FK');
4092: IGS_GE_MSG_STACK.ADD;
4093: App_Exception.Raise_Exception;
4094: Return;
4095: END IF;
4112: Open cur_rowid;
4113: Fetch cur_rowid INTO lv_rowid;
4114: IF (cur_rowid%FOUND) THEN
4115: Close cur_rowid;
4116: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACA_FK');
4117: IGS_GE_MSG_STACK.ADD;
4118: App_Exception.Raise_Exception;
4119: Return;
4120: END IF;
4133: Open cur_rowid;
4134: Fetch cur_rowid INTO lv_rowid;
4135: IF (cur_rowid%FOUND) THEN
4136: Close cur_rowid;
4137: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ACOS_FK');
4138: IGS_GE_MSG_STACK.ADD;
4139: App_Exception.Raise_Exception;
4140: Return;
4141: END IF;
4154: Open cur_rowid;
4155: Fetch cur_rowid INTO lv_rowid;
4156: IF (cur_rowid%FOUND) THEN
4157: Close cur_rowid;
4158: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ADS_FK');
4159: IGS_GE_MSG_STACK.ADD;
4160: App_Exception.Raise_Exception;
4161: Return;
4162: END IF;
4175: Open cur_rowid;
4176: Fetch cur_rowid INTO lv_rowid;
4177: IF (cur_rowid%FOUND) THEN
4178: Close cur_rowid;
4179: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AEQS_FK');
4180: IGS_GE_MSG_STACK.ADD;
4181: App_Exception.Raise_Exception;
4182: Return;
4183: END IF;
4196: Open cur_rowid;
4197: Fetch cur_rowid INTO lv_rowid;
4198: IF (cur_rowid%FOUND) THEN
4199: Close cur_rowid;
4200: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_AFS_FK');
4201: IGS_GE_MSG_STACK.ADD;
4202: App_Exception.Raise_Exception;
4203: Return;
4204: END IF;
4226: Open cur_rowid;
4227: Fetch cur_rowid INTO lv_rowid;
4228: IF (cur_rowid%FOUND) THEN
4229: Close cur_rowid;
4230: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAI_ASAT_FK');
4231: IGS_GE_MSG_STACK.ADD;
4232: App_Exception.Raise_Exception;
4233: Return;
4234: END IF;
4568: new_references.person_id,
4569: new_references.admission_appl_number,
4570: new_references.nominated_course_cd,
4571: new_references.sequence_number) THEN
4572: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
4573: IGS_GE_MSG_STACK.ADD;
4574: App_Exception.Raise_Exception;
4575: END IF;
4576: Check_Constraints;
4586:
4587: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED'
4588: AND (NVL(l_is_inst_reconsidered,'N') <> 'Y') -- APADEGAL (IGS.M) - CANCELLED instance can be updated while reconsideration.
4589: THEN
4590: Fnd_Message.Set_name('IGS','IGS_AD_NOT_UPD_CANCEL_APPLINST');
4591: IGS_GE_MSG_STACK.ADD;
4592: App_Exception.Raise_Exception;
4593: END IF;
4594: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN
4616: new_references.adm_outcome_status,
4617: old_references.adm_offer_resp_status,
4618: l_message_name);
4619: IF l_message_name IS NOT NULL THEN
4620: fnd_message.set_name('IGS',l_message_name);
4621: igs_ge_msg_stack.add;
4622: END IF;
4623:
4624: IF l_message_name IS NULL AND
4647: new_references.person_id,
4648: new_references.admission_appl_number,
4649: new_references.nominated_course_cd,
4650: new_references.sequence_number) THEN
4651: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
4652: IGS_GE_MSG_STACK.ADD;
4653: App_Exception.Raise_Exception;
4654: END IF;
4655: Check_Constraints;
5134: else
5135: X_PROGRAM_UPDATE_DATE := SYSDATE;
5136: end if;
5137: else
5138: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
5139: IGS_GE_MSG_STACK.ADD;
5140: app_exception.raise_exception;
5141: end if;
5142: Before_DML(
5586: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
5587: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
5588: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
5589: -- that the ownerof policy function does not have privilege to access.
5590: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
5591: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
5592: IGS_GE_MSG_STACK.ADD;
5593: app_exception.raise_exception;
5594: ELSE
5587: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
5588: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
5589: -- that the ownerof policy function does not have privilege to access.
5590: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
5591: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
5592: IGS_GE_MSG_STACK.ADD;
5593: app_exception.raise_exception;
5594: ELSE
5595: RAISE;
5871: begin
5872: open c1;
5873: fetch c1 into tlinfo;
5874: if (c1%notfound) then
5875: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
5876: IGS_AD_GEN_001.SET_TOKEN('From IGS_AD_PS_APPL_INST ->Parameter : Lock_row ');
5877: IGS_GE_MSG_STACK.ADD;
5878: close c1;
5879: app_exception.raise_exception;
6028:
6029: ) THEN
6030: null;
6031: else
6032: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
6033: IGS_GE_MSG_STACK.ADD;
6034: app_exception.raise_exception;
6035: end if;
6036: return;
6201: if X_LAST_UPDATE_LOGIN is NULL then
6202: X_LAST_UPDATE_LOGIN := -1;
6203: end if;
6204: else
6205: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
6206: IGS_GE_MSG_STACK.ADD;
6207: app_exception.raise_exception;
6208: end if;
6209:
6500: where ROWID = X_ROWID;
6501:
6502:
6503: IF (sql%notfound) THEN
6504: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
6505: igs_ge_msg_stack.add;
6506: igs_sc_gen_001.unset_ctx('R');
6507: app_exception.raise_exception;
6508: END IF;
6525: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
6526: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
6527: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
6528: -- that the ownerof policy function does not have privilege to access.
6529: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
6530: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
6531: IGS_GE_MSG_STACK.ADD;
6532: app_exception.raise_exception;
6533: ELSE
6526: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
6527: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
6528: -- that the ownerof policy function does not have privilege to access.
6529: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
6530: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
6531: IGS_GE_MSG_STACK.ADD;
6532: app_exception.raise_exception;
6533: ELSE
6534:
6983: END IF;
6984: delete from IGS_AD_PS_APPL_INST_ALL
6985: where ROWID = X_ROWID;
6986: if (sql%notfound) then
6987: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
6988: igs_ge_msg_stack.add;
6989: igs_sc_gen_001.unset_ctx('R');
6990: app_exception.raise_exception;
6991: end if;
7007: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
7008: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
7009: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
7010: -- that the ownerof policy function does not have privilege to access.
7011: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
7012: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
7013: IGS_GE_MSG_STACK.ADD;
7014: app_exception.raise_exception;
7015: ELSE
7008: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
7009: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
7010: -- that the ownerof policy function does not have privilege to access.
7011: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
7012: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
7013: IGS_GE_MSG_STACK.ADD;
7014: app_exception.raise_exception;
7015: ELSE
7016: RAISE;