1738: l_trx_date DATE;
1739: l_trx_line_date DATE;
1740: l_prov_tax_det_date DATE;
1741: l_return_status VARCHAR2(30);
1742: l_upg_trx_info_rec ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type;
1743: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1744:
1745: BEGIN
1746: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1779: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
1780: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;
1781: l_upg_trx_info_rec.event_class_code := p_event_class_rec.event_class_code;
1782: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
1783: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1784: x_return_status => l_return_status
1785: );
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1784: x_return_status => l_return_status
1785: );
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1788: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1789: END IF;
1790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: l_prov_tax_det_date DATE;
1897: l_adjusted_doc_date DATE;
1898: l_first_pty_org_id NUMBER;
1899: l_return_status VARCHAR2(30);
1900: l_upg_trx_info_rec ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type;
1901: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1902:
1903: BEGIN
1904: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1934: l_upg_trx_info_rec.application_id := p_application_id;
1935: l_upg_trx_info_rec.entity_code := p_entity_code;
1936: l_upg_trx_info_rec.event_class_code := p_event_class_code;
1937: l_upg_trx_info_rec.trx_id := p_trx_id;
1938: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
1939: x_return_status => l_return_status
1940: );
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1939: x_return_status => l_return_status
1940: );
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1943: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
1944: END IF;
1945: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2033: l_entity_code VARCHAR2(30);
2034: l_event_class_code VARCHAR2(30);
2035: l_trx_id NUMBER;
2036: l_return_status VARCHAR2(1);
2037: l_upg_trx_info_rec ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type;
2038: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2039:
2040: BEGIN
2041: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2096: l_upg_trx_info_rec.application_id := p_event_class_rec.application_id;
2097: l_upg_trx_info_rec.entity_code := p_event_class_rec.entity_code;
2098: l_upg_trx_info_rec.event_class_code := p_event_class_rec.event_class_code;
2099: l_upg_trx_info_rec.trx_id := p_event_class_rec.trx_id;
2100: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
2101: x_return_status => l_return_status
2102: );
2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2101: x_return_status => l_return_status
2102: );
2103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2105: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly returned errors');
2106: END IF;
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN