DBA Data[Home] [Help]

APPS.IGS_HE_ST_PROG_ALL_PKG dependencies on APP_EXCEPTION

Line 82: app_exception.raise_exception;

78: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
79: CLOSE cur_old_ref_values;
80: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
81: igs_ge_msg_stack.add;
82: app_exception.raise_exception;
83: RETURN;
84: END IF;
85: CLOSE cur_old_ref_values;
86:

Line 159: app_exception.raise_exception;

155: )
156: ) THEN
157: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception;
160: END IF;
161:
162: END check_uniqueness;
163:

Line 188: app_exception.raise_exception;

184: new_references.version_number
185: ) THEN
186: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190:
191: END check_parent_existance;
192:

Line 295: app_exception.raise_exception;

291: IF (cur_rowid%FOUND) THEN
292: CLOSE cur_rowid;
293: fnd_message.set_name ('IGS', 'IGS_HE_HSPR_CRV_FK');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: RETURN;
297: END IF;
298: CLOSE cur_rowid;
299:

Line 321: app_exception.raise_exception;

317: IF cur_prog_attempt%FOUND THEN
318: CLOSE cur_prog_attempt;
319: fnd_message.set_name ('IGS', 'IGS_HE_CANT_DEL_SPA_EXIST');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: RETURN;
323: END IF;
324: CLOSE cur_prog_attempt;
325:

Line 444: app_exception.raise_exception;

440: )
441: ) THEN
442: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446: check_uniqueness;
447: check_parent_existance;
448: ELSIF (p_action = 'UPDATE') THEN

Line 463: app_exception.raise_exception;

459: )
460: ) THEN
461: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
462: igs_ge_msg_stack.add;
463: app_exception.raise_exception;
464: END IF;
465: check_uniqueness;
466: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
467: check_uniqueness;

Line 558: app_exception.raise_exception;

554: END IF;
555: ELSE
556: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
557: igs_ge_msg_stack.add;
558: app_exception.raise_exception;
559: END IF;
560:
561: SELECT igs_he_st_prog_all_s.NEXTVAL
562: INTO x_hesa_st_prog_id

Line 811: app_exception.raise_exception;

807: IF (c1%notfound) THEN
808: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
809: igs_ge_msg_stack.add;
810: CLOSE c1;
811: app_exception.raise_exception;
812: RETURN;
813: END IF;
814: CLOSE c1;
815:

Line 856: app_exception.raise_exception;

852: NULL;
853: ELSE
854: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
855: igs_ge_msg_stack.add;
856: app_exception.raise_exception;
857: END IF;
858:
859: RETURN;
860:

Line 942: app_exception.raise_exception;

938: END IF;
939: ELSE
940: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
941: igs_ge_msg_stack.add;
942: app_exception.raise_exception;
943: END IF;
944:
945: before_dml(
946: p_action => 'UPDATE',