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 453: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 684: IF FND_API.to_Boolean( p_init_msg_list ) THEN

680:
681: /*************************************************************
682: * Initialize message list if p_init_msg_list is set to TRUE. *
683: *************************************************************/
684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: /*************************************************

Line 692: IF NOT FND_API.Compatible_API_Call

688: /*************************************************
689: * Standard call to check for call compatibility. *
690: *************************************************/
691:
692: IF NOT FND_API.Compatible_API_Call
693: (
694: l_api_version,
695: p_api_version,
696: l_api_name,

Line 699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

695: p_api_version,
696: l_api_name,
697: G_PKG_NAME
698: ) THEN
699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
700: END IF;
701:
702: /******************************************
703: * Initialize API return status to success *

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

701:
702: /******************************************
703: * Initialize API return status to success *
704: ******************************************/
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706: x_msg_count := 0;
707: x_msg_data := NULL;
708:
709: IF (l_debug_flag > 0) THEN

Line 1028: WHEN FND_API.G_EXC_ERROR THEN

1024: p_count => x_msg_count,
1025: p_data => x_msg_data
1026: );
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: x_return_status := FND_API.G_RET_STS_ERROR ;
1030: FND_MSG_PUB.Count_And_Get (
1031: p_count => x_msg_count,
1032: p_data => x_msg_data

Line 1029: x_return_status := FND_API.G_RET_STS_ERROR ;

1025: p_data => x_msg_data
1026: );
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: x_return_status := FND_API.G_RET_STS_ERROR ;
1030: FND_MSG_PUB.Count_And_Get (
1031: p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );

Line 1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1031: p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );
1034: RETURN -1;
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: FND_MSG_PUB.Count_And_Get (
1038: p_count => x_msg_count,
1039: p_data => x_msg_data

Line 1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1032: p_data => x_msg_data
1033: );
1034: RETURN -1;
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: FND_MSG_PUB.Count_And_Get (
1038: p_count => x_msg_count,
1039: p_data => x_msg_data
1040: );

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1039: p_data => x_msg_data
1040: );
1041: RETURN -1;
1042: WHEN OTHERS THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1045: FND_MSG_PUB.Add_Exc_Msg (
1046: G_PKG_NAME,
1047: l_api_name

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

1104: ***********************************************************************************************/
1105: FUNCTION Get_Process_Item_Cost
1106: (
1107: p_api_version IN NUMBER
1108: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1109: , x_return_status OUT NOCOPY VARCHAR2
1110: , x_msg_count OUT NOCOPY NUMBER
1111: , x_msg_data OUT NOCOPY VARCHAR2
1112: , p_inventory_item_id IN NUMBER /* Item_Id */

Line 1269: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1265:
1266: /*************************************************************
1267: * Initialize message list if p_init_msg_list is set to TRUE. *
1268: *************************************************************/
1269: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:
1273: /*************************************************

Line 1276: IF NOT FND_API.Compatible_API_Call (

1272:
1273: /*************************************************
1274: * Standard call to check for call compatibility. *
1275: *************************************************/
1276: IF NOT FND_API.Compatible_API_Call (
1277: l_api_version,
1278: p_api_version,
1279: l_api_name,
1280: G_PKG_NAME

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278: p_api_version,
1279: l_api_name,
1280: G_PKG_NAME
1281: ) THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: /******************************************
1286: * Initialize API return status to success *

Line 1288: x_return_status := FND_API.G_RET_STS_SUCCESS;

1284:
1285: /******************************************
1286: * Initialize API return status to success *
1287: ******************************************/
1288: x_return_status := FND_API.G_RET_STS_SUCCESS;
1289: x_msg_count := 0;
1290: x_msg_data := NULL;
1291:
1292: IF (p_inventory_item_id IS NULL OR p_organization_id IS NULL OR p_transaction_date IS NULL) THEN

Line 1512: WHEN FND_API.G_EXC_ERROR THEN

1508: x_no_of_rows := 0;
1509: x_total_cost := 0;
1510: p_no_of_rows := 0;
1511: RETURN(-1);
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: FND_MSG_PUB.Count_And_Get (
1515: p_count => x_msg_count,
1516: p_data => x_msg_data

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR ;

1509: x_total_cost := 0;
1510: p_no_of_rows := 0;
1511: RETURN(-1);
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: FND_MSG_PUB.Count_And_Get (
1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );

Line 1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: RETURN -1;
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1521: FND_MSG_PUB.Count_And_Get (
1522: p_count => x_msg_count,
1523: p_data => x_msg_data

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1516: p_data => x_msg_data
1517: );
1518: RETURN -1;
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1521: FND_MSG_PUB.Count_And_Get (
1522: p_count => x_msg_count,
1523: p_data => x_msg_data
1524: );

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1523: p_data => x_msg_data
1524: );
1525: RETURN -1;
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1529: FND_MSG_PUB.Add_Exc_Msg (
1530: G_PKG_NAME,
1531: l_api_name

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

1564: ***************************************************************************************/
1565: FUNCTION is_batch_cost_frozen
1566: (
1567: p_api_version IN NUMBER
1568: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1569: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1570: , x_return_status OUT NOCOPY VARCHAR2
1571: , x_msg_count OUT NOCOPY NUMBER
1572: , x_msg_data OUT NOCOPY VARCHAR2

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

1565: FUNCTION is_batch_cost_frozen
1566: (
1567: p_api_version IN NUMBER
1568: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1569: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1570: , x_return_status OUT NOCOPY VARCHAR2
1571: , x_msg_count OUT NOCOPY NUMBER
1572: , x_msg_data OUT NOCOPY VARCHAR2
1573: , p_batch_id IN gme_batch_header.batch_id%TYPE

Line 1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1609:
1610: /*************************************************************
1611: * Initialize message list if p_init_msg_list is set to TRUE. *
1612: *************************************************************/
1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1614:
1615: FND_MSG_PUB.initialize;
1616:
1617: END IF;

Line 1622: IF NOT FND_API.Compatible_API_Call

1618:
1619: /*************************************************
1620: * Standard call to check for call compatibility. *
1621: *************************************************/
1622: IF NOT FND_API.Compatible_API_Call
1623: (
1624: l_api_version,
1625: p_api_version,
1626: l_api_name,

Line 1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1626: l_api_name,
1627: G_PKG_NAME
1628: ) THEN
1629:
1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631:
1632: END IF;
1633:
1634: /******************************************

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

1633:
1634: /******************************************
1635: * Initialize API return status to success *
1636: ******************************************/
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638: x_msg_count := 0;
1639: x_msg_data := NULL;
1640:
1641: OPEN c_get_period_info( p_batch_id);

Line 1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1642: FETCH c_get_period_info INTO l_cnt_frozen_matls;
1643: IF c_get_period_info%NOTFOUND THEN
1644:
1645: CLOSE c_get_period_info;
1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647:
1648: END IF;
1649: CLOSE c_get_period_info;
1650:

Line 1661: IF FND_API.to_Boolean( p_commit ) THEN

1657: );
1658: /*************************************************************
1659: * Initialize message list if p_init_msg_list is set to TRUE. *
1660: *************************************************************/
1661: IF FND_API.to_Boolean( p_commit ) THEN
1662: COMMIT;
1663: END IF;
1664:
1665: IF nvl(l_cnt_frozen_matls,0) > 0 THEN

Line 1672: WHEN FND_API.G_EXC_ERROR THEN

1668: RETURN FALSE;
1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: x_return_status := FND_API.G_RET_STS_ERROR ;
1674: FND_MSG_PUB.Count_And_Get (
1675: p_count => x_msg_count,
1676: p_data => x_msg_data

Line 1673: x_return_status := FND_API.G_RET_STS_ERROR ;

1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: x_return_status := FND_API.G_RET_STS_ERROR ;
1674: FND_MSG_PUB.Count_And_Get (
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );

Line 1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );
1678: RETURN NULL;
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get (
1682: p_count => x_msg_count,
1683: p_data => x_msg_data

Line 1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1676: p_data => x_msg_data
1677: );
1678: RETURN NULL;
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get (
1682: p_count => x_msg_count,
1683: p_data => x_msg_data
1684: );

Line 1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1683: p_data => x_msg_data
1684: );
1685: RETURN NULL;
1686: WHEN OTHERS THEN
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1688: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1689: FND_MSG_PUB.Add_Exc_Msg (
1690: G_PKG_NAME,
1691: l_api_name

Line 1783: l_return_status := FND_API.G_RET_STS_SUCCESS;

1779: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1780:
1781: BEGIN
1782:
1783: l_return_status := FND_API.G_RET_STS_SUCCESS;
1784: l_transfer_type := 'INTORG';
1785:
1786: IF (p_src_process_enabled_flag <> p_dest_process_enabled_flag)
1787: THEN

Line 1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR

1842: , x_incr_transfer_price => x_incr_transfer_price /* not used */
1843: , x_incr_currency_code => x_incr_currency_code /* not used */
1844: );
1845:
1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR
1847: x_unit_price IS NULL
1848: THEN
1849: x_unit_price := 0;
1850: x_return_status := -1; -- since pld cannot read db package variables

Line 1865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1861: , x_unit_price => x_unit_price
1862: , x_return_status => l_return_status
1863: );
1864:
1865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1866: THEN
1867: x_unit_price := 0;
1868: x_return_status := -2; -- since pld cannot read db package variables
1869: END IF;

Line 1872: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1868: x_return_status := -2; -- since pld cannot read db package variables
1869: END IF;
1870:
1871:
1872: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1873: THEN
1874: ------------------------------------------------------------
1875: -- If the trans UOM and the item's primary UOM are same then
1876: -- the unit price is same else we need to calculate (derive)

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

1915: END IF;
1916:
1917: END IF; -- IF l_primary_uom <> p_trans_uom
1918:
1919: END IF; -- IF x_return_status = FND_API.G_RET_STS_SUCCESS
1920:
1921: END IF; -- ELSIF p_src_process_enabled_flag = 'Y' AND p_dest_process_enabled_flag = 'Y'
1922:
1923: x_return_status := 0;

Line 1976: l_return_status := FND_API.G_RET_STS_SUCCESS;

1972: x_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
1973:
1974: BEGIN
1975:
1976: l_return_status := FND_API.G_RET_STS_SUCCESS;
1977:
1978: l_ret_val := GMF_CMCOMMON.Get_Process_Item_Cost (
1979: 1.0
1980: , fnd_api.g_true

Line 1980: , fnd_api.g_true

1976: l_return_status := FND_API.G_RET_STS_SUCCESS;
1977:
1978: l_ret_val := GMF_CMCOMMON.Get_Process_Item_Cost (
1979: 1.0
1980: , fnd_api.g_true
1981: , l_return_status
1982: , x_msg_count
1983: , x_msg_data
1984: , p_inventory_item_id

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

1991: , x_unit_price
1992: , x_no_of_rows
1993: );
1994:
1995: IF l_ret_val <> 1 OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1996: THEN
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: END IF;
1999:

Line 1997: x_return_status := FND_API.G_RET_STS_ERROR;

1993: );
1994:
1995: IF l_ret_val <> 1 OR l_return_status <> FND_API.G_RET_STS_SUCCESS
1996: THEN
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: END IF;
1999:
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: x_unit_price := 1;

Line 2000: x_return_status := FND_API.G_RET_STS_SUCCESS;

1996: THEN
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: END IF;
1999:
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: x_unit_price := 1;
2002:
2003: END get_process_item_unit_price;
2004:

Line 2055: l_return_status := FND_API.G_RET_STS_SUCCESS;

2051:
2052: /******************************************
2053: * Initialize API return status to success *
2054: ******************************************/
2055: l_return_status := FND_API.G_RET_STS_SUCCESS;
2056: l_msg_count := 0;
2057: l_msg_data := NULL;
2058:
2059: IF (l_debug_flag > 0) THEN

Line 2073: , p_init_msg_list => FND_API.G_TRUE

2069:
2070: l_ret_val := Get_Process_Item_Cost
2071: (
2072: p_api_version => l_api_version
2073: , p_init_msg_list => FND_API.G_TRUE
2074: , x_return_status => l_return_status
2075: , x_msg_count => l_msg_count
2076: , x_msg_data => l_msg_data
2077: , p_inventory_item_id => p_inventory_item_id

Line 2102: WHEN FND_API.G_EXC_ERROR THEN

2098:
2099: RETURN (nvl(l_total_cost,0));
2100:
2101: EXCEPTION
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR ;
2104: FND_MSG_PUB.Count_And_Get (
2105: p_count => l_msg_count,
2106: p_data => l_msg_data

Line 2103: l_return_status := FND_API.G_RET_STS_ERROR ;

2099: RETURN (nvl(l_total_cost,0));
2100:
2101: EXCEPTION
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR ;
2104: FND_MSG_PUB.Count_And_Get (
2105: p_count => l_msg_count,
2106: p_data => l_msg_data
2107: );

Line 2109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2105: p_count => l_msg_count,
2106: p_data => l_msg_data
2107: );
2108: RETURN 0;
2109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2110: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: FND_MSG_PUB.Count_And_Get (
2112: p_count => l_msg_count,
2113: p_data => l_msg_data

Line 2110: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2106: p_data => l_msg_data
2107: );
2108: RETURN 0;
2109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2110: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: FND_MSG_PUB.Count_And_Get (
2112: p_count => l_msg_count,
2113: p_data => l_msg_data
2114: );

Line 2117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2113: p_data => l_msg_data
2114: );
2115: RETURN 0;
2116: WHEN OTHERS THEN
2117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2119: FND_MSG_PUB.Add_Exc_Msg (
2120: G_PKG_NAME,
2121: l_api_name

Line 2185: l_return_status := FND_API.G_RET_STS_SUCCESS;

2181:
2182: /******************************************
2183: * Initialize API return status to success *
2184: ******************************************/
2185: l_return_status := FND_API.G_RET_STS_SUCCESS;
2186: l_msg_count := 0;
2187: l_msg_data := NULL;
2188:
2189: IF (l_debug_flag > 0) THEN

Line 2205: , p_init_msg_list => FND_API.G_TRUE

2201:
2202: l_ret_val := Get_Process_Item_Cost
2203: (
2204: p_api_version => l_api_version
2205: , p_init_msg_list => FND_API.G_TRUE
2206: , x_return_status => l_return_status
2207: , x_msg_count => l_msg_count
2208: , x_msg_data => l_msg_data
2209: , p_inventory_item_id => p_inventory_item_id

Line 2237: WHEN FND_API.G_EXC_ERROR THEN

2233:
2234: RETURN (nvl(l_total_cost,0));
2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: l_return_status := FND_API.G_RET_STS_ERROR ;
2239: FND_MSG_PUB.Count_And_Get (
2240: p_count => l_msg_count,
2241: p_data => l_msg_data

Line 2238: l_return_status := FND_API.G_RET_STS_ERROR ;

2234: RETURN (nvl(l_total_cost,0));
2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: l_return_status := FND_API.G_RET_STS_ERROR ;
2239: FND_MSG_PUB.Count_And_Get (
2240: p_count => l_msg_count,
2241: p_data => l_msg_data
2242: );

Line 2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2240: p_count => l_msg_count,
2241: p_data => l_msg_data
2242: );
2243: RETURN 0;
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2246: FND_MSG_PUB.Count_And_Get (
2247: p_count => l_msg_count,
2248: p_data => l_msg_data

Line 2245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2241: p_data => l_msg_data
2242: );
2243: RETURN 0;
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2246: FND_MSG_PUB.Count_And_Get (
2247: p_count => l_msg_count,
2248: p_data => l_msg_data
2249: );

Line 2252: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2248: p_data => l_msg_data
2249: );
2250: RETURN 0;
2251: WHEN OTHERS THEN
2252: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2254: FND_MSG_PUB.Add_Exc_Msg (
2255: G_PKG_NAME,
2256: l_api_name