eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_LINE_UTIL dependencies on OE_DEBUG_PUB

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

2075: sort_order;
2076:
2077:
2078: --
2079: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2080: --
2081: BEGIN
2082:
2083: IF OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N' THEN

Line 2086: oe_debug_pub.add('before OPEN c_lines');

2082:
2083: IF OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N' THEN
2084: IF p_process_configurations = 'N'
2085: THEN
2086: oe_debug_pub.add('before OPEN c_lines');
2087:
2088: OPEN c_lines;
2089: oe_debug_pub.add('after OPEN c_lines');
2090: FETCH c_lines BULK COLLECT INTO

Line 2089: oe_debug_pub.add('after OPEN c_lines');

2085: THEN
2086: oe_debug_pub.add('before OPEN c_lines');
2087:
2088: OPEN c_lines;
2089: oe_debug_pub.add('after OPEN c_lines');
2090: FETCH c_lines BULK COLLECT INTO
2091: p_line_rec.ACCOUNTING_RULE_ID
2092: ,p_line_rec.ACCOUNTING_RULE_DURATION
2093: ,p_line_rec.ACTUAL_ARRIVAL_DATE

Line 2414: oe_debug_pub.add('before OPEN c_lines1');

2410:
2411: else -- when p_process_configurations in Y
2412:
2413: IF l_debug_level > 0 THEN
2414: oe_debug_pub.add('before OPEN c_lines1');
2415: END IF;
2416:
2417: OPEN c_lines1;
2418:

Line 2420: oe_debug_pub.add('after OPEN c_lines1');

2416:
2417: OPEN c_lines1;
2418:
2419: IF l_debug_level > 0 THEN
2420: oe_debug_pub.add('after OPEN c_lines1');
2421: END IF;
2422:
2423: FETCH c_lines1 BULK COLLECT INTO
2424: p_line_rec.ACCOUNTING_RULE_ID

Line 2752: oe_debug_pub.add('before OPEN c_lines_rtrim');

2748: -- This code is added to rtrim text columns. It is controlled by the
2749: -- input parameter to HVOP order import program.
2750: IF p_process_configurations = 'N'
2751: THEN
2752: oe_debug_pub.add('before OPEN c_lines_rtrim');
2753: OPEN c_lines_rtrim;
2754: oe_debug_pub.add('after OPEN c_lines_rtrim');
2755: ------------------------------------------------------------------------------
2756:

Line 2754: oe_debug_pub.add('after OPEN c_lines_rtrim');

2750: IF p_process_configurations = 'N'
2751: THEN
2752: oe_debug_pub.add('before OPEN c_lines_rtrim');
2753: OPEN c_lines_rtrim;
2754: oe_debug_pub.add('after OPEN c_lines_rtrim');
2755: ------------------------------------------------------------------------------
2756:
2757: FETCH c_lines_rtrim BULK COLLECT INTO
2758: p_line_rec.ACCOUNTING_RULE_ID

Line 3076: oe_debug_pub.add('before OPEN c_lines1_rtrim');

3072: ,p_line_rec.fulfillment_base ----ER#14763609
3073: ;
3074: else -- p_process_configuration=y
3075: IF l_debug_level > 0 THEN
3076: oe_debug_pub.add('before OPEN c_lines1_rtrim');
3077: END IF;
3078:
3079: OPEN c_lines1_rtrim;
3080:

Line 3082: oe_debug_pub.add('after OPEN c_lines1_rtrim');

3078:
3079: OPEN c_lines1_rtrim;
3080:
3081: IF l_debug_level > 0 THEN
3082: oe_debug_pub.add('after OPEN c_lines1_rtrim');
3083: END IF;
3084:
3085: FETCH c_lines1_rtrim BULK COLLECT INTO
3086: p_line_rec.ACCOUNTING_RULE_ID

Line 3419: oe_debug_pub.add('after bulk collect');

3415: if (p_line_rec.header_index.count < p_line_rec.line_id.count)
3416: then
3417: p_line_rec.header_index.extend(p_line_rec.line_id.count - p_line_rec.header_index.count);
3418: end if;
3419: oe_debug_pub.add('after bulk collect');
3420: EXCEPTION
3421: WHEN OTHERS THEN
3422: IF l_debug_level > 0 THEN
3423: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;

Line 3423: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;

