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_RESERVE_CONC dependencies on OE_DEBUG_PUB

Line 50: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

46: l_total_supply2 NUMBER :=0;
47: l_on_hand_qty2 NUMBER;
48:
49: --
50: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
51: --
52: BEGIN
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( ' ENTERING RESERVABLE_QUANTITY' , 1 ) ;

Line 54: oe_debug_pub.add( ' ENTERING RESERVABLE_QUANTITY' , 1 ) ;

50: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
51: --
52: BEGIN
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( ' ENTERING RESERVABLE_QUANTITY' , 1 ) ;
55: END IF;
56: -- Getting the Primary UOM of the item
57: BEGIN
58: SELECT primary_uom_code

Line 67: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

63: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
64: EXCEPTION
65: WHEN OTHERS THEN
66: IF l_debug_level > 0 THEN
67: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);
68: END IF;
69: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
70: THEN
71: OE_MSG_PUB.Add_Exc_Msg

Line 96: oe_debug_pub.add( ' EXITING RESERVABLE_QUANTITY' , 1 ) ;

92: l_total_supply2 := l_total_supply2 - g_total_consumed2;
93: x_available_qty2 := l_total_supply2;
94:
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( ' EXITING RESERVABLE_QUANTITY' , 1 ) ;
97: END IF;
98: EXCEPTION
99: WHEN OTHERS THEN
100:

Line 124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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: --
124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
125: --
126:
127: BEGIN
128: IF l_debug_level > 0 THEN

Line 129: oe_debug_pub.add( ' BEFORE CALLING DO_CHECK_FOR_COMMIT' , 1 ) ;

125: --
126:
127: BEGIN
128: IF l_debug_level > 0 THEN
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

Line 140: oe_debug_pub.add( ' AFTER CALLING DO_CHECK_FOR_COMMIT:'||l_return_status , 1 ) ;

136: ,x_msg_data => l_msg_data
137: ,x_failed_rsv_temp_tbl => l_failed_rsv_temp_tbl);
138:
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

Line 145: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR' , 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;
148: l_msg_count := OE_MSG_PUB.COUNT_MSG;
149:

Line 154: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

150: FOR I IN 1..l_msg_count LOOP
151: l_msg_data := OE_MSG_PUB.Get(I,'F');
152:
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:

Line 161: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;

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);
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;

Line 170: OE_DEBUG_PUB.Add('In Expected Error...in Proc Commit_Reservation for rsv_tbl',1);

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;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: IF l_debug_level > 0 THEN

Line 175: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Commit_Reservation ',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;
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: WHEN OTHERS THEN

Line 181: OE_DEBUG_PUB.Add('In others error...in Proc Commit_Reservation ',1);

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;
183: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END Commit_Reservation;

Line 229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

225: l_line_reserve_qty2 NUMBER :=0; -- INVCONV
226: l_sales_order_id NUMBER;
227: l_count_header NUMBER :=0;
228: --
229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
230: --
231: BEGIN
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'ENTERING VALIDATE_AND_RESERVE_FOR_SET ' , 1 ) ;

Line 233: oe_debug_pub.add( 'ENTERING VALIDATE_AND_RESERVE_FOR_SET ' , 1 ) ;

229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
230: --
231: BEGIN
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'ENTERING VALIDATE_AND_RESERVE_FOR_SET ' , 1 ) ;
234: END IF;
235:
236: FOR I IN 1..p_x_rsv_tbl.COUNT
237: LOOP

Line 322: oe_debug_pub.add('Before calling Create Reservation: ' || l_rsv_tbl.count,1);

318: END IF;
319: END IF;
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;

Line 328: oe_debug_pub.add( 'EXITING VALIDATE_AND_RESERVE_FOR_SET: '||l_return_status , 1 ) ;

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 ) ;
329: END IF;
330: EXCEPTION
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: IF l_debug_level > 0 THEN

Line 333: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Validate_and_Reserve_for_Set ',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;
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: WHEN OTHERS THEN

Line 339: OE_DEBUG_PUB.Add('In others error...in Proc Validate_and_Reserve_for_Set ',1);

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;
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;

Line 355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

351: x_return_status OUT NOCOPY VARCHAR2)
352: IS
353: l_request_id NUMBER;
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: BEGIN
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( 'ENTERING UPDATE_RESERVATION_SET ' , 1 ) ;

Line 359: oe_debug_pub.add( 'ENTERING UPDATE_RESERVATION_SET ' , 1 ) ;

355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: BEGIN
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( 'ENTERING UPDATE_RESERVATION_SET ' , 1 ) ;
360: END IF;
361:
362: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
363: UPDATE oe_reservation_sets

Line 377: oe_debug_pub.add( 'EXITING UPDATE_RESERVATION_SET ' , 1 ) ;

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;
379:
380: EXCEPTION
381: WHEN OTHERS THEN

Line 383: OE_DEBUG_PUB.Add('In others error...in Proc Update_Reservation_Set for rsv set tbl',1);

379:
380: EXCEPTION
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;

Line 406: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

402: l_delete_set_id NUMBER;
403: l_process_flag VARCHAR2(1) :='N';
404: l_line_count NUMBER :=0;
405: --
406: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
407: --
408: BEGIN
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'ENTERING CREATE_RESERVATION_SET ' , 1 ) ;

Line 410: oe_debug_pub.add( 'ENTERING CREATE_RESERVATION_SET ' , 1 ) ;

406: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
407: --
408: BEGIN
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'ENTERING CREATE_RESERVATION_SET ' , 1 ) ;
411: END IF;
412:
413: IF g_set_id IS NULL THEN
414: g_program_application_id := Fnd_global.PROG_APPL_ID;

Line 442: oe_debug_pub.add( 'Reservation_Set_Id: '||g_set_id , 1 ) ;

438: IF p_rsv_request_id IS NOT NULL THEN
439: l_process_flag := 'Y';
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'Reservation_Set_Id: '||g_set_id , 1 ) ;
443: END IF;
444: -- Insert Header information
445: Insert Into oe_reservation_sets
446: (Reservation_Set_Id

Line 536: oe_debug_pub.add( 'EXITING CREATE_RESERVATION_SET ' , 1 ) ;

532:
533: END LOOP;
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

Line 542: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation_Set ',1);

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);
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;

Line 573: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

569: l_total_conv_supply NUMBER:=0;
570: l_total_conv_supply2 NUMBER:=0; -- INVCONV
571: l_temp NUMBER:=0;
572: --
573: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
574: --
575: BEGIN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add( 'ENTERING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;

Line 577: oe_debug_pub.add( 'ENTERING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;

573: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
574: --
575: BEGIN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add( 'ENTERING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;
578: END IF;
579: Reservable_Quantity(p_inventory_item_id => p_x_rsv_tbl(1).inventory_item_id,
580: p_ship_from_org_id => p_x_rsv_tbl(1).ship_from_org_id,
581: p_subinventory => p_x_rsv_tbl(1).subinventory,

Line 596: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;

592: l_temp :=0;
593: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)
594: THEN
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
597: END IF;
598: l_total_conv_supply :=
599: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
600: precision => 5,

Line 619: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;

615: );
616:
617: --l_primary_uom := p_x_rsv_tbl(I).ordered_qty_uom;
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;
620: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;
621: END IF;
622: ELSE
623: l_total_conv_supply := l_total_supply;

Line 620: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;

616:
617: --l_primary_uom := p_x_rsv_tbl(I).ordered_qty_uom;
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;
620: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 ) ;
621: END IF;
622: ELSE
623: l_total_conv_supply := l_total_supply;
624: l_total_conv_supply2 := l_total_supply2;

Line 716: oe_debug_pub.add( 'Derived Reserved Qty: '||p_x_rsv_tbl(I).derived_reserved_qty , 1 ) ;

712: := p_x_rsv_tbl(I).ordered_qty - NVL(l_reserved_quantity,0);
713: p_x_rsv_tbl(I).derived_reserved_qty2 -- INVCONV
714: := p_x_rsv_tbl(I).ordered_qty2 - NVL(l_reserved_quantity2,0);
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'Derived Reserved Qty: '||p_x_rsv_tbl(I).derived_reserved_qty , 1 ) ;
717: END IF;
718: -- Partial Reservation
719: -- Reservation exists for the line. Set the flag
720: IF l_reserved_quantity > 0 THEN

Line 790: oe_debug_pub.add( 'EXITING CALCULATE_PARTIAL_QUANTITY ' , 1 ) ;

786: p_x_rsv_tbl(I).corrected_reserved_qty := p_x_rsv_tbl(I).derived_reserved_qty;
787: p_x_rsv_tbl(I).corrected_reserved_qty2 := p_x_rsv_tbl(I).derived_reserved_qty2;
788: END LOOP;
789: IF l_debug_level > 0 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

Line 796: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Calculate_Partial_Quantity ',1 );

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;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: WHEN OTHERS THEN

Line 802: OE_DEBUG_PUB.Add('In others error...in Proc Calculate_Partial_Quantity ',1);

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;
804: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END Calculate_Partial_Quantity;

Line 827: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

823: )
824:
825: IS
826: --
827: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
828: --
829: l_return_status VARCHAR2(1);
830: l_msg_count NUMBER;
831: l_msg_data VARCHAR2(2000);

Line 853: oe_debug_pub.add( 'ENTERING QUERY_QTY_TREE ' , 1 ) ;

849:
850: BEGIN
851:
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add( 'ENTERING QUERY_QTY_TREE ' , 1 ) ;
854: END IF;
855:
856: BEGIN
857:

Line 890: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

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');
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

Line 900: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

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');
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;

Line 940: oe_debug_pub.add( 'AFTER CALLING QUERY_QUANTITIES' , 1 ) ;

936: , x_satr => l_satr -- INVCONV
937: );
938:
939: IF l_debug_level > 0 THEN
940: oe_debug_pub.add( 'AFTER CALLING QUERY_QUANTITIES' , 1 ) ;
941: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH , 1 ) ;
942: oe_debug_pub.add( 'RR: L_QOH ' || L_ATR , 1 ) ;
943: END IF;
944: x_on_hand_qty := l_qoh;

Line 941: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH , 1 ) ;

937: );
938:
939: IF l_debug_level > 0 THEN
940: oe_debug_pub.add( 'AFTER CALLING QUERY_QUANTITIES' , 1 ) ;
941: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH , 1 ) ;
942: oe_debug_pub.add( 'RR: L_QOH ' || L_ATR , 1 ) ;
943: END IF;
944: x_on_hand_qty := l_qoh;
945: x_avail_to_reserve := l_atr;

Line 942: oe_debug_pub.add( 'RR: L_QOH ' || L_ATR , 1 ) ;

938:
939: IF l_debug_level > 0 THEN
940: oe_debug_pub.add( 'AFTER CALLING QUERY_QUANTITIES' , 1 ) ;
941: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH , 1 ) ;
942: oe_debug_pub.add( 'RR: L_QOH ' || L_ATR , 1 ) ;
943: END IF;
944: x_on_hand_qty := l_qoh;
945: x_avail_to_reserve := l_atr;
946: x_on_hand_qty2 := l_sqoh; -- INVCONV

Line 954: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;

950: x_on_hand_qty);
951: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||
952: x_avail_to_reserve);
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;
955: END IF;
956:
957: EXCEPTION
958:

Line 994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

990: l_avail_to_reserve2 NUMBER; -- INVCONV
991:
992:
993: --
994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
995: --
996: BEGIN
997: IF l_debug_level > 0 THEN
998: OE_DEBUG_PUB.Add('Inside Calculate Percentage Procedure',1);

Line 998: OE_DEBUG_PUB.Add('Inside Calculate Percentage Procedure',1);

994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
995: --
996: BEGIN
997: IF l_debug_level > 0 THEN
998: OE_DEBUG_PUB.Add('Inside Calculate Percentage Procedure',1);
999: END IF;
1000: -- Getting the Primary UOM of the item
1001: BEGIN
1002: SELECT primary_uom_code

Line 1011: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

1007: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: IF l_debug_level > 0 THEN
1011: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);
1012: END IF;
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg

Line 1024: OE_DEBUG_PUB.Add('Calculate Percentage Table Count '||p_rsv_tbl.COUNT,1);

1020:
1021: END;
1022: -- Getting the ordered quantity
1023: IF l_debug_level > 0 THEN
1024: OE_DEBUG_PUB.Add('Calculate Percentage Table Count '||p_rsv_tbl.COUNT,1);
1025: END IF;
1026: FOR I IN 1..p_rsv_tbl.COUNT
1027: LOOP
1028:

