eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on APP_EXCEPTION

Line 173: App_Exception.Raise_Exception;

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;
175: END IF;
176: Close cur_old_ref_values;
177: -- Populate New Values.

Line 512: APP_EXCEPTION.RAISE_EXCEPTION;

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
515: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OFRDT_APPLDT');
516: IGS_GE_MSG_STACK.ADD;

Line 517: 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
520: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OFFER_DATE_INVALID');
521: IGS_GE_MSG_STACK.ADD;

Line 522: 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:
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');

Line 529: APP_EXCEPTION.RAISE_EXCEPTION;

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');
532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CALC_DATE'));
533: IGS_GE_MSG_STACK.ADD;

Line 534: 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

Line 543: App_Exception.Raise_Exception;

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;
546:
547:

Line 590: APP_EXCEPTION.RAISE_EXCEPTION;

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;
593: END IF;
594: END IF;

Line 726: APP_EXCEPTION.RAISE_EXCEPTION;

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
729: IF NOT (igs_ad_gen_002.check_any_offer_inst(new_references.person_id, --arvsrini igsm
730: new_references.admission_appl_number, --either instance is withdrawn

Line 740: APP_EXCEPTION.RAISE_EXCEPTION;

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');
743: IGS_GE_MSG_STACK.ADD;
744: APP_EXCEPTION.RAISE_EXCEPTION;

Line 744: APP_EXCEPTION.RAISE_EXCEPTION;

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;
747:
748: END IF;

Line 760: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
763: -- Validate change of preference.
764: IF v_pref_allowed_ind = 'Y' AND

Line 780: APP_EXCEPTION.RAISE_EXCEPTION;

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;
783: END IF; -- p_updating
784: IF NVL(p_inserting,FALSE) THEN

Line 801: APP_EXCEPTION.RAISE_EXCEPTION;

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;
804: END IF;
805: --

Line 813: APP_EXCEPTION.RAISE_EXCEPTION;

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
816: new_references.adm_cal_type IS NULL THEN
817: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ADMCAL_SET_ADMCAL_SET');

Line 819: APP_EXCEPTION.RAISE_EXCEPTION;

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
822: (NVL(old_references.adm_cal_type, '-1') <> new_references.adm_cal_type OR
823: NVL(old_references.adm_ci_sequence_number, -1) <> new_references.adm_ci_sequence_number) THEN

Line 834: APP_EXCEPTION.RAISE_EXCEPTION;

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;
837: --
838: -- Determine the offer indicator.

Line 870: APP_EXCEPTION.RAISE_EXCEPTION;

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;
873: END IF;
874: --

Line 894: APP_EXCEPTION.RAISE_EXCEPTION;

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;
897: END IF;
898: --

Line 917: APP_EXCEPTION.RAISE_EXCEPTION;

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;
920: END IF;
921: --

Line 950: APP_EXCEPTION.RAISE_EXCEPTION;

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;
953: END IF;
954: --

Line 987: APP_EXCEPTION.RAISE_EXCEPTION;

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;
990: END IF;
991: --

Line 1023: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1026: --
1027: -- Validate the IGS_PS_COURSE offering IGS_PS_UNIT set.

Line 1056: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1059: END IF;
1060: --

Line 1084: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1087: END IF;
1088: --

Line 1100: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1103: --
1104: -- IGS_GE_NOTE: STATUS VALIDATIONS

Line 1119: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1122: --
1123: -- Validate admission documentation status.

Line 1135: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1138: --
1139: -- Validate late admission fee status.

Line 1171: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1174: --
1175: -- Validate admission outcome status.

Line 1239: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1242: IF NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1243: -- Validate update of admission outcome status.

Line 1254: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1257: END IF;
1258:

Line 1270: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1273:
1274:

Line 1314: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1317: --
1318: -- Validate admission conditional offer.

Line 1337: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1340: --
1341: -- Validate admission offer deferment status.

Line 1359: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1362: --
1363: -- Validate offer date.

Line 1379: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1382: --
1383: -- Validate offer response date.

Line 1397: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1400: --
1401: -- Validate proposed commencement date.

Line 1422: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1425: --
1426: -- Validate actual response date.

Line 1438: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1441: --
1442: -- Validate conditional offer satisfied date.

Line 1456: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1459: --
1460: -- Validate acceptance condition.

Line 1472: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1475: --
1476: -- Validate conditional offer condition.

Line 1488: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1491: --
1492: -- Validate conditional offer must be satisfied indicator.

Line 1506: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1509: --
1510: -- Validate the fee category.

Line 1520: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1523: --
1524: -- Validate the HECS payment option.

Line 1534: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1537: --
1538: -- Validate the correspondence category.

Line 1548: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1551: --
1552: -- Validate the enrolment category.

Line 1562: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1565: --
1566: -- Validate the funding source.

Line 1577: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1580: --
1581: -- Validate the expected completion details.

Line 1593: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1596: --
1597: -- Validate the deferment calendar.

Line 1635: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1638: END IF;
1639: --

Line 1652: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1655: --
1656: -- Validate the Outcome Status Authorising IGS_PE_PERSON ID.

Line 1671: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1674: --
1675: -- Validate the Outcome Status Override Reason.

Line 1690: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1693: END IF; -- p_inserting or p_updating
1694: IF NVL(p_deleting,FALSE) THEN

Line 1706: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1709: --
1710: -- Get admission application details required for validation.

Line 1767: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1770: FOR c_pti_rec IN c_pti (
1771: old_references.person_id,

Line 2138: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2141: END IF;
2142: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) THEN

Line 2194: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
2197: -- Validate admission offer response status.
2198: --

Line 2229: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
2232: -- Validate multiple offers across admission process categories.
2233: --

Line 2250: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2253: END IF;
2254: END IF; -- v_row_validated

Line 2413: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2416: OPEN c_aa (
2417: old_references.person_id,

Line 2544: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2552: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2560: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2568: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2576: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2584: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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')

Line 2593: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2601: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2609: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2617: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2625: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2633: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2641: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2649: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2657: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2665: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2673: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2681: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2689: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2697: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2705: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2713: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2721: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2729: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2737: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2745: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2753: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2761: APP_EXCEPTION.RAISE_EXCEPTION;

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;
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

Line 2769: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 2778: APP_EXCEPTION.RAISE_EXCEPTION;

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;*/
2781: END Check_Constraints;
2782:

Line 2807: App_Exception.Raise_Exception;

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
2810: ((new_references.attent_other_inst_cd IS NULL))) THEN
2811: NULL;

Line 2818: App_Exception.Raise_Exception;

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
2821: ((new_references.app_source_id IS NULL))) THEN
2822: NULL;

Line 2830: App_Exception.Raise_Exception;

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
2833: ((new_references.decision_make_id IS NULL))) THEN
2834: NULL;

Line 2841: App_Exception.Raise_Exception;

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
2844: ((new_references.decision_reason_id IS NULL))) THEN
2845: NULL;

Line 2853: App_Exception.Raise_Exception;

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
2856: ((new_references.pending_reason_id IS NULL))) THEN
2857: NULL;

Line 2865: App_Exception.Raise_Exception;

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
2868: ((new_references.attendance_mode IS NULL))) THEN
2869: NULL;

Line 2877: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2880: IF (((old_references.adm_offer_dfrmnt_status = new_references.adm_offer_dfrmnt_status)) OR
2881: ((new_references.adm_offer_dfrmnt_status IS NULL))) THEN

Line 2890: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2893: IF (((old_references.adm_offer_resp_status = new_references.adm_offer_resp_status)) OR
2894: ((new_references.adm_offer_resp_status IS NULL))) THEN

Line 2903: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2906: IF (((old_references.adm_outcome_status = new_references.adm_outcome_status)) OR
2907: ((new_references.adm_outcome_status IS NULL))) THEN

Line 2916: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2919: IF (((old_references.attendance_type = new_references.attendance_type)) OR
2920: ((new_references.attendance_type IS NULL))) THEN

Line 2929: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2932: -- Bug no 2380815 locking issue
2933: -- Removed GET_PK call for Correspondence categories

Line 2948: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2951: IF (((old_references.adm_cal_type = new_references.adm_cal_type) AND
2952: (old_references.adm_ci_sequence_number = new_references.adm_ci_sequence_number)) OR

Line 2964: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2967: -- Bug no 2380815 locking issue
2968: -- Removed GET_PK call for IGS_PS_COURSE_PKG

Line 2983: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2986: IF (((old_references.enrolment_cat = new_references.enrolment_cat)) OR
2987: ((new_references.enrolment_cat IS NULL))) THEN

Line 2996: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2999: IF (((old_references.fee_cat = new_references.fee_cat)) OR
3000: ((new_references.fee_cat IS NULL))) THEN

Line 3009: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3012: IF (((old_references.funding_source = new_references.funding_source)) OR
3013: ((new_references.funding_source IS NULL))) THEN

Line 3022: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3025: IF (((old_references.hecs_payment_option = new_references.hecs_payment_option)) OR
3026: ((new_references.hecs_payment_option IS NULL))) THEN

Line 3035: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3038: IF (((old_references.location_cd = new_references.location_cd)) OR
3039: ((new_references.location_cd IS NULL))) THEN

Line 3048: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3051: IF (((old_references.person_id = new_references.person_id)) OR
3052: ((new_references.person_id IS NULL))) THEN

Line 3061: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3064: IF (((old_references.ass_tracking_id = new_references.ass_tracking_id)) OR
3065: ((new_references.ass_tracking_id IS NULL))) THEN

Line 3074: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3077: IF (((old_references.deferred_tracking_id = new_references.deferred_tracking_id)) OR
3078: ((new_references.deferred_tracking_id IS NULL))) THEN

Line 3087: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3090: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND
3091: (old_references.us_version_number = new_references.us_version_number)) OR

