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

Line 47: App_Exception.Raise_Exception;

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

Line 105: App_Exception.Raise_Exception;

101: new_references.ceremony_number,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS', v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108: END IF;
109: IF p_inserting OR (p_updating AND new_references.venue_cd <> old_references.venue_cd) THEN

Line 116: App_Exception.Raise_Exception;

112: new_references.venue_cd,
113: v_message_name) = FALSE THEN
114: Fnd_Message.Set_Name('IGS', v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- Validate venue is not closed
119: IF IGS_GR_VAL_GC.assp_val_ve_closed(
120: new_references.venue_cd,

Line 124: App_Exception.Raise_Exception;

120: new_references.venue_cd,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS', v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127: IF p_inserting OR (p_updating AND
128: (new_references.ceremony_dt_alias <> old_references.ceremony_dt_alias OR

Line 143: App_Exception.Raise_Exception;

139: new_references.closing_dai_sequence_number,
140: v_message_name) = FALSE THEN
141: Fnd_Message.Set_Name('IGS', v_message_name);
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147:

Line 180: App_Exception.Raise_Exception;

176: NEW_REFERENCES.ceremony_end_time,
177: v_message_name) = FALSE THEN
178: Fnd_Message.Set_Name('IGS', v_message_name);
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: v_rowid_saved := TRUE;
183: END IF;
184:

Line 208: APP_EXCEPTION.RAISE_EXCEPTION;

204: new_references.grd_ci_sequence_number
205: ) THEN
206: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
207: IGS_GE_MSG_STACK.ADD;
208: APP_EXCEPTION.RAISE_EXCEPTION;
209: END IF;
210:
211: END IF;
212:

Line 231: APP_EXCEPTION.RAISE_EXCEPTION;

227: new_references.grd_ci_sequence_number
228: ) THEN
229: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233:
234: END IF;
235:

Line 248: APP_EXCEPTION.RAISE_EXCEPTION;

244: new_references.grd_ci_sequence_number
245: ) THEN
246: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
247: IGS_GE_MSG_STACK.ADD;
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: END IF;
250:
251: END IF;
252:

Line 262: APP_EXCEPTION.RAISE_EXCEPTION;

258: new_references.venue_cd
259: ) THEN
260: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
261: IGS_GE_MSG_STACK.ADD;
262: APP_EXCEPTION.RAISE_EXCEPTION;
263: END IF;
264:
265: END IF;
266:

Line 311: App_Exception.Raise_Exception ;

307: IF upper(Column_name) = 'CEREMONY_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
308: IF new_references.CEREMONY_DT_ALIAS<> upper(NEW_REFERENCES.CEREMONY_DT_ALIAS) then
309: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception ;
312: END IF;
313:
314: END IF ;
315:

Line 320: App_Exception.Raise_Exception ;

316: IF upper(Column_name) = 'CLOSING_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
317: IF new_references.CLOSING_DT_ALIAS<> upper(NEW_REFERENCES.CLOSING_DT_ALIAS) then
318: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception ;
321: END IF;
322:
323: END IF ;
324:

Line 329: App_Exception.Raise_Exception ;

325: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
326: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
327: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception ;
330: END IF;
331:
332: END IF ;
333:

Line 338: App_Exception.Raise_Exception ;

334: IF upper(Column_name) = 'VENUE_CD' OR COLUMN_NAME IS NULL THEN
335: IF new_references.VENUE_CD<> upper(NEW_REFERENCES.VENUE_CD) then
336: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception ;
339: END IF;
340:
341: END IF ;
342: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 346: App_Exception.Raise_Exception ;

342: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
343: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 then
344: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
345: IGS_GE_MSG_STACK.ADD;
346: App_Exception.Raise_Exception ;
347: END IF;
348:
349: END IF ;
350: IF upper(Column_name) = 'CEREMONY_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 354: App_Exception.Raise_Exception ;

350: IF upper(Column_name) = 'CEREMONY_NUMBER' OR COLUMN_NAME IS NULL THEN
351: IF new_references.CEREMONY_NUMBER < 0 OR new_references.CEREMONY_NUMBER > 999 then
352: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception ;
355: END IF;
356:
357: END IF ;
358: IF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 362: App_Exception.Raise_Exception ;

358: IF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
359: IF new_references.CEREMONY_DAI_SEQUENCE_NUMBER < 1 OR new_references.CEREMONY_DAI_SEQUENCE_NUMBER > 999999 then
360: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception ;
363: END IF;
364:
365: END IF ;
366: IF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 370: App_Exception.Raise_Exception ;

366: IF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
367: IF new_references.CLOSING_DAI_SEQUENCE_NUMBER < 1 OR new_references.CLOSING_DAI_SEQUENCE_NUMBER > 999999 then
368: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception ;
371: END IF;
372:
373: END IF ;
374: IF upper(Column_name) = 'CEREMONY_FEE' OR COLUMN_NAME IS NULL THEN

Line 378: App_Exception.Raise_Exception ;

374: IF upper(Column_name) = 'CEREMONY_FEE' OR COLUMN_NAME IS NULL THEN
375: IF new_references.CEREMONY_FEE < 0.00 OR new_references.CEREMONY_FEE > 999.99 then
376: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception ;
379: END IF;
380:
381: END IF ;
382: IF upper(Column_name) = 'NUMBER_OF_GUESTS' OR COLUMN_NAME IS NULL THEN

Line 386: App_Exception.Raise_Exception ;

382: IF upper(Column_name) = 'NUMBER_OF_GUESTS' OR COLUMN_NAME IS NULL THEN
383: IF new_references.NUMBER_OF_GUESTS < 0 OR new_references.NUMBER_OF_GUESTS > 999 then
384: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception ;
387: END IF;
388:
389: END IF ;
390: END;

Line 467: App_Exception.Raise_Exception;

463: IF (cur_rowid%FOUND) THEN
464: Close cur_rowid;
465: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_CEREMONY_DAI_FK');
466: IGS_GE_MSG_STACK.ADD;
467: App_Exception.Raise_Exception;
468: Return;
469: END IF;
470: Close cur_rowid;
471:

Line 495: App_Exception.Raise_Exception;

491: IF (cur_rowid%FOUND) THEN
492: Close cur_rowid;
493: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_CRD_FK');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: Return;
497: END IF;
498: Close cur_rowid;
499:

Line 521: App_Exception.Raise_Exception;

517: IF (cur_rowid%FOUND) THEN
518: Close cur_rowid;
519: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_VE_FK');
520: IGS_GE_MSG_STACK.ADD;
521: App_Exception.Raise_Exception;
522: Return;
523: END IF;
524: Close cur_rowid;
525:

Line 585: App_Exception.Raise_Exception;

581: NEW_REFERENCES.ceremony_number
582: ) THEN
583: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception;
586: END IF;
587:
588: check_constraints;
589: Check_Parent_Existance;

Line 607: App_Exception.Raise_Exception;

603: NEW_REFERENCES.ceremony_number
604: ) THEN
605: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
606: IGS_GE_MSG_STACK.ADD;
607: App_Exception.Raise_Exception;
608: END IF;
609:
610: check_constraints;
611: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 679: app_exception.raise_exception;

675: end if;
676: else
677: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
678: IGS_GE_MSG_STACK.ADD;
679: app_exception.raise_exception;
680: end if;
681:
682: Before_DML (
683: p_action => 'INSERT',

Line 795: app_exception.raise_exception;

791: fetch c1 into tlinfo;
792: if (c1%notfound) then
793: close c1;
794: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
795: app_exception.raise_exception;
796: return;
797: end if;
798: close c1;
799:

Line 818: app_exception.raise_exception;

814: ) then
815: null;
816: else
817: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
818: app_exception.raise_exception;
819: end if;
820: return;
821: end LOCK_ROW;
822:

Line 859: app_exception.raise_exception;

855: end if;
856: else
857: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
858: IGS_GE_MSG_STACK.ADD;
859: app_exception.raise_exception;
860: end if;
861:
862: Before_DML (
863: p_action => 'UPDATE',