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

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

25: l_count NUMBER := 0;
26: l_api_version_number CONSTANT NUMBER := 1.0;
27: l_api_name CONSTANT VARCHAR2(30) := 'Is_Activity_Shipping';
28: --
29: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
30: --
31: BEGIN
32:
33: -- Standard call to check for call compatibility

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

94: l_errname VARCHAR2(30);
95: l_errmsg VARCHAR2(2000);
96: l_errstack VARCHAR2(2000);
97: --
98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
99: --
100: BEGIN
101:
102: -- Standard call to check for call compatibility

Line 104: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) ||' '||P_RESULT_CODE , 1 ) ;

100: BEGIN
101:
102: -- Standard call to check for call compatibility
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) ||' '||P_RESULT_CODE , 1 ) ;
105: END IF;
106:
107: IF NOT FND_API.Compatible_API_Call
108: ( l_api_version_number

Line 120: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;

116:
117: IF OE_Validate.Line(p_line_id)
118: THEN
119: IF l_debug_level > 0 THEN
120: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
121: END IF;
122: BEGIN
123: wf_engine.CompleteActivityInternalName('OEOL', to_char(p_line_id), 'SHIP_LINE', p_result_code,true); --14599978
124: EXCEPTION

Line 126: oe_debug_pub.add('Workflow complete activity failed. Raising');

122: BEGIN
123: wf_engine.CompleteActivityInternalName('OEOL', to_char(p_line_id), 'SHIP_LINE', p_result_code,true); --14599978
124: EXCEPTION
125: WHEN OTHERS THEN
126: oe_debug_pub.add('Workflow complete activity failed. Raising');
127: RAISE ;
128: END ;
129: IF l_debug_level > 0 THEN
130: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;

Line 130: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;

126: oe_debug_pub.add('Workflow complete activity failed. Raising');
127: RAISE ;
128: END ;
129: IF l_debug_level > 0 THEN
130: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
131: END IF;
132: END IF;
133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
138: END IF;
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN

Line 155: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

151:
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153:
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
156: END IF;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158:
159: -- Get message count and data

Line 169: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

165:
166: WHEN OTHERS THEN
167:
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
170: END IF;
171:
172: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
173: IF l_errname IS NOT NULL THEN

Line 175: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;

171:
172: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
173: IF l_errname IS NOT NULL THEN
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
176: END IF;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
178: ELSE
179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

212: l_x_msg_data VARCHAR2(2000);
213: l_api_version_number CONSTANT NUMBER := 1.0;
214: l_api_name CONSTANT VARCHAR2(30) := 'Credit_Check';
215: --
216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
217: --
218: BEGIN
219:
220: -- Standard call to check for call compatibility

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

285: l_credit_check_pass VARCHAR2(1);
286: l_api_version_number CONSTANT NUMBER := 1.0;
287: l_api_name CONSTANT VARCHAR2(30) := 'Check_Holds_For_SC';
288: --
289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
290: --
291: BEGIN
292:
293: -- Standard call to check for call compatibility

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

383: l_del_shipping_quantity NUMBER := 0;
384: l_line_id_mod NUMBER; -- Bug 8795918
385:
386: --
387: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
388: --
389: BEGIN
390:
391: IF l_debug_level > 0 THEN

Line 392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;

388: --
389: BEGIN
390:
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
393: END IF;
394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;

Line 416: oe_debug_pub.add( 'ENTERING THE CONVERT LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 3 ) ;

412: FOR l_tbl_index IN p_cal_tolerance_tbl.FIRST .. p_cal_tolerance_tbl.LAST
413: LOOP
414: l_line_id_mod := mod(p_cal_tolerance_tbl(l_tbl_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'ENTERING THE CONVERT LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 3 ) ;
417: END IF;
418: /* Modified for bug 7833591
419: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).line_id := p_cal_tolerance_tbl(l_tbl_index).line_id;
420: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).quantity_to_be_shipped := p_cal_tolerance_tbl(l_tbl_index).quantity_to_be_shipped;*/

Line 427: oe_debug_pub.add( 'PLANNED QUANTITY IS MISSING SETTING IT TO ZERO ' , 3 ) ;

423:
424: /* to fix the bug 2127323 */
425: IF p_cal_tolerance_tbl(l_tbl_index).planned_quantity = FND_API.G_MISS_NUM THEN
426: IF l_debug_level > 0 THEN
427: oe_debug_pub.add( 'PLANNED QUANTITY IS MISSING SETTING IT TO ZERO ' , 3 ) ;
428: END IF;
429:
430: -- l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).planned_quantity := 0; -- Bug 8795918
431: l_cal_tolerance_tbl(l_line_id_mod).planned_quantity := 0;

Line 442: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;

438: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
439: l_planned_quantity_passed := FND_API.G_TRUE;
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
443: END IF;
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
446: END IF;

Line 445: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;

441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
443: END IF;
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
446: END IF;
447: IF l_debug_level > 0 THEN
448: oe_debug_pub.add( 'PLANNED QUANTITY : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .PLANNED_QUANTITY ) , 3 ) ;
449: END IF;

Line 448: oe_debug_pub.add( 'PLANNED QUANTITY : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .PLANNED_QUANTITY ) , 3 ) ;

444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
446: END IF;
447: IF l_debug_level > 0 THEN
448: oe_debug_pub.add( 'PLANNED QUANTITY : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .PLANNED_QUANTITY ) , 3 ) ;
449: END IF;
450:
451: END LOOP;
452:

Line 457: oe_debug_pub.add( 'ENTERING THE LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 2 ) ;

453: FOR l_tbl_index IN p_cal_tolerance_tbl.FIRST .. p_cal_tolerance_tbl.LAST
454: LOOP
455:
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'ENTERING THE LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 2 ) ;
458: END IF;
459: IF l_debug_level > 0 THEN
460: oe_debug_pub.add( 'LINE ID : ' || TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .LINE_ID ) , 2 ) ;
461: END IF;

Line 460: oe_debug_pub.add( 'LINE ID : ' || TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .LINE_ID ) , 2 ) ;

456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'ENTERING THE LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 2 ) ;
458: END IF;
459: IF l_debug_level > 0 THEN
460: oe_debug_pub.add( 'LINE ID : ' || TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .LINE_ID ) , 2 ) ;
461: END IF;
462: -- l_line_rec := OE_Line_Util.Query_Row(p_cal_tolerance_tbl(l_tbl_index).line_id);
463: OE_Line_Util.Query_Row(p_line_id => p_cal_tolerance_tbl(l_tbl_index).line_id,
464: x_line_rec => l_line_rec);

Line 470: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;

466: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
467:
468: l_model_kit_line := FND_API.G_TRUE;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
471: END IF;
472: l_top_model_line_id := l_line_rec.top_model_line_id;
473:
474: END IF;

Line 481: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;

477:
478: IF l_model_kit_line = FND_API.G_TRUE THEN
479:
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
482: END IF;
483: -- l_line_tbl := OE_Config_Util.Query_Options(l_line_rec.top_model_line_id);
484: OE_Config_Util.Query_Options(p_top_model_line_id => l_line_rec.top_model_line_id,
485: x_line_tbl => l_line_tbl);

Line 492: oe_debug_pub.add( 'INDEX/LINE_ID/TOP_MODEL_LINE_ID :'||TO_CHAR ( L_LINE_INDEX ) ||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) ||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .TOP_MODEL_LINE_ID ) , 3 ) ;

488: FOR l_line_index IN 1 .. l_line_tbl.count
489: LOOP
490:
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'INDEX/LINE_ID/TOP_MODEL_LINE_ID :'||TO_CHAR ( L_LINE_INDEX ) ||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) ||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .TOP_MODEL_LINE_ID ) , 3 ) ;
493: END IF;
494: IF l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id THEN
495: l_top_model_index := l_line_index;
496: GOTO END_GET_TOP_MODEL;

