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 FND_MESSAGE

Line 47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

43: OPEN cur_old_ref_values;
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;

Line 93: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DOB_ERROR');

89: FETCH c_birth_date INTO l_birth_date;
90: CLOSE c_birth_date;
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;

Line 94: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS', 'IGS_AD_DT_RECV'));

90: CLOSE c_birth_date;
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:

Line 100: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');

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');
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;

Line 101: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS', 'IGS_AD_DT_RECV'));

97: END IF;
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;

Line 126: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

122: ELSIF NOT igs_ad_per_stm_typ_pkg.get_pk_for_validation (
123: new_references.persl_stat_type ,
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;

Line 127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CHILD_PER_STAT'));

123: new_references.persl_stat_type ,
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:

Line 198: fnd_message.set_name ('IGS', 'IGS_AD_APS_ST_FK');

194: OPEN cur_rowid;
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;

Line 264: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

260: IF ( get_pk_for_validation( new_references.appl_perstat_id,
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;

Line 280: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

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

Line 349: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

345: ELSE
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:

Line 429: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

425: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
426: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 430: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

426: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;

Line 474: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

470:
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;

Line 491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

487: AND (TRUNC(tlinfo.date_received) = TRUNC(x_date_received) )
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:

Line 544: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

540: IF (x_last_update_login IS NULL) THEN
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:

Line 598: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

594: program_update_date = x_program_update_date
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;

Line 621: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

617: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
618: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 622: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

618: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;

Line 715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

711: DELETE FROM igs_ad_appl_perstat
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;

Line 738: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

734: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
735: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 739: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

735: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;