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

Line 79: App_Exception.Raise_Exception;

75: IF new_references.course_cd <> UPPER(new_references.course_cd)
76: 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:
83: IF upper(column_name)= 'S_RULE_CALL_CD' OR

Line 89: App_Exception.Raise_Exception;

85: IF new_references.s_rule_call_cd <> UPPER(new_references.s_rule_call_cd)
86: THEN
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: END Check_Constraints;
93:

Line 106: App_Exception.Raise_Exception;

102: new_references.course_cd
103: )THEN
104: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109:
110: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR

Line 119: App_Exception.Raise_Exception;

115: new_references.rul_sequence_number
116: )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:
123: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR

Line 132: App_Exception.Raise_Exception;

128: new_references.s_rule_call_cd
129: )THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135:
136: END Check_Parent_Existance;

Line 185: App_Exception.Raise_Exception;

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

Line 211: App_Exception.Raise_Exception;

207: IF (cur_rowid%FOUND) THEN
208: Close cur_rowid;
209: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CR_RUL_FK');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: Return;
213: END IF;
214: Close cur_rowid;
215:

Line 237: App_Exception.Raise_Exception;

233: IF (cur_rowid%FOUND) THEN
234: Close cur_rowid;
235: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CR_SRC_FK');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: Return;
239: END IF;
240: Close cur_rowid;
241:

Line 279: App_Exception.Raise_Exception;

275: new_references.s_rule_call_cd
276: ) THEN
277: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END IF;
281: Check_Constraints;
282: Check_Parent_Existance;
283: ELSIF (p_action = 'UPDATE') THEN

Line 296: App_Exception.Raise_Exception;

292: new_references.s_rule_call_cd
293: ) THEN
294: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
300: Check_Constraints;

Line 346: app_exception.raise_exception;

342: end if;
343: else
344: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348: Before_DML (
349: p_action => 'INSERT',
350: x_rowid => X_ROWID,

Line 414: app_exception.raise_exception;

410: if (c1%notfound) then
411: close c1;
412: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: return;
416: end if;
417: close c1;
418:

Line 425: app_exception.raise_exception;

421: null;
422: else
423: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
424: IGS_GE_MSG_STACK.ADD;
425: app_exception.raise_exception;
426: end if;
427: return;
428: end LOCK_ROW;
429:

Line 457: app_exception.raise_exception;

453: end if;
454: else
455: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459: Before_DML (
460: p_action => 'UPDATE',
461: x_rowid => X_ROWID,