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: wf_engine.CompleteActivityInternalName('OEOL', to_char(p_line_id), 'SHIP_LINE', p_result_code);
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;

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

120: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
121: END IF;
122: wf_engine.CompleteActivityInternalName('OEOL', to_char(p_line_id), 'SHIP_LINE', p_result_code);
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
125: END IF;
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
132: END IF;
133: EXCEPTION
134:
135: WHEN FND_API.G_EXC_ERROR THEN

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

145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
150: END IF;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152:
153: -- Get message count and data

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

159:
160: WHEN OTHERS THEN
161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
164: END IF;
165:
166: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
167: IF l_errname IS NOT NULL THEN

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

165:
166: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
167: IF l_errname IS NOT NULL THEN
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
170: END IF;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: ELSE
173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

206: l_x_msg_data VARCHAR2(2000);
207: l_api_version_number CONSTANT NUMBER := 1.0;
208: l_api_name CONSTANT VARCHAR2(30) := 'Credit_Check';
209: --
210: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
211: --
212: BEGIN
213:
214: -- Standard call to check for call compatibility

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

279: l_credit_check_pass VARCHAR2(1);
280: l_api_version_number CONSTANT NUMBER := 1.0;
281: l_api_name CONSTANT VARCHAR2(30) := 'Check_Holds_For_SC';
282: --
283: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
284: --
285: BEGIN
286:
287: -- Standard call to check for call compatibility

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

376: l_count_unshipped NUMBER := 0;
377: l_del_shipping_quantity NUMBER := 0;
378:
379: --
380: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
381: --
382: BEGIN
383:
384: IF l_debug_level > 0 THEN

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

381: --
382: BEGIN
383:
384: IF l_debug_level > 0 THEN
385: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
386: END IF;
387: -- Standard call to check for call compatibility
388: x_update_tolerance_flag := FND_API.G_FALSE;
389: x_ship_beyond_tolerance := FND_API.G_FALSE;

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

404:
405: FOR l_tbl_index IN p_cal_tolerance_tbl.FIRST .. p_cal_tolerance_tbl.LAST
406: LOOP
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'ENTERING THE CONVERT LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 3 ) ;
409: END IF;
410: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).line_id := p_cal_tolerance_tbl(l_tbl_index).line_id;
411: 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;
412:

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

412:
413: /* to fix the bug 2127323 */
414: IF p_cal_tolerance_tbl(l_tbl_index).planned_quantity = FND_API.G_MISS_NUM THEN
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'PLANNED QUANTITY IS MISSING SETTING IT TO ZERO ' , 3 ) ;
417: END IF;
418:
419: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).planned_quantity := 0;
420:

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

425: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
426: l_planned_quantity_passed := FND_API.G_TRUE;
427: END IF;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
430: END IF;
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
433: END IF;

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

428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
430: END IF;
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
433: END IF;
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'PLANNED QUANTITY : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .PLANNED_QUANTITY ) , 3 ) ;
436: END IF;

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

431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'QUANTITY TO BE SHIPPED : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .QUANTITY_TO_BE_SHIPPED ) , 3 ) ;
433: END IF;
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'PLANNED QUANTITY : '||TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .PLANNED_QUANTITY ) , 3 ) ;
436: END IF;
437:
438: END LOOP;
439:

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

440: FOR l_tbl_index IN p_cal_tolerance_tbl.FIRST .. p_cal_tolerance_tbl.LAST
441: LOOP
442:
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'ENTERING THE LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 2 ) ;
445: END IF;
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'LINE ID : ' || TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .LINE_ID ) , 2 ) ;
448: END IF;

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

443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'ENTERING THE LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 2 ) ;
445: END IF;
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'LINE ID : ' || TO_CHAR ( P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .LINE_ID ) , 2 ) ;
448: END IF;
449: -- l_line_rec := OE_Line_Util.Query_Row(p_cal_tolerance_tbl(l_tbl_index).line_id);
450: OE_Line_Util.Query_Row(p_line_id => p_cal_tolerance_tbl(l_tbl_index).line_id,
451: x_line_rec => l_line_rec);

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

453: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
454:
455: l_model_kit_line := FND_API.G_TRUE;
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
458: END IF;
459: l_top_model_line_id := l_line_rec.top_model_line_id;
460:
461: END IF;

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

464:
465: IF l_model_kit_line = FND_API.G_TRUE THEN
466:
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
469: END IF;
470: -- l_line_tbl := OE_Config_Util.Query_Options(l_line_rec.top_model_line_id);
471: OE_Config_Util.Query_Options(p_top_model_line_id => l_line_rec.top_model_line_id,
472: x_line_tbl => l_line_tbl);

Line 479: 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 ) ;

475: FOR l_line_index IN 1 .. l_line_tbl.count
476: LOOP
477:
478: IF l_debug_level > 0 THEN
479: 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 ) ;
480: END IF;
481: IF l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id THEN
482: l_top_model_index := l_line_index;
483: GOTO END_GET_TOP_MODEL;

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

486: END LOOP;
487: << END_GET_TOP_MODEL >>
488:
489: IF l_debug_level > 0 THEN
490: oe_debug_pub.add( 'TOP MODEL INDEX : '||L_TOP_MODEL_INDEX , 3 ) ;
491: END IF;
492:
493: l_temp_line_tbl := l_line_tbl;
494:

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

496: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
497: LOOP
498:
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
501: END IF;
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
504: END IF;

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

499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
501: END IF;
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
504: END IF;
505:
506: IF l_cal_tolerance_tbl.EXISTS(l_line_tbl(l_line_index).line_id) THEN
507:

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

506: IF l_cal_tolerance_tbl.EXISTS(l_line_tbl(l_line_index).line_id) THEN
507:
508: 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;
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
511: END IF;
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
514: END IF;

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

509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
511: END IF;
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
514: END IF;
515: IF l_debug_level > 0 THEN
516: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;
517: END IF;

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

512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'ORDERED UOM '||L_LINE_TBL ( L_LINE_INDEX ) .ORDER_QUANTITY_UOM , 3 ) ;
514: END IF;
515: IF l_debug_level > 0 THEN
516: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;
517: END IF;
518: 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
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'UOMS ARE DIFFRENT ' , 3 ) ;

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

516: oe_debug_pub.add( 'SHIPPING UOM '||L_CAL_TOLERANCE_TBL ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) .SHIPPING_UOM , 3 ) ;
517: END IF;
518: 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
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'UOMS ARE DIFFRENT ' , 3 ) ;
521: END IF;
522: l_temp_line_tbl(l_line_index).shipped_quantity := OE_Order_Misc_Util.Convert_Uom
523: (
524: l_line_rec.inventory_item_id,

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

531: l_temp_line_tbl(l_line_index).shipped_quantity := l_temp_line_tbl(l_line_index).shipping_quantity;
532:
533: END IF;
534: IF l_debug_level > 0 THEN
535: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
536: END IF;
537: END IF;
538:
539: END LOOP;

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

546: , x_return_status => l_x_return_status
547: );
548:
549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'RATIO STATUS/RETURN STATUS : '||L_RATIO_STATUS||L_X_RETURN_STATUS , 3 ) ;
551: END IF;
552:
553: IF l_ratio_status = FND_API.G_TRUE THEN
554:

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

555: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
556: l_line_rec := l_temp_line_tbl(l_top_model_index);
557:
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
560: END IF;
561: OE_Shipping_Integration_PVT.Check_Shipment_Line
562: (
563: p_line_rec => l_line_rec,

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

568: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
569: l_planned_quantity_passed = FND_API.G_TRUE THEN
570:
571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;
573: END IF;
574:
575: -- Tolerance needs to be updated so that ship confirm can result
576: -- in split.

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

581: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
582: LOOP
583:
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
586: END IF;
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
589: END IF;

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

584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
586: END IF;
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add( 'ITEM TYPE '||L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
589: END IF;
590:
591: IF l_cal_tolerance_tbl.EXISTS(l_line_tbl(l_line_index).line_id) THEN
592:

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

594: l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).quantity_to_be_shipped +
595: nvl(l_cal_tolerance_tbl(l_line_tbl(l_line_index).line_id).planned_quantity,0);
596:
597: IF l_debug_level > 0 THEN
598: oe_debug_pub.add( 'SHIPPING QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPING_QUANTITY ) , 3 ) ;
599: END IF;
600: 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
601: l_temp_line_tbl(l_line_index).shipped_quantity := OE_Order_Misc_Util.Convert_Uom
602: (

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

609: ELSE
610: l_temp_line_tbl(l_line_index).shipped_quantity := l_temp_line_tbl(l_line_index).shipping_quantity;
611: END IF;
612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add( 'SHIPPED QUANTITY '|| TO_CHAR ( L_TEMP_LINE_TBL ( L_LINE_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
614: END IF;
615: END IF;
616:
617: END LOOP;

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

628: l_ordered_quantity := l_temp_line_tbl(l_top_model_index).ordered_quantity;
629: l_line_rec := l_temp_line_tbl(l_top_model_index);
630:
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
633: END IF;
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
636: END IF;

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

631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
633: END IF;
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
636: END IF;
637:
638: -- Get the total ordered and shipped quantities if it is a part of
639: -- a line set.

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

654: x_msg_data => l_msg_data
655: );
656:
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
659: END IF;
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
662: END IF;

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

657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
659: END IF;
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
662: END IF;
663: l_shipped_quantity := l_shipped_quantity + l_x_shipped_quantity;
664: l_ordered_quantity := l_x_ordered_quantity;
665:

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

666: END IF;
667:
668: -- Calculate the new tolerance value
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
671: END IF;
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
674: END IF;

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

669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
671: END IF;
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
674: END IF;
675:
676: l_ship_tolerance := ((l_ordered_quantity - l_shipped_quantity)/l_ordered_quantity) * 100;
677: IF l_ship_tolerance < 0 THEN

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

677: IF l_ship_tolerance < 0 THEN
678: l_ship_tolerance := 0;
679: END IF;
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
682: END IF;
683: x_update_tolerance_flag := FND_API.G_TRUE;
684: x_ship_tolerance := l_ship_tolerance;
685: ELSE

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

687: END IF;
688:
689: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
692: END IF;
693: x_ship_beyond_tolerance := FND_API.G_TRUE;
694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

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

693: x_ship_beyond_tolerance := FND_API.G_TRUE;
694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
698: END IF;
699: x_shipped_within_tolerance := FND_API.G_TRUE;
700: END IF;
701:

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

704: END IF;
705:
706: ELSE
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'IT IS A STANDARD LINE ' , 3 ) ;
709: END IF;
710:
711: IF l_line_rec.line_set_id IS NOT NULL THEN
712:

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

710:
711: IF l_line_rec.line_set_id IS NOT NULL THEN
712:
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'LINE SET ID NOT NULL '||L_LINE_REC.LINE_SET_ID , 3 ) ;
715: END IF;
716: SELECT count(*)
717: INTO l_count_unshipped
718: FROM oe_order_lines

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

720: AND shipped_quantity IS NULL
721: AND line_id <> l_line_rec.line_id ;
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'COUNT '||L_COUNT_UNSHIPPED , 3 ) ;
725: END IF;
726:
727: IF nvl(l_count_unshipped,0) > 0 THEN
728:

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

747:
748: END;
749:
750: IF l_debug_level > 0 THEN
751: oe_debug_pub.add( 'DELIVERY SHIPPING QUANTITY '||L_DEL_SHIPPING_QUANTITY , 3 ) ;
752: END IF;
753:
754: END IF; /* unshipped count more than 0 */
755:

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

765: l_line_rec.order_quantity_uom,
766: l_line_rec.shipping_quantity
767: );
768: IF l_debug_level > 0 THEN
769: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
770: END IF;
771: ELSE
772: l_shipped_quantity := l_line_rec.shipping_quantity;
773: END IF;

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

775: -- Check if the current quantity shipping will fulfill the line within
776: -- tolerance.
777:
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
780: END IF;
781: OE_Shipping_Integration_PVT.Check_Shipment_Line
782: (
783: p_line_rec => l_line_rec,

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

788: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
789: l_planned_quantity_passed = FND_API.G_TRUE THEN
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;
793: END IF;
794:
795: -- Tolerance needs to be updated so that ship confirm can result
796: -- in split.

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

798: l_shipped_quantity := 0;
799: l_line_rec.shipping_quantity := p_cal_tolerance_tbl(1).quantity_to_be_shipped + p_cal_tolerance_tbl(1).planned_quantity;
800: l_ordered_quantity := l_line_rec.ordered_quantity;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
803: END IF;
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
806: END IF;

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

801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
803: END IF;
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
806: END IF;
807: IF l_line_rec.order_quantity_uom <> p_cal_tolerance_tbl(1).shipping_uom THEN
808: l_shipped_quantity := OE_Order_Misc_Util.Convert_Uom
809: (

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

812: l_line_rec.order_quantity_uom,
813: l_line_rec.shipping_quantity
814: );
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'TOTAL QUANTITY TO BE SHIPPED AFTER UOM CONV : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
817: END IF;
818: ELSE
819: l_shipped_quantity := l_line_rec.shipping_quantity;
820: END IF;

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

819: l_shipped_quantity := l_line_rec.shipping_quantity;
820: END IF;
821:
822: IF l_debug_level > 0 THEN
823: oe_debug_pub.add( 'SHIPPED QUANTITY '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
824: END IF;
825:
826: -- Get the total ordered and shipped quantities if it is a part of
827: -- a line set.

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

842: x_msg_data => l_msg_data
843: );
844:
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
847: END IF;
848: IF l_debug_level > 0 THEN
849: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
850: END IF;

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

845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_X_ORDERED_QUANTITY ) , 3 ) ;
847: END IF;
848: IF l_debug_level > 0 THEN
849: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_X_SHIPPED_QUANTITY ) , 3 ) ;
850: END IF;
851: l_shipped_quantity := l_shipped_quantity + l_x_shipped_quantity;
852: l_ordered_quantity := l_x_ordered_quantity;
853:

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

854: END IF;
855:
856: -- Calculate the new tolerance value
857: IF l_debug_level > 0 THEN
858: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
859: END IF;
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
862: END IF;

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

857: IF l_debug_level > 0 THEN
858: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
859: END IF;
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
862: END IF;
863:
864: l_ship_tolerance := ((l_ordered_quantity - l_shipped_quantity)/l_ordered_quantity) * 100;
865: IF l_ship_tolerance < 0 THEN

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

865: IF l_ship_tolerance < 0 THEN
866: l_ship_tolerance := 0;
867: END IF;
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
870: END IF;
871: x_update_tolerance_flag := FND_API.G_TRUE;
872: x_ship_tolerance := l_ship_tolerance;
873:

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

876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
881: END IF;
882: x_shipped_within_tolerance := FND_API.G_TRUE;
883: END IF;
884:

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

886:
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
891: END IF;
892:
893: EXCEPTION
894:

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

904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906:
907: IF l_debug_level > 0 THEN
908: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
909: END IF;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
911:
912: -- Get message count and data

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

918:
919: WHEN OTHERS THEN
920:
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
923: END IF;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925:
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

966: l_x_shipped_quantity NUMBER;
967: l_x_shipping_quantity NUMBER;
968:
969: --
970: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
971: --
972: BEGIN
973:
974: -- Standard call to check for call compatibility

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

972: BEGIN
973:
974: -- Standard call to check for call compatibility
975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;
977: END IF;
978:
979: IF NOT FND_API.Compatible_API_Call
980: ( l_api_version_number

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

1000: x_shipping_quantity := l_x_shipping_quantity;
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:
1003: IF l_debug_level > 0 THEN
1004: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;
1005: END IF;
1006: EXCEPTION
1007:
1008: WHEN NO_DATA_FOUND THEN

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

1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1023: END IF;
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1025:
1026: -- Get message count and data

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

1032:
1033: WHEN OTHERS THEN
1034:
1035: IF l_debug_level > 0 THEN
1036: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039:
1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1072: l_top_model_line_id Number;
1073: l_item_type_code Varchar2(30);
1074: l_smc_flag Varchar2(1);
1075: --
1076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1077: --
1078: l_is_op_create VARCHAR2(1) := 'N';
1079: BEGIN
1080:

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

1078: l_is_op_create VARCHAR2(1) := 'N';
1079: BEGIN
1080:
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1083: END IF;
1084:
1085: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1086: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

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

1089: IF p_line_id IS NULL OR
1090: p_line_id = FND_API.G_MISS_NUM THEN
1091:
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'LINE ID IS NULL ' , 1 ) ;
1094: END IF;
1095:
1096: FND_MESSAGE.SET_NAME('ONT','OE_SHP_LINE_ID_MISSING');
1097: OE_MSG_PUB.ADD;

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

1102: IF p_shipping_interfaced_flag IS NOT NULL AND
1103: p_shipping_interfaced_flag NOT IN ('Y','N') THEN
1104:
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add( 'INVALID VALUE FOR SHIPPING INTERFACED FLAG' , 1 ) ;
1107: END IF;
1108:
1109: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

1165: /* comenting following lines because of bug 1880716
1166: IF (l_line_tbl(1).item_type_code = 'CONFIG') OR
1167: (l_line_tbl(1).item_type_code IN ('STANDARD','OPTION') AND -- 1820608
1168: l_line_tbl(1).ato_line_id IS NOT NULL) THEN
1169: oe_debug_pub.add('Do not update flow status ');
1170: ELSE
1171: oe_debug_pub.add('Update flow status ');
1172: l_line_tbl(1).flow_status_code := 'AWAITING_SHIPPING';
1173: END IF;

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

1167: (l_line_tbl(1).item_type_code IN ('STANDARD','OPTION') AND -- 1820608
1168: l_line_tbl(1).ato_line_id IS NOT NULL) THEN
1169: oe_debug_pub.add('Do not update flow status ');
1170: ELSE
1171: oe_debug_pub.add('Update flow status ');
1172: l_line_tbl(1).flow_status_code := 'AWAITING_SHIPPING';
1173: END IF;
1174: */
1175:

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

1210: p_line_id => p_line_id,
1211: x_index => l_index,
1212: x_return_status => x_return_status);
1213: IF l_debug_level > 0 THEN
1214: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;
1215: END IF;
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1218: END IF;

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

1213: IF l_debug_level > 0 THEN
1214: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;
1215: END IF;
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1218: END IF;
1219:
1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;

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

1310: END IF; -- Firm flag
1311: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.
1312:
1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1315: END IF;
1316:
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:

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

1340: , p_data => x_msg_data
1341: );
1342:
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1345: END IF;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347:
1348: WHEN OTHERS THEN

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

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

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

1411: l_top_model_line_id NUMBER;
1412: l_ato_line_id NUMBER;
1413:
1414: --
1415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1416: --
1417: BEGIN
1418:
1419: IF l_debug_level > 0 THEN

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

