APPS.OE_RESERVE_CONC dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: THEN
71: OE_MSG_PUB.Add_Exc_Msg
72: ( G_PKG_NAME, 'Reservable_Quantity');
73: END IF;
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75:
76: END;
77: -- Getting reservable quantity
78: Query_Qty_Tree(p_ship_from_org_id => p_ship_from_org_id,

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: OE_MSG_PUB.Add_Exc_Msg
104: ( G_PKG_NAME,
105: 'Reservable_Quantity');
106: END IF;
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108:
109: END Reservable_Quantity;
110: /*------------------------------------------------------
111: Procedure Name : Commit_Reservation

Line 119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

115: --------------------------------------------------------------------- */
116: PROCEDURE Commit_Reservation(p_request_id IN NUMBER,
117: x_return_status OUT NOCOPY VARCHAR2)
118: IS
119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
120: l_msg_count NUMBER;
121: l_msg_data VARCHAR2(1000);
122: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
123: --

Line 133: ,p_init_msg_lst => FND_API.G_FALSE

129: oe_debug_pub.add( ' BEFORE CALLING DO_CHECK_FOR_COMMIT' , 1 ) ;
130: END IF;
131: INV_RESERVATION_PVT.Do_Check_For_Commit
132: (p_api_version_number => 1.0
133: ,p_init_msg_lst => FND_API.G_FALSE
134: ,x_return_status => l_return_status
135: ,x_msg_count => l_msg_count
136: ,x_msg_data => l_msg_data
137: ,x_failed_rsv_temp_tbl => l_failed_rsv_temp_tbl);

Line 143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

139: IF l_debug_level > 0 THEN
140: oe_debug_pub.add( ' AFTER CALLING DO_CHECK_FOR_COMMIT:'||l_return_status , 1 ) ;
141: END IF;
142: -- Error Handling Start
143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR' , 1 ) ;
146: END IF;
147: OE_MSG_PUB.Transfer_Msg_Stack;

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: IF l_debug_level > 0 THEN
154: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
155: END IF;
156: END LOOP;
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158:
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: IF l_debug_level > 0 THEN
161: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;

Line 159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

155: END IF;
156: END LOOP;
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158:
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: IF l_debug_level > 0 THEN
161: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
162: END IF;
163: OE_MSG_PUB.Save_Messages(p_request_id => p_request_id);

Line 164: RAISE FND_API.G_EXC_ERROR;

160: IF l_debug_level > 0 THEN
161: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
162: END IF;
163: OE_MSG_PUB.Save_Messages(p_request_id => p_request_id);
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;
166: x_return_status := l_return_status;
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164: RAISE FND_API.G_EXC_ERROR;
165: END IF;
166: x_return_status := l_return_status;
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: IF l_debug_level > 0 THEN
170: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: WHEN FND_API.G_EXC_ERROR THEN
169: IF l_debug_level > 0 THEN
170: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
176: END IF;

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: IF l_debug_level > 0 THEN
170: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
176: END IF;
177: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 177: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
176: END IF;
177: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: WHEN OTHERS THEN
180: IF l_debug_level > 0 THEN
181: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
176: END IF;
177: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: WHEN OTHERS THEN
180: IF l_debug_level > 0 THEN
181: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
182: END IF;

Line 183: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: WHEN OTHERS THEN
180: IF l_debug_level > 0 THEN
181: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
182: END IF;
183: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END Commit_Reservation;
186:
187: /*------------------------------------------------------

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: IF l_debug_level > 0 THEN
181: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
182: END IF;
183: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END Commit_Reservation;
186:
187: /*------------------------------------------------------
188: Procedure Name : Validate_and_Reserve_for_Set

Line 324: ,p_partial_reservation => FND_API.G_FALSE

320: END IF;
321: END LOOP;
322: oe_debug_pub.add('Before calling Create Reservation: ' || l_rsv_tbl.count,1);
323: create_reservation(p_x_rsv_tbl => l_rsv_tbl
324: ,p_partial_reservation => FND_API.G_FALSE
325: ,x_return_status => l_return_status);
326: x_return_status := l_return_status;
327: IF l_debug_level > 0 THEN
328: oe_debug_pub.add( 'EXITING VALIDATE_AND_RESERVE_FOR_SET: '||l_return_status , 1 ) ;

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: IF l_debug_level > 0 THEN
328: oe_debug_pub.add( 'EXITING VALIDATE_AND_RESERVE_FOR_SET: '||l_return_status , 1 ) ;
329: END IF;
330: EXCEPTION
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: IF l_debug_level > 0 THEN
333: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
334: END IF;
335: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 335: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: IF l_debug_level > 0 THEN
333: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
334: END IF;
335: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: WHEN OTHERS THEN
338: IF l_debug_level > 0 THEN
339: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);

Line 336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

332: IF l_debug_level > 0 THEN
333: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
334: END IF;
335: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: WHEN OTHERS THEN
338: IF l_debug_level > 0 THEN
339: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
340: END IF;

Line 341: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337: WHEN OTHERS THEN
338: IF l_debug_level > 0 THEN
339: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
340: END IF;
341: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END Validate_and_Reserve_for_Set;
344:
345: /*------------------------------------------------------

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: IF l_debug_level > 0 THEN
339: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
340: END IF;
341: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END Validate_and_Reserve_for_Set;
344:
345: /*------------------------------------------------------
346: Procedure Name : Update_Reservation_Set

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: last_updated_by = FND_GLOBAL.USER_ID,
369: last_update_date = sysdate
370: WHERE reservation_set_id = p_reservation_set_id;
371: IF (SQL%NOTFOUND) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: ELSE
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: END IF;
376: IF l_debug_level > 0 THEN

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: WHERE reservation_set_id = p_reservation_set_id;
371: IF (SQL%NOTFOUND) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: ELSE
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: END IF;
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'EXITING UPDATE_RESERVATION_SET ' , 1 ) ;
378: END IF;

Line 385: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: WHEN OTHERS THEN
382: IF l_debug_level > 0 THEN
383: OE_DEBUG_PUB.Add('In others error...in Proc Update_Reservation_Set for rsv set tbl',1);
384: END IF;
385: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END Update_Reservation_Set;
388:
389:

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: IF l_debug_level > 0 THEN
383: OE_DEBUG_PUB.Add('In others error...in Proc Update_Reservation_Set for rsv set tbl',1);
384: END IF;
385: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END Update_Reservation_Set;
388:
389:
390: /*------------------------------------------------------

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534:
535: IF l_debug_level > 0 THEN
536: oe_debug_pub.add( 'EXITING CREATE_RESERVATION_SET ' , 1 ) ;
537: END IF;
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: EXCEPTION
540: WHEN OTHERS THEN
541: IF l_debug_level > 0 THEN
542: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);

Line 544: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

540: WHEN OTHERS THEN
541: IF l_debug_level > 0 THEN
542: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);
543: END IF;
544: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END Create_Reservation_Set;
547:
548: /*------------------------------------------------------

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

541: IF l_debug_level > 0 THEN
542: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);
543: END IF;
544: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END Create_Reservation_Set;
547:
548: /*------------------------------------------------------
549: Procedure Name : Calculate_Partial_Quantity

Line 794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

790: oe_debug_pub.add( 'EXITING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;
791: END IF;
792:
793: EXCEPTION
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: IF l_debug_level > 0 THEN
796: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
797: END IF;
798: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 798: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: IF l_debug_level > 0 THEN
796: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
797: END IF;
798: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: WHEN OTHERS THEN
801: IF l_debug_level > 0 THEN
802: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: IF l_debug_level > 0 THEN
796: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
797: END IF;
798: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: WHEN OTHERS THEN
801: IF l_debug_level > 0 THEN
802: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
803: END IF;

Line 804: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: WHEN OTHERS THEN
801: IF l_debug_level > 0 THEN
802: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
803: END IF;
804: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END Calculate_Partial_Quantity;
807:
808: /*-------------------------------------------------------------------

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: IF l_debug_level > 0 THEN
802: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
803: END IF;
804: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END Calculate_Partial_Quantity;
807:
808: /*-------------------------------------------------------------------
809: Procedure Name : Query_Qty_Tree

Line 878: , p_init_msg_lst => FND_API.G_TRUE

874:
875: --inv_quantity_tree_pvt.clear_quantity_cache;
876: inv_quantity_tree_pvt.mark_all_for_refresh
877: ( p_api_version_number => 1.0
878: , p_init_msg_lst => FND_API.G_TRUE
879: , x_return_status => l_return_status
880: , x_msg_count => l_msg_count
881: , x_msg_data => l_msg_data
882: );

Line 884: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

880: , x_msg_count => l_msg_count
881: , x_msg_data => l_msg_data
882: );
883:
884: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
885: oe_msg_pub.transfer_msg_stack;
886: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
887: for I in 1..l_msg_count loop
888: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
891: END IF;
892: end loop;
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
895: oe_msg_pub.transfer_msg_stack;
896: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
897: for I in 1..l_msg_count loop

Line 894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

890: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
891: END IF;
892: end loop;
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
895: oe_msg_pub.transfer_msg_stack;
896: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
897: for I in 1..l_msg_count loop
898: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 903: RAISE FND_API.G_EXC_ERROR;

899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
901: END IF;
902: end loop;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905:
906:
907:

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: OE_MSG_PUB.Add_Exc_Msg
964: ( G_PKG_NAME,
965: 'Query_Qty_Tree');
966: END IF;
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: END Query_Qty_Tree;
969: /*----------------------------------------------------------------
970: PROCEDURE : Calculate_Percentage
971: DESCRIPTION: This Procedure is to determine the percengae when program

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME,
1017: 'Calculate_Percentage');
1018: END IF;
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020:
1021: END;
1022: -- Getting the ordered quantity
1023: IF l_debug_level > 0 THEN

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: OE_MSG_PUB.Add_Exc_Msg
1089: ( G_PKG_NAME,
1090: 'Calculate_Percentage');
1091: END IF;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093:
1094:
1095: END calculate_Percentage;
1096:

Line 1295: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1291: Reservation
1292: -----------------------------------------------------------------*/
1293: Procedure Create_Reservation
1294: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1295: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1296: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1297: IS
1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1299: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

Line 1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1294: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1295: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1296: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1297: IS
1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1299: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1300: l_msg_count NUMBER;
1301: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1302: l_msg_data VARCHAR2(1000);

Line 1369: l_reservation_rec.reservation_id := fnd_api.g_miss_num; -- cannot know

1365: END IF;
1366:
1367:
1368: l_reservation_rec := null;
1369: l_reservation_rec.reservation_id := fnd_api.g_miss_num; -- cannot know
1370: l_reservation_rec.requirement_date := p_x_rsv_tbl(I).schedule_ship_date;
1371: l_reservation_rec.organization_id := p_x_rsv_tbl(I).ship_from_org_id;
1372: l_reservation_rec.inventory_item_id := p_x_rsv_tbl(I).inventory_item_id;
1373:

Line 1446: --IF l_qty_return_status = FND_API.G_RET_STS_SUCCESS

1442: ELSE
1443: l_validated_quantity := l_reservation_rec.reservation_quantity;
1444: END IF;
1445:
1446: --IF l_qty_return_status = FND_API.G_RET_STS_SUCCESS
1447: IF l_validated_quantity > 0 THEN
1448: l_reservation_rec.reservation_quantity := l_validated_quantity;
1449:
1450: -- Partial reservation check

Line 1464: , p_init_msg_lst => FND_API.G_TRUE

1460: ||l_reservation_rec.reservation_quantity,1);
1461: END IF;
1462: INV_RESERVATION_PUB.Create_Reservation
1463: ( p_api_version_number => 1.0
1464: , p_init_msg_lst => FND_API.G_TRUE
1465: , x_return_status => l_return_status
1466: , x_msg_count => l_msg_count
1467: , x_msg_data => l_msg_data
1468: , p_rsv_rec => l_reservation_rec

Line 1471: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE

1467: , x_msg_data => l_msg_data
1468: , p_rsv_rec => l_reservation_rec
1469: , p_serial_number => l_dummy_sn
1470: , x_serial_number => l_dummy_sn
1471: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1472: , p_force_reservation_flag => FND_API.G_FALSE
1473: , p_validation_flag => FND_API.G_TRUE
1474: , x_quantity_reserved => l_quantity_reserved
1475: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV

Line 1472: , p_force_reservation_flag => FND_API.G_FALSE

1468: , p_rsv_rec => l_reservation_rec
1469: , p_serial_number => l_dummy_sn
1470: , x_serial_number => l_dummy_sn
1471: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1472: , p_force_reservation_flag => FND_API.G_FALSE
1473: , p_validation_flag => FND_API.G_TRUE
1474: , x_quantity_reserved => l_quantity_reserved
1475: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1476: , x_reservation_id => l_rsv_id

Line 1473: , p_validation_flag => FND_API.G_TRUE

1469: , p_serial_number => l_dummy_sn
1470: , x_serial_number => l_dummy_sn
1471: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1472: , p_force_reservation_flag => FND_API.G_FALSE
1473: , p_validation_flag => FND_API.G_TRUE
1474: , x_quantity_reserved => l_quantity_reserved
1475: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1476: , x_reservation_id => l_rsv_id
1477: , p_partial_rsv_exists => l_rsv_exists

Line 1483: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1479: IF l_debug_level > 0 THEN
1480: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' || l_return_status ||' '||l_quantity_reserved,1);
1481: END IF;
1482: -- Pack J
1483: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1484: l_commit_count := l_commit_count + 1;
1485:
1486: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: IF l_debug_level > 0 THEN

Line 1486: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1482: -- Pack J
1483: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1484: l_commit_count := l_commit_count + 1;
1485:
1486: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: IF l_debug_level > 0 THEN
1488: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1489: END IF;
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1486: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: IF l_debug_level > 0 THEN
1488: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1489: END IF;
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491:
1492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1493: IF l_debug_level > 0 THEN
1494: OE_DEBUG_PUB.Add('Raising Expected error',1);

Line 1492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1488: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1489: END IF;
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491:
1492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1493: IF l_debug_level > 0 THEN
1494: OE_DEBUG_PUB.Add('Raising Expected error',1);
1495: END IF;
1496: IF l_msg_data is not null THEN

Line 1504: --RAISE FND_API.G_EXC_ERROR; -- Commented as we don't need to fail the program for excepted error.

1500: IF l_debug_level > 0 THEN
1501: OE_DEBUG_PUB.Add(l_msg_data,1);
1502: END IF;
1503: END IF;
1504: --RAISE FND_API.G_EXC_ERROR; -- Commented as we don't need to fail the program for excepted error.
1505:
1506: END IF;
1507: END IF;
1508: -- Pack J

Line 1540: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1536: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
1537:
1538: COMMIT;
1539: -- For Expected errors we will consider status as success.
1540: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: l_return_status := FND_API.G_RET_STS_SUCCESS;
1542: END IF;
1543: x_return_status := l_return_status;
1544: IF l_debug_level > 0 THEN

Line 1541: l_return_status := FND_API.G_RET_STS_SUCCESS;

1537:
1538: COMMIT;
1539: -- For Expected errors we will consider status as success.
1540: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: l_return_status := FND_API.G_RET_STS_SUCCESS;
1542: END IF;
1543: x_return_status := l_return_status;
1544: IF l_debug_level > 0 THEN
1545: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);

Line 1549: WHEN FND_API.G_EXC_ERROR THEN

1545: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);
1546: END IF;
1547:
1548: EXCEPTION
1549: WHEN FND_API.G_EXC_ERROR THEN
1550: IF l_debug_level > 0 THEN
1551: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1552: END IF;
1553: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1553: x_return_status := FND_API.G_RET_STS_ERROR;

1549: WHEN FND_API.G_EXC_ERROR THEN
1550: IF l_debug_level > 0 THEN
1551: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1552: END IF;
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554:
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: IF l_debug_level > 0 THEN
1557: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );

Line 1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1551: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1552: END IF;
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554:
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: IF l_debug_level > 0 THEN
1557: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );
1558: END IF;
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: IF l_debug_level > 0 THEN
1557: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );
1558: END IF;
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560:
1561: WHEN OTHERS THEN
1562: IF l_debug_level > 0 THEN
1563: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation for rsv tbl',1);

Line 1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1561: WHEN OTHERS THEN
1562: IF l_debug_level > 0 THEN
1563: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation for rsv tbl',1);
1564: END IF;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566:
1567: END create_reservation;
1568:
1569: /*----------------------------------------------------------------

Line 1641: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1637:
1638:
1639: create_reservation(p_x_rsv_tbl => p_rsv_tbl
1640: ,x_return_status => l_return_status);
1641: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1642: AND p_reserve_set_name IS NOT NULL THEN -- Pack J
1643: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
1644: Create_Reservation_Set(p_rsv_tbl => p_rsv_tbl,
1645: p_reserve_set_name => p_reserve_set_name,

Line 1651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1647: x_return_status => l_return_status);
1648:
1649: END IF;
1650:
1651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1652: IF l_debug_level > 0 THEN
1653: OE_DEBUG_PUB.Add('Create Reservation returned with Expected error for rsv tbl ',1);
1654: END IF;
1655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1652: IF l_debug_level > 0 THEN
1653: OE_DEBUG_PUB.Add('Create Reservation returned with Expected error for rsv tbl ',1);
1654: END IF;
1655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1656: IF l_debug_level > 0 THEN
1657: OE_DEBUG_PUB.Add('Create Reservation returned with Unexpected error for rsv tbl',1);
1658: END IF;
1659: END IF;

Line 1693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1689: p_use_reservation_time_fence IN VARCHAR2,
1690: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1691: )
1692: IS
1693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1694: l_result Varchar2(30);
1695: l_scheduling_level_code VARCHAR2(30) := NULL;
1696: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1697: l_type_code VARCHAR2(30);

Line 1696: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1692: IS
1693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1694: l_result Varchar2(30);
1695: l_scheduling_level_code VARCHAR2(30) := NULL;
1696: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1697: l_type_code VARCHAR2(30);
1698: l_org_id NUMBER;
1699: l_time_fence BOOLEAN;
1700: l_msg_count NUMBER;

Line 1718: l_return_status := FND_API.G_RET_STS_ERROR;

1714: IF ( p_line_rec.open_flag = 'N' ) THEN
1715: IF l_debug_level > 0 THEN
1716: OE_DEBUG_PUB.Add('Line is closed, not eligible for reservation', 1);
1717: END IF;
1718: l_return_status := FND_API.G_RET_STS_ERROR;
1719:
1720: /* Check if line is shipped, if shipped then ignore the line */
1721: ELSIF ( nvl(p_line_rec.shipped_quantity, -99) > 0 ) THEN
1722: IF l_debug_level > 0 THEN

Line 1725: l_return_status := FND_API.G_RET_STS_ERROR;

1721: ELSIF ( nvl(p_line_rec.shipped_quantity, -99) > 0 ) THEN
1722: IF l_debug_level > 0 THEN
1723: OE_DEBUG_PUB.Add('Line is shipped, not eligible for reservation', 1);
1724: END IF;
1725: l_return_status := FND_API.G_RET_STS_ERROR;
1726: --Added for bug 6873122
1727: ELSIF ( nvl(p_line_rec.fulfilled_quantity, -99) > 0 ) THEN
1728: IF l_debug_level > 0 THEN
1729: OE_DEBUG_PUB.Add('Line is Fulfilled, not eligible for reservation', 1);

Line 1731: l_return_status := FND_API.G_RET_STS_ERROR;

1727: ELSIF ( nvl(p_line_rec.fulfilled_quantity, -99) > 0 ) THEN
1728: IF l_debug_level > 0 THEN
1729: OE_DEBUG_PUB.Add('Line is Fulfilled, not eligible for reservation', 1);
1730: END IF;
1731: l_return_status := FND_API.G_RET_STS_ERROR;
1732: --Added for bug 6873122
1733: END IF;
1734:
1735: IF l_return_status = FND_API.G_RET_STS_SUCCESS

Line 1735: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1731: l_return_status := FND_API.G_RET_STS_ERROR;
1732: --Added for bug 6873122
1733: END IF;
1734:
1735: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1736: AND NVL(g_reservation_mode,'*') <> 'PARTIAL' THEN -- Pack J
1737: /* We need to check for Existing Reservations on the Line */
1738: BEGIN
1739: IF l_debug_level > 0 THEN

Line 1752: RAISE FND_API.G_EXC_ERROR;

1748: IF l_debug_level > 0 THEN
1749: OE_DEBUG_PUB.Add('Reservations exists on the line',3);
1750: END IF;
1751:
1752: RAISE FND_API.G_EXC_ERROR;
1753: EXCEPTION
1754: WHEN FND_API.G_EXC_ERROR THEN
1755: IF l_debug_level > 0 THEN
1756: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);

Line 1754: WHEN FND_API.G_EXC_ERROR THEN

1750: END IF;
1751:
1752: RAISE FND_API.G_EXC_ERROR;
1753: EXCEPTION
1754: WHEN FND_API.G_EXC_ERROR THEN
1755: IF l_debug_level > 0 THEN
1756: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);
1757: END IF;
1758: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1758: l_return_status := FND_API.G_RET_STS_ERROR;

1754: WHEN FND_API.G_EXC_ERROR THEN
1755: IF l_debug_level > 0 THEN
1756: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);
1757: END IF;
1758: l_return_status := FND_API.G_RET_STS_ERROR;
1759:
1760: WHEN NO_DATA_FOUND THEN
1761: NULL;
1762: WHEN TOO_MANY_ROWS THEN

Line 1764: l_return_status := FND_API.G_RET_STS_ERROR; --2929716

1760: WHEN NO_DATA_FOUND THEN
1761: NULL;
1762: WHEN TOO_MANY_ROWS THEN
1763: -- NULL;
1764: l_return_status := FND_API.G_RET_STS_ERROR; --2929716
1765: END;
1766: END IF;
1767: -- 3250889 Starts
1768: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1768: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1764: l_return_status := FND_API.G_RET_STS_ERROR; --2929716
1765: END;
1766: END IF;
1767: -- 3250889 Starts
1768: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1769: BEGIN
1770: IF l_debug_level > 0 THEN
1771: OE_DEBUG_PUB.Add('Before checking for Staged/Closed deliveries', 1);
1772: END IF;

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: IF l_debug_level > 0 THEN
1782: OE_DEBUG_PUB.Add('Staged/Closed deliveries exist for the line', 3);
1783: END IF;
1784:
1785: RAISE FND_API.G_EXC_ERROR;
1786:
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: IF l_debug_level > 0 THEN

Line 1788: WHEN FND_API.G_EXC_ERROR THEN

1784:
1785: RAISE FND_API.G_EXC_ERROR;
1786:
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: IF l_debug_level > 0 THEN
1790: OE_DEBUG_PUB.Add('In Expected Error for Checking Staged/Closed deliveries', 3);
1791: END IF;
1792: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1792: l_return_status := FND_API.G_RET_STS_ERROR;

1788: WHEN FND_API.G_EXC_ERROR THEN
1789: IF l_debug_level > 0 THEN
1790: OE_DEBUG_PUB.Add('In Expected Error for Checking Staged/Closed deliveries', 3);
1791: END IF;
1792: l_return_status := FND_API.G_RET_STS_ERROR;
1793: WHEN NO_DATA_FOUND THEN
1794: NULL;
1795: WHEN TOO_MANY_ROWS THEN
1796: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1796: l_return_status := FND_API.G_RET_STS_ERROR;

1792: l_return_status := FND_API.G_RET_STS_ERROR;
1793: WHEN NO_DATA_FOUND THEN
1794: NULL;
1795: WHEN TOO_MANY_ROWS THEN
1796: l_return_status := FND_API.G_RET_STS_ERROR;
1797: END;
1798: END IF;
1799: -- 3250889 Ends
1800: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1800: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1796: l_return_status := FND_API.G_RET_STS_ERROR;
1797: END;
1798: END IF;
1799: -- 3250889 Ends
1800: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1801:
1802: -- WE NEED TO CHECK FOR THE reservation_time_fence Value.
1803: -- If the Value of the parameter passed to the concurrent
1804: -- program is "NO' then we reserve the lines irrespective

Line 1824: RAISE FND_API.G_EXC_ERROR ;

1820: IF l_debug_level > 0 THEN
1821: OE_DEBUG_PUB.Add('The Schedule Date for Line falls
1822: beyond reservation Time Fence',3);
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR ;
1825:
1826: END IF;
1827: ELSE */
1828: -- 4689197

Line 1835: RAISE FND_API.G_EXC_ERROR ;

1831: IF l_debug_level > 0 THEN
1832: OE_DEBUG_PUB.Add('The Schedule Date for Line falls
1833: beyond reservation Time Fence',3);
1834: END IF;
1835: RAISE FND_API.G_EXC_ERROR ;
1836:
1837: END IF;
1838: END IF;
1839: -- END IF;

Line 1877: RAISE FND_API.G_EXC_ERROR;

1873: THEN
1874: IF l_debug_level > 0 THEN
1875: OE_DEBUG_PUB.Add('Order Type Does not Allow Scheduling',3);
1876: END IF;
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF;
1879: END IF;
1880:
1881: END IF; -- Check for Reservation Exists Clause

Line 1889: WHEN FND_API.G_EXC_ERROR THEN

1885: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||
1886: l_return_status ,1);
1887: END IF;
1888: EXCEPTION
1889: WHEN FND_API.G_EXC_ERROR THEN
1890: IF l_debug_level > 0 THEN
1891: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1892: END IF;
1893: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1893: x_return_status := FND_API.G_RET_STS_ERROR;

1889: WHEN FND_API.G_EXC_ERROR THEN
1890: IF l_debug_level > 0 THEN
1891: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1892: END IF;
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896: IF l_debug_level > 0 THEN
1897: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);

Line 1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1891: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1892: END IF;
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896: IF l_debug_level > 0 THEN
1897: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);
1898: END IF;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896: IF l_debug_level > 0 THEN
1897: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);
1898: END IF;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: WHEN OTHERS THEN
1902:
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: WHEN OTHERS THEN
1902:
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1904:
1905: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1906: THEN
1907: OE_MSG_PUB.Add_Exc_Msg

Line 1925: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1921: Procedure Create_Reservation
1922: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1923: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1924: IS
1925: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1926: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1927: l_msg_count NUMBER;
1928: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1929: l_msg_data VARCHAR2(1000);

Line 1981: , p_init_msg_lst => FND_API.G_TRUE

1977: END IF;
1978:
1979: INV_RESERVATION_PUB.Create_Reservation
1980: ( p_api_version_number => 1.0
1981: , p_init_msg_lst => FND_API.G_TRUE
1982: , x_return_status => l_return_status
1983: , x_msg_count => l_msg_count
1984: , x_msg_data => l_msg_data
1985: , p_rsv_rec => l_reservation_rec

Line 1988: , p_partial_reservation_flag => FND_API.G_FALSE

1984: , x_msg_data => l_msg_data
1985: , p_rsv_rec => l_reservation_rec
1986: , p_serial_number => l_dummy_sn
1987: , x_serial_number => l_dummy_sn
1988: , p_partial_reservation_flag => FND_API.G_FALSE
1989: , p_force_reservation_flag => FND_API.G_FALSE
1990: , p_validation_flag => FND_API.G_TRUE
1991: , x_quantity_reserved => l_quantity_reserved
1992: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV

Line 1989: , p_force_reservation_flag => FND_API.G_FALSE

1985: , p_rsv_rec => l_reservation_rec
1986: , p_serial_number => l_dummy_sn
1987: , x_serial_number => l_dummy_sn
1988: , p_partial_reservation_flag => FND_API.G_FALSE
1989: , p_force_reservation_flag => FND_API.G_FALSE
1990: , p_validation_flag => FND_API.G_TRUE
1991: , x_quantity_reserved => l_quantity_reserved
1992: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1993: , x_reservation_id => l_rsv_id

Line 1990: , p_validation_flag => FND_API.G_TRUE

1986: , p_serial_number => l_dummy_sn
1987: , x_serial_number => l_dummy_sn
1988: , p_partial_reservation_flag => FND_API.G_FALSE
1989: , p_force_reservation_flag => FND_API.G_FALSE
1990: , p_validation_flag => FND_API.G_TRUE
1991: , x_quantity_reserved => l_quantity_reserved
1992: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1993: , x_reservation_id => l_rsv_id
1994: );

Line 2001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1997: l_return_status,1);
1998: OE_DEBUG_PUB.Add(l_msg_data,1);
1999: END IF;
2000:
2001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2002: IF l_debug_level > 0 THEN
2003: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2004: END IF;
2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2002: IF l_debug_level > 0 THEN
2003: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2004: END IF;
2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2006:
2007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2008: IF l_debug_level > 0 THEN
2009: OE_DEBUG_PUB.Add('Raising Expected error',1);

Line 2007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2003: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2004: END IF;
2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2006:
2007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2008: IF l_debug_level > 0 THEN
2009: OE_DEBUG_PUB.Add('Raising Expected error',1);
2010: END IF;
2011: IF l_msg_data is not null THEN

Line 2019: RAISE FND_API.G_EXC_ERROR;

2015: IF l_debug_level > 0 THEN
2016: OE_DEBUG_PUB.Add(l_msg_data,1);
2017: END IF;
2018: END IF;
2019: RAISE FND_API.G_EXC_ERROR;
2020:
2021: END IF;
2022: IF l_debug_level > 0 THEN
2023: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||

Line 2026: x_return_status := FND_API.G_RET_STS_SUCCESS;

2022: IF l_debug_level > 0 THEN
2023: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||
2024: l_return_status ,1);
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:
2028: EXCEPTION
2029: WHEN FND_API.G_EXC_ERROR THEN
2030: IF l_debug_level > 0 THEN

Line 2029: WHEN FND_API.G_EXC_ERROR THEN

2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:
2028: EXCEPTION
2029: WHEN FND_API.G_EXC_ERROR THEN
2030: IF l_debug_level > 0 THEN
2031: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2032: END IF;
2033: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2033: x_return_status := FND_API.G_RET_STS_ERROR;

2029: WHEN FND_API.G_EXC_ERROR THEN
2030: IF l_debug_level > 0 THEN
2031: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2032: END IF;
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');

Line 2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2031: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2032: END IF;
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');
2038: END IF;
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');
2038: END IF;
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2040:
2041: WHEN OTHERS THEN
2042: IF l_debug_level > 0 THEN
2043: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation');

Line 2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2041: WHEN OTHERS THEN
2042: IF l_debug_level > 0 THEN
2043: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation');
2044: END IF;
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2046:
2047: END;
2048:
2049:

Line 2095: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2091: )IS
2092:
2093: l_stmt VARCHAR2(4000) :=NULL;
2094: l_line_rec OE_ORDER_PUB.line_rec_type;
2095: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2096: l_request_date_low DATE;
2097: l_request_date_high DATE;
2098: l_schedule_ship_date_low DATE;
2099: l_schedule_ship_date_high DATE;

Line 2596: l_return_status := FND_API.G_RET_STS_SUCCESS;

2592:
2593: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2594: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2595: l_Line_id||' *****');
2596: l_return_status := FND_API.G_RET_STS_SUCCESS;
2597:
2598: OE_LINE_UTIL.Lock_Row
2599: (p_line_id => l_Line_id,
2600: p_x_line_rec => l_line_rec,

Line 2603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2599: (p_line_id => l_Line_id,
2600: p_x_line_rec => l_line_rec,
2601: x_return_status => l_return_status);
2602:
2603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2604: IF l_debug_level > 0 THEN
2605: OE_DEBUG_PUB.Add('Lock row returned with error',1);
2606: END IF;
2607: END IF;

Line 2610: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2606: END IF;
2607: END IF;
2608:
2609: -- Updating the value of the Schedule Action Code
2610: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2611:
2612: l_line_rec.schedule_action_code := OESCH_ACT_RESERVE;
2613: IF l_debug_level > 0 THEN
2614: OE_DEBUG_PUB.Add('set mesg context line_id:'||l_line_rec.line_id);

Line 2639: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2635: ,p_use_reservation_time_fence => p_use_reservation_time_fence
2636: ,x_return_status => l_return_status
2637: );
2638:
2639: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2640: IF l_debug_level > 0 THEN
2641: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2642: Line id:'||l_line_rec.line_id,1);
2643: END IF;

Line 2645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2641: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2642: Line id:'||l_line_rec.line_id,1);
2643: END IF;
2644:
2645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2646: IF l_debug_level > 0 THEN
2647: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2648: Line id:'||l_line_rec.line_id,1);
2649: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2654: l_return_status := FND_API.G_RET_STS_SUCCESS;

2650: END IF;
2651:
2652: END IF;
2653: ELSE
2654: l_return_status := FND_API.G_RET_STS_SUCCESS;
2655: END IF;
2656:
2657: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2658:

Line 2657: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2653: ELSE
2654: l_return_status := FND_API.G_RET_STS_SUCCESS;
2655: END IF;
2656:
2657: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2658:
2659: /* Here we will call the Procedure for Reservation */
2660:
2661: IF p_reservation_mode IS NULL

Line 2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2666: ,x_return_status => l_return_status
2667: );
2668:
2669: -- 4287740 Start
2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2671: IF l_debug_level > 0 THEN
2672: OE_DEBUG_PUB.Add('Create Reservation returned with
2673: Expected error for Line id:' ||l_line_rec.line_id,1);
2674: END IF;

Line 2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2671: IF l_debug_level > 0 THEN
2672: OE_DEBUG_PUB.Add('Create Reservation returned with
2673: Expected error for Line id:' ||l_line_rec.line_id,1);
2674: END IF;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: IF l_debug_level > 0 THEN
2677: OE_DEBUG_PUB.Add('Create Reservation returned with
2678: Unexpected error for Line id:'||l_line_rec.line_id,1);
2679: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2715: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2711: END IF;
2712:
2713: --4287740 Commented the below code as it has been moved up
2714: /*
2715: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2716: IF l_debug_level > 0 THEN
2717: OE_DEBUG_PUB.Add('Create Reservation returned with
2718: Expected error for Line id:' ||l_line_rec.line_id,1);
2719: END IF;

Line 2720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2716: IF l_debug_level > 0 THEN
2717: OE_DEBUG_PUB.Add('Create Reservation returned with
2718: Expected error for Line id:' ||l_line_rec.line_id,1);
2719: END IF;
2720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2721: IF l_debug_level > 0 THEN
2722: OE_DEBUG_PUB.Add('Create Reservation returned with
2723: Unexpected error for Line id:'||l_line_rec.line_id,1);
2724: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2782: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2778: Validate_and_Reserve_for_Set
2779: (p_x_rsv_tbl => l_rsv_tbl
2780: ,p_reservation_set_id => l_set_id
2781: ,x_return_status => l_return_status);
2782: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2783: Update_Reservation_Set
2784: (p_reservation_set_id => l_set_id
2785: ,x_return_status => l_return_status);
2786: END IF;