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

Line 61: App_Exception.Raise_Exception;

57: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: Close cur_old_ref_values;
61: App_Exception.Raise_Exception;
62: Return;
63: END IF;
64: Close cur_old_ref_values;
65:

Line 129: App_Exception.Raise_Exception;

125: new_references.course_type,
126: v_message_name) = FALSE THEN
127: Fnd_Message.Set_Name('IGS',v_message_name);
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132: -- Validate the IGS_PS_COURSE version is active
133: IF p_inserting OR

Line 144: App_Exception.Raise_Exception;

140: new_references.crv_version_number,
141: v_message_name) = FALSE THEN
142: Fnd_Message.Set_Name('IGS',v_message_name);
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147: -- Validate the IGS_OR_UNIT is active
148: IF p_inserting OR

Line 159: App_Exception.Raise_Exception;

155: new_references.ou_start_dt,
156: v_message_name) = FALSE THEN
157: Fnd_Message.Set_Name('IGS',v_message_name);
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: -- Validate the progression IGS_RU_RULE category
163: IF p_inserting THEN

Line 169: App_Exception.Raise_Exception;

165: new_references.progression_rule_cat,
166: v_message_name) = FALSE THEN
167: Fnd_Message.Set_Name('IGS',v_message_name);
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172: -- Validate the progression IGS_RU_RULE
173: IF new_references.progression_rule_cd IS NOT NULL AND (p_inserting OR

Line 181: App_Exception.Raise_Exception;

177: new_references.progression_rule_cd,
178: v_message_name) = FALSE THEN
179: Fnd_Message.Set_Name('IGS',v_message_name);
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: -- Validate the attendance type
185: IF new_references.attendance_type IS NOT NULL AND (p_inserting OR

Line 199: App_Exception.Raise_Exception;

195: new_references.attendance_type,
196: v_message_name) = FALSE THEN
197: Fnd_Message.Set_Name('IGS',v_message_name);
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202: -- Validate the record has the required details
203: IF p_inserting OR p_updating THEN

Line 225: App_Exception.Raise_Exception;

221: v_message_name) = FALSE THEN
222:
223: Fnd_Message.Set_Name('IGS',v_message_name);
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
228:
229:

Line 244: App_Exception.Raise_Exception;

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

Line 263: App_Exception.Raise_Exception;

259: ) THEN
260:
261: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264:
265: END IF;
266:
267: END IF;

Line 279: App_Exception.Raise_Exception;

275: ) THEN
276:
277: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END IF;
281:
282: END IF;
283:

Line 297: App_Exception.Raise_Exception;

293: ) THEN
294:
295: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298:
299: END IF;
300:
301: END IF;

Line 313: App_Exception.Raise_Exception;

309: ) THEN
310:
311: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314:
315: END IF;
316:
317: END IF;

Line 335: App_Exception.Raise_Exception;

331: ) THEN
332:
333: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336:
337: END IF;
338:
339: END IF;

Line 353: App_Exception.Raise_Exception;

349: new_references.progression_rule_cd
350: ) THEN
351: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354:
355: END IF;
356:
357: END IF;

Line 372: App_Exception.Raise_Exception;

368: ) THEN
369:
370: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373:
374: END IF;
375:
376: END IF;

Line 394: App_Exception.Raise_Exception;

390: ) THEN
391:
392: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: App_Exception.Raise_Exception;
395:
396: END IF;
397:
398: END IF;

Line 412: App_Exception.Raise_Exception;

408: ) THEN
409:
410: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
411: IGS_GE_MSG_STACK.ADD;
412: App_Exception.Raise_Exception;
413:
414: END IF;
415:
416: END IF;

Line 486: App_Exception.Raise_Exception;

482: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
483: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PCS_FK');
484: IGS_GE_MSG_STACK.ADD;
485: Close cur_rowid;
486: App_Exception.Raise_Exception;
487: Return;
488: END IF;
489: Close cur_rowid;
490:

Line 512: App_Exception.Raise_Exception;

508: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null ) THEN
509: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_ATT_FK');
510: IGS_GE_MSG_STACK.ADD;
511: Close cur_rowid;
512: App_Exception.Raise_Exception;
513: Return;
514: END IF;
515: Close cur_rowid;
516:

Line 540: App_Exception.Raise_Exception;

536: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
537: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_CRV_FK');
538: IGS_GE_MSG_STACK.ADD;
539: Close cur_rowid;
540: App_Exception.Raise_Exception;
541: Return;
542: END IF;
543: Close cur_rowid;
544:

Line 569: App_Exception.Raise_Exception;

565: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
566: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_OU_FK');
567: IGS_GE_MSG_STACK.ADD;
568: Close cur_rowid;
569: App_Exception.Raise_Exception;
570: Return;
571: END IF;
572: Close cur_rowid;
573:

Line 595: App_Exception.Raise_Exception;

591: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
592: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRGC_FK');
593: IGS_GE_MSG_STACK.ADD;
594: Close cur_rowid;
595: App_Exception.Raise_Exception;
596:
597: Return;
598: END IF;
599: Close cur_rowid;

Line 626: App_Exception.Raise_Exception;

622: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
623: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRO_FK');
624: IGS_GE_MSG_STACK.ADD;
625: Close cur_rowid;
626: App_Exception.Raise_Exception;
627:
628: Return;
629: END IF;
630: Close cur_rowid;

Line 655: App_Exception.Raise_Exception;

651: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
652: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRR_FK');
653: IGS_GE_MSG_STACK.ADD;
654: Close cur_rowid;
655: App_Exception.Raise_Exception;
656:
657: Return;
658: END IF;
659: Close cur_rowid;

Line 684: App_Exception.Raise_Exception;

680: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
681: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SCA_FK');
682: IGS_GE_MSG_STACK.ADD;
683: Close cur_rowid;
684: App_Exception.Raise_Exception;
685:
686: Return;
687: END IF;
688: Close cur_rowid;

Line 715: App_Exception.Raise_Exception;

711: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
712: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SPO_FK');
713: IGS_GE_MSG_STACK.ADD;
714: Close cur_rowid;
715: App_Exception.Raise_Exception;
716:
717: Return;
718: END IF;
719: Close cur_rowid;

Line 756: APP_EXCEPTION.RAISE_EXCEPTION;

752: IF c_parent%NOTFOUND THEN
753: CLOSE c_parent;
754: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
755: IGS_GE_MSG_STACK.ADD;
756: APP_EXCEPTION.RAISE_EXCEPTION;
757: END IF;
758: CLOSE c_parent;
759: ELSIF(p_action = 'UPDATE') THEN
760: IF NVL(new_references.pro_progression_rule_cat,'1') <> NVL(old_references.pro_progression_rule_cat,'1') OR

Line 769: APP_EXCEPTION.RAISE_EXCEPTION;

765: IF c_parent%NOTFOUND THEN
766: CLOSE c_parent;
767: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
768: IGS_GE_MSG_STACK.ADD;
769: APP_EXCEPTION.RAISE_EXCEPTION;
770: END IF;
771: CLOSE c_parent;
772: END IF;
773: END IF;

Line 871: App_Exception.Raise_Exception;

867: new_references.sequence_number
868: ) THEN
869: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
870: IGS_GE_MSG_STACK.ADD;
871: App_Exception.Raise_Exception;
872: END IF;
873: CHECK_CONSTRAINTS;
874:
875: ELSIF (p_action = 'UPDATE') THEN

Line 897: App_Exception.Raise_Exception;

893: new_references.sequence_number
894: ) THEN
895: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
896: IGS_GE_MSG_STACK.ADD;
897: App_Exception.Raise_Exception;
898: END IF;
899: CHECK_CONSTRAINTS;
900:
901: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 966: app_exception.raise_exception;

