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)

/