Line 503: oe_debug_pub.add( 'TOP MODEL INDEX : '||L_TOP_MODEL_INDEX , 3 ) ;

499: END LOOP;
500: << END_GET_TOP_MODEL >>
501:
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'TOP MODEL INDEX : '||L_TOP_MODEL_INDEX , 3 ) ;
504: END IF;
505:
506: l_temp_line_tbl := l_line_tbl;
507:

Line 515: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;

511:
512: l_line_id_mod := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
513:
514: IF l_debug_level > 0 THEN
515: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
516: END IF;
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
519: END IF;

Line 518: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;

514: IF l_debug_level > 0 THEN
515: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
516: END IF;
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
519: END IF;
520:
521: -- IF l_cal_tolerance_tbl.EXISTS(l_line_tbl(l_line_index).line_id) THEN -- Bug 8795918
522: IF l_cal_tolerance_tbl.EXISTS((l_line_id_mod)) THEN

Line 527: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;

523:
524: -- l_temp_line_tbl(l_line_index).shipping_quantity := nvl(l_line_tbl(l_line_index).shipping_quantity,0) + l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).quantity_to_be_shipped; -- Bug 8795918
525: l_temp_line_tbl(l_line_index).shipping_quantity := nvl(l_line_tbl(l_line_index).shipping_quantity,0) + l_cal_tolerance_tbl(l_line_id_mod).quantity_to_be_shipped;
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
528: END IF;
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
531: END IF;

