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.GMF_CMCOMMON dependencies on FND_API

Line 454: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

450: ***********************************************************************************************/
451: FUNCTION Get_Process_Item_Cost
452: (
453: p_api_version IN NUMBER
454: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
455: , x_return_status OUT NOCOPY VARCHAR2
456: , x_msg_count OUT NOCOPY NUMBER
457: , x_msg_data OUT NOCOPY VARCHAR2
458: , p_inventory_item_id IN NUMBER /* Item_Id */

Line 725: IF FND_API.to_Boolean( p_init_msg_list ) THEN

721:
722: /*************************************************************
723: * Initialize message list if p_init_msg_list is set to TRUE. *
724: *************************************************************/
725: IF FND_API.to_Boolean( p_init_msg_list ) THEN
726: FND_MSG_PUB.initialize;
727: END IF;
728:
729: /*************************************************

Line 733: IF NOT FND_API.Compatible_API_Call

729: /*************************************************
730: * Standard call to check for call compatibility. *
731: *************************************************/
732:
733: IF NOT FND_API.Compatible_API_Call
734: (
735: l_api_version,
736: p_api_version,
737: l_api_name,

Line 740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

736: p_api_version,
737: l_api_name,
738: G_PKG_NAME
739: ) THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742:
743: /******************************************
744: * Initialize API return status to success *

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

742:
743: /******************************************
744: * Initialize API return status to success *
745: ******************************************/
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: x_msg_count := 0;
748: x_msg_data := NULL;
749:
750: IF (l_debug_flag > 0) THEN

Line 1200: WHEN FND_API.G_EXC_ERROR THEN

1196: p_count => x_msg_count,
1197: p_data => x_msg_data
1198: );
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get (
1203: p_count => x_msg_count,
1204: p_data => x_msg_data

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR ;

1197: p_data => x_msg_data
1198: );
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get (
1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );

Line 1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1206: RETURN -1;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MSG_PUB.Count_And_Get (
1210: p_count => x_msg_count,
1211: p_data => x_msg_data

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1204: p_data => x_msg_data
1205: );
1206: RETURN -1;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MSG_PUB.Count_And_Get (
1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );

Line 1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1211: p_data => x_msg_data
1212: );
1213: RETURN -1;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.Add_Exc_Msg (
1218: G_PKG_NAME,
1219: l_api_name

Line 1280: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1276: ***********************************************************************************************/
1277: FUNCTION Get_Process_Item_Cost
1278: (
1279: p_api_version IN NUMBER
1280: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1281: , x_return_status OUT NOCOPY VARCHAR2
1282: , x_msg_count OUT NOCOPY NUMBER
1283: , x_msg_data OUT NOCOPY VARCHAR2
1284: , p_inventory_item_id IN NUMBER /* Item_Id */

Line 1441: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1437:
1438: /*************************************************************
1439: * Initialize message list if p_init_msg_list is set to TRUE. *
1440: *************************************************************/
1441: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445: /*************************************************

Line 1448: IF NOT FND_API.Compatible_API_Call (

1444:
1445: /*************************************************
1446: * Standard call to check for call compatibility. *
1447: *************************************************/
1448: IF NOT FND_API.Compatible_API_Call (
1449: l_api_version,
1450: p_api_version,
1451: l_api_name,
1452: G_PKG_NAME

Line 1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1450: p_api_version,
1451: l_api_name,
1452: G_PKG_NAME
1453: ) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: END IF;
1456:
1457: /******************************************
1458: * Initialize API return status to success *

Line 1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

1456:
1457: /******************************************
1458: * Initialize API return status to success *
1459: ******************************************/
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461: x_msg_count := 0;
1462: x_msg_data := NULL;
1463:
1464: IF (p_inventory_item_id IS NULL OR p_organization_id IS NULL OR p_transaction_date IS NULL) THEN

Line 1690: WHEN FND_API.G_EXC_ERROR THEN

1686: x_no_of_rows := 0;
1687: x_total_cost := 0;
1688: p_no_of_rows := 0;
1689: RETURN(-1);
1690: WHEN FND_API.G_EXC_ERROR THEN
1691: x_return_status := FND_API.G_RET_STS_ERROR ;
1692: FND_MSG_PUB.Count_And_Get (
1693: p_count => x_msg_count,
1694: p_data => x_msg_data

Line 1691: x_return_status := FND_API.G_RET_STS_ERROR ;

1687: x_total_cost := 0;
1688: p_no_of_rows := 0;
1689: RETURN(-1);
1690: WHEN FND_API.G_EXC_ERROR THEN
1691: x_return_status := FND_API.G_RET_STS_ERROR ;
1692: FND_MSG_PUB.Count_And_Get (
1693: p_count => x_msg_count,
1694: p_data => x_msg_data
1695: );

Line 1697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1693: p_count => x_msg_count,
1694: p_data => x_msg_data
1695: );
1696: RETURN -1;
1697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: FND_MSG_PUB.Count_And_Get (
1700: p_count => x_msg_count,
1701: p_data => x_msg_data

Line 1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1694: p_data => x_msg_data
1695: );
1696: RETURN -1;
1697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: FND_MSG_PUB.Count_And_Get (
1700: p_count => x_msg_count,
1701: p_data => x_msg_data
1702: );

Line 1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1701: p_data => x_msg_data
1702: );
1703: RETURN -1;
1704: WHEN OTHERS THEN
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1707: FND_MSG_PUB.Add_Exc_Msg (
1708: G_PKG_NAME,
1709: l_api_name

Line 1746: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1742: ***************************************************************************************/
1743: FUNCTION is_batch_cost_frozen
1744: (
1745: p_api_version IN NUMBER
1746: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1747: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1748: , x_return_status OUT NOCOPY VARCHAR2
1749: , x_msg_count OUT NOCOPY NUMBER
1750: , x_msg_data OUT NOCOPY VARCHAR2

Line 1747: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1743: FUNCTION is_batch_cost_frozen
1744: (
1745: p_api_version IN NUMBER
1746: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1747: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1748: , x_return_status OUT NOCOPY VARCHAR2
1749: , x_msg_count OUT NOCOPY NUMBER
1750: , x_msg_data OUT NOCOPY VARCHAR2
1751: , p_batch_id IN gme_batch_header.batch_id%TYPE

Line 1791: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1787:
1788: /*************************************************************
1789: * Initialize message list if p_init_msg_list is set to TRUE. *
1790: *************************************************************/
1791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1792:
1793: FND_MSG_PUB.initialize;
1794:
1795: END IF;

Line 1800: IF NOT FND_API.Compatible_API_Call

1796:
1797: /*************************************************
1798: * Standard call to check for call compatibility. *
1799: *************************************************/
1800: IF NOT FND_API.Compatible_API_Call
1801: (
1802: l_api_version,
1803: p_api_version,
1804: l_api_name,

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1804: l_api_name,
1805: G_PKG_NAME
1806: ) THEN
1807:
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809:
1810: END IF;
1811:
1812: /******************************************

Line 1815: x_return_status := FND_API.G_RET_STS_SUCCESS;

1811:
1812: /******************************************
1813: * Initialize API return status to success *
1814: ******************************************/
1815: x_return_status := FND_API.G_RET_STS_SUCCESS;
1816: x_msg_count := 0;
1817: x_msg_data := NULL;
1818:
1819: OPEN c_get_period_info( p_batch_id);

Line 1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1820: FETCH c_get_period_info INTO l_cnt_frozen_matls;
1821: IF c_get_period_info%NOTFOUND THEN
1822:
1823: CLOSE c_get_period_info;
1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825:
1826: END IF;
1827: CLOSE c_get_period_info;
1828:

Line 1839: IF FND_API.to_Boolean( p_commit ) THEN

1835: );
1836: /*************************************************************
1837: * Initialize message list if p_init_msg_list is set to TRUE. *
1838: *************************************************************/
1839: IF FND_API.to_Boolean( p_commit ) THEN
1840: COMMIT;
1841: END IF;
1842:
1843: IF nvl(l_cnt_frozen_matls,0) > 0 THEN

Line 1850: WHEN FND_API.G_EXC_ERROR THEN

1846: RETURN FALSE;
1847: END IF;
1848:
1849: EXCEPTION
1850: WHEN FND_API.G_EXC_ERROR THEN
1851: x_return_status := FND_API.G_RET_STS_ERROR ;
1852: FND_MSG_PUB.Count_And_Get (
1853: p_count => x_msg_count,
1854: p_data => x_msg_data

Line 1851: x_return_status := FND_API.G_RET_STS_ERROR ;

1847: END IF;
1848:
1849: EXCEPTION
1850: WHEN FND_API.G_EXC_ERROR THEN
1851: x_return_status := FND_API.G_RET_STS_ERROR ;
1852: FND_MSG_PUB.Count_And_Get (
1853: p_count => x_msg_count,
1854: p_data => x_msg_data
1855: );

Line 1857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1853: p_count => x_msg_count,
1854: p_data => x_msg_data
1855: );
1856: RETURN NULL;
1857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1859: FND_MSG_PUB.Count_And_Get (
1860: p_count => x_msg_count,
1861: p_data => x_msg_data

Line 1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1854: p_data => x_msg_data
1855: );
1856: RETURN NULL;
1857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1859: FND_MSG_PUB.Count_And_Get (
1860: p_count => x_msg_count,
1861: p_data => x_msg_data
1862: );

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1861: p_data => x_msg_data
1862: );
1863: RETURN NULL;
1864: WHEN OTHERS THEN
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1867: FND_MSG_PUB.Add_Exc_Msg (
1868: G_PKG_NAME,
1869: l_api_name

Line 1961: l_return_status := FND_API.G_RET_STS_SUCCESS;

1957: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1958:
1959: BEGIN
1960:
1961: l_return_status := FND_API.G_RET_STS_SUCCESS;
1962: l_transfer_type := 'INTORG';
1963:
1964: IF (p_src_process_enabled_flag <> p_dest_process_enabled_flag)
1965: THEN

Line 2024: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR

2020: , x_incr_transfer_price => x_incr_transfer_price /* not used */
2021: , x_incr_currency_code => x_incr_currency_code /* not used */
2022: );
2023:
2024: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR
2025: x_unit_price IS NULL
2026: THEN
2027: x_unit_price := 0;
2028: x_return_status := -1; -- since pld cannot read db package variables

Line 2043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2039: , x_unit_price => x_unit_price
2040: , x_return_status => l_return_status
2041: );
2042:
2043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2044: THEN
2045: x_unit_price := 0;
2046: x_return_status := -2; -- since pld cannot read db package variables
2047: END IF;

Line 2050: IF l_return_status = FND_API.G_RET_STS_SUCCESS

2046: x_return_status := -2; -- since pld cannot read db package variables
2047: END IF;
2048:
2049:
2050: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2051: THEN
2052: ------------------------------------------------------------
2053: -- If the trans UOM and the item's primary UOM are same then
2054: -- the unit price is same else we need to calculate (derive)

Line 2097: END IF; -- IF x_return_status = FND_API.G_RET_STS_SUCCESS

2093: END IF;
2094:
2095: END IF; -- IF l_primary_uom <> p_trans_uom
2096:
2097: END IF; -- IF x_return_status = FND_API.G_RET_STS_SUCCESS
2098:
2099: END IF; -- ELSIF p_src_process_enabled_flag = 'Y' AND p_dest_process_enabled_flag = 'Y'
2100:
2101: x_return_status := 0;

Line 2154: l_return_status := FND_API.G_RET_STS_SUCCESS;

2150: x_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
2151:
2152: BEGIN
2153:
2154: l_return_status := FND_API.G_RET_STS_SUCCESS;
2155:
2156: l_ret_val := GMF_CMCOMMON.Get_Process_Item_Cost (
2157: 1.0
2158: , fnd_api.g_true

Line 2158: , fnd_api.g_true

2154: l_return_status := FND_API.G_RET_STS_SUCCESS;
2155:
2156: l_ret_val := GMF_CMCOMMON.Get_Process_Item_Cost (
2157: 1.0
2158: , fnd_api.g_true
2159: , l_return_status
2160: , x_msg_count
2161: , x_msg_data
2162: , p_inventory_item_id

Line 2173: IF l_ret_val <> 1 OR l_return_status <> FND_API.G_RET_STS_SUCCESS

2169: , x_unit_price
2170: , x_no_of_rows
2171: );
2172:
2173: IF l_ret_val <> 1 OR l_return_status <> FND_API.G_RET_STS_SUCCESS
2174: THEN
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: END IF;
2177:

Line 2175: x_return_status := FND_API.G_RET_STS_ERROR;

2171: );
2172:
2173: IF l_ret_val <> 1 OR l_return_status <> FND_API.G_RET_STS_SUCCESS
2174: THEN
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: END IF;
2177:
2178: x_return_status := FND_API.G_RET_STS_SUCCESS;
2179: x_unit_price := 1;

Line 2178: x_return_status := FND_API.G_RET_STS_SUCCESS;

2174: THEN
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: END IF;
2177:
2178: x_return_status := FND_API.G_RET_STS_SUCCESS;
2179: x_unit_price := 1;
2180:
2181: END get_process_item_unit_price;
2182:

Line 2233: l_return_status := FND_API.G_RET_STS_SUCCESS;

2229:
2230: /******************************************
2231: * Initialize API return status to success *
2232: ******************************************/
2233: l_return_status := FND_API.G_RET_STS_SUCCESS;
2234: l_msg_count := 0;
2235: l_msg_data := NULL;
2236:
2237: IF (l_debug_flag > 0) THEN

Line 2251: , p_init_msg_list => FND_API.G_TRUE

2247:
2248: l_ret_val := Get_Process_Item_Cost
2249: (
2250: p_api_version => l_api_version
2251: , p_init_msg_list => FND_API.G_TRUE
2252: , x_return_status => l_return_status
2253: , x_msg_count => l_msg_count
2254: , x_msg_data => l_msg_data
2255: , p_inventory_item_id => p_inventory_item_id

Line 2280: WHEN FND_API.G_EXC_ERROR THEN

2276:
2277: RETURN (nvl(l_total_cost,0));
2278:
2279: EXCEPTION
2280: WHEN FND_API.G_EXC_ERROR THEN
2281: l_return_status := FND_API.G_RET_STS_ERROR ;
2282: FND_MSG_PUB.Count_And_Get (
2283: p_count => l_msg_count,
2284: p_data => l_msg_data

Line 2281: l_return_status := FND_API.G_RET_STS_ERROR ;

2277: RETURN (nvl(l_total_cost,0));
2278:
2279: EXCEPTION
2280: WHEN FND_API.G_EXC_ERROR THEN
2281: l_return_status := FND_API.G_RET_STS_ERROR ;
2282: FND_MSG_PUB.Count_And_Get (
2283: p_count => l_msg_count,
2284: p_data => l_msg_data
2285: );

Line 2287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2283: p_count => l_msg_count,
2284: p_data => l_msg_data
2285: );
2286: RETURN 0;
2287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2288: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289: FND_MSG_PUB.Count_And_Get (
2290: p_count => l_msg_count,
2291: p_data => l_msg_data

Line 2288: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2284: p_data => l_msg_data
2285: );
2286: RETURN 0;
2287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2288: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289: FND_MSG_PUB.Count_And_Get (
2290: p_count => l_msg_count,
2291: p_data => l_msg_data
2292: );

Line 2295: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2291: p_data => l_msg_data
2292: );
2293: RETURN 0;
2294: WHEN OTHERS THEN
2295: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2297: FND_MSG_PUB.Add_Exc_Msg (
2298: G_PKG_NAME,
2299: l_api_name

Line 2363: l_return_status := FND_API.G_RET_STS_SUCCESS;

2359:
2360: /******************************************
2361: * Initialize API return status to success *
2362: ******************************************/
2363: l_return_status := FND_API.G_RET_STS_SUCCESS;
2364: l_msg_count := 0;
2365: l_msg_data := NULL;
2366:
2367: IF (l_debug_flag > 0) THEN

Line 2383: , p_init_msg_list => FND_API.G_TRUE

2379:
2380: l_ret_val := Get_Process_Item_Cost
2381: (
2382: p_api_version => l_api_version
2383: , p_init_msg_list => FND_API.G_TRUE
2384: , x_return_status => l_return_status
2385: , x_msg_count => l_msg_count
2386: , x_msg_data => l_msg_data
2387: , p_inventory_item_id => p_inventory_item_id

Line 2415: WHEN FND_API.G_EXC_ERROR THEN

2411:
2412: RETURN (nvl(l_total_cost,0));
2413:
2414: EXCEPTION
2415: WHEN FND_API.G_EXC_ERROR THEN
2416: l_return_status := FND_API.G_RET_STS_ERROR ;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => l_msg_count,
2419: p_data => l_msg_data

Line 2416: l_return_status := FND_API.G_RET_STS_ERROR ;

2412: RETURN (nvl(l_total_cost,0));
2413:
2414: EXCEPTION
2415: WHEN FND_API.G_EXC_ERROR THEN
2416: l_return_status := FND_API.G_RET_STS_ERROR ;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => l_msg_count,
2419: p_data => l_msg_data
2420: );

Line 2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2418: p_count => l_msg_count,
2419: p_data => l_msg_data
2420: );
2421: RETURN 0;
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2424: FND_MSG_PUB.Count_And_Get (
2425: p_count => l_msg_count,
2426: p_data => l_msg_data

Line 2423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2419: p_data => l_msg_data
2420: );
2421: RETURN 0;
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2424: FND_MSG_PUB.Count_And_Get (
2425: p_count => l_msg_count,
2426: p_data => l_msg_data
2427: );

Line 2430: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2426: p_data => l_msg_data
2427: );
2428: RETURN 0;
2429: WHEN OTHERS THEN
2430: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2432: FND_MSG_PUB.Add_Exc_Msg (
2433: G_PKG_NAME,
2434: l_api_name