3419: oe_debug_pub.add('after bulk collect');
3420: EXCEPTION
3421: WHEN OTHERS THEN
3422: IF l_debug_level > 0 THEN
3423: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;
3424: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
3425: END IF;
3426: OE_BULK_MSG_PUB.Add_Exc_Msg
3427: ( G_PKG_NAME

Line 3424: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

3420: EXCEPTION
3421: WHEN OTHERS THEN
3422: IF l_debug_level > 0 THEN
3423: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;
3424: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
3425: END IF;
3426: OE_BULK_MSG_PUB.Add_Exc_Msg
3427: ( G_PKG_NAME
3428: , 'Load_Lines'

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

3441: (p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE)
3442: IS
3443: ctr NUMBER;
3444: --
3445: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3446: --
3447: BEGIN
3448:
3449: ctr := p_line_rec.line_id.count;

Line 4087: oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;

4083:
4084: EXCEPTION
4085: WHEN OTHERS THEN
4086: IF l_debug_level > 0 THEN
4087: oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;
4088: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4089: END IF;
4090: OE_BULK_MSG_PUB.Add_Exc_Msg
4091: ( G_PKG_NAME

Line 4088: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

4084: EXCEPTION
4085: WHEN OTHERS THEN
4086: IF l_debug_level > 0 THEN
4087: oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;
4088: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4089: END IF;
4090: OE_BULK_MSG_PUB.Add_Exc_Msg
4091: ( G_PKG_NAME
4092: , 'Insert_Lines'

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

4100: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4101: )
4102: IS
4103: --
4104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4105: --
4106: BEGIN
4107:
4108: p_line_rec.ACCOUNTING_RULE_ID.extend(p_count);

Line 4418: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;

4414:
4415: EXCEPTION
4416: WHEN OTHERS THEN
4417: IF l_debug_level > 0 THEN
4418: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;
4419: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4420: END IF;
4421: OE_BULK_MSG_PUB.Add_Exc_Msg
4422: ( G_PKG_NAME

Line 4419: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

4415: EXCEPTION
4416: WHEN OTHERS THEN
4417: IF l_debug_level > 0 THEN
4418: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;
4419: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4420: END IF;
4421: OE_BULK_MSG_PUB.Add_Exc_Msg
4422: ( G_PKG_NAME
4423: , 'Extend_Line_Rec'

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

4431: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4432: )
4433: IS
4434: --
4435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4436: --
4437: BEGIN
4438:
4439: p_line_rec.ACCOUNTING_RULE_ID.extend(p_count,p_parent_index);

Line 4755: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;

4751: p_line_rec.IB_Installed_at_Location.extend(p_count,p_parent_index);
4752: EXCEPTION
4753: WHEN OTHERS THEN
4754: IF l_debug_level > 0 THEN
4755: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;
4756: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4757: END IF;
4758: OE_BULK_MSG_PUB.Add_Exc_Msg
4759: ( G_PKG_NAME

Line 4756: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

4752: EXCEPTION
4753: WHEN OTHERS THEN
4754: IF l_debug_level > 0 THEN
4755: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;
4756: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4757: END IF;
4758: OE_BULK_MSG_PUB.Add_Exc_Msg
4759: ( G_PKG_NAME
4760: , 'Extend_Inc_Item_Rec'

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

4780: l_on_booking_hold BOOLEAN := FALSE;
4781: l_on_scheduling_hold BOOLEAN := FALSE;
4782: l_ii_on_hold_count NUMBER := 0;
4783: --
4784: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4785: --
4786: l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
4787: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
4788: BEGIN

Line 4796: oe_debug_pub.add( 'INDEX :'||L_INDEX ) ;

4792:
4793: FOR I IN 1..p_ii_count LOOP
4794:
4795: IF l_debug_level > 0 THEN
4796: oe_debug_pub.add( 'INDEX :'||L_INDEX ) ;
4797: END IF;
4798:
4799: p_line_rec.COMPONENT_CODE(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_CODE;
4800: p_line_rec.COMPONENT_NUMBER(l_index) := l_component_number;

Line 4855: oe_debug_pub.add('Worflow Process for ii :'||l_process_name);

4851: OE_BULK_MSG_PUB.Add('Y','ERROR');
4852: RAISE FND_API.G_EXC_ERROR;
4853: ELSE
4854: IF l_debug_level > 0 THEN
4855: oe_debug_pub.add('Worflow Process for ii :'||l_process_name);
4856: END IF;
4857:
4858: p_line_rec.wf_process_name(l_index) := l_process_name;
4859: END IF;

Line 5012: oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;

5008:
5009: EXCEPTION
5010: WHEN OTHERS THEN
5011: IF l_debug_level > 0 THEN
5012: oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;
5013: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5014: END IF;
5015: OE_BULK_MSG_PUB.Add_Exc_Msg
5016: ( G_PKG_NAME

Line 5013: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

5009: EXCEPTION
5010: WHEN OTHERS THEN
5011: IF l_debug_level > 0 THEN
5012: oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;
5013: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5014: END IF;
5015: OE_BULK_MSG_PUB.Add_Exc_Msg
5016: ( G_PKG_NAME
5017: , 'Assign_Included_Items'

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

5030: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
5031: )
5032: IS
5033: --
5034: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5035: --
5036: BEGIN
5037:
5038: IF p_line_scredit_rec.header_id.COUNT = 0 THEN

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

5149: AND wi.inventory_item_id = be.component_item_id
5150: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5151: ORDER BY be.sort_order;
5152: --
5153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5154: --
5155: BEGIN
5156:
5157: ------------------------------------------------------------------

Line 5211: oe_debug_pub.add( 'START INDEX :'||L_INDEX ) ;

5207:
5208: l_index := G_INC_ITEM_TBL.COUNT + 1;
5209:
5210: IF l_debug_level > 0 THEN
5211: oe_debug_pub.add( 'START INDEX :'||L_INDEX ) ;
5212: END IF;
5213: G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index := l_index;
5214:
5215: l_ship_from_org_id := p_line_rec.ship_from_org_id(p_parent_index);

Line 5242: oe_debug_pub.add( 'END INDEX :'||L_INDEX ) ;

5238:
5239: CLOSE c_inc_items;
5240:
5241: IF l_debug_level > 0 THEN
5242: oe_debug_pub.add( 'END INDEX :'||L_INDEX ) ;
5243: END IF;
5244: G_KIT_ITEM_TBL(l_kit_item_id).ii_count :=
5245: l_index - G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index;
5246:

Line 5284: oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;

5280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5282: WHEN OTHERS THEN
5283: IF l_debug_level > 0 THEN
5284: oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;
5285: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5286: END IF;
5287: OE_BULK_MSG_PUB.Add_Exc_Msg
5288: ( G_PKG_NAME

Line 5285: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

5281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5282: WHEN OTHERS THEN
5283: IF l_debug_level > 0 THEN
5284: oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;
5285: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5286: END IF;
5287: OE_BULK_MSG_PUB.Add_Exc_Msg
5288: ( G_PKG_NAME
5289: , 'Append_Included_Items'