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

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

72: OPEN cur_old_ref_values;
73: FETCH cur_old_ref_values INTO old_references;
74: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
75: CLOSE cur_old_ref_values;
76: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
77: igs_ge_msg_stack.add;
78: app_exception.raise_exception;
79: RETURN;
80: END IF;

Line 175: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');

171: OPEN get_pass_exp_dt(new_references.passport_id);
172: FETCH get_pass_exp_dt INTO l_exp_date;
173: CLOSE get_pass_exp_dt;
174: IF new_references.visa_issue_date > l_exp_date THEN
175: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
176: fnd_message.set_token('PASSPORT_DATE',to_char(l_exp_date,'DD-MON-YYYY'));
177: fnd_message.set_token('VISA_DATE',to_char(new_references.visa_issue_date,'DD-MON-YYYY'));
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;

Line 176: fnd_message.set_token('PASSPORT_DATE',to_char(l_exp_date,'DD-MON-YYYY'));

172: FETCH get_pass_exp_dt INTO l_exp_date;
173: CLOSE get_pass_exp_dt;
174: IF new_references.visa_issue_date > l_exp_date THEN
175: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
176: fnd_message.set_token('PASSPORT_DATE',to_char(l_exp_date,'DD-MON-YYYY'));
177: fnd_message.set_token('VISA_DATE',to_char(new_references.visa_issue_date,'DD-MON-YYYY'));
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;

Line 177: fnd_message.set_token('VISA_DATE',to_char(new_references.visa_issue_date,'DD-MON-YYYY'));

173: CLOSE get_pass_exp_dt;
174: IF new_references.visa_issue_date > l_exp_date THEN
175: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
176: fnd_message.set_token('PASSPORT_DATE',to_char(l_exp_date,'DD-MON-YYYY'));
177: fnd_message.set_token('VISA_DATE',to_char(new_references.visa_issue_date,'DD-MON-YYYY'));
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: END IF;

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

181: END IF;
182:
183:
184: IF new_references.visa_issue_date > new_references.visa_expiry_date THEN
185: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_FROM_DT_GRT_TO_DATE');
186: IGS_GE_MSG_STACK.ADD;
187: APP_EXCEPTION.RAISE_EXCEPTION;
188: END IF;
189:

Line 196: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_INT_DT_LT_BRDT');

192: CLOSE get_dob_dt_cur;
193:
194: IF l_birth_dt IS NOT NULL AND new_references.visa_issue_date IS NOT NULL THEN
195: IF l_birth_dt > new_references.visa_issue_date THEN
196: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_INT_DT_LT_BRDT');
197: IGS_GE_MSG_STACK.ADD;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: END IF;
200: END IF;

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

207: OPEN overlap_poe_cur(new_references.visa_id, new_references.visa_issue_date, new_references.visa_expiry_date);
208: FETCH overlap_poe_cur INTO l_count;
209: IF overlap_poe_cur%FOUND THEN
210: CLOSE overlap_poe_cur;
211: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
212: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', NULL);
213: FND_MESSAGE.SET_TOKEN('VISA_EXP', NULL);
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;

Line 212: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', NULL);

208: FETCH overlap_poe_cur INTO l_count;
209: IF overlap_poe_cur%FOUND THEN
210: CLOSE overlap_poe_cur;
211: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
212: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', NULL);
213: FND_MESSAGE.SET_TOKEN('VISA_EXP', NULL);
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;

Line 213: FND_MESSAGE.SET_TOKEN('VISA_EXP', NULL);

209: IF overlap_poe_cur%FOUND THEN
210: CLOSE overlap_poe_cur;
211: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
212: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', NULL);
213: FND_MESSAGE.SET_TOKEN('VISA_EXP', NULL);
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;
217: CLOSE overlap_poe_cur;

Line 241: fnd_message.set_name ('IGS', 'IGS_PE_VISA_DUP_EXISTS');

237: new_references.visa_type,
238: new_references.visa_issue_date
239: )
240: ) THEN
241: fnd_message.set_name ('IGS', 'IGS_PE_VISA_DUP_EXISTS');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245:

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

263: NULL;
264: ELSIF NOT igs_pe_passport_pkg.get_pk_for_validation (
265: new_references.passport_id
266: ) THEN
267: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
268: igs_ge_msg_stack.add;
269: app_exception.raise_exception;
270: END IF;
271:

Line 278: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

