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

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
28: --
29: BEGIN
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: INSERT INTO OE_PRICE_ADJUSTMENTS
34: (PRICE_ADJUSTMENT_ID
35: ,CREATION_DATE

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: END IF;
264: OE_BULK_MSG_PUB.Add_Exc_Msg
265: (G_PKG_NAME
266: ,'Insert_Adjustments');
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: END Insert_Adjustments;
269:
270:
271: ---------------------------------------------------------------------

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
316: --
317: BEGIN
318:
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: -- Set this global so that pricing integration will not fire security
322: -- checks for update of pricing fields back on order lines.
323: OE_GLOBALS.G_HEADER_CREATED := TRUE;

Line 387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

383: ,p_action_code => 'PRICE_ORDER'
384: ,x_line_Tbl => l_Line_Tbl
385: );
386:
387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: );
386:
387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
392: -- Mark the header for error
393: mark_header_error(i, p_header_rec);

Line 390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

386:
387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
392: -- Mark the header for error
393: mark_header_error(i, p_header_rec);
394: p_header_rec.lock_control(i) := -99;

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
392: -- Mark the header for error
393: mark_header_error(i, p_header_rec);
394: p_header_rec.lock_control(i) := -99;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396: END IF;
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN

Line 399: WHEN FND_API.G_EXC_ERROR THEN

395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396: END IF;
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: IF l_debug_level > 0 then
401: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
402: End if;
403: mark_header_error(i,p_header_rec);

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

401: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
402: End if;
403: mark_header_error(i,p_header_rec);
404: p_header_rec.lock_control(i) := -99;
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: WHEN OTHERS THEN
408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('Unexp Error in Pricing:'||l_header_id|| ' '||SqlErrm, 1);

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: WHEN OTHERS THEN
408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('Unexp Error in Pricing:'||l_header_id|| ' '||SqlErrm, 1);
410: End if;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END;
414:
415: END IF; -- IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED = --bug 455807

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('Unexp Error in Pricing:'||l_header_id|| ' '||SqlErrm, 1);
410: End if;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END;
414:
415: END IF; -- IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED = --bug 455807
416:

Line 536: , p_delayed_request=> FND_API.G_FALSE

532: -- Call the Credit checking API
533: OE_Verify_Payment_PUB.Verify_Payment
534: ( p_header_id => p_header_rec.header_id(i)
535: , p_calling_action => 'BOOKING'
536: , p_delayed_request=> FND_API.G_FALSE
537: , p_msg_count => l_msg_count
538: , p_msg_data => l_msg_data
539: , p_return_status => l_return_status
540: );

Line 541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

537: , p_msg_count => l_msg_count
538: , p_msg_data => l_msg_data
539: , p_return_status => l_return_status
540: );
541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
542:
543: Booking_Failed( i, p_header_rec);
544:
545: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC

Line 545: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC

541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
542:
543: Booking_Failed( i, p_header_rec);
544:
545: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC
546:
547: END IF; -- IF OE_BULK_CACHE.IS_CC_REQUIRED(p_head
548:
549: END IF; -- IF OE_BULK_ORDER_PVT.G_CC_REQUIRED --bug 455807

Line 610: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

606: ,p_action_code => 'PRICE_ORDER'
607: ,x_line_Tbl => l_Line_Tbl
608: );
609:
610: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
611: OR x_return_status = FND_API.G_RET_STS_ERROR )
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;

Line 611: OR x_return_status = FND_API.G_RET_STS_ERROR )

607: ,x_line_Tbl => l_Line_Tbl
608: );
609:
610: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
611: OR x_return_status = FND_API.G_RET_STS_ERROR )
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615:

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609:
610: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
611: OR x_return_status = FND_API.G_RET_STS_ERROR )
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615:
616: END IF; -- IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED =
617:

Line 736: , p_delayed_request=> FND_API.G_FALSE

732: -- Call the Credit checking API
733: OE_Verify_Payment_PUB.Verify_Payment
734: ( p_header_id => p_header_rec.header_id(i)
735: , p_calling_action => 'BOOKING'
736: , p_delayed_request=> FND_API.G_FALSE
737: , p_msg_count => l_msg_count
738: , p_msg_data => l_msg_data
739: , p_return_status => l_return_status
740: );

Line 741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

737: , p_msg_count => l_msg_count
738: , p_msg_data => l_msg_data
739: , p_return_status => l_return_status
740: );
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742:
743: Booking_Failed( i, p_header_rec);
744: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC
745:

Line 744: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC

740: );
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742:
743: Booking_Failed( i, p_header_rec);
744: END IF; --IF l_return_status <> FND_API.G_RET_STS_SUCC
745:
746: END IF; -- IF OE_BULK_CACHE.IS_CC_REQUIRED(p_head
747:
748: END IF; -- IF p_header_rec.booked_flag = 'Y'

Line 761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

757:
758: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: WHEN OTHERS THEN
765: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: WHEN OTHERS THEN
765: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
766: OE_BULK_MSG_PUB.Add_Exc_Msg
767: (G_PKG_NAME

Line 769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

765: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
766: OE_BULK_MSG_PUB.Add_Exc_Msg
767: (G_PKG_NAME
768: ,'Price_Orders');
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: END Price_Orders;
771:
772: --bug 455807 This procedure has been added
773: PROCEDURE Booking_Failed(p_index IN NUMBER,