APPS.IGS_PS_USEC_RPT_FMLY_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: IF (((old_references.repeat_family_unit_cd = new_references.repeat_family_unit_cd) AND
147: (old_references.repeat_family_version_number = new_references.repeat_family_version_number)) OR

Line 157: App_Exception.Raise_Exception;

153: new_references.repeat_family_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_USRF_UOO_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_USRF_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_section_repeat_family_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_section_repeat_family_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 467: app_exception.raise_exception;

463: end if;
464: else
465: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469: select igs_ps_usec_rpt_fmly_s.nextval into x_unit_section_rpt_family_id from dual;
470: Before_DML(
471: p_action=>'INSERT',

Line 546: app_exception.raise_exception;

542: if (c1%notfound) then
543: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
544: IGS_GE_MSG_STACK.ADD;
545: close c1;
546: app_exception.raise_exception;
547: return;
548: end if;
549: close c1;
550: if ( ( tlinfo.UOO_ID = X_UOO_ID)

Line 558: app_exception.raise_exception;

554: null;
555: else
556: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
557: IGS_GE_MSG_STACK.ADD;
558: app_exception.raise_exception;
559: end if;
560: return;
561: end LOCK_ROW;
562: Procedure UPDATE_ROW (

Line 601: app_exception.raise_exception;

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