58:
59: BEGIN
60:
61: IF (X_TRANSACTION_ID is null) then
62: select PO_INTERFACE_ERRORS_S.nextval
63: into l_TRANSACTION_ID from sys.dual;
64: else
65: l_TRANSACTION_ID := X_TRANSACTION_ID;
66: end if;
441: end if;
442:
443: l_error_message := FND_MESSAGE.get;
444:
445: insert into PO_INTERFACE_ERRORS (
446: INTERFACE_TYPE,
447: INTERFACE_TRANSACTION_ID,
448: COLUMN_NAME,
449: ERROR_MESSAGE,
487: --
488: -- In file version 115.10, removed the X_INTERFACE_TYPE and X_TRANSACTION_ID
489: -- parameters from UPDATE_PO and added an X_API_ERRORS parameter, because
490: -- the PO Change API will no longer write error messages to the
491: -- PO_INTERFACE_ERRORS table. Instead, it will return all of the errors
492: -- in the x_api_errors object.
493:
494: FUNCTION update_po
495: (
517:
518: l_api_version CONSTANT NUMBER := 1.0;
519: l_api_name CONSTANT VARCHAR2(50) := 'UPDATE_PO';
520:
521: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;
522:
523: l_result NUMBER := 1;
524: l_return_status VARCHAR2(1);
525: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;