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 STANDARD

Line 66: -- Standard Start of API savepoint

62: WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL
63: WHERE LIST_QUERY_ID = l_id);
64:
65: BEGIN
66: -- Standard Start of API savepoint
67: SAVEPOINT CREATE_List_Query_PVT;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 69: -- Standard call to check for call compatibility.

65: BEGIN
66: -- Standard Start of API savepoint
67: SAVEPOINT CREATE_List_Query_PVT;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
71: p_api_version_number,
72: l_api_name,
73: G_PKG_NAME)

Line 186: -- Standard check for p_commit

182: --
183: -- End of API body
184: --
185:
186: -- Standard check for p_commit
187: IF FND_API.to_Boolean( p_commit )
188: THEN
189: COMMIT WORK;
190: END IF;

Line 199: -- Standard call to get message count and if count is 1, get message info.

195:
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: );

Line 213: -- Standard call to get message count and if count=1, get the message

209:
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

Line 223: -- Standard call to get message count and if count=1, get the message

219:
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

Line 237: -- Standard call to get message count and if count=1, get the message

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,
240: p_count => x_msg_count,
241: p_data => x_msg_data

Line 264: -- Standard Start of API savepoint

260: l_list_query_rec list_query_rec_type;
261: l_list_query_id number;
262: begin
263: x_parent_list_query_id := FND_API.g_miss_num;
264: -- Standard Start of API savepoint
265: SAVEPOINT CREATE_List_Query_PVT_TBL;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 267: -- Standard call to check for call compatibility.

263: x_parent_list_query_id := FND_API.g_miss_num;
264: -- Standard Start of API savepoint
265: SAVEPOINT CREATE_List_Query_PVT_TBL;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
269: p_api_version_number,
270: l_api_name,
271: G_PKG_NAME)

Line 356: -- Standard check for p_commit

352: --
353: -- End of API body
354: --
355:
356: -- Standard check for p_commit
357: IF FND_API.to_Boolean( p_commit )
358: THEN
359: COMMIT WORK;
360: END IF;

Line 369: -- Standard call to get message count and if count is 1, get message info.

365:
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: );

Line 383: -- Standard call to get message count and if count=1, get the message

379:
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

Line 393: -- Standard call to get message count and if count=1, get the message

389:
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

Line 407: -- Standard call to get message count and if count=1, get the message

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,
410: p_count => x_msg_count,
411: p_data => x_msg_data

Line 438: -- Standard Start of API savepoint

434: l_msg_count NUMBER;
435: l_msg_data VARCHAR2(2000);
436: begin
437: x_parent_list_query_id := FND_API.g_miss_num;
438: -- Standard Start of API savepoint
439: SAVEPOINT CREATE_List_Query_PVT_TBL_;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 441: -- Standard call to check for call compatibility.

437: x_parent_list_query_id := FND_API.g_miss_num;
438: -- Standard Start of API savepoint
439: SAVEPOINT CREATE_List_Query_PVT_TBL_;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)

Line 531: -- Standard check for p_commit

527: --
528: -- End of API body
529: --
530:
531: -- Standard check for p_commit
532: IF FND_API.to_Boolean( p_commit )
533: THEN
534: COMMIT WORK;
535: END IF;

Line 544: -- Standard call to get message count and if count is 1, get message info.

540:
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: );

Line 558: -- Standard call to get message count and if count=1, get the message

554:
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

Line 568: -- Standard call to get message count and if count=1, get the message

564:
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

Line 582: -- Standard call to get message count and if count=1, get the message

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,
585: p_count => x_msg_count,
586: p_data => x_msg_data

Line 623: -- Standard Start of API savepoint

619: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;
620: l_rowid ROWID;
621:
622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT UPDATE_List_Query_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 626: -- Standard call to check for call compatibility.

622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT UPDATE_List_Query_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
628: p_api_version_number,
629: l_api_name,
630: G_PKG_NAME)

Line 750: -- Standard check for p_commit

746: p_sequence_order => p_list_query_rec.sequence_order);
747: --
748: -- End of API body.
749: --
750: -- Standard check for p_commit
751: IF FND_API.to_Boolean( p_commit )
752: THEN
753: COMMIT WORK;
754: END IF;

Line 766: -- Standard call to get message count and if count is 1, get message info.

762:
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: );

Line 780: -- Standard call to get message count and if count=1, get the message

776:
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

Line 790: -- Standard call to get message count and if count=1, get the message

786:
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

Line 804: -- Standard call to get message count and if count=1, get the message

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,
807: p_count => x_msg_count,
808: p_data => x_msg_data

Line 863: -- Standard Start of API savepoint

859: l_sql_string varchar2(4000);
860: l_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl ;
861: j number:=0 ;
862: BEGIN
863: -- Standard Start of API savepoint
864: SAVEPOINT UPDATE_List_Query_PVT_TBL;
865:
866: -- Standard call to check for call compatibility.
867: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 866: -- Standard call to check for call compatibility.

862: BEGIN
863: -- Standard Start of API savepoint
864: SAVEPOINT UPDATE_List_Query_PVT_TBL;
865:
866: -- Standard call to check for call compatibility.
867: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
868: p_api_version_number,
869: l_api_name,
870: G_PKG_NAME)

Line 1043: -- Standard check for p_commit

1039:
1040:
1041: -- End of API body.
1042: --
1043: -- Standard check for p_commit
1044: IF FND_API.to_Boolean( p_commit )
1045: THEN
1046: COMMIT WORK;
1047: END IF;

Line 1056: -- Standard call to get message count and if count is 1, get message info.

1052:
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: );

Line 1070: -- Standard call to get message count and if count=1, get the message

1066:
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

Line 1080: -- Standard call to get message count and if count=1, get the message

1076:
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

Line 1094: -- Standard call to get message count and if count=1, get the message

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,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data

Line 1122: -- Standard Start of API savepoint

1118: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1119: l_object_version_number NUMBER;
1120:
1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT DELETE_List_Query_PVT;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1125: -- Standard call to check for call compatibility.

1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT DELETE_List_Query_PVT;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1127: p_api_version_number,
1128: l_api_name,
1129: G_PKG_NAME)

Line 1166: -- Standard check for p_commit

1162: --
1163: -- End of API body
1164: --
1165:
1166: -- Standard check for p_commit
1167: IF FND_API.to_Boolean( p_commit )
1168: THEN
1169: COMMIT WORK;
1170: END IF;

Line 1179: -- Standard call to get message count and if count is 1, get message info.

1175:
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: );

Line 1193: -- Standard call to get message count and if count=1, get the message

1189:
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

Line 1203: -- Standard call to get message count and if count=1, get the message

1199:
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

Line 1217: -- Standard call to get message count and if count=1, get the message

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,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data

Line 1247: -- Standard Start of API savepoint

1243: where parent_list_query_id = p_parent_list_query_id ;
1244: l_list_query_id number;
1245:
1246: BEGIN
1247: -- Standard Start of API savepoint
1248: SAVEPOINT DELETE_List_Query_PVT_tbl;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1250: -- Standard call to check for call compatibility.

1246: BEGIN
1247: -- Standard Start of API savepoint
1248: SAVEPOINT DELETE_List_Query_PVT_tbl;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1252: p_api_version_number,
1253: l_api_name,
1254: G_PKG_NAME)

Line 1296: -- Standard check for p_commit

1292: --
1293: -- End of API body
1294: --
1295:
1296: -- Standard check for p_commit
1297: IF FND_API.to_Boolean( p_commit )
1298: THEN
1299: COMMIT WORK;
1300: END IF;

Line 1309: -- Standard call to get message count and if count is 1, get message info.

1305:
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: );

Line 1323: -- Standard call to get message count and if count=1, get the message

1319:
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

Line 1333: -- Standard call to get message count and if count=1, get the message

1329:
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

Line 1347: -- Standard call to get message count and if count=1, get the message

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,
1350: p_count => x_msg_count,
1351: p_data => x_msg_data

Line 1398: -- Standard call to check for call compatibility.

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,
1400: p_api_version_number,
1401: l_api_name,
1402: G_PKG_NAME)

Line 1454: -- Standard call to get message count and if count=1, get the message

1450:
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

Line 1464: -- Standard call to get message count and if count=1, get the message

1460:
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

Line 1478: -- Standard call to get message count and if count=1, get the message

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,
1481: p_count => x_msg_count,
1482: p_data => x_msg_data

Line 1901: -- Standard Start of API savepoint

1897: l_object_version_number NUMBER;
1898: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
1899:
1900: BEGIN
1901: -- Standard Start of API savepoint
1902: SAVEPOINT VALIDATE_List_Query_;
1903:
1904: -- Standard call to check for call compatibility.
1905: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1904: -- Standard call to check for call compatibility.

1900: BEGIN
1901: -- Standard Start of API savepoint
1902: SAVEPOINT VALIDATE_List_Query_;
1903:
1904: -- Standard call to check for call compatibility.
1905: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1906: p_api_version_number,
1907: l_api_name,
1908: G_PKG_NAME)

Line 1967: -- Standard call to get message count and if count is 1, get message info.

1963:
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: );

Line 1981: -- Standard call to get message count and if count=1, get the message

1977:
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

Line 1991: -- Standard call to get message count and if count=1, get the message

1987:
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

Line 2005: -- Standard call to get message count and if count=1, get the message

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,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data

Line 2044: -- Standard call to get message count and if count is 1, get message info.

2040:
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: );

Line 2393: -- Standard Start of API savepoint

2389: l_parent_list_query_id NUMBER;
2390: l_action_id NUMBER;
2391: BEGIN
2392:
2393: -- Standard Start of API savepoint
2394: SAVEPOINT Copy_List_Queries_PVT;
2395:
2396: x_return_status := FND_API.G_RET_STS_SUCCESS;
2397: -- Standard call to check for call compatibility.

Line 2397: -- Standard call to check for call compatibility.

2393: -- Standard Start of API savepoint
2394: SAVEPOINT Copy_List_Queries_PVT;
2395:
2396: x_return_status := FND_API.G_RET_STS_SUCCESS;
2397: -- Standard call to check for call compatibility.
2398: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2399: p_api_version,
2400: l_api_name,
2401: G_PKG_NAME) THEN

Line 2511: -- Standard check of p_commit.

2507:
2508:
2509: END LOOP;
2510:
2511: -- Standard check of p_commit.
2512: IF FND_API.To_Boolean ( p_commit ) THEN
2513: COMMIT WORK;
2514: END IF;
2515:

Line 2531: -- Standard call to get message count AND IF count is 1, get message info.

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.
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