DBA Data[Home] [Help]

APPS.IGS_PS_USEC_X_UNITS_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 118: app_exception.raise_exception;

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

Line 143: App_Exception.Raise_Exception;

139: new_references.uoo_id
140: ) THEN
141: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145:
146: END Check_Parent_Existance;
147:

Line 253: App_Exception.Raise_Exception;

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

Line 307: App_Exception.Raise_Exception;

303: IF Get_Pk_For_Validation(
304: new_references.unit_sec_cross_units_id) THEN
305: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: Check_Uniqueness;
310: Check_Constraints;
311: Check_Parent_Existance;

Line 327: App_Exception.Raise_Exception;

323: IF Get_PK_For_Validation (
324: new_references.unit_sec_cross_units_id) THEN
325: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: Check_Uniqueness;
330: Check_Constraints;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 414: app_exception.raise_exception;

410: end if;
411: else
412: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: end if;
416: SELECT
417: IGS_PS_USEC_X_UNITS_S.NextVal
418: INTO

Line 498: app_exception.raise_exception;

494: if (c1%notfound) then
495: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
496: IGS_GE_MSG_STACK.ADD;
497: close c1;
498: app_exception.raise_exception;
499: return;
500: end if;
501: close c1;
502: if ( ( tlinfo.UOO_ID = X_UOO_ID)

Line 510: app_exception.raise_exception;

506: null;
507: else
508: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
509: IGS_GE_MSG_STACK.ADD;
510: app_exception.raise_exception;
511: end if;
512: return;
513: end LOCK_ROW;
514: Procedure UPDATE_ROW (

Line 553: app_exception.raise_exception;

549: end if;
550: else
551: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: end if;
555: Before_DML(
556: p_action=>'UPDATE',
557: x_rowid=>X_ROWID,