APPS.IGS_FI_GOVT_HEC_CNTB_PKG dependencies on APP_EXCEPTION

Line 32: App_Exception.Raise_Exception;

28: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
29: Close cur_old_ref_values;
30: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
31: IGS_GE_MSG_STACK.ADD;
32: App_Exception.Raise_Exception;
33: Return;
34: END IF;
35: Close cur_old_ref_values;
36: -- Populate New Values.

Line 67: App_Exception.Raise_Exception;

63: IF ((UPPER (column_name) = 'GOVT_HECS_CNTRBTN_BAND') OR (column_name IS NULL)) THEN
64: IF ((new_references.govt_hecs_cntrbtn_band < 1) OR (new_references.govt_hecs_cntrbtn_band > 99)) THEN
65: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
66: IGS_GE_MSG_STACK.ADD;
67: App_Exception.Raise_Exception;
68: END IF;
69: END IF;
70: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
71: IF (new_references.closed_ind NOT IN ('Y', 'N')) THEN

Line 74: App_Exception.Raise_Exception;

70: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
71: IF (new_references.closed_ind NOT IN ('Y', 'N')) THEN
72: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: END IF;
77: END Check_Constraints;
78: PROCEDURE Check_Child_Existance AS

Line 139: App_Exception.Raise_Exception;

135: new_references.govt_hecs_cntrbtn_band
136: )) THEN
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: Check_Constraints;
142: ELSIF (p_action = 'UPDATE') THEN
143: -- Call all the procedures related to Before Update.

Line 154: App_Exception.Raise_Exception;

150: new_references.govt_hecs_cntrbtn_band
151: )) THEN
152: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: Check_Constraints;
157: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
158: Check_Constraints;

Line 192: app_exception.raise_exception;

188: end if;
189: else
190: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: end if;
194: Before_DML(
195: p_action=>'INSERT',
196: x_rowid=>X_ROWID,

Line 253: app_exception.raise_exception;

249: if (c1%notfound) then
250: close c1;
251: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
252: IGS_GE_MSG_STACK.ADD;
253: app_exception.raise_exception;
254: return;
255: end if;
256: close c1;
257: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 264: app_exception.raise_exception;

260: null;
261: else
262: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
263: IGS_GE_MSG_STACK.ADD;
264: app_exception.raise_exception;
265: end if;
266: return;
267: end LOCK_ROW;
268: procedure UPDATE_ROW (

Line 295: app_exception.raise_exception;

291: end if;
292: else
293: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
294: IGS_GE_MSG_STACK.ADD;
295: app_exception.raise_exception;
296: end if;
297: Before_DML(
298: p_action=>'UPDATE',
299: x_rowid=>X_ROWID,