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

Line 49: l_header_id = FND_API.G_MISS_NUM

45: l_header_id := oe_line_security.g_record.header_id;
46: END IF;
47:
48: IF l_header_id IS NULL OR
49: l_header_id = FND_API.G_MISS_NUM
50: THEN
51: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
52: p_result := 0;
53: END IF;

Line 120: l_header_id = FND_API.G_MISS_NUM

116:
117: -- 3726282 Added the outer If loop alone
118: IF p_validation_entity_short_name in ('HEADER','LINE') THEN
119: IF l_header_id IS NULL OR
120: l_header_id = FND_API.G_MISS_NUM
121: THEN
122: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
123: p_result := 0;
124: ELSE

Line 566: l_return_status := FND_API.G_RET_STS_SUCCESS;

562: END IF;
563: fnd_file.put_line(FND_FILE.OUTPUT, 'Pack H or above must be installed to use this concurrent program');
564: RETURN;
565: END IF;
566: l_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: IF p_ppp_hold = 'N' THEN
569: l_hold1 := 0 ;
570: END IF;

Line 744: IF l_return_status = FND_API.G_RET_STS_ERROR OR

740: oe_debug_pub.add( 'AFTER CALLING VERIFY_PAYMENT , L_RETURN_STATUS: '||L_RETURN_STATUS ) ;
741: END IF;
742: END IF;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR OR
745: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
746: THEN
747: l_count_header_failure := l_count_header_failure + 1;
748: ELSE

Line 745: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

741: END IF;
742: END IF;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR OR
745: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
746: THEN
747: l_count_header_failure := l_count_header_failure + 1;
748: ELSE
749: --bug 4967981 start

Line 760: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

756: END IF;
757: --bug 4967981 end
758: END IF;
759:
760: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'UNEXPECTED ERROR' ) ;
763: END IF;
764: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);

Line 765: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'UNEXPECTED ERROR' ) ;
763: END IF;
764: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
765: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( 'EXPECTED ERROR' ) ;
769: END IF;

Line 766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

762: oe_debug_pub.add( 'UNEXPECTED ERROR' ) ;
763: END IF;
764: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
765: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( 'EXPECTED ERROR' ) ;
769: END IF;
770: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);

Line 771: -- RAISE FND_API.G_EXC_ERROR;

767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( 'EXPECTED ERROR' ) ;
769: END IF;
770: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
771: -- RAISE FND_API.G_EXC_ERROR;
772: END IF;
773:
774: -- releasing the holds.
775: -- commented out for bug 4967981

Line 777: IF l_return_status = FND_API.G_RET_STS_SUCCESS

773:
774: -- releasing the holds.
775: -- commented out for bug 4967981
776: /***
777: IF l_return_status = FND_API.G_RET_STS_SUCCESS
778: AND IS_MULTIPLE_PAYMENTS_ENABLED THEN
779:
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'OEXUPPYB: releasing payment hold.' ) ;

Line 793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

789: , p_msg_data => l_msg_data
790: , p_return_status => l_return_status
791: );
792:
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;

Line 794: RAISE FND_API.G_EXC_ERROR;

790: , p_return_status => l_return_status
791: );
792:
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: END IF;

Line 795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

791: );
792:
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: END IF;
799:

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

792:
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: END IF;
799:
800: IF p_epay_failure_hold = 'Y' THEN

Line 809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

805: , p_msg_data => l_msg_data
806: , p_return_status => l_return_status
807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;

Line 810: RAISE FND_API.G_EXC_ERROR;

806: , p_return_status => l_return_status
807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: END IF;

Line 811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: END IF;
815:

Line 812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: END IF;
815:
816: IF p_epay_server_failure_hold = 'Y' THEN

Line 825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

821: , p_msg_data => l_msg_data
822: , p_return_status => l_return_status
823: );
824:
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;

Line 826: RAISE FND_API.G_EXC_ERROR;

822: , p_return_status => l_return_status
823: );
824:
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;

Line 827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

823: );
824:
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831:

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824:
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831:
832: IF p_payment_authorization_hold = 'Y' THEN

Line 841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

837: , p_msg_data => l_msg_data
838: , p_return_status => l_return_status
839: );
840:
841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
845: END IF;

Line 842: RAISE FND_API.G_EXC_ERROR;

838: , p_return_status => l_return_status
839: );
840:
841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
845: END IF;
846: END IF;

Line 843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

839: );
840:
841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
845: END IF;
846: END IF;
847: END IF;

Line 844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

840:
841: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
845: END IF;
846: END IF;
847: END IF;
848: ***/ -- end of bug 4967981

Line 907: WHEN FND_API.G_EXC_ERROR THEN

903: END IF;
904: --rollback;
905: EXCEPTION
906:
907: WHEN FND_API.G_EXC_ERROR THEN
908: l_return_status := FND_API.G_RET_STS_ERROR ;
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
911: END IF;

Line 908: l_return_status := FND_API.G_RET_STS_ERROR ;

904: --rollback;
905: EXCEPTION
906:
907: WHEN FND_API.G_EXC_ERROR THEN
908: l_return_status := FND_API.G_RET_STS_ERROR ;
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
911: END IF;
912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

918: ( p_count => l_msg_count,
919: p_data => l_msg_data
920: );
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: OE_MSG_PUB.Count_And_Get
925: ( p_count => l_msg_count,
926: p_data => l_msg_data

Line 923: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

919: p_data => l_msg_data
920: );
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: OE_MSG_PUB.Count_And_Get
925: ( p_count => l_msg_count,
926: p_data => l_msg_data
927: );

Line 1322: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1318: p_action in varchar2,
1319: x_return_status out nocopy varchar2,
1320: x_msg_count out nocopy number,
1321: x_msg_data out nocopy varchar2) IS
1322: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1323: BEGIN
1324:
1325: x_return_status := l_return_status;
1326:

Line 1430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1426: x_msg_data => l_msg_data );
1427:
1428: oe_debug_pub.add('after calling AR');
1429:
1430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1431: NULL;
1432: oe_debug_pub.add('return status is failure ');
1433: l_downpayment := 0;
1434: --RAISE FORM_TRIGGER_FAILURE;

Line 1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1530: RETURN l_installment_options;
1531:
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: END Get_Installment_Options;
1536:
1537: -- This procedure needs to be called only when the system parameter 'Installment Options' is set to 'ENABLE_PAY_NOW'
1538: Function Is_Pay_Now_Line (p_line_id IN NUMBER) RETURN BOOLEAN

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

1545: l_pay_now_total NUMBER := 0;
1546: l_pay_now_commitment NUMBER :=0;
1547: l_msg_count NUMBER;
1548: l_msg_data VARCHAR2(2000);
1549: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
1550: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1551:
1552: BEGIN
1553: BEGIN

Line 1579: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1575: ,x_msg_data => l_msg_data
1576: ,x_return_status => l_return_status
1577: );
1578:
1579: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1580: IF l_debug_level > 0 THEN
1581: oe_debug_pub.add('OE_Prepayment_PVT.Get_Pay_Now_Amounts returned with errors');
1582: END IF;
1583: RETURN FALSE;