[Home] [Help]
105: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
106: FND_LOG.STRING(
107: G_LEVEL_UNEXPECTED,
108: G_MODULE_NAME||l_api_name,
109: 'No lines exist in zx_transaction_lines_gt which '||
110: 'is incorrect or the event information in headers and lines is incorrect.' ||
111: SQLERRM);
112: END IF;
113: END get_locations;
472:
473: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX','OVERRIDE_TAX',
474: 'GET_DEFAULT_TAX_DET_ATTRS','VALIDATE_DOCUMENT_FOR_TAX') THEN
475: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
476: SELECT /*+ INDEX (ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1)*/
477: adjusted_doc_date,
478: trx_line_date --Bug 13547362
479: INTO l_adj_doc_date,
480: l_trx_line_date
477: adjusted_doc_date,
478: trx_line_date --Bug 13547362
479: INTO l_adj_doc_date,
480: l_trx_line_date
481: FROM ZX_TRANSACTION_LINES_GT
482: WHERE application_id = p_event_class_rec.application_id
483: AND entity_code = p_event_class_rec.entity_code
484: AND event_class_code = p_event_class_rec.event_class_code
485: AND trx_id = p_event_class_rec.trx_id
525: WHEN OTHERS THEN
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
529: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
530: ' which is incorrect or the event information in headers and lines is incorrect.'||
531: SQLERRM);
532: END IF;
533: END determine_effective_date;
721: AND p_trx_date >= opt.EFFECTIVE_FROM and p_trx_date <= nvl(opt.EFFECTIVE_TO,p_trx_date)
722: AND opt.enabled_flag = 'Y';
723: END IF;
724: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN --import/calculate_tax
725: SELECT /*+ FIRST_ROWS(1) leading (LINES) INDEX(LINES ZX_TRANSACTION_LINES_GT_U1)*/
726: opt.process_for_applicability_flag
727: INTO p_event_class_rec.source_process_for_appl_flag
728: FROM zx_evnt_cls_options opt,
729: zx_transaction_lines_gt lines
725: SELECT /*+ FIRST_ROWS(1) leading (LINES) INDEX(LINES ZX_TRANSACTION_LINES_GT_U1)*/
726: opt.process_for_applicability_flag
727: INTO p_event_class_rec.source_process_for_appl_flag
728: FROM zx_evnt_cls_options opt,
729: zx_transaction_lines_gt lines
730: WHERE opt.application_id = lines.source_application_id
731: AND opt.entity_code = lines.source_entity_code
732: AND opt.event_class_code = lines.source_event_class_code
733: AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id