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 1333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;

1329: IF (g_level_unexpected >= g_current_runtime_level) THEN
1330: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.get_category_tax_rule');
1331: END IF;
1332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;
1334:
1335: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1336: 'LINE';
1337:

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

1734: l_contributor_type := NULL;
1735:
1736: BEGIN
1737: -- Bugfix 1783986
1738: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1739: select ota.tax_attribute_value,
1740: cta.tax_attribute_value
1741: into l_establishment_type,
1742: l_contributor_type

Line 2724: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

2720: p_exchange_rate IN NUMBER) RETURN NUMBER IS
2721: l_functional_amount NUMBER;
2722: BEGIN
2723:
2724: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2725: p_amount * p_exchange_rate,
2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

2722: BEGIN
2723:
2724: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2725: p_amount * p_exchange_rate,
2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2729: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2730: 'Y');

Line 2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

2723:
2724: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2725: p_amount * p_exchange_rate,
2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2729: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2730: 'Y');
2731:

Line 2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

2724: l_functional_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
2725: p_amount * p_exchange_rate,
2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2729: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2730: 'Y');
2731:
2732: RETURN l_functional_amount;

Line 2729: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

2725: p_amount * p_exchange_rate,
2726: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
2727: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
2728: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
2729: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
2730: 'Y');
2731:
2732: RETURN l_functional_amount;
2733:

Line 2974: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

2970: l_grp_attr_name,
2971: p_trx_date,
2972: nvl(p_ship_to_site_use_id,p_bill_to_site_use_id),
2973: p_organization_class,
2974: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
2975: p_transaction_nature_class);
2976:
2977: IF (g_level_statement >= g_current_runtime_level) THEN
2978: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_tax_amount: ' || '-- validate current tax line return status: '||

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

3004: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_tax_amount: ' || '-- Total Calculated Tax Amount: '||
3005: to_char(l_tot_calculated_tax_amt));
3006: END IF;
3007: IF (g_level_statement >= g_current_runtime_level) THEN
3008: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||

Line 3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);

3005: to_char(l_tot_calculated_tax_amt));
3006: END IF;
3007: IF (g_level_statement >= g_current_runtime_level) THEN
3008: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);

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

3006: END IF;
3007: IF (g_level_statement >= g_current_runtime_level) THEN
3008: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||

Line 3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);

3007: IF (g_level_statement >= g_current_runtime_level) THEN
3008: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);

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

3008: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code = '||
3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3016: END IF;

Line 3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);

3009: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code);
3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3016: END IF;
3017:

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

3010: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision = '||
3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3016: END IF;
3017:
3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

Line 3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);

3011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision);
3012: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit = '||
3013: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit);
3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3016: END IF;
3017:
3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3019: p_base_amount * (p_tax_rate / 100),

Line 3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3014: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule ='||
3015: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule);
3016: END IF;
3017:
3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3019: p_base_amount * (p_tax_rate / 100),
3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3016: END IF;
3017:
3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3019: p_base_amount * (p_tax_rate / 100),
3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3023: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3024: 'Y');

Line 3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3017:
3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3019: p_base_amount * (p_tax_rate / 100),
3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3023: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3024: 'Y');
3025: p_tax_amount := 0;

Line 3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3018: p_calculated_tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3019: p_base_amount * (p_tax_rate / 100),
3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3023: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3024: 'Y');
3025: p_tax_amount := 0;
3026:

Line 3023: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3019: p_base_amount * (p_tax_rate / 100),
3020: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3021: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3022: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3023: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3024: 'Y');
3025: p_tax_amount := 0;
3026:
3027: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3097: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3093: to_char(l_sch_tax_amount));
3094: END IF;
3095:
3096: p_calculated_tax_amount :=
3097: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3098: (l_sch_tax_amount / p_exchange_rate),
3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3095:
3096: p_calculated_tax_amount :=
3097: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3098: (l_sch_tax_amount / p_exchange_rate),
3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3102: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3103: 'Y');

Line 3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3096: p_calculated_tax_amount :=
3097: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3098: (l_sch_tax_amount / p_exchange_rate),
3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3102: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3103: 'Y');
3104: END IF;

Line 3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3097: ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3098: (l_sch_tax_amount / p_exchange_rate),
3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3102: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3103: 'Y');
3104: END IF;
3105:

Line 3102: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3098: (l_sch_tax_amount / p_exchange_rate),
3099: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3100: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3101: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3102: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3103: 'Y');
3104: END IF;
3105:
3106: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3232: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec

3228: --
3229: -- DESCRIPTION
3230: -- This routine calculates the tax amount for the transaction line or
3231: -- sales order line that is recorded in the global structure
3232: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec
3233: --
3234: -- PARAMETERS
3235: -- p_tax_category_id
3236: -- p_tax_rate

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

3385: WHERE tc.tax_category_id = p_tax_category_id
3386: AND p_trx_date <= tc.end_date_active
3387: AND p_trx_date >= NVL(tc.start_date_active, p_trx_date)
3388: AND nvl(tc.org_id,-99) = nvl(sp.org_id,-99)
3389: AND tc.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;
3390:
3391: -- Tax code passed in the line is a group
3392: ELSE
3393: -- get attributes from the Latin tax group to check

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

3413: AND tg.establishment_type = p_establishment_type
3414: AND p_trx_date <= tg.end_date_active
3415: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
3416: AND nvl(tg.org_id,-99) = nvl(sp.org_id,-99)
3417: AND tg.org_id = zx_product_integration_pkg.sysinfo.sysparam.org_id;
3418:
3419: END IF;
3420:
3421: IF (g_level_statement >= g_current_runtime_level) THEN

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

3491: begin
3492: -- Bugfix 1388703
3493:
3494: -- Bugfix 1783986. Added if and else conditions
3495: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3496: select ac.tax_attribute_value
3497: into v_aux_contributor_type
3498: from jl_zz_ar_tx_cus_cls ac,
3499: hz_cust_site_uses su,

Line 3676: IF v_aux_latin_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN

3672: v_aux_latin_return_code,
3673: v_aux_calculated_tax_amount,
3674: p_exchange_rate);
3675:
3676: IF v_aux_latin_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN
3677: RAISE ERROR_FROM_FUNCTION;
3678: END IF;
3679:
3680: -- add the tax amount to the base amount if needed

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

3702: END IF;
3703:
3704: -- CR 3571797. Assign Unrounded Taxable Amount in tax_info_rec for E-Business Tax
3705: -- requirement on LTE Tax Lines to simplify migration process of LTE.
3706: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt := (nvl(p_base_amount,0) + p_entered_amount)
3707: * (1 + (nvl(p_base_rate,0)/100));
3708:
3709: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3710: (nvl(p_base_amount,0) + p_entered_amount)

Line 3709: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (

3705: -- requirement on LTE Tax Lines to simplify migration process of LTE.
3706: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt := (nvl(p_base_amount,0) + p_entered_amount)
3707: * (1 + (nvl(p_base_rate,0)/100));
3708:
3709: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3710: (nvl(p_base_amount,0) + p_entered_amount)
3711: * (1 + (nvl(p_base_rate,0)/100)),
3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

Line 3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

3708:
3709: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3710: (nvl(p_base_amount,0) + p_entered_amount)
3711: * (1 + (nvl(p_base_rate,0)/100)),
3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3714: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3715: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3716: 'Y');

Line 3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

3709: p_base_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round (
3710: (nvl(p_base_amount,0) + p_entered_amount)
3711: * (1 + (nvl(p_base_rate,0)/100)),
3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3714: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3715: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3716: 'Y');
3717:

Line 3714: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

3710: (nvl(p_base_amount,0) + p_entered_amount)
3711: * (1 + (nvl(p_base_rate,0)/100)),
3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3714: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3715: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3716: 'Y');
3717:
3718: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3715: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

3711: * (1 + (nvl(p_base_rate,0)/100)),
3712: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
3713: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
3714: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
3715: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
3716: 'Y');
3717:
3718: IF (g_level_statement >= g_current_runtime_level) THEN
3719: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || '-- Base amount after apply base rate (rounded): '||

Line 3768: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

3764: END IF;
3765: END IF;
3766:
3767: -- return success
3768: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
3769:
3770: IF (g_level_statement >= g_current_runtime_level) THEN
3771: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate_latin_tax()-');
3772: END IF;

Line 3784: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3780: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3781: fnd_message.set_token('GENERIC_TEXT',
3782: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax '||
3783: v_calculate_return_code);
3784: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3786: p_customer_trx_line_id;
3787:
3788: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

Line 3800: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3796: WHEN ERROR_FROM_FUNCTION THEN
3797: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3798: fnd_message.set_token('GENERIC_TEXT',
3799: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax');
3800: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3801: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3802: p_customer_trx_line_id;
3803:
3804: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

Line 3819: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3815: WHEN NO_DATA_FOUND THEN
3816: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3817: fnd_message.set_token('GENERIC_TEXT',
3818: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate_latin_tax');
3819: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3820: IF (g_level_statement >= g_current_runtime_level) THEN
3821: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(NO_DATA_FOUND): '||
3822: 'jl_zz_tax.calculate_latin_tax');
3823: END IF;

Line 3829: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3825: WHEN TOO_MANY_ROWS THEN
3826: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3827: fnd_message.set_token('GENERIC_TEXT',
3828: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate_latin_tax');
3829: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3830: IF (g_level_statement >= g_current_runtime_level) THEN
3831: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(TOO_MANY_ROWS): '||
3832: 'jl_zz_tax.calculate_latin_tax');
3833: END IF;

Line 3842: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3838: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3839: fnd_message.set_token('GENERIC_TEXT',
3840: 'EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3841: to_char(err_num)||' '||err_msg);
3842: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3843: IF (g_level_statement >= g_current_runtime_level) THEN
3844: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3845: to_char(err_num)||' '||err_msg);
3846: END IF;

Line 3858: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec

3854: --
3855: -- DESCRIPTION
3856: -- This routine calculates the tax amount for the transaction line or
3857: -- sales order line that is recorded in the global structure
3858: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec
3859: --
3860: -- PARAMETERS
3861: -- tax_info_rec
3862: --

Line 3868: -- ZX_PRODUCT_INTEGRATION_PKG.calculate

3864: -- tax_info_rec updated with tax_rate, amount, global_attributes and
3865: -- other information
3866: --
3867: -- CALLED FROM
3868: -- ZX_PRODUCT_INTEGRATION_PKG.calculate
3869: --
3870: -- HISTORY
3871: -- 02-OCT-97 A. Chiromatzo Return values for global flexfield just
3872: -- for AR

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

3870: -- HISTORY
3871: -- 02-OCT-97 A. Chiromatzo Return values for global flexfield just
3872: -- for AR
3873: -- 09-SEP-97 A. Chiromatzo in calculate function, first check
3874: -- if ZX_PRODUCT_INTEGRATION_PKG.TAX_INFO_REC.TAX_AMOUNT is not null, if
3875: -- it's not null then does not perform anything as it
3876: -- does not use the audit trail, avoiding error
3877: -- during delete
3878: -- 20-NOV-97 A.Chiromatzo debug messages

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

3880: -- and global_attribute9 to null in the beginning
3881: -- of the calculate_latin_tax procedure. Also,
3882: -- for base amount reduction, <= 0 condition
3883: -- replaced with < 0.
3884: -- 08-FEB-99 H. Takle Used ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 to determine
3885: -- the calling view name. Changed for bug number
3886: -- 807588. Following is the mapping for usern7.
3887: -- 1 TAX_LINES_DELETE_VBR
3888: -- 2 TAX_LINES_CREATE_VBR

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

3943:
3944: IF (g_level_statement >= g_current_runtime_level) THEN
3945: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
3946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
3947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
3948: 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);
3949: 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);
3950: END IF;
3951:

Line 3948: 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);

3944: IF (g_level_statement >= g_current_runtime_level) THEN
3945: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
3946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
3947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
3948: 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);
3949: 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);
3950: END IF;
3951:
3952: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

Line 3949: 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);

3945: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','jl_zz_tax.calculate()+');
3946: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-P- Tax category tax amount: '||
3947: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
3948: 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);
3949: 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);
3950: END IF;
3951:
3952: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
3953:

Line 3952: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;

3948: 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);
3949: 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);
3950: END IF;
3951:
3952: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
3953:
3954: -- Following code added for the bug number 1019748++
3955:
3956: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN

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

3952: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS;
3953:
3954: -- Following code added for the bug number 1019748++
3955:
3956: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
3957: l_application := 'AR';
3958: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN
3959: l_application := 'OE';
3960: END IF;

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

3954: -- Following code added for the bug number 1019748++
3955:
3956: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
3957: l_application := 'AR';
3958: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN
3959: l_application := 'OE';
3960: END IF;
3961:
3962: -- Above code added for the bug number 1019748--

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

3964: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Application: '||l_application);
3965: END IF;
3966: -- Following code added for the bug number 807588++
3967:
3968: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 = 1 THEN
3969: -- Set following variable to populate_plsql_tables to execute before
3970: -- the first tax line processing
3971: g_prev_invoice_line_number := NULL;
3972: END IF;

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

3979: -- in order to get the correct rule defined from
3980: -- jl_zz_ar_tx_rules table
3981: --
3982:
3983: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
3984: OPEN get_orig_trx_type_id_c
3985: (l_org_id,
3986: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);
3987: FETCH get_orig_trx_type_id_c INTO l_cust_trx_type_id;

Line 3986: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);

3982:
3983: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
3984: OPEN get_orig_trx_type_id_c
3985: (l_org_id,
3986: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id);
3987: FETCH get_orig_trx_type_id_c INTO l_cust_trx_type_id;
3988: CLOSE get_orig_trx_type_id_c;
3989:
3990: l_trx_type_id := l_cust_trx_type_id;

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

3989:
3990: l_trx_type_id := l_cust_trx_type_id;
3991: ELSE
3992: -- not credit memo
3993: l_trx_type_id := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id;
3994: END IF;
3995:
3996:
3997: -- The view did not get the default tax code

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

3994: END IF;
3995:
3996:
3997: -- The view did not get the default tax code
3998: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
3999: -- Raise the message populated in get_category_tax_code
4000: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4001:
4002: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN

Line 4000: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

3996:
3997: -- The view did not get the default tax code
3998: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
3999: -- Raise the message populated in get_category_tax_code
4000: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4001:
4002: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4003: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4004: sp.global_attribute14,

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

3998: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code IS NULL THEN
3999: -- Raise the message populated in get_category_tax_code
4000: v_latin_tax_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
4001:
4002: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4003: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4004: sp.global_attribute14,
4005: vt.global_attribute3,
4006: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

Line 4006: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

4002: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount IS NULL THEN
4003: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4004: sp.global_attribute14,
4005: vt.global_attribute3,
4006: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4007: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4009: NULL, 1,
4010: 0, 1,

Line 4007: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,

4003: SELECT NVL(vt.amount_includes_tax_flag,'N'),
4004: sp.global_attribute14,
4005: vt.global_attribute3,
4006: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4007: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4009: NULL, 1,
4010: 0, 1,
4011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))

Line 4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,

4004: sp.global_attribute14,
4005: vt.global_attribute3,
4006: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4007: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4009: NULL, 1,
4010: 0, 1,
4011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4012: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,

Line 4011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))

4007: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.base_currency_code, 1,
4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4009: NULL, 1,
4010: 0, 1,
4011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4012: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,
4013: v_use_legal_message,
4014: v_legal_message_exception,
4015: l_exchange_rate

Line 4012: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,

4008: decode(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate,
4009: NULL, 1,
4010: 0, 1,
4011: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_exchange_rate))
4012: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,
4013: v_use_legal_message,
4014: v_legal_message_exception,
4015: l_exchange_rate
4016: FROM ar_vat_tax vt,

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

4014: v_legal_message_exception,
4015: l_exchange_rate
4016: FROM ar_vat_tax vt,
4017: ar_system_parameters_all sp
4018: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4019: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4020:
4021: --BugFix 2180174 commented the Following IF condition.
4022: /*

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

4019: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4020:
4021: --BugFix 2180174 commented the Following IF condition.
4022: /*
4023: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL AND
4024: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN
4025: IF (g_level_statement >= g_current_runtime_level) THEN
4026: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4027: END IF;

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

4020:
4021: --BugFix 2180174 commented the Following IF condition.
4022: /*
4023: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL AND
4024: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN
4025: IF (g_level_statement >= g_current_runtime_level) THEN
4026: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4027: END IF;
4028: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 4039: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);

4035:
4036: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Use Legal Message: '||v_use_legal_message);
4037: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Exchange Rate: '||to_char(l_exchange_rate));
4038: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes tax flag: '||
4039: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag);
4040: END IF;
4041:
4042: SELECT NVL(global_attribute1,'DEFAULT')
4043: INTO l_organization_class

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

4041:
4042: SELECT NVL(global_attribute1,'DEFAULT')
4043: INTO l_organization_class
4044: FROM hr_locations_all
4045: where location_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4;
4046:
4047: IF (g_level_statement >= g_current_runtime_level) THEN
4048: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);
4049: END IF;

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

4048: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);
4049: END IF;
4050:
4051:
4052: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 is NOT NULL THEN
4053: IF (g_level_statement >= g_current_runtime_level) THEN
4054:
4055: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4056: to_char(l_trx_type_id));

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

4054:
4055: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4056: to_char(l_trx_type_id));
4057: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax Category Id: '||
4058: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
4059: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Contributor Type: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8);
4060: END IF;
4061:
4062: l_legal_message8 := NULL;

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

4055: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Trx Type Id: '||
4056: to_char(l_trx_type_id));
4057: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax Category Id: '||
4058: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1));
4059: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Contributor Type: '||ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8);
4060: END IF;
4061:
4062: l_legal_message8 := NULL;
4063: l_legal_message9 := NULL;

Line 4064: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,

4060: END IF;
4061:
4062: l_legal_message8 := NULL;
4063: l_legal_message9 := NULL;
4064: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

Line 4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

4061:
4062: l_legal_message8 := NULL;
4063: l_legal_message9 := NULL;
4064: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

Line 4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

4063: l_legal_message9 := NULL;
4064: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

Line 4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

4064: get_rule_legal_message (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

Line 4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

4065: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

Line 4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,

4066: l_trx_type_id,
4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

Line 4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

4067: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,

Line 4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

4068: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

4069: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

Line 4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

4070: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4071: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4072: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),

Line 4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

4073: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

Line 4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4074: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

Line 4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

4075: l_application,
4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *

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

4076: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),

Line 4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

4077: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

Line 4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

4078: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

Line 4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *

4079: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

Line 4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),

4080: to_number(ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10),
4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

Line 4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

4081: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4089: v_use_legal_message,

Line 4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

4082: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4089: v_use_legal_message,
4090: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

Line 4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

4083: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount *
4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4089: v_use_legal_message,
4090: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4091: v_legal_message_exception,

Line 4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

4084: (1 + (nvl(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,0)/100)),
4085: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4089: v_use_legal_message,
4090: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4091: v_legal_message_exception,
4092: v_rule_id,

Line 4090: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

4086: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4087: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4088: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4089: v_use_legal_message,
4090: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4091: v_legal_message_exception,
4092: v_rule_id,
4093: l_legal_message8,
4094: l_legal_message9);

Line 4103: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,

4099: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Legal Message 2: '|| l_legal_message9);
4100: END IF;
4101: END IF;
4102:
4103: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4104: v_rule_id,
4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

Line 4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,

4101: END IF;
4102:
4103: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4104: v_rule_id,
4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

Line 4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,

4102:
4103: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4104: v_rule_id,
4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

Line 4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,

4103: calculate_latin_tax (ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1,
4104: v_rule_id,
4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,

Line 4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,

4104: v_rule_id,
4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

Line 4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,

4105: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2,
4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

Line 4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,

4106: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date,
4107: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf8,
4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

Line 4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,

4108: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf3,
4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

Line 4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,

4109: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf5,
4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

Line 4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,

4110: --ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_type_id,
4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,

Line 4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,

4111: l_trx_type_id,
4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

Line 4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,

4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_site_use_id,
4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

Line 4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,

4113: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_site_use_id,
4114: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.inventory_item_id,
4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

Line 4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,

4115: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id,
4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

Line 4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,

4116: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_to_cust_id,
4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

Line 4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,

4117: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.bill_to_cust_id,
4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,

Line 4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,

4118: l_application,
4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,

Line 4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,

4119: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.ship_from_warehouse_id,
4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,

Line 4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,

4120: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2,
4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,

Line 4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,

4121: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4,
4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,

Line 4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,

4122: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9,
4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,

Line 4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,

4123: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id,
4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

Line 4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,

4124: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.location_structure_id,
4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,

Line 4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,

4125: ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.global_attribute10,
4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,
4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,

Line 4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,

4126: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.entered_amount,
4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,
4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4134: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

Line 4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,

4127: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_id,
4128: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id,
4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,
4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4134: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4135: v_base_amount,

Line 4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,

4129: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5,
4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,
4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4134: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4135: v_base_amount,
4136: v_tax_amount,
4137: v_latin_tax_return_code,

Line 4134: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,

4130: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_id,
4131: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6,
4132: l_organization_class,
4133: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate,
4134: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3,
4135: v_base_amount,
4136: v_tax_amount,
4137: v_latin_tax_return_code,
4138: v_calculated_tax_amount,

Line 4141: IF v_latin_tax_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN

4137: v_latin_tax_return_code,
4138: v_calculated_tax_amount,
4139: l_exchange_rate);
4140:
4141: IF v_latin_tax_return_code <> ZX_PRODUCT_INTEGRATION_PKG.TAX_SUCCESS THEN
4142: RAISE ERROR_FROM_FUNCTION;
4143: END IF;
4144:
4145: IF (g_level_statement >= g_current_runtime_level) THEN

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

4150: END IF;
4151:
4152: -- CR 3571797. Assign Unrounded Tax Amount to tax_info_rec for E-Business Tax
4153: -- requirement on LTE Tax Lines to simplify migration process of LTE.
4154: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_tax_amt := v_tax_amount;
4155:
4156: -- associate values in tax_info_rec and in global_attributes
4157: -- original rounding procedure
4158: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round

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

4154: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_tax_amt := v_tax_amount;
4155:
4156: -- associate values in tax_info_rec and in global_attributes
4157: -- original rounding procedure
4158: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4159: (v_tax_amount,
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

Line 4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,

4156: -- associate values in tax_info_rec and in global_attributes
4157: -- original rounding procedure
4158: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4159: (v_tax_amount,
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4164: 'Y');

Line 4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,

4157: -- original rounding procedure
4158: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4159: (v_tax_amount,
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4164: 'Y');
4165:

Line 4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,

4158: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount := ZX_PRODUCT_INTEGRATION_PKG.tax_curr_round
4159: (v_tax_amount,
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4164: 'Y');
4165:
4166: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,

4159: (v_tax_amount,
4160: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_currency_code,
4161: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.precision,
4162: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.minimum_accountable_unit,
4163: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule,
4164: 'Y');
4165:
4166: IF (g_level_statement >= g_current_runtime_level) THEN
4167: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax category tax amount after rounding: '||

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

4164: 'Y');
4165:
4166: IF (g_level_statement >= g_current_runtime_level) THEN
4167: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Tax category tax amount after rounding: '||
4168: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount));
4169: END IF;
4170: -- set the global flexfield context according to product 'AR'
4171: IF l_application = 'AR' THEN
4172: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null);

Line 4180: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

4176: END IF;
4177:
4178: IF l_country_code = 'BR' THEN --Bug 2367111
4179: --IF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') = 'BR' THEN
4180: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4181: 'JL.BR.ARXTWMAI.Additional Info';
4182: ELSIF l_country_code IN ('AR','CO') THEN --Bug 2367111
4183: --ELSIF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') IN ('AR','CO') THEN
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

Line 4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=

4180: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4181: 'JL.BR.ARXTWMAI.Additional Info';
4182: ELSIF l_country_code IN ('AR','CO') THEN --Bug 2367111
4183: --ELSIF fnd_profile.value_wnps('JGZZ_COUNTRY_CODE') IN ('AR','CO') THEN
4184: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute_category :=
4185: 'J'||'L.'||JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)|| --Bug 2367111
4186: --'J'||'L.'||fnd_profile.value_wnps('JGZZ_COUNTRY_CODE')||
4187: '.ARXTWMAI.LINES';
4188: END IF;

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

4187: '.ARXTWMAI.LINES';
4188: END IF;
4189:
4190: -- set the default global attributes for the tax lines
4191: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4192: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=

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

4188: END IF;
4189:
4190: -- set the default global attributes for the tax lines
4191: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4192: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);

Line 4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=

4191: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4192: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:

Line 4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=

4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;

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

4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;

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

4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

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

4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=

Line 4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=

4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:

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

4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:
4209: -- Added following 1 line to take care of bug# 787259

Line 4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=

4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:
4209: -- Added following 1 line to take care of bug# 787259
4210: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;

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

4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:
4209: -- Added following 1 line to take care of bug# 787259
4210: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;
4211: END IF;
4212:
4213: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4214: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

Line 4214: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4210: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;
4211: END IF;
4212:
4213: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4214: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4215: ELSE
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4218: END IF;

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

4212:
4213: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4214: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4215: ELSE
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4218: END IF;
4219:
4220: END IF;

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

4213: IF l_legal_message8 = 'ERROR' OR l_legal_message9 = 'ERROR' THEN
4214: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4215: ELSE
4216: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := l_legal_message8;
4217: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := l_legal_message9;
4218: END IF;
4219:
4220: END IF;
4221:

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

4220: END IF;
4221:
4222: -- Following code added for Bug Number 803394++
4223:
4224: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern5 IS NOT NULL THEN
4225: l_vat_tax_id := NULL;
4226: BEGIN
4227: SELECT vat_tax_id
4228: INTO l_vat_tax_id

Line 4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code

4226: BEGIN
4227: SELECT vat_tax_id
4228: INTO l_vat_tax_id
4229: FROM ar_vat_tax
4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4234: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=

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

4227: SELECT vat_tax_id
4228: INTO l_vat_tax_id
4229: FROM ar_vat_tax
4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4234: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4235: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))

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

4229: FROM ar_vat_tax
4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4234: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4235: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4236: AND nvl(enabled_flag,'Y') = 'Y'
4237: AND nvl(tax_class,'O') = 'O';

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

4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4234: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4235: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4236: AND nvl(enabled_flag,'Y') = 'Y'
4237: AND nvl(tax_class,'O') = 'O';
4238: EXCEPTION

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

4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date
4234: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') <=
4235: nvl(end_date,to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD'))
4236: AND nvl(enabled_flag,'Y') = 'Y'
4237: AND nvl(tax_class,'O') = 'O';
4238: EXCEPTION
4239: WHEN OTHERS THEN

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

4240: l_vat_tax_id := NULL;
4241: END;
4242: IF (g_level_statement >= g_current_runtime_level) THEN
4243: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Original Vat Tax Id '||
4244: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4245: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4246: END IF;
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4248: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);

Line 4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=

4243: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Original Vat Tax Id '||
4244: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4245: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4246: END IF;
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4248: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);
4249: END IF;
4250:
4251: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines

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

4244: to_char(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id));
4245: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- New Vat Tax Id '||to_char(l_vat_tax_id));
4246: END IF;
4247: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id :=
4248: NVL(l_vat_tax_id,ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id);
4249: END IF;
4250:
4251: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines
4252: -- that are required for E-Business Tax solution and simplifies migration of LTE

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

4250:
4251: -- 11.6 Bug 3571797. Following code would populate missing columns of Tax Lines
4252: -- that are required for E-Business Tax solution and simplifies migration of LTE
4253: -- tax lines.
4254: --IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code IS NULL THEN
4255:
4256: IF (g_level_statement >= g_current_runtime_level) THEN
4257: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- populating tix information for tax_regime_code: '||
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

Line 4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

4254: --IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code IS NULL THEN
4255:
4256: IF (g_level_statement >= g_current_runtime_level) THEN
4257: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- populating tix information for tax_regime_code: '||
4258: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4259: END IF;
4260:
4261: BEGIN
4262: SELECT rate.tax_rate_id,

Line 4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,

4266: tax.tax_id,
4267: tax.tax,
4268: status.tax_status_id,
4269: status.tax_status_code
4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,

Line 4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,

4267: tax.tax,
4268: status.tax_status_id,
4269: status.tax_status_code
4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

Line 4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,

4268: status.tax_status_id,
4269: status.tax_status_code
4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,

Line 4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,

4269: status.tax_status_code
4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

Line 4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,

4270: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4278: FROM zx_rates_b rate,

Line 4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

4271: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4278: FROM zx_rates_b rate,
4279: zx_regimes_b regime,

Line 4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,

4272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_id,
4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4278: FROM zx_rates_b rate,
4279: zx_regimes_b regime,
4280: zx_taxes_b tax,

Line 4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

4273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4274: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_id,
4275: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4276: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_id,
4277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4278: FROM zx_rates_b rate,
4279: zx_regimes_b regime,
4280: zx_taxes_b tax,
4281: zx_status_b status

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

4278: FROM zx_rates_b rate,
4279: zx_regimes_b regime,
4280: zx_taxes_b tax,
4281: zx_status_b status
4282: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4283: and rate.tax_regime_code = regime.tax_regime_code
4284: and rate.tax = tax.tax
4285: and tax.tax_regime_code = rate.tax_regime_code
4286: and tax.content_owner_id = rate.content_owner_id

Line 4294: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);

4290: and status.content_owner_id = rate.content_owner_id;
4291:
4292: IF (g_level_statement >= g_current_runtime_level) THEN
4293: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Rate Code: ' ||
4294: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4295: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4297: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);

Line 4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);

4292: IF (g_level_statement >= g_current_runtime_level) THEN
4293: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Rate Code: ' ||
4294: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4295: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4297: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4299: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);

Line 4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);

4294: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code);
4295: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Regime Code: ' ||
4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4297: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4299: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);
4301: END IF;
4302:

Line 4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);

4296: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code);
4297: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax: ' ||
4298: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax);
4299: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- EBTAX- Tax Status: ' ||
4300: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code);
4301: END IF;
4302:
4303: EXCEPTION
4304: WHEN NO_DATA_FOUND THEN

Line 4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,

4307: rate.tax_rate_code,
4308: rate.tax_regime_code,
4309: rate.tax,
4310: rate.tax_status_code
4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

Line 4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,

4308: rate.tax_regime_code,
4309: rate.tax,
4310: rate.tax_status_code
4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4316: FROM zx_rates_b rate

Line 4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,

4309: rate.tax,
4310: rate.tax_status_code
4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4316: FROM zx_rates_b rate
4317: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;

Line 4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,

4310: rate.tax_status_code
4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4316: FROM zx_rates_b rate
4317: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4318:

Line 4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code

4311: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_id,
4312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rate_code,
4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4316: FROM zx_rates_b rate
4317: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4318:
4319: WHEN OTHERS THEN

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

4313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_regime_code,
4314: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax,
4315: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_status_code
4316: FROM zx_rates_b rate
4317: WHERE rate.tax_rate_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id;
4318:
4319: WHEN OTHERS THEN
4320: IF (g_level_statement >= g_current_runtime_level) THEN
4321: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(EBTAX): jl_zz_tax.calculate '||

Line 4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=

4325: END;
4326: --END IF; -- End Bug 3571797
4327:
4328: -- Populate the eBTax related columns here:
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=

Line 4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;

4326: --END IF; -- End Bug 3571797
4327:
4328: -- Populate the eBTax related columns here:
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;

Line 4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=

4327:
4328: -- Populate the eBTax related columns here:
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=

Line 4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;

4328: -- Populate the eBTax related columns here:
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;

Line 4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=

4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text1 :=
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;

Line 4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;

4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE8;
4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;

Line 4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=

4331: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text2 :=
4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;

Line 4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;

4332: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE9;
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=

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

4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.legal_justification_text3 :=
4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;

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

4334: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE10;
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=

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

4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_base_modifier_rate :=
4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=

4336: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3;
4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=

Line 4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;

4337: -- same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE12;
4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=

4338: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.cal_tax_amt := v_calculated_tax_amount;
4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=

Line 4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4339: -- Same as ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.GLOBAL_ATTRIBUTE20;
4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

Line 4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=

4340: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.unrounded_taxable_amt :=
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4348:

Line 4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_Amount;
4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4348:
4349: -- Code added for Bug Number 803394--

Line 4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=

4342: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_date :=
4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4348:
4349: -- Code added for Bug Number 803394--
4350:

Line 4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;

4343: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4344: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_determine_date :=
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4346: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_point_date :=
4347: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date;
4348:
4349: -- Code added for Bug Number 803394--
4350:
4351: IF (g_level_statement >= g_current_runtime_level) THEN

Line 4365: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;

4361: IF (g_level_unexpected >= g_current_runtime_level) THEN
4362: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');
4363: END IF;
4364: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4365: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.customer_trx_line_id;
4366:
4367: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4368: 'LINE';
4369:

Line 4374: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4370: ZX_API_PUB.add_msg(
4371: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4372:
4373:
4374: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4375:
4376: WHEN NO_DATA_FOUND THEN
4377: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4378: fnd_message.set_token('GENERIC_TEXT',

Line 4383: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4379: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4380: IF (g_level_unexpected >= g_current_runtime_level) THEN
4381: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4382: END IF;
4383: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4384:
4385: WHEN TOO_MANY_ROWS THEN
4386: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4387: fnd_message.set_token('GENERIC_TEXT',

Line 4392: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4388: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4389: IF (g_level_unexpected >= g_current_runtime_level) THEN
4390: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4391: END IF;
4392: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4393:
4394: WHEN OTHERS THEN
4395: err_num := SQLCODE;
4396: err_msg := SUBSTR(SQLERRM,1,100);

Line 4406: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);

4402: IF (g_level_unexpected >= g_current_runtime_level) THEN
4403: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(OTHERS): jl_zz_tax.calculate '||
4404: SQLCODE||' ; '||SQLERRM);
4405: END IF;
4406: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4407:
4408: END calculate;
4409:
4410: FUNCTION get_legal_message (