APPS.IGS_HE_SUBMSN_RETURN_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 100: app_exception.raise_exception;

96: new_references.submission_name
97: ) THEN
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
103: IF (((old_references.user_return_subclass = new_references.user_return_subclass)) OR
104: ((new_references.user_return_subclass IS NULL))) THEN

Line 111: app_exception.raise_exception;

107: new_references.user_return_subclass
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;
115:

Line 190: app_exception.raise_exception;

186: (l_rowid IS NULL OR l_check_record_exist.rowid <> l_rowid) THEN
187: CLOSE cur_check_record_exist;
188: fnd_message.set_name('IGS','IGS_HE_DLHE_SUBRTN_EXIST');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: END IF ;
192: CLOSE cur_check_record_exist;
193: END IF;
194:

Line 263: app_exception.raise_exception;

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

Line 298: app_exception.raise_exception;

294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_HE_HESBRET_HEURCD_FK');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
301: CLOSE cur_rowid;
302:

Line 361: app_exception.raise_exception;

357: )
358: ) THEN
359: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363: check_parent_existance;
364: check_duplicate_dlhe_return;
365: ELSIF (p_action = 'UPDATE') THEN

Line 382: app_exception.raise_exception;

378: )
379: ) THEN
380: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: END IF;
384: check_duplicate_dlhe_return;
385: ELSIF (p_action = 'VALIDATE_DELETE') THEN
386: check_child_existance;

Line 441: app_exception.raise_exception;

437: END IF;
438: ELSE
439: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443:
444: SELECT igs_he_submsn_return_s.NEXTVAL
445: INTO x_sub_rtn_id

Line 543: app_exception.raise_exception;

539: IF (c1%notfound) THEN
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: igs_ge_msg_stack.add;
542: CLOSE c1;
543: app_exception.raise_exception;
544: RETURN;
545: END IF;
546: CLOSE c1;
547:

Line 558: app_exception.raise_exception;

554: NULL;
555: ELSE
556: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
557: igs_ge_msg_stack.add;
558: app_exception.raise_exception;
559: END IF;
560:
561: RETURN;
562:

Line 608: app_exception.raise_exception;

604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
611: before_dml(
612: p_action => 'UPDATE',