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 217: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

213: l_api_name CONSTANT VARCHAR2(30) := 'release_expired_holds';
214: l_api_version CONSTANT NUMBER := 1.0;
215: l_hold_source_id NUMBER := 0;
216:
217: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
218: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
219:
220: l_return_status VARCHAR2(30);
221: l_msg_count NUMBER;

Line 218: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

214: l_api_version CONSTANT NUMBER := 1.0;
215: l_hold_source_id NUMBER := 0;
216:
217: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
218: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
219:
220: l_return_status VARCHAR2(30);
221: l_msg_count NUMBER;
222: l_msg_data VARCHAR2(240);

Line 275: oe_holds_pvt.Release_Holds(

271: l_hold_release_rec.RELEASE_REASON_CODE := 'EXPIRE';
272: l_hold_release_rec.RELEASE_COMMENT :=
273: 'Expired Hold, Automatically Released';
274:
275: oe_holds_pvt.Release_Holds(
276: p_hold_source_rec => l_hold_source_rec
277: ,p_hold_release_rec => l_hold_release_rec
278: ,x_return_status => l_return_status
279: ,x_msg_count => l_msg_count

Line 551: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
549: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
550: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
551: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
552: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
553: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
554: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
555: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 583: oe_holds_pvt.apply_holds(

579:
580: -- Initialize API return status to success
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: oe_holds_pvt.apply_holds(
584: p_order_tbl => p_order_tbl,
585: p_hold_id => p_hold_id,
586: p_hold_until_date => p_hold_until_date,
587: p_hold_comment => p_hold_comment,

Line 631: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

627: p_api_version IN NUMBER,
628: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
629: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
630: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
631: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
632: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
633: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
634: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
635: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 632: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,

628: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
629: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
630: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
631: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
632: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
633: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
634: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
635: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
636: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 663: oe_holds_pvt.apply_Holds(

659: -- Initialize API return status to success
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: --dbms_output.put_line ('IN PUB.ApplyHolds'); -- delete
663: oe_holds_pvt.apply_Holds(
664: p_hold_source_rec => p_hold_source_rec
665: ,p_hold_existing_flg => p_hold_existing_flg
666: ,p_hold_future_flg => p_hold_future_flg
667: ,x_return_status => x_return_status

Line 716: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,

712: p_api_version IN NUMBER DEFAULT 1.0,
713: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
714: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
715: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
716: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
717: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
718: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
719: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
720: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 717: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,

713: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
714: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
715: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
716: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
717: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
718: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
719: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
720: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
721: IS

Line 746: oe_holds_pvt.Release_Holds(

742: -- Initialize API return status to success
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744:
745: -- dbms_output.put_line ('IN RELEASE_HOLDS->'); -- delete
746: oe_holds_pvt.Release_Holds(
747: p_hold_source_rec => p_hold_source_rec
748: ,p_hold_release_rec => p_hold_release_rec
749: ,x_return_status => x_return_status
750: ,x_msg_count => x_msg_count

Line 791: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

787: p_api_version IN NUMBER DEFAULT 1.0,
788: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
789: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
790: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
791: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
792: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
793: DEFAULT NULL,
794: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
795: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

Line 804: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

800: IS
801: l_api_name CONSTANT VARCHAR2(30) := 'Release_holds';
802: l_header_id NUMBER DEFAULT NULL;
803: j NUMBER;
804: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
805: l_org_id number;
806: --
807: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
808: --

Line 847: oe_holds_pvt.release_holds(

843: l_order_tbl(j).line_id := p_order_tbl(j).line_id;
844: END IF;
845: end loop;
846:
847: oe_holds_pvt.release_holds(
848: p_order_tbl => l_order_tbl,
849: p_hold_id => p_hold_id,
850: p_release_reason_code => p_release_reason_code,
851: p_release_comment => p_release_comment,

Line 936: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

932: l_entity_code2 oe_hold_sources_all.hold_entity_code2%TYPE; --ER#7479609
933: l_entity_id2 NUMBER;
934: l_header_id NUMBER DEFAULT NULL;
935:
936: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
937: l_site_use_code VARCHAR2(30);
938: l_org_id number;
939: --
940: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

1125:
1126: --dbms_output.put_line ('AH-hold_id' ||to_char(p_hold_source_rec.hold_id)); -- delete
1127: --dbms_output.put_line ('AH-B4ApplyHolds' ); -- delete
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.APPLY_HOLDS' ) ;
1130: END IF;
1131: oe_holds_pvt.apply_Holds(
1132: p_hold_source_rec => l_hold_source_rec
1133: ,p_hold_existing_flg => 'Y'

Line 1131: oe_holds_pvt.apply_Holds(

1127: --dbms_output.put_line ('AH-B4ApplyHolds' ); -- delete
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.APPLY_HOLDS' ) ;
1130: END IF;
1131: oe_holds_pvt.apply_Holds(
1132: p_hold_source_rec => l_hold_source_rec
1133: ,p_hold_existing_flg => 'Y'
1134: ,p_hold_future_flg => 'Y'
1135: ,x_return_status => x_return_status

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

1136: ,x_msg_count => x_msg_count
1137: ,x_msg_data => x_msg_data
1138: );
1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add( 'OE_HOLDS_PVT.APPLY_HOLDS STATUS:' || X_RETURN_STATUS ) ;
1141: END IF;
1142: --dbms_output.put_line('AH-x_return_status' || x_return_status ); -- delete
1143: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1144: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2382: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

2378: l_order_hold_id NUMBER := 0;
2379: --ER#7479609 l_entity_code VARCHAR2(1);
2380: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2381:
2382: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2383: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2384: l_org_id number;
2385:
2386: -- Define Cursors

Line 2383: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

2379: --ER#7479609 l_entity_code VARCHAR2(1);
2380: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2381:
2382: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
2383: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2384: l_org_id number;
2385:
2386: -- Define Cursors
2387: CURSOR hold_source IS

Line 2546: oe_holds_pvt.Release_Holds(

2542:
2543: IF l_debug_level > 0 THEN
2544: oe_debug_pub.add( 'CALLING RELEASE HOLDS , OLD' ) ;
2545: END IF;
2546: oe_holds_pvt.Release_Holds(
2547: p_hold_source_rec => l_hold_source_rec
2548: ,p_hold_release_rec => l_hold_release_rec
2549: ,x_return_status => x_return_status
2550: ,x_msg_count => x_msg_count

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

2550: ,x_msg_count => x_msg_count
2551: ,x_msg_data => x_msg_data
2552: );
2553: IF l_debug_level > 0 THEN
2554: oe_debug_pub.add( 'OE_HOLDS_PVT.RELEASE_HOLDS STATUS:' || X_RETURN_STATUS ) ;
2555: END IF;
2556:
2557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2884: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

2880: --l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC;
2881: temp NUMBER DEFAULT NULL;
2882: l_attribute VARCHAR2(30);
2883:
2884: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2885: --ER#7479609 l_hold_entity_code VARCHAR2(1);
2886: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
2887: --ER#7479609 l_hold_entity_id NUMBER;
2888: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

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

3493: l_hold_source_rec.header_id := l_header_id;
3494: l_hold_source_rec.line_id := l_line_id;
3495:
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3498: END IF;
3499: oe_holds_pvt.Create_Order_Holds (
3500: p_hold_source_rec => l_hold_source_rec
3501: ,x_return_status => x_return_status

Line 3499: oe_holds_pvt.Create_Order_Holds (

3495:
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3498: END IF;
3499: oe_holds_pvt.Create_Order_Holds (
3500: p_hold_source_rec => l_hold_source_rec
3501: ,x_return_status => x_return_status
3502: ,x_msg_count => x_msg_count
3503: ,x_msg_data => x_msg_data

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

3508: END IF;
3509:
3510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3511: IF l_debug_level > 0 THEN
3512: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3513: END IF;
3514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3515: RAISE FND_API.G_EXC_ERROR;
3516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

3760: l_hold_source_rec.header_id := l_header_id;
3761: l_hold_source_rec.line_id := l_line_id;
3762:
3763: IF l_debug_level > 0 THEN
3764: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3765: END IF;
3766: oe_holds_pvt.Create_Order_Holds (
3767: p_hold_source_rec => l_hold_source_rec
3768: ,x_return_status => x_return_status

Line 3766: oe_holds_pvt.Create_Order_Holds (

3762:
3763: IF l_debug_level > 0 THEN
3764: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3765: END IF;
3766: oe_holds_pvt.Create_Order_Holds (
3767: p_hold_source_rec => l_hold_source_rec
3768: ,x_return_status => x_return_status
3769: ,x_msg_count => x_msg_count
3770: ,x_msg_data => x_msg_data

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

3775: END IF;
3776:
3777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3778: IF l_debug_level > 0 THEN
3779: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
3780: END IF;
3781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3782: RAISE FND_API.G_EXC_ERROR;
3783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3972: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

3968: l_return_status VARCHAR2(30);
3969: l_msg_count NUMBER;
3970: l_msg_data VARCHAR2(2000);
3971: l_attribute VARCHAR2(30);
3972: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3973: l_hold_entity_code VARCHAR2(1);
3974: --ER#7479609 l_hold_entity_id NUMBER;
3975: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609
3976: --ER#7479609 l_hold_entity_code2 VARCHAR2(1);

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

4069: l_hold_source_rec.header_id := l_header_id;
4070: l_hold_source_rec.line_id := l_line_id;
4071:
4072: IF l_debug_level > 0 THEN
4073: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4074: END IF;
4075: oe_holds_pvt.Create_Order_Holds (
4076: p_hold_source_rec => l_hold_source_rec
4077: ,x_return_status => x_return_status

Line 4075: oe_holds_pvt.Create_Order_Holds (

4071:
4072: IF l_debug_level > 0 THEN
4073: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4074: END IF;
4075: oe_holds_pvt.Create_Order_Holds (
4076: p_hold_source_rec => l_hold_source_rec
4077: ,x_return_status => x_return_status
4078: ,x_msg_count => x_msg_count
4079: ,x_msg_data => x_msg_data

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

4085: END IF;
4086:
4087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4088: IF l_debug_level > 0 THEN
4089: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4090: END IF;
4091: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4092: RAISE FND_API.G_EXC_ERROR;
4093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4171: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

4167: l_msg_data VARCHAR2(2000);
4168: temp NUMBER DEFAULT NULL;
4169: l_attribute VARCHAR2(50);
4170: --
4171: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
4172: --ER#7479609 l_hold_entity_code VARCHAR2(1);
4173: l_hold_entity_code oe_hold_sources_all.hold_entity_code%TYPE; --ER#7479609
4174: --ER#7479609 l_hold_entity_id NUMBER;
4175: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE; --ER#7479609

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

4668: l_hold_source_rec.header_id := l_header_id;
4669: l_hold_source_rec.line_id := l_line_id;
4670:
4671: IF l_debug_level > 0 THEN
4672: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4673: END IF;
4674: oe_holds_pvt.Create_Order_Holds (
4675: p_hold_source_rec => l_hold_source_rec
4676: ,x_return_status => x_return_status

Line 4674: oe_holds_pvt.Create_Order_Holds (

4670:
4671: IF l_debug_level > 0 THEN
4672: oe_debug_pub.add( 'CALLING OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4673: END IF;
4674: oe_holds_pvt.Create_Order_Holds (
4675: p_hold_source_rec => l_hold_source_rec
4676: ,x_return_status => x_return_status
4677: ,x_msg_count => x_msg_count
4678: ,x_msg_data => x_msg_data

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

4684: END IF;
4685:
4686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4687: IF l_debug_level > 0 THEN
4688: oe_debug_pub.add( 'ERROR AFTER OE_HOLDS_PVT.CREATE_ORDER_HOLDS' ) ;
4689: END IF;
4690: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4691: RAISE FND_API.G_EXC_ERROR;
4692: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

4861: l_hold_source_rec.hold_source_id := l_hold_source_id;
4862: l_hold_source_rec.header_id := l_header_id;
4863: l_hold_source_rec.line_id := l_line_id;
4864:
4865: oe_debug_pub.add('Calling oe_holds_pvt.create_order_holds');
4866: oe_holds_pvt.Create_Order_Holds (
4867: p_hold_source_rec => l_hold_source_rec
4868: ,x_return_status => x_return_status
4869: ,x_msg_count => x_msg_count

Line 4866: oe_holds_pvt.Create_Order_Holds (

4862: l_hold_source_rec.header_id := l_header_id;
4863: l_hold_source_rec.line_id := l_line_id;
4864:
4865: oe_debug_pub.add('Calling oe_holds_pvt.create_order_holds');
4866: oe_holds_pvt.Create_Order_Holds (
4867: p_hold_source_rec => l_hold_source_rec
4868: ,x_return_status => x_return_status
4869: ,x_msg_count => x_msg_count
4870: ,x_msg_data => x_msg_data

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

4872:
4873: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,1);
4874:
4875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4876: OE_Debug_PUB.Add('Error After oe_holds_pvt.Create_Order_Holds');
4877: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4878: RAISE FND_API.G_EXC_ERROR;
4879: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5047: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

5043: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
5044: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5045: ) IS
5046:
5047: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5048: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5049:
5050: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5051: l_org_id NUMBER := null;

Line 5048: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

5044: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5045: ) IS
5046:
5047: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5048: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5049:
5050: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5051: l_org_id NUMBER := null;
5052: l_hold_source_id NUMBER := null;

Line 5113: oe_holds_pvt.apply_Holds(

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'
5116: ,p_hold_future_flg => 'Y'
5117: ,x_return_status => x_return_status

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

5118: ,x_msg_count => x_msg_count
5119: ,x_msg_data => x_msg_data );
5120:
5121: IF l_debug_level > 0 THEN
5122: oe_debug_pub.add('oe_holds_pvt.apply_Holds:x_return_status ' || x_return_status, 1);
5123: END IF;
5124:
5125: l_return_status := x_return_status;
5126:

Line 5147: oe_holds_pvt.Release_Holds(

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
5150: ,x_return_status => x_return_status
5151: ,x_msg_count => x_msg_count

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

5151: ,x_msg_count => x_msg_count
5152: ,x_msg_data => x_msg_data);
5153:
5154: IF l_debug_level > 0 THEN
5155: oe_debug_pub.add('oe_holds_pvt.Release_Holds:x_return_status ' || x_return_status, 1);
5156: END IF;
5157:
5158: l_return_status := x_return_status;
5159:

Line 5214: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

5210: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
5211: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5212: ) IS
5213:
5214: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5215: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5216: l_hold_entity_code varchar2(1);
5217: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5218: l_hold_exists VARCHAR2(1) := 'N';

Line 5215: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

5211: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5212: ) IS
5213:
5214: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5215: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
5216: l_hold_entity_code varchar2(1);
5217: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5218: l_hold_exists VARCHAR2(1) := 'N';
5219: l_org_id NUMBER := null;

Line 5273: oe_holds_pvt.apply_Holds(

5269: should we give a message to the user? Right now, the API does nothing.
5270:
5271: */
5272: IF NOT Hold_exists(p_hold_entity_code,p_hold_entity_id,p_hold_id,l_org_id) THEN
5273: oe_holds_pvt.apply_Holds(
5274: p_hold_source_rec => l_hold_source_rec
5275: ,p_hold_existing_flg => 'Y' -- Hold all existing orders
5276: ,p_hold_future_flg => 'Y' -- hold new orders also
5277: ,x_return_status => x_return_status

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

5278: ,x_msg_count => x_msg_count
5279: ,x_msg_data => x_msg_data );
5280:
5281: IF l_debug_level > 0 THEN
5282: oe_debug_pub.add('oe_holds_pvt.apply:x_return_status: ' || x_return_status, 1);
5283: END IF;
5284:
5285: -- Exceptions and return status are checked in process_holds
5286: END IF; -- hold not exists

Line 5289: oe_holds_pvt.Release_Holds(

5285: -- Exceptions and return status are checked in process_holds
5286: END IF; -- hold not exists
5287: ELSIF p_action = 'RELEASE' THEN
5288:
5289: oe_holds_pvt.Release_Holds(
5290: p_hold_source_rec => l_hold_source_rec
5291: ,p_hold_release_rec => l_hold_release_rec
5292: ,x_return_status => x_return_status
5293: ,x_msg_count => x_msg_count

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

5294: ,x_msg_data => x_msg_data);
5295:
5296:
5297: IF l_debug_level > 0 THEN
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 ) ;