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.34.12020000.2 2012/07/03 10:00:52 amallik 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.34.12020000.2 2012/07/03 10:00:52 amallik 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 168: oe_debug_pub.add( 'OE_HOLDS_PUB.UPDATE_HOLD_COMMENTS:' || 'EITHER PASS HOLD_SOURCE_ID OR HOLD_ENTITY_CODE/HOLD_ENTITY_ID' ) ;

164: end if;
165:
166: else
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'OE_HOLDS_PUB.UPDATE_HOLD_COMMENTS:' || 'EITHER PASS HOLD_SOURCE_ID OR HOLD_ENTITY_CODE/HOLD_ENTITY_ID' ) ;
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;
171: end if;
172:

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

369: --
370: BEGIN
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'IN OE_HOLDS_PUB.VALIDATEORDER' ) ;
374: END IF;
375:
376: -- Initialize API return status to success
377: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

635: l_check_authorization_flag varchar2(1):= 'N'; -- bug 8477694
636: BEGIN
637: l_check_authorization_flag:= p_check_authorization_flag; -- 8477694
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS' ) ;
640: END IF;
641:
642: SAVEPOINT APPLY_HOLDS_PUB; -- 11803186 Adding a new SAVEPOINT to get the new Apply_Holds proc in synch with the Old
643:

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

722: l_check_authorization_flag varchar2(1):= 'N'; -- bug 8477694
723: BEGIN
724: l_check_authorization_flag:= p_check_authorization_flag; -- 8477694
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS , CREATING HOLD SOURCE' ) ;
727: END IF;
728: l_org_id := MO_GLOBAL.get_current_org_id;
729: IF l_org_id IS NULL THEN
730: -- org_id is null, raise an error.

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

748: ,x_msg_count => x_msg_count
749: ,x_msg_data => x_msg_data
750: );
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'OE_HOLDS_PUB.APPLY_HOLDS , HOLD SOURCE:' ||X_RETURN_STATUS ) ;
753: END IF;
754:
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN

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

808: l_check_authorization_flag varchar2(1):= 'N'; -- bug 8477694
809: BEGIN
810: l_check_authorization_flag:=p_check_authorization_flag; --8477694
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;
813: END IF;
814: l_org_id := MO_GLOBAL.get_current_org_id;
815: IF l_org_id IS NULL THEN
816: -- org_id is null, raise an error.

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

893: l_check_authorization_flag varchar2(1):= 'N'; -- bug 8477694
894: BEGIN
895: l_check_authorization_flag :=p_check_authorization_flag; -- bug 8477694
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( 'IN OE_HOLDS_PUB.RELEASE_HOLDS' ) ;
898: END IF;
899:
900: l_org_id := MO_GLOBAL.get_current_org_id;
901: IF l_org_id IS NULL THEN

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

1039: RAISE FND_API.G_EXC_ERROR;
1040: END IF;
1041:
1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add( 'IN OE_HOLDS_PUB.APPLY_HOLDS OLD' ) ;
1044: END IF;
1045:
1046: SAVEPOINT APPLY_HOLDS_PUB;
1047:

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

1305: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1306: --
1307: BEGIN
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_LINE:' || P_LINE_ID ) ;
1310: END IF;
1311: -- Initialize API return status to success
1312: x_return_status := FND_API.G_RET_STS_SUCCESS;
1313:

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

1376: null;
1377: END;
1378:
1379: IF l_debug_level > 0 THEN
1380: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_LINE' ) ;
1381: END IF;
1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN

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

1442: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1443: --
1444: BEGIN
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;
1447: END IF;
1448: -- Initialize API return status to success
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:

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

1503: null;
1504: END;
1505:
1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_ATO' ) ;
1508: END IF;
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN

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

1569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1570: --
1571: BEGIN
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;
1574: END IF;
1575: -- Initialize API return status to success
1576: x_return_status := FND_API.G_RET_STS_SUCCESS;
1577:

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

1629: null;
1630: END;
1631:
1632: IF l_debug_level > 0 THEN
1633: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS_SMC' ) ;
1634: END IF;
1635:
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN

Line 1675: x_hold_rec IN OUT NOCOPY OE_HOLDS_PUB.Any_Line_Hold_rec

1671: -- Created for bug 2673236
1672: -- Check If any line in the order is on hold
1673:
1674: PROCEDURE Check_Any_Line_Hold (
1675: x_hold_rec IN OUT NOCOPY OE_HOLDS_PUB.Any_Line_Hold_rec
1676: , x_return_status OUT NOCOPY VARCHAR2
1677: , x_msg_count OUT NOCOPY NUMBER
1678: , x_msg_data OUT NOCOPY VARCHAR2
1679: )

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

1837: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
1838: l_org_id NUMBER; -- 7832836
1839: BEGIN
1840: IF l_debug_level > 0 THEN
1841: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLDS' ) ;
1842: END IF;
1843:
1844: -- Initialize API return status to success
1845: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2258:
2259: END IF; /* IF LINE ID IS NOT NULL */
2260:
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.CHECK_HOLDS' ) ;
2263: END IF;
2264:
2265: EXCEPTION
2266: WHEN FND_API.G_EXC_ERROR THEN

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

2334: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2335: --
2336: BEGIN
2337: IF l_debug_level > 0 THEN
2338: oe_debug_pub.add( 'IN OE_HOLDS_PUB.CHECK_HOLD_SOURCES' ) ;
2339: END IF;
2340: -- Initialize API return status to success
2341: x_return_status := FND_API.G_RET_STS_SUCCESS;
2342:

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

5525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5526:
5527: BEGIN
5528: IF l_debug_level > 0 THEN
5529: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Hold_Exists',1 ) ;
5530: END IF;
5531: IF p_org_id IS NULL THEN
5532:
5533: SELECT 'Y'

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

5550: AND ORG_ID = p_org_id;
5551:
5552: END IF;
5553: IF l_debug_level > 0 THEN
5554: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Hold_Exists',1 ) ;
5555: END IF;
5556:
5557: IF l_hold_exists = 'Y' THEN
5558: return true;

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

5564: WHEN NO_DATA_FOUND THEN
5565: return false;
5566: WHEN TOO_MANY_ROWS THEN
5567: IF l_debug_level > 0 THEN
5568: oe_debug_pub.add( 'TOO_MANY_ROWS exception in OE_HOLDS_PUB.Hold_Exists' ) ;
5569: END IF;
5570: return true;
5571: WHEN others THEN
5572: IF l_debug_level > 0 THEN

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

5569: END IF;
5570: return true;
5571: WHEN others THEN
5572: IF l_debug_level > 0 THEN
5573: oe_debug_pub.add( 'Exception in OE_HOLDS_PUB.Hold_Exists' ) ;
5574: END IF;
5575: return false;
5576: END Hold_exists;
5577:

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

5635: AND nvl(released_flag,'N') = 'N';
5636:
5637: BEGIN
5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5640: oe_debug_pub.add('EntityCode: ' || p_hold_entity_code||' EntityID:'|| p_hold_entity_id||' HoldId: ' || p_hold_id||' p_Action: ' || p_action, 1);
5641: END IF;
5642: l_hold_source_rec.hold_entity_code := p_hold_entity_code;
5643: l_hold_source_rec.hold_entity_id := p_hold_entity_id;

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

5706:
5707: END LOOP;
5708: END IF;
5709: IF l_debug_level > 0 THEN
5710: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5711: END IF;
5712:
5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN

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

5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN
5715:
5716: IF l_debug_level > 0 THEN
5717: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5718: END IF;
5719: IF x_msg_count is not null then
5720: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5721: p_data => x_msg_data);

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

5723: RAISE FND_API.G_EXC_ERROR;
5724:
5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5726: IF l_debug_level > 0 THEN
5727: oe_debug_pub.add( 'API UNEXPECTED ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5728: END IF;
5729: IF x_msg_count is not null then
5730: OE_MSG_PUB.Count_And_Get
5731: ( p_count => x_msg_count

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

5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5736:
5737: WHEN OTHERS THEN
5738: IF l_debug_level > 0 THEN
5739: oe_debug_pub.add( 'ERROR in oe_holds_pub.Process_Holds_Customer' , 1 ) ;
5740: END IF;
5741: RAISE;
5742:
5743: END Process_Holds_Customer;

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

5766: l_org_id NUMBER := null;
5767: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5768: BEGIN
5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;
5771: oe_debug_pub.add('EntityCode: ' || p_hold_entity_code||'::EntityID: ' || p_hold_entity_id||'::HoldId: ' || p_hold_id||'::p_Action: ' || p_action, 1);
5772: END IF;
5773:
5774: -- Fetch the org_id of the site that is being sent to put on hold

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

5845: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status: ' || x_return_status, 1);
5846: END IF;
5847:
5848: IF l_debug_level > 0 THEN
5849: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.Process_Holds_Site' , 1 ) ;
5850: END IF;
5851: END IF; -- APPLY OR RELEASE
5852: EXCEPTION
5853: WHEN FND_API.G_EXC_ERROR THEN

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

5852: EXCEPTION
5853: WHEN FND_API.G_EXC_ERROR THEN
5854:
5855: IF l_debug_level > 0 THEN
5856: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5857: END IF;
5858:
5859: IF x_msg_count is not null then
5860: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

5864: RAISE FND_API.G_EXC_ERROR;
5865:
5866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5867: IF l_debug_level > 0 THEN
5868: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5869: END IF;
5870:
5871: FND_MSG_PUB.Count_And_Get
5872: ( p_count => x_msg_count

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

5876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5877:
5878: WHEN OTHERS THEN
5879: IF l_debug_level > 0 THEN
5880: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;
5881: END IF;
5882: RAISE;
5883: END Process_Holds_Site;
5884:

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

5926:
5927: BEGIN
5928:
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add( 'ENTERED OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5931: END IF;
5932:
5933: SAVEPOINT oe_process_holds;
5934:

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

5965:
5966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5967:
5968: IF l_debug_level > 0 THEN
5969: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;
5970: END IF;
5971:
5972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5973: RAISE FND_API.G_EXC_ERROR;

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

6004:
6005: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6006:
6007: IF l_debug_level > 0 THEN
6008: oe_debug_pub.add( 'ERROR AFTER PROCESS_HOLDS_SITE IN OE_HOLDS_PUB.PROCESS_HOLDS' ) ;
6009: END IF;
6010:
6011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6012: RAISE FND_API.G_EXC_ERROR;

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

6025:
6026: x_return_status := l_return_status;
6027:
6028: IF l_debug_level > 0 THEN
6029: oe_debug_pub.add( 'EXITING OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
6030: END IF;
6031: EXCEPTION
6032: WHEN FND_API.G_EXC_ERROR THEN
6033:

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

6031: EXCEPTION
6032: WHEN FND_API.G_EXC_ERROR THEN
6033:
6034: IF l_debug_level > 0 THEN
6035: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
6036: END IF;
6037: x_return_status := l_return_status;
6038: x_msg_count := l_msg_count;
6039: x_msg_data := l_msg_data;

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

6058:
6059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
6063: END IF;
6064: x_return_status := l_return_status;
6065: x_msg_count := l_msg_count;
6066: x_msg_data := l_msg_data;

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

6084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6085:
6086: WHEN OTHERS THEN
6087: IF l_debug_level > 0 THEN
6088: oe_debug_pub.add( 'ERROR in oe_holds_pub.process_holds' , 1 ) ;
6089: END IF;
6090: x_return_status := l_return_status;
6091: x_msg_count := l_msg_count;
6092: x_msg_data := l_msg_data;

Line 6106: END OE_Holds_PUB;

6102:
6103: RAISE;
6104: END Process_Holds;
6105:
6106: END OE_Holds_PUB;