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

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.initialize.BEGIN',
333: 'ZX_PRODUCT_INTEGRATION_PKG: initialize (+)');
334: END IF;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: -- l_debug_flag := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
338:
339: -- IF L_DEBUG_FLAG <> PG_DEBUG THEN
340: -- FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calling initialize ....');

Line 350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

346: x_return_status
347: );
348:
349:
350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
352: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
353: END IF;
354: RETURN;

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378:
379: IF (g_level_event >= g_current_runtime_level) THEN
380: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
381: END IF;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
385: ZX_API_PUB.add_msg(
386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122: END IF;
1123:
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1128: FND_LOG.STRING(g_level_unexpected,
1129: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.initialize',
1130: SQLCODE || ' ; ' || SQLERRM);

Line 1176: x_return_status := FND_API.G_RET_STS_SUCCESS;

1172: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax.BEGIN',
1173: 'ZX_PRODUCT_INTEGRATION_PKG: calculate_tax (+)');
1174: END IF;
1175:
1176: x_return_status := FND_API.G_RET_STS_SUCCESS;
1177:
1178: -- adjustment is not supported for LTE tax method
1179: IF p_event_class_rec.event_class_code = 'ADJUSTMENT' THEN
1180: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1198: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1194: x_return_status => x_return_status
1195: );
1196:
1197:
1198: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1199: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1200: FND_LOG.STRING(g_level_unexpected,
1201: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1202: 'Incorrect return_status after calling ' ||

Line 1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1306: p_event_class_rec ,
1307: 'LINE' ,
1308: x_return_status );
1309:
1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1311: IF (g_level_procedure >= g_current_runtime_level ) THEN
1312: FND_LOG.STRING(g_level_procedure,
1313: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1314: 'Incorrect return_status when calling '||

Line 1354: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1350: p_event_class_rec => p_event_class_rec,
1351: p_index => l_index,
1352: x_return_status => x_return_status);
1353:
1354: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1355: IF (g_level_statement >= g_current_runtime_level ) THEN
1356: FND_LOG.STRING(g_level_statement,
1357: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1358: 'Incorrect RETURN_STATUS after calling '||

Line 1376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1372: p_event_class_rec => p_event_class_rec,
1373: p_index => l_index,
1374: x_return_status => x_return_status);
1375:
1376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1377: IF (g_level_statement >= g_current_runtime_level ) THEN
1378: FND_LOG.STRING(g_level_statement,
1379: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1380: 'Incorrect return_status after calling ' ||

Line 1414: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1410: p_id_dist_tbl => l_index,
1411: x_return_status => x_return_status
1412: );
1413:
1414: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1415: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1416: FND_LOG.STRING(g_level_unexpected,
1417: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1418: 'Errored out when calculate tax.');

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: END IF;
1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_unexpected,
1446: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1447: SQLCODE || ' ; ' || SQLERRM);

Line 1493: x_return_status := FND_API.G_RET_STS_SUCCESS;

1489: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax.BEGIN',
1490: 'ZX_PRODUCT_INTEGRATION_PKG: import_document_with_tax (+)');
1491: END IF;
1492:
1493: x_return_status := FND_API.G_RET_STS_SUCCESS;
1494:
1495: -- adjustment is not supported for LTE tax method
1496: IF p_event_class_rec.event_class_code = 'ADJUSTMENT' THEN
1497: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1513: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1509: initialize (
1510: p_event_class_rec => p_event_class_rec,
1511: x_return_status => x_return_status
1512: );
1513: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1514: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1515: FND_LOG.STRING(g_level_unexpected,
1516: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1517: 'Incorrect return_status after calling ' ||

Line 1632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1628: p_event_class_rec ,
1629: 'LINE' ,
1630: x_return_status );
1631:
1632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1633: IF (g_level_procedure >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_procedure,
1635: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1636: 'Incorrect return_status when calling '||

Line 1659: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1655: p_id_dist_tbl => l_index,
1656: x_return_status => x_return_status
1657: );
1658:
1659: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1660: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1661: FND_LOG.STRING(g_level_unexpected,
1662: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1663: 'Errored out when calling import_trx_line_with_taxes().');

