APPS.IGS_AS_UNIT_MODE_PKG dependencies on APP_EXCEPTION

Line 34: App_Exception.Raise_Exception;

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

Line 77: App_Exception.Raise_Exception;

73: new_references.unit_mode, new_references.closed_ind,
74: v_message_name) = FALSE THEN
75: Fnd_Message.Set_Name('IGS', v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;
80: END BeforeRowInsertUpdate1;
81:

Line 143: App_Exception.Raise_Exception;

139: column_name is null Then
140: IF new_references.s_unit_mode <> UPPER(new_references.s_unit_mode) OR new_references.s_unit_mode NOT IN ( 'ON' , 'OFF' , 'COMPOSITE' ) Then
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147: IF upper(column_name) = 'CLOSED_IND' OR

Line 152: App_Exception.Raise_Exception;

148: column_name is null Then
149: IF new_references.closed_ind <> UPPER(new_references.closed_ind) OR new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155:
156: IF upper(column_name) = 'UNIT_MODE' OR

Line 161: App_Exception.Raise_Exception;

157: column_name is null Then
158: IF new_references.unit_mode <> UPPER(new_references.unit_mode) Then
159: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164:
165:

Line 204: App_Exception.Raise_Exception;

200: new_references.unit_MODE
201: ) THEN
202: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206: Check_Constraints;
207: ELSIF (p_action = 'UPDATE') THEN
208: -- Call all the procedures related to Before Update.

Line 222: App_Exception.Raise_Exception;

218: new_references.unit_MODE
219: ) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: Check_Constraints;
225: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
226: Check_Constraints;

Line 261: app_exception.raise_exception;

257: X_LAST_UPDATE_LOGIN := -1;
258: end if;
259: else
260: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
261: app_exception.raise_exception;
262: IGS_GE_MSG_STACK.ADD;
263: end if;
264: --
265: Before_DML(

Line 331: app_exception.raise_exception;

327: if (c1%notfound) then
328: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
329: IGS_GE_MSG_STACK.ADD;
330: close c1;
331: app_exception.raise_exception;
332: return;
333: end if;
334: close c1;
335: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 343: app_exception.raise_exception;

339: null;
340: else
341: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
342: IGS_GE_MSG_STACK.ADD;
343: app_exception.raise_exception;
344: end if;
345: return;
346: end LOCK_ROW;
347: procedure UPDATE_ROW (

Line 375: app_exception.raise_exception;

371: end if;
372: else
373: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
374: IGS_GE_MSG_STACK.ADD;
375: app_exception.raise_exception;
376: end if;
377: --
378: Before_DML(
379: p_action=>'UPADTE',