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

Line 53: App_Exception.Raise_Exception;

49: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
50: Close cur_old_ref_values;
51: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
56: Close cur_old_ref_values;
57:

Line 193: App_Exception.Raise_Exception;

189: v_unit_restr_ind,
190: v_message_name) = FALSE THEN
191: Fnd_Message.Set_Name('IGS',v_message_name);
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196: IF p_inserting OR p_updating THEN
197: -- Determine the Academic and Admission period for validation.

Line 236: App_Exception.Raise_Exception;

232: v_offer_ind,
233: v_message_name) = FALSE THEN
234: Fnd_Message.Set_Name('IGS',v_message_name);
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: -- Validate a research unit.
239: IF IGS_AD_VAL_ACAIU.admp_val_res_unit (
240: new_references.person_id,

Line 254: App_Exception.Raise_Exception;

250: v_return_type) = FALSE THEN
251: IF v_return_type = cst_error THEN
252: Fnd_Message.Set_Name('IGS',v_message_name);
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: -- Validate unit encumbrances.
258: IF v_unit_encmb_chk_ind = 'Y' THEN

Line 272: App_Exception.Raise_Exception;

268: v_return_type) = FALSE THEN
269: IF NVL(v_return_type, '-1') = cst_error THEN
270: Fnd_Message.Set_Name('IGS',v_message_name);
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
275: END IF;
276: END IF;

Line 290: App_Exception.Raise_Exception;

286: new_references.adm_unit_outcome_status,
287: v_message_name) = FALSE THEN
288: Fnd_Message.Set_Name('IGS',v_message_name);
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292: IF v_offer_ind = 'Y' THEN
293: -- Validate that unit version is active
294: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_uv(

Line 302: App_Exception.Raise_Exception;

298: v_offer_ind,
299: v_message_name) = FALSE THEN
300: Fnd_Message.Set_Name('IGS',v_message_name);
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: -- Validate a research unit.
305: IF IGS_AD_VAL_ACAIU.admp_val_res_unit (
306: new_references.person_id,

Line 320: App_Exception.Raise_Exception;

316: v_return_type) = FALSE THEN
317: IF v_return_type = cst_error THEN
318: Fnd_Message.Set_Name('IGS',v_message_name);
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: END IF;
323: END IF;
324: END IF;

Line 333: App_Exception.Raise_Exception;

329: new_references.unit_mode,
330: v_message_name) = FALSE THEN
331: Fnd_Message.Set_Name('IGS',v_message_name);
332: IGS_GE_MSG_STACK.ADD;
333: App_Exception.Raise_Exception;
334: END IF;
335: END IF;
336: IF (NVL(old_references.unit_mode, '-1') <> NVL(new_references.unit_mode, '-1')) OR
337: (NVL(old_references.unit_class, '-1') <> NVL(new_references.unit_class, '-1')) THEN

Line 344: App_Exception.Raise_Exception;

340: new_references.unit_mode,
341: v_message_name) = FALSE THEN
342: Fnd_Message.Set_Name('IGS',v_message_name);
343: IGS_GE_MSG_STACK.ADD;
344: App_Exception.Raise_Exception;
345: END IF;
346: END IF;
347: -- Validate the options of the admission course application unit
348: IF (NVL(old_references.uv_version_number, -1) <> new_references.uv_version_number) OR

Line 373: App_Exception.Raise_Exception;

369: v_offer_ind,
370: v_message_name) = FALSE THEN
371: Fnd_Message.Set_Name('IGS',v_message_name);
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375: END IF;
376: -- Validate the unit version against the teaching period.
377: IF (NVL(old_references.uv_version_number, -1) <> new_references.uv_version_number) OR

Line 388: App_Exception.Raise_Exception;

384: new_references.ci_sequence_number,
385: v_message_name) = FALSE THEN
386: Fnd_Message.Set_Name('IGS',v_message_name);
387: IGS_GE_MSG_STACK.ADD;
388: App_Exception.Raise_Exception;
389: END IF;
390: END IF;
391: END IF;
392:

Line 475: App_Exception.Raise_Exception;

471: new_references.unit_class ) = FALSE THEN
472: Fnd_Message.Set_Name('IGS',v_message_name);
473: Fnd_Message.Set_Token('UNIT_RSTR_NUM',IGS_GE_NUMBER.TO_CANN(v_unit_restriction_num));
474: IGS_GE_MSG_STACK.ADD;
475: App_Exception.Raise_Exception;
476: END IF;
477: END IF;
478: -- Save the rowid of the current row.
479: END IF;

Line 576: App_Exception.Raise_Exception;

572: new_references.acai_sequence_number
573: ) THEN
574: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
575: IGS_GE_MSG_STACK.ADD;
576: App_Exception.Raise_Exception;
577: END IF;
578: END IF;
579:
580: IF (((old_references.adm_unit_outcome_status = new_references.adm_unit_outcome_status)) OR

Line 589: App_Exception.Raise_Exception;

585: new_references.adm_unit_outcome_status , 'N'
586: ) THEN
587: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
588: IGS_GE_MSG_STACK.ADD;
589: App_Exception.Raise_Exception;
590: END IF;
591: END IF;
592:
593: IF (((old_references.location_cd = new_references.location_cd)) OR

Line 602: App_Exception.Raise_Exception;

598: new_references.location_cd , 'N'
599: ) THEN
600: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception;
603: END IF;
604: END IF;
605:
606: IF (((old_references.rule_waived_person_id = new_references.rule_waived_person_id)) OR

Line 615: App_Exception.Raise_Exception;

611: new_references.rule_waived_person_id
612: ) THEN
613: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
614: IGS_GE_MSG_STACK.ADD;
615: App_Exception.Raise_Exception;
616: END IF;
617: END IF;
618:
619: IF (((old_references.sup_unit_cd = new_references.sup_unit_cd) AND

Line 631: App_Exception.Raise_Exception;

627: new_references.sup_uv_version_number
628: ) THEN
629: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
630: IGS_GE_MSG_STACK.ADD;
631: App_Exception.Raise_Exception;
632: END IF;
633: END IF;
634:
635: IF (((old_references.ass_tracking_id = new_references.ass_tracking_id)) OR

Line 644: App_Exception.Raise_Exception;

640: new_references.ass_tracking_id
641: ) THEN
642: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
643: IGS_GE_MSG_STACK.ADD;
644: App_Exception.Raise_Exception;
645: END IF;
646: END IF;
647:
648: IF (((old_references.unit_class = new_references.unit_class)) OR

Line 657: App_Exception.Raise_Exception;

653: new_references.unit_class
654: ) THEN
655: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
656: IGS_GE_MSG_STACK.ADD;
657: App_Exception.Raise_Exception;
658: END IF;
659: END IF;
660:
661: IF (((old_references.unit_mode= new_references.unit_mode)) OR

Line 670: App_Exception.Raise_Exception;

666: new_references.unit_mode
667: ) THEN
668: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
669: IGS_GE_MSG_STACK.ADD;
670: App_Exception.Raise_Exception;
671: END IF;
672: END IF;
673:
674: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 698: App_Exception.Raise_Exception;

694: new_references.unit_class
695: ) THEN
696: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
697: IGS_GE_MSG_STACK.ADD;
698: App_Exception.Raise_Exception;
699: END IF;
700: END IF;
701:
702: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 720: App_Exception.Raise_Exception;

716: new_references.ci_sequence_number
717: ) THEN
718: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
719: IGS_GE_MSG_STACK.ADD;
720: App_Exception.Raise_Exception;
721: END IF;
722: END IF;
723:
724: END Check_Parent_Existance;

Line 757: App_Exception.Raise_Exception;

753: column_name is null Then
754: IF new_references.adm_unit_outcome_status <> UPPER(new_references.adm_unit_outcome_status) Then
755: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
756: IGS_GE_MSG_STACK.ADD;
757: App_Exception.Raise_Exception;
758: END IF;
759: END IF;
760:
761: IF upper(column_name) = 'CAL_TYPE' OR

Line 766: App_Exception.Raise_Exception;

762: column_name is null Then
763: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
764: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
765: IGS_GE_MSG_STACK.ADD;
766: App_Exception.Raise_Exception;
767: END IF;
768: END IF;
769:
770: IF upper(column_name) = 'LOCATION_CD' OR

Line 775: App_Exception.Raise_Exception;

771: column_name is null Then
772: IF new_references.location_cd <> UPPER(new_references.location_cd) Then
773: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
774: IGS_GE_MSG_STACK.ADD;
775: App_Exception.Raise_Exception;
776: END IF;
777: END IF;
778:
779: IF upper(column_name) = 'UNIT_CD' OR

Line 784: App_Exception.Raise_Exception;

780: column_name is null Then
781: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
782: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
783: IGS_GE_MSG_STACK.ADD;
784: App_Exception.Raise_Exception;
785: END IF;
786: END IF;
787:
788: IF upper(column_name) = 'UNIT_CLASS' OR

