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 IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

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;
46: Close cur_old_ref_values;

Line 92: IGS_GE_MSG_STACK.ADD;

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,
96: v_message_name) = FALSE THEN

Line 99: IGS_GE_MSG_STACK.ADD;

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;
103: -- Validate letter phrase

Line 110: IGS_GE_MSG_STACK.ADD;

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;
114: IF new_references.phrase_cd IS NULL AND new_references.phrase_text IS NULL THEN

Line 117: IGS_GE_MSG_STACK.ADD;

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,
121: new_references.admission_appl_number,

Line 127: IGS_GE_MSG_STACK.ADD;

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:
131:

Line 156: IGS_GE_MSG_STACK.ADD;

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

Line 169: IGS_GE_MSG_STACK.ADD;

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

Line 182: IGS_GE_MSG_STACK.ADD;

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

Line 248: IGS_GE_MSG_STACK.ADD;

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;
252: Close cur_rowid;

Line 274: IGS_GE_MSG_STACK.ADD;

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;
278: Close cur_rowid;

Line 300: IGS_GE_MSG_STACK.ADD;

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;
304: Close cur_rowid;

Line 332: IGS_GE_MSG_STACK.ADD;

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;
336: IF upper(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL THEN

Line 339: IGS_GE_MSG_STACK.ADD;

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

Line 347: IGS_GE_MSG_STACK.ADD;

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;
351: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR column_name IS NULL THEN

Line 354: IGS_GE_MSG_STACK.ADD;

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;
358: IF upper(column_name) = 'PHRASE_CD' OR column_name IS NULL THEN

Line 361: IGS_GE_MSG_STACK.ADD;

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;
365: END CHECK_CONSTRAINTS;

Line 416: IGS_GE_MSG_STACK.ADD;

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;
420: Check_Parent_Existance;

Line 439: IGS_GE_MSG_STACK.ADD;

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;
443: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 499: IGS_GE_MSG_STACK.ADD;

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:
503: Before_DML (

Line 596: IGS_GE_MSG_STACK.ADD;

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;
600: close c1;

Line 616: IGS_GE_MSG_STACK.ADD;

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;
620: end LOCK_ROW;

Line 654: IGS_GE_MSG_STACK.ADD;

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 (
658: p_action => 'UPDATE',