Wednesday, July 7, 2010

PO Acceptance API



Below API insert the acceptance record into PO_ACCEPTANCES table, before that check box must be checked for acceptance before submitting the PO for approval.


Declare
result number := null;
begin
fnd_global.apps_initialize (user_id, Responsibility_id_id, Application_id);
result :=
PO_CHANGE_API1_S.record_acceptance
(9310000133, ---PO Num
null, ---Release Num
0, ---Revision Num
'NEW', ---Action
sysdate, ---Action Date
261, ---Buyer id
'Y', ---Acceptance flag ‘Y’ or ‘N’
'ABCD', ---Acceptance lookup code
'All valid', ---Note
'1.0'); ---Version Number
commit;
end;

Parameter Description
PO_NUM:
Purchase order number.
RELEASE_NUM:
Required if the purchase order is a release. The pass-in value must be a number.
REVISION_NUM:
Which revision of the purchase order/release is being acted upon.
ACTION:
Indicates the action to take. The value must be NEW.
ACTION_DATE:
Indicates the date of follow-up action. Provide a value in the format of 'MM/DD/YY' or 'MM-DD-YY', its default value is TRUNC (SYSDATE).
EMPLOYEE_ID:
The fnd_global.user_id of the buyer.
ACCEPTED_FLAG:
Indicate if purchase is accepted. Must be 'Y' or 'N'.
ACCEPTANCE_LOOKUP_CODE:
Type of acceptance, its value must be corresponding to the LOOKUP_CODE in PO_LOOKUP_CODES table with LOOKUP_TYPE of ACCEPTANCE TYPE. The possible values are- Accepted Terms, Accepted All Terms, On Schedule, UnacceptableChanges, and REJECTED
NOTE:
Any description you want to insert.
VERSION:
Version of the current API (currently 1.0)

2 comments:

  1. The description of the given parameters are very specific and to the point.Thanks for this piece of information. Its quite useful.
    sap testing tools

    ReplyDelete
  2. Have you used this successfully? I'm wondering where to look in case of result = 0. I don't see anything entered in po_interface_errors. Also is employee_id supposed to be the user_id or the agent_id for the buyer?

    ReplyDelete

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