APPS.IGS_AD_UP_DETAIL_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 104: App_Exception.Raise_Exception;

100: Column_Name IS NULL THEN
101: IF NOT (new_references.closed_ind in ('Y','N')) THEN
102: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107:
108:

Line 130: app_exception.raise_exception;

126: ,new_references.version_number
127: ) THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
129: IGS_GE_MSG_STACK.ADD;
130: app_exception.raise_exception;
131: END IF;
132: END Check_Uniqueness ;
133:
134:

Line 157: App_Exception.Raise_Exception;

153: new_references.up_header_id
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: IF (((old_references.unit_cd = new_references.unit_cd) AND
161: (old_references.version_number = new_references.version_number)) OR

Line 171: App_Exception.Raise_Exception;

167: new_references.version_number
168: ) THEN
169: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173:
174: END Check_Parent_Existance;
175:

Line 287: App_Exception.Raise_Exception;

283: IF (cur_rowid%FOUND) THEN
284: Close cur_rowid;
285: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUD_AUH_FK');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: Return;
289: END IF;
290: Close cur_rowid;
291:

Line 326: App_Exception.Raise_Exception;

322: IF (cur_rowid%FOUND) THEN
323: Close cur_rowid;
324: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUD_UV_FK');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: Return;
328: END IF;
329: Close cur_rowid;
330:

Line 382: App_Exception.Raise_Exception;

378: IF Get_Pk_For_Validation(
379: new_references.up_detail_id) THEN
380: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception;
383: END IF;
384: Check_Constraints;
385: Check_Uniqueness;
386: Check_Parent_Existance;

Line 402: App_Exception.Raise_Exception;

398: IF Get_PK_For_Validation (
399: new_references.up_detail_id) THEN
400: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
401: IGS_GE_MSG_STACK.ADD;
402: App_Exception.Raise_Exception;
403: END IF;
404: Check_Constraints;
405: Check_Uniqueness;
406: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 491: app_exception.raise_exception;

487: end if;
488: else
489: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
490: IGS_GE_MSG_STACK.ADD;
491: app_exception.raise_exception;
492: end if;
493:
494: X_UP_DETAIL_ID := -1;
495: Before_DML(

Line 576: app_exception.raise_exception;

572: if (c1%notfound) then
573: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
574: IGS_GE_MSG_STACK.ADD;
575: close c1;
576: app_exception.raise_exception;
577: return;
578: end if;
579: close c1;
580: if ( ( tlinfo.UP_HEADER_ID = X_UP_HEADER_ID)

Line 589: app_exception.raise_exception;

585: null;
586: else
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: IGS_GE_MSG_STACK.ADD;
589: app_exception.raise_exception;
590: end if;
591: return;
592: end LOCK_ROW;
593: Procedure UPDATE_ROW (

Line 633: app_exception.raise_exception;

629: end if;
630: else
631: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
632: IGS_GE_MSG_STACK.ADD;
633: app_exception.raise_exception;
634: end if;
635: Before_DML(
636: p_action=>'UPDATE',
637: x_rowid=>X_ROWID,