APPS.IGS_GE_REF_CD_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: ,new_references.reference_cd
116: ) THEN
117: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
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 144: App_Exception.Raise_Exception;

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

Line 306: App_Exception.Raise_Exception;

302: IF (cur_rowid%FOUND) THEN
303: Close cur_rowid;
304: Fnd_Message.Set_Name ('IGS', 'IGS_PS_RC_RCT_FK');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: Return;
308: END IF;
309: Close cur_rowid;
310:

Line 362: App_Exception.Raise_Exception;

358: IF Get_Pk_For_Validation(
359: new_references.reference_code_id) THEN
360: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception;
363: END IF;
364: Check_Uniqueness;
365: Check_Constraints;
366: Check_Parent_Existance;

Line 383: App_Exception.Raise_Exception;

379: IF Get_PK_For_Validation (
380: new_references.reference_code_id) THEN
381: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
382: IGS_GE_MSG_STACK.ADD;
383: App_Exception.Raise_Exception;
384: END IF;
385: Check_Uniqueness;
386: Check_Constraints;
387: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 475: app_exception.raise_exception;

471: end if;
472: else
473: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477: SELECT IGS_GE_REF_CD_S.NEXTVAL
478: INTO X_REFERENCE_CODE_ID FROM Dual;
479: Before_DML(

Line 560: app_exception.raise_exception;

556: if (c1%notfound) then
557: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
558: IGS_GE_MSG_STACK.ADD;
559: close c1;
560: app_exception.raise_exception;
561: return;
562: end if;
563: close c1;
564: if ( ( tlinfo.REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE)

Line 573: app_exception.raise_exception;

569: null;
570: else
571: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
572: IGS_GE_MSG_STACK.ADD;
573: app_exception.raise_exception;
574: end if;
575: return;
576: end LOCK_ROW;
577: Procedure UPDATE_ROW (

Line 617: app_exception.raise_exception;

613: end if;
614: else
615: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
616: IGS_GE_MSG_STACK.ADD;
617: app_exception.raise_exception;
618: end if;
619: Before_DML(
620: p_action=>'UPDATE',
621: x_rowid=>X_ROWID,