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 451: insert into PO_INTERFACE_ERRORS (

447: end if;
448:
449: l_error_message := FND_MESSAGE.get;
450:
451: insert into PO_INTERFACE_ERRORS (
452: INTERFACE_TYPE,
453: INTERFACE_TRANSACTION_ID,
454: COLUMN_NAME,
455: ERROR_MESSAGE,

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

493: --
494: -- In file version 115.10, removed the X_INTERFACE_TYPE and X_TRANSACTION_ID
495: -- parameters from UPDATE_PO and added an X_API_ERRORS parameter, because
496: -- the PO Change API will no longer write error messages to the
497: -- PO_INTERFACE_ERRORS table. Instead, it will return all of the errors
498: -- in the x_api_errors object.
499:
500: FUNCTION update_po
501: (

Line 527: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;

523:
524: l_api_version CONSTANT NUMBER := 1.0;
525: l_api_name CONSTANT VARCHAR2(50) := 'UPDATE_PO';
526:
527: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;
528:
529: l_result NUMBER := 1;
530: l_return_status VARCHAR2(1);
531: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;