API RF SCE_GP_008

Package : Standard

Nom de la gnc : gnc_sce_gp_008

gnc_ue_palettiser

1/

The control:

If the parcel is not pure (LCOL.flgue != ‘0’), the API returns an error code 0 and an error message “LOG_COLPUR”.

Was changed with:

If the parcel data is not from parcel type (lcol.flgcolis != ‘1’), the API returns an error code 0 and an error message “LOG_COLIS”.

2/

The control:

Else if the parcel is not validated (LCOL.statut != ‘5’), the API returns an error code 0 and an error message “LOG_NONVAL”.

Was changed with:

Else if the parcel is not valid (LCOL.statut != ‘5’ AND lcol.flgue = ‘0’ OR lcol.statut != ‘5’ AND lcol.statut != ‘6’ AND lcol.flgue != ‘0’), the API returns an error code 0 and an error message “LOG_NONVAL”.

3/

The control:

If the expedition tour identifier is not the same for the first preparation unit delivery order headers and for the expedition unit delivery order headers (lole.idtrn), the API returns an error code 0 and an error message “LOG_TRN_ID”.

Was changed with:

If the palettization for the first preparation unit delivery order header is of type ‘5’ (palettis = ‘5’) AND the palettization for the expedition unit delivery order header is of type ‘5’ (palettis = ‘5’) AND (the addressed depot types for the first preparation unit delivery order header and for the expedition unit delivery order header are different (lole.typdest) OR the addressed depot identifiers for the first preparation unit delivery order header and for the expedition unit delivery order header are different (lole.sigdest))

The expedition unit is considered as multi store.

If the expedition tour identifier is not the same for the first preparation unit delivery order header and for the expedition unit delivery order header (LOLE .idtrn) AND the expedition unit is not considered as multi store AND the expedition unit is assigned to an expedition tour (idtrn != ‘0’) AND the palettization for the first preparation unit delivery order header is not of type ‘5’ (palettis != ‘5’) AND the palettization for the expedition unit delivery order header is not of type ‘5’ (palettis != ‘5’)

The API returns an error code 0 and an error message “LOG_TRN_ID”.

The following controls were added.

If there is a preparation unit on the expedition unit.

Else if the palettization must be of type ‘5’ (LOLE .palettis = ‘5’).

If the expedition unit is not assigned to an expedition tour (LCOL.idtrn = 0) AND the first preparation unit is not assigned to an expedition tour (lcol.idtrn = 0).

IF the delivery associated third-party type for the expedition unit and for the first preparation unit is different (lcol.typliv) OR the delivery associated third-party identifier for the expedition unit and for the first preparation unit is different (lcol.sigliv).

The API returns an error code 0 and an error message “L_COL_PAL”.

Else if the expedition unit is not assigned to an expedition tour (lcol.idtrn = 0).

Read the client/expedition tour relation (ltrncli) with the parameters: third party type (lole.typtie) and third party ID (lole.sigtie) from the delivery order header for the first preparation unit, expedition tour ID (LCOL.idtrn) from the first preparation unit, delivery associated third-party type (LCOL.typliv) and delivery associated third-party ID (lcol.sigliv) from the expedition unit.

If the relation is not found, the API returns an error code 0 and an error message “L_COL_PAL”.

Call the function gnc_colis_affect_colis_tournee, as so to affect the parcel to the expedition tour.

If the execution of the function is not successful, the API returns an error code 0 and an error message “L_COL_PAL”.

Else if the first preparation unit is not assigned to an expedition tour (LCOL.idtrn = 0).

Read the client/expedition tour relation (ltrncli) with the parameters: third party type (LOLE.typtie) and third party ID (lole.sigtie) from the delivery order header for the expedition unit, expedition tour ID (LCOL.idtrn) from the expedition unit, delivery associated third-party type (LCOL.typliv) and delivery associated third-party ID (LCOL.sigliv) from the first preparation unit.

If the relation is not found, the API returns an error code 0 and an error message “L_COL_PAL”.

For each preparation unit (LCOL) for the expedition unit (idue=idue input parameter).

Call the function gnc_colis_affect_colis_tournee, as so to affect the parcel to the expedition tour.

If the execution of the function is not successful, the API returns an error code 0 and an error message “L_COL_PAL”.

Else.

Read the client/expedition tour relation (ltrncli) with the parameters: third party type (LOLE.typtie) and third party ID (LOLE.sigtie) from the delivery order header for the expedition unit, expedition tour ID (lcol.idtrn) from the expedition unit, delivery associated third-party type (lcol.typliv) and delivery associated third-party ID (LCOL.sigliv) from the expedition unit.

If the relation is not found, the API returns an error code 0 and an error message “L_COL_PAL”.

Read the client/expedition tour relation (ltrncli) with the parameters: third party type (lole.typtie) and third party ID (LOLE.sigtie) from the delivery order header for the first preparation unit, expedition tour ID (LCOL.idtrn) from the first preparation unit, delivery associated third-party type (lcol.typliv) and delivery associated third-party ID (LCOL.sigliv) from the first preparation unit.

If the relation is not found, the API returns an error code 0 and an error message “L_COL_PAL”.

If the expedition tour identifier is the same for the first preparation unit delivery order header and for the expedition unit delivery order header (LOLE.idtrn) AND the expedition unit is considered as multi store.

If the platform delivery flag for the expedition unit OR for the first preparation unit is not active (ltrncli.livptf != ‘1’).

The API returns an error code 0 and an error message “L_COL_PAL”.

Else if the expedition tour identifier is not the same for the first preparation unit delivery order header and for the expedition unit delivery order header (LOLE.idtrn).

If the platform delivery flag for the expedition unit OR for the first preparation unit is not active (LTRNCLI.livptf != ‘1’) OR the destination depot type (LOLE.typdest) for the delivery order headers of the expedition unit and the first preparation unit is not the same OR the destination depot ID (lole.sigdest) for the delivery order headers of the expedition unit and the first preparation unit is not the same OR the order number address (LOLE.numadr) for the delivery order headers of the expedition unit and the first preparation unit is not the same.

The API returns an error code 0 and an error message “L_COL_PAL”.

Else

Call the function gnc_colis_desaff_colis_tournee, as so to deallocate the preparation unit form the current expedition tour.

Call the function gnc_colis_affect_colis_tournee, as so to assign the preparation unit to the expedition tour of the expedition tour.

If the delivery order header for the expedition unit has mono expedition tour type (lole.idtrn != ‘0’).

The delivery order header expedition tour type is changed to multi (lole.idtrn = ‘0’).

Else

For each delivery order header (lole) in pending status (statut = 1), related to the delivery order header for the expedition unit (idol = lcol.idol).

Check whether its expedition tour identifier is the same as the expedition tour identifier of the expedition unit (lole.idtrn = lcol.idtrn).

If the verification is fulfilled the expedition tour is considered as multi tour.

If the expedition tour is a multi tour.

Update the expedition tour ID for the delivery order header related to the expedition unit with the expedition tour ID of the expedition tour (LOLE.idtrn = LCOL.idtrn).

The following functionality was added.

If the parcel is not on an expedition unit (lcol.idue is empty).

If the expedition unit is empty.

Read the parcel data (LCOL) related to the expedition unit (idobjcol = idue input parameter).

If the parcel is not found, the API returns an error code 0 and an error message “ELT_PASTRO”.

Read the stock object data (LOBJSTK ) related to the first preparation unit (idobj = lcol.idobj).

If the stock object is not found, the API returns an error code 0 and an error message “ELT_PASTRO”.

Read the depot data (ldep).

If the virtual store for the depot (LDEP.magvir) is the same as the store for the stock object of the first preparation unit.

Update the slot address and the store for the stock object of the first preparation unit with the slot address and the store for the stock object of the expedition unit (lobjstk.adremp, lobjstk.lcodmag).

Read the parcel data (LCOL) for the expedition unit (idobjcol = idue input parameter).

If the parcel does not exist, the API returns an error code 0 and an error message “ELT_PASTRO”.

If the third-party ID associated with the delivery for the first preparation unit parcel (lcol.sigliv) is not presented.

Update the delivery associated third-party ID (lcol.sigliv), the delivery associated third-party type (LCOL.typliv), the address order number (LCOL.numadr) for the parcel with the corresponding data from the parcel related to the expedition unit (idue = idue input parameter).