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_PRTY_URL_ASSOC_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 163: FND_MSG_PUB.Count_And_Get

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

Line 177: FND_MSG_PUB.Count_And_Get (

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

Line 187: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 201: FND_MSG_PUB.Count_And_Get (

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

Line 253: FND_MSG_PUB.initialize;

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

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

315: END IF;
316:
317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Update_Row)
322: AMS_PRETTY_URL_ASSOC_PKG.Update_Row(
323: p_assoc_id => p_prty_url_assoc_rec.assoc_id,

Line 348: FND_MSG_PUB.Count_And_Get

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

Line 362: FND_MSG_PUB.Count_And_Get (

358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
366: );

Line 372: FND_MSG_PUB.Count_And_Get (

368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: -- Standard call to get message count and if count=1, get the message
372: FND_MSG_PUB.Count_And_Get (
373: p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data
376: );

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

377:
378: WHEN OTHERS THEN
379: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
384: END IF;
385: -- Standard call to get message count and if count=1, get the message

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

379: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
384: END IF;
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.Count_And_Get (
387: p_encoded => FND_API.G_FALSE,

Line 386: FND_MSG_PUB.Count_And_Get (

382: THEN
383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
384: END IF;
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.Count_And_Get (
387: p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data
390: );

Line 427: FND_MSG_PUB.initialize;

423:
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )
426: THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Debug Message
431: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 461: FND_MSG_PUB.Count_And_Get

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

Line 475: FND_MSG_PUB.Count_And_Get (

471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
479: );

Line 485: FND_MSG_PUB.Count_And_Get (

481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );

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

490:
491: WHEN OTHERS THEN
492: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message

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

492: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,

Line 499: FND_MSG_PUB.Count_And_Get (

495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );

Line 542: FND_MSG_PUB.initialize;

538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.
540: IF FND_API.to_Boolean( p_init_msg_list )
541: THEN
542: FND_MSG_PUB.initialize;
543: END IF;
544:
545: -- Standard call to check for call compatibility.
546: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

564: FETCH c_Prty_Url_Assoc INTO l_ASSOC_ID;
565:
566: IF (c_Prty_Url_Assoc%NOTFOUND) THEN
567: CLOSE c_Prty_Url_Assoc;
568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
569: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
570: FND_MSG_PUB.add;
571: END IF;
572: RAISE FND_API.g_exc_error;

Line 570: FND_MSG_PUB.add;

566: IF (c_Prty_Url_Assoc%NOTFOUND) THEN
567: CLOSE c_Prty_Url_Assoc;
568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
569: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
570: FND_MSG_PUB.add;
571: END IF;
572: RAISE FND_API.g_exc_error;
573: END IF;
574:

Line 578: FND_MSG_PUB.count_and_get(

574:
575: CLOSE c_Prty_Url_Assoc;
576:
577: -------------------- finish --------------------------
578: FND_MSG_PUB.count_and_get(
579: p_encoded => FND_API.g_false,
580: p_count => x_msg_count,
581: p_data => x_msg_data);
582: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 593: FND_MSG_PUB.Count_And_Get (

589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: -- Standard call to get message count and if count=1, get the message
593: FND_MSG_PUB.Count_And_Get (
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data
597: );

Line 603: FND_MSG_PUB.Count_And_Get (

599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: -- Standard call to get message count and if count=1, get the message
603: FND_MSG_PUB.Count_And_Get (
604: p_encoded => FND_API.G_FALSE,
605: p_count => x_msg_count,
606: p_data => x_msg_data
607: );

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

608:
609: WHEN OTHERS THEN
610: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message

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

610: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,

Line 617: FND_MSG_PUB.Count_And_Get (

613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );

Line 954: FND_MSG_PUB.initialize;

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

Line 1004: FND_MSG_PUB.Count_And_Get

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

Line 1018: FND_MSG_PUB.Count_And_Get (

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

Line 1028: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1042: FND_MSG_PUB.Count_And_Get (

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

Line 1063: FND_MSG_PUB.initialize;

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

Line 1077: FND_MSG_PUB.Count_And_Get

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