APPS.IGS_PS_UOFR_WLST_PRI_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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

Line 126: app_exception.raise_exception;

122: ,new_references.version_number
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;
129: PROCEDURE Check_Parent_Existance AS
130: /*************************************************************

Line 160: App_Exception.Raise_Exception;

156: new_references.ci_sequence_number
157: ) THEN
158: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162:
163: IF (((old_references.priority_value = new_references.priority_value)) OR
164: ((new_references.priority_value IS NULL))) THEN

Line 170: App_Exception.Raise_Exception;

166: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_WAITLIST',
167: new_references.priority_value) THEN
168: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172:
173: END Check_Parent_Existance;
174:

Line 308: App_Exception.Raise_Exception;

304: IF (cur_rowid%FOUND) THEN
305: Close cur_rowid;
306: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
307: IGS_GE_MSG_STACK.ADD;
308: App_Exception.Raise_Exception;
309: Return;
310: END IF;
311: Close cur_rowid;
312:

Line 368: App_Exception.Raise_Exception;

364: IF Get_Pk_For_Validation(
365: new_references.unit_ofr_waitlist_priority_id) THEN
366: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: IGS_GE_MSG_STACK.ADD;
368: App_Exception.Raise_Exception;
369: END IF;
370: Check_Uniqueness;
371: Check_Constraints;
372: Check_Parent_Existance;

Line 389: App_Exception.Raise_Exception;

385: IF Get_PK_For_Validation (
386: new_references.unit_ofr_waitlist_priority_id) THEN
387: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception;
390: END IF;
391: Check_Uniqueness;
392: Check_Constraints;
393: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 478: app_exception.raise_exception;

474: end if;
475: else
476: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: end if;
480: SELECT IGS_PS_UOFR_WLST_PRI_S.NEXTVAL
481: INTO X_UNIT_OFR_WL_PRIORITY_ID
482: FROM dual;

Line 573: app_exception.raise_exception;

569: if (c1%notfound) then
570: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
571: IGS_GE_MSG_STACK.ADD;
572: close c1;
573: app_exception.raise_exception;
574: return;
575: end if;
576: close c1;
577: if ( ( tlinfo.UNIT_CD = X_UNIT_CD)

Line 588: app_exception.raise_exception;

584: null;
585: else
586: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
587: IGS_GE_MSG_STACK.ADD;
588: app_exception.raise_exception;
589: end if;
590: return;
591: end LOCK_ROW;
592: Procedure UPDATE_ROW (

Line 634: app_exception.raise_exception;

630: end if;
631: else
632: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
633: IGS_GE_MSG_STACK.ADD;
634: app_exception.raise_exception;
635: end if;
636: Before_DML(
637: p_action=>'UPDATE',
638: x_rowid=>X_ROWID,