eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on ORG_ORGANIZATION_DEFINITIONS

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

1593:
1594: ----------------------------------------------------------
1595: --validate warehouse_id
1596: ----------------------------------------------------------
1597: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS
1598:
1599: IF p_cust_account_rec.warehouse_id is NOT NULL AND
1600: p_cust_account_rec.warehouse_id <> FND_API.G_MISS_NUM
1601: AND ( p_create_update_flag = 'C' OR

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

1607: p_column_value => p_cust_account_rec.warehouse_id,
1608: x_return_status => x_return_status );
1609: /*IF G_DEBUG THEN
1610: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1611: 'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
1612: 'x_return_status = ' || x_return_status, l_debug_prefix);
1613: END IF;
1614: */
1615:

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

1613: END IF;
1614: */
1615:
1616: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1617: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
1618: 'x_return_status = ' || x_return_status,
1619: p_msg_level=>fnd_log.level_statement);
1620: END IF;
1621:

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

9103:
9104: --------------------------------------------------
9105: --validate warehouse_id
9106: --------------------------------------------------
9107: --warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS
9108:
9109: IF p_cust_site_use_rec.warehouse_id is NOT NULL AND
9110: p_cust_site_use_rec.warehouse_id <> FND_API.G_MISS_NUM
9111: AND ( p_create_update_flag = 'C' OR

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

9117: p_column_value => p_cust_site_use_rec.warehouse_id,
9118: x_return_status => x_return_status );
9119:
9120: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9121: hz_utility_v2pub.debug(p_message=>'warehouse_id should be a value defined in ORG_ORGANIZATION_DEFINITIONS . '||
9122: 'x_return_status = ' || x_return_status,
9123: p_prefix =>l_debug_prefix,
9124: p_msg_level=>fnd_log.level_statement);
9125: END IF;

Line 11586: FROM ORG_ORGANIZATION_DEFINITIONS org

11582: ) IS
11583: l_dummy VARCHAR2(1);
11584: BEGIN
11585: SELECT 'Y' INTO l_dummy
11586: FROM ORG_ORGANIZATION_DEFINITIONS org
11587: WHERE org.organization_id = p_column_value
11588: AND trunc(sysdate) <= nvl(trunc(org.disable_date),trunc(sysdate));
11589: EXCEPTION
11590: WHEN NO_DATA_FOUND THEN

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

11590: WHEN NO_DATA_FOUND THEN
11591: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11592: FND_MESSAGE.SET_TOKEN( 'FK', 'warehouse_id' );
11593: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11594: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ORG_ORGANIZATION_DEFINITIONS' );
11595: FND_MSG_PUB.ADD;
11596: x_return_status := FND_API.G_RET_STS_ERROR;
11597: END check_warehouse;
11598: