APPS.IGS_PS_UNT_INLV_HIST_PKG dependencies on APP_EXCEPTION

Line 44: App_Exception.Raise_Exception;

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

Line 90: App_Exception.Raise_Exception;

86: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
87: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
88: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93:
94: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then

Line 98: App_Exception.Raise_Exception;

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

Line 175: App_Exception.Raise_Exception;

171: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd,
172: New_References.hist_start_dt) THEN
173: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: Check_Constraints;
178: ELSIF (p_action = 'UPDATE') THEN
179: -- Call all the procedures related to Before Update.

Line 187: App_Exception.Raise_Exception;

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

Line 245: app_exception.raise_exception;

241: end if;
242: else
243: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
244: IGS_GE_MSG_STACK.ADD;
245: app_exception.raise_exception;
246: end if;
247:
248: Before_DML(
249: p_action => 'INSERT',

Line 338: app_exception.raise_exception;

334: if (c1%notfound) then
335: close c1;
336: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: return;
340: end if;
341: close c1;
342:

Line 359: app_exception.raise_exception;

355: null;
356: else
357: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
358: IGS_GE_MSG_STACK.ADD;
359: app_exception.raise_exception;
360: end if;
361: return;
362: end LOCK_ROW;
363:

Line 395: app_exception.raise_exception;

391: end if;
392: else
393: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
394: IGS_GE_MSG_STACK.ADD;
395: app_exception.raise_exception;
396: end if;
397: Before_DML(
398: p_action => 'UPDATE',
399: x_rowid => X_ROWID,