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

Line 74: App_Exception.Raise_Exception;

70: (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
71: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
72: IGS_GE_MSG_STACK.ADD;
73: Close cur_old_ref_values;
74: App_Exception.Raise_Exception;
75:
76: Return;
77: END IF;
78: Close cur_old_ref_values;

Line 142: App_Exception.Raise_Exception;

138: new_references.restricted_attendance_type
139: ) THEN
140: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
145:
146: IF (((old_references.encmb_course_group_cd =

Line 156: App_Exception.Raise_Exception;

152: new_references.encmb_course_group_cd
153: )THEN
154: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:
160: IF (((old_references.decision_org_unit_cd =

Line 174: App_Exception.Raise_Exception;

170: new_references.decision_ou_start_dt
171: )THEN
172: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177:
178: IF (((old_references.progression_outcome_type =

Line 188: App_Exception.Raise_Exception;

184: new_references.progression_outcome_type
185: )THEN
186: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191:
192: IF (((old_references.progression_rule_cat =

Line 210: App_Exception.Raise_Exception;

206: new_references.pro_sequence_number
207: )THEN
208: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213:
214: IF (((old_references.person_id = new_references.person_id) AND

Line 244: App_Exception.Raise_Exception;

240: new_references.rule_check_dt
241: )THEN
242: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: END IF;
247:
248: END Check_Parent_Existance;

Line 338: App_Exception.Raise_Exception;

334: IF (cur_rowid%FOUND) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPO_ATT_FK');
336: IGS_GE_MSG_STACK.ADD;
337: Close cur_rowid;
338: App_Exception.Raise_Exception;
339: Return;
340: END IF;
341: Close cur_rowid;
342:

Line 367: App_Exception.Raise_Exception;

363: IF (cur_rowid%FOUND) THEN
364: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPO_OU_FK');
365: IGS_GE_MSG_STACK.ADD;
366: Close cur_rowid;
367: App_Exception.Raise_Exception;
368: Return;
369: END IF;
370: Close cur_rowid;
371:

Line 393: App_Exception.Raise_Exception;

389: IF (cur_rowid%FOUND) THEN
390: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPO_POT_FK');
391: IGS_GE_MSG_STACK.ADD;
392: Close cur_rowid;
393: App_Exception.Raise_Exception;
394: Return;
395: END IF;
396: Close cur_rowid;
397:

Line 423: App_Exception.Raise_Exception;

419: IF (cur_rowid%FOUND) THEN
420: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPO_PRO_FK');
421: IGS_GE_MSG_STACK.ADD;
422: Close cur_rowid;
423: App_Exception.Raise_Exception;
424: Return;
425: END IF;
426: Close cur_rowid;
427:

Line 461: App_Exception.Raise_Exception;

457: IF (cur_rowid%FOUND) THEN
458: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPO_SPRC_FK');
459: IGS_GE_MSG_STACK.ADD;
460: Close cur_rowid;
461: App_Exception.Raise_Exception;
462: Return;
463: END IF;
464: Close cur_rowid;
465:

Line 498: APP_EXCEPTION.RAISE_EXCEPTION;

494: IF c_parent%NOTFOUND THEN
495: CLOSE c_parent;
496: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
497: IGS_GE_MSG_STACK.ADD;
498: APP_EXCEPTION.RAISE_EXCEPTION;
499: END IF;
500: CLOSE c_parent;
501: ELSIF(p_action = 'UPDATE') THEN
502: IF NVL(new_references.progression_rule_cat,'1') <> NVL(old_references.progression_rule_cat,'1') OR

Line 511: APP_EXCEPTION.RAISE_EXCEPTION;

507: IF c_parent%NOTFOUND THEN
508: CLOSE c_parent;
509: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
510: IGS_GE_MSG_STACK.ADD;
511: APP_EXCEPTION.RAISE_EXCEPTION;
512: END IF;
513: CLOSE c_parent;
514: END IF;
515: END IF;

Line 623: App_Exception.Raise_Exception;

619: IF lvSystem_Outcome_Type = 'SUSPENSION' THEN
620: IF (x_duration IS NULL OR x_duration_type IS NULL) THEN
621: Fnd_Message.Set_Name('IGS','IGS_PR_SUSP_OUC_MUST_DURAT');
622: IGS_GE_MSG_STACK.ADD;
623: App_Exception.Raise_Exception;
624: END IF;
625: END IF;
626: IF lvSystem_Outcome_Type <> 'PROBATION' THEN
627: IF x_duration_type = 'EFFECTIVE' THEN

Line 630: App_Exception.Raise_Exception;

626: IF lvSystem_Outcome_Type <> 'PROBATION' THEN
627: IF x_duration_type = 'EFFECTIVE' THEN
628: Fnd_Message.Set_Name('IGS','IGS_PR_PROB_OUC_ONLY_EFCT_DUR');
629: IGS_GE_MSG_STACK.ADD;
630: App_Exception.Raise_Exception;
631: END IF;
632: END IF;
633: END IF; -- end of the added code, pmarada
634:

Line 644: App_Exception.Raise_Exception;

640: new_references.course_cd,
641: new_references.sequence_number) THEN
642: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
643: IGS_GE_MSG_STACK.ADD;
644: App_Exception.Raise_Exception;
645: END IF;
646: check_constraints;
647: ELSIF (p_action = 'UPDATE') THEN
648: -- Call all the procedures related to Before Update.

Line 661: App_Exception.Raise_Exception;

657: new_references.course_cd,
658: new_references.sequence_number) THEN
659: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
660: IGS_GE_MSG_STACK.ADD;
661: App_Exception.Raise_Exception;
662: END IF;
663: check_constraints;
664: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
665: check_constraints;

Line 739: app_exception.raise_exception;

735: END IF;
736: ELSE
737: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
738: IGS_GE_MSG_STACK.ADD;
739: app_exception.raise_exception;
740: END IF;
741:
742: Before_DML (
743: p_action =>'INSERT',

Line 891: app_exception.raise_exception;

887: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
888: fnd_message.set_token ('ERR_CD', SQLCODE);
889: igs_ge_msg_stack.add;
890: igs_sc_gen_001.unset_ctx('R');
891: app_exception.raise_exception;
892: ELSE
893: igs_sc_gen_001.unset_ctx('R');
894: RAISE;
895: END IF;

Line 976: app_exception.raise_exception;

972: IF (c1%NOTFOUND) THEN
973: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
974: IGS_GE_MSG_STACK.ADD;
975: CLOSE c1;
976: app_exception.raise_exception;
977: RETURN;
978: END IF;
979: CLOSE c1;
980:

Line 1077: app_exception.raise_exception;

1073: NULL;
1074: ELSE
1075: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: END IF;
1079: RETURN;
1080: END LOCK_ROW;
1081:

Line 1139: app_exception.raise_exception;

1135: END IF;
1136: ELSE
1137: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1138: IGS_GE_MSG_STACK.ADD;
1139: app_exception.raise_exception;
1140: END IF;
1141:
1142: Before_DML (
1143: p_action =>'UPDATE',

Line 1227: app_exception.raise_exception;

1223: IF (SQL%NOTFOUND) THEN
1224: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1225: igs_ge_msg_stack.add;
1226: igs_sc_gen_001.unset_ctx('R');
1227: app_exception.raise_exception;
1228: END IF;
1229: IF (x_mode = 'S') THEN
1230: igs_sc_gen_001.unset_ctx('R');
1231: END IF;

Line 1242: app_exception.raise_exception;

1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;
1246: END IF;

Line 1397: app_exception.raise_exception;

1393: IF (SQL%NOTFOUND) THEN
1394: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1395: igs_ge_msg_stack.add;
1396: igs_sc_gen_001.unset_ctx('R');
1397: app_exception.raise_exception;
1398: END IF;
1399: IF (x_mode = 'S') THEN
1400: igs_sc_gen_001.unset_ctx('R');
1401: END IF;

Line 1454: App_Exception.Raise_Exception ;

1450: IF new_references.sequence_number < 1 OR
1451: new_references.SEQUENCE_NUMBER > 999999 THEN
1452: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1453: IGS_GE_MSG_STACK.ADD;
1454: App_Exception.Raise_Exception ;
1455: END IF;
1456: END IF ;
1457:
1458: IF UPPER (Column_name) = 'PRG_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 1463: App_Exception.Raise_Exception ;

1459: IF new_references.PRG_CI_SEQUENCE_NUMBER < 1 OR
1460: new_references.PRG_CI_SEQUENCE_NUMBER > 999999 THEN
1461: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1462: IGS_GE_MSG_STACK.ADD;
1463: App_Exception.Raise_Exception ;
1464: END IF;
1465: END IF ;
1466:
1467: IF UPPER (Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 1472: App_Exception.Raise_Exception ;

1468: IF new_references.PRA_SEQUENCE_NUMBER < 1 OR
1469: new_references.PRA_SEQUENCE_NUMBER > 999999 THEN
1470: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1471: IGS_GE_MSG_STACK.ADD;
1472: App_Exception.Raise_Exception ;
1473: END IF;
1474: END IF ;
1475:
1476: IF UPPER (Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 1481: App_Exception.Raise_Exception ;

1477: IF new_references.PRO_SEQUENCE_NUMBER < 1 OR
1478: new_references.PRO_SEQUENCE_NUMBER > 999999 THEN
1479: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1480: IGS_GE_MSG_STACK.ADD;
1481: App_Exception.Raise_Exception ;
1482: END IF;
1483: END IF ;
1484:
1485: IF UPPER (Column_name) = 'DURATION' OR COLUMN_NAME IS NULL THEN

Line 1489: App_Exception.Raise_Exception ;

1485: IF UPPER (Column_name) = 'DURATION' OR COLUMN_NAME IS NULL THEN
1486: IF new_references.DURATION < 1 OR new_references.DURATION > 999 THEN
1487: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1488: IGS_GE_MSG_STACK.ADD;
1489: App_Exception.Raise_Exception ;
1490: END IF;
1491: END IF ;
1492:
1493: IF UPPER (Column_name) = 'DURATION_TYPE' OR COLUMN_NAME IS NULL THEN

Line 1497: App_Exception.Raise_Exception ;

1493: IF UPPER (Column_name) = 'DURATION_TYPE' OR COLUMN_NAME IS NULL THEN
1494: IF new_references.DURATION_TYPE<> UPPER (new_references.DURATION_TYPE) THEN
1495: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1496: IGS_GE_MSG_STACK.ADD;
1497: App_Exception.Raise_Exception ;
1498: END IF;
1499: IF new_references.DURATION_TYPE NOT IN ('NORMAL' , 'EFFECTIVE') THEN
1500: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1501: IGS_GE_MSG_STACK.ADD;

Line 1502: App_Exception.Raise_Exception ;

1498: END IF;
1499: IF new_references.DURATION_TYPE NOT IN ('NORMAL' , 'EFFECTIVE') THEN
1500: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1501: IGS_GE_MSG_STACK.ADD;
1502: App_Exception.Raise_Exception ;
1503: END IF;
1504: END IF ;
1505:
1506: IF UPPER (Column_name) = 'DECISION_STATUS' OR COLUMN_NAME IS NULL THEN

Line 1511: App_Exception.Raise_Exception ;

1507: IF new_references.DECISION_STATUS <> UPPER (new_references.DECISION_STATUS)
1508: THEN
1509: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1510: IGS_GE_MSG_STACK.ADD;
1511: App_Exception.Raise_Exception ;
1512: END IF;
1513: IF new_references.DECISION_STATUS NOT IN ('PENDING', 'APPROVED',
1514: 'WAIVED', 'CANCELLED', 'REMOVED') THEN
1515: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1517: App_Exception.Raise_Exception ;

1513: IF new_references.DECISION_STATUS NOT IN ('PENDING', 'APPROVED',
1514: 'WAIVED', 'CANCELLED', 'REMOVED') THEN
1515: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1516: IGS_GE_MSG_STACK.ADD;
1517: App_Exception.Raise_Exception ;
1518: END IF;
1519: END IF ;
1520:
1521: IF UPPER (Column_name) = 'SHOW_CAUSE_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN

Line 1526: App_Exception.Raise_Exception ;

1522: IF new_references.SHOW_CAUSE_OUTCOME_TYPE <>
1523: UPPER (new_references.SHOW_CAUSE_OUTCOME_TYPE) THEN
1524: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1525: IGS_GE_MSG_STACK.ADD;
1526: App_Exception.Raise_Exception ;
1527: END IF;
1528: IF new_references.SHOW_CAUSE_OUTCOME_TYPE NOT IN ('UPHELD', 'DISMISSED')
1529: THEN
1530: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1532: App_Exception.Raise_Exception ;

1528: IF new_references.SHOW_CAUSE_OUTCOME_TYPE NOT IN ('UPHELD', 'DISMISSED')
1529: THEN
1530: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1531: IGS_GE_MSG_STACK.ADD;
1532: App_Exception.Raise_Exception ;
1533: END IF;
1534: END IF ;
1535:
1536: IF UPPER (Column_name) = 'APPEAL_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN

Line 1541: App_Exception.Raise_Exception ;

1537: IF new_references.APPEAL_OUTCOME_TYPE <>
1538: UPPER (new_references.APPEAL_OUTCOME_TYPE) THEN
1539: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1540: IGS_GE_MSG_STACK.ADD;
1541: App_Exception.Raise_Exception ;
1542: END IF;
1543: IF new_references.APPEAL_OUTCOME_TYPE NOT IN ('UPHELD' , 'DISMISSED') THEN
1544: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1545: IGS_GE_MSG_STACK.ADD;

Line 1546: App_Exception.Raise_Exception ;

1542: END IF;
1543: IF new_references.APPEAL_OUTCOME_TYPE NOT IN ('UPHELD' , 'DISMISSED') THEN
1544: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1545: IGS_GE_MSG_STACK.ADD;
1546: App_Exception.Raise_Exception ;
1547: END IF;
1548: END IF ;
1549:
1550: IF UPPER (Column_name) = 'RESTRICTED_ENROLMENT_CP' OR COLUMN_NAME IS NULL THEN

Line 1555: App_Exception.Raise_Exception ;

1551: IF new_references.RESTRICTED_ENROLMENT_CP < 0 OR
1552: new_references.RESTRICTED_ENROLMENT_CP > 999.999 THEN
1553: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1554: IGS_GE_MSG_STACK.ADD;
1555: App_Exception.Raise_Exception ;
1556: END IF;
1557: END IF ;
1558:
1559: IF UPPER (Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN

Line 1563: App_Exception.Raise_Exception ;

1559: IF UPPER (Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
1560: IF new_references.COURSE_CD<> UPPER (new_references.COURSE_CD) THEN
1561: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1562: IGS_GE_MSG_STACK.ADD;
1563: App_Exception.Raise_Exception ;
1564: END IF;
1565: END IF ;
1566:
1567: IF UPPER (Column_name) = 'ENCMB_COURSE_GROUP_CD' OR COLUMN_NAME IS NULL THEN

Line 1572: App_Exception.Raise_Exception ;

1568: IF new_references.ENCMB_COURSE_GROUP_CD <>
1569: UPPER (new_references.ENCMB_COURSE_GROUP_CD) THEN
1570: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1571: IGS_GE_MSG_STACK.ADD;
1572: App_Exception.Raise_Exception ;
1573: END IF;
1574: END IF ;
1575:
1576: IF UPPER (Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN

Line 1580: App_Exception.Raise_Exception ;

1576: IF UPPER (Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
1577: IF new_references.PRG_CAL_TYPE<> UPPER (new_references.PRG_CAL_TYPE) THEN
1578: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1579: IGS_GE_MSG_STACK.ADD;
1580: App_Exception.Raise_Exception ;
1581: END IF;
1582: END IF ;
1583:
1584: IF UPPER (Column_name) = 'PROGRESSION_OUTCOME_TYPE' OR COLUMN_NAME IS NULL

Line 1590: App_Exception.Raise_Exception ;

1586: IF new_references.PROGRESSION_OUTCOME_TYPE <>
1587: UPPER (new_references.PROGRESSION_OUTCOME_TYPE) THEN
1588: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1589: IGS_GE_MSG_STACK.ADD;
1590: App_Exception.Raise_Exception ;
1591: END IF;
1592: END IF ;
1593:
1594: IF UPPER (Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN

Line 1599: App_Exception.Raise_Exception ;

1595: IF new_references.PROGRESSION_RULE_CAT <>
1596: UPPER (new_references.PROGRESSION_RULE_CAT) THEN
1597: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1598: IGS_GE_MSG_STACK.ADD;
1599: App_Exception.Raise_Exception ;
1600: END IF;
1601: END IF ;
1602:
1603: IF UPPER (Column_name) = 'RESTRICTED_ATTENDANCE_TYPE' OR

Line 1609: App_Exception.Raise_Exception ;

1605: IF new_references.RESTRICTED_ATTENDANCE_TYPE <>
1606: UPPER (new_references.RESTRICTED_ATTENDANCE_TYPE) THEN
1607: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1608: IGS_GE_MSG_STACK.ADD;
1609: App_Exception.Raise_Exception ;
1610: END IF;
1611: END IF ;
1612:
1613: END Check_Constraints;