[Home] [Help]
327: -- success means all groups have been released.
328: -- warning means at least one group is released and at least one
329: -- group failed.
330: -- error means all groups failed.
331: -- caller needs to look at WSH_INTERFACE_ERRORS
332: -- to check for groups that failed.
333: --
334: -- Description:
335: -- Reconciliate shipping data with the transportation
652: -- Parameters:
653: -- p_group_ids list of group_ids to purge their
654: -- WSH_TRIPS_INTERFACE records and
655: -- their associated tables' records.
656: -- WSH_INTERFACE_ERRORS will be purged.
657: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit
658: -- x_return_status return status
659: --
660: -- Description:
792: where wti.group_id = p_group_ids(i)
793: and wti.INTERFACE_ACTION_CODE = G_TP_RELEASE_CODE;
794:
795:
796: -- Purge wsh_interface_errors
797:
798: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
799: delete from wsh_interface_errors wie
800: where wie.interface_error_group_id = p_group_ids(i)
795:
796: -- Purge wsh_interface_errors
797:
798: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
799: delete from wsh_interface_errors wie
800: where wie.interface_error_group_id = p_group_ids(i)
801: and wie.interface_action_code = G_TP_RELEASE_CODE;
802:
803:
849: -- x_delivery_unassigns list of delivery lines to unassign from their deliveries
850: -- x_trip_unassigns list of deliveries to unassign from their trips
851: -- x_obsoleted_stops list of mapped trips' stops that are not mapped in the plan
852: -- x_obsoleted_trip_moves list of mapped trips' moves that are not mapped in the plan
853: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
854: -- x_return_status return status
855: --
856: -- Description:
857: -- Clears the message stack and context at the beginning
953: --
954: -- Procedure: resync_interface_tables
955: -- Parameters:
956: -- x_context context in this session
957: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
958: -- x_return_status return status
959: --
960: -- Description:
961: -- Resynchronizes the interface tables' records with their base table records'
1474: -- x_delivery_unassigns list of delivery lines to unassign from their deliveries
1475: -- x_trip_unassigns list of deliveries to unassign from their trips
1476: -- x_obsoleted_stops list of mapped trips' stops that are not mapped in the plan
1477: -- x_obsoleted_trip_moves list of mapped trips' moves that are not mapped in the plan
1478: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
1479: -- x_return_status return status
1480: --
1481: -- Description:
1482: -- Maps the interface records to their base records and locks them:
4407: -- x_used_details list of delivery details partially used by the plan
4408: -- x_delivery_unassigns list of delivery lines to unassign from their deliveries
4409: -- x_trip_unassigns list of deliveries to unassign from their trips
4410: -- x_obsoleted_stops list of mapped trips' stops that are not mapped in the plan
4411: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
4412: -- x_return_status return status
4413: --
4414: -- Description:
4415: -- * Perform general validation checks on the plan not
4609: -- x_delivery_unassigns list of delivery lines to unassign from their deliveries
4610: -- x_trip_unassigns list of deliveries to unassign from their trips
4611: -- x_obsoleted_stops list of mapped trips' stops that are not mapped in the plan
4612: -- x_obsoleted_trip_moves list of mapped trips' moves that are not mapped in the plan
4613: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
4614: -- x_return_status return status
4615: --
4616: -- Description:
4617: -- Implement the plan by calling group APIs:
4686: l_number_of_warnings NUMBER;
4687: l_number_of_errors NUMBER;
4688: l_msg_data VARCHAR2(32767);
4689: l_msg_count NUMBER;
4690: l_interface_entity WSH_INTERFACE_ERRORS.INTERFACE_TABLE_NAME%TYPE;
4691: l_interface_id NUMBER;
4692:
4693: l_temp_delivery_index NUMBER;
4694:
6531: -- x_plan_trips list of trips mapped to interface trips
6532: -- x_trip_unassigns list of trip unassignments to check for empty stops/trips to delete
6533: -- x_obsoleted_trip_moves list of obsoleted moves that might have empty trips
6534: -- belonging to an obsoleted move.
6535: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
6536: -- x_return_status return status
6537: --
6538: -- Description:
6539: -- Clean up the shipping data not used by the plan and log exceptions as needed:
7727: -- x_context context in this session
7728: -- x_current_used_details current list of fully and partially used details
7729: -- which will be deleted when the procedure returns.
7730: -- x_used_details master list of partially used details
7731: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
7732: -- x_return_status return status
7733: -- Description:
7734: -- Flushes the current list, adding only partially used details
7735: -- to the master list.
7828: -- Parameters:
7829: -- x_context context in this session
7830: -- p_delivery_index index into x_plan_deliveries to map dangling containers
7831: -- x_plan_deliveries list of deliveries mapped to interface deliveries
7832: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
7833: -- x_return_status return status
7834: --
7835: -- Description:
7836: -- Maps and locks all containers of a delivery that have no plan lines.
8098: -- x_track_conts list of topmost containers to track
8099: -- x_plan_deliveries list of deliveries mapped to interface deliveries
8100: -- x_used_details list of delivery details partially used by the plan
8101: -- x_delivery_unassigns list of delivery lines to unassign from their deliveries
8102: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
8103: -- x_return_status return status
8104: --
8105: -- Description:
8106: -- Goes through each mapped delivery (with lines) to identify details
8481: -- x_context context in this session
8482: -- x_plan_details list of delivery details mapped to interface lines
8483: -- x_plan_deliveries list of deliveries mapped to interface deliveries
8484: -- x_delivery_unassigns list of details to unassign in order to validate LPN unassignments
8485: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
8486: -- x_return_status return status
8487: --
8488: -- Description: Validate that the plan will not affect WMS data.
8489: -- 1. call WMS to validate the lines released to warehouse that will go into each
8852: -- x_plan_stops list of stops mapped to interface stops
8853: -- x_plan_trips list of trips mapped to interface trips
8854: -- x_trip_unassigns list of deliveries to unassign from their trips
8855: -- x_obsoleted_stops list of mapped trips' stops that are not mapped in the plan
8856: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
8857: -- x_return_status return status
8858: --
8859: -- Description:
8860: -- Goes through each mapped trip to identify deliveries
10143: -- Parameters:
10144: -- p_phase value 1 = create or update with NULL lane_id
10145: -- value 2 = update with lane_id
10146: -- x_plan_trips list of plan trips
10147: -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
10148: -- x_return_status return status
10149: -- Description:
10150: -- in phase 1, create or update trips with NULL lane_id.
10151: -- in phase 2, update trips with lane_id.
10171: l_number_of_warnings NUMBER;
10172: l_number_of_errors NUMBER;
10173: l_msg_data VARCHAR2(32767);
10174: l_msg_count NUMBER;
10175: l_interface_entity WSH_INTERFACE_ERRORS.INTERFACE_TABLE_NAME%TYPE;
10176: l_interface_id NUMBER;
10177: --
10178: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
10179: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
10350: -- p_token_3_name optional token 3 name
10351: -- p_token_3_value optional token 3 value
10352: -- p_token_4_name optional token 4 name
10353: -- p_token_4_value optional token 4 value
10354: -- p_errors_tab list of errors to insert into wsh_interface_errors at the end
10355: -- x_return_status return status
10356: --
10357: -- Description:
10358: -- puts the error information into the list p_errors_tab
10508:
10509: --
10510: -- Procedure: insert_interface_errors
10511: -- Parameters:
10512: -- p_errors_tab list of errors to insert into wsh_interface_errors[
10513: -- x_return_status return status
10514: --
10515: -- Description:
10516: -- does a bulk-insert of error records into wsh_interface_errors
10512: -- p_errors_tab list of errors to insert into wsh_interface_errors[
10513: -- x_return_status return status
10514: --
10515: -- Description:
10516: -- does a bulk-insert of error records into wsh_interface_errors
10517: --
10518: PROCEDURE insert_interface_errors(
10519: p_errors_tab IN interface_errors_tab_type,
10520: x_return_status OUT NOCOPY VARCHAR2)
10518: PROCEDURE insert_interface_errors(
10519: p_errors_tab IN interface_errors_tab_type,
10520: x_return_status OUT NOCOPY VARCHAR2)
10521: IS
10522: TYPE text_tab_type IS TABLE OF WSH_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE INDEX BY BINARY_INTEGER;
10523: --
10524: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_INTERFACE_ERRORS';
10525: --
10526: l_debug_on BOOLEAN;
10555: l_messages(i) := p_errors_tab(i).ERROR_MESSAGE;
10556: END LOOP;
10557:
10558: FORALL i IN l_groups.FIRST .. l_groups.LAST
10559: INSERT INTO WSH_INTERFACE_ERRORS (
10560: INTERFACE_ERROR_ID,
10561: INTERFACE_ERROR_GROUP_ID,
10562: INTERFACE_TABLE_NAME,
10563: INTERFACE_ID,
10568: CREATED_BY,
10569: LAST_UPDATE_DATE,
10570: LAST_UPDATED_BY)
10571: VALUES (
10572: WSH_INTERFACE_ERRORS_S.nextval,
10573: l_groups(i),
10574: l_table_names(i),
10575: l_interface_ids(i),
10576: G_TP_RELEASE_CODE,