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 FND_FILE

Line 156: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);

152: where flxvsets.flex_value_set_id = flxvals.flex_value_set_id
153: and flxvsets.flex_value_set_name = 'JAINMTCH_PO_DOCUMENT_TYPES'
154: )
155: loop
156: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);
157:
158: /* For each tax category where invoice mass tax flag is set, call mass tax changes procedure*/
159: for r_tax_cat in (select tax_category_id
160: from jai_cmn_taxctg_updates

Line 192: fnd_file.put_line( fnd_file.log, 'Mass update completed for document type='|| r_doc_type.document_type);

188: --,p_dbms_output => p_dbms_output
189: );
190: end loop; /* r_tax_cat */
191:
192: fnd_file.put_line( fnd_file.log, 'Mass update completed for document type='|| r_doc_type.document_type);
193:
194: end loop; /*r_doc_type*/
195:
196: end process_tax_cat_update;

Line 856: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line

852: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
853: Reason and Fix:-
854: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
855: This parameter was previously added to debug from backend with dbms_output.
856: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
857: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
858: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
859: This can now be also enabled from conc program.
860:

Line 897: 115.3 hjujjuru 4245089 VAT Implelentationfnd_file.put_line(fnd_file.log,

893: Version Author Dependencies Comments
894: 115.2 LGOPALSA IN60106 + Added Cess tax code
895: 4146708
896:
897: 115.3 hjujjuru 4245089 VAT Implelentationfnd_file.put_line(fnd_file.log,
898: 120.3 Aiyer R12 JAI A Changed for bug 4565665. Spec and body change in jai_cmn_mtax_pkg
899: --------------------------------------------------------------------------------------------------------------------------*/
900:
901: /* Ramananda for File.Sql.35 */

Line 933: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id ||','|| p_from_date||','||p_to_date );

929: || Added by aiyer for the bug 5490479
930: || Get the operating unit (org_id)
931: */
932: ln_org_id := mo_global.get_current_org_id;
933: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id ||','|| p_from_date||','||p_to_date );
934: /*End of bug 5490479 */
935:
936: /* Ramananda for File.Sql.35 */
937:

Line 960: || and called fnd_file.put_line to register the info

956:
957: /*
958: || Start of bug 4517919
959: ||Opened the existing cursor to get the database name
960: || and called fnd_file.put_line to register the info
961: || also changed the dbms_support.start and stop trace to execute immediate alter session code
962: */
963: OPEN get_audsid;
964: FETCH get_audsid INTO v_sid, v_serial, v_spid;

Line 971: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');

967: OPEN get_dbname;
968: FETCH get_dbname INTO v_name1;
969: CLOSE get_dbname;
970:
971: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');
972:
973: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
974:
975: /*

Line 1011: fnd_file.put_line(fnd_file.log,'Input Parameters1. ln_org_id -> '|| ln_org_id||

1007:
1008: END IF;
1009:
1010: IF v_debug THEN
1011: fnd_file.put_line(fnd_file.log,'Input Parameters1. ln_org_id -> '|| ln_org_id||
1012: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
1013: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1014: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1015: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category

Line 1017: fnd_file.put_line(fnd_file.log,', p_document_no -> '||p_document_no || ', p_release_no -> '||p_release_no ||

1013: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1014: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1015: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category
1016: );
1017: fnd_file.put_line(fnd_file.log,', p_document_no -> '||p_document_no || ', p_release_no -> '||p_release_no ||
1018: ', p_document_line_no -> '||p_document_line_no || ', p_shipment_no -> '||p_shipment_no ||
1019: ', p_commit_interval -> '||p_commit_interval || ', p_override_manual_taxes -> '||p_override_manual_taxes ||
1020: ', p_process_partial -> '||p_process_partial
1021: );

Line 1092: fnd_file.put_line( fnd_file.log, 'Batch ID -> '|| v_batch_id );

1088:
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

Line 1097: 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 );
1098: END IF;
1099:
1100: --//~~~~~~~~~ Actual Code of Tax Recalculation starts from here ~~~~~~~~~//
1101:

Line 1385: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||

1381: );
1382: END IF;
1383:
1384: IF v_debug THEN
1385: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||
1386: ', PO header id -> '||shipment_rec.po_header_id||
1387: ', line id -> '|| shipment_rec.po_line_id||
1388: ', line location id -> '|| v_line_location_id||
1389: ', line focus id -> '|| shipment_rec.line_focus_id||

Line 1494: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

1490: );
1491: END IF;
1492:
1493: IF v_debug THEN
1494: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
1495: ||shipment_rec.ship_to_organization_id ||', '||shipment_rec.vendor_id
1496: ||', '||shipment_rec.vendor_site_id ||', '|| shipment_rec.item_id ||', '||shipment_rec.po_header_id
1497: ||', '||shipment_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
1498: );

Line 1514: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

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;
1516:
1517: IF v_dflt_tax_category_id IS NOT NULL THEN
1518:

Line 1564: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);

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;
1566:
1567: IF v_success IN (1, 3, 5) THEN
1568:

Line 1602: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

1598: END IF;
1599:
1600: IF v_debug THEN
1601: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
1602: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
1603: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
1604: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
1605: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
1606: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 1774: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

1770: ', Message -> '||v_message
1771: );
1772: END IF;
1773: IF v_debug THEN
1774: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
1775: ', PO hdr_id -> '||shipment_rec.po_header_id||
1776: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
1777: ', vendor_id -> '||shipment_rec.vendor_id||
1778: ', vendor_site_id -> '||shipment_rec.vendor_site_id ||

Line 1806: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

1802: ', vendor_site_id -> '||shipment_rec.vendor_site_id
1803: );
1804: END IF;
1805: IF v_debug THEN
1806: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
1807: ', PO hdr_id -> '||shipment_rec.po_header_id||
1808: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
1809: ', vendor_id -> '||shipment_rec.vendor_id||
1810: ', vendor_site_id -> '||shipment_rec.vendor_site_id

Line 1831: fnd_file.put_line(fnd_file.log,'ROLLBACK to point1, error ->'||SQLERRM );

1827: WHEN OTHERS THEN
1828: ROLLBACK TO point1;
1829:
1830: IF v_debug THEN
1831: fnd_file.put_line(fnd_file.log,'ROLLBACK to point1, error ->'||SQLERRM );
1832: END IF;
1833:
1834: IF v_message IS NULL THEN
1835: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 1946: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||

1942: ', quantity_received -> '||releases_rec.quantity_received
1943: );
1944: END IF;
1945: IF v_debug THEN
1946: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||
1947: ', PO header id -> '||releases_rec.po_header_id||
1948: ', line id -> '|| releases_rec.po_line_id||
1949: ', line location id -> '|| releases_rec.line_location_id||
1950: ', line focus id -> '|| releases_rec.line_focus_id||

Line 2059: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

2055: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2056: );
2057: END IF;
2058: IF v_debug THEN
2059: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2060: ||v_organization_id ||', '||releases_rec.vendor_id
2061: ||', '||releases_rec.vendor_site_id ||', '|| releases_rec.item_id ||', '||releases_rec.po_header_id
2062: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2063: );

Line 2079: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id );

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;
2081:
2082: IF v_dflt_tax_category_id IS NOT NULL THEN
2083:

Line 2127: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);

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;
2129:
2130: IF v_success IN (1, 3, 5) THEN
2131:

Line 2166: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

2162: END IF;
2163:
2164: IF v_debug THEN
2165: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
2166: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
2167: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
2168: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
2169: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
2170: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 2336: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2332: ', Message -> '||v_message
2333: );
2334: END IF;
2335: IF v_debug THEN
2336: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2337: ', PO hdr_id -> '||releases_rec.po_header_id||
2338: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2339: ', vendor_id -> '||releases_rec.vendor_id||
2340: ', vendor_site_id -> '||releases_rec.vendor_site_id ||

Line 2367: fnd_file.put_line(fnd_file.log, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2363: ', vendor_site_id -> '||releases_rec.vendor_site_id
2364: );
2365: END IF;
2366: IF v_debug THEN
2367: fnd_file.put_line(fnd_file.log, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2368: ', PO hdr_id -> '||releases_rec.po_header_id||
2369: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2370: ', vendor_id -> '||releases_rec.vendor_id||
2371: ', vendor_site_id -> '||releases_rec.vendor_site_id

Line 2392: fnd_file.put_line(fnd_file.log,'Rollback to point2, error -> '||SQLERRM);

2388: WHEN OTHERS THEN
2389: ROLLBACK TO point2;
2390:
2391: IF v_debug THEN
2392: fnd_file.put_line(fnd_file.log,'Rollback to point2, error -> '||SQLERRM);
2393: END IF;
2394:
2395: IF v_message IS NULL THEN
2396: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 2503: fnd_file.put_line(fnd_file.log, 'For loop 4' );

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;
2505:
2506: -- There wont be any partial receipts in this case, so No partial Case
2507:

Line 2616: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

2612: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
2613: );
2614: END IF;
2615: IF v_debug THEN
2616: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2617: ||v_organization_id ||', '||v_vendor_id
2618: ||', '||v_vendor_site_id ||', '|| reqn_rec.item_id ||', '||reqn_rec.requisition_header_id
2619: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
2620: );

Line 2644: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

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;
2646:
2647:
2648: IF v_dflt_tax_category_id IS NOT NULL THEN

Line 2694: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);

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;
2696:
2697:
2698: IF v_success IN (1, 3, 5) THEN

Line 2738: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

2734: END IF;
2735:
2736: IF v_debug THEN
2737: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
2738: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
2739: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
2740: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
2741: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
2742: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 2894: fnd_file.put_line(fnd_file.log,'No Tax Changes for Requisition No. '||reqn_rec.document_no||

2890: ', Message -> '||v_message
2891: );
2892: END IF;
2893: IF v_debug THEN
2894: fnd_file.put_line(fnd_file.log,'No Tax Changes for Requisition No. '||reqn_rec.document_no||
2895: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
2896: ', line_id -> '|| reqn_rec.requisition_line_id||
2897: ', vendor_id -> '||v_vendor_id||
2898: ', vendor_site_id -> '||v_vendor_site_id ||

Line 2925: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||

2921: ', vendor_site_id -> '||v_vendor_site_id
2922: );
2923: END IF;
2924: IF v_debug THEN
2925: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||
2926: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
2927: ', line_id -> '|| reqn_rec.requisition_line_id||
2928: ', vendor_id -> '||v_vendor_id||
2929: ', vendor_site_id -> '||v_vendor_site_id

Line 2950: fnd_file.put_line(fnd_file.log,'Rollback to POINT3, error -> '|| SQLERRM);

2946: WHEN OTHERS THEN
2947: ROLLBACK TO point3;
2948:
2949: IF v_debug THEN
2950: fnd_file.put_line(fnd_file.log,'Rollback to POINT3, error -> '|| SQLERRM);
2951: END IF;
2952:
2953: IF v_message IS NULL THEN
2954: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 2965: fnd_file.put_line(fnd_file.log,'Ex. Record Not found so inserting record');

2961:
2962: -- as advised by APARAJITA
2963: IF SQL%NOTFOUND THEN
2964: IF v_debug THEN
2965: fnd_file.put_line(fnd_file.log,'Ex. Record Not found so inserting record');
2966: END IF;
2967:
2968: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
2969: mtax_dtl_id,

Line 3052: fnd_file.put_line(fnd_file.log,'For loop3' );

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;
3054:
3055: -- v_qty_remaining := so_rec.ordered_quantity - so_rec.shipped_quantity ;
3056: -- check for Partially shipped or not. if partial then skip SO line processing

Line 3067: fnd_file.put_line(fnd_file.log,'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||

3063: ', ordered_quantity -> '||so_rec.ordered_quantity||
3064: ', shipped_quantity -> '||so_rec.shipped_quantity
3065: );
3066: IF v_debug THEN
3067: fnd_file.put_line(fnd_file.log,'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||
3068: ', SO hdr_id -> '||so_rec.header_id||
3069: ', line_id -> '|| so_rec.line_id||
3070: ', ordered_quantity -> '||so_rec.ordered_quantity||
3071: ', shipped_quantity -> '||so_rec.shipped_quantity

Line 3147: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('

3143: );
3144:
3145: END IF;
3146: IF v_debug THEN
3147: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('
3148: ||v_organization_id ||', '||so_rec.customer_id
3149: ||', '||so_rec.ship_to_org_id ||', '||so_rec.inventory_item_id ||', '||so_rec.header_id
3150: ||', '||so_rec.line_id ||', '||v_dflt_tax_category_id||' );'
3151: );

Line 3165: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

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;
3167:
3168: IF v_dflt_tax_category_id IS NOT NULL THEN
3169:

Line 3210: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);

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;
3212:
3213:
3214: IF v_success IN (1, 3, 5) THEN

Line 3223: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

3219: j := j + 1;
3220:
3221: IF v_debug THEN
3222: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
3223: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
3224: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
3225: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
3226: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
3227: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 3299: fnd_file.put_line(fnd_file.log, ' v_converted_rate -> '||v_converted_rate);

3295: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_sob_id , so_rec.currency_code,
3296: v_date_ordered , so_rec.conversion_type_code, so_rec.conversion_rate);
3297:
3298: IF v_debug THEN
3299: fnd_file.put_line(fnd_file.log, ' v_converted_rate -> '||v_converted_rate);
3300: END IF;
3301:
3302: OPEN c_address(so_rec.ship_to_org_id);
3303: FETCH c_address INTO v_address_id;

Line 3307: fnd_file.put_line(fnd_file.log, ' v_address_id -> '||v_address_id

3303: FETCH c_address INTO v_address_id;
3304: CLOSE c_address;
3305:
3306: IF v_debug THEN
3307: fnd_file.put_line(fnd_file.log, ' v_address_id -> '||v_address_id
3308: || ', customer_id -> '|| so_rec.customer_id
3309: || ', inventory_item_id -> '|| so_rec.inventory_item_id
3310: || ', order_quantity_uom -> '|| so_rec.order_quantity_uom
3311: || ', v_date_ordered -> '|| v_date_ordered

Line 3321: fnd_file.put_line(fnd_file.log, ' 1 v_assessable_value -> '|| nvl(v_assessable_value,-1) );

3317: FETCH c_get_assessable_value INTO v_assessable_value; --, v_price_list_uom_code;
3318: CLOSE c_get_assessable_value;
3319:
3320: IF v_debug THEN
3321: fnd_file.put_line(fnd_file.log, ' 1 v_assessable_value -> '|| nvl(v_assessable_value,-1) );
3322: END IF;
3323:
3324: IF v_assessable_value IS NULL THEN
3325: OPEN c_get_assessable_value(so_rec.customer_id, 0, so_rec.inventory_item_id,

Line 3332: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);

3328: CLOSE c_get_assessable_value;
3329: END IF;
3330:
3331: IF v_debug THEN
3332: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);
3333: END IF;
3334:
3335: /*
3336: IF v_assessable_value IS NULL THEN

Line 3379: fnd_file.put_line(fnd_file.log, ' ln_vat_assess_value -> '||ln_vat_assess_value);

3375: ) ;
3376:
3377:
3378: IF v_debug THEN
3379: fnd_file.put_line(fnd_file.log, ' ln_vat_assess_value -> '||ln_vat_assess_value);
3380: END IF;
3381:
3382: ln_vat_assess_amount := ln_vat_assess_value * so_rec.ordered_quantity;
3383: --ended, Harshita for bug #4245062

Line 3399: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

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 );
3401: END IF;
3402:
3403:

Line 3434: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||so_rec.order_number||

3430: ', Message -> '||v_message
3431: );
3432: END IF;
3433: IF v_debug THEN
3434: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||so_rec.order_number||
3435: ', SO hdr_id -> '||so_rec.header_id||
3436: ', line_id -> '|| so_rec.line_id||
3437: ', customer_id -> '||so_rec.customer_id||
3438: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 3466: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||

3462: ', Message -> '||v_message
3463: );
3464: END IF;
3465: IF v_debug THEN
3466: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||
3467: ', SO hdr_id -> '||so_rec.header_id||
3468: ', line_id -> '|| so_rec.line_id||
3469: ', customer_id -> '||so_rec.customer_id||
3470: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 3491: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);

3487: WHEN OTHERS THEN
3488: ROLLBACK TO point4;
3489:
3490: IF v_debug THEN
3491: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);
3492: END IF;
3493:
3494: IF v_message IS NULL THEN
3495: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 3596: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);

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;
3600:

Line 3910: fnd_file.put_line(fnd_file.log,' 3.1');

3906: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
3907: END IF;
3908:
3909: IF v_debug = 'Y' THEN
3910: fnd_file.put_line(fnd_file.log,' 3.1');
3911: END IF;
3912:
3913: RETURN;
3914: ELSIF v_manual = 'Y' AND p_success > 0 THEN

Line 3939: fnd_file.put_line(fnd_file.log,' 3.2');

3935: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
3936: END IF;
3937:
3938: IF v_debug = 'Y' THEN
3939: fnd_file.put_line(fnd_file.log,' 3.2');
3940: END IF;
3941:
3942: p_message := 'Manual taxes are attached and there is no problem in deleting the taxes';
3943: