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 82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

78: g_hold_source_rec.HOLD_ENTITY_CODE.DELETE;
79: g_hold_source_rec.HOLD_ENTITY_ID.DELETE;
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: WHEN OTHERS THEN
85: OE_BULK_MSG_PUB.Add_Exc_Msg
86: ( G_PKG_NAME

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: g_hold_source_rec.HOLD_ENTITY_ID.DELETE;
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: WHEN OTHERS THEN
85: OE_BULK_MSG_PUB.Add_Exc_Msg
86: ( G_PKG_NAME
87: , 'Initialize_Holds_Tbl'

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: OE_BULK_MSG_PUB.Add_Exc_Msg
86: ( G_PKG_NAME
87: , 'Initialize_Holds_Tbl'
88: );
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END Initialize_Holds_Tbl;
91:
92: PROCEDURE Load_Hold_Sources
93: IS

Line 1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1374:
1375: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
1376:
1377: EXCEPTION
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1380: WHEN OTHERS THEN
1381: OE_BULK_MSG_PUB.Add_Exc_Msg
1382: ( G_PKG_NAME

Line 1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1375: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
1376:
1377: EXCEPTION
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1380: WHEN OTHERS THEN
1381: OE_BULK_MSG_PUB.Add_Exc_Msg
1382: ( G_PKG_NAME
1383: , 'Load_Hold_Sources'

Line 1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1381: OE_BULK_MSG_PUB.Add_Exc_Msg
1382: ( G_PKG_NAME
1383: , 'Load_Hold_Sources'
1384: );
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END Load_Hold_Sources;
1387:
1388:
1389:

Line 4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4048:
4049: END IF;
4050: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug
4051: EXCEPTION
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: OE_BULK_MSG_PUB.Add_Exc_Msg
4056: ( G_PKG_NAME

Line 4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4049: END IF;
4050: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug
4051: EXCEPTION
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: OE_BULK_MSG_PUB.Add_Exc_Msg
4056: ( G_PKG_NAME
4057: , 'Evaluate_Holds'

Line 4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4055: OE_BULK_MSG_PUB.Add_Exc_Msg
4056: ( G_PKG_NAME
4057: , 'Evaluate_Holds'
4058: );
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END Evaluate_Holds;
4061:
4062: --ER#7479609 end
4063:

Line 4528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4524:
4525: END IF;
4526:
4527: EXCEPTION
4528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4530: WHEN OTHERS THEN
4531: OE_BULK_MSG_PUB.Add_Exc_Msg
4532: ( G_PKG_NAME

Line 4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4525: END IF;
4526:
4527: EXCEPTION
4528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4530: WHEN OTHERS THEN
4531: OE_BULK_MSG_PUB.Add_Exc_Msg
4532: ( G_PKG_NAME
4533: , 'Evaluate_Holds'

Line 4535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4531: OE_BULK_MSG_PUB.Add_Exc_Msg
4532: ( G_PKG_NAME
4533: , 'Evaluate_Holds'
4534: );
4535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4536: END Evaluate_Holds;
4537:
4538: PROCEDURE Extend_Holds_Tbl
4539: IS

Line 4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4547: G_hold_top_model_line_id.EXTEND;
4548: G_hold_activity_name.EXTEND;
4549:
4550: EXCEPTION
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN
4554: OE_BULK_MSG_PUB.Add_Exc_Msg
4555: ( G_PKG_NAME

Line 4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4548: G_hold_activity_name.EXTEND;
4549:
4550: EXCEPTION
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN
4554: OE_BULK_MSG_PUB.Add_Exc_Msg
4555: ( G_PKG_NAME
4556: , 'Extend_Holds_Tbl'

Line 4558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4554: OE_BULK_MSG_PUB.Add_Exc_Msg
4555: ( G_PKG_NAME
4556: , 'Extend_Holds_Tbl'
4557: );
4558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4559: END Extend_Holds_Tbl;
4560:
4561: PROCEDURE Create_Holds
4562: IS

Line 4665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4661: OE_BULK_MSG_PUB.Add_Exc_Msg
4662: ( G_PKG_NAME
4663: , 'Create_Holds'
4664: );
4665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4666: END Create_Holds;
4667:
4668: PROCEDURE Mark_Hold(p_header_id IN NUMBER,
4669: p_line_id IN NUMBER,

Line 4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4709: OE_BULK_MSG_PUB.Add_Exc_Msg
4710: ( G_PKG_NAME
4711: , 'Mark_Hold'
4712: );
4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4714: END Mark_Hold;
4715:
4716: FUNCTION Is_Header_On_Hold(
4717: p_header_id IN NUMBER,

Line 4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4758:
4759: RETURN FALSE;
4760:
4761: EXCEPTION
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4764: WHEN OTHERS THEN
4765: OE_BULK_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME

Line 4763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4759: RETURN FALSE;
4760:
4761: EXCEPTION
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4764: WHEN OTHERS THEN
4765: OE_BULK_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME
4767: , 'Is_Header_On_Hold'

Line 4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4765: OE_BULK_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME
4767: , 'Is_Header_On_Hold'
4768: );
4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4770: END Is_Header_On_Hold;
4771:
4772: FUNCTION Is_Line_On_Hold(
4773: p_header_id IN NUMBER,

Line 4853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4849:
4850: RETURN FALSE;
4851:
4852: EXCEPTION
4853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4855: WHEN OTHERS THEN
4856: OE_BULK_MSG_PUB.Add_Exc_Msg
4857: ( G_PKG_NAME

Line 4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4850: RETURN FALSE;
4851:
4852: EXCEPTION
4853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4855: WHEN OTHERS THEN
4856: OE_BULK_MSG_PUB.Add_Exc_Msg
4857: ( G_PKG_NAME
4858: , 'Is_Line_On_Hold'

Line 4860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4856: OE_BULK_MSG_PUB.Add_Exc_Msg
4857: ( G_PKG_NAME
4858: , 'Is_Line_On_Hold'
4859: );
4860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4861: END Is_Line_On_Hold;
4862:
4863: PROCEDURE Apply_GSA_Hold(p_header_id IN NUMBER,
4864: p_line_id IN NUMBER,

Line 4878: x_return_status := FND_API.G_RET_STS_SUCCESS;

4874: IS
4875: i BINARY_INTEGER;
4876: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4877: BEGIN
4878: x_return_status := FND_API.G_RET_STS_SUCCESS;
4879: -- Check the count of the Global Table for Hold Source Rec
4880: i := g_hold_source_rec.HOLD_ID.COUNT;
4881:
4882: -- Assign memory

Line 4914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4910: IF l_debug_level > 0 THEN
4911: oe_debug_pub.add('In OTHERS error - Apply GSA Hold ' ||
4912: SUBSTR(sqlerrm,1,240), 1);
4913: END IF;
4914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4915: --bug 3735141
4916:
4917: END Apply_GSA_Hold;
4918: