APPS.IGS_PS_UNIT_VER_NOTE_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
35: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 79: App_Exception.Raise_Exception;

75: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then
76: IF New_References.Crs_Note_Type <> UPPER(New_References.Crs_Note_Type) Then
77: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82:
83:

Line 88: App_Exception.Raise_Exception;

84: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
85: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91:
92: END Check_Constraints;

Line 105: App_Exception.Raise_Exception;

101: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
102: new_references.crs_note_type) THEN
103: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107:
108: END IF;
109:

Line 118: App_Exception.Raise_Exception;

114: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
115: new_references.reference_number) THEN
116: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120:
121:
122: END IF;

Line 135: App_Exception.Raise_Exception;

131: new_references.unit_cd,
132: new_references.version_number) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137:
138:
139: END IF;

Line 192: App_Exception.Raise_Exception;

188: IF (cur_rowid%FOUND) THEN
189: Close cur_rowid;
190: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_CNT_FK');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: Return;
194: END IF;
195: Close cur_rowid;
196:

Line 218: App_Exception.Raise_Exception;

214: IF (cur_rowid%FOUND) THEN
215: Close cur_rowid;
216: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_NOTE_FK');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;
221: Close cur_rowid;
222:

Line 246: App_Exception.Raise_Exception;

242: IF (cur_rowid%FOUND) THEN
243: Close cur_rowid;
244: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVN_UV_FK');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: Return;
248: END IF;
249: Close cur_rowid;
250:

Line 289: App_Exception.Raise_Exception;

285: New_References.version_number,
286: New_References.reference_number) THEN
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: Check_Constraints;
292: Check_Parent_Existance;
293: ELSIF (p_action = 'UPDATE') THEN

Line 304: App_Exception.Raise_Exception;

300: New_References.version_number,
301: New_References.reference_number) THEN
302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: Check_Constraints;
307: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
308: Check_Constraints;

Line 357: app_exception.raise_exception;

353: end if;
354: else
355: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
356: IGS_GE_MSG_STACK.ADD;
357: app_exception.raise_exception;
358: end if;
359:
360: Before_DML(
361: p_action => 'INSERT',

Line 430: app_exception.raise_exception;

426: if (c1%notfound) then
427: close c1;
428: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: return;
432: end if;
433: close c1;
434:

Line 441: app_exception.raise_exception;

437: null;
438: else
439: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: end if;
443: return;
444: end LOCK_ROW;
445:

Line 474: app_exception.raise_exception;

470: end if;
471: else
472: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
473: IGS_GE_MSG_STACK.ADD;
474: app_exception.raise_exception;
475: end if;
476: Before_DML(
477: p_action => 'UPDATE',
478: x_rowid => X_ROWID,