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_ACKNOWLEDGMENT_PUB dependencies on OE_MSG_PUB

Line 80: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

76: When Others Then
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
79: END IF;
80: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
81: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
82: End if;
83: Return l_orig_sys_document_ref;
84:

Line 81: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');

77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
79: END IF;
80: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
81: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
82: End if;
83: Return l_orig_sys_document_ref;
84:
85: End Get_Orig_Sys_Document_Ref;

Line 154: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

150: When Others Then
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
153: END IF;
154: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
156: End if;
157: Return l_header_id;
158: End Get_Header_Id;

Line 155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');

151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
153: END IF;
154: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
156: End if;
157: Return l_header_id;
158: End Get_Header_Id;
159:

Line 1232: oe_msg_pub.add;

1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1229: END IF;
1230: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1232: oe_msg_pub.add;
1233: End;
1234:
1235:
1236: -- { Start of l_reject_order = 'Y'

Line 1267: OE_MSG_PUB.update_msg_context(

1263: /* And nvl(change_sequence, ' ')
1264: = nvl(p_change_sequence, ' ');
1265: */
1266: -- start bug 4195533
1267: OE_MSG_PUB.update_msg_context(
1268: p_header_id => l_header_id
1269: );
1270: -- end bug 4195533
1271:

Line 1284: oe_msg_pub.add;

1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1281: END IF;
1282: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1283: fnd_message.set_token ('TABLE', 'oe_order_headers');
1284: oe_msg_pub.add;
1285: End;
1286:
1287: End If;
1288: -- End of l_reject_order = 'Y'}

Line 1354: oe_msg_pub.add;

1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1353: fnd_message.set_token ('TABLE', 'oe_order_headers');
1354: oe_msg_pub.add;
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: --RETURN;
1357: End;
1358: -- End Header query}

Line 1450: oe_msg_pub.add;

1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1447: END IF;
1448: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1449: fnd_message.set_token ('TABLE', 'oe_order_lines');
1450: oe_msg_pub.add;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: --RETURN;
1453: End;
1454:

Line 1512: oe_msg_pub.add;

1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1509: END IF;
1510: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1511: fnd_message.set_token ('TABLE', 'oe_order_lines');
1512: oe_msg_pub.add;
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: --RETURN;
1515: End;
1516: -- End Line query}

Line 1692: -- oe_msg_pub.add;

1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: -- start bug 3711152
1690: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');
1691: -- fnd_message.set_token ('CUST_ID', p_customer_id);
1692: -- oe_msg_pub.add;
1693: -- end bug 3711152
1694: WHEN OTHERS THEN
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;

Line 1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;
1697: END IF;
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1701: END IF;
1702: IF l_debug_level > 0 THEN
1703: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

Line 1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');

1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;
1697: END IF;
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1701: END IF;
1702: IF l_debug_level > 0 THEN
1703: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1704: END IF;

Line 2853: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2849: oe_debug_pub.add( 'OEXPACKB: EXITING PROCESS_SSO' ) ;
2850: END IF;
2851: Exception
2852: When Others Then
2853: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso');
2855: End if;
2856: END Process_SSO;
2857: -- End of the Process_SSO }

Line 2854: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso');

2850: END IF;
2851: Exception
2852: When Others Then
2853: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso');
2855: End if;
2856: END Process_SSO;
2857: -- End of the Process_SSO }
2858:

Line 3070: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3069: END IF;
3070: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
3072: End if;
3073: End Process_SSO_CONC_PGM;
3074: -- End of the Process_SSO_Conc_Pgm }

Line 3071: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');

3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3069: END IF;
3070: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
3072: End if;
3073: End Process_SSO_CONC_PGM;
3074: -- End of the Process_SSO_Conc_Pgm }
3075:

Line 3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3528: x_return_status := FND_API.G_RET_STS_SUCCESS;
3529: EXCEPTION
3530: When Others Then
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3534: END IF;
3535: IF l_debug_level > 0 THEN
3536: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;

Line 3533: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');

3529: EXCEPTION
3530: When Others Then
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3534: END IF;
3535: IF l_debug_level > 0 THEN
3536: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;
3537: END IF;

Line 3672: OE_MSG_PUB.Count_And_Get

3668: IF l_debug_level > 0 THEN
3669: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3670: END IF;
3671: x_return_status := FND_API.G_RET_STS_ERROR;
3672: OE_MSG_PUB.Count_And_Get
3673: ( p_count => l_msg_count,
3674: p_data => l_msg_data
3675: );
3676:

Line 3682: OE_MSG_PUB.Count_And_Get

3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: OE_MSG_PUB.Count_And_Get
3683: ( p_count => l_msg_count,
3684: p_data => l_msg_data
3685: );
3686:

Line 3700: OE_MSG_PUB.Count_And_Get

3696: , 'Apply_3A7_Hold'
3697: );
3698: END IF;
3699:
3700: OE_MSG_PUB.Count_And_Get
3701: ( p_count => l_msg_count,
3702: p_data => l_msg_data
3703: );
3704:

Line 3798: OE_MSG_PUB.Count_And_Get

3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3796: END IF;
3797: x_return_status := FND_API.G_RET_STS_ERROR;
3798: OE_MSG_PUB.Count_And_Get
3799: ( p_count => l_msg_count,
3800: p_data => l_msg_data
3801: );
3802:

Line 3808: OE_MSG_PUB.Count_And_Get

3804: IF l_debug_level > 0 THEN
3805: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3806: END IF;
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3808: OE_MSG_PUB.Count_And_Get
3809: ( p_count => l_msg_count,
3810: p_data => l_msg_data
3811: );
3812:

Line 3826: OE_MSG_PUB.Count_And_Get

3822: , 'Release_3A7_Hold'
3823: );
3824: END IF;
3825:
3826: OE_MSG_PUB.Count_And_Get
3827: ( p_count => l_msg_count,
3828: p_data => l_msg_data
3829: );
3830:

Line 3889: OE_MSG_PUB.Add;

3885: IF l_debug_level > 0 THEN
3886: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3887: END IF;
3888: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3889: OE_MSG_PUB.Add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF; -- check for columns
3892: END IF; -- check for independent/response 3A8
3893:

Line 3923: OE_MSG_PUB.Count_And_Get

3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3921: END IF;
3922: x_return_status := FND_API.G_RET_STS_ERROR;
3923: OE_MSG_PUB.Count_And_Get
3924: ( p_count => l_msg_count,
3925: p_data => l_msg_data
3926: );
3927:

Line 3933: OE_MSG_PUB.Count_And_Get

3929: IF l_debug_level > 0 THEN
3930: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3931: END IF;
3932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3933: OE_MSG_PUB.Count_And_Get
3934: ( p_count => l_msg_count,
3935: p_data => l_msg_data
3936: );
3937:

Line 3951: OE_MSG_PUB.Count_And_Get

3947: , 'Process_3A8'
3948: );
3949: END IF;
3950:
3951: OE_MSG_PUB.Count_And_Get
3952: ( p_count => l_msg_count,
3953: p_data => l_msg_data
3954: );
3955: