DBA Data[Home] [Help]

APPS.IGS_UC_COND_DETAILS_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 106: app_exception.raise_exception;

102: new_references.condition_name
103: ) THEN
104: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END IF;
108:
109: IF (((old_references.abbreviation = new_references.abbreviation)) OR
110: ((new_references.abbreviation IS NULL))) THEN

Line 117: app_exception.raise_exception;

113: new_references.abbreviation
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: END check_parent_existance;
121:

Line 190: app_exception.raise_exception;

186: IF (cur_rowid%FOUND) THEN
187: CLOSE cur_rowid;
188: fnd_message.set_name ('IGS', 'IGS_UC_UCOCDT_UCOC_FK');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: RETURN;
192: END IF;
193: CLOSE cur_rowid;
194:

Line 224: app_exception.raise_exception;

220: IF (cur_rowid%FOUND) THEN
221: CLOSE cur_rowid;
222: fnd_message.set_name ('IGS', 'IGS_UC_UCCD_UROA_FK');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: RETURN;
226: END IF;
227: CLOSE cur_rowid;
228:

Line 288: app_exception.raise_exception;

284: )
285: ) THEN
286: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: END IF;
290: check_parent_existance;
291: ELSIF (p_action = 'UPDATE') THEN
292: -- Call all the procedures related to Before Update.

Line 304: app_exception.raise_exception;

300: )
301: ) THEN
302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306: END IF;
307:
308: END before_dml;

Line 361: app_exception.raise_exception;

357: END IF;
358: ELSE
359: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363:
364: before_dml(
365: p_action => 'INSERT',

Line 464: app_exception.raise_exception;

460: IF (c1%notfound) THEN
461: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
462: igs_ge_msg_stack.add;
463: CLOSE c1;
464: app_exception.raise_exception;
465: RETURN;
466: END IF;
467: CLOSE c1;
468:

Line 480: app_exception.raise_exception;

476: NULL;
477: ELSE
478: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482:
483: RETURN;
484:

Line 531: app_exception.raise_exception;

527: END IF;
528: ELSE
529: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
530: igs_ge_msg_stack.add;
531: app_exception.raise_exception;
532: END IF;
533:
534: before_dml(
535: p_action => 'UPDATE',