DBA Data[Home] [Help]

APPS.IGS_CO_S_PER_LT_PARM_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 116: app_exception.raise_exception;

112: IF NOT (new_references.splrg_sequence_number BETWEEN 1
113: AND 9999999999) THEN
114: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118: END IF;
119:
120: IF (UPPER(column_name) = 'SPL_SEQUENCE_NUMBER' OR column_name IS NULL) THEN

Line 125: app_exception.raise_exception;

121: IF NOT (new_references.spl_sequence_number BETWEEN 1
122: AND 9999999999) THEN
123: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: END IF;
127: END IF;
128:
129: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN

Line 134: app_exception.raise_exception;

130: IF NOT (new_references.sequence_number BETWEEN 1
131: AND 9999999999) 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 167: app_exception.raise_exception;

163: new_references.letter_reference_number
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:
170: IF (((old_references.person_id = new_references.person_id) AND
171: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 187: app_exception.raise_exception;

183: new_references.spl_sequence_number
184: ) THEN
185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189:
190: IF (((old_references.letter_order_number = new_references.letter_order_number) AND
191: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 207: app_exception.raise_exception;

203: new_references.letter_repeating_group_cd
204: ) THEN
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: IF (((old_references.person_id = new_references.person_id) AND
211: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 233: app_exception.raise_exception;

229: new_references.splrg_sequence_number
230: ) THEN
231: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235:
236: END check_parent_existance;
237:

Line 315: app_exception.raise_exception;

311: IF (cur_rowid%FOUND) THEN
312: CLOSE cur_rowid;
313: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: RETURN;
317: END IF;
318: CLOSE cur_rowid;
319:

Line 356: app_exception.raise_exception;

352: IF (cur_rowid%FOUND) THEN
353: CLOSE cur_rowid;
354: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: RETURN;
358: END IF;
359: CLOSE cur_rowid;
360:

Line 397: app_exception.raise_exception;

393: IF (cur_rowid%FOUND) THEN
394: CLOSE cur_rowid;
395: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: RETURN;
399: END IF;
400: CLOSE cur_rowid;
401:

Line 442: app_exception.raise_exception;

438: IF (cur_rowid%FOUND) THEN
439: CLOSE cur_rowid;
440: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;
445: CLOSE cur_rowid;
446:

Line 516: app_exception.raise_exception;

512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_constraints;
519: check_parent_existance;
520: ELSIF (p_action = 'UPDATE') THEN

Line 537: app_exception.raise_exception;

533: )
534: ) THEN
535: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
536: igs_ge_msg_stack.add;
537: app_exception.raise_exception;
538: END IF;
539: check_constraints;
540: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
541: check_constraints;

Line 619: app_exception.raise_exception;

615: END IF;
616: ELSE
617: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:
622: before_dml(
623: p_action => 'INSERT',

Line 742: app_exception.raise_exception;

738: IF (c1%notfound) THEN
739: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
740: igs_ge_msg_stack.add;
741: CLOSE c1;
742: app_exception.raise_exception;
743: RETURN;
744: END IF;
745: CLOSE c1;
746:

Line 758: app_exception.raise_exception;

754: NULL;
755: ELSE
756: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
760:
761: RETURN;
762:

Line 815: app_exception.raise_exception;

811: END IF;
812: ELSE
813: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
814: igs_ge_msg_stack.add;
815: app_exception.raise_exception;
816: END IF;
817:
818: before_dml(
819: p_action => 'UPDATE',