DBA Data[Home] [Help]

APPS.ASO_ORDER_FEEDBACK_GET_PVT dependencies on FND_API

Line 905: x_line_tbl(i).semi_processed_flag := FND_API.To_Boolean(p_line_varray(i).semi_processed_flag);

901: x_line_tbl(i).model_remnant_flag := p_line_varray(i).model_remnant_flag;
902: x_line_tbl(i).flow_status_code := p_line_varray(i).flow_status_code;
903: x_line_tbl(i).fulfilled_flag := p_line_varray(i).fulfilled_flag;
904: x_line_tbl(i).fulfillment_method_code := p_line_varray(i).fulfillment_method_code;
905: x_line_tbl(i).semi_processed_flag := FND_API.To_Boolean(p_line_varray(i).semi_processed_flag);
906:
907: i := p_line_varray.NEXT(i);
908:
909: END LOOP;

Line 1455: -- Default = FND_API.G_FALSE

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
1457: -- Default = FND_API.G_FALSE
1458: --
1459: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 1457: -- Default = FND_API.G_FALSE

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
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

Line 1516: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1512:
1513: PROCEDURE GET_NOTICE
1514: (
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1517: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1518: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1519: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1520: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1517: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1513: PROCEDURE GET_NOTICE
1514: (
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1517: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1518: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1519: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1520: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1521: p_app_short_name IN VARCHAR2,

Line 1602: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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 ,
1605: G_PKG_NAME ) THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1602: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1603: p_api_version ,
1604: l_api_name ,
1605: G_PKG_NAME ) THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;
1608:
1609: -- Initialize message list if p_init_msg_list is set to TRUE.
1610:

Line 1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1607: END IF;
1608:
1609: -- Initialize message list if p_init_msg_list is set to TRUE.
1610:
1611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1612: FND_MSG_PUB.initialize;
1613: END IF;
1614:
1615: -- Initialize API return status to success

Line 1617: x_return_status := FND_API.G_RET_STS_SUCCESS;

1613: END IF;
1614:
1615: -- Initialize API return status to success
1616:
1617: x_return_status := FND_API.G_RET_STS_SUCCESS;
1618:
1619: -- Initialize output no_more_messages to FND_API.G_FALSE;
1620:
1621: x_no_more_messages := FND_API.G_FALSE;

Line 1619: -- Initialize output no_more_messages to FND_API.G_FALSE;

1615: -- Initialize API return status to success
1616:
1617: x_return_status := FND_API.G_RET_STS_SUCCESS;
1618:
1619: -- Initialize output no_more_messages to FND_API.G_FALSE;
1620:
1621: x_no_more_messages := FND_API.G_FALSE;
1622:
1623: -- GET_NOTICE API specific input parameter validation logic

Line 1621: x_no_more_messages := FND_API.G_FALSE;

1617: x_return_status := FND_API.G_RET_STS_SUCCESS;
1618:
1619: -- Initialize output no_more_messages to FND_API.G_FALSE;
1620:
1621: x_no_more_messages := FND_API.G_FALSE;
1622:
1623: -- GET_NOTICE API specific input parameter validation logic
1624:
1625: -- API Body

Line 1831: IF FND_API.To_Boolean( p_commit ) THEN

1827:
1828:
1829: -- Standard check of p_commit.
1830:
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.

Line 1844: WHEN FND_API.G_EXC_ERROR THEN

1840: );
1841:
1842: EXCEPTION
1843:
1844: WHEN FND_API.G_EXC_ERROR THEN
1845: ROLLBACK TO GET_NOTICE_PVT;
1846: x_return_status := FND_API.G_RET_STS_ERROR ;
1847: FND_MSG_PUB.Count_And_Get
1848: (p_count => x_msg_count ,

Line 1846: x_return_status := FND_API.G_RET_STS_ERROR ;

1842: EXCEPTION
1843:
1844: WHEN FND_API.G_EXC_ERROR THEN
1845: ROLLBACK TO GET_NOTICE_PVT;
1846: x_return_status := FND_API.G_RET_STS_ERROR ;
1847: FND_MSG_PUB.Count_And_Get
1848: (p_count => x_msg_count ,
1849: p_data => x_msg_data
1850: );

Line 1851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1847: FND_MSG_PUB.Count_And_Get
1848: (p_count => x_msg_count ,
1849: p_data => x_msg_data
1850: );
1851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1852: ROLLBACK TO GET_NOTICE_PVT;
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854: FND_MSG_PUB.Count_And_Get
1855: (p_count => x_msg_count ,

Line 1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1849: p_data => x_msg_data
1850: );
1851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1852: ROLLBACK TO GET_NOTICE_PVT;
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854: FND_MSG_PUB.Count_And_Get
1855: (p_count => x_msg_count ,
1856: p_data => x_msg_data
1857: );

Line 1860: x_no_more_messages := FND_API.G_TRUE;

1856: p_data => x_msg_data
1857: );
1858: WHEN no_message then
1859: -- dbms_output.put_line('No more messages');
1860: x_no_more_messages := FND_API.G_TRUE;
1861: WHEN OTHERS THEN
1862: ROLLBACK TO GET_NOTICE_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1859: -- dbms_output.put_line('No more messages');
1860: x_no_more_messages := FND_API.G_TRUE;
1861: WHEN OTHERS THEN
1862: ROLLBACK TO GET_NOTICE_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1866: END IF;
1867: FND_MSG_PUB.Count_And_Get