DBA Data[Home] [Help]

APPS.PO_CHANGE_API1_S dependencies on PO_INTERFACE_ERRORS

Line 62: select PO_INTERFACE_ERRORS_S.nextval

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;

Line 445: insert into PO_INTERFACE_ERRORS (

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,

Line 491: -- PO_INTERFACE_ERRORS table. Instead, it will return all of the errors

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: (

Line 521: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;

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;