APPS.IGS_RU_SET_MEMBER_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_RU_GEN_006.SET_TOKEN('IGS_RU_SET_MEMBER : P_ACTION INSERT, VALIDATE_INSERT : IGSUI13B.PLS');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 80: App_Exception.Raise_Exception;

76: IF upper(Column_Name) = 'UNIT_CD' OR Column_Name IS NULL THEN
77: IF new_references.unit_cd <> UPPER(new_references.unit_cd) THEN
78: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF upper(Column_Name) = 'VERSIONS' OR Column_Name IS NULL THEN
84: IF new_references.versions <> UPPER(new_references.versions) THEN

Line 87: App_Exception.Raise_Exception;

83: IF upper(Column_Name) = 'VERSIONS' OR Column_Name IS NULL THEN
84: IF new_references.versions <> UPPER(new_references.versions) THEN
85: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: IF upper(Column_Name) = 'RS_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
91: IF new_references.rs_sequence_number < 0 OR new_references.rs_sequence_number > 999999 THEN

Line 94: App_Exception.Raise_Exception;

90: IF upper(Column_Name) = 'RS_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
91: IF new_references.rs_sequence_number < 0 OR new_references.rs_sequence_number > 999999 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: END Check_Constraints;

Line 113: App_Exception.Raise_Exception;

109: ) THEN
110: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
111: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_SET : P_ACTION Check_Parent_Existance rs_sequence_number : IGSUI13B.PLS');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116:
117: END Check_Parent_Existance;

Line 166: App_Exception.Raise_Exception;

162: IF (cur_rowid%FOUND) THEN
163: Close cur_rowid;
164: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RSM_RUS_FK');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: Return;
168: END IF;
169: Close cur_rowid;
170:

Line 265: app_exception.raise_exception;

261: end if;
262: else
263: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
264: IGS_GE_MSG_STACK.ADD;
265: app_exception.raise_exception;
266: end if;
267:
268: Before_DML(
269: p_action=>'INSERT',

Line 334: app_exception.raise_exception;

330: if (c1%notfound) then
331: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
332: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_SET_MEMBER : P_ACTION LOCK_ROW : IGSUI13B.PLS');
333: IGS_GE_MSG_STACK.ADD;
334: app_exception.raise_exception;
335: close c1;
336: return;
337: end if;
338: close c1;

Line 349: app_exception.raise_exception;

345: else
346: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
347: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_SET_MEMBER : P_ACTION LOCK_ROW FORM_RECORD_CHANGED: IGSUI13B.PLS');
348: IGS_GE_MSG_STACK.ADD;
349: app_exception.raise_exception;
350: end if;
351: return;
352: end LOCK_ROW;
353:

Line 381: app_exception.raise_exception;

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