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_NEW_SERVICES_PKG dependencies on ZX_NEW_SERVICES_PKG

Line 1: PACKAGE BODY ZX_NEW_SERVICES_PKG AS

1: PACKAGE BODY ZX_NEW_SERVICES_PKG AS
2: /* $Header: zxifnewsrvcspubb.pls 120.13.12020000.4 2013/03/15 10:12:09 ssohal ship $ */
3:
4: /* ======================================================================*
5: | Global Data Types |

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';

4: /* ======================================================================*
5: | Global Data Types |
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 479: 'ZX_NEW_SERVICES_PKG: Pop_Index_Attrbs_To_Null()-');

475: ZX_Global_Structures_Pkg.trx_line_dist_tbl.Trx_level_type(p_index) := l_trx_level_type;
476:
477: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
478: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
479: 'ZX_NEW_SERVICES_PKG: Pop_Index_Attrbs_To_Null()-');
480: END IF;
481:
482: EXCEPTION
483: WHEN OTHERS THEN

Line 864: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

860: BEGIN
861:
862: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
864: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
865: END IF;
866:
867: /*--------------------------------------------------+
868: | Standard start of API savepoint |

Line 1037: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

1033:
1034: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1035: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1036: G_MODULE_NAME||l_api_name||'.END',
1037: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN

Line 1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

1151:
1152: BEGIN
1153:
1154: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
1156: END IF;
1157:
1158: SAVEPOINT update_det_factors_PVT;
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',

1181: IF l_evnt_cls.internal_organization_id.COUNT > 1 THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1184: FND_LOG.STRING(g_level_unexpected,
1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');
1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

Line 1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1184: FND_LOG.STRING(g_level_unexpected,
1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');
1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1190: END IF;
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;

Line 1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');
1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1190: END IF;
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:

Line 1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1243: x_return_status := l_return_status ;
1244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1246: G_PKG_NAME||': '||l_api_name||':ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors');
1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1248: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1249: END IF;
1250: RETURN;
1251: END IF;

Line 1248: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1246: G_PKG_NAME||': '||l_api_name||':ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors');
1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1248: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1249: END IF;
1250: RETURN;
1251: END IF;
1252:

Line 1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1268: ' RETURN_STATUS = ' || x_return_status);
1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1270: G_PKG_NAME||': '||l_api_name||':ZX_TCM_PTP_PKG.get_location_id returned errors');
1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1272: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1273: END IF;
1274: RETURN;
1275: END IF;

Line 1272: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1268: ' RETURN_STATUS = ' || x_return_status);
1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1270: G_PKG_NAME||': '||l_api_name||':ZX_TCM_PTP_PKG.get_location_id returned errors');
1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1272: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1273: END IF;
1274: RETURN;
1275: END IF;
1276:

Line 1280: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',

1276:
1277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1279: 'p_trx_line_id:' || p_trx_line_id);
1280: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1281: 'p_trx_level_type: ' || p_trx_level_type);
1282: END IF;
1283:
1284: OPEN c_lines(l_event_class_rec,

Line 1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1669: x_return_status := l_return_status;
1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1674: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1675: END IF;
1676: IF c_lines%ISOPEN THEN
1677: CLOSE c_lines;

Line 1674: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1674: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1675: END IF;
1676: IF c_lines%ISOPEN THEN
1677: CLOSE c_lines;
1678: END IF;

Line 1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1689: x_return_status := l_return_status;
1690: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1692: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1694: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1695: END IF;
1696: IF c_lines%ISOPEN THEN
1697: CLOSE c_lines;

Line 1694: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1690: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1692: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1694: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1695: END IF;
1696: IF c_lines%ISOPEN THEN
1697: CLOSE c_lines;
1698: END IF;

Line 1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1718: x_return_status := l_return_status;
1719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1721: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.get_tax_event_type returned errors');
1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1723: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1724: END IF;
1725: IF c_lines%ISOPEN THEN
1726: CLOSE c_lines;

Line 1723: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1721: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.get_tax_event_type returned errors');
1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1723: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1724: END IF;
1725: IF c_lines%ISOPEN THEN
1726: CLOSE c_lines;
1727: END IF;

Line 1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1743: x_return_status := l_return_status;
1744: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1746: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.populate_event_class_options returned errors');
1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1748: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1749: END IF;
1750: IF c_lines%ISOPEN THEN
1751: CLOSE c_lines;

Line 1748: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1744: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1746: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.populate_event_class_options returned errors');
1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1748: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1749: END IF;
1750: IF c_lines%ISOPEN THEN
1751: CLOSE c_lines;
1752: END IF;

Line 1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1765: x_return_status := l_return_status;
1766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1768: G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1770: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1771: END IF;
1772: IF c_lines%ISOPEN THEN
1773: CLOSE c_lines;

Line 1770: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1768: G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1770: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1771: END IF;
1772: IF c_lines%ISOPEN THEN
1773: CLOSE c_lines;
1774: END IF;

Line 1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');

1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1795: END IF;
1796: IF c_lines%ISOPEN THEN

Line 1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1795: END IF;
1796: IF c_lines%ISOPEN THEN
1797: CLOSE c_lines;

Line 1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1795: END IF;
1796: IF c_lines%ISOPEN THEN
1797: CLOSE c_lines;
1798: END IF;

Line 1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');

1822: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1829: END IF;
1830: RETURN;

Line 1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1829: END IF;
1830: RETURN;
1831: END IF;

Line 1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');

1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1829: END IF;
1830: RETURN;
1831: END IF;
1832:

Line 2071: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

2067: HAVING zl.tax_amt <> SUM(zd.rec_nrec_tax_amt);
2068:
2069: BEGIN
2070: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2071: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
2072: END IF;
2073:
2074: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2212: FND_LOG.STRING(G_LEVEL_STATEMENT,
2213: G_MODULE_NAME || l_api_name,
2214: G_PKG_NAME||':'||l_api_name||': Event Class Info not retreived');
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2217: 'RETURN_STATUS = ' || x_return_status);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2217: 'RETURN_STATUS = ' || x_return_status);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2221: END IF;
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: END IF;

Line 2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2217: 'RETURN_STATUS = ' || x_return_status);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2221: END IF;
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: END IF;
2224:

Line 2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2247: x_return_status := l_return_status;
2248: IF (g_level_statement >= g_current_runtime_level ) THEN
2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2251: 'Incorrect return_status after calling ' ||
2252: ' ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly');
2253: FND_LOG.STRING(g_level_statement,
2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2251: 'Incorrect return_status after calling ' ||
2252: ' ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly');
2253: FND_LOG.STRING(g_level_statement,
2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2255: 'RETURN_STATUS = ' || x_return_status);
2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2253: FND_LOG.STRING(g_level_statement,
2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2255: 'RETURN_STATUS = ' || x_return_status);
2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;

Line 2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2255: 'RETURN_STATUS = ' || x_return_status);
2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE

Line 2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2275:
2276: IF NOT l_trx_migrated_b THEN
2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2280: 'New Item Line with no tax impacts in Payables, no action required');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2283: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2280: 'New Item Line with no tax impacts in Payables, no action required');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2283: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2284: END IF;
2285: RETURN;
2286: END IF;

Line 2283: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2280: 'New Item Line with no tax impacts in Payables, no action required');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2283: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2284: END IF;
2285: RETURN;
2286: END IF;
2287:

Line 2294: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2290: FROM ZX_REVERSE_DIST_GT;
2291:
2292: IF (g_level_statement >= g_current_runtime_level ) THEN
2293: FND_LOG.STRING(g_level_statement,
2294: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2295: 'Count in ZX_REVERSE_DIST_GT : '||TO_CHAR(l_count));
2296: END IF;
2297:
2298: -- If distributions exists

Line 2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2307: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2308: x_return_status := l_return_status;
2309: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2310: FND_LOG.STRING(g_level_unexpected,
2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2312: 'Incorrect return_status after calling ' ||
2313: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2314: FND_LOG.STRING(g_level_unexpected,
2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2312: 'Incorrect return_status after calling ' ||
2313: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2314: FND_LOG.STRING(g_level_unexpected,
2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2316: 'RETURN_STATUS = ' || x_return_status);
2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2314: FND_LOG.STRING(g_level_unexpected,
2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2316: 'RETURN_STATUS = ' || x_return_status);
2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2322: RAISE FND_API.G_EXC_ERROR;

Line 2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2316: 'RETURN_STATUS = ' || x_return_status);
2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: ELSE

Line 2470: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2466: -- Cancel flow for the entire Invoice
2467: ELSE
2468: IF (g_level_statement >= g_current_runtime_level ) THEN
2469: FND_LOG.STRING(g_level_statement,
2470: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2471: 'Canceling Complete Invoice');
2472: END IF;
2473: -- Reverse the tax distributions, Payables needs to populate
2474: -- zx_reverse_dist_gt for this case.

Line 2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2477: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2478: x_return_status := l_return_status;
2479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2480: FND_LOG.STRING(g_level_unexpected,
2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2482: 'Incorrect return_status after calling ' ||
2483: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2484: FND_LOG.STRING(g_level_unexpected,
2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2482: 'Incorrect return_status after calling ' ||
2483: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2484: FND_LOG.STRING(g_level_unexpected,
2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2486: 'RETURN_STATUS = ' || x_return_status);
2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2484: FND_LOG.STRING(g_level_unexpected,
2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2486: 'RETURN_STATUS = ' || x_return_status);
2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2492: RAISE FND_API.G_EXC_ERROR;

Line 2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2486: 'RETURN_STATUS = ' || x_return_status);
2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE

Line 2501: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2497:
2498: -- Update the freeze flag for the entire invoice
2499: IF (g_level_statement >= g_current_runtime_level ) THEN
2500: FND_LOG.STRING(g_level_statement,
2501: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2502: 'Updating the Freeze_Flag');
2503: END IF;
2504:
2505: UPDATE ZX_REC_NREC_DIST

Line 2583: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2579:
2580: -- Check if there exist tax lines that do not have any distributions
2581: IF (g_level_statement >= g_current_runtime_level ) THEN
2582: FND_LOG.STRING(g_level_statement,
2583: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2584: 'Checking for Tax Lines without distributions');
2585: END IF;
2586:
2587: BEGIN

Line 2608: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2604: AND ROWNUM = 1);
2605: EXCEPTION WHEN OTHERS THEN
2606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2607: FND_LOG.STRING(g_level_unexpected,
2608: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2609: 'Query to check for Tax Lines without dists failed with error '||SQLERRM);
2610: END IF;
2611: l_tax_line_count := 0;
2612: END;

Line 2616: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2612: END;
2613:
2614: IF (g_level_statement >= g_current_runtime_level ) THEN
2615: FND_LOG.STRING(g_level_statement,
2616: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2617: 'Count of Tax Lines without distributions = '||l_tax_line_count);
2618: END IF;
2619:
2620: IF l_tax_line_count > 0 THEN

Line 2673: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2669: AND ROWNUM = 1);
2670:
2671: IF (g_level_statement >= g_current_runtime_level ) THEN
2672: FND_LOG.STRING(g_level_statement,
2673: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2674: 'No. of Rows Updated : '||SQL%ROWCOUNT);
2675: END IF;
2676: END IF;
2677:

Line 2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',

2896: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2897: x_return_status := l_return_status;
2898: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2899: FND_LOG.STRING(g_level_unexpected,
2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2901: 'Incorrect return_status after calling ' ||
2902: 'ZX_API_PUB.discard_tax_only_lines');
2903: FND_LOG.STRING(g_level_unexpected,
2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2901: 'Incorrect return_status after calling ' ||
2902: 'ZX_API_PUB.discard_tax_only_lines');
2903: FND_LOG.STRING(g_level_unexpected,
2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2905: 'RETURN_STATUS = ' || x_return_status);
2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2903: FND_LOG.STRING(g_level_unexpected,
2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2905: 'RETURN_STATUS = ' || x_return_status);
2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2911: RAISE FND_API.G_EXC_ERROR;

Line 2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2905: 'RETURN_STATUS = ' || x_return_status);
2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2911: RAISE FND_API.G_EXC_ERROR;
2912: ELSE

Line 2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',

2941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2942: x_return_status := l_return_status;
2943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2944: FND_LOG.STRING(g_level_unexpected,
2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2946: 'Incorrect return_status after calling ' ||
2947: 'ZX_API_PUB.Global_document_update');
2948: FND_LOG.STRING(g_level_unexpected,
2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2946: 'Incorrect return_status after calling ' ||
2947: 'ZX_API_PUB.Global_document_update');
2948: FND_LOG.STRING(g_level_unexpected,
2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2950: 'RETURN_STATUS = ' || x_return_status);
2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

Line 2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

2948: FND_LOG.STRING(g_level_unexpected,
2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2950: 'RETURN_STATUS = ' || x_return_status);
2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;

Line 2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');

2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2950: 'RETURN_STATUS = ' || x_return_status);
2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSE

Line 2965: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2961:
2962: --Preventice checks
2963: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2964: FND_LOG.STRING(G_LEVEL_STATEMENT,
2965: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2966: 'Opening Preventive Check Cursor Check_Canceled_Tax_Lines');
2967: END IF;
2968:
2969: l_chk_tax_line_id_tbl.DELETE;

Line 2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2981:
2982: IF check_canceled_tax_lines%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
2983: l_return_status := FND_API.G_RET_STS_ERROR;
2984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2986: 'Following tax lines are not canceled properly:');
2987: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2989: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2986: 'Following tax lines are not canceled properly:');
2987: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2989: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
2990: ', CANCEL_FLAG: '||l_chk_cancel_flg_tbl(i)||
2991: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i)));
2992: END LOOP;

Line 2996: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2992: END LOOP;
2993: END IF;
2994: ELSE
2995: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2996: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2997: 'No problematic records found. Tax canceled successfully.');
2998: END IF;
2999: END IF;
3000: EXIT WHEN check_canceled_tax_lines%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3006: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3002: CLOSE check_canceled_tax_lines;
3003:
3004: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3005: FND_LOG.STRING(G_LEVEL_STATEMENT,
3006: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3007: 'Opening Preventive Check Cursor Check_Tax_Lines_Dists_Amt');
3008: END IF;
3009:
3010: l_chk_tax_line_id_tbl.DELETE;

Line 3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3023: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3024: l_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3028: 'Following tax lines and its distributions are out of sync:');
3029: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3031: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3026: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3028: 'Following tax lines and its distributions are out of sync:');
3029: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3031: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
3032: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i))||
3033: ', TOTAL_DIST_AMT: '||TO_CHAR(l_chk_tot_dist_amt_tbl(i)));
3034: END LOOP;

Line 3038: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3034: END LOOP;
3035: END IF;
3036: ELSE
3037: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3038: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3039: 'No problematic records found. Tax lines and distributions are in sync.');
3040: END IF;
3041: END IF;
3042: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

3052: RAISE FND_API.G_EXC_ERROR;
3053: END IF;
3054:
3055: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3057: END IF;
3058:
3059: EXCEPTION
3060: WHEN FND_API.G_EXC_ERROR THEN

Line 3171: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

3167: HAVING zl.tax_amt <> SUM(zd.rec_nrec_tax_amt);
3168:
3169: BEGIN
3170: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
3172: END IF;
3173:
3174: /*--------------------------------------------------+
3175: | Standard start of API savepoint |

Line 3279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3275: l_chk_tot_dist_amt_tbl.DELETE;
3276:
3277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING(G_LEVEL_STATEMENT,
3279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3280: 'Opening Preventive Check Cursor Check_Tax_Lines_Dists_Amt');
3281: END IF;
3282:
3283: OPEN check_tax_lines_dists_amt;

Line 3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3292: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294:
3295: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3297: 'Following tax lines and its distributions are out of sync:');
3298: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3300: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3295: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3297: 'Following tax lines and its distributions are out of sync:');
3298: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3300: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
3301: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i))||
3302: ', TOTAL_DIST_AMT: '||TO_CHAR(l_chk_tot_dist_amt_tbl(i)));
3303: END LOOP;

Line 3307: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3303: END LOOP;
3304: END IF;
3305: ELSE
3306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3307: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3308: 'No problematic records found. Tax lines and distributions are in sync.');
3309: END IF;
3310: END IF;
3311: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

3350: END IF;
3351: -- End : Preventive check code --
3352:
3353: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3355: END IF;
3356:
3357: EXCEPTION
3358: WHEN FND_API.G_EXC_ERROR THEN

Line 3439: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

3435: BEGIN
3436:
3437: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
3439: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
3440: END IF;
3441:
3442: /*--------------------------------------------------+
3443: | Standard start of API savepoint |

Line 3511: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

3507:
3508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3509: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3510: G_MODULE_NAME||l_api_name||'.END',
3511: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3512: END IF;
3513:
3514: EXCEPTION
3515: WHEN FND_API.G_EXC_ERROR THEN

Line 3572: END ZX_NEW_SERVICES_PKG;

3568:
3569: END SYNC_TAX_DIST_DFF;
3570: --End Bug 7117340 --DFF ER
3571:
3572: END ZX_NEW_SERVICES_PKG;