274: NULL;
275: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
276: new_references.person_id
277: ) THEN
278: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282:

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

400: OPEN cur_rowid;
401: FETCH cur_rowid INTO lv_rowid;
402: IF (cur_rowid%FOUND) THEN
403: CLOSE cur_rowid;
404: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
405: igs_ge_msg_stack.add;
406: app_exception.raise_exception;
407: RETURN;
408: END IF;

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

516: IF ( get_pk_for_validation(
517: new_references.visa_id
518: )
519: ) THEN
520: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524: check_uniqueness;

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

536: IF ( get_pk_for_validation (
537: new_references.visa_id
538: )
539: ) THEN
540: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544: check_uniqueness;

Line 585: FND_MESSAGE.SET_NAME('IGS','IGS_PE_VISA_DATE_OVERLAP');

581: FETCH c_visa_overlap INTO l_count;
582: CLOSE c_visa_overlap;
583:
584: IF l_count > 0 THEN
585: FND_MESSAGE.SET_NAME('IGS','IGS_PE_VISA_DATE_OVERLAP');
586: IGS_GE_MSG_STACK.ADD;
587: APP_EXCEPTION.RAISE_EXCEPTION;
588: END IF;
589:

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

693: IF (x_last_update_login IS NULL) THEN
694: x_last_update_login := -1;
695: END IF;
696: ELSE
697: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
698: igs_ge_msg_stack.add;
699: app_exception.raise_exception;
700: END IF;
701:

Line 845: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

841:
842: EXCEPTION
843: WHEN OTHERS THEN
844: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
845: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
846: fnd_message.set_token ('ERR_CD', SQLCODE);
847: igs_ge_msg_stack.add;
848: igs_sc_gen_001.unset_ctx('R');
849: app_exception.raise_exception;

Line 846: fnd_message.set_token ('ERR_CD', SQLCODE);

842: EXCEPTION
843: WHEN OTHERS THEN
844: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
845: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
846: fnd_message.set_token ('ERR_CD', SQLCODE);
847: igs_ge_msg_stack.add;
848: igs_sc_gen_001.unset_ctx('R');
849: app_exception.raise_exception;
850: ELSE

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

945:
946: OPEN c1;
947: FETCH c1 INTO tlinfo;
948: IF (c1%notfound) THEN
949: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
950: igs_ge_msg_stack.add;
951: CLOSE c1;
952: app_exception.raise_exception;
953: RETURN;

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

990: AND ((tlinfo.visa_issuing_country = x_visa_issuing_country) OR ((tlinfo.visa_issuing_country IS NULL) AND (x_visa_issuing_country IS NULL)))
991: ) THEN
992: NULL;
993: ELSE
994: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
995: igs_ge_msg_stack.add;
996: app_exception.raise_exception;
997: END IF;
998:

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

1067: IF (x_last_update_login IS NULL) THEN
1068: x_last_update_login := -1;
1069: END IF;
1070: ELSE
1071: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1072: igs_ge_msg_stack.add;
1073: app_exception.raise_exception;
1074: END IF;
1075:

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

1160: last_update_login = x_last_update_login
1161: WHERE rowid = x_rowid;
1162:
1163: IF (SQL%NOTFOUND) THEN
1164: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1165: igs_ge_msg_stack.add;
1166: igs_sc_gen_001.unset_ctx('R');
1167: app_exception.raise_exception;
1168: END IF;

Line 1183: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF (SQLCODE = (-28115)) THEN
1183: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1184: fnd_message.set_token ('ERR_CD', SQLCODE);
1185: igs_ge_msg_stack.add;
1186: igs_sc_gen_001.unset_ctx('R');
1187: app_exception.raise_exception;

Line 1184: fnd_message.set_token ('ERR_CD', SQLCODE);

1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF (SQLCODE = (-28115)) THEN
1183: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1184: fnd_message.set_token ('ERR_CD', SQLCODE);
1185: igs_ge_msg_stack.add;
1186: igs_sc_gen_001.unset_ctx('R');
1187: app_exception.raise_exception;
1188: ELSE

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

1361: DELETE FROM igs_pe_visa
1362: WHERE rowid = x_rowid;
1363:
1364: IF (SQL%NOTFOUND) THEN
1365: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1366: igs_ge_msg_stack.add;
1367: igs_sc_gen_001.unset_ctx('R');
1368: app_exception.raise_exception;
1369: END IF;