[Home] [Help]
723: and wdli.interface_action_code = G_TP_RELEASE_CODE)
724: and wdai.interface_action_code = G_TP_RELEASE_CODE;
725:
726:
727: -- Purge wsh_new_del_interface
728:
729: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
730: delete from wsh_new_del_interface wndi
731: where wndi.delivery_interface_id in (
726:
727: -- Purge wsh_new_del_interface
728:
729: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
730: delete from wsh_new_del_interface wndi
731: where wndi.delivery_interface_id in (
732: select wdli.delivery_interface_id
733: from wsh_trips_interface wti,
734: wsh_trip_stops_interface wtsi,
994: wsh_trip_stops_interface wtsi,
995: wsh_del_legs_interface wdli,
996: wsh_del_assgn_interface wdai,
997: wsh_del_details_interface wddi,
998: wsh_new_del_interface wndi
999: where wti.group_id = p_group_id
1000: and wti.trip_interface_id = wtsi.trip_interface_id
1001: and wti.interface_action_code = G_TP_RELEASE_CODE
1002: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1125: wsh_trip_stops_interface wtsi,
1126: wsh_del_legs_interface wdli,
1127: wsh_del_assgn_interface wdai,
1128: wsh_del_details_interface wddi,
1129: wsh_new_del_interface wndi
1130: where wti.group_id = p_group_id
1131: and wti.trip_interface_id = wtsi.trip_interface_id
1132: and wti.interface_action_code = G_TP_RELEASE_CODE
1133: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1590: wndi.delivery_interface_id
1591: FROM wsh_trips_interface wti,
1592: wsh_trip_stops_interface wtsi,
1593: wsh_del_legs_interface wdli,
1594: wsh_new_del_interface wndi,
1595: wsh_del_assgn_interface wdai,
1596: wsh_del_details_interface wddi
1597: WHERE wti.group_id = p_group_id
1598: AND wti.interface_action_code = G_TP_RELEASE_CODE
1683: wnd.wv_frozen_flag -- WV changes
1684: FROM wsh_trips_interface wti,
1685: wsh_trip_stops_interface wtsi,
1686: wsh_del_legs_interface wdli,
1687: wsh_new_del_interface wndi,
1688: wsh_new_deliveries wnd
1689: WHERE wti.group_id = p_group_id
1690: AND wti.interface_action_code = G_TP_RELEASE_CODE
1691: AND wti.trip_interface_id = wtsi.trip_interface_id
3236: -- and none of them has been mapped.
3237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3238: stamp_interface_error(
3239: p_group_id => x_context.group_id,
3240: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
3241: p_entity_interface_id => x_plan_deliveries(l_new_index).del_interface_id,
3242: p_message_name => 'WSH_TP_F_EMPTY_DEL',
3243: p_token_1_name => 'PLAN_DEL_NUM',
3244: p_token_1_value => x_plan_deliveries(l_new_index).tp_delivery_number,
3258: -- containers does not exist or does not have the original firm status.
3259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3260: stamp_interface_error(
3261: p_group_id => x_context.group_id,
3262: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
3263: p_entity_interface_id => x_plan_deliveries(l_new_index).del_interface_id,
3264: p_message_name => 'WSH_TP_F_DANGLING_DEL_DIFF', -- new message
3265: p_token_1_name => 'PLAN_DEL_NUM',
3266: p_token_1_value => x_plan_deliveries(l_new_index).tp_delivery_number,
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: stamp_interface_error(
3776: p_group_id => x_context.group_id,
3777: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
3778: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
3779: p_message_name => 'WSH_TP_F_NO_LOCK_LEGS',
3780: p_token_1_name => 'DELIVERY_NAME',
3781: p_token_1_value =>
4235: IF (NOT l_phys_ult_do_mapped)
4236: AND (x_plan_deliveries(l_plan_del_index).physical_ultimate_do_loc_id IS NOT NULL) THEN
4237: stamp_interface_error(
4238: p_group_id => x_context.group_id,
4239: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
4240: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
4241: p_message_name => 'WSH_TP_F_INT_LOC_CHANGED', --!!! new message
4242: p_token_1_name => 'PLAN_DEL_NUM',
4243: p_token_1_value => x_plan_deliveries(l_plan_del_index).tp_delivery_number,
4295: IF l_snapshot_trip_plan_flags(l_used_index) = 'F' THEN
4296: -- cannot unassign delivery from this routing/contents firmed trip
4297: stamp_interface_error(
4298: p_group_id => x_context.group_id,
4299: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
4300: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
4301: p_message_name => 'WSH_TP_F_TRIP_FIRM_NO_UNASSIGN',
4302: p_token_1_name => 'DELIVERY_NAME',
4303: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),
5038: );
5039:
5040: -- bug 3593690: fail release if delivery cannot be populated
5041: -- usually because shipping parameters are missing.
5042: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5043: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5044: wsh_util_core.api_post_call(
5045: p_return_status => l_return_status,
5046: x_num_warnings => l_number_of_warnings,
5057: x_return_status => l_return_status,
5058: x_msg_count => l_msg_count,
5059: x_msg_data => l_msg_data);
5060:
5061: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5062: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5063: wsh_util_core.api_post_call(
5064: p_return_status => l_return_status,
5065: x_num_warnings => l_number_of_warnings,
5725: END IF;
5726: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5727: END IF;
5728:
5729: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5730: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5731: l_message_name := 'WSH_TP_F_ASSIGN_DEL';
5732: wsh_util_core.api_post_call(
5733: p_return_status => l_return_status,
5744: p_organization_id => x_plan_deliveries(l_index).organization_id,
5745: x_param_info => l_ship_params,
5746: x_return_status => l_return_status);
5747:
5748: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5749: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5750: l_message_name := 'WSH_TP_F_SHIP_PARAMS';
5751: wsh_util_core.api_post_call(
5752: p_return_status => l_return_status,
5766: x_return_status => l_return_status);
5767:
5768: IF NOT l_valid_flag THEN
5769: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5770: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5771: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5772: l_message_name := 'WSH_TP_F_BROKEN_SHIP_SET';
5773: wsh_util_core.api_post_call(
5774: p_return_status => l_return_status,
5782: x_return_status => l_return_status);
5783:
5784: IF NOT l_valid_flag THEN
5785: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5786: l_interface_entity := 'WSH_NEW_DEL_INTERFACE';
5787: l_interface_id := x_plan_deliveries(l_index).del_interface_id;
5788: l_message_name := 'WSH_TP_F_BROKEN_SMC';
5789: wsh_util_core.api_post_call(
5790: p_return_status => l_return_status,
7459: WSH_DEBUG_SV.log(l_module_name, 'Bulk update deliveries: count', l_interface_ids.COUNT);
7460: END IF;
7461:
7462: FORALL i in 1..l_interface_ids.count
7463: UPDATE wsh_new_del_interface
7464: SET delivery_id = l_ids(i)
7465: WHERE delivery_interface_id = l_interface_ids(i);
7466:
7467:
8307: END IF;
8308:
8309: IF NVL(x_plan_deliveries(i).wsh_planned_flag, 'N') <> 'N' THEN
8310: Stamp_Interface_Error(p_group_id => x_context.group_id,
8311: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8312: p_entity_interface_id => x_plan_deliveries(i).del_interface_id,
8313: p_message_name => 'WSH_TP_F_PLAN_DEL_NOT_MATCH',
8314: p_token_1_name => 'DELIVERY_NAME',
8315: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(
8397: -- (backup for the logic in flush_details to set WSH_TP_F_FIRM_DEL_UNUSED)
8398:
8399: IF NVL(x_plan_deliveries(i).wsh_planned_flag, 'N') <> 'N' THEN
8400: Stamp_Interface_Error(p_group_id => x_context.group_id,
8401: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8402: p_entity_interface_id => x_plan_deliveries(i).del_interface_id,
8403: p_message_name => 'WSH_TP_F_PLAN_DEL_NOT_MATCH',
8404: x_errors_tab => x_errors_tab,
8405: x_return_status => x_return_status);
8612: -- per discussion with WMS, this action will not mark lines as
8613: -- having errors, and the message does not have a token.
8614: stamp_interface_error(
8615: p_group_id => x_context.group_id,
8616: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8617: p_entity_interface_id => x_plan_deliveries(l_del_index).del_interface_id,
8618: p_message_name => l_wms_table(1).r_message_code,
8619: p_message_appl => l_wms_table(1).r_message_appl,
8620: p_message_text => l_wms_table(1).r_message_text,
8622: x_return_status => l_discard_rs);
8623:
8624: stamp_interface_error(
8625: p_group_id => x_context.group_id,
8626: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8627: p_entity_interface_id => x_plan_deliveries(l_del_index).del_interface_id,
8628: p_message_name => 'WSH_TP_F_WMS_REL_LPN_BREAK',
8629: p_token_1_name => 'PLAN_TRIP_NUM',
8630: p_token_1_value => get_plan_trip_num(x_context),
8753: x_return_status => l_discard_rs);
8754: ELSIF x_delivery_unassigns(l_indexes(l_dd_index)).plan_del_index IS NOT NULL THEN
8755: stamp_interface_error(
8756: p_group_id => x_context.group_id,
8757: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8758: p_entity_interface_id => x_plan_deliveries(x_delivery_unassigns(l_indexes(l_dd_index)).plan_del_index).del_interface_id,
8759: p_message_name => l_wms_table(l_dd_index).r_message_code,
8760: p_message_appl => l_wms_table(l_dd_index).r_message_appl,
8761: p_message_text => l_wms_table(l_dd_index).r_message_text,