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_HOLDS_PUB dependencies on OE_HOLDS_PUB

Line 1: PACKAGE BODY OE_Holds_PUB AS

1: PACKAGE BODY OE_Holds_PUB AS
2: /* $Header: OEXPHLDB.pls 120.10.12010000.9 2009/01/22 13:48:28 cpati ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Holds_PUB';

2: /* $Header: OEXPHLDB.pls 120.10.12010000.9 2009/01/22 13:48:28 cpati ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Holds_PUB';
7:
8: PROCEDURE Utilities
9: ( p_user_id OUT NOCOPY /* file.sql.39 change */ NUMBER)
10: IS

Line 155: oe_debug_pub.add( 'OE_HOLDS_PUB.UPDATE_HOLD_COMMENTS:' || 'EITHER PASS HOLD_SOURCE_ID OR HOLD_ENTITY_CODE/HOLD_ENTITY_ID' ) ;

151: end if;
152:
153: else
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add( 'OE_HOLDS_PUB.UPDATE_HOLD_COMMENTS:' || 'EITHER PASS HOLD_SOURCE_ID OR HOLD_ENTITY_CODE/HOLD_ENTITY_ID' ) ;
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;
158: end if;
159:

Line 360: oe_debug_pub.add( 'IN OE_HOLDS_PUB.VALIDATEORDER' ) ;

356: --
357: BEGIN
358:
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add( 'IN OE_HOLDS_PUB.VALIDATEORDER' ) ;
361: END IF;
362:
363: -- Initialize API return status to success
364: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 567: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS' ) ;

563: --
564: BEGIN
565:
566: IF l_debug_level > 0 THEN
567: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS' ) ;
568: END IF;
569:
570: l_org_id := MO_GLOBAL.get_current_org_id;
571: IF l_org_id IS NULL THEN

Line 647: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS , CREATING HOLD SOURCE' ) ;

643: --
644: BEGIN
645:
646: IF l_debug_level > 0 THEN
647: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS , CREATING HOLD SOURCE' ) ;
648: END IF;
649: l_org_id := MO_GLOBAL.get_current_org_id;
650: IF l_org_id IS NULL THEN
651: -- org_id is null, raise an error.

Line 672: oe_debug_pub.add( 'OE_HOLDS_PUB.APPLY_HOLDS , HOLD SOURCE:' ||X_RETURN_STATUS ) ;

668: ,x_msg_count => x_msg_count
669: ,x_msg_data => x_msg_data
670: );
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'OE_HOLDS_PUB.APPLY_HOLDS , HOLD SOURCE:' ||X_RETURN_STATUS ) ;
673: END IF;
674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN

Line 730: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;

726: --
727: BEGIN
728:
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;
731: END IF;
732: l_org_id := MO_GLOBAL.get_current_org_id;
733: IF l_org_id IS NULL THEN
734: -- org_id is null, raise an error.

Line 812: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;

808: --
809: BEGIN
810:
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;
813: END IF;
814:
815: l_org_id := MO_GLOBAL.get_current_org_id;
816: IF l_org_id IS NULL THEN

Line 955: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS OLD' ) ;

951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
954: IF l_debug_level > 0 THEN
955: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS OLD' ) ;
956: END IF;
957:
958: SAVEPOINT APPLY_HOLDS_PUB;
959:

Line 1220: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_LINE:' || P_LINE_ID ) ;

1216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1217: --
1218: BEGIN
1219: IF l_debug_level > 0 THEN
1220: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_LINE:' || P_LINE_ID ) ;
1221: END IF;
1222: -- Initialize API return status to success
1223: x_return_status := FND_API.G_RET_STS_SUCCESS;
1224:

Line 1291: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_LINE' ) ;

1287: null;
1288: END;
1289:
1290: IF l_debug_level > 0 THEN
1291: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_LINE' ) ;
1292: END IF;
1293:
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN

Line 1357: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;

1353: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1354: --
1355: BEGIN
1356: IF l_debug_level > 0 THEN
1357: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;
1358: END IF;
1359: -- Initialize API return status to success
1360: x_return_status := FND_API.G_RET_STS_SUCCESS;
1361:

Line 1418: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;

1414: null;
1415: END;
1416:
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;
1419: END IF;
1420:
1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN

Line 1484: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;

1480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1481: --
1482: BEGIN
1483: IF l_debug_level > 0 THEN
1484: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;
1485: END IF;
1486: -- Initialize API return status to success
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;
1488:

