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_CMN_MTAX_PKG dependencies on UTL_FILE

Line 335: v_myfilehandle UTL_FILE.FILE_TYPE;

331:
332: -- used for log file Generation
333: v_log_file_name VARCHAR2(50); -- := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log'; --Ramananda for File.Sql.35
334: v_utl_location VARCHAR2(512);
335: v_myfilehandle UTL_FILE.FILE_TYPE;
336:
337: --//~~~~~~~~ Declaration Section for Preprocessing of the variables ~~~~~~~~~~//
338:
339: CURSOR c_po_header( p_document_type IN VARCHAR2, p_document_no IN VARCHAR2, p_org_id IN NUMBER) IS

Line 1335: WHERE name = 'utl_file_dir';

1331: BEGIN
1332: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
1333: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location
1334: FROM v$parameter
1335: WHERE name = 'utl_file_dir';
1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: v_debug := FALSE;

Line 1340: -- RAISE_APPLICATION_ERROR(-20000, 'ERROR: WHEN OTHERS in UTL_FILE_DIR Query');

1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: v_debug := FALSE;
1340: -- RAISE_APPLICATION_ERROR(-20000, 'ERROR: WHEN OTHERS in UTL_FILE_DIR Query');
1341: END;
1342: END IF;
1343:
1344: IF v_debug THEN

Line 1345: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');

1341: END;
1342: END IF;
1343:
1344: IF v_debug THEN
1345: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
1346: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
1347: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
1348: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
1349: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||

Line 1346: UTL_FILE.PUT_LINE(v_myfilehandle, '* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *');

1342: END IF;
1343:
1344: IF v_debug THEN
1345: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
1346: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
1347: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
1348: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
1349: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1350: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||

Line 1347: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||

1343:
1344: IF v_debug THEN
1345: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
1346: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
1347: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
1348: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
1349: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1350: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1351: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category ||

Line 1447: utl_file.put_line( v_myfilehandle, 'Batch ID -> '|| v_batch_id );

1443: COMMIT;
1444:
1445: IF v_debug THEN
1446: fnd_file.put_line( fnd_file.log, 'Batch ID -> '|| v_batch_id );
1447: utl_file.put_line( v_myfilehandle, 'Batch ID -> '|| v_batch_id );
1448: END IF;
1449:
1450: IF v_debug THEN
1451: fnd_file.put_line(fnd_file.log, 'Batch ID -> '|| v_batch_id );

Line 1467: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);

1463: v_message := 'Both old and new tax category must be provided';
1464: p_err_buf := v_message;
1465:
1466: IF v_debug THEN
1467: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1468: UTL_FILE.fclose(v_myfilehandle);
1469: END IF;
1470:
1471: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

Line 1468: UTL_FILE.fclose(v_myfilehandle);

1464: p_err_buf := v_message;
1465:
1466: IF v_debug THEN
1467: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1468: UTL_FILE.fclose(v_myfilehandle);
1469: END IF;
1470:
1471: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1472:

Line 1573: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);

1569: p_ret_code := 1;
1570: p_err_buf := v_message;
1571:
1572: IF v_debug THEN
1573: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1574: UTL_FILE.fclose(v_myfilehandle);
1575: END IF;
1576:
1577: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

Line 1574: UTL_FILE.fclose(v_myfilehandle);

1570: p_err_buf := v_message;
1571:
1572: IF v_debug THEN
1573: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1574: UTL_FILE.fclose(v_myfilehandle);
1575: END IF;
1576:
1577: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1578:

Line 1729: UTL_FILE.PUT_LINE(v_myfilehandle, v_message );

1725:
1726: COMMIT;
1727:
1728: IF v_debug THEN
1729: UTL_FILE.PUT_LINE(v_myfilehandle, v_message );
1730: UTL_FILE.fclose(v_myfilehandle);
1731: END IF;
1732:
1733: RETURN;

Line 1730: UTL_FILE.fclose(v_myfilehandle);

1726: COMMIT;
1727:
1728: IF v_debug THEN
1729: UTL_FILE.PUT_LINE(v_myfilehandle, v_message );
1730: UTL_FILE.fclose(v_myfilehandle);
1731: END IF;
1732:
1733: RETURN;
1734:

