APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FND_COMMON_LOOKUPS

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

8903: END IF;
8904: ---------------------------------------------
8905: --validate demand_class_code
8906: ---------------------------------------------
8907: --Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups
8908:
8909: IF p_cust_site_use_rec.demand_class_code is NOT NULL AND
8910: p_cust_site_use_rec.demand_class_code <> FND_API.G_MISS_CHAR
8911: AND ( p_create_update_flag = 'C' OR

Line 8917: p_lookup_table =>'FND_COMMON_LOOKUPS',

8913: p_cust_site_use_rec.demand_class_code <> NVL(l_demand_class_code,FND_API.G_MISS_CHAR) ) )
8914: THEN
8915: validate_lookup(
8916: p_column =>'demand_class_code',
8917: p_lookup_table =>'FND_COMMON_LOOKUPS',
8918: p_lookup_type =>'DEMAND_CLASS',
8919: p_column_value =>p_cust_site_use_rec.demand_class_code,
8920: x_return_status =>x_return_status );
8921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

8918: p_lookup_type =>'DEMAND_CLASS',
8919: p_column_value =>p_cust_site_use_rec.demand_class_code,
8920: x_return_status =>x_return_status );
8921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8922: hz_utility_v2pub.debug(p_message=>'Demand_class_code is lookup_code in lookup_type DEMAND_CLASS in fnd_common_lookups. '||
8923: 'x_return_status = ' || x_return_status,
8924: p_prefix =>l_debug_prefix,
8925: p_msg_level=>fnd_log.level_statement);
8926: END IF;

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

12282: EXCEPTION
12283: WHEN NO_DATA_FOUND THEN
12284: l_return := FALSE;
12285: END;
12286: ELSIF UPPER( l_lookup_table ) = 'FND_COMMON_LOOKUPS' THEN
12287: BEGIN
12288: SELECT 'Y' INTO l_dummy
12289: FROM FND_COMMON_LOOKUPS
12290: WHERE LOOKUP_TYPE = l_lookup_type

Line 12289: FROM FND_COMMON_LOOKUPS

12285: END;
12286: ELSIF UPPER( l_lookup_table ) = 'FND_COMMON_LOOKUPS' THEN
12287: BEGIN
12288: SELECT 'Y' INTO l_dummy
12289: FROM FND_COMMON_LOOKUPS
12290: WHERE LOOKUP_TYPE = l_lookup_type
12291: AND LOOKUP_CODE = l_lookup_code
12292: AND ( ENABLED_FLAG = 'Y' AND
12293: TRUNC( SYSDATE ) BETWEEN