APPS.IGS_OR_REL_PS_TYPE_PKG dependencies on APP_EXCEPTION

Line 35: App_Exception.Raise_Exception;

31: Fetch cur_old_ref_values INTO old_references;
32: IF (cur_old_ref_values%NOTFOUND) AND (p_action <> 'INSERT') THEN
33: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
34: IGS_GE_MSG_STACK.ADD;
35: App_Exception.Raise_Exception;
36: Close cur_old_ref_values;
37: Return;
38: END IF;
39: Close cur_old_ref_values;

Line 70: App_Exception.Raise_Exception;

66: new_references.course_type
67: )THEN
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71:
72: END IF;
73: END IF;
74: IF (((old_references.parent_org_unit_cd = new_references.parent_org_unit_cd) AND

Line 95: App_Exception.Raise_Exception;

91: new_references.our_create_dt
92: )THEN
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96:
97: END IF;
98: END IF;
99: END Check_Parent_Existance;

Line 156: App_Exception.Raise_Exception;

152: IF (cur_rowid%FOUND) THEN
153: Close cur_rowid;
154: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OURCT_OUR_FK');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157:
158: Return;
159: END IF;
160: Close cur_rowid;

Line 207: App_Exception.Raise_Exception ;

203: new_references.course_type
204: ) THEN
205: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception ;
208:
209: END IF;
210: Check_Parent_Existance;
211: Check_Constraints;

Line 231: App_Exception.Raise_Exception ;

227: new_references.course_type
228: ) THEN
229: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception ;
232:
233: END IF;
234: Check_Constraints;
235:

Line 292: app_exception.raise_exception;

288: end if;
289: else
290: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
291: IGS_GE_MSG_STACK.ADD;
292: app_exception.raise_exception;
293: end if;
294: Before_DML(
295: p_action=>'INSERT',
296: x_rowid=>X_ROWID,

Line 366: app_exception.raise_exception;

362: open c1;
363: fetch c1 into tlinfo;
364: if (c1%notfound) then
365: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
366: app_exception.raise_exception;
367: close c1;
368: return;
369: end if;
370: close c1;

Line 422: App_Exception.Raise_Exception ;

418: IF upper(Column_name) = 'COURSE_TYPE' OR COLUMN_NAME IS NULL THEN
419: IF new_references.COURSE_TYPE<> upper(new_references.COURSE_TYPE) then
420: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
421: IGS_GE_MSG_STACK.ADD;
422: App_Exception.Raise_Exception ;
423: END IF;
424:
425: END IF ;
426: