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.9 2010/07/23 07:43:12 spothula 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.9 2010/07/23 07:43:12 spothula 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 570: Print_Time('Exiting OE_FREIGHT_CHOICES_PVT.Prepare_Freight_Choices_Input...');

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

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

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

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

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

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

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

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

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

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

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

Line 1323: l_freight_choices_rec OE_Freight_Choices_PVT.Freight_Choices_Rec_type;

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

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

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

Line 1811: END OE_FREIGHT_CHOICES_PVT;

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