APPS.IGS_PS_UNIT_LOCATION_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 124: app_exception.raise_exception;

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

Line 150: App_Exception.Raise_Exception;

146: 'N'
147: ) THEN
148: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152:
153: IF (((old_references.unit_code = new_references.unit_code) AND
154: (old_references.unit_version_number = new_references.unit_version_number)) OR

Line 164: App_Exception.Raise_Exception;

160: new_references.unit_version_number
161: ) THEN
162: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166:
167: IF (((old_references.room_id = new_references.room_id)) OR
168: ((new_references.room_id IS NULL))) THEN

Line 176: App_Exception.Raise_Exception;

172: 'N'
173: ) THEN
174: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178:
179: IF (((old_references.building_id = new_references.building_id)) OR
180: ((new_references.building_id IS NULL))) THEN

Line 188: App_Exception.Raise_Exception;

184: 'N'
185: ) THEN
186: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190:
191: END Check_Parent_Existance;
192:

Line 303: App_Exception.Raise_Exception;

299: IF (cur_rowid%FOUND) THEN
300: Close cur_rowid;
301: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_LOC_FK');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: Return;
305: END IF;
306: Close cur_rowid;
307:

Line 342: App_Exception.Raise_Exception;

338: IF (cur_rowid%FOUND) THEN
339: Close cur_rowid;
340: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_UV_FK');
341: IGS_GE_MSG_STACK.ADD;
342: App_Exception.Raise_Exception;
343: Return;
344: END IF;
345: Close cur_rowid;
346:

Line 379: App_Exception.Raise_Exception;

375: IF (cur_rowid%FOUND) THEN
376: Close cur_rowid;
377: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_ROOM_FK');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: Return;
381: END IF;
382: Close cur_rowid;
383:

Line 416: App_Exception.Raise_Exception;

412: IF (cur_rowid%FOUND) THEN
413: Close cur_rowid;
414: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_BLDG_FK');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: Return;
418: END IF;
419: Close cur_rowid;
420:

Line 474: App_Exception.Raise_Exception;

470: IF Get_Pk_For_Validation(
471: new_references.unit_location_id) THEN
472: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: Check_Uniqueness;
477: Check_Constraints;
478: Check_Parent_Existance;

Line 494: App_Exception.Raise_Exception;

490: IF Get_PK_For_Validation (
491: new_references.unit_location_id) THEN
492: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
493: IGS_GE_MSG_STACK.ADD;
494: App_Exception.Raise_Exception;
495: END IF;
496: Check_Uniqueness;
497: Check_Constraints;
498: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 583: app_exception.raise_exception;

579: end if;
580: else
581: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
582: IGS_GE_MSG_STACK.ADD;
583: app_exception.raise_exception;
584: end if;
585: Select IGS_PS_UNIT_LOCATION_S.NEXTVAL into x_unit_location_id from dual;
586:
587: Before_DML(

Line 673: app_exception.raise_exception;

669: if (c1%notfound) then
670: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
671: IGS_GE_MSG_STACK.ADD;
672: close c1;
673: app_exception.raise_exception;
674: return;
675: end if;
676: close c1;
677: if ( ( tlinfo.UNIT_CODE = X_UNIT_CODE)

Line 691: app_exception.raise_exception;

687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;
694: end LOCK_ROW;
695: Procedure UPDATE_ROW (

Line 736: app_exception.raise_exception;

732: end if;
733: else
734: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
735: IGS_GE_MSG_STACK.ADD;
736: app_exception.raise_exception;
737: end if;
738: Before_DML(
739: p_action=>'UPDATE',
740: x_rowid=>X_ROWID,