Database Administration (MOSC)

MOSC Banner

Error calling ASO_QUOTE_PUB.Create_Quote_Line from a custom package

edited Jan 9, 2009 9:05AM in Database Administration (MOSC) 1 commentAnswered
 I got the following error when i call the procedure ASO_QUOTE_PUB.Create_Quote_Line:
v_org_id :43
v_price_list_id :18789
INVENTORY_ITEM_ID :1640831
v_party_rec.PARTY_ID :22295
v_party_rec.PARTY_SITE_ID :55517
UOM_CODE :NR
no. of FND messages :2
Error msg: Errore restituito in ASO_QUOTE_LINES_PVT.Create_Quote_Lines.
Error msg: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
U
2
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Here is mine procedure:

  PROCEDURE ADD_MODEL_TO_QUOTE(i_user_id NUMBER, i_quote_header_id IN NUMBER, i_model_code IN VARCHAR2, o_err_code OUT NOCOPY VARCHAR2) AS

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center