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_SHIPMENT_REQUEST_PKG dependencies on WSH_INTERFACE_ERRORS

Line 778: -- logged in Wsh_Interface_Errors table.

774: -- OE_ORDER_GRP.Process_Order to Create/Update/Cancel Sales Order.
775: -- Attributes related to shipping are validated, If PO group api returns
776: -- success.
777: -- If PO group api returns error then corresponding error messages are
778: -- logged in Wsh_Interface_Errors table.
779: --=============================================================================
780: --
781: PROCEDURE Process_Shipment_Request (
782: p_transaction_rec IN WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,

Line 1127: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Delivery Interface)');

1123:
1124: --
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_del_details_interface, wsh_del_assgn_interface Records');
1127: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Delivery Interface)');
1128: END IF;
1129: --
1130:
1131: SELECT wie.interface_error_id

Line 1133: FROM wsh_interface_errors wie,

1129: --
1130:
1131: SELECT wie.interface_error_id
1132: BULK COLLECT INTO l_del_interface_error_tbl
1133: FROM wsh_interface_errors wie,
1134: wsh_transactions_history wth
1135: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1136: AND wie.interface_action_code = g_interface_action_code
1137: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )

Line 1147: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');

1143: FOR UPDATE NOWAIT;
1144:
1145: --
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');
1148: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Detail Interface)');
1149: END IF;
1150: --
1151:

Line 1148: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Detail Interface)');

1144:
1145: --
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');
1148: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Detail Interface)');
1149: END IF;
1150: --
1151:
1152: SELECT wie.interface_error_id

Line 1154: FROM wsh_interface_errors wie

1150: --
1151:
1152: SELECT wie.interface_error_id
1153: BULK COLLECT INTO l_det_interface_error_tbl
1154: FROM wsh_interface_errors wie
1155: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
1156: AND interface_action_code = g_interface_action_code
1157: AND interface_id in
1158: ( select wddi.delivery_detail_interface_id

Line 1174: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Detail Interface)');

1170: AND wdai.delivery_interface_id = to_number(wth.entity_number) )
1171: FOR UPDATE NOWAIT;
1172:
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Detail Interface)');
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN RECORD_LOCKED THEN

Line 2350: WSH_DEBUG_SV.log(l_module_name, 'Querying wsh_interface_errors Records (For Delivery Interface)', l_entity_number);

2346: END IF;
2347:
2348: --
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.log(l_module_name, 'Querying wsh_interface_errors Records (For Delivery Interface)', l_entity_number);
2351: END IF;
2352: --
2353:
2354: --Flushing following arrays since it contains interface errors of Current/Existing document revisions

Line 2361: FROM wsh_interface_errors wie

2357:
2358: --Querying interface errors of Current processing document revision - Start
2359: SELECT wie.interface_error_id
2360: BULK COLLECT INTO l_del_interface_error_tbl
2361: FROM wsh_interface_errors wie
2362: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
2363: AND wie.interface_action_code = g_interface_action_code
2364: AND wie.interface_id = l_entity_number;
2365:

Line 2368: WSH_DEBUG_SV.logmsg(l_module_name, 'Queried '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');

2364: AND wie.interface_id = l_entity_number;
2365:
2366: --
2367: IF l_debug_on THEN
2368: WSH_DEBUG_SV.logmsg(l_module_name, 'Queried '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');
2369: WSH_DEBUG_SV.log(l_module_name, 'Querying wsh_interface_errors Records (For Detail Interface)', l_entity_number);
2370: END IF;
2371: --
2372:

Line 2369: WSH_DEBUG_SV.log(l_module_name, 'Querying wsh_interface_errors Records (For Detail Interface)', l_entity_number);

2365:
2366: --
2367: IF l_debug_on THEN
2368: WSH_DEBUG_SV.logmsg(l_module_name, 'Queried '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Delivery Interface)');
2369: WSH_DEBUG_SV.log(l_module_name, 'Querying wsh_interface_errors Records (For Detail Interface)', l_entity_number);
2370: END IF;
2371: --
2372:
2373: SELECT wie.interface_error_id

Line 2375: FROM wsh_interface_errors wie

2371: --
2372:
2373: SELECT wie.interface_error_id
2374: BULK COLLECT INTO l_det_interface_error_tbl
2375: FROM wsh_interface_errors wie
2376: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
2377: AND interface_action_code = g_interface_action_code
2378: AND interface_id in
2379: ( select wddi.delivery_detail_interface_id

Line 2388: WSH_DEBUG_SV.logmsg(l_module_name, 'Queried '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Detail Interface)');

2384: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
2385: AND wdai.delivery_interface_id = l_entity_number );
2386:
2387: IF l_debug_on THEN
2388: WSH_DEBUG_SV.logmsg(l_module_name, 'Queried '||SQL%ROWCOUNT||' wsh_interface_errors Records (For Detail Interface)');
2389: END IF;
2390: --Querying interface errors of Current processing document revision - End
2391:
2392: --