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

Line 54: App_Exception.Raise_Exception;

50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
51: Close cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: Return;
56: END IF;
57: Close cur_old_ref_values;
58:

Line 139: App_Exception.Raise_Exception;

135: IF new_references.percentage_allocation not between 0.00 and 999.99 THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_PS_LGCY_PTS_RANGE_0_999');
137: fnd_message.set_token('PARAM', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PERCENTAGE','LEGACY_TOKENS'));
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142:
143: IF upper(column_name)= 'INSTRUCTIONAL_LOAD_LECTURE' OR column_name is null THEN

Line 147: app_exception.raise_exception;

143: IF upper(column_name)= 'INSTRUCTIONAL_LOAD_LECTURE' OR column_name is null THEN
144: IF new_references.instructional_load_lecture not between 0 and 9999.99 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)= 'INSTRUCTIONAL_LOAD_LAB' OR column_name is null THEN

Line 155: app_exception.raise_exception;

151: IF upper(column_name)= 'INSTRUCTIONAL_LOAD_LAB' OR column_name is null THEN
152: IF new_references.instructional_load_lab not between 0 and 9999.99 THEN
153: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157: END IF;
158:
159: IF upper(column_name)= 'INSTRUCTIONAL_LOAD' OR column_name is null THEN

Line 163: app_exception.raise_exception;

159: IF upper(column_name)= 'INSTRUCTIONAL_LOAD' OR column_name is null THEN
160: IF new_references.instructional_load not between 0 and 9999.99 THEN
161: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165: END IF;
166:
167: IF upper(column_name)= 'CONFIRMED_FLAG' OR column_name is null THEN

Line 171: app_exception.raise_exception;

167: IF upper(column_name)= 'CONFIRMED_FLAG' OR column_name is null THEN
168: IF new_references.confirmed_flag NOT IN ('Y','N') THEN
169: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173: END IF;
174:
175: IF upper(column_name)= 'LEAD_INSTRUCTOR_FLAG' OR column_name is null THEN

Line 179: app_exception.raise_exception;

175: IF upper(column_name)= 'LEAD_INSTRUCTOR_FLAG' OR column_name is null THEN
176: IF new_references.lead_instructor_flag NOT IN ('Y','N') THEN
177: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: END IF;
182:
183: END Check_Constraints;

Line 205: app_exception.raise_exception;

201:
202: ) THEN
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
204: IGS_GE_MSG_STACK.ADD;
205: app_exception.raise_exception;
206: END IF;
207: END Check_Uniqueness ;
208: PROCEDURE Check_Parent_Existance AS
209: /*************************************************************

Line 230: App_Exception.Raise_Exception;

226: new_references.uoo_id
227: ) THEN
228: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232:
233: END Check_Parent_Existance;
234:

Line 337: App_Exception.Raise_Exception;

333: IF (cur_rowid%FOUND) THEN
334: Close cur_rowid;
335: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USTR_UOO_UFK');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: Return;
339: END IF;
340: Close cur_rowid;
341:

Line 401: App_Exception.Raise_Exception;

397: IF Get_Pk_For_Validation(
398: new_references.unit_section_teach_resp_id) THEN
399: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: END IF;
403: Check_Uniqueness;
404: Check_Constraints;
405: Check_Parent_Existance;

Line 421: App_Exception.Raise_Exception;

417: IF Get_PK_For_Validation (
418: new_references.unit_section_teach_resp_id) THEN
419: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423: Check_Uniqueness;
424: Check_Constraints;
425: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 514: app_exception.raise_exception;

510: end if;
511: else
512: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
513: IGS_GE_MSG_STACK.ADD;
514: app_exception.raise_exception;
515: end if;
516:
517: SELECT
518: igs_ps_usec_tch_resp_s.NEXTVAL

Line 624: app_exception.raise_exception;

620: if (c1%notfound) then
621: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
622: IGS_GE_MSG_STACK.ADD;
623: close c1;
624: app_exception.raise_exception;
625: return;
626: end if;
627: close c1;
628: if ((tlinfo.INSTRUCTOR_ID = X_INSTRUCTOR_ID)

Line 649: app_exception.raise_exception;

645: null;
646: else
647: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
648: IGS_GE_MSG_STACK.ADD;
649: app_exception.raise_exception;
650: end if;
651: return;
652: end LOCK_ROW;
653: Procedure UPDATE_ROW (

Line 697: app_exception.raise_exception;

693: end if;
694: else
695: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
696: IGS_GE_MSG_STACK.ADD;
697: app_exception.raise_exception;
698: end if;
699: Before_DML(
700: p_action=>'UPDATE',
701: x_rowid=>X_ROWID,