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_TAXWARE_TAX_SERVICE_PKG dependencies on FND_API

Line 900: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

896: IF (g_level_exception >= g_current_runtime_level ) THEN
897: FND_LOG.STRING(g_level_exception,
898: G_PKG_NAME||'.'||l_api_name,'Current Taxware version is imcompaitable with Oracle Apps');
899: END IF;
900: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: g_string :='Call to ZX_TAX_TAXWARE_REV.GET_RELEASE failed with exception';
902: error_exception_handle(g_string);
903: x_messages_tbl:=g_messages_tbl;
904: return;

Line 913: x_error_status := FND_API.G_RET_STS_ERROR;

909: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
911: 'Release 12 Old tax partner integration does not support P2P products' );
912: END IF;
913: x_error_status := FND_API.G_RET_STS_ERROR;
914: Raise WRONG_BUSINESS_FLOW;
915: END IF;
916:
917: open item_lines_to_be_processed;

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

1199: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1201: 'No item lines exist to whom tax lines need to be created' );
1202: END IF;
1203: --x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: --g_string :='No item lines exist to whom tax lines need to be created';
1205: --error_exception_handle(g_string);
1206: --x_messages_tbl:=g_messages_tbl;
1207: RETURN;

Line 1240: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1236: When no_data_found then
1237: IF (g_level_exception >= g_current_runtime_level ) THEN
1238: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1239: End if;
1240: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: g_string :='No document type exist for provided event_class_mapping_id ';
1242: error_exception_handle(g_string);
1243: x_messages_tbl:=g_messages_tbl;
1244: return;

Line 1266: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1262: END IF;
1263:
1264: Perform_validate(l_return_status);
1265:
1266: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1267: IF (g_level_exception >= g_current_runtime_level ) THEN
1268: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1269: END IF;
1270: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1270: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1266: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1267: IF (g_level_exception >= g_current_runtime_level ) THEN
1268: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1269: END IF;
1270: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: g_string :='Header ,line level actions are incompaitable';
1272: error_exception_handle(g_string);
1273: x_messages_tbl:=g_messages_tbl;
1274: RETURN;

Line 1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1280: END IF;
1281:
1282: SET_DOCUMENT_TYPE(l_document_type,pg_adj_doc_trx_id_tab(I),pg_line_amount_tab(I),l_return_status);
1283:
1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF (g_level_exception >= g_current_runtime_level ) THEN
1286: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1287: END IF;
1288: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1288: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF (g_level_exception >= g_current_runtime_level ) THEN
1286: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1287: END IF;
1288: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: g_string :='Failed in setting up document type';
1290: error_exception_handle(g_string);
1291: x_messages_tbl:=g_messages_tbl;
1292: RETURN;

Line 1307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1303: ' Calling LINE_CREATION procedure to create entry in TAXWARE' );
1304: END IF;
1305:
1306: Perform_line_creation(l_tax_lines_tbl,p_currency_tab,l_return_status);
1307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1308: IF (g_level_exception >= g_current_runtime_level ) THEN
1309: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1310: END IF;
1311: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1311: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1308: IF (g_level_exception >= g_current_runtime_level ) THEN
1309: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1310: END IF;
1311: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: g_string :='Failed in creating tax line';
1313: error_exception_handle(g_string);
1314: x_messages_tbl:=g_messages_tbl;
1315: return;

Line 1328: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1324: ' Calling PERFORM_UPDATE procedure to update an entry in TAXWARE' );
1325: END IF;
1326:
1327: Perform_update(l_tax_lines_tbl,p_currency_tab,l_return_status);
1328: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1329: IF (g_level_exception >= g_current_runtime_level ) THEN
1330: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1331: END IF;
1332: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1332: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1328: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1329: IF (g_level_exception >= g_current_runtime_level ) THEN
1330: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1331: END IF;
1332: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: g_string :='Failed in performing the update';
1334: error_exception_handle(g_string);
1335: x_messages_tbl:=g_messages_tbl;
1336: RETURN;

Line 1352: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1348: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1350: ' Unknown header level action' );
1351: END IF;
1352: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: g_string :=' Unknown header level action';
1354: error_exception_handle(g_string);
1355: x_messages_tbl:=g_messages_tbl;
1356: RETURN;

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

1424: x_return_status OUT NOCOPY VARCHAR2)IS
1425: l_api_name CONSTANT VARCHAR2(30) := 'SET_DOCUMENT_TYPE';
1426:
1427: Begin
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429:
1430: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1431: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1432: END IF;

Line 1475: x_return_status := FND_API.G_RET_STS_SUCCESS;

1471: PROCEDURE PERFORM_VALIDATE(x_return_status OUT NOCOPY varchar2) is
1472: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_VALIDATE';
1473: Begin
1474:
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;
1476:
1477: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1478: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1479: END IF;

Line 1490: x_return_status := FND_API.G_RET_STS_ERROR;

1486: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'QUOTE','SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1487: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1489: END IF;
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491: end if;
1492: elsif(pg_doc_level_action_tab(i) = 'QUOTE') Then
1493: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1497: x_return_status := FND_API.G_RET_STS_ERROR;

1493: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1496: END IF;
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: end if;
1499: elsif(pg_doc_level_action_tab(i) = 'UPDATE') Then
1500: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1501: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1501: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1502: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1503: END IF;
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: end if;
1506: else
1507: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');

Line 1530: x_return_status := FND_API.G_RET_STS_SUCCESS;

1526: l_return_status VARCHAR2(30);
1527: input_param_flag boolean;
1528: Begin
1529:
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;
1531:
1532: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1534: END IF;

Line 1554: --x_return_status := FND_API.G_RET_STS_ERROR;

1550: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
1551: input_param_flag := FALSE;
1552: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
1553: IF (return_code = FALSE) then
1554: --x_return_status := FND_API.G_RET_STS_ERROR;
1555: g_string :='Failed in CALCULATE_TAX procedure';
1556: error_exception_handle(g_string);
1557: return;
1558: END IF;

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

1556: error_exception_handle(g_string);
1557: return;
1558: END IF;
1559: else
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: g_string :='Failed in SET_PRAMETERS procedure';
1562: error_exception_handle(g_string);
1563: return;
1564: end if;

Line 1570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling TAX_RESULTS_PROCESSING procedure' );
1567: END IF;
1568:
1569: tax_results_processing(p_tax_lines_tbl,p_currency_tab,l_TaxLink, l_JurLink, l_OraLink,l_return_status);
1570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1571: IF (g_level_exception >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1573: END IF;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1571: IF (g_level_exception >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1573: END IF;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: g_string :='Failed in call to the TAX_RESULTS_PROCESSING';
1576: error_exception_handle(g_string);
1577: RETURN;
1578: END IF;

Line 1585: x_return_status := FND_API.G_RET_STS_ERROR;

1581: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
1582: END IF;
1583: Exception
1584: When Others then
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: IF (g_level_exception >= g_current_runtime_level ) THEN
1587: FND_LOG.STRING(g_level_exception,G_PKG_NAME||'.'||l_api_name,
1588: 'Failed in Line creation procedure');
1589: END IF;

Line 1600: x_return_status := FND_API.G_RET_STS_SUCCESS;

1596: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_DELETION';
1597: return_code boolean;
1598: input_param_flag boolean;
1599: Begin
1600: x_return_status := FND_API.G_RET_STS_SUCCESS;
1601: /*ZX_TAXWARE_USER_PKG.g_line_negation := TRUE;
1602: ZX_TAXWARE_USER_PKG.g_trx_line_id := pg_trx_line_id_tab(I);
1603: ZX_TAXWARE_USER_PKG.Derive_Hdr_Ext_Attr;
1604: ZX_TAXWARE_USER_PKG.Derive_Line_Ext_Attr;*/

Line 1626: --x_return_status := FND_API.G_RET_STS_ERROR;

1622: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
1623: input_param_flag := FALSE;
1624: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
1625: IF (return_code = FALSE) then
1626: --x_return_status := FND_API.G_RET_STS_ERROR;
1627: g_string :='Failed in CALCULATE_TAX procedure';
1628: error_exception_handle(g_string);
1629: return;
1630: END IF;

Line 1632: x_return_status := FND_API.G_RET_STS_ERROR;

1628: error_exception_handle(g_string);
1629: return;
1630: END IF;
1631: else
1632: x_return_status := FND_API.G_RET_STS_ERROR;
1633: end if;
1634: /*end of line deletion process.*/
1635: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1636: 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_ERROR;

1636: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()+');
1637: END IF;
1638: Exception
1639: When Others then
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: IF (g_level_exception >= g_current_runtime_level ) THEN
1642: FND_LOG.STRING(g_level_exception,G_PKG_NAME||'.'||l_api_name,
1643: 'Failed in Line deletion procedure');
1644: END IF;

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652: l_return_status varchar2(30);
1653: l_ret_code boolean;
1654: Begin
1655:
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657:
1658: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1660: END IF;

Line 1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling PERFORM_LINE_CREATION procedure' );
1671: END IF;
1672:
1673: Perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: IF (g_level_exception >= g_current_runtime_level ) THEN
1676: FND_LOG.STRING(G_LEVEL_EXCEPTION,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_exception >= g_current_runtime_level ) THEN
1676: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1677: END IF;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: g_string :='Not compaitable to TAXWARE Release';
1680: error_exception_handle(g_string);
1681: return;
1682: END IF;

Line 1699: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1695: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling PERFORM_LINE_CREATION procedure' );
1696: END IF;
1697:
1698: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1699: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1700: IF (g_level_exception >= g_current_runtime_level ) THEN
1701: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1702: END IF;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1699: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1700: IF (g_level_exception >= g_current_runtime_level ) THEN
1701: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1702: END IF;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: g_string :='Not compaitable to TAXWARE Release';
1705: error_exception_handle(g_string);
1706: return;
1707: END IF;

Line 1737: x_return_status := FND_API.G_RET_STS_SUCCESS;

1733: x_jurisdictions_found VARCHAR2(20);
1734: l_return_status VARCHAR2(30);
1735:
1736: BEGIN
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738:
1739: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1740: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1741: END IF;

Line 1753: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1749: x_tax_jurisdiction_rec ,
1750: x_jurisdictions_found ,
1751: x_return_status
1752: );
1753: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1754: IF (g_level_exception >= g_current_runtime_level ) THEN
1755: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1756: END IF;
1757: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1753: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1754: IF (g_level_exception >= g_current_runtime_level ) THEN
1755: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1756: END IF;
1757: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: g_string :='Not able to find Jurisdiction';
1759: error_exception_handle(g_string);
1760: RETURN;
1761: END IF;

Line 2876: x_return_status := FND_API.G_RET_STS_SUCCESS;

2872: l_return_status VARCHAR2(30);
2873: ind NUMBER;
2874: Begin
2875:
2876: x_return_status := FND_API.G_RET_STS_SUCCESS;
2877:
2878: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2879: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2880: END IF;

Line 3427: x_return_status := FND_API.G_RET_STS_SUCCESS;

3423: l_JurLink ZX_TAX_TAXWARE_GEN.JurParm;
3424: l_OraLink ZX_TAX_TAXWARE_GEN.t_OraParm;
3425: input_param_flag boolean;
3426: BEGIN
3427: x_return_status := FND_API.G_RET_STS_SUCCESS;
3428:
3429: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3430: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3431: END IF;

Line 3507: --x_return_status := FND_API.G_RET_STS_ERROR;

3503: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
3504: input_param_flag := FALSE;
3505: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
3506: IF (return_code = FALSE) then
3507: --x_return_status := FND_API.G_RET_STS_ERROR;
3508: g_string :='Failed in CALCULATE_TAX procedure';
3509: error_exception_handle(g_string);
3510: return;
3511: END IF;

Line 3513: x_return_status := FND_API.G_RET_STS_ERROR;

3509: error_exception_handle(g_string);
3510: return;
3511: END IF;
3512: else
3513: x_return_status := FND_API.G_RET_STS_ERROR;
3514: g_string :='Failed in SET_PRAMETERS procedure';
3515: error_exception_handle(g_string);
3516: return;
3517: end if;

Line 3549: x_return_status := FND_API.G_RET_STS_SUCCESS;

3545: l_TRX_LEVEL_TYPE varchar2(20);
3546:
3547: l_api_name CONSTANT VARCHAR2(30) := 'GET_DOC_AND_EXT_ATT_INFO';
3548: Begin
3549: x_return_status := FND_API.G_RET_STS_SUCCESS;
3550:
3551: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3552: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3553: END IF;

Line 3589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3585: When no_data_found then
3586: IF (g_level_exception >= g_current_runtime_level ) THEN
3587: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3588: End if;
3589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3590: g_string :='No data found in zx_lines_det_factors ';
3591: error_exception_handle(g_string);
3592: return;
3593: End;

Line 3616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3612: p_regime_code => p_regime_code,
3613: p_tax_provider_id => p_tax_provider_id,
3614: x_return_status => l_return_status);
3615:
3616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS 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;

Line 3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS 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 :='Not able to copy the line information :Failed with an exception';
3622: error_exception_handle(g_string);
3623: return;
3624: END IF;

Line 3689: x_return_status := FND_API.G_RET_STS_SUCCESS;

3685:
3686: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';
3687:
3688: BEGIN
3689: x_return_status := FND_API.G_RET_STS_SUCCESS;
3690:
3691: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3692: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3693: END IF;

Line 3815: x_return_status := FND_API.G_RET_STS_SUCCESS;

3811: l_trx_number VARCHAR2(150);
3812: l_statements VARCHAR2(2000);
3813:
3814: BEGIN
3815: x_return_status := FND_API.G_RET_STS_SUCCESS;
3816:
3817: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3818: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
3819: END IF;

Line 3840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3836: WHEN TOO_MANY_ROWS THEN
3837: IF (g_level_exception >= g_current_runtime_level ) THEN
3838: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3839: End if;
3840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3841: g_string :='More than one row exist at header level';
3842: error_exception_handle(g_string);
3843: RETURN;
3844: END;

Line 3962: x_return_status :=FND_API.G_RET_STS_ERROR;

3958: ELSE
3959: l_event_type:='TAX_LINE_CREATE';
3960: END IF;
3961: ELSE
3962: x_return_status :=FND_API.G_RET_STS_ERROR;
3963: g_string := 'There were more than one tax line';
3964: error_exception_handle(g_string);
3965: RETURN;
3966: END IF;

Line 3979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3975: SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt),
3976: SYNC_TAX_LINES.trx_level_type(sync_tax_cnt),
3977: SYNC_TAX_LINES.country_code(sync_tax_cnt),
3978: 1,l_return_status);
3979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3980: IF (g_level_exception >= g_current_runtime_level ) THEN
3981: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3982: END IF;
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3980: IF (g_level_exception >= g_current_runtime_level ) THEN
3981: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3982: END IF;
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3984: g_string :='Failed in GET_DOC_AND_EXT_ATT_INFO procedure';
3985: error_exception_handle(g_string);
3986: RETURN;
3987: END IF;

Line 3992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3988: --END IF;
3989:
3990: IF (l_event_type='TAX_LINE_UPDATE') THEN
3991: /*Taxware does not have this feature*/
3992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3993: g_string :='Unable to perform with Taxware';
3994: error_exception_handle(g_string);
3995:
3996: ELSIF(l_event_type='TAX_LINE_DELETE')then

Line 4030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4026: populate_sync_tax_amts(sync_tax_cnt
4027: , sync_tax_lines.tax(sync_tax_cnt)
4028: , x_output_sync_tax_lines
4029: , x_return_status);
4030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4031: IF (g_level_exception >= g_current_runtime_level ) THEN
4032: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4033: END IF;
4034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4031: IF (g_level_exception >= g_current_runtime_level ) THEN
4032: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4033: END IF;
4034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4035: g_string :='Failed in populate_sync_tax_amts procedure';
4036: error_exception_handle(g_string);
4037: RETURN;
4038: END IF;

Line 4058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4054: WHEN TOO_MANY_ROWS THEN
4055: IF (g_level_exception >= g_current_runtime_level ) THEN
4056: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4057: End if;
4058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4059: g_string :='More than one row exist at header level';
4060: error_exception_handle(g_string);
4061: RETURN;
4062: WHEN OTHERS THEN

Line 4109: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4179: WHEN no_data_found THEN
4180: IF (g_level_exception >= g_current_runtime_level ) THEN
4181: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4182: End if;
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4184: g_string := 'No document type exist for provided event_class_mapping_id ';
4185: error_exception_handle(g_string);
4186: x_messages_tbl := g_messages_tbl;
4187: RETURN;

Line 4200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4196: WHEN no_data_found THEN
4197: IF (g_level_exception >= g_current_runtime_level ) THEN
4198: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4199: End if;
4200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4201: g_string := 'No document type exist for provided event_class_mapping_id ';
4202: error_exception_handle(g_string);
4203: x_messages_tbl := g_messages_tbl;
4204: RETURN;

Line 4211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4207: FOR cnt IN 1..nvl(pg_trx_line_id_tab.last, 0)
4208: LOOP
4209: I := cnt;
4210: perform_line_deletion(l_return_status);
4211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4212: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
4214: END IF;
4215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4212: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
4214: END IF;
4215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4216: g_string :='Failed in PERFORM_LINE_DELETION procedure';
4217: error_exception_handle(g_string);
4218: RETURN;
4219: END IF;