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_MSG_PUB

Line 1: PACKAGE BODY OE_MSG_PUB AS

1: PACKAGE BODY OE_MSG_PUB AS
2: /* $Header: OEXUMSGB.pls 120.17.12020000.2 2012/07/03 10:11:03 amallik ship $ */
3:
4: -- Constants used as tokens for unexpected error messages.
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(15):= 'OE_MSG_PUB';

2: /* $Header: OEXUMSGB.pls 120.17.12020000.2 2012/07/03 10:11:03 amallik ship $ */
3:
4: -- Constants used as tokens for unexpected error messages.
5:
6: G_PKG_NAME CONSTANT VARCHAR2(15):= 'OE_MSG_PUB';
7: G_HEADER_ID NUMBER;
8: G_ORDER_NUMBER NUMBER;
9:
10: -- Procedure Initialize

Line 43: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;

39: G_msg_context_count := 0;
40: G_Msg_Context_index := 0;
41:
42: IF l_debug_level > 0 THEN
43: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;
44: END IF;
45: EXCEPTION
46: WHEN OTHERS THEN
47: IF l_debug_level > 0 THEN

Line 377: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.COUNT_AND_GET '|| L_MSG_COUNT , 3 ) ;

373:
374: p_count := l_msg_count ;
375:
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.COUNT_AND_GET '|| L_MSG_COUNT , 3 ) ;
378: END IF;
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF l_debug_level > 0 THEN

Line 474: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD' , 3 ) ;

470: G_msg_tbl(G_msg_count).ORG_ID := NULL;
471: END IF;
472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD' , 3 ) ;
475: END IF;
476: EXCEPTION
477: WHEN OTHERS THEN
478: IF l_debug_level > 0 THEN

Line 545: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD_TEXT' , 3 ) ;

541: G_msg_tbl(G_msg_count).ORG_ID := NULL;
542: END IF;
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD_TEXT' , 3 ) ;
546: END IF;
547: EXCEPTION
548: WHEN OTHERS THEN
549: IF l_debug_level > 0 THEN

Line 860: OE_MSG_PUB.Add_Exc_Msg

856: ELSE
857:
858: -- Invalid mode.
859:
860: OE_MSG_PUB.Add_Exc_Msg
861: ( p_pkg_name => G_PKG_NAME ,
862: p_procedure_name => l_procedure_name ,
863: p_error_text => 'Invalid p_mode: '||p_mode
864: );

Line 1078: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;

1074:
1075: Procedure save_messages(p_request_id IN NUMBER
1076: ,p_message_source_code IN VARCHAR2 DEFAULT 'C')
1077: IS
1078: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1079: --
1080: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1081: --
1082: begin

Line 1094: oe_msg_pub.initialize;

1090: End Loop;
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add( 'EXIT SAVE_MESSAGES' , 1 ) ;
1093: END IF;
1094: oe_msg_pub.initialize;
1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: IF l_debug_level > 0 THEN
1098: oe_debug_pub.add('Error in Procedure save_messages ' || sqlerrm);

Line 1109: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;

1105: ,p_message_source_code IN VARCHAR2 DEFAULT 'A')
1106: RETURN VARCHAR2
1107: IS
1108: Pragma AUTONOMOUS_TRANSACTION;
1109: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1111: l_count NUMBER := 0;
1112: begin
1113: IF l_debug_level > 0 THEN

Line 1123: oe_msg_pub.initialize;

1119: l_count := l_count +1;
1120: END IF;
1121: End Loop;
1122:
1123: oe_msg_pub.initialize;
1124:
1125: COMMIT;
1126: IF l_count = l_count_msg THEN
1127: -- All messages processed

Line 1620: IF OE_Msg_pub.Count_Msg <> 1 THEN

1616: BEGIN
1617:
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: IF OE_Msg_pub.Count_Msg <> 1 THEN
1621:
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: ELSE

Line 1739: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;

1735: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1736: --
1737: BEGIN
1738: IF l_debug_level > 0 THEN
1739: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;
1740: END IF;
1741: /* 1922443 */
1742: /* select msg.rowid,
1743: msg.transaction_id

Line 1986: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_MESSAGE' ) ;

1982:
1983: commit;
1984:
1985: IF l_debug_level > 0 THEN
1986: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_MESSAGE' ) ;
1987: END IF;
1988:
1989: EXCEPTION
1990:

Line 2032: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;

2028: --
2029: BEGIN
2030:
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
2033: END IF;
2034: /* Replaced with the following for 1922443
2035: Select transaction_id
2036: Bulk Collect Into transactions_oi

Line 2222: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;

2218:
2219: commit;
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
2223: END IF;
2224:
2225: /*
2226: EXCEPTION

Line 2327: oe_msg_pub.add_text(p_message_text => l_errmsg);

2323: AND substr(l_errmsg,5,4) <> '0000'
2324: AND rtrim(ltrim(l_errmsg)) <> 'ORA-20001:'
2325: AND upper(substr(ltrim(l_errmsg),1,5)) <> 'USER-' THEN
2326: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;
2327: oe_msg_pub.add_text(p_message_text => l_errmsg);
2328: END IF;
2329:
2330: */
2331: l_count_msg := OE_MSG_PUB.Count_Msg;

Line 2331: l_count_msg := OE_MSG_PUB.Count_Msg;

2327: oe_msg_pub.add_text(p_message_text => l_errmsg);
2328: END IF;
2329:
2330: */
2331: l_count_msg := OE_MSG_PUB.Count_Msg;
2332:
2333: FOR I IN 1..l_count_msg LOOP
2334: IF nvl(g_msg_tbl(I).processed,'N') = 'N' THEN
2335: insert_message(I,l_request_id,l_message_source_code);

Line 2568: END OE_MSG_PUB ;

2564: RETURN G_msg_init_with_timer;
2565: END Get_Msg_Init_with_timer;
2566: --Bug 8514085 Ends
2567:
2568: END OE_MSG_PUB ;