Line 1681: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1677: p_event_class_rec ,
1678: 'LINE' ,
1679: x_return_status );
1680:
1681: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1682: IF (g_level_procedure >= g_current_runtime_level ) THEN
1683: FND_LOG.STRING(g_level_procedure,
1684: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1685: 'Incorrect return_status when calling '||

Line 1702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1698: p_event_class_rec => p_event_class_rec,
1699: p_index => l_index,
1700: x_return_status => x_return_status);
1701:
1702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1703: IF (g_level_statement >= g_current_runtime_level ) THEN
1704: FND_LOG.STRING(g_level_statement,
1705: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1706: 'Incorrect return_status after calling ' ||

Line 1738: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1734: p_id_dist_tbl => l_index,
1735: x_return_status => x_return_status
1736: );
1737:
1738: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1739: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1740: FND_LOG.STRING(g_level_unexpected,
1741: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1742: 'Incorrect return_status after calling ' ||

Line 1756: x_return_status := FND_API.G_RET_STS_ERROR;

1752: END IF;
1753:
1754: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1755:
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1758: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1759: ZX_API_PUB.add_msg(
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1758: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1759: ZX_API_PUB.add_msg(
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1761:
1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1763: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1764: FND_LOG.STRING(g_level_unexpected,
1765: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1766: 'Transaction line level action can only be CREATE or CREATE_WITH_TAX.');

Line 1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1792: END IF;
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1798: FND_LOG.STRING(g_level_unexpected,
1799: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1800: SQLCODE || ' ; ' || SQLERRM);

Line 1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

1893: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes.BEGIN',
1894: 'ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes(+)');
1895: END IF;
1896:
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898:
1899: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);
1900:
1901: FOR tax_line_rec IN get_detail_tax_lines_csr LOOP

Line 1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1912: p_id_dist_tbl => p_id_dist_tbl,
1913: p_new_row_num => l_new_row_num,
1914: x_return_status => x_return_status);
1915:
1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1917: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_unexpected,
1919: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1920: 'Incorrect return_status after calling '||

Line 1964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1960: l_begin_index,
1961: l_end_index,
1962: x_return_status,
1963: l_error_buffer);
1964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1965: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1966: FND_LOG.STRING(g_level_unexpected,
1967: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1968: 'Incorrect return_status after calling ' ||

Line 2003: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1999: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST >= C_LINES_PER_INSERT) THEN
2000:
2001: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
2002:
2003: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_unexpected,
2006: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
2007: 'Incorrect return_status after calling ' ||

Line 2025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2021: END IF;
2022:
2023: EXCEPTION
2024: WHEN OTHERS THEN
2025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2026: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2027: FND_LOG.STRING(g_level_unexpected,
2028: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
2029: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 2149: x_return_status := FND_API.G_RET_STS_SUCCESS;

2145: FND_LOG.STRING(g_level_procedure,
2146: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte.BEGIN',
2147: 'ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte(+)');
2148: END IF;
2149: x_return_status := FND_API.G_RET_STS_SUCCESS;
2150:
2151: INITIALIZE_TAX_INFO_REC;
2152:
2153: -- Bug#6936808: init exception code returned from LTE

Line 2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2378: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST >= C_LINES_PER_INSERT) THEN
2379:
2380: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
2381:
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2384: FND_LOG.STRING(g_level_unexpected,
2385: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte',
2386: 'Incorrect return_status after calling ' ||

Line 2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2404:
2405: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
2406:
2407:
2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2409: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2410: FND_LOG.STRING(g_level_unexpected,
2411: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte',
2412: 'Incorrect return_status after calling ' ||

Line 2447: x_return_status := FND_API.G_RET_STS_ERROR;

2443: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte',
2444: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 512));
2445: END IF;
2446: IF JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type = 'E' THEN
2447: x_return_status := FND_API.G_RET_STS_ERROR;
2448: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2449: ELSE
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2446: IF JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type = 'E' THEN
2447: x_return_status := FND_API.G_RET_STS_ERROR;
2448: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2449: ELSE
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2452: END IF;
2453:
2454: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4823: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4819: l_tax_regime_rec,
4820: l_return_status,
4821: l_error_buffer);
4822:
4823: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4825: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
4826:
4827: ELSE

Line 4861: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4857: x_tax_rec => l_tax_rec,
4858: p_return_status => l_return_status,
4859: p_error_buffer => l_error_buffer);
4860:
4861: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4862: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_id := l_tax_Rec.TAX_id;
4863:
4864: IF l_tax_rec.Def_Place_Of_Supply_Type_Code = 'SHIP_TO_BILL_TO' then
4865: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).PLACE_OF_SUPPLY_TYPE_CODE := 'SHIP_TO';

Line 4908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4904:
4905: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_jurisdiction_id
4906: := l_tax_jurisdiction_rec.tax_jurisdiction_id;
4907:
4908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4909: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4910: FND_LOG.STRING(g_level_unexpected,
4911: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4912: 'Incorrect return_status after calling ' ||

Line 4941: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4937: l_tax_status_rec,
4938: l_return_status,
4939: l_error_buffer);
4940:
4941: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4942: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4943: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
4944: ELSE
4945: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 4977: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4973: p_tax_rate_rec => l_tax_rate_rec,
4974: p_return_status => l_return_status,
4975: p_error_buffer => l_error_buffer);
4976:
4977: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).TAXABLE_BASIS_FORMULA
4979: := NVL(l_tax_rate_rec.taxable_basis_formula_code, l_tax_rec.def_taxable_basis_formula);
4980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).TAX_CALCULATION_FORMULA
4981: := l_tax_rec.def_tax_calc_formula;

Line 5187: x_return_status := FND_API.G_RET_STS_SUCCESS;

5183: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5184: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
5185: END IF;
5186:
5187: x_return_status := FND_API.G_RET_STS_SUCCESS;
5188:
5189: -- get tax date
5190: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(
5191: p_id_dist_tbl,

Line 5197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5193: l_tax_determine_date,
5194: l_tax_point_date,
5195: x_return_status);
5196:
5197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5198: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5199: FND_LOG.STRING(g_level_unexpected,
5200: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5201: 'Incorrect return_status after calling ' ||

Line 5221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5217: l_tax_regime_rec,
5218: x_return_status,
5219: l_error_buffer);
5220:
5221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5222: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5223: FND_LOG.STRING(g_level_unexpected,
5224: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5225: 'Incorrect return_status after calling ' ||

Line 5247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5243: l_tax_rec,
5244: x_return_status,
5245: l_error_buffer);
5246:
5247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5248: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5249: FND_LOG.STRING(g_level_unexpected,
5250: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5251: 'Incorrect return_status after calling ' ||

Line 5274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5270: x_jurisdiction_rec => l_tax_jurisdiction_rec,
5271: p_return_status => l_return_status,
5272: p_error_buffer => l_error_buffer);
5273:
5274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5276: FND_LOG.STRING(g_level_unexpected,
5277: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5278: 'Incorrect return_status after calling ' ||

Line 5302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5298: l_tax_status_rec,
5299: x_return_status,
5300: l_error_buffer);
5301:
5302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5303: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5304: FND_LOG.STRING(g_level_unexpected,
5305: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
5306: 'Incorrect return_status after calling ' ||

Line 5489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5485: END IF;
5486:
5487: EXCEPTION
5488: WHEN OTHERS THEN
5489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5490:
5491: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5492: FND_LOG.STRING(g_level_unexpected,
5493: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',

Line 5569: x_return_status := FND_API.G_RET_STS_SUCCESS;

5565: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_tax_rate_id',
5566: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
5567:
5568: END IF;
5569: x_return_status := FND_API.G_RET_STS_SUCCESS;
5570:
5571: /* Bug#5395227- use cache structure
5572: OPEN fetch_tax_rate_id;
5573: FETCH fetch_tax_rate_id INTO x_tax_rate_id;

Line 5592: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5588: x_error_buffer);
5589:
5590: */
5591:
5592: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5593: x_tax_rate_id := l_tax_rate_rec.tax_rate_id;
5594: END IF;
5595:
5596: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5606: END IF;
5607:
5608: EXCEPTION
5609: WHEN OTHERS THEN
5610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5611: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5612: FND_LOG.STRING(g_level_unexpected,
5613: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_tax_rate_id',
5614: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 6655: x_return_status := FND_API.G_RET_STS_SUCCESS;

6651: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines.BEGIN',
6652: 'ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines(+)');
6653: END IF;
6654:
6655: x_return_status := FND_API.G_RET_STS_SUCCESS;
6656:
6657: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
6658: l_tax_class := 'OUTPUT';
6659: ELSIF p_event_class_rec.prod_family_grp_code = 'P2P' THEN

Line 6673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6669: l_tax_determine_date,
6670: l_tax_point_date,
6671: x_return_status);
6672:
6673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6674: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6675: FND_LOG.STRING(g_level_unexpected,
6676: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6677: 'Incorrect return_status after calling ' ||

Line 6710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6706: l_tax_regime_rec,
6707: x_return_status,
6708: l_error_buffer);
6709:
6710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6711: IF (g_level_statement >= g_current_runtime_level ) THEN
6712: FND_LOG.STRING(g_level_statement,
6713: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6714: 'Incorrect return_status after calling ' ||

Line 6737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6733: l_tax_rec,
6734: x_return_status,
6735: l_error_buffer);
6736:
6737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6738: IF (g_level_statement >= g_current_runtime_level ) THEN
6739: FND_LOG.STRING(g_level_statement,
6740: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6741: 'Incorrect return_status after calling ' ||

Line 6765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6761: l_tax_status_rec,
6762: x_return_status,
6763: l_error_buffer);
6764:
6765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6766: IF (g_level_statement >= g_current_runtime_level ) THEN
6767: FND_LOG.STRING(g_level_statement,
6768: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6769: 'Incorrect return_status after calling ' ||

Line 6796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6792: l_tax_rate_rec,
6793: x_return_status,
6794: l_error_buffer);
6795:
6796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6797: IF (g_level_statement >= g_current_runtime_level ) THEN
6798: FND_LOG.STRING(g_level_statement,
6799: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6800: 'Incorrect return_status after calling ' ||

Line 6851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6847: l_end_index,
6848: x_return_status,
6849: l_error_buffer );
6850:
6851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6852: IF (g_level_statement >= g_current_runtime_level ) THEN
6853: FND_LOG.STRING(g_level_statement,
6854: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6855: 'Incorrect RETURN_STATUS after calling '||

Line 6875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6871: END IF;
6872:
6873: EXCEPTION
6874: WHEN OTHERS THEN
6875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6876:
6877: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6878: FND_LOG.STRING(g_level_unexpected,
6879: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',

Line 6938: x_return_status := FND_API.G_RET_STS_SUCCESS;

6934: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm.BEGIN',
6935: 'ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm(+)');
6936: END IF;
6937:
6938: x_return_status := FND_API.G_RET_STS_SUCCESS;
6939:
6940: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
6941:
6942: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6956: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6952: l_tax_determine_date,
6953: l_tax_point_date,
6954: x_return_status);
6955:
6956: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6957: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6958: FND_LOG.STRING(g_level_unexpected,
6959: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
6960: 'Incorrect return_status after calling ' ||

Line 6980: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6976: p_tax_id => tax_line_rec.TAX_ID,
6977: p_return_status => x_return_status,
6978: p_error_buffer => l_error_buffer);
6979:
6980: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6981: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6982: FND_LOG.STRING(g_level_unexpected,
6983: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
6984: 'Incorrect return_status after calling ' ||

Line 7303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7299: p_end_index => l_end_index,
7300: p_return_status => x_return_status ,
7301: p_error_buffer => l_error_buffer );
7302:
7303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7304: IF (g_level_statement >= g_current_runtime_level ) THEN
7305: FND_LOG.STRING(g_level_statement,
7306: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
7307: 'Incorrect return_status after calling ' ||

Line 7325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7321: p_end_index => l_end_index,
7322: p_return_status => x_return_status ,
7323: p_error_buffer => l_error_buffer );
7324:
7325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7326: IF (g_level_statement >= g_current_runtime_level ) THEN
7327: FND_LOG.STRING(g_level_statement,
7328: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
7329: 'Incorrect return_status after calling ' ||

Line 7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7345: END IF;
7346:
7347: EXCEPTION
7348: WHEN OTHERS THEN
7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7350: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7351: FND_LOG.STRING(g_level_unexpected,
7352: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
7353: SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80));