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

Line 39: App_Exception.Raise_Exception;

35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:

Line 77: app_exception.raise_exception;

73: IF IGS_AD_VAL_APCOO.CRSP_VAL_ATT_CLOSED(new_references.attendance_type
74: ,v_message_name) = FALSE THEN
75: fnd_message.set_name('IGS',v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: app_exception.raise_exception;
78: END IF;
79: IF IGS_PS_VAL_ATL.CRSP_VAL_ATL_CAT(new_references.cal_type
80: ,v_message_name) = FALSE THEN
81: fnd_message.set_name('IGS',v_message_name);

Line 83: app_exception.raise_exception;

79: IF IGS_PS_VAL_ATL.CRSP_VAL_ATL_CAT(new_references.cal_type
80: ,v_message_name) = FALSE THEN
81: fnd_message.set_name('IGS',v_message_name);
82: IGS_GE_MSG_STACK.ADD;
83: app_exception.raise_exception;
84: END IF;
85: END IF;
86:
87:

Line 109: app_exception.raise_exception;

105: new_references.upper_enr_load_range,
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: v_rowid_saved := TRUE;
112: END AfterRowInsertUpdate2;
113:

Line 137: App_Exception.Raise_Exception;

133: if new_references.upper_enr_load_range <0 OR
134: new_references.upper_enr_load_range > 999.999 then
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: end if;
139: end if;
140: IF upper(column_name) = 'LOWER_ENR_LOAD_RANGE' OR
141: column_name is null then

Line 146: App_Exception.Raise_Exception;

142: if new_references.lower_enr_load_range<0 OR
143: new_references.lower_enr_load_range >999.999 then
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: end if;
148: end if;
149: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
150: column_name is null then

Line 154: App_Exception.Raise_Exception;

150: column_name is null then
151: if new_references.attendance_type <> upper(new_references.attendance_type) then
152: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: end if;
156: end if;
157: IF upper(column_name) = 'CAL_TYPE' OR
158: column_name is null then

Line 162: App_Exception.Raise_Exception;

158: column_name is null then
159: if new_references.cal_type <> upper(new_references.cal_type) then
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: end if;
164: end if;
165: END check_constraints;
166:

Line 179: App_Exception.Raise_Exception;

175: new_references.attendance_type
176: ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: end if;
181: END IF;
182:
183: IF (((old_references.cal_type = new_references.cal_type)) OR

Line 192: App_Exception.Raise_Exception;

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

Line 245: App_Exception.Raise_Exception;

241: IF (cur_rowid%FOUND) THEN
242: Close cur_rowid;
243: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ATL_ATT_FK');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: Return;
247: END IF;
248: Close cur_rowid;
249:

Line 271: App_Exception.Raise_Exception;

267: IF (cur_rowid%FOUND) THEN
268: Close cur_rowid;
269: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ATL_CAT_FK');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: Return;
273: END IF;
274: Close cur_rowid;
275:

Line 319: App_Exception.Raise_Exception;

315: new_references.attendance_type
316: ) THEN
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_constraints;
322: Check_Parent_Existance;
323: ELSIF (p_action = 'UPDATE') THEN

Line 338: App_Exception.Raise_Exception;

334: new_references.attendance_type
335: ) THEN
336: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340: Check_constraints;
341: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
342: Check_constraints;

Line 402: app_exception.raise_exception;

398: end if;
399: else
400: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
401: IGS_GE_MSG_STACK.ADD;
402: app_exception.raise_exception;
403: end if;
404: Before_DML (
405: p_action => 'INSERT',
406: x_rowid => X_ROWID,

Line 483: app_exception.raise_exception;

479: if (c1%notfound) then
480: close c1;
481: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
482: IGS_GE_MSG_STACK.ADD;
483: app_exception.raise_exception;
484: return;
485: end if;
486: close c1;
487:

Line 498: app_exception.raise_exception;

494: null;
495: else
496: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: return;
501: end LOCK_ROW;
502:

Line 532: app_exception.raise_exception;

528: end if;
529: else
530: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
531: IGS_GE_MSG_STACK.ADD;
532: app_exception.raise_exception;
533: end if;
534: Before_DML (
535: p_action => 'UPDATE',
536: x_rowid => X_ROWID,