APPS.IGS_PS_TYPE_GRP_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: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd)
77: 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)= 'CLOSED_IND' OR

Line 90: App_Exception.Raise_Exception;

86: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
87: THEN
88: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93:
94: END Check_Constraints;

Line 169: App_Exception.Raise_Exception;

165: new_references.course_type_group_cd
166: ) THEN
167: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: Check_Constraints;
172: ELSIF (p_action = 'UPDATE') THEN
173: -- Call all the procedures related to Before Update.

Line 185: App_Exception.Raise_Exception;

181: new_references.course_type_group_cd
182: ) THEN
183: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: Check_Constraints;
188: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
189: Check_Constraints;

Line 235: app_exception.raise_exception;

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

Line 300: app_exception.raise_exception;

296: fetch c1 into tlinfo;
297: if (c1%notfound) then
298: close c1;
299: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
300: app_exception.raise_exception;
301: return;
302: end if;
303: close c1;
304:

Line 311: app_exception.raise_exception;

307: ) then
308: null;
309: else
310: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
311: app_exception.raise_exception;
312: end if;
313: return;
314: end LOCK_ROW;
315:

Line 343: app_exception.raise_exception;

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