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

Line 20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Iba_Pl_Sites_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvsitb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: function check_site_pages(

Line 21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Iba_Pl_Sites_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvsitb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: function check_site_pages(
25: p_site_id IN NUMBER

Line 22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvsitb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: function check_site_pages(
25: p_site_id IN NUMBER
26: , p_validation_mode IN VARCHAR2

Line 164: FND_MSG_PUB.initialize;

160:
161: -- Initialize message list if p_init_msg_list is set to TRUE.
162: IF FND_API.to_Boolean( p_init_msg_list )
163: THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: -- Debug Message
168: IF (AMS_DEBUG_HIGH_ON) THEN

Line 273: FND_MSG_PUB.Count_And_Get

269: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
270: END IF;
271:
272: -- Standard call to get message count and if count is 1, get message info.
273: FND_MSG_PUB.Count_And_Get
274: (p_count => x_msg_count,
275: p_data => x_msg_data
276: );
277: EXCEPTION

Line 287: FND_MSG_PUB.Count_And_Get (

283: WHEN FND_API.G_EXC_ERROR THEN
284: ROLLBACK TO CREATE_Iba_Pl_Sites_PVT;
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: -- Standard call to get message count and if count=1, get the message
287: FND_MSG_PUB.Count_And_Get (
288: p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data
291: );

Line 297: FND_MSG_PUB.Count_And_Get (

293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO CREATE_Iba_Pl_Sites_PVT;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );

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

302:
303: WHEN OTHERS THEN
304: ROLLBACK TO CREATE_Iba_Pl_Sites_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
309: END IF;
310: -- Standard call to get message count and if count=1, get the message

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

304: ROLLBACK TO CREATE_Iba_Pl_Sites_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
309: END IF;
310: -- Standard call to get message count and if count=1, get the message
311: FND_MSG_PUB.Count_And_Get (
312: p_encoded => FND_API.G_FALSE,

Line 311: FND_MSG_PUB.Count_And_Get (

307: THEN
308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
309: END IF;
310: -- Standard call to get message count and if count=1, get the message
311: FND_MSG_PUB.Count_And_Get (
312: p_encoded => FND_API.G_FALSE,
313: p_count => x_msg_count,
314: p_data => x_msg_data
315: );

Line 369: FND_MSG_PUB.initialize;

365:
366: -- Initialize message list if p_init_msg_list is set to TRUE.
367: IF FND_API.to_Boolean( p_init_msg_list )
368: THEN
369: FND_MSG_PUB.initialize;
370: END IF;
371:
372: -- Debug Message
373: IF (AMS_DEBUG_HIGH_ON) THEN

Line 446: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

442: -- );
443: --
444: -- IF ((l_sitename_changed=fnd_api.g_true) or (l_siterefcode_changed = fnd_api.g_true))
445: -- THEN
446: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
447: -- THEN
448: -- FND_MESSAGE.set_name('AMS','AMS_PLCE_SEED_SITE_NOUPD');
449: -- FND_MSG_PUB.add;
450: -- END IF;

Line 449: -- FND_MSG_PUB.add;

445: -- THEN
446: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
447: -- THEN
448: -- FND_MESSAGE.set_name('AMS','AMS_PLCE_SEED_SITE_NOUPD');
449: -- FND_MSG_PUB.add;
450: -- END IF;
451: -- RAISE FND_API.g_exc_error;
452: -- END IF;
453: -- end if;

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

468: );
469:
470: IF (l_siterefcode_changed = fnd_api.g_true)
471: THEN
472: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
473: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_PG_REF_NOUPD');
474: FND_MSG_PUB.add;
475: END IF;
476: RAISE FND_API.g_exc_error;

Line 474: FND_MSG_PUB.add;

470: IF (l_siterefcode_changed = fnd_api.g_true)
471: THEN
472: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
473: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_PG_REF_NOUPD');
474: FND_MSG_PUB.add;
475: END IF;
476: RAISE FND_API.g_exc_error;
477: END IF;
478: END IF;

Line 514: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;

510: END IF;
511:
512:
513: -- Debug Message
514: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
515: IF (AMS_DEBUG_HIGH_ON) THEN
516:
517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);
518: END IF;

Line 554: FND_MSG_PUB.Count_And_Get

550: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
551: END IF;
552:
553: -- Standard call to get message count and if count is 1, get message info.
554: FND_MSG_PUB.Count_And_Get
555: (p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: EXCEPTION

Line 568: FND_MSG_PUB.Count_And_Get (

564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO UPDATE_Iba_Pl_Sites_PVT;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 582: FND_MSG_PUB.Count_And_Get (

578: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Updte method - unexpected exception area');
579: END IF;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (
583: p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => x_msg_data
586: );

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

591: IF (AMS_DEBUG_HIGH_ON) THEN
592:
593: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Update method - others exception area');
594: END IF;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message

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

593: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Update method - others exception area');
594: END IF;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,

Line 600: FND_MSG_PUB.Count_And_Get (

596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );

Line 647: FND_MSG_PUB.initialize;

643:
644: -- Initialize message list if p_init_msg_list is set to TRUE.
645: IF FND_API.to_Boolean( p_init_msg_list )
646: THEN
647: FND_MSG_PUB.initialize;
648: END IF;
649:
650: -- Debug Message
651: IF (AMS_DEBUG_HIGH_ON) THEN

Line 699: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

695:
696: AMS_UTILITY_PVT.debug_message('Private API: Just after calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);
697: END IF;
698: -- ELSE -- VERSIONS DOESN'T MATCH
699: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
700: -- THEN
701: -- FND_MESSAGE.set_name('AMS','AMS_API_VERS_DONT_MATCH');
702: -- FND_MSG_PUB.add;
703: -- END IF;

Line 702: -- FND_MSG_PUB.add;

698: -- ELSE -- VERSIONS DOESN'T MATCH
699: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
700: -- THEN
701: -- FND_MESSAGE.set_name('AMS','AMS_API_VERS_DONT_MATCH');
702: -- FND_MSG_PUB.add;
703: -- END IF;
704: -- RAISE FND_API.g_exc_error;
705: -- END IF;
706: ELSE -- PAGES ARE AVAILABLE FOR THIS SITE

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

703: -- END IF;
704: -- RAISE FND_API.g_exc_error;
705: -- END IF;
706: ELSE -- PAGES ARE AVAILABLE FOR THIS SITE
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
708: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_HAS_PAGES');
709: FND_MSG_PUB.add;
710: END IF;
711: RAISE FND_API.g_exc_error;

Line 709: FND_MSG_PUB.add;

705: -- END IF;
706: ELSE -- PAGES ARE AVAILABLE FOR THIS SITE
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
708: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_HAS_PAGES');
709: FND_MSG_PUB.add;
710: END IF;
711: RAISE FND_API.g_exc_error;
712: END IF;
713:

Line 743: FND_MSG_PUB.Count_And_Get

739: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
740: END IF;
741:
742: -- Standard call to get message count and if count is 1, get message info.
743: FND_MSG_PUB.Count_And_Get
744: (p_count => x_msg_count,
745: p_data => x_msg_data
746: );
747: EXCEPTION

Line 757: FND_MSG_PUB.Count_And_Get (

753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO DELETE_Iba_Pl_Sites_PVT;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: -- Standard call to get message count and if count=1, get the message
757: FND_MSG_PUB.Count_And_Get (
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );

Line 767: FND_MSG_PUB.Count_And_Get (

763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764: ROLLBACK TO DELETE_Iba_Pl_Sites_PVT;
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );

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

772:
773: WHEN OTHERS THEN
774: ROLLBACK TO DELETE_Iba_Pl_Sites_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message

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

774: ROLLBACK TO DELETE_Iba_Pl_Sites_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,

Line 781: FND_MSG_PUB.Count_And_Get (

777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );

Line 827: FND_MSG_PUB.initialize;

823:
824: -- Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean( p_init_msg_list )
826: THEN
827: FND_MSG_PUB.initialize;
828: END IF;
829:
830: -- Standard call to check for call compatibility.
831: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

854: FETCH c_Iba_Pl_Sites INTO l_SITE_ID;
855:
856: IF (c_Iba_Pl_Sites%NOTFOUND) THEN
857: CLOSE c_Iba_Pl_Sites;
858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
859: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
860: FND_MSG_PUB.add;
861: END IF;
862: RAISE FND_API.g_exc_error;

Line 860: FND_MSG_PUB.add;

856: IF (c_Iba_Pl_Sites%NOTFOUND) THEN
857: CLOSE c_Iba_Pl_Sites;
858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
859: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
860: FND_MSG_PUB.add;
861: END IF;
862: RAISE FND_API.g_exc_error;
863: END IF;
864:

Line 868: FND_MSG_PUB.count_and_get(

864:
865: CLOSE c_Iba_Pl_Sites;
866:
867: -------------------- finish --------------------------
868: FND_MSG_PUB.count_and_get(
869: p_encoded => FND_API.g_false,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 887: FND_MSG_PUB.Count_And_Get (

883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO LOCK_Iba_Pl_Sites_PVT;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: -- Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
891: );

Line 897: FND_MSG_PUB.Count_And_Get (

893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: ROLLBACK TO LOCK_Iba_Pl_Sites_PVT;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: -- Standard call to get message count and if count=1, get the message
897: FND_MSG_PUB.Count_And_Get (
898: p_encoded => FND_API.G_FALSE,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );

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

902:
903: WHEN OTHERS THEN
904: ROLLBACK TO LOCK_Iba_Pl_Sites_PVT;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message

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

904: ROLLBACK TO LOCK_Iba_Pl_Sites_PVT;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message
911: FND_MSG_PUB.Count_And_Get (
912: p_encoded => FND_API.G_FALSE,

Line 911: FND_MSG_PUB.Count_And_Get (

907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message
911: FND_MSG_PUB.Count_And_Get (
912: p_encoded => FND_API.G_FALSE,
913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );

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

1155:
1156: IF l_site_page_count = 0 THEN
1157: x_return_status := FND_API.g_ret_sts_success;
1158: ELSE
1159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1160: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_HAS_PAGES');
1161: FND_MSG_PUB.add;
1162: END IF;
1163: x_return_status := fnd_api.g_ret_sts_error;

Line 1161: FND_MSG_PUB.add;

1157: x_return_status := FND_API.g_ret_sts_success;
1158: ELSE
1159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1160: FND_MESSAGE.set_name('AMS','AMS_PLCE_SITE_HAS_PAGES');
1161: FND_MSG_PUB.add;
1162: END IF;
1163: x_return_status := fnd_api.g_ret_sts_error;
1164: RAISE FND_API.g_exc_error;
1165: return;

Line 1344: FND_MSG_PUB.initialize;

1340:
1341: -- Initialize message list if p_init_msg_list is set to TRUE.
1342: IF FND_API.to_Boolean( p_init_msg_list )
1343: THEN
1344: FND_MSG_PUB.initialize;
1345: END IF;
1346: -- sodixit : commenting following lines as site items will be checked in middle tier
1347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1348: check_iba_pl_sites_items(

Line 1401: FND_MSG_PUB.Count_And_Get

1397: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1398: END IF;
1399:
1400: -- Standard call to get message count and if count is 1, get message info.
1401: FND_MSG_PUB.Count_And_Get
1402: (p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );
1405: EXCEPTION

Line 1415: FND_MSG_PUB.Count_And_Get (

1411: WHEN FND_API.G_EXC_ERROR THEN
1412: ROLLBACK TO validate_iba_pl_sites_;
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: -- Standard call to get message count and if count=1, get the message
1415: FND_MSG_PUB.Count_And_Get (
1416: p_encoded => FND_API.G_FALSE,
1417: p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );

Line 1425: FND_MSG_PUB.Count_And_Get (

1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: ROLLBACK TO validate_iba_pl_sites_;
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: -- Standard call to get message count and if count=1, get the message
1425: FND_MSG_PUB.Count_And_Get (
1426: p_encoded => FND_API.G_FALSE,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data
1429: );

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

1430:
1431: WHEN OTHERS THEN
1432: ROLLBACK TO validate_iba_pl_sites_;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message

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

1432: ROLLBACK TO validate_iba_pl_sites_;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message
1439: FND_MSG_PUB.Count_And_Get (
1440: p_encoded => FND_API.G_FALSE,

Line 1439: FND_MSG_PUB.Count_And_Get (

1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message
1439: FND_MSG_PUB.Count_And_Get (
1440: p_encoded => FND_API.G_FALSE,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

Line 1460: FND_MSG_PUB.initialize;

1456: BEGIN
1457: -- Initialize message list if p_init_msg_list is set to TRUE.
1458: IF FND_API.to_Boolean( p_init_msg_list )
1459: THEN
1460: FND_MSG_PUB.initialize;
1461: END IF;
1462:
1463: -- Initialize API return status to SUCCESS
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1477: FND_MSG_PUB.Count_And_Get

1473:
1474: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1475: END IF;
1476: -- Standard call to get message count and if count is 1, get message info.
1477: FND_MSG_PUB.Count_And_Get
1478: (p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );
1481: END validate_iba_pl_sites_rec;