DBA Data[Home] [Help]

APPS.IGS_AD_LOCVENUE_ADDR_PKG dependencies on FND_MESSAGE

Line 47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

43: OPEN cur_old_ref_values;
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;

Line 101: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

97: END IF;
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;

Line 109: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

105: END IF;
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;

Line 144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

140: ELSE
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;

Line 238: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

234: OPEN cur_rowid;
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;

Line 310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

306: IF ( get_pk_for_validation(
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;

Line 340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

336: IF ( get_pk_for_validation (
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;

Line 413: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

409: ELSE
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:

Line 511: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

507:
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;

Line 527: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

523: AND ((tlinfo.identifying_address_flag = x_identifying_address_flag) OR ((tlinfo.identifying_address_flag IS NULL) AND (X_identifying_address_flag IS NULL)))
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:

Line 579: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

575: IF (x_last_update_login IS NULL) THEN
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: