APPS.IGS_PS_FLD_STD_HIST_PKG dependencies on APP_EXCEPTION

Line 44: App_Exception.Raise_Exception;

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

Line 94: App_Exception.Raise_Exception;

90: column_name is null Then
91: IF ( new_references.major_field_ind NOT IN ( 'Y' , 'N' ) ) Then
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98: IF upper(column_name) = 'COURSE_CD' OR

Line 103: App_Exception.Raise_Exception;

99: column_name is null Then
100: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107: IF upper(column_name) = 'FIELD_OF_STUDY' OR

Line 112: App_Exception.Raise_Exception;

108: column_name is null Then
109: IF ( new_references.field_of_study <> UPPER(new_references.field_of_study) ) Then
110: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:
116: END Check_Constraints;

Line 133: App_Exception.Raise_Exception;

129: new_references.version_number
130: ) THEN
131: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF (((old_references.field_of_study = new_references.field_of_study)) OR

Line 146: App_Exception.Raise_Exception;

142: new_references.field_of_study
143: ) THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: END Check_Parent_Existance;

Line 206: App_Exception.Raise_Exception;

202: IF (cur_rowid%FOUND) THEN
203: Close cur_rowid;
204: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CFOSH_CV_FK');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: Return;
208: END IF;
209: Close cur_rowid;
210:

Line 261: App_Exception.Raise_Exception;

257: new_references.field_of_study ,
258: new_references.hist_start_dt) THEN
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: Check_Constraints;
264: Check_Parent_Existance;
265: ELSIF (p_action = 'UPDATE') THEN

Line 280: App_Exception.Raise_Exception;

276: new_references.field_of_study ,
277: new_references.hist_start_dt) THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints;
283: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
284: Check_Constraints;

Line 338: app_exception.raise_exception;

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

Line 434: app_exception.raise_exception;

430: if (c1%notfound) then
431: close c1;
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: return;
436: end if;
437: close c1;
438:

Line 452: app_exception.raise_exception;

448: null;
449: else
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: return;
455: end LOCK_ROW;
456:

Line 490: app_exception.raise_exception;

486: end if;
487: else
488: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
489: IGS_GE_MSG_STACK.ADD;
490: app_exception.raise_exception;
491: end if;
492: Before_DML (
493: p_action => 'UPDATE',
494: x_rowid => X_ROWID,