APPS.IGS_PS_USEC_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_sec_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_sec_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 255: App_Exception.Raise_Exception;

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

Line 311: App_Exception.Raise_Exception;

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

Line 331: App_Exception.Raise_Exception;

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

Line 419: app_exception.raise_exception;

415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421: SELECT
422: IGS_PS_USEC_WLST_PRF_S.NextVal
423: INTO

Line 508: app_exception.raise_exception;

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

Line 523: app_exception.raise_exception;

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

Line 567: app_exception.raise_exception;

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