APPS.IGS_ST_GOVT_SEMESTER_PKG dependencies on IGS_GE_MSG_STACK

Line 36: IGS_GE_MSG_STACK.ADD;

32: Open cur_old_ref_values;
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;

Line 87: IGS_GE_MSG_STACK.ADD;

83: v_submission_number,
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:

Line 113: IGS_GE_MSG_STACK.ADD;

109: column_name is null Then
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:

Line 123: IGS_GE_MSG_STACK.ADD;

119: column_name is null Then
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;

Line 143: IGS_GE_MSG_STACK.ADD;

139: new_references.submission_yr,
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:

Line 230: IGS_GE_MSG_STACK.ADD;

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

Line 273: IGS_GE_MSG_STACK.ADD;

269: new_references.submission_number,
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;

Line 292: IGS_GE_MSG_STACK.ADD;

288: new_references.submission_number,
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

Line 342: IGS_GE_MSG_STACK.ADD;

338: X_LAST_UPDATE_LOGIN := -1;
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 (

Line 410: IGS_GE_MSG_STACK.ADD;

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