eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on FND_API

Line 744: x_error_status := FND_API.G_RET_STS_SUCCESS;

740: l_doc_amount NUMBER;
741: l_doc_trx_id NUMBER;
742:
743: BEGIN
744: x_error_status := FND_API.G_RET_STS_SUCCESS;
745: err_count := 0;
746: l_doc_trx_id := NULL;
747:
748: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

763: with the version of Vertex Q Series product is certified' );
764: END IF;
765: ZX_TAX_VERTEX_REV.GET_RELEASE(context_rec,version_rec,l_return_status);
766:
767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
768: IF (g_level_exception >= g_current_runtime_level ) THEN
769: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
770: END IF;
771: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 771: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
768: IF (g_level_exception >= g_current_runtime_level ) THEN
769: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
770: END IF;
771: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: g_string :='Not compaitable to VERTEX Release';
773: error_exception_handle(g_string);
774: x_messages_tbl:=g_messages_tbl;
775: return;

Line 783: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

779: WHEN OTHERS THEN
780: IF (g_level_exception >= g_current_runtime_level ) THEN
781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
782: END IF;
783: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: g_string :='Not compaitable to VERTEX Release failed with exception';
785: error_exception_handle(g_string);
786: x_messages_tbl:=g_messages_tbl;
787: return;

Line 797: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

793: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
795: 'Release 12 Old tax partner integration does not support P2P products' );
796: END IF;
797: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: g_string :='Release 12 Old tax partner integration does not support P2P products';
799: error_exception_handle(g_string);
800: x_messages_tbl:=g_messages_tbl;
801: return;

Line 1280: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1306: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1302: When no_data_found then
1303: IF (g_level_exception >= g_current_runtime_level ) THEN
1304: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1305: End if;
1306: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: g_string :='No document type exist for provided event_class_mapping_id ';
1308: error_exception_handle(g_string);
1309: x_messages_tbl:=g_messages_tbl;
1310: return;

Line 1356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1352: END IF;
1353:
1354:
1355: Perform_validate(l_return_status);
1356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1357: IF (g_level_exception >= g_current_runtime_level ) THEN
1358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1359: END IF;
1360: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1360: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1357: IF (g_level_exception >= g_current_runtime_level ) THEN
1358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1359: END IF;
1360: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: g_string :='Header ,line level actions are incompaitable';
1362: error_exception_handle(g_string);
1363: x_messages_tbl:=g_messages_tbl;
1364: return;

Line 1376: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1372: FROM ZX_O2C_CALC_TXN_INPUT_V
1373: WHERE transaction_id = l_doc_trx_id;
1374:
1375: 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);
1376: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1377: IF (g_level_exception >= g_current_runtime_level ) THEN
1378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1379: END IF;
1380: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1380: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1394: IF (l_document_type in ('TAX_ONLY_CREDIT_MEMO', 'TAX_ONLY_ADJUSTMENT','TAX_ONLY_INVOICE')) THEN
1395: RETURN;
1396: ELSE
1397: Perform_line_creation(x_tax_lines_tbl,p_currency_tab,l_return_status);
1398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1399: IF (g_level_exception >= g_current_runtime_level ) THEN
1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1401: END IF;
1402: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1402: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1398: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1399: IF (g_level_exception >= g_current_runtime_level ) THEN
1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1401: END IF;
1402: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: g_string :='Failed in creating tax line';
1404: error_exception_handle(g_string);
1405: x_messages_tbl:=g_messages_tbl;
1406: return;

Line 1417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1413: RETURN;
1414: END IF;
1415: Perform_update(x_tax_lines_tbl,p_currency_tab,l_return_status);
1416:
1417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1418: IF (g_level_exception >= g_current_runtime_level ) THEN
1419: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1420: END IF;
1421: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1421: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1418: IF (g_level_exception >= g_current_runtime_level ) THEN
1419: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1420: END IF;
1421: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: g_string :='Failed in creating update';
1423: error_exception_handle(g_string);
1424: x_messages_tbl:=g_messages_tbl;
1425: return;

Line 1443: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1441: ' Unknown header level action' );
1442: END IF;
1443: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: g_string :=' Unknown header level action';
1445: error_exception_handle(g_string);
1446: x_messages_tbl:=g_messages_tbl;
1447: return;

Line 1463: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1459: FND_LOG.STRING(g_level_unexpected,
1460: G_MODULE_NAME||l_api_name,
1461: sqlerrm);
1462: END IF;
1463: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: g_string :='Not compaitable to VERTEX Release';
1465: error_exception_handle(g_string);
1466: x_messages_tbl:=g_messages_tbl;
1467: return;

Line 1479: x_return_status := FND_API.G_RET_STS_SUCCESS;

1475: p_LINE_LEVEL_ACTION IN VARCHAR2,
1476: x_return_status OUT NOCOPY VARCHAR2)IS
1477: l_api_name CONSTANT VARCHAR2(30) := 'SET_DOCUMENT_TYPE';
1478: BEGIN
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1483: END IF;

Line 1529: x_return_status := FND_API.G_RET_STS_SUCCESS;

1525: PROCEDURE PERFORM_VALIDATE(x_return_status OUT NOCOPY VARCHAR2) is
1526: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_VALIDATE';
1527:
1528: Begin
1529: x_return_status := FND_API.G_RET_STS_SUCCESS;
1530:
1531: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1533: END IF;

Line 1545: x_return_status := FND_API.G_RET_STS_ERROR;

1541: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'QUOTE','SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1542: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1544: END IF;
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: end if;
1547: elsif(pg_doc_level_action_tab(i) = 'QUOTE') Then
1548: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1549: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1552: x_return_status := FND_API.G_RET_STS_ERROR;

1548: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1549: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: end if;
1554: elsif(pg_doc_level_action_tab(i) = 'UPDATE') Then
1555: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1556: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1559: x_return_status := FND_API.G_RET_STS_ERROR;

1555: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1556: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1558: END IF;
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: end if;
1561: else
1562: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');

Line 1565: x_return_status := FND_API.G_RET_STS_ERROR;

1561: else
1562: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');
1564: END IF;
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: end if;
1567:
1568: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 1580: x_return_status := FND_API.G_RET_STS_SUCCESS;

1576:
1577: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_CREATION';
1578: l_return_status VARCHAR2(30);
1579: Begin
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581:
1582: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1584: END IF;

Line 1591: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Value of Variable I is'|| I );
1588: END IF;
1589:
1590: reset_parameters(l_return_status);
1591: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1594: END IF;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1591: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1594: END IF;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: g_string :='Failed in RESET_PARAMETERS procedure';
1597: error_exception_handle(g_string);
1598: return;
1599: END IF;

Line 1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1599: END IF;
1600:
1601: l_line_level_action := 'CREATE';
1602: set_parameters(l_return_status);
1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1604: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1606: END IF;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1604: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1606: END IF;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: g_string :='Failed in SET_PRAMETERS procedure';
1609: error_exception_handle(g_string);
1610: return;
1611: END IF;

Line 1614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1610: return;
1611: END IF;
1612:
1613: calculate_tax(l_return_status);
1614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1615: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1617: END IF;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1615: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1617: END IF;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: g_string :='Failed in CALCULATE_TAX Procedure ';
1620: error_exception_handle(g_string);
1621: return;
1622: END IF;

Line 1631: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1627: END IF;
1628:
1629: IF (pg_line_level_action_tab(i)<>'QUOTE') THEN
1630: write_to_vertex_repository(l_return_status);
1631: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1634: END IF;
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1631: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1634: END IF;
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636: g_string :='Failed in WRITE_TO_VERTEX_REPOSITORY Procedure ';
1637: error_exception_handle(g_string);
1638: return;
1639: END IF;

Line 1644: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1640: END IF;
1641:
1642: /*Vertex returned values need to be written back to zx_repository.*/
1643: tax_results_processing(p_tax_lines_tbl,p_currency_tab,l_return_status);
1644: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1645: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1647: END IF;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1645: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1647: END IF;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: g_string :='Failed in TAX_RESULTS_PROCESSING procedure';
1650: error_exception_handle(g_string);
1651: return;
1652: END IF;

Line 1665: x_return_status := FND_API.G_RET_STS_SUCCESS;

1661: PROCEDURE PERFORM_LINE_DELETION(x_return_status OUT NOCOPY VARCHAR2) is
1662: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_DELETION';
1663: l_return_status VARCHAR2(30);
1664: Begin
1665: x_return_status := FND_API.G_RET_STS_SUCCESS;
1666:
1667: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1669: END IF;

Line 1675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1671: ZX_VTX_USER_PKG.g_trx_line_id := pg_trx_line_id_tab(I);*/
1672:
1673: reset_parameters(l_return_status);
1674:
1675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1676: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1678: END IF;
1679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1682: return;
1683: END IF;
1684: set_parameters(l_return_status);
1685:
1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1687: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1687: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1691: g_string :='Failed in SET_PARAMETERS procedure';
1692: error_exception_handle(g_string);
1693: return;
1694: END IF;

Line 1696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1697: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1699: END IF;
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1701: g_string :='Failed in CALCULATE_TAX procedure';
1702: error_exception_handle(g_string);
1703: return;
1704: END IF;

Line 1706: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1702: error_exception_handle(g_string);
1703: return;
1704: END IF;
1705: write_to_vertex_repository(l_return_status);
1706: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1707: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1709: END IF;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1730: x_return_status := FND_API.G_RET_STS_SUCCESS;

1726: l_return_status VARCHAR2(30);
1727: l_application_id NUMBER;
1728: l_ver_count NUMBER(10);
1729: Begin
1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731:
1732: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1733: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1734: END IF;

Line 1745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1741:
1742: l_line_level_action := 'CREATE';
1743: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1744:
1745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1746: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1748: END IF;
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1780: IF l_ver_count <> 0 THEN
1781: l_line_level_action := 'NEGATE';
1782: perform_line_deletion(l_return_status);
1783:
1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1786: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1787: END IF;
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1786: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1787: END IF;
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: g_string :='Failed in PERFORM_LINE_DELETION procedure';
1790: error_exception_handle(g_string);
1791: return;
1792: END IF;

Line 1798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1794: /*For new line*/
1795: -- l_line_level_action := 'CREATE';
1796: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1797:
1798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1799: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1800: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1801: END IF;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1799: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1800: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1801: END IF;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803: g_string :='Failed in PERFORM_LINE_CREATION procedure';
1804: error_exception_handle(g_string);
1805: return;
1806: END IF;

Line 1811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1807:
1808: elsif(pg_line_level_action_tab(i) in ('DELETE','CANCEL')) Then
1809: l_line_level_action := pg_line_level_action_tab(i);
1810: perform_line_deletion(l_return_status);
1811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1812: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1812: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: g_string :='Failed in PERFORM_LINE_DELETION procedure';
1817: error_exception_handle(g_string);
1818: return;
1819: END IF;

Line 1844: x_return_status := FND_API.G_RET_STS_SUCCESS;

1840: x_jurisdictions_found VARCHAR2(20);
1841: l_return_status VARCHAR2(30);
1842:
1843: BEGIN
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845:
1846: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1847: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1848: END IF;

Line 1860: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1856: x_tax_jurisdiction_rec ,
1857: x_jurisdictions_found ,
1858: x_return_status
1859: );
1860: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: IF (g_level_exception >= g_current_runtime_level ) THEN
1862: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1863: END IF;
1864: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1860: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: IF (g_level_exception >= g_current_runtime_level ) THEN
1862: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1863: END IF;
1864: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: g_string :='Not able to find Jurisdiction';
1866: error_exception_handle(g_string);
1867: RETURN;
1868: END IF;

Line 2061: x_return_status := FND_API.G_RET_STS_SUCCESS;

2057:
2058: l_location_info_rec location_info_rec_type;
2059: l_api_name CONSTANT VARCHAR2(30) := 'SET_PARAMETERS';
2060: BEGIN
2061: x_return_status := FND_API.G_RET_STS_SUCCESS;
2062:
2063: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2064: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2065: END IF;

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

2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: IF (g_level_exception >= g_current_runtime_level ) THEN
2962: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2963: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
2965: error_exception_handle(g_string);
2966: --return;
2967:

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

2984: IF (g_level_exception >= g_current_runtime_level ) THEN
2985: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2986: END IF;
2987: IF (SQLCODE > -20500) OR (SQLCODE < -20599) THEN
2988: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2989: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
2990: error_exception_handle(g_string);
2991: --return;
2992: END IF;

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

3056: IF (g_level_exception >= g_current_runtime_level ) THEN
3057: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3058: END IF;
3059: IF (SQLCODE > -20500) OR (SQLCODE < -20599) THEN
3060: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3061: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3062: error_exception_handle(g_string);
3063:
3064: END IF;

Line 3097: x_return_status := FND_API.G_RET_STS_SUCCESS;

3093:
3094: PROCEDURE CALCULATE_TAX(x_return_status OUT NOCOPY VARCHAR2) IS
3095: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TAX';
3096: BEGIN
3097: x_return_status := FND_API.G_RET_STS_SUCCESS;
3098:
3099: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3100: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3101: END IF;

