APPS.IGS_RU_SET_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 74: App_Exception.Raise_Exception;

70: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
71: IF new_references.sequence_number < 0 OR new_references.sequence_number > 999999 THEN
72: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: END IF;
77: END Check_Constraints;
78:

Line 150: App_Exception.Raise_Exception;

146: new_references.sequence_number
147: ) THEN
148: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: Check_Constraints;
153: ELSIF (p_action = 'UPDATE') THEN
154: Check_Constraints;

Line 163: App_Exception.Raise_Exception;

159: new_references.sequence_number
160: ) THEN
161: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: Check_Constraints;
166: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
167: Check_Constraints;

Line 223: app_exception.raise_exception;

219: end if;
220: else
221: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
222: IGS_GE_MSG_STACK.ADD;
223: app_exception.raise_exception;
224: end if;
225:
226: Before_DML(
227: p_action=>'INSERT',

Line 260: App_Exception.Raise_Exception ;

256: IF (l_sequence_number > 499999) THEN
257: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
258: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_SET : Sequence_number > 499999 : IGSUI12B.PLS');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception ;
261: END IF;
262: ELSE
263: l_sequence_number := NEW_REFERENCES.SEQUENCE_NUMBER;
264: END IF;

Line 316: app_exception.raise_exception;

312: if (c1%notfound) then
313: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
314: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_SET : P_ACTION LOCK_ROW : IGSUI12B.PLS');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: close c1;
318: return;
319: end if;
320: close c1;

Line 329: app_exception.raise_exception;

325: else
326: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
327: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_SET : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI12B.PLS');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331: return;
332: end LOCK_ROW;
333:

Line 360: app_exception.raise_exception;

356: end if;
357: else
358: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362:
363: Before_DML(
364: p_action=>'UPDATE',