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

Line 1262: v_myfilehandle UTL_FILE.FILE_TYPE;

1258: )
1259: IS
1260:
1261: v_debug BOOLEAN; --File.Sql.35 Cbabu := false;
1262: v_myfilehandle UTL_FILE.FILE_TYPE;
1263: v_utl_file_name VARCHAR2(100); --File.Sql.35 Cbabu := 'update_57f4_on_receiving.log';
1264: v_utl_location VARCHAR2(512);
1265: v_po_uom po_line_locations_all.unit_meas_lookup_code%type;
1266:

Line 1263: v_utl_file_name VARCHAR2(100); --File.Sql.35 Cbabu := 'update_57f4_on_receiving.log';

1259: IS
1260:
1261: v_debug BOOLEAN; --File.Sql.35 Cbabu := false;
1262: v_myfilehandle UTL_FILE.FILE_TYPE;
1263: v_utl_file_name VARCHAR2(100); --File.Sql.35 Cbabu := 'update_57f4_on_receiving.log';
1264: v_utl_location VARCHAR2(512);
1265: v_po_uom po_line_locations_all.unit_meas_lookup_code%type;
1266:
1267: CURSOR c_po_uom is

Line 1617: v_utl_file_name := 'update_57f4_on_receiving.log';

1613: --------------------------------------------------------------------------------------------*/
1614:
1615: /*
1616: --File.Sql.35 Cbabu
1617: v_utl_file_name := 'update_57f4_on_receiving.log';
1618:
1619: IF v_debug THEN
1620: BEGIN
1621:

Line 1624: FROM v$parameter WHERE name = 'utl_file_dir';

1620: BEGIN
1621:
1622: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL, Value,SUBSTR (value,1,INSTR(value,',') -1))
1623: INTO v_utl_location
1624: FROM v$parameter WHERE name = 'utl_file_dir';
1625:
1626: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_utl_file_name, 'A');
1627:
1628: EXCEPTION

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

1622: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL, Value,SUBSTR (value,1,INSTR(value,',') -1))
1623: INTO v_utl_location
1624: FROM v$parameter WHERE name = 'utl_file_dir';
1625:
1626: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_utl_file_name, 'A');
1627:
1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: v_debug := FALSE;

Line 1646: jai_cmn_utils_pkg.print_log(v_utl_file_name,'START Time Stamp' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')

1642: v_tran_type := p_tran_type;
1643: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1 update receiving quantity ');
1644:
1645: IF v_debug THEN
1646: jai_cmn_utils_pkg.print_log(v_utl_file_name,'*******START Time Stamp*******' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')
1647: ||' Transaction Type is ' || v_tran_type
1648: );
1649: END IF;
1650:

Line 1666: jai_cmn_utils_pkg.print_log(v_utl_file_name,'1 line_location_id -> '|| p_po_line_location_id

1662: FETCH c_get_rcv_trans INTO v_wip_entity_id;
1663: CLOSE c_get_rcv_trans;
1664:
1665: IF v_debug THEN
1666: jai_cmn_utils_pkg.print_log(v_utl_file_name,'1 line_location_id -> '|| p_po_line_location_id
1667: ||', v_wip_entity_id -> '|| v_wip_entity_id
1668: );
1669: END IF;
1670:

Line 1677: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id

1673: CLOSE c_count_primary_57f4;
1674: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 v_count_57f4 '|| v_count_57f4);
1675:
1676: IF v_debug THEN
1677: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id
1678: ||', po_release_id -> '|| p_po_release_id ||', to_organization_id -> '|| p_to_organization_id
1679: ||', ship_to_location_id -> '|| p_ship_to_location_id ||', v_count_57f4 -> '|| v_count_57f4
1680: ||', shipment_header_id -> '|| p_shipment_header_id ||', shipment_line_id -> '|| p_shipment_line_id
1681: ||', v_tran_type -> '|| v_tran_type ||', v_received_qty -> '|| v_received_qty

Line 1707: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id

1703: close c_po_qty_cur;
1704: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 v_po_qty '|| v_po_qty );
1705:
1706: IF v_debug THEN
1707: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id
1708: ||', v_received_qty -> '|| v_received_qty
1709: ||', v_po_qty -> '|| v_po_qty
1710: );
1711: END IF;

Line 1719: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);

1715: close c_po_uom;
1716: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 v_po_uom '|| v_po_uom );
1717:
1718: IF v_debug THEN
1719: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);
1720: END IF;
1721:
1722: -- added for bug#3446045 - sriram
1723: if v_po_uom is null then

Line 1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);

1728:
1729: -- ends here additions for bug# 3446045
1730:
1731: IF v_debug THEN
1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);
1733: END IF;
1734: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.1 v_po_uom '|| v_po_uom );
1735:
1736: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.2 p_unit_of_measure '|| p_unit_of_measure);

Line 1746: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.124 v_po_uom -> '|| v_po_uom

1742: (p_item_id, NULL, NULL, NULL, NULL,
1743: p_unit_of_measure, v_po_uom);
1744:
1745: IF v_debug THEN
1746: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.124 v_po_uom -> '|| v_po_uom
1747: ||', p_unit_of_measure -> '|| p_unit_of_measure
1748: ||', v_po_to_rec_conv -> '|| nvl(v_po_to_rec_conv, -1275)
1749: );
1750: END IF;

Line 1911: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1x2 v_po_uom -> '|| v_po_uom

1907: null, null);
1908: -- p_unit_of_measure, v_to_uom);
1909:
1910: IF v_debug THEN
1911: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1x2 v_po_uom -> '|| v_po_uom
1912: ||', v_to_uom -> '|| v_to_uom
1913: ||', v_pr_to_57f4_line_conv -> '|| nvl(v_pr_to_57f4_line_conv, -1275)
1914: );
1915: END IF;

Line 1940: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id

1936: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.3 v_comp_balance_qty ' ||v_comp_balance_qty);
1937: END IF;
1938:
1939: IF v_debug THEN
1940: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id
1941: ||', line_id -> '|| each_line.line_id ||', parent_item_id -> '|| each_line.parent_item_id
1942: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1943: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1944: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom

Line 1946: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1.1 unit_of_measure -> '|| p_unit_of_measure

1942: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1943: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1944: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom
1945: );
1946: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1.1 unit_of_measure -> '|| p_unit_of_measure
1947: ||', primary_unit_of_measure -> '|| p_new_primary_unit_of_measure ||', item_id -> '|| p_item_id
1948: ||', v_temp_rcvd_qty -> '|| v_temp_rcvd_qty ||', v_received_qty -> '|| v_received_qty
1949: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1950: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type

Line 1953: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.4 v_comp_qty_pa -> '|| v_comp_qty_pa

1949: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1950: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type
1951:
1952: );
1953: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.4 v_comp_qty_pa -> '|| v_comp_qty_pa
1954: ||', v_despatch_parent_qty -> '|| v_despatch_parent_qty
1955: ||', v_comp_balance_qty -> '|| v_comp_balance_qty
1956: ||', v_pr_to_57f4_line_conv -> '|| v_pr_to_57f4_line_conv
1957: );

Line 2033: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.1 v_bal_qty -> '|| v_bal_qty

2029: );
2030: --------
2031:
2032: IF v_debug THEN
2033: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.1 v_bal_qty -> '|| v_bal_qty
2034: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '|| v_left_received_qty
2035: );
2036: END IF;
2037:

Line 2063: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.3 updatedCount -> '|| SQL%ROWCOUNT

2059: END IF;
2060: --End, Vijay Shankar for Bug# 3644845
2061:
2062: IF v_debug THEN
2063: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.3 updatedCount -> '|| SQL%ROWCOUNT
2064: ||', v_left_received_qty -> '|| v_left_received_qty
2065: );
2066: END IF;
2067:

Line 2121: UTL_FILE.fclose(v_myfilehandle);

2117:
2118: END IF;
2119:
2120: IF v_debug THEN
2121: UTL_FILE.fclose(v_myfilehandle);
2122: END IF;
2123:
2124: EXCEPTION
2125: WHEN OTHERS THEN