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

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

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Query_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvliqb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_query_Rec (

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

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvliqb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_query_Rec (
26: P_list_query_rec IN list_query_rec_type,

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

19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_query_Rec (
26: P_list_query_rec IN list_query_rec_type,
27: x_complete_rec OUT NOCOPY list_query_rec_type

Line 81: FND_MSG_PUB.initialize;

77:
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list )
80: THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: -- Debug Message
85: IF (AMS_DEBUG_HIGH_ON) THEN

Line 200: FND_MSG_PUB.Count_And_Get

196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
197: END IF;
198:
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get
201: (p_count => x_msg_count,
202: p_data => x_msg_data
203: );
204: EXCEPTION

Line 214: FND_MSG_PUB.Count_And_Get (

210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO CREATE_List_Query_PVT;
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: -- Standard call to get message count and if count=1, get the message
214: FND_MSG_PUB.Count_And_Get (
215: p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data
218: );

Line 224: FND_MSG_PUB.Count_And_Get (

220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221: ROLLBACK TO CREATE_List_Query_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: -- Standard call to get message count and if count=1, get the message
224: FND_MSG_PUB.Count_And_Get (
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );

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

229:
230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_List_Query_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
236: END IF;
237: -- Standard call to get message count and if count=1, get the message

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

231: ROLLBACK TO CREATE_List_Query_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
236: END IF;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,

Line 238: FND_MSG_PUB.Count_And_Get (

234: THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
236: END IF;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data
242: );

Line 279: FND_MSG_PUB.initialize;

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

Line 370: FND_MSG_PUB.Count_And_Get

366: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
367: END IF;
368:
369: -- Standard call to get message count and if count is 1, get message info.
370: FND_MSG_PUB.Count_And_Get
371: (p_count => x_msg_count,
372: p_data => x_msg_data
373: );
374: EXCEPTION

Line 384: FND_MSG_PUB.Count_And_Get (

380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO CREATE_List_Query_PVT_TBL;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );

Line 394: FND_MSG_PUB.Count_And_Get (

390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO CREATE_List_Query_PVT_TBL;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: -- Standard call to get message count and if count=1, get the message
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => FND_API.G_FALSE,
396: p_count => x_msg_count,
397: p_data => x_msg_data
398: );

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

399:
400: WHEN OTHERS THEN
401: ROLLBACK TO CREATE_List_Query_PVT_TBL;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
404: THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
406: END IF;
407: -- Standard call to get message count and if count=1, get the message

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

401: ROLLBACK TO CREATE_List_Query_PVT_TBL;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
404: THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
406: END IF;
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get (
409: p_encoded => FND_API.G_FALSE,

Line 408: FND_MSG_PUB.Count_And_Get (

404: THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
406: END IF;
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get (
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );

Line 453: FND_MSG_PUB.initialize;

449:
450: -- Initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean( p_init_msg_list )
452: THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: -- Debug Message
457: IF (AMS_DEBUG_HIGH_ON) THEN

Line 545: FND_MSG_PUB.Count_And_Get

541: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
542: END IF;
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: EXCEPTION

Line 559: FND_MSG_PUB.Count_And_Get (

555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO CREATE_List_Query_PVT_TBL_;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );

Line 569: FND_MSG_PUB.Count_And_Get (

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

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

574:
575: WHEN OTHERS THEN
576: ROLLBACK TO CREATE_List_Query_PVT_TBL_;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message

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

576: ROLLBACK TO CREATE_List_Query_PVT_TBL_;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,

Line 583: FND_MSG_PUB.Count_And_Get (

579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
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: );

Line 638: FND_MSG_PUB.initialize;

634:
635: -- Initialize message list if p_init_msg_list is set to TRUE.
636: IF FND_API.to_Boolean( p_init_msg_list )
637: THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -- Debug Message
642: IF (AMS_DEBUG_HIGH_ON) THEN

Line 720: -- 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;

716: END IF;
717:
718:
719: -- Debug Message
720: -- 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;
721:
722:
723: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Update_Row)
724: AMS_LIST_QUERIES_PKG.Update_Row(

Line 767: FND_MSG_PUB.Count_And_Get

763: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
764: END IF;
765:
766: -- Standard call to get message count and if count is 1, get message info.
767: FND_MSG_PUB.Count_And_Get
768: (p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771: EXCEPTION

Line 781: FND_MSG_PUB.Count_And_Get (

777: WHEN FND_API.G_EXC_ERROR THEN
778: ROLLBACK TO UPDATE_List_Query_PVT;
779: x_return_status := FND_API.G_RET_STS_ERROR;
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 791: FND_MSG_PUB.Count_And_Get (

787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO UPDATE_List_Query_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );

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

796:
797: WHEN OTHERS THEN
798: ROLLBACK TO UPDATE_List_Query_PVT;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
803: END IF;
804: -- Standard call to get message count and if count=1, get the message

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

798: ROLLBACK TO UPDATE_List_Query_PVT;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
803: END IF;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,

Line 805: FND_MSG_PUB.Count_And_Get (

801: THEN
802: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
803: END IF;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );

Line 878: FND_MSG_PUB.initialize;

874:
875: -- Initialize message list if p_init_msg_list is set to TRUE.
876: IF FND_API.to_Boolean( p_init_msg_list )
877: THEN
878: FND_MSG_PUB.initialize;
879: END IF;
880:
881: -- Debug Message
882: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1057: FND_MSG_PUB.Count_And_Get

1053: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1054: END IF;
1055:
1056: -- Standard call to get message count and if count is 1, get message info.
1057: FND_MSG_PUB.Count_And_Get
1058: (p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );
1061: EXCEPTION

Line 1071: FND_MSG_PUB.Count_And_Get (

1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO UPDATE_List_Query_PVT_tbl;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: -- Standard call to get message count and if count=1, get the message
1071: FND_MSG_PUB.Count_And_Get (
1072: p_encoded => FND_API.G_FALSE,
1073: p_count => x_msg_count,
1074: p_data => x_msg_data
1075: );

Line 1081: FND_MSG_PUB.Count_And_Get (

1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1078: ROLLBACK TO UPDATE_List_Query_PVT_tbl;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: -- Standard call to get message count and if count=1, get the message
1081: FND_MSG_PUB.Count_And_Get (
1082: p_encoded => FND_API.G_FALSE,
1083: p_count => x_msg_count,
1084: p_data => x_msg_data
1085: );

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

1086:
1087: WHEN OTHERS THEN
1088: ROLLBACK TO UPDATE_List_Query_PVT_tbl;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1091: THEN
1092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1093: END IF;
1094: -- Standard call to get message count and if count=1, get the message

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

1088: ROLLBACK TO UPDATE_List_Query_PVT_tbl;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1091: THEN
1092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1093: END IF;
1094: -- Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,

Line 1095: FND_MSG_PUB.Count_And_Get (

1091: THEN
1092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1093: END IF;
1094: -- Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );

Line 1137: FND_MSG_PUB.initialize;

1133:
1134: -- Initialize message list if p_init_msg_list is set to TRUE.
1135: IF FND_API.to_Boolean( p_init_msg_list )
1136: THEN
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139:
1140: -- Debug Message
1141: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1180: FND_MSG_PUB.Count_And_Get

1176: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1177: END IF;
1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180: FND_MSG_PUB.Count_And_Get
1181: (p_count => x_msg_count,
1182: p_data => x_msg_data
1183: );
1184: EXCEPTION

Line 1194: FND_MSG_PUB.Count_And_Get (

1190: WHEN FND_API.G_EXC_ERROR THEN
1191: ROLLBACK TO DELETE_List_Query_PVT;
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data
1198: );

Line 1204: FND_MSG_PUB.Count_And_Get (

1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: ROLLBACK TO DELETE_List_Query_PVT;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: -- Standard call to get message count and if count=1, get the message
1204: FND_MSG_PUB.Count_And_Get (
1205: p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data
1208: );

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

1209:
1210: WHEN OTHERS THEN
1211: ROLLBACK TO DELETE_List_Query_PVT;
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1216: END IF;
1217: -- Standard call to get message count and if count=1, get the message

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

1211: ROLLBACK TO DELETE_List_Query_PVT;
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1216: END IF;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,

Line 1218: FND_MSG_PUB.Count_And_Get (

1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1216: END IF;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );

Line 1262: FND_MSG_PUB.initialize;

1258:
1259: -- Initialize message list if p_init_msg_list is set to TRUE.
1260: IF FND_API.to_Boolean( p_init_msg_list )
1261: THEN
1262: FND_MSG_PUB.initialize;
1263: END IF;
1264:
1265: -- Debug Message
1266: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1310: FND_MSG_PUB.Count_And_Get

1306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1307: END IF;
1308:
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: (p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );
1314: EXCEPTION

Line 1324: FND_MSG_PUB.Count_And_Get (

1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO DELETE_List_Query_PVT_tbl;
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: -- Standard call to get message count and if count=1, get the message
1324: FND_MSG_PUB.Count_And_Get (
1325: p_encoded => FND_API.G_FALSE,
1326: p_count => x_msg_count,
1327: p_data => x_msg_data
1328: );

Line 1334: FND_MSG_PUB.Count_And_Get (

1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331: ROLLBACK TO DELETE_List_Query_PVT_tbl;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: -- Standard call to get message count and if count=1, get the message
1334: FND_MSG_PUB.Count_And_Get (
1335: p_encoded => FND_API.G_FALSE,
1336: p_count => x_msg_count,
1337: p_data => x_msg_data
1338: );

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

1339:
1340: WHEN OTHERS THEN
1341: ROLLBACK TO DELETE_List_Query_PVT_tbl;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1344: THEN
1345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1346: END IF;
1347: -- Standard call to get message count and if count=1, get the message

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

1341: ROLLBACK TO DELETE_List_Query_PVT_tbl;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1344: THEN
1345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1346: END IF;
1347: -- Standard call to get message count and if count=1, get the message
1348: FND_MSG_PUB.Count_And_Get (
1349: p_encoded => FND_API.G_FALSE,

Line 1348: FND_MSG_PUB.Count_And_Get (

1344: THEN
1345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1346: END IF;
1347: -- Standard call to get message count and if count=1, get the message
1348: FND_MSG_PUB.Count_And_Get (
1349: p_encoded => FND_API.G_FALSE,
1350: p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );

Line 1395: FND_MSG_PUB.initialize;

1391:
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list )
1394: THEN
1395: FND_MSG_PUB.initialize;
1396: END IF;
1397:
1398: -- Standard call to check for call compatibility.
1399: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1423: FETCH c_List_Query INTO l_LIST_QUERY_ID;
1424:
1425: IF (c_List_Query%NOTFOUND) THEN
1426: CLOSE c_List_Query;
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: RAISE FND_API.g_exc_error;

Line 1429: FND_MSG_PUB.add;

1425: IF (c_List_Query%NOTFOUND) THEN
1426: CLOSE c_List_Query;
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: RAISE FND_API.g_exc_error;
1432: END IF;
1433:

Line 1437: FND_MSG_PUB.count_and_get(

1433:
1434: CLOSE c_List_Query;
1435:
1436: -------------------- finish --------------------------
1437: FND_MSG_PUB.count_and_get(
1438: p_encoded => FND_API.g_false,
1439: p_count => x_msg_count,
1440: p_data => x_msg_data);
1441: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1455: FND_MSG_PUB.Count_And_Get (

1451: WHEN FND_API.G_EXC_ERROR THEN
1452: ROLLBACK TO LOCK_List_Query_PVT;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: -- Standard call to get message count and if count=1, get the message
1455: FND_MSG_PUB.Count_And_Get (
1456: p_encoded => FND_API.G_FALSE,
1457: p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );

Line 1465: FND_MSG_PUB.Count_And_Get (

1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1462: ROLLBACK TO LOCK_List_Query_PVT;
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: -- Standard call to get message count and if count=1, get the message
1465: FND_MSG_PUB.Count_And_Get (
1466: p_encoded => FND_API.G_FALSE,
1467: p_count => x_msg_count,
1468: p_data => x_msg_data
1469: );

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

1470:
1471: WHEN OTHERS THEN
1472: ROLLBACK TO LOCK_List_Query_PVT;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message

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

1472: ROLLBACK TO LOCK_List_Query_PVT;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message
1479: FND_MSG_PUB.Count_And_Get (
1480: p_encoded => FND_API.G_FALSE,

Line 1479: FND_MSG_PUB.Count_And_Get (

1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message
1479: FND_MSG_PUB.Count_And_Get (
1480: p_encoded => FND_API.G_FALSE,
1481: p_count => x_msg_count,
1482: p_data => x_msg_data
1483: );

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

1524: close c_check_name;
1525:
1526:
1527: IF l_valid_flag = FND_API.g_false THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1529:
1530: IF (AMS_DEBUG_HIGH_ON) THEN
1531:
1532:

Line 1538: FND_MSG_PUB.add;

1534: AMS_UTILITY_PVT.debug_message('parent id: ' || p_list_query_rec.parent_list_query_id );
1535:
1536: END IF;
1537: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_DUPE_NAME');
1538: FND_MSG_PUB.add;
1539: END IF;
1540: x_return_status := FND_API.g_ret_sts_error;
1541: RETURN;
1542: END IF;

Line 1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1555: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1556:
1557: IF p_list_query_rec.name = FND_API.g_miss_char OR p_list_query_rec.name IS NULL THEN
1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1560: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_NAME');
1561: FND_MSG_PUB.Add;
1562: END IF;
1563: x_return_status := FND_API.g_ret_sts_error;

Line 1561: FND_MSG_PUB.Add;

1557: IF p_list_query_rec.name = FND_API.g_miss_char OR p_list_query_rec.name IS NULL THEN
1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1560: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_NAME');
1561: FND_MSG_PUB.Add;
1562: END IF;
1563: x_return_status := FND_API.g_ret_sts_error;
1564: RETURN;
1565: END IF;

Line 1571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1567:
1568: /*
1569: IF p_list_query_rec.act_list_query_used_by_id = FND_API.g_miss_num OR p_list_query_rec.act_list_query_used_by_id IS NULL THEN
1570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_act_list_query_used_by_id');
1571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1572: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY_ID');
1573: FND_MSG_PUB.Add;
1574: END IF;
1575: x_return_status := FND_API.g_ret_sts_error;

Line 1573: FND_MSG_PUB.Add;

1569: IF p_list_query_rec.act_list_query_used_by_id = FND_API.g_miss_num OR p_list_query_rec.act_list_query_used_by_id IS NULL THEN
1570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_act_list_query_used_by_id');
1571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1572: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY_ID');
1573: FND_MSG_PUB.Add;
1574: END IF;
1575: x_return_status := FND_API.g_ret_sts_error;
1576: RETURN;
1577: END IF;

Line 1583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1579:
1580:
1581: IF p_list_query_rec.arc_act_list_query_used_by = FND_API.g_miss_char OR p_list_query_rec.arc_act_list_query_used_by IS NULL THEN
1582: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_arc_act_list_query_used_by');
1583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1584: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY');
1585: FND_MSG_PUB.Add;
1586: END IF;
1587: x_return_status := FND_API.g_ret_sts_error;

Line 1585: FND_MSG_PUB.Add;

1581: IF p_list_query_rec.arc_act_list_query_used_by = FND_API.g_miss_char OR p_list_query_rec.arc_act_list_query_used_by IS NULL THEN
1582: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_arc_act_list_query_used_by');
1583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1584: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY');
1585: FND_MSG_PUB.Add;
1586: END IF;
1587: x_return_status := FND_API.g_ret_sts_error;
1588: RETURN;
1589: END IF;

Line 1593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1589: END IF;
1590:
1591: */
1592: IF p_list_query_rec.sql_string = FND_API.g_miss_char OR p_list_query_rec.sql_string IS NULL THEN
1593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1594: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_SQLSTRING');
1595: FND_MSG_PUB.Add;
1596: END IF;
1597: x_return_status := FND_API.g_ret_sts_error;

Line 1595: FND_MSG_PUB.Add;

1591: */
1592: IF p_list_query_rec.sql_string = FND_API.g_miss_char OR p_list_query_rec.sql_string IS NULL THEN
1593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1594: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_SQLSTRING');
1595: FND_MSG_PUB.Add;
1596: END IF;
1597: x_return_status := FND_API.g_ret_sts_error;
1598: RETURN;
1599: END IF;

Line 1685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1681: THEN
1682: x_return_status := FND_API.G_RET_STS_SUCCESS;
1683:
1684: ELSE
1685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1686: THEN
1687: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QRY_USEDBYID_INVALID');
1688: FND_MSG_PUB.Add;
1689: END IF;

Line 1688: FND_MSG_PUB.Add;

1684: ELSE
1685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1686: THEN
1687: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QRY_USEDBYID_INVALID');
1688: FND_MSG_PUB.Add;
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF; -- end AMS_Utility_PVT.Check_FK_Exists

Line 1713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1709: p_lookup_type => 'AMS_LIST_QUERY_TYPE',
1710: p_lookup_code => p_list_query_rec.arc_act_list_query_used_by
1711: ) = FND_API.g_false
1712: THEN
1713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1714: THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_USEDBY_INVALID');
1716: FND_MSG_PUB.add;
1717: END IF;

Line 1716: FND_MSG_PUB.add;

1712: THEN
1713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1714: THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_USEDBY_INVALID');
1716: FND_MSG_PUB.add;
1717: END IF;
1718:
1719: x_return_status := FND_API.g_ret_sts_error;
1720: RETURN;

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

1788: OPEN c_query;
1789: FETCH c_query INTO l_query_rec;
1790: IF c_query%NOTFOUND THEN
1791: CLOSE c_query;
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: RAISE FND_API.g_exc_error;

Line 1794: FND_MSG_PUB.add;

1790: IF c_query%NOTFOUND THEN
1791: CLOSE c_query;
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: RAISE FND_API.g_exc_error;
1797: END IF;
1798: CLOSE c_query;

Line 1916: FND_MSG_PUB.initialize;

1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.
1914: IF FND_API.to_Boolean( p_init_msg_list )
1915: THEN
1916: FND_MSG_PUB.initialize;
1917: END IF;
1918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1919: Check_list_query_Items(
1920: p_list_query_rec => p_list_query_rec,

Line 1968: FND_MSG_PUB.Count_And_Get

1964: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1965: END IF;
1966:
1967: -- Standard call to get message count and if count is 1, get message info.
1968: FND_MSG_PUB.Count_And_Get
1969: (p_count => x_msg_count,
1970: p_data => x_msg_data
1971: );
1972: EXCEPTION

Line 1982: FND_MSG_PUB.Count_And_Get (

1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO VALIDATE_List_Query_;
1980: x_return_status := FND_API.G_RET_STS_ERROR;
1981: -- Standard call to get message count and if count=1, get the message
1982: FND_MSG_PUB.Count_And_Get (
1983: p_encoded => FND_API.G_FALSE,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data
1986: );

Line 1992: FND_MSG_PUB.Count_And_Get (

1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1989: ROLLBACK TO VALIDATE_List_Query_;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: -- Standard call to get message count and if count=1, get the message
1992: FND_MSG_PUB.Count_And_Get (
1993: p_encoded => FND_API.G_FALSE,
1994: p_count => x_msg_count,
1995: p_data => x_msg_data
1996: );

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

1997:
1998: WHEN OTHERS THEN
1999: ROLLBACK TO VALIDATE_List_Query_;
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2002: THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: -- Standard call to get message count and if count=1, get the message

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

1999: ROLLBACK TO VALIDATE_List_Query_;
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2002: THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: -- Standard call to get message count and if count=1, get the message
2006: FND_MSG_PUB.Count_And_Get (
2007: p_encoded => FND_API.G_FALSE,

Line 2006: FND_MSG_PUB.Count_And_Get (

2002: THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: -- Standard call to get message count and if count=1, get the message
2006: FND_MSG_PUB.Count_And_Get (
2007: p_encoded => FND_API.G_FALSE,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data
2010: );

Line 2027: FND_MSG_PUB.initialize;

2023: BEGIN
2024: -- Initialize message list if p_init_msg_list is set to TRUE.
2025: IF FND_API.to_Boolean( p_init_msg_list )
2026: THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029:
2030: -- Initialize API return status to SUCCESS
2031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2045: FND_MSG_PUB.Count_And_Get

2041: AMS_UTILITY_PVT.debug_message('Private API: Validate_query__rec->'
2042: || x_return_status);
2043: END IF;
2044: -- Standard call to get message count and if count is 1, get message info.
2045: FND_MSG_PUB.Count_And_Get
2046: (p_count => x_msg_count,
2047: p_data => x_msg_data
2048: );
2049: END Validate_list_query_Rec;

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

2124: OPEN c_listquery;
2125: FETCH c_listquery INTO l_listquery_rec;
2126: IF c_listquery%NOTFOUND THEN
2127: CLOSE c_listquery;
2128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2129: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2130: FND_MSG_PUB.add;
2131: END IF;
2132: RAISE FND_API.g_exc_error;

Line 2130: FND_MSG_PUB.add;

2126: IF c_listquery%NOTFOUND THEN
2127: CLOSE c_listquery;
2128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2129: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2130: FND_MSG_PUB.add;
2131: END IF;
2132: RAISE FND_API.g_exc_error;
2133: END IF;
2134: CLOSE c_listquery;

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

2238: OPEN c_listquery;
2239: FETCH c_listquery INTO l_listquery_rec;
2240: IF c_listquery%NOTFOUND THEN
2241: CLOSE c_listquery;
2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2243: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2244: FND_MSG_PUB.add;
2245: END IF;
2246: RAISE FND_API.g_exc_error;

Line 2244: FND_MSG_PUB.add;

2240: IF c_listquery%NOTFOUND THEN
2241: CLOSE c_listquery;
2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2243: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2244: FND_MSG_PUB.add;
2245: END IF;
2246: RAISE FND_API.g_exc_error;
2247: END IF;
2248: CLOSE c_listquery;

Line 2408: FND_MSG_PUB.initialize;

2404:
2405:
2406: -- Initialize message list IF p_init_msg_list is set to TRUE.
2407: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2408: FND_MSG_PUB.initialize;
2409: END IF;
2410:
2411: -- Debug Message
2412: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2415: FND_MSG_PUB.Add;

2411: -- Debug Message
2412: IF (AMS_DEBUG_HIGH_ON) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);
2415: FND_MSG_PUB.Add;
2416: END IF;
2417:
2418: -- Initialize API return status to success
2419: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2513: COMMIT WORK;
2514: END IF;
2515:
2516: -- Success Message
2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);
2521: FND_MSG_PUB.Add;

Line 2521: FND_MSG_PUB.Add;

2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);
2521: FND_MSG_PUB.Add;
2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

Line 2527: FND_MSG_PUB.Add;

2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);
2527: FND_MSG_PUB.Add;
2528: END IF;
2529:
2530:
2531: -- Standard call to get message count AND IF count is 1, get message info.

Line 2532: FND_MSG_PUB.Count_AND_Get

2528: END IF;
2529:
2530:
2531: -- Standard call to get message count AND IF count is 1, get message info.
2532: FND_MSG_PUB.Count_AND_Get
2533: ( p_count => x_msg_count,
2534: p_data => x_msg_data,
2535: p_encoded => FND_API.G_FALSE
2536: );

Line 2543: FND_MSG_PUB.Count_AND_Get

2539: WHEN FND_API.G_EXC_ERROR THEN
2540: ROLLBACK TO Copy_List_Queries_PVT;
2541: x_return_status := FND_API.G_RET_STS_ERROR ;
2542:
2543: FND_MSG_PUB.Count_AND_Get
2544: ( p_count => x_msg_count,
2545: p_data => x_msg_data,
2546: p_encoded => FND_API.G_FALSE
2547: );

Line 2553: FND_MSG_PUB.Count_AND_Get

2549:
2550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2551: ROLLBACK TO Copy_List_Queries_PVT;
2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2553: FND_MSG_PUB.Count_AND_Get
2554: ( p_count => x_msg_count,
2555: p_data => x_msg_data,
2556: p_encoded => FND_API.G_FALSE
2557: );

Line 2562: FND_MSG_PUB.Add;

2558:
2559: WHEN OTHERS THEN
2560: ROLLBACK TO Copy_List_Queries_PVT;
2561: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
2562: FND_MSG_PUB.Add;
2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2566: END IF;

Line 2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2560: ROLLBACK TO Copy_List_Queries_PVT;
2561: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
2562: FND_MSG_PUB.Add;
2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2566: END IF;
2567:
2568: FND_MSG_PUB.Count_AND_Get

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

2561: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
2562: FND_MSG_PUB.Add;
2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2566: END IF;
2567:
2568: FND_MSG_PUB.Count_AND_Get
2569: ( p_count => x_msg_count,

Line 2568: FND_MSG_PUB.Count_AND_Get

2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2566: END IF;
2567:
2568: FND_MSG_PUB.Count_AND_Get
2569: ( p_count => x_msg_count,
2570: p_data => x_msg_data,
2571: p_encoded => FND_API.G_FALSE
2572: );