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.JAI_OM_TAX_PKG dependencies on FND_FILE

Line 3599: FND_FILE.PUT_LINE(FND_FILE.LOG,'STARTED the procedure ' );

3595: --------------------------------------------------------------------------------------------------------------------*/
3596: v_assessable_value_date := sysdate;
3597: ii := 1;
3598:
3599: FND_FILE.PUT_LINE(FND_FILE.LOG,'STARTED the procedure ' );
3600:
3601: /* Added by Brathod for Bug# 4400993*/
3602: /*
3603: || Start of bug 5490479

Line 3608: fnd_file.put_line(fnd_file.log, 'Operating unit p_org_id is -> '||p_org_id);

3604: || Added by aiyer for the bug 5490479
3605: || Get the operating unit (org_id)
3606: */
3607: p_org_id := mo_global.get_current_org_id;
3608: fnd_file.put_line(fnd_file.log, 'Operating unit p_org_id is -> '||p_org_id);
3609: /*End of bug 5490479 */
3610:
3611: p_start_order := pn_start_order;
3612: p_end_order := pn_end_order ;

Line 3623: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sl. No., Order Number, Header_id , line_id, line_number'

3619: v_last_updated_by := FND_GLOBAL.USER_ID;
3620: v_last_update_login := FND_GLOBAL.LOGIN_ID;
3621: -- added by cbabu for Bug#2496481, end
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sl. No., Order Number, Header_id , line_id, line_number'
3624: ||', ship_to_site_use_id, inventory_item_id, line_quantity, uom_code'
3625: ||',warehouse_id, Line_Category_Code, reference_line_id, item_type_code'
3626: ||',original_line_reference, unit_selling_price, operating_id, org_id'
3627: ||',SOLD_TO_ORG_ID, hsdi, price_list_id, ORDER_CATEGORY_CODE, ORIG_SYS_DOCUMENT_REF'

Line 3633: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||', ' || rec.order_number||', '||rec.header_id|| ', '||rec.line_id|| ', '||rec.line_number||', '||rec.SHIP_FROM_ORG_ID

3629: ||',CONVERSION_RATE_DATE, ORDERED_DATE');
3630:
3631: FOR rec IN line_details1( p_start_order, p_end_order,p_ship_from_org_id, p_org_id, p_order_type_id) LOOP
3632: ------------------------------------------------------------------------
3633: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||', ' || rec.order_number||', '||rec.header_id|| ', '||rec.line_id|| ', '||rec.line_number||', '||rec.SHIP_FROM_ORG_ID
3634: ||', '||rec.inventory_item_id|| ', '||rec.ordered_quantity||', '||rec.order_quantity_uom|| ', '||rec.SHIP_FROM_ORG_ID
3635: ||', '||rec.Line_Category_Code||', '||rec.reference_line_id|| ', '||rec.item_type_code
3636: ||', '||rec.ORIG_SYS_LINE_REF||', '||rec.unit_selling_price||', '||rec.org_id
3637: ||', '||rec.org_id1|| ', '||rec.SOLD_TO_ORG_ID||', '||rec.hsdi

Line 3680: FND_FILE.PUT_LINE(FND_FILE.LOG,ii|| ', 1 v_line_amount = ' ||v_line_amount) ;

3676: v_operating_id := rec.org_id;
3677: v_old_assessable_value := rec.assessable_value;
3678: v_line_amount := nvl(v_line_quantity,0) * nvl(v_unit_selling_price,0);
3679:
3680: FND_FILE.PUT_LINE(FND_FILE.LOG,ii|| ', 1 v_line_amount = ' ||v_line_amount) ;
3681:
3682: v_org_id := rec.org_id1;
3683: v_customer_id := rec.sold_to_org_id;
3684:

Line 3714: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||', 2 , returning v_item_type_code = '||v_item_type_code||', v_order_category = '||v_order_category||', v_reference_line_id = '||v_reference_line_id);

3710: AND UPPER(v_order_source_type) <> 'COPY'
3711: THEN --- aaa -- if execution enters here, it means it is a return order which need not be considered for recalculation
3712: --return;
3713: null;
3714: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||', 2 , returning v_item_type_code = '||v_item_type_code||', v_order_category = '||v_order_category||', v_reference_line_id = '||v_reference_line_id);
3715: ELSIF v_line_category_code in ('ORDER') THEN --- aaa, compute assessable value
3716:
3717: /* Bug 5243532. Added by Lakshmi Gopalsami
3718: * Removed the cursor set_of_books_cur and implemented using caching logic.

Line 3731: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 3 v_address_id = '||v_address_id||', 121 v_customer_id = '||v_customer_id);

3727: OPEN address_cur(v_ship_to_site_use_id);
3728: FETCH address_cur INTO v_address_id;
3729: CLOSE address_cur;
3730:
3731: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 3 v_address_id = '||v_address_id||', 121 v_customer_id = '||v_customer_id);
3732: -- Fetch Assessable Price List Value for the
3733: -- given Customer and Location Combination
3734: -- OPEN Get_Assessable_Value_Cur(v_customer_id, v_address_id, v_inventory_item_id, v_uom_code, v_date_ordered);
3735: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980 --added to_char*/

Line 3748: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 4 v_assessable_value = '||v_assessable_value);

3744: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980 --added to_char*/
3745: OPEN Get_Assessable_Value_Cur(v_customer_id, 0, to_char(v_inventory_item_id), v_uom_code, v_assessable_value_date); -- cbabu for Bug#2496494
3746: FETCH Get_Assessable_Value_Cur INTO v_assessable_value, v_price_list_uom_code;
3747: CLOSE Get_Assessable_Value_Cur;
3748: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 4 v_assessable_value = '||v_assessable_value);
3749: END IF; --5
3750:
3751: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 5 , v_assessable_value = '||v_assessable_value||', v_price_list_uom_code = '||v_price_list_uom_code);
3752: IF NVL(v_assessable_value,0) > 0 THEN --6

Line 3751: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 5 , v_assessable_value = '||v_assessable_value||', v_price_list_uom_code = '||v_price_list_uom_code);

3747: CLOSE Get_Assessable_Value_Cur;
3748: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 4 v_assessable_value = '||v_assessable_value);
3749: END IF; --5
3750:
3751: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 5 , v_assessable_value = '||v_assessable_value||', v_price_list_uom_code = '||v_price_list_uom_code);
3752: IF NVL(v_assessable_value,0) > 0 THEN --6
3753: -- If still the Assessable Value is available
3754: IF v_price_list_uom_code IS NOT NULL THEN --7
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 6 , v_uom_code = '||v_uom_code||', v_inventory_item_id = '||v_inventory_item_id||', v_conversion_rate = '||v_conversion_rate);

Line 3755: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 6 , v_uom_code = '||v_uom_code||', v_inventory_item_id = '||v_inventory_item_id||', v_conversion_rate = '||v_conversion_rate);

3751: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 5 , v_assessable_value = '||v_assessable_value||', v_price_list_uom_code = '||v_price_list_uom_code);
3752: IF NVL(v_assessable_value,0) > 0 THEN --6
3753: -- If still the Assessable Value is available
3754: IF v_price_list_uom_code IS NOT NULL THEN --7
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 6 , v_uom_code = '||v_uom_code||', v_inventory_item_id = '||v_inventory_item_id||', v_conversion_rate = '||v_conversion_rate);
3756: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
3757: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
3759: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);

Line 3758: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);

3754: IF v_price_list_uom_code IS NOT NULL THEN --7
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 6 , v_uom_code = '||v_uom_code||', v_inventory_item_id = '||v_inventory_item_id||', v_conversion_rate = '||v_conversion_rate);
3756: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
3757: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
3759: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
3760: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 8 , v_conversion_rate = '||v_conversion_rate);
3761: IF nvl(v_conversion_rate, 0) <= 0 THEN --9
3762: v_conversion_rate := 0;

Line 3760: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 8 , v_conversion_rate = '||v_conversion_rate);

3756: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
3757: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
3758: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
3759: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
3760: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 8 , v_conversion_rate = '||v_conversion_rate);
3761: IF nvl(v_conversion_rate, 0) <= 0 THEN --9
3762: v_conversion_rate := 0;
3763: END IF; --9
3764: END IF; --8

