APPS.IGS_HE_SUBMSN_RETURN_PKG dependencies on IGS_GE_MSG_STACK

Line 50: igs_ge_msg_stack.add;

46: FETCH cur_old_ref_values INTO old_references;
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;

Line 99: igs_ge_msg_stack.add;

95: ELSIF NOT igs_he_submsn_header_pkg.get_pk_for_validation (
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

Line 110: igs_ge_msg_stack.add;

106: ELSIF NOT igs_he_usr_rtn_clas_pkg.get_pk_for_validation (
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;

Line 189: igs_ge_msg_stack.add;

185: IF cur_check_record_exist%FOUND AND
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;

Line 262: igs_ge_msg_stack.add;

258: FETCH cur_rowid INTO lv_rowid;
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;

Line 297: igs_ge_msg_stack.add;

293: FETCH cur_rowid INTO lv_rowid;
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;

Line 360: igs_ge_msg_stack.add;

356: new_references.return_name
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;

Line 381: igs_ge_msg_stack.add;

377: new_references.return_name
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

Line 440: igs_ge_msg_stack.add;

436: x_last_update_login := -1;
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

Line 541: igs_ge_msg_stack.add;

537: OPEN c1;
538: FETCH c1 INTO tlinfo;
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;

Line 557: igs_ge_msg_stack.add;

553: ) THEN
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;

Line 607: igs_ge_msg_stack.add;

603: x_last_update_login := -1;
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(