APPS.IGS_PS_UNIT_INT_LVL_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 148: App_Exception.Raise_Exception;

144: IF Upper(Column_Name)='WEFTSU_FACTOR' OR Column_Name IS NULL Then
145: IF New_References.weftsu_factor < 0 AND New_References.weftsu_factor > 1.80 Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then

Line 156: App_Exception.Raise_Exception;

152: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
153: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:
160:

Line 165: App_Exception.Raise_Exception;

161: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then
162: IF New_References.Unit_Int_Course_Level_Cd <> UPPER(New_References.Unit_Int_Course_Level_Cd) Then
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168:
169: END Check_Constraints;

Line 245: App_Exception.Raise_Exception;

241: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
242: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd) THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: Check_Constraints;
248: ELSIF (p_action = 'UPDATE') THEN
249: -- Call all the procedures related to Before Update.

Line 260: App_Exception.Raise_Exception;

256: ELSIF (p_action = 'VALIDATE_INSERT') THEN
257: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: Check_Constraints;
263: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
264: Check_Constraints;

Line 312: app_exception.raise_exception;

308: end if;
309: else
310: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
311: IGS_GE_MSG_STACK.ADD;
312: app_exception.raise_exception;
313: end if;
314:
315: Before_DML(
316: p_action => 'INSERT',

Line 388: app_exception.raise_exception;

384: if (c1%notfound) then
385: close c1;
386: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
387: IGS_GE_MSG_STACK.ADD;
388: app_exception.raise_exception;
389: return;
390: end if;
391: close c1;
392:

Line 401: app_exception.raise_exception;

397: null;
398: else
399: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
400: IGS_GE_MSG_STACK.ADD;
401: app_exception.raise_exception;
402: end if;
403: return;
404: end LOCK_ROW;
405:

Line 434: app_exception.raise_exception;

430: end if;
431: else
432: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: end if;
436:
437: Before_DML(
438: p_action => 'UPDATE',