DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_AUTOCASH_HIERARCHIES

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

4312: x_return_status => x_return_status );
4313:
4314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4315: hz_utility_v2pub.debug(p_message=>'autocash_hierarchy_id is foreign key to
4316: ar_autocash_hierarchies. ' || 'x_return_status = ' ||
4317: x_return_status,
4318: p_prefix =>l_debug_prefix,
4319: p_msg_level=>fnd_log.level_statement);
4320: END IF;

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

4344: x_return_status=> x_return_status );
4345:
4346: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4347: hz_utility_v2pub.debug(p_message=>'autocash_hierarchy_id_for_adr is foreign key to
4348: ar_autocash_hierarchies . ' || 'x_return_status = ' ||
4349: x_return_status,
4350: p_prefix =>l_debug_prefix,
4351: p_msg_level=>fnd_log.level_statement);
4352: END IF;

Line 11453: FROM ar_autocash_hierarchies h

11449:
11450: BEGIN
11451:
11452: SELECT 'Y' into l_dummy
11453: FROM ar_autocash_hierarchies h
11454: WHERE h.status = 'A'
11455: AND h.autocash_hierarchy_id =
11456: p_column_value;
11457: EXCEPTION

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

11458: WHEN NO_DATA_FOUND THEN
11459: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11460: FND_MESSAGE.SET_TOKEN( 'FK', p_column );
11461: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11462: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_autocash_hierarchies');
11463: FND_MSG_PUB.ADD;
11464: x_return_status := FND_API.G_RET_STS_ERROR;
11465:
11466: END check_auto_hierid_fk;