DBA Data[Home] [Help]

APPS.WSH_PR_CRITERIA dependencies on INV_VALIDATE

Line 928: -- Variables for INV_Validate APIs

924: l_debug_on BOOLEAN;
925: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INIT';
926: --
927:
928: -- Variables for INV_Validate APIs
929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;

Line 929: l_validate_org INV_Validate.Org;

925: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INIT';
926: --
927:
928: -- Variables for INV_Validate APIs
929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;
933: l_validate_item INV_Validate.Item;

Line 930: l_validate_sub INV_Validate.Sub;

926: --
927:
928: -- Variables for INV_Validate APIs
929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;
933: l_validate_item INV_Validate.Item;
934:

Line 931: l_validate_from_sub INV_Validate.Sub;

927:
928: -- Variables for INV_Validate APIs
929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;
933: l_validate_item INV_Validate.Item;
934:
935:

Line 932: l_validate_locator INV_Validate.Locator;

928: -- Variables for INV_Validate APIs
929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;
933: l_validate_item INV_Validate.Item;
934:
935:
936: BEGIN

Line 933: l_validate_item INV_Validate.Item;

929: l_validate_org INV_Validate.Org;
930: l_validate_sub INV_Validate.Sub;
931: l_validate_from_sub INV_Validate.Sub;
932: l_validate_locator INV_Validate.Locator;
933: l_validate_item INV_Validate.Item;
934:
935:
936: BEGIN
937: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

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

1254: -- Validating From_Subinventory and From_Locator
1255: IF (g_from_subinventory IS NOT NULL) THEN --{
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260: l_validate_org := NULL;
1261: l_validate_sub := NULL;
1262: l_validate_locator := NULL;

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

1263: l_validate_item := NULL;
1264: l_validate_sub.secondary_inventory_name := g_from_subinventory;
1265: l_validate_org.organization_id := g_organization_id;
1266:
1267: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,
1268: p_org => l_validate_org,
1269: p_item => l_validate_item,
1270: p_acct_txn => 1
1271: ) = 0 ) THEN

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

1282: END IF;
1283:
1284: IF (g_from_locator IS NOT NULL) THEN
1285: IF l_debug_on THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1287: END IF;
1288: l_validate_locator.inventory_location_id := g_from_locator;
1289: IF (INV_Validate.From_Locator( p_locator => l_validate_locator,
1290: p_org => l_validate_org,

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

1285: IF l_debug_on THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Locator',WSH_DEBUG_SV.C_PROC_LEVEL);
1287: END IF;
1288: l_validate_locator.inventory_location_id := g_from_locator;
1289: IF (INV_Validate.From_Locator( p_locator => l_validate_locator,
1290: p_org => l_validate_org,
1291: p_item => l_validate_item,
1292: p_from_sub => l_validate_sub,
1293: p_project_id => g_project_id,

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

1311: -- Validating To_Subinventory and To_Locator
1312: IF (g_to_subinventory IS NOT NULL) THEN --{
1313:
1314: IF l_debug_on THEN
1315: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.To_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1316: END IF;
1317: l_validate_org := NULL;
1318: l_validate_sub := NULL;
1319: l_validate_from_sub := NULL;

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

1322: l_validate_sub.secondary_inventory_name := g_to_subinventory;
1323: l_validate_org.organization_id := g_organization_id;
1324: l_validate_from_sub.secondary_inventory_name := g_from_subinventory;
1325:
1326: IF (INV_Validate.To_Subinventory( p_sub => l_validate_sub,
1327: p_org => l_validate_org,
1328: p_item => l_validate_item,
1329: p_from_sub => l_validate_from_sub,
1330: p_acct_txn => 1

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

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

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

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

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

1369:
1370: -- Validating RelSubinventory
1371: IF (g_relsubinventory IS NOT NULL) THEN --{
1372: IF l_debug_on THEN
1373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_Validate.From_Subinventory',WSH_DEBUG_SV.C_PROC_LEVEL);
1374: END IF;
1375: l_validate_org := NULL;
1376: l_validate_sub := NULL;
1377: l_validate_locator := NULL;

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

1378: l_validate_item := NULL;
1379: l_validate_sub.secondary_inventory_name := g_relsubinventory;
1380: l_validate_org.organization_id := g_organization_id;
1381:
1382: IF (INV_Validate.From_Subinventory( p_sub => l_validate_sub,
1383: p_org => l_validate_org,
1384: p_item => l_validate_item,
1385: p_acct_txn => 1
1386: ) = 0 ) THEN