APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FND_COMMON_LOOKUPS

Line 8624: --Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups

8620: END IF;
8621: ---------------------------------------------
8622: --validate demand_class_code
8623: ---------------------------------------------
8624: --Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups
8625:
8626: IF p_cust_site_use_rec.demand_class_code is NOT NULL AND
8627: p_cust_site_use_rec.demand_class_code <> FND_API.G_MISS_CHAR
8628: AND ( p_create_update_flag = 'C' OR

Line 8634: p_lookup_table =>'FND_COMMON_LOOKUPS',

8630: p_cust_site_use_rec.demand_class_code <> NVL(l_demand_class_code,FND_API.G_MISS_CHAR) ) )
8631: THEN
8632: validate_lookup(
8633: p_column =>'demand_class_code',
8634: p_lookup_table =>'FND_COMMON_LOOKUPS',
8635: p_lookup_type =>'DEMAND_CLASS',
8636: p_column_value =>p_cust_site_use_rec.demand_class_code,
8637: x_return_status =>x_return_status );
8638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8639: hz_utility_v2pub.debug(p_message=>'Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups. '||

8635: p_lookup_type =>'DEMAND_CLASS',
8636: p_column_value =>p_cust_site_use_rec.demand_class_code,
8637: x_return_status =>x_return_status );
8638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8639: hz_utility_v2pub.debug(p_message=>'Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups. '||
8640: 'x_return_status = ' || x_return_status,
8641: p_prefix =>l_debug_prefix,
8642: p_msg_level=>fnd_log.level_statement);
8643: END IF;

Line 11963: ELSIF UPPER( l_lookup_table ) = 'FND_COMMON_LOOKUPS' THEN

11959: EXCEPTION
11960: WHEN NO_DATA_FOUND THEN
11961: l_return := FALSE;
11962: END;
11963: ELSIF UPPER( l_lookup_table ) = 'FND_COMMON_LOOKUPS' THEN
11964: BEGIN
11965: SELECT 'Y' INTO l_dummy
11966: FROM FND_COMMON_LOOKUPS
11967: WHERE LOOKUP_TYPE = l_lookup_type

Line 11966: FROM FND_COMMON_LOOKUPS

11962: END;
11963: ELSIF UPPER( l_lookup_table ) = 'FND_COMMON_LOOKUPS' THEN
11964: BEGIN
11965: SELECT 'Y' INTO l_dummy
11966: FROM FND_COMMON_LOOKUPS
11967: WHERE LOOKUP_TYPE = l_lookup_type
11968: AND LOOKUP_CODE = l_lookup_code
11969: AND ( ENABLED_FLAG = 'Y' AND
11970: TRUNC( SYSDATE ) BETWEEN