DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WMS_XDOCK_PEGGING_PUB

Line 699: -- {{ call wms_xdock_pegging_pub.opportunistic_cross_dock API, performing opportunistic

695: END IF;
696:
697: l_progress := '110';
698:
699: -- {{ call wms_xdock_pegging_pub.opportunistic_cross_dock API, performing opportunistic
700: -- crossdock pegging to fulfill a move order line supply that has been received.
701: -- this API will find a set of demands that thas MTRL record can satisfy according to
702: -- crossdock criteria. The splitting of WDD lines, creation and splitting of reservations,
703: -- splitting and updating of MOL will all be done in the API. }}

Line 706: mydebug('***Calling wms_xdock_pegging_pub.opportunistic_cross_dock with the following parameters***');

702: -- crossdock criteria. The splitting of WDD lines, creation and splitting of reservations,
703: -- splitting and updating of MOL will all be done in the API. }}
704:
705: IF (l_debug = 1) THEN
706: mydebug('***Calling wms_xdock_pegging_pub.opportunistic_cross_dock with the following parameters***');
707: mydebug('p_organization_id: =========> ' || l_org_id);
708: mydebug('p_move_order_line_id:=======> ' || l_line_id);
709: mydebug('p_crossdock_criterion_id: ==> ' || l_xdock_criterion_id);
710: END IF;

Line 717: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');

713: IF l_xdock_criterion_id IS NOT NULL THEN
714: -- Bug# 4662186
715: -- Cache crossdock criteria data first before calling the pegging API
716: IF (l_debug = 1) THEN
717: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
718: END IF;
719: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
720:
721: wms_xdock_pegging_pub.Opportunistic_Cross_Dock

Line 719: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);

