DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on SO_LOOKUPS

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

998: --------------------------------------
999: -- validate sales_channel_code
1000: --------------------------------------
1001:
1002: -- sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups
1003: IF p_cust_account_rec.sales_channel_code IS NOT NULL AND
1004: p_cust_account_rec.sales_channel_code <> FND_API.G_MISS_CHAR AND
1005: ( p_create_update_flag = 'C' OR
1006: ( p_create_update_flag = 'U' AND

Line 1011: p_lookup_table => 'SO_LOOKUPS',

1007: p_cust_account_rec.sales_channel_code <> NVL( l_sales_channel_code, FND_API.G_MISS_CHAR ) ) )
1008: THEN
1009: validate_lookup (
1010: p_column => 'sales_channel_code',
1011: p_lookup_table => 'SO_LOOKUPS',
1012: p_lookup_type => 'SALES_CHANNEL',
1013: p_column_value => p_cust_account_rec.sales_channel_code,
1014: x_return_status => x_return_status );
1015:

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

1014: x_return_status => x_return_status );
1015:
1016: /*IF G_DEBUG THEN
1017: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1018: 'sales_channel_code is lookup code in lookup type SALES_CHANNEL in so_lookups. ' ||
1019: 'x_return_status = ' || x_return_status, l_debug_prefix );
1020: END IF;
1021: */
1022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1019: 'x_return_status = ' || x_return_status, l_debug_prefix );
1020: END IF;
1021: */
1022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1023: 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. ' ||
1024: 'x_return_status = ' || x_return_status,
1025: p_msg_level=>fnd_log.level_statement);
1026: END IF;
1027:

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

1043: --------------------------------------
1044: -- validate freight_term
1045: --------------------------------------
1046:
1047: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups
1048: IF p_cust_account_rec.freight_term IS NOT NULL AND
1049: p_cust_account_rec.freight_term <> FND_API.G_MISS_CHAR AND
1050: ( p_create_update_flag = 'C' OR
1051: ( p_create_update_flag = 'U' AND

Line 1056: p_lookup_table => 'SO_LOOKUPS',

1052: p_cust_account_rec.freight_term <> NVL( l_freight_term, FND_API.G_MISS_CHAR ) ) )
1053: THEN
1054: validate_lookup (
1055: p_column => 'freight_term',
1056: p_lookup_table => 'SO_LOOKUPS',
1057: p_lookup_type => 'FREIGHT_TERMS',
1058: p_column_value => p_cust_account_rec.freight_term,
1059: x_return_status => x_return_status );
1060:

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

1059: x_return_status => x_return_status );
1060:
1061: /*IF G_DEBUG THEN
1062: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1063: 'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
1064: 'x_return_status = ' || x_return_status, l_debug_prefix );
1065: END IF;
1066: */
1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1064: 'x_return_status = ' || x_return_status, l_debug_prefix );
1065: END IF;
1066: */
1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1068: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
1069: 'x_return_status = ' || x_return_status,
1070: p_msg_level=>fnd_log.level_statement);
1071: END IF;
1072:

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

8207: ----------------------------------------------
8208: -- validate freight_term
8209: ----------------------------------------------
8210:
8211: -- freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups
8212: IF p_cust_site_use_rec.freight_term IS NOT NULL AND
8213: p_cust_site_use_rec.freight_term <> FND_API.G_MISS_CHAR AND
8214: ( p_create_update_flag = 'C' OR
8215: ( p_create_update_flag = 'U' AND

Line 8220: p_lookup_table => 'SO_LOOKUPS',

8216: p_cust_site_use_rec.freight_term <> NVL( l_freight_term, FND_API.G_MISS_CHAR ) ) )
8217: THEN
8218: validate_lookup (
8219: p_column => 'freight_term',
8220: p_lookup_table => 'SO_LOOKUPS',
8221: p_lookup_type => 'FREIGHT_TERMS',
8222: p_column_value => p_cust_site_use_rec.freight_term,
8223: x_return_status => x_return_status );
8224:

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

8222: p_column_value => p_cust_site_use_rec.freight_term,
8223: x_return_status => x_return_status );
8224:
8225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8226: hz_utility_v2pub.debug(p_message=>'freight_term is lookup code in lookup type FREIGHT_TERMS in so_lookups. ' ||
8227: 'x_return_status = ' || x_return_status,
8228: p_prefix =>l_debug_prefix,
8229: p_msg_level=>fnd_log.level_statement);
8230: END IF;

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

11909: EXCEPTION
11910: WHEN NO_DATA_FOUND THEN
11911: l_return := FALSE;
11912: END;
11913: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
11914: BEGIN
11915: SELECT 'Y' INTO l_dummy
11916: FROM SO_LOOKUPS
11917: WHERE LOOKUP_TYPE = l_lookup_type

Line 11916: FROM SO_LOOKUPS

11912: END;
11913: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
11914: BEGIN
11915: SELECT 'Y' INTO l_dummy
11916: FROM SO_LOOKUPS
11917: WHERE LOOKUP_TYPE = l_lookup_type
11918: AND LOOKUP_CODE = l_lookup_code
11919: AND ( ENABLED_FLAG = 'Y' AND
11920: TRUNC( SYSDATE ) BETWEEN