APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on FND_API

Line 752: x_error_status := FND_API.G_RET_STS_SUCCESS;

748: l_index NUMBER;
749: l_tax_lines_tbl ZX_TAX_PARTNER_PKG.tax_lines_tbl_type;
750:
751: BEGIN
752: x_error_status := FND_API.G_RET_STS_SUCCESS;
753: err_count := 0;
754: l_doc_trx_id := NULL;
755:
756: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

771: END IF;
772:
773: ZX_TAX_VERTEX_REV.GET_RELEASE(context_rec,version_rec,l_return_status);
774:
775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
776: IF (g_level_exception >= g_current_runtime_level ) THEN
777: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
778: END IF;
779: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 779: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
776: IF (g_level_exception >= g_current_runtime_level ) THEN
777: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
778: END IF;
779: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: g_string :='Not compaitable to VERTEX Release';
781: error_exception_handle(g_string);
782: x_messages_tbl:=g_messages_tbl;
783: return;

Line 791: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

787: WHEN OTHERS THEN
788: IF (g_level_exception >= g_current_runtime_level ) THEN
789: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
790: END IF;
791: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: g_string :='Not compaitable to VERTEX Release failed with exception';
793: error_exception_handle(g_string);
794: x_messages_tbl:=g_messages_tbl;
795: return;

Line 803: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
801: 'Release 12 Old tax partner integration does not support P2P products' );
802: END IF;
803: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: g_string :='Release 12 Old tax partner integration does not support P2P products';
805: error_exception_handle(g_string);
806: x_messages_tbl:=g_messages_tbl;
807: return;

Line 1276: -- x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1272: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1274: 'No item lines exist to whom tax lines need to be created' );
1275: END IF;
1276: -- x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: -- g_string :='Not compaitable to VERTEX Release';
1278: -- error_exception_handle(g_string);
1279: -- x_messages_tbl:=g_messages_tbl;
1280: return;

Line 1316: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1312:
1313: /* Performing validation of passed document level,line level actions */
1314: Perform_validate(l_return_status);
1315:
1316: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1317: IF (g_level_exception >= g_current_runtime_level ) THEN
1318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1319: END IF;
1320: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1320: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1317: IF (g_level_exception >= g_current_runtime_level ) THEN
1318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1319: END IF;
1320: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: g_string :='Header ,line level actions are incompaitable';
1322: error_exception_handle(g_string);
1323: x_messages_tbl:=g_messages_tbl;
1324: return;

Line 1343: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1339: When no_data_found then
1340: IF (g_level_exception >= g_current_runtime_level ) THEN
1341: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1342: End if;
1343: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: g_string :='No document type exist for provided event_class_mapping_id ';
1345: error_exception_handle(g_string);
1346: x_messages_tbl:=g_messages_tbl;
1347: return;

Line 1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1368: WHERE transaction_id = l_doc_trx_id;
1369:
1370: SET_DOCUMENT_TYPE(l_document_type,pg_adj_doc_trx_id_tab(I),l_doc_amount,pg_line_level_action_tab(I),l_return_status);
1371:
1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: IF (g_level_exception >= g_current_runtime_level ) THEN
1374: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1375: END IF;
1376: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1376: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: IF (g_level_exception >= g_current_runtime_level ) THEN
1374: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1375: END IF;
1376: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: g_string :='Failed in setting up document type';
1378: error_exception_handle(g_string);
1379: x_messages_tbl:=g_messages_tbl;
1380: return;

Line 1395: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1391: IF pg_doc_level_action_tab(i) not in ('CREATE', 'QUOTE', 'UPDATE') THEN
1392: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action' );
1394: END IF;
1395: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: g_string :=' Unknown header level action';
1397: error_exception_handle(g_string);
1398: x_messages_tbl:=g_messages_tbl;
1399: return;