962: end if;
963: else
964: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
965: IGS_GE_MSG_STACK.ADD;
966: app_exception.raise_exception;
967: end if;
968:
969: Before_DML (
970: p_action => 'INSERT',

Line 1143: app_exception.raise_exception;

1139: if (c1%notfound) then
1140: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1141: IGS_GE_MSG_STACK.ADD;
1142: close c1;
1143: app_exception.raise_exception;
1144:
1145: return;
1146: end if;
1147: close c1;

Line 1221: app_exception.raise_exception;

1217: null;
1218: else
1219: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1220: IGS_GE_MSG_STACK.ADD;
1221: app_exception.raise_exception;
1222: end if;
1223: return;
1224: end LOCK_ROW;
1225:

Line 1275: app_exception.raise_exception;

1271: end if;
1272: else
1273: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1274: IGS_GE_MSG_STACK.ADD;
1275: app_exception.raise_exception;
1276: end if;
1277: Before_DML (
1278: p_action => 'UPDATE',
1279: x_rowid => x_rowid ,

Line 1526: App_Exception.Raise_Exception ;

1522: IF upper(Column_name) = 'ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
1523: IF new_references.ATTENDANCE_TYPE<> upper(new_references.ATTENDANCE_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:
1529: END IF ;
1530:

Line 1535: App_Exception.Raise_Exception ;

1531: IF upper(Column_name) = 'COURSE_TYPE' OR COLUMN_NAME IS NULL THEN
1532: IF new_references.COURSE_TYPE<> upper(new_references.COURSE_TYPE) then
1533: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1534: IGS_GE_MSG_STACK.ADD;
1535: App_Exception.Raise_Exception ;
1536: END IF;
1537:
1538: END IF ;
1539:

Line 1544: App_Exception.Raise_Exception ;

1540: IF upper(Column_name) = 'CRV_COURSE_CD' OR COLUMN_NAME IS NULL THEN
1541: IF new_references.CRV_COURSE_CD<> upper(new_references.CRV_COURSE_CD) then
1542: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1543: IGS_GE_MSG_STACK.ADD;
1544: App_Exception.Raise_Exception ;
1545: END IF;
1546:
1547: END IF ;
1548:

Line 1554: App_Exception.Raise_Exception ;

1550: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1551: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
1552: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1553: IGS_GE_MSG_STACK.ADD;
1554: App_Exception.Raise_Exception ;
1555: END IF;
1556:
1557: END IF ;
1558:

Line 1563: App_Exception.Raise_Exception ;

1559: IF upper(Column_name) = 'PROGRESSION_RULE_CD' OR COLUMN_NAME IS NULL THEN
1560: IF new_references.PROGRESSION_RULE_CD<> upper(new_references.PROGRESSION_RULE_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:
1566: END IF ;
1567:

Line 1572: App_Exception.Raise_Exception ;

1568: IF upper(Column_name) = 'REFERENCE_CD' OR COLUMN_NAME IS NULL THEN
1569: IF new_references.REFERENCE_CD<> upper(new_references.REFERENCE_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:
1575: END IF ;
1576:

Line 1581: App_Exception.Raise_Exception ;

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

Line 1590: App_Exception.Raise_Exception ;

1586: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
1587: IF new_references.SPO_COURSE_CD<> upper(new_references.SPO_COURSE_CD) 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:
1593: END IF ;
1594:

Line 1599: App_Exception.Raise_Exception ;

1595: IF upper(Column_name) = 'PRO_PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1596: IF new_references.PRO_PROGRESSION_RULE_CAT<> upper(new_references.PRO_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:
1602: END IF ;
1603:

Line 1608: App_Exception.Raise_Exception ;

1604: IF upper(Column_name) = 'S_RELATION_TYPE' OR COLUMN_NAME IS NULL THEN
1605: IF new_references.S_RELATION_TYPE<> upper(new_references.S_RELATION_TYPE) then
1606: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1607: IGS_GE_MSG_STACK.ADD;
1608: App_Exception.Raise_Exception ;
1609: END IF;
1610:
1611: IF new_references.S_RELATION_TYPE not in ('OU' , 'CTY' , 'CRV' , 'SCA' , 'PRR' , 'PRGC' , 'SPO' , 'PRO' ) then
1612: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1614: App_Exception.Raise_Exception ;

1610:
1611: IF new_references.S_RELATION_TYPE not in ('OU' , 'CTY' , 'CRV' , 'SCA' , 'PRR' , 'PRGC' , 'SPO' , 'PRO' ) then
1612: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1613: IGS_GE_MSG_STACK.ADD;
1614: App_Exception.Raise_Exception ;
1615: END IF;
1616:
1617: END IF ;
1618:

Line 1623: App_Exception.Raise_Exception ;

1619: IF upper(Column_name) = 'PRO_PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1620: IF new_references.PRO_PRA_SEQUENCE_NUMBER < 1 or new_references.PRO_PRA_SEQUENCE_NUMBER > 999999 then
1621: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1622: IGS_GE_MSG_STACK.ADD;
1623: App_Exception.Raise_Exception ;
1624: END IF;
1625:
1626: END IF ;
1627:

Line 1632: App_Exception.Raise_Exception ;

1628: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1629: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
1630: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1631: IGS_GE_MSG_STACK.ADD;
1632: App_Exception.Raise_Exception ;
1633: END IF;
1634:
1635: END IF ;
1636:

Line 1641: App_Exception.Raise_Exception ;

1637: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1638: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
1639: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1640: IGS_GE_MSG_STACK.ADD;
1641: App_Exception.Raise_Exception ;
1642: END IF;
1643:
1644: END IF ;
1645: