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 1141: -- same in OE_PROCESSING_MSGS. This procedure resolvs message

1137: -- Usage Used by save_messages procedure to insert messages in database.
1138: --
1139: -- Desc Accepts request_id and index as input
1140: -- Reads the message from stack based on the index and inserts the
1141: -- same in OE_PROCESSING_MSGS. This procedure resolvs message
1142: -- text before inserting in database.
1143: --
1144: --
1145: procedure insert_message (

Line 1252: insert into OE_PROCESSING_MSGS

1248: FROM dual;
1249:
1250: END;
1251:
1252: insert into OE_PROCESSING_MSGS
1253: ( Transaction_id
1254: ,request_Id
1255: -- ,message_text
1256: ,entity_code

Line 1320: INSERT INTO OE_PROCESSING_MSGS_TL

1316: );
1317:
1318: BEGIN
1319:
1320: INSERT INTO OE_PROCESSING_MSGS_TL
1321: (Transaction_id
1322: ,language
1323: ,source_lang
1324: ,message_text

Line 1346: FROM oe_processing_msgs_tl t

1342: WHERE l.installed_flag in ('I','B')
1343: AND language_code = USERENV('LANG')
1344: AND not exists
1345: (SELECT null
1346: FROM oe_processing_msgs_tl t
1347: WHERE t.transaction_id = l_transaction_id
1348: AND t.language = l.language_code);
1349:
1350: END;

Line 1462: -- in OE_PROCESSING_MSGS.

1458: -- by using autonomous transaction .
1459: --
1460: -- Desc This procedure is set for autonomous transaction.
1461: -- This procedure calls save_messages procedure to insert messages
1462: -- in OE_PROCESSING_MSGS.
1463: -- This procedure accepts request_id as input from the caller
1464: --
1465: -- Note This procedure uses autonomous transaction.That means
1466: -- commit or rollback with in this procedure will not affect

Line 1496: -- the OE_PROCESSING_MSGS.

1492: -- for batch program generated messages.
1493: --
1494: -- Desc This procedure is set for autonomous transaction.
1495: -- This procedure accepts transaction_id and updates
1496: -- the OE_PROCESSING_MSGS.
1497: --
1498: -- Note This procedure uses autonomous transaction.That means
1499: -- commit or rollback with in this procedure will not affect
1500: -- the callers transaction.

Line 1510: UPDATE oe_processing_msgs

1506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1507: --
1508: BEGIN
1509:
1510: UPDATE oe_processing_msgs
1511: SET notification_flag = 'Y'
1512: WHERE transaction_id = p_transaction_id;
1513:
1514: COMMIT;

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

1656: -- Usage Used by process message form to delete queried
1657: -- messages.
1658: --
1659: -- Desc This procedure accepts where clause parameters
1660: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL
1661: -- and OE_PROCESSING_MSGS.
1662: --
1663:
1664: PROCEDURE DELETE_MESSAGE

Line 1661: -- and OE_PROCESSING_MSGS.

1657: -- messages.
1658: --
1659: -- Desc This procedure accepts where clause parameters
1660: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL
1661: -- and OE_PROCESSING_MSGS.
1662: --
1663:
1664: PROCEDURE DELETE_MESSAGE
1665: (p_message_source_code IN VARCHAR2 DEFAULT NULL

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

1678:
1679:
1680: IS
1681: /* These types and variables introduced to fix 1922443 */
1682: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
1683: TYPE Transactionrowidtab is TABLE OF varchar2(100);
1684: Transactionids Transactionidtab := Transactionidtab();
1685: Transactionrowids Transactionrowidtab := Transactionrowidtab();
1686:

Line 1708: from oe_processing_msgs msg,

1704: msg.transaction_id
1705: bulk collect
1706: into transactionrowids,
1707: transactionids
1708: from oe_processing_msgs msg,
1709: oe_order_headers hdr,
1710: wf_process_activities wpa,
1711: wf_activities_tl wa
1712: Where msg.header_id = hdr.header_id (+)

Line 1759: ' from oe_processing_msgs msg';

1755:
1756: THEN
1757:
1758: l_stmt := 'select transaction_id ' ||
1759: ' from oe_processing_msgs msg';
1760:
1761: l_stmt := l_stmt ||' WHERE 1 = 1';
1762: ELSIF p_process_activity_name is null
1763: THEN

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

1762: ELSIF p_process_activity_name is null
1763: THEN
1764:
1765: l_stmt := 'select transaction_id ' ||
1766: ' from oe_processing_msgs msg, oe_order_headers_all hdr';
1767:
1768: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1769: ELSE
1770:

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

1768: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1769: ELSE
1770:
1771: l_stmt := 'select transaction_id ' ||
1772: ' from oe_processing_msgs msg, oe_order_headers hdr' ||
1773: ',wf_process_activities wpa, wf_activities_tl wa ';
1774:
1775: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id' ||
1776: ' AND msg.process_activity = wpa.instance_id(+)' ||

Line 1927: from oe_processing_msgs_tl

1923: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1924:
1925: FORALL J in 1..Transactionids.COUNT
1926: Delete
1927: from oe_processing_msgs_tl
1928: Where transaction_id = Transactionids(J);
1929:
1930: FORALL J in 1..Transactionids.COUNT
1931: Delete

Line 1932: from oe_processing_msgs

1928: Where transaction_id = Transactionids(J);
1929:
1930: FORALL J in 1..Transactionids.COUNT
1931: Delete
1932: from oe_processing_msgs
1933: Where transaction_id = Transactionids(J);
1934:
1935: /*
1936: FORALL J in 1..Transactionrowids.COUNT

Line 1938: from oe_processing_msgs

1934:
1935: /*
1936: FORALL J in 1..Transactionrowids.COUNT
1937: Delete
1938: from oe_processing_msgs
1939: Where rowid = Transactionrowids(J);
1940: */
1941: Transactionids.DELETE;
1942: Transactionrowids.DELETE;

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

1967: ,p_org_id IN NUMBER DEFAULT NULL)
1968:
1969: IS
1970: /* Replaced with the following to fix 1922443
1971: TYPE Transaction_tab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
1972: Transactions_oi Transaction_tab;
1973: */
1974:
1975: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;

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

1971: TYPE Transaction_tab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
1972: Transactions_oi Transaction_tab;
1973: */
1974:
1975: TYPE Transactionidtab is TABLE OF oe_processing_msgs.transaction_id%TYPE;
1976: TYPE Transactionrowidtab is TABLE OF varchar2(100);
1977: Transactionids Transactionidtab := Transactionidtab();
1978: Transactionrowids Transactionrowidtab := Transactionrowidtab();
1979:

Line 2004: from oe_processing_msgs

2000: transaction_id
2001: bulk collect
2002: into transactionrowids,
2003: transactionids
2004: from oe_processing_msgs
2005: Where nvl(request_id,0) = nvl(p_request_id,
2006: nvl(request_id,0))
2007: Removed nvl condition as we expect order_source_id and
2008: original_sys_document_ref to be passed # 2467558

Line 2026: from oe_processing_msgs_tl

2022:
2023: Replaced with the following to fix 1922443
2024: FORALL J in 1..Transactions_oi.COUNT
2025: Delete
2026: from oe_processing_msgs_tl
2027: Where transaction_id = Transactions_oi(J);
2028:
2029:
2030: FORALL J in 1..Transactions_oi.COUNT

Line 2032: from oe_processing_msgs

2028:
2029:
2030: FORALL J in 1..Transactions_oi.COUNT
2031: Delete
2032: from oe_processing_msgs
2033: Where transaction_id = Transactions_oi(J);
2034:
2035: Transactions_oi.DELETE;
2036:

Line 2040: from oe_processing_msgs_tl

2036:
2037:
2038: FORALL J in 1..Transactionids.COUNT
2039: Delete
2040: from oe_processing_msgs_tl
2041: Where transaction_id = Transactionids(J);
2042:
2043:
2044: FORALL J in 1..Transactionrowids.COUNT

Line 2046: from oe_processing_msgs

2042:
2043:
2044: FORALL J in 1..Transactionrowids.COUNT
2045: Delete
2046: from oe_processing_msgs
2047: Where rowid = Transactionrowids(J);
2048:
2049:
2050: Transactionids.DELETE;

Line 2060: ' from oe_processing_msgs';

2056:
2057:
2058:
2059: l_stmt := 'select transaction_id ' ||
2060: ' from oe_processing_msgs';
2061:
2062:
2063:
2064: l_stmt := l_stmt ||' WHERE order_source_id = :order_source_id';

Line 2169: from oe_processing_msgs_tl

2165: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2166:
2167: FORALL J in 1..Transactionids.COUNT
2168: Delete
2169: from oe_processing_msgs_tl
2170: Where transaction_id = Transactionids(J);
2171:
2172: FORALL J in 1..Transactionids.COUNT
2173: Delete

Line 2174: from oe_processing_msgs

2170: Where transaction_id = Transactionids(J);
2171:
2172: FORALL J in 1..Transactionids.COUNT
2173: Delete
2174: from oe_processing_msgs
2175: Where transaction_id = Transactionids(J);
2176:
2177: Transactionids.DELETE;
2178: Transactionrowids.DELETE;

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

2352:
2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2354:
2355:
2356: l_stmt := 'Select transaction_id from oe_processing_msgs Where 1 = 1';
2357:
2358:
2359: IF p_request_id IS NOT NULL THEN
2360: l_stmt := l_stmt ||' AND request_id = :request_id';

Line 2484: Update oe_processing_msgs

2480: END IF;
2481: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2482:
2483:
2484: Update oe_processing_msgs
2485: Set message_status_code = p_status_code
2486: Where transaction_id = l_transaction_id;
2487:
2488: END LOOP;