DBA Data[Home] [Help]

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 243: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);

239: l_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: If p_org_id IS Not Null Then
242: -- Set Single Org access
243: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);
244: l_curr_org_id := p_org_id;
245: Else
246: MO_GLOBAL.set_policy_context('M', '');
247: END IF;

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

242: -- Set Single Org access
243: MO_GLOBAL.SET_POLICY_CONTEXT('S', p_org_id);
244: l_curr_org_id := p_org_id;
245: Else
246: MO_GLOBAL.set_policy_context('M', '');
247: END IF;
248:
249:
250: open expired_holds_cur;

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

261:
262: if l_org_id <> nvl(l_curr_org_id, -99)
263: then
264: oe_debug_pub.add('Setting Policy Context for:' || TO_CHAR(l_org_id) ) ;
265: MO_GLOBAL.SET_POLICY_CONTEXT('S', l_org_id);
266: l_curr_org_id := l_org_id;
267: oe_debug_pub.add('MO_GLOBAL.get_current_org_id;:' || to_char(MO_GLOBAL.get_current_org_id));
268: End if;
269:

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

263: then
264: oe_debug_pub.add('Setting Policy Context for:' || TO_CHAR(l_org_id) ) ;
265: MO_GLOBAL.SET_POLICY_CONTEXT('S', l_org_id);
266: l_curr_org_id := l_org_id;
267: oe_debug_pub.add('MO_GLOBAL.get_current_org_id;:' || to_char(MO_GLOBAL.get_current_org_id));
268: End if;
269:
270: l_hold_source_rec.hold_source_id := l_hold_source_id;
271: l_hold_release_rec.RELEASE_REASON_CODE := 'EXPIRE';

Line 570: l_org_id := MO_GLOBAL.get_current_org_id;

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

Line 649: l_org_id := MO_GLOBAL.get_current_org_id;

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

Line 732: l_org_id := MO_GLOBAL.get_current_org_id;

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

Line 815: l_org_id := MO_GLOBAL.get_current_org_id;

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

Line 944: l_org_id := MO_GLOBAL.get_current_org_id;

940: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
941: --
942: BEGIN
943:
944: l_org_id := MO_GLOBAL.get_current_org_id;
945: IF l_org_id IS NULL THEN
946: -- org_id is null, raise an error.
947: oe_debug_pub.add('Org_Id is NULL',1);
948: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1800: l_org_id := MO_GLOBAL.get_current_org_id;

1796: oe_debug_pub.add( 'CHECKING HOLD ON HEADER ID: ' || P_HDR_ID ) ;
1797: END IF;
1798:
1799: --7832836 start
1800: l_org_id := MO_GLOBAL.get_current_org_id;
1801: IF l_org_id IS NULL THEN
1802: BEGIN
1803: SELECT org_id
1804: INTO l_org_id

Line 2418: l_org_id := MO_GLOBAL.get_current_org_id;

2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'IN RELEASE_HOLDS , OLD' ) ;
2416: END IF;
2417:
2418: l_org_id := MO_GLOBAL.get_current_org_id;
2419: IF l_org_id IS NULL THEN
2420: -- org_id is null, raise an error.
2421: oe_debug_pub.add('Org_Id is NULL',1);
2422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2656: l_org_id := MO_GLOBAL.get_current_org_id;

2652: --
2653: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2654: --
2655: BEGIN
2656: l_org_id := MO_GLOBAL.get_current_org_id;
2657: IF l_org_id IS NULL THEN
2658: -- org_id is null, raise an error.
2659: oe_debug_pub.add('Org_Id is NULL',1);
2660: x_return_status := FND_API.G_RET_STS_ERROR;

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

5107: IF l_debug_level > 0 THEN
5108: oe_debug_pub.add('Applying Hold in ORG_ID ' || l_org_id, 1);
5109: END IF;
5110:
5111: MO_GLOBAL.set_policy_context('S',l_org_id);
5112:
5113: oe_holds_pvt.apply_Holds(
5114: p_hold_source_rec => l_hold_source_rec
5115: ,p_hold_existing_flg => 'Y'

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

5141: END IF;
5142:
5143: l_hold_source_rec.hold_source_id := l_hold_source_id;
5144:
5145: MO_GLOBAL.set_policy_context('S',l_org_id);
5146:
5147: oe_holds_pvt.Release_Holds(
5148: p_hold_source_rec => l_hold_source_rec
5149: ,p_hold_release_rec => l_hold_release_rec

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

5252: IF l_debug_level > 0 THEN
5253: oe_debug_pub.add('Process_Holds_Site:ORG_ID: ' || l_org_id, 1);
5254: END IF;
5255:
5256: MO_GLOBAL.set_policy_context('S',l_org_id);
5257:
5258: -- Validate hold entity (site) and get correct code for Ship To, Bill To
5259: l_hold_entity_code := Hold_Site_Code(p_hold_entity_id);
5260:

Line 5404: l_orig_org := MO_GLOBAL.get_current_org_id;

5400: -- hold the original org id being used by programs when calling process_holds.
5401: -- set the org org context to this original org when leaving process_holds.
5402: -- sHOULD IT BE SET EVEN WHEN EXITING WITH AN EXCEPTION??
5403:
5404: l_orig_org := MO_GLOBAL.get_current_org_id;
5405:
5406: IF p_hold_entity_code = 'S' THEN
5407:
5408: Process_Holds_Site

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

5470:
5471: END IF;
5472:
5473: IF l_orig_org IS NULL THEN
5474: MO_GLOBAL.set_policy_context('M',null);
5475: ELSE
5476: MO_GLOBAL.set_policy_context('S',l_orig_org);
5477: END IF;
5478:

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

5472:
5473: IF l_orig_org IS NULL THEN
5474: MO_GLOBAL.set_policy_context('M',null);
5475: ELSE
5476: MO_GLOBAL.set_policy_context('S',l_orig_org);
5477: END IF;
5478:
5479: x_return_status := l_return_status;
5480: