APPS.IGS_PS_UNIT_STAT_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 82: App_Exception.Raise_Exception;

78: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
79: IF New_References.Closed_Ind NOT IN ( 'Y' , 'N' ) Then
80: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84:
85: END IF;
86:

Line 91: App_Exception.Raise_Exception;

87: IF Upper(Column_Name)='S_UNIT_STATUS' OR Column_Name IS NULL Then
88: IF New_References.S_Unit_Status NOT IN ( 'ACTIVE' , 'INACTIVE' , 'PLANNED' ) Then
89: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93:
94: END IF;
95:

Line 100: App_Exception.Raise_Exception;

96: IF Upper(Column_Name)='UNIT_STATUS' OR Column_Name IS NULL Then
97: IF New_References.Unit_Status <> UPPER(New_References.Unit_Status) Then
98: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:
104: END Check_Constraints;

Line 174: App_Exception.Raise_Exception;

170: -- Call all the procedures related to Before Insert.
171: IF Get_PK_For_Validation (New_References.unit_status) 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 = 'UPDATE') THEN
178: -- Call all the procedures related to Before Update.

Line 188: App_Exception.Raise_Exception;

184: ELSIF (p_action = 'VALIDATE_INSERT') THEN
185: IF Get_PK_For_Validation (New_References.unit_status) THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: Check_Constraints;
191: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
192: Check_Constraints;

Line 241: app_exception.raise_exception;

237: end if;
238: else
239: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
240: IGS_GE_MSG_STACK.ADD;
241: app_exception.raise_exception;
242: end if;
243:
244: Before_DML(
245: p_action => 'INSERT',

Line 317: app_exception.raise_exception;

313: if (c1%notfound) then
314: close c1;
315: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
316: IGS_GE_MSG_STACK.ADD;
317: app_exception.raise_exception;
318: return;
319: end if;
320: close c1;
321:

Line 330: app_exception.raise_exception;

326: null;
327: else
328: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
329: IGS_GE_MSG_STACK.ADD;
330: app_exception.raise_exception;
331: end if;
332: return;
333: end LOCK_ROW;
334:

Line 363: app_exception.raise_exception;

359: end if;
360: else
361: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
362: IGS_GE_MSG_STACK.ADD;
363: app_exception.raise_exception;
364: end if;
365:
366: Before_DML(
367: p_action => 'UPDATE',