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 MO_GLOBAL

Line 89: l_org_id := MO_GLOBAL.get_current_org_id;

85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'IN UPDATE_HOLD_COMMENTS' ) ;
87: END IF;
88:
89: l_org_id := MO_GLOBAL.get_current_org_id;
90: IF l_org_id IS NULL THEN
91: -- org_id is null, raise an error.
92: oe_debug_pub.add('Org_Id is NULL',1);
93: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 256: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);

252: l_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: If p_org_id IS Not Null Then
255: -- Set Single Org access
256: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);
257: l_curr_org_id := p_org_id;
258: Else
259: MO_GLOBAL.set_policy_context('M', '');
260: END IF;

Line 259: MO_GLOBAL.set_policy_context('M', '');

255: -- Set Single Org access
256: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);
257: l_curr_org_id := p_org_id;
258: Else
259: MO_GLOBAL.set_policy_context('M', '');
260: END IF;
261:
262:
263: open expired_holds_cur;

Line 278: MO_GLOBAL.SET_POLICY_CONTEXT('S', l_org_id);

274:
275: if l_org_id <> nvl(l_curr_org_id, -99)
276: then
277: oe_debug_pub.add('Setting Policy Context for:' || TO_CHAR(l_org_id) ) ;
278: MO_GLOBAL.SET_POLICY_CONTEXT('S', l_org_id);
279: l_curr_org_id := l_org_id;
280: oe_debug_pub.add('MO_GLOBAL.get_current_org_id;:' || to_char(MO_GLOBAL.get_current_org_id));
281: End if;
282:

Line 280: oe_debug_pub.add('MO_GLOBAL.get_current_org_id;:' || to_char(MO_GLOBAL.get_current_org_id));

276: then
277: oe_debug_pub.add('Setting Policy Context for:' || TO_CHAR(l_org_id) ) ;
278: MO_GLOBAL.SET_POLICY_CONTEXT('S', l_org_id);
279: l_curr_org_id := l_org_id;
280: oe_debug_pub.add('MO_GLOBAL.get_current_org_id;:' || to_char(MO_GLOBAL.get_current_org_id));
281: End if;
282:
283: l_hold_source_rec.hold_source_id := l_hold_source_id;
284: l_hold_release_rec.RELEASE_REASON_CODE := 'EXPIRE';

Line 644: l_org_id := MO_GLOBAL.get_current_org_id;

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:
644: l_org_id := MO_GLOBAL.get_current_org_id;
645: IF l_org_id IS NULL THEN
646: -- org_id is null, raise an error.
647: oe_debug_pub.add('Org_Id is NULL',1);
648: x_return_status := FND_API.G_RET_STS_ERROR;

Line 728: l_org_id := MO_GLOBAL.get_current_org_id;

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.
731: oe_debug_pub.add('Org_Id is NULL',1);
732: x_return_status := FND_API.G_RET_STS_ERROR;

Line 814: l_org_id := MO_GLOBAL.get_current_org_id;

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.
817: oe_debug_pub.add('Org_Id is NULL',1);
818: x_return_status := FND_API.G_RET_STS_ERROR;

Line 900: l_org_id := MO_GLOBAL.get_current_org_id;

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
902: -- org_id is null, raise an error.
903: oe_debug_pub.add('Org_Id is NULL',1);
904: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1032: l_org_id := MO_GLOBAL.get_current_org_id;

1028: --
1029: l_check_authorization_flag varchar2(1):= 'N'; -- bug 8477694
1030: BEGIN
1031: l_check_authorization_flag:= p_check_authorization_flag; -- 8477694
1032: l_org_id := MO_GLOBAL.get_current_org_id;
1033: IF l_org_id IS NULL THEN
1034: -- org_id is null, raise an error.
1035: oe_debug_pub.add('Org_Id is NULL',1);
1036: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1889: l_org_id := MO_GLOBAL.get_current_org_id;

1885: oe_debug_pub.add( 'CHECKING HOLD ON HEADER ID: ' || P_HDR_ID ) ;
1886: END IF;
1887:
1888: --7832836 start
1889: l_org_id := MO_GLOBAL.get_current_org_id;
1890: IF l_org_id IS NULL THEN
1891: BEGIN
1892: SELECT org_id
1893: INTO l_org_id

Line 2509: l_org_id := MO_GLOBAL.get_current_org_id;

2505: IF l_debug_level > 0 THEN
2506: oe_debug_pub.add( 'IN RELEASE_HOLDS , OLD' ) ;
2507: END IF;
2508:
2509: l_org_id := MO_GLOBAL.get_current_org_id;
2510: IF l_org_id IS NULL THEN
2511: -- org_id is null, raise an error.
2512: oe_debug_pub.add('Org_Id is NULL',1);
2513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2748: l_org_id := MO_GLOBAL.get_current_org_id;

2744: --
2745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2746: --
2747: BEGIN
2748: l_org_id := MO_GLOBAL.get_current_org_id;
2749: IF l_org_id IS NULL THEN
2750: -- org_id is null, raise an error.
2751: oe_debug_pub.add('Org_Id is NULL',1);
2752: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5658: MO_GLOBAL.set_policy_context('S',l_org_id);

