APPS.IGS_PS_UNIT_OFR_NOTE_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 84: App_Exception.Raise_Exception;

80: IF Upper(Column_Name)='CAL_TYPE' OR Column_Name IS NULL Then
81: IF New_References.Cal_Type <> UPPER(New_References.Cal_Type) Then
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87:
88: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then

Line 92: App_Exception.Raise_Exception;

88: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then
89: IF New_References.Crs_Note_Type <> UPPER(New_References.Crs_Note_Type) Then
90: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:
96:

Line 101: App_Exception.Raise_Exception;

97: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
98: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105: END Check_Constraints;

Line 119: App_Exception.Raise_Exception;

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

Line 132: App_Exception.Raise_Exception;

128: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
129: new_references.reference_number) THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134:
135: END IF;
136:

Line 151: App_Exception.Raise_Exception;

147: new_references.version_number,
148: new_references.cal_type) THEN
149: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
154: END IF;
155:

Line 209: App_Exception.Raise_Exception;

205: IF (cur_rowid%FOUND) THEN
206: Close cur_rowid;
207: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UON_CNT_FK');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: Return;
211: END IF;
212: Close cur_rowid;
213:

Line 235: App_Exception.Raise_Exception;

231: IF (cur_rowid%FOUND) THEN
232: Close cur_rowid;
233: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UON_NOTE_FK');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: Return;
237: END IF;
238: Close cur_rowid;
239:

Line 265: App_Exception.Raise_Exception;

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

Line 311: App_Exception.Raise_Exception;

307: New_References.cal_type,
308: New_References.reference_number) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: Check_Constraints;
314: Check_Parent_Existance;
315: ELSIF (p_action = 'UPDATE') THEN

Line 327: App_Exception.Raise_Exception;

323: New_References.cal_type,
324: New_References.reference_number) THEN
325: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: Check_Constraints;
330: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
331: Check_Constraints;

Line 382: app_exception.raise_exception;

378: end if;
379: else
380: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
381: IGS_GE_MSG_STACK.ADD;
382: app_exception.raise_exception;
383: end if;
384:
385: Before_DML(
386: p_action => 'INSERT',

Line 459: app_exception.raise_exception;

455: if (c1%notfound) then
456: close c1;
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: return;
461: end if;
462: close c1;
463:

Line 470: app_exception.raise_exception;

466: null;
467: else
468: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
469: IGS_GE_MSG_STACK.ADD;
470: app_exception.raise_exception;
471: end if;
472: return;
473: end LOCK_ROW;
474:

Line 504: app_exception.raise_exception;

500: end if;
501: else
502: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506:
507: Before_DML(
508: p_action => 'UPDATE',