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 IGS_GE_MSG_STACK

Line 53: IGS_GE_MSG_STACK.ADD;

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

Line 138: IGS_GE_MSG_STACK.ADD;

134: IF upper(column_name)= 'PERCENTAGE_ALLOCATION' OR column_name is null THEN
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:

Line 146: igs_ge_msg_stack.add;

142:
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:

Line 154: igs_ge_msg_stack.add;

150:
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:

Line 162: igs_ge_msg_stack.add;

158:
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:

Line 170: igs_ge_msg_stack.add;

166:
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:

Line 178: igs_ge_msg_stack.add;

174:
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:

Line 204: IGS_GE_MSG_STACK.ADD;

200: new_references.instructor_id
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

Line 229: IGS_GE_MSG_STACK.ADD;

225: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
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;

Line 336: IGS_GE_MSG_STACK.ADD;

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

Line 400: IGS_GE_MSG_STACK.ADD;

396: Null;
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;

Line 420: IGS_GE_MSG_STACK.ADD;

416: -- Call all the procedures related to Before Insert.
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;

Line 513: IGS_GE_MSG_STACK.ADD;

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

Line 622: IGS_GE_MSG_STACK.ADD;

618: open c1;
619: fetch c1 into tlinfo;
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;

Line 648: IGS_GE_MSG_STACK.ADD;

644: ) then
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;

Line 696: IGS_GE_MSG_STACK.ADD;

692: X_LAST_UPDATE_LOGIN := -1;
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',