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

Line 54: app_exception.raise_exception;

50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:

Line 107: app_exception.raise_exception;

103: ) THEN
104: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
105: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_STATE_DUP_EXISTS');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;

Line 111: app_exception.raise_exception;

107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;

Line 115: app_exception.raise_exception;

111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117: END IF;
118:
119: END check_uniqueness;

Line 142: app_exception.raise_exception;

138: new_references.person_id
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:
145: END check_parent_existance;
146:

Line 249: app_exception.raise_exception;

245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_PE_PEIT_HZ_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
252: CLOSE cur_rowid;
253:

Line 308: APP_EXCEPTION.RAISE_EXCEPTION;

304:
305: IF new_references.END_DATE IS NOT NULL AND new_references.END_DATE < new_references.START_DATE THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
312: IGS_GE_MSG_STACK.ADD;

Line 313: APP_EXCEPTION.RAISE_EXCEPTION;

309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
312: IGS_GE_MSG_STACK.ADD;
313: APP_EXCEPTION.RAISE_EXCEPTION;
314: END IF;
315:
316:
317: OPEN validate_dt_overlap(new_references.person_id, new_references.pe_eit_id, new_references.information_type,

Line 343: APP_EXCEPTION.RAISE_EXCEPTION;

339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');
340: END IF;
341:
342: IGS_GE_MSG_STACK.ADD;
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: END IF;
345: CLOSE validate_dt_overlap;
346: END IF;
347:

Line 410: app_exception.raise_exception;

406: )
407: ) THEN
408: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_uniqueness;
413: check_parent_existance;
414: ELSIF (p_action = 'UPDATE') THEN

Line 427: app_exception.raise_exception;

423: )
424: ) THEN
425: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429: check_uniqueness;
430: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
431: check_uniqueness;

Line 487: app_exception.raise_exception;

483: END IF;
484: ELSE
485: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:
490: SELECT igs_pe_eit_s.NEXTVAL
491: INTO x_pe_eit_id

Line 571: app_exception.raise_exception;

567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
568: fnd_message.set_token ('ERR_CD', SQLCODE);
569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;
572: ELSE
573: igs_sc_gen_001.unset_ctx('R');
574: RAISE;
575: END IF;

Line 626: app_exception.raise_exception;

622: IF (c1%notfound) THEN
623: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
624: igs_ge_msg_stack.add;
625: CLOSE c1;
626: app_exception.raise_exception;
627: RETURN;
628: END IF;
629: CLOSE c1;
630:

Line 646: app_exception.raise_exception;

642: NULL;
643: ELSE
644: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
645: igs_ge_msg_stack.add;
646: app_exception.raise_exception;
647: END IF;
648:
649: RETURN;
650:

Line 699: app_exception.raise_exception;

695: END IF;
696: ELSE
697: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
698: igs_ge_msg_stack.add;
699: app_exception.raise_exception;
700: END IF;
701:
702: before_dml(
703: p_action => 'UPDATE',

Line 745: app_exception.raise_exception;

741: IF (SQL%NOTFOUND) THEN
742: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: END IF;
747: IF (x_mode = 'S') THEN
748: igs_sc_gen_001.unset_ctx('R');
749: END IF;

Line 760: app_exception.raise_exception;

756: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
757: fnd_message.set_token ('ERR_CD', SQLCODE);
758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;
761: ELSE
762: igs_sc_gen_001.unset_ctx('R');
763: RAISE;
764: END IF;

Line 869: app_exception.raise_exception;

865: IF (SQL%NOTFOUND) THEN
866: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
867: igs_ge_msg_stack.add;
868: igs_sc_gen_001.unset_ctx('R');
869: app_exception.raise_exception;
870: END IF;
871: IF (x_mode = 'S') THEN
872: igs_sc_gen_001.unset_ctx('R');
873: END IF;