APPS.OE_RESERVE_CONC dependencies on FND_API

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: THEN
147: OE_MSG_PUB.Add_Exc_Msg
148: ( G_PKG_NAME, 'Reservable_Quantity');
149: END IF;
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151:
152: END;
153: -- Getting reservable quantity
154: Query_Qty_Tree(p_ship_from_org_id => p_ship_from_org_id,

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: OE_MSG_PUB.Add_Exc_Msg
180: ( G_PKG_NAME,
181: 'Reservable_Quantity');
182: END IF;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184:
185: END Reservable_Quantity;
186: /*------------------------------------------------------
187: Procedure Name : Commit_Reservation

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

191: --------------------------------------------------------------------- */
192: PROCEDURE Commit_Reservation(p_request_id IN NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2)
194: IS
195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
196: l_msg_count NUMBER;
197: l_msg_data VARCHAR2(1000);
198: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
199: --

Line 209: ,p_init_msg_lst => FND_API.G_FALSE

205: oe_debug_pub.add( ' BEFORE CALLING DO_CHECK_FOR_COMMIT' , 1 ) ;
206: END IF;
207: INV_RESERVATION_PVT.Do_Check_For_Commit
208: (p_api_version_number => 1.0
209: ,p_init_msg_lst => FND_API.G_FALSE
210: ,x_return_status => l_return_status
211: ,x_msg_count => l_msg_count
212: ,x_msg_data => l_msg_data
213: ,x_failed_rsv_temp_tbl => l_failed_rsv_temp_tbl);

Line 219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( ' AFTER CALLING DO_CHECK_FOR_COMMIT:'||l_return_status , 1 ) ;
217: END IF;
218: -- Error Handling Start
219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR' , 1 ) ;
222: END IF;
223: OE_MSG_PUB.Transfer_Msg_Stack;

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: IF l_debug_level > 0 THEN
230: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
231: END IF;
232: END LOOP;
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234:
235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;

Line 235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

231: END IF;
232: END LOOP;
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234:
235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
238: END IF;
239: OE_MSG_PUB.Save_Messages(p_request_id => p_request_id);

Line 240: RAISE FND_API.G_EXC_ERROR;

236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
238: END IF;
239: OE_MSG_PUB.Save_Messages(p_request_id => p_request_id);
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: x_return_status := l_return_status;
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: x_return_status := l_return_status;
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: IF l_debug_level > 0 THEN
246: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
247: END IF;
248: x_return_status := FND_API.G_RET_STS_ERROR;

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: WHEN FND_API.G_EXC_ERROR THEN
245: IF l_debug_level > 0 THEN
246: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
247: END IF;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
252: END IF;

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: IF l_debug_level > 0 THEN
246: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);
247: END IF;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
252: END IF;
253: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
252: END IF;
253: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: WHEN OTHERS THEN
256: IF l_debug_level > 0 THEN
257: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',1 );
252: END IF;
253: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: WHEN OTHERS THEN
256: IF l_debug_level > 0 THEN
257: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
258: END IF;

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

255: WHEN OTHERS THEN
256: IF l_debug_level > 0 THEN
257: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
258: END IF;
259: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END Commit_Reservation;
262:
263: /*------------------------------------------------------

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: IF l_debug_level > 0 THEN
257: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);
258: END IF;
259: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END Commit_Reservation;
262:
263: /*------------------------------------------------------
264: Procedure Name : Validate_and_Reserve_for_Set

Line 400: ,p_partial_reservation => FND_API.G_FALSE

396: END IF;
397: END LOOP;
398: oe_debug_pub.add('Before calling Create Reservation: ' || l_rsv_tbl.count,1);
399: create_reservation(p_x_rsv_tbl => l_rsv_tbl
400: ,p_partial_reservation => FND_API.G_FALSE
401: ,x_return_status => l_return_status);
402: x_return_status := l_return_status;
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'EXITING VALIDATE_AND_RESERVE_FOR_SET: '||l_return_status , 1 ) ;

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'EXITING VALIDATE_AND_RESERVE_FOR_SET: '||l_return_status , 1 ) ;
405: END IF;
406: EXCEPTION
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
410: END IF;
411: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
410: END IF;
411: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: WHEN OTHERS THEN
414: IF l_debug_level > 0 THEN
415: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',1 );
410: END IF;
411: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: WHEN OTHERS THEN
414: IF l_debug_level > 0 THEN
415: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
416: END IF;

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

413: WHEN OTHERS THEN
414: IF l_debug_level > 0 THEN
415: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
416: END IF;
417: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END Validate_and_Reserve_for_Set;
420:
421: /*------------------------------------------------------

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: IF l_debug_level > 0 THEN
415: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);
416: END IF;
417: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END Validate_and_Reserve_for_Set;
420:
421: /*------------------------------------------------------
422: Procedure Name : Update_Reservation_Set

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: last_updated_by = FND_GLOBAL.USER_ID,
445: last_update_date = sysdate
446: WHERE reservation_set_id = p_reservation_set_id;
447: IF (SQL%NOTFOUND) THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: ELSE
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451: END IF;
452: IF l_debug_level > 0 THEN

Line 450: x_return_status := FND_API.G_RET_STS_SUCCESS;

446: WHERE reservation_set_id = p_reservation_set_id;
447: IF (SQL%NOTFOUND) THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: ELSE
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451: END IF;
452: IF l_debug_level > 0 THEN
453: oe_debug_pub.add( 'EXITING UPDATE_RESERVATION_SET ' , 1 ) ;
454: END IF;

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

457: WHEN OTHERS THEN
458: IF l_debug_level > 0 THEN
459: OE_DEBUG_PUB.Add('In others error...in Proc Update_Reservation_Set for rsv set tbl',1);
460: END IF;
461: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END Update_Reservation_Set;
464:
465:

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: IF l_debug_level > 0 THEN
459: OE_DEBUG_PUB.Add('In others error...in Proc Update_Reservation_Set for rsv set tbl',1);
460: END IF;
461: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END Update_Reservation_Set;
464:
465:
466: /*------------------------------------------------------

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'EXITING CREATE_RESERVATION_SET ' , 1 ) ;
613: END IF;
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: EXCEPTION
616: WHEN OTHERS THEN
617: IF l_debug_level > 0 THEN
618: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);

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

616: WHEN OTHERS THEN
617: IF l_debug_level > 0 THEN
618: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);
619: END IF;
620: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END Create_Reservation_Set;
623:
624: /*------------------------------------------------------

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: IF l_debug_level > 0 THEN
618: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);
619: END IF;
620: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END Create_Reservation_Set;
623:
624: /*------------------------------------------------------
625: Procedure Name : Calculate_Partial_Quantity

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837: oe_debug_pub.add( 'EXITING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;
838: END IF;
839:
840: EXCEPTION
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: IF l_debug_level > 0 THEN
843: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
844: END IF;
845: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: IF l_debug_level > 0 THEN
843: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
844: END IF;
845: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: WHEN OTHERS THEN
848: IF l_debug_level > 0 THEN
849: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: IF l_debug_level > 0 THEN
843: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );
844: END IF;
845: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: WHEN OTHERS THEN
848: IF l_debug_level > 0 THEN
849: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
850: END IF;

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

847: WHEN OTHERS THEN
848: IF l_debug_level > 0 THEN
849: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
850: END IF;
851: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END Calculate_Partial_Quantity;
854:
855: /*-------------------------------------------------------------------

Line 852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

848: IF l_debug_level > 0 THEN
849: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);
850: END IF;
851: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END Calculate_Partial_Quantity;
854:
855: /*-------------------------------------------------------------------
856: Procedure Name : Query_Qty_Tree

Line 925: , p_init_msg_lst => FND_API.G_TRUE

921:
922: --inv_quantity_tree_pvt.clear_quantity_cache;
923: inv_quantity_tree_pvt.mark_all_for_refresh
924: ( p_api_version_number => 1.0
925: , p_init_msg_lst => FND_API.G_TRUE
926: , x_return_status => l_return_status
927: , x_msg_count => l_msg_count
928: , x_msg_data => l_msg_data
929: );

Line 931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

927: , x_msg_count => l_msg_count
928: , x_msg_data => l_msg_data
929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: oe_msg_pub.transfer_msg_stack;
933: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
934: for I in 1..l_msg_count loop
935: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
938: END IF;
939: end loop;
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: oe_msg_pub.transfer_msg_stack;
943: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
944: for I in 1..l_msg_count loop

Line 941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

937: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
938: END IF;
939: end loop;
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: oe_msg_pub.transfer_msg_stack;
943: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
944: for I in 1..l_msg_count loop
945: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 950: RAISE FND_API.G_EXC_ERROR;

946: IF l_debug_level > 0 THEN
947: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
948: END IF;
949: end loop;
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952:
953:
954:

Line 1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1008: OE_MSG_PUB.Add_Exc_Msg
1009: ( G_PKG_NAME,
1010: 'Query_Qty_Tree');
1011: END IF;
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END Query_Qty_Tree;
1014: /*----------------------------------------------------------------
1015: PROCEDURE : Calculate_Percentage
1016: DESCRIPTION: This Procedure is to determine the percengae when program

Line 1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1060: OE_MSG_PUB.Add_Exc_Msg
1061: ( G_PKG_NAME,
1062: 'Calculate_Percentage');
1063: END IF;
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065:
1066: END;
1067: -- Getting the ordered quantity
1068: IF l_debug_level > 0 THEN

Line 1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1133: OE_MSG_PUB.Add_Exc_Msg
1134: ( G_PKG_NAME,
1135: 'Calculate_Percentage');
1136: END IF;
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138:
1139:
1140: END calculate_Percentage;
1141:

Line 1337: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1333: Reservation
1334: -----------------------------------------------------------------*/
1335: Procedure Create_Reservation
1336: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1337: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1339: IS
1340: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1341: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

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

1336: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1337: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1339: IS
1340: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1341: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1342: l_msg_count NUMBER;
1343: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1344: l_msg_data VARCHAR2(1000);

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

1407: END IF;
1408:
1409:
1410: l_reservation_rec := null;
1411: l_reservation_rec.reservation_id := fnd_api.g_miss_num; -- cannot know
1412: l_reservation_rec.requirement_date := p_x_rsv_tbl(I).schedule_ship_date;
1413: l_reservation_rec.organization_id := p_x_rsv_tbl(I).ship_from_org_id;
1414: l_reservation_rec.inventory_item_id := p_x_rsv_tbl(I).inventory_item_id;
1415:

Line 1498: --IF l_qty_return_status = FND_API.G_RET_STS_SUCCESS

1494: ELSE
1495: l_validated_quantity := l_reservation_rec.reservation_quantity;
1496: END IF;
1497:
1498: --IF l_qty_return_status = FND_API.G_RET_STS_SUCCESS
1499: IF l_validated_quantity > 0 THEN
1500: l_reservation_rec.reservation_quantity := l_validated_quantity;
1501:
1502: -- Partial reservation check

Line 1516: , p_init_msg_lst => FND_API.G_TRUE

1512: ||l_reservation_rec.reservation_quantity,1);
1513: END IF;
1514: INV_RESERVATION_PUB.Create_Reservation
1515: ( p_api_version_number => 1.0
1516: , p_init_msg_lst => FND_API.G_TRUE
1517: , x_return_status => l_return_status
1518: , x_msg_count => l_msg_count
1519: , x_msg_data => l_msg_data
1520: , p_rsv_rec => l_reservation_rec

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

1519: , x_msg_data => l_msg_data
1520: , p_rsv_rec => l_reservation_rec
1521: , p_serial_number => l_dummy_sn
1522: , x_serial_number => l_dummy_sn
1523: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1524: , p_force_reservation_flag => FND_API.G_FALSE
1525: , p_validation_flag => FND_API.G_TRUE
1526: , x_quantity_reserved => l_quantity_reserved
1527: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV

Line 1524: , p_force_reservation_flag => FND_API.G_FALSE

1520: , p_rsv_rec => l_reservation_rec
1521: , p_serial_number => l_dummy_sn
1522: , x_serial_number => l_dummy_sn
1523: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1524: , p_force_reservation_flag => FND_API.G_FALSE
1525: , p_validation_flag => FND_API.G_TRUE
1526: , x_quantity_reserved => l_quantity_reserved
1527: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1528: , x_reservation_id => l_rsv_id

Line 1525: , p_validation_flag => FND_API.G_TRUE

1521: , p_serial_number => l_dummy_sn
1522: , x_serial_number => l_dummy_sn
1523: , p_partial_reservation_flag => l_partial_reservation_flag --FND_API.G_TRUE
1524: , p_force_reservation_flag => FND_API.G_FALSE
1525: , p_validation_flag => FND_API.G_TRUE
1526: , x_quantity_reserved => l_quantity_reserved
1527: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1528: , x_reservation_id => l_rsv_id
1529: , p_partial_rsv_exists => l_rsv_exists

Line 1535: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1531: IF l_debug_level > 0 THEN
1532: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' || l_return_status ||' '||l_quantity_reserved,1);
1533: END IF;
1534: -- Pack J
1535: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1536: l_commit_count := l_commit_count + 1;
1537:
1538: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: IF l_debug_level > 0 THEN

Line 1538: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1534: -- Pack J
1535: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1536: l_commit_count := l_commit_count + 1;
1537:
1538: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: IF l_debug_level > 0 THEN
1540: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1541: END IF;
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: IF l_debug_level > 0 THEN
1540: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1541: END IF;
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543:
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: IF l_debug_level > 0 THEN
1546: OE_DEBUG_PUB.Add('Raising Expected error',1);

Line 1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1540: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
1541: END IF;
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543:
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: IF l_debug_level > 0 THEN
1546: OE_DEBUG_PUB.Add('Raising Expected error',1);
1547: END IF;
1548: IF l_msg_data is not null THEN

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

1552: IF l_debug_level > 0 THEN
1553: OE_DEBUG_PUB.Add(l_msg_data,1);
1554: END IF;
1555: END IF;
1556: --RAISE FND_API.G_EXC_ERROR; -- Commented as we don't need to fail the program for excepted error.
1557:
1558: END IF;
1559: END IF;
1560: -- Pack J

Line 1592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1588: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
1589:
1590: COMMIT;
1591: -- For Expected errors we will consider status as success.
1592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1593: l_return_status := FND_API.G_RET_STS_SUCCESS;
1594: END IF;
1595: x_return_status := l_return_status;
1596: IF l_debug_level > 0 THEN

Line 1593: l_return_status := FND_API.G_RET_STS_SUCCESS;

1589:
1590: COMMIT;
1591: -- For Expected errors we will consider status as success.
1592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1593: l_return_status := FND_API.G_RET_STS_SUCCESS;
1594: END IF;
1595: x_return_status := l_return_status;
1596: IF l_debug_level > 0 THEN
1597: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);

Line 1601: WHEN FND_API.G_EXC_ERROR THEN

1597: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);
1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF l_debug_level > 0 THEN
1603: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1605: x_return_status := FND_API.G_RET_STS_ERROR;

1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF l_debug_level > 0 THEN
1603: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608: IF l_debug_level > 0 THEN
1609: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );

Line 1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1603: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608: IF l_debug_level > 0 THEN
1609: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );
1610: END IF;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608: IF l_debug_level > 0 THEN
1609: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );
1610: END IF;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612:
1613: WHEN OTHERS THEN
1614: IF l_debug_level > 0 THEN
1615: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation for rsv tbl',1);

Line 1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1613: WHEN OTHERS THEN
1614: IF l_debug_level > 0 THEN
1615: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation for rsv tbl',1);
1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618:
1619: END create_reservation;
1620:
1621: /*----------------------------------------------------------------

Line 1693: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1689:
1690:
1691: create_reservation(p_x_rsv_tbl => p_rsv_tbl
1692: ,x_return_status => l_return_status);
1693: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1694: AND p_reserve_set_name IS NOT NULL THEN -- Pack J
1695: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
1696: Create_Reservation_Set(p_rsv_tbl => p_rsv_tbl,
1697: p_reserve_set_name => p_reserve_set_name,

Line 1703: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1699: x_return_status => l_return_status);
1700:
1701: END IF;
1702:
1703: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: IF l_debug_level > 0 THEN
1705: OE_DEBUG_PUB.Add('Create Reservation returned with Expected error for rsv tbl ',1);
1706: END IF;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1703: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: IF l_debug_level > 0 THEN
1705: OE_DEBUG_PUB.Add('Create Reservation returned with Expected error for rsv tbl ',1);
1706: END IF;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: IF l_debug_level > 0 THEN
1709: OE_DEBUG_PUB.Add('Create Reservation returned with Unexpected error for rsv tbl',1);
1710: END IF;
1711: END IF;

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

1741: p_use_reservation_time_fence IN VARCHAR2,
1742: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1743: )
1744: IS
1745: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1746: l_result Varchar2(30);
1747: l_scheduling_level_code VARCHAR2(30) := NULL;
1748: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1749: l_type_code VARCHAR2(30);

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

1744: IS
1745: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1746: l_result Varchar2(30);
1747: l_scheduling_level_code VARCHAR2(30) := NULL;
1748: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1749: l_type_code VARCHAR2(30);
1750: l_org_id NUMBER;
1751: l_time_fence BOOLEAN;
1752: l_msg_count NUMBER;

Line 1770: l_return_status := FND_API.G_RET_STS_ERROR;

1766: IF ( p_line_rec.open_flag = 'N' ) THEN
1767: IF l_debug_level > 0 THEN
1768: OE_DEBUG_PUB.Add('Line is closed, not eligible for reservation', 1);
1769: END IF;
1770: l_return_status := FND_API.G_RET_STS_ERROR;
1771:
1772: /* Check if line is shipped, if shipped then ignore the line */
1773: ELSIF ( nvl(p_line_rec.shipped_quantity, -99) > 0 ) THEN
1774: IF l_debug_level > 0 THEN

Line 1777: l_return_status := FND_API.G_RET_STS_ERROR;

1773: ELSIF ( nvl(p_line_rec.shipped_quantity, -99) > 0 ) THEN
1774: IF l_debug_level > 0 THEN
1775: OE_DEBUG_PUB.Add('Line is shipped, not eligible for reservation', 1);
1776: END IF;
1777: l_return_status := FND_API.G_RET_STS_ERROR;
1778: --Added for bug 6873122
1779: ELSIF ( nvl(p_line_rec.fulfilled_quantity, -99) > 0 ) THEN
1780: IF l_debug_level > 0 THEN
1781: OE_DEBUG_PUB.Add('Line is Fulfilled, not eligible for reservation', 1);

Line 1783: l_return_status := FND_API.G_RET_STS_ERROR;

1779: ELSIF ( nvl(p_line_rec.fulfilled_quantity, -99) > 0 ) THEN
1780: IF l_debug_level > 0 THEN
1781: OE_DEBUG_PUB.Add('Line is Fulfilled, not eligible for reservation', 1);
1782: END IF;
1783: l_return_status := FND_API.G_RET_STS_ERROR;
1784: --Added for bug 6873122
1785: END IF;
1786:
1787: IF l_return_status = FND_API.G_RET_STS_SUCCESS

Line 1787: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1783: l_return_status := FND_API.G_RET_STS_ERROR;
1784: --Added for bug 6873122
1785: END IF;
1786:
1787: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1788: AND NVL(g_reservation_mode,'*') <> 'PARTIAL' THEN -- Pack J
1789: /* We need to check for Existing Reservations on the Line */
1790: BEGIN
1791: IF l_debug_level > 0 THEN

Line 1804: RAISE FND_API.G_EXC_ERROR;

1800: IF l_debug_level > 0 THEN
1801: OE_DEBUG_PUB.Add('Reservations exists on the line',3);
1802: END IF;
1803:
1804: RAISE FND_API.G_EXC_ERROR;
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: IF l_debug_level > 0 THEN
1808: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);

Line 1806: WHEN FND_API.G_EXC_ERROR THEN

1802: END IF;
1803:
1804: RAISE FND_API.G_EXC_ERROR;
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: IF l_debug_level > 0 THEN
1808: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);
1809: END IF;
1810: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1810: l_return_status := FND_API.G_RET_STS_ERROR;

1806: WHEN FND_API.G_EXC_ERROR THEN
1807: IF l_debug_level > 0 THEN
1808: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);
1809: END IF;
1810: l_return_status := FND_API.G_RET_STS_ERROR;
1811:
1812: WHEN NO_DATA_FOUND THEN
1813: NULL;
1814: WHEN TOO_MANY_ROWS THEN

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

1812: WHEN NO_DATA_FOUND THEN
1813: NULL;
1814: WHEN TOO_MANY_ROWS THEN
1815: -- NULL;
1816: l_return_status := FND_API.G_RET_STS_ERROR; --2929716
1817: END;
1818: END IF;
1819: -- 3250889 Starts
1820: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1820: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1816: l_return_status := FND_API.G_RET_STS_ERROR; --2929716
1817: END;
1818: END IF;
1819: -- 3250889 Starts
1820: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1821: BEGIN
1822: IF l_debug_level > 0 THEN
1823: OE_DEBUG_PUB.Add('Before checking for Staged/Closed deliveries', 1);
1824: END IF;

Line 1837: RAISE FND_API.G_EXC_ERROR;

1833: IF l_debug_level > 0 THEN
1834: OE_DEBUG_PUB.Add('Staged/Closed deliveries exist for the line', 3);
1835: END IF;
1836:
1837: RAISE FND_API.G_EXC_ERROR;
1838:
1839: EXCEPTION
1840: WHEN FND_API.G_EXC_ERROR THEN
1841: IF l_debug_level > 0 THEN

Line 1840: WHEN FND_API.G_EXC_ERROR THEN

1836:
1837: RAISE FND_API.G_EXC_ERROR;
1838:
1839: EXCEPTION
1840: WHEN FND_API.G_EXC_ERROR THEN
1841: IF l_debug_level > 0 THEN
1842: OE_DEBUG_PUB.Add('In Expected Error for Checking Staged/Closed deliveries', 3);
1843: END IF;
1844: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1844: l_return_status := FND_API.G_RET_STS_ERROR;

1840: WHEN FND_API.G_EXC_ERROR THEN
1841: IF l_debug_level > 0 THEN
1842: OE_DEBUG_PUB.Add('In Expected Error for Checking Staged/Closed deliveries', 3);
1843: END IF;
1844: l_return_status := FND_API.G_RET_STS_ERROR;
1845: WHEN NO_DATA_FOUND THEN
1846: NULL;
1847: WHEN TOO_MANY_ROWS THEN
1848: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1848: l_return_status := FND_API.G_RET_STS_ERROR;

1844: l_return_status := FND_API.G_RET_STS_ERROR;
1845: WHEN NO_DATA_FOUND THEN
1846: NULL;
1847: WHEN TOO_MANY_ROWS THEN
1848: l_return_status := FND_API.G_RET_STS_ERROR;
1849: END;
1850: END IF;
1851: -- 3250889 Ends
1852: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1852: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1848: l_return_status := FND_API.G_RET_STS_ERROR;
1849: END;
1850: END IF;
1851: -- 3250889 Ends
1852: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1853:
1854: -- WE NEED TO CHECK FOR THE reservation_time_fence Value.
1855: -- If the Value of the parameter passed to the concurrent
1856: -- program is "NO' then we reserve the lines irrespective

Line 1876: RAISE FND_API.G_EXC_ERROR ;

1872: IF l_debug_level > 0 THEN
1873: OE_DEBUG_PUB.Add('The Schedule Date for Line falls
1874: beyond reservation Time Fence',3);
1875: END IF;
1876: RAISE FND_API.G_EXC_ERROR ;
1877:
1878: END IF;
1879: ELSE */
1880: -- 4689197

Line 1887: RAISE FND_API.G_EXC_ERROR ;

1883: IF l_debug_level > 0 THEN
1884: OE_DEBUG_PUB.Add('The Schedule Date for Line falls
1885: beyond reservation Time Fence',3);
1886: END IF;
1887: RAISE FND_API.G_EXC_ERROR ;
1888:
1889: END IF;
1890: END IF;
1891: -- END IF;

Line 1929: RAISE FND_API.G_EXC_ERROR;

1925: THEN
1926: IF l_debug_level > 0 THEN
1927: OE_DEBUG_PUB.Add('Order Type Does not Allow Scheduling',3);
1928: END IF;
1929: RAISE FND_API.G_EXC_ERROR;
1930: END IF;
1931: END IF;
1932:
1933: END IF; -- Check for Reservation Exists Clause

Line 1941: WHEN FND_API.G_EXC_ERROR THEN

1937: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||
1938: l_return_status ,1);
1939: END IF;
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1944: END IF;
1945: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1945: x_return_status := FND_API.G_RET_STS_ERROR;

1941: WHEN FND_API.G_EXC_ERROR THEN
1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1944: END IF;
1945: x_return_status := FND_API.G_RET_STS_ERROR;
1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: IF l_debug_level > 0 THEN
1949: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);

Line 1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1943: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);
1944: END IF;
1945: x_return_status := FND_API.G_RET_STS_ERROR;
1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: IF l_debug_level > 0 THEN
1949: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);
1950: END IF;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: IF l_debug_level > 0 THEN
1949: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);
1950: END IF;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952:
1953: WHEN OTHERS THEN
1954:
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952:
1953: WHEN OTHERS THEN
1954:
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956:
1957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1958: THEN
1959: OE_MSG_PUB.Add_Exc_Msg

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

1973: Procedure Create_Reservation
1974: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1975: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1976: IS
1977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1978: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1979: l_msg_count NUMBER;
1980: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1981: l_msg_data VARCHAR2(1000);

Line 2033: , p_init_msg_lst => FND_API.G_TRUE

2029: END IF;
2030:
2031: INV_RESERVATION_PUB.Create_Reservation
2032: ( p_api_version_number => 1.0
2033: , p_init_msg_lst => FND_API.G_TRUE
2034: , x_return_status => l_return_status
2035: , x_msg_count => l_msg_count
2036: , x_msg_data => l_msg_data
2037: , p_rsv_rec => l_reservation_rec

Line 2040: , p_partial_reservation_flag => FND_API.G_FALSE

2036: , x_msg_data => l_msg_data
2037: , p_rsv_rec => l_reservation_rec
2038: , p_serial_number => l_dummy_sn
2039: , x_serial_number => l_dummy_sn
2040: , p_partial_reservation_flag => FND_API.G_FALSE
2041: , p_force_reservation_flag => FND_API.G_FALSE
2042: , p_validation_flag => FND_API.G_TRUE
2043: , x_quantity_reserved => l_quantity_reserved
2044: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV

Line 2041: , p_force_reservation_flag => FND_API.G_FALSE

2037: , p_rsv_rec => l_reservation_rec
2038: , p_serial_number => l_dummy_sn
2039: , x_serial_number => l_dummy_sn
2040: , p_partial_reservation_flag => FND_API.G_FALSE
2041: , p_force_reservation_flag => FND_API.G_FALSE
2042: , p_validation_flag => FND_API.G_TRUE
2043: , x_quantity_reserved => l_quantity_reserved
2044: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
2045: , x_reservation_id => l_rsv_id

Line 2042: , p_validation_flag => FND_API.G_TRUE

2038: , p_serial_number => l_dummy_sn
2039: , x_serial_number => l_dummy_sn
2040: , p_partial_reservation_flag => FND_API.G_FALSE
2041: , p_force_reservation_flag => FND_API.G_FALSE
2042: , p_validation_flag => FND_API.G_TRUE
2043: , x_quantity_reserved => l_quantity_reserved
2044: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
2045: , x_reservation_id => l_rsv_id
2046: );

Line 2053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2049: l_return_status,1);
2050: OE_DEBUG_PUB.Add(l_msg_data,1);
2051: END IF;
2052:
2053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: IF l_debug_level > 0 THEN
2055: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2056: END IF;
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: IF l_debug_level > 0 THEN
2055: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2056: END IF;
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058:
2059: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: IF l_debug_level > 0 THEN
2061: OE_DEBUG_PUB.Add('Raising Expected error',1);

Line 2059: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2055: OE_DEBUG_PUB.Add('Raising Unexpected error',1);
2056: END IF;
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058:
2059: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: IF l_debug_level > 0 THEN
2061: OE_DEBUG_PUB.Add('Raising Expected error',1);
2062: END IF;
2063: IF l_msg_data is not null THEN

Line 2071: RAISE FND_API.G_EXC_ERROR;

2067: IF l_debug_level > 0 THEN
2068: OE_DEBUG_PUB.Add(l_msg_data,1);
2069: END IF;
2070: END IF;
2071: RAISE FND_API.G_EXC_ERROR;
2072:
2073: END IF;
2074: IF l_debug_level > 0 THEN
2075: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||

Line 2078: x_return_status := FND_API.G_RET_STS_SUCCESS;

2074: IF l_debug_level > 0 THEN
2075: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||
2076: l_return_status ,1);
2077: END IF;
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF l_debug_level > 0 THEN

Line 2081: WHEN FND_API.G_EXC_ERROR THEN

2077: END IF;
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF l_debug_level > 0 THEN
2083: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2084: END IF;
2085: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2085: x_return_status := FND_API.G_RET_STS_ERROR;

2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF l_debug_level > 0 THEN
2083: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2084: END IF;
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086:
2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2088: IF l_debug_level > 0 THEN
2089: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');

Line 2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2083: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);
2084: END IF;
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086:
2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2088: IF l_debug_level > 0 THEN
2089: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');
2090: END IF;
2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2088: IF l_debug_level > 0 THEN
2089: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');
2090: END IF;
2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2092:
2093: WHEN OTHERS THEN
2094: IF l_debug_level > 0 THEN
2095: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation');

Line 2097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2093: WHEN OTHERS THEN
2094: IF l_debug_level > 0 THEN
2095: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation');
2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2098:
2099: END;
2100:
2101:

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

2143: )IS
2144:
2145: l_stmt VARCHAR2(4000) :=NULL;
2146: l_line_rec OE_ORDER_PUB.line_rec_type;
2147: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2148: l_request_date_low DATE;
2149: l_request_date_high DATE;
2150: l_schedule_ship_date_low DATE;
2151: l_schedule_ship_date_high DATE;

Line 2662: l_return_status := FND_API.G_RET_STS_SUCCESS;

2658:
2659: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2660: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2661: l_Line_id||' *****');
2662: l_return_status := FND_API.G_RET_STS_SUCCESS;
2663:
2664: OE_LINE_UTIL.Lock_Row
2665: (p_line_id => l_Line_id,
2666: p_x_line_rec => l_line_rec,

Line 2669: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2665: (p_line_id => l_Line_id,
2666: p_x_line_rec => l_line_rec,
2667: x_return_status => l_return_status);
2668:
2669: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2670: IF l_debug_level > 0 THEN
2671: OE_DEBUG_PUB.Add('Lock row returned with error',1);
2672: END IF;
2673: END IF;

Line 2676: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2672: END IF;
2673: END IF;
2674:
2675: -- Updating the value of the Schedule Action Code
2676: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2677:
2678: l_line_rec.schedule_action_code := OESCH_ACT_RESERVE;
2679: IF l_debug_level > 0 THEN
2680: OE_DEBUG_PUB.Add('set mesg context line_id:'||l_line_rec.line_id);

Line 2705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2701: ,p_use_reservation_time_fence => p_use_reservation_time_fence
2702: ,x_return_status => l_return_status
2703: );
2704:
2705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2706: IF l_debug_level > 0 THEN
2707: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2708: Line id:'||l_line_rec.line_id,1);
2709: END IF;

Line 2711: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2707: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2708: Line id:'||l_line_rec.line_id,1);
2709: END IF;
2710:
2711: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2712: IF l_debug_level > 0 THEN
2713: OE_DEBUG_PUB.Add('Require Reservation returned with error for
2714: Line id:'||l_line_rec.line_id,1);
2715: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2720: l_return_status := FND_API.G_RET_STS_SUCCESS;

2716: END IF;
2717:
2718: END IF;
2719: ELSE
2720: l_return_status := FND_API.G_RET_STS_SUCCESS;
2721: END IF;
2722:
2723: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2724:

Line 2723: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2719: ELSE
2720: l_return_status := FND_API.G_RET_STS_SUCCESS;
2721: END IF;
2722:
2723: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2724:
2725: /* Here we will call the Procedure for Reservation */
2726:
2727: IF p_reservation_mode IS NULL

Line 2736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2732: ,x_return_status => l_return_status
2733: );
2734:
2735: -- 4287740 Start
2736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2737: IF l_debug_level > 0 THEN
2738: OE_DEBUG_PUB.Add('Create Reservation returned with
2739: Expected error for Line id:' ||l_line_rec.line_id,1);
2740: END IF;

Line 2741: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2737: IF l_debug_level > 0 THEN
2738: OE_DEBUG_PUB.Add('Create Reservation returned with
2739: Expected error for Line id:' ||l_line_rec.line_id,1);
2740: END IF;
2741: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2742: IF l_debug_level > 0 THEN
2743: OE_DEBUG_PUB.Add('Create Reservation returned with
2744: Unexpected error for Line id:'||l_line_rec.line_id,1);
2745: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2786: END IF;
2787:
2788: --4287740 Commented the below code as it has been moved up
2789: /*
2790: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2791: IF l_debug_level > 0 THEN
2792: OE_DEBUG_PUB.Add('Create Reservation returned with
2793: Expected error for Line id:' ||l_line_rec.line_id,1);
2794: END IF;

Line 2795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2791: IF l_debug_level > 0 THEN
2792: OE_DEBUG_PUB.Add('Create Reservation returned with
2793: Expected error for Line id:' ||l_line_rec.line_id,1);
2794: END IF;
2795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2796: IF l_debug_level > 0 THEN
2797: OE_DEBUG_PUB.Add('Create Reservation returned with
2798: Unexpected error for Line id:'||l_line_rec.line_id,1);
2799: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

Line 2855: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2851: Validate_and_Reserve_for_Set
2852: (p_x_rsv_tbl => l_rsv_tbl
2853: ,p_reservation_set_id => l_set_id
2854: ,x_return_status => l_return_status);
2855: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2856: Update_Reservation_Set
2857: (p_reservation_set_id => l_set_id
2858: ,x_return_status => l_return_status);
2859: END IF;