APPS.IGS_CO_S_PERLT_RPTGP_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 112: app_exception.raise_exception;

108: IF NOT (new_references.spl_sequence_number BETWEEN 1
109: AND 9999999999) THEN
110: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114: END IF;
115:
116: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN

Line 121: app_exception.raise_exception;

117: IF NOT (new_references.sequence_number BETWEEN 1
118: AND 9999999999) THEN
119: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
124:
125: IF (UPPER(column_name) = 'SUP_SPLRG_SEQUENCE_NUMBER' OR column_name IS NULL) THEN

Line 130: app_exception.raise_exception;

126: IF NOT (new_references.sup_splrg_sequence_number BETWEEN 1
127: AND 9999999999) THEN
128: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132: END IF;
133:
134: END check_constraints;

Line 172: app_exception.raise_exception;

168: new_references.sup_splrg_sequence_number
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: IF (((old_references.person_id = new_references.person_id) AND
176: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 192: app_exception.raise_exception;

188: new_references.spl_sequence_number
189: ) THEN
190: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception;
193: END IF;
194:
195: IF (((old_references.correspondence_type = new_references.correspondence_type) AND
196: (old_references.letter_reference_number = new_references.letter_reference_number) AND

Line 209: app_exception.raise_exception;

205: new_references.letter_repeating_group_cd
206: ) THEN
207: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211:
212: END check_parent_existance;
213:

Line 330: app_exception.raise_exception;

326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;
334:

Line 371: app_exception.raise_exception;

367: IF (cur_rowid%FOUND) THEN
368: CLOSE cur_rowid;
369: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: RETURN;
373: END IF;
374: CLOSE cur_rowid;
375:

Line 410: app_exception.raise_exception;

406: IF (cur_rowid%FOUND) THEN
407: CLOSE cur_rowid;
408: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE cur_rowid;
414:

Line 480: app_exception.raise_exception;

476: )
477: ) THEN
478: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482: check_constraints;
483: check_parent_existance;
484: ELSIF (p_action = 'UPDATE') THEN

Line 504: app_exception.raise_exception;

500: )
501: ) THEN
502: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: check_constraints;
507: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
508: check_constraints;

Line 586: app_exception.raise_exception;

582: END IF;
583: ELSE
584: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: before_dml(
590: p_action => 'INSERT',

Line 697: app_exception.raise_exception;

693: IF (c1%notfound) THEN
694: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
695: igs_ge_msg_stack.add;
696: CLOSE c1;
697: app_exception.raise_exception;
698: RETURN;
699: END IF;
700: CLOSE c1;
701:

Line 710: app_exception.raise_exception;

706: NULL;
707: ELSE
708: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
709: igs_ge_msg_stack.add;
710: app_exception.raise_exception;
711: END IF;
712:
713: RETURN;
714:

Line 765: app_exception.raise_exception;

761: END IF;
762: ELSE
763: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
764: igs_ge_msg_stack.add;
765: app_exception.raise_exception;
766: END IF;
767:
768: before_dml(
769: p_action => 'UPDATE',