Sunday, January 23, 2011

Calling Autolockbox from PL/SQL



declare
begin
v_request_id :=
fnd_request.submit_request
(application => 'AR',
program => 'ARLPLB',
description => NULL,
start_time => NULL,
sub_request => FALSE,
argument1 => 'Y', -- P_NEW_TRANSMISSION
argument2 => '', -- P_TRANSMISSION_ID
argument3 => '', -- P_ORIGINAL_REQUEST_ID
argument4 => v_transmission_name,
argument5 => 'Y', -- P_RUN_IMPORT
argument6 => V_UTL_FILE_IN_DIR||'/'||P_DATA_FILE_NAME, -- DATA FILE PATH
argument7 => '', -- P_CONTROL_FILE_NAME
argument8 => v_transmission_format_id,
argument9 => 'Y', -- P_SUBMIT_VALIDATION
argument10 => 'N', -- P_PAY_UNRELATED_INVOICES
argument11 => v_lockbox_id,
argument12 => v_gl_date,
argument13 => 'A', -- P_REPORT_FORMAT
argument14 => 'N', -- P_COMPLETE_BATCHES_ONLY
argument15 => 'Y', -- P_SUBMIT_POST_BATCH
argument16 => 'N', -- P_ALTERNATE_NAME_SEARCH
argument17 => 'Y', -- P_APPLY_PARTIAL_OR_REJECT
argument18 => '', -- P_USSGL_TRANSACTION_CODE
argument19 => v_org_id,
argument20 => 'L',
argument21 => '',
CHR(0), CHR(0)
);
end;

2 comments:

  1. it is giving

    AR-ARLCTR Error from arlctr.
    AR-ARLPLB: arlctr returned FALSE.
    AR-ARLPLB: Error in main.
    AR-ARLPLB: -28115 ORA-28115: policy with check option violation
    ORA-06512: at

    ReplyDelete
  2. Hi Goutham,
    Try to append CHR(0), CHR(0) at the end as modified in script.


    Thanks
    Amit

    ReplyDelete

Note: Only a member of this blog may post a comment.