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.8.12010000.2 2008/08/04 15:05:44 amallik 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.8.12010000.2 2008/08/04 15:05:44 amallik 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: END IF;
434:
435: /***
436: -- Bug fix 1633094 start

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

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

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

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

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

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

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

1961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1962:
1963: WHEN OTHERS THEN
1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PVT.PROCESS_ACKNOWLEDGMENT: '||SQLERRM , 1 ) ;
1966: END IF;
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1968:
1969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1968:
1969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1970: THEN
1971: OE_MSG_PUB.Add_Exc_Msg
1972: (G_PKG_NAME, 'OE_Acknowledgment_Pvt.Process_Acknowledgment');
1973: END IF;
1974:
1975:
1976: END Process_Acknowledgment;

Line 2458: END OE_Acknowledgment_Pvt;

2454: End Process_Acknowledgment;
2455:
2456:
2457:
2458: END OE_Acknowledgment_Pvt;