APPS.IGS_PS_UNIT_LEVEL_PKG dependencies on APP_EXCEPTION

Line 41: App_Exception.Raise_Exception;

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

Line 83: App_Exception.Raise_Exception;

79: IF Upper(Column_Name)='WAM_WEIGHTING' OR Column_Name IS NULL Then
80: IF New_References.wam_weighting < 0 AND New_References.wam_weighting > 9.999 Then
81: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86:
87: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then

Line 91: App_Exception.Raise_Exception;

87: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
88: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) 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: END IF;
94:
95: IF Upper(Column_Name)='UNIT_LEVEL' OR Column_Name IS NULL Then

Line 99: App_Exception.Raise_Exception;

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

Line 167: App_Exception.Raise_Exception;

163: -- Call all the procedures related to Before Insert.
164: IF Get_PK_For_Validation (New_References.unit_level) THEN
165: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: Check_Constraints;
170: ELSIF (p_action = 'UPDATE') THEN
171: -- Call all the procedures related to Before Update.

Line 177: App_Exception.Raise_Exception;

173: ELSIF (p_action = 'VALIDATE_INSERT') THEN
174: IF Get_PK_For_Validation (New_References.unit_level) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: Check_Constraints;
180: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
181: Check_Constraints;

Line 229: app_exception.raise_exception;

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

Line 310: app_exception.raise_exception;

306: if (c1%notfound) then
307: close c1;
308: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
309: IGS_GE_MSG_STACK.ADD;
310: app_exception.raise_exception;
311: return;
312: end if;
313: close c1;
314:

Line 326: app_exception.raise_exception;

322: null;
323: else
324: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
325: IGS_GE_MSG_STACK.ADD;
326: app_exception.raise_exception;
327: end if;
328: return;
329: end LOCK_ROW;
330:

Line 360: app_exception.raise_exception;

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