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

Line 52: app_exception.raise_exception;

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

Line 111: APP_EXCEPTION.RAISE_EXCEPTION;

107: CLOSE validate_cr_dt;
108: IF l_birth_dt IS NOT NULL AND l_birth_dt > new_references.start_date THEN
109: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113:
114: IF new_references.start_date IS NULL AND new_references.end_date IS NOT NULL THEN
115: FND_MESSAGE.SET_NAME('IGS','IGS_PE_CANT_SPECIFY_FROM_DATE');

Line 117: APP_EXCEPTION.RAISE_EXCEPTION;

113:
114: IF new_references.start_date IS NULL AND new_references.end_date IS NOT NULL THEN
115: FND_MESSAGE.SET_NAME('IGS','IGS_PE_CANT_SPECIFY_FROM_DATE');
116: IGS_GE_MSG_STACK.ADD;
117: APP_EXCEPTION.RAISE_EXCEPTION;
118: END IF;
119:
120: END IF;
121:

Line 146: app_exception.raise_exception;

142: new_references.person_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: END check_parent_existance;
150:

Line 214: app_exception.raise_exception;

210: IF (cur_rowid%FOUND) THEN
211: CLOSE cur_rowid;
212: fnd_message.set_name ('IGS', 'IGS_PE_PHD_HZ_FK');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: RETURN;
216: END IF;
217: CLOSE cur_rowid;
218:

Line 279: app_exception.raise_exception;

275: )
276: ) THEN
277: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_parent_existance;
282: ELSIF (p_action = 'UPDATE') THEN
283: -- Call all the procedures related to Before Update.

Line 297: app_exception.raise_exception;

293: )
294: ) THEN
295: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299: END IF;
300:
301: END before_dml;

Line 352: app_exception.raise_exception;

348: END IF;
349: ELSE
350: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
355: SELECT igs_pe_hearing_dtls_s.NEXTVAL
356: INTO x_hearing_details_id

Line 430: app_exception.raise_exception;

426: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
427: fnd_message.set_token ('ERR_CD', SQLCODE);
428: igs_ge_msg_stack.add;
429: igs_sc_gen_001.unset_ctx('R');
430: app_exception.raise_exception;
431: ELSE
432: igs_sc_gen_001.unset_ctx('R');
433: RAISE;
434: END IF;

Line 481: app_exception.raise_exception;

477: IF (c1%notfound) THEN
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: igs_ge_msg_stack.add;
480: CLOSE c1;
481: app_exception.raise_exception;
482: RETURN;
483: END IF;
484: CLOSE c1;
485:

Line 499: app_exception.raise_exception;

495: NULL;
496: ELSE
497: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
498: igs_ge_msg_stack.add;
499: app_exception.raise_exception;
500: END IF;
501:
502: RETURN;
503:

Line 550: app_exception.raise_exception;

546: END IF;
547: ELSE
548: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
549: igs_ge_msg_stack.add;
550: app_exception.raise_exception;
551: END IF;
552:
553: before_dml(
554: p_action => 'UPDATE',

Line 592: app_exception.raise_exception;

588: IF (SQL%NOTFOUND) THEN
589: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
590: igs_ge_msg_stack.add;
591: igs_sc_gen_001.unset_ctx('R');
592: app_exception.raise_exception;
593: END IF;
594: IF (x_mode = 'S') THEN
595: igs_sc_gen_001.unset_ctx('R');
596: END IF;

Line 607: app_exception.raise_exception;

603: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
604: fnd_message.set_token ('ERR_CD', SQLCODE);
605: igs_ge_msg_stack.add;
606: igs_sc_gen_001.unset_ctx('R');
607: app_exception.raise_exception;
608: ELSE
609: igs_sc_gen_001.unset_ctx('R');
610: RAISE;
611: END IF;

Line 710: app_exception.raise_exception;

706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
708: igs_ge_msg_stack.add;
709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;
712: IF (x_mode = 'S') THEN
713: igs_sc_gen_001.unset_ctx('R');
714: END IF;