APPS.IGS_EN_ORUN_WLST_PRF_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

46: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
47: Close cur_old_ref_values;
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;
53: Close cur_old_ref_values;
54:

Line 118: App_Exception.Raise_Exception;

114: new_references.org_unit_wlst_pri_id
115: ) THEN
116: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120:
121: END Check_Parent_Existance;
122:

Line 189: App_Exception.Raise_Exception;

185: IF (cur_rowid%FOUND) THEN
186: Close cur_rowid;
187: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUWPR_OUWP_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: )
214: ) THEN
215: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: END IF;
219:
220: END check_uniqueness;
221:

Line 314: App_Exception.Raise_Exception;

310: IF Get_Pk_For_Validation(
311: new_references.org_unit_wlst_prf_id) THEN
312: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: Check_uniqueness;
317: Check_Constraints;
318: Check_Parent_Existance;

Line 333: App_Exception.Raise_Exception;

329: IF Get_PK_For_Validation (
330: new_references.org_unit_wlst_prf_id) THEN
331: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
332: IGS_GE_MSG_STACK.ADD;
333: App_Exception.Raise_Exception;
334: END IF;
335: Check_uniqueness;
336: Check_Constraints;
337: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 420: app_exception.raise_exception;

416: end if;
417: else
418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: SELECT IGS_EN_OR_UNIT_WLST_PRF_S.NEXTVAL
423: INTO x_org_unit_wlst_prf_id
424: FROm dual;

Line 506: app_exception.raise_exception;

502: if (c1%notfound) then
503: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
504: IGS_GE_MSG_STACK.ADD;
505: close c1;
506: app_exception.raise_exception;
507: return;
508: end if;
509: close c1;
510: if ( ( tlinfo.ORG_UNIT_WLST_PRI_ID = X_ORG_UNIT_WLST_PRI_ID)

Line 521: app_exception.raise_exception;

517: null;
518: else
519: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
520: IGS_GE_MSG_STACK.ADD;
521: app_exception.raise_exception;
522: end if;
523: return;
524: end LOCK_ROW;
525: Procedure UPDATE_ROW (

Line 565: app_exception.raise_exception;

561: end if;
562: else
563: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
564: IGS_GE_MSG_STACK.ADD;
565: app_exception.raise_exception;
566: end if;
567: Before_DML(
568: p_action=>'UPDATE',
569: x_rowid=>X_ROWID,