APPS.IGS_PS_CAT_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 80: App_Exception.Raise_Exception;

76: column_name is null Then
77: IF ( new_references.closed_ind NOT IN ( 'Y' , 'N' ) ) 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:
84: IF upper(column_name) = 'COURSE_CAT' OR

Line 89: App_Exception.Raise_Exception;

85: column_name is null Then
86: IF ( new_references.course_cat <> UPPER(new_references.course_cat) ) 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:
93: END Check_Constraints;

Line 164: App_Exception.Raise_Exception;

160: IF Get_PK_For_Validation (
161: new_references.course_cat ) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: Check_Constraints;
167: ELSIF (p_action = 'UPDATE') THEN
168: -- Call all the procedures related to Before Update.

Line 180: App_Exception.Raise_Exception;

176: IF Get_PK_For_Validation (
177: new_references.course_cat ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: Check_Constraints;
183: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
184: Check_Constraints;

Line 231: app_exception.raise_exception;

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

Line 303: app_exception.raise_exception;

299: if (c1%notfound) then
300: close c1;
301: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
302: IGS_GE_MSG_STACK.ADD;
303: app_exception.raise_exception;
304: return;
305: end if;
306: close c1;
307:

Line 315: app_exception.raise_exception;

311: null;
312: else
313: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
314: IGS_GE_MSG_STACK.ADD;
315: app_exception.raise_exception;
316: end if;
317: return;
318: end LOCK_ROW;
319:

Line 347: app_exception.raise_exception;

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