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_PRETTY_URL_PVT dependencies on FND_MSG_PUB

Line 163: FND_MSG_PUB.add;

159: x_return_status := FND_API.g_ret_sts_error;
160: FND_MESSAGE.set_name('AMS', 'AMS_PRETTY_URL_NOT_UNIQUE_ERR');
161: FND_MESSAGE.set_token('SCHEDULENAME', l_scheduleName);
162: FND_MESSAGE.set_token('OWNER', l_ownerName);
163: FND_MSG_PUB.add;
164: RETURN;
165: END IF;
166: END IF;
167: END IF;

Line 219: FND_MSG_PUB.initialize;

215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list )
218: THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 309: FND_MSG_PUB.Count_And_Get

305: -- Debug Message
306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313: EXCEPTION

Line 323: FND_MSG_PUB.Count_And_Get (

319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO CREATE_Pretty_Url_PVT;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: -- Standard call to get message count and if count=1, get the message
323: FND_MSG_PUB.Count_And_Get (
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );

Line 333: FND_MSG_PUB.Count_And_Get (

329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: ROLLBACK TO CREATE_Pretty_Url_PVT;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );

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

338:
339: WHEN OTHERS THEN
340: ROLLBACK TO CREATE_Pretty_Url_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message

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

340: ROLLBACK TO CREATE_Pretty_Url_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,

Line 347: FND_MSG_PUB.Count_And_Get (

343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );

Line 399: FND_MSG_PUB.initialize;

395:
396: -- Initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean( p_init_msg_list )
398: THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Debug Message
403: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

461: END IF;
462:
463:
464: -- Debug Message
465: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
466:
467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)
468: AMS_PRETTY_URL_PKG.Update_Row(
469: p_pretty_url_id => p_pretty_url_rec.pretty_url_id,

Line 492: FND_MSG_PUB.Count_And_Get

488: -- Debug Message
489: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
490:
491: -- Standard call to get message count and if count is 1, get message info.
492: FND_MSG_PUB.Count_And_Get
493: (p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496: EXCEPTION

Line 506: FND_MSG_PUB.Count_And_Get (

502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO UPDATE_Pretty_Url_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: -- Standard call to get message count and if count=1, get the message
506: FND_MSG_PUB.Count_And_Get (
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data
510: );

Line 516: FND_MSG_PUB.Count_And_Get (

512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO UPDATE_Pretty_Url_PVT;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );

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

521:
522: WHEN OTHERS THEN
523: ROLLBACK TO UPDATE_Pretty_Url_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message

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

523: ROLLBACK TO UPDATE_Pretty_Url_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,

Line 530: FND_MSG_PUB.Count_And_Get (

526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data
534: );

Line 571: FND_MSG_PUB.initialize;

567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF FND_API.to_Boolean( p_init_msg_list )
570: THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: -- Debug Message
575: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 605: FND_MSG_PUB.Count_And_Get

601: -- Debug Message
602: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count,
607: p_data => x_msg_data
608: );
609: EXCEPTION

Line 619: FND_MSG_PUB.Count_And_Get (

615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO DELETE_Pretty_Url_PVT;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data
623: );

Line 629: FND_MSG_PUB.Count_And_Get (

625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: ROLLBACK TO DELETE_Pretty_Url_PVT;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );

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

634:
635: WHEN OTHERS THEN
636: ROLLBACK TO DELETE_Pretty_Url_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message

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

636: ROLLBACK TO DELETE_Pretty_Url_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,

Line 643: FND_MSG_PUB.Count_And_Get (

639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );

Line 686: FND_MSG_PUB.initialize;

682:
683: -- Initialize message list if p_init_msg_list is set to TRUE.
684: IF FND_API.to_Boolean( p_init_msg_list )
685: THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

708: FETCH c_Pretty_Url INTO l_PRETTY_URL_ID;
709:
710: IF (c_Pretty_Url%NOTFOUND) THEN
711: CLOSE c_Pretty_Url;
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
714: FND_MSG_PUB.add;
715: END IF;
716: RAISE FND_API.g_exc_error;

Line 714: FND_MSG_PUB.add;

710: IF (c_Pretty_Url%NOTFOUND) THEN
711: CLOSE c_Pretty_Url;
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
714: FND_MSG_PUB.add;
715: END IF;
716: RAISE FND_API.g_exc_error;
717: END IF;
718:

Line 722: FND_MSG_PUB.count_and_get(

718:
719: CLOSE c_Pretty_Url;
720:
721: -------------------- finish --------------------------
722: FND_MSG_PUB.count_and_get(
723: p_encoded => FND_API.g_false,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 737: FND_MSG_PUB.Count_And_Get (

733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO LOCK_Pretty_Url_PVT;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );

Line 747: FND_MSG_PUB.Count_And_Get (

743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: ROLLBACK TO LOCK_Pretty_Url_PVT;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );

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

752:
753: WHEN OTHERS THEN
754: ROLLBACK TO LOCK_Pretty_Url_PVT;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message

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

754: ROLLBACK TO LOCK_Pretty_Url_PVT;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,

Line 761: FND_MSG_PUB.Count_And_Get (

757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );

Line 1061: FND_MSG_PUB.initialize;

1057:
1058: -- Initialize message list if p_init_msg_list is set to TRUE.
1059: IF FND_API.to_Boolean( p_init_msg_list )
1060: THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_pretty_url_Items(
1065: p_pretty_url_rec => p_pretty_url_rec,

Line 1111: FND_MSG_PUB.Count_And_Get

1107: -- Debug Message
1108: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get
1112: (p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115: EXCEPTION

Line 1125: FND_MSG_PUB.Count_And_Get (

1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK TO VALIDATE_Pretty_Url_;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );

Line 1135: FND_MSG_PUB.Count_And_Get (

1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: ROLLBACK TO VALIDATE_Pretty_Url_;
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );

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

1140:
1141: WHEN OTHERS THEN
1142: ROLLBACK TO VALIDATE_Pretty_Url_;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message

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

1142: ROLLBACK TO VALIDATE_Pretty_Url_;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,

Line 1149: FND_MSG_PUB.Count_And_Get (

1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );

Line 1170: FND_MSG_PUB.initialize;

1166: BEGIN
1167: -- Initialize message list if p_init_msg_list is set to TRUE.
1168: IF FND_API.to_Boolean( p_init_msg_list )
1169: THEN
1170: FND_MSG_PUB.initialize;
1171: END IF;
1172:
1173: -- Initialize API return status to SUCCESS
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1184: FND_MSG_PUB.Count_And_Get

1180:
1181: -- Debug Message
1182: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1183: -- Standard call to get message count and if count is 1, get message info.
1184: FND_MSG_PUB.Count_And_Get
1185: (p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );
1188: END Validate_pretty_url_Rec;

Line 1218: FND_MSG_PUB.add;

1214: WRITE_LOG(l_api_name, 'Pretty Url Id not found');
1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here
1216: x_return_status := FND_API.g_ret_sts_error;
1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');
1218: FND_MSG_PUB.add;
1219: RETURN;
1220: END IF;
1221:
1222: IF p_pretty_url_rec.landing_page_url = FND_API.g_miss_char OR p_pretty_url_rec.landing_page_url IS NULL THEN

Line 1227: FND_MSG_PUB.add;

1223: WRITE_LOG(l_api_name, 'Landing page Url not found');
1224: --AMS_Utility_PVT.Error_Message('AMS_REQ_FIELDS_NOT_MAPPED');
1225: x_return_status := FND_API.g_ret_sts_error;
1226: FND_MESSAGE.set_name('AMS', 'AMS_PU_REQ_FIELDS_NOT_MAPPED');
1227: FND_MSG_PUB.add;
1228: RETURN;
1229: END IF;
1230:
1231: END CHECK_PU_MANDATORY_FIELDS;