[Home] [Help]
1448: -- to get the data regarding changes (inserts/updates/deletes) to the
1449: -- Order Entities communicated by the Order Management application.
1450: -- Pre-reqs : None.
1451: --
1452: -- Standard IN Parameters:
1453: -- p_api_version IN NUMBER Required
1454: -- p_init_msg_list IN VARCHAR2 Optional
1455: -- Default = FND_API.G_FALSE
1456: -- p_commit IN VARCHAR2 Optional
1455: -- Default = FND_API.G_FALSE
1456: -- p_commit IN VARCHAR2 Optional
1457: -- Default = FND_API.G_FALSE
1458: --
1459: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1460: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1461: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1462: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
1463: --
1591: pragma EXCEPTION_INIT(no_message, -25228);
1592:
1593: BEGIN
1594:
1595: -- Standard Start of API savepoint
1596:
1597: SAVEPOINT GET_NOTICE_PVT;
1598:
1599: -- Standard call to check for call compatibility.
1595: -- Standard Start of API savepoint
1596:
1597: SAVEPOINT GET_NOTICE_PVT;
1598:
1599: -- Standard call to check for call compatibility.
1600:
1601: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1602: p_api_version ,
1603: l_api_name ,
1819: x_old_Lot_Serial_tbl := l_old_Lot_Serial_tbl;
1820: x_Action_Request_tbl := l_Action_Request_tbl;
1821:
1822:
1823: -- Standard check of p_commit.
1824:
1825: IF FND_API.To_Boolean( p_commit ) THEN
1826: COMMIT WORK;
1827: END IF;
1825: IF FND_API.To_Boolean( p_commit ) THEN
1826: COMMIT WORK;
1827: END IF;
1828:
1829: -- Standard call to get message count and if count is 1, get message info.
1830:
1831: FND_MSG_PUB.Count_And_Get
1832: (p_count => x_msg_count ,
1833: p_data => x_msg_data