1: PACKAGE BODY JL_ZZ_TAX_INTEGRATION_PKG AS
2: /* $Header: jlzztinb.pls 120.19.12010000.5 2009/08/04 23:06:42 skorrapa ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
2: /* $Header: jlzztinb.pls 120.19.12010000.5 2009/08/04 23:06:42 skorrapa ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10:
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10:
11:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10:
11:
12: -- Bugfix# 3259701
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10:
11:
12: -- Bugfix# 3259701
13:
62: l_org_id NUMBER;
63:
64: BEGIN
65:
66: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
67:
68: IF p_org_id IS NULL THEN
69: l_org_id := to_number(fnd_profile.value('ORG_ID'));
70:
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
130: 'Required Parameter Missing: Transaction Condition Class');
131: app_exception.raise_exception;
132: END IF;
133: IF (g_level_statement >= g_current_runtime_level ) THEN
134: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute5 : ' || l_global_attribute5);
135: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute6 : ' || l_global_attribute6);
136: END IF;
137:
138: END IF;
131: app_exception.raise_exception;
132: END IF;
133: IF (g_level_statement >= g_current_runtime_level ) THEN
134: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute5 : ' || l_global_attribute5);
135: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute6 : ' || l_global_attribute6);
136: END IF;
137:
138: END IF;
139: */
216: END;
217:
218: IF (NVL(l_tax_calculation_flag,'N') <> 'Y') THEN
219: IF (g_level_statement >= g_current_runtime_level ) THEN
220: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Calculation Flag is not checked');
221: END IF;
222: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
223: IF (g_level_statement >= g_current_runtime_level ) THEN
224: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
220: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Calculation Flag is not checked');
221: END IF;
222: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
223: IF (g_level_statement >= g_current_runtime_level ) THEN
224: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
225: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
226: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
227: END IF;
228: return;
221: END IF;
222: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
223: IF (g_level_statement >= g_current_runtime_level ) THEN
224: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
225: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
226: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
227: END IF;
228: return;
229: END IF;
222: IF (NVL(p_tax_exempt_flag,'S') <> 'R') THEN
223: IF (g_level_statement >= g_current_runtime_level ) THEN
224: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Exempt Flag is ' || p_tax_exempt_flag);
225: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','VALUES ARE NOT POPULATED');
226: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','populate_om_ar_tax_struct ()-');
227: END IF;
228: return;
229: END IF;
230: END IF;
462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6 := to_number(to_char(p_tax_date, 'YYYYMMDD'));
463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 := 7;
464:
465: IF (g_level_statement >= g_current_runtime_level ) THEN
466: 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));
467: 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));
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
469: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 := 7;
464:
465: IF (g_level_statement >= g_current_runtime_level ) THEN
466: 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));
467: 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));
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
469: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
471: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
464:
465: IF (g_level_statement >= g_current_runtime_level ) THEN
466: 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));
467: 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));
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
469: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
471: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
472: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
466: 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));
467: 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));
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
469: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
471: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
472: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
473: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
468: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Id : '
469: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
471: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
472: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
473: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
470: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Account Site Id : '
471: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
472: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
473: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
472: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Structure Id : '
473: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
473: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
474: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Location Segment Number : '
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
475: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
476: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rule Set : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
484: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
477: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Contributor Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
478: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
484: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
479: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Organization Class : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
480: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Taxable Basis : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis);
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
484: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
486: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
481: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Calculation PL/SQL Block : '
482: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block);
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
484: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
486: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
488: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
483: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Amount Includes Tax Flag : '
484: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
486: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
488: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
485: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Customer Trx Type Id : '
486: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id));
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
488: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
492: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
487: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Id : '
488: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id));
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
492: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
494: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
489: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Site Use Id : '
490: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id));
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
492: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
494: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
496: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
491: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Postal Code : '
492: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_postal_code);
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
494: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
496: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
493: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Location Id : '
494: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_location_id));
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
496: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
500: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
495: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Number : '
496: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_number);
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
500: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
502: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
497: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer Name : '
498: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_customer_name);
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
500: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
502: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
499: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Id : '
500: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id));
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
502: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
501: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Site Use Id : '
502: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id));
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
508: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
503: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Postal Code : '
504: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_postal_code);
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
508: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
510: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
511: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
505: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Location Id : '
506: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_location_id));
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
508: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
510: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
511: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
512: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
513: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
507: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Number : '
508: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_number);
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
510: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
511: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
512: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
513: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
515: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
509: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer Name : '
510: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_customer_name);
511: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
512: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
513: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
515: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
516: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
517: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
511: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Header Level Flag : '
512: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_header_level_flag);
513: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
515: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
516: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
517: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
518: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
519: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
513: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Rounding Rule : '
514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
515: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
516: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
517: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
518: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
519: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
520: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
521:
515: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Minimum Accountable Unit : '
516: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit));
517: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Precision : '
518: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
519: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
520: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
521:
522: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()-');
523: END IF;
518: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision));
519: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount : '
520: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.extended_amount));
521:
522: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_om_ar_tax_struct ()-');
523: END IF;
524:
525: END populate_om_ar_tax_struct;
526:
570:
571:
572: BEGIN
573:
574: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
575:
576: IF (g_level_statement >= g_current_runtime_level ) THEN
577: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()+');
578: END IF;
573:
574: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
575:
576: IF (g_level_statement >= g_current_runtime_level ) THEN
577: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()+');
578: END IF;
579:
580: IF p_bill_to_site_use_id IS NULL THEN
581: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
641: END LOOP;
642: END IF;
643:
644: IF (g_level_statement >= g_current_runtime_level ) THEN
645: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
646: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
647: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
648: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
649: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
642: END IF;
643:
644: IF (g_level_statement >= g_current_runtime_level ) THEN
645: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
646: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
647: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
648: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
649: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
650: END IF;
643:
644: IF (g_level_statement >= g_current_runtime_level ) THEN
645: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
646: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
647: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
648: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
649: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
650: END IF;
651:
645: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
646: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
647: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
648: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
649: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-');
650: END IF;
651:
652: END populate_ship_bill2;
653:
918:
919: BEGIN
920:
921:
922: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
923:
924: -- bug#6936808: init exception type
925: g_jl_exception_type := 'N';
926:
930: l_org_id := p_org_id;
931: END IF;
932:
933: IF (g_level_statement >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
935:
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
932:
933: IF (g_level_statement >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
935:
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
934: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()+');
935:
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
936: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Transaction Type Id: '||
937: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_TYPE_ID));
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
938: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship to Site use id: '||
939: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_SITE_USE_ID));
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
940: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill to Site use id: '||
941: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_SITE_USE_ID));
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
942: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Inventory Item Id: '||
943: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.INVENTORY_ITEM_ID));
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
949: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Memo Line Id: '||
945: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.MEMO_LINE_ID));
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
949: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
951: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship To Customer id: '||
947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_TO_CUST_ID));
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
949: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
951: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
953: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
948: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Bill To Customer id: '||
949: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.BILL_TO_CUST_ID));
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
951: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
953: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
955: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
956: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
950: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Date: '||
951: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE,'DD-MM-YYYY'));
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
953: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
955: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
956: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
957: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
952: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Ship From Warehouse Id: '||
953: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.SHIP_FROM_WAREHOUSE_ID));
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
955: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
956: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
957: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
954: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Set Of Books Id: '||
955: to_char(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id));
956: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
957: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
956: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Extended Amount: '||
957: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
957: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.EXTENDED_AMOUNT));
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
958: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Vat Tax Id: '||
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
959: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.VAT_TAX_ID));
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
960: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf1: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1);
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
961: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf2: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
962: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf4: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4);
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
970: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
963: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf6: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 );
964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf7: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7);
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
970: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
971: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
965: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf9: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
966: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- userf10 : '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 );
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
970: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
971: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
972: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
973: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern6: '||
967: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern2: '||
968: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2));
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
970: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
971: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
972: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
973: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern6: '||
974: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6));
975: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern7: '||
969: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern3: '||
970: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
971: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
972: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
973: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern6: '||
974: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6));
975: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern7: '||
976: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7));
977: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
971: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern4: '||
972: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4));
973: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern6: '||
974: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6));
975: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern7: '||
976: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7));
977: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
978: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
979: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
973: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern6: '||
974: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6));
975: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern7: '||
976: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7));
977: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
978: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
979: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
980: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
975: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern7: '||
976: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7));
977: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
978: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
979: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
980: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
982: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
983: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
977: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern8: '||
978: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8));
979: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
980: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
982: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
983: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
984: to_char(l_org_id));
985: END IF;
979: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern9: '||
980: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9));
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- usern10: '||
982: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10));
983: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- org_id '||
984: to_char(l_org_id));
985: END IF;
986:
987: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl.delete;
1006: -- Validate memo_line_id to AR_MEMO_LINES
1007: 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
1008: BEGIN
1009: IF (g_level_statement >= g_current_runtime_level ) THEN
1010: 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||
1011: ' org_id: '||l_org_id);
1012: END IF;
1013: SELECT ml.line_type
1014: INTO l_line_type
1053: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2 :=
1054: SUBSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
1055: INSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,l_delimiter_prod_cat, 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','
1058: -- Product Category after delimiter '|| ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2);
1059: END IF;
1060: END IF;
1061:
1072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 :=
1073: SUBSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
1074: INSTR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9, l_delimiter, 1) +1 );
1075: IF (g_level_statement >= g_current_runtime_level ) THEN
1076: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- trx_business_category: '||
1077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1078: END IF;
1079: END IF;
1080:
1148:
1149: -- Check if Override Customer Site Profile is set to 'Y'
1150: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1151: IF (g_level_statement >= g_current_runtime_level ) THEN
1152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1153: END IF;
1154:
1155: -- Fetch Tax Group details
1156: FOR c_grp_code_cus_rec IN c_grp_code_cus
1160: c_grp_code_cus_rec.calculate_in_oe = 'Y') OR
1161: (NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) <> 7) THEN
1162: IF (g_level_statement >= g_current_runtime_level ) THEN
1163:
1164: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Fetching Tax Code for Tax Category: '
1165: || c_grp_code_cus_rec.tax_category);
1166: END IF;
1167:
1168: l_index := l_index + 1;
1197: c_grp_code_cus_rec.attribute8,
1198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
1199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1200: IF (g_level_statement >= g_current_runtime_level ) THEN
1201: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Code: '
1202: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1203: END IF;
1204:
1205: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1236: exit;
1237: End Loop;
1238:
1239: IF (g_level_statement >= g_current_runtime_level ) THEN
1240: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type: '
1241: ||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf7);
1242: END IF;
1243:
1244: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1269: END IF;
1270:
1271: IF (g_level_statement >= g_current_runtime_level ) THEN
1272: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Base Rate: '
1273: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3));
1274: END IF;
1275:
1276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf3 :=
1287:
1288: ELSIF (NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) = 7 AND
1289: nvl(c_grp_code_cus_rec.calculate_in_oe,'N') <> 'Y') THEN
1290: IF (g_level_statement >= g_current_runtime_level ) THEN
1291: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Calculate In OM is not checked for '
1292: || 'Tax Category '
1293: || c_grp_code_cus_rec.tax_category
1294: || ' With Tax Category Id '
1295: || to_char(c_grp_code_cus_rec.numeric_attribute1));
1298: END LOOP;
1299: ELSE
1300: -- Override of Customer Site Profile is NOT set to 'Y'
1301: IF (g_level_statement >= g_current_runtime_level ) THEN
1302: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1303: END IF;
1304: -- Fetch Tax Group details
1305: FOR c_grp_code_att_rec IN c_grp_code_att
1306: LOOP
1308: c_grp_code_att_rec.calculate_in_oe = 'Y') OR
1309: (NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) <> 7) THEN
1310:
1311: IF (g_level_statement >= g_current_runtime_level ) THEN
1312: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Fetching Tax Code for Tax Category: '
1313: || c_grp_code_att_rec.tax_category);
1314: END IF;
1315:
1316: l_index := l_index + 1;
1345: c_grp_code_att_rec.attribute8,
1346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
1347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1348: IF (g_level_statement >= g_current_runtime_level ) THEN
1349: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Code: '
1350: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1351: END IF;
1352:
1353: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1373: exit;
1374:
1375: End Loop;
1376: IF (g_level_statement >= g_current_runtime_level ) THEN
1377: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Tax Type: '
1378: ||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf7);
1379: END IF;
1380: IF (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 is null) then
1381: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3 :=
1404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
1405: END IF;
1406:
1407: IF (g_level_statement >= g_current_runtime_level ) THEN
1408: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Base Rate: '
1409: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).usern3));
1410: END IF;
1411:
1412: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).userf3 :=
1423:
1424: ELSIF (NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7,1) = 7 AND
1425: nvl(c_grp_code_att_rec.calculate_in_oe,'N') <> 'Y') THEN
1426: IF (g_level_statement >= g_current_runtime_level ) THEN
1427: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Calculate In OM is not checked for '
1428: || 'Tax Category '
1429: || c_grp_code_att_rec.tax_category
1430: || ' With Tax Category Id '
1431: || to_char(c_grp_code_att_rec.numeric_attribute1));
1434: END LOOP;
1435: END IF;
1436:
1437: IF (g_level_statement >= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Number of Tax Lines for this transaction line: '||
1439: to_char(l_index));
1440: END IF;
1441:
1442: IF l_index = 0 THEN
1443:
1444: -- Could not expand tax group successfully
1445: -- Log reasons for unsuccessful group expansion
1446: IF (g_level_statement >= g_current_runtime_level ) THEN
1447: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','***Reason(s) for Unsuccessful group expansion***');
1448: END IF;
1449:
1450: DECLARE
1451: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1482: LOOP
1483:
1484: -- Display Tax Group
1485: IF (g_level_statement >= g_current_runtime_level ) THEN
1486: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Tax Group : ' || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1487: END IF;
1488: -- Match with Attribute Value of Transaction Class Type
1489: BEGIN
1490: SELECT TTA.TAX_ATTRIBUTE_VALUE
1502:
1503: EXCEPTION
1504: WHEN NO_DATA_FOUND THEN
1505: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1506: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Transaction Condition Class =>'
1507: || ' Condition Name: '
1508: || c_tax_categ_rec.txn_tax_attribute
1509: || ' and Value: '
1510: || c_tax_categ_rec.transaction_nature
1523: app_exception.raise_exception;
1524:
1525: WHEN OTHERS THEN
1526: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1527: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '
1528: || 'Transaction Condition Class');
1529: END IF;
1530: END;
1531:
1545:
1546: EXCEPTION
1547: WHEN NO_DATA_FOUND THEN
1548: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1549: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Organization Condition Class =>'
1550: || ' Condition Name: '
1551: || c_tax_categ_rec.org_tax_attribute
1552: || ' and Value: '
1553: || c_tax_categ_rec.establishment_type
1565: app_exception.raise_exception;
1566:
1567: WHEN OTHERS THEN
1568: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1569: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '
1570: || 'Organization Condition Class');
1571: END IF;
1572: END;
1573:
1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1604: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Contributor Type =>'
1605: || ' Condition Name: '
1606: || c_tax_categ_rec.cus_tax_attribute
1607: || ' and Value: '
1608: || c_tax_categ_rec.contributor_type
1620: app_exception.raise_exception;
1621:
1622: WHEN OTHERS THEN
1623: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1624: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): ' || 'Contributor Type');
1625: END IF;
1626: END;
1627:
1628: END LOOP;
1628: END LOOP;
1629:
1630: END;
1631: IF (g_level_statement >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1633: END IF;
1634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1635: fnd_message.set_token('GENERIC_TEXT',
1636: 'Could not expand tax group successfully');
1641: -- If Tax Type is not TAX_GROUP
1642: -- bug#5112515
1643: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
1644: IF (g_level_statement >= g_current_runtime_level ) THEN
1645: FND_LOG.STRING(g_level_statement,
1646: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1647: 'Credit Memo and not Tax Group');
1648: FND_LOG.STRING(g_level_statement,
1649: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1644: IF (g_level_statement >= g_current_runtime_level ) THEN
1645: FND_LOG.STRING(g_level_statement,
1646: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1647: 'Credit Memo and not Tax Group');
1648: FND_LOG.STRING(g_level_statement,
1649: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1650: 'Previous Trx Line ID : ' ||
1651: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id));
1652: FND_LOG.STRING(g_level_statement,
1648: FND_LOG.STRING(g_level_statement,
1649: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1650: 'Previous Trx Line ID : ' ||
1651: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id));
1652: FND_LOG.STRING(g_level_statement,
1653: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1654: 'Tax Category ID: ' ||
1655: TO_CHAR(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
1656: END IF;
1675: EXCEPTION
1676: WHEN NO_DATA_FOUND THEN
1677: l_group_tax_id := NULL;
1678: IF (g_level_statement >= g_current_runtime_level ) THEN
1679: FND_LOG.STRING(g_level_statement,
1680: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1681: 'No tax group id found');
1682: END IF;
1683: END;
1684:
1685: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 := l_group_tax_id;
1686:
1687: IF (g_level_statement >= g_current_runtime_level ) THEN
1688: FND_LOG.STRING(g_level_statement,
1689: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1690: 'Tax Group ID: ' ||
1691: TO_CHAR(l_group_tax_id));
1692: END IF;
1701: -- Check if Override Customer Site Profile is set to 'Y'
1702: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1703:
1704: IF (g_level_statement >= g_current_runtime_level ) THEN
1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1707: 'Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1708: END IF;
1709:
1724: END IF;
1725: ELSE
1726: -- Override of Customer Site Profile is NOT set to 'Y'
1727: IF (g_level_statement >= g_current_runtime_level ) THEN
1728: FND_LOG.STRING(g_level_statement,
1729: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1730: 'Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1731: END IF;
1732:
1748:
1749: END IF; -- check Customer Site Profile
1750:
1751: IF (g_level_statement >= g_current_runtime_level ) THEN
1752: FND_LOG.STRING(g_level_statement,
1753: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1754: 'Transaction Nature: ' || l_transaction_nature);
1755: FND_LOG.STRING(g_level_statement,
1756: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1751: IF (g_level_statement >= g_current_runtime_level ) THEN
1752: FND_LOG.STRING(g_level_statement,
1753: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1754: 'Transaction Nature: ' || l_transaction_nature);
1755: FND_LOG.STRING(g_level_statement,
1756: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1757: 'Establishment Type: '|| l_establishment_type);
1758: FND_LOG.STRING(g_level_statement,
1759: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1754: 'Transaction Nature: ' || l_transaction_nature);
1755: FND_LOG.STRING(g_level_statement,
1756: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1757: 'Establishment Type: '|| l_establishment_type);
1758: FND_LOG.STRING(g_level_statement,
1759: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1760: 'Contributor Type: '|| l_contributor_type);
1761: END IF;
1762:
1765: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(1) := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec;
1766: END IF;
1767:
1768: IF (g_level_statement >= g_current_runtime_level ) THEN
1769: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.expand_group_tax_code ()-');
1770: END IF;
1771:
1772: END expand_group_tax_code;
1773: