eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_PARTIES

Line 2261: -- selling_party_id is foreign key of hz_parties

2257: --------------------------------------
2258: -- validate selling_party_id
2259: --------------------------------------
2260:
2261: -- selling_party_id is foreign key of hz_parties
2262: IF p_cust_account_rec.selling_party_id IS NOT NULL AND
2263: p_cust_account_rec.selling_party_id <> FND_API.G_MISS_NUM
2264: THEN
2265: check_party_fk (

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

2268: x_return_status => x_return_status );
2269:
2270: /*IF G_DEBUG THEN
2271: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2272: 'selling_party_id is foreign key of hz_parties. ' ||
2273: 'x_return_status = ' || x_return_status, l_debug_prefix );
2274: END IF;
2275: */
2276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2273: 'x_return_status = ' || x_return_status, l_debug_prefix );
2274: END IF;
2275: */
2276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2277: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'selling_party_id is foreign key of hz_parties. ' ||
2278: 'x_return_status = ' || x_return_status,
2279: p_msg_level=>fnd_log.level_statement);
2280: END IF;
2281:

Line 6768: l_party_type hz_parties.party_type%TYPE;

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;
6770: l_account_party_name hz_parties.party_name%TYPE;
6771:
6772: l_debug_prefix VARCHAR2(30) := '';

Line 6769: l_site_party_name hz_parties.party_name%TYPE;

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;
6770: l_account_party_name hz_parties.party_name%TYPE;
6771:
6772: l_debug_prefix VARCHAR2(30) := '';
6773: l_dummy VARCHAR2(1);

Line 6770: l_account_party_name hz_parties.party_name%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;
6770: l_account_party_name hz_parties.party_name%TYPE;
6771:
6772: l_debug_prefix VARCHAR2(30) := '';
6773: l_dummy VARCHAR2(1);
6774: BEGIN

Line 6819: FROM hz_parties

6815: END IF;
6816:
6817: SELECT party_type,party_name
6818: INTO l_party_type,l_site_party_name
6819: FROM hz_parties
6820: WHERE party_id = l_site_party_id ;
6821: -- Debug info.
6822: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6823: hz_utility_v2pub.debug(p_message=>' Site Party Type : '||l_party_type||' Site Party Name : '||l_site_party_name,

Line 6830: FROM hz_parties

6826: END IF;
6827:
6828: SELECT party_name
6829: INTO l_account_party_name
6830: FROM hz_parties
6831: WHERE party_id = l_account_party_id ;
6832: -- Debug info.
6833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6834: hz_utility_v2pub.debug(p_message=>' Account Party Name : '||l_account_party_name,

Line 6846: AND subject_table_name = 'HZ_PARTIES'

6842: SELECT 'X'
6843: INTO l_dummy
6844: FROM hz_relationships
6845: WHERE subject_id = l_account_party_id
6846: AND subject_table_name = 'HZ_PARTIES'
6847: AND party_id = l_site_party_id
6848: AND object_table_name = 'HZ_PARTIES'
6849: AND status = 'A'
6850: AND ROWNUM = 1;

Line 6848: AND object_table_name = 'HZ_PARTIES'

6844: FROM hz_relationships
6845: WHERE subject_id = l_account_party_id
6846: AND subject_table_name = 'HZ_PARTIES'
6847: AND party_id = l_site_party_id
6848: AND object_table_name = 'HZ_PARTIES'
6849: AND status = 'A'
6850: AND ROWNUM = 1;
6851: EXCEPTION
6852: WHEN NO_DATA_FOUND THEN

Line 6876: AND subject_table_name = 'HZ_PARTIES'

6872: SELECT 'X'
6873: INTO l_dummy
6874: FROM hz_relationships
6875: WHERE subject_id = l_account_party_id
6876: AND subject_table_name = 'HZ_PARTIES'
6877: AND object_id = l_site_party_id
6878: AND object_table_name = 'HZ_PARTIES'
6879: AND status = 'A'
6880: AND ROWNUM = 1;

Line 6878: AND object_table_name = 'HZ_PARTIES'

6874: FROM hz_relationships
6875: WHERE subject_id = l_account_party_id
6876: AND subject_table_name = 'HZ_PARTIES'
6877: AND object_id = l_site_party_id
6878: AND object_table_name = 'HZ_PARTIES'
6879: AND status = 'A'
6880: AND ROWNUM = 1;
6881: EXCEPTION
6882: WHEN NO_DATA_FOUND THEN

Line 9894: -- party_id is foreign key to hz_parties

9890: -- referened by cust_account_id.
9891: -- However, we decide donot add this validation for now since we may
9892: -- need migrate data. (Dylan's reply)
9893:
9894: -- party_id is foreign key to hz_parties
9895: -- Since party_id is mandatory and non-updateable, we only need to
9896: -- check FK during creation.
9897:
9898: IF p_create_update_flag = 'C' AND

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

9904: p_column_value => p_cust_account_role_rec.party_id,
9905: x_return_status => x_return_status );
9906:
9907: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9908: hz_utility_v2pub.debug(p_message=>'party_id is foreign key to hz_parties. ' ||
9909: 'x_return_status = ' || x_return_status,
9910: p_prefix =>l_debug_prefix,
9911: p_msg_level=>fnd_log.level_statement);
9912: END IF;

Line 11164: FROM HZ_PARTIES

11160:
11161: BEGIN
11162:
11163: SELECT 'Y' INTO l_dummy
11164: FROM HZ_PARTIES
11165: WHERE PARTY_ID = p_column_value;
11166:
11167: EXCEPTION
11168: WHEN NO_DATA_FOUND THEN

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

11168: WHEN NO_DATA_FOUND THEN
11169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11170: FND_MESSAGE.SET_TOKEN( 'FK', 'party_id' );
11171: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11172: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );
11173: FND_MSG_PUB.ADD;
11174: x_return_status := FND_API.G_RET_STS_ERROR;
11175:
11176: END check_party_fk;