[Home] [Help]
1151: END IF;
1152:
1153: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1154:
1155: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
1156: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
1157:
1158: IF l_debug_on THEN
1159: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
2851: WV_FROZEN_FLAG,
2852: --Bug 3458160
2853: SHIPMENT_DIRECTION,
2854: DELIVERED_DATE
2855: FROM WSH_NEW_DEL_INTERFACE
2856: WHERE delivery_interface_id = p_delivery_interface_id
2857: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2858:
2859: cursor get_carrier ( p_carrier_name in varchar2 ) is
3044: --}
3045: END IF;
3046: IF ( l_log_error_flag = 'Y') THEN
3047: --{
3048: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3049: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3050: Log_Errors(
3051: p_loc_interface_errors_rec => l_loc_interface_error_rec,
3052: p_api_name =>'Process_Interfaced_Deliveries, Action=UPDATE' ,
3278:
3279: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3280: THEN
3281: -- {
3282: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3283: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3284: --
3285: Log_Errors(
3286: p_loc_interface_errors_rec => l_loc_interface_error_rec,
3318: x_dlvy_id := l_dlvy_out_rec_tab(l_dlvy_out_rec_tab.first).delivery_id;
3319:
3320: -- TPW - Distributed changes
3321: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN
3322: update wsh_new_del_interface
3323: set delivery_id = x_dlvy_id
3324: where delivery_interface_id = p_delivery_interface_id;
3325:
3326: UPDATE wsh_del_legs_interface
3458: gross_weight,
3459: net_weight,
3460: volume,
3461: wv_frozen_flag
3462: FROM wsh_new_del_interface
3463: WHERE delivery_interface_id = p_delivery_interface_id
3464: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3465:
3466: cursor org_del_id(c_del_id IN NUMBER) IS
3542: wsh_debug_sv.log (l_module_name,'Return status from lock delivery and details', l_return_status);
3543: END IF;
3544:
3545: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
3546: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3547: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3548: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
3549:
3550: Log_Errors(
3570: wsh_debug_sv.log (l_module_name,'Return status from Lock_Delivery_Details', l_return_status);
3571: END IF;
3572:
3573: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
3574: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3575: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3576: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
3577:
3578: Log_Errors(
3674: END IF;
3675:
3676: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3677:
3678: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3679: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3680:
3681: IF l_debug_on THEN
3682: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
3925: END IF;
3926: ELSIF(p_delivery_interface_id IS NOT NULL) THEN
3927: l_entity_interface_id := p_delivery_interface_id;
3928: SELECT delivery_id INTO l_delivery_id
3929: FROM wsh_new_del_interface
3930: WHERE delivery_interface_id = p_delivery_interface_id
3931: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3932:
3933: IF l_debug_on THEN
4199: -- For 940 inbound - cancel case, there may not be any
4200: -- data in interface tables.
4201:
4202: IF(p_delivery_interface_id IS NOT NULL) THEN
4203: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
4204: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
4205:
4206: Log_Errors(
4207: p_loc_interface_errors_rec => l_loc_interface_error_rec,