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.AMS_SYSTEM_PRETTY_URL_PVT dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 166: FND_MSG_PUB.Count_And_Get

162: -- Debug Message
163: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: (p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: EXCEPTION

Line 180: FND_MSG_PUB.Count_And_Get (

176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );

Line 190: FND_MSG_PUB.Count_And_Get (

186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_MSG_PUB.Count_And_Get (
191: p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data
194: );

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

195:
196: WHEN OTHERS THEN
197: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
202: END IF;
203: -- Standard call to get message count and if count=1, get the message

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

197: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
202: END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,

Line 204: FND_MSG_PUB.Count_And_Get (

200: THEN
201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
202: END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );

Line 256: FND_MSG_PUB.initialize;

252:
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF FND_API.to_Boolean( p_init_msg_list )
255: THEN
256: FND_MSG_PUB.initialize;
257: END IF;
258:
259: -- Debug Message
260: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

318: END IF;
319:
320:
321: -- Debug Message
322: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
323:
324: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Update_Row)
325: AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(
326: p_system_url_id => p_system_pretty_url_rec.system_url_id,

Line 353: FND_MSG_PUB.Count_And_Get

349: -- Debug Message
350: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count,
355: p_data => x_msg_data
356: );
357: EXCEPTION

Line 367: FND_MSG_PUB.Count_And_Get (

363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: -- Standard call to get message count and if count=1, get the message
367: FND_MSG_PUB.Count_And_Get (
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );

Line 377: FND_MSG_PUB.Count_And_Get (

373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: -- Standard call to get message count and if count=1, get the message
377: FND_MSG_PUB.Count_And_Get (
378: p_encoded => FND_API.G_FALSE,
379: p_count => x_msg_count,
380: p_data => x_msg_data
381: );

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

382:
383: WHEN OTHERS THEN
384: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
389: END IF;
390: -- Standard call to get message count and if count=1, get the message

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

384: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
389: END IF;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,

Line 391: FND_MSG_PUB.Count_And_Get (

387: THEN
388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
389: END IF;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );

Line 432: FND_MSG_PUB.initialize;

428:
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Debug Message
436: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 466: FND_MSG_PUB.Count_And_Get

462: -- Debug Message
463: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: (p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470: EXCEPTION

Line 480: FND_MSG_PUB.Count_And_Get (

476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );

Line 490: FND_MSG_PUB.Count_And_Get (

486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );

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

495:
496: WHEN OTHERS THEN
497: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message

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

497: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,

Line 504: FND_MSG_PUB.Count_And_Get (

500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
508: );

Line 547: FND_MSG_PUB.initialize;

543:
544: -- Initialize message list if p_init_msg_list is set to TRUE.
545: IF FND_API.to_Boolean( p_init_msg_list )
546: THEN
547: FND_MSG_PUB.initialize;
548: END IF;
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

569: FETCH c_System_Pretty_Url INTO l_SYSTEM_URL_ID;
570:
571: IF (c_System_Pretty_Url%NOTFOUND) THEN
572: CLOSE c_System_Pretty_Url;
573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
574: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
575: FND_MSG_PUB.add;
576: END IF;
577: RAISE FND_API.g_exc_error;

Line 575: FND_MSG_PUB.add;

571: IF (c_System_Pretty_Url%NOTFOUND) THEN
572: CLOSE c_System_Pretty_Url;
573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
574: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
575: FND_MSG_PUB.add;
576: END IF;
577: RAISE FND_API.g_exc_error;
578: END IF;
579:

Line 583: FND_MSG_PUB.count_and_get(

579:
580: CLOSE c_System_Pretty_Url;
581:
582: -------------------- finish --------------------------
583: FND_MSG_PUB.count_and_get(
584: p_encoded => FND_API.g_false,
585: p_count => x_msg_count,
586: p_data => x_msg_data);
587: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 598: FND_MSG_PUB.Count_And_Get (

594: WHEN FND_API.G_EXC_ERROR THEN
595: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: -- Standard call to get message count and if count=1, get the message
598: FND_MSG_PUB.Count_And_Get (
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data
602: );

Line 608: FND_MSG_PUB.Count_And_Get (

604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: -- Standard call to get message count and if count=1, get the message
608: FND_MSG_PUB.Count_And_Get (
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data
612: );

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

613:
614: WHEN OTHERS THEN
615: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
620: END IF;
621: -- Standard call to get message count and if count=1, get the message

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

615: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
620: END IF;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,

Line 622: FND_MSG_PUB.Count_And_Get (

618: THEN
619: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
620: END IF;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
626: );

Line 956: FND_MSG_PUB.initialize;

952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean( p_init_msg_list )
955: THEN
956: FND_MSG_PUB.initialize;
957: END IF;
958: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
959: CHECK_SYS_PRETTY_URL_ITM(
960: p_system_pretty_url_rec => p_system_pretty_url_rec,

Line 1006: FND_MSG_PUB.Count_And_Get

1002: -- Debug Message
1003: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1004:
1005: -- Standard call to get message count and if count is 1, get message info.
1006: FND_MSG_PUB.Count_And_Get
1007: (p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1010: EXCEPTION

Line 1020: FND_MSG_PUB.Count_And_Get (

1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: -- Standard call to get message count and if count=1, get the message
1020: FND_MSG_PUB.Count_And_Get (
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data
1024: );

Line 1030: FND_MSG_PUB.Count_And_Get (

1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: -- Standard call to get message count and if count=1, get the message
1030: FND_MSG_PUB.Count_And_Get (
1031: p_encoded => FND_API.G_FALSE,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );

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

1035:
1036: WHEN OTHERS THEN
1037: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1042: END IF;
1043: -- Standard call to get message count and if count=1, get the message

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

1037: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1042: END IF;
1043: -- Standard call to get message count and if count=1, get the message
1044: FND_MSG_PUB.Count_And_Get (
1045: p_encoded => FND_API.G_FALSE,

Line 1044: FND_MSG_PUB.Count_And_Get (

1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1042: END IF;
1043: -- Standard call to get message count and if count=1, get the message
1044: FND_MSG_PUB.Count_And_Get (
1045: p_encoded => FND_API.G_FALSE,
1046: p_count => x_msg_count,
1047: p_data => x_msg_data
1048: );

Line 1065: FND_MSG_PUB.initialize;

1061: BEGIN
1062: -- Initialize message list if p_init_msg_list is set to TRUE.
1063: IF FND_API.to_Boolean( p_init_msg_list )
1064: THEN
1065: FND_MSG_PUB.initialize;
1066: END IF;
1067:
1068: -- Initialize API return status to SUCCESS
1069: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1079: FND_MSG_PUB.Count_And_Get

1075:
1076: -- Debug Message
1077: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1078: -- Standard call to get message count and if count is 1, get message info.
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083: END Validate_system_pretty_url_Rec;