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

Line 156: app_exception.raise_exception;

152: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
153: CLOSE cur_old_ref_values;
154: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: RETURN;
158: END IF;
159: CLOSE cur_old_ref_values;
160:

Line 363: app_exception.raise_exception;

359: new_references.system_code
360: ) THEN
361: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
362: igs_ge_msg_stack.add;
363: app_exception.raise_exception;
364: END IF;
365:
366: IF (((old_references.oss_person_id = new_references.oss_person_id)) OR
367: ((new_references.oss_person_id IS NULL))) THEN

Line 374: app_exception.raise_exception;

370: new_references.oss_person_id
371: ) THEN
372: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:
377: END check_parent_existance;
378:

Line 396: app_exception.raise_exception;

392: IF ( get_uk_for_validation(new_references.app_no)
393: ) THEN
394: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:
399:
400: END check_uniqueness;

Line 432: app_exception.raise_exception;

428: IF (cur_rowid%FOUND) THEN
429: CLOSE cur_rowid;
430: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_UAS_FK');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: RETURN;
434: END IF;
435: CLOSE cur_rowid;
436:

Line 466: app_exception.raise_exception;

462: IF (cur_rowid%FOUND) THEN
463: CLOSE cur_rowid;
464: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_PE_FK');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: RETURN;
468: END IF;
469: CLOSE cur_rowid;
470:

Line 801: app_exception.raise_exception;

797: )
798: ) THEN
799: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
800: igs_ge_msg_stack.add;
801: app_exception.raise_exception;
802: END IF;
803: check_parent_existance;
804: check_uniqueness;
805: ELSIF (p_action = 'UPDATE') THEN

Line 820: app_exception.raise_exception;

816: )
817: ) THEN
818: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
819: igs_ge_msg_stack.add;
820: app_exception.raise_exception;
821: END IF;
822: ELSIF (p_action = 'VALIDATE_DELETE') THEN
823: check_child_existance;
824: END IF;

Line 986: app_exception.raise_exception;

982: END IF;
983: ELSE
984: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
985: igs_ge_msg_stack.add;
986: app_exception.raise_exception;
987: END IF;
988:
989: SELECT igs_uc_applicants_s1.NEXTVAL
990: INTO x_app_id

Line 1364: app_exception.raise_exception;

1360: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1361: fnd_message.set_token ('ERR_CD', SQLCODE);
1362: igs_ge_msg_stack.add;
1363: igs_sc_gen_001.unset_ctx('R');
1364: app_exception.raise_exception;
1365: ELSE
1366: igs_sc_gen_001.unset_ctx('R');
1367: RAISE;
1368: END IF;

Line 1616: app_exception.raise_exception;

1612: IF (c1%notfound) THEN
1613: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1614: igs_ge_msg_stack.add;
1615: CLOSE c1;
1616: app_exception.raise_exception;
1617: RETURN;
1618: END IF;
1619: CLOSE c1;
1620:

Line 1733: app_exception.raise_exception;

1729: NULL;
1730: ELSE
1731: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1732: igs_ge_msg_stack.add;
1733: app_exception.raise_exception;
1734: END IF;
1735:
1736: RETURN;
1737:

Line 1887: app_exception.raise_exception;

1883: END IF;
1884: ELSE
1885: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1886: igs_ge_msg_stack.add;
1887: app_exception.raise_exception;
1888: END IF;
1889:
1890: before_dml(
1891: p_action => 'UPDATE',

Line 2127: app_exception.raise_exception;

2123: IF (SQL%NOTFOUND) THEN
2124: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2125: igs_ge_msg_stack.add;
2126: igs_sc_gen_001.unset_ctx('R');
2127: app_exception.raise_exception;
2128: END IF;
2129: IF (x_mode = 'S') THEN
2130: igs_sc_gen_001.unset_ctx('R');
2131: END IF;

Line 2144: app_exception.raise_exception;

2140: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
2141: fnd_message.set_token ('ERR_CD', SQLCODE);
2142: igs_ge_msg_stack.add;
2143: igs_sc_gen_001.unset_ctx('R');
2144: app_exception.raise_exception;
2145: ELSE
2146: igs_sc_gen_001.unset_ctx('R');
2147: RAISE;
2148: END IF;

Line 2550: app_exception.raise_exception;

2546: IF (SQL%NOTFOUND) THEN
2547: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2548: igs_ge_msg_stack.add;
2549: igs_sc_gen_001.unset_ctx('R');
2550: app_exception.raise_exception;
2551: END IF;
2552: IF (x_mode = 'S') THEN
2553: igs_sc_gen_001.unset_ctx('R');
2554: END IF;