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

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

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

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

139: OPEN get_count_exp_dt(new_references.passport_id,new_references.passport_expiry_date);
140: FETCH get_count_exp_dt INTO l_date;
141: IF get_count_exp_dt%FOUND THEN
142: CLOSE get_count_exp_dt;
143: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
144: fnd_message.set_token('PASSPORT_DATE',new_references.passport_expiry_date);
145: fnd_message.set_token('VISA_DATE',l_date);
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;

Line 144: fnd_message.set_token('PASSPORT_DATE',new_references.passport_expiry_date);

140: FETCH get_count_exp_dt INTO l_date;
141: IF get_count_exp_dt%FOUND THEN
142: CLOSE get_count_exp_dt;
143: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
144: fnd_message.set_token('PASSPORT_DATE',new_references.passport_expiry_date);
145: fnd_message.set_token('VISA_DATE',l_date);
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;
148: END IF;

Line 145: fnd_message.set_token('VISA_DATE',l_date);

141: IF get_count_exp_dt%FOUND THEN
142: CLOSE get_count_exp_dt;
143: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
144: fnd_message.set_token('PASSPORT_DATE',new_references.passport_expiry_date);
145: fnd_message.set_token('VISA_DATE',l_date);
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;
148: END IF;
149: CLOSE get_count_exp_dt;

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

173: CLOSE get_dob_dt_cur;
174:
175: IF l_birth_dt IS NOT NULL AND new_references.passport_expiry_date IS NOT NULL THEN
176: IF l_birth_dt > new_references.passport_expiry_date THEN
177: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_INT_DT_LT_BRDT');
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: END IF;
181: END IF;

Line 203: fnd_message.set_name ('IGS', 'IGS_PE_PASSPORT_DUP_EXISTS');

199: new_references.passport_cntry_code,
200: new_references.passport_number
201: )
202: ) THEN
203: fnd_message.set_name ('IGS', 'IGS_PE_PASSPORT_DUP_EXISTS');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:

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

244: NULL;
245: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
246: new_references.person_id
247: ) THEN
248: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252:

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

416: IF ( get_pk_for_validation(
417: new_references.passport_id
418: )
419: ) THEN
420: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: END IF;
424: beforerowinsertupdate(TRUE, FALSE);

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

438: IF ( get_pk_for_validation (
439: new_references.passport_id
440: )
441: ) THEN
442: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446: check_uniqueness;

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

512: IF (x_last_update_login IS NULL) THEN
513: x_last_update_login := -1;
514: END IF;
515: ELSE
516: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
517: igs_ge_msg_stack.add;
518: app_exception.raise_exception;
519: END IF;
520:

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

630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
635: fnd_message.set_token ('ERR_CD', SQLCODE);
636: igs_ge_msg_stack.add;
637: igs_sc_gen_001.unset_ctx('R');
638: app_exception.raise_exception;

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

631: EXCEPTION
632: WHEN OTHERS THEN
633: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
635: fnd_message.set_token ('ERR_CD', SQLCODE);
636: igs_ge_msg_stack.add;
637: igs_sc_gen_001.unset_ctx('R');
638: app_exception.raise_exception;
639: ELSE

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

718:
719: OPEN c1;
720: FETCH c1 INTO tlinfo;
721: IF (c1%notfound) THEN
722: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
723: igs_ge_msg_stack.add;
724: CLOSE c1;
725: app_exception.raise_exception;
726: RETURN;

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

755: AND ((tlinfo.attribute20 = x_attribute20) OR ((tlinfo.attribute20 IS NULL) AND (X_attribute20 IS NULL)))
756: ) THEN
757: NULL;
758: ELSE
759: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
760: igs_ge_msg_stack.add;
761: app_exception.raise_exception;
762: END IF;
763:

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

824: IF (x_last_update_login IS NULL) THEN
825: x_last_update_login := -1;
826: END IF;
827: ELSE
828: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
829: igs_ge_msg_stack.add;
830: app_exception.raise_exception;
831: END IF;
832:

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

901: last_update_login = x_last_update_login
902: WHERE rowid = x_rowid;
903:
904: IF (SQL%NOTFOUND) THEN
905: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
906: igs_ge_msg_stack.add;
907: igs_sc_gen_001.unset_ctx('R');
908: app_exception.raise_exception;
909: END IF;

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

913:
914: EXCEPTION
915: WHEN OTHERS THEN
916: IF (SQLCODE = (-28115)) THEN
917: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
918: fnd_message.set_token ('ERR_CD', SQLCODE);
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;

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

914: EXCEPTION
915: WHEN OTHERS THEN
916: IF (SQLCODE = (-28115)) THEN
917: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
918: fnd_message.set_token ('ERR_CD', SQLCODE);
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: ELSE

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

1072: DELETE FROM igs_pe_passport
1073: WHERE rowid = x_rowid;
1074:
1075: IF (SQL%NOTFOUND) THEN
1076: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1077: igs_ge_msg_stack.add;
1078: igs_sc_gen_001.unset_ctx('R');
1079: app_exception.raise_exception;
1080: END IF;