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 FND_API

Line 46: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

42: g_hold_source_rec.HOLD_ENTITY_CODE.DELETE;
43: g_hold_source_rec.HOLD_ENTITY_ID.DELETE;
44:
45: EXCEPTION
46: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: WHEN OTHERS THEN
49: OE_BULK_MSG_PUB.Add_Exc_Msg
50: ( G_PKG_NAME

Line 47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

43: g_hold_source_rec.HOLD_ENTITY_ID.DELETE;
44:
45: EXCEPTION
46: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: WHEN OTHERS THEN
49: OE_BULK_MSG_PUB.Add_Exc_Msg
50: ( G_PKG_NAME
51: , 'Initialize_Holds_Tbl'

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: OE_BULK_MSG_PUB.Add_Exc_Msg
50: ( G_PKG_NAME
51: , 'Initialize_Holds_Tbl'
52: );
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END Initialize_Holds_Tbl;
55:
56: PROCEDURE Load_Hold_Sources
57: IS

Line 891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
893: WHEN OTHERS THEN
894: OE_BULK_MSG_PUB.Add_Exc_Msg
895: ( G_PKG_NAME

Line 892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
893: WHEN OTHERS THEN
894: OE_BULK_MSG_PUB.Add_Exc_Msg
895: ( G_PKG_NAME
896: , 'Load_Hold_Sources'

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: OE_BULK_MSG_PUB.Add_Exc_Msg
895: ( G_PKG_NAME
896: , 'Load_Hold_Sources'
897: );
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END Load_Hold_Sources;
900:
901:
902:

Line 2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
2455: OE_BULK_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME

Line 2453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2455: OE_BULK_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Evaluate_Holds'

Line 2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2455: OE_BULK_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Evaluate_Holds'
2458: );
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: END Evaluate_Holds;
2461:
2462: --ER#7479609 end
2463:

Line 2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2924:
2925: END IF;
2926:
2927: EXCEPTION
2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: WHEN OTHERS THEN
2931: OE_BULK_MSG_PUB.Add_Exc_Msg
2932: ( G_PKG_NAME

Line 2929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2925: END IF;
2926:
2927: EXCEPTION
2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: WHEN OTHERS THEN
2931: OE_BULK_MSG_PUB.Add_Exc_Msg
2932: ( G_PKG_NAME
2933: , 'Evaluate_Holds'

Line 2935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2931: OE_BULK_MSG_PUB.Add_Exc_Msg
2932: ( G_PKG_NAME
2933: , 'Evaluate_Holds'
2934: );
2935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2936: END Evaluate_Holds;
2937:
2938: PROCEDURE Extend_Holds_Tbl
2939: IS

Line 2951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2947: G_hold_top_model_line_id.EXTEND;
2948: G_hold_activity_name.EXTEND;
2949:
2950: EXCEPTION
2951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2953: WHEN OTHERS THEN
2954: OE_BULK_MSG_PUB.Add_Exc_Msg
2955: ( G_PKG_NAME

Line 2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2948: G_hold_activity_name.EXTEND;
2949:
2950: EXCEPTION
2951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2953: WHEN OTHERS THEN
2954: OE_BULK_MSG_PUB.Add_Exc_Msg
2955: ( G_PKG_NAME
2956: , 'Extend_Holds_Tbl'

Line 2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2954: OE_BULK_MSG_PUB.Add_Exc_Msg
2955: ( G_PKG_NAME
2956: , 'Extend_Holds_Tbl'
2957: );
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END Extend_Holds_Tbl;
2960:
2961: PROCEDURE Create_Holds
2962: IS

Line 3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3061: OE_BULK_MSG_PUB.Add_Exc_Msg
3062: ( G_PKG_NAME
3063: , 'Create_Holds'
3064: );
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3066: END Create_Holds;
3067:
3068: PROCEDURE Mark_Hold(p_header_id IN NUMBER,
3069: p_line_id IN NUMBER,

Line 3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3109: OE_BULK_MSG_PUB.Add_Exc_Msg
3110: ( G_PKG_NAME
3111: , 'Mark_Hold'
3112: );
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: END Mark_Hold;
3115:
3116: FUNCTION Is_Header_On_Hold(
3117: p_header_id IN NUMBER,

Line 3162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3158:
3159: RETURN FALSE;
3160:
3161: EXCEPTION
3162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: WHEN OTHERS THEN
3165: OE_BULK_MSG_PUB.Add_Exc_Msg
3166: ( G_PKG_NAME

Line 3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3159: RETURN FALSE;
3160:
3161: EXCEPTION
3162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: WHEN OTHERS THEN
3165: OE_BULK_MSG_PUB.Add_Exc_Msg
3166: ( G_PKG_NAME
3167: , 'Is_Header_On_Hold'

Line 3169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3165: OE_BULK_MSG_PUB.Add_Exc_Msg
3166: ( G_PKG_NAME
3167: , 'Is_Header_On_Hold'
3168: );
3169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3170: END Is_Header_On_Hold;
3171:
3172: FUNCTION Is_Line_On_Hold(
3173: p_header_id IN NUMBER,

Line 3253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3249:
3250: RETURN FALSE;
3251:
3252: EXCEPTION
3253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3255: WHEN OTHERS THEN
3256: OE_BULK_MSG_PUB.Add_Exc_Msg
3257: ( G_PKG_NAME

Line 3254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3250: RETURN FALSE;
3251:
3252: EXCEPTION
3253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3255: WHEN OTHERS THEN
3256: OE_BULK_MSG_PUB.Add_Exc_Msg
3257: ( G_PKG_NAME
3258: , 'Is_Line_On_Hold'

Line 3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3256: OE_BULK_MSG_PUB.Add_Exc_Msg
3257: ( G_PKG_NAME
3258: , 'Is_Line_On_Hold'
3259: );
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: END Is_Line_On_Hold;
3262:
3263: PROCEDURE Apply_GSA_Hold(p_header_id IN NUMBER,
3264: p_line_id IN NUMBER,

Line 3278: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3281:
3282: -- Assign memory

Line 3314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
3316:
3317: END Apply_GSA_Hold;
3318: