APPS.IGS_GE_MEASUREMENT_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:

Line 81: App_Exception.Raise_Exception;

77: IF upper(Column_name) = 'MEASUREMENT_CD' OR column_name is null then
78: IF new_references.measurement_cd <> UPPER(new_references.measurement_cd ) THEN
79: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
84: IF upper(Column_name) = 'MEASUREMENT_TYPE' OR column_name is null then
85: IF new_references.measurement_type <> UPPER(new_references.measurement_type ) THEN

Line 88: App_Exception.Raise_Exception;

84: IF upper(Column_name) = 'MEASUREMENT_TYPE' OR column_name is null then
85: IF new_references.measurement_type <> UPPER(new_references.measurement_type ) THEN
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91: IF upper(Column_name) = 'CLOSED_IND' OR column_name is null then
92: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR

Line 96: App_Exception.Raise_Exception;

92: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
93: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99: END Check_Constraints;
100:

Line 169: App_Exception.Raise_Exception;

165: -- Call all the procedures related to Before Insert.
166: IF GET_PK_FOR_VALIDATION ( new_references.measurement_cd ) THEN
167: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: Check_Constraints;
172: ELSIF (p_action = 'UPDATE') THEN
173: -- Call all the procedures related to Before Update.

Line 184: App_Exception.Raise_Exception;

180: -- Call all the procedures related to Before Insert.
181: IF GET_PK_FOR_VALIDATION ( new_references.measurement_cd ) THEN
182: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: Check_Constraints;
187: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
188: -- Call all the procedures related to Before Update.

Line 249: app_exception.raise_exception;

245: end if;
246: else
247: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
248: IGS_GE_MSG_STACK.ADD;
249: app_exception.raise_exception;
250: end if;
251:
252: Before_DML (
253: p_action => 'INSERT',

Line 325: app_exception.raise_exception;

321: if (c1%notfound) then
322: close c1;
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: IGS_GE_MSG_STACK.ADD;
325: app_exception.raise_exception;
326: return;
327: end if;
328: close c1;
329:

Line 338: app_exception.raise_exception;

334: null;
335: else
336: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
337: IGS_GE_MSG_sTACK.ADD;
338: app_exception.raise_exception;
339: end if;
340: return;
341: end LOCK_ROW;
342:

Line 371: app_exception.raise_exception;

367: end if;
368: else
369: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: end if;
373:
374: Before_DML (
375: p_action => 'UPDATE',