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

Line 520: p_return_status := FND_API.G_RET_STS_SUCCESS;

516: 'p_tax_conversion_type = ' || p_tax_conversion_type||
517: 'p_trx_conversion_type = ' || p_trx_conversion_type);
518: END IF;
519:
520: p_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: -- Check if both currencies are identical
523: IF ( p_from_currency = p_to_currency ) THEN
524: g_tax_curr_conv_rate_tbl(p_rate_index) := 1;

Line 541: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

537: p_from_currency,
538: p_conversion_date,
539: p_return_status,
540: p_error_buffer);
541: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
542: RETURN NULL;
543: END IF;
544:
545: l_from_type := g_currency_tbl(p_from_currency).currency_type;

Line 562: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: p_to_currency,
559: p_conversion_date,
560: p_return_status,
561: p_error_buffer);
562: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RETURN NULL;
564: END IF;
565:
566: l_to_type := g_currency_tbl(p_to_currency).currency_type;

Line 588: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

584: IF g_euro_code IS NULL THEN
585: g_euro_code := get_euro_code(p_return_status,
586: p_error_buffer );
587: END IF;
588: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
589: RETURN NULL;
590: END IF;
591:
592: l_other_rate := get_other_rate(

Line 602: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

598: p_return_status,
599: p_error_buffer,
600: p_trx_conversion_date); --Bug7183884
601:
602: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
603: -- Get conversion amt by converting EMU -> EURO -> OTHER
604: l_converted_amount := ( p_amount / l_from_rate ) * l_other_rate;
605: g_tax_curr_conv_rate_tbl(p_rate_index) := l_other_rate /l_from_rate;
606: END IF;

Line 631: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

627: p_trx_conversion_type,
628: p_return_status,
629: p_error_buffer,
630: p_trx_conversion_date);--Bug7183884
631: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
632: l_converted_amount := p_amount * l_other_rate;
633: g_tax_curr_conv_rate_tbl(p_rate_index) := l_other_rate;
634: END IF;
635: END IF;

Line 645: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

641: g_euro_code := get_euro_code(p_return_status,
642: p_error_buffer );
643: END IF;
644:
645: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
646: RETURN NULL;
647: END IF;
648: l_other_rate := get_other_rate(
649: p_from_currency,

Line 659: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

655: p_error_buffer,
656: p_trx_conversion_date);--Bug7183884
657:
658:
659: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
660: -- Get conversion amt by converting OTHER -> EURO -> EMU
661: l_converted_amount := ( p_amount * l_other_rate ) * l_to_rate;
662: g_tax_curr_conv_rate_tbl(p_rate_index) := l_other_rate * l_to_rate;
663: END IF;

Line 676: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

672: p_error_buffer,
673: p_trx_conversion_date);--Bug7183884
674:
675:
676: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
677: l_converted_amount := p_amount * l_other_rate;
678: g_tax_curr_conv_rate_tbl(p_rate_index) := l_other_rate;
679: END IF;
680: ELSIF ( l_to_type = 'OTHER' ) THEN

Line 692: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

688: p_error_buffer ,
689: p_trx_conversion_date);--Bug7183884
690:
691:
692: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
693: l_converted_amount := p_amount * l_other_rate;
694: g_tax_curr_conv_rate_tbl(p_rate_index) := l_other_rate;
695: END IF;
696: END IF;

Line 713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

709: RETURN l_converted_amount;
710:
711: EXCEPTION
712: WHEN OTHERS THEN
713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
715:
716: IF (g_level_unexpected >= g_current_runtime_level ) THEN
717: FND_LOG.STRING(g_level_unexpected,

Line 826: p_return_status := FND_API.G_RET_STS_SUCCESS;

822: 'p_currency = ' || p_currency||
823: 'p_eff_date = ' || to_char(p_eff_date, 'DD-MON-YY'));
824: END IF;
825:
826: p_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: -- Get currency information from FND_CURRENCIES table
829: --Commented for Bug 7519288
830: /* SELECT decode( derive_type,

Line 891: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

887: END IF;
888:
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: p_error_buffer := 'Currency type and Currency rate not found in FND_CURRENCIES';
893: IF (g_level_unexpected >= g_current_runtime_level ) THEN
894: FND_LOG.STRING(g_level_unexpected,
895: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_currency_info',

Line 900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

896: p_error_buffer);
897: END IF;
898:
899: WHEN OTHERS THEN
900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
902:
903: IF (g_level_unexpected >= g_current_runtime_level ) THEN
904: FND_LOG.STRING(g_level_unexpected,

Line 958: p_return_status := FND_API.G_RET_STS_SUCCESS;

954: 'p_tax_conversion_type = ' || p_tax_conversion_type||
955: 'p_trx_conversion_type = ' || p_trx_conversion_type);
956: END IF;
957:
958: p_return_status := FND_API.G_RET_STS_SUCCESS;
959: l_rate := NULL;
960:
961: IF p_tax_conversion_type IS NOT NULL THEN
962: --

Line 1086: p_return_status := FND_API.G_RET_STS_ERROR;

1082: p_trx_conversion_date,
1083: p_trx_conversion_type);
1084: FETCH get_rate_info_csr INTO l_rate;
1085: IF get_rate_info_csr%NOTFOUND THEN
1086: p_return_status := FND_API.G_RET_STS_ERROR;
1087:
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);

Line 1126: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122:
1123:
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1128:
1129: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1130: FND_LOG.STRING(g_level_unexpected,

Line 1156: p_return_status := FND_API.G_RET_STS_SUCCESS;

1152: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_euro_code.BEGIN',
1153: 'ZX_TDS_TAX_ROUNDING_PKG: get_euro_code(+)');
1154: END IF;
1155:
1156: p_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: -- Get currency code of the EURO currency
1159: SELECT currency_code
1160: INTO euro_code

Line 1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1172: RETURN( euro_code );
1173:
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1178: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1180: ZX_API_PUB.add_msg(

Line 1193: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1189: p_error_buffer);
1190: END IF;
1191:
1192: WHEN OTHERS THEN
1193: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1195:
1196: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1197: FND_LOG.STRING(g_level_unexpected,

Line 1236: p_return_status := FND_API.G_RET_STS_SUCCESS;

1232: 'p_min_acct_unit = ' || to_char(p_min_acct_unit)||
1233: 'p_precision = ' || to_char(p_precision));
1234: END IF;
1235:
1236: p_return_status := FND_API.G_RET_STS_SUCCESS;
1237:
1238: --
1239: -- check if all require info are available for rounding
1240: --

Line 1300: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1296: -- Use precision
1297: l_rounded_amt := ROUND(p_amount, p_precision);
1298: END IF;
1299: ELSE
1300: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: p_error_buffer := 'Unknown Rounding Rule Code';
1302: END IF;
1303:
1304: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1311: RETURN l_rounded_amt;
1312:
1313: EXCEPTION
1314: WHEN ZERO_DIVIDE THEN
1315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: p_error_buffer := 'Minimum Accountable Unit can not be 0';
1317: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1318: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','round_tax- '|| p_error_buffer);
1319: FND_MSG_PUB.Add;

Line 1327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1323: p_error_buffer);
1324: END IF;
1325:
1326: WHEN OTHERS THEN
1327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1329: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1330: FND_LOG.STRING(g_level_unexpected,
1331: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.round_tax',

Line 1364: p_return_status := FND_API.G_RET_STS_SUCCESS;

1360: 'ZX_TDS_TAX_ROUNDING_PKG: det_rounding_level_basis(+)'||
1361: 'Party_Type_Code = ' || p_Party_Type_Code);
1362: END IF;
1363:
1364: p_return_status := FND_API.G_RET_STS_SUCCESS;
1365:
1366: --
1367: -- determine the rounding party type
1368: --

Line 1380: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1376: 'BILL_TO_PTY_SITE',
1377: 'BILL_FROM_PTY_SITE') THEN
1378: p_rounding_level_basis := 'SITE';
1379: ELSE
1380: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381: p_error_buffer := 'Invalid Rounding Level Hierarchy';
1382:
1383: IF (g_level_statement >= g_current_runtime_level ) THEN
1384: FND_LOG.STRING(g_level_statement,

Line 1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1406:
1407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1408: FND_LOG.STRING(g_level_unexpected,

Line 1460: p_return_status := FND_API.G_RET_STS_SUCCESS;

1456: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_round_level_and_rule.BEGIN',
1457: 'ZX_TDS_TAX_ROUNDING_PKG: determine_round_level_and_rule(+)');
1458: END IF;
1459:
1460: p_return_status := FND_API.G_RET_STS_SUCCESS;
1461:
1462: --
1463: -- determine the rounding party type
1464: --

Line 1471: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1467: l_rounding_level_basis,
1468: p_return_status,
1469: p_error_buffer);
1470:
1471: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: RETURN;
1473: END IF;
1474:
1475: IF l_rounding_level_basis = 'PARTY' THEN

Line 1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1533: l_account_site_id := p_bill_third_pty_acct_site_id;
1534: l_site_use_id := p_bill_to_cust_acct_st_use_id;
1535:
1536: ELSE
1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: p_error_buffer := 'Invalid Rounding Level Hierarchy';
1539:
1540: IF (g_level_statement >= g_current_runtime_level ) THEN
1541: FND_LOG.STRING(g_level_statement,

Line 1587: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1583: p_return_status => P_return_status);
1584:
1585: **********/
1586:
1587: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1588: IF (g_level_statement >= g_current_runtime_level ) THEN
1589: FND_LOG.STRING(g_level_statement,
1590: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_round_level_and_rule',
1591: 'Incorrect return_status after calling ' ||

Line 1597: p_return_status := FND_API.G_RET_STS_SUCCESS;

1593:
1594: END IF;
1595: p_rounding_level_code := NULL;
1596: p_rounding_rule_code := NULL;
1597: p_return_status := FND_API.G_RET_STS_SUCCESS;
1598: END IF;
1599:
1600: -- populate rounding_level_code and rounding_rule_code
1601: --

Line 1636: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1632: END IF;
1633:
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1637: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1638:
1639: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1640: FND_LOG.STRING(g_level_unexpected,

Line 1690: p_return_status := FND_API.G_RET_STS_SUCCESS;

1686: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_rounding_rule.BEGIN',
1687: 'ZX_TDS_TAX_ROUNDING_PKG: determine_rounding_rule(+)');
1688: END IF;
1689:
1690: p_return_status := FND_API.G_RET_STS_SUCCESS;
1691:
1692: --
1693: -- determine the rounding party type
1694: --

Line 1701: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1697: l_rounding_level_basis,
1698: p_return_status,
1699: p_error_buffer);
1700:
1701: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1702: RETURN;
1703: END IF;
1704:
1705: IF l_rounding_level_basis = 'PARTY' THEN

Line 1796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1792: l_site_use_id :=
1793: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(p_trx_line_index);
1794:
1795: ELSE
1796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: p_error_buffer := 'Invalid Rounding Level Hierarchy';
1798:
1799: IF (g_level_statement >= g_current_runtime_level ) THEN
1800: FND_LOG.STRING(g_level_statement,

Line 1827: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1823: p_zx_registration_rec => l_registration_rec,
1824: p_ret_record_level => l_ret_record_level,
1825: p_return_status => P_return_status);
1826:
1827: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1828: IF (g_level_error >= g_current_runtime_level ) THEN
1829: FND_LOG.STRING(g_level_error,
1830: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_rounding_rule',
1831: 'Incorrect return_status after calling ' ||

Line 1838: p_return_status := FND_API.G_RET_STS_SUCCESS;

1834: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_rounding_rule',
1835: 'Continue processing ...');
1836: END IF;
1837: p_rounding_rule_code := NULL;
1838: p_return_status := FND_API.G_RET_STS_SUCCESS;
1839: RETURN;
1840: END IF;
1841:
1842: -- populate rounding_rule_code

Line 1871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1867: END IF;
1868:
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1873:
1874: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1875: FND_LOG.STRING(g_level_unexpected,

Line 1911: p_return_status := FND_API.G_RET_STS_SUCCESS;

1907: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_rounding_rule.BEGIN',
1908: 'ZX_TDS_TAX_ROUNDING_PKG: get_rounding_rule(+)');
1909: END IF;
1910:
1911: p_return_status := FND_API.G_RET_STS_SUCCESS;
1912:
1913: IF p_event_class_rec.rounding_level_hier_1_code IS NOT NULL THEN
1914:
1915: determine_rounding_rule(

Line 1927: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1923: p_rounding_rule_code,
1924: p_return_status,
1925: p_error_buffer);
1926:
1927: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1928: RETURN;
1929: ELSE
1930: IF p_rounding_rule_code IS NOT NULL THEN
1931: RETURN;

Line 1950: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1946: p_rounding_rule_code,
1947: p_return_status,
1948: p_error_buffer);
1949:
1950: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1951: RETURN;
1952: ELSE
1953: IF p_rounding_rule_code IS NOT NULL THEN
1954: RETURN;

Line 1973: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1969: p_rounding_rule_code,
1970: p_return_status,
1971: p_error_buffer);
1972:
1973: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1974: RETURN;
1975: ELSE
1976: IF p_rounding_rule_code IS NOT NULL THEN
1977: RETURN;

Line 1996: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1992: p_rounding_rule_code,
1993: p_return_status,
1994: p_error_buffer);
1995:
1996: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1997: RETURN;
1998: ELSE
1999: IF p_rounding_rule_code IS NOT NULL THEN
2000: RETURN;

Line 2013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2009: END IF;
2010:
2011: EXCEPTION
2012: WHEN OTHERS THEN
2013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2015:
2016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2017: FND_LOG.STRING(g_level_unexpected,

Line 2051: p_return_status := FND_API.G_RET_STS_SUCCESS;

2047: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_round_level_ptp_id.BEGIN',
2048: 'ZX_TDS_TAX_ROUNDING_PKG: get_round_level_ptp_id(+)');
2049: END IF;
2050:
2051: p_return_status := FND_API.G_RET_STS_SUCCESS;
2052:
2053: --
2054: -- determine the rounding party type
2055: --

Line 2062: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2058: l_rounding_level_basis,
2059: p_return_status,
2060: p_error_buffer);
2061:
2062: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2063: RETURN;
2064: END IF;
2065:
2066: IF l_rounding_level_basis = 'PARTY' THEN

Line 2105: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2101: END IF;
2102:
2103: EXCEPTION
2104: WHEN OTHERS THEN
2105: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2106: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2107:
2108: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2109: FND_LOG.STRING(g_level_unexpected,

Line 2214: p_return_status := FND_API.G_RET_STS_SUCCESS;

2210: 'ZX_TDS_TAX_ROUNDING_PKG: get_rounding_level_and_rule(+)');
2211:
2212: END IF;
2213:
2214: p_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216: --
2217: -- check if trx_currency_code is available at header level
2218: -- if not, that means trx_currency_code can be different

Line 2236: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2232: l_tax_prof_id,
2233: p_return_status,
2234: p_error_buffer);
2235:
2236: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2237: RETURN;
2238: ELSE
2239: IF l_tax_prof_id IS NOT NULL THEN
2240: p_rnd_lvl_party_tax_prof_id := l_tax_prof_id;

Line 2265: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2261: l_tax_prof_id,
2262: p_return_status,
2263: p_error_buffer);
2264:
2265: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2266: RETURN;
2267: ELSE
2268: IF l_tax_prof_id IS NOT NULL THEN
2269: p_rnd_lvl_party_tax_prof_id := l_tax_prof_id;

Line 2293: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2289: l_tax_prof_id,
2290: p_return_status,
2291: p_error_buffer);
2292:
2293: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2294: RETURN;
2295: ELSE
2296: IF l_tax_prof_id IS NOT NULL THEN
2297: p_rnd_lvl_party_tax_prof_id := l_tax_prof_id;

Line 2321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2317: l_tax_prof_id,
2318: p_return_status,
2319: p_error_buffer);
2320:
2321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2322: RETURN;
2323: ELSE
2324: IF l_tax_prof_id IS NOT NULL THEN
2325: p_rnd_lvl_party_tax_prof_id := l_tax_prof_id;

Line 2411: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2407: l_tax_determine_date,
2408: l_tax_point_date,
2409: p_return_status);
2410:
2411: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2412: IF (g_level_error >= g_current_runtime_level ) THEN
2413: FND_LOG.STRING(g_level_error,
2414: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_rounding_level_and_rule',
2415: 'Incorrect return_status after calling ' ||

Line 2452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2448: l_ship_to_cust_acct_st_use_id,
2449: l_bill_to_cust_acct_st_use_id,
2450: l_tax_determine_date );
2451:
2452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2453: RETURN;
2454: ELSE
2455: IF l_rounding_level_code IS NOT NULL THEN
2456: p_rnd_lvl_party_tax_prof_id := l_tax_prof_id;

Line 2489: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2485: l_ship_to_cust_acct_st_use_id,
2486: l_bill_to_cust_acct_st_use_id,
2487: l_tax_determine_date );
2488:
2489: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2490: RETURN;
2491: ELSE
2492: IF (NOT l_rounding_level_found AND
2493: l_rounding_level_code IS NOT NULL) THEN

Line 2528: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2524: l_ship_to_cust_acct_st_use_id,
2525: l_bill_to_cust_acct_st_use_id,
2526: l_tax_determine_date );
2527:
2528: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2529: RETURN;
2530: ELSE
2531: IF (NOT l_rounding_level_found AND
2532: l_rounding_level_code IS NOT NULL) THEN

Line 2567: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2563: l_ship_to_cust_acct_st_use_id,
2564: l_bill_to_cust_acct_st_use_id,
2565: l_tax_determine_date );
2566:
2567: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2568: RETURN;
2569: ELSE
2570: IF (NOT l_rounding_level_found AND
2571: l_rounding_level_code IS NOT NULL) THEN

Line 2609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2605: END IF;
2606:
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2611:
2612: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2613: FND_LOG.STRING(g_level_unexpected,

Line 2644: p_return_status := FND_API.G_RET_STS_SUCCESS;

2640: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.init_header_group.BEGIN',
2641: 'ZX_TDS_TAX_ROUNDING_PKG: init_header_group(+)');
2642: END IF;
2643:
2644: p_return_status := FND_API.G_RET_STS_SUCCESS;
2645:
2646: p_hdr_grp_rec.tax_regime_code := 'X';
2647: p_hdr_grp_rec.tax := 'X';
2648: p_hdr_grp_rec.tax_status_code := 'X';

Line 2708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2704: END IF;
2705:
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2709: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2710:
2711: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2712: FND_LOG.STRING(g_level_unexpected,

Line 2744: p_return_status := FND_API.G_RET_STS_SUCCESS;

2740: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_header_group.BEGIN',
2741: 'ZX_TDS_TAX_ROUNDING_PKG: determine_header_group(+)');
2742: END IF;
2743:
2744: p_return_status := FND_API.G_RET_STS_SUCCESS;
2745:
2746: -- bug6773534: remove applied_to information from header grouping critera
2747:
2748: IF (NVL(p_prev_hdr_grp_rec.tax_regime_code, 'X') <>

Line 2981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2977: END IF;
2978:
2979: EXCEPTION
2980: WHEN OTHERS THEN
2981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2983: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2984: FND_LOG.STRING(g_level_unexpected,
2985: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.determine_header_group' ,

Line 3022: p_return_status := FND_API.G_RET_STS_SUCCESS;

3018: 'ZX_TDS_TAX_ROUNDING_PKG: get_currency_info_for_rounding(+)'||
3019: 'p_currency_code = ' || p_currency_code);
3020: END IF;
3021:
3022: p_return_status := FND_API.G_RET_STS_SUCCESS;
3023:
3024: --
3025: -- first check if currency info can be obtained from the cache structure
3026: -- if not, call get_currency_info to get it

Line 3051: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3047: l_precision,
3048: l_currency_type,
3049: p_return_status,
3050: p_error_buffer);
3051: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3052: g_currency_tbl(p_currency_code).min_acct_unit := l_mau;
3053: g_currency_tbl(p_currency_code).precision := l_precision;
3054: g_currency_tbl(p_currency_code).conversion_rate := l_conversion_rate;
3055: g_currency_tbl(p_currency_code).currency_type := l_currency_type;

Line 3071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3067: END IF;
3068:
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3072: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3073:
3074: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3075: FND_LOG.STRING(g_level_unexpected,

Line 3114: p_return_status := FND_API.G_RET_STS_SUCCESS;

3110: 'ZX_TDS_TAX_ROUNDING_PKG: convert_to_currency(+)'||
3111: 'p_to_curr_conv_rate = ' || to_char(p_to_curr_conv_rate));
3112: END IF;
3113:
3114: p_return_status := FND_API.G_RET_STS_SUCCESS;
3115:
3116: --
3117: -- if currency conversion rate is available, use it, otherwise,
3118: -- check if it exists in cache, if not, call convert_amount to get

Line 3168: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3164: l_rate_index,
3165: p_return_status,
3166: p_error_buffer,
3167: p_trx_conversion_date);--Bug7183884
3168: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3169: p_to_curr_conv_rate := g_tax_curr_conv_rate_tbl(l_rate_index);
3170: END IF;
3171: END IF;
3172: END IF;

Line 3185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3181: END IF;
3182:
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3187:
3188: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3189: FND_LOG.STRING(g_level_unexpected,

Line 3229: p_return_status := FND_API.G_RET_STS_SUCCESS;

3225: to_char(p_unround_amt));
3226:
3227: END IF;
3228:
3229: p_return_status := FND_API.G_RET_STS_SUCCESS;
3230:
3231: --
3232: -- perform rounding for amount in functional currency
3233: --

Line 3244: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3240: p_return_status,
3241: p_error_buffer );
3242:
3243:
3244: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3245: --
3246: -- error getting min acct unit and precision
3247: -- return original unround amount to caller
3248: --

Line 3282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3278: RETURN l_round_amt;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3283: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3284:
3285: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3286: FND_LOG.STRING(g_level_unexpected,

Line 3329: p_return_status := FND_API.G_RET_STS_SUCCESS;

3325: 'p_tax_curr_conv_rate = ' || to_char(p_tax_curr_conv_rate));
3326:
3327: END IF;
3328:
3329: p_return_status := FND_API.G_RET_STS_SUCCESS;
3330:
3331: --
3332: -- convert tax amt to tax currency
3333: --

Line 3354: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3350: 'tax conversion rate = ' || to_char(p_tax_curr_conv_rate)||
3351: 'unround tax amt tax currency = ' || to_char(l_amt_tax_curr));
3352: END IF;
3353:
3354: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3355: RETURN;
3356: END IF;
3357:
3358: --

Line 3378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3374: END IF;
3375:
3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3379: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3380:
3381: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3382: FND_LOG.STRING(g_level_unexpected,

Line 3420: p_return_status := FND_API.G_RET_STS_SUCCESS;

3416: 'p_funcl_curr_conv_rate = ' || to_char(p_funcl_curr_conv_rate));
3417:
3418: END IF;
3419:
3420: p_return_status := FND_API.G_RET_STS_SUCCESS;
3421:
3422: l_amt_funcl_curr := p_amt * p_funcl_curr_conv_rate;
3423:
3424: IF l_amt_funcl_curr IS NOT NULL THEN

Line 3431: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3427: p_ledger_id,
3428: p_return_status,
3429: p_error_buffer);
3430:
3431: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3432: RETURN;
3433: END IF;
3434:
3435: ELSE

Line 3452: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3448: END IF;
3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3453: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3454:
3455: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3456: FND_LOG.STRING(g_level_unexpected,

Line 3506: p_return_status := FND_API.G_RET_STS_SUCCESS;

3502: 'p_tax_curr_conv_rate = ' || to_char(p_tax_curr_conv_rate));
3503:
3504: END IF;
3505:
3506: p_return_status := FND_API.G_RET_STS_SUCCESS;
3507:
3508: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3509: l_rate_type_code :=
3510: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;

Line 3518: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3514: p_tax_rate_rec => l_tax_rate_rec,
3515: p_return_status => p_return_status,
3516: p_error_buffer => p_error_buffer);
3517:
3518: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3519: l_rate_type_code := l_tax_rate_rec.rate_type_code;
3520: END IF;
3521: END IF;
3522:

Line 3544: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3540: l_amt_tax_curr,
3541: p_return_status,
3542: p_error_buffer,
3543: p_trx_conversion_date); --Bug7183884
3544: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3545: RETURN;
3546: END IF;
3547:
3548: END IF;

Line 3571: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3567: END IF;
3568:
3569: EXCEPTION
3570: WHEN OTHERS THEN
3571: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3572: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3573: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3574: FND_LOG.STRING(g_level_unexpected,
3575: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.conv_rnd_taxable_tax_curr',

Line 3616: p_return_status := FND_API.G_RET_STS_SUCCESS;

3612: 'p_funcl_curr_conv_rate = ' || to_char(p_funcl_curr_conv_rate));
3613:
3614: END IF;
3615:
3616: p_return_status := FND_API.G_RET_STS_SUCCESS;
3617:
3618: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3619: l_rate_type_code :=
3620: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;

Line 3628: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

3624: p_tax_rate_rec => l_tax_rate_rec,
3625: p_return_status => p_return_status,
3626: p_error_buffer => p_error_buffer);
3627:
3628: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
3629: l_rate_type_code := l_tax_rate_rec.rate_type_code;
3630: END IF;
3631: END IF;
3632:

Line 3655: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3651: p_ledger_id,
3652: p_return_status,
3653: p_error_buffer);
3654:
3655: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3656: RETURN;
3657: END IF;
3658:
3659: ELSE

Line 3678: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3674: END IF;
3675:
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3680:
3681: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3682: FND_LOG.STRING(g_level_unexpected,

Line 3723: p_return_status := FND_API.G_RET_STS_SUCCESS;

3719: 'p_trx_precision = ' || to_char(p_trx_precision)||
3720: 'p_trx_min_acct_unit = ' || to_char(p_trx_min_acct_unit));
3721: END IF;
3722:
3723: p_return_status := FND_API.G_RET_STS_SUCCESS;
3724:
3725: --
3726: -- perform rounding for tax amount
3727: --

Line 3745: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3741: p_return_status,
3742: p_error_buffer);
3743: END IF;
3744:
3745: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3746: RETURN;
3747: END IF;
3748:
3749: --

Line 3789: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3785: END IF;
3786:
3787: EXCEPTION
3788: WHEN OTHERS THEN
3789: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3790: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3791:
3792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3793: FND_LOG.STRING(g_level_unexpected,

Line 3835: p_return_status := FND_API.G_RET_STS_SUCCESS;

3831:
3832: --
3833: -- init return status
3834: --
3835: p_return_status := FND_API.G_RET_STS_SUCCESS;
3836:
3837: --
3838: -- check whether it is in the same group of tax for
3839: -- header rounding level. l_same_tax is used for header

Line 3848: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3844: l_same_tax,
3845: p_return_status,
3846: p_error_buffer);
3847:
3848: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3849: RETURN;
3850: END IF;
3851:
3852: --

Line 3868: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3864: p_ledger_id,
3865: p_return_status,
3866: p_error_buffer);
3867:
3868: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3869: RETURN;
3870: END IF;
3871:
3872: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3877: END IF;
3878:
3879: EXCEPTION
3880: WHEN OTHERS THEN
3881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3882: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3883: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3884: FND_LOG.STRING(g_level_unexpected,
3885: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.handle_header_rounding_curr',

Line 3925: p_return_status := FND_API.G_RET_STS_SUCCESS;

3921: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_rounding_info.BEGIN',
3922: 'ZX_TDS_TAX_ROUNDING_PKG: get_rounding_info(+)');
3923: END IF;
3924:
3925: p_return_status := FND_API.G_RET_STS_SUCCESS;
3926:
3927: l_tax_id := p_tax_id;
3928:
3929: --

Line 3938: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3934: p_tax_id,
3935: p_return_status,
3936: p_error_buffer);
3937:
3938: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3939: IF (g_level_statement >= g_current_runtime_level ) THEN
3940: FND_LOG.STRING(g_level_statement,
3941: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process',
3942: 'p_return_status = ' || p_return_status ||

Line 3979: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3975: p_tax_currency_code,
3976: p_tax_currency_conversion_date,
3977: p_return_status,
3978: p_error_buffer);
3979: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3980: RETURN;
3981: END IF;
3982:
3983: --

Line 4001: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3997: p_trx_currency_code,
3998: p_currency_conversion_date,
3999: p_return_status,
4000: p_error_buffer);
4001: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4002: RETURN;
4003: END IF;
4004:
4005: --

Line 4023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4019: END IF;
4020:
4021: EXCEPTION
4022: WHEN OTHERS THEN
4023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4024: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4025: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4026: FND_LOG.STRING(g_level_unexpected,
4027: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_rounding_info',

Line 4065: p_return_status := FND_API.G_RET_STS_SUCCESS;

4061: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.adjust_rounding_diff_curr.BEGIN',
4062: 'ZX_TDS_TAX_ROUNDING_PKG: adjust_rounding_diff_curr(+)');
4063: END IF;
4064:
4065: p_return_status := FND_API.G_RET_STS_SUCCESS;
4066:
4067: l_count := g_hdr_rounding_curr_tbl.COUNT;
4068:
4069: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4096: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4092: g_hdr_rounding_curr_tbl(i).ledger_id,
4093: p_return_status,
4094: p_error_buffer);
4095:
4096: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4097: RETURN;
4098: END IF;
4099:
4100: g_hdr_rounding_curr_tbl(i).rnd_tax_amt_curr :=

Line 4117: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4113: g_hdr_rounding_curr_tbl(i).tax_rate),
4114: g_hdr_rounding_info_tbl(i).ledger_id,
4115: p_return_status,
4116: p_error_buffer);
4117: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4118: RETURN;
4119: END IF;
4120: END IF;
4121: END IF; -- total_rec_in_grp > 1

Line 4154: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4150: END IF;
4151:
4152: EXCEPTION
4153: WHEN OTHERS THEN
4154: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4155: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4156:
4157: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4158: FND_LOG.STRING(g_level_unexpected,

Line 4206: p_return_status := FND_API.G_RET_STS_SUCCESS;

4202: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.adjust_rounding_diff.BEGIN',
4203: 'ZX_TDS_TAX_ROUNDING_PKG: adjust_rounding_diff(+)');
4204: END IF;
4205:
4206: p_return_status := FND_API.G_RET_STS_SUCCESS;
4207:
4208: l_count := g_hdr_rounding_info_tbl.COUNT;
4209:
4210: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4235: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4231: g_hdr_rounding_info_tbl(i).precision,
4232: p_return_status,
4233: p_error_buffer);
4234:
4235: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4236: RETURN;
4237: END IF;
4238:
4239: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4289: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4285: l_tax_precision,
4286: p_return_status,
4287: p_error_buffer);
4288:
4289: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4290: RETURN;
4291: END IF;
4292:
4293: g_hdr_rounding_info_tbl(i).rnd_tax_amt_tax_curr :=

Line 4311: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4307: g_hdr_rounding_info_tbl(i).ledger_id,
4308: p_return_status,
4309: p_error_buffer);
4310:
4311: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4312: RETURN;
4313: END IF;
4314:
4315: g_hdr_rounding_info_tbl(i).rnd_tax_amt_funcl_curr :=

Line 4341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4337: l_tax_min_acct_unit,
4338: l_tax_precision,
4339: p_return_status,
4340: p_error_buffer);
4341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4342: RETURN;
4343: END IF;
4344:
4345: g_hdr_rounding_info_tbl(i).rnd_taxable_amt_funcl_curr :=

Line 4353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4349: g_hdr_rounding_info_tbl(i).ledger_id,
4350: p_return_status,
4351: p_error_buffer);
4352:
4353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4354: RETURN;
4355: END IF;
4356: END IF;
4357: END IF; -- g_hdr_rounding_info_tbl(i).mrc_tax_line_flag = 'Y'

Line 4405: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4401: END IF;
4402:
4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4407:
4408: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4409: FND_LOG.STRING(g_level_unexpected,

Line 4450: p_return_status := FND_API.G_RET_STS_SUCCESS;

4446:
4447: --
4448: -- init return status
4449: --
4450: p_return_status := FND_API.G_RET_STS_SUCCESS;
4451:
4452: j := g_hdr_rounding_curr_tbl.COUNT;
4453:
4454: IF p_same_tax = 'N' THEN

Line 4504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4500: 'ZX_TDS_TAX_ROUNDING_PKG: update_header_rounding_curr(-)');
4501: END IF;
4502: EXCEPTION
4503: WHEN OTHERS THEN
4504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4505: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4506:
4507: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4508: FND_LOG.STRING(g_level_unexpected,

Line 4561: p_return_status := FND_API.G_RET_STS_SUCCESS;

4557:
4558: --
4559: -- init return status
4560: --
4561: p_return_status := FND_API.G_RET_STS_SUCCESS;
4562:
4563: j := g_hdr_rounding_info_tbl.COUNT;
4564:
4565: --

Line 4654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4650: 'ZX_TDS_TAX_ROUNDING_PKG: update_header_rounding_info(-)');
4651: END IF;
4652: EXCEPTION
4653: WHEN OTHERS THEN
4654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4655: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4656:
4657: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4658: FND_LOG.STRING(g_level_unexpected,

Line 4740: p_return_status := FND_API.G_RET_STS_SUCCESS;

4736:
4737: --
4738: -- init return status
4739: --
4740: p_return_status := FND_API.G_RET_STS_SUCCESS;
4741: --
4742: -- get unround amt
4743: --
4744: l_prd_total_tax_amt := p_prd_total_tax_amt;

Line 4766: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4762: l_tax_currency_conversion_type,
4763: p_return_status,
4764: p_error_buffer);
4765:
4766: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4767: RETURN;
4768: END IF;
4769:
4770: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4803: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4799: p_unrounded_tax_amt,
4800: p_return_status,
4801: p_error_buffer);
4802:
4803: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4804: RETURN;
4805: END IF;
4806:
4807: --

Line 4834: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4830: l_funcl_precision,
4831: p_return_status,
4832: p_error_buffer );
4833:
4834: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4835: RETURN;
4836: END IF;
4837:
4838: IF p_tax_currency_code = l_funcl_currency_code THEN

Line 4875: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4871: p_trx_conversion_date => l_trx_currency_conversion_date);--Bug7183884
4872:
4873: --Bug 7109899
4874:
4875: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4876: RETURN;
4877: END IF;
4878:
4879:

Line 4900: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4896: p_trx_conversion_date => l_trx_currency_conversion_date); --Bug7183884
4897:
4898: -- Bug 7109899
4899:
4900: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4901: RETURN;
4902: END IF;
4903:
4904:

Line 4949: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4945: p_return_status,
4946: p_error_buffer,
4947: l_trx_currency_conversion_date);--Bug7183884
4948:
4949: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4950: RETURN;
4951: END IF;
4952: END IF;
4953:

Line 4972: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4968: p_return_status,
4969: p_error_buffer);
4970:
4971:
4972: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4973: RETURN;
4974: END IF;
4975:
4976: --

Line 4989: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4985: p_ledger_id,
4986: p_return_status,
4987: p_error_buffer);
4988:
4989: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4990: RETURN;
4991: END IF;
4992: END IF;
4993:

Line 5027: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5023: p_tax_amt_tax_curr,
5024: p_return_status,
5025: p_error_buffer,
5026: l_trx_currency_conversion_date); --Bug7183884
5027: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5028: RETURN;
5029: END IF;
5030:
5031: --

Line 5046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5042: p_tax_rate_id,
5043: p_tax_amt_funcl_curr,
5044: p_return_status,
5045: p_error_buffer);
5046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5047: RETURN;
5048: END IF;
5049:
5050: END IF;

Line 5086: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5082: l_tax_precision,
5083: p_return_status,
5084: p_error_buffer,
5085: l_trx_currency_conversion_date);--Bug7183884
5086: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5087: RETURN;
5088: END IF;
5089: --
5090: -- convert to functional currency based

Line 5100: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5096: p_prd_total_tax_amt_funcl_curr,
5097: p_ledger_id,
5098: p_return_status,
5099: p_error_buffer);
5100: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5101: RETURN;
5102: END IF;
5103: END IF;
5104: END IF;

Line 5116: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5112: END IF;
5113:
5114: EXCEPTION
5115: WHEN OTHERS THEN
5116: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5117: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5118:
5119: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5120: FND_LOG.STRING(g_level_unexpected,

Line 5155: p_return_status := FND_API.G_RET_STS_SUCCESS;

5151: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.process_tax_line_create.BEGIN',
5152: 'ZX_TDS_TAX_ROUNDING_PKG: process_tax_line_create(+)');
5153: END IF;
5154:
5155: p_return_status := FND_API.G_RET_STS_SUCCESS;
5156:
5157: --
5158: -- init sum to 0 for fresh rounding
5159: --

Line 5174: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5170: END IF;
5171:
5172: EXCEPTION
5173: WHEN OTHERS THEN
5174: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5175: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5176: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5177: FND_LOG.STRING(g_level_unexpected,
5178: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.process_tax_line_create',

Line 5342: p_return_status := FND_API.G_RET_STS_SUCCESS;

5338: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.process_tax_line_upd_override.BEGIN',
5339: 'ZX_TDS_TAX_ROUNDING_PKG: process_tax_line_upd_override(+)');
5340: END IF;
5341:
5342: p_return_status := FND_API.G_RET_STS_SUCCESS;
5343:
5344: --
5345: -- this is new group of tax, need to get existing sum amounts
5346: --

Line 5444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5440: END IF;
5441:
5442: EXCEPTION
5443: WHEN OTHERS THEN
5444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5445: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5446: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5447: FND_LOG.STRING(g_level_unexpected,
5448: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.process_tax_line_upd_override',

Line 5482: p_return_status := FND_API.G_RET_STS_SUCCESS;

5478: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.chk_mandatory_col_after_round.BEGIN',
5479: 'ZX_TDS_TAX_ROUNDING_PKG: chk_mandatory_col_after_round(+)');
5480: END IF;
5481:
5482: p_return_status := FND_API.G_RET_STS_SUCCESS;
5483:
5484: IF p_tax_amt IS NULL THEN
5485: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5486: p_error_buffer := 'tax_amt can not be NULL';

Line 5485: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5481:
5482: p_return_status := FND_API.G_RET_STS_SUCCESS;
5483:
5484: IF p_tax_amt IS NULL THEN
5485: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5486: p_error_buffer := 'tax_amt can not be NULL';
5487: ELSIF p_taxable_amt IS NULL THEN
5488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5489: p_error_buffer := 'taxable_amt can not be NULL';

Line 5488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5484: IF p_tax_amt IS NULL THEN
5485: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5486: p_error_buffer := 'tax_amt can not be NULL';
5487: ELSIF p_taxable_amt IS NULL THEN
5488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5489: p_error_buffer := 'taxable_amt can not be NULL';
5490: END IF;
5491:
5492: IF p_mrc_tax_line_flag = 'N' THEN

Line 5494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5490: END IF;
5491:
5492: IF p_mrc_tax_line_flag = 'N' THEN
5493: IF p_trx_currency_code IS NULL THEN
5494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5495: p_error_buffer := 'trx_currency_code can not be NULL';
5496: ELSIF p_tax_currency_code IS NULL THEN
5497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5498: p_error_buffer := 'tax_currency_code can not be NULL';

Line 5497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5493: IF p_trx_currency_code IS NULL THEN
5494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5495: p_error_buffer := 'trx_currency_code can not be NULL';
5496: ELSIF p_tax_currency_code IS NULL THEN
5497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5498: p_error_buffer := 'tax_currency_code can not be NULL';
5499: ELSIF p_tax_amt_tax_curr IS NULL THEN
5500: IF p_rate_type_code = 'QUANTITY' THEN
5501: --

Line 5504: p_return_status := FND_API.G_RET_STS_ERROR;

5500: IF p_rate_type_code = 'QUANTITY' THEN
5501: --
5502: -- Bug#5506495- quantity based tax, raise error
5503: --
5504: p_return_status := FND_API.G_RET_STS_ERROR;
5505:
5506: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5507: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5508: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN

Line 5522: p_return_status := FND_API.G_RET_STS_ERROR;

5518: IF p_rate_type_code = 'QUANTITY' THEN
5519: --
5520: -- Bug#5506495- quantity based tax, raise error
5521: --
5522: p_return_status := FND_API.G_RET_STS_ERROR;
5523:
5524: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5525: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5526: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN

Line 5549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5545: END IF;
5546:
5547: EXCEPTION
5548: WHEN OTHERS THEN
5549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5550: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5551:
5552: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5553: FND_LOG.STRING(g_level_unexpected,

Line 5599: p_return_status := FND_API.G_RET_STS_SUCCESS;

5595: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_detail_tax_lines_gt.BEGIN',
5596: 'ZX_TDS_TAX_ROUNDING_PKG: update_detail_tax_lines_gt(+)');
5597: END IF;
5598:
5599: p_return_status := FND_API.G_RET_STS_SUCCESS;
5600:
5601: l_count := p_tax_line_id_tbl.COUNT;
5602:
5603: FORALL i IN 1 .. l_count

Line 5640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5636: END IF;
5637:
5638: EXCEPTION
5639: WHEN OTHERS THEN
5640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5641: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5642:
5643: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5644: FND_LOG.STRING(g_level_unexpected,

Line 5683: p_return_status := FND_API.G_RET_STS_SUCCESS;

5679: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.BEGIN',
5680: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(+)');
5681: END IF;
5682:
5683: p_return_status := FND_API.G_RET_STS_SUCCESS;
5684:
5685: l_count := p_tax_line_id_tbl.COUNT;
5686:
5687: -- update zx_lines

Line 5708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5704: END IF;
5705:
5706: EXCEPTION
5707: WHEN OTHERS THEN
5708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5709: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5710:
5711: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5712: FND_LOG.STRING(g_level_unexpected,

Line 6020: p_return_status := FND_API.G_RET_STS_SUCCESS;

6016:
6017: --
6018: -- init error buffer and return status
6019: --
6020: p_return_status := FND_API.G_RET_STS_SUCCESS;
6021: p_error_buffer := NULL;
6022:
6023: OPEN get_trx_id_csr;
6024: LOOP

Line 6046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6042: init_header_group(l_prev_hdr_grp_rec,
6043: p_return_status,
6044: p_error_buffer);
6045:
6046: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6047: RETURN;
6048: END IF;
6049:
6050: --

Line 6200: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6196: l_tax_provider_id_tbl(i),
6197: p_return_status,
6198: p_error_buffer);
6199:
6200: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6201: EXIT;
6202: END IF;
6203:
6204: IF l_rounding_level_code_tbl(i) = 'HEADER' THEN

Line 6321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6317: l_same_tax,
6318: p_return_status,
6319: p_error_buffer);
6320:
6321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6322: EXIT;
6323: END IF;
6324:
6325: -- when not in the same rounding group

Line 6339: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6335: l_sum_rnd_tax_curr,
6336: l_sum_rnd_funcl_curr,
6337: p_return_status,
6338: p_error_buffer);
6339: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6340: EXIT;
6341: END IF;
6342: ELSIF (p_event_class_rec.tax_event_type_code = 'UPDATE' OR
6343: p_event_class_rec.tax_event_type_code = 'OVERRIDE_TAX') THEN

Line 6353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6349: l_sum_rnd_funcl_curr,
6350: p_event_class_rec,
6351: p_return_status,
6352: p_error_buffer);
6353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6354: EXIT;
6355: END IF;
6356: END IF;
6357:

Line 6395: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6391: l_ledger_id_tbl(i),
6392: p_return_status,
6393: p_error_buffer);
6394:
6395: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6396: EXIT;
6397: END IF;
6398: END IF;
6399: --

Line 6420: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

6416: p_return_status => p_return_status,
6417: p_error_buffer => p_error_buffer);
6418:
6419:
6420: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
6421: l_rate_type_code := l_tax_rate_rec.rate_type_code;
6422: END IF;
6423: END IF;
6424:

Line 6426: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6422: END IF;
6423: END IF;
6424:
6425: --Bug 7109899
6426: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6427: EXIT;
6428: END IF;
6429: END IF;
6430:

Line 6443: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6439: l_rate_type_code,
6440: p_return_status,
6441: p_error_buffer);
6442:
6443: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6444: EXIT;
6445: END IF;
6446: END IF;
6447:

Line 6452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6448: END LOOP;
6449:
6450: --Bug 7109899
6451:
6452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6453: RETURN;
6454: END IF;
6455:
6456: --

Line 6482: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6478: p_tax_line_id_tbl => l_tax_line_id_tbl,
6479: p_return_status => p_return_status,
6480: p_error_buffer => p_error_buffer);
6481:
6482: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6483: EXIT;
6484: END IF;
6485:
6486: EXIT WHEN get_round_info_csr%NOTFOUND;

Line 6491: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6487:
6488: END LOOP;
6489:
6490: CLOSE get_round_info_csr;
6491: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6492: RETURN;
6493: END IF;
6494:
6495: --

Line 6503: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6499: --
6500: adjust_rounding_diff(
6501: p_return_status,
6502: p_error_buffer);
6503: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6504: RETURN;
6505: END IF;
6506: END LOOP;
6507:

Line 6517: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 6565: p_return_status := FND_API.G_RET_STS_SUCCESS;

6561:
6562: --
6563: -- init return status
6564: --
6565: p_return_status := FND_API.G_RET_STS_SUCCESS;
6566:
6567: -- convert and round for functional currency
6568: --
6569: IF p_rounded_tax_amt <> 0 THEN

Line 6583: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6579: p_conv_rnd_tax_amt_curr,
6580: p_ledger_id,
6581: p_return_status,
6582: p_error_buffer);
6583: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6584: RETURN;
6585: END IF;
6586: END IF;
6587: IF p_rounded_taxable_amt <> 0 THEN

Line 6605: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6601: p_tax_rate_id,
6602: p_conv_rnd_tax_amt_curr,
6603: p_return_status,
6604: p_error_buffer);
6605: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6606: RETURN;
6607: END IF;
6608: END IF; -- end functional currency
6609:

Line 6619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6615: END IF;
6616:
6617: EXCEPTION
6618: WHEN OTHERS THEN
6619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6620: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6621:
6622: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6623: FND_LOG.STRING(g_level_unexpected,

Line 6711: p_return_status := FND_API.G_RET_STS_SUCCESS;

6707:
6708: --
6709: -- init return status
6710: --
6711: p_return_status := FND_API.G_RET_STS_SUCCESS;
6712:
6713: --
6714: -- get amount columns and other rounding info
6715: --

Line 6773: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6769: l_tax_rate_id_tbl(i),
6770: p_return_status,
6771: p_error_buffer);
6772:
6773: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6774: EXIT;
6775: END IF;
6776: END LOOP;
6777:

Line 6778: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6774: EXIT;
6775: END IF;
6776: END LOOP;
6777:
6778: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6779: EXIT;
6780: END IF;
6781:
6782: --

Line 6800: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6796: l_tax_line_id_tbl,
6797: p_return_status,
6798: p_error_buffer);
6799:
6800: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6801: EXIT;
6802: END IF;
6803:
6804: ELSE

Line 6813: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6809: EXIT;
6810: END IF; -- end of count > 0
6811: END LOOP;
6812:
6813: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6814: CLOSE get_round_line_level_curr_csr;
6815: RETURN;
6816: END IF;
6817:

Line 6827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6823: END IF;
6824:
6825: EXCEPTION
6826: WHEN OTHERS THEN
6827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6828: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6829: IF get_round_line_level_curr_csr%ISOPEN THEN
6830: CLOSE get_round_line_level_curr_csr;
6831: END IF;

Line 7073: p_return_status := FND_API.G_RET_STS_SUCCESS;

7069:
7070: --
7071: -- init return status
7072: --
7073: p_return_status := FND_API.G_RET_STS_SUCCESS;
7074:
7075: --
7076: -- init header group record
7077: --

Line 7082: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7078: init_header_group(l_prev_hdr_grp_rec,
7079: p_return_status,
7080: p_error_buffer);
7081:
7082: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7083: RETURN;
7084: END IF;
7085:
7086: --

