APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_PARTY_SITES

Line 6930: -- party_site_id is foreign key of hz_party_sites

6926: p_msg_level=>fnd_log.level_statement);
6927: END IF;
6928: END IF;
6929:
6930: -- party_site_id is foreign key of hz_party_sites
6931: -- Do not need to check during update because party_site_id is
6932: -- non-updateable.
6933: IF p_create_update_flag = 'C' AND
6934: p_cust_acct_site_rec.party_site_id IS NOT NULL AND

Line 6945: hz_utility_v2pub.debug(p_message=>'party_site_id is foreign key of hz_party_sites. ' ||

6941:
6942: -- Debug info.
6943:
6944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6945: hz_utility_v2pub.debug(p_message=>'party_site_id is foreign key of hz_party_sites. ' ||
6946: 'x_return_status = ' || x_return_status,
6947: p_prefix =>l_debug_prefix,
6948: p_msg_level=>fnd_log.level_statement);
6949: END IF;

Line 6965: FROM HZ_PARTY_SITES

6961: SELECT 'Y' INTO l_dummy
6962: FROM HZ_LOCATIONS
6963: WHERE LOCATION_ID = (
6964: SELECT LOCATION_ID
6965: FROM HZ_PARTY_SITES
6966: WHERE PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id )
6967: AND CONTENT_SOURCE_TYPE = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
6968:
6969: EXCEPTION

Line 10899: FROM HZ_PARTY_SITES

10895: BEGIN
10896:
10897: BEGIN
10898: SELECT 'Y' INTO l_dummy
10899: FROM HZ_PARTY_SITES
10900: WHERE PARTY_SITE_ID = p_column_value;
10901: EXCEPTION
10902: WHEN NO_DATA_FOUND THEN
10903: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 10906: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );

10902: WHEN NO_DATA_FOUND THEN
10903: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10904: FND_MESSAGE.SET_TOKEN( 'FK', 'party_site_id' );
10905: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10906: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );
10907: FND_MSG_PUB.ADD;
10908: x_return_status := FND_API.G_RET_STS_ERROR;
10909: END;
10910: