APPS.IGS_RU_TURIN_FNC_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_TURIN_FNC : P_ACTION INSERT, VALIDATE_INSERT : IGSUI14B.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 79: App_Exception.Raise_Exception;

75: IF upper(Column_Name) = 'PARENTHESIS_IND' OR Column_Name IS NULL THEN
76: IF new_references.parenthesis_ind NOT IN ('Y','N') THEN
77: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82: IF upper(Column_Name) = 'RUD_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
83: IF new_references.rud_sequence_number < 1 OR new_references.rud_sequence_number > 999999 THEN

Line 86: App_Exception.Raise_Exception;

82: IF upper(Column_Name) = 'RUD_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
83: IF new_references.rud_sequence_number < 1 OR new_references.rud_sequence_number > 999999 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: END Check_Constraints;

Line 105: App_Exception.Raise_Exception;

101: ) THEN
102: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
103: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION Check_Parent_Existance rud_sequence_number : IGSUI14B.PLS');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:
109: END Check_Parent_Existance;

Line 169: App_Exception.Raise_Exception;

165: IF (cur_rowid%FOUND) THEN
166: Close cur_rowid;
167: Fnd_Message.Set_Name ('IGS', 'IGS_RU_STF_RUD_FK');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: Return;
171: END IF;
172: Close cur_rowid;
173:

Line 209: App_Exception.Raise_Exception;

205: new_references.s_turin_function
206: ) THEN
207: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END IF;
211: Check_Constraints;
212: Check_Parent_Existance;
213: ELSIF (p_action = 'UPDATE') THEN

Line 224: App_Exception.Raise_Exception;

220: new_references.s_turin_function
221: ) THEN
222: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226: Check_Constraints;
227: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
228: Check_Constraints;

Line 275: app_exception.raise_exception;

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

Line 345: app_exception.raise_exception;

341: if (c1%notfound) then
342: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
343: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW : IGSUI14B.PLS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: close c1;
347: return;
348: end if;
349: close c1;

Line 361: app_exception.raise_exception;

357: else
358: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
359: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI14B.PLS');
360: IGS_GE_MSG_STACK.ADD;
361: app_exception.raise_exception;
362: end if;
363: return;
364: end LOCK_ROW;
365:

Line 393: app_exception.raise_exception;

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