APPS.IGS_PR_ORG_STAT_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 103: app_exception.raise_exception;

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

Line 129: app_exception.raise_exception;

125: new_references.stat_type
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: ELSIF NOT igs_or_unit_pkg.get_pk_for_str_validation (
131: new_references.org_unit_cd
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 135: app_exception.raise_exception;

131: new_references.org_unit_cd
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: END check_parent_existance;
139:

Line 262: app_exception.raise_exception;

258: IF (cur_rowid%FOUND) THEN
259: CLOSE cur_rowid;
260: fnd_message.set_name ('IGS', 'IGS_PR_ORST_STTY_FK');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: RETURN;
264: END IF;
265: CLOSE cur_rowid;
266:

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

Line 348: app_exception.raise_exception;

344: )
345: ) THEN
346: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: END IF;
350: check_uniqueness;
351: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
352: check_uniqueness;

Line 410: app_exception.raise_exception;

406: END IF;
407: ELSE
408: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412:
413: before_dml(
414: p_action => 'INSERT',

Line 524: app_exception.raise_exception;

520: OR l_both_std_flag ='Y' ) THEN
521: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
522: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526: END IF;
527: END LOOP;
528: OPEN c2;

Line 534: app_exception.raise_exception;

530: IF c2%FOUND THEN
531: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
532: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536: CLOSE c2;
537: END after_dml;
538:

Line 586: app_exception.raise_exception;

582: IF (c1%notfound) THEN
583: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
584: igs_ge_msg_stack.add;
585: CLOSE c1;
586: app_exception.raise_exception;
587: RETURN;
588: END IF;
589: CLOSE c1;
590:

Line 604: app_exception.raise_exception;

600: NULL;
601: ELSE
602: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: END IF;
606:
607: RETURN;
608:

Line 656: app_exception.raise_exception;

652: END IF;
653: ELSE
654: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658:
659: before_dml(
660: p_action => 'UPDATE',