Line 3770: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 9 v_assessable_amount = '||v_assessable_amount||', v_assessable_value = '||v_assessable_value);

3766:
3767: v_assessable_value := NVL(1/v_converted_rate,0) * nvl(v_assessable_value,0) * v_conversion_rate;
3768: v_assessable_amount := nvl(v_assessable_value,0) * v_line_quantity;
3769:
3770: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 9 v_assessable_amount = '||v_assessable_amount||', v_assessable_value = '||v_assessable_value);
3771: ELSE --6
3772: -- If the assessable value is not available
3773: -- then pick up the Line price for Tax Calculation
3774: v_assessable_value := NVL(v_unit_selling_price,0);

Line 3776: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 10 v_assessable_amount = '||v_assessable_amount);

3772: -- If the assessable value is not available
3773: -- then pick up the Line price for Tax Calculation
3774: v_assessable_value := NVL(v_unit_selling_price,0);
3775: v_assessable_amount := v_line_amount;
3776: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 10 v_assessable_amount = '||v_assessable_amount);
3777: END IF; --6
3778:
3779: IF v_old_assessable_value <> v_assessable_value THEN ---bbb
3780:

Line 3788: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 11');

3784: Close get_source_id;
3785:
3786: IF v_line_category_code in ('ORDER') THEN --11 , and V_Order_Source_Type = 'Internal'
3787:
3788: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 11');
3789: ja_in_tax_pkg.ja_in_cust_default_taxes(
3790: v_warehouse_id, v_customer_id,v_ship_to_site_use_id, v_inventory_item_id,
3791: v_header_id,v_line_id,v_tax_category_id);
3792: IF v_tax_category_id IS NULL THEN

Line 3793: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 12');

3789: ja_in_tax_pkg.ja_in_cust_default_taxes(
3790: v_warehouse_id, v_customer_id,v_ship_to_site_use_id, v_inventory_item_id,
3791: v_header_id,v_line_id,v_tax_category_id);
3792: IF v_tax_category_id IS NULL THEN
3793: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 12');
3794: ja_in_tax_pkg.ja_in_org_default_taxes(v_warehouse_id, v_inventory_item_id, v_tax_category_id);
3795: ELSE --13
3796: v_line_tax_amount := v_line_amount;
3797: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);

Line 3797: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);

3793: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 12');
3794: ja_in_tax_pkg.ja_in_org_default_taxes(v_warehouse_id, v_inventory_item_id, v_tax_category_id);
3795: ELSE --13
3796: v_line_tax_amount := v_line_amount;
3797: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);
3798: END IF; --13
3799:
3800: ja_in_tax_pkg.ja_in_calc_prec_taxes(
3801: v_transaction_name, v_tax_category_id, v_header_id, v_line_id,

Line 3816: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);

3812:
3813: -- added by cbabu for Bug#2496481, start
3814: -- v_line_tax_amount is the OUT variable for ja_in_tax_recalc procedure which contains total tax amount for that line
3815: v_line_tax_amount := v_line_amount;
3816: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);
3817: /* Added by Brathod for Bug# 4400993 */
3818: ln_vat_assessable_value := jai_general_pkg.ja_in_vat_assessable_value
3819: (
3820: p_party_id => v_customer_id ,

Line 3883: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 14');

3879:
3880: END IF; ---bbb
3881: END IF; ---aaa
3882:
3883: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 14');
3884: ------------------------------------------------------------------------
3885: v_original_system_reference := null;
3886: v_customer_id := null;
3887: v_address_id := null;

Line 3935: FND_FILE.PUT_LINE(FND_FILE.LOG,'END of the procedure JA_IN_ASSESSABLE_PRICE_CHANGE');

3931: ii := ii + 1;
3932:
3933: END LOOP;
3934: COMMIT;
3935: FND_FILE.PUT_LINE(FND_FILE.LOG,'END of the procedure JA_IN_ASSESSABLE_PRICE_CHANGE');
3936:
3937: EXCEPTION
3938: WHEN OTHERS THEN
3939: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');