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 APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

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

Line 93: APP_EXCEPTION.RAISE_EXCEPTION;

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
97: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));

Line 100: APP_EXCEPTION.RAISE_EXCEPTION;

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
104: IF p_inserting OR

Line 111: APP_EXCEPTION.RAISE_EXCEPTION;

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
115: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(3153));

Line 118: APP_EXCEPTION.RAISE_EXCEPTION;

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,
122: new_references.correspondence_type,

Line 128: APP_EXCEPTION.RAISE_EXCEPTION;

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:
132: END BeforeRowInsertUpdate1;

Line 157: APP_EXCEPTION.RAISE_EXCEPTION;

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:
161: IF (((old_references.letter_parameter_type = new_references.letter_parameter_type)) OR

Line 170: APP_EXCEPTION.RAISE_EXCEPTION;

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:
174: IF (((old_references.phrase_cd = new_references.phrase_cd)) OR

Line 183: APP_EXCEPTION.RAISE_EXCEPTION;

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:
187: END Check_Parent_Existance;

Line 249: App_Exception.Raise_Exception;

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

Line 275: App_Exception.Raise_Exception;

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

Line 301: App_Exception.Raise_Exception;

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

Line 333: APP_EXCEPTION.RAISE_EXCEPTION;

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
337: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN

Line 340: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 348: APP_EXCEPTION.RAISE_EXCEPTION;

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
352: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) THEN

Line 355: APP_EXCEPTION.RAISE_EXCEPTION;

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
359: IF new_references.phrase_cd <> UPPER(new_references.phrase_cd) THEN

Line 362: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 417: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 440: APP_EXCEPTION.RAISE_EXCEPTION;

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
444: -- Call all the procedures related to Before Delete.

Line 500: app_exception.raise_exception;

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 (
504: p_action => 'INSERT',

Line 597: app_exception.raise_exception;

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

Line 617: app_exception.raise_exception;

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

Line 655: app_exception.raise_exception;

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',
659: x_rowid => X_ROWID,