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 OE_DEBUG_PUB

Line 29: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

25:
26: PROCEDURE Print_Time(p_msg IN VARCHAR2)
27: IS
28: l_time VARCHAR2(100);
29: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
30: BEGIN
31: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
32: 'DD-MON-YY HH24:MI:SS');
33: IF l_debug_level > 0 THEN

Line 34: OE_DEBUG_PUB.Add(p_msg || ': '|| l_time, 1);

30: BEGIN
31: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
32: 'DD-MON-YY HH24:MI:SS');
33: IF l_debug_level > 0 THEN
34: OE_DEBUG_PUB.Add(p_msg || ': '|| l_time, 1);
35: END IF;
36: END Print_Time;
37:
38:

Line 154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

150: l_transactional_curr_code VARCHAR2(15);
151: l_conversion_type_code VARCHAR2(30);
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

Line 159: OE_DEBUG_PUB.Add('Order header Id:'||p_header_id,1);

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;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Validating Order

Line 173: OE_DEBUG_PUB.Add('No Data Found when Validating Order',3);

169: WHERE header_id = p_header_id;
170: EXCEPTION
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

Line 178: OE_DEBUG_PUB.Add('When Others 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;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END;
182:

Line 185: OE_DEBUG_PUB.Add('Order is Return/Closed',1);

181: END;
182:
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:

Line 198: OE_DEBUG_PUB.Add('Calling Process Included Items for Line:'||

194:
195: FOR c_inc_parent IN C_INC_ITEMS_PARENT
196: LOOP
197: IF l_debug_level > 0 THEN
198: OE_DEBUG_PUB.Add('Calling Process Included Items for Line:'||
199: c_inc_parent.line_id,3);
200: END IF;
201:
202: x_return_status := OE_CONFIG_UTIL.Process_Included_Items

Line 207: OE_DEBUG_PUB.Add('After Calling Process Included Items: '||

203: (p_line_id => c_inc_parent.line_id
204: ,p_freeze => FALSE);
205:
206: IF l_debug_level > 0 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

Line 236: OE_DEBUG_PUB.Add('Config Line Count:'||l_config_count,3);

232: AND ato_line_id IS NOT NULL
233: AND header_id = p_header_id;
234:
235: IF l_debug_level > 0 THEN
236: OE_DEBUG_PUB.Add('Config Line Count:'||l_config_count,3);
237: END IF;
238:
239: x_config_count := l_config_count;
240: l_line_count := l_config_count;

Line 278: OE_DEBUG_PUB.Add('Line is External/Service/Return:'||

274: FND_MESSAGE.Set_Name('ONT','ONT_FTE_EXTERNAL_RET_SERVICE');
275: OE_MSG_PUB.Add;
276:
277: IF l_debug_level > 0 THEN
278: OE_DEBUG_PUB.Add('Line is External/Service/Return:'||
279: c_ship_method.line_id ,3);
280: END IF;
281:
282: ELSIF c_ship_method.ship_from_org_id IS NULL THEN

Line 287: OE_DEBUG_PUB.Add('Line is Missing Ship From Org Id:'||

283:
284: FND_MESSAGE.Set_Name('ONT','ONT_FTE_MISSING_SHIP_FROM');
285: OE_MSG_PUB.Add;
286: IF l_debug_level > 0 THEN
287: OE_DEBUG_PUB.Add('Line is Missing Ship From Org Id:'||
288: c_ship_method.line_id ,3);
289: END IF;
290:
291: ELSIF c_ship_method.ship_to_org_id IS NULL THEN

Line 296: OE_DEBUG_PUB.Add('Line is Missing Ship To Org Id:'||

292:
293: FND_MESSAGE.Set_Name('ONT','ONT_FTE_MISSING_SHIP_TO');
294: OE_MSG_PUB.Add;
295: IF l_debug_level > 0 THEN
296: OE_DEBUG_PUB.Add('Line is Missing Ship To Org Id:'||
297: c_ship_method.line_id ,3);
298: END IF;
299:
300: ELSIF c_ship_method.shipped_quantity IS NOT NULL OR

Line 307: OE_DEBUG_PUB.Add('Line is Shipped/Fulfilled/Closed:'||

303:
304: FND_MESSAGE.Set_Name('ONT','ONT_FTE_SHIP_FULFILL_CLOSED');
305: OE_MSG_PUB.Add;
306: IF l_debug_level > 0 THEN
307: OE_DEBUG_PUB.Add('Line is Shipped/Fulfilled/Closed:'||
308: c_ship_method.line_id ,1);
309: END IF;
310: ELSIF c_ship_method.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
311:

Line 315: OE_DEBUG_PUB.Add('Config Line:'||c_ship_method.line_id,3);

311:
312: -- We are not going to send Config lines to FTE
313: -- We have to store the config lines in the line table.
314: IF l_debug_level > 0 THEN
315: OE_DEBUG_PUB.Add('Config Line:'||c_ship_method.line_id,3);
316: END IF;
317:
318: l_line_rec.line_id := c_ship_method.line_id;
319: l_line_rec.ato_line_id := c_ship_method.ato_line_id;

Line 330: OE_DEBUG_PUB.Add('Excluding Config Line from FTE Input:'||

326: l_config_count := l_config_count + 1;
327:
328: p_x_line_tbl(l_config_count) := l_line_rec;
329: IF l_debug_level > 0 THEN
330: OE_DEBUG_PUB.Add('Excluding Config Line from FTE Input:'||
331: c_ship_method.line_id ,1);
332: END IF;
333: ELSE
334: IF l_debug_level > 0 THEN

Line 335: OE_DEBUG_PUB.Add('Sending Eligibile Line to FTE:'||

331: c_ship_method.line_id ,1);
332: END IF;
333: ELSE
334: IF l_debug_level > 0 THEN
335: OE_DEBUG_PUB.Add('Sending Eligibile Line to FTE:'||
336: c_ship_method.line_id ,1);
337: END IF;
338:
339: -- Increment the FTE line table count

Line 461: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);

457: c_ship_method.item_type_code = 'INCLUDED') AND --9775352
458: c_ship_method.ato_line_id = c_ship_method.line_id)
459: THEN
460: IF l_debug_level > 0 THEN
461: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);
462: END IF;
463: ELSE
464: IF l_debug_level > 0 THEN
465: OE_DEBUG_PUB.Add('do not calculate freight_rating '||

Line 465: OE_DEBUG_PUB.Add('do not calculate freight_rating '||

461: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);
462: END IF;
463: ELSE
464: IF l_debug_level > 0 THEN
465: OE_DEBUG_PUB.Add('do not calculate freight_rating '||
466: c_ship_method.line_id, 1);
467: END IF;
468: p_x_fte_source_line_tab(l_count).freight_rating_flag:= 'N';
469: END IF;

Line 474: oe_debug_pub.Add('--------- Input to FTE --------',3);

470:
471: END IF;
472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.Add('--------- Input to FTE --------',3);
475:
476: oe_debug_pub.Add('Source Line :'||
477: p_x_fte_source_line_tab(l_count).source_line_id,3);
478:

Line 476: oe_debug_pub.Add('Source Line :'||

472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.Add('--------- Input to FTE --------',3);
475:
476: oe_debug_pub.Add('Source Line :'||
477: p_x_fte_source_line_tab(l_count).source_line_id,3);
478:
479: oe_debug_pub.Add('Ship From Org :'||
480: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);

Line 479: oe_debug_pub.Add('Ship From Org :'||

475:
476: oe_debug_pub.Add('Source Line :'||
477: p_x_fte_source_line_tab(l_count).source_line_id,3);
478:
479: oe_debug_pub.Add('Ship From Org :'||
480: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);
481:
482: oe_debug_pub.Add('Customer :'||
483: p_x_fte_source_line_tab(l_count).customer_id,3);

Line 482: oe_debug_pub.Add('Customer :'||

478:
479: oe_debug_pub.Add('Ship From Org :'||
480: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);
481:
482: oe_debug_pub.Add('Customer :'||
483: p_x_fte_source_line_tab(l_count).customer_id,3);
484:
485: oe_debug_pub.Add('Inventory Item :'||
486: p_x_fte_source_line_tab(l_count).inventory_item_id,3);

Line 485: oe_debug_pub.Add('Inventory Item :'||

481:
482: oe_debug_pub.Add('Customer :'||
483: p_x_fte_source_line_tab(l_count).customer_id,3);
484:
485: oe_debug_pub.Add('Inventory Item :'||
486: p_x_fte_source_line_tab(l_count).inventory_item_id,3);
487:
488: oe_debug_pub.Add('Source Quantity :'||
489: p_x_fte_source_line_tab(l_count).source_quantity,3);

Line 488: oe_debug_pub.Add('Source Quantity :'||

484:
485: oe_debug_pub.Add('Inventory Item :'||
486: p_x_fte_source_line_tab(l_count).inventory_item_id,3);
487:
488: oe_debug_pub.Add('Source Quantity :'||
489: p_x_fte_source_line_tab(l_count).source_quantity,3);
490:
491: oe_debug_pub.Add('Ship Date :'||
492: p_x_fte_source_line_tab(l_count).ship_date,3);

Line 491: oe_debug_pub.Add('Ship Date :'||

487:
488: oe_debug_pub.Add('Source Quantity :'||
489: p_x_fte_source_line_tab(l_count).source_quantity,3);
490:
491: oe_debug_pub.Add('Ship Date :'||
492: p_x_fte_source_line_tab(l_count).ship_date,3);
493:
494: oe_debug_pub.Add('Delivery Lead Time :'||
495: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);

Line 494: oe_debug_pub.Add('Delivery Lead Time :'||

490:
491: oe_debug_pub.Add('Ship Date :'||
492: p_x_fte_source_line_tab(l_count).ship_date,3);
493:
494: oe_debug_pub.Add('Delivery Lead Time :'||
495: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);
496:
497: oe_debug_pub.Add('Scheduled :'||
498: p_x_fte_source_line_tab(l_count).scheduled_flag,3);

Line 497: oe_debug_pub.Add('Scheduled :'||

493:
494: oe_debug_pub.Add('Delivery Lead Time :'||
495: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);
496:
497: oe_debug_pub.Add('Scheduled :'||
498: p_x_fte_source_line_tab(l_count).scheduled_flag,3);
499:
500: oe_debug_pub.Add('Order Set Type :'||
501: p_x_fte_source_line_tab(l_count).order_set_type,3);

Line 500: oe_debug_pub.Add('Order Set Type :'||

496:
497: oe_debug_pub.Add('Scheduled :'||
498: p_x_fte_source_line_tab(l_count).scheduled_flag,3);
499:
500: oe_debug_pub.Add('Order Set Type :'||
501: p_x_fte_source_line_tab(l_count).order_set_type,3);
502:
503: oe_debug_pub.Add('Order Set :'||
504: p_x_fte_source_line_tab(l_count).order_set_id,3);

Line 503: oe_debug_pub.Add('Order Set :'||

499:
500: oe_debug_pub.Add('Order Set Type :'||
501: p_x_fte_source_line_tab(l_count).order_set_type,3);
502:
503: oe_debug_pub.Add('Order Set :'||
504: p_x_fte_source_line_tab(l_count).order_set_id,3);
505:
506: oe_debug_pub.Add('Ship Method :'||
507: p_x_fte_source_line_tab(l_count).ship_method_code,3);

Line 506: oe_debug_pub.Add('Ship Method :'||

502:
503: oe_debug_pub.Add('Order Set :'||
504: p_x_fte_source_line_tab(l_count).order_set_id,3);
505:
506: oe_debug_pub.Add('Ship Method :'||
507: p_x_fte_source_line_tab(l_count).ship_method_code,3);
508:
509: oe_debug_pub.Add('Freight Terms :'||
510: p_x_fte_source_line_tab(l_count).freight_terms,3);

Line 509: oe_debug_pub.Add('Freight Terms :'||

505:
506: oe_debug_pub.Add('Ship Method :'||
507: p_x_fte_source_line_tab(l_count).ship_method_code,3);
508:
509: oe_debug_pub.Add('Freight Terms :'||
510: p_x_fte_source_line_tab(l_count).freight_terms,3);
511:
512: oe_debug_pub.Add('Freight on Board :'||
513: p_x_fte_source_line_tab(l_count).fob_code,3);

Line 512: oe_debug_pub.Add('Freight on Board :'||

508:
509: oe_debug_pub.Add('Freight Terms :'||
510: p_x_fte_source_line_tab(l_count).freight_terms,3);
511:
512: oe_debug_pub.Add('Freight on Board :'||
513: p_x_fte_source_line_tab(l_count).fob_code,3);
514:
515: oe_debug_pub.Add('Intermediate Ship :'||
516: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);

Line 515: oe_debug_pub.Add('Intermediate Ship :'||

511:
512: oe_debug_pub.Add('Freight on Board :'||
513: p_x_fte_source_line_tab(l_count).fob_code,3);
514:
515: oe_debug_pub.Add('Intermediate Ship :'||
516: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);
517:
518: oe_debug_pub.Add('Transactional Currency :'||
519: p_x_fte_source_line_tab(l_count).currency,3);

Line 518: oe_debug_pub.Add('Transactional Currency :'||

514:
515: oe_debug_pub.Add('Intermediate Ship :'||
516: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);
517:
518: oe_debug_pub.Add('Transactional Currency :'||
519: p_x_fte_source_line_tab(l_count).currency,3);
520:
521: oe_debug_pub.Add('-------------------------------',3);
522: END IF;

Line 521: oe_debug_pub.Add('-------------------------------',3);

517:
518: oe_debug_pub.Add('Transactional Currency :'||
519: p_x_fte_source_line_tab(l_count).currency,3);
520:
521: oe_debug_pub.Add('-------------------------------',3);
522: END IF;
523:
524: -- Store the old ship method code in the line table
525:

Line 552: OE_DEBUG_PUB.Add('No lines of the order are eligible for freight rating');

548:
549: FND_MESSAGE.Set_Name('ONT','ONT_FTE_NO_LINES_ELIGIBLE');
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

Line 560: oe_debug_pub.Add('FTE Input count:'||p_x_fte_source_line_tab.count,3);

556: -- END IF; -- bug 7433107
557: END IF;
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.Add('FTE Input count:'||p_x_fte_source_line_tab.count,3);
561: oe_debug_pub.Add('Total count:'|| p_x_line_tbl.count,3);
562: END IF;
563:
564: for i in G_Ship_Date_tbl.first..G_Ship_Date_tbl.last loop

Line 561: oe_debug_pub.Add('Total count:'|| p_x_line_tbl.count,3);

557: END IF;
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.Add('FTE Input count:'||p_x_fte_source_line_tab.count,3);
561: oe_debug_pub.Add('Total count:'|| p_x_line_tbl.count,3);
562: END IF;
563:
564: for i in G_Ship_Date_tbl.first..G_Ship_Date_tbl.last loop
565: if G_Ship_Date_tbl.exists(i) Then

Line 566: oe_debug_pub.Add('Shedule Ship Date Value .. '||G_Ship_Date_tbl(i).Schedule_Ship_Date);

562: END IF;
563:
564: for i in G_Ship_Date_tbl.first..G_Ship_Date_tbl.last loop
565: if G_Ship_Date_tbl.exists(i) Then
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...');

Line 575: oe_debug_pub.Add('Expected Error in Create FTE Input',2);

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:
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:

Line 582: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);

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:
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586:

Line 620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

616: l_msg_data VARCHAR2(2000);
617: l_msg_count NUMBER;
618: l_config_count NUMBER;
619: i NUMBER;
620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
621: l_msg_text VARCHAR2(2000);
622:
623: BEGIN
624:

Line 625: oe_debug_pub.add(' Entering the procedure Get_shipment_Summary');

621: l_msg_text VARCHAR2(2000);
622:
623: BEGIN
624:
625: oe_debug_pub.add(' Entering the procedure Get_shipment_Summary');
626:
627: x_shipment_count := 0;
628:
629: -- Prepare the input information for FTE.

Line 650: oe_debug_pub.Add(l_msg_text, 3);

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);
653: END LOOP;
654: END IF;

Line 680: oe_debug_pub.Add('After Calling FTE Process Lines:'||

676:
677: x_return_status := l_return_status;
678: Print_Time('After Calling FTE for Get_Group ... ');
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.Add('After Calling FTE Process Lines:'||
681: l_return_status,3);
682: --x_shipment_count := 15;
683: END IF;
684:

Line 692: oe_debug_pub.Add(l_msg_text, 3);

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);
695: END LOOP;
696: END IF;

Line 704: oe_debug_pub.Add('header tab count is : ' || l_fte_source_header_tab.Count);

700: g_line_tbl := l_line_tbl;
701: g_fte_source_line_tab := l_fte_source_line_tab;
702: g_fte_source_header_tab := l_fte_source_header_tab;
703:
704: oe_debug_pub.Add('header tab count is : ' || l_fte_source_header_tab.Count);
705: oe_debug_pub.Add('line tab count is : ' || l_fte_source_line_tab.Count);
706:
707:
708: g_config_count := l_config_count;

Line 705: oe_debug_pub.Add('line tab count is : ' || l_fte_source_line_tab.Count);

701: g_fte_source_line_tab := l_fte_source_line_tab;
702: g_fte_source_header_tab := l_fte_source_header_tab;
703:
704: oe_debug_pub.Add('header tab count is : ' || l_fte_source_header_tab.Count);
705: oe_debug_pub.Add('line tab count is : ' || l_fte_source_line_tab.Count);
706:
707:
708: g_config_count := l_config_count;
709:

Line 736: --oe_debug_pub.add('Before print time');

732:
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

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 744: oe_debug_pub.Add('Expected Error in Get Shipment Summary',2);

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:
747:
748: END Get_Shipment_Summary;

Line 756: oe_debug_pub.add('Entering Get shipment summary tbl');

752: IS
753:
754: BEGIN
755:
756: oe_debug_pub.add('Entering Get shipment summary tbl');
757: oe_debug_pub.add('count:'||g_shipment_summary_tbl.count);
758:
759: IF g_shipment_summary_tbl.count >0 THEN
760: For I IN g_shipment_summary_tbl.FIRST .. g_shipment_summary_tbl.LAST LOOP

Line 757: oe_debug_pub.add('count:'||g_shipment_summary_tbl.count);

753:
754: BEGIN
755:
756: oe_debug_pub.add('Entering Get shipment summary tbl');
757: oe_debug_pub.add('count:'||g_shipment_summary_tbl.count);
758:
759: IF g_shipment_summary_tbl.count >0 THEN
760: For I IN g_shipment_summary_tbl.FIRST .. g_shipment_summary_tbl.LAST LOOP
761: x_shipment_summary_tbl(i).consolidation_id := g_shipment_summary_tbl(i).consolidation_id;

Line 773: oe_debug_pub.add(' exiting the get_shipment_summary_tbl proc');

769: x_shipment_summary_tbl(i).scheduled_ship_date := g_shipment_summary_tbl(i).scheduled_ship_date;
770: END LOOP;
771: END IF;
772:
773: oe_debug_pub.add(' exiting the get_shipment_summary_tbl proc');
774:
775: END Get_Shipment_Summary_Tbl;
776:
777: PROCEDURE Prepare_Adj_Detail

Line 789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

785:
786: l_price_adjustment_id number := 0;
787:
788: --
789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
790: --
791: BEGIN
792:
793: IF l_debug_level > 0 THEN

Line 794: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;

790: --
791: BEGIN
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

Line 802: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;

798: select oe_price_adjustments_s.nextval into l_price_adjustment_id
799: from dual;
800:
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;
803: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;
804: END IF;
805:
806: x_line_adj_rec.header_id := p_header_id;

Line 803: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;

799: from dual;
800:
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;
803: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;
804: END IF;
805:
806: x_line_adj_rec.header_id := p_header_id;
807: x_line_adj_rec.line_id := p_line_id;

Line 817: oe_debug_pub.add('value of cost ' ||p_fte_rates_rec.adjusted_price);

813: x_line_adj_rec.last_update_login := 1;
814:
815: x_line_adj_rec.automatic_flag := 'Y';
816: x_line_adj_rec.adjusted_amount := p_fte_rates_rec.adjusted_price;
817: oe_debug_pub.add('value of cost ' ||p_fte_rates_rec.adjusted_price);
818: x_line_adj_rec.charge_type_code := p_fte_rates_rec.cost_type;
819: oe_debug_pub.add('value of cost_type '||p_fte_rates_rec.cost_type);
820: x_line_adj_rec.list_line_type_code := 'COST';
821: x_line_adj_rec.estimated_flag := 'Y';

Line 819: oe_debug_pub.add('value of cost_type '||p_fte_rates_rec.cost_type);

815: x_line_adj_rec.automatic_flag := 'Y';
816: x_line_adj_rec.adjusted_amount := p_fte_rates_rec.adjusted_price;
817: oe_debug_pub.add('value of cost ' ||p_fte_rates_rec.adjusted_price);
818: x_line_adj_rec.charge_type_code := p_fte_rates_rec.cost_type;
819: oe_debug_pub.add('value of cost_type '||p_fte_rates_rec.cost_type);
820: x_line_adj_rec.list_line_type_code := 'COST';
821: x_line_adj_rec.estimated_flag := 'Y';
822: x_line_adj_rec.source_system_code := 'FTE';
823:

Line 825: oe_debug_pub.add( 'EXITING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;

821: x_line_adj_rec.estimated_flag := 'Y';
822: x_line_adj_rec.source_system_code := 'FTE';
823:
824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add( 'EXITING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
826: END IF;
827:
828: EXCEPTION
829: WHEN OTHERS THEN

Line 832: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;

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
835: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;
836: END IF;

Line 835: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;

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
835: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;
836: END IF;
837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
838: THEN
839: OE_MSG_PUB.Add_Exc_Msg

Line 850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

846: PROCEDURE Create_Dummy_Adjustment(p_header_id in number
847: ) IS
848: l_price_adjustment_id number := -1;
849: --
850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
851: --
852: BEGIN
853:
854: IF p_header_id is not null THEN

Line 932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

928: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
929: l_config_count NUMBER;
930: l_no_opr_count NUMBER;
931: l_msg_text VARCHAR2(2000);
932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
933: i NUMBER;
934: j NUMBER;
935: g_count Number := 0;
936: l_index NUMBER;

Line 958: oe_debug_pub.add( 'Entering Get Freight Choices procedure ');

954: BEGIN
955:
956: /* initialize g_freight_choices_tbl for this call */
957:
958: oe_debug_pub.add( 'Entering Get Freight Choices procedure ');
959:
960: g_freight_choices_tbl.DELETE;
961:
962: For j in g_fte_source_header_tab.FIRST .. g_fte_source_header_tab.LAST LOOP

Line 963: oe_debug_pub.add( ' value of g_fte_source_header_tab ' || g_fte_source_header_tab(j).consolidation_id);

959:
960: g_freight_choices_tbl.DELETE;
961:
962: For j in g_fte_source_header_tab.FIRST .. g_fte_source_header_tab.LAST LOOP
963: oe_debug_pub.add( ' value of g_fte_source_header_tab ' || g_fte_source_header_tab(j).consolidation_id);
964: End loop;
965:
966: For j in g_fte_source_line_tab.FIRST .. g_fte_source_line_tab.LAST LOOP
967: oe_debug_pub.add( ' value of g_fte_source_line_tab ' || g_fte_source_line_tab(j).consolidation_id);

Line 967: oe_debug_pub.add( ' value of g_fte_source_line_tab ' || g_fte_source_line_tab(j).consolidation_id);

963: oe_debug_pub.add( ' value of g_fte_source_header_tab ' || g_fte_source_header_tab(j).consolidation_id);
964: End loop;
965:
966: For j in g_fte_source_line_tab.FIRST .. g_fte_source_line_tab.LAST LOOP
967: oe_debug_pub.add( ' value of g_fte_source_line_tab ' || g_fte_source_line_tab(j).consolidation_id);
968: End loop;
969:
970: IF g_fte_source_header_tab(p_consolidation_id).consolidation_id = p_consolidation_id then
971: l_fte_source_header_tab(1) := g_fte_source_header_tab(p_consolidation_id);

Line 975: oe_debug_pub.add( ' Count 1');

971: l_fte_source_header_tab(1) := g_fte_source_header_tab(p_consolidation_id);
972:
973: END IF;
974:
975: oe_debug_pub.add( ' Count 1');
976:
977: i := 1;
978: For j in g_fte_source_line_tab.FIRST .. g_fte_source_line_tab.LAST LOOP
979: IF g_fte_source_line_tab(j).consolidation_id = p_consolidation_id then

Line 985: oe_debug_pub.add( ' Count 2');

981: i := i+1;
982: End If;
983: END LOOP;
984:
985: oe_debug_pub.add( ' Count 2');
986: /*
987: This is used to populate the return table for the shipment details block
988: in Get_Shipment_Details Procedure.
989: */

Line 996: oe_debug_pub.Add('before process lines ');

992: -- Call FTE to get freight choices only if the number of lines is
993: -- greater than zero.
994: IF l_fte_source_line_tab.Count > 0 THEN
995:
996: oe_debug_pub.Add('before process lines ');
997: oe_debug_pub.Add('source header id : ' || l_fte_source_line_tab(1).source_header_id);
998: Print_Time('Calling FTE for GET_RATE_CHOICE ... ');
999:
1000: FTE_PROCESS_REQUESTS.Process_Lines (

Line 997: oe_debug_pub.Add('source header id : ' || l_fte_source_line_tab(1).source_header_id);

993: -- greater than zero.
994: IF l_fte_source_line_tab.Count > 0 THEN
995:
996: oe_debug_pub.Add('before process lines ');
997: oe_debug_pub.Add('source header id : ' || l_fte_source_line_tab(1).source_header_id);
998: Print_Time('Calling FTE for GET_RATE_CHOICE ... ');
999:
1000: FTE_PROCESS_REQUESTS.Process_Lines (
1001: p_source_line_tab => l_fte_source_line_tab,

Line 1013: oe_debug_pub.Add('After Calling FTE Process Lines:'||

1009: x_msg_data => x_msg_data);
1010:
1011: Print_Time('After Calling FTE for GET_RATE_CHOICE ... ');
1012: IF l_debug_level > 0 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

Line 1024: oe_debug_pub.Add(l_msg_text, 3);

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);
1027: END LOOP;
1028: END IF;

Line 1044: oe_debug_pub.add( ' value of g_fte_source_line_tab ' || g_fte_source_line_tab(j).consolidation_id);

1040: g_shipment_summary_tbl(p_consolidation_id).total_volume := l_fte_source_header_tab(i).total_volume;
1041: END LOOP;
1042:
1043: For j in g_fte_source_line_tab.FIRST .. g_fte_source_line_tab.LAST LOOP
1044: oe_debug_pub.add( ' value of g_fte_source_line_tab ' || g_fte_source_line_tab(j).consolidation_id);
1045: End loop;
1046:
1047: g_fte_line_rate_tab := l_fte_line_rate_tab ;
1048: g_fte_header_rate_tab := l_fte_header_rate_tab;

Line 1060: oe_debug_pub.add( '============ FTE RESULTS ============' , 3 ) ;

1056: l_ship_method_code := l_fte_header_rate_tab(I).ship_method_code;
1057: l_lane_id := l_fte_header_rate_tab(I).lane_id;
1058:
1059: IF l_debug_level > 0 THEN
1060: oe_debug_pub.add( '============ FTE RESULTS ============' , 3 ) ;
1061: END IF;
1062:
1063: M := l_fte_header_rate_tab(I).first_line_index;
1064: l_source_line_id := l_fte_line_rate_tab(M).source_line_id;

Line 1069: oe_debug_pub.add('source line id : ' || l_fte_line_rate_tab(M).source_line_id);

1065: K := 0;
1066:
1067: While M is not null loop
1068:
1069: oe_debug_pub.add('source line id : ' || l_fte_line_rate_tab(M).source_line_id);
1070:
1071: oe_debug_pub.add('ship method is: ' || l_fte_line_rate_tab(M).ship_method_code);
1072:
1073: IF l_fte_line_rate_tab(M).ship_method_code = l_ship_method_code

Line 1071: oe_debug_pub.add('ship method is: ' || l_fte_line_rate_tab(M).ship_method_code);

1067: While M is not null loop
1068:
1069: oe_debug_pub.add('source line id : ' || l_fte_line_rate_tab(M).source_line_id);
1070:
1071: oe_debug_pub.add('ship method is: ' || l_fte_line_rate_tab(M).ship_method_code);
1072:
1073: IF l_fte_line_rate_tab(M).ship_method_code = l_ship_method_code
1074: and l_fte_line_rate_tab(M).lane_id = l_lane_id
1075: and l_fte_line_rate_tab(M).consolidation_id = p_consolidation_id

Line 1086: oe_debug_pub.add('104');

1082: ,x_line_adj_rec => l_line_adj_rec
1083: ,x_return_status => l_return_status
1084: );
1085:
1086: oe_debug_pub.add('104');
1087:
1088: IF deleted_costs.EXISTS(l_fte_line_rate_tab(M).source_line_id) THEN
1089: NULL;
1090: ELSE

Line 1119: oe_debug_pub.add('105');

1115: END IF; --if l_fte_line_rate_tab(M).ship_method_code = l_ship_method_code
1116:
1117: M := l_fte_line_rate_tab.NEXT(M);
1118:
1119: oe_debug_pub.add('105');
1120:
1121: END LOOP; --While M is not null loop
1122:
1123: deleted_costs.DELETE;

Line 1128: oe_debug_pub.add('107');

1124:
1125: -- Calling Pricing Engine to calculate freight charges
1126: -- if being called from Action button.
1127:
1128: oe_debug_pub.add('107');
1129:
1130: /*
1131: Call Pricing to do cost to charge conversion with simulation mode for this order line and
1132: for this ship method combination.

Line 1137: oe_debug_pub.add('108');

1133: populate the simulate_flag to 'Y' and populate the freight_charge_flag to 'Y' in control record,
1134: Also set the write_to_db to false.
1135: Freight_Choices_Tab should store all the applicable freight charges for this particular order line.
1136: */
1137: oe_debug_pub.add('108');
1138:
1139: l_price_control_rec.p_Request_Type_Code:='ONT';
1140: l_Price_control_rec.p_write_to_db:=FALSE;
1141: l_price_control_rec.p_honor_price_flag:='Y';

Line 1146: oe_debug_pub.add('109');

1142: l_price_control_rec.p_multiple_events:='N';
1143: l_price_control_rec.p_get_freight_flag:='Y';
1144: l_price_control_rec.p_simulation_flag := 'Y';
1145:
1146: oe_debug_pub.add('109');
1147:
1148: IF l_line_tbl.count > 0 THEN
1149: oe_order_price_pvt.price_line
1150: (p_Header_id => null

Line 1159: oe_debug_pub.add('110');

1155: ,p_Pricing_Events => 'BATCH'
1156: ,x_Return_Status => l_return_status
1157: );
1158:
1159: oe_debug_pub.add('110');
1160: K := 1;
1161: K := l_line_tbl.FIRST;
1162: WHILE K IS NOT NULL LOOP
1163:

Line 1171: oe_debug_pub.add('value of ordered qty : '||nvl(l_line_tbl(K).ordered_quantity,0));

1167: and q.line_type_code = 'LINE'
1168: AND nvl(l.automatic_flag,'N') = 'Y'
1169: AND l.list_line_type_code = 'FREIGHT_CHARGE';
1170:
1171: oe_debug_pub.add('value of ordered qty : '||nvl(l_line_tbl(K).ordered_quantity,0));
1172:
1173: -- Modified for bug # 7043225
1174: -- bug 6701769/6753485
1175: --l_Adjusted_amount := l_Adjusted_amount + nvl(l_line_tbl(K).ordered_quantity,0)*q_Adjusted_amount;

Line 1178: oe_debug_pub.add('6701769 value of l_Adjusted_amount : '||l_Adjusted_amount);

1174: -- bug 6701769/6753485
1175: --l_Adjusted_amount := l_Adjusted_amount + nvl(l_line_tbl(K).ordered_quantity,0)*q_Adjusted_amount;
1176: l_Adjusted_amount := l_Adjusted_amount + (nvl(nvl(l_line_tbl(K).pricing_quantity,l_line_tbl(K).ordered_quantity),0)*nvl(q_Adjusted_amount,0));
1177:
1178: oe_debug_pub.add('6701769 value of l_Adjusted_amount : '||l_Adjusted_amount);
1179:
1180: K := l_line_tbl.NEXT(K);
1181:
1182: END LOOP; -- while k is not null

Line 1186: oe_debug_pub.add('value of charges : '||l_Adjusted_amount);

1182: END LOOP; -- while k is not null
1183:
1184: K := 0;
1185:
1186: oe_debug_pub.add('value of charges : '||l_Adjusted_amount);
1187:
1188: --oe_debug_pub.add('value of ordered qty : '||nvl(l_line_tbl(K).ordered_quantity,0));
1189:
1190: Select MEANING into l_meaning from oe_ship_methods_v

Line 1188: --oe_debug_pub.add('value of ordered qty : '||nvl(l_line_tbl(K).ordered_quantity,0));

1184: K := 0;
1185:
1186: oe_debug_pub.add('value of charges : '||l_Adjusted_amount);
1187:
1188: --oe_debug_pub.add('value of ordered qty : '||nvl(l_line_tbl(K).ordered_quantity,0));
1189:
1190: Select MEANING into l_meaning from oe_ship_methods_v
1191: where LOOKUP_CODE= l_fte_header_rate_tab(I).ship_method_code
1192: and LOOKUP_TYPE='SHIP_METHOD';

Line 1232: oe_debug_pub.add( 'ERROR IN PROCEDURE Get_Freight_Choices: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;

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
1235: oe_debug_pub.add( 'UNEXPECTED ERROR IN Get_Freight_Choices :'||SQLERRM , 3 ) ;
1236: END IF;

Line 1235: oe_debug_pub.add( 'UNEXPECTED ERROR IN Get_Freight_Choices :'||SQLERRM , 3 ) ;

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
1235: oe_debug_pub.add( 'UNEXPECTED ERROR IN Get_Freight_Choices :'||SQLERRM , 3 ) ;
1236: END IF;
1237: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: OE_MSG_PUB.Add_Exc_Msg

Line 1254: oe_debug_pub.add(' Value of Transit Time Uom .. '||g_freight_choices_tbl(i).transit_time_uom);

1250:
1251: BEGIN
1252:
1253: For I IN g_freight_choices_Tbl.FIRST .. g_freight_choices_tbl.LAST LOOP
1254: oe_debug_pub.add(' Value of Transit Time Uom .. '||g_freight_choices_tbl(i).transit_time_uom);
1255: x_freight_choices_tbl(i).consolidation_id := g_freight_choices_tbl(i).consolidation_id;
1256: x_freight_choices_tbl(i).shipping_method := g_freight_choices_tbl(i).shipping_method;
1257: x_freight_choices_tbl(i).shipping_method_code
1258: := g_freight_choices_tbl(i).shipping_method_code;

Line 1302: oe_debug_pub.add('Entering Repopulate_Freight_Choices');

1298: x_consolidation_id IN NUMBER)
1299: IS
1300:
1301: BEGIN
1302: oe_debug_pub.add('Entering Repopulate_Freight_Choices');
1303:
1304: IF g_shipment_summary_tbl.count >0 THEN
1305: x_weight := g_shipment_summary_tbl(x_consolidation_id).total_weight;
1306: x_volume := g_shipment_summary_tbl(x_consolidation_id).total_volume;

Line 1309: oe_debug_pub.add('Exiting the Repopulate_Freight_Choices proc');

1305: x_weight := g_shipment_summary_tbl(x_consolidation_id).total_weight;
1306: x_volume := g_shipment_summary_tbl(x_consolidation_id).total_volume;
1307: END IF;
1308:
1309: oe_debug_pub.add('Exiting the Repopulate_Freight_Choices proc');
1310:
1311: END Repopulate_Freight_Choices;
1312:
1313: PROCEDURE Process_Freight_Choices

Line 1338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1334: l_count Number;
1335: l_fte_count Number := 1;
1336: i Number := 1;
1337: j Number;
1338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1339: M Number;
1340: K Number;
1341: l_order_source_id NUMBER;
1342: l_orig_sys_document_ref VARCHAR2(50);

Line 1381: oe_debug_pub.add(' Entering the procedure process freight choices');

1377: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
1378: */
1379: BEGIN
1380:
1381: oe_debug_pub.add(' Entering the procedure process freight choices');
1382:
1383: Savepoint Cancel_All;
1384: oe_debug_pub.add('first Consolidation Id got '|| g_fte_header_rate_tab(i).Consolidation_id);
1385:

Line 1384: oe_debug_pub.add('first Consolidation Id got '|| g_fte_header_rate_tab(i).Consolidation_id);

1380:
1381: oe_debug_pub.add(' Entering the procedure process freight choices');
1382:
1383: Savepoint Cancel_All;
1384: oe_debug_pub.add('first Consolidation Id got '|| g_fte_header_rate_tab(i).Consolidation_id);
1385:
1386: I := g_fte_header_rate_tab.FIRST;
1387: WHILE I IS NOT NULL LOOP
1388: If g_fte_header_rate_tab(i).Consolidation_id = p_Consolidation_id and

Line 1391: oe_debug_pub.add('In the first I loop');

1387: WHILE I IS NOT NULL LOOP
1388: If g_fte_header_rate_tab(i).Consolidation_id = p_Consolidation_id and
1389: g_fte_header_rate_tab(i).Ship_method_code = p_ship_method_code and --bug 4408958
1390: g_fte_header_rate_tab(i).lane_id = p_lane_id then
1391: oe_debug_pub.add('In the first I loop');
1392: Exit;
1393: End If;
1394: I := g_fte_header_rate_tab.NEXT(I);
1395: End Loop;

Line 1398: oe_debug_pub.add('Consolidation Id got '|| g_fte_header_rate_tab(i).Consolidation_id);

1394: I := g_fte_header_rate_tab.NEXT(I);
1395: End Loop;
1396:
1397:
1398: oe_debug_pub.add('Consolidation Id got '|| g_fte_header_rate_tab(i).Consolidation_id);
1399:
1400: M := g_fte_header_rate_tab(I).first_line_index;
1401:
1402: K := 0;

Line 1405: oe_debug_pub.add( ' Line Ids: value of g_fte_line_rate_tab' || g_fte_line_rate_tab(j).source_line_id);

1401:
1402: K := 0;
1403:
1404: For j in g_fte_line_rate_tab.FIRST .. g_fte_line_rate_tab.LAST LOOP
1405: oe_debug_pub.add( ' Line Ids: value of g_fte_line_rate_tab' || g_fte_line_rate_tab(j).source_line_id);
1406: oe_debug_pub.add( ' Ship method ids : '||g_fte_line_rate_tab(j).ship_method_code);
1407: End loop;
1408:
1409: While M is not null loop

Line 1406: oe_debug_pub.add( ' Ship method ids : '||g_fte_line_rate_tab(j).ship_method_code);

1402: K := 0;
1403:
1404: For j in g_fte_line_rate_tab.FIRST .. g_fte_line_rate_tab.LAST LOOP
1405: oe_debug_pub.add( ' Line Ids: value of g_fte_line_rate_tab' || g_fte_line_rate_tab(j).source_line_id);
1406: oe_debug_pub.add( ' Ship method ids : '||g_fte_line_rate_tab(j).ship_method_code);
1407: End loop;
1408:
1409: While M is not null loop
1410:

Line 1433: oe_debug_pub.add('The line ids for the lines added '|| g_fte_line_rate_tab(M).source_line_id);

1429: ,x_line_tbl => query_line_tbl );
1430:
1431: K := K + 1;
1432:
1433: oe_debug_pub.add('The line ids for the lines added '|| g_fte_line_rate_tab(M).source_line_id);
1434: l_old_line_tbl(k) := query_line_tbl(1);
1435:
1436: /* renga-review */
1437: For j in g_fte_source_line_tab.first .. g_fte_source_line_tab.Last Loop

Line 1451: oe_debug_pub.add('value of carrier freight code '||g_fte_line_rate_tab(M).carrier_freight_code);

1447: THEN
1448: IF l_debug_level > 0 THEN
1449: Null;
1450: END IF;
1451: oe_debug_pub.add('value of carrier freight code '||g_fte_line_rate_tab(M).carrier_freight_code);
1452: query_line_tbl(1).shipping_method_code :=
1453: g_fte_line_rate_tab(M).ship_method_code;
1454:
1455: query_line_tbl(1).freight_carrier_code :=

Line 1470: oe_debug_pub.add('No Changes to save', 4);

1466:
1467:
1468: ELSE -- no change, set the operation to none.
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('No Changes to save', 4);
1471: END IF;
1472: /* renga-review */
1473: --l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
1474:

Line 1492: oe_debug_pub.add('ato model '||query_line_tbl(1).line_id,3);

1488: query_line_tbl(1).line_id THEN
1489:
1490: -- This is an ATO Model
1491: IF l_debug_level > 0 THEN
1492: oe_debug_pub.add('ato model '||query_line_tbl(1).line_id,3);
1493: END IF;
1494:
1495: -- added by Renga after review
1496: IF query_line_tbl(1).ato_line_id is not null then

Line 1511: oe_debug_pub.add('cfg line '|| g_line_tbl(l_index).line_id, 3);

1507: query_line_tbl(1).line_id
1508: THEN
1509:
1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add('cfg line '|| g_line_tbl(l_index).line_id, 3);
1512: END IF;
1513:
1514: IF query_line_tbl(1).operation = OE_GLOBALS.G_OPR_UPDATE
1515: THEN

Line 1531: oe_debug_pub.Add('Cascading Ship Method from:' ||

1527:
1528: /* End Audit Trail */
1529:
1530: IF l_debug_level > 0 THEN
1531: oe_debug_pub.Add('Cascading Ship Method from:' ||
1532: query_line_tbl(1).line_id ||' to ' ||
1533: g_line_tbl(l_index).line_id,3);
1534: END IF;
1535:

Line 1538: oe_debug_pub.add

1534: END IF;
1535:
1536: END IF;
1537: IF l_debug_level > 0 THEN
1538: oe_debug_pub.add
1539: ('cfg opr '||g_line_tbl(l_index).operation, 3);
1540: END IF;
1541:
1542: g_line_tbl(l_index).operation:=

Line 1558: oe_debug_pub.add('Register changed line: '||l_line_rec.line_id,1);

1554: -- changed. Hence registering the line, inspite of no change.
1555:
1556: -- to register changed line so that repricing for this line
1557: -- would happen.
1558: oe_debug_pub.add('Register changed line: '||l_line_rec.line_id,1);
1559: OE_LINE_ADJ_UTIL.Register_Changed_Lines
1560: (p_line_id => query_line_tbl(1).line_id,
1561: p_header_id => query_line_tbl(1).header_id,
1562: p_operation => OE_GLOBALS.G_OPR_UPDATE);

Line 1623: oe_debug_pub.add( 'CASCADING ADJUSTMENT LINES TO CONFIG LINES. ' , 3 );

1619: WHILE l_index <= g_config_count LOOP
1620:
1621: l_line_id := g_line_tbl(l_index).line_id;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'CASCADING ADJUSTMENT LINES TO CONFIG LINES. ' , 3 );
1624: END IF;
1625:
1626: OPEN C_CONFIG_ITEM_PARENTS(g_line_tbl(l_index).ato_line_id);
1627: FETCH C_CONFIG_ITEM_PARENTS BULK COLLECT INTO

Line 1642: oe_debug_pub.add( ' in the config item loops .. line_id '||l_bulk_adj_rec.line_id(i));

1638:
1639: l_fte_rates_rec.cost_type := l_bulk_adj_rec.charge_type_code(i);
1640: l_fte_rates_rec.adjusted_price := l_bulk_adj_rec.adjusted_amount(i);
1641:
1642: oe_debug_pub.add( ' in the config item loops .. line_id '||l_bulk_adj_rec.line_id(i));
1643:
1644: Prepare_Adj_Detail
1645: (p_header_id => l_header_id
1646: ,p_line_id => l_line_id

Line 1681: oe_debug_pub.add('The config lines added '|| l_line_id);

1677: ,x_line_tbl => query_line_tbl );
1678:
1679: K := K + 1;
1680:
1681: oe_debug_pub.add('The config lines added '|| l_line_id);
1682: l_line_tbl(k) := query_line_tbl(1);
1683:
1684: l_index := l_index + 1;
1685:

Line 1698: oe_debug_pub.add('ATO item price flag set to N :'||l_line_tbl(J).line_id);

1694: -- delete those non-shippable ATO parent lines
1695: IF l_line_tbl(J).ato_line_id IS NOT NULL
1696: AND l_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1697: l_line_tbl(J).calculate_price_flag := 'N';
1698: oe_debug_pub.add('ATO item price flag set to N :'||l_line_tbl(J).line_id);
1699: END IF;
1700: J := l_line_tbl.NEXT(J);
1701: END LOOP;*/
1702:

Line 1704: oe_debug_pub.add( ' Lines passed to pricing Ids: value of l_line_tbl' || l_line_tbl(j).line_id);

1700: J := l_line_tbl.NEXT(J);
1701: END LOOP;*/
1702:
1703: For j in l_line_tbl.FIRST .. l_line_tbl.LAST LOOP
1704: oe_debug_pub.add( ' Lines passed to pricing Ids: value of l_line_tbl' || l_line_tbl(j).line_id);
1705: End loop;
1706:
1707: IF (Nvl(get_list_line_type_code(p_header_id),0) = 0 ) THEN
1708:

Line 1732: oe_debug_pub.Add('After Calling Process Order...'||x_return_status,3);

1728: ,p_x_old_line_tbl => l_old_line_tbl
1729: ,x_return_status => x_return_status);
1730:
1731: IF l_debug_level > 0 THEN
1732: oe_debug_pub.Add('After Calling Process Order...'||x_return_status,3);
1733: END IF; -- bug7433107
1734:
1735: -- Logging a delayed request for Price Line in BATCH mode.
1736:

Line 1752: OE_DEBUG_PUB.Add('Before Calling Process Requests and Notify',3);

1748: x_return_status => l_return_status);
1749:
1750:
1751: IF l_debug_level > 0 THEN -- bug7433107
1752: OE_DEBUG_PUB.Add('Before Calling Process Requests and Notify',3);
1753: END IF;
1754:
1755: OE_ORDER_PVT.Process_Requests_And_notify
1756: ( p_process_requests => TRUE

Line 1763: OE_DEBUG_PUB.Add('After Calling Process Requests and Notify...'|| x_return_status,3);

1759: ,p_line_tbl => l_line_tbl
1760: ,p_old_line_tbl => l_old_line_tbl);
1761:
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:

Line 1772: oe_debug_pub.Add('Expected Error in Process Freight Choices', 1);

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:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776:

Line 1779: oe_debug_pub.Add('Unexpected Error in Process Freight Choices'||

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;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783:

Line 1803: oe_debug_pub.add('Entering Cancel all');

1799: NO_SAVEPOINT EXCEPTION;
1800: PRAGMA EXCEPTION_INIT(NO_SAVEPOINT, -1086);
1801:
1802: Begin
1803: oe_debug_pub.add('Entering Cancel all');
1804: Rollback to Savepoint Cancel_All;
1805:
1806: -- bug 5883660
1807: EXCEPTION WHEN NO_SAVEPOINT THEN