DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1584: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS

1580:
1581: ----------------------------------------------------------
1582: --validate warehouse_id
1583: ----------------------------------------------------------
1584: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS
1585:
1586: IF p_cust_account_rec.warehouse_id is NOT NULL AND
1587: p_cust_account_rec.warehouse_id <> FND_API.G_MISS_NUM
1588: AND ( p_create_update_flag = 'C' OR

Line 1598: 'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||

1594: p_column_value => p_cust_account_rec.warehouse_id,
1595: x_return_status => x_return_status );
1596: /*IF G_DEBUG THEN
1597: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1598: 'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
1599: 'x_return_status = ' || x_return_status, l_debug_prefix);
1600: END IF;
1601: */
1602:

Line 1604: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||

1600: END IF;
1601: */
1602:
1603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1604: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
1605: 'x_return_status = ' || x_return_status,
1606: p_msg_level=>fnd_log.level_statement);
1607: END IF;
1608:

Line 8824: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS

8820:
8821: --------------------------------------------------
8822: --validate warehouse_id
8823: --------------------------------------------------
8824: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS
8825:
8826: IF p_cust_site_use_rec.warehouse_id is NOT NULL AND
8827: p_cust_site_use_rec.warehouse_id <> FND_API.G_MISS_NUM
8828: AND ( p_create_update_flag = 'C' OR

Line 8838: hz_utility_v2pub.debug(p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||

8834: p_column_value => p_cust_site_use_rec.warehouse_id,
8835: x_return_status => x_return_status );
8836:
8837: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8838: hz_utility_v2pub.debug(p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
8839: 'x_return_status = ' || x_return_status,
8840: p_prefix =>l_debug_prefix,
8841: p_msg_level=>fnd_log.level_statement);
8842: END IF;

Line 11295: FROM ORG_ORGANIZATION_DEFINITIONS org

11291: ) IS
11292: l_dummy VARCHAR2(1);
11293: BEGIN
11294: SELECT 'Y' INTO l_dummy
11295: FROM ORG_ORGANIZATION_DEFINITIONS org
11296: WHERE org.organization_id = p_column_value
11297: AND trunc(sysdate) <= nvl(trunc(org.disable_date),trunc(sysdate));
11298: EXCEPTION
11299: WHEN NO_DATA_FOUND THEN

Line 11303: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ORG_ORGANIZATION_DEFINITIONS' );

11299: WHEN NO_DATA_FOUND THEN
11300: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11301: FND_MESSAGE.SET_TOKEN( 'FK', 'warehouse_id' );
11302: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11303: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ORG_ORGANIZATION_DEFINITIONS' );
11304: FND_MSG_PUB.ADD;
11305: x_return_status := FND_API.G_RET_STS_ERROR;
11306: END check_warehouse;
11307: