APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_COLLECTORS

Line 3168: -- collector_id is foreign key to ar_collectors

3164: p_prefix =>l_debug_prefix,
3165: p_msg_level=>fnd_log.level_statement);
3166: END IF;
3167:
3168: -- collector_id is foreign key to ar_collectors
3169: IF p_customer_profile_rec.collector_id IS NOT NULL AND
3170: p_customer_profile_rec.collector_id <> FND_API.G_MISS_NUM
3171: THEN
3172: check_collector_fk (

Line 3179: hz_utility_v2pub.debug(p_message=>'collector_id is foreign key to ar_collectors. ' ||

3175: x_return_status => x_return_status );
3176:
3177:
3178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3179: hz_utility_v2pub.debug(p_message=>'collector_id is foreign key to ar_collectors. ' ||
3180: 'x_return_status = ' || x_return_status,
3181: p_prefix =>l_debug_prefix,
3182: p_msg_level=>fnd_log.level_statement);
3183: END IF;

Line 10848: FROM AR_COLLECTORS

10844:
10845: BEGIN
10846:
10847: SELECT 'Y' INTO l_dummy
10848: FROM AR_COLLECTORS
10849: WHERE COLLECTOR_ID = p_column_value;
10850:
10851: EXCEPTION
10852: WHEN NO_DATA_FOUND THEN

Line 10856: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_collectors');

10852: WHEN NO_DATA_FOUND THEN
10853: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10854: FND_MESSAGE.SET_TOKEN( 'FK', 'collector_id' );
10855: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10856: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_collectors');
10857: FND_MSG_PUB.ADD;
10858: x_return_status := FND_API.G_RET_STS_ERROR;
10859:
10860: END check_collector_fk;