715: -- Cache crossdock criteria data first before calling the pegging API
716: IF (l_debug = 1) THEN
717: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
718: END IF;
719: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
720:
721: wms_xdock_pegging_pub.Opportunistic_Cross_Dock
722: (p_organization_id => l_org_id,
723: p_move_order_line_id => l_line_id,

Line 721: wms_xdock_pegging_pub.Opportunistic_Cross_Dock

717: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
718: END IF;
719: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
720:
721: wms_xdock_pegging_pub.Opportunistic_Cross_Dock
722: (p_organization_id => l_org_id,
723: p_move_order_line_id => l_line_id,
724: p_crossdock_criterion_id => l_xdock_criterion_id,
725: x_return_status => l_return_status,

Line 730: mydebug('***After calling wms_xdock_pegging_pub.Opportunistic_Cross_Dock ***');

726: x_msg_count => l_msg_count,
727: x_msg_data => l_msg_data);
728:
729: IF (l_debug = 1) THEN
730: mydebug('***After calling wms_xdock_pegging_pub.Opportunistic_Cross_Dock ***');
731: mydebug('l_return_status = '||l_return_status);
732: mydebug('l_msg_count = '||l_msg_count);
733: mydebug('l_msg_data = '||l_msg_data);
734: END IF;

Line 759: mydebug('***Calling wms_xdock_pegging_pub.clear_crossdock_cache***');

755:
756: -- Bug# 4662186
757: -- Clear the crossdock criteria cache when pegging has completed
758: IF (l_debug = 1) THEN
759: mydebug('***Calling wms_xdock_pegging_pub.clear_crossdock_cache***');
760: END IF;
761: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;
762:
763: l_progress := '130';

Line 761: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;

757: -- Clear the crossdock criteria cache when pegging has completed
758: IF (l_debug = 1) THEN
759: mydebug('***Calling wms_xdock_pegging_pub.clear_crossdock_cache***');
760: END IF;
761: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;
762:
763: l_progress := '130';
764: END IF;
765:

Line 952: mydebug('Calling wms_xdock_pegging_pub.get_expected_time');

948: END IF;
949: END;
950:
951: IF (l_debug = 1) THEN
952: mydebug('Calling wms_xdock_pegging_pub.get_expected_time');
953: mydebug(' p_source_type_id => '|| l_source_type_id);
954: mydebug(' p_source_header_id => '||l_source_header_id);
955: mydebug(' p_source_line_id => '||l_source_line_id);
956: mydebug(' p_source_line_detail_=> '||l_backorder_delivery_detail_id);

Line 961: wms_xdock_pegging_pub.get_expected_time

957: mydebug(' p_supply_or_demand => '||2);
958: mydebug(' p_crossdock_criterion=> '||l_xdock_criterion_id);
959: END IF;
960:
961: wms_xdock_pegging_pub.get_expected_time
962: ( p_source_type_id => l_source_type_id
963: ,p_source_header_id => l_source_header_id
964: ,p_source_line_id => l_source_line_id
965: ,p_source_line_detail_id => l_backorder_delivery_detail_id

Line 1027: l_xdock_criteria := wms_xdock_pegging_pub.get_crossdock_criteria(l_xdock_criterion_id);

1023: --AND simply create the delivery
1024: IF (l_xdock_criterion_id IS NOT NULL) THEN
1025:
1026: -- {{ get BT, OPT, and crossdocking_window from cached values }}
1027: l_xdock_criteria := wms_xdock_pegging_pub.get_crossdock_criteria(l_xdock_criterion_id);
1028:
1029: IF (l_debug = 1) THEN
1030: mydebug('Crossdock Window: ' ||
1031: l_xdock_criteria.window_interval || ' ' ||

Line 1131: -- {{ call wms_xdock_pegging_pub.get_expected_delivery_time}}

1127: -- {{ loop those deliveries returned by WSH API
1128: -- check whether the delivery satisfies the crossdocking window and related
1129: -- time constraints) based on crossdock criteria;
1130: FOR l_index IN 1..l_matched_entities.COUNT LOOP
1131: -- {{ call wms_xdock_pegging_pub.get_expected_delivery_time}}
1132:
1133: IF (l_debug = 1) THEN
1134: mydebug('***Calling wms_xdock_pegging_pub.get_expected_delivery_time***');
1135: mydebug('p_delivery_id = '||l_matched_entities(l_index));

Line 1134: mydebug('***Calling wms_xdock_pegging_pub.get_expected_delivery_time***');

1130: FOR l_index IN 1..l_matched_entities.COUNT LOOP
1131: -- {{ call wms_xdock_pegging_pub.get_expected_delivery_time}}
1132:
1133: IF (l_debug = 1) THEN
1134: mydebug('***Calling wms_xdock_pegging_pub.get_expected_delivery_time***');
1135: mydebug('p_delivery_id = '||l_matched_entities(l_index));
1136: mydebug('p_crossdock_criterion_id = '||l_xdock_criterion_id);
1137: END IF;
1138:

Line 1139: wms_xdock_pegging_pub.get_expected_delivery_time

1135: mydebug('p_delivery_id = '||l_matched_entities(l_index));
1136: mydebug('p_crossdock_criterion_id = '||l_xdock_criterion_id);
1137: END IF;
1138:
1139: wms_xdock_pegging_pub.get_expected_delivery_time
1140: (p_delivery_id => l_matched_entities(l_index),
1141: p_crossdock_criterion_id => l_xdock_criterion_id,
1142: x_return_status => l_return_status,
1143: x_msg_count => l_msg_count,

Line 1151: mydebug('***After calling wms_xdock_pegging_pub.get_expected_delivery_time***');

1147: x_dock_end_time => l_matched_dock_end_time,
1148: x_expected_time => l_matched_expected_del_time);
1149:
1150: IF (l_debug = 1) THEN
1151: mydebug('***After calling wms_xdock_pegging_pub.get_expected_delivery_time***');
1152: mydebug('x_dock_appointment_id = '||l_matched_dock_appointment_id);
1153: mydebug('x_dock_start_time = '||l_matched_dock_start_time);
1154: mydebug('x_dock_end_time = '||l_matched_dock_end_time);
1155: mydebug('x_expected_time = '||l_matched_expected_del_time);