DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_INTEGRATION

Line 1119: l_msg_table WSH_INTEGRATION.MSG_TABLE ;

1115: l_error_code NUMBER;
1116: x_ret_code number;
1117: l_status_code varchar2(3);
1118: l_del_name VARCHAR2(30);
1119: l_msg_table WSH_INTEGRATION.MSG_TABLE ;
1120: l_count NUMBER := 0;
1121:
1122: -- varajago: Added the following 3, for 5204686
1123: l_enforce_shipmethod VARCHAR2(1) ;

Line 1420: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP

1416: END IF;
1417: IF (l_return_status=fnd_api.g_ret_sts_success) THEN
1418: l_count:=0;
1419:
1420: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1421: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1422: l_count := l_count + 1;
1423: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1424: END IF;

Line 1421: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN

1417: IF (l_return_status=fnd_api.g_ret_sts_success) THEN
1418: l_count:=0;
1419:
1420: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1421: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1422: l_count := l_count + 1;
1423: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1424: END IF;
1425: END LOOP;

Line 1423: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);

1419:
1420: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1421: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1422: l_count := l_count + 1;
1423: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1424: END IF;
1425: END LOOP;
1426: IF (l_debug = 1) THEN
1427: debug('before calling process shipping warning msgs','ship_confirm');

Line 1439: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP

1435: FOR i in 1..l_msg_table.count LOOP
1436: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
1437: --l_error_exists := TRUE;
1438: l_return_status:=fnd_api.g_ret_sts_error;
1439: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1440: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1441: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1442: END IF;
1443: END LOOP;

Line 1440: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN

1436: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
1437: --l_error_exists := TRUE;
1438: l_return_status:=fnd_api.g_ret_sts_error;
1439: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1440: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1441: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1442: END IF;
1443: END LOOP;
1444: END IF;

Line 1441: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';

1437: --l_error_exists := TRUE;
1438: l_return_status:=fnd_api.g_ret_sts_error;
1439: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1440: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1441: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1442: END IF;
1443: END LOOP;
1444: END IF;
1445: END LOOP;

Line 5046: l_invpcinrectype wsh_integration.invpcinrectype;

5042: l_item_reservable NUMBER;
5043: l_lot_control_code NUMBER;
5044: l_serial_number_control_code NUMBER;
5045: l_shipping_attr wsh_interface.changedattributetabtype;
5046: l_invpcinrectype wsh_integration.invpcinrectype;
5047: l_rsv_index NUMBER;
5048: l_rsv_qty NUMBER;
5049: i NUMBER;
5050: l_return NUMBER;

Line 5755: wsh_integration.set_inv_pc_attributes(

5751: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
5752: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
5753: END IF;
5754:
5755: wsh_integration.set_inv_pc_attributes(
5756: p_in_attributes => l_invpcinrectype
5757: , x_return_status => l_return_status
5758: , x_msg_count => l_msg_data
5759: , x_msg_data => l_msg_count

Line 6022: WSH_INTEGRATION.Set_INV_PC_Attributes(

6018: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6019: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6020: END IF;
6021:
6022: WSH_INTEGRATION.Set_INV_PC_Attributes(
6023: p_in_attributes => l_invpcinrectype
6024: , x_return_status => l_return_status
6025: , x_msg_count => l_msg_data
6026: , x_msg_data => l_msg_count );

Line 6110: wsh_integration.set_inv_pc_attributes(

6106: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6107: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6108: END IF;
6109:
6110: wsh_integration.set_inv_pc_attributes(
6111: p_in_attributes => l_invpcinrectype
6112: , x_return_status => l_return_status
6113: , x_msg_count => l_msg_data
6114: , x_msg_data => l_msg_count

Line 10730: l_minmaxinrectype wsh_integration.minmaxinrectype;

10726: l_order_header_id NUMBER;
10727:
10728: /* Commented for bug 5262108
10729: -- to query tolerance
10730: l_minmaxinrectype wsh_integration.minmaxinrectype;
10731: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
10732: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
10733: l_max_shippable_quantity NUMBER;
10734: l_total_resvd_qty NUMBER;

Line 10731: l_minmaxoutrectype wsh_integration.minmaxoutrectype;

10727:
10728: /* Commented for bug 5262108
10729: -- to query tolerance
10730: l_minmaxinrectype wsh_integration.minmaxinrectype;
10731: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
10732: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
10733: l_max_shippable_quantity NUMBER;
10734: l_total_resvd_qty NUMBER;
10735: -- For create_reservation

Line 10732: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */

10728: /* Commented for bug 5262108
10729: -- to query tolerance
10730: l_minmaxinrectype wsh_integration.minmaxinrectype;
10731: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
10732: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
10733: l_max_shippable_quantity NUMBER;
10734: l_total_resvd_qty NUMBER;
10735: -- For create_reservation
10736: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

Line 10895: wsh_integration.get_min_max_tolerance_quantity(

10891: DEBUG('l_order_line_id=' || l_order_line_id, 'Perform_Overship_Distribution');
10892: END IF;
10893:
10894: /* Commented for bug 5262108
10895: wsh_integration.get_min_max_tolerance_quantity(
10896: p_in_attributes => l_minmaxinrectype
10897: , p_out_attributes => l_minmaxoutrectype
10898: , p_inout_attributes => l_minmaxinoutrectype
10899: , x_return_status => l_return_status

Line 11221: wsh_integration.get_min_max_tolerance_quantity(

11217: -- get max shippble quantity
11218: l_minmaxinrectype.api_version_number := 1.0;
11219: l_minmaxinrectype.source_code := 'OE';
11220: l_minmaxinrectype.line_id := l_loaded_lines_rec.order_line_id;
11221: wsh_integration.get_min_max_tolerance_quantity(
11222: p_in_attributes => l_minmaxinrectype
11223: , p_out_attributes => l_minmaxoutrectype
11224: , p_inout_attributes => l_minmaxinoutrectype
11225: , x_return_status => l_return_status