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

Line 450: p_return_status := FND_API.G_RET_STS_SUCCESS;

446: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params.BEGIN',
447: 'ZX_TDS_RULE_BASE_DETM_PVT: init_cec_params (+)');
448: END IF;
449:
450: p_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: -- Fetch Ship To Party Site Id
453: -- (equivalent of arp_tax.tax_info_rec.ship_to_site_use_id)
454: get_tsrm_num_value(p_structure_name,

Line 628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: 'ZX_TDS_RULE_BASE_DETM_PVT: init_cec_params (-)');
625: END IF;
626: EXCEPTION
627: WHEN OTHERS THEN
628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
630:
631: IF (g_level_unexpected >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_unexpected,

Line 858: p_return_status := FND_API.G_RET_STS_SUCCESS;

854:
855: END IF;
856: END IF;
857:
858: p_return_status := FND_API.G_RET_STS_SUCCESS;
859: l_found := FALSE;
860:
861: --
862: -- check if tax_status_code is null for Tax rate determination

Line 867: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

863: -- return error if it is null
864: --
865: IF (p_service_type_code = 'DET_TAX_RATE' AND
866: p_tax_status_code IS NULL) THEN
867: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: p_error_buffer := 'Tax status code can not be null for Rate Determination';
869:
870: IF (g_level_error >= g_current_runtime_level ) THEN
871: FND_LOG.STRING(g_level_error,

Line 882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

878: END IF;
879:
880: IF (p_service_type_code = 'DET_RECOVERY_RATE' AND
881: p_recovery_type_code IS NULL) THEN
882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: p_error_buffer := 'Recovery type can not be null for DET_RECOVERY_RATE';
884:
885: IF (g_level_error >= g_current_runtime_level ) THEN
886: FND_LOG.STRING(g_level_error,

Line 906: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

902: p_tax_id,
903: p_return_status,
904: p_error_buffer);
905:
906: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
907: IF (g_level_statement >= g_current_runtime_level ) THEN
908: FND_LOG.STRING(g_level_statement,
909: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',
910: 'p_return_status = ' || p_return_status ||

Line 942: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS OR l_found)THEN

938: p_zx_result_rec,
939: p_return_status,
940: p_error_buffer);
941:
942: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS OR l_found)THEN
943: -- return to caller if error occurs or success with a result
944: IF (g_level_error >= g_current_runtime_level ) THEN
945: FND_LOG.STRING(g_level_error,
946: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',

Line 965: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

961: l_source_event_class_code,
962: p_return_status,
963: p_error_buffer);
964:
965: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966: IF (g_level_error >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_error,
968: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.fetch_proc_det_factor_templ',
969: 'Incorrect return_status after call get_tsrm_alphanum_value().'||

Line 1029: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1025: l_rule_geography_id_tbl,
1026: p_zx_result_rec,
1027: p_return_status,
1028: p_error_buffer);
1029: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1030: CLOSE get_det_factor_templ_csr_a;
1031:
1032: IF (g_level_error >= g_current_runtime_level ) THEN
1033: FND_LOG.STRING(g_level_error,

Line 1099: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1095: l_rule_geography_id_tbl,
1096: p_zx_result_rec,
1097: p_return_status,
1098: p_error_buffer);
1099: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1100: CLOSE get_det_factor_templ_csr_a;
1101:
1102: IF (g_level_error >= g_current_runtime_level ) THEN
1103: FND_LOG.STRING(g_level_error,

Line 1181: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1177: p_zx_result_rec,
1178: p_return_status,
1179: p_error_buffer);
1180:
1181: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1182: CLOSE get_det_factor_templ_csr_b;
1183: IF (g_level_error >= g_current_runtime_level ) THEN
1184: FND_LOG.STRING(g_level_error,
1185: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',

Line 1251: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1247: p_zx_result_rec,
1248: p_return_status,
1249: p_error_buffer);
1250:
1251: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1252: CLOSE get_det_factor_templ_csr_b;
1253: IF (g_level_error >= g_current_runtime_level ) THEN
1254: FND_LOG.STRING(g_level_error,
1255: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',

Line 1304: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1300: p_return_status,
1301: p_error_buffer) ;
1302:
1303: /* Bug 4017396 - included the check for p_return_status*/
1304: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1305: IF (g_level_error >= g_current_runtime_level ) THEN
1306: FND_LOG.STRING(g_level_error,
1307: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',
1308: 'p_return_status = ' || p_return_status ||

Line 1317: IF (NOT l_found AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1313:
1314: END IF; -- p_service_type_code = 'DET_TAX_RATE'/'DET_RECOVERY_RATE' OR ELSE
1315:
1316: /* comment this out as in Phase 1 only rules at tax level are supported.
1317: IF (NOT l_found AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1318:
1319: --
1320: -- traverse the regime hierarchy to get rules
1321: --

Line 1342: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1338: l_found,
1339: l_parent_regime_code_tbl,
1340: p_return_status,
1341: p_error_buffer);
1342: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1343: CLOSE get_regime_code_csr;
1344:
1345: IF (g_level_error >= g_current_runtime_level ) THEN
1346: FND_LOG.STRING(g_level_error,

Line 1389: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1385: END IF;
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1391: IF get_det_factor_templ_csr_a%ISOPEN THEN
1392: CLOSE get_det_factor_templ_csr_a;
1393: ELSIF get_det_factor_templ_csr_b%ISOPEN THEN

Line 1511: p_return_status := FND_API.G_RET_STS_SUCCESS;

1507: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code.BEGIN',
1508: 'ZX_TDS_RULE_BASE_DETM_PVT: process_rule_code(+)');
1509: END IF;
1510:
1511: p_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: --
1514: -- determine which cursor to open
1515: --

Line 1554: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1550: END IF;
1551: CLOSE get_offset_templ_csr;
1552: **********************/
1553: ELSE
1554: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: p_error_buffer := 'Invalid service type code for the tax rule code';
1556: IF (g_level_error >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_error,
1558: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code',

Line 1576: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1572: p_return_status,
1573: p_error_buffer);
1574:
1575: -- process the template only if its parameters are valid for the given application
1576: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1577:
1578: -- get all the condition groups and conditions
1579: proc_condition_group_per_templ(
1580: p_structure_name,

Line 1613: -- EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);

1609: p_return_status,
1610: p_error_buffer);
1611: END IF;
1612: */
1613: -- EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
1614: END IF;
1615: IF (g_level_procedure >= g_current_runtime_level ) THEN
1616: FND_LOG.STRING(g_level_procedure,
1617: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code',

Line 1626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1622: END IF;
1623:
1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1628: IF get_recovery_templ_csr%ISOPEN THEN
1629: CLOSE get_recovery_templ_csr;
1630: END IF;

Line 1814: p_return_status := FND_API.G_RET_STS_SUCCESS; --Included as part of Bug fix 4017396

1810:
1811: END IF;
1812: END IF;
1813:
1814: p_return_status := FND_API.G_RET_STS_SUCCESS; --Included as part of Bug fix 4017396
1815:
1816: IF p_event_class_rec.source_event_class_mapping_id IS NOT NULL THEN
1817:
1818: get_tsrm_alphanum_value(

Line 1826: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1822: l_source_event_class_code,
1823: p_return_status,
1824: p_error_buffer);
1825:
1826: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1827: IF (g_level_error >= g_current_runtime_level ) THEN
1828: FND_LOG.STRING(g_level_error,
1829: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.fetch_proc_det_factor_templ',
1830: 'Incorrect return_status after call get_tsrm_alphanum_value().'||

Line 1891: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1887: p_zx_result_rec,
1888: p_return_status,
1889: p_error_buffer);
1890:
1891: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1892: CLOSE get_det_factor_templ_csr_c;
1893:
1894: IF (g_level_error >= g_current_runtime_level ) THEN
1895: FND_LOG.STRING(g_level_error,

Line 1962: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1958: p_zx_result_rec,
1959: p_return_status,
1960: p_error_buffer);
1961:
1962: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1963: CLOSE get_det_factor_templ_csr_d;
1964:
1965: IF (g_level_error >= g_current_runtime_level ) THEN
1966: FND_LOG.STRING(g_level_error,

Line 2051: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2047: p_zx_result_rec,
2048: p_return_status,
2049: p_error_buffer);
2050:
2051: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2052: CLOSE get_det_factor_templ_csr_e;
2053:
2054: IF (g_level_error >= g_current_runtime_level ) THEN
2055: FND_LOG.STRING(g_level_error,

Line 2120: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2116: p_zx_result_rec,
2117: p_return_status,
2118: p_error_buffer);
2119:
2120: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2121: CLOSE get_det_factor_templ_csr_e;
2122:
2123: IF (g_level_error >= g_current_runtime_level ) THEN
2124: FND_LOG.STRING(g_level_error,

Line 2165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2161: END IF;
2162:
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2167: IF get_det_factor_templ_csr_c%ISOPEN THEN
2168: CLOSE get_det_factor_templ_csr_c;
2169: ELSIF get_det_factor_templ_csr_d%ISOPEN THEN

Line 2266: p_return_status := FND_API.G_RET_STS_SUCCESS;

2262: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_rule_from_regime_hier.BEGIN',
2263: 'ZX_TDS_RULE_BASE_DETM_PVT: get_rule_from_regime_hier(+)');
2264: END IF;
2265:
2266: p_return_status := FND_API.G_RET_STS_SUCCESS;
2267:
2268: l_count := p_parent_regime_cd_tbl.count;
2269:
2270: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2326: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2322: l_rule_geography_id_tbl,
2323: p_zx_result_rec,
2324: p_return_status,
2325: p_error_buffer);
2326: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2327: CLOSE get_templ_from_regime_hier_csr;
2328:
2329: IF (g_level_error >= g_current_runtime_level ) THEN
2330: FND_LOG.STRING(g_level_error,

Line 2358: EXIT WHEN (p_found OR p_return_status = FND_API.G_RET_STS_ERROR);

2354: IF get_templ_from_regime_hier_csr%ISOPEN THEN
2355: CLOSE get_templ_from_regime_hier_csr;
2356: END IF;
2357:
2358: EXIT WHEN (p_found OR p_return_status = FND_API.G_RET_STS_ERROR);
2359: END LOOP;
2360:
2361: IF (g_level_procedure >= g_current_runtime_level ) THEN
2362: FND_LOG.STRING(g_level_procedure,

Line 2371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2367: END IF;
2368:
2369: EXCEPTION
2370: WHEN OTHERS THEN
2371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2373: IF get_templ_from_regime_hier_csr%ISOPEN THEN
2374: CLOSE get_templ_from_regime_hier_csr;
2375: END IF;

Line 2432: p_return_status := FND_API.G_RET_STS_SUCCESS;

2428: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_det_factor_templ.BEGIN',
2429: 'ZX_TDS_RULE_BASE_DETM_PVT: proc_det_factor_templ(+)');
2430: END IF;
2431:
2432: p_return_status := FND_API.G_RET_STS_SUCCESS;
2433: l_valid := TRUE;
2434:
2435: l_count := p_det_factor_templ_cd_tbl.count;
2436:

Line 2477: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2473: p_return_status,
2474: p_error_buffer);
2475: END IF;
2476:
2477: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2478: IF g_level_error >= g_current_runtime_level THEN
2479: FND_LOG.STRING(g_level_error,
2480: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_det_factor_templ',
2481: ' check_rule_geography returned Error');

Line 2490: IF(l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2486:
2487: --Continue processing the Rule only if the Rule's geography
2488: --matched with the one cached in the gloabl location structure
2489:
2490: IF(l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2491: --
2492: -- process 1 template at a time
2493: --
2494:

Line 2515: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2511: p_return_status,
2512: p_error_buffer);
2513:
2514: -- process the template only if it is valid for the given application
2515: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2516:
2517: -- get all the condition groups and conditions
2518: proc_condition_group_per_templ(
2519: p_structure_name,

Line 2553: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);

2549: p_return_status,
2550: p_error_buffer);
2551: END IF; --l_result
2552: */
2553: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
2554: END IF; --l_valid
2555: END IF; --l_valid for check_rule_geography
2556: END LOOP;
2557:

Line 2566: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2562: END IF;
2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2568:
2569: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2570: FND_LOG.STRING(g_level_unexpected,

Line 2808: p_return_status := FND_API.G_RET_STS_SUCCESS;

2804: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ.BEGIN',
2805: 'ZX_TDS_RULE_BASE_DETM_PVT: proc_condition_group_per_templ(+)');
2806: END IF;
2807:
2808: p_return_status := FND_API.G_RET_STS_SUCCESS;
2809: l_constraint_result := FALSE;
2810: l_condition_group_evaluated := FALSE;
2811:
2812: -- reset the left hand side trx value for a new unevaluated template.

Line 2823: hash_val := to_char(p_tax_rule_id) || '|' || NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) || '|' || NVL(p_tax_status_code, FND_API.G_MISS_CHAR);

