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 75: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

71: When Others Then
72: IF l_debug_level > 0 THEN
73: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
74: END IF;
75: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
77: End if;
78: Return l_orig_sys_document_ref;
79:

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

72: IF l_debug_level > 0 THEN
73: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
74: END IF;
75: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
77: End if;
78: Return l_orig_sys_document_ref;
79:
80: End Get_Orig_Sys_Document_Ref;

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

145: When Others Then
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
148: END IF;
149: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
150: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
151: End if;
152: Return l_header_id;
153: End Get_Header_Id;

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

146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
148: END IF;
149: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
150: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
151: End if;
152: Return l_header_id;
153: End Get_Header_Id;
154:

Line 1227: oe_msg_pub.add;

1223: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1224: END IF;
1225: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1226: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1227: oe_msg_pub.add;
1228: End;
1229:
1230:
1231: -- { Start of l_reject_order = 'Y'

Line 1262: OE_MSG_PUB.update_msg_context(

1258: /* And nvl(change_sequence, ' ')
1259: = nvl(p_change_sequence, ' ');
1260: */
1261: -- start bug 4195533
1262: OE_MSG_PUB.update_msg_context(
1263: p_header_id => l_header_id
1264: );
1265: -- end bug 4195533
1266:

Line 1279: oe_msg_pub.add;

1275: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1276: END IF;
1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1278: fnd_message.set_token ('TABLE', 'oe_order_headers');
1279: oe_msg_pub.add;
1280: End;
1281:
1282: End If;
1283: -- End of l_reject_order = 'Y'}

Line 1349: oe_msg_pub.add;

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

Line 1445: oe_msg_pub.add;

1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: --RETURN;
1448: End;
1449:

Line 1507: oe_msg_pub.add;

1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: --RETURN;
1510: End;
1511: -- End Line query}

Line 1687: -- oe_msg_pub.add;

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

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

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

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

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

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

2733: oe_debug_pub.add( 'OEXPACKB: EXITING PROCESS_SSO' ) ;
2734: END IF;
2735: Exception
2736: When Others Then
2737: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2738: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso');
2739: End if;
2740: END Process_SSO;
2741: -- End of the Process_SSO }

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

2734: END IF;
2735: Exception
2736: When Others Then
2737: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2738: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso');
2739: End if;
2740: END Process_SSO;
2741: -- End of the Process_SSO }
2742:

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

2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2952: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2953: END IF;
2954: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2955: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
2956: End if;
2957: End Process_SSO_CONC_PGM;
2958: -- End of the Process_SSO_Conc_Pgm }

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

2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2952: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2953: END IF;
2954: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2955: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
2956: End if;
2957: End Process_SSO_CONC_PGM;
2958: -- End of the Process_SSO_Conc_Pgm }
2959:

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

3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: EXCEPTION
3414: When Others Then
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3417: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3418: END IF;
3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;

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

3413: EXCEPTION
3414: When Others Then
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3417: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3418: END IF;
3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;
3421: END IF;

Line 3556: OE_MSG_PUB.Count_And_Get

3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3554: END IF;
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: OE_MSG_PUB.Count_And_Get
3557: ( p_count => l_msg_count,
3558: p_data => l_msg_data
3559: );
3560:

Line 3566: OE_MSG_PUB.Count_And_Get

3562: IF l_debug_level > 0 THEN
3563: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3564: END IF;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566: OE_MSG_PUB.Count_And_Get
3567: ( p_count => l_msg_count,
3568: p_data => l_msg_data
3569: );
3570:

Line 3584: OE_MSG_PUB.Count_And_Get

3580: , 'Apply_3A7_Hold'
3581: );
3582: END IF;
3583:
3584: OE_MSG_PUB.Count_And_Get
3585: ( p_count => l_msg_count,
3586: p_data => l_msg_data
3587: );
3588:

Line 3682: OE_MSG_PUB.Count_And_Get

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

Line 3692: OE_MSG_PUB.Count_And_Get

3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: OE_MSG_PUB.Count_And_Get
3693: ( p_count => l_msg_count,
3694: p_data => l_msg_data
3695: );
3696:

Line 3710: OE_MSG_PUB.Count_And_Get

3706: , 'Release_3A7_Hold'
3707: );
3708: END IF;
3709:
3710: OE_MSG_PUB.Count_And_Get
3711: ( p_count => l_msg_count,
3712: p_data => l_msg_data
3713: );
3714:

Line 3773: OE_MSG_PUB.Add;

3769: IF l_debug_level > 0 THEN
3770: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3771: END IF;
3772: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3773: OE_MSG_PUB.Add;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF; -- check for columns
3776: END IF; -- check for independent/response 3A8
3777:

Line 3807: OE_MSG_PUB.Count_And_Get

3803: IF l_debug_level > 0 THEN
3804: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3805: END IF;
3806: x_return_status := FND_API.G_RET_STS_ERROR;
3807: OE_MSG_PUB.Count_And_Get
3808: ( p_count => l_msg_count,
3809: p_data => l_msg_data
3810: );
3811:

Line 3817: OE_MSG_PUB.Count_And_Get

3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3815: END IF;
3816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3817: OE_MSG_PUB.Count_And_Get
3818: ( p_count => l_msg_count,
3819: p_data => l_msg_data
3820: );
3821:

Line 3835: OE_MSG_PUB.Count_And_Get

3831: , 'Process_3A8'
3832: );
3833: END IF;
3834:
3835: OE_MSG_PUB.Count_And_Get
3836: ( p_count => l_msg_count,
3837: p_data => l_msg_data
3838: );
3839: