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_PVT

Line 73: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,

69: /*
70:
71: */
72: PROCEDURE UPDATE_HOLD_COMMENTS (
73: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
74: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
77:

Line 230: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

226: l_api_name CONSTANT VARCHAR2(30) := 'release_expired_holds';
227: l_api_version CONSTANT NUMBER := 1.0;
228: l_hold_source_id NUMBER := 0;
229:
230: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
231: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
232:
233: l_return_status VARCHAR2(30);
234: l_msg_count NUMBER;

Line 231: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

227: l_api_version CONSTANT NUMBER := 1.0;
228: l_hold_source_id NUMBER := 0;
229:
230: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
231: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
232:
233: l_return_status VARCHAR2(30);
234: l_msg_count NUMBER;
235: l_msg_data VARCHAR2(240);

Line 288: oe_holds_pvt.Release_Holds(

284: l_hold_release_rec.RELEASE_REASON_CODE := 'EXPIRE';
285: l_hold_release_rec.RELEASE_COMMENT :=
286: 'Expired Hold, Automatically Released';
287:
288: oe_holds_pvt.Release_Holds(
289: p_hold_source_rec => l_hold_source_rec
290: ,p_hold_release_rec => l_hold_release_rec
291: ,x_return_status => l_return_status
292: ,x_msg_count => l_msg_count

Line 621: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

617: p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
619: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
620: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
621: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
622: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
623: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
624: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
625: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 657: oe_holds_pvt.apply_holds(

653:
654: -- Initialize API return status to success
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: oe_holds_pvt.apply_holds(
658: p_order_tbl => p_order_tbl,
659: p_hold_id => p_hold_id,
660: p_hold_until_date => p_hold_until_date,
661: p_hold_comment => p_hold_comment,

Line 708: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

704: p_api_version IN NUMBER,
705: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
706: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
707: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
708: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
709: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
710: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
711: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
712: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 709: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,

705: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
706: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
707: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
708: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
709: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
710: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
711: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
712: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
713: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 742: oe_holds_pvt.apply_Holds(

738: -- Initialize API return status to success
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740:
741: --dbms_output.put_line ('IN PUB.ApplyHolds'); -- delete
742: oe_holds_pvt.apply_Holds(
743: p_hold_source_rec => p_hold_source_rec
744: ,p_hold_existing_flg => p_hold_existing_flg
745: ,p_hold_future_flg => p_hold_future_flg
746: ,p_check_authorization_flag => l_check_authorization_flag -- 8477694

Line 796: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,

792: p_api_version IN NUMBER DEFAULT 1.0,
793: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
794: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
795: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
796: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
797: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
798: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
799: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
800: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 797: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,

793: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
794: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
795: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
796: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
797: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
798: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
799: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
800: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
801: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 828: oe_holds_pvt.Release_Holds(

824: -- Initialize API return status to success
825: x_return_status := FND_API.G_RET_STS_SUCCESS;
826:
827: -- dbms_output.put_line ('IN RELEASE_HOLDS->'); -- delete
828: oe_holds_pvt.Release_Holds(
829: p_hold_source_rec => p_hold_source_rec
830: ,p_hold_release_rec => p_hold_release_rec
831: ,p_check_authorization_flag => l_check_authorization_flag -- bug 8477694
832: ,x_return_status => x_return_status

Line 874: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

870: p_api_version IN NUMBER DEFAULT 1.0,
871: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
872: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
873: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
874: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
875: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
876: DEFAULT NULL,
877: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
878: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

Line 888: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

884: IS
885: l_api_name CONSTANT VARCHAR2(30) := 'Release_holds';
886: l_header_id NUMBER DEFAULT NULL;
887: j NUMBER;
888: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
889: l_org_id number;
890: --
891: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
892: --

Line 932: oe_holds_pvt.release_holds(

928: l_order_tbl(j).line_id := p_order_tbl(j).line_id;
929: END IF;
930: end loop;
931:
932: oe_holds_pvt.release_holds(
933: p_order_tbl => l_order_tbl,
934: p_hold_id => p_hold_id,
935: p_release_reason_code => p_release_reason_code,
936: p_release_comment => p_release_comment,

Line 1023: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

1019: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
1020: l_entity_id2 NUMBER;
1021: l_header_id NUMBER DEFAULT NULL;
1022:
1023: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1024: l_site_use_code VARCHAR2(30);
1025: l_org_id number;
1026: --
1027: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1217: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.APPLY_HOLDS' ) ;

1213:
1214: --dbms_output.put_line ('AH-hold_id' ||to_char(p_hold_source_rec.hold_id)); -- delete
1215: --dbms_output.put_line ('AH-B4ApplyHolds' ); -- delete
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.APPLY_HOLDS' ) ;
1218: END IF;
1219: oe_holds_pvt.apply_Holds(
1220: p_hold_source_rec => l_hold_source_rec
1221: ,p_hold_existing_flg => 'Y'

Line 1219: oe_holds_pvt.apply_Holds(

1215: --dbms_output.put_line ('AH-B4ApplyHolds' ); -- delete
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.APPLY_HOLDS' ) ;
1218: END IF;
1219: oe_holds_pvt.apply_Holds(
1220: p_hold_source_rec => l_hold_source_rec
1221: ,p_hold_existing_flg => 'Y'
1222: ,p_hold_future_flg => 'Y'
1223: ,p_check_authorization_flag => l_check_authorization_flag -- 8477694

Line 1229: oe_debug_pub.add( 'OE_HOLDS_PVT.APPLY_HOLDS STATUS:' || X_RETURN_STATUS ) ;

1225: ,x_msg_count => x_msg_count
1226: ,x_msg_data => x_msg_data
1227: );
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add( 'OE_HOLDS_PVT.APPLY_HOLDS STATUS:' || X_RETURN_STATUS ) ;
1230: END IF;
1231: --dbms_output.put_line('AH-x_return_status' || x_return_status ); -- delete
1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2472: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

2468: l_order_hold_id NUMBER := 0;
2469: --ER#7479609 l_entity_code VARCHAR2(1);
2470: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2471:
2472: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2473: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2474: l_org_id number;
2475: l_check_authorization_flag varchar2(1):='N'; -- bug 8477694
2476: -- Define Cursors

Line 2473: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

2469: --ER#7479609 l_entity_code VARCHAR2(1);
2470: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2471:
2472: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2473: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2474: l_org_id number;
2475: l_check_authorization_flag varchar2(1):='N'; -- bug 8477694
2476: -- Define Cursors
2477: CURSOR hold_source IS

Line 2637: oe_holds_pvt.Release_Holds(

2633:
2634: IF l_debug_level > 0 THEN
2635: oe_debug_pub.add( 'CALLING RELEASE HOLDS , OLD' ) ;
2636: END IF;
2637: oe_holds_pvt.Release_Holds(
2638: p_hold_source_rec => l_hold_source_rec
2639: ,p_hold_release_rec => l_hold_release_rec
2640: ,p_check_authorization_flag => l_check_authorization_flag -- bug 8477694
2641: ,x_return_status => x_return_status

Line 2646: oe_debug_pub.add( 'OE_HOLDS_PVT.RELEASE_HOLDS STATUS:' || X_RETURN_STATUS ) ;

2642: ,x_msg_count => x_msg_count
2643: ,x_msg_data => x_msg_data
2644: );
2645: IF l_debug_level > 0 THEN
2646: oe_debug_pub.add( 'OE_HOLDS_PVT.RELEASE_HOLDS STATUS:' || X_RETURN_STATUS ) ;
2647: END IF;
2648:
2649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2650: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2977: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

2973: temp NUMBER DEFAULT NULL;
2974: --l_attribute VARCHAR2(30); --ER#12571983
2975: l_attribute VARCHAR2(60); --ER#12571983
2976:
2977: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2978: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2979: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2980: --ER#7479609 l_hold_entity_id NUMBER;
2981: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

Line 3660: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

3656: l_hold_source_rec.header_id := l_header_id;
3657: l_hold_source_rec.line_id := l_line_id;
3658:
3659: IF l_debug_level > 0 THEN
3660: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3661: END IF;
3662: oe_holds_pvt.Create_Order_Holds (
3663: p_hold_source_rec => l_hold_source_rec
3664: ,x_return_status => x_return_status

Line 3662: oe_holds_pvt.Create_Order_Holds (

3658:
3659: IF l_debug_level > 0 THEN
3660: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3661: END IF;
3662: oe_holds_pvt.Create_Order_Holds (
3663: p_hold_source_rec => l_hold_source_rec
3664: ,x_return_status => x_return_status
3665: ,x_msg_count => x_msg_count
3666: ,x_msg_data => x_msg_data

Line 3675: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

3671: END IF;
3672:
3673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3674: IF l_debug_level > 0 THEN
3675: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3676: END IF;
3677: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3678: RAISE FND_API.G_EXC_ERROR;
3679: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3996: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

3992: l_hold_source_rec.header_id := l_header_id;
3993: l_hold_source_rec.line_id := l_line_id;
3994:
3995: IF l_debug_level > 0 THEN
3996: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3997: END IF;
3998: oe_holds_pvt.Create_Order_Holds (
3999: p_hold_source_rec => l_hold_source_rec
4000: ,x_return_status => x_return_status

Line 3998: oe_holds_pvt.Create_Order_Holds (

3994:
3995: IF l_debug_level > 0 THEN
3996: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3997: END IF;
3998: oe_holds_pvt.Create_Order_Holds (
3999: p_hold_source_rec => l_hold_source_rec
4000: ,x_return_status => x_return_status
4001: ,x_msg_count => x_msg_count
4002: ,x_msg_data => x_msg_data

Line 4011: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

4007: END IF;
4008:
4009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4010: IF l_debug_level > 0 THEN
4011: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4012: END IF;
4013: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4230: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

4226: l_return_status VARCHAR2(30);
4227: l_msg_count NUMBER;
4228: l_msg_data VARCHAR2(2000);
4229: l_attribute VARCHAR2(30);
4230: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4231: l_hold_entity_code VARCHAR2(1);
4232: --ER#7479609 l_hold_entity_id NUMBER;
4233: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
4234: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);

Line 4331: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

4327: l_hold_source_rec.header_id := l_header_id;
4328: l_hold_source_rec.line_id := l_line_id;
4329:
4330: IF l_debug_level > 0 THEN
4331: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4332: END IF;
4333: oe_holds_pvt.Create_Order_Holds (
4334: p_hold_source_rec => l_hold_source_rec
4335: ,x_return_status => x_return_status

Line 4333: oe_holds_pvt.Create_Order_Holds (

4329:
4330: IF l_debug_level > 0 THEN
4331: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4332: END IF;
4333: oe_holds_pvt.Create_Order_Holds (
4334: p_hold_source_rec => l_hold_source_rec
4335: ,x_return_status => x_return_status
4336: ,x_msg_count => x_msg_count
4337: ,x_msg_data => x_msg_data

Line 4347: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

4343: END IF;
4344:
4345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4346: IF l_debug_level > 0 THEN
4347: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4348: END IF;
4349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4350: RAISE FND_API.G_EXC_ERROR;
4351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4429: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

4425: l_msg_data VARCHAR2(2000);
4426: temp NUMBER DEFAULT NULL;
4427: l_attribute VARCHAR2(50);
4428: --
4429: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4430: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4431: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4432: --ER#7479609 l_hold_entity_id NUMBER;
4433: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

Line 5165: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

5161: l_hold_source_rec.header_id := l_header_id;
5162: l_hold_source_rec.line_id := l_line_id;
5163:
5164: IF l_debug_level > 0 THEN
5165: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
5166: END IF;
5167: oe_holds_pvt.Create_Order_Holds (
5168: p_hold_source_rec => l_hold_source_rec
5169: ,x_return_status => x_return_status

Line 5167: oe_holds_pvt.Create_Order_Holds (

5163:
5164: IF l_debug_level > 0 THEN
5165: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
5166: END IF;
5167: oe_holds_pvt.Create_Order_Holds (
5168: p_hold_source_rec => l_hold_source_rec
5169: ,x_return_status => x_return_status
5170: ,x_msg_count => x_msg_count
5171: ,x_msg_data => x_msg_data

Line 5181: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;

5177: END IF;
5178:
5179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5180: IF l_debug_level > 0 THEN
5181: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
5182: END IF;
5183: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5184: RAISE FND_API.G_EXC_ERROR;
5185: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5397: oe_debug_pub.add('Calling oe_holds_pvt.create_order_holds');

5393: l_hold_source_rec.hold_source_id := l_hold_source_id;
5394: l_hold_source_rec.header_id := l_header_id;
5395: l_hold_source_rec.line_id := l_line_id;
5396:
5397: oe_debug_pub.add('Calling oe_holds_pvt.create_order_holds');
5398: oe_holds_pvt.Create_Order_Holds (
5399: p_hold_source_rec => l_hold_source_rec
5400: ,x_return_status => x_return_status
5401: ,x_msg_count => x_msg_count

Line 5398: oe_holds_pvt.Create_Order_Holds (

5394: l_hold_source_rec.header_id := l_header_id;
5395: l_hold_source_rec.line_id := l_line_id;
5396:
5397: oe_debug_pub.add('Calling oe_holds_pvt.create_order_holds');
5398: oe_holds_pvt.Create_Order_Holds (
5399: p_hold_source_rec => l_hold_source_rec
5400: ,x_return_status => x_return_status
5401: ,x_msg_count => x_msg_count
5402: ,x_msg_data => x_msg_data

Line 5408: OE_Debug_PUB.Add('Error After oe_holds_pvt.Create_Order_Holds');

5404:
5405: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,1);
5406:
5407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5408: OE_Debug_PUB.Add('Error After oe_holds_pvt.Create_Order_Holds');
5409: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5410: RAISE FND_API.G_EXC_ERROR;
5411: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5594: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

5590: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
5591: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5592: ) IS
5593:
5594: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5595: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5596:
5597: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5598: l_org_id NUMBER := null;

Line 5595: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

5591: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5592: ) IS
5593:
5594: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5595: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5596:
5597: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5598: l_org_id NUMBER := null;
5599: l_hold_source_id NUMBER := null;

Line 5660: oe_holds_pvt.apply_Holds(

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'
5663: ,p_hold_future_flg => 'Y'
5664: ,x_return_status => x_return_status

Line 5669: oe_debug_pub.add('oe_holds_pvt.apply_Holds:x_return_status ' || x_return_status, 1);

5665: ,x_msg_count => x_msg_count
5666: ,x_msg_data => x_msg_data );
5667:
5668: IF l_debug_level > 0 THEN
5669: oe_debug_pub.add('oe_holds_pvt.apply_Holds:x_return_status ' || x_return_status, 1);
5670: END IF;
5671:
5672: l_return_status := x_return_status;
5673:

Line 5694: oe_holds_pvt.Release_Holds(

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
5697: ,x_return_status => x_return_status
5698: ,x_msg_count => x_msg_count

Line 5702: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status ' || x_return_status, 1);

5698: ,x_msg_count => x_msg_count
5699: ,x_msg_data => x_msg_data);
5700:
5701: IF l_debug_level > 0 THEN
5702: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status ' || x_return_status, 1);
5703: END IF;
5704:
5705: l_return_status := x_return_status;
5706:

Line 5761: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

5757: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
5758: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5759: ) IS
5760:
5761: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5762: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5763: l_hold_entity_code varchar2(1);
5764: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5765: l_hold_exists VARCHAR2(1) := 'N';

Line 5762: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

5758: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5759: ) IS
5760:
5761: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5762: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5763: l_hold_entity_code varchar2(1);
5764: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5765: l_hold_exists VARCHAR2(1) := 'N';
5766: l_org_id NUMBER := null;

Line 5820: oe_holds_pvt.apply_Holds(

5816: should we give a message to the user? Right now, the API does nothing.
5817:
5818: */
5819: IF NOT Hold_exists(p_hold_entity_code,p_hold_entity_id,p_hold_id,l_org_id) THEN
5820: oe_holds_pvt.apply_Holds(
5821: p_hold_source_rec => l_hold_source_rec
5822: ,p_hold_existing_flg => 'Y' -- Hold all existing orders
5823: ,p_hold_future_flg => 'Y' -- hold new orders also
5824: ,x_return_status => x_return_status

Line 5829: oe_debug_pub.add('oe_holds_pvt.apply:x_return_status: ' || x_return_status, 1);

5825: ,x_msg_count => x_msg_count
5826: ,x_msg_data => x_msg_data );
5827:
5828: IF l_debug_level > 0 THEN
5829: oe_debug_pub.add('oe_holds_pvt.apply:x_return_status: ' || x_return_status, 1);
5830: END IF;
5831:
5832: -- Exceptions and return status are checked in process_holds
5833: END IF; -- hold not exists

Line 5836: oe_holds_pvt.Release_Holds(

5832: -- Exceptions and return status are checked in process_holds
5833: END IF; -- hold not exists
5834: ELSIF p_action = 'RELEASE' THEN
5835:
5836: oe_holds_pvt.Release_Holds(
5837: p_hold_source_rec => l_hold_source_rec
5838: ,p_hold_release_rec => l_hold_release_rec
5839: ,x_return_status => x_return_status
5840: ,x_msg_count => x_msg_count

Line 5845: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status: ' || x_return_status, 1);

5841: ,x_msg_data => x_msg_data);
5842:
5843:
5844: IF l_debug_level > 0 THEN
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 ) ;