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

Line 38: App_Exception.Raise_Exception;

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

Line 79: App_Exception.Raise_Exception;

75: new_references.letter_reference_number,
76: v_message_name) = FALSE THEN
77: Fnd_Message.Set_Name('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: -- Validate that the s_letter is of type 'ADM'
82: IF IGS_AD_VAL_APCL.corp_val_slet_slrt(
83: new_references.correspondence_type,

Line 89: App_Exception.Raise_Exception;

85: 'ADM',
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92:
93: END BeforeRowInsertUpdate1;

Line 116: App_Exception.Raise_Exception;

112: column_name is null Then
113: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:
120: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR

Line 125: App_Exception.Raise_Exception;

121: column_name is null Then
122: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR

Line 134: App_Exception.Raise_Exception;

130: column_name is null Then
131: IF new_references.s_admission_process_type <> UPPER(new_references.s_admission_process_type) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137: END Check_Constraints;
138:

Line 155: App_Exception.Raise_Exception;

151: 'N'
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) AND

Line 171: App_Exception.Raise_Exception;

167: new_references.letter_reference_number
168: ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: END Check_Parent_Existance;

Line 230: App_Exception.Raise_Exception;

226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_APC_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;
233: Close cur_rowid;
234:

Line 258: App_Exception.Raise_Exception;

254: IF (cur_rowid%FOUND) THEN
255: Close cur_rowid;
256: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_SLET_FK');
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: Return;
260: END IF;
261: Close cur_rowid;
262:

Line 304: App_Exception.Raise_Exception;

300: new_references.correspondence_type
301: ) THEN
302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: Check_Constraints;
307: Check_Parent_Existance;
308: ELSIF (p_action = 'UPDATE') THEN

Line 321: App_Exception.Raise_Exception;

317: new_references.correspondence_type
318: ) THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: Check_Constraints;
324: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
325: Check_Constraints;

Line 371: app_exception.raise_exception;

367: end if;
368: else
369: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: end if;
373:
374: Before_DML(p_action =>'INSERT',
375: x_rowid =>X_ROWID,

Line 441: app_exception.raise_exception;

437: if (c1%notfound) then
438: close c1;
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: return;
443: end if;
444: close c1;
445:

Line 452: app_exception.raise_exception;

448: null;
449: else
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: return;
455: end LOCK_ROW;
456:

Line 485: app_exception.raise_exception;

481: end if;
482: else
483: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487: Before_DML(p_action =>'UPDATE',
488: x_rowid =>X_ROWID,
489: x_admission_cat => X_ADMISSION_CAT,