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

Line 83: App_Exception.Raise_Exception;

79: IF ((UPPER (column_name) = 'PACKAGE_ITEM_ID') OR (column_name IS NULL)) THEN
80: IF (new_references.package_item_id <> UPPER (new_references.package_item_id)) THEN
81: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86:
87: IF ((UPPER (column_name) = 'PUBLISH_SS_IND') OR (column_name IS NULL)) THEN

Line 91: App_Exception.Raise_Exception;

87: IF ((UPPER (column_name) = 'PUBLISH_SS_IND') OR (column_name IS NULL)) THEN
88: IF new_references.publish_ss_ind NOT IN ( 'Y' , 'N' ) THEN
89: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
94:
95:

Line 119: App_Exception.Raise_Exception;

115: CLOSE c_ams_deliverables;
116: IF c_ams_deliverables%NOTFOUND 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: END IF;
122: END;
123: END check_parent_existance;

Line 186: App_Exception.Raise_Exception;

182: IF (cur_rowid%FOUND) THEN
183: Fnd_Message.Set_Name ('IGS', 'IGS_IN_EPI_AM_FK');
184: IGS_GE_MSG_STACK.ADD;
185: Close cur_rowid;
186: App_Exception.Raise_Exception;
187: Return;
188: END IF;
189: Close cur_rowid;
190:

Line 222: App_Exception.Raise_Exception;

218: -- Call all the procedures related to Before Insert.
219: IF get_pk_for_validation(new_references.package_item_id) THEN
220: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224:
225: Check_Constraints;
226: ELSIF (p_action = 'UPDATE') THEN

Line 237: App_Exception.Raise_Exception;

233: ELSIF (p_action = 'VALIDATE_INSERT') THEN
234: IF get_pk_for_validation (new_references.package_item_id) THEN
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: check_constraints;
240: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
241: check_constraints;

Line 276: app_exception.raise_exception;

272: end if;
273: else
274: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
275: IGS_GE_MSG_STACK.ADD;
276: app_exception.raise_exception;
277: end if;
278:
279: Before_DML(
280: p_action=>'INSERT',

Line 337: app_exception.raise_exception;

333: IF (c1%NOTFOUND) THEN
334: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
335: IGS_GE_MSG_STACK.ADD;
336: CLOSE c1;
337: app_exception.raise_exception;
338: RETURN;
339: END IF;
340: CLOSE c1;
341:

Line 351: app_exception.raise_exception;

347: NULL;
348: ELSE
349: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
350: IGS_GE_MSG_STACK.ADD;
351: app_exception.raise_exception;
352: END IF;
353: RETURN;
354: END lock_row;
355:

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=>'UPDATE',