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

Line 1120: v_utl_file_name VARCHAR2(50);--File.Sql.35 Cbabu := 'ja_in_po_dflt_taxes.log';

1116: -- v_tax_currency VARCHAR2(15);
1117: v_curr_conv_rate NUMBER;
1118:
1119: v_debug BOOLEAN; --File.Sql.35 Cbabu := false;
1120: v_utl_file_name VARCHAR2(50);--File.Sql.35 Cbabu := 'ja_in_po_dflt_taxes.log';
1121: v_utl_location VARCHAR2(512);
1122: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
1123:
1124: -- Bug 4513549. Added by LGOPALSA

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

1118:
1119: v_debug BOOLEAN; --File.Sql.35 Cbabu := false;
1120: v_utl_file_name VARCHAR2(50);--File.Sql.35 Cbabu := 'ja_in_po_dflt_taxes.log';
1121: v_utl_location VARCHAR2(512);
1122: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
1123:
1124: -- Bug 4513549. Added by LGOPALSA
1125: lv_tax_cnt NUMBER := 0;
1126: lv_tax_from_reqn_flag varchar2(1) := 'N';

Line 1293: v_utl_file_name := 'ja_in_po_dflt_taxes.log';

1289: v_req_conv_date := pr_new.Rate_Date;
1290: DUMMY := 1;
1291: v_loc_count := 0; --new variable for loc chk on 17-aug-00
1292: v_debug := true;
1293: v_utl_file_name := 'ja_in_po_dflt_taxes.log';
1294: -- Bug 5243532. Added by Lakshmi Gopalsami
1295: v_requisition_header_id := pr_new.requisition_header_id;
1296:
1297: IF v_debug THEN

Line 1303: WHERE name = 'utl_file_dir';

1299: pv_return_code := jai_constants.successful ;
1300: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL, Value,SUBSTR (value,1,INSTR(value,',') -1))
1301: INTO v_utl_location
1302: FROM v$parameter
1303: WHERE name = 'utl_file_dir';
1304:
1305: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_utl_file_name ,'A');
1306:
1307: EXCEPTION

Line 1305: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_utl_file_name ,'A');

1301: INTO v_utl_location
1302: FROM v$parameter
1303: WHERE name = 'utl_file_dir';
1304:
1305: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_utl_file_name ,'A');
1306:
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: v_debug := false;

Line 1317: UTL_FILE.PUT_LINE(v_myfilehandle,'********* Start Debug, TimeStamp -> '||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));

1313:
1314:
1315:
1316: IF v_debug THEN
1317: UTL_FILE.PUT_LINE(v_myfilehandle,'********* Start Debug, TimeStamp -> '||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1318: UTL_FILE.PUT_LINE(v_myfilehandle, 'reqn_line_id -> '||pr_new.Requisition_Line_Id
1319: ||', line_loc_id -> '||pr_new.line_location_Id
1320: ||', dest_org_id -> '||pr_new.Destination_Organization_Id
1321: );

Line 1318: UTL_FILE.PUT_LINE(v_myfilehandle, 'reqn_line_id -> '||pr_new.Requisition_Line_Id

1314:
1315:
1316: IF v_debug THEN
1317: UTL_FILE.PUT_LINE(v_myfilehandle,'********* Start Debug, TimeStamp -> '||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
1318: UTL_FILE.PUT_LINE(v_myfilehandle, 'reqn_line_id -> '||pr_new.Requisition_Line_Id
1319: ||', line_loc_id -> '||pr_new.line_location_Id
1320: ||', dest_org_id -> '||pr_new.Destination_Organization_Id
1321: );
1322: END IF;

Line 1340: utl_file.fclose(v_myfilehandle);

1336:
1337: /*IF pr_new.org_id IS NOT NULL THEN
1338: IF v_currency_code <> 'INR' THEN
1339: IF v_debug THEN
1340: utl_file.fclose(v_myfilehandle);
1341: END IF;
1342: RETURN;
1343: END IF;
1344: END IF;*/

Line 1403: utl_file.fclose(v_myfilehandle);

1399: CLOSE tax_override_flag_cur;
1400:
1401: IF NVL(v_override_flag,'N') = 'Y' AND v_shipment_type <> 'BLANKET' THEN
1402: IF v_debug THEN
1403: utl_file.fclose(v_myfilehandle);
1404: END IF;
1405: RETURN;
1406: END IF;
1407:

Line 1414: utl_file.fclose(v_myfilehandle);

1410:
1411: IF v_shipment_type <> 'BLANKET' THEN
1412: IF NVL(v_loc_count,0) = 0 THEN
1413: IF v_debug THEN
1414: utl_file.fclose(v_myfilehandle);
1415: END IF;
1416: RETURN;
1417: END IF;
1418:

Line 1440: utl_file.fclose(v_myfilehandle);

1436:
1437: IF pr_new.org_id IS NOT NULL THEN
1438: IF v_currency_code <> 'INR' THEN
1439: IF v_debug THEN
1440: utl_file.fclose(v_myfilehandle);
1441: END IF;
1442: RETURN;
1443: END IF;
1444:

Line 1450: UTL_FILE.PUT_LINE(v_myfilehandle,'777 jai_po_cmn_pkg.process_release_shipment ('''||'BLANKET'||''''

1446: */
1447: -- End of addition by Gsri on 07-MAR-2001
1448:
1449: if v_debug THEN
1450: UTL_FILE.PUT_LINE(v_myfilehandle,'777 jai_po_cmn_pkg.process_release_shipment ('''||'BLANKET'||''''
1451: ||','||v_src_ship_id || v_line_loc_id||',' ||v_po_line_id||',' ||v_po_hdr_id
1452: ||','||v_quantity||',' ||v_po_rel_id
1453: ||',' ||''''||TO_CHAR(v_cre_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_cre_by
1454: ||',' ||''''||TO_CHAR(v_last_upd_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_last_upd_by

Line 1482: utl_file.fclose(v_myfilehandle);

1478: v_last_upd_login );
1479:
1480: */
1481: IF v_debug THEN
1482: utl_file.fclose(v_myfilehandle);
1483: END IF;
1484:
1485: --This Return is commented by Nagaraj.s on 09/05/2002
1486: --As this is stopping insertion of Taxes into Ja_IN_Po_line_location_taxes_trg(Bug#2364148)

Line 1504: UTL_FILE.PUT_LINE(v_myfilehandle, 'pr_new.line_location_id '|| pr_new.line_location_id);

1500: select count(1) into v_line_loc_cnt from JAI_PO_LINE_LOCATIONS
1501: where line_location_id = pr_new.line_location_id;
1502:
1503: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1504: UTL_FILE.PUT_LINE(v_myfilehandle, 'pr_new.line_location_id '|| pr_new.line_location_id);
1505: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_line_loc_cnt '|| v_line_loc_cnt);
1506: END IF;
1507:
1508: -- this means multiple requisition lines are merged into a single PO Shipment line

Line 1505: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_line_loc_cnt '|| v_line_loc_cnt);

1501: where line_location_id = pr_new.line_location_id;
1502:
1503: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1504: UTL_FILE.PUT_LINE(v_myfilehandle, 'pr_new.line_location_id '|| pr_new.line_location_id);
1505: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_line_loc_cnt '|| v_line_loc_cnt);
1506: END IF;
1507:
1508: -- this means multiple requisition lines are merged into a single PO Shipment line
1509: -- so the taxes should get defaulted from SET UP's rather than carrying the reqn taxes to PO Shipment

Line 1516: UTL_FILE.PUT_LINE(v_myfilehandle, 'Into the IF Condition');

1512:
1513: IF v_line_loc_cnt > 0 THEN
1514:
1515: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1516: UTL_FILE.PUT_LINE(v_myfilehandle, 'Into the IF Condition');
1517: END IF;
1518:
1519: --START, added, Bgowrava for Bug#6084636
1520: OPEN c_get_tax_modified_flag ;

Line 1532: UTL_FILE.PUT_LINE(v_myfilehandle, 'Deleted Taxes');

1528: WHERE line_location_id = pr_new.line_location_id;
1529:
1530: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1531:
1532: UTL_FILE.PUT_LINE(v_myfilehandle, 'Deleted Taxes');
1533: END IF;
1534:
1535: OPEN c_inventory_org_id( v_ship_to_location_id );
1536: FETCH c_inventory_org_id INTO v_inventory_org_id;

Line 1565: UTL_FILE.PUT_LINE(v_myfilehandle, 'Reqn Lines Merge returning Successfully' );

1561: );
1562:
1563:
1564: IF v_debug THEN
1565: UTL_FILE.PUT_LINE(v_myfilehandle, 'Reqn Lines Merge returning Successfully' );
1566: utl_file.fclose(v_myfilehandle);
1567: END IF;
1568: END IF ;
1569: return;

Line 1566: utl_file.fclose(v_myfilehandle);

1562:
1563:
1564: IF v_debug THEN
1565: UTL_FILE.PUT_LINE(v_myfilehandle, 'Reqn Lines Merge returning Successfully' );
1566: utl_file.fclose(v_myfilehandle);
1567: END IF;
1568: END IF ;
1569: return;
1570: END IF;

Line 1591: UTL_FILE.PUT_LINE(v_myfilehandle, 'line focus id '|| v_line_focus_id);

1587: v_last_upd_login,
1588: 'I' );
1589:
1590: IF v_debug THEN
1591: UTL_FILE.PUT_LINE(v_myfilehandle, 'line focus id '|| v_line_focus_id);
1592: END IF;
1593:
1594:
1595:

Line 1606: UTL_FILE.PUT_LINE(v_myfilehandle, 'line focus id '|| v_line_focus_id);

1602: Fetch Fetch_Focus_Id_Cur_for_req INTO v_line_focus_id;
1603: Close Fetch_Focus_Id_Cur_for_req;
1604:
1605: IF v_debug THEN
1606: UTL_FILE.PUT_LINE(v_myfilehandle, 'line focus id '|| v_line_focus_id);
1607: END IF;
1608:
1609: IF v_debug THEN
1610: UTL_FILE.PUT_LINE(v_myfilehandle, '2-1 v_line_loc_cnt -> '||v_line_loc_cnt

Line 1610: UTL_FILE.PUT_LINE(v_myfilehandle, '2-1 v_line_loc_cnt -> '||v_line_loc_cnt

1606: UTL_FILE.PUT_LINE(v_myfilehandle, 'line focus id '|| v_line_focus_id);
1607: END IF;
1608:
1609: IF v_debug THEN
1610: UTL_FILE.PUT_LINE(v_myfilehandle, '2-1 v_line_loc_cnt -> '||v_line_loc_cnt
1611: );
1612: END IF;
1613:
1614: v_reqn_tax := 0; --Added by Bgowrava for Bug#8766851

Line 1633: UTL_FILE.PUT_LINE(v_myfilehandle, '2 tax_id -> '||v_taxid

1629: , v_adhoc_flag; -- Vijay Shankar for Bug# 2782356
1630: CLOSE Fetch_Mod_Cr_Cur;
1631:
1632: IF v_debug THEN
1633: UTL_FILE.PUT_LINE(v_myfilehandle, '2 tax_id -> '||v_taxid
1634: ||', v_t_curr -> '||v_t_curr
1635: ||', v_tax_amt -> '||v_tax_amt
1636: );
1637: END IF;

Line 1644: UTL_FILE.PUT_LINE(v_myfilehandle, '3 jai_cmn_utils_pkg.currency_conversion('||v_set_of_book_id

1640: IF nvl(v_adhoc_flag, 'N') = 'Y' THEN
1641: IF v_t_curr <> v_po_curr THEN
1642: -- Vijay Shankar for Bug# 2782356
1643: IF v_debug THEN
1644: UTL_FILE.PUT_LINE(v_myfilehandle, '3 jai_cmn_utils_pkg.currency_conversion('||v_set_of_book_id
1645: ||', '''||v_po_curr
1646: ||''', to_date('||v_po_conv_date
1647: ||','''||'''DD/MM/YYYY''||''), '''||v_po_conv_type
1648: ||''', '||v_po_conv_rate ||');'

Line 1653: UTL_FILE.PUT_LINE(v_myfilehandle, '5 v_curr_conv_rate -> '||v_curr_conv_rate );

1649: );
1650: END IF;
1651:
1652: IF v_debug THEN
1653: UTL_FILE.PUT_LINE(v_myfilehandle, '5 v_curr_conv_rate -> '||v_curr_conv_rate );
1654: END IF;
1655:
1656: -- as tax_currency is same as functional currency and v_curr_conv_rate contains conversion from v_po_curr to func_curr
1657: IF v_t_curr = v_currency_code THEN

Line 1662: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');

1658: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_po_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
1659:
1660: v_tax_amount := v_tax_amt / v_curr_conv_rate;
1661: IF v_debug THEN
1662: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');
1663: END IF;
1664:
1665: ELSE -- now tax_currency is not equal to functional currency, so division is fine
1666: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );

Line 1669: UTL_FILE.PUT_LINE(v_myfilehandle, '5.2 divide' );

1665: ELSE -- now tax_currency is not equal to functional currency, so division is fine
1666: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
1667: v_tax_amount := v_tax_amt * v_curr_conv_rate;
1668: IF v_debug THEN
1669: UTL_FILE.PUT_LINE(v_myfilehandle, '5.2 divide' );
1670: END IF;
1671:
1672: END IF;
1673:

Line 1844: UTL_FILE.PUT_LINE(v_myfilehandle, 'End');

1840:
1841: end if; --Added by Bgowrava for Bug#8766851
1842:
1843: IF v_debug THEN
1844: UTL_FILE.PUT_LINE(v_myfilehandle, '*******End*******');
1845: utl_file.fclose(v_myfilehandle);
1846: END IF;
1847:
1848: exception

Line 1845: utl_file.fclose(v_myfilehandle);

1841: end if; --Added by Bgowrava for Bug#8766851
1842:
1843: IF v_debug THEN
1844: UTL_FILE.PUT_LINE(v_myfilehandle, '*******End*******');
1845: utl_file.fclose(v_myfilehandle);
1846: END IF;
1847:
1848: exception
1849: when others then

Line 1851: UTL_FILE.PUT_LINE(v_myfilehandle, '4 Error in procedure, errm -> '||SQLERRM

1847:
1848: exception
1849: when others then
1850: IF v_debug THEN
1851: UTL_FILE.PUT_LINE(v_myfilehandle, '4 Error in procedure, errm -> '||SQLERRM
1852: );
1853: utl_file.fclose(v_myfilehandle);
1854: END IF;
1855: RAISE;

Line 1853: utl_file.fclose(v_myfilehandle);

1849: when others then
1850: IF v_debug THEN
1851: UTL_FILE.PUT_LINE(v_myfilehandle, '4 Error in procedure, errm -> '||SQLERRM
1852: );
1853: utl_file.fclose(v_myfilehandle);
1854: END IF;
1855: RAISE;
1856: END ARU_T1 ;
1857: