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

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

37: Open cur_old_ref_values;
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;

Line 91: FND_MESSAGE.SET_NAME('IGS',v_message_name);

87: (old_references.letter_parameter_type <> new_references.letter_parameter_type) THEN
88: IF IGS_AD_VAL_AALP.corp_val_lpt_closed(new_references.letter_parameter_type,
89: v_message_name) = FALSE THEN
90: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
91: FND_MESSAGE.SET_NAME('IGS',v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: APP_EXCEPTION.RAISE_EXCEPTION;
94: END IF;
95: IF IGS_AD_VAL_AALP.corp_val_lpt_phrase(new_references.letter_parameter_type,

Line 98: FND_MESSAGE.SET_NAME('IGS',v_message_name);

94: END IF;
95: IF IGS_AD_VAL_AALP.corp_val_lpt_phrase(new_references.letter_parameter_type,
96: v_message_name) = FALSE THEN
97: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
98: FND_MESSAGE.SET_NAME('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: APP_EXCEPTION.RAISE_EXCEPTION;
101: END IF;
102: END IF;

Line 109: FND_MESSAGE.SET_NAME('IGS',v_message_name);

105: (old_references.phrase_cd <> new_references.phrase_cd) THEN
106: IF IGS_AD_VAL_AALP.corp_val_ltp_closed(new_references.phrase_cd,
107: v_message_name) = FALSE THEN
108: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
109: FND_MESSAGE.SET_NAME('IGS',v_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113: END IF;

Line 116: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PHRASECD_TXT_ENTERED');

112: END IF;
113: END IF;
114: IF new_references.phrase_cd IS NULL AND new_references.phrase_text IS NULL THEN
115: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(3153));
116: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PHRASECD_TXT_ENTERED');
117: IGS_GE_MSG_STACK.ADD;
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: END IF;
120: v_issue_dt := IGS_AD_GEN_002.ADMP_GET_AAL_SENT_DT(new_references.person_id,

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

122: new_references.correspondence_type,
123: new_references.aal_sequence_number);
124: IF v_issue_dt IS NOT NULL THEN
125: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(3086));
126: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANNOT_ALTER_LETTER');
127: IGS_GE_MSG_STACK.ADD;
128: APP_EXCEPTION.RAISE_EXCEPTION;
129: END IF;
130:

Line 155: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

151: new_references.admission_appl_number,
152: new_references.correspondence_type,
153: new_references.aal_sequence_number
154: )THEN
155: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: APP_EXCEPTION.RAISE_EXCEPTION;
158: END IF;
159: END IF;

Line 168: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

164: ELSE
165: IF NOT IGS_CO_LTR_PARM_TYPE_PKG.Get_PK_For_Validation (
166: new_references.letter_parameter_type
167: )THEN
168: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: APP_EXCEPTION.RAISE_EXCEPTION;
171: END IF;
172: END IF;

Line 181: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

177: ELSE
178: IF NOT IGS_CO_LTR_PHR_PKG.Get_PK_For_Validation (
179: new_references.phrase_cd
180: )THEN
181: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
182: IGS_GE_MSG_STACK.ADD;
183: APP_EXCEPTION.RAISE_EXCEPTION;
184: END IF;
185: END IF;

Line 247: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_AAL_FK');

243: Open cur_rowid;
244: Fetch cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: Close cur_rowid;
247: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_AAL_FK');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: Return;
251: END IF;

Line 273: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_LPT_FK');

269: Open cur_rowid;
270: Fetch cur_rowid INTO lv_rowid;
271: IF (cur_rowid%FOUND) THEN
272: Close cur_rowid;
273: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_LPT_FK');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: Return;
277: END IF;

Line 299: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_LTP_FK');

295: Open cur_rowid;
296: Fetch cur_rowid INTO lv_rowid;
297: IF (cur_rowid%FOUND) THEN
298: Close cur_rowid;
299: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AALP_LTP_FK');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: Return;
303: END IF;

Line 331: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

327: END IF;
328:
329: IF upper(column_name) = 'AAL_SEQUENCE_NUMBER' OR column_name IS NULL THEN
330: IF new_references.aal_sequence_number < 1 OR new_references.aal_sequence_number > 999999 THEN
331: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
332: IGS_GE_MSG_STACK.ADD;
333: APP_EXCEPTION.RAISE_EXCEPTION;
334: END IF;
335: END IF;

Line 338: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

334: END IF;
335: END IF;
336: IF upper(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL THEN
337: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN
338: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
339: IGS_GE_MSG_STACK.ADD;
340: APP_EXCEPTION.RAISE_EXCEPTION;
341: END IF;
342: END IF;

Line 346: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

342: END IF;
343:
344: IF upper(column_name) = 'LETTER_PARAMETER_TYPE' OR column_name IS NULL THEN
345: IF new_references.letter_parameter_type <> UPPER(new_references.letter_parameter_type) THEN
346: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
347: IGS_GE_MSG_STACK.ADD;
348: APP_EXCEPTION.RAISE_EXCEPTION;
349: END IF;
350: END IF;

Line 353: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

349: END IF;
350: END IF;
351: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR column_name IS NULL THEN
352: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) THEN
353: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
354: IGS_GE_MSG_STACK.ADD;
355: APP_EXCEPTION.RAISE_EXCEPTION;
356: END IF;
357: END IF;

Line 360: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

356: END IF;
357: END IF;
358: IF upper(column_name) = 'PHRASE_CD' OR column_name IS NULL THEN
359: IF new_references.phrase_cd <> UPPER(new_references.phrase_cd) THEN
360: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
361: IGS_GE_MSG_STACK.ADD;
362: APP_EXCEPTION.RAISE_EXCEPTION;
363: END IF;
364: END IF;

Line 415: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

411: new_references.correspondence_type,
412: new_references.aal_sequence_number,
413: new_references.sequence_number
414: )THEN
415: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
416: IGS_GE_MSG_STACK.ADD;
417: APP_EXCEPTION.RAISE_EXCEPTION;
418: END IF;
419: Check_Constraints;

Line 438: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

434: new_references.correspondence_type,
435: new_references.aal_sequence_number,
436: new_references.sequence_number
437: )THEN
438: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: IGS_GE_MSG_STACK.ADD;
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: END IF;
442: Check_Constraints;

Line 498: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

494: if X_LAST_UPDATE_LOGIN is NULL then
495: X_LAST_UPDATE_LOGIN := -1;
496: end if;
497: else
498: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
499: IGS_GE_MSG_STACK.ADD;
500: app_exception.raise_exception;
501: end if;
502:

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

591: open c1;
592: fetch c1 into tlinfo;
593: if (c1%notfound) then
594: close c1;
595: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
596: IGS_GE_MSG_STACK.ADD;
597: app_exception.raise_exception;
598: return;
599: end if;

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

611: AND (X_PHRASE_TEXT is null)))
612: ) then
613: null;
614: else
615: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
616: IGS_GE_MSG_STACK.ADD;
617: app_exception.raise_exception;
618: end if;
619: return;

Line 653: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

649: if X_LAST_UPDATE_LOGIN is NULL then
650: X_LAST_UPDATE_LOGIN := -1;
651: end if;
652: else
653: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
654: IGS_GE_MSG_STACK.ADD;
655: app_exception.raise_exception;
656: end if;
657: Before_DML (