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

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
61: END IF;
62:
63: /*Set the return status to Success */
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX') THEN
68:

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

165: END IF;
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
171: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
172: END IF;
173: RETURN;

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
203: END IF;
204:
205: /*Set the return status to Success */
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: /* Storing of eBTax regimes in zx_trx_line_app_regimes table is expensive from performance and storage perspective
209: By not storing these regimes, we will not be able to handle scenario of eBTax to tax provider switch scenario */
210:

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
275: END IF;
276:
277: /*Set the return status to Success */
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.internal_organization_id(p_ptnr_tax_line_ind) := p_event_class_rec.internal_organization_id;
281: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.application_id(p_ptnr_tax_line_ind) := p_event_class_rec.application_id;
282: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.entity_code(p_ptnr_tax_line_ind) := p_event_class_rec.entity_code;

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

623: END IF;
624:
625: EXCEPTION
626: WHEN OTHERS THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
630: END IF;
631: RETURN;

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
657: END IF;
658:
659: --Set the return status to Success
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: FOR exemption_index IN ZX_PTNR_SRVC_INTGRTN_PKG.g_exemption_tbl.TAX.FIRST..
663: nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_exemption_tbl.TAX.LAST,0)
664: LOOP

Line 754: x_return_status := FND_API.G_RET_STS_SUCCESS;

750: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
751: END IF;
752:
753: /*Set the return status to Success */
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756: IF p_event = 'INSERT' THEN
757: FOR i IN nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.application_id.FIRST,0) .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.application_id.LAST,-1)
758: LOOP

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

819: fnd_global.conc_login_id
820: ) ;
821: EXCEPTION
822: WHEN OTHERS THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
826: END IF;
827: END;

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
868: END IF;
869: END trx_line_app_regimes_tbl_hdl;

Line 956: x_return_status := FND_API.G_RET_STS_SUCCESS;

952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
953: END IF;
954:
955: --Set the return status to Success
956: x_return_status := FND_API.G_RET_STS_SUCCESS;
957:
958: --Populate the product business group in the global variable - needed to determine the service provider
959: ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW := p_event_class_rec.prod_family_grp_code;
960:

Line 999: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

995: l_migrated_effective_to, -- Bug 5557565
996: l_migrated_country_code,
997: l_return_status
998: );
999: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1000: x_return_status := l_return_status;
1001: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1002: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1003: ' RETURN_STATUS = ' || x_return_status);

Line 1028: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1024: l_migrated_tax_provider_id,
1025: l_return_status
1026: );
1027:
1028: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: x_return_status := l_return_status;
1030: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1032: ' RETURN_STATUS = ' || x_return_status);

Line 1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_regime_code,
1057: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_provider_id,
1058: l_return_status
1059: );
1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: x_return_status := l_return_status;
1062: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1063: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1064: ' RETURN_STATUS = ' || x_return_status);

Line 1100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1096: l_migrated_country_code,
1097: l_return_status
1098: );
1099:
1100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1101: x_return_status := l_return_status;
1102: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1104: ' RETURN_STATUS = ' || x_return_status);

Line 1129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1125: l_migrated_tax_provider_id,
1126: l_return_status
1127: );
1128:
1129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1130: x_return_status := l_return_status;
1131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1133: ' RETURN_STATUS = ' || x_return_status);

Line 1161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1157: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_regime_code,
1158: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_provider_id,
1159: l_return_status
1160: );
1161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: x_return_status := l_return_status;
1163: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1164: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1165: ' RETURN_STATUS = ' || x_return_status);

Line 1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1188: ,l_provider_id
1189: ,l_return_status
1190: );
1191:
1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1193: x_return_status := l_return_status;
1194: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1196: ' RETURN_STATUS = ' || x_return_status);

Line 1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1212: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_regime_code,
1213: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_provider_id,
1214: l_return_status
1215: );
1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: x_return_status := l_return_status;
1218: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1220: ' RETURN_STATUS = ' || x_return_status);

Line 1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1235: ,l_provider_id
1236: ,l_return_status
1237: );
1238:
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: x_return_status := l_return_status;
1241: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1243: ' RETURN_STATUS = ' || x_return_status);

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1260: END IF;
1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1267: END IF;
1268: END popl_pvrdr_info_tax_reg_tbl;

Line 1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

1299: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1300: END IF;
1301:
1302: --Set the return status to Success
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1307: ' Application Id = ' || to_char(p_application_id) ||

Line 1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1388: END IF;
1389:
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1395: END IF;
1396: END get_service_provider;

Line 1430: x_return_status := FND_API.G_RET_STS_SUCCESS;

1426: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1427: END IF;
1428:
1429: --Set the return status to Success
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431:
1432: --Check service provider to call for import exemptions
1433: SELECT srvc.srvc_provider_id
1434: INTO x_provider_id

Line 1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1468: ' Tax Provider = eBTax' );
1469: END IF;
1470: WHEN OTHERS THEN
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1472: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1473: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1474: END IF;
1475: END get_service_provider;

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1525: END IF;
1526:
1527: --Set the return status to Success
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529:
1530: --Set the global variables
1531: ZX_TAX_PARTNER_PKG.G_TAX_REGIME_CODE := p_tax_regime_code;
1532: ZX_TAX_PARTNER_PKG.G_EVENT_CLASS_REC := p_event_class_rec;

Line 1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1580: ,l_data_transfer_mode
1581: ,l_return_status
1582: );
1583:
1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1585: x_return_status := l_return_status;
1586: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1588: ' RETURN_STATUS = ' || x_return_status);

Line 1594: x_return_status := FND_API.G_RET_STS_ERROR ;

1590: RETURN;
1591: END IF;
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: x_return_status := FND_API.G_RET_STS_ERROR ;
1595: IF p_provider_id = 1 THEN
1596: l_service_provider := 'VERTEX';
1597: ELSIF p_provider_id = 2 THEN
1598: l_service_provider := 'TAXWARE';

Line 1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1700: END IF;
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1707: END IF;
1708: END derive_ext_attrs;

Line 1758: x_return_status := FND_API.G_RET_STS_SUCCESS;

1754: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1755: END IF;
1756:
1757: --Set the return status to Success
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: IF p_tax_provider_id is NULL THEN
1761:
1762: get_service_provider (p_event_class_rec.application_id

Line 1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1766: ,l_tax_provider_id
1767: ,l_return_status
1768: );
1769:
1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: x_return_status := l_return_status;
1772: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1774: ' RETURN_STATUS = ' || x_return_status);

Line 2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2008: EXCEPTION
2009: WHEN NO_DATA_FOUND THEN
2010: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).partner_processing_flag := 'F';
2011: WHEN OTHERS THEN
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2013: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2015: END IF;
2016: END partner_pre_processing;

Line 2087: x_return_status := FND_API.G_RET_STS_SUCCESS;

2083: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2084: END IF;
2085:
2086: --Set the return status to Success
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088:
2089: BEGIN
2090: SELECT reg.service_type_id,
2091: reg.context_ccid

Line 2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes

2101: AND reg.api_owner_id = p_tax_provider_id
2102: AND srvc.service_type_id = reg.service_type_id
2103: AND srvc.service_type_code = p_service_type_code;
2104: EXCEPTION WHEN OTHERS THEN
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
2106: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2107: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2108: ' The Partner Service '|| p_service_type_code || ' is not registered for ' ||
2109: p_event_class_rec.prod_family_grp_code || ',' || p_tax_regime_code ||

Line 2139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2135: p_return_status => l_return_status,
2136: p_error_buffer => l_error_buffer,
2137: p_trx_conversion_date => doc_curr.trx_date); --Bug7183884
2138:
2139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2140: x_return_status := l_return_status;
2141: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2143: ' RETURN_STATUS = ' || x_return_status);

Line 2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2207: l_context_ccid ,
2208: 'PLS',
2209: l_return_status
2210: );
2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2212: x_return_status := l_return_status;
2213: l_prev_trx_id := -99;
2214:
2215: FOR er_index IN NVL(ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING.FIRST,1) ..

Line 2262: x_return_status := FND_API.G_RET_STS_ERROR;

2258: END IF;
2259:
2260: EXCEPTION
2261: WHEN OTHERS THEN
2262: x_return_status := FND_API.G_RET_STS_ERROR;
2263: FOR er_index IN NVL(ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING.FIRST,1) ..
2264: NVL(ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING.LAST,0)
2265: LOOP
2266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2370: x_return_status := FND_API.G_RET_STS_SUCCESS;

2366: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2367: END IF;
2368:
2369: --Set the return status to Success
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;
2371:
2372: -- Bug#5417753- determine tax_class value
2373: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
2374: l_tax_class := 'OUTPUT';

Line 2410: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2406: p_trx_level_type => null,
2407: x_return_status => l_return_status
2408: );
2409:
2410: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2411: x_return_status := l_return_status;
2412: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2414: ' RETURN_STATUS = ' || x_return_status);

Line 2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --tax returned by partner is not amongst candidate taxes

2480: ORDER BY subscription_level_code; -- Bug#5395227
2481:
2482: EXCEPTION
2483: WHEN NO_DATA_FOUND THEN
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --tax returned by partner is not amongst candidate taxes
2485: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'Tax returned by the tax partner is invalid');
2487: END IF;
2488: RETURN;

Line 2496: l_return_status := FND_API.G_RET_STS_SUCCESS;

2492:
2493: -- Bug#5395227- replace above code
2494:
2495: l_tax_rec := NULL;
2496: l_return_status := FND_API.G_RET_STS_SUCCESS;
2497:
2498: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2499: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2500: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),

Line 2506: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2502: l_tax_rec,
2503: l_return_status,
2504: l_error_buffer);
2505:
2506: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2507: l_tax_precision := l_tax_rec.tax_precision;
2508: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.minimum_accountable_unit(ptnr_tax_line_index) := l_tax_rec.minimum_accountable_unit;
2509: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rounding_rule_code(ptnr_tax_line_index) := l_tax_rec.rounding_rule_code;
2510: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_id(ptnr_tax_line_index) := l_tax_rec.tax_id;

Line 2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes

2530: FOR i IN ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl.FIRST.. nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl.LAST,0)
2531: LOOP
2532: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl(i).tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index) THEN
2533: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl(i).tax_currency_precision > l_tax_precision THEN -- Bug 5288518
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
2535: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2536: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,
2537: ' Precision returned by the tax partner is invalid ');
2538: END IF;

Line 2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner cannot be inclusive

2564: AND trx_level_type = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(ptnr_tax_line_index);
2565: END;
2566:
2567: IF l_app_regimes > 1 THEN
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner cannot be inclusive
2569: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2571: ' Returned tax line for multiple regimes by the tax partner is invalid ' || x_return_status);
2572: END IF;

Line 2722: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2718: l_tax_rec,
2719: l_return_status,
2720: l_error_buffer);
2721:
2722: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2723: IF (g_level_statement >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2725: 'Incorrect return_status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info for tax '
2726: || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)

Line 2818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2814: );
2815:
2816: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.party_tax_reg_number(ptnr_tax_line_index) := l_registration_rec.registration_number;
2817:
2818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2819: null; --ok if not first party tax registration registration number is not found
2820: END IF;
2821: */
2822: END LOOP; --looping over the tax lines

Line 3092: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3088: p_trx_level_type => null,
3089: x_return_status => l_return_status
3090: );
3091:
3092: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3093: x_return_status := l_return_status;
3094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3095: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3096: ' RETURN_STATUS = ' || x_return_status);

Line 3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3110: END IF;
3111:
3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3116: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3117: END IF;
3118: END ptnr_post_processing_calc_tax;

Line 3155: x_return_status := FND_API.G_RET_STS_SUCCESS;

3151: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3152: END IF;
3153:
3154: --Set the return status to Success
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156:
3157: /* Bug 4908196: Following assumption is true for tax partner integration.
3158: If partner needs to return more than one tax line of the same tax, the tax line with different situs will be sent. */
3159:

Line 3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax rate cannot be modified

3184: WHERE tax_line_id = l_tax_line_id;
3185: END IF;
3186: ELSIF l_last_manual_entry = 'TAX_RATE' THEN
3187: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage is not null THEN
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax rate cannot be modified
3189: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');
3191: END IF;
3192: ELSIF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN

Line 3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3217: END IF;
3218:
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3222: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3223: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3224: END IF;
3225: END ptnr_post_proc_sync_tax;