DBA Data[Home] [Help]

APPS.IGS_CO_OU_CO_REF_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

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

Line 124: app_exception.raise_exception;

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

Line 133: app_exception.raise_exception;

129: IF NOT (new_references.sequence_number BETWEEN 1
130: AND 999999) THEN
131: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135: END IF;
136:
137: IF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name IS NULL) THEN

Line 142: app_exception.raise_exception;

138: IF NOT (new_references.ci_sequence_number BETWEEN 1
139: AND 999999) THEN
140: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144: END IF;
145:
146: END check_constraints;

Line 172: app_exception.raise_exception;

168: new_references.ci_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.unit_cd = new_references.unit_cd) AND
176: (old_references.uv_version_number = new_references.uv_version_number)) OR

Line 186: app_exception.raise_exception;

182: new_references.uv_version_number
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
189: IF (((old_references.course_cd = new_references.course_cd) AND
190: (old_references.cv_version_number = new_references.cv_version_number)) OR

Line 200: app_exception.raise_exception;

196: new_references.cv_version_number
197: ) THEN
198: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: END IF;
202:
203: IF (((old_references.person_id = new_references.person_id) AND
204: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 220: app_exception.raise_exception;

216: new_references.issue_dt
217: ) THEN
218: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222:
223: END check_parent_existance;
224:

Line 298: app_exception.raise_exception;

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

Line 335: app_exception.raise_exception;

331: IF (cur_rowid%FOUND) THEN
332: CLOSE cur_rowid;
333: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: RETURN;
337: END IF;
338: CLOSE cur_rowid;
339:

Line 372: app_exception.raise_exception;

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

Line 413: app_exception.raise_exception;

409: IF (cur_rowid%FOUND) THEN
410: CLOSE cur_rowid;
411: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: RETURN;
415: END IF;
416: CLOSE cur_rowid;
417:

Line 492: app_exception.raise_exception;

488: )
489: ) THEN
490: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494: check_constraints;
495: check_parent_existance;
496: ELSIF (p_action = 'UPDATE') THEN

Line 512: app_exception.raise_exception;

508: )
509: ) THEN
510: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514: check_constraints;
515: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
516: check_constraints;

Line 596: app_exception.raise_exception;

592: END IF;
593: ELSE
594: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598:
599: before_dml(
600: p_action => 'INSERT',

Line 733: app_exception.raise_exception;

729: IF (c1%notfound) THEN
730: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
731: igs_ge_msg_stack.add;
732: CLOSE c1;
733: app_exception.raise_exception;
734: RETURN;
735: END IF;
736: CLOSE c1;
737:

Line 752: app_exception.raise_exception;

748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
755: RETURN;
756:

Line 812: app_exception.raise_exception;

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