APPS.IGS_PS_FLD_STDY_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 93: App_Exception.Raise_Exception;

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

Line 102: App_Exception.Raise_Exception;

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

Line 111: App_Exception.Raise_Exception;

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

Line 189: App_Exception.Raise_Exception;

185: new_references.hist_start_dt
186: ) THEN
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: Check_Constraints;
192: ELSIF (p_action = 'UPDATE') THEN
193: -- Call all the procedures related to Before Update.

Line 203: App_Exception.Raise_Exception;

199: new_references.hist_start_dt
200: ) THEN
201: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205: Check_Constraints;
206: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
207: Check_Constraints;

Line 259: app_exception.raise_exception;

255: end if;
256: else
257: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
258: IGS_GE_MSG_STACK.ADD;
259: app_exception.raise_exception;
260: end if;
261:
262: Before_DML( p_action => 'INSERT',
263: x_rowid => X_ROWID,

Line 355: app_exception.raise_exception;

351: if (c1%notfound) then
352: close c1;
353: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
354: IGS_GE_MSG_STACK.ADD;
355: app_exception.raise_exception;
356: return;
357: end if;
358: close c1;
359:

Line 377: app_exception.raise_exception;

373: null;
374: else
375: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
376: IGS_GE_MSG_STACK.ADD;
377: app_exception.raise_exception;
378: end if;
379: return;
380: end LOCK_ROW;
381:

Line 415: app_exception.raise_exception;

411: end if;
412: else
413: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
414: IGS_GE_MSG_STACK.ADD;
415: app_exception.raise_exception;
416: end if;
417:
418: Before_DML( p_action => 'UPDATE',
419: x_rowid => X_ROWID,