DBA Data[Home] [Help]

APPS.OE_FREIGHT_CHOICES_PVT dependencies on OE_FREIGHT_CHOICES_PVT

Line 1: PACKAGE BODY OE_FREIGHT_CHOICES_PVT AS

1: PACKAGE BODY OE_FREIGHT_CHOICES_PVT AS
2: /* $Header: OEXVFCHB.pls 120.4.12010000.5 2008/11/14 23:11:03 rbadadar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_FREIGHT_CHOICES_PVT';
5: G_config_count NUMBER;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_FREIGHT_CHOICES_PVT';

1: PACKAGE BODY OE_FREIGHT_CHOICES_PVT AS
2: /* $Header: OEXVFCHB.pls 120.4.12010000.5 2008/11/14 23:11:03 rbadadar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_FREIGHT_CHOICES_PVT';
5: G_config_count NUMBER;
6: --G_line_tbl OE_Order_PUB.Line_Tbl_Type;
7:
8: TYPE number_type is table of number index by binary_integer;

Line 156: Print_Time('Entering OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');

152: l_line_rec OE_ORDER_PUB.line_rec_type :=
153: OE_Order_Pub.G_MISS_LINE_REC;
154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
155: BEGIN
156: Print_Time('Entering OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');
157:
158: IF l_debug_level > 0 THEN
159: OE_DEBUG_PUB.Add('Order header Id:'||p_header_id,1);
160: END IF;

Line 569: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');

565: oe_debug_pub.Add('Shedule Ship Date Value .. '||G_Ship_Date_tbl(i).Schedule_Ship_Date);
566: end if;
567: end loop;
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

Line 736: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary...');

732: x_shipment_count := g_shipment_summary_tbl.count;
733:
734: End If; -- l_fte_source_line_tab.Count > 0
735: --oe_debug_pub.add('Before print time');
736: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary...');
737: oe_debug_pub.add('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary');
738:
739: EXCEPTION
740:

Line 737: oe_debug_pub.add('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary');

733:
734: End If; -- l_fte_source_line_tab.Count > 0
735: --oe_debug_pub.add('Before print time');
736: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Summary...');
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

Line 1225: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Freight_Choices...');

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
1228: WHEN OTHERS THEN
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1266: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Freight_Choices_Tbl...');

1262: x_freight_choices_tbl(i).lane_id := g_freight_choices_tbl(i).lane_id; --bug 4408958
1263:
1264: END LOOP;
1265:
1266: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Freight_Choices_Tbl...');
1267:
1268: END Get_Freight_Choices_Tbl;
1269:
1270:

Line 1289: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Details_Tbl...');

1285: x_Line_Shipment_Details_tbl(i).arrival_date := g_line_shipment_details_tbl(i).arrival_date;
1286:
1287: END LOOP;
1288:
1289: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Get_Shipment_Details_Tbl...');
1290:
1291: END Get_Shipment_Details_Tbl;
1292:
1293: --Bug 6186084

Line 1322: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;

1318: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1319: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1320: IS
1321:
1322: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;
1323: l_fte_line_rate_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab;
1324: l_fte_rates_rec FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_rec;
1325: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1326: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;

Line 1765: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Process_Freight_Choices...');

1761: IF l_debug_level > 0 THEN
1762: OE_DEBUG_PUB.Add('After Calling Process Requests and Notify...'|| x_return_status,3);
1763: END IF;
1764:
1765: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Process_Freight_Choices...');
1766:
1767: EXCEPTION
1768:
1769: WHEN FND_API.G_EXC_ERROR THEN

Line 1810: END OE_FREIGHT_CHOICES_PVT;

1806: EXCEPTION WHEN NO_SAVEPOINT THEN
1807: Null;
1808: End Cancel_all;
1809:
1810: END OE_FREIGHT_CHOICES_PVT;