Line 1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1419:
1420: IF l_line_action <> 'ALLOCATE_TAX_ONLY_ADJUSTMENT' THEN
1421: IF (pg_doc_level_action_tab(i) in ('CREATE', 'QUOTE')) THEN
1422: Perform_line_creation(l_tax_lines_tbl,p_currency_tab,l_return_status);
1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1424: IF (g_level_exception >= g_current_runtime_level ) THEN
1425: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1426: END IF;
1427: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1427: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1424: IF (g_level_exception >= g_current_runtime_level ) THEN
1425: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1426: END IF;
1427: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: g_string :='Failed in creating tax line';
1429: error_exception_handle(g_string);
1430: x_messages_tbl:=g_messages_tbl;
1431: return;

Line 1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1431: return;
1432: END IF;
1433: ELSIF (pg_doc_level_action_tab(i) = 'UPDATE') then
1434: Perform_update(l_tax_lines_tbl,p_currency_tab,l_return_status);
1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1436: IF (g_level_exception >= g_current_runtime_level ) THEN
1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1438: END IF;
1439: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1439: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1436: IF (g_level_exception >= g_current_runtime_level ) THEN
1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1438: END IF;
1439: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: g_string :='Failed in creating update';
1441: error_exception_handle(g_string);
1442: x_messages_tbl:=g_messages_tbl;
1443: return;

Line 1525: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: when others then
1522: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1523: FND_LOG.STRING(g_level_unexpected,G_MODULE_NAME||l_api_name,sqlerrm);
1524: END IF;
1525: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: g_string :='Not compaitable to VERTEX Release';
1527: error_exception_handle(g_string);
1528: x_messages_tbl:=g_messages_tbl;
1529: return;

Line 1539: x_return_status := FND_API.G_RET_STS_SUCCESS;

1535: p_LINE_LEVEL_ACTION IN VARCHAR2,
1536: x_return_status OUT NOCOPY VARCHAR2)IS
1537: l_api_name CONSTANT VARCHAR2(30) := 'SET_DOCUMENT_TYPE';
1538: BEGIN
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1542: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1543: END IF;

Line 1589: x_return_status := FND_API.G_RET_STS_SUCCESS;

1585: PROCEDURE PERFORM_VALIDATE(x_return_status OUT NOCOPY VARCHAR2) is
1586: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_VALIDATE';
1587:
1588: Begin
1589: x_return_status := FND_API.G_RET_STS_SUCCESS;
1590:
1591: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1593: END IF;

Line 1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1601: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'QUOTE','SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1602: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1603: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1606: end if;
1607: elsif(pg_doc_level_action_tab(i) = 'QUOTE') Then
1608: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1609: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1608: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1609: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1610: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1611: END IF;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: end if;
1614: elsif(pg_doc_level_action_tab(i) = 'UPDATE') Then
1615: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1616: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1615: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1616: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1617: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1618: END IF;
1619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: end if;
1621: else
1622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1621: else
1622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');
1624: END IF;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: end if;
1627:
1628: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 1640: x_return_status := FND_API.G_RET_STS_SUCCESS;

1636:
1637: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_CREATION';
1638: l_return_status VARCHAR2(30);
1639: Begin
1640: x_return_status := FND_API.G_RET_STS_SUCCESS;
1641:
1642: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1644: END IF;

Line 1651: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Value of Variable I is'|| I );
1648: END IF;
1649:
1650: reset_parameters(l_return_status);
1651: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1654: END IF;
1655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1651: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1654: END IF;
1655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: g_string :='Failed in RESET_PARAMETERS procedure';
1657: error_exception_handle(g_string);
1658: return;
1659: END IF;

Line 1663: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1659: END IF;
1660:
1661: l_line_level_action := 'CREATE';
1662: set_parameters(l_return_status);
1663: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1664: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1666: END IF;
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1663: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1664: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1666: END IF;
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1668: g_string :='Failed in SET_PRAMETERS procedure';
1669: error_exception_handle(g_string);
1670: return;
1671: END IF;

Line 1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1670: return;
1671: END IF;
1672:
1673: calculate_tax(l_return_status);
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1677: END IF;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1677: END IF;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: g_string :='Failed in CALCULATE_TAX Procedure ';
1680: error_exception_handle(g_string);
1681: return;
1682: END IF;

