APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on OE_LOOKUPS

Line 1420: p_lookup_table =>'OE_LOOKUPS',

1416: p_cust_account_rec.invoice_quantity_rule <> NVL( l_invoice_quantity_rule, FND_API.G_MISS_CHAR) ) )
1417: THEN
1418: validate_lookup(
1419: p_column =>'invoice_quantity_rule',
1420: p_lookup_table =>'OE_LOOKUPS',
1421: p_lookup_type =>'INVOICE_BASIS',
1422: p_column_value =>p_cust_account_rec.invoice_quantity_rule,
1423: x_return_status =>x_return_status );
1424:

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

1623:
1624: ----------------------------------------------------------
1625: --validate date_type_preference
1626: ----------------------------------------------------------
1627: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups
1628:
1629: IF p_cust_account_rec.date_type_preference is NOT NULL AND
1630: p_cust_account_rec.date_type_preference <> FND_API.G_MISS_CHAR
1631: AND ( p_create_update_flag = 'C' OR

Line 1637: p_lookup_table =>'OE_LOOKUPS',

1633: p_cust_account_rec.date_type_preference <> NVL( l_date_type_preference, FND_API.G_MISS_CHAR) ) )
1634: THEN
1635: validate_lookup(
1636: p_column =>'date_type_preference',
1637: p_lookup_table =>'OE_LOOKUPS',
1638: p_lookup_type =>'REQUEST_DATE_TYPE',
1639: p_column_value =>p_cust_account_rec.date_type_preference,
1640: x_return_status =>x_return_status );
1641: /*IF G_DEBUG THEN

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

1639: p_column_value =>p_cust_account_rec.date_type_preference,
1640: x_return_status =>x_return_status );
1641: /*IF G_DEBUG THEN
1642: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1643: 'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||
1644: 'x_return_status = ' || x_return_status, l_debug_prefix);
1645: END IF;
1646: */
1647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1644: 'x_return_status = ' || x_return_status, l_debug_prefix);
1645: END IF;
1646: */
1647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1648: 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. '||
1649: 'x_return_status = ' || x_return_status,
1650: p_msg_level=>fnd_log.level_statement);
1651: END IF;
1652:

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

8889:
8890: ----------------------------------------------------------
8891: --validate date_type_preference
8892: ----------------------------------------------------------
8893: --date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups
8894:
8895: IF p_cust_site_use_rec.date_type_preference IS NOT NULL AND
8896: p_cust_site_use_rec.date_type_preference <> FND_API.G_MISS_CHAR
8897: AND ( p_create_update_flag = 'C' OR

Line 8903: p_lookup_table =>'OE_LOOKUPS',

8899: p_cust_site_use_rec.date_type_preference <> NVL(l_date_type_preference,FND_API.G_MISS_CHAR) ) )
8900: THEN
8901: validate_lookup(
8902: p_column =>'date_type_preference',
8903: p_lookup_table =>'OE_LOOKUPS',
8904: p_lookup_type =>'REQUEST_DATE_TYPE',
8905: p_column_value =>p_cust_site_use_rec.date_type_preference,
8906: x_return_status =>x_return_status );
8907:

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

8905: p_column_value =>p_cust_site_use_rec.date_type_preference,
8906: x_return_status =>x_return_status );
8907:
8908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8909: hz_utility_v2pub.debug(p_message=>'date_type_preference is a lookup_code in lookup_type REQUEST_DATE_TYPE in oe_lookups. '||
8910: 'x_return_status = ' || x_return_status,
8911: p_prefix =>l_debug_prefix,
8912: p_msg_level=>fnd_log.level_statement);
8913: END IF;

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

11942: EXCEPTION
11943: WHEN NO_DATA_FOUND THEN
11944: l_return := FALSE;
11945: END;
11946: ELSIF UPPER( l_lookup_table ) = 'OE_LOOKUPS' THEN
11947: BEGIN
11948: SELECT 'Y' INTO l_dummy
11949: FROM OE_LOOKUPS
11950: WHERE LOOKUP_TYPE = l_lookup_type

Line 11949: FROM OE_LOOKUPS

11945: END;
11946: ELSIF UPPER( l_lookup_table ) = 'OE_LOOKUPS' THEN
11947: BEGIN
11948: SELECT 'Y' INTO l_dummy
11949: FROM OE_LOOKUPS
11950: WHERE LOOKUP_TYPE = l_lookup_type
11951: AND LOOKUP_CODE = l_lookup_code
11952: AND ( ENABLED_FLAG = 'Y' AND
11953: TRUNC( SYSDATE ) BETWEEN