Line 530: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;

526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
528: END IF;
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
531: END IF;
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;
534: END IF;

Line 533: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;

529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
531: END IF;
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;
534: END IF;
535: -- IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).shipping_uom THEN -- Bug 8795918
536: IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_id_mod).shipping_uom THEN
537: IF l_debug_level > 0 THEN

Line 538: oe_debug_pub.add( 'UOMS ARE DIFFRENT ' , 3 ) ;

534: END IF;
535: -- IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).shipping_uom THEN -- Bug 8795918
536: IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_id_mod).shipping_uom THEN
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'UOMS ARE DIFFRENT ' , 3 ) ;
539: END IF;
540: l_temp_line_tbl(l_line_index).shipped_quantity := OE_Order_Misc_Util.Convert_Uom
541: (
542: l_line_rec.inventory_item_id,

Line 554: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;

550: l_temp_line_tbl(l_line_index).shipped_quantity := l_temp_line_tbl(l_line_index).shipping_quantity;
551:
552: END IF;
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
555: END IF;
556: END IF;
557:
558: END LOOP;

Line 569: oe_debug_pub.add( 'RATIO STATUS/RETURN STATUS : '||L_RATIO_STATUS||L_X_RETURN_STATUS , 3 ) ;

565: , x_return_status => l_x_return_status
566: );
567:
568: IF l_debug_level > 0 THEN
569: oe_debug_pub.add( 'RATIO STATUS/RETURN STATUS : '||L_RATIO_STATUS||L_X_RETURN_STATUS , 3 ) ;
570: END IF;
571:
572: IF l_ratio_status = FND_API.G_TRUE THEN
573:

Line 578: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

574: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
575: l_line_rec := l_temp_line_tbl(l_top_model_index);
576:
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
579: END IF;
580: OE_Shipping_Integration_PVT.Check_Shipment_Line
581: (
582: p_line_rec => l_line_rec,

Line 591: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;

587: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
588: l_planned_quantity_passed = FND_API.G_TRUE THEN
589:
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;
592: END IF;
593:
594: -- Tolerance needs to be updated so that ship confirm can result
595: -- in split.

Line 604: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;

600: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
601: LOOP
602:
603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
605: END IF;
606: IF l_debug_level > 0 THEN
607: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
608: END IF;

Line 607: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;

603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
605: END IF;
606: IF l_debug_level > 0 THEN
607: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
608: END IF;
609:
610: -- IF l_cal_tolerance_tbl.EXISTS(l_line_tbl(l_line_index).line_id) THEN -- Bug 8795918
611: IF l_cal_tolerance_tbl.EXISTS(l_line_id_mod) THEN

Line 619: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;

615: -- l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).quantity_to_be_shipped + Bug 8795918
616: -- nvl(l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).planned_quantity,0);
617:
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
620: END IF;
621: -- IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).shipping_uom THEN -- Bug 8795918
622: IF l_line_tbl(l_line_index).order_quantity_uom <> l_cal_tolerance_tbl(l_line_id_mod).shipping_uom THEN
623: l_temp_line_tbl(l_line_index).shipped_quantity := OE_Order_Misc_Util.Convert_Uom

Line 636: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;

632: ELSE
633: l_temp_line_tbl(l_line_index).shipped_quantity := l_temp_line_tbl(l_line_index).shipping_quantity;
634: END IF;
635: IF l_debug_level > 0 THEN
636: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
637: END IF;
638: END IF;
639:
640: END LOOP;

Line 655: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

651: l_ordered_quantity := l_temp_line_tbl(l_top_model_index).ordered_quantity;
652: l_line_rec := l_temp_line_tbl(l_top_model_index);
653:
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
656: END IF;
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
659: END IF;

Line 658: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;

654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
656: END IF;
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
659: END IF;
660:
661: -- Get the total ordered and shipped quantities if it is a part of
662: -- a line set.

Line 681: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;

677: x_msg_data => l_msg_data
678: );
679:
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
682: END IF;
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
685: END IF;

Line 684: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;

680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
682: END IF;
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
685: END IF;
686: l_shipped_quantity := l_shipped_quantity + l_x_shipped_quantity;
687: l_ordered_quantity := l_x_ordered_quantity;
688:

Line 693: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;

689: END IF;
690:
691: -- Calculate the new tolerance value
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
694: END IF;
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
697: END IF;

Line 696: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
694: END IF;
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
697: END IF;
698:
699: l_ship_tolerance := ((l_ordered_quantity - l_shipped_quantity)/l_ordered_quantity) * 100;
700: IF l_ship_tolerance < 0 THEN

Line 704: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;

700: IF l_ship_tolerance < 0 THEN
701: l_ship_tolerance := 0;
702: END IF;
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
705: END IF;
706: x_update_tolerance_flag := FND_API.G_TRUE;
707: x_ship_tolerance := l_ship_tolerance;
708: ELSE

Line 714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;

710: END IF;
711:
712: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
715: END IF;
716: x_ship_beyond_tolerance := FND_API.G_TRUE;
717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

Line 720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

716: x_ship_beyond_tolerance := FND_API.G_TRUE;
717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
721: END IF;
722: x_shipped_within_tolerance := FND_API.G_TRUE;
723: END IF;
724:

Line 731: oe_debug_pub.add( 'IT IS A STANDARD LINE ' , 3 ) ;

727: END IF;
728:
729: ELSE
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add( 'IT IS A STANDARD LINE ' , 3 ) ;
732: END IF;
733:
734: IF l_line_rec.line_set_id IS NOT NULL THEN
735:

Line 737: oe_debug_pub.add( 'LINE SET ID NOT NULL '||L_LINE_REC.LINE_SET_ID , 3 ) ;

733:
734: IF l_line_rec.line_set_id IS NOT NULL THEN
735:
736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( 'LINE SET ID NOT NULL '||L_LINE_REC.LINE_SET_ID , 3 ) ;
738: END IF;
739: SELECT count(*)
740: INTO l_count_unshipped
741: FROM oe_order_lines

Line 747: oe_debug_pub.add( 'COUNT '||L_COUNT_UNSHIPPED , 3 ) ;

743: AND shipped_quantity IS NULL
744: AND line_id <> l_line_rec.line_id ;
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'COUNT '||L_COUNT_UNSHIPPED , 3 ) ;
748: END IF;
749:
750: IF nvl(l_count_unshipped,0) > 0 THEN
751:

Line 774: oe_debug_pub.add( 'DELIVERY SHIPPING QUANTITY '||L_DEL_SHIPPING_QUANTITY , 3 ) ;

770:
771: END;
772:
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add( 'DELIVERY SHIPPING QUANTITY '||L_DEL_SHIPPING_QUANTITY , 3 ) ;
775: END IF;
776:
777: END IF; /* unshipped count more than 0 */
778:

Line 792: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

788: l_line_rec.order_quantity_uom,
789: l_line_rec.shipping_quantity
790: );
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
793: END IF;
794: ELSE
795: l_shipped_quantity := l_line_rec.shipping_quantity;
796: END IF;

Line 802: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

798: -- Check if the current quantity shipping will fulfill the line within
799: -- tolerance.
800:
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
803: END IF;
804: OE_Shipping_Integration_PVT.Check_Shipment_Line
805: (
806: p_line_rec => l_line_rec,

Line 815: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;

811: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
812: l_planned_quantity_passed = FND_API.G_TRUE THEN
813:
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;
816: END IF;
817:
818: -- Tolerance needs to be updated so that ship confirm can result
819: -- in split.

Line 825: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

821: l_shipped_quantity := 0;
822: l_line_rec.shipping_quantity := p_cal_tolerance_tbl(1).quantity_to_be_shipped + p_cal_tolerance_tbl(1).planned_quantity;
823: l_ordered_quantity := l_line_rec.ordered_quantity;
824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
826: END IF;
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
829: END IF;

Line 828: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;

824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
826: END IF;
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
829: END IF;
830: IF l_line_rec.order_quantity_uom <> p_cal_tolerance_tbl(1).shipping_uom THEN
831: l_shipped_quantity := OE_Order_Misc_Util.Convert_Uom
832: (

Line 839: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

835: l_line_rec.order_quantity_uom,
836: l_line_rec.shipping_quantity
837: );
838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
840: END IF;
841: ELSE
842: l_shipped_quantity := l_line_rec.shipping_quantity;
843: END IF;

Line 846: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

842: l_shipped_quantity := l_line_rec.shipping_quantity;
843: END IF;
844:
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
847: END IF;
848:
849: -- Get the total ordered and shipped quantities if it is a part of
850: -- a line set.

Line 869: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;

865: x_msg_data => l_msg_data
866: );
867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
873: END IF;

Line 872: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;

868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
873: END IF;
874: l_shipped_quantity := l_shipped_quantity + l_x_shipped_quantity;
875: l_ordered_quantity := l_x_ordered_quantity;
876:

Line 881: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;

877: END IF;
878:
879: -- Calculate the new tolerance value
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
882: END IF;
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
885: END IF;

Line 884: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
882: END IF;
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
885: END IF;
886:
887: l_ship_tolerance := ((l_ordered_quantity - l_shipped_quantity)/l_ordered_quantity) * 100;
888: IF l_ship_tolerance < 0 THEN

Line 892: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;

888: IF l_ship_tolerance < 0 THEN
889: l_ship_tolerance := 0;
890: END IF;
891: IF l_debug_level > 0 THEN
892: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
893: END IF;
894: x_update_tolerance_flag := FND_API.G_TRUE;
895: x_ship_tolerance := l_ship_tolerance;
896:

Line 903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN
903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
904: END IF;
905: x_shipped_within_tolerance := FND_API.G_TRUE;
906: END IF;
907:

Line 913: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;

909:
910:
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912: IF l_debug_level > 0 THEN
913: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
914: END IF;
915:
916: EXCEPTION
917:

Line 931: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929:
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
932: END IF;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934:
935: -- Get message count and data

Line 945: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

941:
942: WHEN OTHERS THEN
943:
944: IF l_debug_level > 0 THEN
945: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

989: l_x_shipped_quantity NUMBER;
990: l_x_shipping_quantity NUMBER;
991:
992: --
993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
994: --
995: BEGIN
996:
997: -- Standard call to check for call compatibility

Line 999: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;

995: BEGIN
996:
997: -- Standard call to check for call compatibility
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;
1000: END IF;
1001:
1002: IF NOT FND_API.Compatible_API_Call
1003: ( l_api_version_number

Line 1027: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;

1023: x_shipping_quantity := l_x_shipping_quantity;
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: IF l_debug_level > 0 THEN
1027: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;
1028: END IF;
1029: EXCEPTION
1030:
1031: WHEN NO_DATA_FOUND THEN

Line 1045: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1041:
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043:
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1046: END IF;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048:
1049: -- Get message count and data

Line 1059: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1055:
1056: WHEN OTHERS THEN
1057:
1058: IF l_debug_level > 0 THEN
1059: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1060: END IF;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062:
1063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1095: l_top_model_line_id Number;
1096: l_item_type_code Varchar2(30);
1097: l_smc_flag Varchar2(1);
1098: --
1099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1100: --
1101: l_is_op_create VARCHAR2(1) := 'N';
1102: BEGIN
1103:

Line 1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;

1101: l_is_op_create VARCHAR2(1) := 'N';
1102: BEGIN
1103:
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1106: END IF;
1107:
1108: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1109: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

Line 1116: oe_debug_pub.add( 'LINE ID IS NULL ' , 1 ) ;

1112: IF p_line_id IS NULL OR
1113: p_line_id = FND_API.G_MISS_NUM THEN
1114:
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add( 'LINE ID IS NULL ' , 1 ) ;
1117: END IF;
1118:
1119: FND_MESSAGE.SET_NAME('ONT','OE_SHP_LINE_ID_MISSING');
1120: OE_MSG_PUB.ADD;

Line 1129: oe_debug_pub.add( 'INVALID VALUE FOR SHIPPING INTERFACED FLAG' , 1 ) ;

1125: IF p_shipping_interfaced_flag IS NOT NULL AND
1126: p_shipping_interfaced_flag NOT IN ('Y','N') THEN
1127:
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'INVALID VALUE FOR SHIPPING INTERFACED FLAG' , 1 ) ;
1130: END IF;
1131:
1132: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1192: oe_debug_pub.add('Do not update flow status ');

