DBA Data[Home] [Help]

APPS.WSH_PR_CRITERIA dependencies on INV_VALIDATE

Line 960: -- Variables for INV_Validate APIs

956: l_debug_on BOOLEAN;
957: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INIT';
958: --
959:
960: -- Variables for INV_Validate APIs
961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;

Line 961: l_validate_org INV_Validate.Org;

957: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INIT';
958: --
959:
960: -- Variables for INV_Validate APIs
961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;
965: l_validate_item INV_Validate.Item;

Line 962: l_validate_sub INV_Validate.Sub;

958: --
959:
960: -- Variables for INV_Validate APIs
961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;
965: l_validate_item INV_Validate.Item;
966:

Line 963: l_validate_from_sub INV_Validate.Sub;

959:
960: -- Variables for INV_Validate APIs
961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;
965: l_validate_item INV_Validate.Item;
966:
967:

Line 964: l_validate_locator INV_Validate.Locator;

960: -- Variables for INV_Validate APIs
961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;
965: l_validate_item INV_Validate.Item;
966:
967:
968: BEGIN

Line 965: l_validate_item INV_Validate.Item;

961: l_validate_org INV_Validate.Org;
962: l_validate_sub INV_Validate.Sub;
963: l_validate_from_sub INV_Validate.Sub;
964: l_validate_locator INV_Validate.Locator;
965: l_validate_item INV_Validate.Item;
966:
967:
968: BEGIN
969: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1319: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);

1315: -- Validating From_Subinventory and From_Locator
1316: IF (g_from_subinventory IS NOT NULL) THEN --{
1317:
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1320: END IF;
1321: l_validate_org := NULL;
1322: l_validate_sub := NULL;
1323: l_validate_locator := NULL;

Line 1328: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,

1324: l_validate_item := NULL;
1325: l_validate_sub.secondary_inventory_name := g_from_subinventory;
1326: l_validate_org.organization_id := g_organization_id;
1327:
1328: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,
1329: p_org => l_validate_org,
1330: p_item => l_validate_item,
1331: p_acct_txn => 1
1332: ) = 0 ) THEN

Line 1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);

1343: END IF;
1344:
1345: IF (g_from_locator IS NOT NULL) THEN
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: END IF;
1349: l_validate_locator.inventory_location_id := g_from_locator;
1350: IF (INV_Validate.From_Locator( p_locator => l_validate_locator,
1351: p_org => l_validate_org,

Line 1350: IF (INV_Validate.From_Locator( p_locator => l_validate_locator,

1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: END IF;
1349: l_validate_locator.inventory_location_id := g_from_locator;
1350: IF (INV_Validate.From_Locator( p_locator => l_validate_locator,
1351: p_org => l_validate_org,
1352: p_item => l_validate_item,
1353: p_from_sub => l_validate_sub,
1354: p_project_id => g_project_id,

Line 1376: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);

1372: -- Validating To_Subinventory and To_Locator
1373: IF (g_to_subinventory IS NOT NULL) THEN --{
1374:
1375: IF l_debug_on THEN
1376: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1377: END IF;
1378: l_validate_org := NULL;
1379: l_validate_sub := NULL;
1380: l_validate_from_sub := NULL;

Line 1387: IF (INV_Validate.To_Subinventory( p_sub => l_validate_sub,

1383: l_validate_sub.secondary_inventory_name := g_to_subinventory;
1384: l_validate_org.organization_id := g_organization_id;
1385: l_validate_from_sub.secondary_inventory_name := g_from_subinventory;
1386:
1387: IF (INV_Validate.To_Subinventory( p_sub => l_validate_sub,
1388: p_org => l_validate_org,
1389: p_item => l_validate_item,
1390: p_from_sub => l_validate_from_sub,
1391: p_acct_txn => 1

Line 1407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);

1403: END IF;
1404:
1405: IF (g_to_locator IS NOT NULL) THEN
1406: IF l_debug_on THEN
1407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1408: END IF;
1409: l_validate_locator.inventory_location_id := g_to_locator;
1410: IF (INV_Validate.To_Locator( p_locator => l_validate_locator,
1411: p_org => l_validate_org,

Line 1410: IF (INV_Validate.To_Locator( p_locator => l_validate_locator,

1406: IF l_debug_on THEN
1407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1408: END IF;
1409: l_validate_locator.inventory_location_id := g_to_locator;
1410: IF (INV_Validate.To_Locator( p_locator => l_validate_locator,
1411: p_org => l_validate_org,
1412: p_item => l_validate_item,
1413: p_to_sub => l_validate_sub,
1414: p_project_id => g_project_id,

Line 1434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);

1430:
1431: -- Validating RelSubinventory
1432: IF (g_relsubinventory IS NOT NULL) THEN --{
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1435: END IF;
1436: l_validate_org := NULL;
1437: l_validate_sub := NULL;
1438: l_validate_locator := NULL;

Line 1443: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,

1439: l_validate_item := NULL;
1440: l_validate_sub.secondary_inventory_name := g_relsubinventory;
1441: l_validate_org.organization_id := g_organization_id;
1442:
1443: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,
1444: p_org => l_validate_org,
1445: p_item => l_validate_item,
1446: p_acct_txn => 1
1447: ) = 0 ) THEN