DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_AUTOCASH_HIERARCHIES

Line 4343: ar_autocash_hierarchies. ' || 'x_return_status = ' ||

4339: x_return_status => x_return_status );
4340:
4341: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4342: hz_utility_v2pub.debug(p_message=>'autocash_hierarchy_id is foreign key to
4343: ar_autocash_hierarchies. ' || 'x_return_status = ' ||
4344: x_return_status,
4345: p_prefix =>l_debug_prefix,
4346: p_msg_level=>fnd_log.level_statement);
4347: END IF;

Line 4375: ar_autocash_hierarchies . ' || 'x_return_status = ' ||

4371: x_return_status=> x_return_status );
4372:
4373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4374: hz_utility_v2pub.debug(p_message=>'autocash_hierarchy_id_for_adr is foreign key to
4375: ar_autocash_hierarchies . ' || 'x_return_status = ' ||
4376: x_return_status,
4377: p_prefix =>l_debug_prefix,
4378: p_msg_level=>fnd_log.level_statement);
4379: END IF;

Line 11745: FROM ar_autocash_hierarchies h

11741:
11742: BEGIN
11743:
11744: SELECT 'Y' into l_dummy
11745: FROM ar_autocash_hierarchies h
11746: WHERE h.status = 'A'
11747: AND h.autocash_hierarchy_id =
11748: p_column_value;
11749: EXCEPTION

Line 11754: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_autocash_hierarchies');

11750: WHEN NO_DATA_FOUND THEN
11751: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11752: FND_MESSAGE.SET_TOKEN( 'FK', p_column );
11753: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11754: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_autocash_hierarchies');
11755: FND_MSG_PUB.ADD;
11756: x_return_status := FND_API.G_RET_STS_ERROR;
11757:
11758: END check_auto_hierid_fk;