APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

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

1145: ----------------------------
1146: --validate tax_code
1147: ----------------------------
1148:
1149: -- Bug 4713150 : tax_code is now validated against the view zx_output_classifications_v
1150: /*
1151: IF p_cust_account_rec.tax_code IS NOT NULL AND
1152: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
1153: THEN

Line 1175: 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. '||

1171: p_called_from => 'validate_cust_account',
1172: x_return_status => x_return_status );
1173:
1174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1175: 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. '||
1176: 'x_return_status = ' || x_return_status,
1177: p_msg_level=>fnd_log.level_statement);
1178: END IF;
1179:

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

8838:
8839: ------------------------------------------
8840: -- validate tax_code
8841: ------------------------------------------
8842: --Tax_code should be a valid value defined in zx_output_classifications_v
8843:
8844: IF p_cust_site_use_rec.tax_code is NOT NULL AND
8845: p_cust_site_use_rec.tax_code <> FND_API.G_MISS_CHAR
8846: AND ( p_create_update_flag = 'C' OR

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

8855: p_called_from => 'validate_cust_site_use',
8856: x_return_status => x_return_status );
8857:
8858: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8859: hz_utility_v2pub.debug(p_message=>'Tax_code should be a valid value defined in view zx_output_classifications_v. '||
8860: 'x_return_status = ' || x_return_status,
8861: p_prefix =>l_debug_prefix,
8862: p_msg_level=>fnd_log.level_statement);
8863: END IF;

Line 11545: FROM zx_output_classifications_v

11541: END IF;
11542:
11543: -- Bug 4713150
11544: SELECT 'Y' INTO l_dummy
11545: FROM zx_output_classifications_v
11546: WHERE lookup_type = 'ZX_OUTPUT_CLASSIFICATIONS'
11547: AND lookup_code = p_column_value
11548: AND trunc(sysdate) BETWEEN trunc(start_date_active) AND nvl(trunc(end_date_active),trunc(sysdate))
11549: AND enabled_flag = 'Y'

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

11569: WHEN NO_DATA_FOUND THEN
11570: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11571: FND_MESSAGE.SET_TOKEN( 'FK', 'tax_code' );
11572: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11573: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ZX_OUTPUT_CLASSIFICATIONS_V' );
11574: FND_MSG_PUB.ADD;
11575: x_return_status := FND_API.G_RET_STS_ERROR;
11576: END check_tax_code;
11577: