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_VISIT_HISTRY_PKG dependencies on FND_MESSAGE

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

65: OPEN cur_old_ref_values;
66: FETCH cur_old_ref_values INTO old_references;
67: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
68: CLOSE cur_old_ref_values;
69: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
70: igs_ge_msg_stack.add;
71: app_exception.raise_exception;
72: RETURN;
73: END IF;

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

134: NULL;
135: ELSIF NOT igs_pe_visa_pkg.get_pk_for_validation (
136: new_references.visa_id
137: ) THEN
138: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
139: igs_ge_msg_stack.add;
140: app_exception.raise_exception;
141: END IF;
142:

Line 171: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');

167:
168: IF (new_references.visit_start_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date) OR
169: (new_references.visit_end_date IS NOT NULL AND
170: new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
171: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
172: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
173: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
174: IGS_GE_MSG_STACK.ADD;
175: APP_EXCEPTION.RAISE_EXCEPTION;

Line 172: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);

168: IF (new_references.visit_start_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date) OR
169: (new_references.visit_end_date IS NOT NULL AND
170: new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
171: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
172: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
173: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
174: IGS_GE_MSG_STACK.ADD;
175: APP_EXCEPTION.RAISE_EXCEPTION;
176: END IF;

Line 173: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);

169: (new_references.visit_end_date IS NOT NULL AND
170: new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
171: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
172: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
173: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
174: IGS_GE_MSG_STACK.ADD;
175: APP_EXCEPTION.RAISE_EXCEPTION;
176: END IF;
177: END IF;

Line 190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');

186: CLOSE visa_dtl_cur;
187:
188: IF (new_references.visit_start_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date) OR
189: (new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
191: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
192: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
193: IGS_GE_MSG_STACK.ADD;
194: APP_EXCEPTION.RAISE_EXCEPTION;

Line 191: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);

187:
188: IF (new_references.visit_start_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date) OR
189: (new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
191: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
192: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
193: IGS_GE_MSG_STACK.ADD;
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END IF;

Line 192: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);

188: IF (new_references.visit_start_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date) OR
189: (new_references.visit_end_date NOT BETWEEN visa_dtl_rec.visa_issue_date AND visa_dtl_rec.visa_expiry_date+30) THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
191: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
192: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
193: IGS_GE_MSG_STACK.ADD;
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END IF;
196: END IF;

Line 201: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_FROM_DT_GRT_TO_DATE');

197: END IF;
198:
199: IF p_inserting OR p_updating THEN
200: IF new_references.visit_start_date > new_references.visit_end_date THEN
201: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_FROM_DT_GRT_TO_DATE');
202: IGS_GE_MSG_STACK.ADD;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204: END IF;
205: END IF;

Line 271: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

267: OPEN cur_rowid;
268: FETCH cur_rowid INTO lv_rowid;
269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;

Line 374: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');

370: new_references.port_of_entry,
371: new_references.cntry_entry_form_num
372: )
373: ) THEN
374: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378: check_parent_existance;

Line 390: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');

386: new_references.port_of_entry,
387: new_references.cntry_entry_form_num
388: )
389: ) THEN
390: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394: END IF;

Line 442: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PORT_DATE_OVERLAP');

438: FETCH c_visit_hist_overlap INTO l_count;
439: CLOSE c_visit_hist_overlap;
440:
441: IF l_count > 0 THEN
442: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PORT_DATE_OVERLAP');
443: IGS_GE_MSG_STACK.ADD;
444: APP_EXCEPTION.RAISE_EXCEPTION;
445: END IF;
446:

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

543: IF (x_last_update_login IS NULL) THEN
544: x_last_update_login := -1;
545: END IF;
546: ELSE
547: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
548: igs_ge_msg_stack.add;
549: app_exception.raise_exception;
550: END IF;
551:

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

738:
739: OPEN c1;
740: FETCH c1 INTO tlinfo;
741: IF (c1%notfound) THEN
742: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
743: igs_ge_msg_stack.add;
744: CLOSE c1;
745: app_exception.raise_exception;
746: RETURN;

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

775: AND ((tlinfo.attribute20 = x_attribute20) OR ((tlinfo.attribute20 IS NULL) AND (X_attribute20 IS NULL)))
776: ) THEN
777: NULL;
778: ELSE
779: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception;
782: END IF;
783:

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

855: IF (x_last_update_login IS NULL) THEN
856: x_last_update_login := -1;
857: END IF;
858: ELSE
859: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
860: igs_ge_msg_stack.add;
861: app_exception.raise_exception;
862: END IF;
863:

Line 905: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');

901: OPEN cur_rowid;
902: FETCH cur_rowid INTO lv_rowid;
903: IF cur_rowid%FOUND THEN
904: CLOSE cur_rowid;
905: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
906: igs_ge_msg_stack.add;
907: app_exception.raise_exception;
908: END IF;
909: