APPS.IGS_PS_UOFR_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 120: app_exception.raise_exception;

116: ,new_references.unit_ofr_waitlist_priority_id
117: ) THEN
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
119: IGS_GE_MSG_STACK.ADD;
120: app_exception.raise_exception;
121: END IF;
122: END Check_Uniqueness ;
123: PROCEDURE Check_Parent_Existance AS
124: /*************************************************************

Line 145: App_Exception.Raise_Exception;

141: new_references.unit_ofr_waitlist_priority_id
142: ) THEN
143: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
148: END Check_Parent_Existance;
149:

Line 256: App_Exception.Raise_Exception;

252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPF_USPR_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;
260:

Line 312: App_Exception.Raise_Exception;

308: IF Get_Pk_For_Validation(
309: new_references.unit_ofr_waitlist_pref_id) THEN
310: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: IGS_GE_MSG_STACK.ADD;
312: App_Exception.Raise_Exception;
313: END IF;
314: Check_Uniqueness;
315: Check_Constraints;
316: Check_Parent_Existance;

Line 332: App_Exception.Raise_Exception;

328: IF Get_PK_For_Validation (
329: new_references.unit_ofr_waitlist_pref_id) THEN
330: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: END IF;
334: Check_Uniqueness;
335: Check_Constraints;
336: 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_PS_UOFR_WLST_PRF_S.NEXTVAL
423: INTO X_UNIT_OFR_WL_PREF_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.UNIT_OFR_WAITLIST_PRIORITY_ID = X_UNIT_OFR_WL_PRIORITY_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,