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_HOLDS_PVT dependencies on OE_DEBUG_PUB

Line 91: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

87:
88: l_count BINARY_INTEGER;
89: BEGIN
90:
91: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
92: -- Clear the Globals.
93: g_hold_header_id.DELETE;
94: g_hold_line_id.DELETE;
95: g_hold_Source_Id.DELETE;

Line 223: oe_debug_pub.add('Before opening C_Hold_Sources'); --ER#7479609 debug

219:
220: CreDate_CreBy_Hold.DELETE;
221: --ER#7479609 end
222:
223: oe_debug_pub.add('Before opening C_Hold_Sources'); --ER#7479609 debug
224: -- Load the Hold Sources into Globals.
225: OPEN C_Hold_Sources;
226: FETCH C_Hold_Sources BULK COLLECT INTO
227: T_HOLD_SOURCE_ID,

Line 234: oe_debug_pub.add('After Closing C_Hold_Sources:'||T_HOLD_SOURCE_ID.COUNT); --ER#7479609 debug

230: T_HOLD_ENTITY_ID2,
231: T_HOLD_ENTITY_CODE2,
232: T_HOLD_ACTIVITY_NAME;
233: CLOSE C_Hold_Sources;
234: oe_debug_pub.add('After Closing C_Hold_Sources:'||T_HOLD_SOURCE_ID.COUNT); --ER#7479609 debug
235:
236: FOR i IN 1..T_HOLD_SOURCE_ID.COUNT LOOP
237:
238: -- Load Customer Hold Source

Line 366: oe_debug_pub.add('Before Loading payment type'); --ER#7479609 debug

362: SalesChannel_Pointer(T_HOLD_ENTITY_ID(i)) := l_count+1;
363: END IF;
364: END IF;
365:
366: oe_debug_pub.add('Before Loading payment type'); --ER#7479609 debug
367: IF T_HOLD_ENTITY_CODE(i) = 'P' AND T_HOLD_ENTITY_ID2(i) IS NULL
368: THEN
369: l_count := PaymentType_Hold.COUNT;
370: PaymentType_Hold(l_count+1).Entity_Id1 := T_HOLD_ENTITY_ID(i);

Line 714: oe_debug_pub.add('Before Loading Ware House'); --ER#7479609 debug

710:
711: END IF;
712:
713: --ER#7479609 end
714: oe_debug_pub.add('Before Loading Ware House'); --ER#7479609 debug
715: -- Load Warehouse Customer Hold Source
716: IF T_HOLD_ENTITY_CODE(i) = 'W' AND T_HOLD_ENTITY_CODE2(i) = 'C'
717: THEN
718: l_count := Warehouse_Customer_Hold.COUNT;

Line 888: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

884: --ER#7479609 end
885:
886: END LOOP;
887:
888: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
889:
890: EXCEPTION
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');

915: l_activity_name VARCHAR2(30);
916: l_inventory_item_id NUMBER;
917:
918: BEGIN
919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
920: oe_debug_pub.add('Header'||p_header_rec.header_id);
921: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
922:
923: -- Set the OUT parameter

Line 920: oe_debug_pub.add('Header'||p_header_rec.header_id);

916: l_inventory_item_id NUMBER;
917:
918: BEGIN
919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
920: oe_debug_pub.add('Header'||p_header_rec.header_id);
921: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
922:
923: -- Set the OUT parameter
924: p_on_generic_hold := FALSE;

Line 921: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);

917:
918: BEGIN
919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
920: oe_debug_pub.add('Header'||p_header_rec.header_id);
921: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
922:
923: -- Set the OUT parameter
924: p_on_generic_hold := FALSE;
925: p_on_booking_hold := FALSE;

Line 2450: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug

2446:
2447: --ER#7479609 end
2448:
2449: END IF;
2450: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug
2451: EXCEPTION
2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2454: WHEN OTHERS THEN

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

2959: END Extend_Holds_Tbl;
2960:
2961: PROCEDURE Create_Holds
2962: IS
2963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2964: l_org_id number :=mo_global.get_current_org_id; --5488209
2965: BEGIN
2966:
2967: IF l_debug_level > 0 THEN

Line 2968: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);

2964: l_org_id number :=mo_global.get_current_org_id; --5488209
2965: BEGIN
2966:
2967: IF l_debug_level > 0 THEN
2968: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);
2969: oe_debug_pub.add('No. of holds sources to create is '
2970: ||g_hold_source_rec.HOLD_SOURCE_ID.COUNT);
2971: END IF;
2972:

Line 2969: oe_debug_pub.add('No. of holds sources to create is '

2965: BEGIN
2966:
2967: IF l_debug_level > 0 THEN
2968: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);
2969: oe_debug_pub.add('No. of holds sources to create is '
2970: ||g_hold_source_rec.HOLD_SOURCE_ID.COUNT);
2971: END IF;
2972:
2973: FORALL i IN 1..G_Hold_header_id.COUNT

Line 3059: oe_debug_pub.add('In OTHERS error ' || SUBSTR(sqlerrm,1,240), 1);

3055: END IF;
3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: IF l_debug_level > 0 THEN
3059: oe_debug_pub.add('In OTHERS error ' || SUBSTR(sqlerrm,1,240), 1);
3060: END IF;
3061: OE_BULK_MSG_PUB.Add_Exc_Msg
3062: ( G_PKG_NAME
3063: , 'Create_Holds'

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

3075: p_attribute IN VARCHAR2,
3076: p_top_model_line_id IN NUMBER
3077: )
3078: IS
3079: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3080: i BINARY_INTEGER;
3081: BEGIN
3082:
3083: i := G_Hold_header_id.COUNT;

Line 3106: oe_debug_pub.add('In OTHERS error - Mark_Hold ' ||

3102:
3103: EXCEPTION
3104: WHEN OTHERS THEN
3105: IF l_debug_level > 0 THEN
3106: oe_debug_pub.add('In OTHERS error - Mark_Hold ' ||
3107: SUBSTR(sqlerrm,1,240), 1);
3108: END IF;
3109: OE_BULK_MSG_PUB.Add_Exc_Msg
3110: ( G_PKG_NAME

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

3272: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --bug 3735141
3273: )
3274: IS
3275: i BINARY_INTEGER;
3276: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3277: BEGIN
3278: x_return_status := FND_API.G_RET_STS_SUCCESS;
3279: -- Check the count of the Global Table for Hold Source Rec
3280: i := g_hold_source_rec.HOLD_ID.COUNT;

Line 3311: oe_debug_pub.add('In OTHERS error - Apply GSA Hold ' ||

3307: --bug 3735141
3308: EXCEPTION
3309: WHEN OTHERS THEN
3310: IF l_debug_level > 0 THEN
3311: oe_debug_pub.add('In OTHERS error - Apply GSA Hold ' ||
3312: SUBSTR(sqlerrm,1,240), 1);
3313: END IF;
3314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3315: --bug 3735141

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

3348: IS
3349:
3350: l_result BOOLEAN;
3351: l_header_hold_index BINARY_INTEGER;
3352: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3353:
3354: BEGIN
3355:
3356: IF l_debug_level > 0 THEN

Line 3357: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');

3353:
3354: BEGIN
3355:
3356: IF l_debug_level > 0 THEN
3357: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');
3358: oe_debug_pub.add( 'p_line_index is '||p_line_index);
3359: END IF;
3360:
3361: -- Initialize API return value to False

Line 3358: oe_debug_pub.add( 'p_line_index is '||p_line_index);

3354: BEGIN
3355:
3356: IF l_debug_level > 0 THEN
3357: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');
3358: oe_debug_pub.add( 'p_line_index is '||p_line_index);
3359: END IF;
3360:
3361: -- Initialize API return value to False
3362: l_result := FALSE;

Line 3369: oe_debug_pub.add( 'Line on Generic Hold' ||p_line_id ) ;

3365: IF G_Line_Holds_Tbl.EXISTS(p_line_index) THEN
3366: IF G_Line_Holds_Tbl(p_line_index).On_Generic_Hold = 'Y' THEN
3367:
3368: IF l_debug_level > 0 THEN
3369: oe_debug_pub.add( 'Line on Generic Hold' ||p_line_id ) ;
3370: END IF;
3371: RETURN TRUE;
3372:
3373: END IF;

Line 3382: oe_debug_pub.add( 'HEADER LEVEL HOLD EXISTS' ) ;

3378: p_hold_index => l_header_hold_index );
3379:
3380: IF l_result THEN
3381: IF l_debug_level > 0 THEN
3382: oe_debug_pub.add( 'HEADER LEVEL HOLD EXISTS' ) ;
3383: END IF;
3384: RETURN l_result;
3385: END IF;
3386:

Line 3396: oe_debug_pub.add( 'Line is part of ATO model and one of the lines

3392: IF G_Line_Holds_Tbl.EXISTS(p_ato_line_index) THEN
3393: IF G_Line_Holds_Tbl(p_ato_line_index).Any_ato_line_on_hold = 'Y' THEN
3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add( 'Line is part of ATO model and one of the lines
3397: is on Generic Hold') ;
3398: END IF;
3399: RETURN TRUE;
3400: END IF;

Line 3414: oe_debug_pub.add( 'Line is part of SMC model and one of the lines

3410: IF G_Line_Holds_Tbl(p_top_model_line_index).Any_SMC_Line_on_hold = 'Y'
3411: THEN
3412:
3413: IF l_debug_level > 0 THEN
3414: oe_debug_pub.add( 'Line is part of SMC model and one of the lines
3415: is on Generic Hold') ;
3416: END IF;
3417: RETURN TRUE;
3418: END IF;

Line 3432: oe_debug_pub.add( 'II Parent line is on Generic Hold') ;

3428: IF G_Line_Holds_Tbl(p_ii_parent_line_index).On_Generic_Hold = 'Y' AND
3429: G_Line_Holds_Tbl(p_ii_parent_line_index).hold_ii_flag = 'Y'
3430: THEN
3431: IF l_debug_level > 0 THEN
3432: oe_debug_pub.add( 'II Parent line is on Generic Hold') ;
3433: END IF;
3434: RETURN TRUE;
3435: END IF;
3436: END IF;

Line 3439: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');

3435: END IF;
3436: END IF;
3437: END IF;
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');
3440: END IF;
3441: RETURN FALSE;
3442:
3443: EXCEPTION

Line 3446: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');

3442:
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: IF l_debug_level > 0 THEN
3446: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');
3447: END IF;
3448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3449: THEN
3450: OE_MSG_PUB.Add_Exc_Msg