APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_PUTAWAY_SUGGESTIONS

Line 983: -- An autonomous_transaction wrapper arount wms_putaway_suggestions.cleanup_suggestions

979: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
980: END create_mo;
981:
982: -- added for bug 3401817
983: -- An autonomous_transaction wrapper arount wms_putaway_suggestions.cleanup_suggestions
984: -- This is because after cleanup_suggestions, we call create_suggestions,
985: -- which may very well suggest the same locator. In cleanup_suggestions, we call abort_operation_instance, which
986: -- in turn calls revert_loc_sugg_capacity_nauto. However, in create_suggestions, we call update_loc_suggested_capacity,
987: -- with autonomous_transaction, which will cause resource busy.

Line 1000: wms_putaway_suggestions.cleanup_suggestions

996: , p_move_order_line_id IN NUMBER DEFAULT NULL -- added for ATF_J2
997: ) IS
998: PRAGMA autonomous_transaction;
999: BEGIN
1000: wms_putaway_suggestions.cleanup_suggestions
1001: ( p_lpn_id => p_lpn_id
1002: , p_org_id => p_org_id
1003: , x_return_status => x_return_status
1004: , x_msg_count => x_msg_count

Line 1752: -- 4. If l_Need_to_cleanup_prege is YES, call wms_putaway_suggestions.cleanup_suggestions, passing lpn_id and move_order_line_id

1748: -- 3. After the loop,
1749: -- set l_Need_to_cleanup_prege based on the flags set.
1750: --
1751: --
1752: -- 4. If l_Need_to_cleanup_prege is YES, call wms_putaway_suggestions.cleanup_suggestions, passing lpn_id and move_order_line_id
1753:
1754: IF l_lpn_context <> 1 THEN
1755: IF pregen_suggestions_csr%ISOPEN THEN
1756: CLOSE pregen_suggestions_csr;

Line 1909: wms_putaway_suggestions.cleanup_suggestions

1905: -- The original need for autonomous cleanup_suggestions
1906: -- is satisfied by passing p_for_manual_drop => true
1907: -- into abort_operation_instance .
1908:
1909: wms_putaway_suggestions.cleanup_suggestions
1910: (
1911: p_lpn_id => l_lpn_id
1912: , p_org_id => p_org_id
1913: , x_return_status => l_return_status

Line 1920: mydebug(' suggestions_pub: After calling wms_putaway_suggestions.cleanup_suggestions ');

1916: , p_move_order_line_id => p_move_order_line_id
1917: ); --added for ATF_J2
1918:
1919: IF (l_debug = 1) THEN
1920: mydebug(' suggestions_pub: After calling wms_putaway_suggestions.cleanup_suggestions ');
1921: mydebug('x_return_status = ' || l_return_status);
1922: mydebug('x_msg_count = ' || x_msg_count);
1923: mydebug('x_msg_data = ' || x_msg_data);
1924: END IF;

Line 1928: mydebug(' suggestions_pub: wms_putaway_suggestions.cleanup_suggestions failed');

1924: END IF;
1925:
1926: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1927: IF (l_debug = 1) THEN
1928: mydebug(' suggestions_pub: wms_putaway_suggestions.cleanup_suggestions failed');
1929: END IF;
1930:
1931: RAISE fnd_api.g_exc_error;
1932: END IF;