APPS.IGS_PS_RSV_USEC_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 138: app_exception.raise_exception;

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;
142: IF (c_priority%found) THEN

Line 150: app_exception.raise_exception;

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;
154: ELSIF (priority_value1 = 'PROGRAM_STAGE') THEN

Line 160: app_exception.raise_exception;

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;
164: ELSIF (priority_value1 = 'UNIT_SET') THEN

Line 171: app_exception.raise_exception;

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;
175: ELSIF (priority_value1 = 'PERSON_GRP') THEN

Line 181: app_exception.raise_exception;

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;
185: ELSIF (priority_value1 = 'ORG_UNIT') THEN

Line 193: app_exception.raise_exception;

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;
197: END IF;

Line 304: app_exception.raise_exception;

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

Line 339: app_exception.raise_exception;

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

Line 373: app_exception.raise_exception;

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

Line 408: app_exception.raise_exception;

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

Line 442: app_exception.raise_exception;

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

Line 456: App_Exception.Raise_Exception;

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

Line 515: app_exception.raise_exception;

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;
519: ELSIF (p_action = 'UPDATE') THEN

Line 532: app_exception.raise_exception;

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
536: check_uniqueness;

Line 591: app_exception.raise_exception;

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
595: INTO x_rsv_usec_prf_id

Line 695: app_exception.raise_exception;

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;
698: CLOSE c1;
699:

Line 712: app_exception.raise_exception;

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

Line 762: app_exception.raise_exception;

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(
766: p_action => 'UPDATE',