APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on OE_LOOKUPS

Line 1433: p_lookup_table =>'OE_LOOKUPS',

1429: p_cust_account_rec.invoice_quantity_rule <> NVL( l_invoice_quantity_rule, FND_API.G_MISS_CHAR) ) )
1430: THEN
1431: validate_lookup(
1432: p_column =>'invoice_quantity_rule',
1433: p_lookup_table =>'OE_LOOKUPS',
1434: p_lookup_type =>'INVOICE_BASIS',
1435: p_column_value =>p_cust_account_rec.invoice_quantity_rule,
1436: x_return_status =>x_return_status );
1437:

Line 1640: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups

1636:
1637: ----------------------------------------------------------
1638: --validate date_type_preference
1639: ----------------------------------------------------------
1640: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups
1641:
1642: IF p_cust_account_rec.date_type_preference is NOT NULL AND
1643: p_cust_account_rec.date_type_preference <> FND_API.G_MISS_CHAR
1644: AND ( p_create_update_flag = 'C' OR

Line 1650: p_lookup_table =>'OE_LOOKUPS',

1646: p_cust_account_rec.date_type_preference <> NVL( l_date_type_preference, FND_API.G_MISS_CHAR) ) )
1647: THEN
1648: validate_lookup(
1649: p_column =>'date_type_preference',
1650: p_lookup_table =>'OE_LOOKUPS',
1651: p_lookup_type =>'REQUEST_DATE_TYPE',
1652: p_column_value =>p_cust_account_rec.date_type_preference,
1653: x_return_status =>x_return_status );
1654: /*IF G_DEBUG THEN

Line 1656: 'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||

1652: p_column_value =>p_cust_account_rec.date_type_preference,
1653: x_return_status =>x_return_status );
1654: /*IF G_DEBUG THEN
1655: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1656: 'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||
1657: 'x_return_status = ' || x_return_status, l_debug_prefix);
1658: END IF;
1659: */
1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1661: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||

1657: 'x_return_status = ' || x_return_status, l_debug_prefix);
1658: END IF;
1659: */
1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1661: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||
1662: 'x_return_status = ' || x_return_status,
1663: p_msg_level=>fnd_log.level_statement);
1664: END IF;
1665:

Line 9176: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups

9172:
9173: ----------------------------------------------------------
9174: --validate date_type_preference
9175: ----------------------------------------------------------
9176: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups
9177:
9178: IF p_cust_site_use_rec.date_type_preference IS NOT NULL AND
9179: p_cust_site_use_rec.date_type_preference <> FND_API.G_MISS_CHAR
9180: AND ( p_create_update_flag = 'C' OR

Line 9186: p_lookup_table =>'OE_LOOKUPS',

9182: p_cust_site_use_rec.date_type_preference <> NVL(l_date_type_preference,FND_API.G_MISS_CHAR) ) )
9183: THEN
9184: validate_lookup(
9185: p_column =>'date_type_preference',
9186: p_lookup_table =>'OE_LOOKUPS',
9187: p_lookup_type =>'REQUEST_DATE_TYPE',
9188: p_column_value =>p_cust_site_use_rec.date_type_preference,
9189: x_return_status =>x_return_status );
9190:

Line 9192: hz_utility_v2pub.debug(p_message=>'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||

9188: p_column_value =>p_cust_site_use_rec.date_type_preference,
9189: x_return_status =>x_return_status );
9190:
9191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9192: hz_utility_v2pub.debug(p_message=>'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||
9193: 'x_return_status = ' || x_return_status,
9194: p_prefix =>l_debug_prefix,
9195: p_msg_level=>fnd_log.level_statement);
9196: END IF;

Line 12269: ELSIF UPPER( l_lookup_table ) = 'OE_LOOKUPS' THEN

12265: EXCEPTION
12266: WHEN NO_DATA_FOUND THEN
12267: l_return := FALSE;
12268: END;
12269: ELSIF UPPER( l_lookup_table ) = 'OE_LOOKUPS' THEN
12270: BEGIN
12271: SELECT 'Y' INTO l_dummy
12272: FROM OE_LOOKUPS
12273: WHERE LOOKUP_TYPE = l_lookup_type

Line 12272: FROM OE_LOOKUPS

12268: END;
12269: ELSIF UPPER( l_lookup_table ) = 'OE_LOOKUPS' THEN
12270: BEGIN
12271: SELECT 'Y' INTO l_dummy
12272: FROM OE_LOOKUPS
12273: WHERE LOOKUP_TYPE = l_lookup_type
12274: AND LOOKUP_CODE = l_lookup_code
12275: AND ( ENABLED_FLAG = 'Y' AND
12276: TRUNC( SYSDATE ) BETWEEN