DBA Data[Home] [Help]

APPS.AMV_PERSPECTIVE_PVT dependencies on STANDARD

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

72: AMV_I_PERSPECTIVES_B_S.nextval, sysdate
73: from dual;
74: --
75: BEGIN
76: -- Standard call to check for call compatibility.
77: SAVEPOINT Add_Perspective_Pvt;
78: IF NOT FND_API.Compatible_API_Call (
79: l_api_version,
80: p_api_version,

Line 172: --Standard check of commit

168: X_LAST_UPDATE_DATE => l_current_date,
169: X_LAST_UPDATED_BY => l_current_user_id,
170: X_LAST_UPDATE_LOGIN => l_current_login_id
171: );
172: --Standard check of commit
173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: -- Debug Message

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

177: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
178: FND_MESSAGE.Set_name('AMV','PVT Add Persp. API: End');
179: FND_MSG_PUB.Add;
180: END IF;
181: --Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,
184: p_count => x_msg_count,
185: p_data => x_msg_data

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

187: EXCEPTION
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO Add_Perspective_Pvt;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: -- Standard call to get message count and if count=1, get the message
192: FND_MSG_PUB.Count_And_Get (
193: p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data

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

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

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

208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
211: END IF;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data

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

242: l_perspective_id NUMBER;
243: --
244: --
245: BEGIN
246: -- Standard call to check for call compatibility.
247: SAVEPOINT Delete_Perspective_Pvt;
248: IF NOT FND_API.Compatible_API_Call (
249: l_api_version,
250: p_api_version,

Line 349: --Standard check of commit

345: AMV_I_PERSPECTIVES_PKG.DELETE_ROW
346: (
347: X_PERSPECTIVE_ID => l_perspective_id
348: );
349: --Standard check of commit
350: IF FND_API.To_Boolean ( p_commit ) THEN
351: COMMIT WORK;
352: END IF;
353: --Standard call to get message count and if count=1, get the message

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

349: --Standard check of commit
350: IF FND_API.To_Boolean ( p_commit ) THEN
351: COMMIT WORK;
352: END IF;
353: --Standard call to get message count and if count=1, get the message
354: FND_MSG_PUB.Count_And_Get (
355: p_encoded => FND_API.G_FALSE,
356: p_count => x_msg_count,
357: p_data => x_msg_data

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

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

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

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

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

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

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

423: where perspective_id = p_persp_id;
424: --
425: --
426: BEGIN
427: -- Standard call to check for call compatibility.
428: SAVEPOINT Update_Perspective_Pvt;
429: IF NOT FND_API.Compatible_API_Call (
430: l_api_version,
431: p_api_version,

Line 548: --Standard check of commit

544: X_LAST_UPDATE_DATE => sysdate,
545: X_LAST_UPDATED_BY => l_current_user_id,
546: X_LAST_UPDATE_LOGIN => l_current_login_id
547: );
548: --Standard check of commit
549: IF FND_API.To_Boolean ( p_commit ) THEN
550: COMMIT WORK;
551: END IF;
552: -- Debug Message

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

553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
554: FND_MESSAGE.Set_name('AMV','PVT Update Persp. API: End');
555: FND_MSG_PUB.Add;
556: END IF;
557: --Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data

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

564: EXCEPTION
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Update_Perspective_Pvt;
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 577: -- Standard call to get message count and if count=1, get the message

573: );
574: WHEN FND_API.G_EXC_ERROR THEN
575: ROLLBACK TO Update_Perspective_Pvt;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: -- Standard call to get message count and if count=1, get the message
578: FND_MSG_PUB.Count_And_Get (
579: p_encoded => FND_API.G_FALSE,
580: p_count => x_msg_count,
581: p_data => x_msg_data

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

585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
588: END IF;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data

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

637: --
638: l_perspective_rec Get_PerspRecord_csr%ROWTYPE;
639: --
640: BEGIN
641: -- Standard call to check for call compatibility.
642: IF NOT FND_API.Compatible_API_Call (
643: l_api_version,
644: p_api_version,
645: l_api_name,

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

756: );
757: */
758: END IF;
759: CLOSE Get_PerspRecord_csr;
760: --Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data

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

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

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

773: p_data => x_msg_data
774: );
775: WHEN FND_API.G_EXC_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: -- Standard call to get message count and if count=1, get the message
778: FND_MSG_PUB.Count_And_Get (
779: p_encoded => FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data

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

784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
787: END IF;
788: -- Standard call to get message count and if count=1, get the message
789: FND_MSG_PUB.Count_And_Get (
790: p_encoded => FND_API.G_FALSE,
791: p_count => x_msg_count,
792: p_data => x_msg_data

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

837: l_last_updated_by NUMBER;
838: l_last_update_login NUMBER;
839: --
840: BEGIN
841: -- Standard call to check for call compatibility.
842: IF NOT FND_API.Compatible_API_Call (
843: l_api_version,
844: p_api_version,
845: l_api_name,

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

996: p_subset_request_obj.start_record_position + l_fetch_count,
997: l_total_record_count
998: );
999: */
1000: --Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data

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

1005: );
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: -- Standard call to get message count and if count=1, get the message
1010: FND_MSG_PUB.Count_And_Get (
1011: p_encoded => FND_API.G_FALSE,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data

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

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

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

1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1027: END IF;
1028: -- Standard call to get message count and if count=1, get the message
1029: FND_MSG_PUB.Count_And_Get (
1030: p_encoded => FND_API.G_FALSE,
1031: p_count => x_msg_count,
1032: p_data => x_msg_data

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

1072: Select amv_i_item_perspectives_s.nextval, sysdate
1073: From Dual;
1074: --
1075: BEGIN
1076: -- Standard call to check for call compatibility.
1077: SAVEPOINT Add_ItemPersps_Pvt;
1078: IF NOT FND_API.Compatible_API_Call (
1079: l_api_version,
1080: p_api_version,

Line 1200: --Standard check of commit

1196: END IF;
1197: END IF;
1198: END IF;
1199: END LOOP;
1200: --Standard check of commit
1201: IF FND_API.To_Boolean ( p_commit ) THEN
1202: COMMIT WORK;
1203: END IF;
1204: --Standard call to get message count and if count=1, get the message

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

1200: --Standard check of commit
1201: IF FND_API.To_Boolean ( p_commit ) THEN
1202: COMMIT WORK;
1203: END IF;
1204: --Standard call to get message count and if count=1, get the message
1205: FND_MSG_PUB.Count_And_Get (
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data

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

1210: EXCEPTION
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: ROLLBACK TO Add_ItemPersps_Pvt;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data

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

1219: );
1220: WHEN FND_API.G_EXC_ERROR THEN
1221: ROLLBACK TO Add_ItemPersps_Pvt;
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data

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

1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data

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

1276: Select amv_i_item_perspectives_s.nextval, sysdate
1277: From Dual;
1278: --
1279: BEGIN
1280: -- Standard call to check for call compatibility.
1281: SAVEPOINT Add_ItemPersps_Pvt;
1282: IF NOT FND_API.Compatible_API_Call (
1283: l_api_version,
1284: p_api_version,

Line 1395: --Standard check of commit

1391: p_item_id,
1392: p_perspective_id
1393: );
1394: END IF;
1395: --Standard check of commit
1396: IF FND_API.To_Boolean ( p_commit ) THEN
1397: COMMIT WORK;
1398: END IF;
1399: --Standard call to get message count and if count=1, get the message

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

1395: --Standard check of commit
1396: IF FND_API.To_Boolean ( p_commit ) THEN
1397: COMMIT WORK;
1398: END IF;
1399: --Standard call to get message count and if count=1, get the message
1400: FND_MSG_PUB.Count_And_Get (
1401: p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data

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

1405: EXCEPTION
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: ROLLBACK TO Add_ItemPersps_Pvt;
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409: -- Standard call to get message count and if count=1, get the message
1410: FND_MSG_PUB.Count_And_Get (
1411: p_encoded => FND_API.G_FALSE,
1412: p_count => x_msg_count,
1413: p_data => x_msg_data

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

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

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

1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1429: END IF;
1430: -- Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data

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

1470: Where item_id = p_item_id
1471: And perspective_id = p_perspectiv_id;
1472: --
1473: BEGIN
1474: -- Standard call to check for call compatibility.
1475: SAVEPOINT Delete_ItemPersps_Pvt;
1476: IF NOT FND_API.Compatible_API_Call (
1477: l_api_version,
1478: p_api_version,

Line 1563: --Standard check of commit

1559: Where item_id = p_item_id
1560: And perspective_id = l_perspective_id;
1561: END IF;
1562: END LOOP;
1563: --Standard check of commit
1564: IF FND_API.To_Boolean ( p_commit ) THEN
1565: COMMIT WORK;
1566: END IF;
1567: --Standard call to get message count and if count=1, get the message

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

1563: --Standard check of commit
1564: IF FND_API.To_Boolean ( p_commit ) THEN
1565: COMMIT WORK;
1566: END IF;
1567: --Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data

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

1573: EXCEPTION
1574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1575: ROLLBACK TO Delete_ItemPersps_Pvt;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: -- Standard call to get message count and if count=1, get the message
1578: FND_MSG_PUB.Count_And_Get (
1579: p_encoded => FND_API.G_FALSE,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data

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

1582: );
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: ROLLBACK TO Delete_ItemPersps_Pvt;
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: -- Standard call to get message count and if count=1, get the message
1587: FND_MSG_PUB.Count_And_Get (
1588: p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data

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

1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1597: END IF;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (
1600: p_encoded => FND_API.G_FALSE,
1601: p_count => x_msg_count,
1602: p_data => x_msg_data

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

1635: Where item_id = p_item_id
1636: And perspective_id = p_perspective_id;
1637: --
1638: BEGIN
1639: -- Standard call to check for call compatibility.
1640: SAVEPOINT Delete_ItemPersps_Pvt;
1641: IF NOT FND_API.Compatible_API_Call (
1642: l_api_version,
1643: p_api_version,

Line 1731: --Standard check of commit

1727: -- caller wants to delete all the perspectives of the item.
1728: Delete from amv_i_item_perspectives
1729: Where item_id = p_item_id;
1730: END IF;
1731: --Standard check of commit
1732: IF FND_API.To_Boolean ( p_commit ) THEN
1733: COMMIT WORK;
1734: END IF;
1735: --Standard call to get message count and if count=1, get the message

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

1731: --Standard check of commit
1732: IF FND_API.To_Boolean ( p_commit ) THEN
1733: COMMIT WORK;
1734: END IF;
1735: --Standard call to get message count and if count=1, get the message
1736: FND_MSG_PUB.Count_And_Get (
1737: p_encoded => FND_API.G_FALSE,
1738: p_count => x_msg_count,
1739: p_data => x_msg_data

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

1741: EXCEPTION
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: ROLLBACK TO Delete_ItemPersps_Pvt;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: -- Standard call to get message count and if count=1, get the message
1746: FND_MSG_PUB.Count_And_Get (
1747: p_encoded => FND_API.G_FALSE,
1748: p_count => x_msg_count,
1749: p_data => x_msg_data

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

1750: );
1751: WHEN FND_API.G_EXC_ERROR THEN
1752: ROLLBACK TO Delete_ItemPersps_Pvt;
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: -- Standard call to get message count and if count=1, get the message
1755: FND_MSG_PUB.Count_And_Get (
1756: p_encoded => FND_API.G_FALSE,
1757: p_count => x_msg_count,
1758: p_data => x_msg_data

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

1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1765: END IF;
1766: -- Standard call to get message count and if count=1, get the message
1767: FND_MSG_PUB.Count_And_Get (
1768: p_encoded => FND_API.G_FALSE,
1769: p_count => x_msg_count,
1770: p_data => x_msg_data

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

1860: l_perspective_rec Get_ItemPerspective_csr%ROWTYPE;
1861: l_fetch_count NUMBER := 0;
1862: --
1863: BEGIN
1864: -- Standard call to check for call compatibility.
1865: IF NOT FND_API.Compatible_API_Call (
1866: l_api_version,
1867: p_api_version,
1868: l_api_name,

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

1940: psp_rec.last_update_login
1941: );
1942: */
1943: END LOOP;
1944: --Standard call to get message count and if count=1, get the message
1945: FND_MSG_PUB.Count_And_Get (
1946: p_encoded => FND_API.G_FALSE,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data

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

1949: );
1950: EXCEPTION
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: -- Standard call to get message count and if count=1, get the message
1954: FND_MSG_PUB.Count_And_Get (
1955: p_encoded => FND_API.G_FALSE,
1956: p_count => x_msg_count,
1957: p_data => x_msg_data

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

1957: p_data => x_msg_data
1958: );
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: -- Standard call to get message count and if count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data

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

1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1971: END IF;
1972: -- Standard call to get message count and if count=1, get the message
1973: FND_MSG_PUB.Count_And_Get (
1974: p_encoded => FND_API.G_FALSE,
1975: p_count => x_msg_count,
1976: p_data => x_msg_data