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 553: --l_return_status = FND_API.G_RET_STS_ERROR;

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

Line 554: RAISE FND_API.G_EXC_ERROR;

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

Line 572: WHEN FND_API.G_EXC_ERROR THEN

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

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 642: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 644: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 654: RAISE FND_API.G_EXC_ERROR;

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

Line 684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 696: RAISE FND_API.G_EXC_ERROR;

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

Line 741: WHEN FND_API.G_EXC_ERROR THEN

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

Line 795: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 1028: RAISE FND_API.G_EXC_ERROR;

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

Line 1223: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1724: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 1769: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1774: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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