1188: /* comenting following lines because of bug 1880716
1189: IF (l_line_tbl(1).item_type_code = 'CONFIG') OR
1190: (l_line_tbl(1).item_type_code IN ('STANDARD','OPTION') AND -- 1820608
1191: l_line_tbl(1).ato_line_id IS NOT NULL) THEN
1192: oe_debug_pub.add('Do not update flow status ');
1193: ELSE
1194: oe_debug_pub.add('Update flow status ');
1195: l_line_tbl(1).flow_status_code := 'AWAITING_SHIPPING';
1196: END IF;

Line 1194: oe_debug_pub.add('Update flow status ');

1190: (l_line_tbl(1).item_type_code IN ('STANDARD','OPTION') AND -- 1820608
1191: l_line_tbl(1).ato_line_id IS NOT NULL) THEN
1192: oe_debug_pub.add('Do not update flow status ');
1193: ELSE
1194: oe_debug_pub.add('Update flow status ');
1195: l_line_tbl(1).flow_status_code := 'AWAITING_SHIPPING';
1196: END IF;
1197: */
1198:

Line 1238: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;

1234: p_line_id => p_line_id,
1235: x_index => l_index,
1236: x_return_status => x_return_status);
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;
1239: END IF;
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1242: END IF;

Line 1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;

1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;
1239: END IF;
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1242: END IF;
1243:
1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;

Line 1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;

1335: END IF; -- Firm flag
1336: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.
1337:
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1340: END IF;
1341:
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:

Line 1369: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1365: , p_data => x_msg_data
1366: );
1367:
1368: IF l_debug_level > 0 THEN
1369: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1370: END IF;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372:
1373: WHEN OTHERS THEN

Line 1393: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1389: , p_data => x_msg_data
1390: );
1391:
1392: IF l_debug_level > 0 THEN
1393: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1394: END IF;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:
1397: END Update_Shipping_Interface;

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

1436: l_top_model_line_id NUMBER;
1437: l_ato_line_id NUMBER;
1438:
1439: --
1440: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1441: --
1442: BEGIN
1443:
1444: IF l_debug_level > 0 THEN

Line 1445: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;

1441: --
1442: BEGIN
1443:
1444: IF l_debug_level > 0 THEN
1445: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_SUCCESS;
1449: /*

Line 1476: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;

1472: x_msg_data => x_msg_data
1473: );
1474:
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
1477: END IF;
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1480: END IF;

Line 1479: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;

1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
1477: END IF;
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1480: END IF;
1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1483: END IF;

Line 1482: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;

1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1480: END IF;
1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1483: END IF;
1484: IF l_debug_level > 0 THEN
1485: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1486: END IF;

Line 1485: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;

1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1483: END IF;
1484: IF l_debug_level > 0 THEN
1485: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1486: END IF;
1487:
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

Line 1489: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

1485: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1486: END IF;
1487:
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;
1490: END IF;
1491:
1492: EXCEPTION
1493:

Line 1511: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1507:
1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1509:
1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1512: END IF;
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1514:
1515: -- Get message count and data

Line 1525: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

1521:
1522: WHEN OTHERS THEN
1523:
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1526: END IF;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528:
1529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1550: ,p_top_model_line_id IN NUMBER
1551: ,p_transactable_flag IN VARCHAR2
1552: ,x_return_status OUT NOCOPY VARCHAR2)
1553: RETURN BOOLEAN IS
1554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1555: l_line_id NUMBER;
1556: BEGIN
1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:

Line 1598: OE_DEBUG_PUB.Add('No Pending_Lines', 1);

1594:
1595: EXCEPTION
1596: WHEN NO_DATA_FOUND THEN
1597: if l_debug_level > 0 then
1598: OE_DEBUG_PUB.Add('No Pending_Lines', 1);
1599: End if;
1600: Return False;
1601:
1602: WHEN OTHERS THEN

Line 1604: OE_DEBUG_PUB.Add('When Others in Check_Pick_pending_Lines'||SqlErrm, 1);

1600: Return False;
1601:
1602: WHEN OTHERS THEN
1603: if l_debug_level > 0 then
1604: OE_DEBUG_PUB.Add('When Others in Check_Pick_pending_Lines'||SqlErrm, 1);
1605: End if;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: End Check_Import_Pending_Lines;
1608:

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

1616:
1617:
1618: l_config_line_id NUMBER;
1619:
1620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1621:
1622: config_line_ship_notified NUMBER := 0;
1623: BEGIN
1624:

Line 1649: oe_debug_pub.add('Config line line_id' || l_config_line_id);

1645: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1646: AND item_type_code = 'CONFIG';
1647:
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add('Config line line_id' || l_config_line_id);
1650: END IF;
1651:
1652:
1653: SELECT 1

Line 1666: oe_debug_pub.add('In NO DATA FOUND - No config lines for this model have been ship notified');

1662: EXCEPTION
1663: WHEN NO_DATA_FOUND THEN
1664: config_line_ship_notified := 0;
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add('In NO DATA FOUND - No config lines for this model have been ship notified');
1667: END IF;
1668: END;
1669:
1670: IF config_line_ship_notified = 1 THEN

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

1694: (p_setsmc_input_rec IN Setsmc_Input_Rec_Type
1695: ,p_setsmc_output_rec OUT NOCOPY /* file.sql.39 change */ Setsmc_Output_Rec_Type
1696: ,x_return_status OUT NOCOPY VARCHAR2)
1697: IS
1698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1699: l_line_id NUMBER;
1700: l_header_id NUMBER := p_setsmc_input_rec.header_id;
1701: l_top_model_line_id NUMBER := p_setsmc_input_rec.top_model_line_id;
1702: l_ship_set_id NUMBER := p_setsmc_input_rec.ship_set_id;

Line 1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);

1703: BEGIN
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705:
1706: IF l_debug_level > 0 THEN
1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1708: oe_debug_pub.add('headerID = '||l_header_id, 3);
1709: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1710: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1711: END IF;

Line 1708: oe_debug_pub.add('headerID = '||l_header_id, 3);

1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705:
1706: IF l_debug_level > 0 THEN
1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1708: oe_debug_pub.add('headerID = '||l_header_id, 3);
1709: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1710: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1711: END IF;
1712: BEGIN

Line 1709: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);

1705:
1706: IF l_debug_level > 0 THEN
1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1708: oe_debug_pub.add('headerID = '||l_header_id, 3);
1709: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1710: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1711: END IF;
1712: BEGIN
1713: SELECT oel.line_id

Line 1710: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);

1706: IF l_debug_level > 0 THEN
1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1708: oe_debug_pub.add('headerID = '||l_header_id, 3);
1709: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1710: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1711: END IF;
1712: BEGIN
1713: SELECT oel.line_id
1714: INTO l_line_id

Line 1741: oe_debug_pub.add('leaving Get_SetSMC_Interface_Status '

1737: -- If some shippable lines are found not interfaced to wsh
1738: p_setsmc_output_rec.x_interface_status := 'N';
1739:
1740: IF l_debug_level > 0 THEN
1741: oe_debug_pub.add('leaving Get_SetSMC_Interface_Status '
1742: || p_setsmc_output_rec.x_interface_status
1743: || '-' || x_return_status, 1);
1744: END IF;
1745: EXCEPTION

Line 1748: oe_debug_pub.add('all shippable lines are interfaced to wsh', 1);

1744: END IF;
1745: EXCEPTION
1746: WHEN NO_DATA_FOUND THEN
1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add('all shippable lines are interfaced to wsh', 1);
1749: END IF;
1750: p_setsmc_output_rec.x_interface_status := 'Y';
1751: END;
1752:

Line 1756: oe_debug_pub.add('OTHERS EXCEPTION ' || sqlerrm, 1);

1752:
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: IF l_debug_level > 0 THEN
1756: oe_debug_pub.add('OTHERS EXCEPTION ' || sqlerrm, 1);
1757: END IF;
1758:
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760: p_setsmc_output_rec.x_interface_status := 'N';