2819: -- values only once
2820: --
2821:
2822: -- caching fix done for bug#8551677
2823: hash_val := to_char(p_tax_rule_id) || '|' || NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) || '|' || NVL(p_tax_status_code, FND_API.G_MISS_CHAR);
2824:
2825: IF ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.EXISTS(hash_val) AND
2826: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_rule_id = p_tax_rule_id AND
2827: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code, FND_API.G_MISS_CHAR) = NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) AND

Line 2827: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code, FND_API.G_MISS_CHAR) = NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) AND

2823: hash_val := to_char(p_tax_rule_id) || '|' || NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) || '|' || NVL(p_tax_status_code, FND_API.G_MISS_CHAR);
2824:
2825: IF ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.EXISTS(hash_val) AND
2826: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_rule_id = p_tax_rule_id AND
2827: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code, FND_API.G_MISS_CHAR) = NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) AND
2828: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code, FND_API.G_MISS_CHAR) = NVL(p_tax_status_code, FND_API.G_MISS_CHAR) THEN
2829: IF (g_level_statement >= g_current_runtime_level ) THEN
2830: FND_LOG.STRING(g_level_statement,
2831: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',

Line 2828: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code, FND_API.G_MISS_CHAR) = NVL(p_tax_status_code, FND_API.G_MISS_CHAR) THEN

2824:
2825: IF ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.EXISTS(hash_val) AND
2826: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_rule_id = p_tax_rule_id AND
2827: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code, FND_API.G_MISS_CHAR) = NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR) AND
2828: NVL(ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code, FND_API.G_MISS_CHAR) = NVL(p_tax_status_code, FND_API.G_MISS_CHAR) THEN
2829: IF (g_level_statement >= g_current_runtime_level ) THEN
2830: FND_LOG.STRING(g_level_statement,
2831: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',
2832: 'Condition Information found in cache...' || hash_val);

Line 2842: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code := NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR);

2838: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',
2839: 'Condition Information not found in cache...' || hash_val);
2840: END IF;
2841: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_rule_id := p_tax_rule_id;
2842: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code := NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR);
2843: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code := NVL(p_tax_status_code, FND_API.G_MISS_CHAR);
2844: OPEN get_condition_group_codes_csr(p_det_factor_templ_code,
2845: p_tax_rule_id,
2846: p_tax_status_code);

Line 2843: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code := NVL(p_tax_status_code, FND_API.G_MISS_CHAR);

2839: 'Condition Information not found in cache...' || hash_val);
2840: END IF;
2841: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_rule_id := p_tax_rule_id;
2842: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).det_factor_templ_code := NVL(p_det_factor_templ_code, FND_API.G_MISS_CHAR);
2843: ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).tax_status_code := NVL(p_tax_status_code, FND_API.G_MISS_CHAR);
2844: OPEN get_condition_group_codes_csr(p_det_factor_templ_code,
2845: p_tax_rule_id,
2846: p_tax_status_code);
2847: --LOOP

Line 3047: p_return_status := FND_API.G_RET_STS_ERROR;

3043:
3044: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
3045:
3046: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
3047: p_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: -- Bug 8568734
3050: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
3051: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).condition_info_rec_tbl(j).condition_group_code);

Line 3141: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3137: -- if p_return_status = ERROR from process_set_condition
3138: -- that means get_trx_value results in error while trying to get
3139: -- transaction values, return to calling process immediately
3140: --
3141: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3142: CLOSE get_condition_group_codes_csr;
3143: IF (g_level_error >= g_current_runtime_level ) THEN
3144: FND_LOG.STRING(g_level_error,
3145: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',

Line 3184: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);

3180: p_found,
3181: p_zx_result_rec,
3182: p_return_status,
3183: p_error_buffer);
3184: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
3185: END IF;
3186: END LOOP;
3187:
3188: IF (l_counter = 0 OR p_result) THEN

Line 3222: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3218: END IF;
3219:
3220: EXCEPTION
3221: WHEN OTHERS THEN
3222: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3224: IF get_condition_group_codes_csr%ISOPEN THEN
3225: CLOSE get_condition_group_codes_csr;
3226: END IF;

Line 3300: p_return_status := FND_API.G_RET_STS_SUCCESS;

3296:
3297: END IF;
3298: END IF;
3299:
3300: p_return_status := FND_API.G_RET_STS_SUCCESS;
3301:
3302: l_condition_result := TRUE;
3303:
3304: --

Line 3337: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3333: p_return_status,
3334: p_error_buffer);
3335:
3336:
3337: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3338: CLOSE get_condition_csr;
3339: IF (g_level_error >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_error,
3341: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_and_process_condition',

Line 3376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3372: END IF;
3373:
3374: EXCEPTION
3375: WHEN OTHERS THEN
3376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3377: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3378: IF get_condition_csr%ISOPEN THEN
3379: CLOSE get_condition_csr;
3380: END IF;

Line 3678: p_return_status := FND_API.G_RET_STS_SUCCESS;

3674: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition.BEGIN',
3675: 'ZX_TDS_RULE_BASE_DETM_PVT: process_set_condition(+)');
3676: END IF;
3677:
3678: p_return_status := FND_API.G_RET_STS_SUCCESS;
3679:
3680: l_count := g_determining_factor_code_tbl.count;
3681:
3682: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3715: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3711: p_result,
3712: p_return_status,
3713: p_error_buffer);
3714:
3715: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3716:
3717: IF (g_level_error >= g_current_runtime_level ) THEN
3718: FND_LOG.STRING(g_level_error,
3719: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3752: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3748: p_sob_id,
3749: p_return_status,
3750: p_error_buffer);
3751:
3752: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3753:
3754: IF (g_level_error >= g_current_runtime_level ) THEN
3755: FND_LOG.STRING(g_level_error,
3756: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3768: p_return_status := FND_API.G_RET_STS_SUCCESS;

3764: -- process immediately
3765: --
3766:
3767: IF g_determining_factor_class_tbl(k) = 'ACCOUNTING_FLEXFIELD' THEN
3768: p_return_status := FND_API.G_RET_STS_SUCCESS;
3769: END IF;
3770:
3771: RETURN;
3772: END IF;

Line 3822: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3818: p_sob_id,
3819: p_return_status,
3820: p_error_buffer);
3821:
3822: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3823:
3824: IF (g_level_error >= g_current_runtime_level ) THEN
3825: FND_LOG.STRING(g_level_error,
3826: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3883: END IF;
3884:
3885: EXCEPTION
3886: WHEN OTHERS THEN
3887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3889:
3890: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3891: FND_LOG.STRING(g_level_unexpected,

Line 3938: p_return_status := FND_API.G_RET_STS_SUCCESS;

3934: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value.BEGIN',
3935: 'ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value(+)');
3936: END IF;
3937:
3938: p_return_status := FND_API.G_RET_STS_SUCCESS;
3939:
3940: i := p_condition_index;
3941:
3942: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3964: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3960: p_alphanum_value,
3961: p_date_value,
3962: p_return_status,
3963: p_error_buffer);
3964: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3965: IF p_alphanum_value IS NULL THEN
3966: --
3967: -- OUTPUT_TAX_CLASSIFICATION_CODE is null,
3968: -- use INPUT_TAX_CLASSIFICATION_CODE

Line 4162: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4158: p_return_status,
4159: p_error_buffer);
4160: */
4161: END IF;
4162: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4163: -- update trx value cache structure
4164: /* Bug 5003413 */
4165: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
4166: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 4188: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4184: END IF;
4185:
4186: EXCEPTION
4187: WHEN OTHERS THEN
4188: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4189: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4190: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4191: FND_LOG.STRING(g_level_unexpected,
4192: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value',

Line 4236: p_return_status := FND_API.G_RET_STS_SUCCESS;

4232: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl.BEGIN',
4233: 'ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl(+)');
4234: END IF;
4235:
4236: p_return_status := FND_API.G_RET_STS_SUCCESS;
4237:
4238: i := p_condition_index;
4239: p_result := FALSE;
4240:

Line 4258: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4254: p_tax_determine_date,
4255: p_return_status,
4256: p_error_buffer);
4257:
4258: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4259: IF (g_level_error >= g_current_runtime_level ) THEN
4260: FND_LOG.STRING(g_level_error,
4261: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
4262: 'Incorrect return_status after calling get_geography_info()' ||

Line 4289: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4285: p_chart_of_accounts_id,
4286: p_result,
4287: p_return_status,
4288: p_error_buffer);
4289: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4290: IF (g_level_error >= g_current_runtime_level ) THEN
4291: FND_LOG.STRING(g_level_error,
4292: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
4293: 'Incorrect return_status after calling evaluate_condition()' ||

Line 4325: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4321: p_chart_of_accounts_id,
4322: p_result,
4323: p_return_status,
4324: p_error_buffer);
4325: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4326: IF (g_level_error >= g_current_runtime_level ) THEN
4327: FND_LOG.STRING(g_level_error,
4328: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
4329: 'Incorrect return_status after calling evaluate_condition()' ||

Line 4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4343: END IF;
4344:
4345: EXCEPTION
4346: WHEN OTHERS THEN
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4349: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4350: FND_LOG.STRING(g_level_unexpected,
4351: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',

Line 4388: p_return_status := FND_API.G_RET_STS_SUCCESS;

4384: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_parameter_value.BEGIN',
4385: 'ZX_TDS_RULE_BASE_DETM_PVT: get_tsrm_parameter_value(+)');
4386: END IF;
4387:
4388: p_return_status := FND_API.G_RET_STS_SUCCESS;
4389:
4390: i := p_condition_index;
4391:
4392: IF g_data_type_tbl(i) = 'NUMERIC' THEN

Line 4444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4440: ', p_alphanum_value: ' || p_alphanum_value );
4441: END IF;
4442: ELSE
4443:
4444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4445: p_error_buffer := 'Invalid data type';
4446: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4447: FND_LOG.STRING(g_level_unexpected,
4448: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_parameter_value',

Line 4464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4460: END IF;
4461:
4462: EXCEPTION
4463: WHEN OTHERS THEN
4464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4465: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4466:
4467: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4468: FND_LOG.STRING(g_level_unexpected,

Line 4507: p_return_status := FND_API.G_RET_STS_SUCCESS;

4503: FND_LOG.STRING(g_level_statement ,
4504: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value',
4505: 'p_parameter_code: ' || p_parameter_code );
4506: END IF;
4507: p_return_status := FND_API.G_RET_STS_SUCCESS;
4508:
4509: -- commenting caching as no value check is possible at this point.
4510: -- for checking if the value in cache is matching the current transaction value
4511: -- we need to call get_driver_value

Line 4531: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4527: p_trx_numeric_value,
4528: p_return_status
4529: );
4530:
4531: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4532: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4533: --END IF;
4534: --END IF;
4535:

Line 4549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4545: END IF;
4546:
4547: EXCEPTION
4548: WHEN OTHERS THEN
4549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4550: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4551:
4552: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4553: FND_LOG.STRING(g_level_unexpected,

Line 4592: p_return_status := FND_API.G_RET_STS_SUCCESS;

4588: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_alphanum_value',
4589: 'p_parameter_code: ' || p_parameter_code );
4590: END IF;
4591:
4592: p_return_status := FND_API.G_RET_STS_SUCCESS;
4593:
4594: -- commenting caching as no value check is possible at this point.
4595: -- for checking if the value in cache is matching the current transaction value
4596: -- we need to call get_driver_value

Line 4615: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4611: p_parameter_code,
4612: p_trx_alphanumeric_value,
4613: p_return_status
4614: );
4615: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4616: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4617: --END IF;
4618: --END IF;
4619:

Line 4633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4629: END IF;
4630:
4631: EXCEPTION
4632: WHEN OTHERS THEN
4633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4634: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4635:
4636: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4637: FND_LOG.STRING(g_level_unexpected,

Line 4676: p_return_status := FND_API.G_RET_STS_SUCCESS;

4672: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_num_value',
4673: 'p_parameter_code: ' || p_parameter_code );
4674: END IF;
4675: END IF;
4676: p_return_status := FND_API.G_RET_STS_SUCCESS;
4677:
4678: l_table_index := dbms_utility.get_hash_value(
4679: p_parameter_code,
4680: 1,

Line 4700: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4696: p_trx_numeric_value,
4697: p_return_status
4698: );
4699:
4700: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4702: END IF;
4703: END IF;
4704:

Line 4718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4714: END IF;
4715:
4716: EXCEPTION
4717: WHEN OTHERS THEN
4718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4719: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4720:
4721: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4722: FND_LOG.STRING(g_level_unexpected,

Line 4762: p_return_status := FND_API.G_RET_STS_SUCCESS;

4758: 'p_parameter_code: ' || p_parameter_code );
4759: END IF;
4760: END IF;
4761:
4762: p_return_status := FND_API.G_RET_STS_SUCCESS;
4763:
4764: l_table_index := dbms_utility.get_hash_value(
4765: p_parameter_code,
4766: 1,

Line 4785: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4781: p_parameter_code,
4782: p_trx_alphanumeric_value,
4783: p_return_status
4784: );
4785: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4786: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4787: END IF;
4788: END IF;
4789:

Line 4803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4799: END IF;
4800:
4801: EXCEPTION
4802: WHEN OTHERS THEN
4803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4804: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4805:
4806: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4807: FND_LOG.STRING(g_level_unexpected,

Line 4844: p_return_status := FND_API.G_RET_STS_SUCCESS;

4840: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_user_item_type_value.BEGIN',
4841: 'ZX_TDS_RULE_BASE_DETM_PVT: get_user_item_type_value(+)');
4842: END IF;
4843:
4844: p_return_status := FND_API.G_RET_STS_SUCCESS;
4845:
4846: i := p_condition_index;
4847:
4848: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 4867: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4863: ', p_alphanum_value: ' || p_alphanum_value );
4864: END IF;
4865: ELSE
4866:
4867: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4868: p_error_buffer := 'Invalid data type';
4869: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4870: FND_LOG.STRING(g_level_unexpected,
4871: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_user_item_type_value',

Line 4887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4883: END IF;
4884:
4885: EXCEPTION
4886: WHEN OTHERS THEN
4887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4888: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4889:
4890: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4891: FND_LOG.STRING(g_level_unexpected,

Line 4934: p_return_status := FND_API.G_RET_STS_SUCCESS;

4930: 'p_parameter_code: ' || p_parameter_code );
4931: END IF;
4932: END IF;
4933:
4934: p_return_status := FND_API.G_RET_STS_SUCCESS;
4935:
4936: l_table_index := dbms_utility.get_hash_value(
4937: p_parameter_code,
4938: 1,

Line 4978: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4974: ', p_error_buffer = ' || p_error_buffer);
4975: END IF;
4976: EXCEPTION
4977: WHEN OTHERS THEN
4978: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4979: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4980:
4981: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4982: FND_LOG.STRING(g_level_unexpected,

Line 5076: p_return_status := FND_API.G_RET_STS_SUCCESS;

5072: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc.BEGIN',
5073: 'ZX_TDS_RULE_BASE_DETM_PVT: get_fc(+)');
5074: END IF;
5075:
5076: p_return_status := FND_API.G_RET_STS_SUCCESS;
5077:
5078: i := p_condition_index;
5079:
5080: l_classification_category := g_determining_factor_class_tbl(i);

Line 5115: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5111: l_prod_trx_parm_value,
5112: p_return_status,
5113: p_error_buffer );
5114:
5115: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5116: IF (g_level_error >= g_current_runtime_level ) THEN
5117: FND_LOG.STRING(g_level_error,
5118: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5119: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||

Line 5122: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5118: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5119: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||
5120: ', return_status: ' || p_return_status);
5121: END IF;
5122: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5123: RETURN;
5124: END IF;
5125:
5126: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5160: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5156: ZX_TCM_CONTROL_PKG.GET_PROD_TRX_CATE_VALUE(
5157: l_fsc_cat_rec,
5158: p_return_status);
5159:
5160: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5161: p_trx_alphanumeric_value := nvl(l_fsc_cat_rec.condition_value, FND_API.G_MISS_CHAR);
5162: ELSE
5163: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5164: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5161: p_trx_alphanumeric_value := nvl(l_fsc_cat_rec.condition_value, FND_API.G_MISS_CHAR);

5157: l_fsc_cat_rec,
5158: p_return_status);
5159:
5160: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5161: p_trx_alphanumeric_value := nvl(l_fsc_cat_rec.condition_value, FND_API.G_MISS_CHAR);
5162: ELSE
5163: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5164: p_return_status := FND_API.G_RET_STS_SUCCESS;
5165: END IF;

Line 5163: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5159:
5160: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5161: p_trx_alphanumeric_value := nvl(l_fsc_cat_rec.condition_value, FND_API.G_MISS_CHAR);
5162: ELSE
5163: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5164: p_return_status := FND_API.G_RET_STS_SUCCESS;
5165: END IF;
5166:
5167: END IF; -- Null Class Qualifier

Line 5164: p_return_status := FND_API.G_RET_STS_SUCCESS;

5160: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5161: p_trx_alphanumeric_value := nvl(l_fsc_cat_rec.condition_value, FND_API.G_MISS_CHAR);
5162: ELSE
5163: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5164: p_return_status := FND_API.G_RET_STS_SUCCESS;
5165: END IF;
5166:
5167: END IF; -- Null Class Qualifier
5168:

Line 5182: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5178: l_prod_trx_parm_value,
5179: p_return_status,
5180: p_error_buffer );
5181:
5182: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5183: IF (g_level_error >= g_current_runtime_level ) THEN
5184: FND_LOG.STRING(g_level_error,
5185: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5186: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||

Line 5189: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5185: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5186: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||
5187: ', return_status: ' || p_return_status);
5188: END IF;
5189: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5190: RETURN;
5191: END IF;
5192:
5193: l_fsc_rec.classification_type := l_classification_type;

Line 5208: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5204: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5205: l_fsc_rec,
5206: p_return_status);
5207:
5208: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5209: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5210: ELSE
5211: -- Bugfix 4882676: ignore error even if fc not found
5212: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5209: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);

5205: l_fsc_rec,
5206: p_return_status);
5207:
5208: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5209: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5210: ELSE
5211: -- Bugfix 4882676: ignore error even if fc not found
5212: p_return_status := FND_API.G_RET_STS_SUCCESS;
5213: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5212: p_return_status := FND_API.G_RET_STS_SUCCESS;

5208: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5209: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5210: ELSE
5211: -- Bugfix 4882676: ignore error even if fc not found
5212: p_return_status := FND_API.G_RET_STS_SUCCESS;
5213: IF (g_level_statement >= g_current_runtime_level ) THEN
5214: FND_LOG.STRING(g_level_statement,
5215: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5216: 'ignore error even if fc not found ' );

Line 5218: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5214: FND_LOG.STRING(g_level_statement,
5215: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5216: 'ignore error even if fc not found ' );
5217: END IF;
5218: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5219: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;
5220: END IF;
5221: ELSE
5222: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR;

Line 5222: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR;

5218: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5219: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;
5220: END IF;
5221: ELSE
5222: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR;
5223: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;
5224: END IF; --Checking for NULL case for calling GET_FISCAL_CLASSIFICATION
5225:
5226: ELSIF l_classification_category = 'PRODUCT_FISCAL_CLASS' THEN

