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 145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

141: l_orig_sys_line_ref VARCHAR2(50);
142: -- Fix for bug 2469894
143: l_header_id NUMBER;
144: --
145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
146: --
147: -- Fix for bug 3217280
148: l_org_id NUMBER;
149: BEGIN

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

268: GROUP BY l.source_document_line_id;
269:
270:
271: --
272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
273: --
274: BEGIN
275:
276: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

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

366: x_order_number NUMBER;
367: l_orig_sys_document_ref VARCHAR2(50);
368: l_orig_sys_line_ref VARCHAR2(50);
369: --
370: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
371: --
372: -- Fix for bug 3217280
373: l_org_id NUMBER;
374: BEGIN

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

448: RETURN NUMBER
449: IS
450: x_header_id NUMBER;
451: --
452: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
453: --
454: -- Fix for bug 3217280
455: l_org_id NUMBER;
456: l_orig_sys_line_ref VARCHAR2(50);

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

535: )
536: RETURN NUMBER IS
537: x_req_header_id NUMBER;
538: --
539: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
540: --
541: BEGIN
542:
543: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

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

610: AND l.source_document_line_id = p_requisition_line_id
611: AND l.order_source_id = p_order_source_id
612: AND l.shipped_quantity IS NOT NULL;
613: --
614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: BEGIN
617:
618: oe_debug_pub.add('Entering OEXPIMIB.Get_Line_Id');

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

614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: BEGIN
617:
618: oe_debug_pub.add('Entering OEXPIMIB.Get_Line_Id');
619:
620: x_return_status := fnd_api.g_ret_sts_success;
621:
622: -- for bug 8555888

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

643:
644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: oe_debug_pub.add('Unexpected error: '||sqlerrm);
648: If oe_msg_pub.check_msg_level(oe_msg_pub.g_msg_lvl_unexp_error) Then
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: oe_msg_pub.add_exc_Msg (g_pkg_name, 'oe_order_import_interop_pub');
651: END IF;

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

675: FROM oe_drop_ship_sources d
676: WHERE d.header_id = p_header_id
677: And d.requisition_header_id is not null;
678: --
679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
680: --
681: BEGIN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add('Entering OEXPIMIB.Get_Requisition_header_ids');

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

679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
680: --
681: BEGIN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add('Entering OEXPIMIB.Get_Requisition_header_ids');
684: END IF;
685:
686: Open header_Id_Cur;
687: Loop

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

694:
695: EXCEPTION
696: WHEN OTHERS THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Unexpected error: '||sqlerrm);
699: END IF;
700: If oe_msg_pub.check_msg_level(oe_msg_pub.g_msg_lvl_unexp_error) Then
701: oe_msg_pub.add_exc_Msg (g_pkg_name, 'oe_order_import_interop_pub');
702: END IF;