APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_PARTY_SITES

Line 6765: l_site_party_id hz_party_sites.party_id%TYPE;

6761: PROCEDURE validate_accnt_party_site (
6762: p_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE,
6763: x_return_status IN OUT NOCOPY VARCHAR2
6764: ) IS
6765: l_site_party_id hz_party_sites.party_id%TYPE;
6766: l_account_party_id hz_cust_accounts.party_id%TYPE;
6767: l_account_number hz_cust_accounts.account_number%TYPE;
6768: l_party_type hz_parties.party_type%TYPE;
6769: l_site_party_name hz_parties.party_name%TYPE;

Line 6796: FROM hz_party_sites ps

6792: END IF;
6793:
6794: SELECT party_id
6795: INTO l_site_party_id
6796: FROM hz_party_sites ps
6797: WHERE party_site_id = p_cust_acct_site_rec.party_site_id;
6798:
6799: -- Debug info.
6800: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7187: -- party_site_id is foreign key of hz_party_sites

7183: p_msg_level=>fnd_log.level_statement);
7184: END IF;
7185: END IF;
7186:
7187: -- party_site_id is foreign key of hz_party_sites
7188: -- Do not need to check during update because party_site_id is
7189: -- non-updateable.
7190: IF p_create_update_flag = 'C' AND
7191: p_cust_acct_site_rec.party_site_id IS NOT NULL AND

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

7198:
7199: -- Debug info.
7200:
7201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7202: hz_utility_v2pub.debug(p_message=>'party_site_id is foreign key of hz_party_sites. ' ||
7203: 'x_return_status = ' || x_return_status,
7204: p_prefix =>l_debug_prefix,
7205: p_msg_level=>fnd_log.level_statement);
7206: END IF;

Line 7222: FROM HZ_PARTY_SITES

7218: SELECT 'Y' INTO l_dummy
7219: FROM HZ_LOCATIONS
7220: WHERE LOCATION_ID = (
7221: SELECT LOCATION_ID
7222: FROM HZ_PARTY_SITES
7223: WHERE PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id )
7224: AND CONTENT_SOURCE_TYPE = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
7225:
7226: EXCEPTION

Line 11190: FROM HZ_PARTY_SITES

11186: BEGIN
11187:
11188: BEGIN
11189: SELECT 'Y' INTO l_dummy
11190: FROM HZ_PARTY_SITES
11191: WHERE PARTY_SITE_ID = p_column_value;
11192: EXCEPTION
11193: WHEN NO_DATA_FOUND THEN
11194: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

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

11193: WHEN NO_DATA_FOUND THEN
11194: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11195: FND_MESSAGE.SET_TOKEN( 'FK', 'party_site_id' );
11196: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11197: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );
11198: FND_MSG_PUB.ADD;
11199: x_return_status := FND_API.G_RET_STS_ERROR;
11200: END;
11201: