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_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_TDS_RULE_BASE_DETM_PVT

Line 1015: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(

1011:
1012: l_tax_service_type_code := 'DET_DIRECT_RATE';
1013: l_result := FALSE;
1014:
1015: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(
1016: l_tax_service_type_code,
1017: 'TRX_LINE_DIST_TBL',
1018: p_trx_line_index,
1019: p_event_class_rec,

Line 1034: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');

1030: IF (g_level_statement >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_statement,
1032: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1033: 'Incorrect return_status after calling ' ||
1034: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');
1035: END IF;
1036:
1037: x_direct_rate_result_rec := NULL;
1038: x_direct_rate_result_id := NULL;

Line 5277: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5273:
5274: x_return_status := FND_API.G_RET_STS_SUCCESS;
5275: -- get l_reg_party_prof_id
5276: --
5277: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5278: p_structure_name,
5279: p_structure_index,
5280: p_reg_party_type || '_' || 'TAX_PROF_ID',
5281: l_reg_party_prof_id,

Line 5290: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5286: IF (g_level_error >= g_current_runtime_level ) THEN
5287: FND_LOG.STRING(g_level_error,
5288: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5289: 'Incorrect return_status after calling ' ||
5290: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5291: FND_LOG.STRING(g_level_error,
5292: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5293: 'l_reg_party_prof_id = ' || l_reg_party_prof_id);
5294: FND_LOG.STRING(g_level_error,

Line 5310: l_first_party_flag := ZX_TDS_RULE_BASE_DETM_PVT.evaluate_if_first_party(p_reg_party_type);

5306: -- establishment will be used. If registration status of third party is required, then the
5307: -- registration at site level will be attemtped to be derived. Failing which, the party level
5308: -- registration will be obtained.
5309:
5310: l_first_party_flag := ZX_TDS_RULE_BASE_DETM_PVT.evaluate_if_first_party(p_reg_party_type);
5311:
5312: IF l_first_party_flag THEN
5313:
5314: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

Line 5314: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5310: l_first_party_flag := ZX_TDS_RULE_BASE_DETM_PVT.evaluate_if_first_party(p_reg_party_type);
5311:
5312: IF l_first_party_flag THEN
5313:
5314: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5315: p_structure_name,
5316: p_structure_index,
5317: 'HQ_ESTB_PARTY_TAX_PROF_ID',
5318: l_hq_estb_ptp_id,

Line 5327: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5323: IF (g_level_error >= g_current_runtime_level ) THEN
5324: FND_LOG.STRING(g_level_error,
5325: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5326: 'Incorrect return_status after calling ' ||
5327: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5328: FND_LOG.STRING(g_level_error,
5329: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5330: 'l_hq_estb_ptp_id = ' || l_hq_estb_ptp_id);
5331: FND_LOG.STRING(g_level_error,

Line 5354: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5350: SUBSTR(p_reg_party_type, 1, 9) IN ('SHIP_FROM','BILL_FROM')
5351: THEN
5352: -- get l_account_site_id
5353: --
5354: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5355: p_structure_name,
5356: p_structure_index,
5357: SUBSTR(p_reg_party_type,1,5) || 'THIRD_PTY_ACCT_SITE_ID',
5358: l_account_site_id,

Line 5367: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5363: IF (g_level_error >= g_current_runtime_level ) THEN
5364: FND_LOG.STRING(g_level_error,
5365: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5366: 'Incorrect return_status after calling ' ||
5367: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5368: FND_LOG.STRING(g_level_error,
5369: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5370: 'l_account_site_id = ' || l_account_site_id);
5371: FND_LOG.STRING(g_level_error,

Line 5383: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5379: END IF;
5380:
5381: -- get l_account_id
5382: --
5383: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5384: p_structure_name,
5385: p_structure_index,
5386: SUBSTR(p_reg_party_type,1,5) || 'THIRD_PTY_ACCT_ID',
5387: l_account_id,

Line 5396: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5392: IF (g_level_error >= g_current_runtime_level ) THEN
5393: FND_LOG.STRING(g_level_error,
5394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5395: 'Incorrect return_status after calling ' ||
5396: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5397: FND_LOG.STRING(g_level_error,
5398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5399: 'l_account_id = ' || l_account_id);
5400: FND_LOG.STRING(g_level_error,

Line 5415: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5411: -- get l_site_use_id
5412: --
5413: IF SUBSTR(p_reg_party_type, 1, 7) IN ('SHIP_TO', 'BILL_TO') THEN
5414:
5415: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5416: p_structure_name,
5417: p_structure_index,
5418: SUBSTR(p_reg_party_type, 1,7) || '_' || 'CUST_ACCT_SITE_USE_ID',
5419: l_site_use_id,

Line 5430: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5426: IF (g_level_error >= g_current_runtime_level ) THEN
5427: FND_LOG.STRING(g_level_error,
5428: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5429: 'Incorrect return_status after calling ' ||
5430: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5431: FND_LOG.STRING(g_level_error,
5432: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5433: 'l_site_use_id = ' || l_site_use_id);
5434: FND_LOG.STRING(g_level_error,

Line 5454: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5450: -- Alway pass l_parent_ptp_id and l_site_ptp_id
5451: --
5452: l_parent_ptp_id := l_reg_party_prof_id;
5453:
5454: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5455: p_structure_name,
5456: p_structure_index,
5457: REPLACE(p_reg_party_type, 'PARTY', 'SITE') || '_' || 'TAX_PROF_ID',
5458: l_site_ptp_id,

Line 5467: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5463: IF (g_level_error >= g_current_runtime_level ) THEN
5464: FND_LOG.STRING(g_level_error,
5465: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5466: 'Incorrect return_status after calling ' ||
5467: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5468: FND_LOG.STRING(g_level_error,
5469: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5470: 'l_site_ptp_id = ' || l_site_ptp_id);
5471: FND_LOG.STRING(g_level_error,

Line 5579: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_registration_info',

5575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5576:
5577: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5578: FND_LOG.STRING(g_level_unexpected,
5579: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_registration_info',
5580: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5581: END IF;
5582:
5583: END get_tax_registration_info;

Line 5977: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5973: -- bug 4633146
5974: --
5975: IF p_event_class_rec.prod_family_grp_code = 'P2P' THEN
5976:
5977: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5978: 'TRX_LINE_DIST_TBL',
5979: p_trx_line_index,
5980: 'SHIP_TO_PARTY_TAX_PROF_ID',
5981: l_party_ptp_id,

Line 5987: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5983: x_error_buffer);
5984:
5985: ELSIF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
5986:
5987: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5988: 'TRX_LINE_DIST_TBL',
5989: p_trx_line_index,
5990: 'SHIP_FROM_PARTY_TAX_PROF_ID',
5991: l_party_ptp_id,

Line 6096: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(

6092: END IF;
6093:
6094: x_return_status := FND_API.G_RET_STS_SUCCESS;
6095:
6096: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(
6097: p_tax_service_type_code,
6098: 'TRX_LINE_DIST_TBL',
6099: p_trx_line_index,
6100: p_event_class_rec,

Line 6115: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');

6111: IF (g_level_statement >= g_current_runtime_level ) THEN
6112: FND_LOG.STRING(g_level_statement,
6113: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm',
6114: 'Incorrect return_status after calling ' ||
6115: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');
6116: END IF;
6117:
6118: x_alphanumeric_result := NULL;
6119: x_result_id := NULL;

Line 8238: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (

8234:
8235: -- The following procedure is currently PRIVATE inside rule engine.
8236: -- It has to be made public to be called as below
8237:
8238: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (
8239: p_structure_name => 'TRX_LINE_DIST_TBL',
8240: p_structure_index => p_trx_line_index,
8241: p_return_status => x_return_status,
8242: p_error_buffer => l_error_buffer);

Line 8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,

8242: p_error_buffer => l_error_buffer);
8243:
8244: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8245: p_constraint_id => l_constraint_id,
8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

Line 8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,

8243:
8244: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8245: p_constraint_id => l_constraint_id,
8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

Line 8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,

8244: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8245: p_constraint_id => l_constraint_id,
8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

Line 8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,

8245: p_constraint_id => l_constraint_id,
8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

Line 8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

8246: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

Line 8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

8247: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

Line 8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

8248: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

Line 8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

8249: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

Line 8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

8250: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

Line 8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

8251: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

Line 8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

8252: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

Line 8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

8253: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

Line 8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

8254: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

Line 8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

8255: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

Line 8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

8256: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8264: p_cec_result => l_cec_result,

Line 8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

8257: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8264: p_cec_result => l_cec_result,
8265: p_action_rec_tbl => l_action_rec_tbl,

Line 8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

8258: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8264: p_cec_result => l_cec_result,
8265: p_action_rec_tbl => l_action_rec_tbl,
8266: p_return_status => x_return_status,

Line 8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

8259: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8260: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8261: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8262: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8263: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8264: p_cec_result => l_cec_result,
8265: p_action_rec_tbl => l_action_rec_tbl,
8266: p_return_status => x_return_status,
8267: p_error_buffer => l_error_buffer);

Line 8369: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (

8365:
8366:
8367: -- The initialization would have occurred earlier if the constraint_id was NOT NULL
8368:
8369: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (
8370:
8371: p_structure_name => 'TRX_LINE_DIST_TBL',
8372:
8373: p_structure_index => p_trx_line_index,

Line 8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,

8382:
8383: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8384: p_condition_set_id => l_condition_set_tbl(j),
8385: p_exception_set_id => l_exception_set_tbl(j),
8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

Line 8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,

8383: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8384: p_condition_set_id => l_condition_set_tbl(j),
8385: p_exception_set_id => l_exception_set_tbl(j),
8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

Line 8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,

8384: p_condition_set_id => l_condition_set_tbl(j),
8385: p_exception_set_id => l_exception_set_tbl(j),
8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

Line 8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,

8385: p_exception_set_id => l_exception_set_tbl(j),
8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

Line 8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

8386: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

Line 8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

8387: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

Line 8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

8388: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

Line 8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

8389: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

Line 8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

8390: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

Line 8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

8391: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

Line 8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

8392: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

Line 8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

8393: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

Line 8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

8394: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

Line 8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

8395: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

Line 8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

8396: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8404: p_cec_result => l_cec_result,

Line 8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

8397: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8404: p_cec_result => l_cec_result,
8405: p_action_rec_tbl => l_action_rec_tbl,

Line 8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

8398: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8404: p_cec_result => l_cec_result,
8405: p_action_rec_tbl => l_action_rec_tbl,
8406: p_return_status => x_return_status,

Line 8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

8399: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8400: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8401: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8402: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8403: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8404: p_cec_result => l_cec_result,
8405: p_action_rec_tbl => l_action_rec_tbl,
8406: p_return_status => x_return_status,
8407: p_error_buffer => l_error_buffer);

Line 8421: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

8417: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
8418: x_return_status := FND_API.G_RET_STS_ERROR;
8419: IF (g_level_error >= g_current_runtime_level ) THEN
8420: FND_LOG.STRING(g_level_error,
8421: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8422: 'Action_code is ERROR_MESSAGE,SYSTEM_ERROR');
8423: END IF;
8424:
8425: app_exception.raise_exception;

Line 8493: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

8489: p_return_status := FND_API.G_RET_STS_ERROR;
8490: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
8491: IF (g_level_error >= g_current_runtime_level ) THEN
8492: FND_LOG.STRING(g_level_error,
8493: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8494: 'Cannot set the tax rate code to '||l_override_tax_rate_code ||
8495: ', ERROR: '||p_error_buffer);
8496: END IF;
8497: IF select_tax_status_rate_code%isopen then

Line 8530: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

8526: 'does not contain number');
8527: FND_MSG_PUB.Add;
8528: IF (g_level_error >= g_current_runtime_level ) THEN
8529: FND_LOG.STRING(g_level_error,
8530: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8531: 'The action value for APPLY_EXCEPTION action code '||
8532: 'does not contain number');
8533: END IF;
8534: app_exception.raise_exception;