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 692: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (profile value) is ' || lv_profile_val);

688: FETCH c_iproc_profile INTO lv_profile_val;
689: CLOSE c_iproc_profile;
690:
691: IF v_debug_flag = 'Y' THEN
692: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (profile value) is ' || lv_profile_val);
693: END IF;
694:
695: lv_profile_val := fnd_profile.value_specific(NAME =>'JA_ACCESS_IPROC_TAX',user_id=>ln_user_id);
696:

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

694:
695: lv_profile_val := fnd_profile.value_specific(NAME =>'JA_ACCESS_IPROC_TAX',user_id=>ln_user_id);
696:
697: IF v_debug_flag = 'Y' THEN
698: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (for userid) is ' || lv_profile_val);
699: END IF;
700:
701: IF NVL(lv_profile_val,'2') = '2' Then
702: lv_profile_val := 'N';

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

704: lv_profile_val :='Y';
705: END IF;
706:
707: IF v_debug_flag = 'Y' THEN
708: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of lv_profile_val (as Y/N) is ' || lv_profile_val);
709: END IF;
710:
711: FND_FILE.put_line(fnd_file.log, 'ROI:'|| lv_tax_change_on_roi_recpts
712: ||', WMS:'||lv_tax_change_on_wms_recpts

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

725: v_receipt_modify_flag := 'N';
726: END IF;
727:
728: IF v_debug_flag = 'Y' THEN
729: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after WMS Receipts loop is ' || v_receipt_modify_flag);
730: END IF;
731:
732: /* following if condition is for Open Interface Receipts */
733: ELSIF lv_open_interace_receipt_flag = 'Y' THEN

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

739: v_receipt_modify_flag := 'N';
740: END IF;
741:
742: IF v_debug_flag = 'Y' THEN
743: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_modify_flag after Open Interface Receipts loop is ' || v_receipt_modify_flag);
744: END IF;
745:
746: ELSE
747:

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

1296: Uncommented statements which were wrongly commented.
1297:
1298: 55. 16/10/2007 rchandan for bug#6504410, File Version 120.23
1299: Issue : R12RUP04.I/ORG.QA.ST1:RTP GOING INTO ERROR FOR MFG-MFG INTRANSIT RCPT WITH VAT
1300: Fix : Few utl_file debugs were added in previous version without checking for the v_debug_flag
1301: Added the check now.
1302:
1303: 56. 16/10/2007 bgowrava for Bug#6459894, File Version 120.24
1304: removed the lv_object_name from the JAI_PROCESS_MESSAGE of JAI_EXCEPTION

Line 1368: WHERE name = 'utl_file_dir';

1364: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
1365: Value,SUBSTR (value,1,INSTR(value,',') -1))
1366: INTO v_utl_location
1367: FROM v$parameter
1368: WHERE name = 'utl_file_dir';
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: v_debug_flag := 'N';
1372: END;

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

1372: END;
1373:
1374:
1375: IF v_debug_flag = 'Y' THEN
1376: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1377: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1378: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1379: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1380: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);

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

1373:
1374:
1375: IF v_debug_flag = 'Y' THEN
1376: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1377: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1378: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1379: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1380: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1381: END IF;

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

1374:
1375: IF v_debug_flag = 'Y' THEN
1376: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1377: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1378: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1379: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1380: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1381: END IF;
1382:

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

1375: IF v_debug_flag = 'Y' THEN
1376: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1377: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1378: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1379: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1380: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1381: END IF;
1382:
1383: IF p_currency_code IS NULL THEN

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

