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 294: v_myfilehandle UTL_FILE.FILE_TYPE;

290:
291: -- used for log file Generation
292: v_log_file_name VARCHAR2(50); -- := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log'; --Ramananda for File.Sql.35
293: v_utl_location VARCHAR2(512);
294: v_myfilehandle UTL_FILE.FILE_TYPE;
295:
296: --//~~~~~~~~ Declaration Section for Preprocessing of the variables ~~~~~~~~~~//
297:
298: CURSOR c_po_header( p_document_type IN VARCHAR2, p_document_no IN VARCHAR2, p_org_id IN NUMBER) IS

Line 985: WHERE name = 'utl_file_dir';

981: BEGIN
982: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
983: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location
984: FROM v$parameter
985: WHERE name = 'utl_file_dir';
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: v_debug := FALSE;

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

986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: v_debug := FALSE;
990: -- RAISE_APPLICATION_ERROR(-20000, 'ERROR: WHEN OTHERS in UTL_FILE_DIR Query');
991: END;
992: END IF;
993:
994: IF v_debug THEN

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

991: END;
992: END IF;
993:
994: IF v_debug THEN
995: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
996: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
997: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
998: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
999: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||

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

992: END IF;
993:
994: IF v_debug THEN
995: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
996: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
997: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
998: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
999: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1000: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||

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

993:
994: IF v_debug THEN
995: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
996: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start Mass Changes ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');
997: UTL_FILE.PUT_LINE(v_myfilehandle, 'Input Parameters. ln_org_id -> '|| ln_org_id||
998: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
999: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1000: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1001: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category ||

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

1089: COMMIT;
1090:
1091: IF v_debug THEN
1092: fnd_file.put_line( fnd_file.log, 'Batch ID -> '|| v_batch_id );
1093: utl_file.put_line( v_myfilehandle, 'Batch ID -> '|| v_batch_id );
1094: END IF;
1095:
1096: IF v_debug THEN
1097: fnd_file.put_line(fnd_file.log, 'Batch ID -> '|| v_batch_id );

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

1109: v_message := 'Both old and new tax category must be provided';
1110: p_err_buf := v_message;
1111:
1112: IF v_debug THEN
1113: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1114: UTL_FILE.fclose(v_myfilehandle);
1115: END IF;
1116:
1117: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

Line 1114: UTL_FILE.fclose(v_myfilehandle);

1110: p_err_buf := v_message;
1111:
1112: IF v_debug THEN
1113: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1114: UTL_FILE.fclose(v_myfilehandle);
1115: END IF;
1116:
1117: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1118:

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

1208: p_ret_code := 1;
1209: p_err_buf := v_message;
1210:
1211: IF v_debug THEN
1212: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1213: UTL_FILE.fclose(v_myfilehandle);
1214: END IF;
1215:
1216: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

Line 1213: UTL_FILE.fclose(v_myfilehandle);

1209: p_err_buf := v_message;
1210:
1211: IF v_debug THEN
1212: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1213: UTL_FILE.fclose(v_myfilehandle);
1214: END IF;
1215:
1216: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1217:

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

1326:
1327: COMMIT;
1328:
1329: IF v_debug THEN
1330: UTL_FILE.PUT_LINE(v_myfilehandle, v_message );
1331: UTL_FILE.fclose(v_myfilehandle);
1332: END IF;
1333:
1334: RETURN;

Line 1331: UTL_FILE.fclose(v_myfilehandle);

1327: COMMIT;
1328:
1329: IF v_debug THEN
1330: UTL_FILE.PUT_LINE(v_myfilehandle, v_message );
1331: UTL_FILE.fclose(v_myfilehandle);
1332: END IF;
1333:
1334: RETURN;
1335:

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

1335:
1336: END IF;
1337:
1338: IF v_debug THEN
1339: UTL_FILE.PUT_LINE(v_myfilehandle, 'before Forloop 1'||', v_org_id -> '||v_org_id
1340: ||', v_document_type -> '||v_document_type ||', p_from_date -> '||p_from_date ||', p_to_date -> '||p_to_date
1341: ||', p_supplier_id -> '||p_supplier_id ||', p_supplier_site_id -> '||p_supplier_site_id
1342: );
1343: END IF;

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

1355:
1356: BEGIN
1357:
1358: IF v_debug THEN
1359: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 1');
1360: END IF;
1361:
1362: IF shipment_rec.line_location_id IS NOT NULL AND shipment_rec.line_location_id > 0 THEN
1363: v_line_location_id := shipment_rec.line_location_id;

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

1370: shipment_rec.shipment_qty <> shipment_rec.quantity_received AND p_process_partial = 'N'
1371: THEN
1372:
1373: IF v_debug THEN
1374: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||
1375: ', PO header id -> '||shipment_rec.po_header_id||
1376: ', line id -> '|| shipment_rec.po_line_id||
1377: ', line location id -> '|| v_line_location_id||
1378: ', line focus id -> '|| shipment_rec.line_focus_id||

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

1482:
1483: END IF;
1484:
1485: IF v_debug THEN
1486: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
1487: ||shipment_rec.ship_to_organization_id ||', '||shipment_rec.vendor_id
1488: ||', '||shipment_rec.vendor_site_id ||', '|| shipment_rec.item_id ||', '||shipment_rec.po_header_id
1489: ||', '||shipment_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
1490: );

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

