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 424: p_return_status := FND_API.G_RET_STS_SUCCESS;

420: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params.BEGIN',
421: 'ZX_TDS_RULE_BASE_DETM_PVT: init_cec_params (+)');
422: END IF;
423:
424: p_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426: -- Fetch Ship To Party Site Id
427: -- (equivalent of arp_tax.tax_info_rec.ship_to_site_use_id)
428: get_tsrm_num_value(p_structure_name,

Line 592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: 'ZX_TDS_RULE_BASE_DETM_PVT: init_cec_params (-)');
589: END IF;
590: EXCEPTION
591: WHEN OTHERS THEN
592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
594:
595: IF (g_level_unexpected >= g_current_runtime_level ) THEN
596: FND_LOG.STRING(g_level_unexpected,

Line 805: p_return_status := FND_API.G_RET_STS_SUCCESS;

801: ', p_tax_rule_code:' || p_tax_rule_code );
802:
803: END IF;
804:
805: p_return_status := FND_API.G_RET_STS_SUCCESS;
806: l_found := FALSE;
807:
808: --
809: -- check if tax_status_code is null for Tax rate determination

Line 814: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

810: -- return error if it is null
811: --
812: IF (p_service_type_code = 'DET_TAX_RATE' AND
813: p_tax_status_code IS NULL) THEN
814: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: p_error_buffer := 'Tax status code can not be null for Rate Determination';
816:
817: IF (g_level_error >= g_current_runtime_level ) THEN
818: FND_LOG.STRING(g_level_error,

Line 829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

825: END IF;
826:
827: IF (p_service_type_code = 'DET_RECOVERY_RATE' AND
828: p_recovery_type_code IS NULL) THEN
829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: p_error_buffer := 'Recovery type can not be null for DET_RECOVERY_RATE';
831:
832: IF (g_level_error >= g_current_runtime_level ) THEN
833: FND_LOG.STRING(g_level_error,

Line 853: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

849: p_tax_id,
850: p_return_status,
851: p_error_buffer);
852:
853: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
854: IF (g_level_statement >= g_current_runtime_level ) THEN
855: FND_LOG.STRING(g_level_statement,
856: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',
857: 'p_return_status = ' || p_return_status ||

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

885: p_zx_result_rec,
886: p_return_status,
887: p_error_buffer);
888:
889: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS OR l_found)THEN
890: -- return to caller if error occurs or success with a result
891: IF (g_level_error >= g_current_runtime_level ) THEN
892: FND_LOG.STRING(g_level_error,
893: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',

Line 943: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

939: l_rule_geography_id_tbl,
940: p_zx_result_rec,
941: p_return_status,
942: p_error_buffer);
943: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
944: CLOSE get_det_factor_templ_csr_a;
945:
946: IF (g_level_error >= g_current_runtime_level ) THEN
947: FND_LOG.STRING(g_level_error,

Line 1015: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1011: p_zx_result_rec,
1012: p_return_status,
1013: p_error_buffer);
1014:
1015: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1016: CLOSE get_det_factor_templ_csr_b;
1017: IF (g_level_error >= g_current_runtime_level ) THEN
1018: FND_LOG.STRING(g_level_error,
1019: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',

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

1060: p_return_status,
1061: p_error_buffer) ;
1062:
1063: /* Bug 4017396 - included the check for p_return_status*/
1064: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1065: IF (g_level_error >= g_current_runtime_level ) THEN
1066: FND_LOG.STRING(g_level_error,
1067: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',
1068: 'p_return_status = ' || p_return_status ||

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

1073:
1074: END IF; -- p_service_type_code = 'DET_TAX_RATE'/'DET_RECOVERY_RATE' OR ELSE
1075:
1076: /* comment this out as in Phase 1 only rules at tax level are supported.
1077: IF (NOT l_found AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1078:
1079: --
1080: -- traverse the regime hierarchy to get rules
1081: --

Line 1102: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1098: l_found,
1099: l_parent_regime_code_tbl,
1100: p_return_status,
1101: p_error_buffer);
1102: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1103: CLOSE get_regime_code_csr;
1104:
1105: IF (g_level_error >= g_current_runtime_level ) THEN
1106: FND_LOG.STRING(g_level_error,

Line 1149: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1145: END IF;
1146:
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1150: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1151: IF get_det_factor_templ_csr_a%ISOPEN THEN
1152: CLOSE get_det_factor_templ_csr_a;
1153: ELSIF get_det_factor_templ_csr_b%ISOPEN THEN

Line 1265: p_return_status := FND_API.G_RET_STS_SUCCESS;

1261: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code.BEGIN',
1262: 'ZX_TDS_RULE_BASE_DETM_PVT: process_rule_code(+)');
1263: END IF;
1264:
1265: p_return_status := FND_API.G_RET_STS_SUCCESS;
1266:
1267: --
1268: -- determine which cursor to open
1269: --

Line 1306: p_return_status := FND_API.G_RET_STS_ERROR;

1302: END IF;
1303: CLOSE get_offset_templ_csr;
1304: **********************/
1305: ELSE
1306: p_return_status := FND_API.G_RET_STS_ERROR;
1307: p_error_buffer := 'Invalid service type code for the tax rule code';
1308: IF (g_level_error >= g_current_runtime_level ) THEN
1309: FND_LOG.STRING(g_level_error,
1310: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code',

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

1324: p_return_status,
1325: p_error_buffer);
1326:
1327: -- process the template only if its parameters are valid for the given application
1328: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1329:
1330: -- get all the condition groups and conditions
1331: proc_condition_group_per_templ(
1332: p_structure_name,

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

1361: p_return_status,
1362: p_error_buffer);
1363: END IF;
1364: */
1365: -- EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
1366: END IF;
1367: IF (g_level_procedure >= g_current_runtime_level ) THEN
1368: FND_LOG.STRING(g_level_procedure,
1369: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_rule_code',

Line 1378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1374: END IF;
1375:
1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1380: IF get_recovery_templ_csr%ISOPEN THEN
1381: CLOSE get_recovery_templ_csr;
1382: END IF;

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

1559: p_event_class_rec.tax_event_class_code);
1560:
1561: END IF;
1562:
1563: p_return_status := FND_API.G_RET_STS_SUCCESS; --Included as part of Bug fix 4017396
1564:
1565: IF p_event_class_rec.source_event_class_mapping_id IS NOT NULL THEN
1566:
1567: get_tsrm_alphanum_value(

Line 1575: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1571: l_source_event_class_code,
1572: p_return_status,
1573: p_error_buffer);
1574:
1575: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1576: IF (g_level_error >= g_current_runtime_level ) THEN
1577: FND_LOG.STRING(g_level_error,
1578: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.fetch_proc_det_factor_templ',
1579: 'Incorrect return_status after call get_tsrm_alphanum_value().'||

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

1636: p_zx_result_rec,
1637: p_return_status,
1638: p_error_buffer);
1639:
1640: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1641: CLOSE get_det_factor_templ_csr_c;
1642:
1643: IF (g_level_error >= g_current_runtime_level ) THEN
1644: FND_LOG.STRING(g_level_error,

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

1707: p_zx_result_rec,
1708: p_return_status,
1709: p_error_buffer);
1710:
1711: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1712: CLOSE get_det_factor_templ_csr_d;
1713:
1714: IF (g_level_error >= g_current_runtime_level ) THEN
1715: FND_LOG.STRING(g_level_error,

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

1786: p_zx_result_rec,
1787: p_return_status,
1788: p_error_buffer);
1789:
1790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1791: CLOSE get_det_factor_templ_csr_e;
1792:
1793: IF (g_level_error >= g_current_runtime_level ) THEN
1794: FND_LOG.STRING(g_level_error,

Line 1832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1828: END IF;
1829:
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1834: IF get_det_factor_templ_csr_c%ISOPEN THEN
1835: CLOSE get_det_factor_templ_csr_c;
1836: ELSIF get_det_factor_templ_csr_d%ISOPEN THEN

Line 1931: p_return_status := FND_API.G_RET_STS_SUCCESS;

1927: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_rule_from_regime_hier.BEGIN',
1928: 'ZX_TDS_RULE_BASE_DETM_PVT: get_rule_from_regime_hier(+)');
1929: END IF;
1930:
1931: p_return_status := FND_API.G_RET_STS_SUCCESS;
1932:
1933: l_count := p_parent_regime_cd_tbl.count;
1934:
1935: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1991: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1987: l_rule_geography_id_tbl,
1988: p_zx_result_rec,
1989: p_return_status,
1990: p_error_buffer);
1991: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1992: CLOSE get_templ_from_regime_hier_csr;
1993:
1994: IF (g_level_error >= g_current_runtime_level ) THEN
1995: FND_LOG.STRING(g_level_error,

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

2019: IF get_templ_from_regime_hier_csr%ISOPEN THEN
2020: CLOSE get_templ_from_regime_hier_csr;
2021: END IF;
2022:
2023: EXIT WHEN (p_found OR p_return_status = FND_API.G_RET_STS_ERROR);
2024: END LOOP;
2025:
2026: IF (g_level_procedure >= g_current_runtime_level ) THEN
2027: FND_LOG.STRING(g_level_procedure,

Line 2036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2032: END IF;
2033:
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2038: IF get_templ_from_regime_hier_csr%ISOPEN THEN
2039: CLOSE get_templ_from_regime_hier_csr;
2040: END IF;

Line 2097: p_return_status := FND_API.G_RET_STS_SUCCESS;

2093: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_det_factor_templ.BEGIN',
2094: 'ZX_TDS_RULE_BASE_DETM_PVT: proc_det_factor_templ(+)');
2095: END IF;
2096:
2097: p_return_status := FND_API.G_RET_STS_SUCCESS;
2098: l_valid := TRUE;
2099:
2100: l_count := p_det_factor_templ_cd_tbl.count;
2101:

Line 2142: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2138: p_return_status,
2139: p_error_buffer);
2140: END IF;
2141:
2142: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2143: IF g_level_error >= g_current_runtime_level THEN
2144: FND_LOG.STRING(g_level_error,
2145: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_det_factor_templ',
2146: ' check_rule_geography returned Error');

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

