APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on FND_TABLES

Line 356: -- database_object_name has foreign key fnd_tables.table_name

352: p_msg_level=>fnd_log.level_statement);
353: END IF;
354: END IF;
355:
356: -- database_object_name has foreign key fnd_tables.table_name
357: IF p_style_rec.database_object_name IS NOT NULL
358: AND
359: p_style_rec.database_object_name <> fnd_api.g_miss_char
360: THEN

Line 365: FROM fnd_tables t

361: BEGIN
362:
363: SELECT 'Y'
364: into l_dummy
365: FROM fnd_tables t
366: where t.table_name = p_style_rec.database_object_name ;
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN

Line 373: fnd_message.set_token('TABLE', 'fnd_tables');

369: WHEN NO_DATA_FOUND THEN
370: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
371: fnd_message.set_token('FK', 'database_object_name');
372: fnd_message.set_token('COLUMN', 'table_name');
373: fnd_message.set_token('TABLE', 'fnd_tables');
374: fnd_msg_pub.add;
375: x_return_status := fnd_api.g_ret_sts_error;
376: END;
377:

Line 379: hz_utility_v2pub.debug(p_message=>'database_object_name has foreign key fnd_tables.table_name. ' ||

375: x_return_status := fnd_api.g_ret_sts_error;
376: END;
377:
378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'database_object_name has foreign key fnd_tables.table_name. ' ||
380: 'x_return_status = ' || x_return_status,
381: p_prefix =>l_debug_prefix,
382: p_msg_level=>fnd_log.level_statement);
383: END IF;

Line 2169: FROM fnd_columns c, fnd_tables t

2165: s.style_code = sf.style_code;
2166:
2167: SELECT 'Y'
2168: into l_dummy
2169: FROM fnd_columns c, fnd_tables t
2170: where t.table_name = l_database_object_name AND
2171: t.table_id = c.table_id AND
2172: c.application_id = t.application_id AND --Bug No.4942505. SQLID:14450634
2173: c.column_name = p_style_fmt_layout_rec.attribute_code;