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 2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'STARTED the procedure ' );

2541: --------------------------------------------------------------------------------------------------------------------*/
2542: v_assessable_value_date := sysdate;
2543: ii := 1;
2544:
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'STARTED the procedure ' );
2546:
2547: /* Added by Brathod for Bug# 4400993*/
2548: /*
2549: || Start of bug 5490479

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

2550: || Added by aiyer for the bug 5490479
2551: || Get the operating unit (org_id)
2552: */
2553: p_org_id := mo_global.get_current_org_id;
2554: fnd_file.put_line(fnd_file.log, 'Operating unit p_org_id is -> '||p_org_id);
2555: /*End of bug 5490479 */
2556:
2557: p_start_order := pn_start_order;
2558: p_end_order := pn_end_order ;

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

2565: v_last_updated_by := FND_GLOBAL.USER_ID;
2566: v_last_update_login := FND_GLOBAL.LOGIN_ID;
2567: -- added by cbabu for Bug#2496481, end
2568:
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sl. No., Order Number, Header_id , line_id, line_number'
2570: ||', ship_to_site_use_id, inventory_item_id, line_quantity, uom_code'
2571: ||',warehouse_id, Line_Category_Code, reference_line_id, item_type_code'
2572: ||',original_line_reference, unit_selling_price, operating_id, org_id'
2573: ||',SOLD_TO_ORG_ID, hsdi, price_list_id, ORDER_CATEGORY_CODE, ORIG_SYS_DOCUMENT_REF'

Line 2579: 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

2575: ||',CONVERSION_RATE_DATE, ORDERED_DATE');
2576:
2577: FOR rec IN line_details1( p_start_order, p_end_order,p_ship_from_org_id, p_org_id, p_order_type_id) LOOP
2578: ------------------------------------------------------------------------
2579: 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
2580: ||', '||rec.inventory_item_id|| ', '||rec.ordered_quantity||', '||rec.order_quantity_uom|| ', '||rec.SHIP_FROM_ORG_ID
2581: ||', '||rec.Line_Category_Code||', '||rec.reference_line_id|| ', '||rec.item_type_code
2582: ||', '||rec.ORIG_SYS_LINE_REF||', '||rec.unit_selling_price||', '||rec.org_id
2583: ||', '||rec.org_id1|| ', '||rec.SOLD_TO_ORG_ID||', '||rec.hsdi

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

2622: v_operating_id := rec.org_id;
2623: v_old_assessable_value := rec.assessable_value;
2624: v_line_amount := nvl(v_line_quantity,0) * nvl(v_unit_selling_price,0);
2625:
2626: FND_FILE.PUT_LINE(FND_FILE.LOG,ii|| ', 1 v_line_amount = ' ||v_line_amount) ;
2627:
2628: v_org_id := rec.org_id1;
2629: v_customer_id := rec.sold_to_org_id;
2630:

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

2656: AND UPPER(v_order_source_type) <> 'COPY'
2657: THEN --- aaa -- if execution enters here, it means it is a return order which need not be considered for recalculation
2658: --return;
2659: null;
2660: 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);
2661: ELSIF v_line_category_code in ('ORDER') THEN --- aaa, compute assessable value
2662:
2663: /* Bug 5243532. Added by Lakshmi Gopalsami
2664: * Removed the cursor set_of_books_cur and implemented using caching logic.

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

2673: OPEN address_cur(v_ship_to_site_use_id);
2674: FETCH address_cur INTO v_address_id;
2675: CLOSE address_cur;
2676:
2677: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 3 v_address_id = '||v_address_id||', 121 v_customer_id = '||v_customer_id);
2678: -- Fetch Assessable Price List Value for the
2679: -- given Customer and Location Combination
2680: -- OPEN Get_Assessable_Value_Cur(v_customer_id, v_address_id, v_inventory_item_id, v_uom_code, v_date_ordered);
2681: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980 --added to_char*/

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

2690: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980 --added to_char*/
2691: 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
2692: FETCH Get_Assessable_Value_Cur INTO v_assessable_value, v_price_list_uom_code;
2693: CLOSE Get_Assessable_Value_Cur;
2694: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 4 v_assessable_value = '||v_assessable_value);
2695: END IF; --5
2696:
2697: 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);
2698: IF NVL(v_assessable_value,0) > 0 THEN --6

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

2693: CLOSE Get_Assessable_Value_Cur;
2694: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 4 v_assessable_value = '||v_assessable_value);
2695: END IF; --5
2696:
2697: 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);
2698: IF NVL(v_assessable_value,0) > 0 THEN --6
2699: -- If still the Assessable Value is available
2700: IF v_price_list_uom_code IS NOT NULL THEN --7
2701: 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 2701: 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);

2697: 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);
2698: IF NVL(v_assessable_value,0) > 0 THEN --6
2699: -- If still the Assessable Value is available
2700: IF v_price_list_uom_code IS NOT NULL THEN --7
2701: 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);
2702: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
2703: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
2704: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
2705: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);

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

2700: IF v_price_list_uom_code IS NOT NULL THEN --7
2701: 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);
2702: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
2703: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
2704: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
2705: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
2706: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 8 , v_conversion_rate = '||v_conversion_rate);
2707: IF nvl(v_conversion_rate, 0) <= 0 THEN --9
2708: v_conversion_rate := 0;

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

2702: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate);
2703: IF nvl(v_conversion_rate, 0) <= 0 THEN --8
2704: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 7 , v_conversion_rate = '||v_conversion_rate);
2705: INV_CONVERT.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
2706: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 8 , v_conversion_rate = '||v_conversion_rate);
2707: IF nvl(v_conversion_rate, 0) <= 0 THEN --9
2708: v_conversion_rate := 0;
2709: END IF; --9
2710: END IF; --8

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

2712:
2713: v_assessable_value := NVL(1/v_converted_rate,0) * nvl(v_assessable_value,0) * v_conversion_rate;
2714: v_assessable_amount := nvl(v_assessable_value,0) * v_line_quantity;
2715:
2716: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 9 v_assessable_amount = '||v_assessable_amount||', v_assessable_value = '||v_assessable_value);
2717: ELSE --6
2718: -- If the assessable value is not available
2719: -- then pick up the Line price for Tax Calculation
2720: v_assessable_value := NVL(v_unit_selling_price,0);

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

2718: -- If the assessable value is not available
2719: -- then pick up the Line price for Tax Calculation
2720: v_assessable_value := NVL(v_unit_selling_price,0);
2721: v_assessable_amount := v_line_amount;
2722: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 10 v_assessable_amount = '||v_assessable_amount);
2723: END IF; --6
2724:
2725: IF v_old_assessable_value <> v_assessable_value THEN ---bbb
2726:

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

2730: Close get_source_id;
2731:
2732: IF v_line_category_code in ('ORDER') THEN --11 , and V_Order_Source_Type = 'Internal'
2733:
2734: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 11');
2735: ja_in_tax_pkg.ja_in_cust_default_taxes(
2736: v_warehouse_id, v_customer_id,v_ship_to_site_use_id, v_inventory_item_id,
2737: v_header_id,v_line_id,v_tax_category_id);
2738: IF v_tax_category_id IS NULL THEN

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

2735: ja_in_tax_pkg.ja_in_cust_default_taxes(
2736: v_warehouse_id, v_customer_id,v_ship_to_site_use_id, v_inventory_item_id,
2737: v_header_id,v_line_id,v_tax_category_id);
2738: IF v_tax_category_id IS NULL THEN
2739: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 12');
2740: ja_in_tax_pkg.ja_in_org_default_taxes(v_warehouse_id, v_inventory_item_id, v_tax_category_id);
2741: ELSE --13
2742: v_line_tax_amount := v_line_amount;
2743: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);

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

2739: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 12');
2740: ja_in_tax_pkg.ja_in_org_default_taxes(v_warehouse_id, v_inventory_item_id, v_tax_category_id);
2741: ELSE --13
2742: v_line_tax_amount := v_line_amount;
2743: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);
2744: END IF; --13
2745:
2746: ja_in_tax_pkg.ja_in_calc_prec_taxes(
2747: v_transaction_name, v_tax_category_id, v_header_id, v_line_id,

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

2758:
2759: -- added by cbabu for Bug#2496481, start
2760: -- v_line_tax_amount is the OUT variable for ja_in_tax_recalc procedure which contains total tax amount for that line
2761: v_line_tax_amount := v_line_amount;
2762: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 13 = '||v_line_tax_amount);
2763: /* Added by Brathod for Bug# 4400993 */
2764: ln_vat_assessable_value := jai_general_pkg.ja_in_vat_assessable_value
2765: (
2766: p_party_id => v_customer_id ,

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

2804:
2805: END IF; ---bbb
2806: END IF; ---aaa
2807:
2808: FND_FILE.PUT_LINE(FND_FILE.LOG,ii||' 14');
2809: ------------------------------------------------------------------------
2810: v_original_system_reference := null;
2811: v_customer_id := null;
2812: v_address_id := null;

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

2856: ii := ii + 1;
2857:
2858: END LOOP;
2859: COMMIT;
2860: FND_FILE.PUT_LINE(FND_FILE.LOG,'END of the procedure JA_IN_ASSESSABLE_PRICE_CHANGE');
2861:
2862: EXCEPTION
2863: WHEN OTHERS THEN
2864: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');