Line 3130: x_return_status := FND_API.G_RET_STS_ERROR;

3126: WHEN OTHERS THEN
3127: IF (g_level_exception >= g_current_runtime_level ) THEN
3128: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3129: END IF;
3130: x_return_status := FND_API.G_RET_STS_ERROR;
3131: g_string :='Error in VERTEX tax calulation API:'||to_char(SQLCODE)||SQLERRM;
3132: error_exception_handle(g_string);
3133: return;
3134: END;

Line 3166: x_return_status := FND_API.G_RET_STS_ERROR;

3162: END IF;
3163:
3164: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3165: error_exception_handle(g_string);
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: return;
3168: END;
3169:
3170: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3211: x_return_status := FND_API.G_RET_STS_SUCCESS;

3207: l_api_name CONSTANT VARCHAR2(30) := 'TAX_RESULTS_PROCESSING';
3208: l_return_status VARCHAR2(30);
3209:
3210: Begin
3211: x_return_status := FND_API.G_RET_STS_SUCCESS;
3212:
3213: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3214: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3215: END IF;

Line 3600: x_return_status := FND_API.G_RET_STS_SUCCESS;

3596: PROCEDURE RESET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
3597: l_api_name CONSTANT VARCHAR2(30) := 'RESET_PARAMETERS';
3598: BEGIN
3599:
3600: x_return_status := FND_API.G_RET_STS_SUCCESS;
3601:
3602: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3603: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3604: END IF;

Line 3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3616: WHEN OTHERS THEN
3617: IF (g_level_exception >= g_current_runtime_level ) THEN
3618: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3619: END IF;
3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3621: g_string :='Error in VERTEX API:'||to_char(SQLCODE)||SQLERRM;
3622: error_exception_handle(g_string);
3623: return;
3624: END;

Line 3789: x_return_status := FND_API.G_RET_STS_SUCCESS;

3785:
3786: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TAX_LINE';
3787: l_return_Status VARCHAR2(30);
3788: BEGIN
3789: x_return_status := FND_API.G_RET_STS_SUCCESS;
3790:
3791: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3792: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3793: END IF;

Line 3870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3866: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'g_TotalTaxAmt : '||g_TotalTaxAmt);
3867: END IF;
3868:
3869: RESET_PARAMETERS(l_return_status);
3870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3871: IF (g_level_exception >= g_current_runtime_level ) THEN
3872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3873: END IF;
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3871: IF (g_level_exception >= g_current_runtime_level ) THEN
3872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3873: END IF;
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875: g_string :='Failed in RESET_PARAMETERS procedure';
3876: error_exception_handle(g_string);
3877: return;
3878: END IF;

Line 3881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3877: return;
3878: END IF;
3879:
3880: SET_PARAMETERS(l_return_status);
3881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3882: IF (g_level_exception >= g_current_runtime_level ) THEN
3883: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3884: END IF;
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3882: IF (g_level_exception >= g_current_runtime_level ) THEN
3883: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3884: END IF;
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3886: g_string :='Failed in SET_PARAMETERS procedure';
3887: error_exception_handle(g_string);
3888: return;
3889: END IF;

Line 3893: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3889: END IF;
3890:
3891: CALCULATE_TAX(l_return_status);
3892:
3893: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3894: IF (g_level_exception >= g_current_runtime_level ) THEN
3895: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3896: END IF;
3897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3893: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3894: IF (g_level_exception >= g_current_runtime_level ) THEN
3895: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3896: END IF;
3897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3898: g_string :='Failed in CALCULATE_TAX procedure';
3899: error_exception_handle(g_string);
3900: return;
3901: END IF;

Line 3909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3905: ELSE
3906: WRITE_TO_VERTEX_REPOSITORY(l_return_status);
3907: END IF;
3908:
3909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3910: IF (g_level_exception >= g_current_runtime_level ) THEN
3911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3912: END IF;
3913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3910: IF (g_level_exception >= g_current_runtime_level ) THEN
3911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3912: END IF;
3913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3914: g_string :='Failed in WRITE_TO_VERTEX_REPOSITORY procedure';
3915: error_exception_handle(g_string);
3916: return;
3917: END IF;

Line 3949: x_return_status := FND_API.G_RET_STS_SUCCESS;

3945: l_neg_line_gt_exists NUMBER;
3946:
3947: l_api_name CONSTANT VARCHAR2(30) := 'GET_DOC_AND_EXT_ATT_INFO';
3948: Begin
3949: x_return_status := FND_API.G_RET_STS_SUCCESS;
3950:
3951: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3953: END IF;

