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_PKG dependencies on APP_EXCEPTION

Line 41: App_Exception.Raise_Exception;

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

Line 97: APP_EXCEPTION.RAISE_EXCEPTION;

93: v_message_name) = FALSE THEN
94: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
95: FND_MESSAGE.SET_NAME('IGS',v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: END IF;
99: IF IGS_AD_VAL_AAL.admp_val_aal_exists(new_references.person_id,
100: new_references.admission_appl_number,
101: new_references.correspondence_type,

Line 106: APP_EXCEPTION.RAISE_EXCEPTION;

102: v_message_name) = FALSE THEN
103: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
104: FND_MESSAGE.SET_NAME('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: APP_EXCEPTION.RAISE_EXCEPTION;
107: END IF;
108: IGS_AD_GEN_002.ADMP_GET_AA_DTL(new_references.person_id,
109: new_references.admission_appl_number,
110: v_admission_cat,

Line 126: APP_EXCEPTION.RAISE_EXCEPTION;

122: v_message_name) = FALSE THEN
123: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
124: FND_MESSAGE.SET_NAME('IGS',v_message_name);
125: IGS_GE_MSG_STACK.ADD;
126: APP_EXCEPTION.RAISE_EXCEPTION;
127: END IF;
128: END IF;
129: IF ( new_references.composed_ind <> old_references.composed_ind) AND
130: new_references.spl_sequence_number IS NOT NULL THEN

Line 134: APP_EXCEPTION.RAISE_EXCEPTION;

130: new_references.spl_sequence_number IS NOT NULL THEN
131: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(3086));
132: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANNOT_ALTER_LETTER');
133: IGS_GE_MSG_STACK.ADD;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135: END IF;
136:
137:
138: END BeforeRowInsertUpdate1;

Line 155: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 168: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 188: APP_EXCEPTION.RAISE_EXCEPTION;

184: new_references.person_id,new_references.correspondence_type,new_references.letter_reference_number,
185: new_references.spl_sequence_number )THEN
186: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;
188: APP_EXCEPTION.RAISE_EXCEPTION;
189: END IF;
190:
191: END IF;
192:

Line 262: App_Exception.Raise_Exception;

258: IF (cur_rowid%FOUND) THEN
259: Close cur_rowid;
260: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAL_AA_FK');
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263: Return;
264: END IF;
265: Close cur_rowid;
266:

Line 288: App_Exception.Raise_Exception;

284: IF (cur_rowid%FOUND) THEN
285: Close cur_rowid;
286: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAL_CORT_FK');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: Return;
290: END IF;
291: Close cur_rowid;
292:

Line 320: App_Exception.Raise_Exception;

316: IF (cur_rowid%FOUND) THEN
317: Close cur_rowid;
318: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAL_SPL_FK');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: Return;
322: END IF;
323: Close cur_rowid;
324:

Line 347: APP_EXCEPTION.RAISE_EXCEPTION;

343: IF upper(column_name) = 'COMPOSED_IND' OR column_name IS NULL THEN
344: IF new_references.composed_ind NOT IN ('Y','N') THEN
345: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
346: IGS_GE_MSG_STACK.ADD;
347: APP_EXCEPTION.RAISE_EXCEPTION;
348: END IF;
349: END IF;
350: IF upper(column_name) = 'SPL_SEQUENCE_NUMBER' OR column_name IS NULL THEN
351: IF new_references.spl_sequence_number < 1 OR new_references.spl_sequence_number > 9999999999 THEN

Line 354: APP_EXCEPTION.RAISE_EXCEPTION;

350: IF upper(column_name) = 'SPL_SEQUENCE_NUMBER' OR column_name IS NULL THEN
351: IF new_references.spl_sequence_number < 1 OR new_references.spl_sequence_number > 9999999999 THEN
352: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
353: IGS_GE_MSG_STACK.ADD;
354: APP_EXCEPTION.RAISE_EXCEPTION;
355: END IF;
356: END IF;
357:
358: IF upper(column_name) = 'COMPOSED_IND' OR column_name IS NULL THEN

Line 362: APP_EXCEPTION.RAISE_EXCEPTION;

358: IF upper(column_name) = 'COMPOSED_IND' OR column_name IS NULL THEN
359: IF new_references.composed_ind <> UPPER(new_references.composed_ind) 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: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR column_name IS NULL THEN
366: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) THEN

Line 369: APP_EXCEPTION.RAISE_EXCEPTION;

365: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR column_name IS NULL THEN
366: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) THEN
367: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
368: IGS_GE_MSG_STACK.ADD;
369: APP_EXCEPTION.RAISE_EXCEPTION;
370: END IF;
371: END IF;
372: END CHECK_CONSTRAINTS;
373:

Line 422: APP_EXCEPTION.RAISE_EXCEPTION;

418: new_references.sequence_number
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: Check_Constraints;
425: Check_Parent_Existance;
426: ELSIF (p_action = 'UPDATE') THEN

Line 445: APP_EXCEPTION.RAISE_EXCEPTION;

441: new_references.sequence_number
442: )THEN
443: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
444: IGS_GE_MSG_STACK.ADD;
445: APP_EXCEPTION.RAISE_EXCEPTION;
446: END IF;
447: Check_Constraints;
448: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
449: -- Call all the procedures related to Before Delete.

Line 519: app_exception.raise_exception;

515: end if;
516: else
517: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
518: IGS_GE_MSG_STACK.ADD;
519: app_exception.raise_exception;
520: end if;
521:
522: Before_DML (
523: p_action => 'INSERT',

Line 615: app_exception.raise_exception;

611: if (c1%notfound) then
612: close c1;
613: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
614: IGS_GE_MSG_STACK.ADD;
615: app_exception.raise_exception;
616: return;
617: end if;
618: close c1;
619:

Line 632: app_exception.raise_exception;

628: null;
629: else
630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
631: IGS_GE_MSG_STACK.ADD;
632: app_exception.raise_exception;
633: end if;
634: return;
635: end LOCK_ROW;
636:

Line 672: app_exception.raise_exception;

668: end if;
669: else
670: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
671: IGS_GE_MSG_STACK.ADD;
672: app_exception.raise_exception;
673: end if;
674:
675: Before_DML (
676: p_action => 'UPDATE',