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 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

123: END IF;
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
129: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
130: END IF;
131: RETURN;

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
161: END IF;
162:
163: /*Set the return status to Success */
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: /* Storing of eBTax regimes in zx_trx_line_app_regimes table is expensive from performance and storage perspective
167: By not storing these regimes, we will not be able to handle scenario of eBTax to tax provider switch scenario */
168:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
233: END IF;
234:
235: /*Set the return status to Success */
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: 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;
239: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.application_id(p_ptnr_tax_line_ind) := p_event_class_rec.application_id;
240: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.entity_code(p_ptnr_tax_line_ind) := p_event_class_rec.entity_code;

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

504: END IF;
505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
511: END IF;
512: RETURN;

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
538: END IF;
539:
540: --Set the return status to Success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: FOR exemption_index IN ZX_PTNR_SRVC_INTGRTN_PKG.g_exemption_tbl.TAX.FIRST..
544: nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_exemption_tbl.TAX.LAST,0)
545: LOOP

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
632: END IF;
633:
634: /*Set the return status to Success */
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: IF p_event = 'INSERT' THEN
638: 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)
639: LOOP

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

700: fnd_global.conc_login_id
701: ) ;
702: EXCEPTION
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
705: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
706: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
707: END IF;
708: END;

Line 746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

742: END IF;
743:
744: EXCEPTION
745: WHEN OTHERS THEN
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
747: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
748: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
749: END IF;
750: END trx_line_app_regimes_tbl_hdl;

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
834: END IF;
835:
836: --Set the return status to Success
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: --Populate the product business group in the global variable - needed to determine the service provider
840: ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW := p_event_class_rec.prod_family_grp_code;
841:

Line 880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

876: l_migrated_effective_to, -- Bug 5557565
877: l_migrated_country_code,
878: l_return_status
879: );
880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
881: x_return_status := l_return_status;
882: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
884: ' RETURN_STATUS = ' || x_return_status);

Line 908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

904: l_migrated_tax_provider_id,
905: l_return_status
906: );
907:
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
909: x_return_status := FND_API.G_RET_STS_ERROR;
910: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
912: ' RETURN_STATUS = ' || x_return_status);

Line 909: x_return_status := FND_API.G_RET_STS_ERROR;

905: l_return_status
906: );
907:
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
909: x_return_status := FND_API.G_RET_STS_ERROR;
910: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
912: ' RETURN_STATUS = ' || x_return_status);
913: END IF;

Line 940: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

936: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_regime_code,
937: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_provider_id,
938: l_return_status
939: );
940: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
941: x_return_status := l_return_status;
942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
943: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
944: ' RETURN_STATUS = ' || x_return_status);

Line 981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

977: l_migrated_country_code,
978: l_return_status
979: );
980:
981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
982: x_return_status := l_return_status;
983: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
984: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
985: ' RETURN_STATUS = ' || x_return_status);

Line 1009: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1005: l_migrated_tax_provider_id,
1006: l_return_status
1007: );
1008:
1009: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1010: x_return_status := l_return_status;
1011: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1012: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1013: ' RETURN_STATUS = ' || x_return_status);

Line 1041: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1037: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_regime_code,
1038: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_provider_id,
1039: l_return_status
1040: );
1041: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1042: x_return_status := l_return_status;
1043: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1044: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1045: ' RETURN_STATUS = ' || x_return_status);

Line 1073: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1069: ,l_provider_id
1070: ,l_return_status
1071: );
1072:
1073: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1074: x_return_status := l_return_status;
1075: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1077: ' RETURN_STATUS = ' || x_return_status);

Line 1097: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1093: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_regime_code,
1094: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_provider_id,
1095: l_return_status
1096: );
1097: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1100: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1101: ' RETURN_STATUS = ' || x_return_status);

Line 1098: x_return_status := FND_API.G_RET_STS_ERROR;

1094: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(l_tax_regime_id).tax_provider_id,
1095: l_return_status
1096: );
1097: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1100: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1101: ' RETURN_STATUS = ' || x_return_status);
1102: END IF;

Line 1120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1116: ,l_provider_id
1117: ,l_return_status
1118: );
1119:
1120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1121: x_return_status := l_return_status;
1122: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1123: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1124: ' RETURN_STATUS = ' || x_return_status);

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1141: END IF;
1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1147: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1148: END IF;
1149: END popl_pvrdr_info_tax_reg_tbl;

Line 1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1181: END IF;
1182:
1183: --Set the return status to Success
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1187: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1188: ' Application Id = ' || to_char(p_application_id) ||

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1298: END IF;
1299:
1300: --Set the return status to Success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: --Check service provider to call for import exemptions
1304: SELECT srvc.srvc_provider_id
1305: INTO x_provider_id

Line 1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1339: ' Tax Provider = eBTax' );
1340: END IF;
1341: WHEN OTHERS THEN
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1343: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1344: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1345: END IF;
1346: END get_service_provider;

Line 1389: x_return_status := FND_API.G_RET_STS_SUCCESS;

1385: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1386: END IF;
1387:
1388: --Set the return status to Success
1389: x_return_status := FND_API.G_RET_STS_SUCCESS;
1390:
1391: --Set the global variables
1392: ZX_TAX_PARTNER_PKG.G_TAX_REGIME_CODE := p_tax_regime_code;
1393: ZX_TAX_PARTNER_PKG.G_EVENT_CLASS_REC := p_event_class_rec;

Line 1445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1441: ,l_data_transfer_mode
1442: ,l_return_status
1443: );
1444:
1445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: x_return_status := l_return_status;
1447: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1449: ' RETURN_STATUS = ' || x_return_status);

Line 1455: x_return_status := FND_API.G_RET_STS_ERROR ;

1451: RETURN;
1452: END IF;
1453: EXCEPTION
1454: WHEN OTHERS THEN
1455: x_return_status := FND_API.G_RET_STS_ERROR ;
1456: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1457: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1458: END IF;
1459: FND_MESSAGE.SET_NAME('ZX','ZX_PTNR_SERVICE_REQD');

Line 1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1550: END IF;
1551:
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1555: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1556: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1557: END IF;
1558: END derive_ext_attrs;

Line 1608: x_return_status := FND_API.G_RET_STS_SUCCESS;

1604: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1605: END IF;
1606:
1607: --Set the return status to Success
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: IF p_tax_provider_id is NULL THEN
1611:
1612: get_service_provider (p_event_class_rec.application_id

Line 1620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1616: ,l_tax_provider_id
1617: ,l_return_status
1618: );
1619:
1620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: x_return_status := l_return_status;
1622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1624: ' RETURN_STATUS = ' || x_return_status);

Line 1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1847: EXCEPTION
1848: WHEN NO_DATA_FOUND THEN
1849: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).partner_processing_flag := 'F';
1850: WHEN OTHERS THEN
1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1852: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1853: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1854: END IF;
1855: END partner_pre_processing;

Line 1917: x_return_status := FND_API.G_RET_STS_SUCCESS;

1913: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1914: END IF;
1915:
1916: --Set the return status to Success
1917: x_return_status := FND_API.G_RET_STS_SUCCESS;
1918:
1919: BEGIN
1920: SELECT reg.service_type_id,
1921: reg.context_ccid

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

1932: AND srvc.service_type_id = reg.service_type_id
1933: AND srvc.service_type_code = p_service_type_code;
1934: EXCEPTION WHEN OTHERS THEN
1935: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
1937: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1938: ' The Partner Service '|| p_service_type_code || ' is not registered for ' ||
1939: p_event_class_rec.prod_family_grp_code || ',' || p_tax_regime_code ||
1940: ', and provider ' || p_tax_provider_id);

Line 1966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1962: p_return_status => l_return_status,
1963: p_error_buffer => l_error_buffer,
1964: p_trx_conversion_date => ZX_SECURITY.G_EFFECTIVE_DATE); --Bug7183884
1965:
1966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1967: x_return_status := l_return_status;
1968: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1970: ' RETURN_STATUS = ' || x_return_status);

Line 2003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1999: l_context_ccid ,
2000: 'PLS',
2001: l_return_status
2002: );
2003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2004: x_return_status := l_return_status;
2005: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2006: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2007: ' RETURN_STATUS = ' || x_return_status);

Line 2019: x_return_status := FND_API.G_RET_STS_ERROR; --partner service not registered

2015: END IF;
2016:
2017: EXCEPTION
2018: WHEN NO_DATA_FOUND THEN
2019: x_return_status := FND_API.G_RET_STS_ERROR; --partner service not registered
2020: FND_MESSAGE.SET_NAME('ZX','ZX_PTNR_SERVICE_REQD');
2021: l_context_info_rec.APPLICATION_ID := p_event_class_rec.application_id;
2022: l_context_info_rec.ENTITY_CODE := p_event_class_rec.entity_code;
2023: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.event_class_code;

Line 2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2023: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.event_class_code;
2024: l_context_info_rec.TRX_ID := p_event_class_rec.trx_id;
2025: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
2026: WHEN OTHERS THEN
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2030: END IF;
2031: RETURN;

Line 2122: x_return_status := FND_API.G_RET_STS_SUCCESS;

2118: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2119: END IF;
2120:
2121: --Set the return status to Success
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;
2123:
2124: -- Bug#5417753- determine tax_class value
2125: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
2126: l_tax_class := 'OUTPUT';

Line 2167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2163: p_trx_level_type => null,
2164: x_return_status => l_return_status
2165: );
2166:
2167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2168: x_return_status := l_return_status;
2169: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2171: ' RETURN_STATUS = ' || x_return_status);

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

2211: ORDER BY subscription_level_code; -- Bug#5395227
2212:
2213: EXCEPTION
2214: WHEN NO_DATA_FOUND THEN
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --tax returned by partner is not amongst candidate taxes
2216: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2217: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'Tax returned by the tax partner is invalid');
2218: END IF;
2219: RETURN;

Line 2227: l_return_status := FND_API.G_RET_STS_SUCCESS;

2223:
2224: -- Bug#5395227- replace above code
2225:
2226: l_tax_rec := NULL;
2227: l_return_status := FND_API.G_RET_STS_SUCCESS;
2228:
2229: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2230: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index),
2231: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index),

Line 2237: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2233: l_tax_rec,
2234: l_return_status,
2235: l_error_buffer);
2236:
2237: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2238: l_tax_precision := l_tax_rec.tax_precision;
2239: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.minimum_accountable_unit(ptnr_tax_line_index) := l_tax_rec.minimum_accountable_unit;
2240: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rounding_rule_code(ptnr_tax_line_index) := l_tax_rec.rounding_rule_code;
2241: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_id(ptnr_tax_line_index) := l_tax_rec.tax_id;

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

2261: 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)
2262: LOOP
2263: 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
2264: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl(i).tax_currency_precision > l_tax_precision THEN -- Bug 5288518
2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
2266: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,
2268: ' Precision returned by the tax partner is invalid ');
2269: END IF;

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

2295: AND trx_level_type = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(ptnr_tax_line_index);
2296: END;
2297:
2298: IF l_app_regimes > 1 THEN
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner cannot be inclusive
2300: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2302: ' Returned tax line for multiple regimes by the tax partner is invalid ' || x_return_status);
2303: END IF;

Line 2352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2348: l_tax_rec,
2349: l_return_status,
2350: l_error_buffer);
2351:
2352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2353: IF (g_level_statement >= g_current_runtime_level ) THEN
2354: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2355: 'Incorrect return_status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info for tax '
2356: || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)

Line 2539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2535: );
2536:
2537: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.party_tax_reg_number(ptnr_tax_line_index) := l_registration_rec.registration_number;
2538:
2539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2540: null; --ok if not first party tax registration registration number is not found
2541: END IF;
2542: */
2543: END LOOP; --looping over the tax lines

Line 2798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2794: p_trx_level_type => null,
2795: x_return_status => l_return_status
2796: );
2797:
2798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2799: x_return_status := l_return_status;
2800: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2802: ' RETURN_STATUS = ' || x_return_status);

Line 2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2815: END IF;
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2820: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2822: END IF;
2823: END ptnr_post_processing_calc_tax;

Line 2860: x_return_status := FND_API.G_RET_STS_SUCCESS;

2856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2857: END IF;
2858:
2859: --Set the return status to Success
2860: x_return_status := FND_API.G_RET_STS_SUCCESS;
2861:
2862: /* Bug 4908196: Following assumption is true for tax partner integration.
2863: If partner needs to return more than one tax line of the same tax, the tax line with different situs will be sent. */
2864:

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

2889: WHERE tax_line_id = l_tax_line_id;
2890: END IF;
2891: ELSIF l_last_manual_entry = 'TAX_RATE' THEN
2892: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage is not null THEN
2893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax rate cannot be modified
2894: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');
2896: END IF;
2897: ELSIF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN

Line 2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2922: END IF;
2923:
2924: EXCEPTION
2925: WHEN OTHERS THEN
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2927: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2928: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2929: END IF;
2930: END ptnr_post_proc_sync_tax;