APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 1136: -- Bug 4713150 : tax_code is now validated against the view zx_output_classifications_v

1132: ----------------------------
1133: --validate tax_code
1134: ----------------------------
1135:
1136: -- Bug 4713150 : tax_code is now validated against the view zx_output_classifications_v
1137: /*
1138: IF p_cust_account_rec.tax_code IS NOT NULL AND
1139: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
1140: THEN

Line 1162: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Tax_code should be a valid value defined in view zx_output_classifications_v. '||

1158: p_called_from => 'validate_cust_account',
1159: x_return_status => x_return_status );
1160:
1161: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1162: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Tax_code should be a valid value defined in view zx_output_classifications_v. '||
1163: 'x_return_status = ' || x_return_status,
1164: p_msg_level=>fnd_log.level_statement);
1165: END IF;
1166:

Line 8559: --Tax_code should be a valid value defined in zx_output_classifications_v

8555:
8556: ------------------------------------------
8557: -- validate tax_code
8558: ------------------------------------------
8559: --Tax_code should be a valid value defined in zx_output_classifications_v
8560:
8561: IF p_cust_site_use_rec.tax_code is NOT NULL AND
8562: p_cust_site_use_rec.tax_code <> FND_API.G_MISS_CHAR
8563: AND ( p_create_update_flag = 'C' OR

Line 8576: hz_utility_v2pub.debug(p_message=>'Tax_code should be a valid value defined in view zx_output_classifications_v. '||

8572: p_called_from => 'validate_cust_site_use',
8573: x_return_status => x_return_status );
8574:
8575: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8576: hz_utility_v2pub.debug(p_message=>'Tax_code should be a valid value defined in view zx_output_classifications_v. '||
8577: 'x_return_status = ' || x_return_status,
8578: p_prefix =>l_debug_prefix,
8579: p_msg_level=>fnd_log.level_statement);
8580: END IF;

Line 11254: FROM zx_output_classifications_v

11250: END IF;
11251:
11252: -- Bug 4713150
11253: SELECT 'Y' INTO l_dummy
11254: FROM zx_output_classifications_v
11255: WHERE lookup_type = 'ZX_OUTPUT_CLASSIFICATIONS'
11256: AND lookup_code = p_column_value
11257: AND trunc(sysdate) BETWEEN trunc(start_date_active) AND nvl(trunc(end_date_active),trunc(sysdate))
11258: AND enabled_flag = 'Y'

Line 11282: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ZX_OUTPUT_CLASSIFICATIONS_V' );

11278: WHEN NO_DATA_FOUND THEN
11279: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11280: FND_MESSAGE.SET_TOKEN( 'FK', 'tax_code' );
11281: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11282: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ZX_OUTPUT_CLASSIFICATIONS_V' );
11283: FND_MSG_PUB.ADD;
11284: x_return_status := FND_API.G_RET_STS_ERROR;
11285: END check_tax_code;
11286: