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.INV_PICK_RELEASE_PUB dependencies on INV_PICK_RELEASE_PUB

Line 1: PACKAGE BODY INV_Pick_Release_PUB AS

1: PACKAGE BODY INV_Pick_Release_PUB AS
2: /* $Header: INVPPICB.pls 120.41.12020000.7 2013/03/29 10:53:20 brana ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Pick_Release_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Pick_Release_PUB';

1: PACKAGE BODY INV_Pick_Release_PUB AS
2: /* $Header: INVPPICB.pls 120.41.12020000.7 2013/03/29 10:53:20 brana ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Pick_Release_PUB';
6:
7: is_debug BOOLEAN := NULL;
8: all_del_det_bo_tbl WSH_INTERFACE.ChangedAttributeTabType;
9: g_org_grouping_rule_id NUMBER;

Line 99: print_debug('Inside Store_smc_bo_details','INV_PICK_RELEASE_PUB');

95:
96:
97: BEGIN
98: If is_debug Then
99: print_debug('Inside Store_smc_bo_details','INV_PICK_RELEASE_PUB');
100: print_debug('delivery detail'||back_order_det_tbl(1).delivery_detail_id,
101: 'INV_PICK_RELEASE_PUB');
102: End If;
103: x_return_status := fnd_api.g_ret_sts_success;

Line 101: 'INV_PICK_RELEASE_PUB');

97: BEGIN
98: If is_debug Then
99: print_debug('Inside Store_smc_bo_details','INV_PICK_RELEASE_PUB');
100: print_debug('delivery detail'||back_order_det_tbl(1).delivery_detail_id,
101: 'INV_PICK_RELEASE_PUB');
102: End If;
103: x_return_status := fnd_api.g_ret_sts_success;
104:
105: if back_order_det_tbl.count >0 then

Line 109: 'INV_PICK_RELEASE_PUB');

105: if back_order_det_tbl.count >0 then
106: l_delivery_detail_id :=back_order_det_tbl(1).delivery_detail_id;
107: If is_debug Then
108: print_debug('Delivery detail'||l_delivery_detail_id,
109: 'INV_PICK_RELEASE_PUB');
110: End If;
111: l_new_cycle_count_quantity :=back_order_det_tbl(1).cycle_count_quantity;
112:
113: end if;

Line 126: ,'INV_PICK_RELEASE_PUB');

122:
123: If is_debug Then
124: print_debug('New Cycle count Qty: '
125: ||all_del_det_bo_tbl(l_delivery_detail_id).cycle_count_quantity
126: ,'INV_PICK_RELEASE_PUB');
127: End If;
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: --

Line 134: print_debug(SQLERRM,'INV_PICK_RELEASE_PUB');

130: --
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: if is_debug then
134: print_debug(SQLERRM,'INV_PICK_RELEASE_PUB');
135: end if;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: WHEN OTHERS THEN
138: if is_debug then

Line 139: print_debug(SQLERRM,'INV_PICK_RELEASE_PUB');

135: end if;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: WHEN OTHERS THEN
138: if is_debug then
139: print_debug(SQLERRM,'INV_PICK_RELEASE_PUB');
140: end if;
141: ROLLBACK TO Pick_Release_PUB;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END;

Line 185: print_debug('Backordering SMC','INV_PICK_RELEASE_PUB');

181: all_del_det_bo_tbl(l_del_index).subinventory ;
182: l_shipping_attr(1).locator_id :=all_del_det_bo_tbl(l_del_index).locator_id;
183:
184: if is_debug then
185: print_debug('Backordering SMC','INV_PICK_RELEASE_PUB');
186: print_debug('Delivery detail'|| l_shipping_attr(1).delivery_detail_id,
187: 'INV_PICK_RELEASE_PUB');
188: end if;
189:

Line 187: 'INV_PICK_RELEASE_PUB');

183:
184: if is_debug then
185: print_debug('Backordering SMC','INV_PICK_RELEASE_PUB');
186: print_debug('Delivery detail'|| l_shipping_attr(1).delivery_detail_id,
187: 'INV_PICK_RELEASE_PUB');
188: end if;
189:
190: WSH_INTERFACE.Update_Shipping_Attributes
191: (p_source_code => 'INV',

Line 199: 'Inv_Pick_Release_Pub.Pick_Release');

195:
196: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
197: if is_debug then
198: print_debug('return error from update shipping attributes',
199: 'Inv_Pick_Release_Pub.Pick_Release');
200: end if;
201: raise FND_API.G_EXC_ERROR;
202: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
203: if is_debug then

Line 205: 'Inv_Pick_Release_Pub.Pick_Release');

201: raise FND_API.G_EXC_ERROR;
202: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
203: if is_debug then
204: print_debug('return error from update shipping attributes',
205: 'Inv_Pick_Release_Pub.Pick_Release');
206: end if;
207: raise FND_API.G_EXC_UNEXPECTED_ERROR;
208: end if;
209:

Line 688: INV_Pick_Release_Pub.Pick_Release

684: l_trolin_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
685: l_del_detail_id WSH_PICK_LIST.DelDetTabTyp;
686:
687: BEGIN
688: INV_Pick_Release_Pub.Pick_Release
689: (
690: p_api_version => p_api_version
691: ,p_init_msg_list => p_init_msg_list
692: ,p_commit => p_commit

Line 1018: print_debug('Inside Pick_Release', 'INV_Pick_Release_Pub.Pick_Release');

1014: END IF;
1015:
1016: -- Set savepoint for this API
1017: If is_debug then
1018: print_debug('Inside Pick_Release', 'INV_Pick_Release_Pub.Pick_Release');
1019: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment, 'INV_Pick_Release_Pub.Pick_Release');
1020: End If;
1021:
1022: l_return_value := inv_cache.set_pick_release(TRUE); --Added for bug3237702

Line 1019: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment, 'INV_Pick_Release_Pub.Pick_Release');

1015:
1016: -- Set savepoint for this API
1017: If is_debug then
1018: print_debug('Inside Pick_Release', 'INV_Pick_Release_Pub.Pick_Release');
1019: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment, 'INV_Pick_Release_Pub.Pick_Release');
1020: End If;
1021:
1022: l_return_value := inv_cache.set_pick_release(TRUE); --Added for bug3237702
1023: inv_log_util.g_maintain_log_profile := TRUE; -- Bug 5558315 - duplication so no dependency btw inv_cache and inv_log

Line 1030: print_debug('Fnd_APi not compatible','INV_Pick_Release_Pub.Pick_Release');

1026:
1027: -- Standard Call to check for call compatibility
1028: IF NOT fnd_api.Compatible_API_Call(l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN
1029: If is_debug then
1030: print_debug('Fnd_APi not compatible','INV_Pick_Release_Pub.Pick_Release');
1031: End If;
1032: RAISE fnd_api.g_exc_unexpected_error;
1033: END IF;
1034:

Line 1051: print_debug('No Lines to pick', 'INV_Pick_Release_Pub.Pick_Release');

1047: -- any records
1048: l_mo_line_count := p_mo_line_tbl.COUNT;
1049: IF l_mo_line_count = 0 THEN
1050: If is_debug then
1051: print_debug('No Lines to pick', 'INV_Pick_Release_Pub.Pick_Release');
1052: End If;
1053:
1054: ROLLBACK TO Pick_Release_PUB;
1055: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');

Line 1092: print_debug('Error: Trying to pick for different org','INV_Pick_Release_Pub.Pick_Release');

1088:
1089: -- Verify that the lines are all for the same organization
1090: IF l_mo_line.organization_id <> l_organization_id THEN
1091: If is_debug then
1092: print_debug('Error: Trying to pick for different org','INV_Pick_Release_Pub.Pick_Release');
1093: End If;
1094:
1095: ROLLBACK TO Pick_Release_PUB;
1096: FND_MESSAGE.SET_NAME('INV','INV_PICK_DIFFERENT_ORG');

Line 1104: print_debug('Error: Invalid Move Order Line Status','INV_Pick_Release_Pub.Pick_Release');

1100:
1101: -- Verify that the line status is approved or pre-approved
1102: IF (l_mo_line.line_status <> 3 AND l_mo_line.line_status <> 7) THEN
1103: If is_debug then
1104: print_debug('Error: Invalid Move Order Line Status','INV_Pick_Release_Pub.Pick_Release');
1105: End If;
1106:
1107: ROLLBACK TO Pick_Release_PUB;
1108: FND_MESSAGE.SET_NAME('INV','INV_PICK_LINE_STATUS');

Line 1118: print_debug('Error setting cache for move order header ','INV_Pick_Release_Pub.Pick_Release');

1114: l_current_header_id IS NULL THEN
1115: l_return_value := INV_CACHE.set_mtrh_rec(l_mo_line.header_Id);
1116: If NOT l_return_value Then
1117: If is_debug then
1118: print_debug('Error setting cache for move order header ','INV_Pick_Release_Pub.Pick_Release');
1119: End If;
1120: RAISE fnd_api.g_exc_unexpected_error;
1121: End If;
1122: l_mo_type := INV_CACHE.mtrh_rec.move_order_type;

Line 1129: print_debug('Error: Trying to release non pick wave move order','INV_Pick_Release_Pub.Pick_Release');

1125: END IF;
1126:
1127: IF l_mo_type <> 3 THEN
1128: If is_debug then
1129: print_debug('Error: Trying to release non pick wave move order','INV_Pick_Release_Pub.Pick_Release');
1130: End If;
1131:
1132: ROLLBACK TO Pick_Release_PUB;
1133: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');

Line 1239: print_debug('No Item Info found','Inv_Pick_Release_Pub.Pick_Release');

1235: EXCEPTION
1236: WHEN no_data_found THEN
1237: ROLLBACK TO Pick_Release_PUB;
1238: If is_debug then
1239: print_debug('No Item Info found','Inv_Pick_Release_Pub.Pick_Release');
1240: End If;
1241: RAISE fnd_api.g_exc_unexpected_error;
1242: END;
1243:

Line 1323: 'Inv_Pick_Release_PUB.Pick_release');

1319: WHEN others THEN
1320: l_OE_HEADER_ID :=-9999;
1321: If is_debug then
1322: print_debug('No data found-Delivery Info',
1323: 'Inv_Pick_Release_PUB.Pick_release');
1324: End If;
1325: --ROLLBACK TO Pick_Release_PUB;
1326: --FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
1327: -- FND_MSG_PUB.Add;

Line 1335: print_debug('No Mtl_Sales_Order ID found for oe header','Inv_Pick_Release_PUB.Process_Line');

1331: l_return_value := INV_CACHE.set_mso_rec(l_oe_header_id);
1332: IF NOT l_return_value THEN
1333: l_mso_header_id :=-9999;
1334: If is_debug then
1335: print_debug('No Mtl_Sales_Order ID found for oe header','Inv_Pick_Release_PUB.Process_Line');
1336: End If;
1337: ELSE
1338: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;
1339: END IF;

Line 1389: print_debug('Error from Create tree','Inv_pick_release_pub.Pick_release');

1385: l_qtree_line_tbl(l_qtree_line_index).tree_id := l_tree_id;
1386:
1387: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1388: If is_debug then
1389: print_debug('Error from Create tree','Inv_pick_release_pub.Pick_release');
1390: End If;
1391: RAISE fnd_api.g_exc_error ;
1392: ELSIF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN
1393: If is_debug then

Line 1394: print_debug('Unexpected error from Create tree','Inv_pick_release_pub.Pick_release');

1390: End If;
1391: RAISE fnd_api.g_exc_error ;
1392: ELSIF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN
1393: If is_debug then
1394: print_debug('Unexpected error from Create tree','Inv_pick_release_pub.Pick_release');
1395: End If;
1396: RAISE fnd_api.g_exc_unexpected_error;
1397: END IF;
1398:

Line 1416: print_debug('Error setting cache for wms installed','INV_Pick_Release_Pub.Pick_Release');

1412: -- l_mo_line_tbl(l_line_index).organization_id);
1413: l_return_value := INV_CACHE.set_wms_installed(l_organization_id);
1414: If NOT l_return_value Then
1415: If is_debug then
1416: print_debug('Error setting cache for wms installed','INV_Pick_Release_Pub.Pick_Release');
1417: End If;
1418: RAISE fnd_api.g_exc_unexpected_error;
1419: End If;
1420: l_wms_installed := INV_CACHE.wms_installed;

Line 1431: print_debug('Error: Invalid auto_pick_confirm flag','INV_Pick_Release_Pub.Pick_Release');

1427: -- Determine whether or not to automatically pick confirm
1428: IF p_auto_pick_confirm IS NOT NULL THEN
1429: IF (p_auto_pick_confirm <> 1 AND p_auto_pick_confirm <> 2) THEN
1430: If is_debug then
1431: print_debug('Error: Invalid auto_pick_confirm flag','INV_Pick_Release_Pub.Pick_Release');
1432: End If;
1433: ROLLBACK TO Pick_Release_PUB;
1434: FND_MESSAGE.SET_NAME('INV','INV_AUTO_PICK_CONFIRM_PARAM');
1435: FND_MSG_PUB.Add;

Line 1446: 'INV_Pick_Release_Pub.Pick_Release');

1442: l_return_value := INV_CACHE.set_org_rec(l_organization_id);
1443: If NOT l_return_value Then
1444: If is_debug then
1445: print_debug('Error setting cache for organization',
1446: 'INV_Pick_Release_Pub.Pick_Release');
1447: End If;
1448: RAISE fnd_api.g_exc_unexpected_error;
1449: End If;
1450: l_auto_pick_confirm:= INV_CACHE.org_rec.mo_pick_confirm_required;

Line 1469: print_debug('Error: print_pick_slip_mode not defined','INV_Pick_Release_Pub.Pick_Release');

1465: WHERE organization_id = l_organization_id;
1466: EXCEPTION
1467: WHEN no_data_found THEN
1468: If is_debug then
1469: print_debug('Error: print_pick_slip_mode not defined','INV_Pick_Release_Pub.Pick_Release');
1470: End If;
1471: ROLLBACK TO Pick_Release_PUB;
1472: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
1473: FND_MSG_PUB.Add;

Line 1486: print_debug('Error: invalid partial pick parameter','INV_Pick_Release_Pub.Pick_Release');

1482: IF p_allow_partial_pick <> fnd_api.g_true AND
1483: p_allow_partial_pick <> fnd_api.g_false THEN
1484:
1485: If is_debug then
1486: print_debug('Error: invalid partial pick parameter','INV_Pick_Release_Pub.Pick_Release');
1487: End If;
1488: ROLLBACK TO Pick_Release_PUB;
1489: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PARTIAL_PICK_PARAM');
1490: FND_MSG_PUB.Add;

Line 1495: print_debug('p_allow_partial_pick is ' || p_allow_partial_pick,'Inv_Pick_Release_Pub.Pick_Release');

1491: RAISE fnd_api.g_exc_unexpected_error;
1492: END IF;
1493:
1494: If is_debug then
1495: print_debug('p_allow_partial_pick is ' || p_allow_partial_pick,'Inv_Pick_Release_Pub.Pick_Release');
1496: End If;
1497:
1498: -- The Move Order Lines may need to have their grouping rule ID defaulted
1499: -- from the header. This is only necessary if the Grouping Rule ID was not

Line 1523: print_debug('Error setting cache for WSH picking batch record','INV_Pick_Release_Pub.Pick_Release');

1519: IF (NOT INV_CACHE.set_wpb_rec
1520: (p_batch_id => NULL,
1521: p_request_number => INV_CACHE.mtrh_rec.request_number)) THEN
1522: IF (is_debug) THEN
1523: print_debug('Error setting cache for WSH picking batch record','INV_Pick_Release_Pub.Pick_Release');
1524: END IF;
1525: RAISE fnd_api.g_exc_unexpected_error;
1526: END IF;
1527: -- Set the allocation method variable

Line 1537: print_debug('Mismatch in size of input tables from Shipping for delivery creation','INV_Pick_Release_Pub.Pick_Release');

1533: -- NULL empty tables should be passed by Shipping for this. These tables are used to store
1534: -- crossdocked WDD lines so deliveries can be created for them.
1535: IF (p_del_detail_id.COUNT <> p_trolin_delivery_ids.COUNT) THEN
1536: IF (is_debug) THEN
1537: print_debug('Mismatch in size of input tables from Shipping for delivery creation','INV_Pick_Release_Pub.Pick_Release');
1538: END IF;
1539: RAISE fnd_api.g_exc_unexpected_error;
1540: END IF;
1541:

Line 1567: 'Inv_Pick_Release_Pub.Pick_Release');

1563: l_line_index := p_wsh_release_table.FIRST;
1564: l_wdd_index_tbl.DELETE;
1565: IF (is_debug) THEN
1566: print_debug('Build the WDD index pointer table (Prioritize Inventory)',
1567: 'Inv_Pick_Release_Pub.Pick_Release');
1568: END IF;
1569: LOOP
1570: -- Store this WDD record into the WDD index pointer table
1571: l_wdd_index_tbl(p_wsh_release_table(l_line_index).delivery_detail_id) := l_line_index;

Line 1580: print_debug('Before calling the update_wave_lines_tbl ','Inv_Pick_Release_Pub.Pick_Release');

1576: END IF;
1577:
1578: if l_wms_installed then -- 14781148
1579: IF (is_debug) THEN
1580: print_debug('Before calling the update_wave_lines_tbl ','Inv_Pick_Release_Pub.Pick_Release');
1581: END IF;
1582:
1583: wms_wave_planning_pvt.update_wave_lines_tbl( p_mo_line_table => l_mo_line_tbl
1584: ,x_return_status => l_return_status);

Line 1588: print_debug('After calling the update_wave_lines_tbl which has returned error - Still Continue with rest of Pick Release','Inv_Pick_Release_Pub.Pick_Release');

1584: ,x_return_status => l_return_status);
1585:
1586: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1587: IF (l_debug = 1) THEN
1588: print_debug('After calling the update_wave_lines_tbl which has returned error - Still Continue with rest of Pick Release','Inv_Pick_Release_Pub.Pick_Release');
1589: END IF;
1590: END IF;
1591:
1592: IF (is_debug) THEN

Line 1593: print_debug('After calling the update_wave_lines_tbl ','Inv_Pick_Release_Pub.Pick_Release');

1589: END IF;
1590: END IF;
1591:
1592: IF (is_debug) THEN
1593: print_debug('After calling the update_wave_lines_tbl ','Inv_Pick_Release_Pub.Pick_Release');
1594: END IF;
1595: end if; -- 14781148
1596:
1597:

Line 1612: 'INV_Pick_Release_Pub.Pick_Release');

1608: l_return_value := INV_CACHE.set_mtrh_rec(l_mo_line.header_id);
1609: If NOT l_return_value Then
1610: If is_debug then
1611: print_debug('Error setting cache for move order header ',
1612: 'INV_Pick_Release_Pub.Pick_Release');
1613: End If;
1614: RAISE fnd_api.g_exc_unexpected_error;
1615: End If;
1616: l_grouping_rule_id := INV_CACHE.mtrh_rec.grouping_rule_id;

Line 1637: 'INV_Pick_Release_Pub.Pick_Release');

1633: EXCEPTION
1634: WHEN no_data_found THEN
1635: If is_debug then
1636: print_debug('Error finding org grouping rules',
1637: 'INV_Pick_Release_Pub.Pick_Release');
1638: End If;
1639: ROLLBACK TO Pick_Release_PUB;
1640: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
1641: FND_MSG_PUB.Add;

Line 1670: 'Inv_Pick_Release_Pub.Pick_Release');

1666: l_start_process := l_processed_row_count;
1667: l_qtree_backup_tbl.DELETE;
1668: If is_debug then
1669: print_debug('Start Shipset :' || l_cur_ship_set_id,
1670: 'Inv_Pick_Release_Pub.Pick_Release');
1671: End If;
1672: ELSIF l_cur_ship_set_id IS NOT NULL AND
1673: l_mo_line.ship_set_id IS NULL THEN
1674: If is_debug then

Line 1676: 'Inv_Pick_Release_Pub.Pick_Release');

1672: ELSIF l_cur_ship_set_id IS NOT NULL AND
1673: l_mo_line.ship_set_id IS NULL THEN
1674: If is_debug then
1675: print_debug('End of Shipset :' || l_cur_ship_set_id,
1676: 'Inv_Pick_Release_Pub.Pick_Release');
1677: End If;
1678: l_cur_ship_set_id := NULL;
1679: l_qtree_backup_tbl.DELETE;
1680: END IF;

Line 1706: 'Inv_Pick_Release_Pub.Pick_Release');

1702: l_start_process := l_processed_row_count;
1703: l_qtree_backup_tbl.DELETE;
1704: If is_debug then
1705: print_debug('Start Ship Model :' || l_cur_ship_model_id,
1706: 'Inv_Pick_Release_Pub.Pick_Release');
1707: End If;
1708: ELSIF l_cur_ship_model_id IS NOT NULL AND
1709: l_mo_line.ship_model_id IS NULL THEN
1710: If is_debug then

Line 1712: 'Inv_Pick_Release_Pub.Pick_Release');

1708: ELSIF l_cur_ship_model_id IS NOT NULL AND
1709: l_mo_line.ship_model_id IS NULL THEN
1710: If is_debug then
1711: print_debug('End of Ship Model :' || l_cur_ship_model_id,
1712: 'Inv_Pick_Release_Pub.Pick_Release');
1713: End If;
1714: l_cur_ship_model_id := NULL;
1715: l_qtree_backup_tbl.DELETE;
1716: END IF;

Line 1734: 'Inv_Pick_Release_Pub.Pick_Release');

1730: --only backup the tree if it is not already backed up
1731: If Not l_qtree_backup_tbl.Exists(l_tree_id) Then
1732: If is_debug then
1733: print_debug('Backing up qty tree: ' || l_tree_id,
1734: 'Inv_Pick_Release_Pub.Pick_Release');
1735: End If;
1736: --Bug 2814919
1737: if l_tree_id is not null then
1738: inv_quantity_tree_pvt.backup_tree(

Line 1773: print_debug('Set Current Txn Src Line:' || l_cur_txn_source_line_id,'Inv_Pick_Release_Pub.Pick_Release');

1769: l_cur_txn_source_qty := 0;
1770: -- HW INVCONV Added Qty2
1771: l_cur_txn_source_qty2 := 0;
1772: If is_debug then
1773: print_debug('Set Current Txn Src Line:' || l_cur_txn_source_line_id,'Inv_Pick_Release_Pub.Pick_Release');
1774: End If;
1775: END IF;
1776:
1777: g_pick_expired_lots := FALSE;

Line 1788: 'Inv_Pick_Release_Pub.Pick_Release');

1784:
1785: -- Call the Pick Release Process_Line API on the current Move Order Line
1786: If is_debug then
1787: print_debug('calling INV_Pick_Release_PVT.process_line',
1788: 'Inv_Pick_Release_Pub.Pick_Release');
1789: End If;
1790:
1791: INV_Pick_Release_PVT.Process_Line(
1792: p_api_version => 1.0

Line 1807: print_debug('l_return_status from process_line is '|| l_api_return_status, 'Inv_Pick_Release_Pub.Pick_Release');

1803: ,p_plan_tasks => p_plan_tasks
1804: );
1805:
1806: If is_debug then
1807: print_debug('l_return_status from process_line is '|| l_api_return_status, 'Inv_Pick_Release_Pub.Pick_Release');
1808: End If;
1809:
1810: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1811: -- Return error if Process_Line returns error and

Line 1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');

1851: l_quantity :=l_mo_line.required_quantity;
1852: END IF;
1853:
1854: If is_debug then
1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');

Line 1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');

1852: END IF;
1853:
1854: If is_debug then
1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');

Line 1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');

1853:
1854: If is_debug then
1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');

Line 1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');

1854: If is_debug then
1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');

Line 1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');

1855: print_debug('l_quantity '|| l_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');

Line 1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');

1856: print_debug('l_line_status '|| l_line_status, 'Inv_Pick_Release_Pub.Pick_Release');
1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');
1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');

Line 1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');

1857: print_debug('l_quantity_delivered '|| l_quantity_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');
1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');
1865: end if;

Line 1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');

1858: print_debug('l_transaction_quantity '|| l_transaction_quantity, 'Inv_Pick_Release_Pub.Pick_Release');
1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');
1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');
1865: end if;
1866:

Line 1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');

1859: print_debug('l_cur_txn_source_qty '|| l_cur_txn_source_qty, 'Inv_Pick_Release_Pub.Pick_Release');
1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');
1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');
1865: end if;
1866:
1867: -- If the total allocated quantity is less than the requested

Line 1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');

1860: print_debug('l_quantity2_delivered '|| l_quantity2_delivered, 'Inv_Pick_Release_Pub.Pick_Release');
1861: print_debug('l_transaction_quantity2 '|| l_transaction_quantity2, 'Inv_Pick_Release_Pub.Pick_Release');
1862: print_debug('l_cur_txn_source_qty2 '|| l_cur_txn_source_qty2, 'Inv_Pick_Release_Pub.Pick_Release');
1863: print_debug('l_cur_ship_set_id '|| l_cur_ship_set_id, 'Inv_Pick_Release_Pub.Pick_Release');
1864: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,'INV_Pick_Release_Pub.Pick_Release');
1865: end if;
1866:
1867: -- If the total allocated quantity is less than the requested
1868: -- quantity, call shipping to backorder the missing quantity.

Line 1889: print_debug('l_lower_tolerance '|| l_lower_tolerance, 'Inv_Pick_Release_Pub.Pick_Release');

1885: x_fulfillment_base => l_fulfill_base
1886: );
1887: --
1888: If is_debug then
1889: print_debug('l_lower_tolerance '|| l_lower_tolerance, 'Inv_Pick_Release_Pub.Pick_Release');
1890: print_debug('l_lower_tolerance2 '|| l_lower_tolerance2, 'Inv_Pick_Release_Pub.Pick_Release');
1891: print_debug('l_fulfill_base '|| l_fulfill_base, 'Inv_Pick_Release_Pub.Pick_Release');
1892: end if ;
1893: --

Line 1890: print_debug('l_lower_tolerance2 '|| l_lower_tolerance2, 'Inv_Pick_Release_Pub.Pick_Release');

1886: );
1887: --
1888: If is_debug then
1889: print_debug('l_lower_tolerance '|| l_lower_tolerance, 'Inv_Pick_Release_Pub.Pick_Release');
1890: print_debug('l_lower_tolerance2 '|| l_lower_tolerance2, 'Inv_Pick_Release_Pub.Pick_Release');
1891: print_debug('l_fulfill_base '|| l_fulfill_base, 'Inv_Pick_Release_Pub.Pick_Release');
1892: end if ;
1893: --
1894: -- Bug #2748751

Line 1891: print_debug('l_fulfill_base '|| l_fulfill_base, 'Inv_Pick_Release_Pub.Pick_Release');

1887: --
1888: If is_debug then
1889: print_debug('l_lower_tolerance '|| l_lower_tolerance, 'Inv_Pick_Release_Pub.Pick_Release');
1890: print_debug('l_lower_tolerance2 '|| l_lower_tolerance2, 'Inv_Pick_Release_Pub.Pick_Release');
1891: print_debug('l_fulfill_base '|| l_fulfill_base, 'Inv_Pick_Release_Pub.Pick_Release');
1892: end if ;
1893: --
1894: -- Bug #2748751
1895: -- If move order is partially transacted and the allocations are split

Line 1907: print_debug('l_cur_ship_set_id:'||l_cur_ship_set_id,'Inv_Pick_Release_Pub.Pick_Release');

1903: -- For shipsets, if any of the lines fail to allocate completely,
1904: -- rollback all allocations and then back order all of the
1905: -- move order lines for that ship set.
1906: If is_debug then
1907: print_debug('l_cur_ship_set_id:'||l_cur_ship_set_id,'Inv_Pick_Release_Pub.Pick_Release');
1908: print_debug('l_cur_ship_model_id:'||l_cur_ship_model_id ,'Inv_Pick_Release_Pub.Pick_Release');
1909: print_debug('g_pick_release_caller :'||g_pick_release_caller,'Inv_Pick_Release_Pub.Pick_Release');
1910: end if;
1911: IF ( l_cur_ship_set_id IS NOT NULL AND NVL(g_pick_release_caller,'###') <> 'WMS-PICK-EXCEPTION') THEN --9556463

Line 1908: print_debug('l_cur_ship_model_id:'||l_cur_ship_model_id ,'Inv_Pick_Release_Pub.Pick_Release');

1904: -- rollback all allocations and then back order all of the
1905: -- move order lines for that ship set.
1906: If is_debug then
1907: print_debug('l_cur_ship_set_id:'||l_cur_ship_set_id,'Inv_Pick_Release_Pub.Pick_Release');
1908: print_debug('l_cur_ship_model_id:'||l_cur_ship_model_id ,'Inv_Pick_Release_Pub.Pick_Release');
1909: print_debug('g_pick_release_caller :'||g_pick_release_caller,'Inv_Pick_Release_Pub.Pick_Release');
1910: end if;
1911: IF ( l_cur_ship_set_id IS NOT NULL AND NVL(g_pick_release_caller,'###') <> 'WMS-PICK-EXCEPTION') THEN --9556463
1912:

Line 1909: print_debug('g_pick_release_caller :'||g_pick_release_caller,'Inv_Pick_Release_Pub.Pick_Release');

1905: -- move order lines for that ship set.
1906: If is_debug then
1907: print_debug('l_cur_ship_set_id:'||l_cur_ship_set_id,'Inv_Pick_Release_Pub.Pick_Release');
1908: print_debug('l_cur_ship_model_id:'||l_cur_ship_model_id ,'Inv_Pick_Release_Pub.Pick_Release');
1909: print_debug('g_pick_release_caller :'||g_pick_release_caller,'Inv_Pick_Release_Pub.Pick_Release');
1910: end if;
1911: IF ( l_cur_ship_set_id IS NOT NULL AND NVL(g_pick_release_caller,'###') <> 'WMS-PICK-EXCEPTION') THEN --9556463
1912:
1913: -- Bug 2461353, 2411016

Line 1920: 'Inv_Pick_Release_Pub.Pick_Release');

1916:
1917: BEGIN
1918: If is_debug then
1919: print_debug('Update shipping that ship set detailing failed',
1920: 'Inv_Pick_Release_Pub.Pick_Release');
1921: End If;
1922:
1923: l_shipset_smc_backorder_rec.move_order_line_id:=l_mo_line.line_id;
1924: l_shipset_smc_backorder_rec.ship_set_id :=l_cur_ship_set_id;

Line 1939: 'failed ship set','Inv_Pick_Release_Pub.Pick_Release');

1935:
1936: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1937: If is_debug then
1938: print_debug('Error occured while updating shipping for ' ||
1939: 'failed ship set','Inv_Pick_Release_Pub.Pick_Release');
1940: print_debug('l_return_status' || l_api_return_status,
1941: 'Inv_Pick_Release_Pub.Pick_Release');
1942: End If;
1943: END IF;

Line 1941: 'Inv_Pick_Release_Pub.Pick_Release');

1937: If is_debug then
1938: print_debug('Error occured while updating shipping for ' ||
1939: 'failed ship set','Inv_Pick_Release_Pub.Pick_Release');
1940: print_debug('l_return_status' || l_api_return_status,
1941: 'Inv_Pick_Release_Pub.Pick_Release');
1942: End If;
1943: END IF;
1944:
1945: EXCEPTION

Line 1949: 'Inv_Pick_Release_Pub.Pick_Release');

1945: EXCEPTION
1946: WHEN OTHERS THEN
1947: If is_debug then
1948: print_debug('When other exception: ' || Sqlerrm,
1949: 'Inv_Pick_Release_Pub.Pick_Release');
1950: print_debug('l_return_status' || l_api_return_status,
1951: 'Inv_Pick_Release_Pub.Pick_Release');
1952: End If;
1953: NULL;

Line 1951: 'Inv_Pick_Release_Pub.Pick_Release');

1947: If is_debug then
1948: print_debug('When other exception: ' || Sqlerrm,
1949: 'Inv_Pick_Release_Pub.Pick_Release');
1950: print_debug('l_return_status' || l_api_return_status,
1951: 'Inv_Pick_Release_Pub.Pick_Release');
1952: End If;
1953: NULL;
1954: --no need to error out for reporting purpose.
1955: END;

Line 1959: 'Inv_Pick_Release_Pub.Pick_Release');

1955: END;
1956:
1957: If is_debug then
1958: print_debug('Rollback for shipset :' || l_cur_ship_set_id,
1959: 'Inv_Pick_Release_Pub.Pick_Release');
1960: End If;
1961:
1962: ROLLBACK to SHIPSET;
1963: l_set_index := l_start_index;

Line 1989: 'Inv_Pick_Release_Pub.Pick_Release');

1985: IF l_qtree_backup_tbl.EXISTS(l_tree_id) THEN
1986:
1987: If is_debug then
1988: print_debug('Restoring Quantity Tree: ' || l_tree_id,
1989: 'Inv_Pick_Release_Pub.Pick_Release');
1990: End If;
1991:
1992: inv_quantity_tree_pvt.restore_tree
1993: (x_return_status => l_api_return_status

Line 2001: 'Inv_Pick_Release_Pub.Pick_Release');

1997:
1998: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
1999: If is_debug then
2000: print_debug('Error in Restore_Tree',
2001: 'Inv_Pick_Release_Pub.Pick_Release');
2002: End If;
2003: raise FND_API.G_EXC_ERROR;
2004: elsif l_api_return_status=FND_API.G_RET_STS_UNEXP_ERROR then
2005: If is_debug then

Line 2007: 'Inv_Pick_Release_Pub.Pick_Release');

2003: raise FND_API.G_EXC_ERROR;
2004: elsif l_api_return_status=FND_API.G_RET_STS_UNEXP_ERROR then
2005: If is_debug then
2006: print_debug('Unexpected error in Restore_tree',
2007: 'Inv_Pick_Release_Pub.Pick_Release');
2008: End If;
2009: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2010: end if;
2011:

Line 2019: 'Inv_Pick_Release_Pub.Pick_Release');

2015: END IF;
2016:
2017: If is_debug then
2018: print_debug('Backorder mo line:' || l_mo_line.line_id,
2019: 'Inv_Pick_Release_Pub.Pick_Release');
2020: End If;
2021:
2022: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
2023: If NOT l_return_value Then

Line 2026: 'INV_Pick_Release_Pub.Pick_Release');

2022: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
2023: If NOT l_return_value Then
2024: If is_debug then
2025: print_debug('Error setting cache for delivery line',
2026: 'INV_Pick_Release_Pub.Pick_Release');
2027: End If;
2028: RAISE fnd_api.g_exc_unexpected_error;
2029: End If;
2030: l_delivery_detail_id := INV_CACHE.wdd_rec.delivery_detail_id;

Line 2058: 'Inv_Pick_Release_Pub.Pick_Release');

2054: );
2055: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
2056: If is_debug then
2057: print_debug('return error from update shipping attributes',
2058: 'Inv_Pick_Release_Pub.Pick_Release');
2059: End If;
2060: raise FND_API.G_EXC_ERROR;
2061: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2062: If is_debug then

Line 2064: 'Inv_Pick_Release_Pub.Pick_Release');

2060: raise FND_API.G_EXC_ERROR;
2061: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2062: If is_debug then
2063: print_debug('return error from update shipping attributes',
2064: 'Inv_Pick_Release_Pub.Pick_Release');
2065: End If;
2066: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2067: end if;
2068:

Line 2127: 'Inv_Pick_Release_Pub.Pick_Release');

2123: l_detail_rec_count := 0;
2124: l_qtree_backup_tbl.DELETE;
2125: If is_debug then
2126: print_debug('Finished backordering all lines in shipset',
2127: 'Inv_Pick_Release_Pub.Pick_Release');
2128: End If;
2129:
2130: --For Ship Models, if a move order line does not fully
2131: -- allocate, we have to determine the new model quantity. Then,

Line 2143: 'Inv_Pick_Release_Pub.Pick_Release');

2139: --able to allocate completely
2140: BEGIN
2141: If is_debug then
2142: print_debug('Update shipping that ship model detailing partial',
2143: 'Inv_Pick_Release_Pub.Pick_Release');
2144: End If;
2145:
2146: l_shipset_smc_backorder_rec.move_order_line_id:=l_mo_line.line_id;
2147: l_shipset_smc_backorder_rec.ship_model_id :=l_cur_ship_model_id;

Line 2162: 'Inv_Pick_Release_Pub.Pick_Release');

2158: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2159: If is_debug then
2160: print_debug('Error occured while updating shipping for ' ||
2161: 'failed ship set',
2162: 'Inv_Pick_Release_Pub.Pick_Release');
2163: print_debug('l_return_status'||l_api_return_status,
2164: 'Inv_Pick_Release_Pub.Pick_Release');
2165: End If;
2166: END IF;

Line 2164: 'Inv_Pick_Release_Pub.Pick_Release');

2160: print_debug('Error occured while updating shipping for ' ||
2161: 'failed ship set',
2162: 'Inv_Pick_Release_Pub.Pick_Release');
2163: print_debug('l_return_status'||l_api_return_status,
2164: 'Inv_Pick_Release_Pub.Pick_Release');
2165: End If;
2166: END IF;
2167: EXCEPTION
2168: WHEN OTHERS THEN

Line 2171: 'Inv_Pick_Release_Pub.Pick_Release');

2167: EXCEPTION
2168: WHEN OTHERS THEN
2169: If is_debug then
2170: print_debug('When other exception',
2171: 'Inv_Pick_Release_Pub.Pick_Release');
2172: End If;
2173: NULL;
2174: --no need to error out for reporting purpose.
2175: END;

Line 2179: 'Inv_Pick_Release_Pub.Pick_Release');

2175: END;
2176:
2177: If is_debug then
2178: print_debug('Rolling back for ship model :' ||l_cur_ship_model_id,
2179: 'Inv_Pick_Release_Pub.Pick_Release');
2180: End If;
2181:
2182: ROLLBACK to SHIPMODEL;
2183: l_set_index := l_start_index;

Line 2188: 'Inv_Pick_Release_Pub.Pick_Release');

2184: l_set_process := l_start_process;
2185:
2186: If is_debug then
2187: print_debug('OE Line: ' || l_cur_txn_source_line_id,
2188: 'Inv_Pick_Release_Pub.Pick_Release');
2189: End If;
2190:
2191: -- Get the sales order line quantity. We need the order
2192: -- line quantity to determine the new model quantity. We

Line 2204: 'Inv_Pick_Release_Pub.Pick_Release');

2200: EXCEPTION
2201: WHEN NO_DATA_FOUND then
2202: If is_debug then
2203: print_debug('No Order Line Quantity found',
2204: 'Inv_Pick_Release_Pub.Pick_Release');
2205: End If;
2206: ROLLBACK TO Pick_Release_PUB;
2207: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2208: FND_MSG_PUB.Add;

Line 2242: 'Inv_Pick_Release_Pub.Pick_Release');

2238: --We keep model quantity and quantity in PUOM so should not
2239: --find it from order lines.
2240: If is_debug then
2241: print_debug('New model qty ' || l_new_model_quantity,
2242: 'Inv_Pick_Release_Pub.Pick_Release');
2243: End If;
2244:
2245: --loop through all move order lines for this ship model
2246: LOOP

Line 2250: 'Inv_Pick_Release_Pub.Pick_Release');

2246: LOOP
2247: l_mo_line := l_mo_line_tbl(l_set_index);
2248: If is_debug then
2249: print_debug('SHIPMODEL-Current mo line:'||l_mo_line.line_id,
2250: 'Inv_Pick_Release_Pub.Pick_Release');
2251: End If;
2252:
2253: --find tree id. If item is unit effective, get tree id from
2254: -- qtree_line_tbl. Else, get it from qtree_item_tbl.

Line 2272: 'Inv_Pick_Release_Pub.Pick_Release');

2268: IF l_qtree_backup_tbl.EXISTS(l_tree_id) THEN
2269:
2270: If is_debug then
2271: print_debug('Restoring Quantity Tree: ' || l_tree_id,
2272: 'Inv_Pick_Release_Pub.Pick_Release');
2273: End If;
2274: inv_quantity_tree_pvt.restore_tree
2275: (x_return_status => l_api_return_status
2276: ,p_tree_id => l_tree_id

Line 2282: 'Inv_Pick_Release_Pub.Pick_Release');

2278: );
2279: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
2280: If is_debug then
2281: print_debug('Error in Restore_Tree',
2282: 'Inv_Pick_Release_Pub.Pick_Release');
2283: End If;
2284: raise FND_API.G_EXC_ERROR;
2285: elsif l_api_return_status=FND_API.G_RET_STS_UNEXP_ERROR then
2286: If is_debug then

Line 2288: 'Inv_Pick_Release_Pub.Pick_Release');

2284: raise FND_API.G_EXC_ERROR;
2285: elsif l_api_return_status=FND_API.G_RET_STS_UNEXP_ERROR then
2286: If is_debug then
2287: print_debug('Unexpected error in Restore_tree',
2288: 'Inv_Pick_Release_Pub.Pick_Release');
2289: End If;
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2291: end if;
2292:

Line 2307: 'Inv_Pick_Release_Pub.Pick_Release');

2303: THEN
2304: l_set_txn_source_line_id := l_mo_line.txn_source_line_id;
2305: If is_debug then
2306: print_debug('OE Line: ' || l_set_txn_source_line_id,
2307: 'Inv_Pick_Release_Pub.Pick_Release');
2308: End If;
2309:
2310: -- if we already got the qty, don't get it again
2311: IF l_set_txn_source_line_id = l_cur_txn_source_line_id Then

Line 2325: 'Inv_Pick_Release_Pub.Pick_Release');

2321: EXCEPTION
2322: WHEN NO_DATA_FOUND then
2323: If is_debug then
2324: print_debug('No Order Line Quantity found',
2325: 'Inv_Pick_Release_Pub.Pick_Release');
2326: End If;
2327: ROLLBACK TO Pick_Release_PUB;
2328: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2329: FND_MSG_PUB.Add;

Line 2361: 'Inv_Pick_Release_Pub.Pick_Release');

2357: l_mo_line.model_quantity;
2358:
2359: If is_debug then
2360: print_debug('New req qty: ' || l_set_new_req_qty,
2361: 'Inv_Pick_Release_Pub.Pick_Release');
2362: End If;
2363: END IF;
2364:
2365: -- set new move order line quantity

Line 2375: 'Inv_Pick_Release_Pub.Pick_Release');

2371: l_new_line_quantity := l_set_new_req_qty;
2372:
2373: If is_debug then
2374: print_debug('New line qty: ' || l_new_line_quantity,
2375: 'Inv_Pick_Release_Pub.Pick_Release');
2376: End If;
2377:
2378: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
2379: If NOT l_return_value Then

Line 2382: 'INV_Pick_Release_Pub.Pick_Release');

2378: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
2379: If NOT l_return_value Then
2380: If is_debug then
2381: print_debug('Error setting cache for delivery line',
2382: 'INV_Pick_Release_Pub.Pick_Release');
2383: End If;
2384: RAISE fnd_api.g_exc_unexpected_error;
2385: End If;
2386: l_delivery_detail_id := INV_CACHE.wdd_rec.delivery_detail_id;

Line 2415: 'Inv_Pick_Release_Pub.Pick_Release');

2411: back_order_det_tbl =>l_smc_backorder_det_tbl);
2412: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
2413: If is_debug then
2414: print_debug(' return error E from Store_smc_bo_details',
2415: 'Inv_Pick_Release_Pub.Pick_Release');
2416: End If;
2417: l_smc_backorder_det_tbl.DELETE;
2418: raise FND_API.G_EXC_ERROR;
2419: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 2422: 'Inv_Pick_Release_Pub.Pick_Release');

2418: raise FND_API.G_EXC_ERROR;
2419: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2420: If is_debug then
2421: print_debug(' return error U from Store_smc_bo_details',
2422: 'Inv_Pick_Release_Pub.Pick_Release');
2423: End If;
2424: l_smc_backorder_det_tbl.DELETE;
2425: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2426: end if;

Line 2469: 'Inv_Pick_Release_Pub.Pick_Release');

2465: --l_mo_line_tbl(l_set_index).model_quantity := l_new_model_quantity;
2466:
2467: If is_debug then
2468: print_debug('Finished Updating Mo Line',
2469: 'Inv_Pick_Release_Pub.Pick_Release');
2470: End If;
2471:
2472: -- Exit if there are no more move order lines to detail
2473: -- or when the next move order is not for the same ship model.

Line 2534: 'Inv_Pick_Release_Pub.Pick_Release');

2530: l_detail_rec_count := 0;
2531:
2532: If is_debug then
2533: print_debug('Backordered all lines with this Ship Model Id',
2534: 'Inv_Pick_Release_Pub.Pick_Release');
2535: End If;
2536: Backorder_SMC_DETAILS(l_api_return_status ,
2537: x_msg_data ,
2538: x_msg_count

Line 2543: 'Inv_Pick_Release_Pub.Pick_Release');

2539: );
2540: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
2541: If is_debug then
2542: print_debug('return error E from Backorder_SMC_DETAILS',
2543: 'Inv_Pick_Release_Pub.Pick_Release');
2544: End If;
2545: raise FND_API.G_EXC_ERROR;
2546: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2547: If is_debug then

Line 2549: 'Inv_Pick_Release_Pub.Pick_Release');

2545: raise FND_API.G_EXC_ERROR;
2546: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2547: If is_debug then
2548: print_debug('return error U from Backorder_SMC_DETAILS',
2549: 'Inv_Pick_Release_Pub.Pick_Release');
2550: End If;
2551: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2552: end if;
2553:

Line 2596: 'INV_Pick_Release_Pub.Pick_Release');

2592: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
2593: IF (NOT l_return_value) THEN
2594: IF (is_debug) THEN
2595: print_debug('Error setting cache for delivery line',
2596: 'INV_Pick_Release_Pub.Pick_Release');
2597: END IF;
2598: RAISE fnd_api.g_exc_unexpected_error;
2599: END IF;
2600: l_delivery_detail_id := INV_CACHE.wdd_rec.delivery_detail_id;

Line 2635: 'INV_Pick_Release_Pub.Pick_Release');

2631: -- R12.1 replenishment Project 6681109/6710368
2632: -- changes based ON p_dynamic_replenishment
2633: IF (is_debug) THEN
2634: print_debug('p_dynamic_replenishment :'||p_dynamic_replenishment,
2635: 'INV_Pick_Release_Pub.Pick_Release');
2636: END IF;
2637:
2638:
2639: l_detail_info_tab(1).delivery_detail_id := l_delivery_detail_id;

Line 2646: print_debug('Mark WDD repl_status as RR','INV_Pick_Release_Pub.Pick_Release');

2642:
2643: IF NVL(p_dynamic_replenishment,'N') = 'Y' THEN
2644:
2645: IF (is_debug) THEN
2646: print_debug('Mark WDD repl_status as RR','INV_Pick_Release_Pub.Pick_Release');
2647: END IF;
2648: --if qty is available somewhere in the org, we will try to replenish it first
2649: -- mark the demand lines for replenishment requested status
2650: l_detail_info_tab(1).replenishment_status := 'R';

Line 2683: 'Inv_Pick_Release_Pub.Pick_Release');

2679:
2680: IF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
2681: IF (is_debug) THEN
2682: print_debug('Error returned from Create_Update_Delivery_Detail API',
2683: 'Inv_Pick_Release_Pub.Pick_Release');
2684: END IF;
2685: RAISE FND_API.G_EXC_ERROR;
2686: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2687: IF (is_debug) THEN

Line 2689: 'Inv_Pick_Release_Pub.Pick_Release');

2685: RAISE FND_API.G_EXC_ERROR;
2686: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2687: IF (is_debug) THEN
2688: print_debug('Unexpected errror from Create_Update_Delivery_Detail API',
2689: 'Inv_Pick_Release_Pub.Pick_Release');
2690: END IF;
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: END IF;
2693:

Line 2723: 'Inv_Pick_Release_Pub.Pick_Release');

2719:
2720: IF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
2721: IF (is_debug) THEN
2722: print_debug('Error returned from Split Delivery_Detail_Action API',
2723: 'Inv_Pick_Release_Pub.Pick_Release');
2724: END IF;
2725: RAISE FND_API.G_EXC_ERROR;
2726: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2727: IF (is_debug) THEN

Line 2729: 'Inv_Pick_Release_Pub.Pick_Release');

2725: RAISE FND_API.G_EXC_ERROR;
2726: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2727: IF (is_debug) THEN
2728: print_debug('Unexpected errror from Split Delivery_Detail_Action API',
2729: 'Inv_Pick_Release_Pub.Pick_Release');
2730: END IF;
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: END IF;
2733:

Line 2752: print_debug(' Mark repl_status of WDD as RR','INV_Pick_Release_Pub.Pick_Release');

2748:
2749:
2750: IF NVL(p_dynamic_replenishment,'N') = 'Y' THEN
2751: IF (is_debug) THEN
2752: print_debug(' Mark repl_status of WDD as RR','INV_Pick_Release_Pub.Pick_Release');
2753: END IF;
2754: -- mark the new split demand lines for replenishment requested status
2755: l_detail_info_tab(1).replenishment_status := 'R';
2756: l_in_rec.caller := 'WMS_REP';

Line 2780: 'Inv_Pick_Release_Pub.Pick_Release');

2776:
2777: IF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
2778: IF (is_debug) THEN
2779: print_debug('Error returned from Create_Update_Delivery_Detail API',
2780: 'Inv_Pick_Release_Pub.Pick_Release');
2781: END IF;
2782: RAISE FND_API.G_EXC_ERROR;
2783: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2784: IF (is_debug) THEN

Line 2786: 'Inv_Pick_Release_Pub.Pick_Release');

2782: RAISE FND_API.G_EXC_ERROR;
2783: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2784: IF (is_debug) THEN
2785: print_debug('Unexpected errror from Create_Update_Delivery_Detail API',
2786: 'Inv_Pick_Release_Pub.Pick_Release');
2787: END IF;
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790:

Line 2851: print_debug('The value of l_reservation_exists is - ' ||l_reservation_exists,'Inv_Pick_Release_Pub.Pick_Release');

2847: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed
2848: and (nvl(mr.staged_flag,'N') = 'N' and nvl(mr.detailed_quantity,0) = 0);
2849:
2850: IF is_debug THEN
2851: print_debug('The value of l_reservation_exists is - ' ||l_reservation_exists,'Inv_Pick_Release_Pub.Pick_Release');
2852: END IF;
2853:
2854: --Note: Inside the API Update_Shipping_Attributes, wdd is split and qty are backordered
2855: --in case action_flag is 'B'. Backorder qty is passed

Line 2864: 'Inv_Pick_Release_Pub.Pick_Release');

2860:
2861: IF (l_reservation_exists = 0 and NVL(p_dynamic_replenishment,'N') = 'Y') THEN --BUG13604664
2862: IF is_debug THEN
2863: print_debug('Marking line status as RR',
2864: 'Inv_Pick_Release_Pub.Pick_Release');
2865: END IF;
2866: l_shipping_attr(1).action_flag := 'R';
2867: ELSE
2868: l_shipping_attr(1).action_flag := 'B';

Line 2905: 'Inv_Pick_Release_Pub.Pick_Release');

2901: );
2902: IF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
2903: IF is_debug THEN
2904: print_debug('return error from update shipping attributes',
2905: 'Inv_Pick_Release_Pub.Pick_Release');
2906: END IF;
2907: RAISE FND_API.G_EXC_ERROR;
2908: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2909: IF is_debug THEN

Line 2911: 'Inv_Pick_Release_Pub.Pick_Release');

2907: RAISE FND_API.G_EXC_ERROR;
2908: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2909: IF is_debug THEN
2910: print_debug('return error from update shipping attributes',
2911: 'Inv_Pick_Release_Pub.Pick_Release');
2912: END IF;
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2914: END IF;
2915: END IF; -- for IF (l_allocation_method = g_prioritize_inventory) AND (p_wsh...

Line 2974: 'INV_Pick_Release_Pub.Pick_Release');

2970: -- Retrieve the WDD record associated with the current MOL
2971: IF (NOT INV_CACHE.set_wdd_rec(l_mo_line.line_id)) THEN
2972: IF (is_debug) THEN
2973: print_debug('Error setting cache for WDD delivery line',
2974: 'INV_Pick_Release_Pub.Pick_Release');
2975: END IF;
2976: RAISE fnd_api.g_exc_unexpected_error;
2977: END IF;
2978: l_delivery_detail_id := INV_CACHE.wdd_rec.delivery_detail_id;

Line 3013: 'Inv_Pick_Release_Pub.Pick_Release');

3009: x_pick_release_status(l_processed_row_count).detail_rec_count,
3010: 'Pick_Release_Pub');
3011: print_Debug('detail record count is ' ||
3012: x_pick_release_status(l_processed_row_count).detail_rec_count,
3013: 'Inv_Pick_Release_Pub.Pick_Release');
3014: End If;
3015: END IF;
3016: l_detail_rec_count := 0;
3017: --Update the Pick Release API's return status to an error if the line could

Line 3040: 'Inv_Pick_Release_Pub.Pick_Release');

3036: END LOOP;
3037:
3038: IF is_debug then
3039: print_debug('after calling inv_pick_release_pvt',
3040: 'Inv_Pick_Release_Pub.Pick_Release');
3041: END IF;
3042:
3043: -- To ensure that lock_flag should not get updated to Y unnecessarily i.e., only change needed only when high volume related code executes
3044: -- WMS installed should be true

Line 3051: print_debug('Updating lock_flag of MMTT records','Inv_Pick_Release_Pub.Pick_Release');

3047: -- Value of p_skip_cartonization passed as TRUE only when parallel pick release happens
3048: IF l_wms_installed AND p_auto_pick_confirm = 2 AND l_do_cartonization = 1 AND p_skip_cartonization = TRUE THEN
3049: BEGIN
3050: IF is_debug THEN
3051: print_debug('Updating lock_flag of MMTT records','Inv_Pick_Release_Pub.Pick_Release');
3052: END IF;
3053: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
3054: update mtl_material_transactions_temp
3055: set lock_flag = 'Y'

Line 3061: ,'Inv_Pick_Release_Pub.Pick_Release');

3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: IF is_debug THEN
3060: print_debug('Error in updating MMTT records lock_flag: ' || sqlerrm
3061: ,'Inv_Pick_Release_Pub.Pick_Release');
3062: END IF;
3063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3064: END;
3065: END IF;

Line 3070: print_debug('Deleting MOLs in status 5','Inv_Pick_Release_Pub.Pick_Release');

3066:
3067: -- Bug 4349602: Deleting Move Order Lines which are not allocated
3068: BEGIN
3069: IF is_debug THEN
3070: print_debug('Deleting MOLs in status 5','Inv_Pick_Release_Pub.Pick_Release');
3071: END IF;
3072: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
3073: DELETE FROM mtl_txn_request_lines mtrl
3074: WHERE line_status = 5

Line 3087: ,'Inv_Pick_Release_Pub.Pick_Release');

3083: EXCEPTION
3084: WHEN OTHERS THEN
3085: IF is_debug THEN
3086: print_debug('Error in Deleting Move Order Lines: ' || sqlerrm
3087: ,'Inv_Pick_Release_Pub.Pick_Release');
3088: END IF;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3090: END;
3091:

Line 3098: 'Inv_Pick_Release_pub.Pick_Release');

3094: l_line_index := l_mo_line_tbl.FIRST;
3095: l_api_return_status := '';
3096: IF is_debug THEN
3097: print_Debug('l_mo_line_tbl.count is ' || l_mo_line_tbl.COUNT,
3098: 'Inv_Pick_Release_pub.Pick_Release');
3099: END IF;
3100: -- Calling device integration api to set global var which will decide
3101: -- whether to process device request or not, if it is a WMS organization.
3102: IF wms_device_integration_pvt.wms_call_device_request IS NULL THEN

Line 3118: 'Inv_Pick_Release_Pub.Pick_Release');

3114: LOOP
3115: If is_debug then
3116: print_debug('headeR_id for line index ' || l_line_index || ' is ' ||
3117: l_mo_line_tbl(l_line_index).header_id,
3118: 'Inv_Pick_Release_Pub.Pick_Release');
3119: End If;
3120:
3121: IF l_line_index >= l_mo_line_tbl.COUNT THEN
3122: -- it's the last line in this group

Line 3125: 'Inv_Pick_Release_Pub.Pick_Release');

3121: IF l_line_index >= l_mo_line_tbl.COUNT THEN
3122: -- it's the last line in this group
3123: If is_debug then
3124: print_debug('calling cartonize api',
3125: 'Inv_Pick_Release_Pub.Pick_Release');
3126: End If;
3127:
3128: WMS_CARTNZN_PUB.cartonize
3129: (

Line 3146: 'Inv_Pick_Release_Pub.Pick_Release');

3142: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3143: l_api_return_status = fnd_api.g_ret_sts_error THEN
3144: If is_debug then
3145: print_debug('error from cartonize api',
3146: 'Inv_Pick_Release_Pub.Pick_Release');
3147: print_debug('error count ' || x_msg_count,
3148: 'Inv_Pick_Release_Pub.Pick_Release');
3149: print_debug('error msg ' || x_msg_data,
3150: 'Inv_Pick_Release_Pub.Pick_Release');

Line 3148: 'Inv_Pick_Release_Pub.Pick_Release');

3144: If is_debug then
3145: print_debug('error from cartonize api',
3146: 'Inv_Pick_Release_Pub.Pick_Release');
3147: print_debug('error count ' || x_msg_count,
3148: 'Inv_Pick_Release_Pub.Pick_Release');
3149: print_debug('error msg ' || x_msg_data,
3150: 'Inv_Pick_Release_Pub.Pick_Release');
3151: x_return_status := fnd_api.g_ret_sts_error;
3152: End If;

Line 3150: 'Inv_Pick_Release_Pub.Pick_Release');

3146: 'Inv_Pick_Release_Pub.Pick_Release');
3147: print_debug('error count ' || x_msg_count,
3148: 'Inv_Pick_Release_Pub.Pick_Release');
3149: print_debug('error msg ' || x_msg_data,
3150: 'Inv_Pick_Release_Pub.Pick_Release');
3151: x_return_status := fnd_api.g_ret_sts_error;
3152: End If;
3153: ELSE -- patchset J bulk picking
3154: IF (WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN

Line 3157: 'Inv_Pick_Release_Pub.Pick_Release');

3153: ELSE -- patchset J bulk picking
3154: IF (WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN
3155: IF (is_debug) THEN
3156: print_debug('PATCHSET J -- BULK PICKING --- START',
3157: 'Inv_Pick_Release_Pub.Pick_Release');
3158: END IF;
3159: assign_pick_slip_number
3160: (x_return_status => l_api_return_status,
3161: x_msg_count => x_msg_count,

Line 3171: 'Inv_Pick_Release_Pub.Pick_Release');

3167:
3168: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3169: l_api_return_status = fnd_api.g_ret_sts_error THEN
3170: print_debug('error from assign_pick_slip_number api',
3171: 'Inv_Pick_Release_Pub.Pick_Release');
3172: print_debug('error count ' || x_msg_count,
3173: 'Inv_Pick_Release_Pub.Pick_Release');
3174: print_debug('error msg ' || x_msg_data,
3175: 'Inv_Pick_Release_Pub.Pick_Release');

Line 3173: 'Inv_Pick_Release_Pub.Pick_Release');

3169: l_api_return_status = fnd_api.g_ret_sts_error THEN
3170: print_debug('error from assign_pick_slip_number api',
3171: 'Inv_Pick_Release_Pub.Pick_Release');
3172: print_debug('error count ' || x_msg_count,
3173: 'Inv_Pick_Release_Pub.Pick_Release');
3174: print_debug('error msg ' || x_msg_data,
3175: 'Inv_Pick_Release_Pub.Pick_Release');
3176: x_return_status := fnd_api.g_ret_sts_error;
3177: END IF;

Line 3175: 'Inv_Pick_Release_Pub.Pick_Release');

3171: 'Inv_Pick_Release_Pub.Pick_Release');
3172: print_debug('error count ' || x_msg_count,
3173: 'Inv_Pick_Release_Pub.Pick_Release');
3174: print_debug('error msg ' || x_msg_data,
3175: 'Inv_Pick_Release_Pub.Pick_Release');
3176: x_return_status := fnd_api.g_ret_sts_error;
3177: END IF;
3178: IF (is_debug) THEN
3179: print_debug('PATCHSET J -- BULK PICKING --- END',

Line 3180: 'Inv_Pick_Release_Pub.Pick_Release');

3176: x_return_status := fnd_api.g_ret_sts_error;
3177: END IF;
3178: IF (is_debug) THEN
3179: print_debug('PATCHSET J -- BULK PICKING --- END',
3180: 'Inv_Pick_Release_Pub.Pick_Release');
3181: END IF;
3182: END IF;
3183: END IF;
3184: EXIT;

Line 3193: 'Inv_Pick_Release_Pub.Pick_Release');

3189: ELSE
3190: -- call cartonize API
3191: If is_debug then
3192: print_debug('calling cartonize api',
3193: 'Inv_Pick_Release_Pub.Pick_Release');
3194: End If;
3195:
3196: WMS_CARTNZN_PUB.cartonize
3197: (

Line 3214: 'Inv_Pick_Release_Pub.Pick_Release');

3210: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3211: l_api_return_status = fnd_api.g_ret_sts_error THEN
3212: If is_debug then
3213: print_debug('error from cartonize api',
3214: 'Inv_Pick_Release_Pub.Pick_Release');
3215: print_debug('error count ' || x_msg_count,
3216: 'Inv_Pick_Release_Pub.Pick_Release');
3217: print_debug('error msg ' || x_msg_data,
3218: 'Inv_Pick_Release_Pub.Pick_Release');

Line 3216: 'Inv_Pick_Release_Pub.Pick_Release');

3212: If is_debug then
3213: print_debug('error from cartonize api',
3214: 'Inv_Pick_Release_Pub.Pick_Release');
3215: print_debug('error count ' || x_msg_count,
3216: 'Inv_Pick_Release_Pub.Pick_Release');
3217: print_debug('error msg ' || x_msg_data,
3218: 'Inv_Pick_Release_Pub.Pick_Release');
3219: End If;
3220: x_return_status := fnd_api.g_ret_sts_error;

Line 3218: 'Inv_Pick_Release_Pub.Pick_Release');

3214: 'Inv_Pick_Release_Pub.Pick_Release');
3215: print_debug('error count ' || x_msg_count,
3216: 'Inv_Pick_Release_Pub.Pick_Release');
3217: print_debug('error msg ' || x_msg_data,
3218: 'Inv_Pick_Release_Pub.Pick_Release');
3219: End If;
3220: x_return_status := fnd_api.g_ret_sts_error;
3221: ELSE -- patchset J bulk picking
3222: IF (WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN

Line 3225: 'Inv_Pick_Release_Pub.Pick_Release');

3221: ELSE -- patchset J bulk picking
3222: IF (WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN
3223: IF (is_debug) THEN
3224: print_debug('PATCHSET J -- BULK PICKING --- START',
3225: 'Inv_Pick_Release_Pub.Pick_Release');
3226: print_debug('calling assign_pick_slip_number',
3227: 'Inv_Pick_Release_Pub.Pick_Release');
3228: END IF;
3229:

Line 3227: 'Inv_Pick_Release_Pub.Pick_Release');

3223: IF (is_debug) THEN
3224: print_debug('PATCHSET J -- BULK PICKING --- START',
3225: 'Inv_Pick_Release_Pub.Pick_Release');
3226: print_debug('calling assign_pick_slip_number',
3227: 'Inv_Pick_Release_Pub.Pick_Release');
3228: END IF;
3229:
3230: assign_pick_slip_number
3231: (x_return_status => l_api_return_status,

Line 3242: 'Inv_Pick_Release_Pub.Pick_Release');

3238:
3239: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3240: l_api_return_status = fnd_api.g_ret_sts_error THEN
3241: print_debug('error from assign_pick_slip_number api',
3242: 'Inv_Pick_Release_Pub.Pick_Release');
3243: print_debug('error count ' || x_msg_count,
3244: 'Inv_Pick_Release_Pub.Pick_Release');
3245: print_debug('error msg ' || x_msg_data,
3246: 'Inv_Pick_Release_Pub.Pick_Release');

Line 3244: 'Inv_Pick_Release_Pub.Pick_Release');

3240: l_api_return_status = fnd_api.g_ret_sts_error THEN
3241: print_debug('error from assign_pick_slip_number api',
3242: 'Inv_Pick_Release_Pub.Pick_Release');
3243: print_debug('error count ' || x_msg_count,
3244: 'Inv_Pick_Release_Pub.Pick_Release');
3245: print_debug('error msg ' || x_msg_data,
3246: 'Inv_Pick_Release_Pub.Pick_Release');
3247: x_return_status := fnd_api.g_ret_sts_error;
3248: END IF;

Line 3246: 'Inv_Pick_Release_Pub.Pick_Release');

3242: 'Inv_Pick_Release_Pub.Pick_Release');
3243: print_debug('error count ' || x_msg_count,
3244: 'Inv_Pick_Release_Pub.Pick_Release');
3245: print_debug('error msg ' || x_msg_data,
3246: 'Inv_Pick_Release_Pub.Pick_Release');
3247: x_return_status := fnd_api.g_ret_sts_error;
3248: END IF;
3249: IF (is_debug) THEN
3250: print_debug('PATCHSET J -- BULK PICKING --- END',

Line 3251: 'Inv_Pick_Release_Pub.Pick_Release');

3247: x_return_status := fnd_api.g_ret_sts_error;
3248: END IF;
3249: IF (is_debug) THEN
3250: print_debug('PATCHSET J -- BULK PICKING --- END',
3251: 'Inv_Pick_Release_Pub.Pick_Release');
3252: END IF;
3253: END IF;
3254: END IF;
3255:

Line 3258: 'Inv_Pick_Release_Pub.Pick_Release');

3254: END IF;
3255:
3256: IF is_debug THEN
3257: print_debug('success from cartonize api',
3258: 'Inv_Pick_Release_Pub.Pick_Release');
3259: END IF;
3260: l_line_index := l_line_index + 1;
3261: END IF;
3262: EXIT WHEN l_line_index > l_mo_line_tbl.LAST;

Line 3282: print_debug('Move header id: ' || l_mo_line_tbl(l_mo_line_tbl.FIRST).header_id, 'Inv_Pick_Release_Pub.Pick_Release');

3278: BEGIN
3279: -- bug 9130704
3280:
3281: IF (l_debug = 1) THEN
3282: print_debug('Move header id: ' || l_mo_line_tbl(l_mo_line_tbl.FIRST).header_id, 'Inv_Pick_Release_Pub.Pick_Release');
3283: END IF;
3284:
3285: OPEN c_wpr_casepick_labels(l_mo_line_tbl(l_mo_line_tbl.FIRST).header_id);
3286:

Line 3294: print_debug('Calling print_label with v_transaction_id.count : ' || v_transaction_id.COUNT, 'Inv_Pick_Release_Pub.Pick_Release');

3290:
3291: EXIT WHEN v_transaction_id.COUNT = 0;
3292:
3293: IF (l_debug = 1) THEN
3294: print_debug('Calling print_label with v_transaction_id.count : ' || v_transaction_id.COUNT, 'Inv_Pick_Release_Pub.Pick_Release');
3295: END IF;
3296:
3297: l_return_status := fnd_api.g_ret_sts_success;
3298:

Line 3311: print_debug('failed to print labels', 'Inv_Pick_Release_Pub.Pick_Release');

3307: , p_transaction_id => v_transaction_id);
3308:
3309: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
3310: IF (l_debug = 1) THEN
3311: print_debug('failed to print labels', 'Inv_Pick_Release_Pub.Pick_Release');
3312: END IF;
3313: fnd_message.set_name('WMS','WMS_PRINT_LABEL_FAIL');
3314: fnd_msg_pub.ADD;
3315: END IF;

Line 3327: print_debug('Exception occured while calling print_label', 'Inv_Pick_Release_Pub.Pick_Release');

3323:
3324: EXCEPTION
3325: WHEN OTHERS THEN
3326: IF (l_debug = 1) THEN
3327: print_debug('Exception occured while calling print_label', 'Inv_Pick_Release_Pub.Pick_Release');
3328: END IF;
3329: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3330: fnd_msg_pub.ADD;
3331:

Line 3412: l_allocation_method, 'Inv_Pick_Release_Pub.Pick_Release');

3408: /*IF (l_allocation_method IN (g_inventory_only, g_prioritize_crossdock) AND
3409: p_del_detail_id.COUNT > 0) THEN
3410: IF (is_debug) THEN
3411: print_debug('Remove the backordered WDD lines from the inputted delivery tables: ' ||
3412: l_allocation_method, 'Inv_Pick_Release_Pub.Pick_Release');
3413: END IF;
3414: l_xdock_index := p_del_detail_id.FIRST;
3415: l_xdock_next_index := p_del_detail_id.FIRST;
3416: -- Loop through table p_del_detail_id. If that WDD is backordered (value exists in

Line 3438: 'Inv_Pick_Release_Pub.Pick_Release');

3434: -- Crossdock Pegging API here since inventory allocation has been completed
3435: IF (l_allocation_method = g_prioritize_inventory) THEN
3436: IF (is_debug) THEN
3437: print_debug('Call the Planned_Cross_Dock API (Prioritize Inventory)',
3438: 'Inv_Pick_Release_Pub.Pick_Release');
3439: END IF;
3440: WMS_XDOCK_PEGGING_PUB.Planned_Cross_Dock
3441: (p_api_version => 1.0,
3442: p_init_msg_list => fnd_api.g_false,

Line 3455: 'Inv_Pick_Release_Pub.Pick_Release');

3451:
3452: IF (l_api_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3453: IF (is_debug) THEN
3454: print_debug('Success returned from Planned_Cross_Dock API',
3455: 'Inv_Pick_Release_Pub.Pick_Release');
3456: END IF;
3457: ELSIF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
3458: IF (is_debug) THEN
3459: print_debug('Error returned from Planned_Cross_Dock API',

Line 3460: 'Inv_Pick_Release_Pub.Pick_Release');

3456: END IF;
3457: ELSIF (l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
3458: IF (is_debug) THEN
3459: print_debug('Error returned from Planned_Cross_Dock API',
3460: 'Inv_Pick_Release_Pub.Pick_Release');
3461: END IF;
3462: RAISE FND_API.G_EXC_ERROR;
3463: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3464: IF (is_debug) THEN

Line 3466: 'Inv_Pick_Release_Pub.Pick_Release');

3462: RAISE FND_API.G_EXC_ERROR;
3463: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3464: IF (is_debug) THEN
3465: print_debug('Unexpected error returned from Planned_Cross_Dock API',
3466: 'Inv_Pick_Release_Pub.Pick_Release');
3467: END IF;
3468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3469: END IF;
3470: END IF;

Line 3480: 'Inv_Pick_Release_Pub.Pick_Release');

3476:
3477: -- Standard call to get message count and if count is 1, get message info
3478: IF is_debug THEN
3479: print_Debug('x_return_status is ' || x_return_status,
3480: 'Inv_Pick_Release_Pub.Pick_Release');
3481: END IF;
3482:
3483: inv_cache.mo_transaction_date := NULL;
3484: l_return_value := inv_cache.set_pick_release(FALSE); --Added bug3237702

Line 3509: 'Inv_Pick_Release_Pub.Pick_Release');

3505: --
3506: WHEN OTHERS THEN
3507: IF is_debug THEN
3508: print_Debug('Other error: ' || sqlerrm,
3509: 'Inv_Pick_Release_Pub.Pick_Release');
3510: END IF;
3511:
3512: ROLLBACK TO Pick_Release_PUB;
3513: --

Line 3910: 'INV_Pick_Release_Pub.Pick_Release');

3906: EXCEPTION
3907: WHEN no_data_found THEN
3908: If is_debug then
3909: print_debug('Error: print_pick_slip_mode not defined',
3910: 'INV_Pick_Release_Pub.Pick_Release');
3911: End If;
3912: --ROLLBACK TO Pick_Release_PUB;
3913: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
3914: FND_MSG_PUB.Add;

Line 3925: 'Inv_Pick_Release_Pub.Pick_Release');

3921:
3922: -- call cartonize API
3923: If is_debug then
3924: print_debug('calling cartonize api',
3925: 'Inv_Pick_Release_Pub.Pick_Release');
3926: End If;
3927:
3928: IF p_move_order_header_id <> -1 and p_move_order_header_id <> 0 and p_move_order_header_id IS NOT NULL THEN
3929: update mtl_material_transactions_temp

Line 3953: 'Inv_Pick_Release_Pub.Call_Cartonization');

3949: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3950: l_api_return_status = fnd_api.g_ret_sts_error THEN
3951: If is_debug then
3952: print_debug('error from cartonize api',
3953: 'Inv_Pick_Release_Pub.Call_Cartonization');
3954: print_debug('error count ' || x_msg_count,
3955: 'Inv_Pick_Release_Pub.Call_Cartonization');
3956: print_debug('error msg ' || x_msg_data,
3957: 'Inv_Pick_Release_Pub.Call_Cartonization');

Line 3955: 'Inv_Pick_Release_Pub.Call_Cartonization');

3951: If is_debug then
3952: print_debug('error from cartonize api',
3953: 'Inv_Pick_Release_Pub.Call_Cartonization');
3954: print_debug('error count ' || x_msg_count,
3955: 'Inv_Pick_Release_Pub.Call_Cartonization');
3956: print_debug('error msg ' || x_msg_data,
3957: 'Inv_Pick_Release_Pub.Call_Cartonization');
3958: End If;
3959: x_return_status := fnd_api.g_ret_sts_error;

Line 3957: 'Inv_Pick_Release_Pub.Call_Cartonization');

3953: 'Inv_Pick_Release_Pub.Call_Cartonization');
3954: print_debug('error count ' || x_msg_count,
3955: 'Inv_Pick_Release_Pub.Call_Cartonization');
3956: print_debug('error msg ' || x_msg_data,
3957: 'Inv_Pick_Release_Pub.Call_Cartonization');
3958: End If;
3959: x_return_status := fnd_api.g_ret_sts_error;
3960: ELSE
3961: IF (is_debug) THEN print_debug('PATCHSET J -- BULK PICKING --- START',

Line 3962: 'Inv_Pick_Release_Pub.Call_Cartonization');

3958: End If;
3959: x_return_status := fnd_api.g_ret_sts_error;
3960: ELSE
3961: IF (is_debug) THEN print_debug('PATCHSET J -- BULK PICKING --- START',
3962: 'Inv_Pick_Release_Pub.Call_Cartonization');
3963: print_debug('calling assign_pick_slip_number',
3964: 'Inv_Pick_Release_Pub.Call_Cartonization');
3965: END IF;
3966: assign_pick_slip_number(

Line 3964: 'Inv_Pick_Release_Pub.Call_Cartonization');

3960: ELSE
3961: IF (is_debug) THEN print_debug('PATCHSET J -- BULK PICKING --- START',
3962: 'Inv_Pick_Release_Pub.Call_Cartonization');
3963: print_debug('calling assign_pick_slip_number',
3964: 'Inv_Pick_Release_Pub.Call_Cartonization');
3965: END IF;
3966: assign_pick_slip_number(
3967: x_return_status => l_api_return_status,
3968: x_msg_count => x_msg_count,

Line 3977: 'Inv_Pick_Release_Pub.Call_Cartonization');

3973: p_allow_partial_pick => p_allow_partial_pick);
3974: IF l_api_return_status = fnd_api.g_ret_sts_unexp_error OR
3975: l_api_return_status = fnd_api.g_ret_sts_error THEN
3976: print_debug('error from assign_pick_slip_number api',
3977: 'Inv_Pick_Release_Pub.Call_Cartonization');
3978: print_debug('error count ' || x_msg_count,
3979: 'Inv_Pick_Release_Pub.Call_Cartonization');
3980: print_debug('error msg ' || x_msg_data,
3981: 'Inv_Pick_Release_Pub.Call_Cartonization');

Line 3979: 'Inv_Pick_Release_Pub.Call_Cartonization');

3975: l_api_return_status = fnd_api.g_ret_sts_error THEN
3976: print_debug('error from assign_pick_slip_number api',
3977: 'Inv_Pick_Release_Pub.Call_Cartonization');
3978: print_debug('error count ' || x_msg_count,
3979: 'Inv_Pick_Release_Pub.Call_Cartonization');
3980: print_debug('error msg ' || x_msg_data,
3981: 'Inv_Pick_Release_Pub.Call_Cartonization');
3982: x_return_status := fnd_api.g_ret_sts_error;
3983: END IF;

Line 3981: 'Inv_Pick_Release_Pub.Call_Cartonization');

3977: 'Inv_Pick_Release_Pub.Call_Cartonization');
3978: print_debug('error count ' || x_msg_count,
3979: 'Inv_Pick_Release_Pub.Call_Cartonization');
3980: print_debug('error msg ' || x_msg_data,
3981: 'Inv_Pick_Release_Pub.Call_Cartonization');
3982: x_return_status := fnd_api.g_ret_sts_error;
3983: END IF;
3984: END IF;
3985:

Line 3988: 'Inv_Pick_Release_Pub.Call_Cartonization');

3984: END IF;
3985:
3986: If is_debug then
3987: print_debug('success from cartonize api',
3988: 'Inv_Pick_Release_Pub.Call_Cartonization');
3989: End If;
3990: END IF; --l_do_Cartonization=1
3991: EXCEPTION
3992: WHEN FND_API.G_EXC_ERROR THEN

Line 4305: END INV_Pick_Release_PUB;

4301: , p_data => x_msg_data);
4302: END Reserve_Unconfqty_lpn;
4303:
4304:
4305: END INV_Pick_Release_PUB;