1507: v_dflt_tax_category_id := p_new_tax_category;
1508: END IF;
1509:
1510: IF v_debug THEN
1511: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1512: END IF;
1513: IF v_debug THEN
1514: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1515: END IF;

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

1557: );
1558: END IF;
1559:
1560: IF v_debug THEN
1561: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
1562: END IF;
1563: IF v_debug THEN
1564: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
1565: END IF;

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

1761: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1762:
1763: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated *
1764: IF v_debug THEN
1765: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
1766: ', PO hdr_id -> '||shipment_rec.po_header_id||
1767: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
1768: ', vendor_id -> '||shipment_rec.vendor_id||
1769: ', vendor_site_id -> '||shipment_rec.vendor_site_id ||

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

1794: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
1795: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1796:
1797: IF v_debug THEN
1798: 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||
1799: ', PO hdr_id -> '||shipment_rec.po_header_id||
1800: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
1801: ', vendor_id -> '||shipment_rec.vendor_id||
1802: ', vendor_site_id -> '||shipment_rec.vendor_site_id

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

1923:
1924: BEGIN
1925:
1926: IF v_debug THEN
1927: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 2');
1928: END IF;
1929:
1930: -- v_qty_remaining := releases_rec.shipment_qty - releases_rec.quantity_received;
1931: -- Check for Partially received or not, if partial then skip the PO line location processing

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

1932: IF releases_rec.quantity_received > 0 AND
1933: releases_rec.shipment_qty <> releases_rec.quantity_received AND p_process_partial = 'N'
1934: THEN
1935: IF v_debug THEN
1936: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||
1937: ', PO header id -> '||releases_rec.po_header_id||
1938: ', line id -> '|| releases_rec.po_line_id||
1939: ', line location id -> '|| releases_rec.line_location_id||
1940: ', line focus id -> '|| releases_rec.line_focus_id||

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

2048: v_sob_id := l_func_curr_det.ledger_id;
2049: END IF;
2050:
2051: IF v_debug THEN
2052: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2053: ||v_organization_id ||', '||releases_rec.vendor_id
2054: ||', '||releases_rec.vendor_site_id ||', '|| releases_rec.item_id ||', '||releases_rec.po_header_id
2055: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2056: );

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

2072: v_dflt_tax_category_id := p_new_tax_category;
2073: END IF;
2074:
2075: IF v_debug THEN
2076: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
2077: END IF;
2078: IF v_debug THEN
2079: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id );
2080: END IF;

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

2120: );
2121: END IF;
2122:
2123: IF v_debug THEN
2124: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
2125: END IF;
2126: IF v_debug THEN
2127: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
2128: END IF;

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

2323: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2324:
2325: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated
2326: IF v_debug THEN
2327: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2328: ', PO hdr_id -> '||releases_rec.po_header_id||
2329: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2330: ', vendor_id -> '||releases_rec.vendor_id||
2331: ', vendor_site_id -> '||releases_rec.vendor_site_id ||

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

2355: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2356: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2357:
2358: IF v_debug THEN
2359: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2360: ', PO hdr_id -> '||releases_rec.po_header_id||
2361: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2362: ', vendor_id -> '||releases_rec.vendor_id||
2363: ', vendor_site_id -> '||releases_rec.vendor_site_id

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

2496: LOOP
2497: BEGIN
2498:
2499: IF v_debug THEN
2500: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 4');
2501: END IF;
2502: IF v_debug THEN
2503: fnd_file.put_line(fnd_file.log, 'For loop 4' );
2504: END IF;

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

2605: v_func_curr := l_func_curr_det.currency_code;
2606: END IF;
2607:
2608: IF v_debug THEN
2609: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2610: ||v_organization_id ||', '||v_vendor_id
2611: ||', '||v_vendor_site_id ||', '|| reqn_rec.item_id ||', '||reqn_rec.requisition_header_id
2612: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
2613: );

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

2637: v_dflt_tax_category_id := p_new_tax_category;
2638: END IF;
2639:
2640: IF v_debug THEN
2641: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
2642: END IF;
2643: IF v_debug THEN
2644: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
2645: END IF;

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

2687: v_success, v_message );
2688: END IF;
2689:
2690: IF v_debug THEN
2691: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
2692: END IF;
2693: IF v_debug THEN
2694: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
2695: END IF;

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

2881: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2882:
2883: --*XYZ Write the details of the Requisition Details to the log file why the taxes were not recalculated *
2884: IF v_debug THEN
2885: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Requisition No. '||reqn_rec.document_no||
2886: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
2887: ', line_id -> '|| reqn_rec.requisition_line_id||
2888: ', vendor_id -> '||v_vendor_id||
2889: ', vendor_site_id -> '||v_vendor_site_id ||

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

2913: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2914: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2915:
2916: IF v_debug THEN
2917: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||
2918: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
2919: ', line_id -> '|| reqn_rec.requisition_line_id||
2920: ', vendor_id -> '||v_vendor_id||
2921: ', vendor_site_id -> '||v_vendor_site_id

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

3045: LOOP
3046: BEGIN
3047:
3048: IF v_debug THEN
3049: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');
3050: END IF;
3051: IF v_debug THEN
3052: fnd_file.put_line(fnd_file.log,'For loop3' );
3053: END IF;

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

3056: -- check for Partially shipped or not. if partial then skip SO line processing
3057: IF so_rec.shipped_quantity > 0 AND
3058: so_rec.ordered_quantity <> so_rec.shipped_quantity AND p_process_partial = 'N'
3059: THEN
3060: UTL_FILE.PUT_LINE(v_myfilehandle, 'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||
3061: ', SO hdr_id -> '||so_rec.header_id||
3062: ', line_id -> '|| so_rec.line_id||
3063: ', ordered_quantity -> '||so_rec.ordered_quantity||
3064: ', shipped_quantity -> '||so_rec.shipped_quantity

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

3135: v_func_curr := l_func_curr_det.currency_code;
3136: -- End for bug 5243532
3137:
3138: IF v_debug THEN
3139: UTL_FILE.PUT_LINE(v_myfilehandle, 'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('
3140: ||v_organization_id ||', '||so_rec.customer_id
3141: ||', '||so_rec.ship_to_org_id ||', '||so_rec.inventory_item_id ||', '||so_rec.header_id
3142: ||', '||so_rec.line_id ||', '||v_dflt_tax_category_id||' );'
3143: );

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

3158: v_dflt_tax_category_id := p_new_tax_category;
3159: END IF;
3160:
3161: IF v_debug THEN
3162: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3163: END IF;
3164: IF v_debug THEN
3165: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3166: END IF;

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

3203: jai_cmn_mtax_pkg.del_taxes_after_validate( 'SO', null, null, so_rec.line_id, v_success, v_message );
3204: END IF;
3205:
3206: IF v_debug THEN
3207: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
3208: END IF;
3209: IF v_debug THEN
3210: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
3211: END IF;

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

3391: );
3392: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
3393:
3394: IF v_debug THEN
3395: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
3396: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3397: END IF;
3398: IF v_debug THEN
3399: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

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

3392: -- Now v_line_tax_amount contains the total tax amount that should be kept at line level
3393:
3394: IF v_debug THEN
3395: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
3396: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3397: END IF;
3398: IF v_debug THEN
3399: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
3400: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );

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

3421: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3422:
3423: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
3424: IF v_debug THEN
3425: UTL_FILE.PUT_LINE(v_myfilehandle, 'No Tax Changes for Order No. '||so_rec.order_number||
3426: ', SO hdr_id -> '||so_rec.header_id||
3427: ', line_id -> '|| so_rec.line_id||
3428: ', customer_id -> '||so_rec.customer_id||
3429: ', site_use_id -> '||so_rec.ship_to_org_id ||

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

3453: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3454: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3455:
3456: IF v_debug THEN
3457: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||
3458: ', SO hdr_id -> '||so_rec.header_id||
3459: ', line_id -> '|| so_rec.line_id||
3460: ', customer_id -> '||so_rec.customer_id||
3461: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 3586: UTL_FILE.fclose(v_myfilehandle);

3582: -- This the final commit
3583: COMMIT;
3584:
3585: IF v_debug THEN
3586: UTL_FILE.fclose(v_myfilehandle);
3587: END IF;
3588:
3589: EXCEPTION
3590: WHEN OTHERS THEN

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

3590: WHEN OTHERS THEN
3591: ROLLBACK;
3592:
3593: IF v_debug THEN
3594: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');
3595: UTL_FILE.fclose(v_myfilehandle);
3596: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
3597: END IF;
3598: v_message := SQLERRM;

Line 3595: UTL_FILE.fclose(v_myfilehandle);

3591: ROLLBACK;
3592:
3593: IF v_debug THEN
3594: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');
3595: UTL_FILE.fclose(v_myfilehandle);
3596: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
3597: END IF;
3598: v_message := SQLERRM;
3599: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;