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

2069: sort_order;
2070:
2071:
2072: --
2073: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2074: --
2075: BEGIN
2076:
2077: IF OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N' THEN

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

2076:
2077: IF OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N' THEN
2078: IF p_process_configurations = 'N'
2079: THEN
2080: oe_debug_pub.add('before OPEN c_lines');
2081:
2082: OPEN c_lines;
2083: oe_debug_pub.add('after OPEN c_lines');
2084: FETCH c_lines BULK COLLECT INTO

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

2079: THEN
2080: oe_debug_pub.add('before OPEN c_lines');
2081:
2082: OPEN c_lines;
2083: oe_debug_pub.add('after OPEN c_lines');
2084: FETCH c_lines BULK COLLECT INTO
2085: p_line_rec.ACCOUNTING_RULE_ID
2086: ,p_line_rec.ACCOUNTING_RULE_DURATION
2087: ,p_line_rec.ACTUAL_ARRIVAL_DATE

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

2403:
2404: else -- when p_process_configurations in Y
2405:
2406: IF l_debug_level > 0 THEN
2407: oe_debug_pub.add('before OPEN c_lines1');
2408: END IF;
2409:
2410: OPEN c_lines1;
2411:

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

2409:
2410: OPEN c_lines1;
2411:
2412: IF l_debug_level > 0 THEN
2413: oe_debug_pub.add('after OPEN c_lines1');
2414: END IF;
2415:
2416: FETCH c_lines1 BULK COLLECT INTO
2417: p_line_rec.ACCOUNTING_RULE_ID

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

2740: -- This code is added to rtrim text columns. It is controlled by the
2741: -- input parameter to HVOP order import program.
2742: IF p_process_configurations = 'N'
2743: THEN
2744: oe_debug_pub.add('before OPEN c_lines_rtrim');
2745: OPEN c_lines_rtrim;
2746: oe_debug_pub.add('after OPEN c_lines_rtrim');
2747: ------------------------------------------------------------------------------
2748:

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

2742: IF p_process_configurations = 'N'
2743: THEN
2744: oe_debug_pub.add('before OPEN c_lines_rtrim');
2745: OPEN c_lines_rtrim;
2746: oe_debug_pub.add('after OPEN c_lines_rtrim');
2747: ------------------------------------------------------------------------------
2748:
2749: FETCH c_lines_rtrim BULK COLLECT INTO
2750: p_line_rec.ACCOUNTING_RULE_ID

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

3063: ,p_line_rec.IB_Installed_at_Location
3064: ;
3065: else -- p_process_configuration=y
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add('before OPEN c_lines1_rtrim');
3068: END IF;
3069:
3070: OPEN c_lines1_rtrim;
3071:

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

3069:
3070: OPEN c_lines1_rtrim;
3071:
3072: IF l_debug_level > 0 THEN
3073: oe_debug_pub.add('after OPEN c_lines1_rtrim');
3074: END IF;
3075:
3076: FETCH c_lines1_rtrim BULK COLLECT INTO
3077: p_line_rec.ACCOUNTING_RULE_ID

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

3405: if (p_line_rec.header_index.count < p_line_rec.line_id.count)
3406: then
3407: p_line_rec.header_index.extend(p_line_rec.line_id.count - p_line_rec.header_index.count);
3408: end if;
3409: oe_debug_pub.add('after bulk collect');
3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF l_debug_level > 0 THEN
3413: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;

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

3409: oe_debug_pub.add('after bulk collect');
3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF l_debug_level > 0 THEN
3413: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;
3414: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
3415: END IF;
3416: OE_BULK_MSG_PUB.Add_Exc_Msg
3417: ( G_PKG_NAME

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

3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF l_debug_level > 0 THEN
3413: oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;
3414: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
3415: END IF;
3416: OE_BULK_MSG_PUB.Add_Exc_Msg
3417: ( G_PKG_NAME
3418: , 'Load_Lines'

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

3431: (p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE)
3432: IS
3433: ctr NUMBER;
3434: --
3435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3436: --
3437: BEGIN
3438:
3439: ctr := p_line_rec.line_id.count;

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

4071:
4072: EXCEPTION
4073: WHEN OTHERS THEN
4074: IF l_debug_level > 0 THEN
4075: oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;
4076: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4077: END IF;
4078: OE_BULK_MSG_PUB.Add_Exc_Msg
4079: ( G_PKG_NAME

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

4072: EXCEPTION
4073: WHEN OTHERS THEN
4074: IF l_debug_level > 0 THEN
4075: oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;
4076: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4077: END IF;
4078: OE_BULK_MSG_PUB.Add_Exc_Msg
4079: ( G_PKG_NAME
4080: , 'Insert_Lines'

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

4088: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4089: )
4090: IS
4091: --
4092: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4093: --
4094: BEGIN
4095:
4096: p_line_rec.ACCOUNTING_RULE_ID.extend(p_count);

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

4402:
4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: IF l_debug_level > 0 THEN
4406: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;
4407: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4408: END IF;
4409: OE_BULK_MSG_PUB.Add_Exc_Msg
4410: ( G_PKG_NAME

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

4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: IF l_debug_level > 0 THEN
4406: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;
4407: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4408: END IF;
4409: OE_BULK_MSG_PUB.Add_Exc_Msg
4410: ( G_PKG_NAME
4411: , 'Extend_Line_Rec'

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

4419: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4420: )
4421: IS
4422: --
4423: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4424: --
4425: BEGIN
4426:
4427: p_line_rec.ACCOUNTING_RULE_ID.extend(p_count,p_parent_index);

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

4739: p_line_rec.IB_Installed_at_Location.extend(p_count,p_parent_index);
4740: EXCEPTION
4741: WHEN OTHERS THEN
4742: IF l_debug_level > 0 THEN
4743: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;
4744: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4745: END IF;
4746: OE_BULK_MSG_PUB.Add_Exc_Msg
4747: ( G_PKG_NAME

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

4740: EXCEPTION
4741: WHEN OTHERS THEN
4742: IF l_debug_level > 0 THEN
4743: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;
4744: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4745: END IF;
4746: OE_BULK_MSG_PUB.Add_Exc_Msg
4747: ( G_PKG_NAME
4748: , 'Extend_Inc_Item_Rec'

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

4768: l_on_booking_hold BOOLEAN := FALSE;
4769: l_on_scheduling_hold BOOLEAN := FALSE;
4770: l_ii_on_hold_count NUMBER := 0;
4771: --
4772: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4773: --
4774: l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
4775: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
4776: BEGIN

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

4780:
4781: FOR I IN 1..p_ii_count LOOP
4782:
4783: IF l_debug_level > 0 THEN
4784: oe_debug_pub.add( 'INDEX :'||L_INDEX ) ;
4785: END IF;
4786:
4787: p_line_rec.COMPONENT_CODE(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_CODE;
4788: p_line_rec.COMPONENT_NUMBER(l_index) := l_component_number;

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

4839: OE_BULK_MSG_PUB.Add('Y','ERROR');
4840: RAISE FND_API.G_EXC_ERROR;
4841: ELSE
4842: IF l_debug_level > 0 THEN
4843: oe_debug_pub.add('Worflow Process for ii :'||l_process_name);
4844: END IF;
4845:
4846: p_line_rec.wf_process_name(l_index) := l_process_name;
4847: END IF;

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

4987:
4988: EXCEPTION
4989: WHEN OTHERS THEN
4990: IF l_debug_level > 0 THEN
4991: oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;
4992: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4993: END IF;
4994: OE_BULK_MSG_PUB.Add_Exc_Msg
4995: ( G_PKG_NAME

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

4988: EXCEPTION
4989: WHEN OTHERS THEN
4990: IF l_debug_level > 0 THEN
4991: oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;
4992: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4993: END IF;
4994: OE_BULK_MSG_PUB.Add_Exc_Msg
4995: ( G_PKG_NAME
4996: , 'Assign_Included_Items'

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

5009: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
5010: )
5011: IS
5012: --
5013: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5014: --
5015: BEGIN
5016:
5017: IF p_line_scredit_rec.header_id.COUNT = 0 THEN

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

5128: AND wi.inventory_item_id = be.component_item_id
5129: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5130: ORDER BY be.sort_order;
5131: --
5132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5133: --
5134: BEGIN
5135:
5136: ------------------------------------------------------------------

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

5186:
5187: l_index := G_INC_ITEM_TBL.COUNT + 1;
5188:
5189: IF l_debug_level > 0 THEN
5190: oe_debug_pub.add( 'START INDEX :'||L_INDEX ) ;
5191: END IF;
5192: G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index := l_index;
5193:
5194: l_ship_from_org_id := p_line_rec.ship_from_org_id(p_parent_index);

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

5217:
5218: CLOSE c_inc_items;
5219:
5220: IF l_debug_level > 0 THEN
5221: oe_debug_pub.add( 'END INDEX :'||L_INDEX ) ;
5222: END IF;
5223: G_KIT_ITEM_TBL(l_kit_item_id).ii_count :=
5224: l_index - G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index;
5225:

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

5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: IF l_debug_level > 0 THEN
5263: oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;
5264: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5265: END IF;
5266: OE_BULK_MSG_PUB.Add_Exc_Msg
5267: ( G_PKG_NAME

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

5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: IF l_debug_level > 0 THEN
5263: oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;
5264: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5265: END IF;
5266: OE_BULK_MSG_PUB.Add_Exc_Msg
5267: ( G_PKG_NAME
5268: , 'Append_Included_Items'