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

Line 45: App_Exception.Raise_Exception;

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

Line 97: App_Exception.Raise_Exception;

93: new_references.us_version_number,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;
100: -- Validate the graduation ceremony ceremony date is not passed
101: IF p_inserting OR p_updating THEN

Line 109: App_Exception.Raise_Exception;

105: new_references.ceremony_number,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS', v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112: -- Validate the award ceremony is not closed
113: IF p_inserting OR p_updating THEN

Line 124: App_Exception.Raise_Exception;

120: new_references.award_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: -- Validate the award ceremony unit set group is not closed
128: IF p_inserting OR p_updating THEN

Line 140: App_Exception.Raise_Exception;

136: new_references.us_group_number,
137: v_message_name) = FALSE THEN
138: Fnd_Message.Set_Name('IGS', v_message_name);
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
143:
144: IF p_inserting THEN

Line 157: App_Exception.Raise_Exception;

153: NEW_REFERENCES.us_group_number,
154: v_message_name) = FALSE THEN
155: Fnd_Message.Set_Name('IGS', v_message_name);
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160: IF p_deleting THEN
161: -- Validate award ceremony us group order in award

Line 173: App_Exception.Raise_Exception;

169: NEW_REFERENCES.us_group_number,
170: v_message_name) = FALSE THEN
171: Fnd_Message.Set_Name('IGS', v_message_name);
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: END BeforeRowInsertUpdateDelete1;
177:

Line 191: App_Exception.Raise_Exception;

187: NEW_REFERENCES.us_group_number,
188: NEW_REFERENCES.order_in_group) THEN
189: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193:
194: END Check_Uniqueness;
195:

Line 226: App_Exception.Raise_Exception;

222: new_references.us_group_number
223: ) THEN
224: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228:
229: END IF;
230: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 242: App_Exception.Raise_Exception;

238: new_references.us_version_number
239: ) THEN
240: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244: END IF;
245: END Check_Parent_Existance;
246:

Line 319: App_Exception.Raise_Exception;

315: IF (cur_rowid%FOUND) THEN
316: Close cur_rowid;
317: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_ACUSG_FK');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: Return;
321: END IF;
322: Close cur_rowid;
323:

Line 347: App_Exception.Raise_Exception;

343: IF (cur_rowid%FOUND) THEN
344: Close cur_rowid;
345: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_US_FK');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: Return;
349: END IF;
350: Close cur_rowid;
351:

Line 411: App_Exception.Raise_Exception;

407: NEW_REFERENCES.us_version_number
408: ) THEN
409: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: check_constraints;
414: check_uniqueness;
415: Check_Parent_Existance;

Line 441: App_Exception.Raise_Exception;

437: NEW_REFERENCES.us_version_number
438: ) THEN
439: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
440: IGS_GE_MSG_STACK.ADD;
441: App_Exception.Raise_Exception;
442: END IF;
443: check_constraints;
444: check_uniqueness;
445:

Line 500: app_exception.raise_exception;

496: end if;
497: else
498: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
499: IGS_GE_MSG_STACK.ADD;
500: app_exception.raise_exception;
501: end if;
502:
503: Before_DML (
504: p_action => 'INSERT',

Line 592: app_exception.raise_exception;

588: fetch c1 into tlinfo;
589: if (c1%notfound) then
590: close c1;
591: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
592: app_exception.raise_exception;
593: return;
594: end if;
595: close c1;
596:

Line 602: app_exception.raise_exception;

598: ) then
599: null;
600: else
601: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
602: app_exception.raise_exception;
603: end if;
604: return;
605: end LOCK_ROW;
606:

Line 641: app_exception.raise_exception;

637: end if;
638: else
639: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
640: IGS_GE_MSG_STACK.ADD;
641: app_exception.raise_exception;
642: end if;
643:
644: Before_DML (
645: p_action => 'UPDATE',

Line 827: App_Exception.Raise_Exception;

823: IF new_references.grd_ci_sequence_number < 1 AND
824: new_references.grd_ci_sequence_number > 999999 THEN
825: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
826: IGS_GE_MSG_STACK.ADD;
827: App_Exception.Raise_Exception;
828: END IF;
829: END IF;
830:
831: IF upper(Column_name) = 'US_GROUP_NUMBER' OR column_name IS NULL then

Line 836: App_Exception.Raise_Exception;

832: IF new_references.us_group_number < 0 AND
833: new_references.us_group_number > 999999 THEN
834: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
835: IGS_GE_MSG_STACK.ADD;
836: App_Exception.Raise_Exception;
837: END IF;
838: END IF;
839:
840: IF upper(Column_name) = 'US_VERSION_NUMBER' OR column_name IS NULL then

Line 845: App_Exception.Raise_Exception;

841: IF new_references.us_version_number < 0 AND
842: new_references.us_version_number > 999 THEN
843: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
844: IGS_GE_MSG_STACK.ADD;
845: App_Exception.Raise_Exception;
846: END IF;
847: END IF;
848:
849: IF upper(Column_name) = 'ORDER_IN_GROUP' OR column_name IS NULL then

Line 854: App_Exception.Raise_Exception;

850: IF new_references.order_in_group < 0 AND
851: new_references.order_in_group > 999 THEN
852: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: END IF;
856: END IF;
857:
858: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN

Line 862: App_Exception.Raise_Exception;

858: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
859: IF new_references.award_cd <> UPPER(new_references.award_cd) THEN
860: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
861: IGS_GE_MSG_STACK.ADD;
862: App_Exception.Raise_Exception;
863: END IF;
864: END IF;
865:
866: IF upper(Column_name) = 'AWARD_COURSE_CD' OR column_name IS NULL then

Line 870: App_Exception.Raise_Exception;

866: IF upper(Column_name) = 'AWARD_COURSE_CD' OR column_name IS NULL then
867: IF new_references.award_course_cd <> UPPER(new_references.award_course_cd) THEN
868: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
869: IGS_GE_MSG_STACK.ADD;
870: App_Exception.Raise_Exception;
871: END IF;
872: END IF;
873:
874: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then

Line 878: App_Exception.Raise_Exception;

874: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then
875: IF new_references.grd_cal_type <> UPPER(new_references.grd_cal_type) THEN
876: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
877: IGS_GE_MSG_STACK.ADD;
878: App_Exception.Raise_Exception;
879: END IF;
880: END IF;
881:
882: IF upper(Column_name) = 'UNIT_SET_CD' OR column_name IS NULL then

Line 886: App_Exception.Raise_Exception;

882: IF upper(Column_name) = 'UNIT_SET_CD' OR column_name IS NULL then
883: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
884: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
885: IGS_GE_MSG_STACK.ADD;
886: App_Exception.Raise_Exception;
887: END IF;
888: END IF;
889:
890: END Check_Constraints;