[Home] [Help]
123: JTF_AMV_ITEMS_B_S.nextval, sysdate
124: from dual;
125: --
126: BEGIN
127: -- Standard call to check for call compatibility.
128: SAVEPOINT Create_Item_Pub;
129: IF NOT FND_API.Compatible_API_Call (
130: l_api_version,
131: p_api_version,
339: X_ATTRIBUTE15 => null
340: );
341: -- pass back the item id.
342: x_item_id := l_item_rec.item_id;
343: --Standard check of commit
344: IF FND_API.To_Boolean ( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347: --Standard call to get message count and if count=1, get the message
343: --Standard check of commit
344: IF FND_API.To_Boolean ( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347: --Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
353: EXCEPTION
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO Create_Item_Pub;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: -- Standard call to get message count and if count=1, get the message
358: FND_MSG_PUB.Count_And_Get (
359: p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO Create_Item_Pub;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: -- Standard call to get message count and if count=1, get the message
367: FND_MSG_PUB.Count_And_Get (
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
377: END IF;
378: -- Standard call to get message count and if count=1, get the message
379: FND_MSG_PUB.Count_And_Get (
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data
396: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Item';
397: l_api_version CONSTANT NUMBER := 1.0;
398: --
399: BEGIN
400: -- Standard call to check for call compatibility.
401: SAVEPOINT Delete_Item_Pub;
402: IF NOT FND_API.Compatible_API_Call (
403: l_api_version,
404: p_api_version,
432: where attachment_used_by_id = p_item_id
433: and attachment_used_by = G_USED_BY_ITEM;
434: -- Finally delete the item itself.
435: JTF_AMV_ITEMS_PKG.DELETE_ROW ( p_item_id );
436: --Standard check of commit
437: IF FND_API.To_Boolean ( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440: --Standard call to get message count and if count=1, get the message
436: --Standard check of commit
437: IF FND_API.To_Boolean ( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440: --Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
446: EXCEPTION
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: ROLLBACK TO Delete_Item_Pub;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: -- Standard call to get message count and if count=1, get the message
451: FND_MSG_PUB.Count_And_Get (
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Delete_Item_Pub;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => x_msg_data
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
470: END IF;
471: -- Standard call to get message count and if count=1, get the message
472: FND_MSG_PUB.Count_And_Get (
473: p_encoded => FND_API.G_FALSE,
474: p_count => x_msg_count,
475: p_data => x_msg_data
495: l_old_item_rec ITEM_REC_TYPE;
496: l_record_change_flag boolean := false;
497: --
498: BEGIN
499: -- Standard call to check for call compatibility.
500: SAVEPOINT Update_Item_Pub;
501: IF NOT FND_API.Compatible_API_Call (
502: l_api_version,
503: p_api_version,
839: X_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
840: X_ATTRIBUTE15 => FND_API.G_MISS_CHAR
841: );
842: END IF;
843: --Standard check of commit
844: IF FND_API.To_Boolean ( p_commit ) THEN
845: COMMIT WORK;
846: END IF;
847: --Standard call to get message count and if count=1, get the message
843: --Standard check of commit
844: IF FND_API.To_Boolean ( p_commit ) THEN
845: COMMIT WORK;
846: END IF;
847: --Standard call to get message count and if count=1, get the message
848: FND_MSG_PUB.Count_And_Get (
849: p_encoded => FND_API.G_FALSE,
850: p_count => x_msg_count,
851: p_data => x_msg_data
853: EXCEPTION
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK TO Update_Item_Pub;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: -- Standard call to get message count and if count=1, get the message
858: FND_MSG_PUB.Count_And_Get (
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data
862: );
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO Update_Item_Pub;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: -- Standard call to get message count and if count=1, get the message
867: FND_MSG_PUB.Count_And_Get (
868: p_encoded => FND_API.G_FALSE,
869: p_count => x_msg_count,
870: p_data => x_msg_data
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
877: END IF;
878: -- Standard call to get message count and if count=1, get the message
879: FND_MSG_PUB.Count_And_Get (
880: p_encoded => FND_API.G_FALSE,
881: p_count => x_msg_count,
882: p_data => x_msg_data
931: From jtf_amv_items_vl
932: Where item_id = p_item_id;
933: --
934: BEGIN
935: -- Standard call to check for call compatibility.
936: IF NOT FND_API.Compatible_API_Call (
937: l_api_version,
938: p_api_version,
939: l_api_name,
958: END IF;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: CLOSE Get_Item_csr;
962: --Standard call to get message count and if count=1, get the message
963: FND_MSG_PUB.Count_And_Get (
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data
967: );
968: EXCEPTION
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
975: p_data => x_msg_data
976: );
977: WHEN FND_API.G_EXC_ERROR THEN
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,
983: p_data => x_msg_data
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
989: END IF;
990: -- Standard call to get message count and if count=1, get the message
991: FND_MSG_PUB.Count_And_Get (
992: p_encoded => FND_API.G_FALSE,
993: p_count => x_msg_count,
994: p_data => x_msg_data
1027: Select jtf_amv_item_keywords_s.nextval, sysdate
1028: From Dual;
1029: --
1030: BEGIN
1031: -- Standard call to check for call compatibility.
1032: SAVEPOINT Add_ItemKeyword_Pub;
1033: IF NOT FND_API.Compatible_API_Call (
1034: l_api_version,
1035: p_api_version,
1098: p_keyword_tab(i)
1099: );
1100: END IF;
1101: END LOOP;
1102: --Standard check of commit
1103: IF FND_API.To_Boolean ( p_commit ) THEN
1104: COMMIT WORK;
1105: END IF;
1106: --Standard call to get message count and if count=1, get the message
1102: --Standard check of commit
1103: IF FND_API.To_Boolean ( p_commit ) THEN
1104: COMMIT WORK;
1105: END IF;
1106: --Standard call to get message count and if count=1, get the message
1107: FND_MSG_PUB.Count_And_Get (
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1114: ROLLBACK TO Add_ItemKeyword_Pub;
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: -- Standard call to get message count and if count=1, get the message
1117: FND_MSG_PUB.Count_And_Get (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data
1121: );
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK TO Add_ItemKeyword_Pub;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: -- Standard call to get message count and if count=1, get the message
1126: FND_MSG_PUB.Count_And_Get (
1127: p_encoded => FND_API.G_FALSE,
1128: p_count => x_msg_count,
1129: p_data => x_msg_data
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1136: END IF;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1196: From jtf_amv_item_keywords
1197: Where keyword = p_kword
1198: And item_id = p_item_id;
1199: BEGIN
1200: -- Standard call to check for call compatibility.
1201: SAVEPOINT Delete_ItemKeyword_Pub;
1202: IF NOT FND_API.Compatible_API_Call (
1203: l_api_version,
1204: p_api_version,
1246: -- If no keyword specified, delete all the keywords of the item.
1247: Delete from jtf_amv_item_keywords
1248: Where item_id = p_item_id;
1249: END IF;
1250: --Standard check of commit
1251: IF FND_API.To_Boolean ( p_commit ) THEN
1252: COMMIT WORK;
1253: END IF;
1254: --Standard call to get message count and if count=1, get the message
1250: --Standard check of commit
1251: IF FND_API.To_Boolean ( p_commit ) THEN
1252: COMMIT WORK;
1253: END IF;
1254: --Standard call to get message count and if count=1, get the message
1255: FND_MSG_PUB.Count_And_Get (
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_msg_count,
1258: p_data => x_msg_data
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ROLLBACK TO Delete_ItemKeyword_Pub;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: ROLLBACK TO Delete_ItemKeyword_Pub;
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: -- Standard call to get message count and if count=1, get the message
1274: FND_MSG_PUB.Count_And_Get (
1275: p_encoded => FND_API.G_FALSE,
1276: p_count => x_msg_count,
1277: p_data => x_msg_data
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1284: END IF;
1285: -- Standard call to get message count and if count=1, get the message
1286: FND_MSG_PUB.Count_And_Get (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data
1338: l_temp_number NUMBER;
1339: l_date DATE;
1340: --
1341: BEGIN
1342: -- Standard call to check for call compatibility.
1343: SAVEPOINT Replace_ItemKeyword_Pub;
1344: IF NOT FND_API.Compatible_API_Call (
1345: l_api_version,
1346: p_api_version,
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: --Standard call to get message count and if count=1, get the message
1387: FND_MSG_PUB.Count_And_Get (
1388: p_encoded => FND_API.G_FALSE,
1389: p_count => x_msg_count,
1390: p_data => x_msg_data
1392: EXCEPTION
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: ROLLBACK TO Replace_ItemKeyword_Pub;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: -- Standard call to get message count and if count=1, get the message
1397: FND_MSG_PUB.Count_And_Get (
1398: p_encoded => FND_API.G_FALSE,
1399: p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: ROLLBACK TO Replace_ItemKeyword_Pub;
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: -- Standard call to get message count and if count=1, get the message
1406: FND_MSG_PUB.Count_And_Get (
1407: p_encoded => FND_API.G_FALSE,
1408: p_count => x_msg_count,
1409: p_data => x_msg_data
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1416: END IF;
1417: -- Standard call to get message count and if count=1, get the message
1418: FND_MSG_PUB.Count_And_Get (
1419: p_encoded => FND_API.G_FALSE,
1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1442: from JTF_AMV_ITEM_KEYWORDS
1443: Where item_id = p_item_id;
1444: --
1445: BEGIN
1446: -- Standard call to check for call compatibility.
1447: IF NOT FND_API.Compatible_API_Call (
1448: l_api_version,
1449: p_api_version,
1450: l_api_name,
1472: l_fetch_count := l_fetch_count + 1;
1473: x_keyword_tab.extend;
1474: x_keyword_tab(l_fetch_count) := kword.keyword;
1475: END LOOP;
1476: --Standard call to get message count and if count=1, get the message
1477: FND_MSG_PUB.Count_And_Get (
1478: p_encoded => FND_API.G_FALSE,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: -- Standard call to get message count and if count=1, get the message
1486: FND_MSG_PUB.Count_And_Get (
1487: p_encoded => FND_API.G_FALSE,
1488: p_count => x_msg_count,
1489: p_data => x_msg_data
1489: p_data => x_msg_data
1490: );
1491: WHEN FND_API.G_EXC_ERROR THEN
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: -- Standard call to get message count and if count=1, get the message
1494: FND_MSG_PUB.Count_And_Get (
1495: p_encoded => FND_API.G_FALSE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data
1500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data
1541: Select jtf_amv_item_authors_s.nextval, sysdate
1542: From Dual;
1543: --
1544: BEGIN
1545: -- Standard call to check for call compatibility.
1546: SAVEPOINT Add_ItemAuthor_Pub;
1547: IF NOT FND_API.Compatible_API_Call (
1548: l_api_version,
1549: p_api_version,
1612: p_author_tab(i)
1613: );
1614: END IF;
1615: END LOOP;
1616: --Standard check of commit
1617: IF FND_API.To_Boolean ( p_commit ) THEN
1618: COMMIT WORK;
1619: END IF;
1620: --Standard call to get message count and if count=1, get the message
1616: --Standard check of commit
1617: IF FND_API.To_Boolean ( p_commit ) THEN
1618: COMMIT WORK;
1619: END IF;
1620: --Standard call to get message count and if count=1, get the message
1621: FND_MSG_PUB.Count_And_Get (
1622: p_encoded => FND_API.G_FALSE,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data
1626: EXCEPTION
1627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1628: ROLLBACK TO Add_ItemAuthor_Pub;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );
1636: WHEN FND_API.G_EXC_ERROR THEN
1637: ROLLBACK TO Add_ItemAuthor_Pub;
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: -- Standard call to get message count and if count=1, get the message
1640: FND_MSG_PUB.Count_And_Get (
1641: p_encoded => FND_API.G_FALSE,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1650: END IF;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data
1708: From jtf_amv_item_authors
1709: Where author = p_author
1710: And item_id = p_item_id;
1711: BEGIN
1712: -- Standard call to check for call compatibility.
1713: SAVEPOINT Delete_ItemAuthor_Pub;
1714: IF NOT FND_API.Compatible_API_Call (
1715: l_api_version,
1716: p_api_version,
1758: -- If no author specified, delete all the authors of the item.
1759: Delete from jtf_amv_item_authors
1760: Where item_id = p_item_id;
1761: END IF;
1762: --Standard check of commit
1763: IF FND_API.To_Boolean ( p_commit ) THEN
1764: COMMIT WORK;
1765: END IF;
1766: --Standard call to get message count and if count=1, get the message
1762: --Standard check of commit
1763: IF FND_API.To_Boolean ( p_commit ) THEN
1764: COMMIT WORK;
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
1772: EXCEPTION
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: ROLLBACK TO Delete_ItemAuthor_Pub;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: -- Standard call to get message count and if count=1, get the message
1777: FND_MSG_PUB.Count_And_Get (
1778: p_encoded => FND_API.G_FALSE,
1779: p_count => x_msg_count,
1780: p_data => x_msg_data
1781: );
1782: WHEN FND_API.G_EXC_ERROR THEN
1783: ROLLBACK TO Delete_ItemAuthor_Pub;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: -- Standard call to get message count and if count=1, get the message
1786: FND_MSG_PUB.Count_And_Get (
1787: p_encoded => FND_API.G_FALSE,
1788: p_count => x_msg_count,
1789: p_data => x_msg_data
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1796: END IF;
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data
1850: l_temp_number NUMBER;
1851: l_date DATE;
1852: --
1853: BEGIN
1854: -- Standard call to check for call compatibility.
1855: SAVEPOINT Replace_ItemAuthor_Pub;
1856: IF NOT FND_API.Compatible_API_Call (
1857: l_api_version,
1858: p_api_version,
1889: x_msg_data => x_msg_data,
1890: p_item_id => p_item_id,
1891: p_author_tab => p_author_tab
1892: );
1893: --Standard call to get message count and if count=1, get the message
1894: FND_MSG_PUB.Count_And_Get (
1895: p_encoded => FND_API.G_FALSE,
1896: p_count => x_msg_count,
1897: p_data => x_msg_data
1899: EXCEPTION
1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1901: ROLLBACK TO Replace_ItemAuthor_Pub;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: -- Standard call to get message count and if count=1, get the message
1904: FND_MSG_PUB.Count_And_Get (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
1908: );
1909: WHEN FND_API.G_EXC_ERROR THEN
1910: ROLLBACK TO Replace_ItemAuthor_Pub;
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: -- Standard call to get message count and if count=1, get the message
1913: FND_MSG_PUB.Count_And_Get (
1914: p_encoded => FND_API.G_FALSE,
1915: p_count => x_msg_count,
1916: p_data => x_msg_data
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1923: END IF;
1924: -- Standard call to get message count and if count=1, get the message
1925: FND_MSG_PUB.Count_And_Get (
1926: p_encoded => FND_API.G_FALSE,
1927: p_count => x_msg_count,
1928: p_data => x_msg_data
1949: from JTF_AMV_ITEM_AUTHORS
1950: Where item_id = p_item_id;
1951: --
1952: BEGIN
1953: -- Standard call to check for call compatibility.
1954: IF NOT FND_API.Compatible_API_Call (
1955: l_api_version,
1956: p_api_version,
1957: l_api_name,
1979: l_fetch_count := l_fetch_count + 1;
1980: x_author_tab.extend;
1981: x_author_tab(l_fetch_count) := rec.author;
1982: END LOOP;
1983: --Standard call to get message count and if count=1, get the message
1984: FND_MSG_PUB.Count_And_Get (
1985: p_encoded => FND_API.G_FALSE,
1986: p_count => x_msg_count,
1987: p_data => x_msg_data
1988: );
1989: EXCEPTION
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1992: -- Standard call to get message count and if count=1, get the message
1993: FND_MSG_PUB.Count_And_Get (
1994: p_encoded => FND_API.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data
1996: p_data => x_msg_data
1997: );
1998: WHEN FND_API.G_EXC_ERROR THEN
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000: -- Standard call to get message count and if count=1, get the message
2001: FND_MSG_PUB.Count_And_Get (
2002: p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data
2007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2010: END IF;
2011: -- Standard call to get message count and if count=1, get the message
2012: FND_MSG_PUB.Count_And_Get (
2013: p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data