73: v_ErrorCode NUMBER;
74: v_ErrorText VARCHAR2(200);
75:
76: BEGIN
77: --Standard Savepoint
78: SAVEPOINT validProcedure;
79:
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
76: BEGIN
77: --Standard Savepoint
78: SAVEPOINT validProcedure;
79:
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
82: p_api_version_number,
83: l_api_name,
84: G_PKG_NAME)
246: l_IEM_INVALID_PROCEDURE EXCEPTION;
247: logMessage VARCHAR2(2000);
248: -- l_error_text varchar2(2000);
249: BEGIN
250: -- Standard Start of API savepoint
251: SAVEPOINT run_Procedure_PVT;
252:
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
249: BEGIN
250: -- Standard Start of API savepoint
251: SAVEPOINT run_Procedure_PVT;
252:
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
255: p_api_version_number,
256: l_api_name,
257: G_PKG_NAME)
323: x_result := l_result;
324:
325: DBMS_SQL.close_cursor( l_Cursor );
326:
327: -- Standard Check Of p_commit.
328: IF FND_API.To_Boolean(p_commit) THEN
329: COMMIT WORK;
330: END IF;
331:
328: IF FND_API.To_Boolean(p_commit) THEN
329: COMMIT WORK;
330: END IF;
331:
332: -- Standard callto get message count and if count is 1, get message info.
333: FND_MSG_PUB.Count_And_Get
334: ( p_count => x_msg_count,
335: p_data => x_msg_data
336: );