Line 3103: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3106: IF (((old_references.person_id = new_references.person_id) AND
3107: (old_references.admission_appl_number = new_references.admission_appl_number)) OR

Line 3119: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3122: IF (((old_references.person_id = new_references.person_id) AND
3123: (old_references.admission_appl_number = new_references.admission_appl_number) AND

Line 3138: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3141: IF (((old_references.adm_cndtnl_offer_status = new_references.adm_cndtnl_offer_status)) OR
3142: ((new_references.adm_cndtnl_offer_status IS NULL))) THEN

Line 3151: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3154: IF (((old_references.adm_doc_status = new_references.adm_doc_status)) OR
3155: ((new_references.adm_doc_status IS NULL))) THEN

Line 3164: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3167: IF (((old_references.adm_entry_qual_status = new_references.adm_entry_qual_status)) OR
3168: ((new_references.adm_entry_qual_status IS NULL))) THEN

Line 3177: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3180: IF (((old_references.late_adm_fee_status = new_references.late_adm_fee_status)) OR
3181: ((new_references.late_adm_fee_status IS NULL))) THEN

Line 3190: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3193:
3194: IF (((old_references.future_acad_cal_type = new_references.future_acad_cal_type) AND

Line 3207: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3210:
3211: IF (((old_references.future_adm_cal_type = new_references.future_adm_cal_type) AND

Line 3224: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3227: IF (((old_references.person_id = new_references.person_id) AND
3228: (old_references.nominated_course_cd = new_references.nominated_course_cd) AND

Line 3246: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3249:
3250: IF (((old_references.person_id = new_references.person_id) AND

Line 3269: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3272:
3273:

Line 3284: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3287:
3288:

Line 3550: App_Exception.Raise_Exception;

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;
3553: Close cur_rowid1;
3554: Open cur_rowid2;

Line 3560: App_Exception.Raise_Exception;

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;
3563: Close cur_rowid2;
3564: Open cur_rowid3;

Line 3570: App_Exception.Raise_Exception;

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;
3573: Close cur_rowid3;
3574: Open cur_rowid5;

Line 3580: App_Exception.Raise_Exception;

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;
3583: Close cur_rowid5;
3584: Open cur_rowid6;

Line 3590: App_Exception.Raise_Exception;

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;
3593: Close cur_rowid6;
3594: Open cur_rowid7;

Line 3600: App_Exception.Raise_Exception;

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;
3603: Close cur_rowid7;
3604: END Get_FK_Igs_Ad_Code_Classes;

Line 3630: App_Exception.Raise_Exception;

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;
3633: Close cur_rowid;
3634: END Get_FK_Igs_Or_Institution;

Line 3664: App_Exception.Raise_Exception;

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;
3667: Close cur_rowid1;
3668: Open cur_rowid2;

Line 3674: App_Exception.Raise_Exception;

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;
3677: Close cur_rowid2;
3678: END Get_FK_Igs_Pe_Person;

Line 3695: App_Exception.Raise_Exception;

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;
3698: Close cur_rowid;
3699: END GET_FK_IGS_EN_ATD_MODE;

Line 3717: App_Exception.Raise_Exception;

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;
3720: Close cur_rowid;
3721: END GET_FK_IGS_AD_OFRDFRMT_STAT;

Line 3739: App_Exception.Raise_Exception;

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;
3742: Close cur_rowid;
3743: END GET_FK_IGS_AD_OFR_RESP_STAT;

Line 3761: App_Exception.Raise_Exception;

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;
3764: Close cur_rowid;
3765: END GET_FK_IGS_AD_OU_STAT;

Line 3782: App_Exception.Raise_Exception;

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;
3785: Close cur_rowid;
3786: END GET_FK_IGS_EN_ATD_TYPE;

Line 3803: App_Exception.Raise_Exception;

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;
3806: Close cur_rowid;
3807: END GET_FK_IGS_CO_CAT;

Line 3840: App_Exception.Raise_Exception;

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;
3843: Close cur_rowid;
3844: END GET_FK_IGS_CA_INST;

Line 3861: App_Exception.Raise_Exception;

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;
3864: Close cur_rowid;
3865: END GET_FK_IGS_PS_COURSE;

Line 3884: App_Exception.Raise_Exception;

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;
3887: Close cur_rowid;
3888: END GET_FK_IGS_PS_VER;

Line 3905: App_Exception.Raise_Exception;

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;
3908: Close cur_rowid;
3909: END GET_FK_IGS_EN_ENROLMENT_CAT;

Line 3926: App_Exception.Raise_Exception;

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;
3929: Close cur_rowid;
3930: END GET_FK_IGS_FI_FEE_CAT;

Line 3947: App_Exception.Raise_Exception;

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;
3950: Close cur_rowid;
3951: END GET_FK_IGS_FI_FUND_SRC;

Line 3968: App_Exception.Raise_Exception;

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;
3971: Close cur_rowid;
3972: END GET_FK_IGS_FI_HECS_PAY_OPTN;

Line 3989: App_Exception.Raise_Exception;

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;
3992: Close cur_rowid;
3993: END GET_FK_IGS_AD_LOCATION;

Line 4011: App_Exception.Raise_Exception;

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;
4014: Close cur_rowid;
4015: END GET_FK_IGS_TR_ITEM;

Line 4034: App_Exception.Raise_Exception;

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;
4037: Close cur_rowid;
4038: END GET_FK_IGS_EN_UNIT_SET;

Line 4067: App_Exception.Raise_Exception;

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;
4070: Close cur_rowid;
4071: END GET_FK_IGS_PS_OFR_UNIT_SET;

Line 4093: App_Exception.Raise_Exception;

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;
4096: Close cur_rowid;
4097: END GET_FK_IGS_AD_APPL;

Line 4118: App_Exception.Raise_Exception;

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;
4121: Close cur_rowid;
4122: END GET_FK_IGS_AD_PS_APPL;

Line 4139: App_Exception.Raise_Exception;

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;
4142: Close cur_rowid;
4143: END GET_FK_IGS_AD_CNDNL_OFRSTAT;

Line 4160: App_Exception.Raise_Exception;

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;
4163: Close cur_rowid;
4164: END GET_FK_IGS_AD_DOC_STAT;

Line 4181: App_Exception.Raise_Exception;

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;
4184: Close cur_rowid;
4185: END GET_FK_IGS_AD_ENT_QF_STAT;

Line 4202: App_Exception.Raise_Exception;

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;
4205: Close cur_rowid;
4206: END GET_FK_IGS_AD_FEE_STAT;

Line 4232: App_Exception.Raise_Exception;

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;
4235: Close cur_rowid;
4236: END GET_FK_IGS_AD_SCHL_APLY_TO;

Line 4574: App_Exception.Raise_Exception;

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;
4577: Check_Parent_Existance;
4578: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);

Line 4592: App_Exception.Raise_Exception;

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
4595:
4596: -- rghosh bug# 2860860 (UCAS Conditional Offer build)

Line 4653: App_Exception.Raise_Exception;

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;
4656: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
4657: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN

Line 5140: app_exception.raise_exception;

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(
5143: p_action=>'INSERT',
5144: x_rowid=>X_ROWID,

Line 5593: app_exception.raise_exception;

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;
5596: END IF;
5597: END INSERT_ROW;

Line 5879: app_exception.raise_exception;

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;
5880: return;
5881: end if;
5882: close c1;
5883:

Line 6034: app_exception.raise_exception;

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;
6037: end LOCK_ROW;
6038: Procedure UPDATE_ROW (

Line 6207: app_exception.raise_exception;

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:
6210: Before_DML(
6211: p_action=>'UPDATE',

Line 6507: app_exception.raise_exception;

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;
6509: IF (x_mode = 'S') THEN
6510: igs_sc_gen_001.unset_ctx('R');
6511: END IF;

Line 6532: app_exception.raise_exception;

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:
6535:
6536: RAISE;

Line 6990: app_exception.raise_exception;

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;
6992: IF (x_mode = 'S') THEN
6993: igs_sc_gen_001.unset_ctx('R');
6994: END IF;

Line 7014: app_exception.raise_exception;

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;
7017: END IF;
7018: