APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on OE_DEBUG_PUB

Line 46: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

42: l_orig_sys_line_ref VARCHAR2(50);
43: -- Fix for bug 2469894
44: l_header_id NUMBER;
45: --
46: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
47: --
48: -- Fix for bug 3217280
49: l_org_id NUMBER;
50: BEGIN

Line 140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

136: l_orig_sys_line_ref VARCHAR2(50);
137: -- Fix for bug 2469894
138: l_header_id NUMBER;
139: --
140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
141: --
142: -- Fix for bug 3217280
143: l_org_id NUMBER;
144: BEGIN

Line 262: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

258: GROUP BY l.source_document_line_id;
259:
260:
261: --
262: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
263: --
264: BEGIN
265:
266: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

Line 355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

351: x_order_number NUMBER;
352: l_orig_sys_document_ref VARCHAR2(50);
353: l_orig_sys_line_ref VARCHAR2(50);
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: -- Fix for bug 3217280
358: l_org_id NUMBER;
359: BEGIN

Line 436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

432: RETURN NUMBER
433: IS
434: x_header_id NUMBER;
435: --
436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
437: --
438: -- Fix for bug 3217280
439: l_org_id NUMBER;
440: l_orig_sys_line_ref VARCHAR2(50);

Line 518: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

514: )
515: RETURN NUMBER IS
516: x_req_header_id NUMBER;
517: --
518: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
519: --
520: BEGIN
521:
522: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

Line 593: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

589: AND l.source_document_line_id = p_requisition_line_id
590: AND l.order_source_id = p_order_source_id
591: AND l.shipped_quantity IS NOT NULL;
592: --
593: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
594: --
595: BEGIN
596:
597: oe_debug_pub.add('Entering OEXPIMIB.Get_Line_Id');

Line 597: oe_debug_pub.add('Entering OEXPIMIB.Get_Line_Id');

593: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
594: --
595: BEGIN
596:
597: oe_debug_pub.add('Entering OEXPIMIB.Get_Line_Id');
598:
599: x_return_status := fnd_api.g_ret_sts_success;
600: SELECT h.header_id
601: INTO l_header_id

Line 619: oe_debug_pub.add('Unexpected error: '||sqlerrm);

615:
616:
617: EXCEPTION
618: WHEN OTHERS THEN
619: oe_debug_pub.add('Unexpected error: '||sqlerrm);
620: If oe_msg_pub.check_msg_level(oe_msg_pub.g_msg_lvl_unexp_error) Then
621: x_return_status := fnd_api.g_ret_sts_unexp_error;
622: oe_msg_pub.add_exc_Msg (g_pkg_name, 'oe_order_import_interop_pub');
623: END IF;

Line 651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

647: FROM oe_drop_ship_sources d
648: WHERE d.header_id = p_header_id
649: And d.requisition_header_id is not null;
650: --
651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
652: --
653: BEGIN
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add('Entering OEXPIMIB.Get_Requisition_header_ids');

Line 655: oe_debug_pub.add('Entering OEXPIMIB.Get_Requisition_header_ids');

651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
652: --
653: BEGIN
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add('Entering OEXPIMIB.Get_Requisition_header_ids');
656: END IF;
657:
658: Open header_Id_Cur;
659: Loop

Line 670: oe_debug_pub.add('Unexpected error: '||sqlerrm);

666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('Unexpected error: '||sqlerrm);
671: END IF;
672: If oe_msg_pub.check_msg_level(oe_msg_pub.g_msg_lvl_unexp_error) Then
673: oe_msg_pub.add_exc_Msg (g_pkg_name, 'oe_order_import_interop_pub');
674: END IF;