2151:
2152: --Continue processing the Rule only if the Rule's geography
2153: --matched with the one cached in the gloabl location structure
2154:
2155: IF(l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2156: --
2157: -- process 1 template at a time
2158: --
2159:

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

2176: p_return_status,
2177: p_error_buffer);
2178:
2179: -- process the template only if it is valid for the given application
2180: IF (l_valid AND p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2181:
2182: -- get all the condition groups and conditions
2183: proc_condition_group_per_templ(
2184: p_structure_name,

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

2214: p_return_status,
2215: p_error_buffer);
2216: END IF; --l_result
2217: */
2218: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
2219: END IF; --l_valid
2220: END IF; --l_valid for check_rule_geography
2221: END LOOP;
2222:

Line 2231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2227: END IF;
2228:
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2233:
2234: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2235: FND_LOG.STRING(g_level_unexpected,

Line 2467: p_return_status := FND_API.G_RET_STS_SUCCESS;

2463: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ.BEGIN',
2464: 'ZX_TDS_RULE_BASE_DETM_PVT: proc_condition_group_per_templ(+)');
2465: END IF;
2466:
2467: p_return_status := FND_API.G_RET_STS_SUCCESS;
2468: l_constraint_result := FALSE;
2469: l_condition_group_evaluated := FALSE;
2470:
2471: -- reset the left hand side trx value for a new unevaluated template.

Line 2679: p_return_status := FND_API.G_RET_STS_ERROR;

2675:
2676: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
2677:
2678: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
2679: p_return_status := FND_API.G_RET_STS_ERROR;
2680: IF (g_level_error >= g_current_runtime_level ) THEN
2681: FND_LOG.STRING(g_level_error,
2682: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',
2683: 'Action_code is ERROR_MESSAGE or SYSTEM_ERROR');

Line 2904: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2900: -- if p_return_status = ERROR from process_set_condition
2901: -- that means get_trx_value results in error while trying to get
2902: -- transaction values, return to calling process immediately
2903: --
2904: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2905: CLOSE get_condition_group_codes_csr;
2906: IF (g_level_error >= g_current_runtime_level ) THEN
2907: FND_LOG.STRING(g_level_error,
2908: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',

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

2942: p_found,
2943: p_zx_result_rec,
2944: p_return_status,
2945: p_error_buffer);
2946: EXIT WHEN (p_found OR p_return_status <> FND_API.G_RET_STS_SUCCESS);
2947: END IF;
2948: END LOOP;
2949:
2950: IF (get_condition_group_codes_csr%notfound OR p_result) THEN

Line 2979: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2975: END IF;
2976:
2977: EXCEPTION
2978: WHEN OTHERS THEN
2979: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2980: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2981: IF get_condition_group_codes_csr%ISOPEN THEN
2982: CLOSE get_condition_group_codes_csr;
2983: END IF;

Line 3059: p_return_status := FND_API.G_RET_STS_SUCCESS;

3055: 'p_condition_group_code: ' || p_condition_group_code);
3056:
3057: END IF;
3058:
3059: p_return_status := FND_API.G_RET_STS_SUCCESS;
3060:
3061: l_condition_result := TRUE;
3062:
3063: --

Line 3096: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3092: p_return_status,
3093: p_error_buffer);
3094:
3095:
3096: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3097: CLOSE get_condition_csr;
3098: IF (g_level_error >= g_current_runtime_level ) THEN
3099: FND_LOG.STRING(g_level_error,
3100: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_and_process_condition',

Line 3135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3131: END IF;
3132:
3133: EXCEPTION
3134: WHEN OTHERS THEN
3135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3136: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3137: IF get_condition_csr%ISOPEN THEN
3138: CLOSE get_condition_csr;
3139: END IF;

Line 3332: p_return_status := FND_API.G_RET_STS_SUCCESS;

3328: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition.BEGIN',
3329: 'ZX_TDS_RULE_BASE_DETM_PVT: process_set_condition(+)');
3330: END IF;
3331:
3332: p_return_status := FND_API.G_RET_STS_SUCCESS;
3333:
3334: l_count := g_determining_factor_code_tbl.count;
3335:
3336: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3369: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3365: p_result,
3366: p_return_status,
3367: p_error_buffer);
3368:
3369: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3370:
3371: IF (g_level_error >= g_current_runtime_level ) THEN
3372: FND_LOG.STRING(g_level_error,
3373: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3406: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3402: p_sob_id,
3403: p_return_status,
3404: p_error_buffer);
3405:
3406: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3407:
3408: IF (g_level_error >= g_current_runtime_level ) THEN
3409: FND_LOG.STRING(g_level_error,
3410: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3422: p_return_status := FND_API.G_RET_STS_SUCCESS;

3418: -- process immediately
3419: --
3420:
3421: IF g_determining_factor_class_tbl(k) = 'ACCOUNTING_FLEXFIELD' THEN
3422: p_return_status := FND_API.G_RET_STS_SUCCESS;
3423: END IF;
3424:
3425: RETURN;
3426: END IF;

Line 3473: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3469: p_sob_id,
3470: p_return_status,
3471: p_error_buffer);
3472:
3473: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3474:
3475: IF (g_level_error >= g_current_runtime_level ) THEN
3476: FND_LOG.STRING(g_level_error,
3477: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition',

Line 3538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3534: END IF;
3535:
3536: EXCEPTION
3537: WHEN OTHERS THEN
3538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3540:
3541: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3542: FND_LOG.STRING(g_level_unexpected,

Line 3591: p_return_status := FND_API.G_RET_STS_SUCCESS;

3587: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value.BEGIN',
3588: 'ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value(+)');
3589: END IF;
3590:
3591: p_return_status := FND_API.G_RET_STS_SUCCESS;
3592:
3593: i := p_condition_index;
3594:
3595: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3617: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3613: p_alphanum_value,
3614: p_date_value,
3615: p_return_status,
3616: p_error_buffer);
3617: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3618: IF p_alphanum_value IS NULL THEN
3619: --
3620: -- OUTPUT_TAX_CLASSIFICATION_CODE is null,
3621: -- use INPUT_TAX_CLASSIFICATION_CODE

Line 3815: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3811: p_return_status,
3812: p_error_buffer);
3813: */
3814: END IF;
3815: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3816: -- update trx value cache structure
3817: /* Bug 5003413 */
3818: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
3819: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 3841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3837: END IF;
3838:
3839: EXCEPTION
3840: WHEN OTHERS THEN
3841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3842: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3843: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3844: FND_LOG.STRING(g_level_unexpected,
3845: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value',

Line 3891: p_return_status := FND_API.G_RET_STS_SUCCESS;

3887: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl.BEGIN',
3888: 'ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl(+)');
3889: END IF;
3890:
3891: p_return_status := FND_API.G_RET_STS_SUCCESS;
3892:
3893: i := p_condition_index;
3894: p_result := FALSE;
3895:

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

3909: p_tax_determine_date,
3910: p_return_status,
3911: p_error_buffer);
3912:
3913: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3914: IF (g_level_error >= g_current_runtime_level ) THEN
3915: FND_LOG.STRING(g_level_error,
3916: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
3917: 'Incorrect return_status after calling get_geography_info()' ||

Line 3944: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3940: p_chart_of_accounts_id,
3941: p_result,
3942: p_return_status,
3943: p_error_buffer);
3944: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3945: IF (g_level_error >= g_current_runtime_level ) THEN
3946: FND_LOG.STRING(g_level_error,
3947: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
3948: 'Incorrect return_status after calling evaluate_condition()' ||

Line 3980: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3976: p_chart_of_accounts_id,
3977: p_result,
3978: p_return_status,
3979: p_error_buffer);
3980: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3981: IF (g_level_error >= g_current_runtime_level ) THEN
3982: FND_LOG.STRING(g_level_error,
3983: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',
3984: 'Incorrect return_status after calling evaluate_condition()' ||

Line 4002: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3998: END IF;
3999:
4000: EXCEPTION
4001: WHEN OTHERS THEN
4002: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4003: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4005: FND_LOG.STRING(g_level_unexpected,
4006: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl',

Line 4045: p_return_status := FND_API.G_RET_STS_SUCCESS;

4041: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_parameter_value.BEGIN',
4042: 'ZX_TDS_RULE_BASE_DETM_PVT: get_tsrm_parameter_value(+)');
4043: END IF;
4044:
4045: p_return_status := FND_API.G_RET_STS_SUCCESS;
4046:
4047: i := p_condition_index;
4048:
4049: IF g_data_type_tbl(i) = 'NUMERIC' THEN

Line 4101: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4097: ', p_alphanum_value: ' || p_alphanum_value );
4098: END IF;
4099: ELSE
4100:
4101: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4102: p_error_buffer := 'Invalid data type';
4103: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4104: FND_LOG.STRING(g_level_unexpected,
4105: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_parameter_value',

Line 4121: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4117: END IF;
4118:
4119: EXCEPTION
4120: WHEN OTHERS THEN
4121: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4122: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4123:
4124: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4125: FND_LOG.STRING(g_level_unexpected,

Line 4164: p_return_status := FND_API.G_RET_STS_SUCCESS;

4160: FND_LOG.STRING(g_level_statement ,
4161: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value',
4162: 'p_parameter_code: ' || p_parameter_code );
4163: END IF;
4164: p_return_status := FND_API.G_RET_STS_SUCCESS;
4165:
4166: -- commenting caching as no value check is possible at this point.
4167: -- for checking if the value in cache is matching the current transaction value
4168: -- we need to call get_driver_value

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

4184: p_trx_numeric_value,
4185: p_return_status
4186: );
4187:
4188: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4189: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4190: --END IF;
4191: --END IF;
4192:

Line 4206: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4202: END IF;
4203:
4204: EXCEPTION
4205: WHEN OTHERS THEN
4206: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4207: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4208:
4209: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4210: FND_LOG.STRING(g_level_unexpected,

Line 4249: p_return_status := FND_API.G_RET_STS_SUCCESS;

4245: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_alphanum_value',
4246: 'p_parameter_code: ' || p_parameter_code );
4247: END IF;
4248:
4249: p_return_status := FND_API.G_RET_STS_SUCCESS;
4250:
4251: -- commenting caching as no value check is possible at this point.
4252: -- for checking if the value in cache is matching the current transaction value
4253: -- we need to call get_driver_value

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

4268: p_parameter_code,
4269: p_trx_alphanumeric_value,
4270: p_return_status
4271: );
4272: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4273: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4274: --END IF;
4275: --END IF;
4276:

Line 4290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4286: END IF;
4287:
4288: EXCEPTION
4289: WHEN OTHERS THEN
4290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4291: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4292:
4293: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4294: FND_LOG.STRING(g_level_unexpected,

Line 4333: p_return_status := FND_API.G_RET_STS_SUCCESS;

4329: FND_LOG.STRING(g_level_statement ,
4330: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_num_value',
4331: 'p_parameter_code: ' || p_parameter_code );
4332: END IF;
4333: p_return_status := FND_API.G_RET_STS_SUCCESS;
4334:
4335: l_table_index := dbms_utility.get_hash_value(
4336: p_parameter_code,
4337: 1,

Line 4357: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4353: p_trx_numeric_value,
4354: p_return_status
4355: );
4356:
4357: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4359: END IF;
4360: END IF;
4361:

Line 4375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4371: END IF;
4372:
4373: EXCEPTION
4374: WHEN OTHERS THEN
4375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4376: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4377:
4378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4379: FND_LOG.STRING(g_level_unexpected,

Line 4419: p_return_status := FND_API.G_RET_STS_SUCCESS;

4415: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_alphanum_value',
4416: 'p_parameter_code: ' || p_parameter_code );
4417: END IF;
4418:
4419: p_return_status := FND_API.G_RET_STS_SUCCESS;
4420:
4421: l_table_index := dbms_utility.get_hash_value(
4422: p_parameter_code,
4423: 1,

Line 4442: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4438: p_parameter_code,
4439: p_trx_alphanumeric_value,
4440: p_return_status
4441: );
4442: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4444: END IF;
4445: END IF;
4446:

Line 4460: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4503: p_return_status := FND_API.G_RET_STS_SUCCESS;

4499: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_user_item_type_value.BEGIN',
4500: 'ZX_TDS_RULE_BASE_DETM_PVT: get_user_item_type_value(+)');
4501: END IF;
4502:
4503: p_return_status := FND_API.G_RET_STS_SUCCESS;
4504:
4505: i := p_condition_index;
4506:
4507: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 4526: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4522: ', p_alphanum_value: ' || p_alphanum_value );
4523: END IF;
4524: ELSE
4525:
4526: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4527: p_error_buffer := 'Invalid data type';
4528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4529: FND_LOG.STRING(g_level_unexpected,
4530: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_user_item_type_value',

Line 4546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4593: p_return_status := FND_API.G_RET_STS_SUCCESS;

4589: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_user_item_alphanum_value',
4590: 'p_parameter_code: ' || p_parameter_code );
4591: END IF;
4592:
4593: p_return_status := FND_API.G_RET_STS_SUCCESS;
4594:
4595: l_table_index := dbms_utility.get_hash_value(
4596: p_parameter_code,
4597: 1,

Line 4637: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4734: p_return_status := FND_API.G_RET_STS_SUCCESS;

4730: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc.BEGIN',
4731: 'ZX_TDS_RULE_BASE_DETM_PVT: get_fc(+)');
4732: END IF;
4733:
4734: p_return_status := FND_API.G_RET_STS_SUCCESS;
4735:
4736: i := p_condition_index;
4737:
4738: l_classification_category := g_determining_factor_class_tbl(i);

Line 4773: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4769: l_prod_trx_parm_value,
4770: p_return_status,
4771: p_error_buffer );
4772:
4773: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4774: IF (g_level_error >= g_current_runtime_level ) THEN
4775: FND_LOG.STRING(g_level_error,
4776: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
4777: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||

Line 4818: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4814: ZX_TCM_CONTROL_PKG.GET_PROD_TRX_CATE_VALUE(
4815: l_fsc_cat_rec,
4816: p_return_status);
4817:
4818: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4819: p_trx_alphanumeric_value := l_fsc_cat_rec.condition_value;
4820: END IF;
4821:
4822: END IF; -- Null Class Qualifier

Line 4837: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4833: l_prod_trx_parm_value,
4834: p_return_status,
4835: p_error_buffer );
4836:
4837: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4838: IF (g_level_error >= g_current_runtime_level ) THEN
4839: FND_LOG.STRING(g_level_error,
4840: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
4841: 'Incorrect return_status after calling get_tsrm_alphanum_value()' ||

Line 4862: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

4858: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
4859: l_fsc_rec,
4860: p_return_status);
4861:
4862: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4863: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
4864: ELSE
4865: -- Bugfix 4882676: ignore error even if fc not found
4866: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4866: p_return_status := FND_API.G_RET_STS_SUCCESS;

4862: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4863: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
4864: ELSE
4865: -- Bugfix 4882676: ignore error even if fc not found
4866: p_return_status := FND_API.G_RET_STS_SUCCESS;
4867: IF (g_level_statement >= g_current_runtime_level ) THEN
4868: FND_LOG.STRING(g_level_statement,
4869: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
4870: 'ignore error even if fc not found ' );

Line 4910: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4906: l_default_taxation_country,
4907: p_return_status,
4908: p_error_buffer );
4909:
4910: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4911: IF (g_level_error >= g_current_runtime_level ) THEN
4912: FND_LOG.STRING(g_level_error,
4913: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
4914: 'Called get_tsrm_num_value to get DEFAULT_TAXATION_COUNTRY' ||

Line 4943: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4939: l_product_fisc_classification,
4940: p_return_status,
4941: p_error_buffer );
4942:
4943: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4944: IF (g_level_error >= g_current_runtime_level ) THEN
4945: FND_LOG.STRING(g_level_error,
4946: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
4947: 'Called get_tsrm_num_value to get PRODUCT_FISC_CLASSIFICATION' ||

Line 5008: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5004: l_classified_entity_id,
5005: p_return_status,
5006: p_error_buffer );
5007:
5008: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5009: IF (g_level_error >= g_current_runtime_level ) THEN
5010: FND_LOG.STRING(g_level_error,
5011: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5012: 'Called get_tsrm_num_value to get PRODUCT_ID' ||

Line 5029: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5025: l_item_org_id,
5026: p_return_status,
5027: p_error_buffer );
5028:
5029: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5030: IF (g_level_error >= g_current_runtime_level ) THEN
5031: FND_LOG.STRING(g_level_error,
5032: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5033: 'Called get_tsrm_num_value to get PRODUCT_ORG_ID' ||

Line 5092: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5088: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5089: l_fsc_rec,
5090: p_return_status);
5091:
5092: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5093: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5094: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5095: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5096:

Line 5099: p_return_status := FND_API.G_RET_STS_SUCCESS;

5095: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5096:
5097: ELSE
5098: -- Bugfix 4882676: ignore error even if fc not found
5099: p_return_status := FND_API.G_RET_STS_SUCCESS;
5100: IF (g_level_statement >= g_current_runtime_level ) THEN
5101: FND_LOG.STRING(g_level_statement,
5102: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5103: 'ignore error even if fc not found ' );

Line 5165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5161: l_classified_entity_id,
5162: p_return_status,
5163: p_error_buffer );
5164:
5165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5166: IF (g_level_error >= g_current_runtime_level ) THEN
5167: FND_LOG.STRING(g_level_error,
5168: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5169: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5198: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5194: l_classified_entity_id,
5195: p_return_status,
5196: p_error_buffer );
5197:
5198: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5199: IF (g_level_error >= g_current_runtime_level ) THEN
5200: FND_LOG.STRING(g_level_error,
5201: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5202: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5261: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5257: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5258: l_fsc_rec,
5259: p_return_status);
5260:
5261: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5262:
5263: IF (l_classification_category = 'PARTY_FISCAL_CLASS' AND l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR)
5264: OR (l_classification_category <> 'PARTY_FISCAL_CLASS') THEN
5265: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;

Line 5263: IF (l_classification_category = 'PARTY_FISCAL_CLASS' AND l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR)

5259: p_return_status);
5260:
5261: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5262:
5263: IF (l_classification_category = 'PARTY_FISCAL_CLASS' AND l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR)
5264: OR (l_classification_category <> 'PARTY_FISCAL_CLASS') THEN
5265: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5266: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5267: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

Line 5272: p_return_status := FND_API.G_RET_STS_SUCCESS;

5268: END IF;
5269:
5270: ELSE
5271: -- Bugfix 4882676: ignore error even if fc not found
5272: p_return_status := FND_API.G_RET_STS_SUCCESS;
5273: IF (g_level_statement >= g_current_runtime_level ) THEN
5274: FND_LOG.STRING(g_level_statement,
5275: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5276: 'ignore error even if fc not found ' );

Line 5285: AND l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR THEN

5281: END IF;
5282: END IF;
5283:
5284: IF l_classification_category = 'PARTY_FISCAL_CLASS'
5285: AND l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR THEN
5286:
5287: l_fsc_rec.fsc_code := NULL;
5288:
5289: IF l_third_party_flag = 'Y' THEN

Line 5326: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5322: l_classified_entity_id,
5323: p_return_status,
5324: p_error_buffer );
5325:
5326: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5327: IF (g_level_error >= g_current_runtime_level ) THEN
5328: FND_LOG.STRING(g_level_error,
5329: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5330: 'Incorrect return_status after calling get_tsrm_num_value' ||

Line 5408: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5404: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5405: l_fsc_rec,
5406: p_return_status);
5407:
5408: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5409: IF l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR THEN
5410: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

