Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

API: inv_lot_api_pub.update_inv_lot has return status as NULL

edited May 5, 2017 5:00AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

hi Everyone,

We have a requirement to update the lot expiry date. The API: 'inv_lot_api_pub.update_inv_lot' updates the lot expiry date as expected, but it is giving return status as NULL. Can you please help me understand why is this happening? Below is the sample code used:

  declare

    lr_lot_rec                  mtl_lot_numbers%rowtype := NULL;

    lrx_lot_rec                 mtl_lot_numbers%rowtype := NULL;

    x_object_id                 NUMBER;

    ln_message_count            NUMBER                           := 0;

    lc_message_list             VARCHAR2 (4000)                  := NULL;

    lc_return_status            VARCHAR2 (1)                     := 'S';

    ln_msg_index_out            NUMBER                           := 0;

    ld_expiry_date              DATE                             := NULL;

  begin

  lc_message_list  := null;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center