APPS.IGS_PS_UNIT_CAT_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 77: App_Exception.Raise_Exception;

73: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
74: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
75: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79:
80: END IF;
81:

Line 86: App_Exception.Raise_Exception;

82: IF Upper(Column_Name)='UNIT_CAT' OR Column_Name IS NULL Then
83: IF new_references.Unit_Cat <> UPPER(New_References.Unit_Cat ) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:
90: END Check_Constraints;

Line 161: App_Exception.Raise_Exception;

157: -- Call all the procedures related to Before Insert.
158: IF Get_PK_For_Validation (New_References.unit_cat) THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;
164: ELSIF (p_action = 'UPDATE') THEN
165: -- Call all the procedures related to Before Update.

Line 174: App_Exception.Raise_Exception;

170: ELSIF (p_action = 'VALIDATE_INSERT') THEN
171: IF Get_PK_For_Validation (New_References.unit_cat) THEN
172: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: Check_Constraints;
177: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
178: Check_Constraints;

Line 226: app_exception.raise_exception;

222: end if;
223: else
224: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
225: IGS_GE_MSG_STACK.ADD;
226: app_exception.raise_exception;
227: end if;
228:
229: Before_DML(
230: p_action => 'INSERT',

Line 296: app_exception.raise_exception;

292: if (c1%notfound) then
293: close c1;
294: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
295: IGS_GE_MSG_STACK.ADD;
296: app_exception.raise_exception;
297: return;
298: end if;
299: close c1;
300:

Line 308: app_exception.raise_exception;

304: null;
305: else
306: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
307: IGS_GE_MSG_STACK.ADD;
308: app_exception.raise_exception;
309: end if;
310: return;
311: end LOCK_ROW;
312:

Line 340: app_exception.raise_exception;

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