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

Line 44: App_Exception.Raise_Exception;

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

Line 94: App_Exception.Raise_Exception;

90: new_references.govt_attendance_type,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS', v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98:

Line 128: App_Exception.Raise_Exception;

124: IF new_references.lower_enr_load_range < 0 OR
125: new_references.lower_enr_load_range > 9999.999THEN
126: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:
132: IF upper(column_name) = 'RESEARCH_PERCENTAGE' OR

Line 138: App_Exception.Raise_Exception;

134: IF new_references.research_percentage < 0 OR
135: new_references.research_percentage > 100 THEN
136: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:
142: IF upper(column_name) = 'CLOSED_IND' OR

Line 147: App_Exception.Raise_Exception;

143: Column_name is null THEN
144: IF new_references.closed_ind NOT IN ('Y','N') THEN
145: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: END IF;
150:
151: IF upper(column_name) = 'UPPER_ENR_LOAD_RANGE' OR

Line 157: App_Exception.Raise_Exception;

153: IF new_references.upper_enr_load_range < 0 OR
154: new_references.upper_enr_load_range > 9999.999 THEN
155: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:
161: IF upper(column_name) = 'ATTENDANCE_TYPE' OR

Line 166: App_Exception.Raise_Exception;

162: Column_name is null THEN
163: IF new_references.attendance_type <> UPPER(new_references.attendance_type) THEN
164: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:
170: IF upper(column_name) = 'GOVT_ATTENDANCE_TYPE' OR

Line 175: App_Exception.Raise_Exception;

171: Column_name is null THEN
172: IF new_references.govt_attendance_type <> UPPER(new_references.govt_attendance_type) THEN
173: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:
179: END check_constraints;

Line 193: App_Exception.Raise_Exception;

189: new_references.govt_attendance_type
190: ) THEN
191: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196:
197: END Check_Parent_Existance;

Line 320: App_Exception.Raise_Exception;

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

Line 372: App_Exception.Raise_Exception;

368: new_references.attendance_type
369: ) THEN
370: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_constraints;
375: Check_Parent_Existance;
376: ELSIF (p_action = 'UPDATE') THEN

Line 391: App_Exception.Raise_Exception;

387: new_references.attendance_type
388: ) THEN
389: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
390: IGS_GE_MSG_STACK.ADD;
391: App_Exception.Raise_Exception;
392: END IF;
393: Check_constraints;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
395: Check_constraints;

Line 457: app_exception.raise_exception;

453: end if;
454: else
455: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459:
460: Before_DML(
461: p_action => 'INSERT',

Line 553: app_exception.raise_exception;

549: if (c1%notfound) then
550: close c1;
551: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: return;
555: end if;
556: close c1;
557:

Line 571: app_exception.raise_exception;

567: null;
568: else
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: end if;
573: return;
574: end LOCK_ROW;
575:

Line 607: app_exception.raise_exception;

603: end if;
604: else
605: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: end if;
609:
610: Before_DML(
611: p_action => 'UPDATE',

Line 738: APP_EXCEPTION.RAISE_EXCEPTION;

734: BEGIN
735: -- Preventing deletion of the Attendance Type records. As a part of Bug # 2729917
736: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
737: IGS_GE_MSG_STACK.ADD;
738: APP_EXCEPTION.RAISE_EXCEPTION;
739: END beforerowdelete;
740:
741: end IGS_EN_ATD_TYPE_PKG;