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.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_INTEGRATION

Line 2927: l_msg_table WSH_INTEGRATION.MSG_TABLE ;

2923:
2924: x_unassigned_cont wsh_util_core.id_tab_type;
2925: l_msg_rec_count wsh_util_core.MsgCountType;
2926: l_error_exists BOOLEAN;
2927: l_msg_table WSH_INTEGRATION.MSG_TABLE ;
2928: l_count NUMBER := 0;
2929: l_cont_name VARCHAR2(100);
2930: l_empty_container NUMBER;
2931: l_delivery_name VARCHAR2(100);

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

6387:
6388: /* Bug 2761304: Changed the following conditon from '=' to '>='. */
6389:
6390: IF (l_num_error >= 0) AND (l_wms_enabled_flag) THEN
6391: -- Bug 2942938: select all the 'W' message type from WSH_INTEGRATION.G_MSG_TABLE
6392: -- also select hold 'E' messages for WMS org, since hold errors
6393: -- bug 3455640 added 'WSH_INVALID_CATCHWEIGHT'
6394: -- should prevent the delivery from being ship confirmed, not just unassign
6395: -- the delivery details

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

6393: -- bug 3455640 added 'WSH_INVALID_CATCHWEIGHT'
6394: -- should prevent the delivery from being ship confirmed, not just unassign
6395: -- the delivery details
6396: l_count := 0;
6397: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6398: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6399: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6400: 'WSH_HEADER_HOLD_ERROR',
6401: 'WSH_SHIP_LINE_HOLD_ERROR',

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

6394: -- should prevent the delivery from being ship confirmed, not just unassign
6395: -- the delivery details
6396: l_count := 0;
6397: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6398: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6399: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6400: 'WSH_HEADER_HOLD_ERROR',
6401: 'WSH_SHIP_LINE_HOLD_ERROR',
6402: 'WSH_DET_CREDIT_HOLD_ERROR',

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

6395: -- the delivery details
6396: l_count := 0;
6397: FOR i in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6398: IF ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_TYPE = 'W' ) OR
6399: ( WSH_INTEGRATION.G_MSG_TABLE(i).MESSAGE_NAME in (
6400: 'WSH_HEADER_HOLD_ERROR',
6401: 'WSH_SHIP_LINE_HOLD_ERROR',
6402: 'WSH_DET_CREDIT_HOLD_ERROR',
6403: 'WSH_INVALID_CATCHWEIGHT') ) THEN

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

6401: 'WSH_SHIP_LINE_HOLD_ERROR',
6402: 'WSH_DET_CREDIT_HOLD_ERROR',
6403: 'WSH_INVALID_CATCHWEIGHT') ) THEN
6404: l_count := l_count + 1;
6405: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
6406: IF l_debug_on THEN
6407: 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);
6408: END IF;
6409: END IF;

Line 6407: 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);

6403: 'WSH_INVALID_CATCHWEIGHT') ) THEN
6404: l_count := l_count + 1;
6405: l_msg_table(l_count) := WSH_INTEGRATION.G_MSG_TABLE(i);
6406: IF l_debug_on THEN
6407: 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);
6408: END IF;
6409: END IF;
6410: END LOOP;
6411: -- Call WMS api to process the table of l_msg_table only for wms enabled org

Line 6421: -- WSH_INTEGRATION.G_MSG_TABLE

6417: x_shipping_msg_tab => l_msg_table);
6418:
6419: -- Check if there exists an 'E' message in the l_msg_table
6420: -- If there is then turn the message type to 'E' for the particular message name in
6421: -- WSH_INTEGRATION.G_MSG_TABLE
6422: FOR i in 1..l_msg_table.count LOOP
6423: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6424: l_error_exists := TRUE;
6425: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP

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

6421: -- WSH_INTEGRATION.G_MSG_TABLE
6422: FOR i in 1..l_msg_table.count LOOP
6423: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6424: l_error_exists := TRUE;
6425: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6426: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6427: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6428: END IF;
6429: END LOOP;

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

6422: FOR i in 1..l_msg_table.count LOOP
6423: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6424: l_error_exists := TRUE;
6425: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6426: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6427: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6428: END IF;
6429: END LOOP;
6430: END IF;

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

6423: IF ( l_msg_table(i).MESSAGE_TYPE = 'E' ) THEN
6424: l_error_exists := TRUE;
6425: FOR j in 1..WSH_INTEGRATION.G_MSG_TABLE.COUNT LOOP
6426: IF (l_msg_table(i).message_name = WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_NAME) THEN
6427: WSH_INTEGRATION.G_MSG_TABLE(j).MESSAGE_TYPE := 'E';
6428: END IF;
6429: END LOOP;
6430: END IF;
6431: END LOOP;

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

6430: END IF;
6431: END LOOP;
6432: l_msg_table.delete;
6433: END IF;
6434: -- Call Store_Msg_In_Table Api to push the messages in WSH_INTEGRATION.G_MSG_TABLE to fnd stack
6435: WSH_UTIL_CORE.Store_Msg_In_Table (p_store_flag => FALSE,
6436: x_msg_rec_count => l_msg_rec_count,
6437: x_return_status => l_return_status);
6438: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 7528: WSH_INTEGRATION.DBI_Update_Detail_Log

7524: -- DBI API will check if DBI is installed
7525: IF l_debug_on THEN
7526: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);
7527: END IF;
7528: WSH_INTEGRATION.DBI_Update_Detail_Log
7529: (p_delivery_detail_id_tab => l_detail_tab,
7530: p_dml_type => 'UPDATE',
7531: x_return_status => l_dbi_rs);
7532: