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

Line 1: PACKAGE BODY WMS_SHIPPING_INTERFACE_GRP AS

1: PACKAGE BODY WMS_SHIPPING_INTERFACE_GRP AS
2: /* $Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_SHIPPING_INTERFACE_GRP';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $';

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_SHIPPING_INTERFACE_GRP';

1: PACKAGE BODY WMS_SHIPPING_INTERFACE_GRP AS
2: /* $Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_SHIPPING_INTERFACE_GRP';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $';
6: g_debug_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7: g_ret_status_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: g_ret_status_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

Line 75: (p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,

71: END get_lpn_context;
72:
73:
74: PROCEDURE proc_action_unassign_delivery
75: (p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,
76: x_return_status OUT NOCOPY VARCHAR2)
77: IS
78: l_procname CONSTANT VARCHAR2(100) := 'proc_action_unassign_delivery- ';
79: l_lpn_context NUMBER := NULL;

Line 135: (p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,

131:
132: END proc_action_unassign_delivery;
133:
134: PROCEDURE Proc_unassign_released_lines
135: (p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,
136: x_return_status OUT NOCOPY VARCHAR2)
137: IS
138: l_procname CONSTANT VARCHAR2(100) := 'Proc_unassign_for_released_lines- ';
139:

Line 286: p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false,

282: END Proc_unassign_released_lines;
283:
284: PROCEDURE process_delivery_details (
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false,
287: p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false,
288: p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation,
289: p_action IN VARCHAR2,
290: p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,

Line 287: p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false,

283:
284: PROCEDURE process_delivery_details (
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false,
287: p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false,
288: p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation,
289: p_action IN VARCHAR2,
290: p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,
291: x_return_status OUT NOCOPY VARCHAR2,

Line 288: p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation,

284: PROCEDURE process_delivery_details (
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false,
287: p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false,
288: p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation,
289: p_action IN VARCHAR2,
290: p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,

Line 290: p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,

286: p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false,
287: p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false,
288: p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation,
289: p_action IN VARCHAR2,
290: p_delivery_detail_tbl IN OUT NOCOPY wms_shipping_interface_grp.g_delivery_detail_tbl,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
293: x_msg_data OUT NOCOPY VARCHAR2)
294: IS

Line 326: IF p_action = wms_shipping_interface_grp.g_action_unassign_delivery

322:
323: print_debug(l_procname || ' Entered ' || g_pkg_version);
324: print_debug('action='||p_action||' deltblcnt='||p_delivery_detail_tbl.COUNT|| ' relvl='||G_WMS_RELEASE_LEVEL);
325:
326: IF p_action = wms_shipping_interface_grp.g_action_unassign_delivery
327: THEN
328: IF p_delivery_detail_tbl(1).released_Status = 'X' and p_delivery_detail_tbl(1).container_flag = 'Y' THEN -- for staged LPNs
329: IF g_debug_on = 1 THEN
330: print_debug (l_procname || 'calling API to handle the staged LPN.');

Line 364: ELSIF ( p_action = WMS_SHIPPING_INTERFACE_GRP.G_ACTION_VALIDATE_SEC_QTY AND

360: print_debug (l_procname || 'released_status is not correct:'||p_delivery_detail_tbl(1).released_status);
361: END IF;
362: RAISE g_exc_unexpected_error;
363: END IF;
364: ELSIF ( p_action = WMS_SHIPPING_INTERFACE_GRP.G_ACTION_VALIDATE_SEC_QTY AND
365: G_WMS_RELEASE_LEVEL >= G_J_RELEASE_LEVEL ) THEN
366: l_progress := '000';
367: FOR i IN 1..p_delivery_detail_tbl.COUNT LOOP
368: -- Only check for catch weights if Delivery Detail is for a Sales Order

Line 496: ( p_encoded => wms_shipping_interface_grp.g_false,

492: END IF;
493: END IF;
494:
495: fnd_msg_pub.count_and_get
496: ( p_encoded => wms_shipping_interface_grp.g_false,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:

Line 509: x_msg_data := fnd_msg_pub.get(x_msg_count,wms_shipping_interface_grp.g_false);

505: x_msg_data := '';
506: ELSIF x_msg_count =1 THEN
507: null;
508: ELSE
509: x_msg_data := fnd_msg_pub.get(x_msg_count,wms_shipping_interface_grp.g_false);
510: END IF;
511:
512:
513: EXCEPTION

Line 520: ( p_encoded => wms_shipping_interface_grp.g_false,

516: fnd_message.set_name('WMS', 'ERR_PROC_UNASSIGN_DEL');
517: fnd_msg_pub.add;
518:
519: fnd_msg_pub.count_and_get
520: ( p_encoded => wms_shipping_interface_grp.g_false,
521: p_count => x_msg_count,
522: p_data => x_msg_data
523: );
524:

Line 540: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false

536: --3. Desktop
537: --This procedure should only return error in case 3.
538: PROCEDURE process_delivery_trip
539: (p_api_version IN NUMBER
540: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
541: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
542: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
543: ,p_action IN VARCHAR2
544: ,p_dlvy_trip_tbl IN OUT nocopy wms_shipping_interface_grp.g_dlvy_trip_tbl

Line 541: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false

537: --This procedure should only return error in case 3.
538: PROCEDURE process_delivery_trip
539: (p_api_version IN NUMBER
540: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
541: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
542: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
543: ,p_action IN VARCHAR2
544: ,p_dlvy_trip_tbl IN OUT nocopy wms_shipping_interface_grp.g_dlvy_trip_tbl
545: ,x_return_status OUT nocopy VARCHAR2

Line 542: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation

538: PROCEDURE process_delivery_trip
539: (p_api_version IN NUMBER
540: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
541: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
542: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
543: ,p_action IN VARCHAR2
544: ,p_dlvy_trip_tbl IN OUT nocopy wms_shipping_interface_grp.g_dlvy_trip_tbl
545: ,x_return_status OUT nocopy VARCHAR2
546: ,x_msg_count OUT nocopy NUMBER

Line 544: ,p_dlvy_trip_tbl IN OUT nocopy wms_shipping_interface_grp.g_dlvy_trip_tbl

540: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
541: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
542: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
543: ,p_action IN VARCHAR2
544: ,p_dlvy_trip_tbl IN OUT nocopy wms_shipping_interface_grp.g_dlvy_trip_tbl
545: ,x_return_status OUT nocopy VARCHAR2
546: ,x_msg_count OUT nocopy NUMBER
547: ,x_msg_data OUT nocopy VARCHAR2) IS
548:

Line 573: IF p_action NOT IN (wms_shipping_interface_grp.g_action_assign_dlvy_trip,

569: END IF;
570: RAISE g_exc_unexpected_error;
571: END IF;
572:
573: IF p_action NOT IN (wms_shipping_interface_grp.g_action_assign_dlvy_trip,
574: wms_shipping_interface_grp.g_action_unassign_dlvy_trip) THEN
575: IF g_debug_on = 1 THEN
576: print_debug(l_procname || 'Invalid action passed in');
577: END IF;

Line 574: wms_shipping_interface_grp.g_action_unassign_dlvy_trip) THEN

570: RAISE g_exc_unexpected_error;
571: END IF;
572:
573: IF p_action NOT IN (wms_shipping_interface_grp.g_action_assign_dlvy_trip,
574: wms_shipping_interface_grp.g_action_unassign_dlvy_trip) THEN
575: IF g_debug_on = 1 THEN
576: print_debug(l_procname || 'Invalid action passed in');
577: END IF;
578: RAISE g_exc_unexpected_error;

Line 618: IF p_action = wms_shipping_interface_grp.g_action_assign_dlvy_trip THEN

614: IF g_debug_on = 1 THEN
615: print_debug(l_procname || ': wstt.l_trip_id: '|| l_trip_id);
616: END IF;
617: --get to here means the delivery is loaded to dock
618: IF p_action = wms_shipping_interface_grp.g_action_assign_dlvy_trip THEN
619: IF l_trip_id = p_dlvy_trip_tbl(i).trip_id THEN
620: IF g_debug_on = 1 THEN
621: print_debug(l_procname || ': wstt.l_trip_id: is same as the trip passed in ');
622: END IF;

Line 655: ELSIF p_action = wms_shipping_interface_grp.g_action_unassign_dlvy_trip THEN

651: print_debug(l_procname || ': wstt could not be updated: ' || SQLCODE ||':' || SQLERRM);
652: END IF;
653: END ;
654: END IF;
655: ELSIF p_action = wms_shipping_interface_grp.g_action_unassign_dlvy_trip THEN
656: --need a different error message?
657: /* NCR Bug : 4576909 : Instead of returning error, update WSTT
658: p_dlvy_trip_tbl(i).return_status := 'E';
659: p_dlvy_trip_tbl(i).r_message_appl := 'WMS';

Line 712: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false

708: END process_delivery_trip;
709:
710: PROCEDURE process_serial_number
711: (p_api_version IN NUMBER
712: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
713: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
714: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
715: ,p_action IN VARCHAR2
716: ,p_serial_number_tbl IN OUT nocopy wms_shipping_interface_grp.g_serial_number_tbl

Line 713: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false

709:
710: PROCEDURE process_serial_number
711: (p_api_version IN NUMBER
712: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
713: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
714: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
715: ,p_action IN VARCHAR2
716: ,p_serial_number_tbl IN OUT nocopy wms_shipping_interface_grp.g_serial_number_tbl
717: ,x_return_status OUT nocopy VARCHAR2

Line 714: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation

710: PROCEDURE process_serial_number
711: (p_api_version IN NUMBER
712: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
713: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
714: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
715: ,p_action IN VARCHAR2
716: ,p_serial_number_tbl IN OUT nocopy wms_shipping_interface_grp.g_serial_number_tbl
717: ,x_return_status OUT nocopy VARCHAR2
718: ,x_msg_count OUT nocopy NUMBER

Line 716: ,p_serial_number_tbl IN OUT nocopy wms_shipping_interface_grp.g_serial_number_tbl

712: ,p_init_msg_list IN VARCHAR2 := wms_shipping_interface_grp.g_false
713: ,p_commit IN VARCHAR2 := wms_shipping_interface_grp.g_false
714: ,p_validation_level IN NUMBER := wms_shipping_interface_grp.g_full_validation
715: ,p_action IN VARCHAR2
716: ,p_serial_number_tbl IN OUT nocopy wms_shipping_interface_grp.g_serial_number_tbl
717: ,x_return_status OUT nocopy VARCHAR2
718: ,x_msg_count OUT nocopy NUMBER
719: ,x_msg_data OUT nocopy VARCHAR2) IS
720:

Line 737: IF p_action = wms_shipping_interface_grp.g_action_update THEN

733: x_return_status := g_ret_status_success;
734: x_msg_count := 0;
735: x_msg_data := '';
736:
737: IF p_action = wms_shipping_interface_grp.g_action_update THEN
738: IF NOT fnd_api.compatible_api_call(1.0
739: ,p_api_version
740: ,'PROCESS_SERIAL_NUMBER'
741: ,g_pkg_name) THEN

Line 808: ,p_init_msg_list IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false

804: any LPN associated with this delivery is already loaded to dock door
805: */
806: PROCEDURE process_deliveries
807: (p_api_version IN NUMBER
808: ,p_init_msg_list IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
809: ,p_commit IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
810: ,p_validation_level IN NUMBER := Wms_Shipping_Interface_Grp.g_full_validation
811: ,p_action IN VARCHAR2
812: ,x_dlvy_trip_tbl IN OUT nocopy Wms_Shipping_Interface_Grp.g_dlvy_trip_tbl

Line 809: ,p_commit IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false

805: */
806: PROCEDURE process_deliveries
807: (p_api_version IN NUMBER
808: ,p_init_msg_list IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
809: ,p_commit IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
810: ,p_validation_level IN NUMBER := Wms_Shipping_Interface_Grp.g_full_validation
811: ,p_action IN VARCHAR2
812: ,x_dlvy_trip_tbl IN OUT nocopy Wms_Shipping_Interface_Grp.g_dlvy_trip_tbl
813: ,x_return_status OUT nocopy VARCHAR2

Line 810: ,p_validation_level IN NUMBER := Wms_Shipping_Interface_Grp.g_full_validation

806: PROCEDURE process_deliveries
807: (p_api_version IN NUMBER
808: ,p_init_msg_list IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
809: ,p_commit IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
810: ,p_validation_level IN NUMBER := Wms_Shipping_Interface_Grp.g_full_validation
811: ,p_action IN VARCHAR2
812: ,x_dlvy_trip_tbl IN OUT nocopy Wms_Shipping_Interface_Grp.g_dlvy_trip_tbl
813: ,x_return_status OUT nocopy VARCHAR2
814: ,x_msg_count OUT nocopy NUMBER

Line 812: ,x_dlvy_trip_tbl IN OUT nocopy Wms_Shipping_Interface_Grp.g_dlvy_trip_tbl

808: ,p_init_msg_list IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
809: ,p_commit IN VARCHAR2 := Wms_Shipping_Interface_Grp.g_false
810: ,p_validation_level IN NUMBER := Wms_Shipping_Interface_Grp.g_full_validation
811: ,p_action IN VARCHAR2
812: ,x_dlvy_trip_tbl IN OUT nocopy Wms_Shipping_Interface_Grp.g_dlvy_trip_tbl
813: ,x_return_status OUT nocopy VARCHAR2
814: ,x_msg_count OUT nocopy NUMBER
815: ,x_msg_data OUT nocopy VARCHAR2) IS
816:

Line 831: IF p_action = Wms_Shipping_Interface_Grp.g_action_plan_delivery THEN

827: print_debug('x_dlvy_trip_tbl: ' || x_dlvy_trip_tbl.COUNT );
828:
829: x_msg_count := 0;
830: x_msg_data := '';
831: IF p_action = Wms_Shipping_Interface_Grp.g_action_plan_delivery THEN
832: FOR i IN x_dlvy_trip_tbl.first..x_dlvy_trip_tbl.last LOOP
833: l_delivery_status := 0;
834: print_debug('x_dlvy_trip_tbl(i).delivery_id : ' || x_dlvy_trip_tbl(i).delivery_id);
835:

Line 870: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Record No : ' || i );

866: print_debug('NO_DATA_FOUND :' || x_dlvy_trip_tbl(i).delivery_id);
867: END;
868:
869: IF g_debug_on = 1 THEN
870: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Record No : ' || i );
871: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Delivery ID : ' || x_dlvy_trip_tbl(i).delivery_id );
872: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' r_message_code : ' || x_dlvy_trip_tbl(i).r_message_code );
873: END IF;
874:

Line 871: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Delivery ID : ' || x_dlvy_trip_tbl(i).delivery_id );

867: END;
868:
869: IF g_debug_on = 1 THEN
870: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Record No : ' || i );
871: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Delivery ID : ' || x_dlvy_trip_tbl(i).delivery_id );
872: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' r_message_code : ' || x_dlvy_trip_tbl(i).r_message_code );
873: END IF;
874:
875: END LOOP;

Line 872: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' r_message_code : ' || x_dlvy_trip_tbl(i).r_message_code );

868:
869: IF g_debug_on = 1 THEN
870: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Record No : ' || i );
871: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' Delivery ID : ' || x_dlvy_trip_tbl(i).delivery_id );
872: print_debug('WMS_SHIPPING_INTERFACE_GRP.PROCESS_DELIVERIES : ' || ' r_message_code : ' || x_dlvy_trip_tbl(i).r_message_code );
873: END IF;
874:
875: END LOOP;
876: END IF;

Line 994: END wms_shipping_interface_grp;

990: --need to use print method
991: print_debug('Unexpected error in split_wave_line: '||SQLCODE || ' : '||SQLERRM);
992: x_return_status := 'U';
993: end split_wave_line;
994: END wms_shipping_interface_grp;