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 1601: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1610: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1616: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1620: x_no_more_messages := FND_API.G_FALSE;

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

Line 1825: IF FND_API.To_Boolean( p_commit ) THEN

1821:
1822:
1823: -- Standard check of p_commit.
1824:
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.

Line 1838: WHEN FND_API.G_EXC_ERROR THEN

1834: );
1835:
1836: EXCEPTION
1837:
1838: WHEN FND_API.G_EXC_ERROR THEN
1839: ROLLBACK TO GET_NOTICE_PVT;
1840: x_return_status := FND_API.G_RET_STS_ERROR ;
1841: FND_MSG_PUB.Count_And_Get
1842: (p_count => x_msg_count ,

Line 1840: x_return_status := FND_API.G_RET_STS_ERROR ;

1836: EXCEPTION
1837:
1838: WHEN FND_API.G_EXC_ERROR THEN
1839: ROLLBACK TO GET_NOTICE_PVT;
1840: x_return_status := FND_API.G_RET_STS_ERROR ;
1841: FND_MSG_PUB.Count_And_Get
1842: (p_count => x_msg_count ,
1843: p_data => x_msg_data
1844: );

Line 1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1854: x_no_more_messages := FND_API.G_TRUE;

1850: p_data => x_msg_data
1851: );
1852: WHEN no_message then
1853: -- dbms_output.put_line('No more messages');
1854: x_no_more_messages := FND_API.G_TRUE;
1855: WHEN OTHERS THEN
1856: ROLLBACK TO GET_NOTICE_PVT;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1853: -- dbms_output.put_line('No more messages');
1854: x_no_more_messages := FND_API.G_TRUE;
1855: WHEN OTHERS THEN
1856: ROLLBACK TO GET_NOTICE_PVT;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1859: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1860: END IF;
1861: FND_MSG_PUB.Count_And_Get