Line 1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1687: END IF;
1688:
1689: IF (pg_line_level_action_tab(i)<>'QUOTE') THEN
1690: write_to_vertex_repository(l_return_status);
1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1694: END IF;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1694: END IF;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1696: g_string :='Failed in WRITE_TO_VERTEX_REPOSITORY Procedure ';
1697: error_exception_handle(g_string);
1698: return;
1699: END IF;

Line 1704: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1700: END IF;
1701:
1702: /*Vertex returned values need to be written back to zx_repository.*/
1703: tax_results_processing(p_tax_lines_tbl,p_currency_tab,l_return_status);
1704: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1705: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1707: END IF;
1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1704: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1705: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1707: END IF;
1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1709: g_string :='Failed in TAX_RESULTS_PROCESSING procedure';
1710: error_exception_handle(g_string);
1711: return;
1712: END IF;

Line 1725: x_return_status := FND_API.G_RET_STS_SUCCESS;

1721: PROCEDURE PERFORM_LINE_DELETION(x_return_status OUT NOCOPY VARCHAR2) is
1722: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_DELETION';
1723: l_return_status VARCHAR2(30);
1724: Begin
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1729: END IF;

Line 1735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1731: ZX_VTX_USER_PKG.g_trx_line_id := pg_trx_line_id_tab(I);*/
1732:
1733: reset_parameters(l_return_status);
1734:
1735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1738: END IF;
1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1738: END IF;
1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: g_string :='Failed in RESET_PARAMETERS Procedure';
1741: error_exception_handle(g_string);
1742: return;
1743: END IF;

Line 1746: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1742: return;
1743: END IF;
1744: set_parameters(l_return_status);
1745:
1746: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1747: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1748: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1749: END IF;
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1746: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1747: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1748: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1749: END IF;
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: g_string :='Failed in SET_PARAMETERS procedure';
1752: error_exception_handle(g_string);
1753: return;
1754: END IF;

Line 1756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1752: error_exception_handle(g_string);
1753: return;
1754: END IF;
1755: calculate_tax(l_return_status);
1756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1757: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1758: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1757: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1758: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1761: g_string :='Failed in CALCULATE_TAX procedure';
1762: error_exception_handle(g_string);
1763: return;
1764: END IF;

Line 1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1762: error_exception_handle(g_string);
1763: return;
1764: END IF;
1765: write_to_vertex_repository(l_return_status);
1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1769: END IF;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1769: END IF;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: g_string :='Failed in WRITE_TO_VERTEX_REPOSITORY procedure';
1772: error_exception_handle(g_string);
1773: return;
1774: END IF;

Line 1790: x_return_status := FND_API.G_RET_STS_SUCCESS;

1786: l_return_status VARCHAR2(30);
1787: l_application_id NUMBER;
1788: l_ver_count NUMBER(10);
1789: Begin
1790: x_return_status := FND_API.G_RET_STS_SUCCESS;
1791:
1792: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1793: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1794: END IF;

Line 1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1801:
1802: l_line_level_action := 'CREATE';
1803: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1804:
1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1808: END IF;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1808: END IF;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: g_string :='Failed in PERFORM_LINE_CREATION procedure';
1811: error_exception_handle(g_string);
1812: return;
1813: END IF;

Line 1844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1840: IF l_ver_count <> 0 THEN
1841: l_line_level_action := 'NEGATE';
1842: perform_line_deletion(l_return_status);
1843:
1844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1846: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1847: END IF;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1846: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1847: END IF;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: g_string :='Failed in PERFORM_LINE_DELETION procedure';
1850: error_exception_handle(g_string);
1851: return;
1852: END IF;

Line 1858: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1854: /*For new line*/
1855: -- l_line_level_action := 'CREATE';
1856: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1857:
1858: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1859: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1858: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1859: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: g_string :='Failed in PERFORM_LINE_CREATION procedure';
1864: error_exception_handle(g_string);
1865: return;
1866: END IF;

Line 1871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1867:
1868: elsif(pg_line_level_action_tab(i) in ('DELETE','CANCEL')) Then
1869: l_line_level_action := pg_line_level_action_tab(i);
1870: perform_line_deletion(l_return_status);
1871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1872: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1873: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1874: END IF;
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1872: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1873: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1874: END IF;
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1876: g_string :='Failed in PERFORM_LINE_DELETION procedure';
1877: error_exception_handle(g_string);
1878: return;
1879: END IF;

Line 1904: x_return_status := FND_API.G_RET_STS_SUCCESS;

1900: x_jurisdictions_found VARCHAR2(20);
1901: l_return_status VARCHAR2(30);
1902:
1903: BEGIN
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905:
1906: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1907: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1908: END IF;

Line 1920: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1916: x_tax_jurisdiction_rec ,
1917: x_jurisdictions_found ,
1918: x_return_status
1919: );
1920: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1921: IF (g_level_exception >= g_current_runtime_level ) THEN
1922: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1923: END IF;
1924: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1924: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1920: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1921: IF (g_level_exception >= g_current_runtime_level ) THEN
1922: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1923: END IF;
1924: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: g_string :='Not able to find Jurisdiction';
1926: error_exception_handle(g_string);
1927: RETURN;
1928: END IF;

Line 2121: x_return_status := FND_API.G_RET_STS_SUCCESS;

2117:
2118: l_location_info_rec location_info_rec_type;
2119: l_api_name CONSTANT VARCHAR2(30) := 'SET_PARAMETERS';
2120: BEGIN
2121: x_return_status := FND_API.G_RET_STS_SUCCESS;
2122:
2123: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2124: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2125: END IF;

Line 3040: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3036: EXCEPTION
3037: WHEN OTHERS THEN
3038: IF (g_level_exception >= g_current_runtime_level ) THEN
3039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3040: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3041: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3042: error_exception_handle(g_string);
3043: --return;
3044:

Line 3065: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3061: IF (g_level_exception >= g_current_runtime_level ) THEN
3062: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3063: END IF;
3064: IF (SQLCODE > -20500) OR (SQLCODE < -20599) THEN
3065: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3067: error_exception_handle(g_string);
3068: --return;
3069: END IF;

Line 3137: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3133: IF (g_level_exception >= g_current_runtime_level ) THEN
3134: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3135: END IF;
3136: IF (SQLCODE > -20500) OR (SQLCODE < -20599) THEN
3137: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3139: error_exception_handle(g_string);
3140:
3141: END IF;

Line 3174: x_return_status := FND_API.G_RET_STS_SUCCESS;

3170:
3171: PROCEDURE CALCULATE_TAX(x_return_status OUT NOCOPY VARCHAR2) IS
3172: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TAX';
3173: BEGIN
3174: x_return_status := FND_API.G_RET_STS_SUCCESS;
3175:
3176: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3177: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3178: END IF;

Line 3204: RAISE FND_API.G_EXC_ERROR;

3200:
3201: IF line_out_tab(1).fPriStTaxType = 0 THEN
3202: g_string := 'Ship to/Bill To Address is Invalid. Please review the Address Setup';
3203: error_exception_handle(g_string);
3204: RAISE FND_API.G_EXC_ERROR;
3205: END IF;
3206:
3207: display_output('O');
3208:

Line 3210: WHEN FND_API.G_EXC_ERROR THEN

3206:
3207: display_output('O');
3208:
3209: EXCEPTION
3210: WHEN FND_API.G_EXC_ERROR THEN
3211: x_return_status := FND_API.G_RET_STS_ERROR ;
3212: g_string :='Error in VERTEX tax calulation API due to incorrect address passed :'||
3213: to_char(SQLCODE)||SQLERRM;
3214: IF (g_level_exception >= g_current_runtime_level ) THEN

Line 3211: x_return_status := FND_API.G_RET_STS_ERROR ;

3207: display_output('O');
3208:
3209: EXCEPTION
3210: WHEN FND_API.G_EXC_ERROR THEN
3211: x_return_status := FND_API.G_RET_STS_ERROR ;
3212: g_string :='Error in VERTEX tax calulation API due to incorrect address passed :'||
3213: to_char(SQLCODE)||SQLERRM;
3214: IF (g_level_exception >= g_current_runtime_level ) THEN
3215: FND_LOG.STRING(G_LEVEL_EXCEPTION,

Line 3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3217: g_string);
3218: END IF;
3219: RETURN;
3220: WHEN OTHERS THEN
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3222: g_string :='Error in VERTEX tax calulation API:'||to_char(SQLCODE)||SQLERRM;
3223: IF (g_level_exception >= g_current_runtime_level ) THEN
3224: FND_LOG.STRING(G_LEVEL_EXCEPTION,
3225: G_MODULE_NAME||l_api_name,

Line 3262: x_return_status := FND_API.G_RET_STS_ERROR;

3258: END IF;
3259:
3260: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3261: error_exception_handle(g_string);
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: return;
3264: END;
3265:
3266: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3307: x_return_status := FND_API.G_RET_STS_SUCCESS;

3303: l_api_name CONSTANT VARCHAR2(30) := 'TAX_RESULTS_PROCESSING';
3304: l_return_status VARCHAR2(30);
3305:
3306: Begin
3307: x_return_status := FND_API.G_RET_STS_SUCCESS;
3308:
3309: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3310: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3311: END IF;

Line 3698: x_return_status := FND_API.G_RET_STS_SUCCESS;

3694: PROCEDURE RESET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
3695: l_api_name CONSTANT VARCHAR2(30) := 'RESET_PARAMETERS';
3696: BEGIN
3697:
3698: x_return_status := FND_API.G_RET_STS_SUCCESS;
3699:
3700: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3701: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3702: END IF;

Line 3718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3714: WHEN OTHERS THEN
3715: IF (g_level_exception >= g_current_runtime_level ) THEN
3716: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3717: END IF;
3718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3719: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3720: error_exception_handle(g_string);
3721: return;
3722: END;

Line 3891: x_return_status := FND_API.G_RET_STS_SUCCESS;

3887: l_rounding_rule varchar2(30);
3888: l_error_buffer varchar2(200);
3889: l_return_Status VARCHAR2(30);
3890: BEGIN
3891: x_return_status := FND_API.G_RET_STS_SUCCESS;
3892:
3893: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3894: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3895: END IF;

Line 4035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'g_TotalTaxAmt : '||g_TotalTaxAmt);
4032: END IF;
4033:
4034: RESET_PARAMETERS(l_return_status);
4035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4036: IF (g_level_exception >= g_current_runtime_level ) THEN
4037: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4038: END IF;
4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4036: IF (g_level_exception >= g_current_runtime_level ) THEN
4037: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4038: END IF;
4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: g_string :='Failed in RESET_PARAMETERS procedure';
4041: error_exception_handle(g_string);
4042: RETURN;
4043: END IF;

Line 4046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4042: RETURN;
4043: END IF;
4044:
4045: SET_PARAMETERS(l_return_status);
4046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4047: IF (g_level_exception >= g_current_runtime_level ) THEN
4048: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4049: END IF;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4047: IF (g_level_exception >= g_current_runtime_level ) THEN
4048: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4049: END IF;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: g_string :='Failed in SET_PARAMETERS procedure';
4052: error_exception_handle(g_string);
4053: RETURN;
4054: END IF;

Line 4058: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4054: END IF;
4055:
4056: CALCULATE_TAX(l_return_status);
4057:
4058: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4059: IF (g_level_exception >= g_current_runtime_level ) THEN
4060: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4061: END IF;
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4058: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4059: IF (g_level_exception >= g_current_runtime_level ) THEN
4060: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4061: END IF;
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063: g_string :='Failed in CALCULATE_TAX procedure';
4064: error_exception_handle(g_string);
4065: RETURN;
4066: END IF;

Line 4074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4070: ELSE
4071: WRITE_TO_VERTEX_REPOSITORY(l_return_status);
4072: END IF;
4073:
4074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4075: IF (g_level_exception >= g_current_runtime_level ) THEN
4076: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4077: END IF;
4078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4075: IF (g_level_exception >= g_current_runtime_level ) THEN
4076: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4077: END IF;
4078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4079: g_string :='Failed in WRITE_TO_VERTEX_REPOSITORY procedure';
4080: error_exception_handle(g_string);
4081: RETURN;
4082: END IF;

Line 4124: x_return_status := FND_API.G_RET_STS_SUCCESS;

4120: l_neg_line_gt_exists NUMBER;
4121:
4122: l_api_name CONSTANT VARCHAR2(30) := 'GET_DOC_AND_EXT_ATT_INFO';
4123: Begin
4124: x_return_status := FND_API.G_RET_STS_SUCCESS;
4125:
4126: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4127: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
4128: END IF;

Line 4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4176: WHEN no_data_found THEN
4177: IF (g_level_exception >= g_current_runtime_level ) THEN
4178: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4179: END IF;
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181: g_string :='No data found in zx_lines_det_factors ';
4182: error_exception_handle(g_string);
4183: RETURN;
4184: END;

Line 4209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4205: p_regime_code => p_regime_code,
4206: p_tax_provider_id => p_tax_provider_id,
4207: x_return_status => l_return_status);
4208:
4209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4210: IF (g_level_exception >= g_current_runtime_level ) THEN
4211: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4212: END IF;
4213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4210: IF (g_level_exception >= g_current_runtime_level ) THEN
4211: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4212: END IF;
4213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4214: g_string :='Not able to copy the line information :Failed with an exception';
4215: error_exception_handle(g_string);
4216: return;
4217: END IF;

Line 4284: x_return_status := FND_API.G_RET_STS_SUCCESS;

4280:
4281: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';
4282:
4283: BEGIN
4284: x_return_status := FND_API.G_RET_STS_SUCCESS;
4285:
4286: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4287: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
4288: END IF;

Line 4471: x_return_status := FND_API.G_RET_STS_SUCCESS;

4467:
4468: l_line_action zx_lines_det_factors.line_level_action%type;
4469: l_adj_trx_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4470: BEGIN
4471: x_return_status := FND_API.G_RET_STS_SUCCESS;
4472: err_count := 0;
4473:
4474: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4475: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4494: WHEN TOO_MANY_ROWS THEN
4495: IF (g_level_exception >= g_current_runtime_level ) THEN
4496: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4497: End if;
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499: g_string :='More than one row exist at header level';
4500: error_exception_handle(g_string);
4501: RETURN;
4502: END;

Line 4644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4640: When no_data_found then
4641: IF (g_level_exception >= g_current_runtime_level ) THEN
4642: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4643: End if;
4644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4645: g_string :='No document type exist for provided event_class_mapping_id ';
4646: error_exception_handle(g_string);
4647: x_messages_tbl:=g_messages_tbl;
4648: return;

Line 4674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4670: END;
4671:
4672: SET_DOCUMENT_TYPE(l_document_type,l_adj_trx_id,l_amount,l_line_action,l_return_status);
4673:
4674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4675: IF (g_level_exception >= g_current_runtime_level ) THEN
4676: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4677: END IF;
4678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4675: IF (g_level_exception >= g_current_runtime_level ) THEN
4676: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4677: END IF;
4678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4679: g_string :='Failed in setting up document type';
4680: error_exception_handle(g_string);
4681: x_messages_tbl:=g_messages_tbl;
4682: return;

Line 4771: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

4767: ELSE
4768: l_event_type := 'TAX_LINE_CREATE';
4769: END IF;
4770: ELSE
4771: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
4772: g_string := 'There were more than one tax/trx lines';
4773: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4774: FND_LOG.STRING(G_LEVEL_EXCEPTION,
4775: G_MODULE_NAME||l_api_name,

Line 4804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4800: SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt),
4801: SYNC_TAX_LINES.trx_level_type(sync_tax_cnt),
4802: SYNC_TAX_LINES.country_code(sync_tax_cnt),
4803: 1,l_return_status);
4804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4805: IF (g_level_exception >= g_current_runtime_level ) THEN
4806: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4807: END IF;
4808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4805: IF (g_level_exception >= g_current_runtime_level ) THEN
4806: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4807: END IF;
4808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4809: g_string :='Failed in GET_DOC_AND_EXT_ATT_INFO procedure';
4810: error_exception_handle(g_string);
4811: RETURN;
4812: END IF;