1376: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_receipts_p3.log','A');
1377: UTL_FILE.PUT_LINE(v_myfilehandle,'************************Start************************************');
1378: UTL_FILE.PUT_LINE(v_myfilehandle,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1379: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_type is ' || p_transaction_type);
1380: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of p_transaction_id is ' || p_transaction_id);
1381: END IF;
1382:
1383: IF p_currency_code IS NULL THEN
1384: /* Bug 5243532. Added by Lakshmi Gopalsami

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

1405:
1406: END IF;
1407:
1408: IF v_debug_flag = 'Y' THEN
1409: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_currency_code is ' || v_currency_code);
1410: END IF;
1411:
1412: -- iSupplier porting
1413: If p_line_location_id IS NOT NULL then

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

1420: jai_rcv_utils_pkg.get_func_curr(p_organization_id,
1421: v_func_currency,
1422: v_gl_set_of_books_id);
1423: IF v_debug_flag = 'Y' THEN
1424: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_func_currency is ' || v_func_currency);
1425: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_gl_set_of_books_id is ' || v_gl_set_of_books_id);
1426: END IF;
1427:
1428: IF v_func_currency <> v_currency_code AND p_transaction_type <> 'MATCH' THEN

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

1421: v_func_currency,
1422: v_gl_set_of_books_id);
1423: IF v_debug_flag = 'Y' THEN
1424: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_func_currency is ' || v_func_currency);
1425: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_gl_set_of_books_id is ' || v_gl_set_of_books_id);
1426: END IF;
1427:
1428: IF v_func_currency <> v_currency_code AND p_transaction_type <> 'MATCH' THEN
1429: v_currency_conversion_rate := p_currency_conversion_rate;

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

1468: v_paddr := HEXTORAW(p_attribute15);
1469: end if;
1470:
1471: IF v_debug_flag = 'Y' THEN
1472: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_paddr is ' || v_paddr);
1473: END IF;
1474:
1475: END IF;
1476:

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

1483: v_chk_form := loc_rec.form_id_drop;
1484: END LOOP;
1485:
1486: IF v_debug_flag = 'Y' THEN
1487: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_chk_form is ' || v_chk_form);
1488: END IF;
1489:
1490: END IF;
1491:

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

1497: END IF;
1498:
1499:
1500: IF v_debug_flag = 'Y' THEN
1501: UTL_FILE.PUT_LINE(v_myfilehandle,'VIJAY2 v_express->' || v_express||', v_chk_form->'||v_chk_form);
1502: END IF;
1503:
1504: -- following if changed by Vijay Shankar for Bug# 3028040
1505: IF (v_chk_form IS NULL AND nvl(v_express, 'NONEXPRESS') = 'EXPRESS') THEN

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

1534: v_receipt_num := header_rec.receipt_num;
1535: END LOOP;
1536: ----------------------------- to retrieve receipt_source_code -------------------------------
1537: IF v_debug_flag = 'Y' THEN
1538: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_num is ' || v_receipt_num);
1539: END IF;
1540:
1541: IF p_transaction_type = 'RECEIVE' THEN
1542: FOR head_rec IN (SELECT receipt_source_code

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

1546: v_receipt_source_code := head_rec.receipt_source_code;
1547: END LOOP;
1548: END IF;
1549: IF v_debug_flag = 'Y' THEN
1550: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_receipt_source_code is ' || v_receipt_source_code);
1551: END IF;
1552: -------------------------------------------------------------------------------------------------gsr
1553: IF p_source_document_code IN ('PO', 'REQ','RMA','INVENTORY') AND /*rchandan for bug#6030615..added INVENTORY*/
1554: p_destination_type_code IN ('RECEIVING', 'INVENTORY')

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

1583: )
1584: LOOP
1585: IF p_shipment_header_id <> excise_rec.shipment_header_id THEN
1586: IF v_debug_flag = 'Y' THEN
1587: UTL_FILE.PUT_LINE(v_myfilehandle,'error 1 dup exc inv ' );
1588: END IF;
1589: errormsg:='Duplicate Excise invoice NUMBER FOR the same supplier site';
1590: RAISE_APPLICATION_ERROR (-20501, 'Duplicate Excise invoice NUMBER FOR the same supplier site');
1591: END IF;

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

1592: END LOOP;
1593: END IF; --End if for Transaction Type in RECEIVE, UNORDERED.
1594:
1595: IF v_debug_flag = 'Y' THEN
1596: UTL_FILE.PUT_LINE(v_myfilehandle,'Before UOM Cursor for Receipt ');
1597: END IF;
1598: -- End of addition by Srihari on 04-APR-2000
1599: -- Start of addition by Srihari on 30-NOV-99
1600: OPEN uom_cur(p_unit_of_measure);

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

