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 5775: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5771:
5772: x_return_status := FND_API.G_RET_STS_SUCCESS;
5773: -- get l_reg_party_prof_id
5774: --
5775: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5776: p_structure_name,
5777: p_structure_index,
5778: p_reg_party_type || '_' || 'TAX_PROF_ID',
5779: l_reg_party_prof_id,

Line 5788: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5784: IF (g_level_error >= g_current_runtime_level ) THEN
5785: FND_LOG.STRING(g_level_error,
5786: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5787: 'Incorrect return_status after calling ' ||
5788: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5789: FND_LOG.STRING(g_level_error,
5790: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5791: 'l_reg_party_prof_id = ' || l_reg_party_prof_id);
5792: FND_LOG.STRING(g_level_error,

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

5804: -- establishment will be used. If registration status of third party is required, then the
5805: -- registration at site level will be attemtped to be derived. Failing which, the party level
5806: -- registration will be obtained.
5807:
5808: l_first_party_flag := ZX_TDS_RULE_BASE_DETM_PVT.evaluate_if_first_party(p_reg_party_type);
5809:
5810: IF l_first_party_flag THEN
5811:
5812: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

Line 5812: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5808: l_first_party_flag := ZX_TDS_RULE_BASE_DETM_PVT.evaluate_if_first_party(p_reg_party_type);
5809:
5810: IF l_first_party_flag THEN
5811:
5812: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5813: p_structure_name,
5814: p_structure_index,
5815: 'HQ_ESTB_PARTY_TAX_PROF_ID',
5816: l_hq_estb_ptp_id,

Line 5825: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5821: IF (g_level_error >= g_current_runtime_level ) THEN
5822: FND_LOG.STRING(g_level_error,
5823: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5824: 'Incorrect return_status after calling ' ||
5825: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5826: FND_LOG.STRING(g_level_error,
5827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5828: 'l_hq_estb_ptp_id = ' || l_hq_estb_ptp_id);
5829: FND_LOG.STRING(g_level_error,

Line 5852: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5848: SUBSTR(p_reg_party_type, 1, 9) IN ('SHIP_FROM','BILL_FROM')
5849: THEN
5850: -- get l_account_site_id
5851: --
5852: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5853: p_structure_name,
5854: p_structure_index,
5855: SUBSTR(p_reg_party_type,1,5) || 'THIRD_PTY_ACCT_SITE_ID',
5856: l_account_site_id,

Line 5865: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5861: IF (g_level_error >= g_current_runtime_level ) THEN
5862: FND_LOG.STRING(g_level_error,
5863: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5864: 'Incorrect return_status after calling ' ||
5865: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5866: FND_LOG.STRING(g_level_error,
5867: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5868: 'l_account_site_id = ' || l_account_site_id);
5869: FND_LOG.STRING(g_level_error,

Line 5881: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5877: END IF;
5878:
5879: -- get l_account_id
5880: --
5881: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5882: p_structure_name,
5883: p_structure_index,
5884: SUBSTR(p_reg_party_type,1,5) || 'THIRD_PTY_ACCT_ID',
5885: l_account_id,

Line 5894: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5890: IF (g_level_error >= g_current_runtime_level ) THEN
5891: FND_LOG.STRING(g_level_error,
5892: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5893: 'Incorrect return_status after calling ' ||
5894: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5895: FND_LOG.STRING(g_level_error,
5896: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5897: 'l_account_id = ' || l_account_id);
5898: FND_LOG.STRING(g_level_error,

Line 5913: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5909: -- get l_site_use_id
5910: --
5911: IF SUBSTR(p_reg_party_type, 1, 7) IN ('SHIP_TO', 'BILL_TO') THEN
5912:
5913: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5914: p_structure_name,
5915: p_structure_index,
5916: SUBSTR(p_reg_party_type, 1,7) || '_' || 'CUST_ACCT_SITE_USE_ID',
5917: l_site_use_id,

Line 5928: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5924: IF (g_level_error >= g_current_runtime_level ) THEN
5925: FND_LOG.STRING(g_level_error,
5926: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5927: 'Incorrect return_status after calling ' ||
5928: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5929: FND_LOG.STRING(g_level_error,
5930: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5931: 'l_site_use_id = ' || l_site_use_id);
5932: FND_LOG.STRING(g_level_error,

Line 5952: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

5948: -- Alway pass l_parent_ptp_id and l_site_ptp_id
5949: --
5950: l_parent_ptp_id := l_reg_party_prof_id;
5951:
5952: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
5953: p_structure_name,
5954: p_structure_index,
5955: REPLACE(p_reg_party_type, 'PARTY', 'SITE') || '_' || 'TAX_PROF_ID',
5956: l_site_ptp_id,

Line 5965: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');

5961: IF (g_level_error >= g_current_runtime_level ) THEN
5962: FND_LOG.STRING(g_level_error,
5963: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5964: 'Incorrect return_status after calling ' ||
5965: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5966: FND_LOG.STRING(g_level_error,
5967: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5968: 'l_site_ptp_id = ' || l_site_ptp_id);
5969: FND_LOG.STRING(g_level_error,

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

6073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6074:
6075: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6076: FND_LOG.STRING(g_level_unexpected,
6077: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_registration_info',
6078: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6079: END IF;
6080:
6081: END get_tax_registration_info;

Line 6475: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

6471: -- bug 4633146
6472: --
6473: IF p_event_class_rec.prod_family_grp_code = 'P2P' THEN
6474:
6475: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
6476: 'TRX_LINE_DIST_TBL',
6477: p_trx_line_index,
6478: 'SHIP_TO_PARTY_TAX_PROF_ID',
6479: l_party_ptp_id,

Line 6485: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(

6481: x_error_buffer);
6482:
6483: ELSIF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
6484:
6485: ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value(
6486: 'TRX_LINE_DIST_TBL',
6487: p_trx_line_index,
6488: 'SHIP_FROM_PARTY_TAX_PROF_ID',
6489: l_party_ptp_id,

Line 6594: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(

6590: END IF;
6591:
6592: x_return_status := FND_API.G_RET_STS_SUCCESS;
6593:
6594: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(
6595: p_tax_service_type_code,
6596: 'TRX_LINE_DIST_TBL',
6597: p_trx_line_index,
6598: p_event_class_rec,

Line 6613: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');

6609: IF (g_level_statement >= g_current_runtime_level ) THEN
6610: FND_LOG.STRING(g_level_statement,
6611: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm',
6612: 'Incorrect return_status after calling ' ||
6613: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');
6614: END IF;
6615:
6616: x_alphanumeric_result := NULL;
6617: x_result_id := NULL;

Line 8906: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (

8902:
8903: -- The following procedure is currently PRIVATE inside rule engine.
8904: -- It has to be made public to be called as below
8905:
8906: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (
8907: p_structure_name => 'TRX_LINE_DIST_TBL',
8908: p_structure_index => p_trx_line_index,
8909: p_return_status => x_return_status,
8910: p_error_buffer => l_error_buffer);

Line 8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,

8910: p_error_buffer => l_error_buffer);
8911:
8912: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8913: p_constraint_id => l_constraint_id,
8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

Line 8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,

8911:
8912: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8913: p_constraint_id => l_constraint_id,
8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

Line 8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,

8912: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
8913: p_constraint_id => l_constraint_id,
8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

Line 8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,

8913: p_constraint_id => l_constraint_id,
8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

Line 8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

8914: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

Line 8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

8915: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

Line 8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

8916: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

Line 8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

8917: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

Line 8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

8918: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

Line 8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

8919: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

Line 8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

8920: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

Line 8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

8921: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

Line 8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

8922: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

Line 8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

8923: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

Line 8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

8924: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8932: p_cec_result => l_cec_result,

Line 8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

8925: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8932: p_cec_result => l_cec_result,
8933: p_action_rec_tbl => l_action_rec_tbl,

Line 8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

8926: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8932: p_cec_result => l_cec_result,
8933: p_action_rec_tbl => l_action_rec_tbl,
8934: p_return_status => x_return_status,

Line 8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

8927: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
8928: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
8929: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
8930: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
8931: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
8932: p_cec_result => l_cec_result,
8933: p_action_rec_tbl => l_action_rec_tbl,
8934: p_return_status => x_return_status,
8935: p_error_buffer => l_error_buffer);

Line 9040: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (

9036: l_exception_rate := NULL; -- bugfix 6906653
9037:
9038: IF l_constraint_id is NULL then
9039: -- The initialization would have occurred earlier if the constraint_id was NOT NULL
9040: ZX_TDS_RULE_BASE_DETM_PVT.init_cec_params (
9041: p_structure_name => 'TRX_LINE_DIST_TBL',
9042: p_structure_index => p_trx_line_index,
9043: p_return_status => x_return_status,
9044: p_error_buffer => l_error_buffer);

Line 9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,

9046:
9047: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
9048: p_condition_set_id => l_condition_set_tbl(j),
9049: p_exception_set_id => l_exception_set_tbl(j),
9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

Line 9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,

9047: ZX_TDS_PROCESS_CEC_PVT.evaluate_cec(
9048: p_condition_set_id => l_condition_set_tbl(j),
9049: p_exception_set_id => l_exception_set_tbl(j),
9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

Line 9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,

9048: p_condition_set_id => l_condition_set_tbl(j),
9049: p_exception_set_id => l_exception_set_tbl(j),
9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

Line 9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,

9049: p_exception_set_id => l_exception_set_tbl(j),
9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

Line 9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,

9050: p_cec_ship_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_site_id,
9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

Line 9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,

9051: p_cec_bill_to_party_site_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_site_id,
9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

Line 9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,

9052: p_cec_ship_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_party_id,
9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

Line 9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,

9053: p_cec_bill_to_party_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_party_id,
9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

Line 9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,

9054: p_cec_poo_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poo_location_id,
9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

Line 9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,

9055: p_cec_poa_location_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_poa_location_id,
9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

Line 9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,

9056: p_cec_trx_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_id,
9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

Line 9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,

9057: p_cec_trx_line_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_id,
9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

Line 9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,

9058: p_cec_ledger_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ledger_id,
9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

Line 9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,

9059: p_cec_internal_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_internal_organization_id,
9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

Line 9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,

9060: p_cec_so_organization_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_so_organization_id,
9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
9068: p_cec_result => l_cec_result,

Line 9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,

9061: p_cec_product_org_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_org_id,
9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
9068: p_cec_result => l_cec_result,
9069: p_action_rec_tbl => l_action_rec_tbl,

Line 9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,

9062: p_cec_product_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_product_id,
9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
9068: p_cec_result => l_cec_result,
9069: p_action_rec_tbl => l_action_rec_tbl,
9070: p_return_status => x_return_status,

Line 9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,

9063: p_cec_trx_line_date => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_line_date,
9064: p_cec_trx_type_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_trx_type_id,
9065: p_cec_fob_point => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_fob_point,
9066: p_cec_ship_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_ship_to_site_use_id,
9067: p_cec_bill_to_site_use_id => ZX_TDS_RULE_BASE_DETM_PVT.g_cec_bill_to_site_use_id,
9068: p_cec_result => l_cec_result,
9069: p_action_rec_tbl => l_action_rec_tbl,
9070: p_return_status => x_return_status,
9071: p_error_buffer => l_error_buffer);

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

9081: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
9082: x_return_status := FND_API.G_RET_STS_ERROR;
9083: IF (g_level_error >= g_current_runtime_level ) THEN
9084: FND_LOG.STRING(g_level_error,
9085: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
9086: 'Action_code is ERROR_MESSAGE,SYSTEM_ERROR');
9087: END IF;
9088:
9089: app_exception.raise_exception;

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

9153: p_return_status := FND_API.G_RET_STS_ERROR;
9154: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
9155: IF (g_level_error >= g_current_runtime_level ) THEN
9156: FND_LOG.STRING(g_level_error,
9157: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
9158: 'Cannot set the tax rate code to '||l_override_tax_rate_code ||
9159: ', ERROR: '||p_error_buffer);
9160: END IF;
9161: IF select_tax_status_rate_code%isopen then

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

9190: 'does not contain number');
9191: FND_MSG_PUB.Add;
9192: IF (g_level_error >= g_current_runtime_level ) THEN
9193: FND_LOG.STRING(g_level_error,
9194: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
9195: 'The action value for APPLY_EXCEPTION action code '||
9196: 'does not contain number');
9197: END IF;
9198: app_exception.raise_exception;