[Home] [Help]
415: GOTO group_error;
416: END IF;
417:
418:
419: -- update wsh_del_details_interface
420: -- with current source_line_set and source_line_id of
421: -- delivery details that were snapshot or their associated details.
422: Resync_Interface_Tables(
423: x_context => l_context,
683: --
684:
685: SAVEPOINT before_purge;
686:
687: -- Purge wsh_del_details interface.
688: -- Remove usage of distinct in code for Bug 3821688 from each Bulk Delete
689:
690: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
691: delete from wsh_del_details_interface wddi
687: -- Purge wsh_del_details interface.
688: -- Remove usage of distinct in code for Bug 3821688 from each Bulk Delete
689:
690: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
691: delete from wsh_del_details_interface wddi
692: where wddi.delivery_detail_interface_id in (
693: select wdai.delivery_detail_interface_id
694: from wsh_trips_interface wti,
695: wsh_trip_stops_interface wtsi,
993: from wsh_trips_interface wti,
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
1124: from wsh_trips_interface wti,
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
1254:
1255: IF l_notfound THEN
1256: -- if still not found, this line cannot be mapped or handled.
1257: stamp_interface_error(p_group_id => x_context.group_id,
1258: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
1259: p_entity_interface_id => l_dd_interface_id(i),
1260: p_message_name => 'WSH_TP_F_INVALID_DETAIL',
1261: p_token_1_name => 'DETAIL_ID',
1262: p_token_1_value => NVL(l_dd_id(i), l_split_from_dd_id(i)),
1280: END IF;
1281:
1282:
1283: FORALL i in 1..l_dd_interface_id.count
1284: UPDATE wsh_del_details_interface
1285: SET (source_line_id, source_line_set_id, source_header_id) =
1286: (select wdd.source_line_id, wdd.source_line_set_id, wdd.source_header_id
1287: from wsh_delivery_details wdd
1288: where wdd.delivery_detail_id = l_dd_id(i))
1327:
1328: IF l_notfound THEN
1329: -- if not found, this po line shipment cannot be mapped or handled.
1330: stamp_interface_error(p_group_id => x_context.group_id,
1331: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
1332: p_entity_interface_id => l_dd_interface_id(i),
1333: p_message_name => 'WSH_TP_F_INVALID_DETAIL_IB', -- new message
1334: p_token_1_name => 'DETAIL_ID',
1335: p_token_1_value => NVL(l_dd_id(i), l_split_from_dd_id(i)),
1345: END IF;
1346: END LOOP;
1347:
1348: FORALL i in 1..l_dd_interface_id.count
1349: UPDATE wsh_del_details_interface
1350: SET (source_line_id, source_line_set_id, source_header_id, po_shipment_line_id, po_shipment_line_number) =
1351: (select wdd.source_line_id, wdd.source_line_set_id, wdd.source_header_id, po_shipment_line_id, po_shipment_line_number
1352: from wsh_delivery_details wdd
1353: where wdd.delivery_detail_id = l_dd_id(i))
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
1599: AND wti.trip_interface_id = wtsi.trip_interface_id
1600: AND wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: stamp_interface_error(
2468: p_group_id => x_context.group_id,
2469: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2470: p_entity_interface_id => iline.dd_interface_id,
2471: p_message_name => 'WSH_TP_I_NO_LOCK_DD',
2472: p_token_1_name => 'DETAIL_ID',
2473: p_token_1_value => candidate.delivery_detail_id,
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: stamp_interface_error(
2488: p_group_id => x_context.group_id,
2489: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2490: p_entity_interface_id => iline.dd_interface_id,
2491: p_message_name => 'WSH_TP_I_NO_LOCK_DEL',
2492: p_token_1_name => 'DELIVERY_NAME',
2493: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(candidate.delivery_id),
2538: IF l_dummy_dd_id IS NULL THEN
2539: -- order line has not been staged; fail the plan.
2540: stamp_interface_error(
2541: p_group_id => x_context.group_id,
2542: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2543: p_entity_interface_id => iline.dd_interface_id,
2544: p_message_name => 'WSH_TP_F_QTY_INCREASE',
2545: p_token_1_name => 'DETAIL_ID',
2546: p_token_1_value => candidate.delivery_detail_id,
2607: AND x_plan_deliveries(l_current_used_details(l_new_index).target_delivery_index).del_interface_id
2608: <> iline.delivery_interface_id THEN
2609: stamp_interface_error(
2610: p_group_id => x_context.group_id,
2611: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2612: p_entity_interface_id => iline.dd_interface_id,
2613: p_message_name => 'WSH_TP_I_LPN_BREAK',
2614: p_token_1_name => 'DETAIL_ID',
2615: p_token_1_value => candidate.delivery_detail_id,
2628: -- if line is released to warehouse, it cannot be split.
2629: IF candidate.released_status = 'S' THEN
2630: stamp_interface_error(
2631: p_group_id => x_context.group_id,
2632: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2633: p_entity_interface_id => iline.dd_interface_id,
2634: p_message_name => 'WSH_TP_I_SPLIT_RELEASED',
2635: p_token_1_name => 'DETAIL_ID',
2636: p_token_1_value => candidate.delivery_detail_id,
2655: AND (l_current_used_details(l_new_index).released_status
2656: IN ('Y', 'B')) THEN
2657: stamp_interface_error(
2658: p_group_id => x_context.group_id,
2659: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2660: p_entity_interface_id => iline.dd_interface_id,
2661: p_message_name => 'WSH_TP_I_SPLIT_OPM_IND_LOT',
2662: p_token_1_name => 'DETAIL_ID',
2663: p_token_1_value => candidate.delivery_detail_id,
3064: IF l_candidates_count > 0 THEN --[
3065:
3066: stamp_interface_error(
3067: p_group_id => x_context.group_id,
3068: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3069: p_entity_interface_id => iline.dd_interface_id,
3070: p_message_name => 'WSH_TP_I_LINE_LEFTOVER',
3071: p_token_1_name => 'QUANTITY',
3072: p_token_1_value => l_current_attributes.mapped_quantity,
3092: END LOOP;
3093: IF l_dummy_dd_id IS NOT NULL THEN
3094: stamp_interface_error(
3095: p_group_id => x_context.group_id,
3096: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3097: p_entity_interface_id => iline.dd_interface_id,
3098: p_message_name => 'WSH_TP_F_LOC_CHANGE',
3099: x_errors_tab => x_errors_tab,
3100: x_return_status => l_return_status);
3114: END LOOP;
3115: IF l_dummy_dd_id IS NOT NULL THEN
3116: stamp_interface_error(
3117: p_group_id => x_context.group_id,
3118: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3119: p_entity_interface_id => iline.dd_interface_id,
3120: p_message_name => 'WSH_TP_F_IGNORED',
3121: p_token_1_name => 'DETAIL_ID',
3122: p_token_1_value => l_dummy_dd_id,
3138: IF (l_current_attributes.mapped_quantity = iline.quantity)
3139: AND l_group_not_matched THEN
3140: stamp_interface_error(
3141: p_group_id => x_context.group_id,
3142: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3143: p_entity_interface_id => iline.dd_interface_id,
3144: p_message_name => 'WSH_TP_F_NOT_IN_GROUP',
3145: p_token_1_name => 'PLAN_DEL_NUM',
3146: p_token_1_value => x_plan_deliveries(l_target_delivery_index).tp_delivery_number,
3357: AND
3358: (x_plan_deliveries(l_target_delivery_index).wsh_planned_flag <> 'N') THEN
3359: stamp_interface_error(
3360: p_group_id => x_context.group_id,
3361: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3362: p_entity_interface_id => x_used_details(l_new_index).dd_interface_id,
3363: p_message_name => 'WSH_TP_F_FIRM_DEL_UNUSED',
3364: p_token_1_name => 'DELIVERY_NAME',
3365: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(
5267: p_action_prms => l_dd_action_prms,
5268: x_defaults => l_dd_defaults,
5269: x_action_out_rec => l_dd_action_rec);
5270:
5271: l_interface_entity := 'WSH_DEL_DETAILS_INTERFACE';
5272: l_interface_id := x_plan_details(l_index).dd_interface_id;
5273: l_message_name := 'WSH_TP_F_LINE_SPLIT';
5274: wsh_util_core.api_post_call(
5275: p_return_status => l_return_status,
7488: WSH_DEBUG_SV.log(l_module_name, 'Bulk update details: count', l_interface_ids.COUNT);
7489: END IF;
7490:
7491: FORALL i in 1..l_interface_ids.count
7492: UPDATE wsh_del_details_interface
7493: SET delivery_detail_id = l_ids(i),
7494: requested_quantity = l_qtys(i)
7495: WHERE delivery_detail_interface_id = l_interface_ids(i);
7496:
7778: -- also check whether LPN configuration would be broken.
7779: IF x_current_used_details(l_used_index).topmost_cont_id IS NOT NULL THEN
7780: stamp_interface_error(
7781: p_group_id => x_context.group_id,
7782: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
7783: p_entity_interface_id => x_current_used_details(l_used_index).dd_interface_id,
7784: p_message_name => 'WSH_TP_F_LPN_BREAK',
7785: p_token_1_name => 'CONTAINER_NAME',
7786: p_token_1_value => wsh_container_utilities.get_cont_name(
7834: --
7835: -- Description:
7836: -- Maps and locks all containers of a delivery that have no plan lines.
7837: --
7838: -- This is the only time the process looks at plan containers in wsh_del_details_interface.
7839: -- This is to allow TP to release what they snapshot because they may have to
7840: -- capture firm deliveries that have only dangling containers.
7841: --
7842: -- * fail the plan if the contents of TE delivery does not match the plan delivery's contents.
7880: -- currently, TP captures all LPNs within the delivery.
7881: CURSOR c_plan_lpn_count(x_delivery_interface_id IN NUMBER) IS
7882: SELECT count(wddi.delivery_detail_id)
7883: FROM wsh_del_assgn_interface wdai,
7884: wsh_del_details_interface wddi
7885: WHERE wdai.delivery_interface_id = x_delivery_interface_id
7886: AND wdai.delivery_interface_id IS NOT NULL
7887: AND wdai.interface_action_code = G_TP_RELEASE_CODE
7888: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
7893: CURSOR c_plan_lpn(x_delivery_interface_id IN NUMBER,
7894: x_delivery_detail_id IN NUMBER) IS
7895: SELECT wddi.delivery_detail_interface_id
7896: FROM wsh_del_assgn_interface wdai,
7897: wsh_del_details_interface wddi
7898: WHERE wdai.delivery_interface_id = x_delivery_interface_id
7899: AND wdai.delivery_interface_id IS NOT NULL
7900: AND wdai.interface_action_code = G_TP_RELEASE_CODE
7901: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
8741: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8742: IF x_delivery_unassigns(l_indexes(l_dd_index)).plan_dd_index IS NOT NULL THEN
8743: stamp_interface_error(
8744: p_group_id => x_context.group_id,
8745: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
8746: p_entity_interface_id => x_plan_details(x_delivery_unassigns(l_indexes(l_dd_index)).plan_dd_index).dd_interface_id,
8747: p_message_name => l_wms_table(l_dd_index).r_message_code,
8748: p_message_appl => l_wms_table(l_dd_index).r_message_appl,
8749: p_message_text => l_wms_table(l_dd_index).r_message_text,