APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on SO_LOOKUPS

Line 1015: -- sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups

1011: --------------------------------------
1012: -- validate sales_channel_code
1013: --------------------------------------
1014:
1015: -- sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups
1016: IF p_cust_account_rec.sales_channel_code IS NOT NULL AND
1017: p_cust_account_rec.sales_channel_code <> FND_API.G_MISS_CHAR AND
1018: ( p_create_update_flag = 'C' OR
1019: ( p_create_update_flag = 'U' AND

Line 1024: p_lookup_table => 'SO_LOOKUPS',

1020: p_cust_account_rec.sales_channel_code <> NVL( l_sales_channel_code, FND_API.G_MISS_CHAR ) ) )
1021: THEN
1022: validate_lookup (
1023: p_column => 'sales_channel_code',
1024: p_lookup_table => 'SO_LOOKUPS',
1025: p_lookup_type => 'SALES_CHANNEL',
1026: p_column_value => p_cust_account_rec.sales_channel_code,
1027: x_return_status => x_return_status );
1028:

Line 1031: 'sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups. ' ||

1027: x_return_status => x_return_status );
1028:
1029: /*IF G_DEBUG THEN
1030: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1031: 'sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups. ' ||
1032: 'x_return_status = ' || x_return_status, l_debug_prefix );
1033: END IF;
1034: */
1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1036: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups. ' ||

1032: 'x_return_status = ' || x_return_status, l_debug_prefix );
1033: END IF;
1034: */
1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups. ' ||
1037: 'x_return_status = ' || x_return_status,
1038: p_msg_level=>fnd_log.level_statement);
1039: END IF;
1040:

Line 1060: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups

1056: --------------------------------------
1057: -- validate freight_term
1058: --------------------------------------
1059:
1060: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups
1061: IF p_cust_account_rec.freight_term IS NOT NULL AND
1062: p_cust_account_rec.freight_term <> FND_API.G_MISS_CHAR AND
1063: ( p_create_update_flag = 'C' OR
1064: ( p_create_update_flag = 'U' AND

Line 1069: p_lookup_table => 'SO_LOOKUPS',

1065: p_cust_account_rec.freight_term <> NVL( l_freight_term, FND_API.G_MISS_CHAR ) ) )
1066: THEN
1067: validate_lookup (
1068: p_column => 'freight_term',
1069: p_lookup_table => 'SO_LOOKUPS',
1070: p_lookup_type => 'FREIGHT_TERMS',
1071: p_column_value => p_cust_account_rec.freight_term,
1072: x_return_status => x_return_status );
1073:

Line 1076: 'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||

1072: x_return_status => x_return_status );
1073:
1074: /*IF G_DEBUG THEN
1075: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1076: 'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
1077: 'x_return_status = ' || x_return_status, l_debug_prefix );
1078: END IF;
1079: */
1080: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1081: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||

1077: 'x_return_status = ' || x_return_status, l_debug_prefix );
1078: END IF;
1079: */
1080: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1081: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
1082: 'x_return_status = ' || x_return_status,
1083: p_msg_level=>fnd_log.level_statement);
1084: END IF;
1085:

Line 8494: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups

8490: ----------------------------------------------
8491: -- validate freight_term
8492: ----------------------------------------------
8493:
8494: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups
8495: IF p_cust_site_use_rec.freight_term IS NOT NULL AND
8496: p_cust_site_use_rec.freight_term <> FND_API.G_MISS_CHAR AND
8497: ( p_create_update_flag = 'C' OR
8498: ( p_create_update_flag = 'U' AND

Line 8503: p_lookup_table => 'SO_LOOKUPS',

8499: p_cust_site_use_rec.freight_term <> NVL( l_freight_term, FND_API.G_MISS_CHAR ) ) )
8500: THEN
8501: validate_lookup (
8502: p_column => 'freight_term',
8503: p_lookup_table => 'SO_LOOKUPS',
8504: p_lookup_type => 'FREIGHT_TERMS',
8505: p_column_value => p_cust_site_use_rec.freight_term,
8506: x_return_status => x_return_status );
8507:

Line 8509: hz_utility_v2pub.debug(p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||

8505: p_column_value => p_cust_site_use_rec.freight_term,
8506: x_return_status => x_return_status );
8507:
8508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8509: hz_utility_v2pub.debug(p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
8510: 'x_return_status = ' || x_return_status,
8511: p_prefix =>l_debug_prefix,
8512: p_msg_level=>fnd_log.level_statement);
8513: END IF;

Line 12236: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN

12232: EXCEPTION
12233: WHEN NO_DATA_FOUND THEN
12234: l_return := FALSE;
12235: END;
12236: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
12237: BEGIN
12238: SELECT 'Y' INTO l_dummy
12239: FROM SO_LOOKUPS
12240: WHERE LOOKUP_TYPE = l_lookup_type

Line 12239: FROM SO_LOOKUPS

12235: END;
12236: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
12237: BEGIN
12238: SELECT 'Y' INTO l_dummy
12239: FROM SO_LOOKUPS
12240: WHERE LOOKUP_TYPE = l_lookup_type
12241: AND LOOKUP_CODE = l_lookup_code
12242: AND ( ENABLED_FLAG = 'Y' AND
12243: TRUNC( SYSDATE ) BETWEEN