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.IGF_AW_AWD_DISB_PKG dependencies on APP_EXCEPTION

Line 810: app_exception.raise_exception;

806: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
807: CLOSE cur_old_ref_values;
808: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
809: igs_ge_msg_stack.add;
810: app_exception.raise_exception;
811: RETURN;
812: END IF;
813: CLOSE cur_old_ref_values;
814:

Line 952: app_exception.raise_exception;

948: END IF;
949: IF l_v_message_name IS NOT NULL THEN
950: fnd_message.set_name ('IGS',l_v_message_name);
951: igs_ge_msg_stack.add;
952: app_exception.raise_exception;
953: END IF;
954: IF g_v_called_from NOT IN ('IGFSL27B','IGFAW038') THEN
955: RETURN;
956: END IF;

Line 1077: app_exception.raise_exception;

1073: END IF;
1074: IF l_v_message_name IS NOT NULL THEN
1075: fnd_message.set_name ('IGS',l_v_message_name);
1076: igs_ge_msg_stack.add;
1077: app_exception.raise_exception;
1078: END IF;
1079: IF g_v_called_from NOT IN ('IGFSL27B','IGFAW038','IGFAW016') THEN
1080: RETURN;
1081: END IF;

Line 1119: app_exception.raise_exception;

1115: igs_ge_msg_stack.add;
1116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1117: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_disb_chg_rec returned error '|| l_v_message_name);
1118: END IF;
1119: app_exception.raise_exception;
1120: END IF;
1121: END IF;
1122: l_n_award_id := new_references.award_id;
1123: -- get the processing type code, loan record status, loan status and loan number for the input award id

Line 1370: app_exception.raise_exception;

1366: igs_ge_msg_stack.add;
1367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||l_n_clchgsnd_id);
1369: END IF;
1370: app_exception.raise_exception;
1371: END IF;
1372: END IF;
1373: END IF;
1374: END AfterRowInsertUpdateDelete1;

Line 1423: app_exception.raise_exception;

1419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.trans_type || ' for TRANS_TYPE is invalid ');
1420: END IF;
1421: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1422: igs_ge_msg_stack.add;
1423: app_exception.raise_exception;
1424: END IF;
1425: END IF;
1426:
1427: IF (UPPER(column_name) = 'ELIG_STATUS' OR column_name IS NULL) THEN

Line 1436: app_exception.raise_exception;

1432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.elig_status || ' for ELIG_STAUS is invalid');
1433: END IF;
1434: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1435: igs_ge_msg_stack.add;
1436: app_exception.raise_exception;
1437: END IF;
1438: END IF;
1439: END IF;
1440:

Line 1449: app_exception.raise_exception;

1445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.affirm_flag || ' for AFFIRM_FLAG is invalid ');
1446: END IF;
1447: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1448: igs_ge_msg_stack.add;
1449: app_exception.raise_exception;
1450: END IF;
1451: END IF;
1452: END IF;
1453:

Line 1465: app_exception.raise_exception;

1461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.hold_rel_ind || ' for HOLD_REL_IND is invalid ');
1462: END IF;
1463: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1464: igs_ge_msg_stack.add;
1465: app_exception.raise_exception;
1466: END IF;
1467: END IF;
1468: END IF;
1469:

Line 1478: app_exception.raise_exception;

1474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.fund_dist_mthd || ' for FUND_DIST_MTHD is invalid ');
1475: END IF;
1476: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1477: igs_ge_msg_stack.add;
1478: app_exception.raise_exception;
1479: END IF;
1480: END IF;
1481: END IF;
1482:

Line 1491: app_exception.raise_exception;

1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.prev_reported_ind || ' for PREV_REPORTED_IND is invalid ');
1488: END IF;
1489: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1490: igs_ge_msg_stack.add;
1491: app_exception.raise_exception;
1492: END IF;
1493: END IF;
1494: END IF;
1495:

Line 1504: app_exception.raise_exception;

1500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.fund_status || ' for FUND_STATUS is invalid ');
1501: END IF;
1502: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1503: igs_ge_msg_stack.add;
1504: app_exception.raise_exception;
1505: END IF;
1506: END IF;
1507: END IF;
1508:

Line 1520: app_exception.raise_exception;

1516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.manual_hold_ind || ' for MANUAL_HOLD_IND is invalid ');
1517: END IF;
1518: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1519: igs_ge_msg_stack.add;
1520: app_exception.raise_exception;
1521: END IF;
1522: END IF;
1523:
1524: IF (UPPER(column_name) = 'LATE_DISB_IND' OR column_name IS NULL) THEN

Line 1531: app_exception.raise_exception;

1527: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.late_disb_ind || ' for LATE_DISB_IND is invalid ');
1528: END IF;
1529: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1530: igs_ge_msg_stack.add;
1531: app_exception.raise_exception;
1532: END IF;
1533: END IF;
1534:
1535: IF (UPPER(column_name) = 'DIRECT_TO_BORR_FLAG' OR column_name IS NULL) THEN

Line 1542: app_exception.raise_exception;

1538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.direct_to_borr_flag || ' for DIRECT_TO_BORR_FLAG is invalid ');
1539: END IF;
1540: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1541: igs_ge_msg_stack.add;
1542: app_exception.raise_exception;
1543: END IF;
1544: END IF;
1545:
1546: END check_constraints;

Line 1569: app_exception.raise_exception;

1565: new_references.award_id
1566: ) THEN
1567: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1568: igs_ge_msg_stack.add;
1569: app_exception.raise_exception;
1570: END IF;
1571:
1572: IF (((old_references.rvsn_id = new_references.rvsn_id)) OR
1573: ((new_references.rvsn_id IS NULL))) THEN

Line 1580: app_exception.raise_exception;

1576: new_references.rvsn_id
1577: ) THEN
1578: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1579: igs_ge_msg_stack.add;
1580: app_exception.raise_exception;
1581: END IF;
1582:
1583: IF (((old_references.tp_cal_type = new_references.tp_cal_type) AND
1584: (old_references.tp_sequence_number = new_references.tp_sequence_number)) OR

Line 1594: app_exception.raise_exception;

1590: new_references.tp_sequence_number
1591: ) THEN
1592: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1593: igs_ge_msg_stack.add;
1594: app_exception.raise_exception;
1595: END IF;
1596:
1597: IF (((old_references.ld_cal_type = new_references.ld_cal_type) AND
1598: (old_references.ld_sequence_number = new_references.ld_sequence_number)) OR

Line 1608: app_exception.raise_exception;

1604: new_references.ld_sequence_number
1605: ) THEN
1606: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1607: igs_ge_msg_stack.add;
1608: app_exception.raise_exception;
1609: END IF;
1610:
1611:
1612: END check_parent_existance;

Line 1714: app_exception.raise_exception;

1710: IF (cur_rowid%FOUND) THEN
1711: CLOSE cur_rowid;
1712: fnd_message.set_name ('IGF', 'IGF_AW_ADISB_AWD_FK');
1713: igs_ge_msg_stack.add;
1714: app_exception.raise_exception;
1715: RETURN;
1716: END IF;
1717: CLOSE cur_rowid;
1718:

Line 1748: app_exception.raise_exception;

1744: IF (cur_rowid%FOUND) THEN
1745: CLOSE cur_rowid;
1746: fnd_message.set_name ('IGF', 'IGF_AW_ADISB_RVSN_FK');
1747: igs_ge_msg_stack.add;
1748: app_exception.raise_exception;
1749: RETURN;
1750: END IF;
1751: CLOSE cur_rowid;
1752:

Line 1787: app_exception.raise_exception;

1783: IF (cur_rowid%FOUND) THEN
1784: CLOSE cur_rowid;
1785: fnd_message.set_name ('IGF', 'IGF_AW_ADISB_CI_FK');
1786: igs_ge_msg_stack.add;
1787: app_exception.raise_exception;
1788: RETURN;
1789: END IF;
1790: CLOSE cur_rowid;
1791:

Line 1821: app_exception.raise_exception;

1817: IF (cur_rowid%FOUND) THEN
1818: CLOSE cur_rowid;
1819: fnd_message.set_name ('IGF', 'IGF_AW_ADISB_LKUP_FK');
1820: igs_ge_msg_stack.add;
1821: app_exception.raise_exception;
1822: RETURN;
1823: END IF;
1824: CLOSE cur_rowid;
1825:

Line 1963: app_exception.raise_exception;

1959: )
1960: ) THEN
1961: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1962: igs_ge_msg_stack.add;
1963: app_exception.raise_exception;
1964: END IF;
1965: check_constraints;
1966: check_parent_existance;
1967:

Line 1981: app_exception.raise_exception;

1977: )
1978: ) THEN
1979: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1980: igs_ge_msg_stack.add;
1981: app_exception.raise_exception;
1982: END IF;
1983: check_constraints;
1984: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1985: check_constraints;

Line 2107: app_exception.raise_exception;

2103: END IF;
2104: ELSE
2105: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
2106: igs_ge_msg_stack.add;
2107: app_exception.raise_exception;
2108: END IF;
2109:
2110: before_dml(
2111: p_action => 'INSERT',

Line 2433: app_exception.raise_exception;

2429: IF (c1%notfound) THEN
2430: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2431: igs_ge_msg_stack.add;
2432: CLOSE c1;
2433: app_exception.raise_exception;
2434: RETURN;
2435: END IF;
2436: CLOSE c1;
2437:

Line 2486: app_exception.raise_exception;

2482: NULL;
2483: ELSE
2484: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2485: igs_ge_msg_stack.add;
2486: app_exception.raise_exception;
2487: END IF;
2488:
2489: RETURN;
2490:

Line 2583: app_exception.raise_exception;

2579: END IF;
2580: ELSE
2581: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2582: igs_ge_msg_stack.add;
2583: app_exception.raise_exception;
2584: END IF;
2585:
2586: before_dml(
2587: p_action => 'UPDATE',