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_FTE_INTEGRATION_PVT dependencies on OE_DEBUG_PUB

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

45:
46: PROCEDURE Print_Time(p_msg IN VARCHAR2)
47: IS
48: l_time VARCHAR2(100);
49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: BEGIN
51: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
52: 'DD-MON-YY HH24:MI:SS');
53: IF l_debug_level > 0 THEN

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

50: BEGIN
51: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
52: 'DD-MON-YY HH24:MI:SS');
53: IF l_debug_level > 0 THEN
54: OE_DEBUG_PUB.Add(p_msg || ': '|| l_time, 1);
55: END IF;
56: END Print_Time;
57:
58:

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

77:
78: IS
79: l_control_rec OE_GLOBALS.Control_Rec_Type;
80: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
82: BEGIN
83:
84: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Update_FTE_Results..');
85:

Line 89: OE_DEBUG_PUB.Add('Before Calling Process Order..',3);

85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: IF l_debug_level > 0 THEN
89: OE_DEBUG_PUB.Add('Before Calling Process Order..',3);
90: END IF;
91:
92: OE_ORDER_PVT.Lines
93: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 101: oe_debug_pub.Add('After Calling Process Order...'||

97: ,x_return_status => x_return_status);
98:
99:
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.Add('After Calling Process Order...'||
102: x_return_status,3);
103: END IF;
104:
105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:
111: IF l_debug_level > 0 THEN
112: OE_DEBUG_PUB.Add('Before Calling Process Requests and Notify',3);
113: END IF;
114:
115: OE_ORDER_PVT.Process_Requests_And_notify
116: ( p_process_requests => TRUE

Line 123: OE_DEBUG_PUB.Add('After Calling Process Requests' ||

119: ,p_line_tbl => p_x_line_tbl
120: ,p_old_line_tbl => l_old_line_tbl);
121:
122: IF l_debug_level > 0 THEN
123: OE_DEBUG_PUB.Add('After Calling Process Requests' ||
124: 'and Notify...'|| x_return_status,3);
125: END IF;
126:
127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 140: OE_DEBUG_PUB.Add('Expected Error in Update FTE Results', 2);

136: EXCEPTION
137:
138: WHEN FND_API.G_EXC_ERROR THEN
139: IF l_debug_level > 0 THEN
140: OE_DEBUG_PUB.Add('Expected Error in Update FTE Results', 2);
141: END IF;
142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 146: OE_DEBUG_PUB.Add('Unexpected Error in Update FTE Results'||

142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: IF l_debug_level > 0 THEN
146: OE_DEBUG_PUB.Add('Unexpected Error in Update FTE Results'||
147: sqlerrm, 1);
148: END IF;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150:

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

275: l_config_count NUMBER := 0;
276: l_count NUMBER := 0;
277: l_line_rec OE_ORDER_PUB.line_rec_type :=
278: OE_Order_Pub.G_MISS_LINE_REC;
279: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
280: BEGIN
281: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');
282:
283: IF l_debug_level > 0 THEN

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

280: BEGIN
281: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');
282:
283: IF l_debug_level > 0 THEN
284: OE_DEBUG_PUB.Add('Order header Id:'||p_header_id,1);
285: END IF;
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287:
288:

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

295: WHERE header_id = p_header_id;
296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN
298: IF l_debug_level > 0 THEN
299: OE_DEBUG_PUB.Add('No Data Found when Validating Order',3);
300: END IF;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: WHEN OTHERS THEN
303: IF l_debug_level > 0 THEN

Line 304: OE_DEBUG_PUB.Add('When Others when Validating Order',3);

300: END IF;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: WHEN OTHERS THEN
303: IF l_debug_level > 0 THEN
304: OE_DEBUG_PUB.Add('When Others when Validating Order',3);
305: END IF;
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: END;
308:

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

307: END;
308:
309: IF l_open_flag = 'N' OR l_order_category_code = 'RETURN' THEN
310: IF l_debug_level > 0 THEN
311: OE_DEBUG_PUB.Add('Order is Return/Closed',1);
312: END IF;
313: RAISE FND_API.G_EXC_ERROR ;
314: END IF;
315:

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

320:
321: FOR c_inc_parent IN C_INC_ITEMS_PARENT
322: LOOP
323: IF l_debug_level > 0 THEN
324: OE_DEBUG_PUB.Add('Calling Process Included Items for Line:'||
325: c_inc_parent.line_id,3);
326: END IF;
327:
328: x_return_status := OE_CONFIG_UTIL.Process_Included_Items

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

329: (p_line_id => c_inc_parent.line_id
330: ,p_freeze => FALSE);
331:
332: IF l_debug_level > 0 THEN
333: OE_DEBUG_PUB.Add('After Calling Process Included Items: '||
334: x_return_status,3);
335: END IF;
336:
337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

358: AND ato_line_id IS NOT NULL
359: AND header_id = p_header_id;
360:
361: IF l_debug_level > 0 THEN
362: OE_DEBUG_PUB.Add('Config Line Count:'||l_config_count,3);
363: END IF;
364:
365: x_config_count := l_config_count;
366: l_line_count := l_config_count;

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

400: FND_MESSAGE.Set_Name('ONT','ONT_FTE_EXTERNAL_RET_SERVICE');
401: OE_MSG_PUB.Add;
402:
403: IF l_debug_level > 0 THEN
404: OE_DEBUG_PUB.Add('Line is External/Service/Return:'||
405: c_ship_method.line_id ,3);
406: END IF;
407:
408: ELSIF c_ship_method.ship_from_org_id IS NULL THEN

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

409:
410: FND_MESSAGE.Set_Name('ONT','ONT_FTE_MISSING_SHIP_FROM');
411: OE_MSG_PUB.Add;
412: IF l_debug_level > 0 THEN
413: OE_DEBUG_PUB.Add('Line is Missing Ship From Org Id:'||
414: c_ship_method.line_id ,3);
415: END IF;
416:
417: ELSIF c_ship_method.ship_to_org_id IS NULL THEN

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

418:
419: FND_MESSAGE.Set_Name('ONT','ONT_FTE_MISSING_SHIP_TO');
420: OE_MSG_PUB.Add;
421: IF l_debug_level > 0 THEN
422: OE_DEBUG_PUB.Add('Line is Missing Ship To Org Id:'||
423: c_ship_method.line_id ,3);
424: END IF;
425:
426: ELSIF c_ship_method.shipped_quantity IS NOT NULL OR

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

429:
430: FND_MESSAGE.Set_Name('ONT','ONT_FTE_SHIP_FULFILL_CLOSED');
431: OE_MSG_PUB.Add;
432: IF l_debug_level > 0 THEN
433: OE_DEBUG_PUB.Add('Line is Shipped/Fulfilled/Closed:'||
434: c_ship_method.line_id ,1);
435: END IF;
436: ELSIF c_ship_method.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
437:

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

437:
438: -- We are not going to send Config lines to FTE
439: -- We have to store the config lines in the line table.
440: IF l_debug_level > 0 THEN
441: OE_DEBUG_PUB.Add('Config Line:'||c_ship_method.line_id,3);
442: END IF;
443:
444: l_line_rec.line_id := c_ship_method.line_id;
445: l_line_rec.ato_line_id := c_ship_method.ato_line_id;

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

452: l_config_count := l_config_count + 1;
453:
454: p_x_line_tbl(l_config_count) := l_line_rec;
455: IF l_debug_level > 0 THEN
456: OE_DEBUG_PUB.Add('Excluding Config Line from FTE Input:'||
457: c_ship_method.line_id ,1);
458: END IF;
459: ELSE
460: IF l_debug_level > 0 THEN

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

457: c_ship_method.line_id ,1);
458: END IF;
459: ELSE
460: IF l_debug_level > 0 THEN
461: OE_DEBUG_PUB.Add('Sending Eligibile Line to FTE:'||
462: c_ship_method.line_id ,1);
463: END IF;
464:
465: -- Increment the FTE line table count

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

572: c_ship_method.item_type_code = 'STANDARD') AND
573: c_ship_method.ato_line_id = c_ship_method.line_id)
574: THEN
575: IF l_debug_level > 0 THEN
576: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);
577: END IF;
578: ELSE
579: IF l_debug_level > 0 THEN
580: OE_DEBUG_PUB.Add('do not calculate freight_rating '||

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

576: OE_DEBUG_PUB.Add('calculate rating part of ato', 4);
577: END IF;
578: ELSE
579: IF l_debug_level > 0 THEN
580: OE_DEBUG_PUB.Add('do not calculate freight_rating '||
581: c_ship_method.line_id, 1);
582: END IF;
583: p_x_fte_source_line_tab(l_count).freight_rating_flag:= 'N';
584: END IF;

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

585:
586: END IF;
587:
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.Add('--------- Input to FTE --------',3);
590:
591: oe_debug_pub.Add('Source Line :'||
592: p_x_fte_source_line_tab(l_count).source_line_id,3);
593:

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

587:
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.Add('--------- Input to FTE --------',3);
590:
591: oe_debug_pub.Add('Source Line :'||
592: p_x_fte_source_line_tab(l_count).source_line_id,3);
593:
594: oe_debug_pub.Add('Ship From Org :'||
595: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);

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

590:
591: oe_debug_pub.Add('Source Line :'||
592: p_x_fte_source_line_tab(l_count).source_line_id,3);
593:
594: oe_debug_pub.Add('Ship From Org :'||
595: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);
596:
597: oe_debug_pub.Add('Customer :'||
598: p_x_fte_source_line_tab(l_count).customer_id,3);

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

593:
594: oe_debug_pub.Add('Ship From Org :'||
595: p_x_fte_source_line_tab(l_count).ship_from_org_id,3);
596:
597: oe_debug_pub.Add('Customer :'||
598: p_x_fte_source_line_tab(l_count).customer_id,3);
599:
600: oe_debug_pub.Add('Inventory Item :'||
601: p_x_fte_source_line_tab(l_count).inventory_item_id,3);

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

596:
597: oe_debug_pub.Add('Customer :'||
598: p_x_fte_source_line_tab(l_count).customer_id,3);
599:
600: oe_debug_pub.Add('Inventory Item :'||
601: p_x_fte_source_line_tab(l_count).inventory_item_id,3);
602:
603: oe_debug_pub.Add('Source Quantity :'||
604: p_x_fte_source_line_tab(l_count).source_quantity,3);

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

599:
600: oe_debug_pub.Add('Inventory Item :'||
601: p_x_fte_source_line_tab(l_count).inventory_item_id,3);
602:
603: oe_debug_pub.Add('Source Quantity :'||
604: p_x_fte_source_line_tab(l_count).source_quantity,3);
605:
606: oe_debug_pub.Add('Ship Date :'||
607: p_x_fte_source_line_tab(l_count).ship_date,3);

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

602:
603: oe_debug_pub.Add('Source Quantity :'||
604: p_x_fte_source_line_tab(l_count).source_quantity,3);
605:
606: oe_debug_pub.Add('Ship Date :'||
607: p_x_fte_source_line_tab(l_count).ship_date,3);
608:
609: oe_debug_pub.Add('Delivery Lead Time :'||
610: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);

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

605:
606: oe_debug_pub.Add('Ship Date :'||
607: p_x_fte_source_line_tab(l_count).ship_date,3);
608:
609: oe_debug_pub.Add('Delivery Lead Time :'||
610: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);
611:
612: oe_debug_pub.Add('Scheduled :'||
613: p_x_fte_source_line_tab(l_count).scheduled_flag,3);

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

608:
609: oe_debug_pub.Add('Delivery Lead Time :'||
610: p_x_fte_source_line_tab(l_count).delivery_lead_time,3);
611:
612: oe_debug_pub.Add('Scheduled :'||
613: p_x_fte_source_line_tab(l_count).scheduled_flag,3);
614:
615: oe_debug_pub.Add('Order Set Type :'||
616: p_x_fte_source_line_tab(l_count).order_set_type,3);

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

611:
612: oe_debug_pub.Add('Scheduled :'||
613: p_x_fte_source_line_tab(l_count).scheduled_flag,3);
614:
615: oe_debug_pub.Add('Order Set Type :'||
616: p_x_fte_source_line_tab(l_count).order_set_type,3);
617:
618: oe_debug_pub.Add('Order Set :'||
619: p_x_fte_source_line_tab(l_count).order_set_id,3);

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

614:
615: oe_debug_pub.Add('Order Set Type :'||
616: p_x_fte_source_line_tab(l_count).order_set_type,3);
617:
618: oe_debug_pub.Add('Order Set :'||
619: p_x_fte_source_line_tab(l_count).order_set_id,3);
620:
621: oe_debug_pub.Add('Ship Method :'||
622: p_x_fte_source_line_tab(l_count).ship_method_code,3);

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

617:
618: oe_debug_pub.Add('Order Set :'||
619: p_x_fte_source_line_tab(l_count).order_set_id,3);
620:
621: oe_debug_pub.Add('Ship Method :'||
622: p_x_fte_source_line_tab(l_count).ship_method_code,3);
623:
624: oe_debug_pub.Add('Freight Terms :'||
625: p_x_fte_source_line_tab(l_count).freight_terms,3);

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

620:
621: oe_debug_pub.Add('Ship Method :'||
622: p_x_fte_source_line_tab(l_count).ship_method_code,3);
623:
624: oe_debug_pub.Add('Freight Terms :'||
625: p_x_fte_source_line_tab(l_count).freight_terms,3);
626:
627: oe_debug_pub.Add('Freight on Board :'||
628: p_x_fte_source_line_tab(l_count).fob_code,3);

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

623:
624: oe_debug_pub.Add('Freight Terms :'||
625: p_x_fte_source_line_tab(l_count).freight_terms,3);
626:
627: oe_debug_pub.Add('Freight on Board :'||
628: p_x_fte_source_line_tab(l_count).fob_code,3);
629:
630: oe_debug_pub.Add('Intermediate Ship :'||
631: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);

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

626:
627: oe_debug_pub.Add('Freight on Board :'||
628: p_x_fte_source_line_tab(l_count).fob_code,3);
629:
630: oe_debug_pub.Add('Intermediate Ship :'||
631: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);
632:
633: oe_debug_pub.Add('-------------------------------',3);
634: END IF;

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

629:
630: oe_debug_pub.Add('Intermediate Ship :'||
631: p_x_fte_source_line_tab(l_count).intmed_ship_to_site_id,3);
632:
633: oe_debug_pub.Add('-------------------------------',3);
634: END IF;
635:
636: -- Store the old ship method code in the line table
637:

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

658:
659: FND_MESSAGE.Set_Name('ONT','ONT_FTE_NO_LINES_ELIGIBLE');
660: OE_MSG_PUB.Add;
661: IF l_debug_level > 0 THEN
662: OE_DEBUG_PUB.Add('No lines of the order are eligible for freight rating');
663: END IF;
664: END IF;
665:
666: IF l_debug_level > 0 THEN

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

663: END IF;
664: END IF;
665:
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.Add('FTE Input count:'||p_x_fte_source_line_tab.count,3);
668: oe_debug_pub.Add('Total count:'|| p_x_line_tbl.count,3);
669: END IF;
670:
671: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');

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

664: END IF;
665:
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.Add('FTE Input count:'||p_x_fte_source_line_tab.count,3);
668: oe_debug_pub.Add('Total count:'|| p_x_line_tbl.count,3);
669: END IF;
670:
671: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');
672: EXCEPTION

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

672: EXCEPTION
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.Add('Expected Error in Create FTE Input',2);
677: END IF;
678:
679: x_return_status := FND_API.G_RET_STS_ERROR;
680:

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

679: x_return_status := FND_API.G_RET_STS_ERROR;
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);
684: END IF;
685:
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687:

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

745: l_change_sequence VARCHAR2(50);
746: l_source_document_id NUMBER;
747: l_source_document_line_id NUMBER;
748: l_source_document_type_id NUMBER;
749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
750: BEGIN
751:
752: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Process_FTE_Output..');
753:

Line 759: oe_debug_pub.Add('Total Number of Config lines:'||p_config_count,3);

755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756: l_line_offset := p_config_count + 1;
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.Add('Total Number of Config lines:'||p_config_count,3);
760: oe_debug_pub.Add('Line Offset is :'||l_line_offset,3);
761: END IF;
762:
763: WHILE l_fte_count IS NOT NULL

Line 760: oe_debug_pub.Add('Line Offset is :'||l_line_offset,3);

756: l_line_offset := p_config_count + 1;
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.Add('Total Number of Config lines:'||p_config_count,3);
760: oe_debug_pub.Add('Line Offset is :'||l_line_offset,3);
761: END IF;
762:
763: WHILE l_fte_count IS NOT NULL
764: LOOP

Line 766: oe_debug_pub.Add('--------- FTE Results ----------',3);

762:
763: WHILE l_fte_count IS NOT NULL
764: LOOP
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.Add('--------- FTE Results ----------',3);
767:
768: oe_debug_pub.Add('Source Line :'||
769: p_x_fte_source_line_tab(l_fte_count).source_line_id,3);
770:

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

764: LOOP
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.Add('--------- FTE Results ----------',3);
767:
768: oe_debug_pub.Add('Source Line :'||
769: p_x_fte_source_line_tab(l_fte_count).source_line_id,3);
770:
771: oe_debug_pub.Add('Ship Method :'||
772: p_x_fte_source_line_tab(l_fte_count).ship_method_code,3);

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

767:
768: oe_debug_pub.Add('Source Line :'||
769: p_x_fte_source_line_tab(l_fte_count).source_line_id,3);
770:
771: oe_debug_pub.Add('Ship Method :'||
772: p_x_fte_source_line_tab(l_fte_count).ship_method_code,3);
773:
774: oe_debug_pub.Add('Frieght Carrier :'||
775: p_x_fte_source_line_tab(l_fte_count).freight_carrier_code,3);

Line 774: oe_debug_pub.Add('Frieght Carrier :'||

770:
771: oe_debug_pub.Add('Ship Method :'||
772: p_x_fte_source_line_tab(l_fte_count).ship_method_code,3);
773:
774: oe_debug_pub.Add('Frieght Carrier :'||
775: p_x_fte_source_line_tab(l_fte_count).freight_carrier_code,3);
776:
777: oe_debug_pub.Add('Service Level :' ||
778: p_x_fte_source_line_tab(l_fte_count).service_level,3);

Line 777: oe_debug_pub.Add('Service Level :' ||

773:
774: oe_debug_pub.Add('Frieght Carrier :'||
775: p_x_fte_source_line_tab(l_fte_count).freight_carrier_code,3);
776:
777: oe_debug_pub.Add('Service Level :' ||
778: p_x_fte_source_line_tab(l_fte_count).service_level,3);
779:
780: oe_debug_pub.Add('Mode of Transport :'||
781: p_x_fte_source_line_tab(l_fte_count).mode_of_transport,3);

Line 780: oe_debug_pub.Add('Mode of Transport :'||

776:
777: oe_debug_pub.Add('Service Level :' ||
778: p_x_fte_source_line_tab(l_fte_count).service_level,3);
779:
780: oe_debug_pub.Add('Mode of Transport :'||
781: p_x_fte_source_line_tab(l_fte_count).mode_of_transport,3);
782:
783: oe_debug_pub.Add('Frieght Terms :'||
784: p_x_fte_source_line_tab(l_fte_count).freight_terms,3);

Line 783: oe_debug_pub.Add('Frieght Terms :'||

779:
780: oe_debug_pub.Add('Mode of Transport :'||
781: p_x_fte_source_line_tab(l_fte_count).mode_of_transport,3);
782:
783: oe_debug_pub.Add('Frieght Terms :'||
784: p_x_fte_source_line_tab(l_fte_count).freight_terms,3);
785:
786: oe_debug_pub.Add('Weight :'||
787: p_x_fte_source_line_tab(l_fte_count).weight,3);

Line 786: oe_debug_pub.Add('Weight :'||

782:
783: oe_debug_pub.Add('Frieght Terms :'||
784: p_x_fte_source_line_tab(l_fte_count).freight_terms,3);
785:
786: oe_debug_pub.Add('Weight :'||
787: p_x_fte_source_line_tab(l_fte_count).weight,3);
788:
789: oe_debug_pub.Add('Weight UOM :'||
790: p_x_fte_source_line_tab(l_fte_count).weight_uom_code,3);

Line 789: oe_debug_pub.Add('Weight UOM :'||

785:
786: oe_debug_pub.Add('Weight :'||
787: p_x_fte_source_line_tab(l_fte_count).weight,3);
788:
789: oe_debug_pub.Add('Weight UOM :'||
790: p_x_fte_source_line_tab(l_fte_count).weight_uom_code,3);
791:
792: oe_debug_pub.Add('Volume :'||
793: p_x_fte_source_line_tab(l_fte_count).volume,3);

Line 792: oe_debug_pub.Add('Volume :'||

788:
789: oe_debug_pub.Add('Weight UOM :'||
790: p_x_fte_source_line_tab(l_fte_count).weight_uom_code,3);
791:
792: oe_debug_pub.Add('Volume :'||
793: p_x_fte_source_line_tab(l_fte_count).volume,3);
794:
795: oe_debug_pub.Add('Volume UOM :'||
796: p_x_fte_source_line_tab(l_fte_count).volume_uom_code,3);

Line 795: oe_debug_pub.Add('Volume UOM :'||

791:
792: oe_debug_pub.Add('Volume :'||
793: p_x_fte_source_line_tab(l_fte_count).volume,3);
794:
795: oe_debug_pub.Add('Volume UOM :'||
796: p_x_fte_source_line_tab(l_fte_count).volume_uom_code,3);
797:
798: oe_debug_pub.Add('Frieght Rate :'||
799: p_x_fte_source_line_tab(l_fte_count).freight_rate,3);

Line 798: oe_debug_pub.Add('Frieght Rate :'||

794:
795: oe_debug_pub.Add('Volume UOM :'||
796: p_x_fte_source_line_tab(l_fte_count).volume_uom_code,3);
797:
798: oe_debug_pub.Add('Frieght Rate :'||
799: p_x_fte_source_line_tab(l_fte_count).freight_rate,3);
800:
801: oe_debug_pub.Add('Frieght Rate Currency :'||
802: p_x_fte_source_line_tab(l_fte_count).freight_rate_currency,3);

Line 801: oe_debug_pub.Add('Frieght Rate Currency :'||

797:
798: oe_debug_pub.Add('Frieght Rate :'||
799: p_x_fte_source_line_tab(l_fte_count).freight_rate,3);
800:
801: oe_debug_pub.Add('Frieght Rate Currency :'||
802: p_x_fte_source_line_tab(l_fte_count).freight_rate_currency,3);
803:
804: oe_debug_pub.Add('Status :'||
805: p_x_fte_source_line_tab(l_fte_count).status,3);

Line 804: oe_debug_pub.Add('Status :'||

800:
801: oe_debug_pub.Add('Frieght Rate Currency :'||
802: p_x_fte_source_line_tab(l_fte_count).freight_rate_currency,3);
803:
804: oe_debug_pub.Add('Status :'||
805: p_x_fte_source_line_tab(l_fte_count).status,3);
806:
807: END IF;
808:

Line 816: oe_debug_pub.add('Getting reference data for line_id:'||

812: IF p_x_fte_source_line_tab(l_fte_count).source_line_id IS NOT NULL AND
813: p_x_fte_source_line_tab(l_fte_count).source_line_id <> FND_API.G_MISS_NUM THEN
814: BEGIN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('Getting reference data for line_id:'||
817: p_x_fte_source_line_tab(l_fte_count).source_line_id);
818: END IF;
819: SELECT order_source_id, orig_sys_document_ref, orig_sys_line_ref,
820: orig_sys_shipment_ref, change_sequence, source_document_id,

Line 830: oe_debug_pub.add('No_data_found while getting reference data '||

826: WHERE line_id = p_x_fte_source_line_tab(l_fte_count).source_line_id;
827: EXCEPTION
828: WHEN NO_DATA_FOUND THEN
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add('No_data_found while getting reference data '||
831: 'for line_id:'||p_x_fte_source_line_tab(l_fte_count).source_line_id);
832: END IF;
833: l_order_source_id := NULL;
834: l_orig_sys_document_ref := NULL;

Line 860: oe_debug_pub.Add

856: ,p_source_document_type_id => l_source_document_type_id);
857:
858: OE_MSG_PUB.Add_Text(p_x_fte_source_line_tab(l_fte_count).message_data);
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.Add
861: ('FTE Error :'|| p_x_fte_source_line_tab(l_fte_count).message_data,3);
862: END IF;
863: p_x_line_tbl(l_line_offset).operation := OE_GLOBALS.G_OPR_NONE;
864: x_no_opr_count := x_no_opr_count + 1;

Line 873: oe_debug_pub.Add

869: IF p_x_fte_source_line_tab(l_fte_count).status = 'W' THEN
870: OE_MSG_PUB.Add_Text
871: (p_x_fte_source_line_tab(l_fte_count).message_data);
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.Add
874: ('FTE Warning:'|| p_x_fte_source_line_tab(l_fte_count).message_data,3);
875: END IF;
876: END IF;
877:

Line 887: oe_debug_pub.Add('Change :'|| p_x_line_tbl(l_line_offset).line_id,3);

883: (p_x_fte_source_line_tab(l_fte_count).freight_terms) =
884: nvl(p_x_line_tbl(l_line_offset).freight_terms_code,'-99')
885: THEN
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.Add('Change :'|| p_x_line_tbl(l_line_offset).line_id,3);
888: END IF;
889:
890: p_x_line_tbl(l_line_offset).shipping_method_code :=
891: p_x_fte_source_line_tab(l_fte_count).ship_method_code;

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

906: /* End Audit Trail */
907:
908: ELSE -- no change, set the operation to none.
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add('No Changes to save', 4);
911: END IF;
912: p_x_line_tbl(l_line_offset).operation := OE_GLOBALS.G_OPR_NONE;
913: x_no_opr_count := x_no_opr_count + 1;
914: END IF;

Line 930: oe_debug_pub.add('ato model '||p_x_line_tbl(l_line_offset).line_id,3);

926: p_x_line_tbl(l_line_offset).line_id THEN
927:
928: -- This is an ATO Model
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add('ato model '||p_x_line_tbl(l_line_offset).line_id,3);
931: END IF;
932:
933: IF p_x_line_tbl(l_index).ato_line_id =
934: p_x_line_tbl(l_line_offset).line_id

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

934: p_x_line_tbl(l_line_offset).line_id
935: THEN
936:
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add('cfg line '|| p_x_line_tbl(l_index).line_id, 3);
939: END IF;
940:
941: IF p_x_line_tbl(l_line_offset).operation = OE_GLOBALS.G_OPR_UPDATE
942: THEN

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

957:
958: /* End Audit Trail */
959:
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.Add('Cascading Ship Method from:' ||
962: p_x_line_tbl(l_line_offset).line_id ||' to ' ||
963: p_x_line_tbl(l_index).line_id,3);
964: END IF;
965:

Line 968: oe_debug_pub.add

964: END IF;
965:
966: END IF;
967: IF l_debug_level > 0 THEN
968: oe_debug_pub.add
969: ('cfg opr '||p_x_line_tbl(l_line_offset).operation, 3);
970: END IF;
971:
972: p_x_line_tbl(l_index).operation :=

Line 993: oe_debug_pub.Add('Expected Error in Process FTE Output', 1);

989: EXCEPTION
990:
991: WHEN FND_API.G_EXC_ERROR THEN
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.Add('Expected Error in Process FTE Output', 1);
994: END IF;
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:

Line 1000: oe_debug_pub.Add('Unexpected Error in Process FTE Output'||

996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.Add('Unexpected Error in Process FTE Output'||
1001: sqlerrm, 2);
1002: END IF;
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004:

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

1062: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1063: l_config_count NUMBER;
1064: l_no_opr_count NUMBER;
1065: l_msg_text VARCHAR2(2000);
1066: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1067: BEGIN
1068:
1069: Print_Time('Entering Process_FTE_Action...'|| p_action);
1070:

Line 1073: oe_debug_pub.add('line id not null, error for now', 1);

1069: Print_Time('Entering Process_FTE_Action...'|| p_action);
1070:
1071: IF p_line_id is not NULL THEN
1072: IF l_debug_level > 0 THEN
1073: oe_debug_pub.add('line id not null, error for now', 1);
1074: END IF;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:

Line 1094: oe_debug_pub.ADD('FTE is NOT Installed!',3);

1090: IF OE_GLOBALS.G_FTE_INSTALLED = 'N' THEN
1091: FND_MESSAGE.Set_Name('ONT','ONT_FTE_NOT_INSTALLED');
1092: OE_MSG_PUB.Add;
1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.ADD('FTE is NOT Installed!',3);
1095: END IF;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: RETURN;
1098: END IF;

Line 1110: oe_debug_pub.Add('After Calling Create FTE Input :'||

1106: ,x_config_count => l_config_count
1107: ,x_return_status => x_return_status);
1108:
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.Add('After Calling Create FTE Input :'||
1111: x_return_status,3);
1112: END IF;
1113:
1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1118: oe_debug_pub.add(x_msg_data,1);

1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add(x_msg_data,1);
1119: END IF;
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122: IF l_debug_level > 0 THEN

Line 1123: oe_debug_pub.Add('Before Calling FTE Process Lines...',3);

1119: END IF;
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.Add('Before Calling FTE Process Lines...',3);
1124: END IF;
1125:
1126: -- Call FTE only if the number of lines is greater than zero.
1127:

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

1138: ,x_msg_count => x_msg_count
1139: ,x_msg_data => x_msg_data );
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.Add('After Calling FTE Process Lines:'||
1143: x_return_status,3);
1144: END IF;
1145:
1146: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1149: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1150: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1151: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1152: IF l_debug_level > 0 THEN
1153: oe_debug_pub.Add(l_msg_text, 3);
1154: END IF;
1155: oe_msg_pub.add_text(p_message_text => l_msg_text);
1156: END LOOP;
1157: END IF;

Line 1166: oe_debug_pub.add('processing o/p for carrier', 1);

1162:
1163: IF p_action = 'B' OR
1164: p_action = 'C' THEN
1165: IF l_debug_level > 0 THEN
1166: oe_debug_pub.add('processing o/p for carrier', 1);
1167: END IF;
1168: Process_FTE_Output
1169: ( p_x_fte_source_line_tab => l_fte_source_line_tab
1170: ,p_x_line_tbl => l_line_tbl

Line 1176: oe_debug_pub.Add('After Calling Process FTE Output: '||

1172: ,x_no_opr_count => l_no_opr_count
1173: ,x_return_status => x_return_status);
1174:
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.Add('After Calling Process FTE Output: '||
1177: x_return_status);
1178: END IF;
1179:
1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1192: oe_debug_pub.Add('Before Calling Update FTE Results...',3);

1188: -- due to the call to FTE.
1189: oe_globals.g_freight_recursion := 'Y';
1190:
1191: IF l_debug_level > 0 THEN
1192: oe_debug_pub.Add('Before Calling Update FTE Results...',3);
1193: END IF;
1194:
1195: -- If there are no lines with operation UPDATE donot call
1196: -- Update Fte Results.

Line 1204: oe_debug_pub.Add('After Calling Update FTE Results...'||

1200: ( p_x_line_tbl => l_line_tbl
1201: ,x_return_status => x_return_status);
1202:
1203: IF l_debug_level > 0 THEN
1204: oe_debug_pub.Add('After Calling Update FTE Results...'||
1205: x_return_status,3);
1206: END IF;
1207:
1208: ELSE

Line 1210: oe_debug_pub.Add('Donot Call Update Results!!:'||l_line_tbl.count,1);

1206: END IF;
1207:
1208: ELSE
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.Add('Donot Call Update Results!!:'||l_line_tbl.count,1);
1211: oe_debug_pub.Add('No of Lines with Opr None:'||l_no_opr_count,1);
1212: END IF;
1213: END IF;
1214:

Line 1211: oe_debug_pub.Add('No of Lines with Opr None:'||l_no_opr_count,1);

1207:
1208: ELSE
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.Add('Donot Call Update Results!!:'||l_line_tbl.count,1);
1211: oe_debug_pub.Add('No of Lines with Opr None:'||l_no_opr_count,1);
1212: END IF;
1213: END IF;
1214:
1215: oe_globals.g_freight_recursion := 'N';

Line 1229: oe_debug_pub.add('processing o/p for rating', 1);

1225:
1226: IF p_action = 'B' OR
1227: p_action = 'R' THEN
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add('processing o/p for rating', 1);
1230: END IF;
1231:
1232: OE_FREIGHT_RATING_PVT.Process_FTE_Output
1233: ( p_header_id => p_header_id

Line 1243: oe_debug_pub.Add('After Calling FREIGHT Process_FTE_Output '||

1239: ,p_call_pricing_for_FR => p_call_pricing_for_FR
1240: ,x_return_status => x_return_status);
1241:
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.Add('After Calling FREIGHT Process_FTE_Output '||
1244: x_return_status,3);
1245: END IF;
1246:
1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1261: oe_debug_pub.Add('Message Count :'||x_msg_count,3);

1257: ( p_count => x_msg_count
1258: ,p_data => x_msg_data);
1259:
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.Add('Message Count :'||x_msg_count,3);
1262: END IF;
1263:
1264: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Process_FTE_Action...');
1265:

Line 1270: oe_debug_pub.Add('Expected Error in Get Ship Method', 1);

1266: EXCEPTION
1267:
1268: WHEN FND_API.G_EXC_ERROR THEN
1269: IF l_debug_level > 0 THEN
1270: oe_debug_pub.Add('Expected Error in Get Ship Method', 1);
1271: END IF;
1272:
1273: OE_MSG_PUB.Count_And_Get
1274: ( p_count => x_msg_count

Line 1281: oe_debug_pub.Add('Unexpected Error in Get Ship Method'||sqlerrm, 2);

1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.Add('Unexpected Error in Get Ship Method'||sqlerrm, 2);
1282: END IF;
1283:
1284: OE_MSG_PUB.Count_And_Get
1285: ( p_count => x_msg_count

Line 1295: oe_debug_pub.Add('When Others in Get Ship Method'||sqlerrm,3);

1291: WHEN OTHERS THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.Add('When Others in Get Ship Method'||sqlerrm,3);
1296: END IF;
1297:
1298: OE_MSG_PUB.Count_And_Get
1299: ( p_count => x_msg_count