APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_PARTIES

Line 2248: -- selling_party_id is foreign key of hz_parties

2244: --------------------------------------
2245: -- validate selling_party_id
2246: --------------------------------------
2247:
2248: -- selling_party_id is foreign key of hz_parties
2249: IF p_cust_account_rec.selling_party_id IS NOT NULL AND
2250: p_cust_account_rec.selling_party_id <> FND_API.G_MISS_NUM
2251: THEN
2252: check_party_fk (

Line 2259: 'selling_party_id is foreign key of hz_parties. ' ||

2255: x_return_status => x_return_status );
2256:
2257: /*IF G_DEBUG THEN
2258: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2259: 'selling_party_id is foreign key of hz_parties. ' ||
2260: 'x_return_status = ' || x_return_status, l_debug_prefix );
2261: END IF;
2262: */
2263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2264: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'selling_party_id is foreign key of hz_parties. ' ||

2260: 'x_return_status = ' || x_return_status, l_debug_prefix );
2261: END IF;
2262: */
2263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2264: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'selling_party_id is foreign key of hz_parties. ' ||
2265: 'x_return_status = ' || x_return_status,
2266: p_msg_level=>fnd_log.level_statement);
2267: END IF;
2268:

Line 9611: -- party_id is foreign key to hz_parties

9607: -- referened by cust_account_id.
9608: -- However, we decide donot add this validation for now since we may
9609: -- need migrate data. (Dylan's reply)
9610:
9611: -- party_id is foreign key to hz_parties
9612: -- Since party_id is mandatory and non-updateable, we only need to
9613: -- check FK during creation.
9614:
9615: IF p_create_update_flag = 'C' AND

Line 9625: hz_utility_v2pub.debug(p_message=>'party_id is foreign key to hz_parties. ' ||

9621: p_column_value => p_cust_account_role_rec.party_id,
9622: x_return_status => x_return_status );
9623:
9624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9625: hz_utility_v2pub.debug(p_message=>'party_id is foreign key to hz_parties. ' ||
9626: 'x_return_status = ' || x_return_status,
9627: p_prefix =>l_debug_prefix,
9628: p_msg_level=>fnd_log.level_statement);
9629: END IF;

Line 10873: FROM HZ_PARTIES

10869:
10870: BEGIN
10871:
10872: SELECT 'Y' INTO l_dummy
10873: FROM HZ_PARTIES
10874: WHERE PARTY_ID = p_column_value;
10875:
10876: EXCEPTION
10877: WHEN NO_DATA_FOUND THEN

Line 10881: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );

10877: WHEN NO_DATA_FOUND THEN
10878: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10879: FND_MESSAGE.SET_TOKEN( 'FK', 'party_id' );
10880: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10881: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );
10882: FND_MSG_PUB.ADD;
10883: x_return_status := FND_API.G_RET_STS_ERROR;
10884:
10885: END check_party_fk;