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.13.12010000.2 2008/08/04 15:03:57 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.13.12010000.2 2008/08/04 15:03:57 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 35: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;

31: G_msg_context_count := 0;
32: G_Msg_Context_index := 0;
33:
34: IF l_debug_level > 0 THEN
35: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;
36: END IF;
37: EXCEPTION
38: WHEN OTHERS THEN
39: IF l_debug_level > 0 THEN

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

365:
366: p_count := l_msg_count ;
367:
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.COUNT_AND_GET '|| L_MSG_COUNT , 3 ) ;
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF l_debug_level > 0 THEN

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

462: G_msg_tbl(G_msg_count).ORG_ID := NULL;
463: END IF;
464:
465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD' , 3 ) ;
467: END IF;
468: EXCEPTION
469: WHEN OTHERS THEN
470: IF l_debug_level > 0 THEN

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

533: G_msg_tbl(G_msg_count).ORG_ID := NULL;
534: END IF;
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD_TEXT' , 3 ) ;
538: END IF;
539: EXCEPTION
540: WHEN OTHERS THEN
541: IF l_debug_level > 0 THEN

Line 852: OE_MSG_PUB.Add_Exc_Msg

848: ELSE
849:
850: -- Invalid mode.
851:
852: OE_MSG_PUB.Add_Exc_Msg
853: ( p_pkg_name => G_PKG_NAME ,
854: p_procedure_name => l_procedure_name ,
855: p_error_text => 'Invalid p_mode: '||p_mode
856: );

Line 1070: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;

1066:
1067: Procedure save_messages(p_request_id IN NUMBER
1068: ,p_message_source_code IN VARCHAR2 DEFAULT 'C')
1069: IS
1070: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --
1074: begin

Line 1086: oe_msg_pub.initialize;

1082: End Loop;
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'EXIT SAVE_MESSAGES' , 1 ) ;
1085: END IF;
1086: oe_msg_pub.initialize;
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: IF l_debug_level > 0 THEN
1090: oe_debug_pub.add('Error in Procedure save_messages ' || sqlerrm);

Line 1101: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;

1097: ,p_message_source_code IN VARCHAR2 DEFAULT 'A')
1098: RETURN VARCHAR2
1099: IS
1100: Pragma AUTONOMOUS_TRANSACTION;
1101: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1103: l_count NUMBER := 0;
1104: begin
1105: IF l_debug_level > 0 THEN

Line 1115: oe_msg_pub.initialize;

1111: l_count := l_count +1;
1112: END IF;
1113: End Loop;
1114:
1115: oe_msg_pub.initialize;
1116:
1117: COMMIT;
1118: IF l_count = l_count_msg THEN
1119: -- All messages processed

Line 1581: IF OE_Msg_pub.Count_Msg <> 1 THEN

1577: BEGIN
1578:
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580:
1581: IF OE_Msg_pub.Count_Msg <> 1 THEN
1582:
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: ELSE

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

1696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1697: --
1698: BEGIN
1699: IF l_debug_level > 0 THEN
1700: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;
1701: END IF;
1702: /* 1922443 */
1703: /* select msg.rowid,
1704: msg.transaction_id

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

1943:
1944: commit;
1945:
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_MESSAGE' ) ;
1948: END IF;
1949:
1950: EXCEPTION
1951:

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

1989: --
1990: BEGIN
1991:
1992: IF l_debug_level > 0 THEN
1993: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
1994: END IF;
1995: /* Replaced with the following for 1922443
1996: Select transaction_id
1997: Bulk Collect Into transactions_oi

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

2179:
2180: commit;
2181:
2182: IF l_debug_level > 0 THEN
2183: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
2184: END IF;
2185:
2186: /*
2187: EXCEPTION

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

2284: AND substr(l_errmsg,5,4) <> '0000'
2285: AND rtrim(ltrim(l_errmsg)) <> 'ORA-20001:'
2286: AND upper(substr(ltrim(l_errmsg),1,5)) <> 'USER-' THEN
2287: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;
2288: oe_msg_pub.add_text(p_message_text => l_errmsg);
2289: END IF;
2290:
2291: */
2292: l_count_msg := OE_MSG_PUB.Count_Msg;

Line 2292: l_count_msg := OE_MSG_PUB.Count_Msg;

2288: oe_msg_pub.add_text(p_message_text => l_errmsg);
2289: END IF;
2290:
2291: */
2292: l_count_msg := OE_MSG_PUB.Count_Msg;
2293:
2294: FOR I IN 1..l_count_msg LOOP
2295: IF nvl(g_msg_tbl(I).processed,'N') = 'N' THEN
2296: insert_message(I,l_request_id,l_message_source_code);

Line 2497: END OE_MSG_PUB ;

2493: oe_debug_pub.add('Error in Procedure Update_status_code ' || sqlerrm);
2494: END IF;
2495: End Update_status_code;
2496:
2497: END OE_MSG_PUB ;