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 IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 95: IGS_GE_MSG_STACK.ADD;

91:
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

Line 102: IGS_GE_MSG_STACK.ADD;

98:
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:

Line 128: IGS_GE_MSG_STACK.ADD;

124: 'N'
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;

Line 199: igs_ge_msg_stack.add;

195: FETCH cur_rowid INTO lv_rowid;
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;

Line 265: igs_ge_msg_stack.add;

261: new_references.person_id,
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

Line 281: igs_ge_msg_stack.add;

277: new_references.admission_appl_number
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:

Line 350: igs_ge_msg_stack.add;

346: x_program_update_date := SYSDATE;
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;

Line 431: IGS_GE_MSG_STACK.ADD;

427: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 475: igs_ge_msg_stack.add;

471: OPEN c1;
472: FETCH c1 INTO tlinfo;
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;

Line 492: igs_ge_msg_stack.add;

488: ) THEN
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;

Line 545: igs_ge_msg_stack.add;

541: x_last_update_login := -1;
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(

Line 599: igs_ge_msg_stack.add;

595: WHERE rowid = x_rowid;
596:
597: IF (SQL%NOTFOUND) THEN
598: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 623: IGS_GE_MSG_STACK.ADD;

619: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 716: igs_ge_msg_stack.add;

712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 740: IGS_GE_MSG_STACK.ADD;

736: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;