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

Line 49: app_exception.raise_exception;

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

Line 96: APP_EXCEPTION.RAISE_EXCEPTION;

92: IF ((l_birth_date IS NOT NULL) AND (l_birth_date > new_references.date_received)) THEN
93: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DOB_ERROR');
94: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS', 'IGS_AD_DT_RECV'));
95: IGS_GE_MSG_STACK.ADD;
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: END IF;
98:
99: IF (new_references.date_received > SYSDATE) THEN
100: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');

Line 103: APP_EXCEPTION.RAISE_EXCEPTION;

99: IF (new_references.date_received > SYSDATE) THEN
100: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
101: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS', 'IGS_AD_DT_RECV'));
102: IGS_GE_MSG_STACK.ADD;
103: APP_EXCEPTION.RAISE_EXCEPTION;
104: END IF;
105: END BeforeRowInsertUpdate;
106:
107: PROCEDURE check_parent_existance AS

Line 129: App_Exception.Raise_Exception;

125: ) THEN
126: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CHILD_PER_STAT'));
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131:
132: END check_parent_existance;
133:

Line 200: app_exception.raise_exception;

196: IF (cur_rowid%FOUND) THEN
197: CLOSE cur_rowid;
198: fnd_message.set_name ('IGS', 'IGS_AD_APS_ST_FK');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: RETURN;
202: END IF;
203: CLOSE cur_rowid;
204:

Line 266: app_exception.raise_exception;

262: new_references.admission_appl_number )
263: ) THEN
264: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_parent_existance;
269: ELSIF (p_action = 'UPDATE') THEN
270: -- Call all the procedures related to Before Update.

Line 282: app_exception.raise_exception;

278: )
279: ) THEN
280: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: END IF;
285:
286: END before_dml;

Line 351: app_exception.raise_exception;

347: END IF;
348: ELSE
349: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353:
354: x_appl_perstat_id := -1;
355: before_dml(

Line 432: app_exception.raise_exception;

428: -- that the ownerof policy function does not have privilege to access.
429: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
430: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: ELSE
434: RAISE;
435: END IF;
436: END insert_row;

Line 477: app_exception.raise_exception;

473: IF (c1%notfound) THEN
474: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
475: igs_ge_msg_stack.add;
476: CLOSE c1;
477: app_exception.raise_exception;
478: RETURN;
479: END IF;
480: CLOSE c1;
481:

Line 493: app_exception.raise_exception;

489: NULL;
490: ELSE
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495:
496: RETURN;
497:

Line 546: app_exception.raise_exception;

542: END IF;
543: ELSE
544: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
545: igs_ge_msg_stack.add;
546: app_exception.raise_exception;
547: END IF;
548:
549: before_dml(
550: p_action => 'UPDATE',

Line 603: app_exception.raise_exception;

599: igs_ge_msg_stack.add;
600: IF (x_mode = 'S') THEN
601: igs_sc_gen_001.unset_ctx('R');
602: END IF;
603: app_exception.raise_exception;
604: END IF;
605: IF (x_mode = 'S') THEN
606: igs_sc_gen_001.unset_ctx('R');
607: END IF;

Line 624: app_exception.raise_exception;

620: -- that the ownerof policy function does not have privilege to access.
621: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
622: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
623: IGS_GE_MSG_STACK.ADD;
624: app_exception.raise_exception;
625: ELSE
626: RAISE;
627: END IF;
628: END update_row;

Line 720: app_exception.raise_exception;

716: igs_ge_msg_stack.add;
717: IF (x_mode = 'S') THEN
718: igs_sc_gen_001.set_ctx('R');
719: END IF;
720: app_exception.raise_exception;
721: END IF;
722: IF (x_mode = 'S') THEN
723: igs_sc_gen_001.unset_ctx('R');
724: END IF;

Line 741: app_exception.raise_exception;

737: -- that the ownerof policy function does not have privilege to access.
738: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
739: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
740: IGS_GE_MSG_STACK.ADD;
741: app_exception.raise_exception;
742: ELSE
743: RAISE;
744: END IF;
745: END delete_row;