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 1314: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table

1310:
1311:
1312: -- This procedure is to write label xml data into LABEL_XML.log
1313: -- This is not used anymore from Patchset I (11.5.9) because
1314: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table
1315: PROCEDURE writeIntoFile(xml LONG) IS
1316: l_dir VARCHAR2(128);
1317: l_debug_trace NUMBER;
1318: l_file_name VARCHAR2(100) := 'LABEL_XML.log';

Line 1440: * Insert into WMS_LABEL_REQUESTS_HIST

1436:
1437: END writeIntoFile;
1438:
1439: /*************************************
1440: * Insert into WMS_LABEL_REQUESTS_HIST
1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN

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

1438:
1439: /*************************************
1440: * Insert into WMS_LABEL_REQUESTS_HIST
1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN
1445: INSERT INTO wms_label_requests_hist
1446: ( label_request_id,

Line 1445: INSERT INTO wms_label_requests_hist

1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN
1445: INSERT INTO wms_label_requests_hist
1446: ( label_request_id,
1447: LABEL_TYPE_ID ,
1448: LABEL_FORMAT_ID,
1449: ORGANIZATION_ID,

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

1587: COMMIT;
1588: EXCEPTION
1589: WHEN others THEN
1590: IF (l_debug = 1) THEN
1591: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);
1592: END IF;
1593: END insert_history_record;
1594:
1595: /************************************

Line 1606: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;

1602: , p_status_flag VARCHAR2 DEFAULT 'S'
1603: , p_error_message VARCHAR2 DEFAULT NULL
1604: ) IS
1605:
1606: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;
1607: CURSOR label_req_rec IS
1608: SELECT * FROM WMS_LABEL_REQUESTS
1609: WHERE label_request_id = p_label_request_id;
1610:

Line 1608: SELECT * FROM WMS_LABEL_REQUESTS

1604: ) IS
1605:
1606: l_label_req_rec WMS_LABEL_REQUESTS%ROWTYPE;
1607: CURSOR label_req_rec IS
1608: SELECT * FROM WMS_LABEL_REQUESTS
1609: WHERE label_request_id = p_label_request_id;
1610:
1611: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1612:

Line 1611: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

1607: CURSOR label_req_rec IS
1608: SELECT * FROM WMS_LABEL_REQUESTS
1609: WHERE label_request_id = p_label_request_id;
1610:
1611: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1612:
1613: l_job_name VARCHAR2(150) := NULL;
1614:
1615: BEGIN

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

1615: BEGIN
1616: IF (l_debug = 1) THEN
1617: trace(' Populate History Record ReqID='||p_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1618: END IF;
1619: -- Retrieve WMS_LABEL_REQUESTS record and copy information to history record
1620: OPEN label_req_rec;
1621: FETCH label_req_rec INTO l_label_req_rec;
1622: IF label_req_rec%NOTFOUND THEN
1623: IF (l_debug = 1) THEN

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

1620: OPEN label_req_rec;
1621: FETCH label_req_rec INTO l_label_req_rec;
1622: IF label_req_rec%NOTFOUND THEN
1623: IF (l_debug = 1) THEN
1624: trace('Fail to retrieve record from WMS_LABEL_REQUESTS with ID '||p_label_request_id , TRACE_PROMPT, TRACE_LEVEL);
1625: END IF;
1626: CLOSE label_req_rec;
1627: RETURN;
1628: END IF;

Line 1732: UPDATE wms_label_requests_hist

1728: , p_error_message IN VARCHAR2
1729: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
1730:
1731: BEGIN
1732: UPDATE wms_label_requests_hist
1733: SET status_flag = nvl(p_status_flag, status_flag)
1734: , job_status = nvl(p_job_status,job_status)
1735: , printer_status = nvl(p_printer_status, printer_status)
1736: , status_type = nvl(p_status_type, status_type)

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

1750:
1751: /*******************************************
1752: * Call the rules engine to get label format
1753: * It only apply for WMS installed
1754: * It will first insert a row into wms_label_requests
1755: * then call the rules engine to get the label format
1756: ******************************************/
1757:
1758: PROCEDURE GET_FORMAT_WITH_RULE

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

1852:
1853: trace(' **Label Request ID : ' || l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1854:
1855: IF (l_debug = 1) THEN
1856: trace(' **Label Request ID inserted in the wms_label_requests table is :'|| l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1857: END IF;
1858:
1859: -- 1. insert a record into wms_label_requests
1860: -- entity to process data for label rules

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

1855: IF (l_debug = 1) THEN
1856: trace(' **Label Request ID inserted in the wms_label_requests table is :'|| l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1857: END IF;
1858:
1859: -- 1. insert a record into wms_label_requests
1860: -- entity to process data for label rules
1861: INSERT INTO wms_label_requests
1862: ( label_request_id,
1863: DOCUMENT_ID ,

Line 1861: INSERT INTO wms_label_requests

1857: END IF;
1858:
1859: -- 1. insert a record into wms_label_requests
1860: -- entity to process data for label rules
1861: INSERT INTO wms_label_requests
1862: ( label_request_id,
1863: DOCUMENT_ID ,
1864: LABEL_FORMAT_ID,
1865: ORGANIZATION_ID,

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

1965: p_sales_order_line_id
1966: );
1967:
1968: IF (l_debug = 1) THEN
1969: trace('Inserted into WMS_LABEL_REQUESTS table, label_request_id=' ||l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1970: END IF;
1971: x_label_request_id := l_label_request_id;
1972:
1973: l_wms_installed := wms_install.check_install(

Line 2026: update wms_label_requests

2022:
2023: -- Bug 3841820
2024: -- When rules engine is not used, update the label request record with label format ID
2025: BEGIN
2026: update wms_label_requests
2027: set label_format_id = x_label_format_id
2028: where label_request_id = l_label_request_id;
2029: EXCEPTION
2030: WHEN others THEN

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

2028: where label_request_id = l_label_request_id;
2029: EXCEPTION
2030: WHEN others THEN
2031: IF l_debug =1 THEN
2032: trace('error when updating wms_label_requests with label format,req_id='||x_label_request_id,TRACE_PROMPT, TRACE_LEVEL);
2033: END IF;
2034: END;
2035:
2036: ELSE

Line 2083: DELETE FROM wms_label_requests

2079: We need to insert it for each time as rules engine works of
2080: wms_label_request table
2081: */
2082:
2083: DELETE FROM wms_label_requests
2084: WHERE label_request_id = l_label_request_id
2085: AND exists (SELECT label_format_id FROM wms_label_formats
2086: WHERE label_format_id = x_label_format_id
2087: AND document_id = p_document_id

Line 3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

3442: l_job_status VARCHAR2(2000); -- Bug 3328061 increased the size
3443: l_printer_status VARCHAR2(2000); -- Bug 3328061 increased the size
3444: l_status_type NUMBER;
3445:
3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3447: CURSOR c_hist IS
3448: SELECT * FROM wms_label_requests_hist
3449: WHERE label_request_id = p_hist_label_request_id;
3450:

Line 3448: SELECT * FROM wms_label_requests_hist

3444: l_status_type NUMBER;
3445:
3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3447: CURSOR c_hist IS
3448: SELECT * FROM wms_label_requests_hist
3449: WHERE label_request_id = p_hist_label_request_id;
3450:
3451: l_label_content LONG;
3452: l_printer_name VARCHAR2(50);

Line 3714: from wms_label_requests_hist wlrh,

3710: msik.concatenated_segments item,
3711: mfglkup1.meaning bus_flow,
3712: mfglkup2.meaning label_type,
3713: wlrh.label_request_id label_request_id
3714: from wms_label_requests_hist wlrh,
3715: wms_label_formats wlf,
3716: wms_license_plate_numbers wlpn,
3717: mtl_system_items_kfv msik,
3718: mfg_lookups mfglkup1,