Line 5260: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5256: l_default_taxation_country,
5257: p_return_status,
5258: p_error_buffer );
5259:
5260: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5261: IF (g_level_error >= g_current_runtime_level ) THEN
5262: FND_LOG.STRING(g_level_error,
5263: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5264: 'Called get_tsrm_alphanum_value to get DEFAULT_TAXATION_COUNTRY' ||

Line 5267: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5263: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5264: 'Called get_tsrm_alphanum_value to get DEFAULT_TAXATION_COUNTRY' ||
5265: ', return_status: ' || p_return_status);
5266: END IF;
5267: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5268: RETURN;
5269: END IF;
5270:
5271: OPEN c_country_def_category_set_id(l_default_taxation_country);

Line 5293: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5289: l_product_fisc_classification,
5290: p_return_status,
5291: p_error_buffer );
5292:
5293: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5294: IF (g_level_error >= g_current_runtime_level ) THEN
5295: FND_LOG.STRING(g_level_error,
5296: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5297: 'Called get_tsrm_alphanum_value to get PRODUCT_FISC_CLASSIFICATION' ||

Line 5300: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5296: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5297: 'Called get_tsrm_alphanum_value to get PRODUCT_FISC_CLASSIFICATION' ||
5298: ', return_status: ' || p_return_status);
5299: END IF;
5300: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5301: RETURN;
5302: END IF;
5303:
5304: IF l_fc_base_category_set_id = l_country_def_category_set_id

Line 5358: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5354: l_classified_entity_id,
5355: p_return_status,
5356: p_error_buffer );
5357:
5358: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5359: IF (g_level_error >= g_current_runtime_level ) THEN
5360: FND_LOG.STRING(g_level_error,
5361: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5362: 'Called get_tsrm_num_value to get PRODUCT_ID' ||

Line 5365: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5361: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5362: 'Called get_tsrm_num_value to get PRODUCT_ID' ||
5363: ', return_status: ' || p_return_status);
5364: END IF;
5365: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5366: RETURN;
5367: END IF;
5368:
5369: -- get organization id for item

Line 5381: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5377: FND_LOG.STRING(g_level_error,
5378: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5379: 'Invalid prod_family_grp_code');
5380: END IF;
5381: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5382: RETURN;
5383: END IF;
5384:
5385: get_tsrm_num_value(

Line 5393: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5389: l_item_org_id,
5390: p_return_status,
5391: p_error_buffer );
5392:
5393: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5394: IF (g_level_error >= g_current_runtime_level ) THEN
5395: FND_LOG.STRING(g_level_error,
5396: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5397: 'Called get_tsrm_num_value to get ' ||l_parameter_code|| ', return_status: ' || p_return_status);

Line 5399: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5395: FND_LOG.STRING(g_level_error,
5396: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5397: 'Called get_tsrm_num_value to get ' ||l_parameter_code|| ', return_status: ' || p_return_status);
5398: END IF;
5399: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5400: RETURN;
5401: END IF;
5402:
5403: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5420: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5416: l_product_org_id,
5417: p_return_status,
5418: p_error_buffer );
5419:
5420: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5421: IF (g_level_error >= g_current_runtime_level ) THEN
5422: FND_LOG.STRING(g_level_error,
5423: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5424: 'Called get_tsrm_num_value to get PRODUCT_ORG_ID' ||

Line 5427: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5423: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5424: 'Called get_tsrm_num_value to get PRODUCT_ORG_ID' ||
5425: ', return_status: ' || p_return_status);
5426: END IF;
5427: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5428: RETURN;
5429: END IF;
5430:
5431: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5482: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5478: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5479: l_fsc_rec,
5480: p_return_status);
5481:
5482: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5483: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5484: j := OPTIMAL_FSC_TBL_LOCATION();
5485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5486: ELSE

Line 5483: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);

5479: l_fsc_rec,
5480: p_return_status);
5481:
5482: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5483: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5484: j := OPTIMAL_FSC_TBL_LOCATION();
5485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5486: ELSE
5487: -- Bugfix 4882676: ignore error even if fc not found

Line 5488: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5484: j := OPTIMAL_FSC_TBL_LOCATION();
5485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5486: ELSE
5487: -- Bugfix 4882676: ignore error even if fc not found
5488: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5489: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5490: p_return_status := FND_API.G_RET_STS_SUCCESS;
5491: END IF;
5492: END IF; -- not found in cache

Line 5490: p_return_status := FND_API.G_RET_STS_SUCCESS;

5486: ELSE
5487: -- Bugfix 4882676: ignore error even if fc not found
5488: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5489: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5490: p_return_status := FND_API.G_RET_STS_SUCCESS;
5491: END IF;
5492: END IF; -- not found in cache
5493: END IF; -- item org id is not null
5494: --

Line 5501: or p_trx_alphanumeric_value = FND_API.G_MISS_CHAR)

5497:
5498: IF (l_classified_entity_id is NOT NULL AND
5499: l_product_org_id IS NOT NULL AND
5500: (p_trx_alphanumeric_value IS NULL
5501: or p_trx_alphanumeric_value = FND_API.G_MISS_CHAR)
5502: ) THEN
5503: IF (g_level_statement >= g_current_runtime_level ) THEN
5504: FND_LOG.STRING(g_level_statement,
5505: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',

Line 5544: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5540: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5541: l_fsc_rec,
5542: p_return_status);
5543:
5544: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5545: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5546: j := OPTIMAL_FSC_TBL_LOCATION();
5547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5548: ELSE

Line 5545: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);

5541: l_fsc_rec,
5542: p_return_status);
5543:
5544: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5545: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5546: j := OPTIMAL_FSC_TBL_LOCATION();
5547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5548: ELSE
5549: -- Bugfix 4882676: ignore error even if fc not found

Line 5550: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5546: j := OPTIMAL_FSC_TBL_LOCATION();
5547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5548: ELSE
5549: -- Bugfix 4882676: ignore error even if fc not found
5550: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5551: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5552: p_return_status := FND_API.G_RET_STS_SUCCESS;
5553: IF (g_level_statement >= g_current_runtime_level ) THEN
5554: FND_LOG.STRING(g_level_statement,

Line 5551: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5548: ELSE
5549: -- Bugfix 4882676: ignore error even if fc not found
5550: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5551: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5552: p_return_status := FND_API.G_RET_STS_SUCCESS;
5553: IF (g_level_statement >= g_current_runtime_level ) THEN
5554: FND_LOG.STRING(g_level_statement,
5555: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',

Line 5552: p_return_status := FND_API.G_RET_STS_SUCCESS;

5548: ELSE
5549: -- Bugfix 4882676: ignore error even if fc not found
5550: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5551: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5552: p_return_status := FND_API.G_RET_STS_SUCCESS;
5553: IF (g_level_statement >= g_current_runtime_level ) THEN
5554: FND_LOG.STRING(g_level_statement,
5555: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5556: 'PFC not found for Product Org Id. Ignore error...' );

Line 5617: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5613: l_classified_entity_id,
5614: p_return_status,
5615: p_error_buffer );
5616:
5617: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5618: IF (g_level_error >= g_current_runtime_level ) THEN
5619: FND_LOG.STRING(g_level_error,
5620: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5621: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5624: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5620: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5621: 'Incorrect return_status after calling get_tsrm_num_value' ||
5622: ', return_status: ' || p_return_status);
5623: END IF;
5624: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5625: RETURN;
5626: END IF;
5627:
5628: IF l_classification_category = 'PARTY_FISCAL_CLASS'

Line 5650: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5646: l_classified_entity_id,
5647: p_return_status,
5648: p_error_buffer );
5649:
5650: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5651: IF (g_level_error >= g_current_runtime_level ) THEN
5652: FND_LOG.STRING(g_level_error,
5653: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5654: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5657: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5653: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5654: 'Incorrect return_status after calling get_tsrm_num_value' ||
5655: ', return_status: ' || p_return_status);
5656: END IF;
5657: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5658: RETURN;
5659: END IF;
5660:
5661: END IF; -- End of check for classification category and classified entity id

Line 5715: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5711: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5712: l_fsc_rec,
5713: p_return_status);
5714:
5715: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5716: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5717: j := OPTIMAL_FSC_TBL_LOCATION();
5718: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5719: ELSE

Line 5716: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);

5712: l_fsc_rec,
5713: p_return_status);
5714:
5715: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5716: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5717: j := OPTIMAL_FSC_TBL_LOCATION();
5718: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5719: ELSE
5720: -- Bugfix 4882676: ignore error even if fc not found

Line 5721: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5717: j := OPTIMAL_FSC_TBL_LOCATION();
5718: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5719: ELSE
5720: -- Bugfix 4882676: ignore error even if fc not found
5721: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5722: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;
5723: p_return_status := FND_API.G_RET_STS_SUCCESS;
5724: IF (g_level_statement >= g_current_runtime_level ) THEN
5725: FND_LOG.STRING(g_level_statement,

Line 5723: p_return_status := FND_API.G_RET_STS_SUCCESS;

5719: ELSE
5720: -- Bugfix 4882676: ignore error even if fc not found
5721: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5722: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;
5723: p_return_status := FND_API.G_RET_STS_SUCCESS;
5724: IF (g_level_statement >= g_current_runtime_level ) THEN
5725: FND_LOG.STRING(g_level_statement,
5726: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5727: 'ignore error even if fc not found ' );

Line 5735: AND (l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR OR

5731: END IF;
5732: END IF;
5733:
5734: IF l_classification_category = 'PARTY_FISCAL_CLASS'
5735: AND (l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR OR
5736: p_trx_alphanumeric_value = FND_API.G_MISS_CHAR )THEN
5737:
5738: IF l_third_party_flag = 'Y' THEN
5739: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);

Line 5736: p_trx_alphanumeric_value = FND_API.G_MISS_CHAR )THEN

5732: END IF;
5733:
5734: IF l_classification_category = 'PARTY_FISCAL_CLASS'
5735: AND (l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR OR
5736: p_trx_alphanumeric_value = FND_API.G_MISS_CHAR )THEN
5737:
5738: IF l_third_party_flag = 'Y' THEN
5739: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5740: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 5739: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);

5735: AND (l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR OR
5736: p_trx_alphanumeric_value = FND_API.G_MISS_CHAR )THEN
5737:
5738: IF l_third_party_flag = 'Y' THEN
5739: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5740: IF (g_level_procedure >= g_current_runtime_level ) THEN
5741: FND_LOG.STRING(g_level_procedure,
5742: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5743: 'fsc_code: ' || p_trx_alphanumeric_value);

Line 5775: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5771: l_classified_entity_id,
5772: p_return_status,
5773: p_error_buffer );
5774:
5775: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5776: IF (g_level_error >= g_current_runtime_level ) THEN
5777: FND_LOG.STRING(g_level_error,
5778: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5779: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5782: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;

5778: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5779: 'Incorrect return_status after calling get_tsrm_num_value' ||
5780: ', return_status: ' || p_return_status);
5781: END IF;
5782: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR|| FND_API.G_MISS_CHAR;
5783: RETURN;
5784: END IF;
5785:
5786: IF l_classified_entity_id IS NULL AND NOT l_first_party_flag THEN

Line 5787: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR;

5783: RETURN;
5784: END IF;
5785:
5786: IF l_classified_entity_id IS NULL AND NOT l_first_party_flag THEN
5787: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR;
5788: IF (g_level_procedure >= g_current_runtime_level ) THEN
5789: FND_LOG.STRING(g_level_procedure,
5790: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5791: 'fsc_code: ' || p_trx_alphanumeric_value);

Line 5810: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5806: FETCH c_get_le_ptp_id INTO l_classified_entity_id;
5807:
5808: IF c_get_le_ptp_id%NOTFOUND THEN
5809: CLOSE c_get_le_ptp_id;
5810: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5811: IF (g_level_statement >= g_current_runtime_level ) THEN
5812: FND_LOG.STRING(g_level_statement,
5813: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5814: 'Legal Entity PTP Not Found; l_le_id' ||

Line 5859: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5855: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5856: l_fsc_rec,
5857: p_return_status);
5858:
5859: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5860: j := OPTIMAL_FSC_TBL_LOCATION();
5861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE

Line 5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);

5858:
5859: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5860: j := OPTIMAL_FSC_TBL_LOCATION();
5861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE
5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5866: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5860: j := OPTIMAL_FSC_TBL_LOCATION();
5861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE
5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5866: p_return_status := FND_API.G_RET_STS_SUCCESS;
5867: IF (g_level_statement >= g_current_runtime_level ) THEN
5868: FND_LOG.STRING(g_level_statement,

Line 5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE
5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5866: p_return_status := FND_API.G_RET_STS_SUCCESS;
5867: IF (g_level_statement >= g_current_runtime_level ) THEN
5868: FND_LOG.STRING(g_level_statement,
5869: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',

Line 5866: p_return_status := FND_API.G_RET_STS_SUCCESS;

5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE
5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5866: p_return_status := FND_API.G_RET_STS_SUCCESS;
5867: IF (g_level_statement >= g_current_runtime_level ) THEN
5868: FND_LOG.STRING(g_level_statement,
5869: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5870: 'ignore error even if fc not found for LE' );

Line 5892: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5888: l_classified_entity_id,
5889: p_return_status,
5890: p_error_buffer );
5891:
5892: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5893: IF (g_level_error >= g_current_runtime_level ) THEN
5894: FND_LOG.STRING(g_level_error,
5895: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5896: 'Incorrect return_status after calling get_tsrm_num_value for LE' ||

Line 5899: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5895: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5896: 'Incorrect return_status after calling get_tsrm_num_value for LE' ||
5897: ', return_status: ' || p_return_status);
5898: END IF;
5899: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5900: RETURN;
5901: END IF;
5902:
5903: l_le_id := l_classified_entity_id;

Line 5910: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5906: FETCH c_get_le_ptp_id INTO l_classified_entity_id;
5907:
5908: IF c_get_le_ptp_id%NOTFOUND THEN
5909: CLOSE c_get_le_ptp_id;
5910: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5911: IF (g_level_statement >= g_current_runtime_level ) THEN
5912: FND_LOG.STRING(g_level_statement,
5913: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5914: 'Legal Entity PTP Not Found; l_le_id' ||

Line 5957: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5953: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5954: l_fsc_rec,
5955: p_return_status);
5956:
5957: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5958: j := OPTIMAL_FSC_TBL_LOCATION();
5959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE

Line 5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);

5956:
5957: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5958: j := OPTIMAL_FSC_TBL_LOCATION();
5959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE
5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5964: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5958: j := OPTIMAL_FSC_TBL_LOCATION();
5959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE
5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5964: p_return_status := FND_API.G_RET_STS_SUCCESS;
5965: IF (g_level_statement >= g_current_runtime_level ) THEN
5966: FND_LOG.STRING(g_level_statement,

Line 5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

5959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE
5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5964: p_return_status := FND_API.G_RET_STS_SUCCESS;
5965: IF (g_level_statement >= g_current_runtime_level ) THEN
5966: FND_LOG.STRING(g_level_statement,
5967: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',

Line 5964: p_return_status := FND_API.G_RET_STS_SUCCESS;

5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE
5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5964: p_return_status := FND_API.G_RET_STS_SUCCESS;
5965: IF (g_level_statement >= g_current_runtime_level ) THEN
5966: FND_LOG.STRING(g_level_statement,
5967: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5968: 'ignore error even if fc not found for LE' );

Line 5989: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5985: END IF;
5986:
5987: EXCEPTION
5988: WHEN OTHERS THEN
5989: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5990: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5991:
5992: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5993: FND_LOG.STRING(g_level_unexpected,

Line 6034: p_return_status := FND_API.G_RET_STS_SUCCESS;

6030: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info.BEGIN',
6031: 'ZX_TDS_RULE_BASE_DETM_PVT: get_geography_info(+)');
6032: END IF;
6033:
6034: p_return_status := FND_API.G_RET_STS_SUCCESS;
6035:
6036: i := p_condition_index;
6037:
6038: -- Bug#4720542

Line 6064: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

6060: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info',
6061: 'location_id: ' || to_char(l_location_id));
6062: END IF;
6063:
6064: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6065:
6066: /*ZX_TCM_GEO_JUR_PKG.get_zone(
6067: l_location_id,
6068: p_Determining_Factor_Cq_Code,

Line 6109: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6105: END IF;
6106:
6107: EXCEPTION
6108: WHEN OTHERS THEN
6109: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6110: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6111: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6112: FND_LOG.STRING(g_level_unexpected,
6113: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info',

Line 6152: p_return_status := FND_API.G_RET_STS_SUCCESS;

6148: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info.BEGIN',
6149: 'ZX_TDS_RULE_BASE_DETM_PVT: get_master_geography_info(+)');
6150: END IF;
6151:
6152: p_return_status := FND_API.G_RET_STS_SUCCESS;
6153:
6154: i := p_condition_index;
6155:
6156: -- Bug#4720542

Line 6182: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

6178: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',
6179: 'location_id: ' || to_char(l_location_id));
6180: END IF;
6181:
6182: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6183:
6184: IF (g_level_statement >= g_current_runtime_level ) THEN
6185: FND_LOG.STRING(g_level_statement,
6186: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',

Line 6201: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

6197: l_geography_code,
6198: l_geography_name,
6199: p_return_status);
6200:
6201: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6202: p_trx_numeric_value := l_geography_id;
6203: END IF;
6204: end if; -- l_location_id is not null
6205: END IF;

Line 6223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6219: END IF;
6220:
6221: EXCEPTION
6222: WHEN OTHERS THEN
6223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6224: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6226: FND_LOG.STRING(g_level_unexpected,
6227: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',

Line 6267: p_return_status := FND_API.G_RET_STS_SUCCESS;

6263: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_registration_status.BEGIN',
6264: 'ZX_TDS_RULE_BASE_DETM_PVT: get_registration_status(+)');
6265: END IF;
6266:
6267: p_return_status := FND_API.G_RET_STS_SUCCESS;
6268:
6269: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(
6270: p_structure_name => p_structure_name,
6271: p_structure_index => p_structure_index,

Line 6282: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

6278: x_registration_rec => l_registration_rec,
6279: x_return_status => p_return_status
6280: );
6281:
6282: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6283: --Bug 9954561
6284: --p_trx_alphanumeric_value := NVL(l_registration_rec.registration_status_code, 'NOT REGISTERED');
6285: p_trx_alphanumeric_value := NVL(l_registration_rec.registration_status_code, FND_API.G_MISS_CHAR);
6286: ELSE

Line 6285: p_trx_alphanumeric_value := NVL(l_registration_rec.registration_status_code, FND_API.G_MISS_CHAR);

6281:
6282: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6283: --Bug 9954561
6284: --p_trx_alphanumeric_value := NVL(l_registration_rec.registration_status_code, 'NOT REGISTERED');
6285: p_trx_alphanumeric_value := NVL(l_registration_rec.registration_status_code, FND_API.G_MISS_CHAR);
6286: ELSE
6287: IF (g_level_error >= g_current_runtime_level ) THEN
6288: FND_LOG.STRING(g_level_error,
6289: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_registration_status',

Line 6297: p_return_status := FND_API.G_RET_STS_SUCCESS;

6293: FND_LOG.STRING(g_level_error,
6294: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_registration_status.END',
6295: 'ZX_TDS_RULE_BASE_DETM_PVT: get_registration_status(-)');
6296: END IF;
6297: p_return_status := FND_API.G_RET_STS_SUCCESS;
6298: END IF;
6299:
6300: IF (g_level_statement >= g_current_runtime_level ) THEN
6301: FND_LOG.STRING(g_level_statement,

Line 6316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6312: END IF;
6313:
6314: EXCEPTION
6315: WHEN OTHERS THEN
6316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6317: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6318:
6319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6320: FND_LOG.STRING(g_level_unexpected,

Line 6368: p_return_status := FND_API.G_RET_STS_SUCCESS;

6364: ', chart of acct id: ' || to_char(p_chart_of_accounts_id));
6365: END IF;
6366: END IF;
6367:
6368: p_return_status := FND_API.G_RET_STS_SUCCESS;
6369:
6370: --
6371: -- check if this is the correct set of books id
6372: -- get sob id from the transaction

Line 6387: p_return_status := FND_API.G_RET_STS_ERROR;

6383: -- compare sob_id from the transaction with sob_id from the
6384: -- condition group, error if they don't match
6385: --
6386: IF l_sob_id <> p_sob_id THEN
6387: p_return_status := FND_API.G_RET_STS_ERROR;
6388: p_error_buffer := 'LEDGER ID does not match with one from condition group';
6389:
6390: IF (g_level_statement >= g_current_runtime_level ) THEN
6391: FND_LOG.STRING(g_level_statement,

Line 6432: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

6428: g_tax_parameter_code_tbl(i) || '_' || 'STRING',
6429: l_account_string,
6430: p_return_status,
6431: p_error_buffer );
6432: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
6433: l_account_string IS NULL) THEN
6434: --
6435: -- account string is not available, get the info from account ccid
6436: --

Line 6446: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

6442: g_tax_parameter_code_tbl(i) || '_' || 'CCID',
6443: l_ccid,
6444: p_return_status,
6445: p_error_buffer );
6446: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
6447: l_ccid IS NOT NULL ) THEN
6448: IF l_ccid > 0 THEN
6449: IF zx_global_structures_pkg.g_ccid_acct_string_info_tbl.exists(l_ccid) then
6450:

Line 6481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6477:
6478: END IF;
6479:
6480: IF l_account_string IS NULL THEN
6481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6482: p_error_buffer := 'Error when derive Account String';
6483: END IF;
6484: END IF;
6485: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 6485: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

6481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6482: p_error_buffer := 'Error when derive Account String';
6483: END IF;
6484: END IF;
6485: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
6486: l_ccid IS NULL ) THEN
6487: --
6488: -- return success but put message in error buffer
6489: -- to see in log file

Line 6491: p_return_status := FND_API.G_RET_STS_SUCCESS;

6487: --
6488: -- return success but put message in error buffer
6489: -- to see in log file
6490: --
6491: p_return_status := FND_API.G_RET_STS_SUCCESS;
6492: p_error_buffer := 'Both Account String and CCID are NULL';
6493: RETURN;
6494: END IF;
6495: END IF;

Line 6497: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6493: RETURN;
6494: END IF;
6495: END IF;
6496:
6497: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6498:
6499: IF (g_level_statement >= g_current_runtime_level ) THEN
6500: FND_LOG.STRING(g_level_statement,
6501: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_flexfield_info',

Line 6534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6530: END IF;
6531:
6532: EXCEPTION
6533: WHEN OTHERS THEN
6534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6535: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6536:
6537: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6538: FND_LOG.STRING(g_level_unexpected,

Line 6570: p_return_status := FND_API.G_RET_STS_SUCCESS;

6566: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_segment_string.BEGIN',
6567: 'ZX_TDS_RULE_BASE_DETM_PVT: process_segment_string(+)');
6568: END IF;
6569:
6570: p_return_status := FND_API.G_RET_STS_SUCCESS;
6571:
6572: --
6573: -- init accounting segment array
6574: --

Line 6600: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6596: END IF;
6597:
6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6601: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6602: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6603: FND_LOG.STRING(g_level_unexpected,
6604: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_segment_string',

Line 6644: p_return_status := FND_API.G_RET_STS_SUCCESS;

6640: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info.BEGIN',
6641: 'ZX_TDS_RULE_BASE_DETM_PVT: get_product_tax_info (+)');
6642: END IF;
6643:
6644: p_return_status := FND_API.G_RET_STS_SUCCESS;
6645:
6646: --
6647: -- get product id from tsrm
6648: --

Line 6664: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6660: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info',
6661: 'product id: ' || to_char(l_product_id));
6662: END IF;
6663:
6664: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6665: RETURN;
6666: END IF;
6667:
6668: --

Line 6686: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6682: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info',
6683: 'item_org_id: ' || to_char(l_item_org_id));
6684: END IF;
6685:
6686: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6687: RETURN;
6688: END IF;
6689:
6690: --

Line 6709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6705: END IF;
6706:
6707: EXCEPTION
6708: WHEN OTHERS THEN
6709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6710: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6711:
6712: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6713: FND_LOG.STRING(g_level_unexpected,

Line 6758: p_return_status := FND_API.G_RET_STS_SUCCESS;

6754: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_info_from_item.BEGIN',
6755: 'ZX_TDS_RULE_BASE_DETM_PVT: get_tax_info_from_item(+)');
6756: END IF;
6757:
6758: p_return_status := FND_API.G_RET_STS_SUCCESS;
6759:
6760: IF p_determining_factor_code = 'TAX_CLASSIFICATION_CODE' THEN
6761: OPEN get_tax_code_csr(p_product_id,
6762: p_item_org_id);

Line 6766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6762: p_item_org_id);
6763: FETCH get_tax_code_csr INTO p_trx_alphanumeric_value;
6764: CLOSE get_tax_code_csr;
6765: ELSE
6766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6767: p_error_buffer := 'Invalid Determining Factor code for Product class';
6768: END IF;
6769:
6770: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6783: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6779: END IF;
6780:
6781: EXCEPTION
6782: WHEN OTHERS THEN
6783: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6784: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6785:
6786: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6787: FND_LOG.STRING(g_level_unexpected,

Line 6832: p_return_status := FND_API.G_RET_STS_SUCCESS;

6828: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_party_tax_info.BEGIN',
6829: 'ZX_TDS_RULE_BASE_DETM_PVT: get_party_tax_info(+)');
6830: END IF;
6831:
6832: p_return_status := FND_API.G_RET_STS_SUCCESS;
6833:
6834: get_tsrm_num_value(
6835: p_structure_name,
6836: p_structure_index,

Line 6848: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6844: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_party_tax_info',
6845: 'l_tax_profile_id: ' || to_char(l_tax_profile_id));
6846: END IF;
6847:
6848: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6849: RETURN;
6850: END IF;
6851:
6852: IF p_determining_factor_code = 'ESTB_TAX_CLASSIFICATION' THEN

Line 6857: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6853: OPEN get_tax_classification_csr(l_tax_profile_id);
6854: FETCH get_tax_classification_csr INTO p_trx_alphanumeric_value;
6855: CLOSE get_tax_classification_csr;
6856: ELSE
6857: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6858: p_error_buffer := 'Invalid Determining Factor code for Party class';
6859: END IF;
6860:
6861: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6870: END IF;
6871:
6872: EXCEPTION
6873: WHEN OTHERS THEN
6874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6875: p_error_buffer :=sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6876:
6877: CLOSE get_tax_classification_csr;
6878: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 6917: p_return_status := FND_API.G_RET_STS_SUCCESS;

6913: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_condition.BEGIN',
6914: 'ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(+)');
6915: END IF;
6916:
6917: p_return_status := FND_API.G_RET_STS_SUCCESS;
6918:
6919: i := p_condition_index;
6920:
6921: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 6944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6940: g_date_value_tbl(i),
6941: p_trx_date_value);
6942:
6943: ELSE
6944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6945: p_error_buffer := 'Invalid data type';
6946: p_result := FALSE;
6947:
6948: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 6964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6960: END IF;
6961:
6962: EXCEPTION
6963: WHEN OTHERS THEN
6964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6965: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6966:
6967: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6968: FND_LOG.STRING(g_level_unexpected,

Line 7072: p_return_status := FND_API.G_RET_STS_SUCCESS;

7068: 'result_id: ' || p_result_id);
7069: END IF;
7070: END IF;
7071:
7072: p_return_status := FND_API.G_RET_STS_SUCCESS;
7073:
7074: l_condition_set_result := FALSE;
7075: l_exception_set_result := FALSE;
7076:

Line 7160: p_return_status := FND_API.G_RET_STS_ERROR;

7156:
7157: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
7158:
7159: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
7160: p_return_status := FND_API.G_RET_STS_ERROR;
7161:
7162: -- Bug 8568734
7163: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
7164: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',p_zx_result_rec.condition_group_code);

Line 7205: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7201: If select_tax_status_rate_code%NOTFOUND then
7202: --A record does not exist with that tax rate code for the given tax.
7203: --Raise error;
7204:
7205: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7206: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
7207: IF (g_level_error >= g_current_runtime_level ) THEN
7208: FND_LOG.STRING(g_level_error,
7209: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 7269: p_return_status := FND_API.G_RET_STS_ERROR;

7265:
7266: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
7267:
7268: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
7269: p_return_status := FND_API.G_RET_STS_ERROR;
7270:
7271: -- Bug 8568734
7272: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
7273: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',p_zx_result_rec.condition_group_code);

Line 7316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7312: If select_tax_status_rate_code%NOTFOUND then
7313: --A record does not exist with that tax rate code for the given tax.
7314: --Raise error;
7315:
7316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7317: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
7318: IF (g_level_error >= g_current_runtime_level ) THEN
7319: FND_LOG.STRING(g_level_error,
7320: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 7389: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7385: END IF;
7386:
7387: EXCEPTION
7388: WHEN OTHERS THEN
7389: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7390: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
7391: CLOSE get_tax_result_csr;
7392:
7393: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 7791: p_return_status := FND_API.G_RET_STS_SUCCESS;

7787: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.check_templ_tax_parameter.BEGIN',
7788: 'ZX_TDS_RULE_BASE_DETM_PVT: check_templ_tax_parameter(+)');
7789: END IF;
7790:
7791: p_return_status := FND_API.G_RET_STS_SUCCESS;
7792:
7793: --Initialize the return status , p_valid as TRUE
7794: p_valid := TRUE;
7795:

Line 7852: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7848: 'ZX_TDS_RULE_BASE_DETM_PVT: check_templ_tax_parameter(-)');
7849: END IF;
7850: EXCEPTION
7851: WHEN OTHERS THEN
7852: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7853: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7854:
7855: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7856: FND_LOG.STRING(g_level_unexpected,

Line 7914: p_return_status := FND_API.G_RET_STS_SUCCESS;

7910: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.check_rule_geography.BEGIN',
7911: 'ZX_TDS_RULE_BASE_DETM_PVT: check_rule_geography(+)');
7912: END IF;
7913:
7914: p_return_status := FND_API.G_RET_STS_SUCCESS;
7915:
7916: --Initialize the return status , p_valid as FALSE
7917: p_valid := FALSE;
7918: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7918: p_return_status := FND_API.G_RET_STS_SUCCESS;

7914: p_return_status := FND_API.G_RET_STS_SUCCESS;
7915:
7916: --Initialize the return status , p_valid as FALSE
7917: p_valid := FALSE;
7918: p_return_status := FND_API.G_RET_STS_SUCCESS;
7919: --l_count := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.COUNT;
7920:
7921: get_tsrm_num_value(
7922: p_structure_name,

Line 7944: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

7940: l_geography_code,
7941: l_geography_name,
7942: p_return_status);
7943:
7944: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
7945: IF l_geography_id = p_rule_geography_id then
7946: p_valid:=TRUE;
7947:
7948: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 8003: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7999: 'ZX_TDS_RULE_BASE_DETM_PVT: check_rule_geography(-)');
8000: END IF;
8001: EXCEPTION
8002: WHEN OTHERS THEN
8003: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8004: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8005:
8006: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8007: FND_LOG.STRING(g_level_unexpected,

Line 8126: IF p_trx_value = FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR THEN return false;

8122: ', p_chart_of_accounts_id: '||p_chart_of_accounts_id);
8123: END IF;
8124: END IF;
8125:
8126: IF p_trx_value = FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR THEN return false;
8127: END IF;
8128:
8129: -- bug fix: 4874898
8130: IF p_Operator_Code = '=' THEN

Line 8221: IF p_trx_value IS NULL or p_trx_value = FND_API.G_MISS_CHAR THEN

8217: RETURN (INSTR(p_condition_value, l_str ) > 0 );
8218: END IF;
8219: -- Bug 9552043
8220: ELSIF p_operator_code = 'NULL' THEN
8221: IF p_trx_value IS NULL or p_trx_value = FND_API.G_MISS_CHAR THEN
8222: RETURN TRUE;
8223: ELSE
8224: RETURN FALSE;
8225: END IF;

Line 8227: IF p_trx_value IS NULL or p_trx_value = FND_API.G_MISS_CHAR THEN

8223: ELSE
8224: RETURN FALSE;
8225: END IF;
8226: ELSIF p_operator_code = 'NOT_NULL' THEN
8227: IF p_trx_value IS NULL or p_trx_value = FND_API.G_MISS_CHAR THEN
8228: RETURN FALSE;
8229: ELSE
8230: RETURN TRUE;
8231: END IF;