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 IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

33: Fetch cur_old_ref_values INTO old_references;
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;

Line 78: IGS_GE_MSG_STACK.ADD;

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

Line 88: IGS_GE_MSG_STACK.ADD;

84: new_references.letter_reference_number,
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:

Line 115: IGS_GE_MSG_STACK.ADD;

111: IF upper(column_name) = 'ADMISSION_CAT' OR
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:

Line 124: IGS_GE_MSG_STACK.ADD;

120: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
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:

Line 133: IGS_GE_MSG_STACK.ADD;

129: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR
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;

Line 154: IGS_GE_MSG_STACK.ADD;

150: new_references.s_admission_process_type,
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:

Line 170: IGS_GE_MSG_STACK.ADD;

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

Line 229: IGS_GE_MSG_STACK.ADD;

225: Fetch cur_rowid INTO lv_rowid;
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;

Line 257: IGS_GE_MSG_STACK.ADD;

253: Fetch cur_rowid INTO lv_rowid;
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;

Line 303: IGS_GE_MSG_STACK.ADD;

299: new_references.s_admission_process_type,
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;

Line 320: IGS_GE_MSG_STACK.ADD;

316: new_references.s_admission_process_type,
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

Line 370: IGS_GE_MSG_STACK.ADD;

366: X_LAST_UPDATE_LOGIN := -1;
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',

Line 440: IGS_GE_MSG_STACK.ADD;

436: fetch c1 into tlinfo;
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;

Line 451: IGS_GE_MSG_STACK.ADD;

447: ) then
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;

Line 484: IGS_GE_MSG_STACK.ADD;

480: X_LAST_UPDATE_LOGIN := -1;
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,