APPS.IGS_OR_UNIT_REL_PKG dependencies on APP_EXCEPTION

Line 36: App_Exception.Raise_Exception;

32: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
33:
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Close cur_old_ref_values;
38: Return;
39: END IF;
40: Close cur_old_ref_values;

Line 86: App_Exception.Raise_Exception;

82: CLOSE c_exists;
83: IF l_exists = 'Y' THEN
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: END BeforeRowInsert1;
90:

Line 112: App_Exception.Raise_Exception ;

108: New_References.child_start_dt,
109: v_message_name) = FALSE THEN
110: Fnd_Message.Set_Name('IGS',v_message_name);
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception ;
113: END IF;
114: END AfterRowInsert1;
115: -- Trigger description :-
116: -- "OSS_TST".trg_our_as_i

Line 134: App_Exception.Raise_Exception;

130: new_references.child_start_dt
131: )THEN
132: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137: IF (((old_references.parent_org_unit_cd = new_references.parent_org_unit_cd) AND
138: (old_references.parent_start_dt = new_references.parent_start_dt)) OR

Line 149: App_Exception.Raise_Exception;

145: new_references.parent_start_dt
146: )THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150:
151: END IF;
152: END IF;
153: END Check_Parent_Existance;

Line 177: App_Exception.Raise_Exception;

173: new_references.create_dt
174: ) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF ;
179: END Check_Uniqueness;
180:
181:

Line 228: App_Exception.Raise_Exception;

224: IF (cur_rowid%FOUND) THEN
225: Close cur_rowid ;
226: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OUR_OU_CHILD_FK');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229:
230: Return;
231: END IF;
232: Close cur_rowid;

Line 340: app_exception.raise_exception;

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

Line 415: app_exception.raise_exception;

411: open c1;
412: fetch c1 into tlinfo;
413: if (c1%notfound) then
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: app_exception.raise_exception;
416: close c1;
417: return;
418: end if;
419: close c1;

Line 427: app_exception.raise_exception;

423: ) then
424: null;
425: else
426: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
427: app_exception.raise_exception;
428: end if;
429: return;
430: end LOCK_ROW;
431:

Line 462: app_exception.raise_exception;

458: end if;
459: else
460: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
461: IGS_GE_MSG_STACK.ADD;
462: app_exception.raise_exception;
463: end if;
464: Before_DML(
465: p_action=>'UPDATE',
466: x_rowid=>X_ROWID,