Line 1738: UTL_FILE.PUT_LINE(v_myfilehandle, 'before Forloop 1'||', v_org_id -> '||v_org_id

1734:
1735: END IF;
1736:
1737: IF v_debug THEN
1738: UTL_FILE.PUT_LINE(v_myfilehandle, 'before Forloop 1'||', v_org_id -> '||v_org_id
1739: ||', v_document_type -> '||v_document_type ||', p_from_date -> '||p_from_date ||', p_to_date -> '||p_to_date
1740: ||', p_supplier_id -> '||p_supplier_id ||', p_supplier_site_id -> '||p_supplier_site_id
1741: );
1742: END IF;

Line 1758: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 1');

1754:
1755: BEGIN
1756:
1757: IF v_debug THEN
1758: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 1');
1759: END IF;
1760:
1761: IF shipment_rec.line_location_id IS NOT NULL AND shipment_rec.line_location_id > 0 THEN
1762: v_line_location_id := shipment_rec.line_location_id;

Line 1773: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||

1769: shipment_rec.shipment_qty <> shipment_rec.quantity_received AND p_process_partial = 'N'
1770: THEN
1771:
1772: IF v_debug THEN
1773: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||
1774: ', PO header id -> '||shipment_rec.po_header_id||
1775: ', line id -> '|| shipment_rec.po_line_id||
1776: ', line location id -> '|| v_line_location_id||
1777: ', line focus id -> '|| shipment_rec.line_focus_id||

Line 1889: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

1885:
1886: END IF;
1887:
1888: IF v_debug THEN
1889: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
1890: ||shipment_rec.ship_to_organization_id ||', '||shipment_rec.vendor_id
1891: ||', '||shipment_rec.vendor_site_id ||', '|| shipment_rec.item_id ||', '||shipment_rec.po_header_id
1892: ||', '||shipment_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
1893: );

Line 1914: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

1910: v_dflt_tax_category_id := p_new_tax_category;
1911: END IF;
1912:
1913: IF v_debug THEN
1914: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1915: END IF;
1916: IF v_debug THEN
1917: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1918: END IF;

Line 1964: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);

1960: );
1961: END IF;
1962:
1963: IF v_debug THEN
1964: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
1965: END IF;
1966: IF v_debug THEN
1967: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
1968: END IF;

Line 2184: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

2180: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2181:
2182: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated *
2183: IF v_debug THEN
2184: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
2185: ', PO hdr_id -> '||shipment_rec.po_header_id||
2186: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
2187: ', vendor_id -> '||shipment_rec.vendor_id||
2188: ', vendor_site_id -> '||shipment_rec.vendor_site_id ||

Line 2217: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

2213: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2214: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2215:
2216: IF v_debug THEN
2217: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
2218: ', PO hdr_id -> '||shipment_rec.po_header_id||
2219: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
2220: ', vendor_id -> '||shipment_rec.vendor_id||
2221: ', vendor_site_id -> '||shipment_rec.vendor_site_id

Line 2351: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 2');

2347:
2348: BEGIN
2349:
2350: IF v_debug THEN
2351: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 2');
2352: END IF;
2353:
2354: -- v_qty_remaining := releases_rec.shipment_qty - releases_rec.quantity_received;
2355: -- Check for Partially received or not, if partial then skip the PO line location processing

Line 2360: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||

2356: IF releases_rec.quantity_received > 0 AND
2357: releases_rec.shipment_qty <> releases_rec.quantity_received AND p_process_partial = 'N'
2358: THEN
2359: IF v_debug THEN
2360: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||
2361: ', PO header id -> '||releases_rec.po_header_id||
2362: ', line id -> '|| releases_rec.po_line_id||
2363: ', line location id -> '|| releases_rec.line_location_id||
2364: ', line focus id -> '|| releases_rec.line_focus_id||

Line 2480: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

2476: v_sob_id := l_func_curr_det.ledger_id;
2477: END IF;
2478:
2479: IF v_debug THEN
2480: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2481: ||v_organization_id ||', '||releases_rec.vendor_id
2482: ||', '||releases_rec.vendor_site_id ||', '|| releases_rec.item_id ||', '||releases_rec.po_header_id
2483: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2484: );

Line 2504: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

2500: v_dflt_tax_category_id := p_new_tax_category;
2501: END IF;
2502:
2503: IF v_debug THEN
2504: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
2505: END IF;
2506: IF v_debug THEN
2507: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id );
2508: END IF;

Line 2552: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);

2548: );
2549: END IF;
2550:
2551: IF v_debug THEN
2552: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
2553: END IF;
2554: IF v_debug THEN
2555: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
2556: END IF;

Line 2772: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2768: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2769:
2770: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated
2771: IF v_debug THEN
2772: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2773: ', PO hdr_id -> '||releases_rec.po_header_id||
2774: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2775: ', vendor_id -> '||releases_rec.vendor_id||
2776: ', vendor_site_id -> '||releases_rec.vendor_site_id ||

Line 2804: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2800: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2801: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2802:
2803: IF v_debug THEN
2804: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2805: ', PO hdr_id -> '||releases_rec.po_header_id||
2806: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2807: ', vendor_id -> '||releases_rec.vendor_id||
2808: ', vendor_site_id -> '||releases_rec.vendor_site_id

Line 2950: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 4');

2946: LOOP
2947: BEGIN
2948:
2949: IF v_debug THEN
2950: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 4');
2951: END IF;
2952: IF v_debug THEN
2953: fnd_file.put_line(fnd_file.log, 'For loop 4' );
2954: END IF;

Line 3063: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

3059: v_func_curr := l_func_curr_det.currency_code;
3060: END IF;
3061:
3062: IF v_debug THEN
3063: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
3064: ||v_organization_id ||', '||v_vendor_id
3065: ||', '||v_vendor_site_id ||', '|| reqn_rec.item_id ||', '||reqn_rec.requisition_header_id
3066: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
3067: );

Line 3095: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

3091: v_dflt_tax_category_id := p_new_tax_category;
3092: END IF;
3093:
3094: IF v_debug THEN
3095: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3096: END IF;
3097: IF v_debug THEN
3098: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3099: END IF;

Line 3145: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);

3141: v_success, v_message );
3142: END IF;
3143:
3144: IF v_debug THEN
3145: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
3146: END IF;
3147: IF v_debug THEN
3148: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
3149: END IF;

Line 3354: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Requisition No. '||reqn_rec.document_no||

3350: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3351:
3352: --*XYZ Write the details of the Requisition Details to the log file why the taxes were not recalculated *
3353: IF v_debug THEN
3354: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Requisition No. '||reqn_rec.document_no||
3355: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
3356: ', line_id -> '|| reqn_rec.requisition_line_id||
3357: ', vendor_id -> '||v_vendor_id||
3358: ', vendor_site_id -> '||v_vendor_site_id ||

Line 3386: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||

3382: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3383: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3384:
3385: IF v_debug THEN
3386: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||
3387: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
3388: ', line_id -> '|| reqn_rec.requisition_line_id||
3389: ', vendor_id -> '||v_vendor_id||
3390: ', vendor_site_id -> '||v_vendor_site_id

Line 3523: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');

3519: LOOP
3520: BEGIN
3521:
3522: IF v_debug THEN
3523: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');
3524: END IF;
3525: IF v_debug THEN
3526: fnd_file.put_line(fnd_file.log,'For loop3' );
3527: END IF;

Line 3534: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||

3530: -- check for Partially shipped or not. if partial then skip SO line processing
3531: IF so_rec.shipped_quantity > 0 AND
3532: so_rec.ordered_quantity <> so_rec.shipped_quantity AND p_process_partial = 'N'
3533: THEN
3534: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||
3535: ', SO hdr_id -> '||so_rec.header_id||
3536: ', line_id -> '|| so_rec.line_id||
3537: ', ordered_quantity -> '||so_rec.ordered_quantity||
3538: ', shipped_quantity -> '||so_rec.shipped_quantity

Line 3617: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('

3613: v_func_curr := l_func_curr_det.currency_code;
3614: -- End for bug 5243532
3615:
3616: IF v_debug THEN
3617: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('
3618: ||v_organization_id ||', '||so_rec.customer_id
3619: ||', '||so_rec.ship_to_org_id ||', '||so_rec.inventory_item_id ||', '||so_rec.header_id
3620: ||', '||so_rec.line_id ||', '||v_dflt_tax_category_id||' );'
3621: );

Line 3649: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

3645: END IF;
3646:
3647:
3648: IF v_debug THEN
3649: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3650: END IF;
3651: IF v_debug THEN
3652: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3653: END IF;

Line 3694: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);

3690: jai_cmn_mtax_pkg.del_taxes_after_validate( 'SO', null, null, so_rec.line_id, v_success, v_message );
3691: END IF;
3692:
3693: IF v_debug THEN
3694: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
3695: END IF;
3696: IF v_debug THEN
3697: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
3698: END IF;

Line 3983: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );

3979: );
3980: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
3981:
3982: IF v_debug THEN
3983: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
3984: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3985: END IF;
3986: IF v_debug THEN
3987: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

Line 3984: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );

3980: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
3981:
3982: IF v_debug THEN
3983: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
3984: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3985: END IF;
3986: IF v_debug THEN
3987: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
3988: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );

Line 4014: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||so_rec.order_number||

4010: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4011:
4012: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
4013: IF v_debug THEN
4014: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||so_rec.order_number||
4015: ', SO hdr_id -> '||so_rec.header_id||
4016: ', line_id -> '|| so_rec.line_id||
4017: ', customer_id -> '||so_rec.customer_id||
4018: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 4046: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||

4042: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4043: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4044:
4045: IF v_debug THEN
4046: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||
4047: ', SO hdr_id -> '||so_rec.header_id||
4048: ', line_id -> '|| so_rec.line_id||
4049: ', customer_id -> '||so_rec.customer_id||
4050: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 4198: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');

4194: LOOP
4195: BEGIN
4196:
4197: IF v_debug THEN
4198: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');
4199: END IF;
4200: IF v_debug THEN
4201: fnd_file.put_line(fnd_file.log,'For loop3' );
4202: END IF;

Line 4276: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

4272: v_dflt_tax_category_id := p_new_tax_category;
4273: END IF;
4274:
4275: IF v_debug THEN
4276: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
4277: END IF;
4278: IF v_debug THEN
4279: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
4280: END IF;

Line 4318: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);

4314: jai_cmn_mtax_pkg.del_taxes_after_validate( 'BOE', null, null, boe_rec.boe_detail_id, v_success, v_message );
4315: END IF;
4316:
4317: IF v_debug THEN
4318: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
4319: END IF;
4320: IF v_debug THEN
4321: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
4322: END IF;

Line 4465: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );

4461:
4462: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
4463:
4464: IF v_debug THEN
4465: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
4466: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
4467: END IF;
4468: IF v_debug THEN
4469: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

Line 4466: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );

4462: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
4463:
4464: IF v_debug THEN
4465: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
4466: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
4467: END IF;
4468: IF v_debug THEN
4469: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
4470: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );

Line 4574: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for BOE id. '||boe_rec.boe_id||

4570: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4571:
4572: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
4573: IF v_debug THEN
4574: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for BOE id. '||boe_rec.boe_id||
4575: ', boe_detail_id -> '|| boe_rec.boe_detail_id||
4576: ', Message -> '||v_message
4577: );
4578: END IF;

Line 4599: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - BOE id. '||boe_rec.boe_id||

4595: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4596: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4597:
4598: IF v_debug THEN
4599: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - BOE id. '||boe_rec.boe_id||
4600: ', boe_detail_id -> '|| boe_rec.boe_detail_id||
4601: ', Message -> '||v_message
4602: );
4603: END IF;

Line 4733: UTL_FILE.fclose(v_myfilehandle);

4729: -- This the final commit
4730: COMMIT;
4731:
4732: IF v_debug THEN
4733: UTL_FILE.fclose(v_myfilehandle);
4734: END IF;
4735:
4736: EXCEPTION
4737: WHEN OTHERS THEN

Line 4741: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');

4737: WHEN OTHERS THEN
4738: ROLLBACK;
4739:
4740: IF v_debug THEN
4741: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');
4742: UTL_FILE.fclose(v_myfilehandle);
4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
4744: END IF;
4745: v_message := SQLERRM;

Line 4742: UTL_FILE.fclose(v_myfilehandle);

4738: ROLLBACK;
4739:
4740: IF v_debug THEN
4741: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');
4742: UTL_FILE.fclose(v_myfilehandle);
4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
4744: END IF;
4745: v_message := SQLERRM;
4746: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;