eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AML_MONITOR_LOG_PVT dependencies on FND_API

Line 20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

16: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
17:
18: PROCEDURE Create_Monitor_Log(
19: p_api_version_number IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,p_monitor_log_rec IN monitor_log_rec_type := g_miss_monitor_log_rec
24: ,x_monitor_log_id OUT NOCOPY NUMBER

Line 21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

17:
18: PROCEDURE Create_Monitor_Log(
19: p_api_version_number IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,p_monitor_log_rec IN monitor_log_rec_type := g_miss_monitor_log_rec
24: ,x_monitor_log_id OUT NOCOPY NUMBER
25: ,x_return_status OUT NOCOPY VARCHAR2

Line 22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

18: PROCEDURE Create_Monitor_Log(
19: p_api_version_number IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,p_monitor_log_rec IN monitor_log_rec_type := g_miss_monitor_log_rec
24: ,x_monitor_log_id OUT NOCOPY NUMBER
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER

Line 34: l_org_id NUMBER ; --:= FND_API.G_MISS_NUM;

30: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Monitor_Log';
31: L_API_VERSION_NUMBER CONSTANT NUMBER := 2.0;
32: l_return_status_full VARCHAR2(1);
33: l_object_version_number NUMBER := 1;
34: l_org_id NUMBER ; --:= FND_API.G_MISS_NUM;
35: l_monitor_log_id NUMBER;
36: l_dummy NUMBER;
37: CURSOR c_id IS
38: SELECT aml_monitor_log_s.NEXTVAL

Line 48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: IF FND_API.to_Boolean( p_init_msg_list )

Line 57: IF FND_API.to_Boolean( p_init_msg_list )

53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: IF FND_API.to_Boolean( p_init_msg_list )
58: THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61: -- Debug Message

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: END IF;
65:
66:
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF FND_GLOBAL.User_Id IS NULL THEN
71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
72: FND_MESSAGE.Set_Name('AMS', 'UT_CANNOT_GET_PROFILE_VALUE');

Line 76: RAISE FND_API.G_EXC_ERROR;

72: FND_MESSAGE.Set_Name('AMS', 'UT_CANNOT_GET_PROFILE_VALUE');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
79: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
80: RAISE FND_API.G_EXC_ERROR;

Line 79: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

75: END IF;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
79: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: -- Debug Message

Line 80: RAISE FND_API.G_EXC_ERROR;

76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
79: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: -- Debug Message
84: IF (AS_DEBUG_LOW_ON) THEN

Line 126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

122: p_attribute15 => p_monitor_log_rec.attribute15
123: );
124:
125: x_monitor_log_id := l_monitor_log_id;
126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129: --
130: -- End of API body

Line 127: RAISE FND_API.G_EXC_ERROR;

123: );
124:
125: x_monitor_log_id := l_monitor_log_id;
126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129: --
130: -- End of API body
131: --

Line 133: IF FND_API.to_Boolean( p_commit )

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;
137: -- Debug Message

Line 148: WHEN FND_API.G_EXC_ERROR THEN

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 (

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

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,

Line 153: p_encoded => FND_API.G_FALSE,

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

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 (

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 162: p_encoded => FND_API.G_FALSE,

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
165: );
166: WHEN OTHERS THEN

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164: p_data => x_msg_data
165: );
166: WHEN OTHERS THEN
167: ROLLBACK TO CREATE_Monitor_Log_PVT;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 175: p_encoded => FND_API.G_FALSE,

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
178: );
179: End Create_Monitor_Log;

Line 184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

180:
181:
182: PROCEDURE Update_Monitor_Log(
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_monitor_log_rec IN monitor_log_rec_type ,
188: x_return_status OUT NOCOPY VARCHAR2,

Line 185: p_commit IN VARCHAR2 := FND_API.G_FALSE,

181:
182: PROCEDURE Update_Monitor_Log(
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_monitor_log_rec IN monitor_log_rec_type ,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

Line 186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

182: PROCEDURE Update_Monitor_Log(
183: p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_monitor_log_rec IN monitor_log_rec_type ,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2

Line 209: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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)
213: THEN

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: p_api_version_number,
211: l_api_name,
212: G_PKG_NAME)
213: THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list )

Line 218: IF FND_API.to_Boolean( p_init_msg_list )

214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list )
219: THEN
220: FND_MSG_PUB.initialize;
221: END IF;
222:

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

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');

Line 245: RAISE FND_API.G_EXC_ERROR;

241: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
242: FND_MESSAGE.Set_Token ('INFO', 'Monitor_log', FALSE);
243: FND_MSG_PUB.Add;
244: END IF;
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');

Line 254: l_tar_monitor_log_rec.last_update_date = FND_API.G_MISS_DATE ) Then

250: END IF;
251: CLOSE c_get_Monitor_Log;
252:
253: If (l_tar_monitor_log_rec.last_update_date is NULL or
254: l_tar_monitor_log_rec.last_update_date = FND_API.G_MISS_DATE ) Then
255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_ID');
257: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
258: FND_MSG_PUB.ADD;

Line 260: raise FND_API.G_EXC_ERROR;

256: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_ID');
257: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
258: FND_MSG_PUB.ADD;
259: END IF;
260: raise FND_API.G_EXC_ERROR;
261: End if;
262:
263: If (to_char(l_tar_monitor_log_rec.last_update_date,'DD-MON-RRRR') <> TO_CHAR(l_ref_monitor_log_rec.last_update_date,'DD-MON-RRRR')) Then
264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 269: raise FND_API.G_EXC_ERROR;

265: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
266: FND_MESSAGE.Set_Token('INFO', 'Monitor_Log', FALSE);
267: FND_MSG_PUB.ADD;
268: END IF;
269: raise FND_API.G_EXC_ERROR;
270: End if;
271:
272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
273: RAISE FND_API.G_EXC_ERROR;

Line 272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

268: END IF;
269: raise FND_API.G_EXC_ERROR;
270: End if;
271:
272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: -- Debug Message
276: IF (AS_DEBUG_LOW_ON) THEN

Line 273: RAISE FND_API.G_EXC_ERROR;

269: raise FND_API.G_EXC_ERROR;
270: End if;
271:
272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
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');

Line 320: IF FND_API.to_Boolean( p_commit )

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;
324:

Line 335: WHEN FND_API.G_EXC_ERROR THEN

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 (

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

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,

Line 340: p_encoded => FND_API.G_FALSE,

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

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 (

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 349: p_encoded => FND_API.G_FALSE,

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
352: );
353: WHEN OTHERS THEN

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351: p_data => x_msg_data
352: );
353: WHEN OTHERS THEN
354: ROLLBACK TO UPDATE_Monitor_Log_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 362: p_encoded => FND_API.G_FALSE,

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
365: );
366: End Update_Monitor_Log;

Line 370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

366: End Update_Monitor_Log;
367:
368: PROCEDURE Delete_Monitor_Log(
369: p_api_version_number IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_monitor_log_id IN NUMBER,
374: x_return_status OUT NOCOPY VARCHAR2,

Line 371: p_commit IN VARCHAR2 := FND_API.G_FALSE,

367:
368: PROCEDURE Delete_Monitor_Log(
369: p_api_version_number IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_monitor_log_id IN NUMBER,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,

Line 372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

368: PROCEDURE Delete_Monitor_Log(
369: p_api_version_number IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_monitor_log_id IN NUMBER,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2

Line 386: IF NOT FND_API.Compatible_API_Call ( l_api_version_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)
390: THEN

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: p_api_version_number,
388: l_api_name,
389: G_PKG_NAME)
390: THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393: -- Initialize message list if p_init_msg_list is set to TRUE.
394: IF FND_API.to_Boolean( p_init_msg_list )
395: THEN

Line 394: IF FND_API.to_Boolean( p_init_msg_list )

390: THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393: -- Initialize message list if p_init_msg_list is set to TRUE.
394: IF FND_API.to_Boolean( p_init_msg_list )
395: THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
406: --
407: -- Api body
408: --
409: -- Debug Message

Line 423: IF FND_API.to_Boolean( p_commit )

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

Line 437: WHEN FND_API.G_EXC_ERROR THEN

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 (

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

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,

Line 442: p_encoded => FND_API.G_FALSE,

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

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 (

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 451: p_encoded => FND_API.G_FALSE,

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
454: );
455: WHEN OTHERS THEN

Line 457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

453: p_data => x_msg_data
454: );
455: WHEN OTHERS THEN
456: ROLLBACK TO DELETE_Monitor_Log_PVT;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 464: p_encoded => FND_API.G_FALSE,

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
467: );
468: End Delete_Monitor_Log;