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 460: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1537: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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