DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_PVT dependencies on INV_CONVERT

Line 1256: l_sec_qty := inv_convert.inv_um_convert

1252: l_from_um := l_dtl_um;
1253: l_to_um := p_secondary_uom_code;
1254:
1255: -- We need to derive secondary from the dtl qty
1256: l_sec_qty := inv_convert.inv_um_convert
1257: (item_id => p_mtl_dtl_rec.inventory_item_id
1258: ,precision => gme_common_pvt.g_precision
1259: ,from_quantity => l_dtl_qty
1260: ,from_unit => l_dtl_um

Line 1268: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' REL2 - PRIM TO SEC - inv_convert.inv_um_convert returned error');

1264:
1265: -- Let's see if conversion went wrong.
1266: IF (NVL(l_sec_qty, 0) = -99999) THEN
1267: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1268: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' REL2 - PRIM TO SEC - inv_convert.inv_um_convert returned error');
1269: END IF;
1270: RAISE um_convert_error;
1271: END IF;
1272: ELSE

Line 1278: l_dtl_qty := inv_convert.inv_um_convert

1274: l_from_um := p_secondary_uom_code;
1275: l_to_um := l_dtl_um;
1276:
1277: -- This means that we need to derive the dtl qty from the secondary qty.
1278: l_dtl_qty := inv_convert.inv_um_convert
1279: (item_id => p_mtl_dtl_rec.inventory_item_id
1280: ,precision => gme_common_pvt.g_precision
1281: ,from_quantity => l_sec_qty
1282: ,from_unit => p_secondary_uom_code

Line 1290: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' REL2 - SEC TO PRIM - inv_convert.inv_um_convert returned error');

1286:
1287: -- Let's see if conversion went wrong.
1288: IF (l_dtl_qty = -99999) THEN
1289: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1290: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' REL2 - SEC TO PRIM - inv_convert.inv_um_convert returned error');
1291: END IF;
1292: RAISE um_convert_error;
1293: END IF;
1294: END IF;

Line 1298: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1294: END IF;
1295: END IF;
1296:
1297: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1298: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1299: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));
1300: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_sec_qty= '||to_char(l_sec_qty));
1301: END IF;
1302: -- We now have in hand both the dtl and secondary qty in the correct UOM.

Line 1327: l_prim_qty := inv_convert.inv_um_convert

1323: l_to_um := l_primary_um;
1324:
1325: -- Bug 8741777 changed assignment from l_dtl_qty to l_prim_qty
1326: -- as it is conversion to primary qty
1327: l_prim_qty := inv_convert.inv_um_convert
1328: (item_id => p_mtl_dtl_rec.inventory_item_id
1329: ,precision => gme_common_pvt.g_precision
1330: ,from_quantity => l_dtl_qty
1331: ,from_unit => l_dtl_um

Line 1338: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' DTL TO PRIM - inv_convert.inv_um_convert returned error');

1334: ,to_name => NULL);
1335:
1336: IF l_prim_qty = -99999 THEN
1337: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1338: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' DTL TO PRIM - inv_convert.inv_um_convert returned error');
1339: END IF;
1340: RAISE um_convert_error;
1341: END IF;
1342:

Line 1344: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' DTL TO PRIM - after call to inv_convert.inv_um_convert');

1340: RAISE um_convert_error;
1341: END IF;
1342:
1343: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1344: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' DTL TO PRIM - after call to inv_convert.inv_um_convert');
1345: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));
1346: END IF;
1347: END IF;
1348: END IF;

Line 1360: l_dtl_qty := inv_convert.inv_um_convert

1356: -- Bug 12813284 - Initialize variables for error message.
1357: l_from_um := l_primary_um;
1358: l_to_um := l_dtl_um;
1359:
1360: l_dtl_qty := inv_convert.inv_um_convert
1361: (item_id => p_mtl_dtl_rec.inventory_item_id
1362: ,precision => gme_common_pvt.g_precision
1363: ,from_quantity => l_prim_qty
1364: ,from_unit => l_primary_um

Line 1371: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' PRIM TO DTL - inv_convert.inv_um_convert returned error');

1367: ,to_name => NULL);
1368:
1369: IF l_dtl_qty = -99999 THEN
1370: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1371: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' PRIM TO DTL - inv_convert.inv_um_convert returned error');
1372: END IF;
1373: RAISE um_convert_error;
1374: END IF;
1375:

Line 1377: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1373: RAISE um_convert_error;
1374: END IF;
1375:
1376: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1377: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1378: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));
1379: END IF;
1380: END IF;
1381: END IF;

Line 1517: l_prim_qty := inv_convert.inv_um_convert

1513: IF l_prim_qty IS NULL THEN
1514: -- need to consider lot conversion as well
1515: l_from_um := p_mtl_dtl_rec.dtl_um;
1516: l_to_um := p_rsrv_rec.primary_uom_code;
1517: l_prim_qty := inv_convert.inv_um_convert
1518: (item_id => p_mtl_dtl_rec.inventory_item_id
1519: ,precision => gme_common_pvt.g_precision
1520: ,from_quantity => l_trxn_qty
1521: ,from_unit => l_from_um

Line 1527: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' rsrv_mode - DTL to PRIM - inv_convert.inv_um_convert returned error');

1523: ,from_name => NULL
1524: ,to_name => NULL);
1525: IF l_prim_qty = -99999 THEN
1526: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1527: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' rsrv_mode - DTL to PRIM - inv_convert.inv_um_convert returned error');
1528: END IF;
1529: RAISE um_convert_error;
1530: END IF;
1531: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN