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.INV_LABEL dependencies on WMS_LABEL_REQUESTS

Line 1375: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table

1371:
1372:
1373: -- This procedure is to write label xml data into LABEL_XML.log
1374: -- This is not used anymore from Patchset I (11.5.9) because
1375: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table
1376: PROCEDURE writeIntoFile(xml LONG) IS
1377: l_dir VARCHAR2(128);
1378: l_debug_trace NUMBER;
1379: l_file_name VARCHAR2(100) := 'LABEL_XML.log';

Line 1501: * Insert into WMS_LABEL_REQUESTS_HIST

1497:
1498: END writeIntoFile;
1499:
1500: /*************************************
1501: * Insert into WMS_LABEL_REQUESTS_HIST
1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN

Line 1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS

1499:
1500: /*************************************
1501: * Insert into WMS_LABEL_REQUESTS_HIST
1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN
1506: INSERT INTO wms_label_requests_hist
1507: ( label_request_id,

Line 1506: INSERT INTO wms_label_requests_hist

1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN
1506: INSERT INTO wms_label_requests_hist
1507: ( label_request_id,
1508: LABEL_TYPE_ID ,
1509: LABEL_FORMAT_ID,
1510: ORGANIZATION_ID,

Line 1652: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);

1648: COMMIT;
1649: EXCEPTION
1650: WHEN others THEN
1651: IF (l_debug = 1) THEN
1652: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);
1653: END IF;
1654: END insert_history_record;
1655:
1656: /************************************

Line 1667: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;

1663: , p_status_flag VARCHAR2 DEFAULT 'S'
1664: , p_error_message VARCHAR2 DEFAULT NULL
1665: ) IS
1666:
1667: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;
1668: CURSOR label_req_rec IS
1669: SELECT * FROM WMS_LABEL_REQUESTS
1670: WHERE label_request_id = p_label_request_id;
1671:

Line 1669: SELECT * FROM WMS_LABEL_REQUESTS

1665: ) IS
1666:
1667: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;
1668: CURSOR label_req_rec IS
1669: SELECT * FROM WMS_LABEL_REQUESTS
1670: WHERE label_request_id = p_label_request_id;
1671:
1672: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1673:

Line 1672: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

1668: CURSOR label_req_rec IS
1669: SELECT * FROM WMS_LABEL_REQUESTS
1670: WHERE label_request_id = p_label_request_id;
1671:
1672: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1673:
1674: l_job_name VARCHAR2(150) := NULL;
1675:
1676: BEGIN

Line 1680: -- Retrieve WMS_LABEL_REQUESTS record and copy information to history record

1676: BEGIN
1677: IF (l_debug = 1) THEN
1678: trace(' Populate History Record ReqID='||p_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1679: END IF;
1680: -- Retrieve WMS_LABEL_REQUESTS record and copy information to history record
1681: OPEN label_req_rec;
1682: FETCH label_req_rec INTO l_label_req_rec;
1683: IF label_req_rec%NOTFOUND THEN
1684: IF (l_debug = 1) THEN

Line 1685: trace('Fail to retrieve record from WMS_LABEL_REQUESTS with ID '||p_label_request_id , TRACE_PROMPT, TRACE_LEVEL);

1681: OPEN label_req_rec;
1682: FETCH label_req_rec INTO l_label_req_rec;
1683: IF label_req_rec%NOTFOUND THEN
1684: IF (l_debug = 1) THEN
1685: trace('Fail to retrieve record from WMS_LABEL_REQUESTS with ID '||p_label_request_id , TRACE_PROMPT, TRACE_LEVEL);
1686: END IF;
1687: CLOSE label_req_rec;
1688: RETURN;
1689: END IF;

Line 1793: UPDATE wms_label_requests_hist

1789: , p_error_message IN VARCHAR2
1790: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
1791:
1792: BEGIN
1793: UPDATE wms_label_requests_hist
1794: SET status_flag = nvl(p_status_flag, status_flag)
1795: , job_status = nvl(p_job_status,job_status)
1796: , printer_status = nvl(p_printer_status, printer_status)
1797: , status_type = nvl(p_status_type, status_type)

Line 1815: * It will first insert a row into wms_label_requests

1811:
1812: /*******************************************
1813: * Call the rules engine to get label format
1814: * It only apply for WMS installed
1815: * It will first insert a row into wms_label_requests
1816: * then call the rules engine to get the label format
1817: ******************************************/
1818:
1819: PROCEDURE GET_FORMAT_WITH_RULE

Line 1917: trace(' **Label Request ID inserted in the wms_label_requests table is :'|| l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);

1913:
1914: trace(' **Label Request ID : ' || l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1915:
1916: IF (l_debug = 1) THEN
1917: trace(' **Label Request ID inserted in the wms_label_requests table is :'|| l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1918: END IF;
1919:
1920: -- 1. insert a record into wms_label_requests
1921: -- entity to process data for label rules

Line 1920: -- 1. insert a record into wms_label_requests

1916: IF (l_debug = 1) THEN
1917: trace(' **Label Request ID inserted in the wms_label_requests table is :'|| l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1918: END IF;
1919:
1920: -- 1. insert a record into wms_label_requests
1921: -- entity to process data for label rules
1922: INSERT INTO wms_label_requests
1923: ( label_request_id,
1924: DOCUMENT_ID ,

Line 1922: INSERT INTO wms_label_requests

1918: END IF;
1919:
1920: -- 1. insert a record into wms_label_requests
1921: -- entity to process data for label rules
1922: INSERT INTO wms_label_requests
1923: ( label_request_id,
1924: DOCUMENT_ID ,
1925: LABEL_FORMAT_ID,
1926: ORGANIZATION_ID,

Line 2030: trace('Inserted into WMS_LABEL_REQUESTS table, label_request_id=' ||l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);

2026: p_sales_order_line_id
2027: );
2028:
2029: IF (l_debug = 1) THEN
2030: trace('Inserted into WMS_LABEL_REQUESTS table, label_request_id=' ||l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
2031: END IF;
2032: x_label_request_id := l_label_request_id;
2033:
2034: l_wms_installed := wms_install.check_install(

Line 2087: update wms_label_requests

2083:
2084: -- Bug 3841820
2085: -- When rules engine is not used, update the label request record with label format ID
2086: BEGIN
2087: update wms_label_requests
2088: set label_format_id = x_label_format_id
2089: where label_request_id = l_label_request_id;
2090: EXCEPTION
2091: WHEN others THEN

Line 2093: trace('error when updating wms_label_requests with label format,req_id='||x_label_request_id,TRACE_PROMPT, TRACE_LEVEL);

2089: where label_request_id = l_label_request_id;
2090: EXCEPTION
2091: WHEN others THEN
2092: IF l_debug =1 THEN
2093: trace('error when updating wms_label_requests with label format,req_id='||x_label_request_id,TRACE_PROMPT, TRACE_LEVEL);
2094: END IF;
2095: END;
2096:
2097: ELSE

Line 2144: DELETE FROM wms_label_requests

2140: We need to insert it for each time as rules engine works of
2141: wms_label_request table
2142: */
2143:
2144: DELETE FROM wms_label_requests
2145: WHERE label_request_id = l_label_request_id
2146: AND exists (SELECT label_format_id FROM wms_label_formats
2147: WHERE label_format_id = x_label_format_id
2148: AND document_id = p_document_id

Line 3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

3514: l_job_status VARCHAR2(2000); -- Bug 3328061 increased the size
3515: l_printer_status VARCHAR2(2000); -- Bug 3328061 increased the size
3516: l_status_type NUMBER;
3517:
3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3519: CURSOR c_hist IS
3520: SELECT * FROM wms_label_requests_hist
3521: WHERE label_request_id = p_hist_label_request_id;
3522:

Line 3520: SELECT * FROM wms_label_requests_hist

3516: l_status_type NUMBER;
3517:
3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3519: CURSOR c_hist IS
3520: SELECT * FROM wms_label_requests_hist
3521: WHERE label_request_id = p_hist_label_request_id;
3522:
3523: l_label_content LONG;
3524: l_printer_name VARCHAR2(50);

Line 3787: from wms_label_requests_hist wlrh,

3783: msik.concatenated_segments item,
3784: mfglkup1.meaning bus_flow,
3785: mfglkup2.meaning label_type,
3786: wlrh.label_request_id label_request_id
3787: from wms_label_requests_hist wlrh,
3788: wms_label_formats wlf,
3789: wms_license_plate_numbers wlpn,
3790: mtl_system_items_kfv msik,
3791: mfg_lookups mfglkup1,