DBA Data[Home] [Help]

APPS.IGS_HE_SUBMSN_AWD_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 104: app_exception.raise_exception;

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

Line 130: app_exception.raise_exception;

126: new_references.submission_name
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132:
133: END check_parent_existance;
134:

Line 241: app_exception.raise_exception;

237: IF (cur_rowid%FOUND) THEN
238: CLOSE cur_rowid;
239: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: RETURN;
243: END IF;
244: CLOSE cur_rowid;
245:

Line 304: app_exception.raise_exception;

300: )
301: ) THEN
302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306: check_uniqueness;
307: check_parent_existance;
308: ELSIF (p_action = 'UPDATE') THEN

Line 320: app_exception.raise_exception;

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

Line 375: app_exception.raise_exception;

371: ELSE
372: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
373: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.INSERT_ROW');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:
378: x_sub_awd_id := NULL;
379:

Line 474: app_exception.raise_exception;

470: IF (c1%notfound) THEN
471: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
472: igs_ge_msg_stack.add;
473: CLOSE c1;
474: app_exception.raise_exception;
475: RETURN;
476: END IF;
477: CLOSE c1;
478:

Line 492: app_exception.raise_exception;

488: NULL;
489: ELSE
490: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494:
495: RETURN;
496:

Line 544: app_exception.raise_exception;

540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.UPDATE_ROW');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:
547: before_dml(
548: p_action => 'UPDATE',