APPS.IGS_EN_INST_WLST_OPT_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

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

Line 119: app_exception.raise_exception;

115:
116: ) THEN
117: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
118: IGS_GE_MSG_STACK.ADD;
119: app_exception.raise_exception;
120: END IF;
121: END Check_Uniqueness ;
122: PROCEDURE Check_Parent_Existance AS
123: /*************************************************************

Line 147: App_Exception.Raise_Exception;

143:
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: END Check_Parent_Existance;
151:

Line 257: App_Exception.Raise_Exception;

253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUW_OU_FK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid;
261:

Line 300: App_Exception.Raise_Exception;

296: IF (cur_rowid%FOUND) THEN
297: Close cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUW_OU_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: Return;
302: END IF;
303: Close cur_rowid; */
304: BEGIN

Line 358: App_Exception.Raise_Exception;

354: IF Get_Pk_For_Validation(
355: new_references.inst_waitlist_id) THEN
356: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360: Check_Uniqueness;
361: Check_Constraints;
362: Check_Parent_Existance;

Line 378: App_Exception.Raise_Exception;

374: IF Get_PK_For_Validation (
375: new_references.inst_waitlist_id) THEN
376: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Uniqueness;
381: Check_Constraints;
382: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 466: app_exception.raise_exception;

462: end if;
463: else
464: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468: select IGS_EN_INST_WLST_OPT_S.nextval into x_inst_waitlist_id from dual;
469: Before_DML(
470: p_action=>'INSERT',

Line 550: app_exception.raise_exception;

546: if (c1%notfound) then
547: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
548: IGS_GE_MSG_STACK.ADD;
549: close c1;
550: app_exception.raise_exception;
551: return;
552: end if;
553: close c1;
554: if ( ( tlinfo.CAL_TYPE = X_CAL_TYPE)

Line 563: app_exception.raise_exception;

559: null;
560: else
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: IGS_GE_MSG_STACK.ADD;
563: app_exception.raise_exception;
564: end if;
565: return;
566: end LOCK_ROW;
567: Procedure UPDATE_ROW (

Line 606: app_exception.raise_exception;

602: end if;
603: else
604: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
605: IGS_GE_MSG_STACK.ADD;
606: app_exception.raise_exception;
607: end if;
608: Before_DML(
609: p_action=>'UPDATE',
610: x_rowid=>X_ROWID,