1601: FETCH uom_cur INTO v_rcv_uom_code;
1602: CLOSE uom_cur;
1603:
1604: IF v_debug_flag = 'Y' THEN
1605: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_rcv_uom_code is ' || v_rcv_uom_code);
1606: END IF;
1607:
1608: IF p_source_document_code = 'PO' THEN
1609: --Changed by Nagaraj.s for Bug2531667

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

1668: FETCH uom_cur INTO v_po_uom_code;
1669: CLOSE uom_cur;
1670:
1671: IF v_debug_flag = 'Y' THEN
1672: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_uom_code is ' || v_po_uom_code);
1673: END IF;
1674:
1675:
1676: jai_rcv_utils_pkg.get_organization(p_shipment_line_id,

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

1676: jai_rcv_utils_pkg.get_organization(p_shipment_line_id,
1677: v_organization_id,
1678: v_item_id);
1679: IF v_debug_flag = 'Y' THEN
1680: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_organization_id is ' || v_organization_id);
1681: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_item_id is ' || v_item_id);
1682: END IF;
1683:
1684: --Pick Item Modvat Flag---------------------------------------------------------------------

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

1677: v_organization_id,
1678: v_item_id);
1679: IF v_debug_flag = 'Y' THEN
1680: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_organization_id is ' || v_organization_id);
1681: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_item_id is ' || v_item_id);
1682: END IF;
1683:
1684: --Pick Item Modvat Flag---------------------------------------------------------------------
1685: --Moved this Piece of Code from the Bottom to Ensure that Item Modvat Flag and Trading Flag

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

1697: v_item_class := mod_rec.item_class; --Added by Nagaraj.s for Bug3202319
1698: END LOOP;
1699:
1700: IF v_debug_flag = 'Y' THEN
1701: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_modvat_flag is ' || v_item_modvat_flag);
1702: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_trading_flag is ' || v_item_trading_flag);
1703: END IF;
1704: v_item_modvat_flag := NVL(v_item_modvat_flag, 'N');
1705: /* Bug 4568090. Added by Lakshmi Gopalsami

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

1698: END LOOP;
1699:
1700: IF v_debug_flag = 'Y' THEN
1701: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_modvat_flag is ' || v_item_modvat_flag);
1702: UTL_FILE.PUT_LINE(v_myfilehandle,'The value of v_item_trading_flag is ' || v_item_trading_flag);
1703: END IF;
1704: v_item_modvat_flag := NVL(v_item_modvat_flag, 'N');
1705: /* Bug 4568090. Added by Lakshmi Gopalsami
1706: Value should be 'N' and not 'M' if the value is null */

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

1745:
1746: v_uom_rate := NVL(v_uom_rate, 1);
1747:
1748: IF v_debug_flag = 'Y' THEN
1749: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_uom_rate is ' || v_uom_rate);
1750: END IF;
1751:
1752: -- End of addition by Srihari on 30-NOV-99
1753: -- Not an unordered receipt --

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

1754:
1755: Duplicate_shipment_update;
1756:
1757: IF v_debug_flag = 'Y' THEN
1758: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
1759: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
1760: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
1761: End IF;
1762: /* R12-PADDR

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

1755: Duplicate_shipment_update;
1756:
1757: IF v_debug_flag = 'Y' THEN
1758: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
1759: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
1760: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
1761: End IF;
1762: /* R12-PADDR
1763: IF v_debug_flag = 'Y' THEN

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

1756:
1757: IF v_debug_flag = 'Y' THEN
1758: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_receipt_source_code ->'||v_receipt_source_code);
1759: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, p_transaction_type ->'||p_transaction_type);
1760: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
1761: End IF;
1762: /* R12-PADDR
1763: IF v_debug_flag = 'Y' THEN
1764: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_chk_form ->'||v_chk_form);

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

1760: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_duplicate_ship ->'||v_duplicate_ship);
1761: End IF;
1762: /* R12-PADDR
1763: IF v_debug_flag = 'Y' THEN
1764: UTL_FILE.PUT_LINE(v_myfilehandle,'After Duplicate Shipment Update, v_chk_form ->'||v_chk_form);
1765: END IF;
1766: R12-PADDR */
1767: ---------- First Receipt for this line location ------------
1768:

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

1785: THEN
1786:
1787:
1788: IF v_debug_flag = 'Y' THEN
1789: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the main If Condition');
1790: UTL_FILE.PUT_LINE(v_myfilehandle,'p_source_document_code = ' || p_source_document_code);
1791: END IF;
1792:
1793: -------------------------- To retrieve po quantity -------------------------------------

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

1786:
1787:
1788: IF v_debug_flag = 'Y' THEN
1789: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the main If Condition');
1790: UTL_FILE.PUT_LINE(v_myfilehandle,'p_source_document_code = ' || p_source_document_code);
1791: END IF;
1792:
1793: -------------------------- To retrieve po quantity -------------------------------------
1794:

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

1813:
1814: IF p_source_document_code = 'RMA' THEN
1815: --Gsr
1816: IF v_debug_flag = 'Y' THEN
1817: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside the RMA Condition');
1818: END IF;
1819:
1820:
1821:

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

2026: WHERE po_header_id = p_po_header_id;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: IF v_debug_flag = 'Y' THEN
2030: UTL_FILE.PUT_LINE(v_myfilehandle,'error 2 fetch po curr ' );
2031: END IF;
2032: errormsg:='Error while fetching PO currency details :' || SQLERRM;
2033: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2034: END;

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

2038: CLOSE c_rcv_shipment_lines;
2039: /*Bug 4644524 End bduvarag*/
2040:
2041: IF v_debug_flag = 'Y' THEN
2042: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);
2043: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_rate is ' || v_po_rate);
2044: END IF;
2045: -- end addition by Aparajita for bug#2415767 on 17th june 2002
2046:

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

2039: /*Bug 4644524 End bduvarag*/
2040:
2041: IF v_debug_flag = 'Y' THEN
2042: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);
2043: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_rate is ' || v_po_rate);
2044: END IF;
2045: -- end addition by Aparajita for bug#2415767 on 17th june 2002
2046:
2047:

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

2394: END IF;
2395: -- End of addition by Srihari on 30-NOV-99
2396:
2397: IF v_debug_flag = 'Y' THEN
2398: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_modvat_flag is ' || v_tax_modvat_flag);
2399: END IF;
2400: lt_tax_modvat_flag(row_count):=v_tax_modvat_flag; --Added by walton for inclusive
2401:
2402: IF po_lines_rec.currency <> v_func_currency THEN

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

2978: IF po_lines_rec.tax_type NOT IN ('TDS', 'Modvat Recovery') THEN
2979: v_tax_total := v_tax_total + NVL(v_cor_amount * v_conv_factor, 0);
2980: END IF;
2981: IF v_debug_flag = 'Y' THEN
2982: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_tax_total is ' ||v_tax_total);
2983: END IF;
2984: END LOOP;
2985: END IF; ----Add by Kevin Cheng for bug 6853787 Mar 5, 2008
2986:

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

3026: fetch c_order_cur into v_order_header_id;
3027: close c_order_cur;
3028:
3029: if v_debug_flag = 'Y' THEN
3030: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_order_header_id is ' || v_order_header_id);
3031: end if;
3032: -- ssumaith - bug# 3657662
3033:
3034: --Changed by Nagaraj.s on 30/07/2003 for Bug#2993865

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

3104:
3105: v_uom_rate := NVL(v_uom_rate, 1);
3106:
3107: IF v_debug_flag = 'Y' THEN
3108: UTL_FILE.PUT_LINE(v_myfilehandle, ' v_uom_rate:' || v_uom_rate
3109: ||', v_line_id:' || v_line_id|| ', v_so_currency:' || v_so_currency
3110: ||', v_loc_quantity:' || v_loc_quantity||', delivery_detail_id:' || v_picking_line_id
3111: );
3112: END IF;

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

3294:
3295: END IF;
3296:
3297: IF v_debug_flag = 'Y' THEN
3298: UTL_FILE.PUT_LINE(v_myfilehandle,'Before the condition if p_transaction_type is UNORDERED ');
3299: END IF;
3300:
3301: IF p_transaction_type = 'UNORDERED'
3302: /* R12-PADDR AND v_chk_form IS NOT NULL */

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

3302: /* R12-PADDR AND v_chk_form IS NOT NULL */
3303: THEN
3304:
3305: IF v_debug_flag = 'Y' THEN
3306: UTL_FILE.PUT_LINE(v_myfilehandle,'Before set receipt flag');
3307: END IF;
3308:
3309: set_receipt_flag;
3310:

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

3308:
3309: set_receipt_flag;
3310:
3311: IF v_debug_flag = 'Y' THEN
3312: UTL_FILE.PUT_LINE(v_myfilehandle,'After set receipt flag');
3313: END IF;
3314:
3315: v_receipt_modify_flag := 'N';
3316:

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

3314:
3315: v_receipt_modify_flag := 'N';
3316:
3317: IF v_debug_flag = 'Y' THEN
3318: UTL_FILE.PUT_LINE(v_myfilehandle,'Before Insert Receipt Line Procedure');
3319: END IF;
3320:
3321: insert_receipt_line;
3322:

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

3320:
3321: insert_receipt_line;
3322:
3323: IF v_debug_flag = 'Y' THEN
3324: UTL_FILE.PUT_LINE(v_myfilehandle,'After Insert Receipt Line Procedure');
3325: END IF;
3326:
3327: END IF;
3328:

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

3397: v_cenvat_amount;
3398: close c_fetch_unclaim_cenvat;
3399:
3400: /* IF v_debug_flag = 'Y' THEN
3401: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC1. v_register_type:' || v_register_type
3402: || ', v_chk_excise:' || v_chk_excise||', v_item_modvat_flag:' || v_item_modvat_flag
3403: ||', v_item_class:' || v_item_class||', chkVat:'||ln_chk_vat );
3404: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC2. v_cenvat_claimed_ptg:' || v_cenvat_claimed_ptg
3405: ||', v_manufacturing:' || v_manufacturing ||', v_non_bonded_flag:' || v_non_bonded_delivery_flag

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

3400: /* IF v_debug_flag = 'Y' THEN
3401: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC1. v_register_type:' || v_register_type
3402: || ', v_chk_excise:' || v_chk_excise||', v_item_modvat_flag:' || v_item_modvat_flag
3403: ||', v_item_class:' || v_item_class||', chkVat:'||ln_chk_vat );
3404: UTL_FILE.PUT_LINE(v_myfilehandle,' ABC2. v_cenvat_claimed_ptg:' || v_cenvat_claimed_ptg
3405: ||', v_manufacturing:' || v_manufacturing ||', v_non_bonded_flag:' || v_non_bonded_delivery_flag
3406: ||', unclaim_flag:'||v_unclaim_cenvat_flag);
3407: END IF;*/
3408:

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

3479: */ --commented by Ramananda for Bug #4530112
3480: END IF;
3481:
3482: IF v_debug_flag = 'Y' THEN
3483: UTL_FILE.PUT_LINE(v_myfilehandle,'*********End of the Receipt taxes procedure********');
3484: UTL_FILE.FCLOSE(v_myfileHandle);
3485: END IF;
3486:
3487:

Line 3484: UTL_FILE.FCLOSE(v_myfileHandle);

3480: END IF;
3481:
3482: IF v_debug_flag = 'Y' THEN
3483: UTL_FILE.PUT_LINE(v_myfilehandle,'*********End of the Receipt taxes procedure********');
3484: UTL_FILE.FCLOSE(v_myfileHandle);
3485: END IF;
3486:
3487:
3488: /* Added by Ramananda for bug# exc_objects */