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

309: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.initialize.BEGIN',
310: 'ZX_PRODUCT_INTEGRATION_PKG: initialize (+)');
311: END IF;
312:
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: -- l_debug_flag := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
315:
316: -- IF L_DEBUG_FLAG <> PG_DEBUG THEN
317: -- FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calling initialize ....');

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341:
342: IF (g_level_event >= g_current_runtime_level) THEN
343: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
344: END IF;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
347: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
348: ZX_API_PUB.add_msg(
349: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1085: END IF;
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1091: FND_LOG.STRING(g_level_unexpected,
1092: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.initialize',
1093: SQLCODE || ' ; ' || SQLERRM);

Line 1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

1135: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax.BEGIN',
1136: 'ZX_PRODUCT_INTEGRATION_PKG: calculate_tax (+)');
1137: END IF;
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140:
1141: -- adjustment is not supported for LTE tax method
1142: IF p_event_class_rec.event_class_code = 'ADJUSTMENT' THEN
1143: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1157: x_return_status => x_return_status
1158: );
1159:
1160:
1161: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1162: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1163: FND_LOG.STRING(g_level_unexpected,
1164: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1165: 'Incorrect return_status after calling ' ||

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

1211: p_id_dist_tbl => l_index,
1212: x_return_status => x_return_status
1213: );
1214:
1215: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1216: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1217: FND_LOG.STRING(g_level_unexpected,
1218: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1219: 'Errored out when calculate tax.');

Line 1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1235: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (
1236: x_return_status => x_return_status
1237: );
1238:
1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1241: FND_LOG.STRING(g_level_unexpected,
1242: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1243: 'Incorrect return_status after calling ' ||

Line 1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1263: END IF;
1264:
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1269: FND_LOG.STRING(g_level_unexpected,
1270: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax',
1271: SQLCODE || ' ; ' || SQLERRM);

Line 1316: x_return_status := FND_API.G_RET_STS_SUCCESS;

1312: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax.BEGIN',
1313: 'ZX_PRODUCT_INTEGRATION_PKG: import_document_with_tax (+)');
1314: END IF;
1315:
1316: x_return_status := FND_API.G_RET_STS_SUCCESS;
1317:
1318: --initialize the cache structure.
1319: initialize (
1320: p_event_class_rec => p_event_class_rec,

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

1319: initialize (
1320: p_event_class_rec => p_event_class_rec,
1321: x_return_status => x_return_status
1322: );
1323: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1324: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1325: FND_LOG.STRING(g_level_unexpected,
1326: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1327: 'Incorrect return_status after calling ' ||

Line 1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1347: p_event_class_rec ,
1348: 'LINE' ,
1349: x_return_status );
1350:
1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: IF (g_level_procedure >= g_current_runtime_level ) THEN
1353: FND_LOG.STRING(g_level_procedure,
1354: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1355: 'Incorrect return_status when calling '||

Line 1382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type,
1379: x_return_status,
1380: l_error_buffer );
1381:
1382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1383: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1384: FND_LOG.STRING(g_level_unexpected,
1385: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1386: 'Incorrect return_status after calling ' ||

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

1401: p_id_dist_tbl => l_index,
1402: x_return_status => x_return_status
1403: );
1404:
1405: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1406: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1407: FND_LOG.STRING(g_level_unexpected,
1408: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1409: 'Errored out when calling import_trx_line_with_taxes().');

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

1425: p_id_dist_tbl => l_index,
1426: x_return_status => x_return_status
1427: );
1428:
1429: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1430: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1431: FND_LOG.STRING(g_level_unexpected,
1432: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1433: 'Incorrect return_status after calling ' ||

Line 1446: x_return_status := FND_API.G_RET_STS_ERROR;

1442: END IF;
1443:
1444: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1445:
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1449: ZX_API_PUB.add_msg(
1450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1449: ZX_API_PUB.add_msg(
1450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1451:
1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1453: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1454: FND_LOG.STRING(g_level_unexpected,
1455: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1456: 'Transaction line level action can only be CREATE or CREATE_WITH_TAX.');

Line 1480: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1476: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (
1477: x_return_status => x_return_status
1478: );
1479:
1480: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1481: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1484: 'Incorrect return_status after calling ' ||

Line 1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1504: END IF;
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1510: FND_LOG.STRING(g_level_unexpected,
1511: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax',
1512: SQLCODE || ' ; ' || SQLERRM);

Line 1586: x_return_status := FND_API.G_RET_STS_SUCCESS;

1582: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes.BEGIN',
1583: 'ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes(+)');
1584: END IF;
1585:
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:
1588: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);
1589:
1590: FOR tax_line_rec IN get_alloc_detail_tax_lines_csr LOOP

Line 1605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1601: p_id_dist_tbl => p_id_dist_tbl,
1602: p_new_row_num => l_new_row_num,
1603: x_return_status => x_return_status);
1604:
1605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1607: FND_LOG.STRING(g_level_unexpected,
1608: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1609: 'Incorrect return_status after calling '||

Line 1650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1646: l_begin_index,
1647: l_end_index,
1648: x_return_status,
1649: l_error_buffer);
1650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1651: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1652: FND_LOG.STRING(g_level_unexpected,
1653: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1654: 'Incorrect return_status after calling ' ||

Line 1689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1685: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST >= C_LINES_PER_INSERT) THEN
1686:
1687: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
1688:
1689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1690: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1691: FND_LOG.STRING(g_level_unexpected,
1692: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1693: 'Incorrect return_status after calling ' ||

Line 1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1707: END IF;
1708:
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1712: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1713: FND_LOG.STRING(g_level_unexpected,
1714: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes',
1715: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1832: x_return_status := FND_API.G_RET_STS_SUCCESS;

1828: FND_LOG.STRING(g_level_procedure,
1829: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte.BEGIN',
1830: 'ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte(+)');
1831: END IF;
1832: x_return_status := FND_API.G_RET_STS_SUCCESS;
1833:
1834: INITIALIZE_TAX_INFO_REC;
1835:
1836: -- Bug#6936808: init exception code returned from LTE

Line 2065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2061: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST >= C_LINES_PER_INSERT) THEN
2062:
2063: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
2064:
2065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2066: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2067: FND_LOG.STRING(g_level_unexpected,
2068: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte',
2069: 'Incorrect return_status after calling ' ||

Line 2091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2087:
2088: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt (x_return_status);
2089:
2090:
2091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2092: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2093: FND_LOG.STRING(g_level_unexpected,
2094: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte',
2095: 'Incorrect return_status after calling ' ||

Line 2125: x_return_status := FND_API.G_RET_STS_ERROR;

2121: WHEN OTHERS THEN
2122: -- bug#6936808: check if this is expected error returned from
2123: -- LTE expand_group_tax_code
2124: IF JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type = 'E' THEN
2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: ELSE
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: END IF;
2129:

Line 2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2123: -- LTE expand_group_tax_code
2124: IF JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type = 'E' THEN
2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: ELSE
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: END IF;
2129:
2130: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2131: FND_LOG.STRING(g_level_unexpected,

Line 4398: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4394: l_tax_determine_date,
4395: l_tax_point_date,
4396: x_return_status);
4397:
4398: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4399: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4400: FND_LOG.STRING(g_level_unexpected,
4401: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4402: 'Incorrect return_status after calling ' ||

Line 4427: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4423: l_tax_regime_rec,
4424: l_return_status,
4425: l_error_buffer);
4426:
4427: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4429: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
4430:
4431: ELSE

Line 4465: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4461: x_tax_rec => l_tax_rec,
4462: p_return_status => l_return_status,
4463: p_error_buffer => l_error_buffer);
4464:
4465: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_id := l_tax_Rec.TAX_id;
4467:
4468: IF l_tax_rec.Def_Place_Of_Supply_Type_Code = 'SHIP_TO_BILL_TO' then
4469: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).PLACE_OF_SUPPLY_TYPE_CODE := 'SHIP_TO';

Line 4513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4509:
4510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_jurisdiction_id
4511: := l_tax_jurisdiction_rec.tax_jurisdiction_id;
4512:
4513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4514: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4515: FND_LOG.STRING(g_level_unexpected,
4516: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4517: 'Incorrect return_status after calling ' ||

Line 4546: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4542: l_tax_status_rec,
4543: l_return_status,
4544: l_error_buffer);
4545:
4546: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4548: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
4549: ELSE
4550: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 4588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4584: l_tax_rate_id,
4585: l_return_status,
4586: l_error_buffer );
4587:
4588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4589: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4590: FND_LOG.STRING(g_level_unexpected,
4591: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4592: 'After calling ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_rate_id()');

Line 4779: x_return_status := FND_API.G_RET_STS_SUCCESS;

4775: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4776: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
4777: END IF;
4778:
4779: x_return_status := FND_API.G_RET_STS_SUCCESS;
4780:
4781: -- get tax date
4782: --
4783:

Line 4791: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4787: l_tax_determine_date,
4788: l_tax_point_date,
4789: x_return_status);
4790:
4791: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4793: FND_LOG.STRING(g_level_unexpected,
4794: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4795: 'Incorrect return_status after calling ' ||

Line 4816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4812: l_tax_regime_rec,
4813: x_return_status,
4814: l_error_buffer);
4815:
4816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4817: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4818: FND_LOG.STRING(g_level_unexpected,
4819: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4820: 'Incorrect return_status after calling ' ||

Line 4843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4839: l_tax_rec,
4840: x_return_status,
4841: l_error_buffer);
4842:
4843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4844: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4845: FND_LOG.STRING(g_level_unexpected,
4846: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4847: 'Incorrect return_status after calling ' ||

Line 4870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4866: x_jurisdiction_rec => l_tax_jurisdiction_rec,
4867: p_return_status => l_return_status,
4868: p_error_buffer => l_error_buffer);
4869:
4870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4871: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4872: FND_LOG.STRING(g_level_unexpected,
4873: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4874: 'Incorrect return_status after calling ' ||

Line 4898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4894: l_tax_status_rec,
4895: x_return_status,
4896: l_error_buffer);
4897:
4898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4899: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4900: FND_LOG.STRING(g_level_unexpected,
4901: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4902: 'Incorrect return_status after calling ' ||

Line 4930: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_id,
4927: x_return_status,
4928: l_error_buffer );
4929:
4930: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4931: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4932: FND_LOG.STRING(g_level_unexpected,
4933: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4934: 'After calling ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_rate_id()');

Line 5083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5079: END IF;
5080:
5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5084:
5085: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5086: FND_LOG.STRING(g_level_unexpected,
5087: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',

Line 5163: x_return_status := FND_API.G_RET_STS_SUCCESS;

5159: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_tax_rate_id',
5160: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
5161:
5162: END IF;
5163: x_return_status := FND_API.G_RET_STS_SUCCESS;
5164:
5165: /* Bug#5395227- use cache structure
5166: OPEN fetch_tax_rate_id;
5167: FETCH fetch_tax_rate_id INTO x_tax_rate_id;

Line 5186: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5182: x_error_buffer);
5183:
5184: */
5185:
5186: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5187: x_tax_rate_id := l_tax_rate_rec.tax_rate_id;
5188: END IF;
5189:
5190: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5200: END IF;
5201:
5202: EXCEPTION
5203: WHEN OTHERS THEN
5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5205: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5206: FND_LOG.STRING(g_level_unexpected,
5207: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_tax_rate_id',
5208: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));