DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on STANDARD

Line 725: l_line_rec.item_type_code IN ('STANDARD','OPTION','INCLUDED'))) THEN --9775352

721: -- 4437814 start changes
722: IF (l_line_rec.item_type_code = 'CONFIG'
723: OR
724: (l_line_rec.ato_line_id = l_line_rec.line_id AND
725: l_line_rec.item_type_code IN ('STANDARD','OPTION','INCLUDED'))) THEN --9775352
726: --Get the activity result
727: OE_LINE_FULLFILL.Get_Activity_Result
728: (p_item_type => OE_GLOBALS.G_WFI_LIN
729: ,p_item_key => l_line_rec.line_id

Line 1975: OE_DEBUG_PUB.Add('Check the Decimals for Standard Items..Different UOM');

1971: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;
1972: END IF;
1973:
1974: IF l_debug_level > 0 THEN
1975: OE_DEBUG_PUB.Add('Check the Decimals for Standard Items..Different UOM');
1976: OE_DEBUG_PUB.Add('Changes for Bug-3468847');
1977: END IF;
1978:
1979: IF p_line_rec.item_type_code = 'STANDARD' THEN

Line 1979: IF p_line_rec.item_type_code = 'STANDARD' THEN

1975: OE_DEBUG_PUB.Add('Check the Decimals for Standard Items..Different UOM');
1976: OE_DEBUG_PUB.Add('Changes for Bug-3468847');
1977: END IF;
1978:
1979: IF p_line_rec.item_type_code = 'STANDARD' THEN
1980:
1981: SELECT count(*)
1982: INTO l_wdd_count
1983: FROM wsh_delivery_details

Line 2508: bug 2361720: added call to ship_confirm_standard_line if the

2504: finally it prrgressed th fulfillment of non-shippable lines
2505: if not in fulfillment set and are at fulfillment activity.
2506:
2507: Change record:
2508: bug 2361720: added call to ship_confirm_standard_line if the
2509: shipped not in proportion branch, whcih will complete the ATO
2510: model's wait for cto inturn.
2511: ---------------------------------------------------------------*/
2512: PROCEDURE Ship_Confirm_PTO_KIT

Line 2857: Ship_Confirm_Standard_Line

2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add( 'INSIDE THE IF FOR SHIPPABLE LINE : ITEM TYPE : '|| L_LINE_TBL ( L_PTO_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
2855: END IF;
2856:
2857: Ship_Confirm_Standard_Line
2858: ( p_line_rec => l_line_tbl(l_pto_index),
2859: p_shipment_status => l_x_result_out,
2860: x_return_status => x_return_status );
2861:

Line 3043: oe_debug_pub.add( 'CALLING SHIP_CONFIRM_STANDARD_LINE '

3039:
3040: IF l_activity_status = 'NOTIFIED' THEN
3041:
3042: IF l_debug_level > 0 THEN
3043: oe_debug_pub.add( 'CALLING SHIP_CONFIRM_STANDARD_LINE '
3044: || L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID , 3 ) ;
3045: END IF;
3046:
3047: Ship_Confirm_Standard_Line

Line 3047: Ship_Confirm_Standard_Line

3043: oe_debug_pub.add( 'CALLING SHIP_CONFIRM_STANDARD_LINE '
3044: || L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID , 3 ) ;
3045: END IF;
3046:
3047: Ship_Confirm_Standard_Line
3048: ( p_line_rec => l_split_line_tbl(l_split_index),
3049: p_shipment_status => l_x_result_out,
3050: x_return_status => x_return_status );
3051:

Line 3307: PROCEDURE Ship_Confirm_Standard_Line

3303: END Ship_Confirm_PTO_KIT;
3304:
3305:
3306: /*--------------------------------------------------------------*/
3307: PROCEDURE Ship_Confirm_Standard_Line
3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 3341: oe_debug_pub.add( 'ENTERING SHIP_CONFIRM_STANDARD_LINE ' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

3337:
3338: BEGIN
3339:
3340: IF l_debug_level > 0 THEN
3341: oe_debug_pub.add( 'ENTERING SHIP_CONFIRM_STANDARD_LINE ' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
3342: END IF;
3343:
3344: IF g_debug_call > 0 THEN
3345: G_DEBUG_MSG := G_DEBUG_MSG || '101,';

Line 3471: -- Split API is called only for Standard line. For PTO/ATO it

3467: (l_line_rec.top_model_line_id is null OR
3468: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
3469: nvl(l_line_rec.model_remnant_flag,'N') = 'Y') THEN
3470:
3471: -- Split API is called only for Standard line. For PTO/ATO it
3472: -- will be called from respective procedures.
3473: -- Call Split API It should perform the followings :
3474: -- 1. Update the ordered quantity on the old line
3475: -- 2. Create a new line with Shipping_Interfaced_Flag = 'Y'

Line 3519: oe_debug_pub.add('Ship_Confirm_Standard_Line : l_temp_shipped_qty for dual control item is '|| l_temp_shipped_qty);

3515: ,NULL -- To uom name
3516: );
3517:
3518: IF l_debug_level > 0 THEN
3519: oe_debug_pub.add('Ship_Confirm_Standard_Line : l_temp_shipped_qty for dual control item is '|| l_temp_shipped_qty);
3520: END IF;
3521:
3522:
3523: IF g_debug_call > 0 THEN

Line 3735: l_line_rec.item_type_code IN ('STANDARD') THEN

3731: THEN
3732:
3733: IF p_check_line_set = 'Y' AND
3734: l_x_result_out <> OE_GLOBALS.G_PARTIALLY_SHIPPED AND
3735: l_line_rec.item_type_code IN ('STANDARD') THEN
3736:
3737: -- not now 'CONFIG'
3738: -- l_line_rec.ordered_quantity 3739: -- 2617708 OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110508' THEN

Line 3832: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

3828: END IF;
3829: x_return_status := FND_API.G_RET_STS_SUCCESS;
3830:
3831: IF l_debug_level > 0 THEN
3832: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
3833: END IF;
3834:
3835: EXCEPTION
3836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3843: 'Ship_Confirm_Standard_Line'

3839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3840: THEN
3841: OE_MSG_PUB.Add_Exc_Msg
3842: ( G_PKG_NAME,
3843: 'Ship_Confirm_Standard_Line'
3844: );
3845: END IF;
3846: IF g_debug_call > 0 THEN
3847: G_DEBUG_MSG := G_DEBUG_MSG || 'E20';

Line 3852: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;

3848: END IF;
3849:
3850: WHEN FND_API.G_EXC_ERROR THEN
3851: IF l_debug_level > 0 THEN
3852: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;
3853: END IF;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855: IF g_debug_call > 0 THEN
3856: G_DEBUG_MSG := G_DEBUG_MSG || 'E-21';

Line 3869: 'Ship_Confirm_Standard_Line'

3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3868: ( G_PKG_NAME,
3869: 'Ship_Confirm_Standard_Line'
3870: );
3871: END IF;
3872: IF g_debug_call > 0 THEN
3873: G_DEBUG_MSG := G_DEBUG_MSG || 'E22';

Line 3875: END Ship_Confirm_Standard_Line;

3871: END IF;
3872: IF g_debug_call > 0 THEN
3873: G_DEBUG_MSG := G_DEBUG_MSG || 'E22';
3874: END IF;
3875: END Ship_Confirm_Standard_Line;
3876:
3877: /*--------------------------------------------------------------
3878: PROCEDURE Handle_Config_Parent
3879: To progress the ATO parent of config line.

Line 4162: Ship_Confirm_Standard_Line

4158:
4159:
4160: ------- call ship confirm std line to complete wf, flow sts ---
4161:
4162: Ship_Confirm_Standard_Line
4163: (p_line_id => l_line_id,
4164: x_return_status => l_return_status);
4165:
4166: IF g_debug_call > 0 THEN

Line 4274: -- Prepare a table with PTO_KIT/ATO/STANDARD lines.

4270: IF l_debug_level > 0 THEN
4271: oe_debug_pub.add( 'SET IS CLOSED : '||TO_CHAR ( P_SHIP_SET_ID ) , 3 ) ;
4272: END IF;
4273:
4274: -- Prepare a table with PTO_KIT/ATO/STANDARD lines.
4275:
4276: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
4277: LOOP
4278:

Line 4309: ELSIF l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

4305: END IF;
4306: l_process_index := l_process_index + 1;
4307: l_process_tbl(l_process_index) := l_line_tbl(l_line_index);
4308:
4309: ELSIF l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4310:
4311: IF l_debug_level > 0 THEN
4312: oe_debug_pub.add( 'IT IS A STANDARD LINE' , 3 ) ;
4313: END IF;

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

4308:
4309: ELSIF l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4310:
4311: IF l_debug_level > 0 THEN
4312: oe_debug_pub.add( 'IT IS A STANDARD LINE' , 3 ) ;
4313: END IF;
4314: l_process_index := l_process_index + 1;
4315: l_process_tbl(l_process_index) := l_line_tbl(l_line_index);
4316: END IF;

Line 4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

4375: l_process_tbl(l_process_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4376: IF l_debug_level > 0 THEN
4377: oe_debug_pub.add( 'INSIDE THE LOOP : LINE ID : '|| TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4378: END IF;
4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4380: Ship_Confirm_Standard_Line
4381: (
4382: p_line_rec => l_process_tbl(l_process_index),
4383: x_return_status => l_return_status

Line 4380: Ship_Confirm_Standard_Line

4376: IF l_debug_level > 0 THEN
4377: oe_debug_pub.add( 'INSIDE THE LOOP : LINE ID : '|| TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4378: END IF;
4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4380: Ship_Confirm_Standard_Line
4381: (
4382: p_line_rec => l_process_tbl(l_process_index),
4383: x_return_status => l_return_status
4384: );

Line 4631: -- Call procedure for Ship Confirmation of Standard Line

4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: ELSE
4630:
4631: -- Call procedure for Ship Confirmation of Standard Line
4632: IF g_debug_call > 0 THEN
4633: G_DEBUG_MSG := G_DEBUG_MSG || '12-5';
4634: END IF;
4635:

Line 4636: Ship_Confirm_Standard_Line

4632: IF g_debug_call > 0 THEN
4633: G_DEBUG_MSG := G_DEBUG_MSG || '12-5';
4634: END IF;
4635:
4636: Ship_Confirm_Standard_Line
4637: (
4638: p_line_id => p_process_id,
4639: x_return_status => l_x_return_status
4640: );

Line 4724: non SMC and standard lines

4720: This procedure is called from workflow.
4721: It broadly has 3 sections,
4722: external/return lines
4723: SMC lines
4724: non SMC and standard lines
4725:
4726: Change Record : bug fix 3539694 - included items if created
4727: by scheduling wf activity, bypass hvop.
4728: --------------------------------------------------------------*/

Line 5240: ELSE -- standard, non-smc etc

5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5237: RAISE FND_API.G_EXC_ERROR;
5238: END IF;
5239:
5240: ELSE -- standard, non-smc etc
5241:
5242: IF l_shippable_flag = 'Y' THEN
5243:
5244: IF l_debug_level > 0 THEN

Line 5284: (l_item_type_code IN ('STANDARD','OPTION','INCLUDED') AND --9775352

5280: l_flow_status_code := 'AWAITING_SHIPPING';
5281: END IF;
5282:
5283: IF ((l_item_type_code = 'CONFIG' OR
5284: (l_item_type_code IN ('STANDARD','OPTION','INCLUDED') AND --9775352
5285: l_ato_line_id = l_line_id)) AND
5286: l_source_type_code = 'INTERNAL') OR
5287: nvl(l_shippable_flag,'N') = 'N' THEN
5288:

Line 5712: It will be used for standard lines and Config items.

5708: This procedure is used to ship confirm split lines when ship
5709: confirmation of other lines in the line set results in fulfilling
5710: the ordered quantity within or beyond tolerance.
5711:
5712: It will be used for standard lines and Config items.
5713: p_line_rec provide details about the line getting ship confirmed
5714: we need to cehck if due shipment of this line if we need to
5715: close other lines.
5716:

Line 5830: Ship_Confirm_Standard_Line

5826: IF l_debug_level > 0 THEN
5827: oe_debug_pub.add('line set id '|| line_rec.line_set_id , 3 ) ;
5828: END IF;
5829:
5830: Ship_Confirm_Standard_Line
5831: ( p_line_rec => l_line_set_rec,
5832: p_shipment_status => p_shipment_status,
5833: p_check_line_set => 'N',
5834: x_return_status => l_return_status );