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

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157:
158: IF l_debug_level > 0 THEN
159: OE_DEBUG_PUB.Add('Order header Id:'||p_header_id,1);
160: END IF;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Validating Order
164: -- transactional curr code is also selected
165: BEGIN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: WHEN NO_DATA_FOUND THEN
172: IF l_debug_level > 0 THEN
173: OE_DEBUG_PUB.Add('No Data Found when Validating Order',3);
174: END IF;
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: WHEN OTHERS THEN
177: IF l_debug_level > 0 THEN
178: OE_DEBUG_PUB.Add('When Others when Validating Order',3);
179: END IF;

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: WHEN OTHERS THEN
177: IF l_debug_level > 0 THEN
178: OE_DEBUG_PUB.Add('When Others when Validating Order',3);
179: END IF;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END;
182:
183: IF l_open_flag = 'N' OR l_order_category_code = 'RETURN' THEN
184: IF l_debug_level > 0 THEN

Line 187: RAISE FND_API.G_EXC_ERROR ;

183: IF l_open_flag = 'N' OR l_order_category_code = 'RETURN' THEN
184: IF l_debug_level > 0 THEN
185: OE_DEBUG_PUB.Add('Order is Return/Closed',1);
186: END IF;
187: RAISE FND_API.G_EXC_ERROR ;
188: END IF;
189:
190:
191: -- We need to create the included items if not already frozen.

Line 211: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

207: OE_DEBUG_PUB.Add('After Calling Process Included Items: '||
208: x_return_status,3);
209: END IF;
210:
211: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: x_return_status,3);
209: END IF;
210:
211: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
216:

Line 213: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

209: END IF;
210:
211: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
216:
217: END LOOP;

Line 214: RAISE FND_API.G_EXC_ERROR;

210:
211: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
216:
217: END LOOP;
218:

Line 554: --l_return_status = FND_API.G_RET_STS_ERROR;

550: OE_MSG_PUB.Add;
551: IF l_debug_level > 0 THEN
552: OE_DEBUG_PUB.Add('No lines of the order are eligible for freight rating');
553: END IF; -- bug 7433107
554: --l_return_status = FND_API.G_RET_STS_ERROR;
555: RAISE FND_API.G_EXC_ERROR;
556: -- END IF; -- bug 7433107
557: END IF;
558:

Line 555: RAISE FND_API.G_EXC_ERROR;

551: IF l_debug_level > 0 THEN
552: OE_DEBUG_PUB.Add('No lines of the order are eligible for freight rating');
553: END IF; -- bug 7433107
554: --l_return_status = FND_API.G_RET_STS_ERROR;
555: RAISE FND_API.G_EXC_ERROR;
556: -- END IF; -- bug 7433107
557: END IF;
558:
559: IF l_debug_level > 0 THEN

Line 573: WHEN FND_API.G_EXC_ERROR THEN

569:
570: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');
571: EXCEPTION
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.Add('Expected Error in Create FTE Input',2);
576: END IF;
577:

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574: IF l_debug_level > 0 THEN
575: oe_debug_pub.Add('Expected Error in Create FTE Input',2);
576: END IF;
577:
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

576: END IF;
577:
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);
583: END IF;
584:

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581: IF l_debug_level > 0 THEN
582: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);
583: END IF;
584:
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586:
587:
588: WHEN OTHERS THEN
589:

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

586:
587:
588: WHEN OTHERS THEN
589:
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591:
592: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: OE_MSG_PUB.Add_Exc_Msg

Line 643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

639: );
640:
641: x_return_status := l_return_status;
642:
643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

640:
641: x_return_status := l_return_status;
642:
643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

641: x_return_status := l_return_status;
642:
643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
649: IF l_debug_level > 0 THEN

Line 648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.Add(l_msg_text, 3);
651: END IF;
652: oe_msg_pub.add_text(p_message_text => l_msg_text);

Line 655: RAISE FND_API.G_EXC_ERROR;

651: END IF;
652: oe_msg_pub.add_text(p_message_text => l_msg_text);
653: END LOOP;
654: END IF;
655: RAISE FND_API.G_EXC_ERROR;
656: END IF;
657:
658: --x_shipment_count := 15;
659:

Line 685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

681: l_return_status,3);
682: --x_shipment_count := 15;
683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

682: --x_shipment_count := 15;
683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
691: IF l_debug_level > 0 THEN

Line 690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.Add(l_msg_text, 3);
693: END IF;
694: oe_msg_pub.add_text(p_message_text => l_msg_text);

Line 697: RAISE FND_API.G_EXC_ERROR;

693: END IF;
694: oe_msg_pub.add_text(p_message_text => l_msg_text);
695: END LOOP;
696: END IF;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: g_line_tbl := l_line_tbl;
701: g_fte_source_line_tab := l_fte_source_line_tab;

Line 742: WHEN FND_API.G_EXC_ERROR THEN

738: oe_debug_pub.add('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary');
739:
740: EXCEPTION
741:
742: WHEN FND_API.G_EXC_ERROR THEN
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.Add('Expected Error in Get Shipment Summary',2);
745: END IF;
746:

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792:
793: IF l_debug_level > 0 THEN
794: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
795: END IF;
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: select oe_price_adjustments_s.nextval into l_price_adjustment_id
799: from dual;
800:

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

826: END IF;
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;
833: END IF;
834: IF l_debug_level > 0 THEN

Line 1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1013: oe_debug_pub.Add('After Calling FTE Process Lines:'||
1014: l_return_status,3);
1015: END IF;
1016:
1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: l_return_status,3);
1015: END IF;
1016:
1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1015: END IF;
1016:
1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1023: IF l_debug_level > 0 THEN

Line 1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.Add(l_msg_text, 3);
1025: END IF;
1026: oe_msg_pub.add_text(p_message_text => l_msg_text);

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: END IF;
1026: oe_msg_pub.add_text(p_message_text => l_msg_text);
1027: END LOOP;
1028: END IF;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: g_line_shipment_details_tbl := l_fte_source_line_tab;
1033:

Line 1224: x_return_status := FND_API.G_RET_STS_SUCCESS;

1220: --This Global table is used in Procedure Process_Freight_Choices
1221:
1222: END IF; --if l_fte_source_line_tab.count > 0
1223:
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225:
1226: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Freight_Choices...');
1227:
1228: EXCEPTION

Line 1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Freight_Choices...');
1227:
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'ERROR IN PROCEDURE Get_Freight_Choices: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;
1233: END IF;
1234: IF l_debug_level > 0 THEN

Line 1725: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1721:
1722: --l_line_tbl.operation := OE_GLOBALS.G_OPR_UPDATE;
1723:
1724: OE_ORDER_PVT.Lines
1725: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1726: ,p_control_rec => l_control_rec
1727: ,p_x_line_tbl => l_line_tbl
1728: ,p_x_old_line_tbl => l_old_line_tbl
1729: ,x_return_status => x_return_status);

Line 1770: WHEN FND_API.G_EXC_ERROR THEN

1766: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Process_Freight_Choices...');
1767:
1768: EXCEPTION
1769:
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.Add('Expected Error in Process Freight Choices', 1);
1773: END IF;
1774:

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.Add('Expected Error in Process Freight Choices', 1);
1773: END IF;
1774:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776:
1777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1778: IF l_debug_level > 0 THEN
1779: oe_debug_pub.Add('Unexpected Error in Process Freight Choices'||

Line 1777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1773: END IF;
1774:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776:
1777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1778: IF l_debug_level > 0 THEN
1779: oe_debug_pub.Add('Unexpected Error in Process Freight Choices'||
1780: sqlerrm, 2);
1781: END IF;

Line 1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1778: IF l_debug_level > 0 THEN
1779: oe_debug_pub.Add('Unexpected Error in Process Freight Choices'||
1780: sqlerrm, 2);
1781: END IF;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783:
1784: WHEN OTHERS THEN
1785:
1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783:
1784: WHEN OTHERS THEN
1785:
1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787:
1788: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: OE_MSG_PUB.Add_Exc_Msg