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

Line 40: App_Exception.Raise_Exception;

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

Line 80: App_Exception.Raise_Exception;

76: new_references.s_adm_outcome_status,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS', v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS', 'IGS_AD_SYS_DFLT_IND_NOTSET_CLS');

Line 86: App_Exception.Raise_Exception;

82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS', 'IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: -- Validate System admission outcome status unit outcome ind.
89: IF p_inserting OR (old_references.s_adm_outcome_status <>
90: new_references.s_adm_outcome_status) THEN

Line 96: App_Exception.Raise_Exception;

92: new_references.s_adm_outcome_status,
93: v_message_name) = FALSE THEN
94: Fnd_Message.Set_Name('IGS', v_message_name);
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99:
100:

Line 126: App_Exception.Raise_Exception;

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

Line 134: App_Exception.Raise_Exception;

130: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
131: IF new_references.closed_ind NOT IN ('Y','N') 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:
138:

Line 143: App_Exception.Raise_Exception;

139: IF upper(Column_Name) = 'SYSTEM_DEFAULT_IND' OR Column_Name IS NULL THEN
140: IF new_references.system_default_ind NOT IN ('Y','N') THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147: IF upper(Column_Name) = 'S_ADM_OUTCOME_STATUS' OR Column_Name IS NULL THEN

Line 151: App_Exception.Raise_Exception;

147: IF upper(Column_Name) = 'S_ADM_OUTCOME_STATUS' OR Column_Name IS NULL THEN
148: IF new_references.s_adm_outcome_status <> UPPER(new_references.s_adm_outcome_status) THEN
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153: END IF;
154:
155: END Check_Constraints;

Line 169: App_Exception.Raise_Exception;

165: 'ADM_OUTCOME_STATUS',new_references.s_adm_outcome_status
166: ) THEN
167: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172:
173: END Check_Parent_Existance;

Line 231: App_Exception.Raise_Exception;

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

Line 277: App_Exception.Raise_Exception;

273: new_references.adm_unit_outcome_status
274: ) THEN
275: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: END IF;
279: Check_Constraints;
280: Check_Parent_Existance;
281: ELSIF (p_action = 'UPDATE') THEN

Line 296: App_Exception.Raise_Exception;

292: new_references.adm_unit_outcome_status
293: ) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
300: Check_Constraints;

Line 347: app_exception.raise_exception;

343: end if;
344: else
345: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
346: IGS_GE_MSG_STACK.ADD;
347: app_exception.raise_exception;
348: end if;
349: Before_DML (
350: p_action => 'INSERT',
351: x_rowid => X_ROWID,

Line 426: app_exception.raise_exception;

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

Line 440: app_exception.raise_exception;

436: null;
437: else
438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439: IGS_GE_MSG_STACK.ADD;
440: app_exception.raise_exception;
441: end if;
442: return;
443: end LOCK_ROW;
444:

Line 474: app_exception.raise_exception;

470: end if;
471: else
472: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
473: IGS_GE_MSG_STACK.ADD;
474: app_exception.raise_exception;
475: end if;
476: Before_DML (
477: p_action => 'UPDATE',
478: x_rowid => X_ROWID,