APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_CASH_AUTO_RULE_SETS

Line 4715: hz_utility_v2pub.debug(p_message=>'automatch_set_id is foreign key to AR_CASH_AUTO_RULE_SETS. ' ||

4711: p_column_value => p_customer_profile_rec.automatch_set_id,
4712: x_return_status => x_return_status );
4713:
4714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4715: hz_utility_v2pub.debug(p_message=>'automatch_set_id is foreign key to AR_CASH_AUTO_RULE_SETS. ' ||
4716: 'x_return_status = ' || x_return_status,
4717: p_prefix =>l_debug_prefix,
4718: p_msg_level=>fnd_log.level_statement);
4719: END IF;

Line 11940: FROM AR_CASH_AUTO_RULE_SETS

11936: p_msg_level => fnd_log.level_statement);
11937: END IF;
11938:
11939: SELECT 'x' into l_dummy
11940: FROM AR_CASH_AUTO_RULE_SETS
11941: WHERE active_flag = 'Y'
11942: AND automatch_set_id = p_column_value;
11943: EXCEPTION
11944: WHEN NO_DATA_FOUND THEN

Line 11948: FND_MESSAGE.SET_TOKEN( 'TABLE', 'AR_CASH_AUTO_RULE_SETS');

11944: WHEN NO_DATA_FOUND THEN
11945: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11946: FND_MESSAGE.SET_TOKEN( 'FK', 'Automatch_Set_Id' );
11947: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11948: FND_MESSAGE.SET_TOKEN( 'TABLE', 'AR_CASH_AUTO_RULE_SETS');
11949: FND_MSG_PUB.ADD;
11950: x_return_status := FND_API.G_RET_STS_ERROR;
11951:
11952: END check_automatch_set_id_fk;