[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;
471:
472: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX','OVERRIDE_TAX',
473: 'GET_DEFAULT_TAX_DET_ATTRS','VALIDATE_DOCUMENT_FOR_TAX') THEN
474: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
475: SELECT /*+ INDEX (ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1)*/
476: adjusted_doc_date
477: INTO l_adj_doc_date
478: FROM ZX_TRANSACTION_LINES_GT
479: WHERE application_id = p_event_class_rec.application_id
474: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
475: SELECT /*+ INDEX (ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1)*/
476: adjusted_doc_date
477: INTO l_adj_doc_date
478: FROM ZX_TRANSACTION_LINES_GT
479: WHERE application_id = p_event_class_rec.application_id
480: AND entity_code = p_event_class_rec.entity_code
481: AND event_class_code = p_event_class_rec.event_class_code
482: AND trx_id = p_event_class_rec.trx_id
518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
522: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
523: ' which is incorrect or the event information in headers and lines is incorrect.'||
524: SQLERRM);
525: END IF;
526: END determine_effective_date;
717: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN --import/calculate_tax
718: SELECT opt.process_for_applicability_flag
719: INTO p_event_class_rec.source_process_for_appl_flag
720: FROM zx_evnt_cls_options opt,
721: zx_transaction_lines_gt lines
722: WHERE opt.application_id = lines.source_application_id
723: AND opt.entity_code = lines.source_entity_code
724: AND opt.event_class_code = lines.source_event_class_code
725: AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id