[Home] [Help]
51: l_item_obj AMV_ITEM_OBJ_TYPE := p_item_obj;
52: l_persp_id_array AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE;
53: --
54: BEGIN
55: -- Standard call to check for call compatibility.
56: SAVEPOINT Create_Item_Pub;
57:
58:
59: IF NOT FND_API.Compatible_API_Call (
363: );
364: END IF;
365: -- pass back the item id.
366: x_item_id := l_item_id;
367: --Standard check of commit
368: IF FND_API.To_Boolean ( p_commit ) THEN
369: COMMIT WORK;
370: END IF;
371: --Standard call to get message count and if count=1, get the message
367: --Standard check of commit
368: IF FND_API.To_Boolean ( p_commit ) THEN
369: COMMIT WORK;
370: END IF;
371: --Standard call to get message count and if count=1, get the message
372: FND_MSG_PUB.Count_And_Get (
373: p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data
377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: ROLLBACK TO Create_Item_Pub;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: -- Standard call to get message count and if count=1, get the message
382: FND_MSG_PUB.Count_And_Get (
383: p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Create_Item_Pub;
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
401: END IF;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.Count_And_Get (
404: p_encoded => FND_API.G_FALSE,
405: p_count => x_msg_count,
406: p_data => x_msg_data
428: l_admin_flag VARCHAR2(1);
429: l_return_status VARCHAR2(1);
430: --
431: BEGIN
432: -- Standard call to check for call compatibility.
433: SAVEPOINT Delete_Item_Pub;
434: IF NOT FND_API.Compatible_API_Call (
435: l_api_version,
436: p_api_version,
547: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR AND
548: x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: --Standard call to get message count and if count=1, get the message
552: FND_MSG_PUB.Count_And_Get (
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data
557: EXCEPTION
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO Delete_Item_Pub;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO Delete_Item_Pub;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: -- Standard call to get message count and if count=1, get the message
571: FND_MSG_PUB.Count_And_Get (
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
627: WHERE item_id = p_item_obj.item_id
628: AND available_due_to_type = AMV_UTILITY_PVT.G_PUSH;
629: --
630: BEGIN
631: -- Standard call to check for call compatibility.
632: SAVEPOINT Update_Item_Pub;
633: IF NOT FND_API.Compatible_API_Call (
634: l_api_version,
635: p_api_version,
980: p_check_login_user => FND_API.G_FALSE,
981: p_item_id => p_item_obj.item_id
982: );
983: END IF;
984: --Standard check of commit
985: IF FND_API.To_Boolean ( p_commit ) THEN
986: COMMIT WORK;
987: END IF;
988: --Standard call to get message count and if count=1, get the message
984: --Standard check of commit
985: IF FND_API.To_Boolean ( p_commit ) THEN
986: COMMIT WORK;
987: END IF;
988: --Standard call to get message count and if count=1, get the message
989: FND_MSG_PUB.Count_And_Get (
990: p_encoded => FND_API.G_FALSE,
991: p_count => x_msg_count,
992: p_data => x_msg_data
994: EXCEPTION
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO Update_Item_Pub;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: -- Standard call to get message count and if count=1, get the message
999: FND_MSG_PUB.Count_And_Get (
1000: p_encoded => FND_API.G_FALSE,
1001: p_count => x_msg_count,
1002: p_data => x_msg_data
1003: );
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: ROLLBACK TO Update_Item_Pub;
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: -- Standard call to get message count and if count=1, get the message
1008: FND_MSG_PUB.Count_And_Get (
1009: p_encoded => FND_API.G_FALSE,
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1016: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1018: END IF;
1019: -- Standard call to get message count and if count=1, get the message
1020: FND_MSG_PUB.Count_And_Get (
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data
1054: l_keyword_varray AMV_CHAR_VARRAY_TYPE;
1055: l_file_id_varray AMV_NUMBER_VARRAY_TYPE;
1056: --
1057: BEGIN
1058: -- Standard call to check for call compatibility.
1059: IF NOT FND_API.Compatible_API_Call (
1060: l_api_version,
1061: p_api_version,
1062: l_api_name,
1209: x_author_array := AMV_CHAR_VARRAY_TYPE();
1210: x_author_array := l_author_varray;
1211: x_keyword_array := AMV_CHAR_VARRAY_TYPE();
1212: x_keyword_array := l_keyword_varray;
1213: --Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219: EXCEPTION
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1226: p_data => x_msg_data
1227: );
1228: WHEN FND_API.G_EXC_ERROR THEN
1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: -- Standard call to get message count and if count=1, get the message
1231: FND_MSG_PUB.Count_And_Get (
1232: p_encoded => FND_API.G_FALSE,
1233: p_count => x_msg_count,
1234: p_data => x_msg_data
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1242: FND_MSG_PUB.Count_And_Get (
1243: p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data
1314: l_file_id_varray AMV_NUMBER_VARRAY_TYPE;
1315: l_file_id_list VARCHAR2(2000);
1316: --
1317: BEGIN
1318: -- Standard call to check for call compatibility.
1319: IF NOT FND_API.Compatible_API_Call (
1320: l_api_version,
1321: p_api_version,
1322: l_api_name,
1573: x_subset_return_obj.returned_record_count := l_fetch_count;
1574: x_subset_return_obj.next_record_position :=
1575: p_subset_request_obj.start_record_position + l_fetch_count;
1576: x_subset_return_obj.total_record_count := l_total_record_count;
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
1582: );
1583: EXCEPTION
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585: x_return_status := FND_API.G_RET_STS_UNEXP_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
1590: p_data => x_msg_data
1591: );
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1603: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1604: END IF;
1605: -- Standard call to get message count and if count=1, get the message
1606: FND_MSG_PUB.Count_And_Get (
1607: p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data
1704: EXCEPTION
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: ROLLBACK TO Add_ItemKeyword_Pub;
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1708: -- Standard call to get message count and if count=1, get the message
1709: FND_MSG_PUB.Count_And_Get (
1710: p_encoded => FND_API.G_FALSE,
1711: p_count => x_msg_count,
1712: p_data => x_msg_data
1713: );
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO Add_ItemKeyword_Pub;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: -- Standard call to get message count and if count=1, get the message
1718: FND_MSG_PUB.Count_And_Get (
1719: p_encoded => FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data
1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1727: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1728: END IF;
1729: -- Standard call to get message count and if count=1, get the message
1730: FND_MSG_PUB.Count_And_Get (
1731: p_encoded => FND_API.G_FALSE,
1732: p_count => x_msg_count,
1733: p_data => x_msg_data
1787: --
1788: l_admin_flag VARCHAR2(1);
1789: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
1790: BEGIN
1791: -- Standard call to check for call compatibility.
1792: SAVEPOINT Delete_ItemKeyword_Pub;
1793: --Initialize message list if p_init_msg_list is TRUE.
1794: IF FND_API.To_Boolean (p_init_msg_list) THEN
1795: FND_MSG_PUB.initialize;
1857: EXCEPTION
1858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1859: ROLLBACK TO Delete_ItemKeyword_Pub;
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: FND_MSG_PUB.Count_And_Get (
1863: p_encoded => FND_API.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data
1866: );
1867: WHEN FND_API.G_EXC_ERROR THEN
1868: ROLLBACK TO Delete_ItemKeyword_Pub;
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: -- Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (
1872: p_encoded => FND_API.G_FALSE,
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1881: END IF;
1882: -- Standard call to get message count and if count=1, get the message
1883: FND_MSG_PUB.Count_And_Get (
1884: p_encoded => FND_API.G_FALSE,
1885: p_count => x_msg_count,
1886: p_data => x_msg_data
1939: l_current_user_status VARCHAR2(80);
1940: --
1941: l_admin_flag VARCHAR2(1);
1942: BEGIN
1943: -- Standard call to check for call compatibility.
1944: SAVEPOINT Replace_ItemKeyword_Pub;
1945: IF NOT FND_API.Compatible_API_Call (
1946: l_api_version,
1947: p_api_version,
2029: EXCEPTION
2030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2031: ROLLBACK TO Replace_ItemKeyword_Pub;
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: -- Standard call to get message count and if count=1, get the message
2034: FND_MSG_PUB.Count_And_Get (
2035: p_encoded => FND_API.G_FALSE,
2036: p_count => x_msg_count,
2037: p_data => x_msg_data
2038: );
2039: WHEN FND_API.G_EXC_ERROR THEN
2040: ROLLBACK TO Replace_ItemKeyword_Pub;
2041: x_return_status := FND_API.G_RET_STS_ERROR;
2042: -- Standard call to get message count and if count=1, get the message
2043: FND_MSG_PUB.Count_And_Get (
2044: p_encoded => FND_API.G_FALSE,
2045: p_count => x_msg_count,
2046: p_data => x_msg_data
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2053: END IF;
2054: -- Standard call to get message count and if count=1, get the message
2055: FND_MSG_PUB.Count_And_Get (
2056: p_encoded => FND_API.G_FALSE,
2057: p_count => x_msg_count,
2058: p_data => x_msg_data
2125: END IF;
2126: EXCEPTION
2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: -- Standard call to get message count and if count=1, get the message
2130: FND_MSG_PUB.Count_And_Get (
2131: p_encoded => FND_API.G_FALSE,
2132: p_count => x_msg_count,
2133: p_data => x_msg_data
2133: p_data => x_msg_data
2134: );
2135: WHEN FND_API.G_EXC_ERROR THEN
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: -- Standard call to get message count and if count=1, get the message
2138: FND_MSG_PUB.Count_And_Get (
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2147: END IF;
2148: -- Standard call to get message count and if count=1, get the message
2149: FND_MSG_PUB.Count_And_Get (
2150: p_encoded => FND_API.G_FALSE,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data
2176: l_admin_flag VARCHAR2(1);
2177: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2178: --
2179: BEGIN
2180: -- Standard call to check for call compatibility.
2181: SAVEPOINT Add_ItemAuthor_Pub;
2182: --Initialize message list if p_init_msg_list is TRUE.
2183: IF FND_API.To_Boolean (p_init_msg_list) THEN
2184: FND_MSG_PUB.initialize;
2248: EXCEPTION
2249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2250: ROLLBACK TO Add_ItemAuthor_Pub;
2251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2252: -- Standard call to get message count and if count=1, get the message
2253: FND_MSG_PUB.Count_And_Get (
2254: p_encoded => FND_API.G_FALSE,
2255: p_count => x_msg_count,
2256: p_data => x_msg_data
2257: );
2258: WHEN FND_API.G_EXC_ERROR THEN
2259: ROLLBACK TO Add_ItemAuthor_Pub;
2260: x_return_status := FND_API.G_RET_STS_ERROR;
2261: -- Standard call to get message count and if count=1, get the message
2262: FND_MSG_PUB.Count_And_Get (
2263: p_encoded => FND_API.G_FALSE,
2264: p_count => x_msg_count,
2265: p_data => x_msg_data
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2271: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2272: END IF;
2273: -- Standard call to get message count and if count=1, get the message
2274: FND_MSG_PUB.Count_And_Get (
2275: p_encoded => FND_API.G_FALSE,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data
2331: --
2332: l_admin_flag VARCHAR2(1);
2333: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2334: BEGIN
2335: -- Standard call to check for call compatibility.
2336: SAVEPOINT Delete_ItemAuthor_Pub;
2337: --Initialize message list if p_init_msg_list is TRUE.
2338: IF FND_API.To_Boolean (p_init_msg_list) THEN
2339: FND_MSG_PUB.initialize;
2400: EXCEPTION
2401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2402: ROLLBACK TO Delete_ItemAuthor_Pub;
2403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2404: -- Standard call to get message count and if count=1, get the message
2405: FND_MSG_PUB.Count_And_Get (
2406: p_encoded => FND_API.G_FALSE,
2407: p_count => x_msg_count,
2408: p_data => x_msg_data
2409: );
2410: WHEN FND_API.G_EXC_ERROR THEN
2411: ROLLBACK TO Delete_ItemAuthor_Pub;
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: -- Standard call to get message count and if count=1, get the message
2414: FND_MSG_PUB.Count_And_Get (
2415: p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2423: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2424: END IF;
2425: -- Standard call to get message count and if count=1, get the message
2426: FND_MSG_PUB.Count_And_Get (
2427: p_encoded => FND_API.G_FALSE,
2428: p_count => x_msg_count,
2429: p_data => x_msg_data
2482: l_current_user_status VARCHAR2(80);
2483: --
2484: l_admin_flag VARCHAR2(1);
2485: BEGIN
2486: -- Standard call to check for call compatibility.
2487: SAVEPOINT Replace_ItemAuthor_Pub;
2488: IF NOT FND_API.Compatible_API_Call (
2489: l_api_version,
2490: p_api_version,
2582: EXCEPTION
2583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2584: ROLLBACK TO Replace_ItemAuthor_Pub;
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: -- Standard call to get message count and if count=1, get the message
2587: FND_MSG_PUB.Count_And_Get (
2588: p_encoded => FND_API.G_FALSE,
2589: p_count => x_msg_count,
2590: p_data => x_msg_data
2591: );
2592: WHEN FND_API.G_EXC_ERROR THEN
2593: ROLLBACK TO Replace_ItemAuthor_Pub;
2594: x_return_status := FND_API.G_RET_STS_ERROR;
2595: -- Standard call to get message count and if count=1, get the message
2596: FND_MSG_PUB.Count_And_Get (
2597: p_encoded => FND_API.G_FALSE,
2598: p_count => x_msg_count,
2599: p_data => x_msg_data
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2604: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2605: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2606: END IF;
2607: -- Standard call to get message count and if count=1, get the message
2608: FND_MSG_PUB.Count_And_Get (
2609: p_encoded => FND_API.G_FALSE,
2610: p_count => x_msg_count,
2611: p_data => x_msg_data
2678: END IF;
2679: EXCEPTION
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2682: -- Standard call to get message count and if count=1, get the message
2683: FND_MSG_PUB.Count_And_Get (
2684: p_encoded => FND_API.G_FALSE,
2685: p_count => x_msg_count,
2686: p_data => x_msg_data
2686: p_data => x_msg_data
2687: );
2688: WHEN FND_API.G_EXC_ERROR THEN
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: -- Standard call to get message count and if count=1, get the message
2691: FND_MSG_PUB.Count_And_Get (
2692: p_encoded => FND_API.G_FALSE,
2693: p_count => x_msg_count,
2694: p_data => x_msg_data
2697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2700: END IF;
2701: -- Standard call to get message count and if count=1, get the message
2702: FND_MSG_PUB.Count_And_Get (
2703: p_encoded => FND_API.G_FALSE,
2704: p_count => x_msg_count,
2705: p_data => x_msg_data
2751: AND attachment_used_by_id = p_item_id
2752: AND attachment_used_by = G_USED_BY_ITEM;
2753: --
2754: BEGIN
2755: -- Standard call to check for call compatibility.
2756: SAVEPOINT Add_ItemFile_Pub;
2757: IF NOT FND_API.Compatible_API_Call (
2758: l_api_version,
2759: p_api_version,
2920: END IF;
2921: END IF;
2922: END IF;
2923: END LOOP;
2924: --Standard check of commit
2925: IF FND_API.To_Boolean ( p_commit ) THEN
2926: COMMIT WORK;
2927: END IF;
2928: --Standard call to get message count and if count=1, get the message
2924: --Standard check of commit
2925: IF FND_API.To_Boolean ( p_commit ) THEN
2926: COMMIT WORK;
2927: END IF;
2928: --Standard call to get message count and if count=1, get the message
2929: FND_MSG_PUB.Count_And_Get (
2930: p_encoded => FND_API.G_FALSE,
2931: p_count => x_msg_count,
2932: p_data => x_msg_data
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2936: ROLLBACK TO Add_ItemFile_Pub;
2937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2938: -- Standard call to get message count and if count=1, get the message
2939: FND_MSG_PUB.Count_And_Get (
2940: p_encoded => FND_API.G_FALSE,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data
2943: );
2944: WHEN FND_API.G_EXC_ERROR THEN
2945: ROLLBACK TO Add_ItemFile_Pub;
2946: x_return_status := FND_API.G_RET_STS_ERROR;
2947: -- Standard call to get message count and if count=1, get the message
2948: FND_MSG_PUB.Count_And_Get (
2949: p_encoded => FND_API.G_FALSE,
2950: p_count => x_msg_count,
2951: p_data => x_msg_data
2955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2958: END IF;
2959: -- Standard call to get message count and if count=1, get the message
2960: FND_MSG_PUB.Count_And_Get (
2961: p_encoded => FND_API.G_FALSE,
2962: p_count => x_msg_count,
2963: p_data => x_msg_data
3030: AND attachment_used_by_id = p_item_id
3031: AND attachment_used_by = G_USED_BY_ITEM;
3032: --
3033: BEGIN
3034: -- Standard call to check for call compatibility.
3035: SAVEPOINT Delete_ItemFile_Pub;
3036: IF NOT FND_API.Compatible_API_Call (
3037: l_api_version,
3038: p_api_version,
3136: DELETE FROM jtf_amv_attachments
3137: WHERE attachment_used_by_id = p_item_id
3138: AND attachment_used_by = G_USED_BY_ITEM;
3139: END IF;
3140: --Standard check of commit
3141: IF FND_API.To_Boolean ( p_commit ) THEN
3142: COMMIT WORK;
3143: END IF;
3144: --Standard call to get message count and if count=1, get the message
3140: --Standard check of commit
3141: IF FND_API.To_Boolean ( p_commit ) THEN
3142: COMMIT WORK;
3143: END IF;
3144: --Standard call to get message count and if count=1, get the message
3145: FND_MSG_PUB.Count_And_Get (
3146: p_encoded => FND_API.G_FALSE,
3147: p_count => x_msg_count,
3148: p_data => x_msg_data
3150: EXCEPTION
3151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3152: ROLLBACK TO Delete_ItemFile_Pub;
3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3154: -- Standard call to get message count and if count=1, get the message
3155: FND_MSG_PUB.Count_And_Get (
3156: p_encoded => FND_API.G_FALSE,
3157: p_count => x_msg_count,
3158: p_data => x_msg_data
3159: );
3160: WHEN FND_API.G_EXC_ERROR THEN
3161: ROLLBACK TO Delete_ItemFile_Pub;
3162: x_return_status := FND_API.G_RET_STS_ERROR;
3163: -- Standard call to get message count and if count=1, get the message
3164: FND_MSG_PUB.Count_And_Get (
3165: p_encoded => FND_API.G_FALSE,
3166: p_count => x_msg_count,
3167: p_data => x_msg_data
3171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3173: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3174: END IF;
3175: -- Standard call to get message count and if count=1, get the message
3176: FND_MSG_PUB.Count_And_Get (
3177: p_encoded => FND_API.G_FALSE,
3178: p_count => x_msg_count,
3179: p_data => x_msg_data
3235: l_count NUMBER;
3236: l_temp_number NUMBER;
3237: --
3238: BEGIN
3239: -- Standard call to check for call compatibility.
3240: SAVEPOINT Replace_ItemFile_Pub;
3241: IF NOT FND_API.Compatible_API_Call (
3242: l_api_version,
3243: p_api_version,
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3331: ROLLBACK TO Replace_ItemFile_Pub;
3332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3333: -- Standard call to get message count and if count=1, get the message
3334: FND_MSG_PUB.Count_And_Get (
3335: p_encoded => FND_API.G_FALSE,
3336: p_count => x_msg_count,
3337: p_data => x_msg_data
3338: );
3339: WHEN FND_API.G_EXC_ERROR THEN
3340: ROLLBACK TO Replace_ItemFile_Pub;
3341: x_return_status := FND_API.G_RET_STS_ERROR;
3342: -- Standard call to get message count and if count=1, get the message
3343: FND_MSG_PUB.Count_And_Get (
3344: p_encoded => FND_API.G_FALSE,
3345: p_count => x_msg_count,
3346: p_data => x_msg_data
3350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3352: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3353: END IF;
3354: -- Standard call to get message count and if count=1, get the message
3355: FND_MSG_PUB.Count_And_Get (
3356: p_encoded => FND_API.G_FALSE,
3357: p_count => x_msg_count,
3358: p_data => x_msg_data
3385: WHERE attachment_used_by_id = p_item_id
3386: AND attachment_used_by = G_USED_BY_ITEM;
3387: --
3388: BEGIN
3389: -- Standard call to check for call compatibility.
3390: IF NOT FND_API.Compatible_API_Call (
3391: l_api_version,
3392: p_api_version,
3393: l_api_name,
3434: l_fetch_count := l_fetch_count + 1;
3435: x_file_id_varray.extend;
3436: x_file_id_varray(l_fetch_count) := rec.file_id;
3437: END LOOP;
3438: --Standard call to get message count and if count=1, get the message
3439: FND_MSG_PUB.Count_And_Get (
3440: p_encoded => FND_API.G_FALSE,
3441: p_count => x_msg_count,
3442: p_data => x_msg_data
3443: );
3444: EXCEPTION
3445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3447: -- Standard call to get message count and if count=1, get the message
3448: FND_MSG_PUB.Count_And_Get (
3449: p_encoded => FND_API.G_FALSE,
3450: p_count => x_msg_count,
3451: p_data => x_msg_data
3451: p_data => x_msg_data
3452: );
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: x_return_status := FND_API.G_RET_STS_ERROR;
3455: -- Standard call to get message count and if count=1, get the message
3456: FND_MSG_PUB.Count_And_Get (
3457: p_encoded => FND_API.G_FALSE,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data
3462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3464: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3465: END IF;
3466: -- Standard call to get message count and if count=1, get the message
3467: FND_MSG_PUB.Count_And_Get (
3468: p_encoded => FND_API.G_FALSE,
3469: p_count => x_msg_count,
3470: p_data => x_msg_data
3532: AND NVL(g.end_date_active, SYSDATE+1) > SYSDATE
3533: ;
3534: --
3535: BEGIN
3536: -- Standard call to check for call compatibility.
3537: IF NOT FND_API.Compatible_API_Call (
3538: l_api_version,
3539: p_api_version,
3540: l_api_name,
3575: x_item_id_varray(l_count) := cur.item_id;
3576: x_message_varray.extend;
3577: x_message_varray(l_count) := cur.item_name;
3578: END LOOP;
3579: --Standard call to get message count and if count=1, get the message
3580: FND_MSG_PUB.Count_And_Get (
3581: p_encoded => FND_API.G_FALSE,
3582: p_count => x_msg_count,
3583: p_data => x_msg_data
3584: );
3585: EXCEPTION
3586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3588: -- Standard call to get message count and if count=1, get the message
3589: FND_MSG_PUB.Count_And_Get (
3590: p_encoded => FND_API.G_FALSE,
3591: p_count => x_msg_count,
3592: p_data => x_msg_data
3592: p_data => x_msg_data
3593: );
3594: WHEN FND_API.G_EXC_ERROR THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: -- Standard call to get message count and if count=1, get the message
3597: FND_MSG_PUB.Count_And_Get (
3598: p_encoded => FND_API.G_FALSE,
3599: p_count => x_msg_count,
3600: p_data => x_msg_data
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3606: END IF;
3607: -- Standard call to get message count and if count=1, get the message
3608: FND_MSG_PUB.Count_And_Get (
3609: p_encoded => FND_API.G_FALSE,
3610: p_count => x_msg_count,
3611: p_data => x_msg_data
3714: AND NVL(g.end_date_active, SYSDATE+1) > SYSDATE
3715: ;
3716: --
3717: BEGIN
3718: -- Standard call to check for call compatibility.
3719: IF NOT FND_API.Compatible_API_Call (
3720: l_api_version,
3721: p_api_version,
3722: l_api_name,
3782: x_item_varray(l_count).persp_name_list := ' ';
3783: x_item_varray(l_count).author_list := ' ';
3784: x_item_varray(l_count).keyword_list := ' ';
3785: END LOOP;
3786: --Standard call to get message count and if count=1, get the message
3787: FND_MSG_PUB.Count_And_Get (
3788: p_encoded => FND_API.G_FALSE,
3789: p_count => x_msg_count,
3790: p_data => x_msg_data
3791: );
3792: EXCEPTION
3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3795: -- Standard call to get message count and if count=1, get the message
3796: FND_MSG_PUB.Count_And_Get (
3797: p_encoded => FND_API.G_FALSE,
3798: p_count => x_msg_count,
3799: p_data => x_msg_data
3799: p_data => x_msg_data
3800: );
3801: WHEN FND_API.G_EXC_ERROR THEN
3802: x_return_status := FND_API.G_RET_STS_ERROR;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => FND_API.G_FALSE,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data
3810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3811: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3812: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3813: END IF;
3814: -- Standard call to get message count and if count=1, get the message
3815: FND_MSG_PUB.Count_And_Get (
3816: p_encoded => FND_API.G_FALSE,
3817: p_count => x_msg_count,
3818: p_data => x_msg_data
3883: and decode(p_match_type, FND_API.G_MISS_CHAR, p_match_type, m.available_due_to_type) = p_match_type;
3884: --and m.available_due_to_type in (decode(p_match_type,FND_API.G_MISS_CHAR,l_all_match,p_match_type));
3885: --
3886: BEGIN
3887: -- Standard call to check for call compatibility.
3888: IF NOT FND_API.Compatible_API_Call (
3889: l_api_version,
3890: p_api_version,
3891: l_api_name,
3930: END LOOP;
3931: CLOSE GetChannels_csr;
3932: --
3933:
3934: --Standard call to get message count and if count=1, get the message
3935: FND_MSG_PUB.Count_And_Get (
3936: p_encoded => FND_API.G_FALSE,
3937: p_count => x_msg_count,
3938: p_data => x_msg_data
3939: );
3940: EXCEPTION
3941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3943: -- Standard call to get message count and if count=1, get the message
3944: FND_MSG_PUB.Count_And_Get (
3945: p_encoded => FND_API.G_FALSE,
3946: p_count => x_msg_count,
3947: p_data => x_msg_data
3947: p_data => x_msg_data
3948: );
3949: WHEN FND_API.G_EXC_ERROR THEN
3950: x_return_status := FND_API.G_RET_STS_ERROR;
3951: -- Standard call to get message count and if count=1, get the message
3952: FND_MSG_PUB.Count_And_Get (
3953: p_encoded => FND_API.G_FALSE,
3954: p_count => x_msg_count,
3955: p_data => x_msg_data
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3960: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3961: END IF;
3962: -- Standard call to get message count and if count=1, get the message
3963: FND_MSG_PUB.Count_And_Get (
3964: p_encoded => FND_API.G_FALSE,
3965: p_count => x_msg_count,
3966: p_data => x_msg_data