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.OE_MSG_PUB dependencies on OE_PROCESSING_MSGS

Line 1149: -- same in OE_PROCESSING_MSGS. This procedure resolvs message

1145: -- Usage Used by save_messages procedure to insert messages in database.
1146: --
1147: -- Desc Accepts request_id and index as input
1148: -- Reads the message from stack based on the index and inserts the
1149: -- same in OE_PROCESSING_MSGS. This procedure resolvs message
1150: -- text before inserting in database.
1151: --
1152: --
1153: procedure insert_message (

Line 1291: insert into OE_PROCESSING_MSGS

1287: FROM dual;
1288:
1289: END;
1290:
1291: insert into OE_PROCESSING_MSGS
1292: ( Transaction_id
1293: ,request_Id
1294: -- ,message_text
1295: ,entity_code

Line 1359: INSERT INTO OE_PROCESSING_MSGS_TL

1355: );
1356:
1357: BEGIN
1358:
1359: INSERT INTO OE_PROCESSING_MSGS_TL
1360: (Transaction_id
1361: ,language
1362: ,source_lang
1363: ,message_text

Line 1385: FROM oe_processing_msgs_tl t

1381: WHERE l.installed_flag in ('I','B')
1382: AND language_code = USERENV('LANG')
1383: AND not exists
1384: (SELECT null
1385: FROM oe_processing_msgs_tl t
1386: WHERE t.transaction_id = l_transaction_id
1387: AND t.language = l.language_code);
1388:
1389: END;

Line 1501: -- in OE_PROCESSING_MSGS.

1497: -- by using autonomous transaction .
1498: --
1499: -- Desc This procedure is set for autonomous transaction.
1500: -- This procedure calls save_messages procedure to insert messages
1501: -- in OE_PROCESSING_MSGS.
1502: -- This procedure accepts request_id as input from the caller
1503: --
1504: -- Note This procedure uses autonomous transaction.That means
1505: -- commit or rollback with in this procedure will not affect

Line 1535: -- the OE_PROCESSING_MSGS.

1531: -- for batch program generated messages.
1532: --
1533: -- Desc This procedure is set for autonomous transaction.
1534: -- This procedure accepts transaction_id and updates
1535: -- the OE_PROCESSING_MSGS.
1536: --
1537: -- Note This procedure uses autonomous transaction.That means
1538: -- commit or rollback with in this procedure will not affect
1539: -- the callers transaction.

Line 1549: UPDATE oe_processing_msgs

1545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1546: --
1547: BEGIN
1548:
1549: UPDATE oe_processing_msgs
1550: SET notification_flag = 'Y'
1551: WHERE transaction_id = p_transaction_id;
1552:
1553: COMMIT;

Line 1699: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL

1695: -- Usage Used by process message form to delete queried
1696: -- messages.
1697: --
1698: -- Desc This procedure accepts where clause parameters
1699: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL
1700: -- and OE_PROCESSING_MSGS.
1701: --
1702:
1703: PROCEDURE DELETE_MESSAGE

Line 1700: -- and OE_PROCESSING_MSGS.

1696: -- messages.
1697: --
1698: -- Desc This procedure accepts where clause parameters
1699: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL
1700: -- and OE_PROCESSING_MSGS.
1701: --
1702:
1703: PROCEDURE DELETE_MESSAGE
1704: (p_message_source_code IN VARCHAR2 DEFAULT NULL

Line 1721: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;

1717:
1718:
1719: IS
1720: /* These types and variables introduced to fix 1922443 */
1721: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
1722: TYPE Transactionrowidtab is TABLE OF varchar2(100);
1723: Transactionids Transactionidtab := Transactionidtab();
1724: Transactionrowids Transactionrowidtab := Transactionrowidtab();
1725:

Line 1747: from oe_processing_msgs msg,

1743: msg.transaction_id
1744: bulk collect
1745: into transactionrowids,
1746: transactionids
1747: from oe_processing_msgs msg,
1748: oe_order_headers hdr,
1749: wf_process_activities wpa,
1750: wf_activities_tl wa
1751: Where msg.header_id = hdr.header_id (+)

Line 1798: ' from oe_processing_msgs msg';

1794:
1795: THEN
1796:
1797: l_stmt := 'select transaction_id ' ||
1798: ' from oe_processing_msgs msg';
1799:
1800: l_stmt := l_stmt ||' WHERE 1 = 1';
1801: ELSIF p_process_activity_name is null
1802: THEN

Line 1805: ' from oe_processing_msgs msg, oe_order_headers_all hdr';

1801: ELSIF p_process_activity_name is null
1802: THEN
1803:
1804: l_stmt := 'select transaction_id ' ||
1805: ' from oe_processing_msgs msg, oe_order_headers_all hdr';
1806:
1807: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1808: ELSE
1809:

Line 1811: ' from oe_processing_msgs msg, oe_order_headers hdr' ||

1807: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1808: ELSE
1809:
1810: l_stmt := 'select transaction_id ' ||
1811: ' from oe_processing_msgs msg, oe_order_headers hdr' ||
1812: ',wf_process_activities wpa, wf_activities_tl wa ';
1813:
1814: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id' ||
1815: ' AND msg.process_activity = wpa.instance_id(+)' ||

Line 1966: from oe_processing_msgs_tl

1962: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1963:
1964: FORALL J in 1..Transactionids.COUNT
1965: Delete
1966: from oe_processing_msgs_tl
1967: Where transaction_id = Transactionids(J);
1968:
1969: FORALL J in 1..Transactionids.COUNT
1970: Delete

Line 1971: from oe_processing_msgs

1967: Where transaction_id = Transactionids(J);
1968:
1969: FORALL J in 1..Transactionids.COUNT
1970: Delete
1971: from oe_processing_msgs
1972: Where transaction_id = Transactionids(J);
1973:
1974: /*
1975: FORALL J in 1..Transactionrowids.COUNT

Line 1977: from oe_processing_msgs

1973:
1974: /*
1975: FORALL J in 1..Transactionrowids.COUNT
1976: Delete
1977: from oe_processing_msgs
1978: Where rowid = Transactionrowids(J);
1979: */
1980: Transactionids.DELETE;
1981: Transactionrowids.DELETE;

Line 2010: TYPE Transaction_tab is TABLE OF oe_processing_msgs.transaction_id%TYPE;

2006: ,p_org_id IN NUMBER DEFAULT NULL)
2007:
2008: IS
2009: /* Replaced with the following to fix 1922443
2010: TYPE Transaction_tab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
2011: Transactions_oi Transaction_tab;
2012: */
2013:
2014: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;

Line 2014: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;

2010: TYPE Transaction_tab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
2011: Transactions_oi Transaction_tab;
2012: */
2013:
2014: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
2015: TYPE Transactionrowidtab is TABLE OF varchar2(100);
2016: Transactionids Transactionidtab := Transactionidtab();
2017: Transactionrowids Transactionrowidtab := Transactionrowidtab();
2018:

Line 2043: from oe_processing_msgs

2039: transaction_id
2040: bulk collect
2041: into transactionrowids,
2042: transactionids
2043: from oe_processing_msgs
2044: Where nvl(request_id,0) = nvl(p_request_id,
2045: nvl(request_id,0))
2046: Removed nvl condition as we expect order_source_id and
2047: original_sys_document_ref to be passed # 2467558

Line 2065: from oe_processing_msgs_tl

2061:
2062: Replaced with the following to fix 1922443
2063: FORALL J in 1..Transactions_oi.COUNT
2064: Delete
2065: from oe_processing_msgs_tl
2066: Where transaction_id = Transactions_oi(J);
2067:
2068:
2069: FORALL J in 1..Transactions_oi.COUNT

Line 2071: from oe_processing_msgs

2067:
2068:
2069: FORALL J in 1..Transactions_oi.COUNT
2070: Delete
2071: from oe_processing_msgs
2072: Where transaction_id = Transactions_oi(J);
2073:
2074: Transactions_oi.DELETE;
2075:

Line 2079: from oe_processing_msgs_tl

2075:
2076:
2077: FORALL J in 1..Transactionids.COUNT
2078: Delete
2079: from oe_processing_msgs_tl
2080: Where transaction_id = Transactionids(J);
2081:
2082:
2083: FORALL J in 1..Transactionrowids.COUNT

Line 2085: from oe_processing_msgs

2081:
2082:
2083: FORALL J in 1..Transactionrowids.COUNT
2084: Delete
2085: from oe_processing_msgs
2086: Where rowid = Transactionrowids(J);
2087:
2088:
2089: Transactionids.DELETE;

Line 2099: ' from oe_processing_msgs';

2095:
2096:
2097:
2098: l_stmt := 'select transaction_id ' ||
2099: ' from oe_processing_msgs';
2100:
2101:
2102:
2103: l_stmt := l_stmt ||' WHERE order_source_id = :order_source_id';

Line 2208: from oe_processing_msgs_tl

2204: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2205:
2206: FORALL J in 1..Transactionids.COUNT
2207: Delete
2208: from oe_processing_msgs_tl
2209: Where transaction_id = Transactionids(J);
2210:
2211: FORALL J in 1..Transactionids.COUNT
2212: Delete

Line 2213: from oe_processing_msgs

2209: Where transaction_id = Transactionids(J);
2210:
2211: FORALL J in 1..Transactionids.COUNT
2212: Delete
2213: from oe_processing_msgs
2214: Where transaction_id = Transactionids(J);
2215:
2216: Transactionids.DELETE;
2217: Transactionrowids.DELETE;

Line 2395: l_stmt := 'Select transaction_id from oe_processing_msgs Where 1 = 1';

2391:
2392: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2393:
2394:
2395: l_stmt := 'Select transaction_id from oe_processing_msgs Where 1 = 1';
2396:
2397:
2398: IF p_request_id IS NOT NULL THEN
2399: l_stmt := l_stmt ||' AND request_id = :request_id';

Line 2523: Update oe_processing_msgs

2519: END IF;
2520: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2521:
2522:
2523: Update oe_processing_msgs
2524: Set message_status_code = p_status_code
2525: Where transaction_id = l_transaction_id;
2526:
2527: END LOOP;