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 908: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

904: IF (g_level_exception >= g_current_runtime_level ) THEN
905: FND_LOG.STRING(g_level_exception,
906: G_PKG_NAME||'.'||l_api_name,'Current Taxware version is imcompaitable with Oracle Apps');
907: END IF;
908: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: g_string :='Call to ZX_TAX_TAXWARE_REV.GET_RELEASE failed with exception';
910: error_exception_handle(g_string);
911: x_messages_tbl:=g_messages_tbl;
912: return;

Line 921: x_error_status := FND_API.G_RET_STS_ERROR;

917: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
918: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
919: 'Release 12 Old tax partner integration does not support P2P products' );
920: END IF;
921: x_error_status := FND_API.G_RET_STS_ERROR;
922: FND_MESSAGE.SET_NAME('ZX', 'ZX_FLOW_NOT_SUPPORTED_4_PTNR');
923: FND_MESSAGE.SET_TOKEN('BUSINESS_FLOW',zx_tax_partner_pkg.G_BUSINESS_FLOW);
924: FND_MESSAGE.SET_TOKEN('SERVICE_PROVIDER','TAXWARE');
925: Raise WRONG_BUSINESS_FLOW;

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

1211: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1213: 'No item lines exist to whom tax lines need to be created' );
1214: END IF;
1215: --x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: --g_string :='No item lines exist to whom tax lines need to be created';
1217: --error_exception_handle(g_string);
1218: --x_messages_tbl:=g_messages_tbl;
1219: RETURN;

Line 1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1240: END IF;
1241:
1242: Perform_validate(l_return_status);
1243:
1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1245: IF (g_level_exception >= g_current_runtime_level ) THEN
1246: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1247: END IF;
1248: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1248: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1245: IF (g_level_exception >= g_current_runtime_level ) THEN
1246: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1247: END IF;
1248: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: g_string :='Header ,line level actions are incompaitable';
1250: error_exception_handle(g_string);
1251: x_messages_tbl:=g_messages_tbl;
1252: RETURN;

Line 1273: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1269: When no_data_found then
1270: IF (g_level_exception >= g_current_runtime_level ) THEN
1271: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1272: End if;
1273: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: g_string :='No document type exist for provided event_class_mapping_id ';
1275: error_exception_handle(g_string);
1276: x_messages_tbl:=g_messages_tbl;
1277: return;

Line 1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1300: WHERE transaction_id = l_doc_trx_id;
1301:
1302: SET_DOCUMENT_TYPE(l_document_type,pg_adj_doc_trx_id_tab(I),l_doc_amount,l_return_status);
1303:
1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: IF (g_level_exception >= g_current_runtime_level ) THEN
1306: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1307: END IF;
1308: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1308: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: IF (g_level_exception >= g_current_runtime_level ) THEN
1306: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1307: END IF;
1308: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: g_string :='Failed in setting up document type';
1310: error_exception_handle(g_string);
1311: x_messages_tbl:=g_messages_tbl;
1312: RETURN;

Line 1327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1323: END IF;
1324:
1325: Perform_line_creation(l_tax_lines_tbl,p_currency_tab,l_return_status);
1326:
1327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1328: IF (g_level_exception >= g_current_runtime_level ) THEN
1329: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1330: END IF;
1331: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1331: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1345: END IF;
1346:
1347: Perform_update(l_tax_lines_tbl,p_currency_tab,l_return_status);
1348:
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: IF (g_level_exception >= g_current_runtime_level ) THEN
1351: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1352: END IF;
1353: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1353: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: IF (g_level_exception >= g_current_runtime_level ) THEN
1351: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1352: END IF;
1353: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: g_string :='Failed in performing the update';
1355: error_exception_handle(g_string);
1356: x_messages_tbl:=g_messages_tbl;
1357: RETURN;

