APPS.IGS_PR_INST_STAT_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 101: app_exception.raise_exception;

97: )
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_PR_DUP_DIS_ORD');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: END check_uniqueness;
105:

Line 126: app_exception.raise_exception;

122: new_references.stat_type
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:

Line 246: app_exception.raise_exception;

242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_PR_INST_STTY_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;
250:

Line 309: app_exception.raise_exception;

305: )
306: ) THEN
307: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311: check_uniqueness;
312: check_parent_existance;
313: ELSIF (p_action = 'UPDATE') THEN

Line 328: app_exception.raise_exception;

324: )
325: ) THEN
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330: check_uniqueness;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
332: check_uniqueness;

Line 395: app_exception.raise_exception;

391: END IF;
392: ELSE
393: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END IF;
397:
398: before_dml(
399: p_action => 'INSERT',

Line 504: app_exception.raise_exception;

500: OR l_both_std_flag ='Y' ) THEN
501: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
502: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: END IF;
507: END LOOP;
508:

Line 515: app_exception.raise_exception;

511: IF c2%FOUND THEN
512: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
513: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
517: CLOSE c2;
518:
519: /*

Line 573: app_exception.raise_exception;

569: IF (c1%notfound) THEN
570: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
571: igs_ge_msg_stack.add;
572: CLOSE c1;
573: app_exception.raise_exception;
574: RETURN;
575: END IF;
576: CLOSE c1;
577:

Line 591: app_exception.raise_exception;

587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: RETURN;
595:

Line 642: app_exception.raise_exception;

638: END IF;
639: ELSE
640: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644:
645: before_dml(
646: p_action => 'UPDATE',