APPS.PO_INTERFACE_ERRORS_PVT dependencies on PO_INTERFACE_ERRORS

Line 1: PACKAGE BODY PO_INTERFACE_ERRORS_PVT AS

1: PACKAGE BODY PO_INTERFACE_ERRORS_PVT AS
2: /* $Header: POXVPIEB.pls 115.1 2003/08/27 03:38:09 bao noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_ERRORS_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_ERRORS_PVT';

1: PACKAGE BODY PO_INTERFACE_ERRORS_PVT AS
2: /* $Header: POXVPIEB.pls 115.1 2003/08/27 03:38:09 bao noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_INTERFACE_ERRORS_PVT';
5:
6: -----------------------------------------------------------------------
7: --Start of Comments
8: --Name: insert_row

Line 10: --Modifies: po_interface_errors

6: -----------------------------------------------------------------------
7: --Start of Comments
8: --Name: insert_row
9: --Pre-reqs:
10: --Modifies: po_interface_errors
11: --Locks:
12: -- None
13: --Function: Insert a record into po_interface_errors table based on
14: -- the values in record p_rec, which is passed in as a parameter

Line 13: --Function: Insert a record into po_interface_errors table based on

9: --Pre-reqs:
10: --Modifies: po_interface_errors
11: --Locks:
12: -- None
13: --Function: Insert a record into po_interface_errors table based on
14: -- the values in record p_rec, which is passed in as a parameter
15: --Parameters:
16: --IN:
17: --p_api_version

Line 24: -- A record structure of the table PO_INTERFACE_ERRORS. The values in

20: -- Whether the message stack should get initialized within the procedure
21: --p_commit
22: -- Whether the API should commit
23: --p_rec
24: -- A record structure of the table PO_INTERFACE_ERRORS. The values in
25: -- this record will be inserted into po_interface_errors as a record.
26: -- See Notes for its usage
27: --IN OUT:
28: --OUT:

Line 25: -- this record will be inserted into po_interface_errors as a record.

21: --p_commit
22: -- Whether the API should commit
23: --p_rec
24: -- A record structure of the table PO_INTERFACE_ERRORS. The values in
25: -- this record will be inserted into po_interface_errors as a record.
26: -- See Notes for its usage
27: --IN OUT:
28: --OUT:
29: --x_return_status

Line 44: -- from the next number in PO_INTERFACE_ERRORS_S sequence.

40: -- Before calling this procedure, p_rec must be populated with values for
41: -- the columns user wants to set. If p_rec.interface_type is not set, the
42: -- value 'UNKNOWN' will be populated as INTERFACE_TYPE in po_interface_erros.
43: -- If p_rec.interface_transaction_id is not set, the value will be derived
44: -- from the next number in PO_INTERFACE_ERRORS_S sequence.
45: -- Also, the following fields will be derived within the procedure and
46: -- the corresponding columns within p_rec will be ignored:
47: -- creation_date
48: -- created_by

Line 66: p_rec IN PO_INTERFACE_ERRORS%ROWTYPE,

62: p_commit IN VARCHAR2,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_rec IN PO_INTERFACE_ERRORS%ROWTYPE,
67: x_row_id OUT NOCOPY ROWID
68: ) IS
69:
70: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 75: l_interface_transaction_id PO_INTERFACE_ERRORS.interface_transaction_id%TYPE;

71: l_api_version NUMBER := 1.0;
72:
73: l_progress VARCHAR2(3);
74:
75: l_interface_transaction_id PO_INTERFACE_ERRORS.interface_transaction_id%TYPE;
76: BEGIN
77:
78: l_progress := '000';
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 97: SELECT po_interface_errors_s.NEXTVAL

93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: IF (p_rec.interface_transaction_id IS NULL) THEN
97: SELECT po_interface_errors_s.NEXTVAL
98: INTO l_interface_transaction_id
99: FROM DUAL;
100: ELSE
101: l_interface_transaction_id := p_rec.interface_transaction_id;

Line 104: INSERT INTO po_interface_errors

100: ELSE
101: l_interface_transaction_id := p_rec.interface_transaction_id;
102: END IF;
103:
104: INSERT INTO po_interface_errors
105: ( interface_type,
106: interface_transaction_id,
107: column_name,
108: error_message,

Line 176: END PO_INTERFACE_ERRORS_PVT;

172: );
173:
174: END insert_row;
175:
176: END PO_INTERFACE_ERRORS_PVT;