1416: --
1417: BEGIN
1418:
1419: IF l_debug_level > 0 THEN
1420: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424: /*

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

1447: x_msg_data => x_msg_data
1448: );
1449:
1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
1452: END IF;
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1455: END IF;

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

1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
1452: END IF;
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1455: END IF;
1456: IF l_debug_level > 0 THEN
1457: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1458: END IF;

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

1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
1455: END IF;
1456: IF l_debug_level > 0 THEN
1457: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1458: END IF;
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1461: END IF;

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

1456: IF l_debug_level > 0 THEN
1457: oe_debug_pub.add( 'SHP RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
1458: END IF;
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1461: END IF;
1462:
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

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

1460: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1461: END IF;
1462:
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;
1465: END IF;
1466:
1467: EXCEPTION
1468:

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

1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1487: END IF;
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489:
1490: -- Get message count and data

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

1496:
1497: WHEN OTHERS THEN
1498:
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1501: END IF;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1525: ,p_top_model_line_id IN NUMBER
1526: ,p_transactable_flag IN VARCHAR2
1527: ,x_return_status OUT NOCOPY VARCHAR2)
1528: RETURN BOOLEAN IS
1529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1530: l_line_id NUMBER;
1531: BEGIN
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533:

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

1569:
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN
1572: if l_debug_level > 0 then
1573: OE_DEBUG_PUB.Add('No Pending_Lines', 1);
1574: End if;
1575: Return False;
1576:
1577: WHEN OTHERS THEN

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

1575: Return False;
1576:
1577: WHEN OTHERS THEN
1578: if l_debug_level > 0 then
1579: OE_DEBUG_PUB.Add('When Others in Check_Pick_pending_Lines'||SqlErrm, 1);
1580: End if;
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: End Check_Import_Pending_Lines;
1583:

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

1591:
1592:
1593: l_config_line_id NUMBER;
1594:
1595: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1596:
1597: config_line_ship_notified NUMBER := 0;
1598: BEGIN
1599:

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

1620: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1621: AND item_type_code = 'CONFIG';
1622:
1623: IF l_debug_level > 0 THEN
1624: oe_debug_pub.add('Config line line_id' || l_config_line_id);
1625: END IF;
1626:
1627:
1628: SELECT 1

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

1637: EXCEPTION
1638: WHEN NO_DATA_FOUND THEN
1639: config_line_ship_notified := 0;
1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add('In NO DATA FOUND - No config lines for this model have been ship notified');
1642: END IF;
1643: END;
1644:
1645: IF config_line_ship_notified = 1 THEN

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

1669: (p_setsmc_input_rec IN Setsmc_Input_Rec_Type
1670: ,p_setsmc_output_rec OUT NOCOPY /* file.sql.39 change */ Setsmc_Output_Rec_Type
1671: ,x_return_status OUT NOCOPY VARCHAR2)
1672: IS
1673: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1674: l_line_id NUMBER;
1675: l_header_id NUMBER := p_setsmc_input_rec.header_id;
1676: l_top_model_line_id NUMBER := p_setsmc_input_rec.top_model_line_id;
1677: l_ship_set_id NUMBER := p_setsmc_input_rec.ship_set_id;

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

1678: BEGIN
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1683: oe_debug_pub.add('headerID = '||l_header_id, 3);
1684: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1685: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1686: END IF;

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

1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1683: oe_debug_pub.add('headerID = '||l_header_id, 3);
1684: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1685: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1686: END IF;
1687: BEGIN

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

1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1683: oe_debug_pub.add('headerID = '||l_header_id, 3);
1684: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1685: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1686: END IF;
1687: BEGIN
1688: SELECT oel.line_id

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

1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1683: oe_debug_pub.add('headerID = '||l_header_id, 3);
1684: oe_debug_pub.add('top_model_line_id = '||l_top_model_line_id, 3);
1685: oe_debug_pub.add('ship_set_id = '||l_ship_set_id, 3);
1686: END IF;
1687: BEGIN
1688: SELECT oel.line_id
1689: INTO l_line_id

Line 1716: oe_debug_pub.add('leaving Get_SetSMC_Interface_Status '

1712: -- If some shippable lines are found not interfaced to wsh
1713: p_setsmc_output_rec.x_interface_status := 'N';
1714:
1715: IF l_debug_level > 0 THEN
1716: oe_debug_pub.add('leaving Get_SetSMC_Interface_Status '
1717: || p_setsmc_output_rec.x_interface_status
1718: || '-' || x_return_status, 1);
1719: END IF;
1720: EXCEPTION

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

1719: END IF;
1720: EXCEPTION
1721: WHEN NO_DATA_FOUND THEN
1722: IF l_debug_level > 0 THEN
1723: oe_debug_pub.add('all shippable lines are interfaced to wsh', 1);
1724: END IF;
1725: p_setsmc_output_rec.x_interface_status := 'Y';
1726: END;
1727:

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

1727:
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: IF l_debug_level > 0 THEN
1731: oe_debug_pub.add('OTHERS EXCEPTION ' || sqlerrm, 1);
1732: END IF;
1733:
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: p_setsmc_output_rec.x_interface_status := 'N';