APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_COLLECTORS

Line 3195: -- collector_id is foreign key to ar_collectors

3191: p_prefix =>l_debug_prefix,
3192: p_msg_level=>fnd_log.level_statement);
3193: END IF;
3194:
3195: -- collector_id is foreign key to ar_collectors
3196: IF p_customer_profile_rec.collector_id IS NOT NULL AND
3197: p_customer_profile_rec.collector_id <> FND_API.G_MISS_NUM
3198: THEN
3199: check_collector_fk (

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

3202: x_return_status => x_return_status );
3203:
3204:
3205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3206: hz_utility_v2pub.debug(p_message=>'collector_id is foreign key to ar_collectors. ' ||
3207: 'x_return_status = ' || x_return_status,
3208: p_prefix =>l_debug_prefix,
3209: p_msg_level=>fnd_log.level_statement);
3210: END IF;

Line 11139: FROM AR_COLLECTORS

11135:
11136: BEGIN
11137:
11138: SELECT 'Y' INTO l_dummy
11139: FROM AR_COLLECTORS
11140: WHERE COLLECTOR_ID = p_column_value;
11141:
11142: EXCEPTION
11143: WHEN NO_DATA_FOUND THEN

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

11143: WHEN NO_DATA_FOUND THEN
11144: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11145: FND_MESSAGE.SET_TOKEN( 'FK', 'collector_id' );
11146: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11147: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_collectors');
11148: FND_MSG_PUB.ADD;
11149: x_return_status := FND_API.G_RET_STS_ERROR;
11150:
11151: END check_collector_fk;