APPS.IGS_AD_LOCVENUE_ADDR_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 102: igs_ge_msg_stack.add;

98:
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:

Line 110: igs_ge_msg_stack.add;

106:
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:

Line 145: IGS_GE_MSG_STACK.ADD;

141: Open cur_rowid;
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:

Line 239: igs_ge_msg_stack.add;

235: FETCH cur_rowid INTO lv_rowid;
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;

Line 311: igs_ge_msg_stack.add;

307: new_references.location_venue_addr_id
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;

Line 341: igs_ge_msg_stack.add;

337: new_references.location_venue_addr_id
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

Line 414: igs_ge_msg_stack.add;

410: x_program_update_date := SYSDATE;
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;

Line 512: igs_ge_msg_stack.add;

508: OPEN c1;
509: FETCH c1 INTO tlinfo;
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;

Line 528: igs_ge_msg_stack.add;

524: ) THEN
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;

Line 580: igs_ge_msg_stack.add;

576: x_last_update_login := -1;
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(