Line 1047: OE_DEBUG_PUB.Add('Calculate Percentage Total demand '||l_total_demand,1);

1043:
1044: END IF;
1045: END LOOP;
1046: IF l_debug_level > 0 THEN
1047: OE_DEBUG_PUB.Add('Calculate Percentage Total demand '||l_total_demand,1);
1048: END IF;
1049: -- Getting reservable quantity
1050: IF l_total_demand > 0
1051: THEN

Line 1064: OE_DEBUG_PUB.Add('Calculate Percentage Total Supply '||l_total_Supply,1);

1060:
1061: END IF;
1062: l_total_supply := l_total_supply - g_total_consumed;
1063: IF l_debug_level > 0 THEN
1064: OE_DEBUG_PUB.Add('Calculate Percentage Total Supply '||l_total_Supply,1);
1065: END IF;
1066: -- Percent calculation
1067: IF (l_total_demand = 0
1068: OR l_total_supply = 0)

Line 1081: OE_DEBUG_PUB.Add('Exiting Calculate Percentage '||x_percentage,1);

1077: -- 4695715
1078: x_primary_uom := l_primary_uom;
1079:
1080: IF l_debug_level > 0 THEN
1081: OE_DEBUG_PUB.Add('Exiting Calculate Percentage '||x_percentage,1);
1082: END IF;
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085:

Line 1121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1117: l_total_conv_supply NUMBER :=0;
1118: l_total_conv_supply2 NUMBER :=0; -- INVCONV
1119: l_temp NUMBER :=0;
1120: --
1121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1122: --
1123: BEGIN
1124: --4695715
1125: IF p_primary_uom IS NOT NULL THEN

Line 1148: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;

1144: IF NOT OE_GLOBALS.Equal(p_x_rsv_tbl(I).ordered_qty_UOM, l_primary_uom)
1145: AND NVL(p_reservation_mode,'*') ='PERCENT'
1146: THEN
1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add( 'Before UOM convertion :' || l_total_supply || '/' || l_primary_uom, 1 ) ;
1149: END IF;
1150: l_total_conv_supply :=
1151: INV_CONVERT.INV_UM_CONVERT( item_id => p_x_rsv_tbl(I).inventory_item_id,
1152: precision => 5,

Line 1171: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );

1167: );
1168:
1169: --l_primary_uom := p_x_rsv_tbl(I).ordered_qty_uom;
1170: IF l_debug_level > 0 THEN
1171: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );
1172: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );
1173: END IF;
1174: ELSIF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1175: l_total_conv_supply := l_total_supply;

Line 1172: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );

1168:
1169: --l_primary_uom := p_x_rsv_tbl(I).ordered_qty_uom;
1170: IF l_debug_level > 0 THEN
1171: oe_debug_pub.add( 'After UOM convertion :' || l_total_conv_supply || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );
1172: oe_debug_pub.add( 'Total Supply2 :' || l_total_conv_supply2 || '/' || p_x_rsv_tbl(I).ordered_qty_uom, 1 );
1173: END IF;
1174: ELSIF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1175: l_total_conv_supply := l_total_supply;
1176: l_total_conv_supply2 := l_total_supply2;

Line 1184: OE_DEBUG_PUB.Add('Before Calling validate_quantity ' ,1);

1180: TRUNC((p_x_rsv_tbl(I).ordered_qty * p_percentage) / 100, 5);
1181: p_x_rsv_tbl(I).derived_reserved_qty2 := -- INVCONV
1182: TRUNC((p_x_rsv_tbl(I).ordered_qty2 * p_percentage) / 100, 5); -- INVCONV
1183: IF l_debug_level > 0 THEN
1184: OE_DEBUG_PUB.Add('Before Calling validate_quantity ' ,1);
1185: END IF;
1186: inv_decimals_pub.validate_quantity(
1187: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1188: p_organization_id =>

Line 1196: OE_DEBUG_PUB.Add('After Calling validate_quantity: '||l_qty_return_status ,1);

1192: x_output_quantity => l_validated_quantity,
1193: x_primary_quantity => l_primary_quantity,
1194: x_return_status => l_qty_return_status);
1195: IF l_debug_level > 0 THEN
1196: OE_DEBUG_PUB.Add('After Calling validate_quantity: '||l_qty_return_status ,1);
1197: END IF;
1198: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1199: IF l_debug_level > 0 THEN
1200: OE_DEBUG_PUB.Add('Validate_quantity returns Error/Warning: truncating the quantity');

Line 1200: OE_DEBUG_PUB.Add('Validate_quantity returns Error/Warning: truncating the quantity');

1196: OE_DEBUG_PUB.Add('After Calling validate_quantity: '||l_qty_return_status ,1);
1197: END IF;
1198: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1199: IF l_debug_level > 0 THEN
1200: OE_DEBUG_PUB.Add('Validate_quantity returns Error/Warning: truncating the quantity');
1201: END IF;
1202: p_x_rsv_tbl(I).derived_reserved_qty := TRUNC(l_validated_quantity);
1203: END IF;
1204: IF l_debug_level > 0 THEN

Line 1205: OE_DEBUG_PUB.Add('Validate_quantity: '||p_x_rsv_tbl(I).derived_reserved_qty ,1);

1201: END IF;
1202: p_x_rsv_tbl(I).derived_reserved_qty := TRUNC(l_validated_quantity);
1203: END IF;
1204: IF l_debug_level > 0 THEN
1205: OE_DEBUG_PUB.Add('Validate_quantity: '||p_x_rsv_tbl(I).derived_reserved_qty ,1);
1206: OE_DEBUG_PUB.Add('Available quantity: '||l_total_conv_supply ,1);
1207: END IF;
1208: IF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1209: IF l_total_conv_supply > 0

Line 1206: OE_DEBUG_PUB.Add('Available quantity: '||l_total_conv_supply ,1);

1202: p_x_rsv_tbl(I).derived_reserved_qty := TRUNC(l_validated_quantity);
1203: END IF;
1204: IF l_debug_level > 0 THEN
1205: OE_DEBUG_PUB.Add('Validate_quantity: '||p_x_rsv_tbl(I).derived_reserved_qty ,1);
1206: OE_DEBUG_PUB.Add('Available quantity: '||l_total_conv_supply ,1);
1207: END IF;
1208: IF NVL(p_reservation_mode,'*') ='PERCENT' THEN
1209: IF l_total_conv_supply > 0
1210: AND p_x_rsv_tbl(I).derived_reserved_qty > l_total_conv_supply THEN

Line 1278: OE_Debug_pub.Add('Derived reserved Qty '||p_x_rsv_tbl(I).derived_reserved_qty,1);

1274: --5041136
1275: p_x_rsv_tbl(I).corrected_reserved_qty := p_x_rsv_tbl(I).derived_reserved_qty;
1276: p_x_rsv_tbl(I).corrected_reserved_qty2 := p_x_rsv_tbl(I).derived_reserved_qty2;
1277: IF l_debug_level > 0 THEN
1278: OE_Debug_pub.Add('Derived reserved Qty '||p_x_rsv_tbl(I).derived_reserved_qty,1);
1279: OE_Debug_pub.Add('Consumed reserved Qty '||g_consumed_for_lot,1);
1280: OE_Debug_pub.Add('Derived reserved Qty2 '||p_x_rsv_tbl(I).derived_reserved_qty2,1);
1281: OE_Debug_pub.Add('Consumed reserved Qty2 '||g_consumed_for_lot2,1);
1282: END IF;

Line 1279: OE_Debug_pub.Add('Consumed reserved Qty '||g_consumed_for_lot,1);

1275: p_x_rsv_tbl(I).corrected_reserved_qty := p_x_rsv_tbl(I).derived_reserved_qty;
1276: p_x_rsv_tbl(I).corrected_reserved_qty2 := p_x_rsv_tbl(I).derived_reserved_qty2;
1277: IF l_debug_level > 0 THEN
1278: OE_Debug_pub.Add('Derived reserved Qty '||p_x_rsv_tbl(I).derived_reserved_qty,1);
1279: OE_Debug_pub.Add('Consumed reserved Qty '||g_consumed_for_lot,1);
1280: OE_Debug_pub.Add('Derived reserved Qty2 '||p_x_rsv_tbl(I).derived_reserved_qty2,1);
1281: OE_Debug_pub.Add('Consumed reserved Qty2 '||g_consumed_for_lot2,1);
1282: END IF;
1283:

Line 1280: OE_Debug_pub.Add('Derived reserved Qty2 '||p_x_rsv_tbl(I).derived_reserved_qty2,1);

1276: p_x_rsv_tbl(I).corrected_reserved_qty2 := p_x_rsv_tbl(I).derived_reserved_qty2;
1277: IF l_debug_level > 0 THEN
1278: OE_Debug_pub.Add('Derived reserved Qty '||p_x_rsv_tbl(I).derived_reserved_qty,1);
1279: OE_Debug_pub.Add('Consumed reserved Qty '||g_consumed_for_lot,1);
1280: OE_Debug_pub.Add('Derived reserved Qty2 '||p_x_rsv_tbl(I).derived_reserved_qty2,1);
1281: OE_Debug_pub.Add('Consumed reserved Qty2 '||g_consumed_for_lot2,1);
1282: END IF;
1283:
1284: END LOOP;

Line 1281: OE_Debug_pub.Add('Consumed reserved Qty2 '||g_consumed_for_lot2,1);

1277: IF l_debug_level > 0 THEN
1278: OE_Debug_pub.Add('Derived reserved Qty '||p_x_rsv_tbl(I).derived_reserved_qty,1);
1279: OE_Debug_pub.Add('Consumed reserved Qty '||g_consumed_for_lot,1);
1280: OE_Debug_pub.Add('Derived reserved Qty2 '||p_x_rsv_tbl(I).derived_reserved_qty2,1);
1281: OE_Debug_pub.Add('Consumed reserved Qty2 '||g_consumed_for_lot2,1);
1282: END IF;
1283:
1284: END LOOP;
1285: END Derive_Reservation_qty;

Line 1317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1313: l_primary_quantity NUMBER;
1314: l_qty_return_status VARCHAR2(1);
1315: l_rsv_exists BOOLEAN;
1316: --
1317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1318: --
1319:
1320: BEGIN
1321: Oe_debug_pub.add ('inside Create reservation',1);

Line 1321: Oe_debug_pub.add ('inside Create reservation',1);

1317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1318: --
1319:
1320: BEGIN
1321: Oe_debug_pub.add ('inside Create reservation',1);
1322: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
1323: l_partial_reservation_flag := p_partial_reservation; -- Pack J
1324: FOR I IN 1..p_x_rsv_tbl.COUNT
1325: LOOP

Line 1330: OE_Debug_pub.Add('Creating reservation record',1);

1326: --5041136
1327: --IF p_x_rsv_tbl(I).derived_reserved_qty > 0 THEN
1328: IF p_x_rsv_tbl(I).corrected_reserved_qty > 0 THEN
1329: IF l_debug_level > 0 THEN
1330: OE_Debug_pub.Add('Creating reservation record',1);
1331: END IF;
1332: --Pack J
1333: l_count_header := l_count_header + 1;
1334: IF l_count_header = 1 THEN

Line 1417: OE_DEBUG_PUB.Add('Before Calling inv_reservation_pub.validate_quantity ' ,1);

1413: IF NVL(l_reservation_rec.reservation_quantity,0)
1414: <> NVL(p_x_rsv_tbl(I).derived_reserved_qty_mir,0) THEN
1415:
1416: IF l_debug_level > 0 THEN
1417: OE_DEBUG_PUB.Add('Before Calling inv_reservation_pub.validate_quantity ' ,1);
1418: END IF;
1419: inv_decimals_pub.validate_quantity(
1420: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1421: p_organization_id =>

Line 1429: OE_DEBUG_PUB.Add('After Calling inv_reservation_pub.validate_quantity: '||l_qty_return_status ,1);

1425: x_output_quantity => l_validated_quantity,
1426: x_primary_quantity => l_primary_quantity,
1427: x_return_status => l_qty_return_status);
1428: IF l_debug_level > 0 THEN
1429: OE_DEBUG_PUB.Add('After Calling inv_reservation_pub.validate_quantity: '||l_qty_return_status ,1);
1430: END IF;
1431:
1432: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1433: IF l_debug_level > 0 THEN

Line 1434: OE_DEBUG_PUB.Add('Validate_quantity returns Error/Warning: truncating the quantity');

1430: END IF;
1431:
1432: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1433: IF l_debug_level > 0 THEN
1434: OE_DEBUG_PUB.Add('Validate_quantity returns Error/Warning: truncating the quantity');
1435: END IF;
1436: l_validated_quantity := TRUNC(l_validated_quantity);
1437: END IF;
1438: IF l_debug_level > 0 THEN

Line 1439: OE_DEBUG_PUB.Add('Parimary_quantity: '||l_primary_quantity ,1);

1435: END IF;
1436: l_validated_quantity := TRUNC(l_validated_quantity);
1437: END IF;
1438: IF l_debug_level > 0 THEN
1439: OE_DEBUG_PUB.Add('Parimary_quantity: '||l_primary_quantity ,1);
1440: OE_DEBUG_PUB.Add('Validate_quantity: '||l_validated_quantity ,1);
1441: END IF;
1442: ELSE
1443: l_validated_quantity := l_reservation_rec.reservation_quantity;

Line 1440: OE_DEBUG_PUB.Add('Validate_quantity: '||l_validated_quantity ,1);

1436: l_validated_quantity := TRUNC(l_validated_quantity);
1437: END IF;
1438: IF l_debug_level > 0 THEN
1439: OE_DEBUG_PUB.Add('Parimary_quantity: '||l_primary_quantity ,1);
1440: OE_DEBUG_PUB.Add('Validate_quantity: '||l_validated_quantity ,1);
1441: END IF;
1442: ELSE
1443: l_validated_quantity := l_reservation_rec.reservation_quantity;
1444: END IF;

Line 1459: OE_DEBUG_PUB.Add('Calling inv_reservation_pub.create_reservation '

1455: END IF;
1456:
1457: -- Call INV with action = RESERVE
1458: IF l_debug_level > 0 THEN
1459: OE_DEBUG_PUB.Add('Calling inv_reservation_pub.create_reservation '
1460: ||l_reservation_rec.reservation_quantity,1);
1461: END IF;
1462: INV_RESERVATION_PUB.Create_Reservation
1463: ( p_api_version_number => 1.0

Line 1480: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' || l_return_status ||' '||l_quantity_reserved,1);

1476: , x_reservation_id => l_rsv_id
1477: , p_partial_rsv_exists => l_rsv_exists
1478: );
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;

Line 1488: OE_DEBUG_PUB.Add('Raising Unexpected error',1);

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;
1491:
1492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1494: OE_DEBUG_PUB.Add('Raising Expected error',1);

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
1497: fnd_message.set_encoded(l_msg_data);
1498: l_buffer := fnd_message.get;

Line 1501: OE_DEBUG_PUB.Add(l_msg_data,1);

1497: fnd_message.set_encoded(l_msg_data);
1498: l_buffer := fnd_message.get;
1499: OE_MSG_PUB.Add_text(p_message_text => l_buffer);
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:

Line 1512: oe_debug_pub.add( ' INSIDE LOOP BEFORE CALLING THE COMMIT_RESERVATION' , 1 ) ;

1508: -- Pack J
1509: IF l_commit_count = 500 THEN
1510:
1511: IF l_debug_level > 0 THEN
1512: oe_debug_pub.add( ' INSIDE LOOP BEFORE CALLING THE COMMIT_RESERVATION' , 1 ) ;
1513: END IF;
1514: Commit_Reservation(p_request_id => l_request_id
1515: ,x_return_status => l_return_status);
1516: IF l_debug_level > 0 THEN

Line 1517: oe_debug_pub.add( 'INSIDE LOOP AFTER CALLING THE COMMIT_RESERVATION : ' , 1 ) ;

1513: END IF;
1514: Commit_Reservation(p_request_id => l_request_id
1515: ,x_return_status => l_return_status);
1516: IF l_debug_level > 0 THEN
1517: oe_debug_pub.add( 'INSIDE LOOP AFTER CALLING THE COMMIT_RESERVATION : ' , 1 ) ;
1518: END IF;
1519: --Pack J
1520: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
1521:

Line 1528: oe_debug_pub.add( ' BEFORE CALLING THE COMMIT_RESERVATION' , 1 ) ;

1524: END IF;
1525: END IF;
1526: END LOOP;
1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( ' BEFORE CALLING THE COMMIT_RESERVATION' , 1 ) ;
1529: END IF;
1530: Commit_Reservation(p_request_id => l_request_id
1531: ,x_return_status => l_return_status);
1532: IF l_debug_level > 0 THEN

Line 1533: oe_debug_pub.add( ' AFTER CALLING THE COMMIT_RESERVATION ', 1 ) ;

1529: END IF;
1530: Commit_Reservation(p_request_id => l_request_id
1531: ,x_return_status => l_return_status);
1532: IF l_debug_level > 0 THEN
1533: oe_debug_pub.add( ' AFTER CALLING THE COMMIT_RESERVATION ', 1 ) ;
1534: END IF;
1535: --Pack J
1536: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
1537:

Line 1545: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);

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);
1546: END IF;
1547:
1548: EXCEPTION
1549: WHEN FND_API.G_EXC_ERROR THEN

Line 1551: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation for rsv_tbl',1);

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;
1554:
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1557: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation for rsv tbl',1 );

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;
1560:
1561: WHEN OTHERS THEN

Line 1563: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation for rsv tbl',1);

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);
1564: END IF;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566:
1567: END create_reservation;

Line 1586: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1582: l_return_status VARCHAR2(1);
1583: l_request_id NUMBER;
1584: l_primary_uom VARCHAR2(3) := NULL; -- 4695715
1585: --
1586: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1587: --
1588:
1589: BEGIN
1590: l_percent := p_percent;

Line 1624: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);

1620:
1621: END IF;
1622:
1623: IF l_debug_level > 0 THEN
1624: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1625: END IF;
1626:
1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1628:

Line 1630: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);

1626:
1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1628:
1629: IF l_debug_level > 0 THEN
1630: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1631: END IF;
1632:
1633: IF p_reserve_run_type = 'RESERVE'
1634: OR p_reserve_run_type IS NULL THEN

Line 1653: OE_DEBUG_PUB.Add('Create Reservation returned with Expected error for rsv tbl ',1);

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
1656: IF l_debug_level > 0 THEN
1657: OE_DEBUG_PUB.Add('Create Reservation returned with Unexpected error for rsv tbl',1);

Line 1657: OE_DEBUG_PUB.Add('Create Reservation returned with Unexpected error for rsv tbl',1);

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;
1660:
1661: ELSIF p_reserve_run_type = 'SIMULATE TO EXTERNAL TABLE' THEN

Line 1663: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);

1659: END IF;
1660:
1661: ELSIF p_reserve_run_type = 'SIMULATE TO EXTERNAL TABLE' THEN
1662: IF l_debug_level > 0 THEN
1663: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1664: END IF;
1665:
1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1667:

Line 1669: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);

1665:
1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1667:
1668: IF l_debug_level > 0 THEN
1669: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1670: END IF;
1671:
1672: ELSIF p_reserve_run_type = 'SIMULATE' THEN -- Pack J
1673: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);

Line 1705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1701: l_msg_data VARCHAR2(1000);
1702: l_dummy VARCHAR2(100);
1703:
1704: --
1705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1706: --
1707:
1708: BEGIN
1709: IF l_debug_level > 0 THEN

Line 1710: OE_DEBUG_PUB.Add('Inside Reserve Eligible Procedure',1);

1706: --
1707:
1708: BEGIN
1709: IF l_debug_level > 0 THEN
1710: OE_DEBUG_PUB.Add('Inside Reserve Eligible Procedure',1);
1711: END IF;
1712:
1713: /* Check if line is open, if not open ignore the line */
1714: IF ( p_line_rec.open_flag = 'N' ) THEN

Line 1716: OE_DEBUG_PUB.Add('Line is closed, not eligible for reservation', 1);

1712:
1713: /* Check if line is open, if not open ignore the line */
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 */

Line 1723: OE_DEBUG_PUB.Add('Line is shipped, not eligible for reservation', 1);

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
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

Line 1729: OE_DEBUG_PUB.Add('Line is Fulfilled, not eligible for reservation', 1);

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);
1730: END IF;
1731: l_return_status := FND_API.G_RET_STS_ERROR;
1732: --Added for bug 6873122
1733: END IF;

Line 1740: OE_DEBUG_PUB.Add('Before checking Existing Reservations',1);

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
1740: OE_DEBUG_PUB.Add('Before checking Existing Reservations',1);
1741: END IF;
1742:
1743: SELECT 'Reservation Exists'
1744: INTO l_dummy

Line 1749: OE_DEBUG_PUB.Add('Reservations exists on the line',3);

1745: FROM MTL_RESERVATIONS
1746: WHERE DEMAND_SOURCE_LINE_ID = p_line_rec.line_id;
1747:
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

Line 1756: OE_DEBUG_PUB.Add('In Expected Error for Check Reservation',3);

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;
1759:
1760: WHEN NO_DATA_FOUND THEN

Line 1771: OE_DEBUG_PUB.Add('Before checking for Staged/Closed deliveries', 1);

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;
1773:
1774: SELECT 'Staging Exists'
1775: INTO l_dummy

Line 1782: OE_DEBUG_PUB.Add('Staged/Closed deliveries exist for the line', 3);

1778: AND SOURCE_CODE = 'OE' -- Added for bug 3286756
1779: AND RELEASED_STATUS IN ('Y', 'C');
1780:
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:

Line 1790: OE_DEBUG_PUB.Add('In Expected Error for Checking Staged/Closed deliveries', 3);

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;
1793: WHEN NO_DATA_FOUND THEN
1794: NULL;

Line 1811: OE_DEBUG_PUB.Add('Schedule Ship Date:'||

1807:
1808: IF (NVL(p_use_reservation_time_fence,'Y') = 'Y' or
1809: NVL(p_use_reservation_time_fence,'Yes') = 'Yes') THEN
1810: IF l_debug_level > 0 THEN
1811: OE_DEBUG_PUB.Add('Schedule Ship Date:'||
1812: p_line_rec.schedule_ship_date,3);
1813: END IF;
1814:
1815: -- Scheduling restructure

Line 1821: OE_DEBUG_PUB.Add('The Schedule Date for Line falls

1817: -- 4689197
1818: IF NOT OE_ORDER_SCH_UTIL.Within_Rsv_Time_Fence
1819: (p_line_rec.schedule_ship_date, p_line_rec.org_id) THEN
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:

Line 1832: OE_DEBUG_PUB.Add('The Schedule Date for Line falls

1828: -- 4689197
1829: IF NOT OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
1830: (p_line_rec.schedule_ship_date, p_line_rec.org_id) THEN
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:

Line 1845: OE_DEBUG_PUB.Add('Checking Scheduling Level...',3);

1841:
1842: -- We need to check if the Line Type for the Line allows
1843: -- us to reserve the Line or not.
1844: IF l_debug_level > 0 THEN
1845: OE_DEBUG_PUB.Add('Checking Scheduling Level...',3);
1846: END IF;
1847: -- Scheduling restructure
1848: /* Bug: 4504362
1849: IF NVL(FND_PROFILE.VALUE('ONT_BRANCH_SCHEDULING'),'N') = 'N' THEN

Line 1861: OE_DEBUG_PUB.Add('l_scheduling_level_code:'||l_scheduling_level_code,1);

1857: ,p_line_rec.line_type_id);
1858: --END IF;
1859:
1860: IF l_debug_level > 0 THEN
1861: OE_DEBUG_PUB.Add('l_scheduling_level_code:'||l_scheduling_level_code,1);
1862: END IF;
1863:
1864: IF l_scheduling_level_code is not null AND
1865: (l_scheduling_level_code = SCH_LEVEL_ONE

Line 1875: OE_DEBUG_PUB.Add('Order Type Does not Allow Scheduling',3);

1871: (p_line_rec.schedule_ship_date is NOT NULL OR
1872: p_line_rec.schedule_arrival_date is NOT NULL))
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;

Line 1885: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||

1881: END IF; -- Check for Reservation Exists Clause
1882: x_return_status := l_return_status;
1883:
1884: IF l_debug_level > 0 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

Line 1891: OE_DEBUG_PUB.Add('In Expected Error...in Proc Reserve_Eligible',3);

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;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1897: OE_DEBUG_PUB.Add('In UnExpected Error...in Proc Reserve_Eligible',3);

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;
1900:
1901: WHEN OTHERS THEN

Line 1939: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1935: l_quantity2_reserved NUMBER; -- INVCONV
1936: l_quantity2_to_reserve NUMBER; -- INVCONV
1937:
1938: --
1939: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1940: --
1941:
1942:
1943: BEGIN

Line 1945: OE_Debug_pub.Add('In the Procedure Create Reservation',1);

1941:
1942:
1943: BEGIN
1944: IF l_debug_level > 0 THEN
1945: OE_Debug_pub.Add('In the Procedure Create Reservation',1);
1946: OE_Debug_pub.Add('Before call of Load_INV_Request',1);
1947: END IF;
1948:
1949:

Line 1946: OE_Debug_pub.Add('Before call of Load_INV_Request',1);

1942:
1943: BEGIN
1944: IF l_debug_level > 0 THEN
1945: OE_Debug_pub.Add('In the Procedure Create Reservation',1);
1946: OE_Debug_pub.Add('Before call of Load_INV_Request',1);
1947: END IF;
1948:
1949:
1950: IF p_line_rec.ordered_quantity2 = 0 -- INVCONV

Line 1976: OE_DEBUG_PUB.Add('Before call of inv_reservation_pub.create_reservation',1);

1972:
1973:
1974: -- Call INV with action = RESERVE
1975: IF l_debug_level > 0 THEN
1976: OE_DEBUG_PUB.Add('Before call of inv_reservation_pub.create_reservation',1);
1977: END IF;
1978:
1979: INV_RESERVATION_PUB.Create_Reservation
1980: ( p_api_version_number => 1.0

Line 1996: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' ||

1992: , x_secondary_quantity_reserved => l_quantity2_reserved -- INVCONV
1993: , x_reservation_id => l_rsv_id
1994: );
1995: IF l_debug_level > 0 THEN
1996: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' ||
1997: l_return_status,1);
1998: OE_DEBUG_PUB.Add(l_msg_data,1);
1999: END IF;
2000:

Line 1998: OE_DEBUG_PUB.Add(l_msg_data,1);

1994: );
1995: IF l_debug_level > 0 THEN
1996: OE_DEBUG_PUB.Add('1. After Calling Create Reservation' ||
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

Line 2003: OE_DEBUG_PUB.Add('Raising Unexpected error',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;
2006:
2007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2009: OE_DEBUG_PUB.Add('Raising Expected error',1);

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
2012: fnd_message.set_encoded(l_msg_data);
2013: l_buffer := fnd_message.get;

Line 2016: OE_DEBUG_PUB.Add(l_msg_data,1);

2012: fnd_message.set_encoded(l_msg_data);
2013: l_buffer := fnd_message.get;
2014: OE_MSG_PUB.Add_text(p_message_text => l_buffer);
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:

Line 2023: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||

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' ||
2024: l_return_status ,1);
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:

Line 2031: OE_DEBUG_PUB.Add('In Expected Error...in Proc Create_Reservation',1);

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;
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2037: OE_DEBUG_PUB.Add('In Unexpected Error...in Proc Create_Reservation');

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;
2040:
2041: WHEN OTHERS THEN

Line 2043: OE_DEBUG_PUB.Add('In others error...in Proc Create_Reservation');

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');
2044: END IF;
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2046:
2047: END;

Line 2132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2128: CURSOR rsv_process_flag IS
2129: SELECT process_flag FROM oe_reservation_sets
2130: WHERE reservation_set_name = p_reserve_set_name;
2131: --
2132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2133: --
2134: -- Moac
2135: l_single_org BOOLEAN := FALSE;
2136: l_old_org_id NUMBER := -99;

Line 2165: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

2161: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2162: ERRBUF := l_msg_data;
2163: RETCODE := 2;
2164: IF l_debug_level > 0 THEN
2165: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);
2166: END IF;
2167: GOTO END_OF_PROCESS;
2168: END IF;
2169: /*

Line 2171: OE_DEBUG_PUB.Add('Error: user_set_id is null',1);

2167: GOTO END_OF_PROCESS;
2168: END IF;
2169: /*
2170: IF l_user_set_id IS NULL THEN
2171: OE_DEBUG_PUB.Add('Error: user_set_id is null',1);
2172: END IF;
2173: */
2174: END IF;
2175: EXCEPTION

Line 2187: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

2183: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2184: ERRBUF := l_msg_data;
2185: RETCODE := 2;
2186: IF l_debug_level > 0 THEN
2187: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);
2188: END IF;
2189: GOTO END_OF_PROCESS;
2190: */
2191: WHEN OTHERS THEN

Line 2202: OE_DEBUG_PUB.Add('Error : Item not supplied ',1);

2198: IF p_reservation_mode = 'FAIR'
2199: AND p_inventory_item_id IS NULL
2200: THEN
2201: IF l_debug_level > 0 THEN
2202: OE_DEBUG_PUB.Add('Error : Item not supplied ',1);
2203: END IF;
2204: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - item not supplied');
2205: ERRBUF := ' Concurrent request failed - item not supplied';
2206: RETCODE := 2;

Line 2222: OE_DEBUG_PUB.Add('Error : Percentage is null ',1);

2218: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2219: ERRBUF := 'ONT_RSV_PCT_NULL';
2220: RETCODE := 2;
2221: IF l_debug_level > 0 THEN
2222: OE_DEBUG_PUB.Add('Error : Percentage is null ',1);
2223: END IF;
2224: goto END_OF_PROCESS;
2225: ELSIF p_percent > 100 OR p_percent < 1
2226: THEN

Line 2235: OE_DEBUG_PUB.Add('Error : Percentage is lesser than 1 or greater than 100 ',1);

2231: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2232: ERRBUF := 'ONT_RSV_PCT_INVALID';
2233: RETCODE := 2;
2234: IF l_debug_level > 0 THEN
2235: OE_DEBUG_PUB.Add('Error : Percentage is lesser than 1 or greater than 100 ',1);
2236: END IF;
2237: goto END_OF_PROCESS;
2238: END IF;
2239: ELSIF (p_reserve_run_type = 'SIMULATE'

Line 2252: OE_DEBUG_PUB.Add('Error : Reservation Set Name is not provided ',1);

2248: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2249: ERRBUF := 'ONT_RSV_SET_NOT_PROVIDED';
2250: RETCODE := 2;
2251: IF l_debug_level > 0 THEN
2252: OE_DEBUG_PUB.Add('Error : Reservation Set Name is not provided ',1);
2253: END IF;
2254: goto END_OF_PROCESS;
2255: ELSIF p_reserve_set_name IS NOT NULL
2256: AND NVL(p_override_set,'N') = 'N'

Line 2272: OE_DEBUG_PUB.Add('Error : Reservation Set Name exists ',1);

2268: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2269: ERRBUF := 'ONT_RSV_SET_EXISTS';
2270: RETCODE := 2;
2271: IF l_debug_level > 0 THEN
2272: OE_DEBUG_PUB.Add('Error : Reservation Set Name exists ',1);
2273: END IF;
2274: goto END_OF_PROCESS;
2275: END IF;
2276: ELSIF p_reserve_set_name IS NOT NULL

Line 2284: OE_DEBUG_PUB.Add('Error : Reservation Set already processed ',1);

2280: CLOSE rsv_process_flag;
2281: IF l_process_flag = 'Y' THEN
2282:
2283: IF l_debug_level > 0 THEN
2284: OE_DEBUG_PUB.Add('Error : Reservation Set already processed ',1);
2285: END IF;
2286: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - Reserevation Set already processed');
2287: ERRBUF := ' Concurrent request failed - Reserevation Set already processed';
2288: RETCODE := 2;

Line 2296: OE_DEBUG_PUB.Add('Warning : Percent is not valid for this reservation mode ',1);

2292: IF p_reservation_mode = 'FAIR'
2293: AND p_percent IS NOT NULL
2294: THEN
2295: IF l_debug_level > 0 THEN
2296: OE_DEBUG_PUB.Add('Warning : Percent is not valid for this reservation mode ',1);
2297: END IF;
2298: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent is not valid for this reservation mode');
2299: ERRBUF := ' Percent is not valid for this reservation mode - hence not considered';
2300: RETCODE := 2;

Line 2352: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);

2348: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||
2349: p_reserve_set_name);
2350:
2351: IF l_debug_level > 0 THEN
2352: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);
2353: END IF;
2354:
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),

Line 2501: --OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

2497: ELSE
2498: l_stmt := l_stmt || ' ORDER BY l.inventory_item_id,l.ship_from_org_id,l.subinventory';
2499: END IF;
2500: END IF;
2501: --OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2502: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2503:
2504: -- Bind variables
2505: -- 4287740

Line 2580: -- OE_DEBUG_PUB.Add(length(l_stmt));

2576:
2577: -- Define the output variables
2578: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
2579:
2580: -- OE_DEBUG_PUB.Add(length(l_stmt));
2581: IF l_debug_level > 0 THEN
2582: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2583: END IF;
2584: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);

Line 2582: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

2578: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
2579:
2580: -- OE_DEBUG_PUB.Add(length(l_stmt));
2581: IF l_debug_level > 0 THEN
2582: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2583: END IF;
2584: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2585:
2586: -- OPEN l_ref_cur_lines FOR l_stmt;

Line 2605: OE_DEBUG_PUB.Add('Lock row returned with error',1);

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;
2608:
2609: -- Updating the value of the Schedule Action Code

Line 2614: OE_DEBUG_PUB.Add('set mesg context line_id:'||l_line_rec.line_id);

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);
2615: OE_DEBUG_PUB.Add('set mesg context header_id:'||l_line_rec.header_id);
2616: END IF;
2617:
2618: OE_MSG_PUB.Set_Msg_Context(

Line 2615: OE_DEBUG_PUB.Add('set mesg context header_id:'||l_line_rec.header_id);

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);
2615: OE_DEBUG_PUB.Add('set mesg context header_id:'||l_line_rec.header_id);
2616: END IF;
2617:
2618: OE_MSG_PUB.Set_Msg_Context(
2619: p_entity_code => 'LINE'

Line 2641: OE_DEBUG_PUB.Add('Require Reservation returned with error for

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;
2644:
2645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2647: OE_DEBUG_PUB.Add('Require Reservation returned with error for

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));
2650: END IF;
2651:

Line 2649: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

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));
2650: END IF;
2651:
2652: END IF;
2653: ELSE

Line 2672: OE_DEBUG_PUB.Add('Create Reservation returned with

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;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: IF l_debug_level > 0 THEN

Line 2677: 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));
2680: END IF;
2681: ELSE

Line 2679: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

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));
2680: END IF;
2681: ELSE
2682: COMMIT;
2683: END IF;

Line 2717: OE_DEBUG_PUB.Add('Create Reservation returned with

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;
2720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2721: IF l_debug_level > 0 THEN

Line 2722: 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));
2725: END IF;
2726: ELSE

Line 2724: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

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));
2725: END IF;
2726: ELSE
2727: COMMIT;
2728: END IF;

Line 2750: OE_DEBUG_PUB.Add('Warning : No lines were eligible for

2746: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_NO_LINES_RSV_ELIGIBLE');
2747: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2748: RETCODE := 1;
2749: IF l_debug_level > 0 THEN
2750: OE_DEBUG_PUB.Add('Warning : No lines were eligible for
2751: reservation.',1);
2752: END IF;
2753:
2754: IF p_reserve_set_name IS NOT NULL

Line 2764: OE_DEBUG_PUB.Add('Warning : The set is not created as no eligible

2760: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED');
2761: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2762: RETCODE := 1;
2763: IF l_debug_level > 0 THEN
2764: OE_DEBUG_PUB.Add('Warning : The set is not created as no eligible
2765: lines were selected',1);
2766: END IF;
2767: END IF;
2768:

Line 2955: OE_DEBUG_PUB.Add('Exiting Reserve procedure ',1);

2951:
2952:
2953: <>
2954: IF l_debug_level > 0 THEN
2955: OE_DEBUG_PUB.Add('Exiting Reserve procedure ',1);
2956: END IF;
2957:
2958:
2959: EXCEPTION

Line 2962: OE_DEBUG_PUB.Add('Inside the When Others Execption',1);

2958:
2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: IF l_debug_level > 0 THEN
2962: OE_DEBUG_PUB.Add('Inside the When Others Execption',1);
2963: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));
2964: END IF;
2965: END Reserve;
2966:

Line 2963: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));

2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: IF l_debug_level > 0 THEN
2962: OE_DEBUG_PUB.Add('Inside the When Others Execption',1);
2963: OE_DEBUG_PUB.Add(substr(sqlerrm, 1, 2000));
2964: END IF;
2965: END Reserve;
2966:
2967: