DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_ACKNOWLEDGMENT_PVT

Line 1: PACKAGE BODY OE_Acknowledgment_Pvt AS

1: PACKAGE BODY OE_Acknowledgment_Pvt AS
2: /* $Header: OEXVACKB.pls 120.10.12020000.2 2013/01/21 05:22:32 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Acknowledgment_Pvt';

2: /* $Header: OEXVACKB.pls 120.10.12020000.2 2013/01/21 05:22:32 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Acknowledgment_Pvt';
7:
8: -- This to fix the performace issue with the call to the HZ tables
9: G_CURR_SOLD_TO_ORG_ID NUMBER;
10: G_CURR_ADDRESS_ID NUMBER;

Line 17: -- API name OE_Acknowledgment_Pvt

13: G_POCAO_ENABLED BOOLEAN := FALSE;
14:
15: /* ---------------------------------------------------------------------
16: -- Start of Comments
17: -- API name OE_Acknowledgment_Pvt
18: -- Type Private
19: -- Function
20: --
21: -- Pre-reqs

Line 176: (G_PKG_NAME, 'OE_Acknowledgment_Pvt.get_address');

172:
173: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
174: THEN
175: OE_MSG_PUB.Add_Exc_Msg
176: (G_PKG_NAME, 'OE_Acknowledgment_Pvt.get_address');
177: END IF;
178:
179: END get_address;
180:

Line 432: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT' , 1 ) ;

428:
429: BEGIN
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT' , 1 ) ;
433: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT', 0.5); -- debug level changed to 0.5 for bug 13435459
434: END IF;
435:
436: /***

Line 433: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT', 0.5); -- debug level changed to 0.5 for bug 13435459

429: BEGIN
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT' , 1 ) ;
433: oe_debug_pub.add( 'ENTERING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT', 0.5); -- debug level changed to 0.5 for bug 13435459
434: END IF;
435:
436: /***
437: -- Bug fix 1633094 start

Line 443: oe_debug_pub.add('Exiting OE_Acknowledgment_Pvt.Process_acknowledgment',1);

439: IF fnd_installation.get_app_info('EC', l_status, l_industry, l_o_schema)
440: THEN
441: IF nvl(l_status,'N') = 'N' THEN
442: oe_debug_pub.add('EC not installed - No ACK required',1);
443: oe_debug_pub.add('Exiting OE_Acknowledgment_Pvt.Process_acknowledgment',1);
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445: RETURN;
446: END IF; -- l_status is N
447: ELSE

Line 449: oe_debug_pub.add('Exiting OE_Acknowledgment_Pvt.Process_acknowledgment',1);

445: RETURN;
446: END IF; -- l_status is N
447: ELSE
448: oe_debug_pub.add('Call to fnd_installation.get_app_info is FALSE',1);
449: oe_debug_pub.add('Exiting OE_Acknowledgment_Pvt.Process_acknowledgment',1);
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451: RETURN;
452: END IF; -- call to fnd_installation
453: -- Bug fix 1633094 end

Line 467: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT' , 1 ) ;

463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'EC NOT INSTALLED - NO ACK REQUIRED' , 1 ) ;
465: END IF;
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT' , 1 ) ;
468: END IF;
469: RETURN;
470: END IF;
471:

Line 1976: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT', 0.5);

1972:
1973: x_return_status := FND_API.G_RET_STS_SUCCESS;
1974:
1975: IF l_debug_level > 0 THEN -- debug level changed to 0.5 for bug 13435459
1976: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT', 0.5);
1977: END IF;
1978:
1979: EXCEPTION
1980:

Line 1995: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT: '||SQLERRM , 1 ) ;

1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1992:
1993: WHEN OTHERS THEN
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT: '||SQLERRM , 1 ) ;
1996: END IF;
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1998:
1999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2002: (G_PKG_NAME, 'OE_Acknowledgment_Pvt.Process_Acknowledgment');

1998:
1999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2000: THEN
2001: OE_MSG_PUB.Add_Exc_Msg
2002: (G_PKG_NAME, 'OE_Acknowledgment_Pvt.Process_Acknowledgment');
2003: END IF;
2004:
2005:
2006: END Process_Acknowledgment;

Line 2488: END OE_Acknowledgment_Pvt;

2484: End Process_Acknowledgment;
2485:
2486:
2487:
2488: END OE_Acknowledgment_Pvt;