32: IS
33: l_api_name CONSTANT VARCHAR2(30) := 'Create_entyrout';
34: l_api_version_number CONSTANT NUMBER := 2.0;
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT CREATE_ENTYROUT_PUB;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT CREATE_ENTYROUT_PUB;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
97: --
98: -- End of API body.
99: --
100:
101: -- Standard check for p_commit
102: IF FND_API.to_Boolean( p_commit )
103: THEN
104: COMMIT WORK;
105: END IF;
118: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119:
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.
123: FND_MSG_PUB.Count_And_Get
124: ( p_count => x_msg_count,
125: p_data => x_msg_data
126: );
176: IS
177: l_api_name CONSTANT VARCHAR2(30) := 'Update_entyrout';
178: l_api_version_number CONSTANT NUMBER := 2.0;
179: BEGIN
180: -- Standard Start of API savepoint
181: SAVEPOINT UPDATE_ENTYROUT_PUB;
182:
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
179: BEGIN
180: -- Standard Start of API savepoint
181: SAVEPOINT UPDATE_ENTYROUT_PUB;
182:
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
185: p_api_version_number,
186: l_api_name,
187: G_PKG_NAME)
239: --
240: -- End of API body
241: --
242:
243: -- Standard check for p_commit
244: IF FND_API.to_Boolean( p_commit )
245: THEN
246: COMMIT WORK;
247: END IF;
260: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
261:
262: END IF;
263:
264: -- Standard call to get message count and if count is 1, get message info.
265: FND_MSG_PUB.Count_And_Get
266: ( p_count => x_msg_count,
267: p_data => x_msg_data
268: );
319: IS
320: l_api_name CONSTANT VARCHAR2(30) := 'Delete_entyrout';
321: l_api_version_number CONSTANT NUMBER := 2.0;
322: BEGIN
323: -- Standard Start of API savepoint
324: SAVEPOINT DELETE_ENTYROUT_PUB;
325:
326: -- Standard call to check for call compatibility.
327: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: BEGIN
323: -- Standard Start of API savepoint
324: SAVEPOINT DELETE_ENTYROUT_PUB;
325:
326: -- Standard call to check for call compatibility.
327: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
328: p_api_version_number,
329: l_api_name,
330: G_PKG_NAME)
382: --
383: -- End of API body
384: --
385:
386: -- Standard check for p_commit
387: IF FND_API.to_Boolean( p_commit )
388: THEN
389: COMMIT WORK;
390: END IF;
403: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
404:
405: END IF;
406:
407: -- Standard call to get message count and if count is 1, get message info.
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data
411: );