APPS.IGS_PS_UNIT_FACILITY_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.unit_version_number
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.media_code
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: IF (((old_references.unit_code = new_references.unit_code) AND
147: (old_references.unit_version_number = new_references.unit_version_number)) OR

Line 157: App_Exception.Raise_Exception;

153: new_references.unit_version_number
154: ) THEN
155: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159:
160: END Check_Parent_Existance;
161:

Line 267: App_Exception.Raise_Exception;

263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UF_ME_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;
271:

Line 306: App_Exception.Raise_Exception;

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

Line 360: App_Exception.Raise_Exception;

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

Line 380: App_Exception.Raise_Exception;

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

Line 471: app_exception.raise_exception;

467: end if;
468: else
469: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
470: IGS_GE_MSG_STACK.ADD;
471: app_exception.raise_exception;
472: end if;
473: Select IGS_PS_UNIT_FACILITY_S.NEXTVAL into x_unit_media_id from dual;
474: Before_DML(
475: 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.UNIT_CODE = X_UNIT_CODE)

Line 562: app_exception.raise_exception;

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

Line 605: app_exception.raise_exception;

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