APPS.IGS_AD_ROOM_PKG dependencies on APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

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

Line 111: App_Exception.Raise_Exception;

107: Column_Name IS NULL THEN
108: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:
115:

Line 137: app_exception.raise_exception;

133: ,new_references.room_cd
134: ) THEN
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
136: IGS_GE_MSG_STACK.ADD;
137: app_exception.raise_exception;
138: END IF;
139: END Check_Uniqueness ;
140: PROCEDURE Check_Parent_Existance AS
141: /*************************************************************

Line 162: App_Exception.Raise_Exception;

158: new_references.building_id ,
159: 'N') THEN
160: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: if not IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ( 'PRIMARY_USE',
165: new_references.primary_use_cd ) THEN
166: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

Line 168: App_Exception.Raise_Exception;

164: if not IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ( 'PRIMARY_USE',
165: new_references.primary_use_cd ) THEN
166: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:
171:
172: END Check_Parent_Existance;

Line 318: App_Exception.Raise_Exception;

314: IF (cur_rowid%FOUND) THEN
315: Close cur_rowid;
316: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ROOM_BLDG_FK');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: Return;
320: END IF;
321: Close cur_rowid;
322:

Line 381: App_Exception.Raise_Exception;

377: IF Get_Pk_For_Validation(
378: new_references.room_id) THEN
379: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: END IF;
383: Check_Uniqueness;
384: Check_Constraints;
385: Check_Parent_Existance;

Line 402: App_Exception.Raise_Exception;

398: IF Get_PK_For_Validation (
399: new_references.room_id) THEN
400: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
401: IGS_GE_MSG_STACK.ADD;
402: App_Exception.Raise_Exception;
403: END IF;
404: Check_Uniqueness;
405: Check_Constraints;
406: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 496: app_exception.raise_exception;

492: end if;
493: else
494: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
495: IGS_GE_MSG_STACK.ADD;
496: app_exception.raise_exception;
497: end if;
498:
499: x_ROOM_ID := -1;
500: Before_DML(

Line 595: app_exception.raise_exception;

591: if (c1%notfound) then
592: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
593: IGS_GE_MSG_STACK.ADD;
594: close c1;
595: app_exception.raise_exception;
596: return;
597: end if;
598: close c1;
599: if ( ( tlinfo.BUILDING_ID = X_BUILDING_ID)

Line 610: app_exception.raise_exception;

606: null;
607: else
608: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: end if;
612: return;
613: end LOCK_ROW;
614: Procedure UPDATE_ROW (

Line 657: app_exception.raise_exception;

653: end if;
654: else
655: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: end if;
659: Before_DML(
660: p_action=>'UPDATE',
661: x_rowid=>X_ROWID,