Line 4886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4882: populate_sync_tax_amts(sync_tax_cnt
4883: , sync_tax_lines.tax(sync_tax_cnt)
4884: , x_output_sync_tax_lines
4885: , x_return_status);
4886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4887: IF (g_level_exception >= g_current_runtime_level ) THEN
4888: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4889: END IF;
4890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4887: IF (g_level_exception >= g_current_runtime_level ) THEN
4888: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4889: END IF;
4890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4891: g_string :='Failed in populate_sync_tax_amts procedure';
4892: error_exception_handle(g_string);
4893: RETURN;
4894: END IF;

Line 4950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4946: When no_data_found then
4947: IF (g_level_exception >= g_current_runtime_level ) THEN
4948: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4949: End if;
4950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4951: g_string :='No document type exist for provided event_class_mapping_id ';
4952: error_exception_handle(g_string);
4953: x_messages_tbl:=g_messages_tbl;
4954: return;

Line 4980: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4976: END;
4977:
4978: SET_DOCUMENT_TYPE(l_document_type,l_adj_trx_id,l_amount,l_line_action,l_return_status);
4979:
4980: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4981: IF (g_level_exception >= g_current_runtime_level ) THEN
4982: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4983: END IF;
4984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4980: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4981: IF (g_level_exception >= g_current_runtime_level ) THEN
4982: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4983: END IF;
4984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4985: g_string :='Failed in setting up document type';
4986: error_exception_handle(g_string);
4987: x_messages_tbl:=g_messages_tbl;
4988: return;

Line 5064: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

5060: ELSE
5061: l_event_type := 'TAX_LINE_CREATE';
5062: END IF;
5063: ELSE
5064: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
5065: g_string := 'There were more than one tax/trx lines';
5066: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5067: FND_LOG.STRING(G_LEVEL_EXCEPTION,
5068: G_MODULE_NAME||l_api_name,

Line 5120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5116: populate_sync_tax_amts(sync_tax_cnt1
5117: , sync_tax_lines.tax(sync_tax_cnt1)
5118: , x_output_sync_tax_lines
5119: , x_return_status);
5120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5121: IF (g_level_exception >= g_current_runtime_level ) THEN
5122: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5123: END IF;
5124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5121: IF (g_level_exception >= g_current_runtime_level ) THEN
5122: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5123: END IF;
5124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5125: g_string :='Failed in populate_sync_tax_amts procedure';
5126: error_exception_handle(g_string);
5127: RETURN;
5128: END IF;

Line 5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5153: WHEN TOO_MANY_ROWS THEN
5154: IF (g_level_exception >= g_current_runtime_level ) THEN
5155: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5156: End if;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: g_string :='More than one row exist at header level';
5159: error_exception_handle(g_string);
5160: RETURN;
5161: WHEN OTHERS THEN

Line 5220: x_return_status := FND_API.G_RET_STS_SUCCESS;

5216: --Bug 8532463
5217: l_doc_amount NUMBER;
5218:
5219: BEGIN
5220: x_return_status := FND_API.G_RET_STS_SUCCESS;
5221: err_count := 0;
5222:
5223: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5224: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 5404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5400: WHEN no_data_found THEN
5401: IF (g_level_exception >= g_current_runtime_level ) THEN
5402: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5403: End if;
5404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5405: g_string := 'No document type exist for provided event_class_mapping_id ';
5406: error_exception_handle(g_string);
5407: x_messages_tbl := g_messages_tbl;
5408: RETURN;

Line 5425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5421: l_doc_amount,
5422: 'NEGATE',
5423: l_return_status);
5424:
5425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5426: IF (g_level_exception >= g_current_runtime_level ) THEN
5427: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5428: END IF;
5429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5426: IF (g_level_exception >= g_current_runtime_level ) THEN
5427: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5428: END IF;
5429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5430: g_string :='Failed in setting up document type';
5431: error_exception_handle(g_string);
5432: x_messages_tbl:=g_messages_tbl;
5433: return;

Line 5441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5437: LOOP
5438: I := cnt;
5439: l_line_level_action := 'NEGATE';
5440: perform_line_deletion(l_return_status);
5441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5442: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5443: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
5444: END IF;
5445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5442: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5443: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
5444: END IF;
5445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5446: g_string :='Failed in PERFORM_LINE_DELETION procedure';
5447: error_exception_handle(g_string);
5448: RETURN;
5449: END IF;