APPS.IGS_AD_LOCVENUE_ADDR_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 103: app_exception.raise_exception;

99: IF (UPPER(column_name) = 'SOURCE_TYPE' OR column_name IS NULL) THEN
100: IF NOT (new_references.source_type IN ('L','V')) THEN
101: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105: END IF;
106:
107: IF (UPPER(column_name) = 'IDENTIFYING_ADDRESS_FLAG' OR column_name IS NULL) THEN

Line 111: app_exception.raise_exception;

107: IF (UPPER(column_name) = 'IDENTIFYING_ADDRESS_FLAG' OR column_name IS NULL) THEN
108: IF NOT (new_references.identifying_address_flag IN ('Y','N')) THEN
109: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113: END IF;
114:
115: END check_constraints;

Line 146: App_Exception.Raise_Exception;

142: Fetch cur_rowid INTO lv_rowid;
143: IF (cur_rowid%NOTFOUND) THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: Close cur_rowid;
149:
150: END IF;

Line 240: app_exception.raise_exception;

236: IF (cur_rowid%FOUND) THEN
237: CLOSE cur_rowid;
238: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
239: igs_ge_msg_stack.add;
240: app_exception.raise_exception;
241: RETURN;
242: END IF;
243: CLOSE cur_rowid;
244:

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_constraints;
315: check_parent_existance;
316: ELSIF (p_action = 'UPDATE') THEN

Line 342: app_exception.raise_exception;

338: )
339: ) THEN
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344: check_constraints;
345: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
346: check_constraints;

Line 415: app_exception.raise_exception;

411: END IF;
412: ELSE
413: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417:
418: X_LOCATION_VENUE_ADDR_ID := -1;
419: before_dml(

Line 514: app_exception.raise_exception;

510: IF (c1%notfound) THEN
511: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
512: igs_ge_msg_stack.add;
513: CLOSE c1;
514: app_exception.raise_exception;
515: RETURN;
516: END IF;
517: CLOSE c1;
518:

Line 529: app_exception.raise_exception;

525: NULL;
526: ELSE
527: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: END IF;
531:
532: RETURN;
533:

Line 581: app_exception.raise_exception;

577: END IF;
578: ELSE
579: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END IF;
583:
584: before_dml(
585: p_action => 'UPDATE',