DBA Data[Home] [Help]

APPS.IGS_AD_TSTSCR_USED_PKG dependencies on APP_EXCEPTION

Line 72: App_Exception.Raise_Exception;

68: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
69: Close cur_old_ref_values;
70: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception;
73: Return;
74: END IF;
75: Close cur_old_ref_values;
76:

Line 175: App_Exception.Raise_Exception;

171: new_references.sequence_number
172: ) THEN
173: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177:
178: END Check_Parent_Existance;
179:

Line 252: App_Exception.Raise_Exception;

248: IF (cur_rowid%FOUND) THEN
249: Close cur_rowid;
250: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATV_ACAI_FK');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: Return;
254: END IF;
255: Close cur_rowid;
256:

Line 359: App_Exception.Raise_Exception;

355: IF Get_Pk_For_Validation(
356: new_references.tstscr_used_id) THEN
357: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
358: IGS_GE_MSG_STACK.ADD;
359: App_Exception.Raise_Exception;
360: END IF;
361: Check_Constraints;
362: Check_Parent_Existance;
363: ELSIF (p_action = 'UPDATE') THEN

Line 377: App_Exception.Raise_Exception;

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

Line 485: app_exception.raise_exception;

481: end if;
482: else
483: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487:
488: X_TSTSCR_USED_ID := -1;
489: Before_DML(

Line 680: app_exception.raise_exception;

676: if (c1%notfound) then
677: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
678: IGS_GE_MSG_STACK.ADD;
679: close c1;
680: app_exception.raise_exception;
681: return;
682: end if;
683: close c1;
684: if ( ( tlinfo.COMMENTS = X_COMMENTS)

Line 757: app_exception.raise_exception;

753: null;
754: else
755: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
756: IGS_GE_MSG_STACK.ADD;
757: app_exception.raise_exception;
758: end if;
759: return;
760: end LOCK_ROW;
761: Procedure UPDATE_ROW (

Line 823: app_exception.raise_exception;

819: end if;
820: else
821: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
822: IGS_GE_MSG_STACK.ADD;
823: app_exception.raise_exception;
824: end if;
825: Before_DML(
826: p_action=>'UPDATE',
827: x_rowid=>X_ROWID,