APPS.IGS_PS_OWN_HIST_PKG dependencies on APP_EXCEPTION

Line 44: App_Exception.Raise_Exception;

40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
47: Close cur_old_ref_values;
48:

Line 90: App_Exception.Raise_Exception;

86: IF new_references.course_cd <> UPPER(new_references.course_cd)
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 112: App_Exception.Raise_Exception;

108: new_references.version_number
109: )THEN
110: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:
116: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 128: App_Exception.Raise_Exception;

124: new_references.ou_start_dt
125: )THEN
126: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:
132: END Check_Parent_Existance;

Line 189: App_Exception.Raise_Exception;

185: IF (cur_rowid%FOUND) THEN
186: Close cur_rowid;
187: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COH_CV_FK');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: Return;
191: END IF;
192: Close cur_rowid;
193:

Line 217: App_Exception.Raise_Exception;

213: IF (cur_rowid%FOUND) THEN
214: Close cur_rowid;
215: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COH_OU_FK');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: Return;
219: END IF;
220: Close cur_rowid;
221:

Line 274: App_Exception.Raise_Exception;

270: new_references.hist_start_dt
271: ) THEN
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Constraints;
277: Check_Parent_Existance;
278: ELSIF (p_action = 'UPDATE') THEN

Line 294: App_Exception.Raise_Exception;

290: new_references.hist_start_dt
291: ) THEN
292: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: Check_Constraints;
297: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
298: Check_Constraints;

Line 353: app_exception.raise_exception;

349: end if;
350: else
351: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
352: IGS_GE_MSG_STACK.ADD;
353: app_exception.raise_exception;
354: end if;
355: Before_DML (
356: p_action => 'INSERT',
357: x_rowid => X_ROWID,

Line 445: app_exception.raise_exception;

441: if (c1%notfound) then
442: close c1;
443: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: return;
447: end if;
448: close c1;
449:

Line 461: app_exception.raise_exception;

457: null;
458: else
459: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
460: IGS_GE_MSG_STACK.ADD;
461: app_exception.raise_exception;
462: end if;
463: return;
464: end LOCK_ROW;
465:

Line 498: app_exception.raise_exception;

494: end if;
495: else
496: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: Before_DML (
501: p_action => 'UPDATE',
502: x_rowid => X_ROWID,