Line 1376: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1372: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1373: ' Unknown header level action' );
1374: END IF;
1375:
1376: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: g_string :=' Unknown header level action';
1378: error_exception_handle(g_string);
1379: x_messages_tbl:=g_messages_tbl;
1380: RETURN;

Line 1456: x_return_status := FND_API.G_RET_STS_SUCCESS;

1452: x_return_status OUT NOCOPY VARCHAR2)IS
1453: l_api_name CONSTANT VARCHAR2(30) := 'SET_DOCUMENT_TYPE';
1454:
1455: Begin
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1460: END IF;

Line 1503: x_return_status := FND_API.G_RET_STS_SUCCESS;

1499: PROCEDURE PERFORM_VALIDATE(x_return_status OUT NOCOPY varchar2) is
1500: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_VALIDATE';
1501: Begin
1502:
1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504:
1505: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1506: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1507: END IF;

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1514: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'QUOTE','SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1515: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1516: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1517: END IF;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: end if;
1520: elsif(pg_doc_level_action_tab(i) = 'QUOTE') Then
1521: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1522: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: if(pg_line_level_action_tab(i) NOT IN ('QUOTE')) Then
1522: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1524: END IF;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: end if;
1527: elsif(pg_doc_level_action_tab(i) = 'UPDATE') Then
1528: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1529: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1528: if(pg_line_level_action_tab(i) NOT IN ('CREATE', 'UPDATE', 'QUOTE', 'CANCEL', 'DELETE', 'SYNCHRONIZE','RECORD_WITH_NO_TAX')) Then
1529: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1530: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown line level action');
1531: END IF;
1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1533: end if;
1534: else
1535: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unknown header level action');

Line 1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

1554: l_return_status VARCHAR2(30);
1555: input_param_flag boolean;
1556: Begin
1557:
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559:
1560: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1562: END IF;

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR; --13533328

1578: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
1579: input_param_flag := FALSE;
1580: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
1581: IF (return_code = FALSE) then
1582: x_return_status := FND_API.G_RET_STS_ERROR; --13533328
1583: g_string :='Failed in CALCULATE_TAX procedure';
1584: error_exception_handle(g_string);
1585: return;
1586: END IF;

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR;

1584: error_exception_handle(g_string);
1585: return;
1586: END IF;
1587: else
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: g_string :='Failed in SET_PRAMETERS procedure';
1590: error_exception_handle(g_string);
1591: return;
1592: end if;

Line 1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1594: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling TAX_RESULTS_PROCESSING procedure' );
1595: END IF;
1596:
1597: tax_results_processing(p_tax_lines_tbl,p_currency_tab,l_TaxLink, l_JurLink, l_OraLink,l_return_status);
1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: IF (g_level_exception >= g_current_runtime_level ) THEN
1600: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1601: END IF;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: IF (g_level_exception >= g_current_runtime_level ) THEN
1600: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1601: END IF;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603: g_string :='Failed in call to the TAX_RESULTS_PROCESSING';
1604: error_exception_handle(g_string);
1605: RETURN;
1606: END IF;

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1609: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
1610: END IF;
1611: Exception
1612: When Others then
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: IF (g_level_exception >= g_current_runtime_level ) THEN
1615: FND_LOG.STRING(g_level_exception,G_PKG_NAME||'.'||l_api_name,
1616: 'Failed in Line creation procedure');
1617: END IF;

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: l_api_name CONSTANT VARCHAR2(30) := 'PERFORM_LINE_DELETION';
1625: return_code boolean;
1626: input_param_flag boolean;
1627: Begin
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: /*ZX_TAXWARE_USER_PKG.g_line_negation := TRUE;
1630: ZX_TAXWARE_USER_PKG.g_trx_line_id := pg_trx_line_id_tab(I);
1631: ZX_TAXWARE_USER_PKG.Derive_Hdr_Ext_Attr;
1632: ZX_TAXWARE_USER_PKG.Derive_Line_Ext_Attr;*/

Line 1654: x_return_status := FND_API.G_RET_STS_ERROR; --13533328

1650: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
1651: input_param_flag := FALSE;
1652: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
1653: IF (return_code = FALSE) then
1654: x_return_status := FND_API.G_RET_STS_ERROR; --13533328
1655: g_string :='Failed in CALCULATE_TAX procedure';
1656: error_exception_handle(g_string);
1657: return;
1658: END IF;

Line 1660: x_return_status := FND_API.G_RET_STS_ERROR;

1656: error_exception_handle(g_string);
1657: return;
1658: END IF;
1659: else
1660: x_return_status := FND_API.G_RET_STS_ERROR;
1661: end if;
1662: /*end of line deletion process.*/
1663: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()+');

Line 1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()+');
1665: END IF;
1666: Exception
1667: When Others then
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: IF (g_level_exception >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_exception,G_PKG_NAME||'.'||l_api_name,
1671: 'Failed in Line deletion procedure');
1672: END IF;

Line 1684: x_return_status := FND_API.G_RET_STS_SUCCESS;

1680: l_return_status varchar2(30);
1681: l_ret_code boolean;
1682: Begin
1683:
1684: x_return_status := FND_API.G_RET_STS_SUCCESS;
1685:
1686: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1688: END IF;

Line 1702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calling PERFORM_LINE_CREATION procedure' );
1725: END IF;
1726:
1727: perform_line_creation(p_tax_lines_tbl,p_currency_tab,l_return_status);
1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1729: IF (g_level_exception >= g_current_runtime_level ) THEN
1730: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1731: END IF;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1729: IF (g_level_exception >= g_current_runtime_level ) THEN
1730: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1731: END IF;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1733: g_string :='Not compaitable to TAXWARE Release';
1734: error_exception_handle(g_string);
1735: return;
1736: END IF;

Line 1767: x_return_status := FND_API.G_RET_STS_SUCCESS;

1763: x_jurisdictions_found VARCHAR2(20);
1764: l_return_status VARCHAR2(30);
1765:
1766: BEGIN
1767: x_return_status := FND_API.G_RET_STS_SUCCESS;
1768:
1769: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1770: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1771: END IF;

Line 1783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1779: x_tax_jurisdiction_rec ,
1780: x_jurisdictions_found ,
1781: x_return_status
1782: );
1783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: IF (g_level_exception >= g_current_runtime_level ) THEN
1785: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1786: END IF;
1787: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: IF (g_level_exception >= g_current_runtime_level ) THEN
1785: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1786: END IF;
1787: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1788: g_string :='Not able to find Jurisdiction';
1789: error_exception_handle(g_string);
1790: RETURN;
1791: END IF;

Line 2980: x_return_status := FND_API.G_RET_STS_SUCCESS;

2976: l_return_status VARCHAR2(30);
2977: ind NUMBER;
2978: Begin
2979:
2980: x_return_status := FND_API.G_RET_STS_SUCCESS;
2981:
2982: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2983: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
2984: END IF;

Line 3678: x_return_status := FND_API.G_RET_STS_SUCCESS;

3674: l_mau number;
3675: l_rounding_rule varchar2(30);
3676: l_error_buffer varchar2(200);
3677: BEGIN
3678: x_return_status := FND_API.G_RET_STS_SUCCESS;
3679:
3680: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3681: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3682: END IF;

Line 3823: x_return_status := FND_API.G_RET_STS_ERROR; --13533328

3819: return_code := calculate_tax(l_TaxLink, l_JurLink, l_OraLink);
3820: input_param_flag := FALSE;
3821: dump_vendor_rec(l_TaxLink, l_JurLink, l_OraLink,input_param_flag);
3822: IF (return_code = FALSE) then
3823: x_return_status := FND_API.G_RET_STS_ERROR; --13533328
3824: g_string :='Failed in CALCULATE_TAX procedure';
3825: error_exception_handle(g_string);
3826: return;
3827: END IF;

Line 3829: x_return_status := FND_API.G_RET_STS_ERROR;

3825: error_exception_handle(g_string);
3826: return;
3827: END IF;
3828: else
3829: x_return_status := FND_API.G_RET_STS_ERROR;
3830: g_string :='Failed in SET_PRAMETERS procedure';
3831: error_exception_handle(g_string);
3832: return;
3833: end if;

Line 3872: x_return_status := FND_API.G_RET_STS_SUCCESS;

3868: l_TRX_LEVEL_TYPE varchar2(20);
3869:
3870: l_api_name CONSTANT VARCHAR2(30) := 'GET_DOC_AND_EXT_ATT_INFO';
3871: Begin
3872: x_return_status := FND_API.G_RET_STS_SUCCESS;
3873:
3874: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3875: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3876: END IF;

Line 3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3908: When no_data_found then
3909: IF (g_level_exception >= g_current_runtime_level ) THEN
3910: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3911: End if;
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913: g_string :='No data found in zx_lines_det_factors ';
3914: error_exception_handle(g_string);
3915: return;
3916: End;

Line 3939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3935: p_regime_code => p_regime_code,
3936: p_tax_provider_id => p_tax_provider_id,
3937: x_return_status => l_return_status);
3938:
3939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3940: IF (g_level_exception >= g_current_runtime_level ) THEN
3941: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3942: END IF;
3943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3940: IF (g_level_exception >= g_current_runtime_level ) THEN
3941: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3942: END IF;
3943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3944: g_string :='Not able to copy the line information :Failed with an exception';
3945: error_exception_handle(g_string);
3946: return;
3947: END IF;

Line 4012: x_return_status := FND_API.G_RET_STS_SUCCESS;

4008:
4009: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';
4010:
4011: BEGIN
4012: x_return_status := FND_API.G_RET_STS_SUCCESS;
4013:
4014: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4015: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
4016: END IF;

Line 4144: x_return_status := FND_API.G_RET_STS_SUCCESS;

4140: l_update_mode BOOLEAN; -- Added for Bug#12544630
4141:
4142:
4143: BEGIN
4144: x_return_status := FND_API.G_RET_STS_SUCCESS;
4145:
4146: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4147: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4148: END IF;

Line 4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4165: WHEN TOO_MANY_ROWS THEN
4166: IF (g_level_exception >= g_current_runtime_level ) THEN
4167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4168: End if;
4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4170: g_string :='More than one row exist at header level';
4171: error_exception_handle(g_string);
4172: RETURN;
4173: END;

Line 4333: x_return_status :=FND_API.G_RET_STS_ERROR;

4329: ELSE
4330: l_event_type := 'TAX_LINE_CREATE';
4331: END IF;
4332: ELSE
4333: x_return_status :=FND_API.G_RET_STS_ERROR;
4334: g_string := 'There were more than one tax/trx lines';
4335:
4336: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4337: FND_LOG.STRING(G_LEVEL_EXCEPTION,

Line 4359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4355: SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt),
4356: SYNC_TAX_LINES.trx_level_type(sync_tax_cnt),
4357: SYNC_TAX_LINES.country_code(sync_tax_cnt),
4358: 1,l_return_status);
4359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4360: IF (g_level_exception >= g_current_runtime_level ) THEN
4361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4362: END IF;
4363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4360: IF (g_level_exception >= g_current_runtime_level ) THEN
4361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4362: END IF;
4363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4364: g_string :='Failed in GET_DOC_AND_EXT_ATT_INFO procedure';
4365: error_exception_handle(g_string);
4366: RETURN;
4367: END IF;

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

4368: --END IF;
4369:
4370: IF (l_event_type='TAX_LINE_UPDATE') THEN
4371: /*Taxware does not have this feature*/
4372: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373: --g_string :='Unable to perform with Taxware';
4374: --error_exception_handle(g_string);
4375:
4376: IF l_neg_tax_line_count = 1 THEN

Line 4436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4432: populate_sync_tax_amts(sync_tax_cnt
4433: , sync_tax_lines.tax(sync_tax_cnt)
4434: , x_output_sync_tax_lines
4435: , x_return_status);
4436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4437: IF (g_level_exception >= g_current_runtime_level ) THEN
4438: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4439: END IF;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4437: IF (g_level_exception >= g_current_runtime_level ) THEN
4438: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4439: END IF;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4441: g_string :='Failed in populate_sync_tax_amts procedure';
4442: error_exception_handle(g_string);
4443: RETURN;
4444: END IF;

Line 4552: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

4548: ELSE
4549: l_event_type := 'TAX_LINE_CREATE';
4550: END IF;
4551: ELSE
4552: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
4553: g_string := 'There were more than one tax/trx lines';
4554: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4555: FND_LOG.STRING(G_LEVEL_EXCEPTION,
4556: G_MODULE_NAME||l_api_name,

Line 4608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4604: populate_sync_tax_amts(sync_tax_cnt1
4605: , sync_tax_lines.tax(sync_tax_cnt1)
4606: , x_output_sync_tax_lines
4607: , x_return_status);
4608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4609: IF (g_level_exception >= g_current_runtime_level ) THEN
4610: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4611: END IF;
4612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4609: IF (g_level_exception >= g_current_runtime_level ) THEN
4610: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4611: END IF;
4612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613: g_string :='Failed in populate_sync_tax_amts procedure';
4614: error_exception_handle(g_string);
4615: RETURN;
4616: END IF;

Line 4640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4636: WHEN TOO_MANY_ROWS THEN
4637: IF (g_level_exception >= g_current_runtime_level ) THEN
4638: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4639: End if;
4640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4641: g_string :='More than one row exist at header level';
4642: error_exception_handle(g_string);
4643: RETURN;
4644: WHEN OTHERS THEN

Line 4694: x_return_status := FND_API.G_RET_STS_SUCCESS;

4690: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4691: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
4692: END IF;
4693:
4694: x_return_status := FND_API.G_RET_STS_SUCCESS;
4695:
4696: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4697: BEGIN
4698: SELECT count(*)

Line 4842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4838: WHEN no_data_found THEN
4839: IF (g_level_exception >= g_current_runtime_level ) THEN
4840: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4841: End if;
4842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4843: g_string := 'No document type exist for provided event_class_mapping_id ';
4844: error_exception_handle(g_string);
4845: x_messages_tbl := g_messages_tbl;
4846: RETURN;

Line 4859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4855: WHEN no_data_found THEN
4856: IF (g_level_exception >= g_current_runtime_level ) THEN
4857: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4858: End if;
4859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4860: g_string := 'No document type exist for provided event_class_mapping_id ';
4861: error_exception_handle(g_string);
4862: x_messages_tbl := g_messages_tbl;
4863: RETURN;

Line 4881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4877: x_transaction_rec.transaction_id,
4878: l_doc_amount,
4879: l_return_status);
4880:
4881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4882: IF (g_level_exception >= g_current_runtime_level ) THEN
4883: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4884: END IF;
4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4882: IF (g_level_exception >= g_current_runtime_level ) THEN
4883: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4884: END IF;
4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4886: g_string :='Failed in setting up document type';
4887: error_exception_handle(g_string);
4888: x_messages_tbl:=g_messages_tbl;
4889: return;

Line 4896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4892: FOR cnt IN 1..nvl(pg_trx_line_id_tab.last, 0)
4893: LOOP
4894: I := cnt;
4895: perform_line_deletion(l_return_status);
4896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4897: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4898: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
4899: END IF;
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4897: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4898: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,SQLERRM);
4899: END IF;
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: g_string :='Failed in PERFORM_LINE_DELETION procedure';
4902: error_exception_handle(g_string);
4903: RETURN;
4904: END IF;