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 IGS_GE_MSG_STACK

Line 46: IGS_GE_MSG_STACK.ADD;

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

Line 104: IGS_GE_MSG_STACK.ADD;

100: new_references.grd_ci_sequence_number,
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;

Line 115: IGS_GE_MSG_STACK.ADD;

111: IF IGS_GR_VAL_GC.grdp_val_ve_lot(
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(

Line 123: IGS_GE_MSG_STACK.ADD;

119: IF IGS_GR_VAL_GC.assp_val_ve_closed(
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

Line 142: IGS_GE_MSG_STACK.ADD;

138: new_references.closing_dt_alias,
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:

Line 179: IGS_GE_MSG_STACK.ADD;

175: NEW_REFERENCES.ceremony_start_time,
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;

Line 207: IGS_GE_MSG_STACK.ADD;

203: new_references.grd_cal_type,
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;

Line 230: IGS_GE_MSG_STACK.ADD;

226: new_references.grd_cal_type,
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;

Line 247: IGS_GE_MSG_STACK.ADD;

243: new_references.grd_cal_type,
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;

Line 261: IGS_GE_MSG_STACK.ADD;

257: IF NOT IGS_GR_VENUE_PKG.Get_PK_For_Validation (
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;

Line 310: IGS_GE_MSG_STACK.ADD;

306:
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 ;

Line 319: IGS_GE_MSG_STACK.ADD;

315:
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 ;

Line 328: IGS_GE_MSG_STACK.ADD;

324:
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 ;

Line 337: IGS_GE_MSG_STACK.ADD;

333:
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 ;

Line 345: IGS_GE_MSG_STACK.ADD;

341: END IF ;
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 ;

Line 353: IGS_GE_MSG_STACK.ADD;

349: END IF ;
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 ;

Line 361: IGS_GE_MSG_STACK.ADD;

357: END IF ;
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 ;

Line 369: IGS_GE_MSG_STACK.ADD;

365: END IF ;
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 ;

Line 377: IGS_GE_MSG_STACK.ADD;

373: END IF ;
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 ;

Line 385: IGS_GE_MSG_STACK.ADD;

381: END IF ;
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 ;

Line 466: IGS_GE_MSG_STACK.ADD;

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

Line 494: IGS_GE_MSG_STACK.ADD;

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

Line 520: IGS_GE_MSG_STACK.ADD;

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

Line 584: IGS_GE_MSG_STACK.ADD;

580: NEW_REFERENCES.grd_ci_sequence_number,
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;

Line 606: IGS_GE_MSG_STACK.ADD;

602: NEW_REFERENCES.grd_ci_sequence_number,
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;

Line 678: IGS_GE_MSG_STACK.ADD;

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

Line 858: IGS_GE_MSG_STACK.ADD;

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