Line 7196: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7192: l_tax_rate_id_tbl(i),
7193: p_return_status,
7194: p_error_buffer);
7195:
7196: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7197: EXIT;
7198: END IF;
7199: --
7200: -- get header grouping criteria of the current record

Line 7313: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7309: l_ledger_id_tbl(i),
7310: p_return_status,
7311: p_error_buffer);
7312:
7313: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7314: EXIT;
7315: END IF;
7316: END LOOP;
7317:

Line 7318: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7314: EXIT;
7315: END IF;
7316: END LOOP;
7317:
7318: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7319: EXIT;
7320: END IF;
7321:
7322: --

Line 7340: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7336: l_tax_line_id_tbl,
7337: p_return_status,
7338: p_error_buffer);
7339:
7340: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7341: EXIT;
7342: END IF;
7343:
7344: ELSE

Line 7353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7349: EXIT;
7350: END IF; -- end of count > 0
7351: END LOOP;
7352:
7353: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7354: CLOSE get_round_head_level_curr_csr;
7355: RETURN;
7356: END IF;
7357:

Line 7366: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7362: --
7363: adjust_rounding_diff_curr
7364: (p_return_status,
7365: p_error_buffer);
7366: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7367: RETURN;
7368: END IF;
7369:
7370: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 7379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7375: END IF;
7376:
7377: EXCEPTION
7378: WHEN OTHERS THEN
7379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7380: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7381: IF get_round_head_level_curr_csr%ISOPEN THEN
7382: CLOSE get_round_head_level_curr_csr;
7383: END IF;

Line 7426: p_return_status := FND_API.G_RET_STS_SUCCESS;

7422:
7423: --
7424: -- init error buffer and return status
7425: --
7426: p_return_status := FND_API.G_RET_STS_SUCCESS;
7427: p_error_buffer := NULL;
7428:
7429:
7430: -- ???????? where to get rounding level if not from zx_lines ????????

Line 7452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7448: p_return_status,
7449: p_error_buffer );
7450: END IF;
7451:
7452: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7453: RETURN;
7454: END IF;
7455:
7456: -- *****************

Line 7474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7470: END IF;
7471:
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,

Line 7595: p_return_status := FND_API.G_RET_STS_SUCCESS;

7591:
7592: --
7593: -- init error buffer and return status
7594: --
7595: p_return_status := FND_API.G_RET_STS_SUCCESS;
7596: p_error_buffer := NULL;
7597:
7598: --
7599: -- get unrounded tax amt

Line 7656: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7652: l_rounding_lvl_party_type,
7653: p_return_status,
7654: p_error_buffer);
7655:
7656: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7657: RETURN;
7658: END IF;
7659:
7660: -- get rounding info from zx_taxes_b

Line 7716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7712: END IF;
7713:
7714: EXCEPTION
7715: WHEN OTHERS THEN
7716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7717: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7718:
7719: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
7720: FND_MSG_PUB.Add;

Line 7785: p_return_status := FND_API.G_RET_STS_SUCCESS;

7781: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.Get_Supplier_Site',
7782: 'p_account_id : ' || TO_CHAR(p_account_id));
7783: END IF;
7784:
7785: p_return_status := FND_API.G_RET_STS_SUCCESS;
7786: p_rounding_level_code := NULL;
7787: p_rounding_rule_code := NULL;
7788:
7789:

Line 7925: p_return_status := FND_API.G_RET_STS_SUCCESS;

7921: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.Get_Reg_Site_Uses',
7922: 'p_site_use_id : ' || TO_CHAR(p_site_use_id));
7923: END IF;
7924:
7925: p_return_status := FND_API.G_RET_STS_SUCCESS;
7926: p_rounding_level_code := NULL;
7927: p_rounding_rule_code := NULL;
7928:
7929: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl.exists(p_site_use_id) then

Line 8037: p_return_status := FND_API.G_RET_STS_SUCCESS;

8033: 'p_account_id : ' || TO_CHAR(p_account_id)) ;
8034:
8035: END IF;
8036:
8037: p_return_status := FND_API.G_RET_STS_SUCCESS;
8038: p_rounding_level_code := NULL;
8039: p_rounding_rule_code := NULL;
8040:
8041: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl.exists(p_account_id) THEN

Line 8129: p_return_status := FND_API.G_RET_STS_SUCCESS;

8125: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.Get_Registration_Party',
8126: 'p_party_tax_profile_id : ' || TO_CHAR(p_party_tax_profile_id)) ;
8127: END IF;
8128:
8129: p_return_status := FND_API.G_RET_STS_SUCCESS;
8130: p_rounding_level_code := NULL;
8131: p_rounding_rule_code := NULL;
8132:
8133:

Line 8222: p_return_status := FND_API.G_RET_STS_SUCCESS;

8218: 'p_site_use_id : ' || TO_CHAR(p_site_use_id));
8219:
8220: END IF;
8221:
8222: p_return_status := FND_API.G_RET_STS_SUCCESS;
8223: p_rounding_level_code := NULL;
8224: p_rounding_rule_code := NULL;
8225:
8226:

Line 8238: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8234: ,p_rounding_level_code
8235: ,p_rounding_rule_code
8236: ,p_return_status
8237: );
8238: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8239: RETURN;
8240: End IF;
8241:
8242: ELSIF p_account_type_code = 'CUSTOMER' THEN

Line 8253: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8249: ,p_rounding_level_code
8250: ,p_rounding_rule_code
8251: ,p_return_status
8252: );
8253: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8254: RETURN;
8255: END IF;
8256:
8257: -- Get registration account level

Line 8265: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8261: ,p_rounding_level_code
8262: ,p_rounding_rule_code
8263: ,p_return_status
8264: );
8265: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8266: RETURN;
8267: END IF;
8268:
8269: END If;

Line 8283: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8279: ,p_rounding_rule_code
8280: ,p_return_status
8281: );
8282:
8283: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8284: RETURN;
8285: END IF;
8286:
8287: IF p_rounding_level_code IS NULL THEN

Line 8306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8302: END IF;
8303:
8304: EXCEPTION
8305: WHEN OTHERS THEN
8306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8307: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8308:
8309: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8310: FND_LOG.STRING(g_level_unexpected,

Line 8350: p_return_status := FND_API.G_RET_STS_SUCCESS;

8346: ' p_ledger_id = ' || to_char(p_ledger_id));
8347:
8348: END IF;
8349:
8350: p_return_status := FND_API.G_RET_STS_SUCCESS;
8351:
8352: --
8353: -- get functional currency info
8354: --

Line 8372: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8368: (p_ledger_id,
8369: p_return_status,
8370: p_error_buffer );
8371:
8372: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8373: --
8374: -- error getting min acct unit and precision
8375: -- return original unround amount to caller
8376: --

Line 8400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8396: END IF;
8397:
8398: EXCEPTION
8399: WHEN OTHERS THEN
8400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8401: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8402:
8403: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8404: FND_LOG.STRING(g_level_unexpected,