eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_LOCATION_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

46: Fetch cur_old_ref_values INTO old_references;
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;

Line 123: IGS_GE_MSG_STACK.ADD;

119: ,new_references.unit_version_number
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

Line 149: IGS_GE_MSG_STACK.ADD;

145: new_references.location_code ,
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

Line 163: IGS_GE_MSG_STACK.ADD;

159: new_references.unit_code,
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

Line 175: IGS_GE_MSG_STACK.ADD;

171: new_references.room_id ,
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

Line 187: IGS_GE_MSG_STACK.ADD;

183: new_references.building_id ,
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;

Line 302: IGS_GE_MSG_STACK.ADD;

298: Fetch cur_rowid INTO lv_rowid;
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;

Line 341: IGS_GE_MSG_STACK.ADD;

337: Fetch cur_rowid INTO lv_rowid;
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;

Line 378: IGS_GE_MSG_STACK.ADD;

374: Fetch cur_rowid INTO lv_rowid;
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;

Line 415: IGS_GE_MSG_STACK.ADD;

411: Fetch cur_rowid INTO lv_rowid;
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;

Line 473: IGS_GE_MSG_STACK.ADD;

469: Null;
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;

Line 493: IGS_GE_MSG_STACK.ADD;

489: -- Call all the procedures related to Before Insert.
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;

Line 582: IGS_GE_MSG_STACK.ADD;

578: X_LAST_UPDATE_LOGIN := -1;
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:

Line 671: IGS_GE_MSG_STACK.ADD;

667: open c1;
668: fetch c1 into tlinfo;
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;

Line 690: IGS_GE_MSG_STACK.ADD;

686: ) then
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;

Line 735: IGS_GE_MSG_STACK.ADD;

731: X_LAST_UPDATE_LOGIN := -1;
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',