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

Line 129: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling

125: v_tax_base NUMBER; --File.Sql.35 Cbabu :=0;
126: v_receipt_tax NUMBER; -- this has not been assigned intentionally.
127: v_debug_flag varchar2(1); --File.Sql.35 Cbabu := 'N';
128: v_utl_location VARCHAR2(512); --For Log file.
129: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
130: -- Variables added by Aparajita on 17th june for bug#2415767
131: --Variables added by Nagaraj.s for Bug2991872.
132: v_price_override NUMBER; --File.Sql.35 Cbabu :=0;
133: v_po_quantity NUMBER; --File.Sql.35 Cbabu :=0;

Line 784: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (profile value) is ' || lv_profile_val);

780: FETCH c_iproc_profile INTO lv_profile_val;
781: CLOSE c_iproc_profile;
782:
783: IF v_debug_flag = 'Y' THEN
784: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (profile value) is ' || lv_profile_val);
785: END IF;
786:
787: lv_profile_val := fnd_profile.value_specific(NAME =>'JA_ACCESS_IPROC_TAX',user_id=>ln_user_id);
788:

Line 790: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (for userid) is ' || lv_profile_val);

786:
787: lv_profile_val := fnd_profile.value_specific(NAME =>'JA_ACCESS_IPROC_TAX',user_id=>ln_user_id);
788:
789: IF v_debug_flag = 'Y' THEN
790: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (for userid) is ' || lv_profile_val);
791: END IF;
792:
793: IF NVL(lv_profile_val,'2') = '2' Then
794: lv_profile_val := 'N';

Line 800: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (as Y/N) is ' || lv_profile_val);

796: lv_profile_val :='Y';
797: END IF;
798:
799: IF v_debug_flag = 'Y' THEN
800: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (as Y/N) is ' || lv_profile_val);
801: END IF;
802:
803: FND_FILE.put_line(fnd_file.log, 'ROI:'|| lv_tax_change_on_roi_recpts
804: ||', WMS:'||lv_tax_change_on_wms_recpts

Line 821: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after WMS Receipts loop is ' || v_receipt_modify_flag);

817: v_receipt_modify_flag := 'N';
818: END IF;
819:
820: IF v_debug_flag = 'Y' THEN
821: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after WMS Receipts loop is ' || v_receipt_modify_flag);
822: END IF;
823:
824: /* following if condition is for Open Interface Receipts */
825: ELSIF lv_open_interace_receipt_flag = 'Y' THEN

Line 835: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after Open Interface Receipts loop is ' || v_receipt_modify_flag);

831: v_receipt_modify_flag := 'N';
832: END IF;
833:
834: IF v_debug_flag = 'Y' THEN
835: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after Open Interface Receipts loop is ' || v_receipt_modify_flag);
836: END IF;
837:
838: ELSE
839:

Line 1392: Fix : Few utl_file debugs were added in previous version without checking for the v_debug_flag

1388: Uncommented statements which were wrongly commented.
1389:
1390: 55. 16/10/2007 rchandan for bug#6504410, File Version 120.23
1391: Issue : R12RUP04.I/ORG.QA.ST1:RTP GOING INTO ERROR FOR MFG-MFG INTRANSIT RCPT WITH VAT
1392: Fix : Few utl_file debugs were added in previous version without checking for the v_debug_flag
1393: Added the check now.
1394:
1395: 56. 16/10/2007 bgowrava for Bug#6459894, File Version 120.24
1396: removed the lv_object_name from the JAI_PROCESS_MESSAGE of JAI_EXCEPTION

Line 1574: WHERE name = 'utl_file_dir';

1570: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
1571: Value,SUBSTR (value,1,INSTR(value,',') -1))
1572: INTO v_utl_location
1573: FROM v$parameter
1574: WHERE name = 'utl_file_dir';
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: v_debug_flag := 'N';
1578: END;

Line 1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');

1578: END;
1579:
1580:
1581: IF v_debug_flag = 'Y' THEN
1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1583: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);

Line 1583: UTL_FILE.PUT_LINE(v_myfilehandle,'Start************');

1579:
1580:
1581: IF v_debug_flag = 'Y' THEN
1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1583: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1587: END IF;

Line 1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));

1580:
1581: IF v_debug_flag = 'Y' THEN
1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1583: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1587: END IF;
1588:

Line 1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);

1581: IF v_debug_flag = 'Y' THEN
1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1583: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1587: END IF;
1588:
1589: IF p_currency_code IS NULL THEN

Line 1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);

1582: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1583: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1584: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1585: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1586: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1587: END IF;
1588:
1589: IF p_currency_code IS NULL THEN
1590: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 1615: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_currency_code is ' || v_currency_code);

1611:
1612: END IF;
1613:
1614: IF v_debug_flag = 'Y' THEN
1615: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_currency_code is ' || v_currency_code);
1616: END IF;
1617:
1618: -- iSupplier porting
1619: If p_line_location_id IS NOT NULL then

Line 1630: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_func_currency is ' || v_func_currency);

1626: jai_rcv_utils_pkg.get_func_curr(p_organization_id,
1627: v_func_currency,
1628: v_gl_set_of_books_id);
1629: IF v_debug_flag = 'Y' THEN
1630: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_func_currency is ' || v_func_currency);
1631: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_gl_set_of_books_id is ' || v_gl_set_of_books_id);
1632: END IF;
1633:
1634: IF v_func_currency <> v_currency_code AND p_transaction_type <> 'MATCH' THEN

Line 1631: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_gl_set_of_books_id is ' || v_gl_set_of_books_id);

1627: v_func_currency,
1628: v_gl_set_of_books_id);
1629: IF v_debug_flag = 'Y' THEN
1630: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_func_currency is ' || v_func_currency);
1631: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_gl_set_of_books_id is ' || v_gl_set_of_books_id);
1632: END IF;
1633:
1634: IF v_func_currency <> v_currency_code AND p_transaction_type <> 'MATCH' THEN
1635: v_currency_conversion_rate := p_currency_conversion_rate;

Line 1688: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_paddr is ' || v_paddr);

1684: v_paddr := HEXTORAW(p_attribute15);
1685: end if;
1686:
1687: IF v_debug_flag = 'Y' THEN
1688: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_paddr is ' || v_paddr);
1689: END IF;
1690:
1691: END IF;
1692:

Line 1703: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_chk_form is ' || v_chk_form);

1699: v_chk_form := loc_rec.form_id_drop;
1700: END LOOP;
1701:
1702: IF v_debug_flag = 'Y' THEN
1703: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_chk_form is ' || v_chk_form);
1704: END IF;
1705:
1706: END IF;
1707:

Line 1717: UTL_FILE.PUT_LINE(v_myfilehandle,'VIJAY2 v_express->' || v_express||', v_chk_form->'||v_chk_form);

1713: END IF;
1714:
1715:
1716: IF v_debug_flag = 'Y' THEN
1717: UTL_FILE.PUT_LINE(v_myfilehandle,'VIJAY2 v_express->' || v_express||', v_chk_form->'||v_chk_form);
1718: END IF;
1719:
1720: -- following if changed by Vijay Shankar for Bug# 3028040
1721: IF (v_chk_form IS NULL AND nvl(v_express, 'NONEXPRESS') = 'EXPRESS') THEN

Line 1754: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_num is ' || v_receipt_num);

1750: v_receipt_num := header_rec.receipt_num;
1751: END LOOP;
1752: ----------------------------- to retrieve receipt_source_code -------------------------------
1753: IF v_debug_flag = 'Y' THEN
1754: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_num is ' || v_receipt_num);
1755: END IF;
1756:
1757: IF p_transaction_type = 'RECEIVE' THEN
1758: FOR head_rec IN (SELECT receipt_source_code

Line 1766: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_source_code is ' || v_receipt_source_code);

1762: v_receipt_source_code := head_rec.receipt_source_code;
1763: END LOOP;
1764: END IF;
1765: IF v_debug_flag = 'Y' THEN
1766: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_source_code is ' || v_receipt_source_code);
1767: END IF;
1768: -------------------------------------------------------------------------------------------------gsr
1769: IF p_source_document_code IN ('PO', 'REQ','RMA','INVENTORY') AND /*rchandan for bug#6030615..added INVENTORY*/
1770: p_destination_type_code IN ('RECEIVING', 'INVENTORY')

Line 1803: UTL_FILE.PUT_LINE(v_myfilehandle,'error 1 dup exc inv ' );

1799: )
1800: LOOP
1801: IF p_shipment_header_id <> excise_rec.shipment_header_id THEN
1802: IF v_debug_flag = 'Y' THEN
1803: UTL_FILE.PUT_LINE(v_myfilehandle,'error 1 dup exc inv ' );
1804: END IF;
1805: errormsg:='Duplicate Excise invoice NUMBER FOR the same supplier site';
1806: RAISE_APPLICATION_ERROR (-20501, 'Duplicate Excise invoice NUMBER FOR the same supplier site');
1807: END IF;

Line 1812: UTL_FILE.PUT_LINE(v_myfilehandle,'Before UOM Cursor for Receipt ');

1808: END LOOP;
1809: END IF; --End if for Transaction Type in RECEIVE, UNORDERED.
1810:
1811: IF v_debug_flag = 'Y' THEN
1812: UTL_FILE.PUT_LINE(v_myfilehandle,'Before UOM Cursor for Receipt ');
1813: END IF;
1814: -- End of addition by Srihari on 04-APR-2000
1815: -- Start of addition by Srihari on 30-NOV-99
1816: OPEN uom_cur(p_unit_of_measure);

Line 1821: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_rcv_uom_code is ' || v_rcv_uom_code);

1817: FETCH uom_cur INTO v_rcv_uom_code;
1818: CLOSE uom_cur;
1819:
1820: IF v_debug_flag = 'Y' THEN
1821: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_rcv_uom_code is ' || v_rcv_uom_code);
1822: END IF;
1823:
1824: IF p_source_document_code = 'PO' THEN
1825: --Changed by Nagaraj.s for Bug2531667

Line 1896: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_uom_code is ' || v_po_uom_code);

1892:
1893: end if;
1894: --end bug#10086567
1895: IF v_debug_flag = 'Y' THEN
1896: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_uom_code is ' || v_po_uom_code);
1897: END IF;
1898:
1899:
1900: jai_rcv_utils_pkg.get_organization(p_shipment_line_id,

Line 1904: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_organization_id is ' || v_organization_id);

1900: jai_rcv_utils_pkg.get_organization(p_shipment_line_id,
1901: v_organization_id,
1902: v_item_id);
1903: IF v_debug_flag = 'Y' THEN
1904: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_organization_id is ' || v_organization_id);
1905: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_item_id is ' || v_item_id);
1906: END IF;
1907:
1908: --Pick Item Modvat Flag---------------------------------------------------------------------

Line 1905: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_item_id is ' || v_item_id);

1901: v_organization_id,
1902: v_item_id);
1903: IF v_debug_flag = 'Y' THEN
1904: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_organization_id is ' || v_organization_id);
1905: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_item_id is ' || v_item_id);
1906: END IF;
1907:
1908: --Pick Item Modvat Flag---------------------------------------------------------------------
1909: --Moved this Piece of Code from the Bottom to Ensure that Item Modvat Flag and Trading Flag

Line 1925: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_modvat_flag is ' || v_item_modvat_flag);

1921: v_item_class := mod_rec.item_class; --Added by Nagaraj.s for Bug3202319
1922: END LOOP;
1923:
1924: IF v_debug_flag = 'Y' THEN
1925: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_modvat_flag is ' || v_item_modvat_flag);
1926: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_trading_flag is ' || v_item_trading_flag);
1927: END IF;
1928: v_item_modvat_flag := NVL(v_item_modvat_flag, 'N');
1929: /* Bug 4568090. Added by Lakshmi Gopalsami

Line 1926: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_trading_flag is ' || v_item_trading_flag);

1922: END LOOP;
1923:
1924: IF v_debug_flag = 'Y' THEN
1925: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_modvat_flag is ' || v_item_modvat_flag);
1926: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_trading_flag is ' || v_item_trading_flag);
1927: END IF;
1928: v_item_modvat_flag := NVL(v_item_modvat_flag, 'N');
1929: /* Bug 4568090. Added by Lakshmi Gopalsami
1930: Value should be 'N' and not 'M' if the value is null */

Line 1995: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_uom_rate is ' || v_uom_rate);

1991: v_uom_rate := NVL(v_uom_rate, 1);
1992: jai_cmn_utils_pkg.write_fnd_log_msg('jai_rcv_trx_prc.process_begin',' The Value of v_uom_rate is'||v_uom_rate);
1993:
1994: IF v_debug_flag = 'Y' THEN
1995: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_uom_rate is ' || v_uom_rate);
1996: END IF;
1997:
1998: -- End of addition by Srihari on 30-NOV-99
1999: -- Not an unordered receipt --

Line 2004: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);

2000:
2001: Duplicate_shipment_update;
2002:
2003: IF v_debug_flag = 'Y' THEN
2004: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
2005: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
2006: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
2007: End IF;
2008: /* R12-PADDR

Line 2005: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);

2001: Duplicate_shipment_update;
2002:
2003: IF v_debug_flag = 'Y' THEN
2004: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
2005: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
2006: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
2007: End IF;
2008: /* R12-PADDR
2009: IF v_debug_flag = 'Y' THEN

Line 2006: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);

2002:
2003: IF v_debug_flag = 'Y' THEN
2004: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
2005: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
2006: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
2007: End IF;
2008: /* R12-PADDR
2009: IF v_debug_flag = 'Y' THEN
2010: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_chk_form ->'||v_chk_form);

Line 2010: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_chk_form ->'||v_chk_form);

2006: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
2007: End IF;
2008: /* R12-PADDR
2009: IF v_debug_flag = 'Y' THEN
2010: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_chk_form ->'||v_chk_form);
2011: END IF;
2012: R12-PADDR */
2013: ---------- First Receipt for this line location ------------
2014:

Line 2035: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the main If Condition');

2031: THEN
2032:
2033:
2034: IF v_debug_flag = 'Y' THEN
2035: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the main If Condition');
2036: UTL_FILE.PUT_LINE(v_myfilehandle,'p_source_document_code = ' || p_source_document_code);
2037: END IF;
2038:
2039: -------------------------- To retrieve po quantity -------------------------------------

Line 2036: UTL_FILE.PUT_LINE(v_myfilehandle,'p_source_document_code = ' || p_source_document_code);

2032:
2033:
2034: IF v_debug_flag = 'Y' THEN
2035: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the main If Condition');
2036: UTL_FILE.PUT_LINE(v_myfilehandle,'p_source_document_code = ' || p_source_document_code);
2037: END IF;
2038:
2039: -------------------------- To retrieve po quantity -------------------------------------
2040:

Line 2063: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the RMA Condition');

2059:
2060: IF p_source_document_code = 'RMA' THEN
2061: --Gsr
2062: IF v_debug_flag = 'Y' THEN
2063: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the RMA Condition');
2064: END IF;
2065:
2066:
2067:

Line 2276: UTL_FILE.PUT_LINE(v_myfilehandle,'error 2 fetch po curr ' );

2272: WHERE po_header_id = p_po_header_id;
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: IF v_debug_flag = 'Y' THEN
2276: UTL_FILE.PUT_LINE(v_myfilehandle,'error 2 fetch po curr ' );
2277: END IF;
2278: errormsg:='Error while fetching PO currency details :' || SQLERRM;
2279: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2280: END;

Line 2288: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);

2284: CLOSE c_rcv_shipment_lines;
2285: /*Bug 4644524 End bduvarag*/
2286:
2287: IF v_debug_flag = 'Y' THEN
2288: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);
2289: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_rate is ' || v_po_rate);
2290: END IF;
2291: -- end addition by Aparajita for bug#2415767 on 17th june 2002
2292:

Line 2289: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_rate is ' || v_po_rate);

2285: /*Bug 4644524 End bduvarag*/
2286:
2287: IF v_debug_flag = 'Y' THEN
2288: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);
2289: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_rate is ' || v_po_rate);
2290: END IF;
2291: -- end addition by Aparajita for bug#2415767 on 17th june 2002
2292:
2293:

Line 2829: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_modvat_flag is ' || v_tax_modvat_flag);

2825: END IF;
2826: -- End of addition by Srihari on 30-NOV-99
2827:
2828: IF v_debug_flag = 'Y' THEN
2829: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_modvat_flag is ' || v_tax_modvat_flag);
2830: END IF;
2831: lt_tax_modvat_flag(row_count):=v_tax_modvat_flag; --Added by walton for inclusive
2832:
2833: IF po_lines_rec.currency <> v_func_currency THEN

Line 4116: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_total is ' ||v_tax_total);

4112: -- v_tax_total := v_tax_total + NVL(v_cor_amount * v_conv_factor, 0); -- Commneted out by shyan for bug 10100899 on 12-Nov-2010
4113: v_tax_total := v_tax_total + NVL(v_cor_amount / v_conv_factor, 0); -- Added by shyan for bug 10100899 on 12-Nov-2010
4114: END IF;
4115: IF v_debug_flag = 'Y' THEN
4116: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_total is ' ||v_tax_total);
4117: END IF;
4118: END LOOP;
4119: END IF; ----Add by Kevin Cheng for bug 6853787 Mar 5, 2008
4120:

Line 4164: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_order_header_id is ' || v_order_header_id);

4160: fetch c_order_cur into v_order_header_id;
4161: close c_order_cur;
4162:
4163: if v_debug_flag = 'Y' THEN
4164: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_order_header_id is ' || v_order_header_id);
4165: end if;
4166: -- ssumaith - bug# 3657662
4167:
4168: --Changed by Nagaraj.s on 30/07/2003 for Bug#2993865

Line 4242: UTL_FILE.PUT_LINE(v_myfilehandle, ' v_uom_rate:' || v_uom_rate

4238:
4239: v_uom_rate := NVL(v_uom_rate, 1);
4240:
4241: IF v_debug_flag = 'Y' THEN
4242: UTL_FILE.PUT_LINE(v_myfilehandle, ' v_uom_rate:' || v_uom_rate
4243: ||', v_line_id:' || v_line_id|| ', v_so_currency:' || v_so_currency
4244: ||', v_loc_quantity:' || v_loc_quantity||', delivery_detail_id:' || v_picking_line_id
4245: );
4246: END IF;

Line 4432: UTL_FILE.PUT_LINE(v_myfilehandle,'Before the condition if p_transaction_type is UNORDERED ');

4428:
4429: END IF;
4430:
4431: IF v_debug_flag = 'Y' THEN
4432: UTL_FILE.PUT_LINE(v_myfilehandle,'Before the condition if p_transaction_type is UNORDERED ');
4433: END IF;
4434:
4435: IF p_transaction_type = 'UNORDERED'
4436: /* R12-PADDR AND v_chk_form IS NOT NULL */

Line 4440: UTL_FILE.PUT_LINE(v_myfilehandle,'Before set receipt flag');

4436: /* R12-PADDR AND v_chk_form IS NOT NULL */
4437: THEN
4438:
4439: IF v_debug_flag = 'Y' THEN
4440: UTL_FILE.PUT_LINE(v_myfilehandle,'Before set receipt flag');
4441: END IF;
4442:
4443: set_receipt_flag;
4444:

Line 4446: UTL_FILE.PUT_LINE(v_myfilehandle,'After set receipt flag');

4442:
4443: set_receipt_flag;
4444:
4445: IF v_debug_flag = 'Y' THEN
4446: UTL_FILE.PUT_LINE(v_myfilehandle,'After set receipt flag');
4447: END IF;
4448:
4449: -- v_receipt_modify_flag := 'N'; /*Commented by nprashar for bug # 9797881 */
4450:

Line 4452: UTL_FILE.PUT_LINE(v_myfilehandle,'Before Insert Receipt Line Procedure');

4448:
4449: -- v_receipt_modify_flag := 'N'; /*Commented by nprashar for bug # 9797881 */
4450:
4451: IF v_debug_flag = 'Y' THEN
4452: UTL_FILE.PUT_LINE(v_myfilehandle,'Before Insert Receipt Line Procedure');
4453: END IF;
4454:
4455: insert_receipt_line;
4456:

Line 4458: UTL_FILE.PUT_LINE(v_myfilehandle,'After Insert Receipt Line Procedure');

4454:
4455: insert_receipt_line;
4456:
4457: IF v_debug_flag = 'Y' THEN
4458: UTL_FILE.PUT_LINE(v_myfilehandle,'After Insert Receipt Line Procedure');
4459: END IF;
4460:
4461: END IF;
4462:

Line 4535: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC1. v_register_type:' || v_register_type

4531: v_cenvat_amount;
4532: close c_fetch_unclaim_cenvat;
4533:
4534: /* IF v_debug_flag = 'Y' THEN
4535: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC1. v_register_type:' || v_register_type
4536: || ', v_chk_excise:' || v_chk_excise||', v_item_modvat_flag:' || v_item_modvat_flag
4537: ||', v_item_class:' || v_item_class||', chkVat:'||ln_chk_vat );
4538: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC2. v_cenvat_claimed_ptg:' || v_cenvat_claimed_ptg
4539: ||', v_manufacturing:' || v_manufacturing ||', v_non_bonded_flag:' || v_non_bonded_delivery_flag

Line 4538: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC2. v_cenvat_claimed_ptg:' || v_cenvat_claimed_ptg

4534: /* IF v_debug_flag = 'Y' THEN
4535: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC1. v_register_type:' || v_register_type
4536: || ', v_chk_excise:' || v_chk_excise||', v_item_modvat_flag:' || v_item_modvat_flag
4537: ||', v_item_class:' || v_item_class||', chkVat:'||ln_chk_vat );
4538: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC2. v_cenvat_claimed_ptg:' || v_cenvat_claimed_ptg
4539: ||', v_manufacturing:' || v_manufacturing ||', v_non_bonded_flag:' || v_non_bonded_delivery_flag
4540: ||', unclaim_flag:'||v_unclaim_cenvat_flag);
4541: END IF;*/
4542:

Line 4617: UTL_FILE.PUT_LINE(v_myfilehandle,'*End of the Receipt taxes procedure');

4613: */ --commented by Ramananda for Bug #4530112
4614: END IF;
4615:
4616: IF v_debug_flag = 'Y' THEN
4617: UTL_FILE.PUT_LINE(v_myfilehandle,'*********End of the Receipt taxes procedure********');
4618: UTL_FILE.FCLOSE(v_myfileHandle);
4619: END IF;
4620:
4621:

Line 4618: UTL_FILE.FCLOSE(v_myfileHandle);

4614: END IF;
4615:
4616: IF v_debug_flag = 'Y' THEN
4617: UTL_FILE.PUT_LINE(v_myfilehandle,'*********End of the Receipt taxes procedure********');
4618: UTL_FILE.FCLOSE(v_myfileHandle);
4619: END IF;
4620:
4621:
4622: /* Added by Ramananda for bug# exc_objects */