APPS.IGS_EN_UNIT_SET_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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: Close cur_old_ref_values;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 86: App_Exception.Raise_Exception;

82: IF ((UPPER (column_name) = 'CRS_NOTE_TYPE') OR (column_name IS NULL)) THEN
83: IF (new_references.crs_note_type <> UPPER (new_references.crs_note_type)) THEN
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:
90: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN

Line 94: App_Exception.Raise_Exception;

90: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
91: IF (new_references.unit_set_cd <> UPPER (new_references.unit_set_cd)) THEN
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98:

Line 113: App_Exception.Raise_Exception;

109: new_references.crs_note_type
110: ) THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114:
115: END IF;
116:
117:

Line 130: App_Exception.Raise_Exception;

126: ) THEN
127:
128: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131:
132: END IF;
133:
134: END IF;

Line 148: App_Exception.Raise_Exception;

144: new_references.version_number
145: ) THEN
146: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149:
150: END IF;
151:
152: END IF;

Line 205: App_Exception.Raise_Exception;

201: IF (cur_rowid%FOUND) THEN
202: Fnd_Message.Set_Name ('IGS', 'IGS_EN_CNT_USN_FK');
203: IGS_GE_MSG_STACK.ADD;
204: Close cur_rowid;
205: App_Exception.Raise_Exception;
206: Return;
207: END IF;
208: Close cur_rowid;
209:

Line 231: App_Exception.Raise_Exception;

227: IF (cur_rowid%FOUND) THEN
228: Fnd_Message.Set_Name ('IGS', 'IGS_EN_USN_NOTE_FK');
229: IGS_GE_MSG_STACK.ADD;
230: Close cur_rowid;
231: App_Exception.Raise_Exception;
232: Return;
233: END IF;
234: Close cur_rowid;
235:

Line 259: App_Exception.Raise_Exception;

255: IF (cur_rowid%FOUND) THEN
256: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USN_FK');
257: IGS_GE_MSG_STACK.ADD;
258: Close cur_rowid;
259: App_Exception.Raise_Exception;
260: Return;
261: END IF;
262: Close cur_rowid;
263:

Line 305: App_Exception.Raise_Exception;

301: ) THEN
302:
303: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306:
307: END IF;
308: Check_Constraints;
309: Check_Parent_Existance;

Line 325: App_Exception.Raise_Exception;

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

Line 391: app_exception.raise_exception;

387: end if;
388: else
389: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
390: IGS_GE_MSG_STACK.ADD;
391: app_exception.raise_exception;
392: end if;
393:
394: Before_DML(
395: p_action => 'INSERT' ,

Line 466: app_exception.raise_exception;

462: if (c1%notfound) then
463: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
464: IGS_GE_MSG_STACK.ADD;
465: close c1;
466: app_exception.raise_exception;
467: return;
468: end if;
469: close c1;
470:

Line 477: app_exception.raise_exception;

473: null;
474: else
475: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
476: IGS_GE_MSG_STACK.ADD;
477: app_exception.raise_exception;
478: end if;
479: return;
480: end LOCK_ROW;
481:

Line 510: app_exception.raise_exception;

506: end if;
507: else
508: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: app_exception.raise_exception;
511: end if;
512:
513: Before_DML(
514: p_action => 'UPDATE' ,