[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: --
1592: pragma EXCEPTION_INIT(no_message, -25228);
1593:
1594: BEGIN
1595:
1596: -- Standard Start of API savepoint
1597:
1598: SAVEPOINT GET_NOTICE_PVT;
1599:
1600: -- Standard call to check for call compatibility.
1596: -- Standard Start of API savepoint
1597:
1598: SAVEPOINT GET_NOTICE_PVT;
1599:
1600: -- Standard call to check for call compatibility.
1601:
1602: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1603: p_api_version ,
1604: l_api_name ,
1825: x_old_Lot_Serial_tbl := l_old_Lot_Serial_tbl;
1826: x_Action_Request_tbl := l_Action_Request_tbl;
1827:
1828:
1829: -- Standard check of p_commit.
1830:
1831: IF FND_API.To_Boolean( p_commit ) THEN
1832: COMMIT WORK;
1833: END IF;
1831: IF FND_API.To_Boolean( p_commit ) THEN
1832: COMMIT WORK;
1833: END IF;
1834:
1835: -- Standard call to get message count and if count is 1, get message info.
1836:
1837: FND_MSG_PUB.Count_And_Get
1838: (p_count => x_msg_count ,
1839: p_data => x_msg_data