Line 5409: IF l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR THEN

5405: l_fsc_rec,
5406: p_return_status);
5407:
5408: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5409: IF l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR THEN
5410: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5413: END IF;

Line 5415: p_return_status := FND_API.G_RET_STS_SUCCESS;

5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5413: END IF;
5414: ELSE
5415: p_return_status := FND_API.G_RET_STS_SUCCESS;
5416: IF (g_level_statement >= g_current_runtime_level ) THEN
5417: FND_LOG.STRING(g_level_statement,
5418: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5419: 'ignore error even if fc not found for LE' );

Line 5442: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5438: l_classified_entity_id,
5439: p_return_status,
5440: p_error_buffer );
5441:
5442: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5443: IF (g_level_error >= g_current_runtime_level ) THEN
5444: FND_LOG.STRING(g_level_error,
5445: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5446: 'Incorrect return_status after calling get_tsrm_num_value for LE' ||

Line 5505: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5501: ZX_TCM_CONTROL_PKG.GET_FISCAL_CLASSIFICATION(
5502: l_fsc_rec,
5503: p_return_status);
5504:
5505: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5506: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5507: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5509: ELSE

Line 5510: p_return_status := FND_API.G_RET_STS_SUCCESS;

5506: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5507: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5509: ELSE
5510: p_return_status := FND_API.G_RET_STS_SUCCESS;
5511: IF (g_level_statement >= g_current_runtime_level ) THEN
5512: FND_LOG.STRING(g_level_statement,
5513: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_fc',
5514: 'ignore error even if fc not found for LE' );

Line 5522: IF l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR THEN

5518: END IF; -- End for internal l_found check
5519:
5520: END IF; -- End for getting LE FC
5521:
5522: IF l_fsc_rec.fsc_code = FND_API.G_MISS_CHAR THEN
5523: p_trx_alphanumeric_value := NULL;
5524: END IF;
5525:
5526:

Line 5542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5538: END IF;
5539:
5540: EXCEPTION
5541: WHEN OTHERS THEN
5542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5543: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5544:
5545: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5546: FND_LOG.STRING(g_level_unexpected,

Line 5589: p_return_status := FND_API.G_RET_STS_SUCCESS;

5585: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info.BEGIN',
5586: 'ZX_TDS_RULE_BASE_DETM_PVT: get_geography_info(+)');
5587: END IF;
5588:
5589: p_return_status := FND_API.G_RET_STS_SUCCESS;
5590:
5591: i := p_condition_index;
5592:
5593: -- Bug#4720542

Line 5619: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5615: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info',
5616: 'location_id: ' || to_char(l_location_id));
5617: END IF;
5618:
5619: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5620:
5621: /*ZX_TCM_GEO_JUR_PKG.get_zone(
5622: l_location_id,
5623: p_Determining_Factor_Cq_Code,

Line 5657: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5653: END IF;
5654:
5655: EXCEPTION
5656: WHEN OTHERS THEN
5657: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5658: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5659: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5660: FND_LOG.STRING(g_level_unexpected,
5661: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info',

Line 5701: p_return_status := FND_API.G_RET_STS_SUCCESS;

5697: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info.BEGIN',
5698: 'ZX_TDS_RULE_BASE_DETM_PVT: get_master_geography_info(+)');
5699: END IF;
5700:
5701: p_return_status := FND_API.G_RET_STS_SUCCESS;
5702:
5703: i := p_condition_index;
5704:
5705: -- Bug#4720542

Line 5731: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5727: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',
5728: 'location_id: ' || to_char(l_location_id));
5729: END IF;
5730:
5731: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5732:
5733: IF (g_level_statement >= g_current_runtime_level ) THEN
5734: FND_LOG.STRING(g_level_statement,
5735: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',

Line 5750: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5746: l_geography_code,
5747: l_geography_name,
5748: p_return_status);
5749:
5750: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5751: p_trx_numeric_value := l_geography_id;
5752: END IF;
5753: end if; -- l_location_id is not null
5754: END IF;

Line 5772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5768: END IF;
5769:
5770: EXCEPTION
5771: WHEN OTHERS THEN
5772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5773: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5774: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5775: FND_LOG.STRING(g_level_unexpected,
5776: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_master_geography_info',

Line 5818: p_return_status := FND_API.G_RET_STS_SUCCESS;

5814: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_registration_status.BEGIN',
5815: 'ZX_TDS_RULE_BASE_DETM_PVT: get_registration_status(+)');
5816: END IF;
5817:
5818: p_return_status := FND_API.G_RET_STS_SUCCESS;
5819:
5820: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(
5821: p_structure_name => p_structure_name,
5822: p_structure_index => p_structure_index,

Line 5833: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

5829: x_registration_rec => l_registration_rec,
5830: x_return_status => p_return_status
5831: );
5832:
5833: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5834: p_trx_alphanumeric_value := l_registration_rec.registration_status_code;
5835: ELSE
5836: IF (g_level_error >= g_current_runtime_level ) THEN
5837: FND_LOG.STRING(g_level_error,

Line 5846: p_return_status := FND_API.G_RET_STS_SUCCESS;

5842: FND_LOG.STRING(g_level_error,
5843: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_registration_status.END',
5844: 'ZX_TDS_RULE_BASE_DETM_PVT: get_registration_status(-)');
5845: END IF;
5846: p_return_status := FND_API.G_RET_STS_SUCCESS;
5847: END IF;
5848:
5849: IF (g_level_statement >= g_current_runtime_level ) THEN
5850: FND_LOG.STRING(g_level_statement,

Line 5865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5861: END IF;
5862:
5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5866: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5867:
5868: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5869: FND_LOG.STRING(g_level_unexpected,

Line 5917: p_return_status := FND_API.G_RET_STS_SUCCESS;

5913: 'sob id: ' || to_char(p_sob_id) ||
5914: ', chart of acct id: ' || to_char(p_chart_of_accounts_id));
5915: END IF;
5916:
5917: p_return_status := FND_API.G_RET_STS_SUCCESS;
5918:
5919: --
5920: -- check if this is the correct set of books id
5921: -- get sob id from the transaction

Line 5936: p_return_status := FND_API.G_RET_STS_ERROR;

5932: -- compare sob_id from the transaction with sob_id from the
5933: -- condition group, error if they don't match
5934: --
5935: IF l_sob_id <> p_sob_id THEN
5936: p_return_status := FND_API.G_RET_STS_ERROR;
5937: p_error_buffer := 'LEDGER ID does not match with one from condition group';
5938:
5939: IF (g_level_statement >= g_current_runtime_level ) THEN
5940: FND_LOG.STRING(g_level_statement,

Line 5981: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

5977: g_tax_parameter_code_tbl(i) || '_' || 'STRING',
5978: l_account_string,
5979: p_return_status,
5980: p_error_buffer );
5981: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
5982: l_account_string IS NULL) THEN
5983: --
5984: -- account string is not available, get the info from account ccid
5985: --

Line 5995: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

5991: g_tax_parameter_code_tbl(i) || '_' || 'CCID',
5992: l_ccid,
5993: p_return_status,
5994: p_error_buffer );
5995: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
5996: l_ccid IS NOT NULL ) THEN
5997: IF l_ccid > 0 THEN
5998: IF zx_global_structures_pkg.g_ccid_acct_string_info_tbl.exists(l_ccid) then
5999:

Line 6030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6026:
6027: END IF;
6028:
6029: IF l_account_string IS NULL THEN
6030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6031: p_error_buffer := 'Error when derive Account String';
6032: END IF;
6033: END IF;
6034: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 6034: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

6030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6031: p_error_buffer := 'Error when derive Account String';
6032: END IF;
6033: END IF;
6034: ELSIF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
6035: l_ccid IS NULL ) THEN
6036: --
6037: -- return success but put message in error buffer
6038: -- to see in log file

Line 6040: p_return_status := FND_API.G_RET_STS_SUCCESS;

6036: --
6037: -- return success but put message in error buffer
6038: -- to see in log file
6039: --
6040: p_return_status := FND_API.G_RET_STS_SUCCESS;
6041: p_error_buffer := 'Both Account String and CCID are NULL';
6042: RETURN;
6043: END IF;
6044: END IF;

Line 6046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6042: RETURN;
6043: END IF;
6044: END IF;
6045:
6046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6047:
6048: IF (g_level_statement >= g_current_runtime_level ) THEN
6049: FND_LOG.STRING(g_level_statement,
6050: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_account_flexfield_info',

Line 6079: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6075: END IF;
6076:
6077: EXCEPTION
6078: WHEN OTHERS THEN
6079: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6080: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6081:
6082: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6083: FND_LOG.STRING(g_level_unexpected,

Line 6117: p_return_status := FND_API.G_RET_STS_SUCCESS;

6113: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_segment_string.BEGIN',
6114: 'ZX_TDS_RULE_BASE_DETM_PVT: process_segment_string(+)');
6115: END IF;
6116:
6117: p_return_status := FND_API.G_RET_STS_SUCCESS;
6118:
6119: --
6120: -- init accounting segment array
6121: --

Line 6147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6143: END IF;
6144:
6145: EXCEPTION
6146: WHEN OTHERS THEN
6147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6148: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6149: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6150: FND_LOG.STRING(g_level_unexpected,
6151: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_segment_string',

Line 6191: p_return_status := FND_API.G_RET_STS_SUCCESS;

6187: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info.BEGIN',
6188: 'ZX_TDS_RULE_BASE_DETM_PVT: get_product_tax_info (+)');
6189: END IF;
6190:
6191: p_return_status := FND_API.G_RET_STS_SUCCESS;
6192:
6193: --
6194: -- get product id from tsrm
6195: --

Line 6211: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6207: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info',
6208: 'product id: ' || to_char(l_product_id));
6209: END IF;
6210:
6211: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6212: RETURN;
6213: END IF;
6214:
6215: --

Line 6233: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6229: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_product_tax_info',
6230: 'item_org_id: ' || to_char(l_item_org_id));
6231: END IF;
6232:
6233: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6234: RETURN;
6235: END IF;
6236:
6237: --

Line 6256: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6252: END IF;
6253:
6254: EXCEPTION
6255: WHEN OTHERS THEN
6256: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6257: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6258:
6259: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6260: FND_LOG.STRING(g_level_unexpected,

Line 6307: p_return_status := FND_API.G_RET_STS_SUCCESS;

6303: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_info_from_item.BEGIN',
6304: 'ZX_TDS_RULE_BASE_DETM_PVT: get_tax_info_from_item(+)');
6305: END IF;
6306:
6307: p_return_status := FND_API.G_RET_STS_SUCCESS;
6308:
6309: IF p_determining_factor_code = 'TAX_CLASSIFICATION_CODE' THEN
6310: OPEN get_tax_code_csr(p_product_id,
6311: p_item_org_id);

Line 6315: p_return_status := FND_API.G_RET_STS_ERROR;

6311: p_item_org_id);
6312: FETCH get_tax_code_csr INTO p_trx_alphanumeric_value;
6313: CLOSE get_tax_code_csr;
6314: ELSE
6315: p_return_status := FND_API.G_RET_STS_ERROR;
6316: p_error_buffer := 'Invalid Determining Factor code for Product class';
6317: END IF;
6318:
6319: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6332: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6328: END IF;
6329:
6330: EXCEPTION
6331: WHEN OTHERS THEN
6332: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6333: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6334:
6335: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6336: FND_LOG.STRING(g_level_unexpected,

Line 6383: p_return_status := FND_API.G_RET_STS_SUCCESS;

6379: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_party_tax_info.BEGIN',
6380: 'ZX_TDS_RULE_BASE_DETM_PVT: get_party_tax_info(+)');
6381: END IF;
6382:
6383: p_return_status := FND_API.G_RET_STS_SUCCESS;
6384:
6385: get_tsrm_num_value(
6386: p_structure_name,
6387: p_structure_index,

Line 6399: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6395: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_party_tax_info',
6396: 'l_tax_profile_id: ' || to_char(l_tax_profile_id));
6397: END IF;
6398:
6399: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6400: RETURN;
6401: END IF;
6402:
6403: IF p_determining_factor_code = 'ESTB_TAX_CLASSIFICATION' THEN

Line 6408: p_return_status := FND_API.G_RET_STS_ERROR;

6404: OPEN get_tax_classification_csr(l_tax_profile_id);
6405: FETCH get_tax_classification_csr INTO p_trx_alphanumeric_value;
6406: CLOSE get_tax_classification_csr;
6407: ELSE
6408: p_return_status := FND_API.G_RET_STS_ERROR;
6409: p_error_buffer := 'Invalid Determining Factor code for Party class';
6410: END IF;
6411:
6412: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6421: END IF;
6422:
6423: EXCEPTION
6424: WHEN OTHERS THEN
6425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6426: p_error_buffer :=sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6427:
6428: CLOSE get_tax_classification_csr;
6429: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 6468: p_return_status := FND_API.G_RET_STS_SUCCESS;

6464: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_condition.BEGIN',
6465: 'ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(+)');
6466: END IF;
6467:
6468: p_return_status := FND_API.G_RET_STS_SUCCESS;
6469:
6470: i := p_condition_index;
6471:
6472: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN

Line 6495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6491: g_date_value_tbl(i),
6492: p_trx_date_value);
6493:
6494: ELSE
6495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6496: p_error_buffer := 'Invalid data type';
6497: p_result := FALSE;
6498:
6499: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 6515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6511: END IF;
6512:
6513: EXCEPTION
6514: WHEN OTHERS THEN
6515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6516: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6517:
6518: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6519: FND_LOG.STRING(g_level_unexpected,

Line 6625: p_return_status := FND_API.G_RET_STS_SUCCESS;

6621: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
6622: 'result_id: ' || p_result_id);
6623: END IF;
6624:
6625: p_return_status := FND_API.G_RET_STS_SUCCESS;
6626:
6627: l_condition_set_result := FALSE;
6628: l_exception_set_result := FALSE;
6629:

Line 6713: p_return_status := FND_API.G_RET_STS_ERROR;

6709:
6710: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
6711:
6712: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
6713: p_return_status := FND_API.G_RET_STS_ERROR;
6714: IF (g_level_error >= g_current_runtime_level ) THEN
6715: FND_LOG.STRING(g_level_error,
6716: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
6717: 'Action_code is ERROR_MESSAGE,SYSTEM_ERROR');

Line 6751: p_return_status := FND_API.G_RET_STS_ERROR;

6747: If select_tax_status_rate_code%NOTFOUND then
6748: --A record does not exist with that tax rate code for the given tax.
6749: --Raise error;
6750:
6751: p_return_status := FND_API.G_RET_STS_ERROR;
6752: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
6753: IF (g_level_error >= g_current_runtime_level ) THEN
6754: FND_LOG.STRING(g_level_error,
6755: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 6815: p_return_status := FND_API.G_RET_STS_ERROR;

6811:
6812: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
6813:
6814: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
6815: p_return_status := FND_API.G_RET_STS_ERROR;
6816: IF (g_level_error >= g_current_runtime_level ) THEN
6817: FND_LOG.STRING(g_level_error,
6818: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
6819: 'Action_code is ERROR_MESSAGE,SYSTEM_ERROR');

Line 6855: p_return_status := FND_API.G_RET_STS_ERROR;

6851: If select_tax_status_rate_code%NOTFOUND then
6852: --A record does not exist with that tax rate code for the given tax.
6853: --Raise error;
6854:
6855: p_return_status := FND_API.G_RET_STS_ERROR;
6856: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
6857: IF (g_level_error >= g_current_runtime_level ) THEN
6858: FND_LOG.STRING(g_level_error,
6859: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 6928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6924: END IF;
6925:
6926: EXCEPTION
6927: WHEN OTHERS THEN
6928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6929: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
6930: CLOSE get_tax_result_csr;
6931:
6932: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 7254: p_return_status := FND_API.G_RET_STS_SUCCESS;

7250:
7251: BEGIN
7252:
7253: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7254: p_return_status := FND_API.G_RET_STS_SUCCESS;
7255:
7256: --Initialize the return status , p_valid as TRUE
7257: p_valid := TRUE;
7258:

Line 7320: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7316: 'ZX_TDS_RULE_BASE_DETM_PVT: check_templ_tax_parameter(-)');
7317: END IF;
7318: EXCEPTION
7319: WHEN OTHERS THEN
7320: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7321: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7322:
7323: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7324: FND_LOG.STRING(g_level_unexpected,

Line 7377: p_return_status := FND_API.G_RET_STS_SUCCESS;

7373:
7374: BEGIN
7375:
7376: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7377: p_return_status := FND_API.G_RET_STS_SUCCESS;
7378:
7379: --Initialize the return status , p_valid as FALSE
7380: p_valid := FALSE;
7381: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7381: p_return_status := FND_API.G_RET_STS_SUCCESS;

7377: p_return_status := FND_API.G_RET_STS_SUCCESS;
7378:
7379: --Initialize the return status , p_valid as FALSE
7380: p_valid := FALSE;
7381: p_return_status := FND_API.G_RET_STS_SUCCESS;
7382: --l_count := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.COUNT;
7383:
7384:
7385: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 7415: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

7411: l_geography_code,
7412: l_geography_name,
7413: p_return_status);
7414:
7415: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
7416: IF l_geography_id = p_rule_geography_id then
7417: p_valid:=TRUE;
7418:
7419: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 7474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7470: 'ZX_TDS_RULE_BASE_DETM_PVT: check_rule_geography(-)');
7471: END IF;
7472: EXCEPTION
7473: WHEN OTHERS THEN
7474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7475: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7476:
7477: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7478: FND_LOG.STRING(g_level_unexpected,