APPS.IGS_HE_ST_SPA_UT_ALL_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 102: app_exception.raise_exception;

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

Line 146: app_exception.raise_exception;

142: IF c_check_parent%NOTFOUND THEN
143: CLOSE c_check_parent ;
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: ELSE
148: CLOSE c_check_parent ;
149: END IF ;
150: END IF;

Line 258: app_exception.raise_exception;

254: IF (cur_rowid%FOUND) THEN
255: CLOSE cur_rowid;
256: fnd_message.set_name ('IGS', 'IGS_HE_HSPAU_HSPA_FK');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: RETURN;
260: END IF;
261: CLOSE cur_rowid;
262:

Line 321: app_exception.raise_exception;

317: )
318: ) THEN
319: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323: check_uniqueness;
324: check_parent_existance;
325: ELSIF (p_action = 'UPDATE') THEN

Line 337: app_exception.raise_exception;

333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: check_uniqueness;

Line 397: app_exception.raise_exception;

393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: SELECT igs_he_st_spa_ut_all_s.NEXTVAL
401: INTO x_hesa_st_spau_id

Line 507: app_exception.raise_exception;

503: IF (c1%notfound) THEN
504: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
505: igs_ge_msg_stack.add;
506: CLOSE c1;
507: app_exception.raise_exception;
508: RETURN;
509: END IF;
510: CLOSE c1;
511:

Line 524: app_exception.raise_exception;

520: NULL;
521: ELSE
522: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
527: RETURN;
528:

Line 577: app_exception.raise_exception;

573: END IF;
574: ELSE
575: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
576: igs_ge_msg_stack.add;
577: app_exception.raise_exception;
578: END IF;
579:
580: before_dml(
581: p_action => 'UPDATE',