Line 1544: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;

1540: null;
1541: END;
1542:
1543: IF l_debug_level > 0 THEN
1544: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;
1545: END IF;
1546:
1547: EXCEPTION
1548: WHEN FND_API.G_EXC_ERROR THEN

Line 1586: x_hold_rec IN OUT NOCOPY OE_HOLDS_PUB.Any_Line_Hold_rec

1582: -- Created for bug 2673236
1583: -- Check If any line in the order is on hold
1584:
1585: PROCEDURE Check_Any_Line_Hold (
1586: x_hold_rec IN OUT NOCOPY OE_HOLDS_PUB.Any_Line_Hold_rec
1587: , x_return_status OUT NOCOPY VARCHAR2
1588: , x_msg_count OUT NOCOPY NUMBER
1589: , x_msg_data OUT NOCOPY VARCHAR2
1590: )

Line 1752: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS' ) ;

1748: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
1749: l_org_id NUMBER; -- 7832836
1750: BEGIN
1751: IF l_debug_level > 0 THEN
1752: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS' ) ;
1753: END IF;
1754:
1755: -- Initialize API return status to success
1756: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2173: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS' ) ;

2169:
2170: END IF; /* IF LINE ID IS NOT NULL */
2171:
2172: IF l_debug_level > 0 THEN
2173: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS' ) ;
2174: END IF;
2175:
2176: EXCEPTION
2177: WHEN FND_API.G_EXC_ERROR THEN

Line 2249: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLD_SOURCES' ) ;

2245: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2246: --
2247: BEGIN
2248: IF l_debug_level > 0 THEN
2249: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLD_SOURCES' ) ;
2250: END IF;
2251: -- Initialize API return status to success
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:

Line 4982: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Hold_Exists',1 ) ;

4978: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4979:
4980: BEGIN
4981: IF l_debug_level > 0 THEN
4982: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Hold_Exists',1 ) ;
4983: END IF;
4984: IF p_org_id IS NULL THEN
4985:
4986: SELECT 'Y'

Line 5007: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Hold_Exists',1 ) ;

5003: AND ORG_ID = p_org_id;
5004:
5005: END IF;
5006: IF l_debug_level > 0 THEN
5007: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Hold_Exists',1 ) ;
5008: END IF;
5009:
5010: IF l_hold_exists = 'Y' THEN
5011: return true;

Line 5021: oe_debug_pub.add( 'TOO_MANY_ROWS exception in OE_HOLDS_PUB.Hold_Exists' ) ;

5017: WHEN NO_DATA_FOUND THEN
5018: return false;
5019: WHEN TOO_MANY_ROWS THEN
5020: IF l_debug_level > 0 THEN
5021: oe_debug_pub.add( 'TOO_MANY_ROWS exception in OE_HOLDS_PUB.Hold_Exists' ) ;
5022: END IF;
5023: return true;
5024: WHEN others THEN
5025: IF l_debug_level > 0 THEN

Line 5026: oe_debug_pub.add( 'Exception in OE_HOLDS_PUB.Hold_Exists' ) ;

5022: END IF;
5023: return true;
5024: WHEN others THEN
5025: IF l_debug_level > 0 THEN
5026: oe_debug_pub.add( 'Exception in OE_HOLDS_PUB.Hold_Exists' ) ;
5027: END IF;
5028: return false;
5029: END Hold_exists;
5030:

Line 5092: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;

5088: AND nvl(released_flag,'N') = 'N';
5089:
5090: BEGIN
5091: IF l_debug_level > 0 THEN
5092: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5093: oe_debug_pub.add('EntityCode: ' || p_hold_entity_code||' EntityID:'|| p_hold_entity_id||' HoldId: ' || p_hold_id||' p_Action: ' || p_action, 1);
5094: END IF;
5095: l_hold_source_rec.hold_entity_code := p_hold_entity_code;
5096: l_hold_source_rec.hold_entity_id := p_hold_entity_id;

Line 5163: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;

5159:
5160: END LOOP;
5161: END IF;
5162: IF l_debug_level > 0 THEN
5163: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5164: END IF;
5165:
5166: EXCEPTION
5167: WHEN FND_API.G_EXC_ERROR THEN

Line 5170: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;

5166: EXCEPTION
5167: WHEN FND_API.G_EXC_ERROR THEN
5168:
5169: IF l_debug_level > 0 THEN
5170: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5171: END IF;
5172: IF x_msg_count is not null then
5173: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5174: p_data => x_msg_data);

Line 5180: oe_debug_pub.add( 'API UNEXPECTED ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;

5176: RAISE FND_API.G_EXC_ERROR;
5177:
5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: IF l_debug_level > 0 THEN
5180: oe_debug_pub.add( 'API UNEXPECTED ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5181: END IF;
5182: IF x_msg_count is not null then
5183: OE_MSG_PUB.Count_And_Get
5184: ( p_count => x_msg_count

Line 5192: oe_debug_pub.add( 'ERROR in oe_holds_pub.Process_Holds_Customer' , 1 ) ;

5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5189:
5190: WHEN OTHERS THEN
5191: IF l_debug_level > 0 THEN
5192: oe_debug_pub.add( 'ERROR in oe_holds_pub.Process_Holds_Customer' , 1 ) ;
5193: END IF;
5194: RAISE;
5195:
5196: END Process_Holds_Customer;

Line 5223: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;

5219: l_org_id NUMBER := null;
5220: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5221: BEGIN
5222: IF l_debug_level > 0 THEN
5223: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;
5224: oe_debug_pub.add('EntityCode: ' || p_hold_entity_code||'::EntityID: ' || p_hold_entity_id||'::HoldId: ' || p_hold_id||'::p_Action: ' || p_action, 1);
5225: END IF;
5226:
5227: -- Fetch the org_id of the site that is being sent to put on hold

Line 5302: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;

5298: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status: ' || x_return_status, 1);
5299: END IF;
5300:
5301: IF l_debug_level > 0 THEN
5302: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;
5303: END IF;
5304: END IF; -- APPLY OR RELEASE
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN

Line 5309: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307:
5308: IF l_debug_level > 0 THEN
5309: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5310: END IF;
5311:
5312: IF x_msg_count is not null then
5313: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 5321: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5317: RAISE FND_API.G_EXC_ERROR;
5318:
5319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5320: IF l_debug_level > 0 THEN
5321: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5322: END IF;
5323:
5324: FND_MSG_PUB.Count_And_Get
5325: ( p_count => x_msg_count

Line 5333: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;

5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330:
5331: WHEN OTHERS THEN
5332: IF l_debug_level > 0 THEN
5333: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;
5334: END IF;
5335: RAISE;
5336: END Process_Holds_Site;
5337:

Line 5383: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5379:
5380: BEGIN
5381:
5382: IF l_debug_level > 0 THEN
5383: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5384: END IF;
5385:
5386: SAVEPOINT oe_process_holds;
5387:

Line 5422: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;

5418:
5419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5420:
5421: IF l_debug_level > 0 THEN
5422: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;
5423: END IF;
5424:
5425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5426: RAISE FND_API.G_EXC_ERROR;

Line 5461: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;

5457:
5458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5459:
5460: IF l_debug_level > 0 THEN
5461: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;
5462: END IF;
5463:
5464: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5465: RAISE FND_API.G_EXC_ERROR;

Line 5482: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5478:
5479: x_return_status := l_return_status;
5480:
5481: IF l_debug_level > 0 THEN
5482: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5483: END IF;
5484: EXCEPTION
5485: WHEN FND_API.G_EXC_ERROR THEN
5486:

Line 5488: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5484: EXCEPTION
5485: WHEN FND_API.G_EXC_ERROR THEN
5486:
5487: IF l_debug_level > 0 THEN
5488: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5489: END IF;
5490: x_return_status := l_return_status;
5491: x_msg_count := l_msg_count;
5492: x_msg_data := l_msg_data;

Line 5507: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;

5503:
5504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5505:
5506: IF l_debug_level > 0 THEN
5507: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5508: END IF;
5509: x_return_status := l_return_status;
5510: x_msg_count := l_msg_count;
5511: x_msg_data := l_msg_data;

Line 5524: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;

5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521:
5522: WHEN OTHERS THEN
5523: IF l_debug_level > 0 THEN
5524: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;
5525: END IF;
5526: x_return_status := l_return_status;
5527: x_msg_count := l_msg_count;
5528: x_msg_data := l_msg_data;

Line 5533: END OE_Holds_PUB;

5529: ROLLBACK TO SAVEPOINT oe_process_holds;
5530: RAISE;
5531: END Process_Holds;
5532:
5533: END OE_Holds_PUB;