59: FND_MSG_PUB.initialize;
60: END IF;
61: -- Debug Message
62: IF (AS_DEBUG_LOW_ON) THEN
63: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
64: END IF;
65:
66:
67: -- Initialize API return status to SUCCESS
81: END IF;
82:
83: -- Debug Message
84: IF (AS_DEBUG_LOW_ON) THEN
85: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
86: END IF;
87:
88: -- Invoke table handler(As_Monitor_Log_Pkg.Insert_Row)
89: Aml_Monitor_Log_Pkg.Insert_Row(
135: COMMIT WORK;
136: END IF;
137: -- Debug Message
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
221: END IF;
222:
223: -- Debug Message
224: IF (AS_DEBUG_LOW_ON) THEN
225: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
226: END IF;
227:
228:
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: -- Debug Message
233: IF (AS_DEBUG_LOW_ON) THEN
234: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Open Cursor to Select');
235: END IF;
236:
237: OPEN c_get_Monitor_Log( l_tar_monitor_log_rec.monitor_log_id);
238: FETCH c_get_Monitor_Log INTO l_ref_monitor_log_rec ;
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: -- Debug Message
248: IF (AS_DEBUG_LOW_ON) THEN
249: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Close Cursor');
250: END IF;
251: CLOSE c_get_Monitor_Log;
252:
253: If (l_tar_monitor_log_rec.last_update_date is NULL or
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: -- Debug Message
276: IF (AS_DEBUG_LOW_ON) THEN
277: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
278: END IF;
279: -- Invoke table handler(As_Monitor_Log_Pkg.Update_Row)
280: AML_Monitor_Log_Pkg.Update_Row(
281: p_monitor_log_id => p_monitor_log_rec.monitor_log_id,
323: END IF;
324:
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,
397: END IF;
398:
399: -- Debug Message
400: IF (AS_DEBUG_LOW_ON) THEN
401: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
402: END IF;
403:
404: -- Initialize API return status to SUCCESS
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
407: -- Api body
408: --
409: -- Debug Message
410: IF (AS_DEBUG_LOW_ON) THEN
411: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
412: END IF;
413:
414: -- Invoke table handler(As_Monitor_Log_Pkg.Delete_Row)
415: AMl_Monitor_Log_Pkg.Delete_Row(
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,