Versions Compared

Version Old Version 4 New Version 5
Changes made by

IFS Energy and Resources

IFS Energy and Resources

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Function returns VARCHAR2 (‘TRUE’/’FALSE’) to indicate a successful/unsuccessful action.
  • Available as both a function and a procedure.
Expand
titleSee table

Parameter

In/Out

Type

Default Value

i_invc_ba_id       

IN

NUMBER(10) 


i_invc_num         

IN

VARCHAR2(20) 


i_invc_date

IN

DATE 


i_p_or_r_code                   

IN

VARCHAR2(6) 


o_voucher_id

OUT

NUMBER(10)


o_voucher_num                   

OUT

NUMBER(5) 


o_voucher_stat_code          

OUT

VARCHAR2(1) 


o_voucher_stat_code_desc          

OUT

VARCHAR2(80) 


o_invc_id

OUT

NUMBER(10) 


o_invc_amt                   

OUT

NUMBER(14,2) 


o_invc_current_bal          

OUT

NUMBER(14,2) 


o_pay_stat_code          

OUT

VARCHAR2(1) 


o_pay_stat_code_desc

OUT

VARCHAR2(80) 


o_cash_tx_stat_code                   

OUT

VARCHAR2(3) 


o_cash_tx_code_desc

OUT

VARCHAR2(80) 


o_cash_tx_date                   

OUT

DATE 


o_cash_tx_amt          

OUT

NUMBER(14,2) 


o_chq_micr_num          

OUT

NUMBER(10) 


o_ba_issued_date

OUT

DATE 


o_ba_issued_num                   

OUT

VARCHAR2(10) 


o_return_status


*procedure only

OUT

VARCHAR2

Possible values:

  • ‘TRUE’
  • ‘FALSE’ 

o_return_code

OUT

NUMBER

Possible values:

  • 0 – Success
  • -20001 – Handled Application Error
  • -20000 – Generic Error 

o_return_message

OUT

VARCHAR2

Insert ‘Successful’ or ‘Failure’ or error message


transaction_status_api.GET_CHEQUE_STATUS()

  • Function returns VARCHAR2 (‘TRUE’/’FALSE’) to indicate a successful/unsuccessful action.
  • Available as both a function and a procedure.
Expand
titleSee table

Parameter

In/Out

Type

Default Value

i_cheque_num       

IN

NUMBER(10)


i_client_issued_num         

IN

VARCHAR2(10)


i_client_id

IN

NUMBER(6)


i_p_or_r_code                   

IN

VARCHAR2(1)


i_bank_acct_num          

IN

VARCHAR2(35)


o_cash_tx_stat_code                   

OUT

VARCHAR2(3)


o_cash_tx_stat_code_desc

OUT

VARCHAR2(80)


o_cash_tx_date                   

OUT

DATE


o_cash_tx_amt          

OUT

NUMBER(14,2)


o_return_status


*procedure only

OUT

VARCHAR2

Possible values:

  • ‘TRUE’
  • ‘FALSE’

o_return_code

OUT

NUMBER

Possible values:

  • 0 – Success
  • -20001 – Handled Application Error
  • -20000 – Generic Error

o_return_message

OUT

VARCHAR2

Insert ‘Successful’ or ‘Failure’ or error message


Error Messages for TRANSACTION_STATUS_API

Expand
titleSee error messages

Message

Explanation

Voucher with specified parameters does not exist.

 


Invoice with specified parameters does not exist.

 


Cheque with specified parameters does not exist.

 


Too many records found! Please provide more parameters.

For example to get cheque status only cheque number was provided but this does not allow to identify record uniquely.  Try providing more input parameters if possible.

Voucher loaded into interface control table but not into production tables.

Voucher has not been transferred yet to production tables.