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

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

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvascb.pls';
19:
20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_List_Assoc(

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

19:
20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_List_Assoc(
27: p_api_version_number IN NUMBER,

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

20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_List_Assoc(
27: p_api_version_number IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 75: FND_MSG_PUB.initialize;

71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list )
74: THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IF (AMS_DEBUG_HIGH_ON) THEN

Line 184: FND_MSG_PUB.Count_And_Get

180: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
181: END IF;
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: FND_MSG_PUB.Count_And_Get
185: (p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188: EXCEPTION

Line 198: FND_MSG_PUB.Count_And_Get (

194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_List_Assoc_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );

Line 208: FND_MSG_PUB.Count_And_Get (

204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_List_Assoc_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data
212: );

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

213:
214: WHEN OTHERS THEN
215: ROLLBACK TO CREATE_List_Assoc_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message

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

215: ROLLBACK TO CREATE_List_Assoc_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,

Line 222: FND_MSG_PUB.Count_And_Get (

218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );

Line 277: FND_MSG_PUB.initialize;

273:
274: -- Initialize message list if p_init_msg_list is set to TRUE.
275: IF FND_API.to_Boolean( p_init_msg_list )
276: THEN
277: FND_MSG_PUB.initialize;
278: END IF;
279:
280: -- Debug Message
281: IF (AMS_DEBUG_HIGH_ON) THEN

Line 393: FND_MSG_PUB.Count_And_Get

389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
390: END IF;
391:
392: -- Standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get
394: (p_count => x_msg_count,
395: p_data => x_msg_data
396: );
397: EXCEPTION

Line 407: FND_MSG_PUB.Count_And_Get (

403: WHEN FND_API.G_EXC_ERROR THEN
404: ROLLBACK TO UPDATE_List_Assoc_PVT;
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: -- Standard call to get message count and if count=1, get the message
407: FND_MSG_PUB.Count_And_Get (
408: p_encoded => FND_API.G_FALSE,
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );

Line 417: FND_MSG_PUB.Count_And_Get (

413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO UPDATE_List_Assoc_PVT;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: -- Standard call to get message count and if count=1, get the message
417: FND_MSG_PUB.Count_And_Get (
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data
421: );

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

422:
423: WHEN OTHERS THEN
424: ROLLBACK TO UPDATE_List_Assoc_PVT;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
429: END IF;
430: -- Standard call to get message count and if count=1, get the message

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

424: ROLLBACK TO UPDATE_List_Assoc_PVT;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.Count_And_Get (
432: p_encoded => FND_API.G_FALSE,

Line 431: FND_MSG_PUB.Count_And_Get (

427: THEN
428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.Count_And_Get (
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );

Line 473: FND_MSG_PUB.initialize;

469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list )
472: THEN
473: FND_MSG_PUB.initialize;
474: END IF;
475:
476: -- Debug Message
477: IF (AMS_DEBUG_HIGH_ON) THEN

Line 516: FND_MSG_PUB.Count_And_Get

512: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: END IF;
514:
515: -- Standard call to get message count and if count is 1, get message info.
516: FND_MSG_PUB.Count_And_Get
517: (p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: EXCEPTION

Line 530: FND_MSG_PUB.Count_And_Get (

526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO DELETE_List_Assoc_PVT;
528: x_return_status := FND_API.G_RET_STS_ERROR;
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 540: FND_MSG_PUB.Count_And_Get (

536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO DELETE_List_Assoc_PVT;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );

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

545:
546: WHEN OTHERS THEN
547: ROLLBACK TO DELETE_List_Assoc_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message

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

547: ROLLBACK TO DELETE_List_Assoc_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message
554: FND_MSG_PUB.Count_And_Get (
555: p_encoded => FND_API.G_FALSE,

Line 554: FND_MSG_PUB.Count_And_Get (

550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message
554: FND_MSG_PUB.Count_And_Get (
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data
558: );

Line 600: FND_MSG_PUB.initialize;

596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )
599: THEN
600: FND_MSG_PUB.initialize;
601: END IF;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

629: FETCH c_List_Assoc INTO l_LIST_CONT_RESTRICTIONs_ID;
630:
631: IF (c_List_Assoc%NOTFOUND) THEN
632: CLOSE c_List_Assoc;
633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
634: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
635: FND_MSG_PUB.add;
636: END IF;
637: RAISE FND_API.g_exc_error;

Line 635: FND_MSG_PUB.add;

631: IF (c_List_Assoc%NOTFOUND) THEN
632: CLOSE c_List_Assoc;
633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
634: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
635: FND_MSG_PUB.add;
636: END IF;
637: RAISE FND_API.g_exc_error;
638: END IF;
639:

Line 643: FND_MSG_PUB.count_and_get(

639:
640: CLOSE c_List_Assoc;
641:
642: -------------------- finish --------------------------
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: IF (AMS_DEBUG_HIGH_ON) THEN

Line 661: FND_MSG_PUB.Count_And_Get (

657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_List_Assoc_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
665: );

Line 671: FND_MSG_PUB.Count_And_Get (

667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO LOCK_List_Assoc_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );

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

676:
677: WHEN OTHERS THEN
678: ROLLBACK TO LOCK_List_Assoc_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message

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

678: ROLLBACK TO LOCK_List_Assoc_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,

Line 685: FND_MSG_PUB.Count_And_Get (

681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );

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

834: END IF;
835: END IF;
836:
837: IF p_list_assoc_rec.do_not_contact_flag<>'Y' AND p_list_assoc_rec.do_not_contact_flag<>'N' THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
839: FND_MESSAGE.set_name('AMS', 'do_not_contact_flag is neither Y nor N');
840: FND_MSG_PUB.add;
841: END IF;
842: RAISE FND_API.g_exc_error;

Line 840: FND_MSG_PUB.add;

836:
837: IF p_list_assoc_rec.do_not_contact_flag<>'Y' AND p_list_assoc_rec.do_not_contact_flag<>'N' THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
839: FND_MESSAGE.set_name('AMS', 'do_not_contact_flag is neither Y nor N');
840: FND_MSG_PUB.add;
841: END IF;
842: RAISE FND_API.g_exc_error;
843: RETURN;
844: END IF;

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

844: END IF;
845:
846: IF p_list_assoc_rec.list_used_by<>'CAMP' AND p_list_assoc_rec.list_used_by <> 'MEDI' THEN
847: IF p_list_assoc_rec.do_not_contact_flag <> 'Y' THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
849: FND_MESSAGE.set_name('AMS', 'list_used_by is neither CAMP nor MEDI');
850: FND_MSG_PUB.add;
851: END IF;
852: RAISE FND_API.g_exc_error;

Line 850: FND_MSG_PUB.add;

846: IF p_list_assoc_rec.list_used_by<>'CAMP' AND p_list_assoc_rec.list_used_by <> 'MEDI' THEN
847: IF p_list_assoc_rec.do_not_contact_flag <> 'Y' THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
849: FND_MESSAGE.set_name('AMS', 'list_used_by is neither CAMP nor MEDI');
850: FND_MSG_PUB.add;
851: END IF;
852: RAISE FND_API.g_exc_error;
853: RETURN;
854: END IF;

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

861: IF (c_media_id%NOTFOUND) THEN
862: IF p_list_assoc_rec.do_not_contact_flag <> 'Y' AND
863: p_list_assoc_rec.list_used_by = 'MEDI' THEN
864: CLOSE c_media_id;
865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
866: FND_MESSAGE.set_name('AMS', 'MEDIA_ID_NOT_VALID');
867: FND_MSG_PUB.add;
868: END IF;
869: RAISE FND_API.g_exc_error;

Line 867: FND_MSG_PUB.add;

863: p_list_assoc_rec.list_used_by = 'MEDI' THEN
864: CLOSE c_media_id;
865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
866: FND_MESSAGE.set_name('AMS', 'MEDIA_ID_NOT_VALID');
867: FND_MSG_PUB.add;
868: END IF;
869: RAISE FND_API.g_exc_error;
870: END IF;
871: END IF;

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

878: IF (c_camp_id%NOTFOUND) THEN
879: IF p_list_assoc_rec.do_not_contact_flag <> 'Y' AND
880: p_list_assoc_rec.list_used_by ='CAMP' THEN
881: CLOSE c_camp_id;
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
883: FND_MESSAGE.set_name('AMS', 'CAMPAIGN_ID_NOT_VALID');
884: FND_MSG_PUB.add;
885: END IF;
886: RAISE FND_API.g_exc_error;

Line 884: FND_MSG_PUB.add;

880: p_list_assoc_rec.list_used_by ='CAMP' THEN
881: CLOSE c_camp_id;
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
883: FND_MESSAGE.set_name('AMS', 'CAMPAIGN_ID_NOT_VALID');
884: FND_MSG_PUB.add;
885: END IF;
886: RAISE FND_API.g_exc_error;
887: END IF;
888: END IF;

Line 1083: FND_MSG_PUB.initialize;

1079:
1080: -- Initialize message list if p_init_msg_list is set to TRUE.
1081: IF FND_API.to_Boolean( p_init_msg_list )
1082: THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Check_list_assoc_Items(
1087: p_list_assoc_rec => p_list_assoc_rec,

Line 1142: FND_MSG_PUB.Count_And_Get

1138: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1139: END IF;
1140:
1141: -- Standard call to get message count and if count is 1, get message info.
1142: FND_MSG_PUB.Count_And_Get
1143: (p_count => x_msg_count,
1144: p_data => x_msg_data
1145: );
1146: EXCEPTION

Line 1156: FND_MSG_PUB.Count_And_Get (

1152: WHEN FND_API.G_EXC_ERROR THEN
1153: ROLLBACK TO VALIDATE_List_Assoc_;
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );

Line 1166: FND_MSG_PUB.Count_And_Get (

1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: ROLLBACK TO VALIDATE_List_Assoc_;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: -- Standard call to get message count and if count=1, get the message
1166: FND_MSG_PUB.Count_And_Get (
1167: p_encoded => FND_API.G_FALSE,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );

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

1171:
1172: WHEN OTHERS THEN
1173: ROLLBACK TO VALIDATE_List_Assoc_;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1178: END IF;
1179: -- Standard call to get message count and if count=1, get the message

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

1173: ROLLBACK TO VALIDATE_List_Assoc_;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1178: END IF;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE,

Line 1180: FND_MSG_PUB.Count_And_Get (

1176: THEN
1177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1178: END IF;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE,
1182: p_count => x_msg_count,
1183: p_data => x_msg_data
1184: );

Line 1201: FND_MSG_PUB.initialize;

1197: BEGIN
1198: -- Initialize message list if p_init_msg_list is set to TRUE.
1199: IF FND_API.to_Boolean( p_init_msg_list )
1200: THEN
1201: FND_MSG_PUB.initialize;
1202: END IF;
1203:
1204: -- Initialize API return status to SUCCESS
1205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1218: FND_MSG_PUB.Count_And_Get

1214:
1215: AMS_UTILITY_PVT.debug_message('Private API: Validate_list_assoc_rec');
1216: END IF;
1217: -- Standard call to get message count and if count is 1, get message info.
1218: FND_MSG_PUB.Count_And_Get
1219: (p_count => x_msg_count,
1220: p_data => x_msg_data
1221: );
1222: END Validate_list_assoc_Rec;