Line 4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4001: WHEN no_data_found THEN
4002: IF (g_level_exception >= g_current_runtime_level ) THEN
4003: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4004: END IF;
4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4006: g_string :='No data found in zx_lines_det_factors ';
4007: error_exception_handle(g_string);
4008: RETURN;
4009: END;

Line 4034: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 4038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4034: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4035: IF (g_level_exception >= g_current_runtime_level ) THEN
4036: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4037: END IF;
4038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4039: g_string :='Not able to copy the line information :Failed with an exception';
4040: error_exception_handle(g_string);
4041: return;
4042: END IF;

Line 4109: x_return_status := FND_API.G_RET_STS_SUCCESS;

4105:
4106: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';
4107:
4108: BEGIN
4109: x_return_status := FND_API.G_RET_STS_SUCCESS;
4110:
4111: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4112: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
4113: END IF;

Line 4246: x_return_status := FND_API.G_RET_STS_SUCCESS;

4242: l_statements VARCHAR2(2000);
4243: cnt NUMBER;
4244:
4245: BEGIN
4246: x_return_status := FND_API.G_RET_STS_SUCCESS;
4247: err_count := 0;
4248:
4249: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4250: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 4274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4270: WHEN TOO_MANY_ROWS THEN
4271: IF (g_level_exception >= g_current_runtime_level ) THEN
4272: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4273: End if;
4274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4275: g_string :='More than one row exist at header level';
4276: error_exception_handle(g_string);
4277: RETURN;
4278: END;

Line 4440: x_return_status :=FND_API.G_RET_STS_ERROR;

4436: ELSE
4437: l_event_type:='TAX_LINE_CREATE';
4438: END IF;
4439: ELSE
4440: x_return_status :=FND_API.G_RET_STS_ERROR;
4441: g_string := 'There were more than one tax line';
4442: error_exception_handle(g_string);
4443: RETURN;
4444: END IF;

Line 4468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4464: SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt),
4465: SYNC_TAX_LINES.trx_level_type(sync_tax_cnt),
4466: SYNC_TAX_LINES.country_code(sync_tax_cnt),
4467: 1,l_return_status);
4468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4469: IF (g_level_exception >= g_current_runtime_level ) THEN
4470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4471: END IF;
4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4469: IF (g_level_exception >= g_current_runtime_level ) THEN
4470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4471: END IF;
4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4473: g_string :='Failed in GET_DOC_AND_EXT_ATT_INFO procedure';
4474: error_exception_handle(g_string);
4475: RETURN;
4476: END IF;

Line 4553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4549: populate_sync_tax_amts(sync_tax_cnt
4550: , sync_tax_lines.tax(sync_tax_cnt)
4551: , x_output_sync_tax_lines
4552: , x_return_status);
4553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4554: IF (g_level_exception >= g_current_runtime_level ) THEN
4555: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4556: END IF;
4557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4554: IF (g_level_exception >= g_current_runtime_level ) THEN
4555: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4556: END IF;
4557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4558: g_string :='Failed in populate_sync_tax_amts procedure';
4559: error_exception_handle(g_string);
4560: RETURN;
4561: END IF;

Line 4588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4584: WHEN TOO_MANY_ROWS THEN
4585: IF (g_level_exception >= g_current_runtime_level ) THEN
4586: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4587: End if;
4588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4589: g_string :='More than one row exist at header level';
4590: error_exception_handle(g_string);
4591: RETURN;
4592: WHEN OTHERS THEN

Line 4647: x_return_status := FND_API.G_RET_STS_SUCCESS;

4643: l_tax_type VARCHAR2(100);
4644: l_tax_flag VARCHAR2(10);
4645:
4646: BEGIN
4647: x_return_status := FND_API.G_RET_STS_SUCCESS;
4648: err_count := 0;
4649:
4650: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4651: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 4791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4787: WHEN no_data_found THEN
4788: IF (g_level_exception >= g_current_runtime_level ) THEN
4789: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4790: End if;
4791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4792: g_string := 'No document type exist for provided event_class_mapping_id ';
4793: error_exception_handle(g_string);
4794: x_messages_tbl := g_messages_tbl;
4795: RETURN;

Line 4803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4799: LOOP
4800: I := cnt;
4801: l_line_level_action := 'NEGATE';
4802: perform_line_deletion(l_return_status);
4803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4804: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
4806: END IF;
4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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