1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Getting Error in PA-Billing

Discussion in 'Oracle Projects' started by venkateswarlu.y@genpact, Dec 30, 2011.

  1. venkateswarlu.y@genpact

    venkateswarlu.y@genpact Active Member

    Messages:
    16
    Likes Received:
    3
    Trophy Points:
    110
    Hi

    I am geting following error in PA billing


    "line:0ORACLE error during DRAFT INVOICE GENERATION (cursor=29 code=-20001: ORA-20001: Please define the item validation organization in the Param)
    PAI_ORACLE_ERROR
    ERROR
    cursor=29 code=-20001: ORA-20001: Please define the item validation organization in the Param"


    The log File shows the following


    ..entering paiiig +---------------------------------------------------------------------------+
    Projects: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    PAIGEN_SINGLE module: PRC: Generate Draft Invoices for a Single Project
    +---------------------------------------------------------------------------+

    Current system time is 19-DEC-2011 19:20:23

    +---------------------------------------------------------------------------+

    ...connected to database
    ...Setting project id
    ...Setting bill_through date to sysdate
    ...Setting bill_through date to invoice date
    ...Setting invoice invoice generation option :
    INCLUDE_RETN_INVOICES
    ...Setting invoice process :
    REGENERATE
    ...No invoice number specified
    ...No start project number specified
    ...No end project number specified
    ...No write off amount specified
    ...No resubmission interval specified
    ...No resubmission time specified
    ...No resubmission end-date specified
    ...No request to adjust date specified
    ...No project type specified
    ...No project org specified
    ...No customer specified
    ...No LOC customer specified
    ...No agreement specified
    ...Multi currency projects only not requested
    ...Exclude addl transactions not requested
    ...Delete only unapproved invoices not specified
    ...Credit level (only for WRITE-OFF/CONCESSION) specified
    NO
    ...Include Pay When Paid Linnked Invoice NOT Specified, Setting it to default : NO
    ...Retrieved user_id
    ...Retrieved request_id
    ...Retrieved program_app_id
    ...Retrieved program_id
    ...Setting Sets Of Books
    Entering paisob()Current system time is 19-DEC-2011 19:20:23

    Leaving paisob()Current system time is 19-DEC-2011 19:20:23
    ...2358...Leaving paiiig
    Entering paicpf()Current system time is 19-DEC-2011 19:20:23
    Leaving paicpf()Current system time is 19-DEC-2011 19:20:23

    ...Regeneration of invoices
    ...Single project invoice generation ...Checking open projects



    Invoice Processing Parameter List
    ========================================================

    ------------ < List Of Parameters > ----------------------


    Single Project ID ---------------------> 6377
    From Project Number ------------------->
    To Project Number --------------------->
    Bill Through Date ---------------------> 2011/12/19
    Invoice Date --------------------------> 2011/12/19
    Invoice Generation Option -------------> INCLUDE_RETN_INVOICES
    Project Type ID -----------------------> 0
    Project Org ID ------------------------> 0
    Customer ID ---------------------------> 0
    LOC Customer ID -----------------------> 0
    Agreement ID --------------------------> 0
    Multi Currency Flag -------------------> No
    Exclude New Transactions --------------> No
    Delete unapproved invoices only -------> No
    Delete PWP Linked invoices ------------> No


    ========= < End of Parameter List > ==================

    Current system time is 19-DEC-2011 19:20:23

    Entering paiorg()
    .....Running under ORG_ID: 8992Current system time is 19-DEC-2011 19:20:23

    Leaving paiorg()
    Getting PA and GL dates and Period Names
    AR Install Flag : I

    Calling AR Install Extension...
    Entering paiinc()Current system time is 19-DEC-2011 19:20:23

    Calling Get GL-PA Dates and Periods API

    PA-GL API Return Code :
    Current system time is 19-DEC-2011 19:20:23

    PA date=2011/12/19 GL date=2011/12/19 PA Period=Dec-W3-11 GL Period=Dec-11

    setting glob vars
    ...Project numbering type is: ALPHANUMERIC

    ...Initialization complete.

    Invoice Generation Option :
    INCLUDE_RETN_INVOICES
    Processing Project Invoices
    ...paigop cursor statement is:
    SELECT P.PROJFUNC_CURRENCY_CODE,DECODE(P.INVPROC_CURRENCY_TYPE,'PROJECT_CURRENCY',
    P.PROJECT_CURRENCY_CODE,'PROJFUNC_CURRENCY',P.PROJFUNC_CURRENCY_CODE,'FUNDING'),
    P.PROJECT_BIL_RATE_TYPE,
    NVL(TO_CHAR(P.PROJECT_BIL_RATE_DATE,'YYYY/MM/DD'),'N'),TO_CHAR(P.PROJECT_BIL_EXCHANGE_RATE),
    P.PROJFUNC_BIL_RATE_TYPE,
    NVL(TO_CHAR(P.PROJFUNC_BIL_RATE_DATE,'YYYY/MM/DD'),'N'), TO_CHAR(P.PROJFUNC_BIL_EXCHANGE_RATE),
    P.FUNDING_RATE_TYPE ,
    NVL(TO_CHAR(P.FUNDING_RATE_DATE,'YYYY/MM/DD'),'N'),TO_CHAR(P.FUNDING_EXCHANGE_RATE),
    P.MULTI_CURRENCY_BILLING_FLAG,
    P.PROJECT_ID,P.NAME,P.INVOICE_COMMENT,P.PROJECT_LEVEL_FUNDING_FLAG,
    DECODE(SUBSTRB(P.DISTRIBUTION_RULE,
    INSTR(P.DISTRIBUTION_RULE,'/')+1), 'EVENT',1,0),
    IG1.GROUP_TYPE_CODE, IG2.GROUP_TYPE_CODE,
    NVL(P.RETENTION_INVOICE_FORMAT_ID,0),
    TO_CHAR(NVL(P.RETENTION_PERCENTAGE,0)/100),
    NVL(P.LABOR_INVOICE_FORMAT_ID,0),
    NVL(P.NON_LABOR_INVOICE_FORMAT_ID,0), P.PROJECT_CURRENCY_CODE,
    DECODE(P.inv_by_bill_trans_curr_flag,'Y',1,0),
    pa_retention_util.CheckRetnInvFormat(p.project_id,p.retention_invoice_format_id)
    , P.ENABLE_TOP_TASK_CUSTOMER_FLAG, P.ENABLE_TOP_TASK_INV_MTH_FLAG ,
    DECODE(P.DATE_EFF_FUNDS_CONSUMPTION,'Y',1,0)
    FROM PA_PROJECTS P, PA_PROJECT_TYPES T,
    PA_INVOICE_FORMATS IF1, PA_INVOICE_GROUPS IG1,
    PA_INVOICE_FORMATS IF2, PA_INVOICE_GROUPS IG2
    WHERE PA_Project_Utils.Check_prj_stus_action_allowed(P.Project_Status_Code, 'GENERATE_INV') = 'Y'
    AND P.PROJECT_TYPE = T.PROJECT_TYPE AND T.DIRECT_FLAG = 'Y'
    AND P.LABOR_INVOICE_FORMAT_ID = IF1.INVOICE_FORMAT_ID (+)
    AND IF1.INVOICE_GROUP_ID = IG1.INVOICE_GROUP_ID (+)
    AND P.NON_LABOR_INVOICE_FORMAT_ID = IF2.INVOICE_FORMAT_ID (+)
    AND IF2.INVOICE_GROUP_ID = IG2.INVOICE_GROUP_ID (+)
    AND exists (select null from pa_summary_project_fundings pf
    where pf.project_id = p.project_id and nvl(pf.total_baselined_amount, 0) != 0
    and nvl(pf.projfunc_baselined_amount, 0) != 0 and nvl(pf.projfunc_baselined_amount, 0) !=0)


    paigop Cursor is :
    SELECT P.PROJFUNC_CURRENCY_CODE,DECODE(P.INVPROC_CURRENCY_TYPE,'PROJECT_CURRENCY',
    P.PROJECT_CURRENCY_CODE,'PROJFUNC_CURRENCY',P.PROJFUNC_CURRENCY_CODE,'FUNDING'),
    P.PROJECT_BIL_RATE_TYPE,
    NVL(TO_CHAR(P.PROJECT_BIL_RATE_DATE,'YYYY/MM/DD'),'N'),TO_CHAR(P.PROJECT_BIL_EXCHANGE_RATE),
    P.PROJFUNC_BIL_RATE_TYPE,
    NVL(TO_CHAR(P.PROJFUNC_BIL_RATE_DATE,'YYYY/MM/DD'),'N'), TO_CHAR(P.PROJFUNC_BIL_EXCHANGE_RATE),
    P.FUNDING_RATE_TYPE ,
    NVL(TO_CHAR(P.FUNDING_RATE_DATE,'YYYY/MM/DD'),'N'),TO_CHAR(P.FUNDING_EXCHANGE_RATE),
    P.MULTI_CURRENCY_BILLING_FLAG,
    P.PROJECT_ID,P.NAME,P.INVOICE_COMMENT,P.PROJECT_LEVEL_FUNDING_FLAG,
    DECODE(SUBSTRB(P.DISTRIBUTION_RULE,
    INSTR(P.DISTRIBUTION_RULE,'/')+1), 'EVENT',1,0),
    IG1.GROUP_TYPE_CODE, IG2.GROUP_TYPE_CODE,
    NVL(P.RETENTION_INVOICE_FORMAT_ID,0),
    TO_CHAR(NVL(P.RETENTION_PERCENTAGE,0)/100),
    NVL(P.LABOR_INVOICE_FORMAT_ID,0),
    NVL(P.NON_LABOR_INVOICE_FORMAT_ID,0), P.PROJECT_CURRENCY_CODE,
    DECODE(P.inv_by_bill_trans_curr_flag,'Y',1,0),
    pa_retention_util.CheckRetnInvFormat(p.project_id,p.retention_invoice_format_id)
    , P.ENABLE_TOP_TASK_CUSTOMER_FLAG, P.ENABLE_TOP_TASK_INV_MTH_FLAG ,
    DECODE(P.DATE_EFF_FUNDS_CONSUMPTION,'Y',1,0)
    FROM PA_PROJECTS P, PA_PROJECT_TYPES T,
    PA_INVOICE_FORMATS IF1, PA_INVOICE_GROUPS IG1,
    PA_INVOICE_FORMATS IF2, PA_INVOICE_GROUPS IG2
    WHERE PA_Project_Utils.Check_prj_stus_action_allowed(P.Project_Status_Code, 'GENERATE_INV') = 'Y'
    AND P.PROJECT_TYPE = T.PROJECT_TYPE AND T.DIRECT_FLAG = 'Y'
    AND P.LABOR_INVOICE_FORMAT_ID = IF1.INVOICE_FORMAT_ID (+)
    AND IF1.INVOICE_GROUP_ID = IG1.INVOICE_GROUP_ID (+)
    AND P.NON_LABOR_INVOICE_FORMAT_ID = IF2.INVOICE_FORMAT_ID (+)
    AND IF2.INVOICE_GROUP_ID = IG2.INVOICE_GROUP_ID (+)
    AND exists (select null from pa_summary_project_fundings pf
    where pf.project_id = p.project_id and nvl(pf.total_baselined_amount, 0) != 0
    and nvl(pf.projfunc_baselined_amount, 0) != 0 and nvl(pf.projfunc_baselined_amount, 0) !=0)
    AND P.PROJECT_ID = 6377
    ORDER BY P.Segment1

    paigop Cursor printed

    .. Project Functional Currency Code : INR

    .. FALSE : Invoice By Bill Transaction Currency

    Federal : Shared Funds Consumption rule is not enabled .....

    .. Project Level Funding Exchange Rate :

    ...The following project info has been fetched:
    ...ID: 6377
    Name: Labor_Contract_Proj_01
    Labor Code: 1062
    Exp Code: 1023
    Events Only? TRUE
    Retn Inv Fmt Error: 0
    Fund Consumption( Yes - 1, No - 0) : 0

    Calling Delete unapproved/unreleased invoices ...
    Entering paidpr()Current system time is 19-DEC-2011 19:20:23

    Entering paiorg()
    .....Running under ORG_ID: 8992Current system time is 19-DEC-2011 19:20:23

    Leaving paiorg()
    paidpr Cursor is :
    SELECT I.DRAFT_INVOICE_NUM,
    SUBSTRB(P.DISTRIBUTION_RULE,INSTR(P.DISTRIBUTION_RULE,'/')+1),
    I.AGREEMENT_ID, to_char(I.INVOICE_DATE,'YYYY/MM/DD'), I.INV_CURRENCY_CODE,
    TO_CHAR(SUM(DII.INV_AMOUNT),
    PA_CURRENCY.TRANS_CURRENCY_FMT_MASK(RTRIM(I.INV_CURRENCY_CODE),18))
    FROM PA_DRAFT_INVOICES I, PA_PROJECTS P, PA_DRAFT_INVOICE_ITEMS DII
    WHERE I.PROJECT_ID = 6377
    AND P.PROJECT_ID = I.PROJECT_ID
    AND nvl(I.CANCEL_CREDIT_MEMO_FLAG, 'N') = 'N'
    AND DII.PROJECT_ID(+) = I.PROJECT_ID
    AND DII.DRAFT_INVOICE_NUM(+) = I.DRAFT_INVOICE_NUM
    AND I.RELEASED_BY_PERSON_ID IS NULL
    AND NOT EXISTS (SELECT NULL
    FROM pa_pwp_linked_invoices pwp
    ,PA_DRAFT_INVOICES DI
    WHERE DI.RELEASED_BY_PERSON_ID IS NULL
    AND pwp.project_id = 6377
    AND pwp.project_id = DI.project_id
    AND pwp.draft_invoice_num = DI.draft_invoice_num
    AND pwp.project_id = I.project_id)
    GROUP BY I.DRAFT_INVOICE_NUM,
    SUBSTRB(P.DISTRIBUTION_RULE,INSTR(P.DISTRIBUTION_RULE,'/')+1),
    I.AGREEMENT_ID, to_char(I.INVOICE_DATE,'YYYY/MM/DD'),I.INV_CURRENCY_CODE

    Row this time

    Calling check spf from paidpr..

    Leaving paidpr()Current system time is 19-DEC-2011 19:20:23

    Generating new invoices
    Entering paiapi() - PRE process
    SQL> execute pa_billing.bill_ext_driver(6377, 'Invoice', 'PRE', '2011/12/19',
    2 6613221, x_error_message =>:status)

    Leaving paiapi()
    Entering paipcm().Current system time is 19-DEC-2011 19:20:23

    Task Funding? FALSE
    ...Opening Cursor paipcm1_cur.

    ...before fetch paipcm1_cur.

    ...after fetch paipcm1_cur.

    ...Rows Fetched: this Time = 0
    Total = 0
    Leaving paipcm()Current system time is 19-DEC-2011 19:20:23

    Entering paiapi() - ADJ process
    SQL> execute pa_billing.bill_ext_driver(6377, 'Invoice', 'ADJ', '2011/12/19',
    2 6613221, x_error_message =>:status)

    Leaving paiapi()
    Entering paiapi() - POST process
    SQL> execute pa_billing.bill_ext_driver(6377, 'Invoice', 'POST', '2011/12/19',
    2 6613221, x_error_message =>:status)

    Leaving paiapi()
    Entering paiapi() - PRE process
    SQL> execute pa_billing.bill_ext_driver(6377, 'Invoice', 'PRE', '2011/12/19',
    2 6613221, x_error_message =>:status)

    Leaving paiapi()
    Entering paiend()Current system time is 19-DEC-2011 19:20:23

    Invoice Date : 2011/12/19

    Build Dynamic Sql
    Misc bill enhan Dynamic Sql
    Second Part of Dynamic Sql...paiend cursor statement is:
    select distinct 'N'status_code,to_char(decode(et.event_type_classification,
    'INVOICE REDUCTION', -e.bill_trans_bill_amount,e.bill_trans_bill_amount)),
    e.bill_trans_currency_code,e.project_currency_code, e.project_rate_type,
    NVL(TO_CHAR(e.project_rate_date,'YYYY/MM/DD'),'N'),TO_CHAR(e.project_exchange_rate),e.projfunc_currency_code, e.projfunc_rate_type,
    NVL(TO_CHAR(e.projfunc_rate_date,'YYYY/MM/DD'),'N'),TO_CHAR(e.projfunc_exchange_rate),e.invproc_currency_code, e.invproc_rate_type,
    NVL(TO_CHAR(e.invproc_rate_date,'YYYY/MM/DD'),'N'),TO_CHAR(e.invproc_exchange_rate),e.funding_rate_type,
    NVL(TO_CHAR(e.funding_rate_date,'YYYY/MM/DD'),'N'),TO_CHAR(e.funding_exchange_rate),e.bill_amount,
    nvl(e.task_id, 0), nvl(e.task_id, 0), e.event_num,
    decode(e.task_id, null, 0, nvl(t.address_id,0)),
    nvl(e.description,'(No Description)'),
    to_char(decode(et.event_type_classification,
    'INVOICE REDUCTION', -e.bill_amount,
    e.bill_amount)),nvl(e.event_num_reversed,0),
    rtrim(to_char(nvl(e.completion_date,sysdate),'J')),
    et.event_type_classification, e.request_id,
    decode(e.calling_place, 'ADJ',1,2),e.event_id,
    t.invoice_method
    from pa_tasks t, pa_events e, pa_event_types et
    where e.project_id = :pproject_id
    and t.ready_to_bill_flag = 'Y'
    and t.project_id = e.project_id
    and t.task_id = nvl(e.task_id, t.task_id)
    and e.event_type = et.event_type
    and e.completion_date < to_date:)pbill_through,'YYYY/MM/DD') + 1
    and nvl(e.bill_hold_flag,'N') = 'N'
    and et.event_type_classification != 'WRITE ON'
    and e.bill_trans_bill_amount != 0
    and e.billed_Flag = 'N'
    and exists (
    select NULL
    from pa_summary_project_fundings f
    where f.project_id = e.project_id
    and f.total_baselined_amount > 0
    and f.projfunc_baselined_amount > 0
    and f.task_id is null)
    and nvl(e.request_id,0) = decode ( :pexc_add_trans, 1, :pone_request_id, nvl(e.request_id,0))
    and not exists
    (select NULL
    from pa_billing_extensions be,
    pa_billing_assignments ba
    where ba.billing_assignment_id =
    e.billing_assignment_id
    and be.billing_extension_id =
    ba.billing_extension_id
    and be.calling_process = 'Revenue'
    and not exists (select null
    from pa_cust_event_rev_dist_lines erdl
    where erdl.project_id = e.project_id
    and nvl(erdl.task_id,-1) =
    nvl(e.task_id,-1)
    and erdl.event_num = e.event_num))
    order by decode(e.calling_place, 'ADJ',1,2),
    sign(decode(et.event_type_classification,
    'INVOICE REDUCTION', -e.bill_trans_bill_amount,e.bill_trans_bill_amount)),
    rtrim(to_char(nvl(e.completion_date,sysdate),'J')), e.event_id


    Prepare Dynamic Sql
    Declare Dynamic Sql
    paiend_cur: Open Cursor
    paiend_cur: Fetch Cursor
    Copy InvDate To IPC Convert date
    Call Convert APIreturn stat...
    After Convert API
    Find Temp Amount
    Event Amount IPC : 5000
    Event Amount To be Billed IPC : 5000
    ...The following normal event info has been fetched:
    Task ID : 0
    Event : 2
    Type : MANUAL
    Name : Manual
    Date : 2455914
    Trans Currency : INR
    Trans Amt : 5000
    PF Currency : INR
    PF Amount :
    Proj Currency : INR
    Proj Amt :
    Event Reversed : 0
    Status : N
    Entering paigaa()Current system time is 19-DEC-2011 19:20:23


    Checking Number of Customers#1
    Checking for Number of Active Bill Customers #1
    Checking for Number of Active Ship to Customers#1
    ... Checking Number of Active Customers#1
    Going to check relation()
    Checking for active bill to address
    Checking for active ship to address
    ...Checking Billing Contact For Cust #174743
    ... For Bill Cust #174743
    ... For Ship Cust #174743
    ...Checking Relation - 0...Customer #174743 is paying for 100% of this event.
    Entering paifai()Current system time is 19-DEC-2011 19:20:23

    ...InvHeader funding Currency :

    ...Customer ID: 174743
    Agreement: -4342416
    Task: 0
    Rever Event: 0
    Event Num: 0
    Amount Available: ��� Amount to Bill: 5000
    Amount to Invoice: 5000

    Constructing dynamic SQL statement.


    Constructing second part of SQL statement.


    Validate the Funding Conversion Attributes Call API to Check
    return stat...
    End of Funding Conversion Attributes Check

    Funding Amount : 5000
    Bill Trans Amount : 5000
    Status Code : N
    ...Here are the vital billing stats....Customer ID: 174743
    Agreement: 3661
    Task: 0
    Rever Event: 0
    Event Num: 0
    Amount Available: 10000
    Amount to Bill: 5000
    Amount to Invoice: 5000...There is still money left to bill.Building invoice header.
    Entering paibih()

    Entering paibih()Current system time is 19-DEC-2011 19:20:23
    (paibih)Event Num : 0 and Task Id: 0
    PEvent_Num=0,Execute the PLSQL Blk to find Auto Evt is not billed or not

    Leaving paibih()
    Leaving paibih()Current system time is 19-DEC-2011 19:20:23
    ...The following invoice header info has been fetched:
    ...Agreement ID: 3661
    Customer ID: 174743
    Invoice Number: 1
    Line Number: 0
    Agreement Expired? FALSE
    Generation Error? FALSE
    Hard Limit? FALSE
    Soft Limit? FALSE
    Invoice Limit? FALSE
    Already Exists? FALSE
    Date: 1
    Customer Bill Split: 100
    Available Amount: 10000
    Billed Amount: 0
    Task ID: 0
    Invoice Num Credited: 0

    Task Id : 0Event Num Reversed : 0Invoice Num : 8Project ID : 6377

    Line Amount IPC : 5000

    Convert Line Amount to PFC, PC, FC

    x_return_status :
    PFC Line Amount : 5000
    PC Line Amount : 5000
    Funding Line Amount : 5000
    Bill Trans Line Amount : 5000
    ...The following invoice line info will be inserted:
    ...Line Num: 0
    Task ID: 0
    Event Num: 2
    Bill Trans Currency: INR
    Bill Trans Amount: 5000
    Invoice Processing Currency: INR
    Invoice Processing Bill Amount: 5000
    Project Currency: INR
    Project Bill Amount: 5000
    Funding Currency: INR
    Funding Bill Amount: 5000
    Description: Manual
    Date: 2455914

    ...Before reset the funding Currency :
    INR

    ...after reset the funding Currency :
    INR

    Entering paiiil()Current system time is 19-DEC-2011 19:20:23

    Added Tax Related Changes
    Tax Reason Code :

    New One :

    ...Inserting line # 1 of invoice # 1 for $5000

    Tax Exempt Reason Code :
    Tax Exempt Cert Num :
    Tax Exempt Flag :
    Tax classification code :
    line:0ORACLE error during DRAFT INVOICE GENERATION (cursor=29 code=-20001: ORA-20001: Please define the item validation organization in the Param)
    PAI_ORACLE_ERROR
    ERROR
    cursor=29 code=-20001: ORA-20001: Please define the item validation organization in the Param

    Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned failure
    PA_IGEN_ERROR
    MODULE
    paiiil
    Error during Draft Invoice Generation. Module paiend returned failure
    PA_IGEN_ERROR
    MODULE
    paiend
    Error during Draft Invoice Generation. Module paigaa returned failure
    PA_IGEN_ERROR
    MODULE
    paigaa
    Error during Draft Invoice Generation. Module paiend returned failure
    PA_IGEN_ERROR
    MODULE
    paiend
    Error during Draft Invoice Generation. Module paigop returned failure
    PA_IGEN_ERROR
    MODULE
    paigop
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    100:From get_ou_period_information
    200:Calling pa_utils2.get_period_information
    100:From get_period_information
    100: Profile option is [Y]
    100: Same PA and GL for Prvdr [8992] is [N]
    100: Same PA and GL for Recvr [] is [N]
    100: p_expenditure_item_date is [19-DEC-11]
    100: p_expenditure_id is []
    100: p_system_linkage_function is []
    100: p_line_type is []
    100: p_prvdr_raw_pa_date is []
    100: p_recvr_raw_pa_date is []
    100: p_prvdr_raw_gl_date is []
    100: p_recvr_raw_gl_date is []
    100: p_prvdr_org_id is [8992]
    100: p_recvr_org_id is []
    100: p_prvdr_sob_id is [2358]
    100: p_recvr_sob_id is []
    100: p_calling_module is [AR_INSTALLED_INVOICE]
    400: New ER expenditure/ Raw VI/ Other.
    400: Deriving GL Info.
    500: Deriving Provider PA Info.
    700: Deriving Receiver PA Info.
    700: Not an ER. Wiping the Cache.
    700: x_prvdr_pa_date is [19-DEC-11] x_prvdr_pa_period_name is [Dec-W3-11]
    700: x_prvdr_gl_date is [19-DEC-11] x_prvdr_gl_period_name is [Dec-11]
    700: x_recvr_pa_date is [] x_recvr_pa_period_name is []
    700: x_recvr_gl_date is [] x_recvr_gl_period_name is []
    700: x_error_code is []
    300:After call to pa_utils2.get_period_information
    300:pA date [19-DEC-11] name [Dec-W3-11]
    300:GL date [19-DEC-11] name [Dec-11]
    300:Error Code []
    2011/12/19 07:20:23 Init: Start PLSQL Error
    2011/12/19 07:20:23 Entering pa_billing.CHECK_SPF_AMOUNTS :
    2011/12/19 07:20:23 Entering pa_billing.CHECK_SPF_AMOUNTS X_option : I
    2011/12/19 07:20:23 Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : 6377
    2011/12/19 07:20:23 Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num :
    2011/12/19 07:20:23 Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num :
    2011/12/19 07:20:23 Inside pa_billing.CHECK_SPF_AMOUNTS cursor sel_proj :
    2011/12/19 07:20:23 Inside pa_billing.CHECK_SPF_AMOUNTS cursor sel_proj :
    2011/12/19 07:20:23 Exiting pa_billing.CHECK_SPF_AMOUNTS :
    2011/12/19 07:20:23 Entering pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 pa_billing.bill_ext_driver project id :6377
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Request id :6613221
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Calling place :pRE
    2011/12/19 07:20:23 pa_billing.bill_ext_driver calling process :Invoice
    2011/12/19 07:20:23 pa_billing.bill_ext_driver accru thru date :2011/12/19
    2011/12/19 07:20:23 Exiting from pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 Entering pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 pa_billing.bill_ext_driver project id :6377
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Request id :6613221
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Calling place :ADJ
    2011/12/19 07:20:23 pa_billing.bill_ext_driver calling process :Invoice
    2011/12/19 07:20:23 pa_billing.bill_ext_driver accru thru date :2011/12/19
    2011/12/19 07:20:23 Exiting from pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 Entering pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 pa_billing.bill_ext_driver project id :6377
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Request id :6613221
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Calling place :pOST
    2011/12/19 07:20:23 pa_billing.bill_ext_driver calling process :Invoice
    2011/12/19 07:20:23 pa_billing.bill_ext_driver accru thru date :2011/12/19
    2011/12/19 07:20:23 Exiting from pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 Entering pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 pa_billing.bill_ext_driver project id :6377
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Request id :6613221
    2011/12/19 07:20:23 pa_billing.bill_ext_driver Calling place :pRE
    2011/12/19 07:20:23 pa_billing.bill_ext_driver calling process :Invoice
    2011/12/19 07:20:23 pa_billing.bill_ext_driver accru thru date :2011/12/19
    2011/12/19 07:20:23 Exiting from pa_billing.bill_ext_driver :
    2011/12/19 07:20:23 Event_Convert_amount_bulk
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Call PA_MULTI_CURRENCY_BILLING.get_project_defaults
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Agreement Id :0
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Call PA_MULTI_CURRENCY_BILLING.get_project_defaults
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Events To Process : 1
    2011/12/19 07:20:23 Event_Convert_amount_bulk: IPC Type : PROJFUNC_CURRENCY
    2011/12/19 07:20:23 Event_Convert_amount_bulk: IPC Code : INR
    2011/12/19 07:20:23 Event_Convert_amount_bulk: PC Code : INR
    2011/12/19 07:20:23 Event_Convert_amount_bulk: PFC Code : INR
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Project Rate Date : 2011/12/19
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Projfunc Rate Date: 2011/12/19
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Funding Rate Date : 2011/12/19
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Invproc Rate Date : 2011/12/19
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Project Rate :
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Projfunc Rate :
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Funding Rate :
    2011/12/19 07:20:23 Event_Convert_amount_bulk: IPC Rate :
    2011/12/19 07:20:23 Event_Convert_amount_bulk: BTC Amount : 5000
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Evt Cmplete Date: 2455914
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Before Assign IPC date to
    2011/12/19 07:20:23 Event_Convert_amount_bulk: first .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: two .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: three .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: three three .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: four .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: five .....
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Convert Bill Transaction To Project functional
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Proj curr = Proj func currency ..Copy
    2011/12/19 07:20:23 Event_Convert_amount_bulk: invproc curr = Proj func currency ..Copy
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Project Id 6377
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Event Num 2
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Task Id 0
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Project Amount 5000
    2011/12/19 07:20:23 Event_Convert_amount_bulk: Project Func Amount 5000
    2011/12/19 07:20:23 Event_Convert_amount_bulk: InvProc Amount 5000
    2011/12/19 07:20:23 No of Rows Updated 1
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Bill Trans Currency : INR
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Bill Trans Amount : 5000
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Funding Currency : INR
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Rate Type : Corporate
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Rate Date : 2011/12/19
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Rate :
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Funding Tab Amount : 5000
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Funding Amount : 5000
    2011/12/19 07:20:23 Check_Funding_Conv_Attributes: Status : N
    2011/12/19 07:20:23 Convert_Line_Event_Amount
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Project Id 6377
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Agreement Id 3661
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Task Id 0
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event Num 2
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Invproc_Bill_Amount 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event IPC Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event PC Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event PFC Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event Bill Trans Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Event Inv Proc Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Invoice Inv Proc Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Inv Proc Currency Type : PROJFUNC_CURRENCY
    2011/12/19 07:20:23 Convert_Line_Event_Amount: tmp_invproc_currency_code = tmp_bill_trans_currency_code
    2011/12/19 07:20:23 Convert_Line_Event_Amount: tmp_bill_trans_inv_amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: tmp_bill_trans_inv_amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: x_projfunc_bill_amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: x_project_bill_amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Line Bill Trans Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Project Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_projfunc Amount: 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: tmp_funding_currency_code = tmp_bill_trans_currency_code
    2011/12/19 07:20:23 Convert_Line_Event_Amount: x_funding_bill_amount = 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: x_bill_trans_inv_amount = 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Funding Amount : 5000
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Funding Rate :
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Funding Rate type :
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Funding Rate Date :
    2011/12/19 07:20:23 Convert_Line_Event_Amount: Convert_Line_Funding Status : N
    2011/12/19 07:20:23 GET_DEFAULT_TAX_INFO: get_pa_default_classification: Org_id: 8992
    2011/12/19 07:20:23 GET_DEFAULT_TAX_INFO: calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG
    2011/12/19 07:20:23 p_project_id : 6377
    2011/12/19 07:20:23 p_bill_to_site_use_id : 15336
    2011/12/19 07:20:23 p_ship_to_site_use_id : 15338
    2011/12/19 07:20:23 p_project_customer_id : 174743
    2011/12/19 07:20:23 p_set_of_books_id : 2358
    2011/12/19 07:20:23 p_expenditure_item_id :
    2011/12/19 07:20:23 p_trx_date : 19-DEC-11
    2011/12/19 07:20:23 p_event_id : 129977
    2011/12/19 07:20:23 p_line_type : EVENT
    2011/12/19 07:20:23 p_request_id : 6613221
    2011/12/19 07:20:23 p_user_id : 1015898
    2011/12/19 07:20:23 p_tax_classification_code :
    2011/12/19 07:20:23 p_bill_to_customer_id : 174743
    2011/12/19 07:20:23 p_ship_to_customer_id : 174743
    2011/12/19 07:20:23 p_application_id : 275
    2011/12/19 07:20:23 p_internal_organization_id: 8992
    2011/12/19 07:20:23 p_draft_inv_num_credited : 0
    2011/12/19 07:20:23 GET_DEFAULT_TAX_INFO: ORA-20001: Please define the item validation organization in the Parameters window in Order Management.
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+


    +---------------------------------------------------------------------------+
    Executing request completion options...


    Output is not being printed because:
    The print option has been disabled for this report.


    Finished executing request completion options.
    ...Error trying to retrieve eligible projects.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 19-DEC-2011 19:20:23

    +---------------------------------------------------------------------------+


    Regards,
    Venkat