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_RSV_USEC_PRF_PKG dependencies on IGS_GE_MSG_STACK

Line 50: igs_ge_msg_stack.add;

46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
54: CLOSE cur_old_ref_values;

Line 98: igs_ge_msg_stack.add;

94: new_references.preference_code
95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: END check_uniqueness;

Line 137: igs_ge_msg_stack.add;

133: ELSIF NOT igs_ps_rsv_usec_pri_pkg.get_pk_for_validation (
134: new_references.rsv_usec_pri_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: ELSE
140: OPEN c_priority;
141: FETCH c_priority INTO priority_value1;

Line 149: igs_ge_msg_stack.add;

145: new_references.preference_code,
146: new_references.preference_version ) THEN
147: CLOSE c_priority;
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: ELSE
152: CLOSE c_priority;
153: END IF;

Line 159: igs_ge_msg_stack.add;

155: IF NOT igs_ps_stage_type_pkg.get_pk_for_validation(
156: new_references.preference_code ) THEN
157: CLOSE c_priority;
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: ELSE
162: CLOSE c_priority;
163: END IF;

Line 170: igs_ge_msg_stack.add;

166: new_references.preference_code,
167: new_references.preference_version ) THEN
168: CLOSE c_priority;
169: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: ELSE
173: CLOSE c_priority;
174: END IF;

Line 180: igs_ge_msg_stack.add;

176: IF NOT igs_pe_persid_group_pkg.get_pk_for_validation(
177: new_references.group_id ) THEN
178: CLOSE c_priority;
179: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: ELSE
183: CLOSE c_priority;
184: END IF;

Line 192: igs_ge_msg_stack.add;

188: IF c_check_hz_exists%NotFound THEN
189: CLOSE c_check_hz_exists;
190: CLOSE c_priority;
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: ELSE
195: CLOSE c_check_hz_exists;
196: CLOSE c_priority;

Line 303: igs_ge_msg_stack.add;

299: FETCH cur_rowid INTO lv_rowid;
300: IF (cur_rowid%FOUND) THEN
301: CLOSE cur_rowid;
302: fnd_message.set_name ('IGS', 'IGS_PS_USPF_USPR_FK');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: RETURN;
306: END IF;
307: CLOSE cur_rowid;

Line 338: igs_ge_msg_stack.add;

334: FETCH cur_rowid INTO lv_rowid;
335: IF (cur_rowid%FOUND) THEN
336: CLOSE cur_rowid;
337: fnd_message.set_name ('IGS', 'IGS_PS_USPF_CRV_FK');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: RETURN;
341: END IF;
342: CLOSE cur_rowid;

Line 372: igs_ge_msg_stack.add;

368: FETCH cur_rowid INTO lv_rowid;
369: IF (cur_rowid%FOUND) THEN
370: CLOSE cur_rowid;
371: fnd_message.set_name ('IGS', 'IGS_PS_USPF_CSTT_FK');
372: igs_ge_msg_stack.add;
373: app_exception.raise_exception;
374: RETURN;
375: END IF;
376: CLOSE cur_rowid;

Line 407: igs_ge_msg_stack.add;

403: FETCH cur_rowid INTO lv_rowid;
404: IF (cur_rowid%FOUND) THEN
405: CLOSE cur_rowid;
406: fnd_message.set_name ('IGS', 'IGS_PS_USPF_US_FK');
407: igs_ge_msg_stack.add;
408: app_exception.raise_exception;
409: RETURN;
410: END IF;
411: CLOSE cur_rowid;

Line 441: igs_ge_msg_stack.add;

437: FETCH cur_rowid INTO lv_rowid;
438: IF (cur_rowid%FOUND) THEN
439: CLOSE cur_rowid;
440: fnd_message.set_name ('IGS', 'IGS_PS_USPF_HZ_PARTIES_FK');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;
445: CLOSE cur_rowid;

Line 455: IGS_GE_MSG_STACK.ADD;

451: BEGIN
452: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.group_id <> old_references.group_id ) ) THEN
453: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(new_references.group_id,p_message_name) THEN
454: Fnd_Message.Set_Name('IGS', p_message_name);
455: IGS_GE_MSG_STACK.ADD;
456: App_Exception.Raise_Exception;
457: END IF;
458: END IF;
459: END BeforeInsertUpdate;

Line 514: igs_ge_msg_stack.add;

510: new_references.rsv_usec_prf_id
511: )
512: ) THEN
513: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
517: check_uniqueness;
518: check_parent_existance;

Line 531: igs_ge_msg_stack.add;

527: new_references.rsv_usec_prf_id
528: )
529: ) THEN
530: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: END IF;
534: check_uniqueness;
535: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 590: igs_ge_msg_stack.add;

586: x_last_update_login := -1;
587: END IF;
588: ELSE
589: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: SELECT igs_ps_rsv_usec_prf_s.NEXTVAL

Line 693: igs_ge_msg_stack.add;

689: OPEN c1;
690: FETCH c1 INTO tlinfo;
691: IF (c1%notfound) THEN
692: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
693: igs_ge_msg_stack.add;
694: CLOSE c1;
695: app_exception.raise_exception;
696: RETURN;
697: END IF;

Line 711: igs_ge_msg_stack.add;

707: ) THEN
708: NULL;
709: ELSE
710: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
711: igs_ge_msg_stack.add;
712: app_exception.raise_exception;
713: END IF;
714:
715: RETURN;

Line 761: igs_ge_msg_stack.add;

757: x_last_update_login := -1;
758: END IF;
759: ELSE
760: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
761: igs_ge_msg_stack.add;
762: app_exception.raise_exception;
763: END IF;
764:
765: before_dml(