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

Line 51: app_exception.raise_exception;

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;
55:

Line 99: app_exception.raise_exception;

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;
103:

Line 111: App_Exception.Raise_Exception;

107: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.group_id <> old_references.group_id ) ) THEN
108: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(new_references.group_id,p_message_name) THEN
109: Fnd_Message.Set_Name('IGS', p_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: END BeforeInsertUpdate;
115:

Line 152: app_exception.raise_exception;

148: new_references.rsv_org_unit_pri_id
149: ) THEN
150: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
151: igs_ge_msg_stack.add;
152: app_exception.raise_exception;
153: ELSE
154: OPEN c_priority;
155: FETCH c_priority into priority_value1;
156: IF (c_priority%found) THEN

Line 164: app_exception.raise_exception;

160: new_references.preference_version ) THEN
161: CLOSE c_priority;
162: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: ELSE
166: CLOSE c_priority;
167: END IF;
168: ELSIF (priority_value1 = 'PROGRAM_STAGE') THEN

Line 174: app_exception.raise_exception;

170: new_references.preference_code ) THEN
171: CLOSE c_priority;
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: ELSE
176: CLOSE c_priority;
177: END IF;
178: ELSIF (priority_value1 = 'UNIT_SET') THEN

Line 185: app_exception.raise_exception;

181: new_references.preference_version ) THEN
182: CLOSE c_priority;
183: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
184: igs_ge_msg_stack.add;
185: app_exception.raise_exception;
186: ELSE
187: CLOSE c_priority;
188: END IF;
189: ELSIF (priority_value1 = 'PERSON_GRP') THEN

Line 195: app_exception.raise_exception;

191: new_references.group_id ) THEN
192: CLOSE c_priority;
193: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: ELSE
197: CLOSE c_priority;
198: END IF;
199: ELSIF (priority_value1 = 'ORG_UNIT') THEN

Line 207: app_exception.raise_exception;

203: CLOSE c_check_hz_exists;
204: CLOSE c_priority;
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: ELSE
209: CLOSE c_check_hz_exists;
210: CLOSE c_priority;
211: END IF;

Line 319: app_exception.raise_exception;

315: IF (cur_rowid%FOUND) THEN
316: CLOSE cur_rowid;
317: fnd_message.set_name ('IGS', 'IGS_PS_USPF_USPR_FK');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: RETURN;
321: END IF;
322: CLOSE cur_rowid;
323:

Line 353: app_exception.raise_exception;

349: IF (cur_rowid%FOUND) THEN
350: CLOSE cur_rowid;
351: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_CRV_FK');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: RETURN;
355: END IF;
356: CLOSE cur_rowid;
357:

Line 387: app_exception.raise_exception;

383: IF (cur_rowid%FOUND) THEN
384: CLOSE cur_rowid;
385: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_CSTT_FK');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: RETURN;
389: END IF;
390: CLOSE cur_rowid;
391:

Line 422: app_exception.raise_exception;

418: IF (cur_rowid%FOUND) THEN
419: CLOSE cur_rowid;
420: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_US_FK');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: RETURN;
424: END IF;
425: CLOSE cur_rowid;
426:

Line 456: app_exception.raise_exception;

452: IF (cur_rowid%FOUND) THEN
453: CLOSE cur_rowid;
454: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: RETURN;
458: END IF;
459: CLOSE cur_rowid;
460:

Line 519: app_exception.raise_exception;

515: )
516: ) THEN
517: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
518: igs_ge_msg_stack.add;
519: app_exception.raise_exception;
520: END IF;
521: check_uniqueness;
522: check_parent_existance;
523: ELSIF (p_action = 'UPDATE') THEN

Line 536: app_exception.raise_exception;

532: )
533: ) THEN
534: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
535: igs_ge_msg_stack.add;
536: app_exception.raise_exception;
537: END IF;
538: check_uniqueness;
539: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
540: check_uniqueness;

Line 595: app_exception.raise_exception;

591: END IF;
592: ELSE
593: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597:
598: SELECT igs_ps_rsv_orgun_prf_s.NEXTVAL
599: INTO x_rsv_org_unit_prf_id

Line 699: app_exception.raise_exception;

695: IF (c1%notfound) THEN
696: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
697: igs_ge_msg_stack.add;
698: CLOSE c1;
699: app_exception.raise_exception;
700: RETURN;
701: END IF;
702: CLOSE c1;
703:

Line 716: app_exception.raise_exception;

712: NULL;
713: ELSE
714: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
719: RETURN;
720:

Line 766: app_exception.raise_exception;

762: END IF;
763: ELSE
764: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
765: igs_ge_msg_stack.add;
766: app_exception.raise_exception;
767: END IF;
768:
769: before_dml(
770: p_action => 'UPDATE',