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_MSG_PUB

Line 13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_Monitor_Log_PVT';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlvlmlb.pls';
11:
12:
13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
17:

Line 14: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlvlmlb.pls';
11:
12:
13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
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(

Line 15: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

11:
12:
13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
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

Line 16: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

12:
13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
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

Line 59: FND_MSG_PUB.initialize;

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

Line 63: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

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

Line 71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;

Line 74: FND_MSG_PUB.ADD;

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

Line 85: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

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(

Line 139: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

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

Line 143: FND_MSG_PUB.Count_And_Get

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

Line 152: FND_MSG_PUB.Count_And_Get (

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

Line 161: FND_MSG_PUB.Count_And_Get (

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
165: );

Line 169: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
173: -- Standard call to get message count and if count=1, get the message

Line 171: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 174: FND_MSG_PUB.Count_And_Get (

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

Line 220: FND_MSG_PUB.initialize;

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:
223: -- Debug Message
224: IF (AS_DEBUG_LOW_ON) THEN

Line 225: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

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

Line 234: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Open Cursor to Select');

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 ;

Line 240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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 ;
239: If ( c_get_Monitor_Log%NOTFOUND) THEN
240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 243: FND_MSG_PUB.Add;

239: If ( c_get_Monitor_Log%NOTFOUND) THEN
240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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

Line 249: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Close Cursor');

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

Line 255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
259: END IF;

Line 258: FND_MSG_PUB.ADD;

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;
259: END IF;
260: raise FND_API.G_EXC_ERROR;
261: End if;
262:

Line 264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 267: FND_MSG_PUB.ADD;

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

Line 277: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

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,

Line 327: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

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,

Line 330: FND_MSG_PUB.Count_And_Get

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

Line 339: FND_MSG_PUB.Count_And_Get (

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

Line 348: FND_MSG_PUB.Count_And_Get (

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
352: );

Line 356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
360: -- Standard call to get message count and if count=1, get the message

Line 358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 361: FND_MSG_PUB.Count_And_Get (

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

Line 396: FND_MSG_PUB.initialize;

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:
399: -- Debug Message
400: IF (AS_DEBUG_LOW_ON) THEN

Line 401: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

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;

Line 411: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

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(

Line 429: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

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,

Line 432: FND_MSG_PUB.Count_And_Get

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

Line 441: FND_MSG_PUB.Count_And_Get (

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

Line 450: FND_MSG_PUB.Count_And_Get (

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
454: );

Line 458: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
462: -- Standard call to get message count and if count=1, get the message

Line 460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 463: FND_MSG_PUB.Count_And_Get (

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