Channel Revenue Management - EBS (MOSC)

MOSC Banner

OZF_CLAIM_PUB.update claim getting error

edited Jul 10, 2018 12:27AM in Channel Revenue Management - EBS (MOSC) 3 commentsAnswered

Getting Error while changing the claim status from PENDING_CLOSE TO CLOSED

Hi Team,

I am trying to update the claim status from PENDING_CLOSE to CLOSED by using the OZF_CLAIM_PUB.update_claim.

below is the code which i am using

DECLARE

  lv_return_status           VARCHAR2 (1);

  lv_msg_count               NUMBER;

  lv_msg_data                VARCHAR2 (20000);

  lv_resp_name               VARCHAR2 (100);

  lv_user_name               VARCHAR2 (100);

  lv_claim_number            VARCHAR2 (25);

  lv_transaction_no          VARCHAR2 (100)                    := '0';

  lv_transaction_id          NUMBER;

  lv_related_customer        VARCHAR2 (10);

  lv_rel_site_use_id         NUMBER;

  lv_rel_cust_acct_id        NUMBER;

  lv_rel_cust_type           VARCHAR2 (10);

  lv_appl_id                 NUMBER                            := fnd_profile.VALUE ('RESP_APPL_ID');

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