5654: IF l_debug_level > 0 THEN
5655: oe_debug_pub.add('Applying Hold in ORG_ID ' || l_org_id, 1);
5656: END IF;
5657:
5658: MO_GLOBAL.set_policy_context('S',l_org_id);
5659:
5660: oe_holds_pvt.apply_Holds(
5661: p_hold_source_rec => l_hold_source_rec
5662: ,p_hold_existing_flg => 'Y'

Line 5692: MO_GLOBAL.set_policy_context('S',l_org_id);

5688: END IF;
5689:
5690: l_hold_source_rec.hold_source_id := l_hold_source_id;
5691:
5692: MO_GLOBAL.set_policy_context('S',l_org_id);
5693:
5694: oe_holds_pvt.Release_Holds(
5695: p_hold_source_rec => l_hold_source_rec
5696: ,p_hold_release_rec => l_hold_release_rec

Line 5803: MO_GLOBAL.set_policy_context('S',l_org_id);

5799: IF l_debug_level > 0 THEN
5800: oe_debug_pub.add('Process_Holds_Site:ORG_ID: ' || l_org_id, 1);
5801: END IF;
5802:
5803: MO_GLOBAL.set_policy_context('S',l_org_id);
5804:
5805: -- Validate hold entity (site) and get correct code for Ship To, Bill To
5806: l_hold_entity_code := Hold_Site_Code(p_hold_entity_id);
5807:

Line 5951: l_orig_org := MO_GLOBAL.get_current_org_id;

5947: -- hold the original org id being used by programs when calling process_holds.
5948: -- set the org org context to this original org when leaving process_holds.
5949: -- sHOULD IT BE SET EVEN WHEN EXITING WITH AN EXCEPTION??
5950:
5951: l_orig_org := MO_GLOBAL.get_current_org_id;
5952:
5953: IF p_hold_entity_code = 'S' THEN
5954:
5955: Process_Holds_Site

Line 6021: MO_GLOBAL.set_policy_context('M',null);

6017:
6018: END IF;
6019:
6020: IF l_orig_org IS NULL THEN
6021: MO_GLOBAL.set_policy_context('M',null);
6022: ELSE
6023: MO_GLOBAL.set_policy_context('S',l_orig_org);
6024: END IF;
6025:

Line 6023: MO_GLOBAL.set_policy_context('S',l_orig_org);

6019:
6020: IF l_orig_org IS NULL THEN
6021: MO_GLOBAL.set_policy_context('M',null);
6022: ELSE
6023: MO_GLOBAL.set_policy_context('S',l_orig_org);
6024: END IF;
6025:
6026: x_return_status := l_return_status;
6027:

Line 6052: MO_GLOBAL.set_policy_context('M',null);

6048: ROLLBACK TO SAVEPOINT oe_process_holds;
6049:
6050: -- Start Bug 14040669
6051: IF l_orig_org IS NULL THEN
6052: MO_GLOBAL.set_policy_context('M',null);
6053: ELSE
6054: MO_GLOBAL.set_policy_context('S',l_orig_org);
6055: END IF;
6056: -- End Bug 14040669

Line 6054: MO_GLOBAL.set_policy_context('S',l_orig_org);

6050: -- Start Bug 14040669
6051: IF l_orig_org IS NULL THEN
6052: MO_GLOBAL.set_policy_context('M',null);
6053: ELSE
6054: MO_GLOBAL.set_policy_context('S',l_orig_org);
6055: END IF;
6056: -- End Bug 14040669
6057: RAISE FND_API.G_EXC_ERROR;
6058:

Line 6078: MO_GLOBAL.set_policy_context('M',null);

6074: ROLLBACK TO SAVEPOINT oe_process_holds;
6075:
6076: -- Start Bug 14040669
6077: IF l_orig_org IS NULL THEN
6078: MO_GLOBAL.set_policy_context('M',null);
6079: ELSE
6080: MO_GLOBAL.set_policy_context('S',l_orig_org);
6081: END IF;
6082: -- End Bug 14040669

Line 6080: MO_GLOBAL.set_policy_context('S',l_orig_org);

6076: -- Start Bug 14040669
6077: IF l_orig_org IS NULL THEN
6078: MO_GLOBAL.set_policy_context('M',null);
6079: ELSE
6080: MO_GLOBAL.set_policy_context('S',l_orig_org);
6081: END IF;
6082: -- End Bug 14040669
6083:
6084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6097: MO_GLOBAL.set_policy_context('M',null);

6093: ROLLBACK TO SAVEPOINT oe_process_holds;
6094:
6095: -- Start Bug 14040669
6096: IF l_orig_org IS NULL THEN
6097: MO_GLOBAL.set_policy_context('M',null);
6098: ELSE
6099: MO_GLOBAL.set_policy_context('S',l_orig_org);
6100: END IF;
6101: -- End Bug 14040669

Line 6099: MO_GLOBAL.set_policy_context('S',l_orig_org);

6095: -- Start Bug 14040669
6096: IF l_orig_org IS NULL THEN
6097: MO_GLOBAL.set_policy_context('M',null);
6098: ELSE
6099: MO_GLOBAL.set_policy_context('S',l_orig_org);
6100: END IF;
6101: -- End Bug 14040669
6102:
6103: RAISE;