APPS.IGS_EN_DL_OFFSET_CONS_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 123: app_exception.raise_exception;

119:
120: IF new_references.deadline_type NOT IN ( 'E' , 'R' ) THEN
121: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
122: IGS_GE_MSG_STACK.ADD;
123: app_exception.raise_exception;
124: END IF;
125:
126: END IF;
127:

Line 134: app_exception.raise_exception;

130: new_references.constraint_resolution > 7 OR
131: new_references.constraint_resolution = 0 THEN
132: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: app_exception.raise_exception;
135: END IF;
136: END IF;
137:
138: END check_constraints;

Line 161: app_exception.raise_exception;

157: new_references.non_std_usec_dls_id
158: ))) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: ELSIF (new_references.deadline_type='R' AND (NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
163: new_references.non_std_usec_dls_id
164: ))) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 167: app_exception.raise_exception;

163: new_references.non_std_usec_dls_id
164: ))) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169: END check_parent_existance;
170:
171:

Line 274: app_exception.raise_exception;

270: IF (cur_rowid%FOUND) THEN
271: CLOSE cur_rowid;
272: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NSUD_FK');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: RETURN;
276: END IF;
277: CLOSE cur_rowid;
278:

Line 308: app_exception.raise_exception;

304: IF (cur_rowid%FOUND) THEN
305: CLOSE cur_rowid;
306: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NR_FK');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: RETURN;
310: END IF;
311: CLOSE cur_rowid;
312:

Line 366: app_exception.raise_exception;

362: )
363: ) THEN
364: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368: check_uniqueness;
369: check_constraints;
370: check_parent_existance;

Line 384: app_exception.raise_exception;

380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
387: check_constraints;
388: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 442: app_exception.raise_exception;

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

Line 541: app_exception.raise_exception;

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

Line 557: app_exception.raise_exception;

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

Line 606: app_exception.raise_exception;

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