[Home] [Help]
41: SELECT 1
42: FROM AML_MONITOR_LOG
43: WHERE monitor_log_id = l_id;
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT create_monitor_log_pvt;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: p_api_version_number,
43: WHERE monitor_log_id = l_id;
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT create_monitor_log_pvt;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
128: END IF;
129: --
130: -- End of API body
131: --
132: -- Standard check for p_commit
133: IF FND_API.to_Boolean( p_commit )
134: THEN
135: COMMIT WORK;
136: END IF;
138: IF (AS_DEBUG_LOW_ON) THEN
139: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
140: END IF;
141:
142: -- Standard call to get message count and if count is 1, get message info.
143: FND_MSG_PUB.Count_And_Get
144: (p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO CREATE_Monitor_Log_PVT;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: -- Standard call to get message count and if count=1, get the message
152: FND_MSG_PUB.Count_And_Get (
153: p_encoded => FND_API.G_FALSE,
154: p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO CREATE_Monitor_Log_PVT;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: -- Standard call to get message count and if count=1, get the message
161: FND_MSG_PUB.Count_And_Get (
162: p_encoded => FND_API.G_FALSE,
163: p_count => x_msg_count,
164: p_data => x_msg_data
169: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
170: THEN
171: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
172: END IF;
173: -- Standard call to get message count and if count=1, get the message
174: FND_MSG_PUB.Count_And_Get (
175: p_encoded => FND_API.G_FALSE,
176: p_count => x_msg_count,
177: p_data => x_msg_data
202: l_ref_monitor_log_rec c_get_Monitor_Log%ROWTYPE ;
203: l_tar_monitor_log_rec monitor_log_rec_type := P_monitor_log_rec;
204: l_rowid ROWID;
205: BEGIN
206: -- Standard Start of API savepoint
207: SAVEPOINT update_monitor_log_pvt;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
210: p_api_version_number,
204: l_rowid ROWID;
205: BEGIN
206: -- Standard Start of API savepoint
207: SAVEPOINT update_monitor_log_pvt;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
210: p_api_version_number,
211: l_api_name,
212: G_PKG_NAME)
315: --
316: -- End of API body.
317: --
318:
319: -- Standard check for p_commit
320: IF FND_API.to_Boolean( p_commit )
321: THEN
322: COMMIT WORK;
323: END IF;
325: -- Debug Message
326: IF (AS_DEBUG_LOW_ON) THEN
327: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
328: END IF;
329: -- Standard call to get message count and if count is 1, get message info.
330: FND_MSG_PUB.Count_And_Get
331: (p_count => x_msg_count,
332: p_data => x_msg_data
333: );
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO UPDATE_Monitor_Log_PVT;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: -- Standard call to get message count and if count=1, get the message
339: FND_MSG_PUB.Count_And_Get (
340: p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO UPDATE_Monitor_Log_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360: -- Standard call to get message count and if count=1, get the message
361: FND_MSG_PUB.Count_And_Get (
362: p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data
379: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Monitor_Log';
380: L_API_VERSION_NUMBER CONSTANT NUMBER := 2.0;
381: l_object_version_number NUMBER;
382: BEGIN
383: -- Standard Start of API savepoint
384: SAVEPOINT delete_monitor_log_pvt;
385: -- Standard call to check for call compatibility.
386: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
387: p_api_version_number,
381: l_object_version_number NUMBER;
382: BEGIN
383: -- Standard Start of API savepoint
384: SAVEPOINT delete_monitor_log_pvt;
385: -- Standard call to check for call compatibility.
386: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
387: p_api_version_number,
388: l_api_name,
389: G_PKG_NAME)
418: );
419: --
420: -- End of API body
421: --
422: -- Standard check for p_commit
423: IF FND_API.to_Boolean( p_commit )
424: THEN
425: COMMIT WORK;
426: END IF;
427: -- Debug Message
428: IF (AS_DEBUG_LOW_ON) THEN
429: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
430: END IF;
431: -- Standard call to get message count and if count is 1, get message info.
432: FND_MSG_PUB.Count_And_Get
433: (p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO DELETE_Monitor_Log_PVT;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: -- Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO DELETE_Monitor_Log_PVT;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
458: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
461: END IF;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data