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

Line 80: -- App_Exception.Raise_Exception;

76: -- IF upper(Column_name) = 'DESCRIPTION' OR column_name is null then
77: -- IF new_references.description <> UPPER(new_references.description ) 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) = 'SEQUENCE_NUMBER' OR column_name is null then
84: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 then

Line 87: App_Exception.Raise_Exception;

83: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR column_name is null then
84: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 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: END Check_Constraints;
91:

Line 156: App_Exception.Raise_Exception;

152: new_references.sequence_number
153: )THEN
154: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF ;
158: Check_Constraints;
159: ELSIF (p_action = 'UPDATE') THEN
160: -- Call all the procedures related to Before Update.

Line 171: App_Exception.Raise_Exception;

167: new_references.sequence_number
168: )THEN
169: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF ;
173: Check_Constraints;
174: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
175: Check_Constraints;

Line 233: app_exception.raise_exception;

229: end if;
230: else
231: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
232: IGS_GE_MSG_STACK.ADD;
233: app_exception.raise_exception;
234: end if;
235:
236: Before_DML (
237: p_action => 'INSERT',

Line 312: app_exception.raise_exception;

308: if (c1%notfound) then
309: close c1;
310: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
311: IGS_GE_MSG_STACK.ADD;
312: app_exception.raise_exception;
313: return;
314: end if;
315: close c1;
316:

Line 325: app_exception.raise_exception;

321: null;
322: else
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: IGS_GE_MSG_STACK.ADD;
325: app_exception.raise_exception;
326: end if;
327: return;
328: end LOCK_ROW;
329:

Line 358: app_exception.raise_exception;

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