[Home] [Help]
1712: -- partner_pre_processing
1713: --
1714: -- DESCRIPTION
1715: -- This procedure is used to prepare the information to be passed to the tax
1716: -- partner services. It sets attributes in ZX_TRX_PRE_PROC_OPTIONS_GT so that
1717: -- partner interface views pick the correct data for the transaction and
1718: -- partner under consideration
1719: --
1720: -- CALLED BY
1739: l_return_status VARCHAR2(1);
1740: l_line_level_action VARCHAR2(30);
1741: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1742: -- Bug# 4769082
1743: l_legal_entity_number ZX_TRX_PRE_PROC_OPTIONS_GT.legal_entity_number%type;
1744: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1745: l_application_short_name FND_APPLICATION.application_short_name%type;
1746: -- Bug# 4769082
1747: l_cnt_of_options_gt NUMBER;
1740: l_line_level_action VARCHAR2(30);
1741: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1742: -- Bug# 4769082
1743: l_legal_entity_number ZX_TRX_PRE_PROC_OPTIONS_GT.legal_entity_number%type;
1744: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1745: l_application_short_name FND_APPLICATION.application_short_name%type;
1746: -- Bug# 4769082
1747: l_cnt_of_options_gt NUMBER;
1748: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1787: l_tax_provider_id := p_tax_provider_id;
1788:
1789: END IF;
1790:
1791: DELETE from ZX_TRX_PRE_PROC_OPTIONS_GT;
1792:
1793: --Set the context for the partner interface views
1794: IF ZX_API_PUB.G_PUB_SRVC = 'SYNCHRONIZE_TAX_REPOSITORY' THEN
1795: BEGIN
1792:
1793: --Set the context for the partner interface views
1794: IF ZX_API_PUB.G_PUB_SRVC = 'SYNCHRONIZE_TAX_REPOSITORY' THEN
1795: BEGIN
1796: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
1797: APPLICATION_ID,
1798: ENTITY_CODE,
1799: EVENT_CLASS_CODE,
1800: EVNT_CLS_MAPPING_ID,
1834: AND clsmap.event_class_code = p_event_class_rec.event_class_code;
1835: EXCEPTION WHEN OTHERS THEN
1836: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1838: ' SYNCHRONIZE_TAX_REPOSITORY: Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1839: END IF;
1840: END;
1841: ELSE
1842: BEGIN
1926: END IF;
1927: -- Bug# 4769082
1928:
1929: BEGIN
1930: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
1931: APPLICATION_ID,
1932: ENTITY_CODE,
1933: EVENT_CLASS_CODE,
1934: EVNT_CLS_MAPPING_ID,
1982: fnd_global.conc_login_id);
1983: EXCEPTION WHEN OTHERS THEN
1984: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1985: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1986: ' Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1987: END IF;
1988: END;
1989:
1990: END IF; -- API is synchronize_tax
1992: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1993: BEGIN
1994: SELECT count(*)
1995: INTO l_cnt_of_options_gt
1996: FROM ZX_TRX_PRE_PROC_OPTIONS_GT;
1997: EXCEPTION WHEN OTHERS THEN
1998: l_cnt_of_options_gt := 0;
1999: END;
2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1997: EXCEPTION WHEN OTHERS THEN
1998: l_cnt_of_options_gt := 0;
1999: END;
2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2001: 'The record is inserted in ZX_TRX_PRE_PROC_OPTIONS_GT = ' || l_cnt_of_options_gt);
2002: END IF;
2003: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2005: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
2319: l_return_status VARCHAR2(1);
2320: l_tax_precision NUMBER;
2321: l_threshold_indicator_flag VARCHAR2(1);
2322: l_partner_migrated_flag VARCHAR2(1);
2323: l_allow_tax_calculation_flag ZX_TRX_PRE_PROC_OPTIONS_GT.allow_tax_calculation_flag%type;
2324:
2325: --Table to derive the apportionment number in case the transaction line has same taxes
2326: TYPE tax_tbl_type is table of NUMBER index by VARCHAR2(240);
2327:
2426: */
2427: BEGIN
2428: SELECT allow_tax_calculation_flag
2429: INTO l_allow_tax_calculation_flag
2430: FROM ZX_TRX_PRE_PROC_OPTIONS_GT
2431: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
2432: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
2433: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
2434: AND TRX_ID = p_event_class_rec.TRX_ID;