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_ORDER_BOOK_UTIL dependencies on FND_API

Line 120: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

116: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;
117: l_msg_count NUMBER;
118: l_active_phase_count NUMBER;
119: l_msg_data VARCHAR2(2000);
120: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
121: l_tax_calculation_event_code varchar2(30) := NULL;
122: l_notify BOOLEAN := FALSE;
123: l_in_loop_index NUMBER := 1;
124: l_line_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_Type;

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
172: --
173: BEGIN
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176: x_validate_cfg := FALSE;
177: x_freeze_inc_items := FALSE;
178:
179: -- NOTE: Process order is called twice, once to update the booked flag

Line 249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

245: );
246:
247: OE_MSG_PUB.reset_msg_context('HEADER');
248:
249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- if unexpected error, then do NOT validate lines.
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 250: x_return_status := FND_API.G_RET_STS_ERROR;

246:
247: OE_MSG_PUB.reset_msg_context('HEADER');
248:
249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- if unexpected error, then do NOT validate lines.
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: RETURN;

Line 252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

248:
249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- if unexpected error, then do NOT validate lines.
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: RETURN;
255: END IF;
256:

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- if unexpected error, then do NOT validate lines.
252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: RETURN;
255: END IF;
256:
257: -- Check whether we need to call the Pricing at BOOKING

Line 364: l_return_status := FND_API.G_RET_STS_SUCCESS;

360: ELSIF l_line_tbl(l_index).item_type_code in ('CLASS','KIT') THEN
361: x_freeze_inc_items := TRUE;
362: END IF;
363:
364: l_return_status := FND_API.G_RET_STS_SUCCESS;
365: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
366: l_line_tbl(l_index).booked_flag := 'Y';
367: l_line_tbl(l_index).flow_status_code := 'BOOKED';
368: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;

Line 395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

391: );
392:
393: OE_MSG_PUB.reset_msg_context('LINE');
394:
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: RETURN;

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392:
393: OE_MSG_PUB.reset_msg_context('LINE');
394:
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: RETURN;
400: END IF;

Line 397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

393: OE_MSG_PUB.reset_msg_context('LINE');
394:
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: RETURN;
400: END IF;
401:

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394:
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: RETURN;
400: END IF;
401:
402: -- bug 1406890

Line 418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

414: p_requesting_entity_id => l_line_tbl(l_index).line_id,
415: p_request_type => OE_GLOBALS.g_tax_line,
416: x_return_status => l_return_status);
417:
418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: RETURN;

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: p_request_type => OE_GLOBALS.g_tax_line,
416: x_return_status => l_return_status);
417:
418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: RETURN;
423: END IF;

Line 420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

416: x_return_status => l_return_status);
417:
418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: RETURN;
423: END IF;
424:

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

417:
418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: RETURN;
423: END IF;
424:
425: END IF; -- if item_type_code not in INCLUDED or CONFIG

Line 445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

441:
442: END LOOP;
443:
444: -- Return error if there were validation errors for the header/line
445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449:

Line 446: RAISE FND_API.G_EXC_ERROR;

442: END LOOP;
443:
444: -- Return error if there were validation errors for the header/line
445: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449:
450: -- Update the booked_flag and flow_status on the tables

Line 451: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

447: END IF;
448:
449:
450: -- Update the booked_flag and flow_status on the tables
451: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
452:
453: UPDATE oe_order_headers_all
454: SET booked_flag = 'Y'
455: , booked_date = sysdate

Line 494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

490: Pricing_Book_Event(p_x_line_tbl => l_line_tbl
491: , p_header_id => p_header_id
492: , x_return_status => l_return_status
493: );
494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;

Line 495: RAISE FND_API.G_EXC_ERROR;

491: , p_header_id => p_header_id
492: , x_return_status => l_return_status
493: );
494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499: END IF;

Line 496: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

492: , x_return_status => l_return_status
493: );
494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499: END IF;
500: */

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: );
494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499: END IF;
500: */
501:

Line 569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
567: END IF;
568:
569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;

Line 570: RAISE FND_API.G_EXC_ERROR;

566: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
567: END IF;
568:
569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:

Line 571: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

567: END IF;
568:
569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: IF l_notify_index is not null then

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568:
569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: IF l_notify_index is not null then
576: -- modify Global Picture

Line 631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
629: END IF;
630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;

Line 632: RAISE FND_API.G_EXC_ERROR;

628: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
629: END IF;
630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:

Line 633: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

629: END IF;
630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: IF l_notify_index is not null then

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: IF l_notify_index is not null then
638: -- modify Global Picture

Line 733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

729: );
730:
731: -- renga -end change for tax calculation event enhancement
732:
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;

Line 734: RAISE FND_API.G_EXC_ERROR;

730:
731: -- renga -end change for tax calculation event enhancement
732:
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:

Line 735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

731: -- renga -end change for tax calculation event enhancement
732:
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739: END IF; /* code set is pack H or higher */

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732:
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739: END IF; /* code set is pack H or higher */
740: /* jolin end*/

Line 754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

750: Pricing_Book_Event(p_x_line_tbl => l_line_tbl
751: , p_header_id => p_header_id
752: , x_return_status => l_return_status
753: );
754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;

Line 755: RAISE FND_API.G_EXC_ERROR;

751: , p_header_id => p_header_id
752: , x_return_status => l_return_status
753: );
754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;

Line 756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

752: , x_return_status => l_return_status
753: );
754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;
760:

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: );
754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;
760:
761: IF OE_FEATURES_PVT.Is_Margin_Avail THEN

Line 767: WHEN FND_API.G_EXC_ERROR THEN

763: Oe_Margin_Pvt.Margin_Hold(p_header_id);
764: END IF;
765:
766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN

Line 768: x_return_status := FND_API.G_RET_STS_ERROR;

764: END IF;
765:
766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

765:
766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg

Line 781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

777: ( G_PKG_NAME
778: , 'Update_Booked_Flag'
779: );
780: END IF;
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END Update_Booked_Flag;
783:
784: PROCEDURE Verify_Payment_AT_Booking
785: ( p_header_id IN NUMBER

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

810: );
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: IF FND_MSG_PUB.Check_Msg_Level
816: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg

Line 846: h_return_status := FND_API.G_RET_STS_SUCCESS;

842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;
844: END IF;
845:
846: h_return_status := FND_API.G_RET_STS_SUCCESS;
847: -- Validate Header Sales Credits
848: OE_Validate_Header_Scredit.Validate_HSC_TOTAL_FOR_BK
849: ( p_header_id => p_header_id
850: , x_return_status => x_return_status );

Line 858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

854: END IF;
855:
856: -- FP bug 4697708
857: -- h_return_status := x_return_status;
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: h_return_status := x_return_status;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RETURN;
862: END IF;

Line 860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

856: -- FP bug 4697708
857: -- h_return_status := x_return_status;
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: h_return_status := x_return_status;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RETURN;
862: END IF;
863:
864:

Line 865: l_return_status := FND_API.G_RET_STS_SUCCESS;

861: RETURN;
862: END IF;
863:
864:
865: l_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- commented out for FP 4697708
868: /*
869: -- IF added for nocopy analysis

Line 870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

866:
867: -- commented out for FP 4697708
868: /*
869: -- IF added for nocopy analysis
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: RETURN ;

Line 871: x_return_status := FND_API.G_RET_STS_ERROR;

867: -- commented out for FP 4697708
868: /*
869: -- IF added for nocopy analysis
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: RETURN ;
875: ELSE

Line 872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

868: /*
869: -- IF added for nocopy analysis
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: RETURN ;
875: ELSE
876: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869: -- IF added for nocopy analysis
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: RETURN ;
875: ELSE
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877: END IF;

Line 876: x_return_status := FND_API.G_RET_STS_SUCCESS;

872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: RETURN ;
875: ELSE
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877: END IF;
878: */
879:
880: --FP bug 3872166 start

Line 891: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

887: oe_debug_pub.add( 'RETURN STATUS AFTER LSC FOR LINE '||l_line_id.line_id|| 'IS '||X_RETURN_STATUS ) ;
888: END IF;
889:
890: -- FP bug 4697708
891: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
892: l_return_status := x_return_status;
893: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
894: RETURN;
895: END IF;

Line 893: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

889:
890: -- FP bug 4697708
891: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
892: l_return_status := x_return_status;
893: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
894: RETURN;
895: END IF;
896: END LOOP;
897: --FP bug 3872166 end

Line 905: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

901: END IF;
902:
903: -- FP bug 4697708
904: /*
905: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
906: l_return_status := x_return_status;
907: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: RETURN;

Line 907: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

903: -- FP bug 4697708
904: /*
905: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
906: l_return_status := x_return_status;
907: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: RETURN;
910: ELSE -- nocopy analysis
911: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

904: /*
905: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
906: l_return_status := x_return_status;
907: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: RETURN;
910: ELSE -- nocopy analysis
911: l_return_status := FND_API.G_RET_STS_SUCCESS;
912: END IF;

Line 911: l_return_status := FND_API.G_RET_STS_SUCCESS;

907: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: RETURN;
910: ELSE -- nocopy analysis
911: l_return_status := FND_API.G_RET_STS_SUCCESS;
912: END IF;
913: */
914:
915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN

911: l_return_status := FND_API.G_RET_STS_SUCCESS;
912: END IF;
913: */
914:
915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 916: x_return_status := FND_API.G_RET_STS_ERROR;

912: END IF;
913: */
914:
915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: ELSE

Line 917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status

913: */
914:
915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: ELSE
921: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 918: = FND_API.G_RET_STS_UNEXP_ERROR THEN

914:
915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: ELSE
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922: END IF;

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915: IF h_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: ELSE
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922: END IF;
923:

Line 921: x_return_status := FND_API.G_RET_STS_SUCCESS;

917: ELSIF h_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status
918: = FND_API.G_RET_STS_UNEXP_ERROR THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: ELSE
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922: END IF;
923:
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;

Line 930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

926: END IF;
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: IF FND_MSG_PUB.Check_Msg_Level
932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
933: THEN
934: OE_MSG_PUB.Add_Exc_Msg

Line 982: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND

978: ,x_msg_data => l_msg_data
979: );
980:
981:
982: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
983: l_check_holds_result = FND_API.G_TRUE )
984: THEN
985: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
986: OE_MSG_PUB.ADD;

Line 983: l_check_holds_result = FND_API.G_TRUE )

979: );
980:
981:
982: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
983: l_check_holds_result = FND_API.G_TRUE )
984: THEN
985: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
986: OE_MSG_PUB.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983: l_check_holds_result = FND_API.G_TRUE )
984: THEN
985: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
986: OE_MSG_PUB.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: /* Changes for bug#2673236:Begin */
989: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
990: l_check_holds_result = FND_API.G_FALSE )
991: THEN

Line 989: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

985: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
986: OE_MSG_PUB.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: /* Changes for bug#2673236:Begin */
989: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
990: l_check_holds_result = FND_API.G_FALSE )
991: THEN
992: IF nvl(fnd_profile.value('ONT_PREVENT_BOOKING'),'N')='Y' THEN
993: IF l_debug_level > 0 THEN

Line 990: l_check_holds_result = FND_API.G_FALSE )

986: OE_MSG_PUB.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: /* Changes for bug#2673236:Begin */
989: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
990: l_check_holds_result = FND_API.G_FALSE )
991: THEN
992: IF nvl(fnd_profile.value('ONT_PREVENT_BOOKING'),'N')='Y' THEN
993: IF l_debug_level > 0 THEN
994: oe_debug_pub.add( 'Profile ont_prevent_booking is set' , 1 ) ;

Line 1021: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND

1017: ,x_msg_data => l_msg_data
1018: );
1019:
1020:
1021: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
1022: p_hold_rec.x_result_out = FND_API.G_TRUE )
1023: THEN
1024: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1025: OE_MSG_PUB.ADD;

Line 1022: p_hold_rec.x_result_out = FND_API.G_TRUE )

1018: );
1019:
1020:
1021: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
1022: p_hold_rec.x_result_out = FND_API.G_TRUE )
1023: THEN
1024: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1025: OE_MSG_PUB.ADD;
1026: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1026: x_return_status := FND_API.G_RET_STS_ERROR;

1022: p_hold_rec.x_result_out = FND_API.G_TRUE )
1023: THEN
1024: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1025: OE_MSG_PUB.ADD;
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: END IF;
1028: END IF;
1029: EXCEPTION
1030: WHEN NO_DATA_FOUND THEN

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level
1044: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg

Line 1056: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1052:
1053: ---------------------------------------------------------------
1054: PROCEDURE BOOK_ORDER
1055: (p_api_version_number IN NUMBER
1056: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1057: ,p_header_id IN NUMBER
1058: ,x_return_status OUT NOCOPY VARCHAR2
1059:
1060: ,x_msg_count OUT NOCOPY NUMBER

Line 1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

1086:
1087: SAVEPOINT BOOK_ORDER;
1088:
1089: -- Initialize API return status to success
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091:
1092: -- Standard call to check for call compatibility
1093:
1094: IF NOT FND_API.Compatible_API_Call

Line 1094: IF NOT FND_API.Compatible_API_Call

1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091:
1092: -- Standard call to check for call compatibility
1093:
1094: IF NOT FND_API.Compatible_API_Call
1095: ( l_api_version_number
1096: , p_api_version_number
1097: , l_api_name
1098: , G_PKG_NAME

Line 1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1097: , l_api_name
1098: , G_PKG_NAME
1099: )
1100: THEN
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: END IF;
1103:
1104: -- Initialize message list.
1105:

Line 1106: IF FND_API.to_Boolean(p_init_msg_list) THEN

1102: END IF;
1103:
1104: -- Initialize message list.
1105:
1106: IF FND_API.to_Boolean(p_init_msg_list) THEN
1107: OE_MSG_PUB.initialize;
1108: END IF;
1109:
1110:

Line 1130: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1126:
1127: -- if unexpected error, then go to exception handler. If there
1128: -- were validation failures, then it is expected error therefore
1129: -- go to order and line validation and then raise error.
1130: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134: IF l_debug_level > 0 THEN

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: -- if unexpected error, then go to exception handler. If there
1128: -- were validation failures, then it is expected error therefore
1129: -- go to order and line validation and then raise error.
1130: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'RETURN STATUS AFTER SALES CREDITS:'||L_RETURN_STATUS ) ;

Line 1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR

1150: END IF;
1151:
1152: -- if failure during validate sales credits OR during order and
1153: -- line validation, raise error
1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR
1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN

1151:
1152: -- if failure during validate sales credits OR during order and
1153: -- line validation, raise error
1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR
1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;

Line 1156: RAISE FND_API.G_EXC_ERROR;

1152: -- if failure during validate sales credits OR during order and
1153: -- line validation, raise error
1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR
1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;
1160:

Line 1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1153: -- line validation, raise error
1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR
1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;
1160:
1161:

Line 1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1154: IF (x_return_status = FND_API.G_RET_STS_ERROR OR
1155: l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;
1160:
1161:
1162: -- Validate configurations, if any, in this order

Line 1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS ) ;
1169: END IF;
1170:
1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;

Line 1172: RAISE FND_API.G_EXC_ERROR;

1168: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS ) ;
1169: END IF;
1170:
1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:

Line 1173: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1169: END IF;
1170:
1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: END IF;

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1170:
1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: END IF;
1178:

Line 1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS ) ;
1191: END IF;
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS ) ;
1191: END IF;
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:

Line 1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1191: END IF;
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: END IF;

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: END IF;
1200:

Line 1215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1211: , p_notify => FALSE
1212: , x_return_status => l_return_status
1213: );
1214:
1215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;

Line 1216: RAISE FND_API.G_EXC_ERROR;

1212: , x_return_status => l_return_status
1213: );
1214:
1215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;
1220:

Line 1217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1213: );
1214:
1215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;
1220:
1221:

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1214:
1215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;
1220:
1221:
1222: -- ABH

Line 1229: --This procedure would return status of FND_API.G_RET_STS_SUCCESS only if the order passed QA check

1225:
1226:
1227: /****************************************************
1228: l_header_id_char := TO_CHAR(p_header_id);
1229: --This procedure would return status of FND_API.G_RET_STS_SUCCESS only if the order passed QA check
1230: QA_Order(
1231: p_api_version_number => 1.0,
1232: p_init_msg_list => 'T',
1233: p_header_id_list => l_header_id_char,

Line 1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1237: x_msg_count => l_msg_count,
1238: x_msg_data => l_msg_data
1239: );
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;

Line 1242: RAISE FND_API.G_EXC_ERROR;

1238: x_msg_data => l_msg_data
1239: );
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246: ****************************************************/

Line 1243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1239: );
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246: ****************************************************/
1247:

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246: ****************************************************/
1247:
1248: --Check for licensing

Line 1266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1262: x_msg_count => l_msg_count,
1263: x_msg_data => l_msg_data);
1264:
1265:
1266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1267:
1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN

1264:
1265:
1266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1267:
1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;

Line 1269: RAISE FND_API.G_EXC_ERROR;

1265:
1266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1267:
1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273:

Line 1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1267:
1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1267:
1268: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;

Line 1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1270: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;

Line 1275: RAISE FND_API.G_EXC_ERROR;

1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279:

Line 1276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1272: END IF;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279:
1280:

Line 1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279:
1280:
1281: END IF;

Line 1301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1297: Verify_Payment_AT_Booking
1298: (p_header_id => p_header_id
1299: , x_return_status => l_return_status
1300: );
1301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: (p_header_id => p_header_id
1299: , x_return_status => l_return_status
1300: );
1301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306: END IF;

Line 1303: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1299: , x_return_status => l_return_status
1300: );
1301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306: END IF;
1307: ELSE

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300: );
1301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306: END IF;
1307: ELSE
1308: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN

Line 1329: WHEN FND_API.G_EXC_ERROR THEN

1325: -- execution of requests is only towards the end, just before Verify_Payments.
1326: -- If there is an error in between logging and execution of requests,
1327: -- requests were not cleared from the cache earlier resulting
1328: -- in bugs like 2285308.
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: WHEN FND_API.G_EXC_ERROR THEN
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1335: OE_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count
1337: , p_data => x_msg_data

Line 1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1336: ( p_count => x_msg_count
1337: , p_data => x_msg_data
1338: );
1339: ROLLBACK TO BOOK_ORDER;
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: IF l_debug_level > 0 THEN
1342: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: IF l_debug_level > 0 THEN
1342: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1346: OE_MSG_PUB.Count_And_Get
1347: ( p_count => x_msg_count
1348: , p_data => x_msg_data

Line 1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1351: WHEN OTHERS THEN
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1357: IF FND_MSG_PUB.Check_Msg_Level
1358: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1359: THEN

Line 1383: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1379: -- adding a message to the stack.
1380: ---------------------------------------------------------------------
1381: PROCEDURE Complete_Book_Eligible
1382: (p_api_version_number IN NUMBER
1383: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1384: , p_header_id IN NUMBER
1385: , x_return_status OUT NOCOPY VARCHAR2
1386:
1387: , x_msg_count OUT NOCOPY NUMBER

Line 1432: x_return_status := FND_API.G_RET_STS_SUCCESS;

1428: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1429: END IF;
1430:
1431: -- Initialize API return status to success
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;
1433:
1434: -- Standard call to check for call compatibility
1435:
1436: IF NOT FND_API.Compatible_API_Call

Line 1436: IF NOT FND_API.Compatible_API_Call

1432: x_return_status := FND_API.G_RET_STS_SUCCESS;
1433:
1434: -- Standard call to check for call compatibility
1435:
1436: IF NOT FND_API.Compatible_API_Call
1437: ( l_api_version_number
1438: , p_api_version_number
1439: , l_api_name
1440: , G_PKG_NAME

Line 1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1439: , l_api_name
1440: , G_PKG_NAME
1441: )
1442: THEN
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END IF;
1445:
1446: -- Initialize message list.
1447:

Line 1448: IF FND_API.to_Boolean(p_init_msg_list) THEN

1444: END IF;
1445:
1446: -- Initialize message list.
1447:
1448: IF FND_API.to_Boolean(p_init_msg_list) THEN
1449: OE_MSG_PUB.initialize;
1450: END IF;
1451:
1452: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id

Line 1507: RAISE FND_API.G_EXC_ERROR;

1503: IF (booking_errored%FOUND)
1504: THEN
1505: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_ERRORED');
1506: OE_MSG_PUB.ADD;
1507: RAISE FND_API.G_EXC_ERROR;
1508: -- Else the order is NOT eligible for booking: raise an error.
1509: ELSE
1510: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');
1511: OE_MSG_PUB.ADD;

Line 1512: RAISE FND_API.G_EXC_ERROR;

1508: -- Else the order is NOT eligible for booking: raise an error.
1509: ELSE
1510: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');
1511: OE_MSG_PUB.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;
1514: CLOSE booking_errored;
1515: END IF;
1516: END IF;

Line 1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1529: OE_ORDER_UTIL.Lock_Order_Object
1530: (p_header_id => p_header_id
1531: ,x_return_status => x_return_status
1532: );
1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1534: RAISE FND_API.G_EXC_ERROR;
1535: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;

Line 1534: RAISE FND_API.G_EXC_ERROR;

1530: (p_header_id => p_header_id
1531: ,x_return_status => x_return_status
1532: );
1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1534: RAISE FND_API.G_EXC_ERROR;
1535: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:

Line 1535: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1531: ,x_return_status => x_return_status
1532: );
1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1534: RAISE FND_API.G_EXC_ERROR;
1535: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:
1539: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed

Line 1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1532: );
1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1534: RAISE FND_API.G_EXC_ERROR;
1535: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:
1539: -- Call WF_ENGINE to complete the BOOK_ELIGIBLE activity and proceed
1540: -- to the next activity in the order workflow

Line 1606: RAISE FND_API.G_EXC_ERROR;

1602: END IF;
1603: OPEN book_eligible;
1604: FETCH book_eligible INTO l_book_eligible;
1605: IF (book_eligible%FOUND) THEN
1606: RAISE FND_API.G_EXC_ERROR;
1607: END IF;
1608: CLOSE book_eligible;
1609:
1610: END IF;

Line 1626: WHEN FND_API.G_EXC_ERROR THEN

1622: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1623: END IF;
1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: IF (book_eligible%ISOPEN) THEN
1629: CLOSE book_eligible;
1630: END IF;

Line 1627: x_return_status := FND_API.G_RET_STS_ERROR;

1623: END IF;
1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: IF (book_eligible%ISOPEN) THEN
1629: CLOSE book_eligible;
1630: END IF;
1631: OE_MSG_PUB.Count_And_Get

Line 1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1632: ( p_count => x_msg_count
1633: , p_data => x_msg_data
1634: );
1635: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: IF (book_eligible%ISOPEN) THEN
1639: CLOSE book_eligible;
1640: END IF;

Line 1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1633: , p_data => x_msg_data
1634: );
1635: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: IF (book_eligible%ISOPEN) THEN
1639: CLOSE book_eligible;
1640: END IF;
1641: OE_MSG_PUB.Count_And_Get

Line 1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1643: , p_data => x_msg_data
1644: );
1645: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1646: WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF (book_eligible%ISOPEN) THEN
1649: CLOSE book_eligible;
1650: END IF;
1651: IF OE_MSG_PUB.Check_Msg_Level

Line 1683: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1679: -- for booking multi_selected orders.
1680: ---------------------------------------------------------------------
1681: PROCEDURE Book_Multiple_Orders
1682: (p_api_version_number IN NUMBER
1683: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1684: ,p_header_id_list IN OE_GLOBALS.Selected_Record_Tbl
1685: ,p_header_count IN NUMBER
1686: ,x_error_count OUT NOCOPY NUMBER
1687:

Line 1716: x_return_status := FND_API.G_RET_STS_SUCCESS;

1712: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1713: END IF;
1714:
1715: -- Initialize API return status to success
1716: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717: x_error_count := 0;
1718:
1719: -- Standard call to check for call compatibility
1720:

Line 1721: IF NOT FND_API.Compatible_API_Call

1717: x_error_count := 0;
1718:
1719: -- Standard call to check for call compatibility
1720:
1721: IF NOT FND_API.Compatible_API_Call
1722: ( l_api_version_number
1723: , p_api_version_number
1724: , l_api_name
1725: , G_PKG_NAME

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: , l_api_name
1725: , G_PKG_NAME
1726: )
1727: THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:
1731: -- Initialize message list.
1732:

Line 1733: IF FND_API.to_Boolean(p_init_msg_list) THEN

1729: END IF;
1730:
1731: -- Initialize message list.
1732:
1733: IF FND_API.to_Boolean(p_init_msg_list) THEN
1734: OE_MSG_PUB.initialize;
1735: END IF;
1736: initial := 1;
1737: FOR I IN 1..p_header_count LOOP

Line 1770: , p_init_msg_list => FND_API.G_FALSE

1766: WHERE l_header_id=h.header_id;
1767: IF (l_Transaction_Phase_Code='N' ) THEN
1768: OE_Order_Wf_Util.Complete_eligible_and_Book(
1769: p_api_version_number => 1.0
1770: , p_init_msg_list => FND_API.G_FALSE
1771: , p_header_id => l_header_id
1772: , x_return_status => l_return_status
1773: , x_msg_count => l_msg_count
1774: , x_msg_data => l_msg_data );

Line 1778: , p_init_msg_list => FND_API.G_FALSE

1774: , x_msg_data => l_msg_data );
1775: ELSE
1776: OE_Order_Book_Util.Complete_Book_Eligible (
1777: p_api_version_number => 1.0
1778: , p_init_msg_list => FND_API.G_FALSE
1779: , p_header_id => l_header_id
1780: , x_return_status => l_return_status
1781: , x_msg_count => l_msg_count
1782: , x_msg_data => l_msg_data);

Line 1785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1781: , x_msg_count => l_msg_count
1782: , x_msg_data => l_msg_data);
1783: END IF ;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: x_error_count := x_error_count + 1.0;
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1789: x_error_count := x_error_count + 1.0;

Line 1787: x_return_status := FND_API.G_RET_STS_ERROR;

1783: END IF ;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: x_error_count := x_error_count + 1.0;
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1789: x_error_count := x_error_count + 1.0;
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: END IF;

Line 1788: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1784:
1785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: x_error_count := x_error_count + 1.0;
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1789: x_error_count := x_error_count + 1.0;
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: END IF;
1792:

Line 1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1786: x_error_count := x_error_count + 1.0;
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1789: x_error_count := x_error_count + 1.0;
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: END IF;
1792:
1793: initial := nextpos + 1.0;
1794: END LOOP;

Line 1801: WHEN FND_API.G_EXC_ERROR THEN

1797: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: OE_MSG_PUB.Count_And_Get
1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data

Line 1802: x_return_status := FND_API.G_RET_STS_ERROR;

1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: OE_MSG_PUB.Count_And_Get
1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data
1806: );

Line 1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1803: OE_MSG_PUB.Count_And_Get
1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: OE_MSG_PUB.Count_And_Get
1810: ( p_count => x_msg_count
1811: , p_data => x_msg_data

Line 1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: OE_MSG_PUB.Count_And_Get
1810: ( p_count => x_msg_count
1811: , p_data => x_msg_data
1812: );

Line 1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1810: ( p_count => x_msg_count
1811: , p_data => x_msg_data
1812: );
1813: WHEN OTHERS THEN
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF OE_MSG_PUB.Check_Msg_Level
1816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: OE_MSG_PUB.Add_Exc_Msg

Line 1846: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1842: -- Called from the form package OE_ORDER_CONTROL.Book_Order_Button
1843: -- for QA'ing multi_selected orders or just a single order.
1844: PROCEDURE QA_Order
1845: (p_api_version_number IN NUMBER
1846: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1847: ,p_header_id_list IN OUT NOCOPY VARCHAR2
1848: ,p_header_count IN NUMBER
1849: ,x_error_count OUT NOCOPY NUMBER
1850: ,x_return_status OUT NOCOPY VARCHAR2

Line 1882: x_return_status := FND_API.G_RET_STS_SUCCESS;

1878: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);
1879: END IF;
1880:
1881: -- Initialize API return status to success
1882: x_return_status := FND_API.G_RET_STS_SUCCESS;
1883: x_error_count := 0;
1884:
1885: --Check for licensing
1886: IF OE_Contracts_util.check_license() <> 'Y' THEN

Line 1897: IF NOT FND_API.Compatible_API_Call

1893:
1894:
1895: -- Standard call to check for call compatibility
1896:
1897: IF NOT FND_API.Compatible_API_Call
1898: ( l_api_version_number
1899: , p_api_version_number
1900: , l_api_name
1901: , G_PKG_NAME

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: , l_api_name
1901: , G_PKG_NAME
1902: )
1903: THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906:
1907: -- Initialize message list.
1908:

Line 1909: IF FND_API.to_Boolean(p_init_msg_list) THEN

1905: END IF;
1906:
1907: -- Initialize message list.
1908:
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN
1910: OE_MSG_PUB.initialize;
1911: END IF;
1912:
1913: --initialize PL/SQL tables

Line 1969: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1965: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);
1966: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
1967: END IF;
1968:
1969: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1970: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1971: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1972: J := J + 1;
1973: x_error_count := x_error_count + 1.0;

Line 1970: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN

1966: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
1967: END IF;
1968:
1969: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1970: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1971: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1972: J := J + 1;
1973: x_error_count := x_error_count + 1.0;
1974: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1974: x_return_status := FND_API.G_RET_STS_ERROR;

1970: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN
1971: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1972: J := J + 1;
1973: x_error_count := x_error_count + 1.0;
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975:
1976: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1977: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1978: J := J + 1;

Line 1976: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1972: J := J + 1;
1973: x_error_count := x_error_count + 1.0;
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975:
1976: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1977: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1978: J := J + 1;
1979: x_error_count := x_error_count + 1.0;
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1976: ELSIF l_qa_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1977: l_delete_header_id_tbl(J) := I; --keep track of which header id to delete later
1978: J := J + 1;
1979: x_error_count := x_error_count + 1.0;
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1981:
1982: END IF;
1983:
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1981:
1982: END IF;
1983:
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END IF;

Line 1985: RAISE FND_API.G_EXC_ERROR;

1981:
1982: END IF;
1983:
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END IF;
1989:

Line 1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1982: END IF;
1983:
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END IF;
1989:
1990:

Line 1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1983:
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END IF;
1989:
1990:
1991: END LOOP;

Line 2044: WHEN FND_API.G_EXC_ERROR THEN

2040: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
2041: END IF;
2042:
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: OE_MSG_PUB.Count_And_Get
2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data

Line 2045: x_return_status := FND_API.G_RET_STS_ERROR;

2041: END IF;
2042:
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: OE_MSG_PUB.Count_And_Get
2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data
2049: );

Line 2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2046: OE_MSG_PUB.Count_And_Get
2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data
2049: );
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052: OE_MSG_PUB.Count_And_Get
2053: ( p_count => x_msg_count
2054: , p_data => x_msg_data

Line 2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data
2049: );
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052: OE_MSG_PUB.Count_And_Get
2053: ( p_count => x_msg_count
2054: , p_data => x_msg_data
2055: );

Line 2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2053: ( p_count => x_msg_count
2054: , p_data => x_msg_data
2055: );
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: IF OE_MSG_PUB.Check_Msg_Level
2059: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2060: THEN
2061: OE_MSG_PUB.Add_Exc_Msg