Line 793: App_Exception.Raise_Exception;

789: column_name is null Then
790: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
791: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
792: IGS_GE_MSG_STACK.ADD;
793: App_Exception.Raise_Exception;
794: END IF;
795: END IF;
796:
797: IF upper(column_name) = 'UNIT_MODE' OR

Line 802: App_Exception.Raise_Exception;

798: column_name is null Then
799: IF new_references.unit_mode <> UPPER(new_references.unit_mode) Then
800: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
801: IGS_GE_MSG_STACK.ADD;
802: App_Exception.Raise_Exception;
803: END IF;
804: END IF;
805:
806: IF upper(column_name) = 'SUP_UNIT_CD' OR

Line 811: App_Exception.Raise_Exception;

807: column_name is null Then
808: IF new_references.sup_unit_cd <> UPPER(new_references.sup_unit_cd) Then
809: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
810: IGS_GE_MSG_STACK.ADD;
811: App_Exception.Raise_Exception;
812: END IF;
813: END IF;
814:
815: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR

Line 821: App_Exception.Raise_Exception;

817: IF new_references.ci_sequence_number < 1 OR
818: new_references.ci_sequence_number > 999999 Then
819: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
820: IGS_GE_MSG_STACK.ADD;
821: App_Exception.Raise_Exception;
822: END IF;
823: END IF;
824:
825: END Check_Constraints;

Line 924: App_Exception.Raise_Exception;

920: IF (cur_rowid%FOUND) THEN
921: Close cur_rowid;
922: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_ACAI_FK');
923: IGS_GE_MSG_STACK.ADD;
924: App_Exception.Raise_Exception;
925: Return;
926: END IF;
927: Close cur_rowid;
928:

Line 950: App_Exception.Raise_Exception;

946: IF (cur_rowid%FOUND) THEN
947: Close cur_rowid;
948: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_AUOS_FK');
949: IGS_GE_MSG_STACK.ADD;
950: App_Exception.Raise_Exception;
951: Return;
952: END IF;
953: Close cur_rowid;
954:

Line 976: App_Exception.Raise_Exception;

972: IF (cur_rowid%FOUND) THEN
973: Close cur_rowid;
974: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_LOC_FK');
975: IGS_GE_MSG_STACK.ADD;
976: App_Exception.Raise_Exception;
977: Return;
978: END IF;
979: Close cur_rowid;
980:

Line 1002: App_Exception.Raise_Exception;

998: IF (cur_rowid%FOUND) THEN
999: Close cur_rowid;
1000: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_PE_FK');
1001: IGS_GE_MSG_STACK.ADD;
1002: App_Exception.Raise_Exception;
1003: Return;
1004: END IF;
1005: Close cur_rowid;
1006:

Line 1030: App_Exception.Raise_Exception;

1026: IF (cur_rowid%FOUND) THEN
1027: Close cur_rowid;
1028: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_SUP_UV_FK');
1029: IGS_GE_MSG_STACK.ADD;
1030: App_Exception.Raise_Exception;
1031: Return;
1032: END IF;
1033: Close cur_rowid;
1034:

Line 1056: App_Exception.Raise_Exception;

1052: IF (cur_rowid%FOUND) THEN
1053: Close cur_rowid;
1054: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_TRI_FK');
1055: IGS_GE_MSG_STACK.ADD;
1056: App_Exception.Raise_Exception;
1057: Return;
1058: END IF;
1059: Close cur_rowid;
1060:

Line 1082: App_Exception.Raise_Exception;

1078: IF (cur_rowid%FOUND) THEN
1079: Close cur_rowid;
1080: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_UM_FK');
1081: IGS_GE_MSG_STACK.ADD;
1082: App_Exception.Raise_Exception;
1083: Return;
1084: END IF;
1085: Close cur_rowid;
1086:

Line 1118: App_Exception.Raise_Exception;

1114: IF (cur_rowid%FOUND) THEN
1115: Close cur_rowid;
1116: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_UOO_FK');
1117: IGS_GE_MSG_STACK.ADD;
1118: App_Exception.Raise_Exception;
1119: Return;
1120: END IF;
1121: Close cur_rowid;
1122:

Line 1150: App_Exception.Raise_Exception;

1146: IF (cur_rowid%FOUND) THEN
1147: Close cur_rowid;
1148: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACAIU_UOP_FK');
1149: IGS_GE_MSG_STACK.ADD;
1150: App_Exception.Raise_Exception;
1151: Return;
1152: END IF;
1153: Close cur_rowid;
1154:

Line 1241: App_Exception.Raise_Exception;

1237: new_references.unit_class
1238: ) THEN
1239: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1240: IGS_GE_MSG_STACK.ADD;
1241: App_Exception.Raise_Exception;
1242: END IF;
1243: Check_Constraints;
1244: Check_Parent_Existance;
1245: ELSIF (p_action = 'UPDATE') THEN

Line 1261: App_Exception.Raise_Exception;

1257: new_references.unit_class
1258: ) THEN
1259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1260: IGS_GE_MSG_STACK.ADD;
1261: App_Exception.Raise_Exception;
1262: END IF;
1263: BeforeRowInsertUpdateDelete1 ( p_updating => TRUE );
1264: Check_Constraints;
1265: Check_Parent_Existance;

Line 1285: App_Exception.Raise_Exception;

1281: new_references.unit_class
1282: ) THEN
1283: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1284: IGS_GE_MSG_STACK.ADD;
1285: App_Exception.Raise_Exception;
1286: END IF;
1287: Check_Constraints;
1288: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1289: IF Get_UK_For_Validation (

Line 1303: App_Exception.Raise_Exception;

1299: new_references.unit_class
1300: ) THEN
1301: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1302: IGS_GE_MSG_STACK.ADD;
1303: App_Exception.Raise_Exception;
1304: END IF;
1305: Check_Constraints;
1306: END IF;
1307: END Before_DML;

Line 1398: app_exception.raise_exception;

1394: end if;
1395: else
1396: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1397: IGS_GE_MSG_STACK.ADD;
1398: app_exception.raise_exception;
1399: end if;
1400:
1401: Before_DML(p_action =>'INSERT',
1402: x_rowid =>X_ROWID,

Line 1518: app_exception.raise_exception;

1514: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1515: fnd_message.set_token ('ERR_CD', SQLCODE);
1516: igs_ge_msg_stack.add;
1517: igs_sc_gen_001.unset_ctx('R');
1518: app_exception.raise_exception;
1519: ELSE
1520: igs_sc_gen_001.unset_ctx('R');
1521: RAISE;
1522: END IF;

Line 1571: app_exception.raise_exception;

1567: if (c1%notfound) then
1568: close c1;
1569: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1570: IGS_GE_MSG_STACK.ADD;
1571: app_exception.raise_exception;
1572: return;
1573: end if;
1574: close c1;
1575:

Line 1613: app_exception.raise_exception;

1609: null;
1610: else
1611: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1612: IGS_GE_MSG_STACK.ADD;
1613: app_exception.raise_exception;
1614: end if;
1615: return;
1616: end LOCK_ROW;
1617:

Line 1665: app_exception.raise_exception;

1661: end if;
1662: else
1663: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1664: IGS_GE_MSG_STACK.ADD;
1665: app_exception.raise_exception;
1666: end if;
1667:
1668: Before_DML(p_action =>'UPDATE',
1669: x_rowid =>X_ROWID,

Line 1737: app_exception.raise_exception;

1733: if (sql%notfound) then
1734: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1735: igs_ge_msg_stack.add;
1736: igs_sc_gen_001.unset_ctx('R');
1737: app_exception.raise_exception;
1738: end if;
1739: IF (x_mode = 'S') THEN
1740: igs_sc_gen_001.unset_ctx('R');
1741: END IF;

Line 1758: app_exception.raise_exception;

1754: -- that the ownerof policy function does not have privilege to access.
1755: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1756: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1757: IGS_GE_MSG_STACK.ADD;
1758: app_exception.raise_exception;
1759: ELSE
1760: RAISE;
1761: END IF;
1762: end UPDATE_ROW;

Line 1861: app_exception.raise_exception;

1857: if (sql%notfound) then
1858: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1859: igs_ge_msg_stack.add;
1860: igs_sc_gen_001.unset_ctx('R');
1861: app_exception.raise_exception;
1862: end if;
1863: IF (x_mode = 'S') THEN
1864: igs_sc_gen_001.unset_ctx('R');
1865: END IF;

Line 1882: app_exception.raise_exception;

1878: -- that the ownerof policy function does not have privilege to access.
1879: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1880: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1881: IGS_GE_MSG_STACK.ADD;
1882: app_exception.raise_exception;
1883: ELSE
1884: RAISE;
1885: END IF;
1886: end DELETE_ROW;