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_GR_VENUE_PKG dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

45: Fetch cur_old_ref_values INTO old_references;
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: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;
53:

Line 105: App_Exception.Raise_Exception;

101: IF IGS_AS_VAL_VE.assp_val_ve_lot (
102: new_references.exam_location_cd,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS', v_message_name);
105: App_Exception.Raise_Exception;
106: END IF;
107: --
108: -- Cannot created against closed exam_location
109: IF IGS_AS_VAL_ELS.ORGP_VAL_LOC_CLOSED (

Line 113: App_Exception.Raise_Exception;

109: IF IGS_AS_VAL_ELS.ORGP_VAL_LOC_CLOSED (
110: new_references.exam_location_cd,
111: v_message_name) = FALSE THEN
112: Fnd_Message.Set_Name('IGS', v_message_name);
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116: -- Validate that inserts/updates are allowed
117: IF p_inserting OR p_updating THEN

Line 125: App_Exception.Raise_Exception;

121: new_references.exam_location_cd,
122: new_references.closed_ind,
123: v_message_name) = FALSE THEN
124: Fnd_Message.Set_Name('IGS', v_message_name);
125: App_Exception.Raise_Exception;
126: END IF;
127: --
128: -- Validate co-ordinator is a valid person
129: IF (new_references.coord_person_id IS NOT NULL and

Line 135: App_Exception.Raise_Exception;

131: IF IGS_CO_VAL_OC.genp_val_prsn_id (
132: new_references.coord_person_id,
133: v_message_name) = FALSE THEN
134: Fnd_Message.Set_Name('IGS', v_message_name);
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138: END IF;
139:

Line 155: APP_EXCEPTION.RAISE_EXCEPTION;

151: new_references.exam_location_cd,
152: 'N'
153: ) THEN
154: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
155: APP_EXCEPTION.RAISE_EXCEPTION;
156: END IF;
157: END IF;
158:
159: IF (((old_references.coord_person_id = new_references.coord_person_id)) OR

Line 167: APP_EXCEPTION.RAISE_EXCEPTION;

163: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
164: new_references.coord_person_id
165: ) THEN
166: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
167: APP_EXCEPTION.RAISE_EXCEPTION;
168: END IF;
169:
170: END IF;
171:

Line 255: App_Exception.Raise_Exception ;

251:
252: IF upper(Column_name) = 'SUPERVISOR_LIMIT' OR COLUMN_NAME IS NULL THEN
253: IF new_references.SUPERVISOR_LIMIT < 0 or new_references.SUPERVISOR_LIMIT > 99 then
254: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
255: App_Exception.Raise_Exception ;
256: END IF;
257:
258: END IF ;
259:

Line 263: App_Exception.Raise_Exception ;

259:
260: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
261: IF new_references.CLOSED_IND not in ('Y','N') then
262: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
263: App_Exception.Raise_Exception ;
264: END IF;
265:
266: END IF ;
267:

Line 271: App_Exception.Raise_Exception ;

267:
268: IF upper(Column_name) = 'EXAM_LOCATION_CD' OR COLUMN_NAME IS NULL THEN
269: IF new_references.EXAM_LOCATION_CD<> upper(new_references.EXAM_LOCATION_CD) then
270: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
271: App_Exception.Raise_Exception ;
272: END IF;
273:
274: END IF ;
275:

Line 279: App_Exception.Raise_Exception ;

275:
276: IF upper(Column_name) = 'VENUE_CD' OR COLUMN_NAME IS NULL THEN
277: IF new_references.VENUE_CD<> upper(new_references.VENUE_CD) then
278: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
279: App_Exception.Raise_Exception ;
280: END IF;
281:
282: END IF ;
283:

Line 287: App_Exception.Raise_Exception ;

283:
284: IF upper(Column_name) = 'BOOKING_COST' OR COLUMN_NAME IS NULL THEN
285: IF new_references.BOOKING_COST < 0 or new_references.BOOKING_COST > 99999.99 then
286: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
287: App_Exception.Raise_Exception ;
288: END IF;
289:
290: END IF ;
291:

Line 295: App_Exception.Raise_Exception ;

291:
292: IF upper(Column_name) = 'NUMBER_OF_SEATS' OR COLUMN_NAME IS NULL THEN
293: IF new_references.NUMBER_OF_SEATS < 0 or new_references.NUMBER_OF_SEATS > 9999 then
294: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
295: App_Exception.Raise_Exception ;
296: END IF;
297:
298: END IF ;
299:

Line 303: App_Exception.Raise_Exception ;

299:
300: IF upper(Column_name) = 'PRIORITY_CD' OR COLUMN_NAME IS NULL THEN
301: IF new_references.PRIORITY_CD < 0 or new_references.PRIORITY_CD > 999 then
302: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
303: App_Exception.Raise_Exception ;
304: END IF;
305:
306: END IF ;
307: END CHECK_CONSTRAINTS;

Line 327: App_Exception.Raise_Exception;

323: Fetch cur_rowid INTO lv_rowid;
324: IF (cur_rowid%FOUND) THEN
325: Close cur_rowid;
326: Fnd_Message.Set_Name ('IGS', 'IGS_GR_VE_LOC_FK');
327: App_Exception.Raise_Exception;
328: Return;
329: END IF;
330: Close cur_rowid;
331:

Line 352: App_Exception.Raise_Exception;

348: Fetch cur_rowid INTO lv_rowid;
349: IF (cur_rowid%FOUND) THEN
350: Close cur_rowid;
351: Fnd_Message.Set_Name ('IGS', 'IGS_GR_VE_PE_FK');
352: App_Exception.Raise_Exception;
353: Return;
354: END IF;
355: Close cur_rowid;
356:

Line 417: App_Exception.Raise_Exception;

413: -- Call all the procedures related to Before Insert.
414: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
415: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.venue_cd) THEN
416: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
417: App_Exception.Raise_Exception;
418: END IF;
419:
420: check_constraints;
421: Check_Parent_Existance;

Line 434: App_Exception.Raise_Exception;

430: Check_Child_Existance;
431: ELSIF (p_action = 'VALIDATE_INSERT') THEN
432: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.venue_cd) THEN
433: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
434: App_Exception.Raise_Exception;
435: END IF;
436:
437: check_constraints;
438: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 488: app_exception.raise_exception;

484: X_LAST_UPDATE_LOGIN := -1;
485: end if;
486: else
487: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
488: app_exception.raise_exception;
489: end if;
490:
491: Before_DML (
492: p_action => 'INSERT',

Line 616: app_exception.raise_exception;

612: fetch c1 into tlinfo;
613: if (c1%notfound) then
614: close c1;
615: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
616: app_exception.raise_exception;
617: return;
618: end if;
619: close c1;
620:

Line 660: app_exception.raise_exception;

656: ) then
657: null;
658: else
659: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
660: app_exception.raise_exception;
661: end if;
662: return;
663: end LOCK_ROW;
664:

Line 703: app_exception.raise_exception;

699: X_LAST_UPDATE_LOGIN := -1;
700: end if;
701: else
702: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
703: app_exception.raise_exception;
704: end if;
705:
706: Before_DML (
707: p_action => 'UPDATE',