DBA Data[Home] [Help]

APPS.IGS_PE_DELIVERY_CDS_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 99: App_Exception.Raise_Exception;

95: If UPPER(column_name) = 'CLOSED_IND' or column_name is null THEN
96: if NEW_REFERENCES.CLOSED_IND not in ( 'Y' , 'N' ) THEN
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: end if;
101: end if;
102:
103:

Line 189: App_Exception.Raise_Exception;

185: IF Get_Pk_For_Validation(
186: new_references.delivery_code) THEN
187: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: Check_Constraints;
192: ELSIF (p_action = 'UPDATE') THEN
193: -- Call all the procedures related to Before Update.

Line 205: App_Exception.Raise_Exception;

201: IF Get_PK_For_Validation (
202: new_references.delivery_code) THEN
203: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: Check_Constraints;
208: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
209: Check_Constraints;

Line 288: app_exception.raise_exception;

284: end if;
285: else
286: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
287: IGS_GE_MSG_STACK.ADD;
288: app_exception.raise_exception;
289: end if;
290: Before_DML(
291: p_action=>'INSERT',
292: x_rowid=>X_ROWID,

Line 366: app_exception.raise_exception;

362: if (c1%notfound) then
363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
364: IGS_GE_MSG_STACK.ADD;
365: close c1;
366: app_exception.raise_exception;
367: return;
368: end if;
369: close c1;
370: if ( ( tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 377: app_exception.raise_exception;

373: null;
374: else
375: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
376: IGS_GE_MSG_STACK.ADD;
377: app_exception.raise_exception;
378: end if;
379: return;
380: end LOCK_ROW;
381: Procedure UPDATE_ROW (

Line 419: app_exception.raise_exception;

415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421: Before_DML(
422: p_action=>'UPDATE',
423: x_rowid=>X_ROWID,