DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on FND_API

Line 1566: WHEN FND_API.G_EXC_ERROR Then

1562: End If;
1563: Dbms_Output.Put_Line('+--------------------------------------------------------------+'); */
1564:
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR Then
1567: x_return_status := OKC_API.G_RET_STS_ERROR;
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then
1569: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1570: WHEN OTHERS Then

Line 1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then

1564:
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR Then
1567: x_return_status := OKC_API.G_RET_STS_ERROR;
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then
1569: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1570: WHEN OTHERS Then
1571: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1572: -- Dbms_Output.Put_Line('Error is '|| sqlerrm);

Line 1707: p_encoded => FND_API.G_FALSE);

1703: FND_MSG_PUB.Add;
1704: End If;
1705: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1706: p_data => x_msg_data,
1707: p_encoded => FND_API.G_FALSE);
1708: When G_REQUIRED_ATTR_FAILED Then
1709: x_return_status := OKC_API.G_RET_STS_ERROR;
1710: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) Then
1711: FND_MESSAGE.SET_NAME('OKC','OKC_ITEM_UOM_QTY_NUMM');

Line 1716: p_encoded => FND_API.G_FALSE);

1712: FND_MSG_PUB.Add;
1713: End If;
1714: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1715: p_data => x_msg_data,
1716: p_encoded => FND_API.G_FALSE);
1717: When G_CALL_QP_FAILED Then
1718: x_return_status := OKC_API.G_RET_STS_ERROR;
1719: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) Then
1720: FND_MESSAGE.SET_NAME('OKC','OKC_QP_FAILED');

Line 1725: p_encoded => FND_API.G_FALSE);

1721: FND_MSG_PUB.Add;
1722: End If;
1723: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1724: p_data => x_msg_data,
1725: p_encoded => FND_API.G_FALSE);
1726:
1727: When G_EXCEPTION_HALT_VALIDATION Then
1728: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1729: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN,

Line 1731: When FND_API.G_EXC_ERROR Then

1727: When G_EXCEPTION_HALT_VALIDATION Then
1728: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1729: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN,
1730: SQLCODE, G_SQLERRM_TOKEN,SQLERRM);
1731: When FND_API.G_EXC_ERROR Then
1732: x_return_status := OKC_API.G_RET_STS_ERROR;
1733: When FND_API.G_EXC_UNEXPECTED_ERROR Then
1734: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1735: When OTHERS Then

Line 1733: When FND_API.G_EXC_UNEXPECTED_ERROR Then

1729: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN,
1730: SQLCODE, G_SQLERRM_TOKEN,SQLERRM);
1731: When FND_API.G_EXC_ERROR Then
1732: x_return_status := OKC_API.G_RET_STS_ERROR;
1733: When FND_API.G_EXC_UNEXPECTED_ERROR Then
1734: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1735: When OTHERS Then
1736: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1737: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN,

Line 2055: p_encoded => FND_API.G_FALSE);

2051:
2052: FND_MSG_PUB.COUNT_AND_GET(
2053: p_count => x_msg_count,
2054: p_data => x_msg_data,
2055: p_encoded => FND_API.G_FALSE);
2056:
2057: WHEN G_REQUIRED_ATTR_FAILED Then
2058: x_return_status := OKC_API.G_RET_STS_ERROR;
2059: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2068: p_encoded => FND_API.G_FALSE);

2064:
2065: FND_MSG_PUB.COUNT_AND_GET(
2066: p_count => x_msg_count,
2067: p_data => x_msg_data,
2068: p_encoded => FND_API.G_FALSE);
2069:
2070: WHEN G_CALL_QP_FAILED Then
2071: x_return_status := OKC_API.G_RET_STS_ERROR;
2072: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2081: p_encoded => FND_API.G_FALSE);

2077:
2078: FND_MSG_PUB.COUNT_AND_GET(
2079: p_count => x_msg_count,
2080: p_data => x_msg_data,
2081: p_encoded => FND_API.G_FALSE);
2082:
2083: WHEN G_EXCEPTION_HALT_VALIDATION Then
2084: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN,SQLERRM);

Line 2086: WHEN FND_API.G_EXC_ERROR Then

2082:
2083: WHEN G_EXCEPTION_HALT_VALIDATION Then
2084: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN,SQLERRM);
2086: WHEN FND_API.G_EXC_ERROR Then
2087: x_return_status := OKC_API.G_RET_STS_ERROR;
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then
2089: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2090: WHEN OTHERS Then

Line 2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then

2084: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN,SQLERRM);
2086: WHEN FND_API.G_EXC_ERROR Then
2087: x_return_status := OKC_API.G_RET_STS_ERROR;
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR Then
2089: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2090: WHEN OTHERS Then
2091: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2092: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);