APPS.IGS_PS_UNIT_CROS_REF_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 121: app_exception.raise_exception;

117: ,new_references.parent_unit_version_number
118: ) THEN
119: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
120: IGS_GE_MSG_STACK.ADD;
121: app_exception.raise_exception;
122: END IF;
123: END Check_Uniqueness ;
124: PROCEDURE Check_Parent_Existance AS
125: /*************************************************************

Line 149: App_Exception.Raise_Exception;

145: new_references.child_unit_version_number
146: ) THEN
147: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:
152: IF (((old_references.parent_unit_code = new_references.parent_unit_code) AND
153: (old_references.parent_unit_version_number = new_references.parent_unit_version_number)) OR

Line 163: App_Exception.Raise_Exception;

159: new_references.parent_unit_version_number
160: ) THEN
161: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165:
166: END Check_Parent_Existance;
167:

Line 279: App_Exception.Raise_Exception;

275: IF (cur_rowid%FOUND) THEN
276: Close cur_rowid;
277: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UCR_UV_FK');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid;
283:

Line 335: App_Exception.Raise_Exception;

331: IF Get_Pk_For_Validation(
332: new_references.unit_cross_reference_id) THEN
333: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Uniqueness;
338: Check_Constraints;
339: Check_Parent_Existance;

Line 355: App_Exception.Raise_Exception;

351: IF Get_PK_For_Validation (
352: new_references.unit_cross_reference_id) THEN
353: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: END IF;
357: Check_Uniqueness;
358: Check_Constraints;
359: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 443: app_exception.raise_exception;

439: end if;
440: else
441: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445:
446: SELECT IGS_PS_UNIT_CROS_REF_S.NEXTVAL INTO X_UNIT_CROSS_REFERENCE_ID FROM DUAL;
447:

Line 530: app_exception.raise_exception;

526: if (c1%notfound) then
527: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
528: IGS_GE_MSG_STACK.ADD;
529: close c1;
530: app_exception.raise_exception;
531: return;
532: end if;
533: close c1;
534: if ( ( tlinfo.PARENT_UNIT_CODE = X_PARENT_UNIT_CODE)

Line 543: app_exception.raise_exception;

539: null;
540: else
541: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
542: IGS_GE_MSG_STACK.ADD;
543: app_exception.raise_exception;
544: end if;
545: return;
546: end LOCK_ROW;
547: Procedure UPDATE_ROW (

Line 587: app_exception.raise_exception;

583: end if;
584: else
585: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: end if;
589: Before_DML(
590: p_action=>'UPDATE',
591: x_rowid=>X_ROWID,