DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WMS_XDOCK_PEGGING_PUB

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

463: END IF;
464:
465: l_progress := '110';
466:
467: -- {{ call wms_xdock_pegging_pub.opportunistic_cross_dock API, performing opportunistic
468: -- crossdock pegging to fulfill a move order line supply that has been received.
469: -- this API will find a set of demands that thas MTRL record can satisfy according to
470: -- crossdock criteria. The splitting of WDD lines, creation and splitting of reservations,
471: -- splitting and updating of MOL will all be done in the API. }}

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

470: -- crossdock criteria. The splitting of WDD lines, creation and splitting of reservations,
471: -- splitting and updating of MOL will all be done in the API. }}
472:
473: IF (l_debug = 1) THEN
474: mydebug('***Calling wms_xdock_pegging_pub.opportunistic_cross_dock with the following parameters***');
475: mydebug('p_organization_id: =========> ' || l_org_id);
476: mydebug('p_move_order_line_id:=======> ' || l_line_id);
477: mydebug('p_crossdock_criterion_id: ==> ' || l_xdock_criterion_id);
478: END IF;

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

481: IF l_xdock_criterion_id IS NOT NULL THEN
482: -- Bug# 4662186
483: -- Cache crossdock criteria data first before calling the pegging API
484: IF (l_debug = 1) THEN
485: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
486: END IF;
487: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
488:
489: wms_xdock_pegging_pub.Opportunistic_Cross_Dock

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

483: -- Cache crossdock criteria data first before calling the pegging API
484: IF (l_debug = 1) THEN
485: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
486: END IF;
487: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
488:
489: wms_xdock_pegging_pub.Opportunistic_Cross_Dock
490: (p_organization_id => l_org_id,
491: p_move_order_line_id => l_line_id,

Line 489: wms_xdock_pegging_pub.Opportunistic_Cross_Dock

485: mydebug('***Calling wms_xdock_pegging_pub.set_crossdock_criteria***');
486: END IF;
487: l_cache := wms_xdock_pegging_pub.set_crossdock_criteria(l_xdock_criterion_id);
488:
489: wms_xdock_pegging_pub.Opportunistic_Cross_Dock
490: (p_organization_id => l_org_id,
491: p_move_order_line_id => l_line_id,
492: p_crossdock_criterion_id => l_xdock_criterion_id,
493: x_return_status => l_return_status,

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

494: x_msg_count => l_msg_count,
495: x_msg_data => l_msg_data);
496:
497: IF (l_debug = 1) THEN
498: mydebug('***After calling wms_xdock_pegging_pub.Opportunistic_Cross_Dock ***');
499: mydebug('l_return_status = '||l_return_status);
500: mydebug('l_msg_count = '||l_msg_count);
501: mydebug('l_msg_data = '||l_msg_data);
502: END IF;

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

523:
524: -- Bug# 4662186
525: -- Clear the crossdock criteria cache when pegging has completed
526: IF (l_debug = 1) THEN
527: mydebug('***Calling wms_xdock_pegging_pub.clear_crossdock_cache***');
528: END IF;
529: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;
530:
531: l_progress := '130';

Line 529: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;

525: -- Clear the crossdock criteria cache when pegging has completed
526: IF (l_debug = 1) THEN
527: mydebug('***Calling wms_xdock_pegging_pub.clear_crossdock_cache***');
528: END IF;
529: l_cache := wms_xdock_pegging_pub.clear_crossdock_cache;
530:
531: l_progress := '130';
532: END IF;
533:

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

673: END IF;
674: END;
675:
676: IF (l_debug = 1) THEN
677: mydebug('Calling wms_xdock_pegging_pub.get_expected_time');
678: mydebug(' p_source_type_id => '|| l_source_type_id);
679: mydebug(' p_source_header_id => '||l_source_header_id);
680: mydebug(' p_source_line_id => '||l_source_line_id);
681: mydebug(' p_source_line_detail_=> '||l_backorder_delivery_detail_id);

Line 686: wms_xdock_pegging_pub.get_expected_time

682: mydebug(' p_supply_or_demand => '||2);
683: mydebug(' p_crossdock_criterion=> '||l_xdock_criterion_id);
684: END IF;
685:
686: wms_xdock_pegging_pub.get_expected_time
687: ( p_source_type_id => l_source_type_id
688: ,p_source_header_id => l_source_header_id
689: ,p_source_line_id => l_source_line_id
690: ,p_source_line_detail_id => l_backorder_delivery_detail_id

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

748: --AND simply create the delivery
749: IF (l_xdock_criterion_id IS NOT NULL) THEN
750:
751: -- {{ get BT, OPT, and crossdocking_window from cached values }}
752: l_xdock_criteria := wms_xdock_pegging_pub.get_crossdock_criteria(l_xdock_criterion_id);
753:
754: IF (l_debug = 1) THEN
755: mydebug('Crossdock Window: ' ||
756: l_xdock_criteria.window_interval || ' ' ||

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

852: -- {{ loop those deliveries returned by WSH API
853: -- check whether the delivery satisfies the crossdocking window and related
854: -- time constraints) based on crossdock criteria;
855: FOR l_index IN 1..l_matched_entities.COUNT LOOP
856: -- {{ call wms_xdock_pegging_pub.get_expected_delivery_time}}
857:
858: IF (l_debug = 1) THEN
859: mydebug('***Calling wms_xdock_pegging_pub.get_expected_delivery_time***');
860: mydebug('p_delivery_id = '||l_matched_entities(l_index));

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

855: FOR l_index IN 1..l_matched_entities.COUNT LOOP
856: -- {{ call wms_xdock_pegging_pub.get_expected_delivery_time}}
857:
858: IF (l_debug = 1) THEN
859: mydebug('***Calling wms_xdock_pegging_pub.get_expected_delivery_time***');
860: mydebug('p_delivery_id = '||l_matched_entities(l_index));
861: mydebug('p_crossdock_criterion_id = '||l_xdock_criterion_id);
862: END IF;
863:

Line 864: wms_xdock_pegging_pub.get_expected_delivery_time

860: mydebug('p_delivery_id = '||l_matched_entities(l_index));
861: mydebug('p_crossdock_criterion_id = '||l_xdock_criterion_id);
862: END IF;
863:
864: wms_xdock_pegging_pub.get_expected_delivery_time
865: (p_delivery_id => l_matched_entities(l_index),
866: p_crossdock_criterion_id => l_xdock_criterion_id,
867: x_return_status => l_return_status,
868: x_msg_count => l_msg_count,

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

872: x_dock_end_time => l_matched_dock_end_time,
873: x_expected_time => l_matched_expected_del_time);
874:
875: IF (l_debug = 1) THEN
876: mydebug('***After calling wms_xdock_pegging_pub.get_expected_delivery_time***');
877: mydebug('x_dock_appointment_id = '||l_matched_dock_appointment_id);
878: mydebug('x_dock_start_time = '||l_matched_dock_start_time);
879: mydebug('x_dock_end_time = '||l_matched_dock_end_time);
880: mydebug('x_expected_time = '||l_matched_expected_del_time);