DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_INTEGRATION

Line 2965: l_msg_table WSH_INTEGRATION.MSG_TABLE ;

2961:
2962: x_unassigned_cont wsh_util_core.id_tab_type;
2963: l_msg_rec_count wsh_util_core.MsgCountType;
2964: l_error_exists BOOLEAN;
2965: l_msg_table WSH_INTEGRATION.MSG_TABLE ;
2966: l_count NUMBER := 0;
2967: l_cont_name VARCHAR2(100);
2968: l_empty_container NUMBER;
2969: l_delivery_name VARCHAR2(100);

Line 6531: -- Bug 2942938: select all the 'W' message type from WSH_INTEGRATION.G_MSG_TABLE

6527:
6528: /* Bug 2761304: Changed the following conditon from '=' to '>='. */
6529:
6530: IF (l_num_error >= 0) AND (l_wms_enabled_flag) THEN
6531: -- Bug 2942938: select all the 'W' message type from WSH_INTEGRATION.G_MSG_TABLE
6532: -- also select hold 'E' messages for WMS org, since hold errors
6533: -- bug 3455640 added 'WSH_INVALID_CATCHWEIGHT'
6534: -- should prevent the delivery from being ship confirmed, not just unassign
6535: -- the delivery details

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

6533: -- bug 3455640 added 'WSH_INVALID_CATCHWEIGHT'
6534: -- should prevent the delivery from being ship confirmed, not just unassign
6535: -- the delivery details
6536: l_count := 0;
6537: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6538: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6539: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6540: 'WSH_HEADER_HOLD_ERROR',
6541: 'WSH_SHIP_LINE_HOLD_ERROR',

Line 6538: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR

6534: -- should prevent the delivery from being ship confirmed, not just unassign
6535: -- the delivery details
6536: l_count := 0;
6537: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6538: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6539: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6540: 'WSH_HEADER_HOLD_ERROR',
6541: 'WSH_SHIP_LINE_HOLD_ERROR',
6542: 'WSH_DET_CREDIT_HOLD_ERROR',

Line 6539: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (

6535: -- the delivery details
6536: l_count := 0;
6537: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6538: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6539: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6540: 'WSH_HEADER_HOLD_ERROR',
6541: 'WSH_SHIP_LINE_HOLD_ERROR',
6542: 'WSH_DET_CREDIT_HOLD_ERROR',
6543: 'WSH_INVALID_CATCHWEIGHT') ) THEN

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

6541: 'WSH_SHIP_LINE_HOLD_ERROR',
6542: 'WSH_DET_CREDIT_HOLD_ERROR',
6543: 'WSH_INVALID_CATCHWEIGHT') ) THEN
6544: l_count := l_count + 1;
6545: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
6546: IF l_debug_on THEN
6547: WSH_DEBUG_SV.logmsg(l_module_name,'Msg '||i||' : '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE||' '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME,WSH_DEBUG_SV.C_PROC_LEVEL);
6548: END IF;
6549: END IF;

Line 6547: WSH_DEBUG_SV.logmsg(l_module_name,'Msg '||i||' : '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE||' '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME,WSH_DEBUG_SV.C_PROC_LEVEL);

6543: 'WSH_INVALID_CATCHWEIGHT') ) THEN
6544: l_count := l_count + 1;
6545: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
6546: IF l_debug_on THEN
6547: WSH_DEBUG_SV.logmsg(l_module_name,'Msg '||i||' : '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE||' '||WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME,WSH_DEBUG_SV.C_PROC_LEVEL);
6548: END IF;
6549: END IF;
6550: END LOOP;
6551: -- Call WMS api to process the table of l_msg_table only for wms enabled org

Line 6561: -- WSH_INTEGRATION.G_MSG_TABLE

6557: x_shipping_msg_tab => l_msg_table);
6558:
6559: -- Check if there exists an 'E' message in the l_msg_table
6560: -- If there is then turn the message type to 'E' for the particular message name in
6561: -- WSH_INTEGRATION.G_MSG_TABLE
6562: FOR i in 1..l_msg_table.count LOOP
6563: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6564: l_error_exists := TRUE;
6565: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP

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

6561: -- WSH_INTEGRATION.G_MSG_TABLE
6562: FOR i in 1..l_msg_table.count LOOP
6563: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6564: l_error_exists := TRUE;
6565: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6566: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6567: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6568: END IF;
6569: END LOOP;

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

6562: FOR i in 1..l_msg_table.count LOOP
6563: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6564: l_error_exists := TRUE;
6565: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6566: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6567: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6568: END IF;
6569: END LOOP;
6570: END IF;

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

6563: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6564: l_error_exists := TRUE;
6565: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6566: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6567: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6568: END IF;
6569: END LOOP;
6570: END IF;
6571: END LOOP;

Line 6574: -- Call Store_Msg_In_Table Api to push the messages in WSH_INTEGRATION.G_MSG_TABLE to fnd stack

6570: END IF;
6571: END LOOP;
6572: l_msg_table.delete;
6573: END IF;
6574: -- Call Store_Msg_In_Table Api to push the messages in WSH_INTEGRATION.G_MSG_TABLE to fnd stack
6575: WSH_UTIL_CORE.Store_Msg_In_Table (p_store_flag => FALSE,
6576: x_msg_rec_count => l_msg_rec_count,
6577: x_return_status => l_return_status);
6578: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 7678: WSH_INTEGRATION.DBI_Update_Detail_Log

7674: -- DBI API will check if DBI is installed
7675: IF l_debug_on THEN
7676: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);
7677: END IF;
7678: WSH_INTEGRATION.DBI_Update_Detail_Log
7679: (p_delivery_detail_id_tab => l_detail_tab,
7680: p_dml_type => 'UPDATE',
7681: x_return_status => l_dbi_rs);
7682: