eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_TAX dependencies on ZX_PRODUCT_INTEGRATION_PKG

Line 1353: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;

1349: IF (g_level_unexpected >= g_current_runtime_level) THEN
1350: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.get_category_tax_rule');
1351: END IF;
1352: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1353: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;
1354:
1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1356: 'LINE';
1357:

Line 1758: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN

1754: l_contributor_type := NULL;
1755:
1756: BEGIN
1757: -- Bugfix 1783986
1758: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1759: select ota.tax_attribute_value,
1760: cta.tax_attribute_value
1761: into l_establishment_type,
1762: l_contributor_type

Line 2744: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

2740: p_exchange_rate IN NUMBER) RETURN NUMBER IS
2741: l_functional_amount NUMBER;
2742: BEGIN
2743:
2744: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2745: p_amount * p_exchange_rate,
2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

2742: BEGIN
2743:
2744: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2745: p_amount * p_exchange_rate,
2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2749: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2750: 'Y');

Line 2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

2743:
2744: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2745: p_amount * p_exchange_rate,
2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2749: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2750: 'Y');
2751:

Line 2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

2744: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2745: p_amount * p_exchange_rate,
2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2749: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2750: 'Y');
2751:
2752: RETURN l_functional_amount;

Line 2749: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

2745: p_amount * p_exchange_rate,
2746: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2747: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2748: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2749: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2750: 'Y');
2751:
2752: RETURN l_functional_amount;
2753:

Line 3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

3018: l_grp_attr_name,
3019: p_trx_date,
3020: nvl(p_ship_to_site_use_id,p_bill_to_site_use_id),
3021: p_organization_class,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
3023: p_transaction_nature_class);
3024:
3025: IF (g_level_statement >= g_current_runtime_level) THEN
3026: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_tax_amount: ' || '-- validate current tax line return status: '||

Line 3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||

3052: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_tax_amount: ' || '-- Total Calculated Tax Amount: '||
3053: to_char(l_tot_calculated_tax_amt));
3054: END IF;
3055: IF (g_level_statement >= g_current_runtime_level) THEN
3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||

Line 3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);

3053: to_char(l_tot_calculated_tax_amt));
3054: END IF;
3055: IF (g_level_statement >= g_current_runtime_level) THEN
3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);

Line 3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||

3054: END IF;
3055: IF (g_level_statement >= g_current_runtime_level) THEN
3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||

Line 3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);

3055: IF (g_level_statement >= g_current_runtime_level) THEN
3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);

Line 3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||

3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3064: END IF;

Line 3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);

3057: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3064: END IF;
3065:

Line 3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||

3058: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3064: END IF;
3065:
3066: IF p_taxable_basis = 'QUANTITY' THEN

Line 3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);

3059: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3060: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3061: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3062: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3064: END IF;
3065:
3066: IF p_taxable_basis = 'QUANTITY' THEN
3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

Line 3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3063: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3064: END IF;
3065:
3066: IF p_taxable_basis = 'QUANTITY' THEN
3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3068: p_base_amount * p_tax_rate,
3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3065:
3066: IF p_taxable_basis = 'QUANTITY' THEN
3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3068: p_base_amount * p_tax_rate,
3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3073: 'Y');

Line 3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3066: IF p_taxable_basis = 'QUANTITY' THEN
3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3068: p_base_amount * p_tax_rate,
3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3073: 'Y');
3074: ELSE

Line 3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3067: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3068: p_base_amount * p_tax_rate,
3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3073: 'Y');
3074: ELSE
3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

Line 3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3068: p_base_amount * p_tax_rate,
3069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3073: 'Y');
3074: ELSE
3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3076: p_base_amount * (p_tax_rate / 100),

Line 3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3073: 'Y');
3074: ELSE
3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3076: p_base_amount * (p_tax_rate / 100),
3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3073: 'Y');
3074: ELSE
3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3076: p_base_amount * (p_tax_rate / 100),
3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3080: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3081: 'Y');

Line 3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3074: ELSE
3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3076: p_base_amount * (p_tax_rate / 100),
3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3080: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3081: 'Y');
3082: END IF;

Line 3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3075: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3076: p_base_amount * (p_tax_rate / 100),
3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3080: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3081: 'Y');
3082: END IF;
3083:

Line 3080: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3076: p_base_amount * (p_tax_rate / 100),
3077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3079: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3080: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3081: 'Y');
3082: END IF;
3083:
3084: p_tax_amount := 0;

Line 3168: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3164: to_char(l_sch_tax_amount));
3165: END IF;
3166:
3167: p_calculated_tax_amount :=
3168: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3169: (l_sch_tax_amount / p_exchange_rate),
3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3166:
3167: p_calculated_tax_amount :=
3168: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3169: (l_sch_tax_amount / p_exchange_rate),
3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3174: 'Y');

Line 3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3167: p_calculated_tax_amount :=
3168: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3169: (l_sch_tax_amount / p_exchange_rate),
3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3174: 'Y');
3175: END IF;

Line 3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3168: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3169: (l_sch_tax_amount / p_exchange_rate),
3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3174: 'Y');
3175: END IF;
3176:

Line 3173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3169: (l_sch_tax_amount / p_exchange_rate),
3170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3174: 'Y');
3175: END IF;
3176:
3177: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3305: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec

3301: --
3302: -- DESCRIPTION
3303: -- This routine calculates the tax amount for the transaction line or
3304: -- sales order line that is recorded in the global structure
3305: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec
3306: --
3307: -- PARAMETERS
3308: -- p_tax_category_id
3309: -- p_tax_rate

Line 3467: AND tc.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;

3463: WHERE tc.tax_category_id = p_tax_category_id
3464: AND p_trx_date <= tc.end_date_active
3465: AND p_trx_date >= NVL(tc.start_date_active, p_trx_date)
3466: AND nvl(tc.org_id,-99) = nvl(sp.org_id,-99)
3467: AND tc.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;
3468:
3469: -- Tax code passed in the line is a group
3470: ELSE
3471: -- get attributes from the Latin tax group to check

Line 3495: AND tg.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;

3491: AND tg.establishment_type = p_establishment_type
3492: AND p_trx_date <= tg.end_date_active
3493: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
3494: AND nvl(tg.org_id,-99) = nvl(sp.org_id,-99)
3495: AND tg.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;
3496:
3497: END IF;
3498:
3499: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3573: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN

3569: begin
3570: -- Bugfix 1388703
3571:
3572: -- Bugfix 1783986. Added if and else conditions
3573: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3574: select ac.tax_attribute_value
3575: into v_aux_contributor_type
3576: from jl_zz_ar_tx_cus_cls ac,
3577: hz_cust_site_uses su,

Line 3675: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;

3671: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || '-- Auxiliary taxable basis: '||to_char(v_aux_taxable_basis));
3672: END IF;
3673:
3674: IF v_aux_taxable_basis = 'QUANTITY' THEN
3675: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;
3676: ELSE
3677: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
3678: END IF;
3679:

Line 3677: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;

3673:
3674: IF v_aux_taxable_basis = 'QUANTITY' THEN
3675: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;
3676: ELSE
3677: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
3678: END IF;
3679:
3680: v_aux_base_rate := NULL;
3681:

Line 3762: IF v_aux_latin_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN

3758: v_aux_latin_return_code,
3759: v_aux_calculated_tax_amount,
3760: p_exchange_rate);
3761:
3762: IF v_aux_latin_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN
3763: RAISE ERROR_FROM_FUNCTION;
3764: END IF;
3765:
3766: -- add the tax amount to the base amount if needed

Line 3792: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt := (nvl(p_base_amount,0) + p_entered_amount)

3788: END IF;
3789:
3790: -- CR 3571797. Assign Unrounded Taxable Amount in tax_info_rec for E-Business Tax
3791: -- requirement on LTE Tax Lines to simplify migration process of LTE.
3792: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt := (nvl(p_base_amount,0) + p_entered_amount)
3793: * (1 + (nvl(p_base_rate,0)/100));
3794:
3795: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3796: (nvl(p_base_amount,0) + p_entered_amount)

Line 3795: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3791: -- requirement on LTE Tax Lines to simplify migration process of LTE.
3792: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt := (nvl(p_base_amount,0) + p_entered_amount)
3793: * (1 + (nvl(p_base_rate,0)/100));
3794:
3795: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3796: (nvl(p_base_amount,0) + p_entered_amount)
3797: * (1 + (nvl(p_base_rate,0)/100)),
3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

Line 3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3794:
3795: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3796: (nvl(p_base_amount,0) + p_entered_amount)
3797: * (1 + (nvl(p_base_rate,0)/100)),
3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3800: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3801: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3802: 'Y');

Line 3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3795: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3796: (nvl(p_base_amount,0) + p_entered_amount)
3797: * (1 + (nvl(p_base_rate,0)/100)),
3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3800: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3801: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3802: 'Y');
3803:

Line 3800: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3796: (nvl(p_base_amount,0) + p_entered_amount)
3797: * (1 + (nvl(p_base_rate,0)/100)),
3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3800: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3801: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3802: 'Y');
3803:
3804: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3801: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3797: * (1 + (nvl(p_base_rate,0)/100)),
3798: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3799: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3800: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3801: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3802: 'Y');
3803:
3804: IF (g_level_statement >= g_current_runtime_level) THEN
3805: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || '-- Base amount after apply base rate (rounded): '||

Line 3855: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

3851: END IF;
3852: END IF;
3853:
3854: -- return success
3855: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
3856:
3857: IF (g_level_statement >= g_current_runtime_level) THEN
3858: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate_latin_tax()-');
3859: END IF;

Line 3871: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3867: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3868: fnd_message.set_token('GENERIC_TEXT',
3869: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax '||
3870: v_calculate_return_code);
3871: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3873: p_customer_trx_line_id;
3874:
3875: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

Line 3887: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3883: WHEN ERROR_FROM_FUNCTION THEN
3884: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3885: fnd_message.set_token('GENERIC_TEXT',
3886: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax');
3887: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3888: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3889: p_customer_trx_line_id;
3890:
3891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

Line 3906: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3902: WHEN NO_DATA_FOUND THEN
3903: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3904: fnd_message.set_token('GENERIC_TEXT',
3905: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate_latin_tax');
3906: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3907: IF (g_level_statement >= g_current_runtime_level) THEN
3908: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(NO_DATA_FOUND): '||
3909: 'jl_zz_tax.calculate_latin_tax');
3910: END IF;

Line 3916: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3912: WHEN TOO_MANY_ROWS THEN
3913: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3914: fnd_message.set_token('GENERIC_TEXT',
3915: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate_latin_tax');
3916: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3917: IF (g_level_statement >= g_current_runtime_level) THEN
3918: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(TOO_MANY_ROWS): '||
3919: 'jl_zz_tax.calculate_latin_tax');
3920: END IF;

Line 3929: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3925: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3926: fnd_message.set_token('GENERIC_TEXT',
3927: 'EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3928: to_char(err_num)||' '||err_msg);
3929: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3930: IF (g_level_statement >= g_current_runtime_level) THEN
3931: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3932: to_char(err_num)||' '||err_msg);
3933: END IF;

Line 3945: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec

3941: --
3942: -- DESCRIPTION
3943: -- This routine calculates the tax amount for the transaction line or
3944: -- sales order line that is recorded in the global structure
3945: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec
3946: --
3947: -- PARAMETERS
3948: -- tax_info_rec
3949: --

Line 3955: -- ZX_PRODUCT_INTEGRATION_PKG.calculate

3951: -- tax_info_rec updated with tax_rate, amount, global_attributes and
3952: -- other information
3953: --
3954: -- CALLED FROM
3955: -- ZX_PRODUCT_INTEGRATION_PKG.calculate
3956: --
3957: -- HISTORY
3958: -- 02-OCT-97 A. Chiromatzo Return values for global flexfield just
3959: -- for AR

Line 3961: -- if ZX_PRODUCT_INTEGRATION_PKG.TAX_INFO_REC.TAX_AMOUNT is not null, if

3957: -- HISTORY
3958: -- 02-OCT-97 A. Chiromatzo Return values for global flexfield just
3959: -- for AR
3960: -- 09-SEP-97 A. Chiromatzo in calculate function, first check
3961: -- if ZX_PRODUCT_INTEGRATION_PKG.TAX_INFO_REC.TAX_AMOUNT is not null, if
3962: -- it's not null then does not perform anything as it
3963: -- does not use the audit trail, avoiding error
3964: -- during delete
3965: -- 20-NOV-97 A.Chiromatzo debug messages

Line 3971: -- 08-FEB-99 H. Takle Used ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 to determine

3967: -- and global_attribute9 to null in the beginning
3968: -- of the calculate_latin_tax procedure. Also,
3969: -- for base amount reduction, <= 0 condition
3970: -- replaced with < 0.
3971: -- 08-FEB-99 H. Takle Used ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 to determine
3972: -- the calling view name. Changed for bug number
3973: -- 807588. Following is the mapping for usern7.
3974: -- 1 TAX_LINES_DELETE_VBR
3975: -- 2 TAX_LINES_CREATE_VBR

Line 4035: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));

4031:
4032: IF (g_level_statement >= g_current_runtime_level) THEN
4033: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
4034: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
4035: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax code: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax rate: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate);
4038: END IF;
4039:

Line 4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax code: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);

4032: IF (g_level_statement >= g_current_runtime_level) THEN
4033: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
4034: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
4035: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax code: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax rate: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate);
4038: END IF;
4039:
4040: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

Line 4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax rate: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate);

4033: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
4034: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
4035: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax code: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax rate: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate);
4038: END IF;
4039:
4040: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
4041:

Line 4040: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax code: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax rate: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate);
4038: END IF;
4039:
4040: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
4041:
4042: -- Following code added for the bug number 1019748++
4043:
4044: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN

Line 4044: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN

4040: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
4041:
4042: -- Following code added for the bug number 1019748++
4043:
4044: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
4045: l_application := 'AR';
4046: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN
4047: l_application := 'OE';
4048: END IF;

Line 4046: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN

4042: -- Following code added for the bug number 1019748++
4043:
4044: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
4045: l_application := 'AR';
4046: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN
4047: l_application := 'OE';
4048: END IF;
4049:
4050: -- Above code added for the bug number 1019748--

Line 4056: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 = 1 THEN

4052: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Application: '||l_application);
4053: END IF;
4054: -- Following code added for the bug number 807588++
4055:
4056: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 = 1 THEN
4057: -- Set following variable to populate_plsql_tables to execute before
4058: -- the first tax line processing
4059: g_prev_invoice_line_number := NULL;
4060: END IF;

Line 4071: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN

4067: -- in order to get the correct rule defined from
4068: -- jl_zz_ar_tx_rules table
4069: --
4070:
4071: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
4072: OPEN get_orig_trx_type_id_c
4073: (l_org_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);
4075: FETCH get_orig_trx_type_id_c INTO l_cust_trx_type_id;

Line 4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);

4070:
4071: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
4072: OPEN get_orig_trx_type_id_c
4073: (l_org_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);
4075: FETCH get_orig_trx_type_id_c INTO l_cust_trx_type_id;
4076: CLOSE get_orig_trx_type_id_c;
4077:
4078: l_trx_type_id := l_cust_trx_type_id;

Line 4081: l_trx_type_id := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id;

4077:
4078: l_trx_type_id := l_cust_trx_type_id;
4079: ELSE
4080: -- not credit memo
4081: l_trx_type_id := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id;
4082: END IF;
4083:
4084:
4085: -- The view did not get the default tax code

Line 4086: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN

4082: END IF;
4083:
4084:
4085: -- The view did not get the default tax code
4086: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
4087: -- Raise the message populated in get_category_tax_code
4088: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4089:
4090: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN

Line 4088: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

4084:
4085: -- The view did not get the default tax code
4086: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
4087: -- Raise the message populated in get_category_tax_code
4088: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4089:
4090: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4091: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4092: sp.global_attribute14,

Line 4090: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN

4086: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
4087: -- Raise the message populated in get_category_tax_code
4088: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4089:
4090: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4091: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4092: sp.global_attribute14,
4093: vt.global_attribute3,
4094: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

Line 4094: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

4090: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4091: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4092: sp.global_attribute14,
4093: vt.global_attribute3,
4094: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4095: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4097: NULL, 1,
4098: 0, 1,

Line 4095: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,

4091: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4092: sp.global_attribute14,
4093: vt.global_attribute3,
4094: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4095: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4097: NULL, 1,
4098: 0, 1,
4099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))

Line 4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,

4092: sp.global_attribute14,
4093: vt.global_attribute3,
4094: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4095: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4097: NULL, 1,
4098: 0, 1,
4099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4100: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,

Line 4099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))

4095: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4097: NULL, 1,
4098: 0, 1,
4099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4100: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,
4101: v_use_legal_message,
4102: v_legal_message_exception,
4103: l_exchange_rate

Line 4100: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,

4096: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4097: NULL, 1,
4098: 0, 1,
4099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4100: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,
4101: v_use_legal_message,
4102: v_legal_message_exception,
4103: l_exchange_rate
4104: FROM ar_vat_tax vt,

Line 4106: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id

4102: v_legal_message_exception,
4103: l_exchange_rate
4104: FROM ar_vat_tax vt,
4105: ar_system_parameters_all sp
4106: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4107: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4108:
4109: --BugFix 2180174 commented the Following IF condition.
4110: /*

Line 4111: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL AND

4107: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4108:
4109: --BugFix 2180174 commented the Following IF condition.
4110: /*
4111: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL AND
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN
4113: IF (g_level_statement >= g_current_runtime_level) THEN
4114: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4115: END IF;

Line 4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN

4108:
4109: --BugFix 2180174 commented the Following IF condition.
4110: /*
4111: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL AND
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN
4113: IF (g_level_statement >= g_current_runtime_level) THEN
4114: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4115: END IF;
4116: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);

4123:
4124: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Use Legal Message: '||v_use_legal_message);
4125: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Exchange Rate: '||to_char(l_exchange_rate));
4126: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes tax flag: '||
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
4128: END IF;
4129:
4130: SELECT NVL(global_attribute1,'DEFAULT')
4131: INTO l_organization_class

Line 4133: where location_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4;

4129:
4130: SELECT NVL(global_attribute1,'DEFAULT')
4131: INTO l_organization_class
4132: FROM hr_locations_all
4133: where location_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4;
4134:
4135: IF (g_level_statement >= g_current_runtime_level) THEN
4136: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);
4137: END IF;

Line 4139: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis = 'QUANTITY' THEN

4135: IF (g_level_statement >= g_current_runtime_level) THEN
4136: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);
4137: END IF;
4138:
4139: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis = 'QUANTITY' THEN
4140: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;
4141: ELSE
4142: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
4143: END IF;

Line 4140: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;

4136: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);
4137: END IF;
4138:
4139: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis = 'QUANTITY' THEN
4140: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;
4141: ELSE
4142: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
4143: END IF;
4144:

Line 4142: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;

4138:
4139: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis = 'QUANTITY' THEN
4140: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxed_quantity;
4141: ELSE
4142: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
4143: END IF;
4144:
4145: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 is NOT NULL THEN
4146: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4145: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 is NOT NULL THEN

4141: ELSE
4142: l_entered_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount;
4143: END IF;
4144:
4145: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 is NOT NULL THEN
4146: IF (g_level_statement >= g_current_runtime_level) THEN
4147:
4148: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4149: to_char(l_trx_type_id));

Line 4151: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));

4147:
4148: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4149: to_char(l_trx_type_id));
4150: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax Category Id: '||
4151: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
4152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Contributor Type: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8);
4153: END IF;
4154:
4155: l_legal_message8 := NULL;

Line 4152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Contributor Type: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8);

4148: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4149: to_char(l_trx_type_id));
4150: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax Category Id: '||
4151: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
4152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Contributor Type: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8);
4153: END IF;
4154:
4155: l_legal_message8 := NULL;
4156: l_legal_message9 := NULL;

Line 4159: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;

4155: l_legal_message8 := NULL;
4156: l_legal_message9 := NULL;
4157:
4158: -- Added following 2 lines to take care of bug# 660025
4159: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4161:
4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=

Line 4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;

4156: l_legal_message9 := NULL;
4157:
4158: -- Added following 2 lines to take care of bug# 660025
4159: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4161:
4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=
4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (

Line 4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN

4158: -- Added following 2 lines to take care of bug# 660025
4159: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4161:
4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=
4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (
4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,

Line 4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=

4159: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4161:
4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=
4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (
4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

Line 4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,

4161:
4162: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 IS NULL THEN
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=
4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (
4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

Line 4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3 :=
4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (
4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

Line 4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

4164: JL_ZZ_TAX.GET_TAX_BASE_RATE (
4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

Line 4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

4165: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

Line 4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,

4166: l_trx_type_id,
4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

Line 4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

4167: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,

Line 4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

4168: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

4169: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',

Line 4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

4170: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4171: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

Line 4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4172: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4173: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

Line 4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

4174: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

Line 4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4175: l_application,
4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

Line 4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

4176: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

Line 4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,

4177: 'BASE',
4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

Line 4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

4178: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );

Line 4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

4179: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
4187: END IF;

Line 4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

4180: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
4187: END IF;
4188:

Line 4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

4181: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
4187: END IF;
4188:
4189: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );

4182: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4183: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4185: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4186: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 );
4187: END IF;
4188:
4189: IF (g_level_statement >= g_current_runtime_level ) THEN
4190: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Base Rate: '

Line 4191: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));

4187: END IF;
4188:
4189: IF (g_level_statement >= g_current_runtime_level ) THEN
4190: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Base Rate: '
4191: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
4192: END IF;
4193:
4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

Line 4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,

4190: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Base Rate: '
4191: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
4192: END IF;
4193:
4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

Line 4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

4191: || to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3));
4192: END IF;
4193:
4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

Line 4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

4193:
4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

Line 4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

4194: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

Line 4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

4195: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

Line 4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,

4196: l_trx_type_id,
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

Line 4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,

Line 4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

4198: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

4199: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

Line 4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

4200: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),

Line 4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

4203: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

Line 4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

Line 4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

4205: l_application,
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),

Line 4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),

4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

Line 4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

4207: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

Line 4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

4208: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

Line 4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),

4209: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

Line 4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

4210: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4218: v_use_legal_message,

Line 4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

4211: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4218: v_use_legal_message,
4219: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

Line 4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

4212: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4218: v_use_legal_message,
4219: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4220: v_legal_message_exception,

Line 4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

4213: l_entered_amount * (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4214: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4218: v_use_legal_message,
4219: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4220: v_legal_message_exception,
4221: v_rule_id,

Line 4219: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

4215: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4218: v_use_legal_message,
4219: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4220: v_legal_message_exception,
4221: v_rule_id,
4222: l_legal_message8,
4223: l_legal_message9);

Line 4233: RETURN(ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4229: END IF;
4230:
4231: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4232: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4233: RETURN(ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4234: ELSE
4235: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4236: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4237: END IF;

Line 4235: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;

4231: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4232: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4233: RETURN(ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4234: ELSE
4235: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4236: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4237: END IF;
4238: END IF;
4239:

Line 4236: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;

4232: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4233: RETURN(ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4234: ELSE
4235: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4236: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4237: END IF;
4238: END IF;
4239:
4240:

Line 4241: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,

4237: END IF;
4238: END IF;
4239:
4240:
4241: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4242: v_rule_id,
4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

Line 4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,

4239:
4240:
4241: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4242: v_rule_id,
4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

Line 4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

4240:
4241: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4242: v_rule_id,
4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

Line 4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

4241: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4242: v_rule_id,
4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

Line 4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

4242: v_rule_id,
4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

Line 4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

4243: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

Line 4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

4244: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

Line 4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

4245: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

Line 4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

4246: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

Line 4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,

Line 4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

4248: l_trx_type_id, --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

4249: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

Line 4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

4250: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4251: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

Line 4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4252: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

Line 4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

4253: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

Line 4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

4254: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,

Line 4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

4255: l_application,
4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,

Line 4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

4256: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,

Line 4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

4257: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,

Line 4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,

4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4259: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,

Line 4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,

4260: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

Line 4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,

4261: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,

Line 4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,

4262: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,

Line 4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,

4263: l_entered_amount,
4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,

Line 4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

4264: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4265: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

Line 4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,

4266: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4273: v_base_amount,
4274: v_tax_amount,

Line 4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,

4267: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4273: v_base_amount,
4274: v_tax_amount,
4275: v_latin_tax_return_code,

Line 4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

4268: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4269: l_organization_class,
4270: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4273: v_base_amount,
4274: v_tax_amount,
4275: v_latin_tax_return_code,
4276: v_calculated_tax_amount,

Line 4279: IF v_latin_tax_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN

4275: v_latin_tax_return_code,
4276: v_calculated_tax_amount,
4277: l_exchange_rate);
4278:
4279: IF v_latin_tax_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN
4280: RAISE ERROR_FROM_FUNCTION;
4281: END IF;
4282:
4283: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4292: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_tax_amt := v_tax_amount;

4288: END IF;
4289:
4290: -- CR 3571797. Assign Unrounded Tax Amount to tax_info_rec for E-Business Tax
4291: -- requirement on LTE Tax Lines to simplify migration process of LTE.
4292: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_tax_amt := v_tax_amount;
4293:
4294: -- associate values in tax_info_rec and in global_attributes
4295: -- original rounding procedure
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round

Line 4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round

4292: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_tax_amt := v_tax_amount;
4293:
4294: -- associate values in tax_info_rec and in global_attributes
4295: -- original rounding procedure
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4297: (v_tax_amount,
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

4294: -- associate values in tax_info_rec and in global_attributes
4295: -- original rounding procedure
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4297: (v_tax_amount,
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4301: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4302: 'Y');

Line 4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

4295: -- original rounding procedure
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4297: (v_tax_amount,
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4301: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4302: 'Y');
4303:

Line 4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4297: (v_tax_amount,
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4301: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4302: 'Y');
4303:
4304: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4301: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

4297: (v_tax_amount,
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4299: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4301: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4302: 'Y');
4303:
4304: IF (g_level_statement >= g_current_runtime_level) THEN
4305: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax category tax amount after rounding: '||

Line 4306: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));

4302: 'Y');
4303:
4304: IF (g_level_statement >= g_current_runtime_level) THEN
4305: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax category tax amount after rounding: '||
4306: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
4307: END IF;
4308: -- set the global flexfield context according to product 'AR'
4309: IF l_application = 'AR' THEN
4310: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null);

Line 4318: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

4314: END IF;
4315:
4316: IF l_country_code = 'BR' THEN --Bug 2367111
4317: --IF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') = 'BR' THEN
4318: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4319: 'JL.BR.ARXTWMAI.Additional Info';
4320: ELSIF l_country_code IN ('AR','CO') THEN --Bug 2367111
4321: --ELSIF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') IN ('AR','CO') THEN
4322: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

Line 4322: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

4318: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4319: 'JL.BR.ARXTWMAI.Additional Info';
4320: ELSIF l_country_code IN ('AR','CO') THEN --Bug 2367111
4321: --ELSIF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') IN ('AR','CO') THEN
4322: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4323: 'J'||'L.'||JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)|| --Bug 2367111
4324: --'J'||'L.'||fnd_profile.value_wnps('JGZZ_COUNTRY_CODE')||
4325: '.ARXTWMAI.LINES';
4326: END IF;

Line 4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;

4325: '.ARXTWMAI.LINES';
4326: END IF;
4327:
4328: -- set the default global attributes for the tax lines
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=

Line 4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;

4326: END IF;
4327:
4328: -- set the default global attributes for the tax lines
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);

Line 4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=

4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:

Line 4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=

4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=

Line 4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);

4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

Line 4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=

4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:

Line 4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:
4344: -- Added following 1 line to take care of bug# 787259

Line 4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=

4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:
4344: -- Added following 1 line to take care of bug# 787259
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;

Line 4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;

4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:
4344: -- Added following 1 line to take care of bug# 787259
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;
4346: END IF;
4347:
4348: END IF;
4349:

Line 4352: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5 IS NOT NULL THEN

4348: END IF;
4349:
4350: -- Following code added for Bug Number 803394++
4351:
4352: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5 IS NOT NULL THEN
4353: l_vat_tax_id := NULL;
4354: BEGIN
4355: SELECT vat_tax_id
4356: INTO l_vat_tax_id

Line 4358: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code

4354: BEGIN
4355: SELECT vat_tax_id
4356: INTO l_vat_tax_id
4357: FROM ar_vat_tax
4358: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4360: AND tax_type = 'VAT'
4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=

Line 4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id

4355: SELECT vat_tax_id
4356: INTO l_vat_tax_id
4357: FROM ar_vat_tax
4358: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4360: AND tax_type = 'VAT'
4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4363: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))

Line 4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date

4357: FROM ar_vat_tax
4358: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4360: AND tax_type = 'VAT'
4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4363: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4364: AND nvl(enabled_flag,'Y') = 'Y'
4365: AND nvl(tax_class,'O') = 'O';

Line 4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=

4358: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4360: AND tax_type = 'VAT'
4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4363: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4364: AND nvl(enabled_flag,'Y') = 'Y'
4365: AND nvl(tax_class,'O') = 'O';
4366: EXCEPTION

Line 4363: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))

4359: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4360: AND tax_type = 'VAT'
4361: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4362: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4363: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4364: AND nvl(enabled_flag,'Y') = 'Y'
4365: AND nvl(tax_class,'O') = 'O';
4366: EXCEPTION
4367: WHEN OTHERS THEN

Line 4372: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));

4368: l_vat_tax_id := NULL;
4369: END;
4370: IF (g_level_statement >= g_current_runtime_level) THEN
4371: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Original Vat Tax Id '||
4372: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4373: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4374: END IF;
4375: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4376: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);

Line 4375: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=

4371: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Original Vat Tax Id '||
4372: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4373: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4374: END IF;
4375: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4376: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);
4377: END IF;
4378:
4379: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines

Line 4376: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);

4372: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4373: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4374: END IF;
4375: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4376: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);
4377: END IF;
4378:
4379: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines
4380: -- that are required for E-Business Tax solution and simplifies migration of LTE

Line 4382: --IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code IS NULL THEN

4378:
4379: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines
4380: -- that are required for E-Business Tax solution and simplifies migration of LTE
4381: -- tax lines.
4382: --IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code IS NULL THEN
4383:
4384: IF (g_level_statement >= g_current_runtime_level) THEN
4385: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- populating tix information for tax_regime_code: '||
4386: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

Line 4386: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

4382: --IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code IS NULL THEN
4383:
4384: IF (g_level_statement >= g_current_runtime_level) THEN
4385: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- populating tix information for tax_regime_code: '||
4386: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4387: END IF;
4388:
4389: BEGIN
4390: SELECT rate.tax_rate_id,

Line 4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,

4394: tax.tax_id,
4395: tax.tax,
4396: status.tax_status_id,
4397: status.tax_status_code
4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,

Line 4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,

4395: tax.tax,
4396: status.tax_status_id,
4397: status.tax_status_code
4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

Line 4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,

4396: status.tax_status_id,
4397: status.tax_status_code
4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,

Line 4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,

4397: status.tax_status_code
4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

Line 4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,

4398: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4406: FROM zx_rates_b rate,

Line 4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

4399: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4406: FROM zx_rates_b rate,
4407: zx_regimes_b regime,

Line 4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,

4400: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4406: FROM zx_rates_b rate,
4407: zx_regimes_b regime,
4408: zx_taxes_b tax,

Line 4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

4401: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4402: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4403: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4404: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4405: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4406: FROM zx_rates_b rate,
4407: zx_regimes_b regime,
4408: zx_taxes_b tax,
4409: zx_status_b status

Line 4410: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id

4406: FROM zx_rates_b rate,
4407: zx_regimes_b regime,
4408: zx_taxes_b tax,
4409: zx_status_b status
4410: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4411: and rate.tax_regime_code = regime.tax_regime_code
4412: and rate.tax = tax.tax
4413: and tax.tax_regime_code = rate.tax_regime_code
4414: and tax.content_owner_id = rate.content_owner_id

Line 4422: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);

4418: and status.content_owner_id = rate.content_owner_id;
4419:
4420: IF (g_level_statement >= g_current_runtime_level) THEN
4421: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Rate Code: ' ||
4422: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4423: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4424: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4425: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4426: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);

Line 4424: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

4420: IF (g_level_statement >= g_current_runtime_level) THEN
4421: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Rate Code: ' ||
4422: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4423: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4424: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4425: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4426: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4427: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4428: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);

Line 4426: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);

4422: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4423: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4424: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4425: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4426: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4427: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4428: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);
4429: END IF;
4430:

Line 4428: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);

4424: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4425: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4426: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4427: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4428: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);
4429: END IF;
4430:
4431: EXCEPTION
4432: WHEN NO_DATA_FOUND THEN

Line 4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,

4435: rate.tax_rate_code,
4436: rate.tax_regime_code,
4437: rate.tax,
4438: rate.tax_status_code
4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

Line 4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,

4436: rate.tax_regime_code,
4437: rate.tax,
4438: rate.tax_status_code
4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4444: FROM zx_rates_b rate

Line 4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,

4437: rate.tax,
4438: rate.tax_status_code
4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4444: FROM zx_rates_b rate
4445: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;

Line 4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

4438: rate.tax_status_code
4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4444: FROM zx_rates_b rate
4445: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4446:

Line 4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

4439: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4440: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4444: FROM zx_rates_b rate
4445: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4446:
4447: WHEN OTHERS THEN

Line 4445: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;

4441: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4442: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4443: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4444: FROM zx_rates_b rate
4445: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4446:
4447: WHEN OTHERS THEN
4448: IF (g_level_statement >= g_current_runtime_level) THEN
4449: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(EBTAX): jl_zz_tax.calculate '||

Line 4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=

4453: END;
4454: --END IF; -- End Bug 3571797
4455:
4456: -- Populate the eBTax related columns here:
4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=

Line 4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;

4454: --END IF; -- End Bug 3571797
4455:
4456: -- Populate the eBTax related columns here:
4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;

Line 4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=

4455:
4456: -- Populate the eBTax related columns here:
4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=

Line 4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;

4456: -- Populate the eBTax related columns here:
4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;

Line 4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=

4457: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;

Line 4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;

4458: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;

Line 4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=

4459: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;

Line 4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;

4460: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=

Line 4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;

4461: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;

Line 4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;

4462: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=

Line 4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;

4463: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=

4464: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=

Line 4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;

4465: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=

4466: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=

Line 4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4467: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=

4468: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4476:

Line 4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4469: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4476:
4477: -- Code added for Bug Number 803394--

Line 4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=

4470: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4476:
4477: -- Code added for Bug Number 803394--
4478:

Line 4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4471: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4472: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4473: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4474: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4475: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4476:
4477: -- Code added for Bug Number 803394--
4478:
4479: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4493: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;

4489: IF (g_level_unexpected >= g_current_runtime_level) THEN
4490: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');
4491: END IF;
4492: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4493: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;
4494:
4495: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4496: 'LINE';
4497:

Line 4502: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4498: ZX_API_PUB.add_msg(
4499: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4500:
4501:
4502: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4503:
4504: WHEN NO_DATA_FOUND THEN
4505: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4506: fnd_message.set_token('GENERIC_TEXT',

Line 4511: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4507: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4508: IF (g_level_unexpected >= g_current_runtime_level) THEN
4509: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4510: END IF;
4511: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4512:
4513: WHEN TOO_MANY_ROWS THEN
4514: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4515: fnd_message.set_token('GENERIC_TEXT',

Line 4520: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4516: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4517: IF (g_level_unexpected >= g_current_runtime_level) THEN
4518: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4519: END IF;
4520: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4521:
4522: WHEN OTHERS THEN
4523: err_num := SQLCODE;
4524: err_msg := SUBSTR(SQLERRM,1,100);

Line 4534: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4530: IF (g_level_unexpected >= g_current_runtime_level) THEN
4531: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(OTHERS): jl_zz_tax.calculate '||
4532: SQLCODE||' ; '||SQLERRM);
4533: END IF;
4534: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4535:
4536: END calculate;
4537:
4538: FUNCTION get_legal_message (