APPS.IGS_EN_ORUN_WLST_PRI_PKG dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;
53:

Line 120: App_Exception.Raise_Exception;

116: new_references.org_unit_wlst_id
117: ) THEN
118: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122:
123: IF (((old_references.priority_value = new_references.priority_value)) OR
124: ((new_references.priority_value IS NULL))) THEN

Line 130: App_Exception.Raise_Exception;

126: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ('UNIT_WAITLIST',new_references.priority_value)
127: THEN
128: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132:
133: END Check_Parent_Existance;
134:

Line 221: App_Exception.Raise_Exception;

217: IF (cur_rowid%FOUND) THEN
218: Close cur_rowid;
219: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUWP_OUW_FK');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: Return;
223: END IF;
224: Close cur_rowid;
225:

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

239: IF (cur_rowid%FOUND) THEN
240: Fnd_Message.Set_Name ('IGS','IGS_EN_EWPI_LKUPV_FK');
241: IGS_GE_MSG_STACK.ADD;
242: CLOSE cur_rowid;
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;
247: END GET_FK_IGS_LOOKUPS_VIEW;

Line 296: App_Exception.Raise_Exception;

292: IF Get_Pk_For_Validation(
293: new_references.org_unit_wlst_pri_id) THEN
294: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: Check_Parent_Existance;
300: ELSIF (p_action = 'UPDATE') THEN

Line 315: App_Exception.Raise_Exception;

311: IF Get_PK_For_Validation (
312: new_references.org_unit_wlst_pri_id) THEN
313: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception;
316: END IF;
317: Check_Constraints;
318: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
319: Check_Constraints;

Line 400: app_exception.raise_exception;

396: end if;
397: else
398: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
399: IGS_GE_MSG_STACK.ADD;
400: app_exception.raise_exception;
401: end if;
402: SELECT IGS_EN_OR_UNIT_WLST_PRI_S.NEXTVAL
403: INTO x_org_unit_wlst_pri_id
404: FROM dual;

Line 481: app_exception.raise_exception;

477: if (c1%notfound) then
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: IGS_GE_MSG_STACK.ADD;
480: close c1;
481: app_exception.raise_exception;
482: return;
483: end if;
484: close c1;
485: if ( ( tlinfo.ORG_UNIT_WLST_ID = X_ORG_UNIT_WLST_ID)

Line 493: app_exception.raise_exception;

489: null;
490: else
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: return;
496: end LOCK_ROW;
497: Procedure UPDATE_ROW (

Line 536: app_exception.raise_exception;

532: end if;
533: else
534: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
535: IGS_GE_MSG_STACK.ADD;
536: app_exception.raise_exception;
537: end if;
538: Before_DML(
539: p_action=>'UPDATE',
540: x_rowid=>X_ROWID,