DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on OE_BULK_ORDER_PVT

Line 1: PACKAGE BODY OE_BULK_ORDER_PVT AS

1: PACKAGE BODY OE_BULK_ORDER_PVT AS
2: /* $Header: OEBVORDB.pls 120.2.12010000.5 2009/01/08 15:42:07 smanian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_ORDER_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_ORDER_PVT';

1: PACKAGE BODY OE_BULK_ORDER_PVT AS
2: /* $Header: OEBVORDB.pls 120.2.12010000.5 2009/01/08 15:42:07 smanian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_ORDER_PVT';
5:
6:
7: ---------------------------------------------------------------
8: -- LOCAL PROCEDURES

Line 266: l_header_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;

262: )
263: IS
264: l_start_time NUMBER;
265: l_end_time NUMBER;
266: l_header_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
267: --
268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
269: --
270: BEGIN

Line 435: l_line_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;

431: IS
432: -- l_line_rec LINE_REC_TYPE;
433: l_start_time NUMBER;
434: l_end_time NUMBER;
435: l_line_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN

Line 651: (p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

647: SELECT hsecs INTO l_start_time from v$timer;
648: end if;
649:
650: OE_Bulk_Schedule_Util.Schedule_Orders
651: (p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC
652: ,p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
653: ,x_return_status => l_return_status
654: );
655:

Line 652: ,p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC

648: end if;
649:
650: OE_Bulk_Schedule_Util.Schedule_Orders
651: (p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC
652: ,p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
653: ,x_return_status => l_return_status
654: );
655:
656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 693: (p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC

689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('before calling OE_BULK_PRICEORDER_PVT.Price_Orders');
691: END IF;
692: OE_BULK_PRICEORDER_PVT.Price_Orders
693: (p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
694: ,p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC
695: ,p_adjustments_exist => p_adjustments_exist --pibadj
696: ,x_return_status => l_return_status
697: );

Line 694: ,p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

690: oe_debug_pub.add('before calling OE_BULK_PRICEORDER_PVT.Price_Orders');
691: END IF;
692: OE_BULK_PRICEORDER_PVT.Price_Orders
693: (p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
694: ,p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC
695: ,p_adjustments_exist => p_adjustments_exist --pibadj
696: ,x_return_status => l_return_status
697: );
698:

Line 936: OE_BULK_PRICEORDER_PVT.credit_check(OE_BULK_ORDER_PVT.G_HEADER_REC);

932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pricing is (sec) '
933: ||((l_end_time-l_start_time)/100));
934:
935: ELSIF (G_CC_REQUIRED = 'Y' and l_credit_check_method = 'NEW') THEN --bug 4558078
936: OE_BULK_PRICEORDER_PVT.credit_check(OE_BULK_ORDER_PVT.G_HEADER_REC);
937: END IF;
938: --PIB }
939:
940: -------------------------------------------------------------------

Line 1405: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)

1401: RETURN 'N';
1402: END GET_FLEX_ENABLED_FLAG;
1403:
1404: PROCEDURE mark_header_error(p_header_index IN NUMBER,
1405: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
1406: IS
1407: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;
1408: --
1409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1407: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;

1403:
1404: PROCEDURE mark_header_error(p_header_index IN NUMBER,
1405: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
1406: IS
1407: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;
1408: --
1409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1410: --
1411: BEGIN

Line 1414: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;

1410: --
1411: BEGIN
1412:
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1415: oe_debug_pub.add('The error count is '|| error_count);
1416: END IF;
1417:
1418: error_count := error_count + 1;

Line 1420: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);

1416: END IF;
1417:
1418: error_count := error_count + 1;
1419:
1420: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
1421: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
1422: := p_header_rec.order_source_id(p_header_index);
1423:
1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

Line 1421: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)

1417:
1418: error_count := error_count + 1;
1419:
1420: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
1421: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
1422: := p_header_rec.order_source_id(p_header_index);
1423:
1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)

Line 1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

1420: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
1421: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
1422: := p_header_rec.order_source_id(p_header_index);
1423:
1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
1426: := p_header_rec.orig_sys_document_ref(p_header_index);
1427:
1428: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);

Line 1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)

1421: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
1422: := p_header_rec.order_source_id(p_header_index);
1423:
1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
1426: := p_header_rec.orig_sys_document_ref(p_header_index);
1427:
1428: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)

Line 1428: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);

1424: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
1426: := p_header_rec.orig_sys_document_ref(p_header_index);
1427:
1428: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
1430: := p_header_rec.header_id(p_header_index);
1431:
1432: IF l_debug_level > 0 THEN

Line 1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)

1425: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
1426: := p_header_rec.orig_sys_document_ref(p_header_index);
1427:
1428: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
1430: := p_header_rec.header_id(p_header_index);
1431:
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;

Line 1433: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;

1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
1430: := p_header_rec.header_id(p_header_index);
1431:
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1434: END IF;
1435:
1436: EXCEPTION
1437: WHEN OTHERS THEN

Line 1452: END OE_BULK_ORDER_PVT;

1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END Mark_Header_Error;
1450:
1451:
1452: END OE_BULK_ORDER_PVT;