DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_INTEGRATION

Line 1202: l_msg_table WSH_INTEGRATION.MSG_TABLE ;

1198: l_error_code NUMBER;
1199: x_ret_code number;
1200: l_status_code varchar2(3);
1201: l_del_name VARCHAR2(30);
1202: l_msg_table WSH_INTEGRATION.MSG_TABLE ;
1203: l_count NUMBER := 0;
1204:
1205: -- varajago: Added the following 3, for 5204686
1206: l_enforce_shipmethod VARCHAR2(1) ;

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

1511: END IF;
1512: IF (l_return_status=fnd_api.g_ret_sts_success) THEN
1513: l_count:=0;
1514:
1515: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1516: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1517: l_count := l_count + 1;
1518: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1519: END IF;

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

1512: IF (l_return_status=fnd_api.g_ret_sts_success) THEN
1513: l_count:=0;
1514:
1515: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1516: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1517: l_count := l_count + 1;
1518: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1519: END IF;
1520: END LOOP;

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

1514:
1515: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1516: IF (WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) THEN
1517: l_count := l_count + 1;
1518: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
1519: END IF;
1520: END LOOP;
1521: IF (l_debug = 1) THEN
1522: debug('before calling process shipping warning msgs','ship_confirm');

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

1530: FOR i in 1..l_msg_table.count LOOP
1531: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
1532: --l_error_exists := TRUE;
1533: l_return_status:=fnd_api.g_ret_sts_error;
1534: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1535: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1536: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1537: END IF;
1538: END LOOP;

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

1531: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
1532: --l_error_exists := TRUE;
1533: l_return_status:=fnd_api.g_ret_sts_error;
1534: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1535: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1536: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1537: END IF;
1538: END LOOP;
1539: END IF;

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

1532: --l_error_exists := TRUE;
1533: l_return_status:=fnd_api.g_ret_sts_error;
1534: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
1535: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
1536: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
1537: END IF;
1538: END LOOP;
1539: END IF;
1540: END LOOP;

Line 5343: l_invpcinrectype wsh_integration.invpcinrectype;

5339: l_item_reservable NUMBER;
5340: l_lot_control_code NUMBER;
5341: l_serial_number_control_code NUMBER;
5342: l_shipping_attr wsh_interface.changedattributetabtype;
5343: l_invpcinrectype wsh_integration.invpcinrectype;
5344: l_rsv_index NUMBER;
5345: l_rsv_qty NUMBER;
5346: l_rsv_sec_qty NUMBER;
5347: l_return NUMBER;

Line 6102: wsh_integration.set_inv_pc_attributes(

6098: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6099: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6100: END IF;
6101:
6102: wsh_integration.set_inv_pc_attributes(
6103: p_in_attributes => l_invpcinrectype
6104: , x_return_status => l_return_status
6105: , x_msg_count => l_msg_data
6106: , x_msg_data => l_msg_count

Line 6445: WSH_INTEGRATION.Set_INV_PC_Attributes(

6441: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6442: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6443: END IF;
6444:
6445: WSH_INTEGRATION.Set_INV_PC_Attributes(
6446: p_in_attributes => l_invpcinrectype
6447: , x_return_status => l_return_status
6448: , x_msg_count => l_msg_data
6449: , x_msg_data => l_msg_count );

Line 6506: wsh_integration.set_inv_pc_attributes(

6502: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6503: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6504: END IF;
6505:
6506: wsh_integration.set_inv_pc_attributes(
6507: p_in_attributes => l_invpcinrectype
6508: , x_return_status => l_return_status
6509: , x_msg_count => l_msg_data
6510: , x_msg_data => l_msg_count

Line 6902: wsh_integration.set_inv_pc_attributes(

6898: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
6899: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6900: END IF;
6901:
6902: wsh_integration.set_inv_pc_attributes(
6903: p_in_attributes => l_invpcinrectype
6904: , x_return_status => l_return_status
6905: , x_msg_count => l_msg_data
6906: , x_msg_data => l_msg_count

Line 7170: WSH_INTEGRATION.Set_INV_PC_Attributes(

7166: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
7167: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
7168: END IF;
7169:
7170: WSH_INTEGRATION.Set_INV_PC_Attributes(
7171: p_in_attributes => l_invpcinrectype
7172: , x_return_status => l_return_status
7173: , x_msg_count => l_msg_data
7174: , x_msg_data => l_msg_count );

Line 7228: wsh_integration.set_inv_pc_attributes(

7224: DEBUG('Calling Set_Inv_PC_Attributes transaction_temp_id=' ||
7225: l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
7226: END IF;
7227:
7228: wsh_integration.set_inv_pc_attributes(
7229: p_in_attributes => l_invpcinrectype
7230: , x_return_status => l_return_status
7231: , x_msg_count => l_msg_data
7232: , x_msg_data => l_msg_count

Line 12518: l_minmaxinrectype wsh_integration.minmaxinrectype;

12514: l_order_header_id NUMBER;
12515:
12516: /* Commented for bug 5262108
12517: -- to query tolerance
12518: l_minmaxinrectype wsh_integration.minmaxinrectype;
12519: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
12520: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
12521: l_max_shippable_quantity NUMBER;
12522: l_max_shippable_sec_qty NUMBER;

Line 12519: l_minmaxoutrectype wsh_integration.minmaxoutrectype;

12515:
12516: /* Commented for bug 5262108
12517: -- to query tolerance
12518: l_minmaxinrectype wsh_integration.minmaxinrectype;
12519: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
12520: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
12521: l_max_shippable_quantity NUMBER;
12522: l_max_shippable_sec_qty NUMBER;
12523: l_total_resvd_qty NUMBER;

Line 12520: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */

12516: /* Commented for bug 5262108
12517: -- to query tolerance
12518: l_minmaxinrectype wsh_integration.minmaxinrectype;
12519: l_minmaxoutrectype wsh_integration.minmaxoutrectype;
12520: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
12521: l_max_shippable_quantity NUMBER;
12522: l_max_shippable_sec_qty NUMBER;
12523: l_total_resvd_qty NUMBER;
12524: l_total_resvd_sec_qty NUMBER;