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

Line 40: App_Exception.Raise_Exception;

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

Line 82: App_Exception.Raise_Exception;

78: new_references.tac_aus_scndry_edu_ass_type,
79: v_message_name) = FALSE THEN
80: Fnd_Message.Set_Name('IGS',v_message_name);
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;
85: END IF;
86:

Line 113: App_Exception.Raise_Exception;

109: IF upper(Column_Name) = 'GOVT_REPORTED_IND' OR Column_Name IS NULL THEN
110: IF new_references.govt_reported_ind NOT IN ('Y','N') THEN
111: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
117: IF new_references.closed_ind NOT IN ('Y','N') THEN

Line 120: App_Exception.Raise_Exception;

116: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
117: IF new_references.closed_ind NOT IN ('Y','N') THEN
118: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123: IF upper(Column_Name) = 'STATE_CD' OR Column_Name IS NULL THEN
124: IF new_references.state_cd <> UPPER(new_references.state_cd) THEN

Line 127: App_Exception.Raise_Exception;

123: IF upper(Column_Name) = 'STATE_CD' OR Column_Name IS NULL THEN
124: IF new_references.state_cd <> UPPER(new_references.state_cd) THEN
125: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130: IF upper(Column_Name) = 'AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
131: IF new_references.aus_scndry_edu_ass_type <> UPPER(new_references.aus_scndry_edu_ass_type) THEN

Line 134: App_Exception.Raise_Exception;

130: IF upper(Column_Name) = 'AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
131: IF new_references.aus_scndry_edu_ass_type <> UPPER(new_references.aus_scndry_edu_ass_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: IF upper(Column_Name) = 'TAC_AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
138: IF new_references.tac_aus_scndry_edu_ass_type <> UPPER(new_references.tac_aus_scndry_edu_ass_type) THEN

Line 141: App_Exception.Raise_Exception;

137: IF upper(Column_Name) = 'TAC_AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
138: IF new_references.tac_aus_scndry_edu_ass_type <> UPPER(new_references.tac_aus_scndry_edu_ass_type) THEN
139: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143:
144: END IF;
145:

Line 160: App_Exception.Raise_Exception;

156: new_references.tac_aus_scndry_edu_ass_type ,
157: 'N') THEN
158: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163:
164: END Check_Parent_Existance;

Line 226: App_Exception.Raise_Exception;

222: IF (cur_rowid%FOUND) THEN
223: Close cur_rowid;
224: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAET_TASAET_FK');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: Return;
228: END IF;
229: Close cur_rowid;
230:

Line 273: App_Exception.Raise_Exception;

269: new_references.aus_scndry_edu_ass_type
270: ) THEN
271: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: END IF;
275: Check_Constraints;
276: Check_Parent_Existance;
277: ELSIF (p_action = 'UPDATE') THEN

Line 289: App_Exception.Raise_Exception;

285: new_references.aus_scndry_edu_ass_type
286: ) THEN
287: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: Check_Constraints;
292: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
293: Check_Constraints;

Line 341: app_exception.raise_exception;

337: end if;
338: else
339: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
340: IGS_GE_MSG_STACK.ADD;
341: app_exception.raise_exception;
342: end if;
343:
344: Before_DML(
345: p_action=>'INSERT',

Line 425: app_exception.raise_exception;

421: fetch c1 into tlinfo;
422: if (c1%notfound) then
423: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
424: IGS_GE_MSG_STACK.ADD;
425: app_exception.raise_exception;
426: close c1;
427: return;
428: end if;
429: close c1;

Line 445: app_exception.raise_exception;

441: null;
442: else
443: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: end if;
447: return;
448: end LOCK_ROW;
449:

Line 480: app_exception.raise_exception;

476: end if;
477: else
478: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: end if;
482:
483: Before_DML(
484: p_action=>'UPDATE',