APPS.IGS_ST_GOVT_SEMESTER_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Close cur_old_ref_values;
39: Return;
40: END IF;
41: Close cur_old_ref_values;

Line 88: App_Exception.Raise_Exception;

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

Line 114: App_Exception.Raise_Exception;

110: IF new_references.submission_yr < 0000 OR
111: new_references.submission_yr > 9999 Then
112: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116: END IF;
117:
118: IF upper(column_name) = 'GOVT_SEMESTER' OR

Line 124: App_Exception.Raise_Exception;

120: IF new_references.govt_semester < 1 OR
121: new_references.govt_semester > 5 Then
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127: END Check_Constraints;
128:

Line 144: App_Exception.Raise_Exception;

140: new_references.submission_number
141: ) THEN
142: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: 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_ST_GSEM_GSC_FK');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: Return;
233: END IF;
234: Close cur_rowid;
235:

Line 274: App_Exception.Raise_Exception;

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

Line 293: App_Exception.Raise_Exception;

289: new_references.govt_semester
290: ) THEN
291: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: Check_Constraints;
296: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
297: Check_Constraints;

Line 343: app_exception.raise_exception;

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

Line 411: app_exception.raise_exception;

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