APPS.IGS_PE_LOCVENUE_USE_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 94: APP_EXCEPTION.RAISE_EXCEPTION;

90: new_references.site_use_code
91: ) THEN
92: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
93: IGS_GE_MSG_STACK.ADD;
94: APP_EXCEPTION.RAISE_EXCEPTION;
95: END IF;
96: END Check_Uniqueness ;
97:
98: PROCEDURE check_parent_existance AS

Line 118: app_exception.raise_exception;

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

Line 224: app_exception.raise_exception;

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

Line 281: app_exception.raise_exception;

277: )
278: ) THEN
279: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: END IF;
283: check_uniqueness;
284: check_parent_existance;
285: ELSIF (p_action = 'UPDATE') THEN

Line 297: app_exception.raise_exception;

293: )
294: ) THEN
295: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299: check_uniqueness;
300: END IF;
301:

Line 368: app_exception.raise_exception;

364: END IF;
365: ELSE
366: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370:
371: before_dml(
372: p_action => 'INSERT',

Line 466: app_exception.raise_exception;

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

Line 481: app_exception.raise_exception;

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

Line 533: app_exception.raise_exception;

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