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

Line 39: App_Exception.Raise_Exception;

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

Line 75: App_Exception.Raise_Exception;

71: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_CLOSED(new_references.administrative_unit_status
72: ,v_message_name) = FALSE THEN
73: Fnd_Message.Set_Name('IGS',v_message_name);
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: END IF;
77: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_DISCONT(new_references.administrative_unit_status,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);

Line 81: App_Exception.Raise_Exception;

77: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_DISCONT(new_references.administrative_unit_status,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: IF IGS_EN_VAL_UDDC.ENRP_VAL_TEACHING_DA(new_references.unit_discont_dt_alias,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);

Line 87: App_Exception.Raise_Exception;

83: IF IGS_EN_VAL_UDDC.ENRP_VAL_TEACHING_DA(new_references.unit_discont_dt_alias,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: IF IGS_EN_VAL_UDDC.ENRP_VAL_UDDC_FIELDS(new_references.administrative_unit_status ,new_references.delete_ind
90: ,v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS',v_message_name);

Line 93: App_Exception.Raise_Exception;

89: IF IGS_EN_VAL_UDDC.ENRP_VAL_UDDC_FIELDS(new_references.administrative_unit_status ,new_references.delete_ind
90: ,v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS',v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
96:
97:

Line 122: App_Exception.Raise_Exception;

118: IF Upper(Column_Name)='ADMINISTRATIVE_UNIT_STATUS' OR Column_Name IS NULL Then
119: IF New_References.administrative_unit_status <> UPPER(New_References.administrative_unit_status) Then
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:
126: IF Upper(Column_Name)='UNIT_DISCONT_DT_ALIAS' OR Column_Name IS NULL Then

Line 130: App_Exception.Raise_Exception;

126: IF Upper(Column_Name)='UNIT_DISCONT_DT_ALIAS' OR Column_Name IS NULL Then
127: IF New_References.unit_discont_dt_alias <> UPPER(New_References.unit_discont_dt_alias) Then
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: END IF;
133:
134: IF Upper(Column_Name)='DFLT_IND' OR Column_Name IS NULL Then

Line 138: App_Exception.Raise_Exception;

134: IF Upper(Column_Name)='DFLT_IND' OR Column_Name IS NULL Then
135: IF New_References.dflt_ind NOT IN ('Y','N') Then
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:
142: IF Upper(Column_Name)='DELETE_IND' OR Column_Name IS NULL Then

Line 146: App_Exception.Raise_Exception;

142: IF Upper(Column_Name)='DELETE_IND' OR Column_Name IS NULL Then
143: IF New_References.delete_ind NOT IN ('Y','N') Then
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: END Check_Constraints;

Line 162: App_Exception.Raise_Exception;

158: ELSE
159: IF NOT IGS_AD_ADM_UNIT_STAT_PKG.Get_PK_For_Validation (new_references.administrative_unit_status , 'N') THEN
160: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164:
165: END IF;
166:

Line 174: App_Exception.Raise_Exception;

170: ELSE
171: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (new_references.unit_discont_dt_alias) THEN
172: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176:
177: END IF;
178:

Line 225: App_Exception.Raise_Exception;

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

Line 267: App_Exception.Raise_Exception;

263: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
264: IF Get_PK_For_Validation (New_References.unit_discont_dt_alias) THEN
265: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: END IF;
269: Check_Constraints;
270: Check_Parent_Existance;
271: ELSIF (p_action = 'UPDATE') THEN

Line 281: App_Exception.Raise_Exception;

277: ELSIF (p_action = 'VALIDATE_INSERT') THEN
278: IF Get_PK_For_Validation (New_References.unit_discont_dt_alias) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: Check_Constraints;
284: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
285: Check_Constraints;

Line 333: app_exception.raise_exception;

329: end if;
330: else
331: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
332: IGS_GE_MSG_STACK.ADD;
333: app_exception.raise_exception;
334: end if;
335:
336: Before_DML(
337: p_action => 'INSERT',

Line 409: app_exception.raise_exception;

405: if (c1%notfound) then
406: close c1;
407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: return;
411: end if;
412: close c1;
413:

Line 424: app_exception.raise_exception;

420: null;
421: else
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: IGS_GE_MSG_STACK.ADD;
424: app_exception.raise_exception;
425: end if;
426: return;
427: end LOCK_ROW;
428:

Line 457: app_exception.raise_exception;

453: end if;
454: else
455: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459:
460: Before_DML(
461: p_action => 'UPDATE',