59: -- Initial version 1.0
60: -- End of comments
61: PROCEDURE create_negotiation_bulk
62: (
63: -- standard API params
64: p_api_version IN NUMBER,
65: x_result IN OUT NOCOPY NUMBER,
66: x_error_message IN OUT NOCOPY VARCHAR2,
67: -- input params
97: l_error_code VARCHAR2(2000);
98: -- l_req_lines_tbl REQ_LINES_TABLE_TYPE; --Bug5841426
99: l_num_lines NUMBER;
100: BEGIN
101: -- Standard start of API savepoint
102: SAVEPOINT create_negotiation_bulk_SP;
103: -- Standard call to check for call compatibility
104: IF NOT FND_API.Compatible_API_Call( l_api_version ,
105: p_api_version ,
99: l_num_lines NUMBER;
100: BEGIN
101: -- Standard start of API savepoint
102: SAVEPOINT create_negotiation_bulk_SP;
103: -- Standard call to check for call compatibility
104: IF NOT FND_API.Compatible_API_Call( l_api_version ,
105: p_api_version ,
106: l_api_name ,
107: G_PKG_NAME)
157: 'After create_negotiation');
158: END IF;
159:
160: -- End of API Body
161: -- Standard check to see if there is any error
162: IF(x_result = -1) THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: EXCEPTION
179:
180: -- Overloaded method
181: PROCEDURE create_negotiation_bulk
182: (
183: -- standard API params
184: p_api_version IN NUMBER,
185: x_result IN OUT NOCOPY NUMBER,
186: x_error_message IN OUT NOCOPY VARCHAR2,
187: -- input params
223: l_error_code VARCHAR2(2000);
224: -- l_req_lines_tbl REQ_LINES_TABLE_TYPE; --Bug5841426
225: l_num_lines NUMBER;
226: BEGIN
227: -- Standard start of API savepoint
228: SAVEPOINT create_negotiation_bulk_SP;
229: -- Standard call to check for call compatibility
230: IF NOT FND_API.Compatible_API_Call( l_api_version ,
231: p_api_version ,
225: l_num_lines NUMBER;
226: BEGIN
227: -- Standard start of API savepoint
228: SAVEPOINT create_negotiation_bulk_SP;
229: -- Standard call to check for call compatibility
230: IF NOT FND_API.Compatible_API_Call( l_api_version ,
231: p_api_version ,
232: l_api_name ,
233: G_PKG_NAME)
282: 'After create_negotiation');
283: END IF;
284:
285: -- End of API Body
286: -- Standard check to see if there is any error
287: IF(x_result = -1) THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: EXCEPTION
1548: l_progress varchar2(3);
1549: BEGIN
1550: l_progress := '000';
1551:
1552: -- Standard call to check for call compatibility
1553: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1554: THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1556: END IF;
1814: --
1815: BEGIN
1816: l_progress := '000';
1817:
1818: -- Standard start of API savepoint
1819: SAVEPOINT renegotiate_blanket_grp;
1820:
1821: -- Standard call to check for call compatibility
1822: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1817:
1818: -- Standard start of API savepoint
1819: SAVEPOINT renegotiate_blanket_grp;
1820:
1821: -- Standard call to check for call compatibility
1822: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1823: THEN
1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825: END IF;