1: PACKAGE BODY JL_ZZ_TAX_INTEGRATION_PKG AS
2: /* $Header: jlzztinb.pls 120.19.12010000.2 2008/08/04 12:53:16 vgadde ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
69: l_org_id := to_number(fnd_profile.value('ORG_ID'));
70:
71: END IF;
72: IF (g_level_statement >= g_current_runtime_level ) THEN
73: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()+');
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
70:
71: END IF;
72: IF (g_level_statement >= g_current_runtime_level ) THEN
73: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()+');
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
71: END IF;
72: IF (g_level_statement >= g_current_runtime_level ) THEN
73: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()+');
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
72: IF (g_level_statement >= g_current_runtime_level ) THEN
73: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()+');
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
73: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()+');
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
74: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Exchange Rate : ' || to_char(p_conversion_rate));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
75: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Currency Code : ' || p_currency_code);
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
76: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- FOB Point Code : ' || p_fob_point_code);
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
77: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute5 : ' || p_global_attribute5);
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
78: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Line Id : ' || to_char(p_line_id));
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
79: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Header Id : ' || to_char(p_header_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
80: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Inventory Item Id : ' || to_char(p_inventory_item_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
81: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoice to Org Id : ' || to_char(p_invoice_to_org_id));
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
82: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Invoicing Rule Id : ' || to_char(p_invoicing_rule_id));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
83: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Transaction Type Id : ' || to_char(p_line_type_id));
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
84: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Pricing Quantity : ' || to_char(p_pricing_quantity));
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
85: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Payment Term Id : ' || to_char(p_payment_term_id));
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
86: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Global Attribute6 : ' || p_global_attribute6);
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
94: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Unit Selling Price : ' || to_char(p_unit_selling_price));
87: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship From Org Id : ' || to_char(p_ship_from_org_id));
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
94: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Unit Selling Price : ' || to_char(p_unit_selling_price));
95: END IF;
88: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Ship To Org Id : ' || to_char(p_ship_to_org_id));
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
94: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Unit Selling Price : ' || to_char(p_unit_selling_price));
95: END IF;
96:
89: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Code : ' || p_tax_code);
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
94: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Unit Selling Price : ' || to_char(p_unit_selling_price));
95: END IF;
96:
97: -- Validate Required Parameter
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Date : ' || to_char(p_tax_date,'DD-MON-YYYY'));
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Flag : ' || p_tax_exempt_flag);
92: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Number : ' || p_tax_exempt_number);
93: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Tax Exempt Reason : ' || p_tax_exempt_reason);
94: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-P- Unit Selling Price : ' || to_char(p_unit_selling_price));
95: END IF;
96:
97: -- Validate Required Parameter
98: IF p_line_type_id IS NULL THEN
129: 'Required Parameter Missing: Transaction Condition Class');
130: app_exception.raise_exception;
131: END IF;
132: IF (g_level_statement >= g_current_runtime_level ) THEN
133: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute5 : ' || l_global_attribute5);
134: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute6 : ' || l_global_attribute6);
135: END IF;
136:
137: END IF;
130: app_exception.raise_exception;
131: END IF;
132: IF (g_level_statement >= g_current_runtime_level ) THEN
133: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute5 : ' || l_global_attribute5);
134: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute6 : ' || l_global_attribute6);
135: END IF;
136:
137: END IF;
138: */
213: END;
214:
215: IF (NVL(l_tax_calculation_flag,'N') <> 'Y') THEN
216: IF (g_level_statement >= g_current_runtime_level ) THEN
217: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Calculation Flag is not checked');
218: END IF;
219: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
220: IF (g_level_statement >= g_current_runtime_level ) THEN
221: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
217: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Calculation Flag is not checked');
218: END IF;
219: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
220: IF (g_level_statement >= g_current_runtime_level ) THEN
221: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
222: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
223: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
224: END IF;
225: return;
218: END IF;
219: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
220: IF (g_level_statement >= g_current_runtime_level ) THEN
221: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
222: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
223: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
224: END IF;
225: return;
226: END IF;
219: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
220: IF (g_level_statement >= g_current_runtime_level ) THEN
221: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
222: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
223: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
224: END IF;
225: return;
226: END IF;
227: END IF;
452: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6 := to_number(to_char(p_tax_date, 'YYYYMMDD'));
453: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 := 7;
454:
455: IF (g_level_statement >= g_current_runtime_level ) THEN
456: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Category Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
457: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
458: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
459: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
453: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 := 7;
454:
455: IF (g_level_statement >= g_current_runtime_level ) THEN
456: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Category Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
457: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
458: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
459: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
461: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
454:
455: IF (g_level_statement >= g_current_runtime_level ) THEN
456: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Category Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
457: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
458: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
459: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
461: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
462: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
456: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Category Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
457: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id : ' || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
458: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
459: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
461: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
462: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
463: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
458: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
459: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
461: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
462: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
463: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
461: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
462: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
463: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
462: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
463: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
463: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
464: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
465: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
466: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
474: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
467: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
474: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
475: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
469: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
474: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
475: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
476: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
471: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
472: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
474: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
475: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
476: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
478: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
473: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
474: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
475: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
476: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
478: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
480: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
475: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
476: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
478: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
480: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
478: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
480: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
484: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
480: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
484: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
486: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
484: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
486: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
488: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
484: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
486: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
488: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
486: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
488: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
492: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
488: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
492: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
494: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
492: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
494: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
496: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
492: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
494: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
496: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
494: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
496: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
500: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
496: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
500: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
502: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
500: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
502: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
500: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
502: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
502: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
508: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
508: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
510: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
511:
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
508: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
510: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
511:
512: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()-');
513: END IF;
508: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
510: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
511:
512: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()-');
513: END IF;
514:
515: END populate_om_ar_tax_struct;
516:
563:
564: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
565:
566: IF (g_level_statement >= g_current_runtime_level ) THEN
567: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()+');
568: END IF;
569:
570: IF p_bill_to_site_use_id IS NULL THEN
571: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
629: END LOOP;
630: END IF;
631:
632: IF (g_level_statement >= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
634: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
635: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
636: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
637: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
630: END IF;
631:
632: IF (g_level_statement >= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
634: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
635: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
636: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
637: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
638: END IF;
631:
632: IF (g_level_statement >= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
634: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
635: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
636: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
637: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
638: END IF;
639:
633: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
634: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
635: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
636: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
637: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
638: END IF;
639:
640: END populate_ship_bill2;
641:
918: l_org_id := p_org_id;
919: END IF;
920:
921: IF (g_level_statement >= g_current_runtime_level ) THEN
922: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
923:
924: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
925: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
926: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
920:
921: IF (g_level_statement >= g_current_runtime_level ) THEN
922: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
923:
924: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
925: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
926: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
927: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
928: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
922: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
923:
924: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
925: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
926: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
927: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
928: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
929: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
930: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
924: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
925: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
926: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
927: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
928: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
929: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
930: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
931: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
932: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
926: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
927: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
928: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
929: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
930: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
931: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
932: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
933: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
928: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
929: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
930: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
931: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
932: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
933: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
935: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
930: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
931: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
932: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
933: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
935: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
932: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
933: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
935: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
935: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
949: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
958: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
951: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
958: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
953: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
958: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
960: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
955: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
956: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
958: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
960: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
962: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
957: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
958: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
960: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
962: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
964: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
960: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
962: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
964: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
966: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
962: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
964: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
966: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
968: to_char(l_org_id));
969: END IF;
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
964: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
966: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
968: to_char(l_org_id));
969: END IF;
970:
971: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl.delete;
990: -- Validate memo_line_id to AR_MEMO_LINES
991: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id IS NOT NULL and nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) <> 1 THEN
992: BEGIN
993: IF (g_level_statement >= g_current_runtime_level ) THEN
994: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Memo_lineId: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id||
995: ' org_id: '||l_org_id);
996: END IF;
997: SELECT ml.line_type
998: INTO l_line_type
1034: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2 :=
1035: SUBSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
1036: INSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,l_delimiter_prod_cat, -1) +1 );
1037: IF (g_level_statement >= g_current_runtime_level ) THEN
1038: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','
1039: -- Product Category after delimiter '|| ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
1040: END IF;
1041: END IF;
1042:
1053: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 :=
1054: SUBSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
1055: INSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9, l_delimiter, -1) +1 );
1056: IF (g_level_statement >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- trx_business_category: '||
1058: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1059: END IF;
1060: END IF;
1061:
1121:
1122: -- Check if Override Customer Site Profile is set to 'Y'
1123: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1124: IF (g_level_statement >= g_current_runtime_level ) THEN
1125: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1126: END IF;
1127:
1128: -- Fetch Tax Group details
1129: FOR c_grp_code_cus_rec IN c_grp_code_cus
1133: c_grp_code_cus_rec.calculate_in_oe = 'Y') OR
1134: (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 <> 7) THEN
1135: IF (g_level_statement >= g_current_runtime_level ) THEN
1136:
1137: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Fetching Tax Code for Tax Category: '
1138: || c_grp_code_cus_rec.tax_category);
1139: END IF;
1140:
1141: l_index := l_index + 1;
1144:
1145: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_line_number := l_index;
1146:
1147: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code :=
1148: JL_ZZ_TAX.GET_CATEGORY_TAX_CODE (
1149: c_grp_code_cus_rec.numeric_attribute1,
1150: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID,
1151: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID,
1152: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID,
1170: c_grp_code_cus_rec.attribute8,
1171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
1172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1173: IF (g_level_statement >= g_current_runtime_level ) THEN
1174: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Code: '
1175: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1176: END IF;
1177:
1178: FOR c_vat_tax_rec IN c_vat_tax(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code)
1201: exit;
1202: End Loop;
1203:
1204: IF (g_level_statement >= g_current_runtime_level ) THEN
1205: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type: '
1206: ||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf7);
1207: END IF;
1208:
1209: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1207: END IF;
1208:
1209: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1210: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 :=
1211: JL_ZZ_TAX.GET_TAX_BASE_RATE (
1212: c_grp_code_cus_rec.numeric_attribute1,
1213: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID,
1214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID,
1215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID,
1233: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1234: END IF;
1235:
1236: IF (g_level_statement >= g_current_runtime_level ) THEN
1237: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Base Rate: '
1238: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3));
1239: END IF;
1240:
1241: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf3 :=
1252:
1253: ELSIF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 = 7 AND
1254: nvl(c_grp_code_cus_rec.calculate_in_oe,'N') <> 'Y') THEN
1255: IF (g_level_statement >= g_current_runtime_level ) THEN
1256: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Calculate In OM is not checked for '
1257: || 'Tax Category '
1258: || c_grp_code_cus_rec.tax_category
1259: || ' With Tax Category Id '
1260: || to_char(c_grp_code_cus_rec.numeric_attribute1));
1263: END LOOP;
1264: ELSE
1265: -- Override of Customer Site Profile is NOT set to 'Y'
1266: IF (g_level_statement >= g_current_runtime_level ) THEN
1267: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1268: END IF;
1269: -- Fetch Tax Group details
1270: FOR c_grp_code_att_rec IN c_grp_code_att
1271: LOOP
1273: c_grp_code_att_rec.calculate_in_oe = 'Y') OR
1274: (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 <> 7) THEN
1275:
1276: IF (g_level_statement >= g_current_runtime_level ) THEN
1277: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Fetching Tax Code for Tax Category: '
1278: || c_grp_code_att_rec.tax_category);
1279: END IF;
1280:
1281: l_index := l_index + 1;
1284:
1285: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_line_number := l_index;
1286:
1287: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code :=
1288: JL_ZZ_TAX.GET_CATEGORY_TAX_CODE (
1289: c_grp_code_att_rec.numeric_attribute1,
1290: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID,
1291: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID,
1292: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID,
1310: c_grp_code_att_rec.attribute8,
1311: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
1312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1313: IF (g_level_statement >= g_current_runtime_level ) THEN
1314: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Code: '
1315: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1316: END IF;
1317:
1318: FOR c_vat_tax_rec IN c_vat_tax(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code)
1330: exit;
1331:
1332: End Loop;
1333: IF (g_level_statement >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type: '
1335: ||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf7);
1336: END IF;
1337: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 :=
1335: ||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf7);
1336: END IF;
1337: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 :=
1339: JL_ZZ_TAX.GET_TAX_BASE_RATE (
1340: c_grp_code_att_rec.numeric_attribute1,
1341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID,
1342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID,
1343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID,
1361: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1362: END IF;
1363:
1364: IF (g_level_statement >= g_current_runtime_level ) THEN
1365: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Base Rate: '
1366: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3));
1367: END IF;
1368:
1369: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf3 :=
1380:
1381: ELSIF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 = 7 AND
1382: nvl(c_grp_code_att_rec.calculate_in_oe,'N') <> 'Y') THEN
1383: IF (g_level_statement >= g_current_runtime_level ) THEN
1384: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Calculate In OM is not checked for '
1385: || 'Tax Category '
1386: || c_grp_code_att_rec.tax_category
1387: || ' With Tax Category Id '
1388: || to_char(c_grp_code_att_rec.numeric_attribute1));
1391: END LOOP;
1392: END IF;
1393:
1394: IF (g_level_statement >= g_current_runtime_level ) THEN
1395: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Number of Tax Lines for this transaction line: '||
1396: to_char(l_index));
1397: END IF;
1398:
1399: IF l_index = 0 THEN
1400:
1401: -- Could not expand tax group successfully
1402: -- Log reasons for unsuccessful group expansion
1403: IF (g_level_statement >= g_current_runtime_level ) THEN
1404: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','***Reason(s) for Unsuccessful group expansion***');
1405: END IF;
1406:
1407: DECLARE
1408: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1439: LOOP
1440:
1441: -- Display Tax Group
1442: IF (g_level_statement >= g_current_runtime_level ) THEN
1443: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Group : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1444: END IF;
1445: -- Match with Attribute Value of Transaction Class Type
1446: BEGIN
1447: SELECT TTA.TAX_ATTRIBUTE_VALUE
1459:
1460: EXCEPTION
1461: WHEN NO_DATA_FOUND THEN
1462: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1463: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Transaction Condition Class =>'
1464: || ' Condition Name: '
1465: || c_tax_categ_rec.txn_tax_attribute
1466: || ' and Value: '
1467: || c_tax_categ_rec.transaction_nature
1488: app_exception.raise_exception;
1489:
1490: WHEN OTHERS THEN
1491: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1492: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '
1493: || 'Transaction Condition Class');
1494: END IF;
1495: END;
1496:
1510:
1511: EXCEPTION
1512: WHEN NO_DATA_FOUND THEN
1513: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1514: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Organization Condition Class =>'
1515: || ' Condition Name: '
1516: || c_tax_categ_rec.org_tax_attribute
1517: || ' and Value: '
1518: || c_tax_categ_rec.establishment_type
1538: app_exception.raise_exception;
1539:
1540: WHEN OTHERS THEN
1541: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '
1543: || 'Organization Condition Class');
1544: END IF;
1545: END;
1546:
1573:
1574: EXCEPTION
1575: WHEN NO_DATA_FOUND THEN
1576: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1577: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Contributor Type =>'
1578: || ' Condition Name: '
1579: || c_tax_categ_rec.cus_tax_attribute
1580: || ' and Value: '
1581: || c_tax_categ_rec.contributor_type
1601: app_exception.raise_exception;
1602:
1603: WHEN OTHERS THEN
1604: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1605: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): ' || 'Contributor Type');
1606: END IF;
1607: END;
1608:
1609: END LOOP;
1609: END LOOP;
1610:
1611: END;
1612: IF (g_level_statement >= g_current_runtime_level ) THEN
1613: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1614: END IF;
1615: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1616: fnd_message.set_token('GENERIC_TEXT',
1617: 'Could not expand tax group successfully');
1624:
1625: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
1626: IF (g_level_statement >= g_current_runtime_level ) THEN
1627: FND_LOG.STRING(g_level_statement,
1628: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1629: 'Credit Memo and not Tax Group');
1630: FND_LOG.STRING(g_level_statement,
1631: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1632: 'Previous Trx Line ID : ' ||
1627: FND_LOG.STRING(g_level_statement,
1628: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1629: 'Credit Memo and not Tax Group');
1630: FND_LOG.STRING(g_level_statement,
1631: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1632: 'Previous Trx Line ID : ' ||
1633: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id));
1634: FND_LOG.STRING(g_level_statement,
1635: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1631: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1632: 'Previous Trx Line ID : ' ||
1633: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id));
1634: FND_LOG.STRING(g_level_statement,
1635: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1636: 'Tax Category ID: ' ||
1637: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
1638: END IF;
1639:
1658: WHEN NO_DATA_FOUND THEN
1659: l_group_tax_id := NULL;
1660: IF (g_level_statement >= g_current_runtime_level ) THEN
1661: FND_LOG.STRING(g_level_statement,
1662: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1663: 'No tax group id found');
1664: END IF;
1665: END;
1666:
1667: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 := l_group_tax_id;
1668:
1669: IF (g_level_statement >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_statement,
1671: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1672: 'Tax Group ID: ' ||
1673: TO_CHAR(l_group_tax_id));
1674: END IF;
1675:
1684: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1685:
1686: IF (g_level_statement >= g_current_runtime_level ) THEN
1687: FND_LOG.STRING(g_level_statement,
1688: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1689: 'Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1690: END IF;
1691:
1692: OPEN c_grp_code_cus_cm;
1707: ELSE
1708: -- Override of Customer Site Profile is NOT set to 'Y'
1709: IF (g_level_statement >= g_current_runtime_level ) THEN
1710: FND_LOG.STRING(g_level_statement,
1711: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1712: 'Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1713: END IF;
1714:
1715: OPEN c_grp_code_att_cm;
1731: END IF; -- check Customer Site Profile
1732:
1733: IF (g_level_statement >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_statement,
1735: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1736: 'Transaction Nature: ' || l_transaction_nature);
1737: FND_LOG.STRING(g_level_statement,
1738: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1739: 'Establishment Type: '|| l_establishment_type);
1734: FND_LOG.STRING(g_level_statement,
1735: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1736: 'Transaction Nature: ' || l_transaction_nature);
1737: FND_LOG.STRING(g_level_statement,
1738: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1739: 'Establishment Type: '|| l_establishment_type);
1740: FND_LOG.STRING(g_level_statement,
1741: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1742: 'Contributor Type: '|| l_contributor_type);
1737: FND_LOG.STRING(g_level_statement,
1738: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1739: 'Establishment Type: '|| l_establishment_type);
1740: FND_LOG.STRING(g_level_statement,
1741: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1742: 'Contributor Type: '|| l_contributor_type);
1743: END IF;
1744:
1745: END IF; -- credit_memo_flag = TRUE
1747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(1) := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec;
1748: END IF;
1749:
1750: IF (g_level_statement >= g_current_runtime_level ) THEN
1751: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()-');
1752: END IF;
1753:
1754: END expand_group_tax_code;
1755:
1752: END IF;
1753:
1754: END expand_group_tax_code;
1755:
1756: END JL_ZZ_TAX_INTEGRATION_PKG;