[Home] [Help]
27: -- If Yes - Phantom Option Item BOM explosion for internally manufactured item will happen
28: -- If No - Phantom Option Item BOM explosion wont happen for internally manufactured
29: -- Config Item. Eligible WIP issuesed instance part of config WIP job
30: -- will come under phantom option item (as per BOM structure)
31: l_option_expl_profile := NVL(FND_PROFILE.VALUE('CSI_PHANTOM_OPTION_BOM_EXPL'),'Y');
32:
33: IF l_option_expl_profile = 'Y' THEN
34: p_option_expl_flag := 'N';
35: ELSE
250: WHERE instance_id = l_u_instance_rec.instance_id;
251:
252:
253:
254: l_split_flag := nvl(fnd_profile.value('CSI_AUTO_SPLIT_INSTANCE' ),'N');
255: debug(' profile_auto_split : '||l_split_flag);
256:
257: l_order_line_rec := p_order_line_rec;
258: l_cp_ind := 0;
453: -- If Y => Shipping/Warehouse Org will be used for BOM child component
454: -- validation and creation
455: -- If N => Item validation Org will be used for BOM child component
456: -- validation and creation
457: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');
458: --csi_gen_utility_pvt.put_line('Group Explode BOM - l_bom_expl_org_flag - ' || l_bom_expl_org_flag);
459:
460: c_tl_rec.source_transaction_type_id := 51;
461: c_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
5195: debug( 'build_option_child_line_tbl');
5196:
5197: IF p_explosion_level IS NULL OR
5198: p_explosion_level = FND_API.G_MISS_NUM THEN
5199: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));
5200: ELSE
5201: l_csi_bom_explosion_level := p_explosion_level;
5202: END IF;
5203: --
5353: x_return_status := FND_API.G_RET_STS_SUCCESS;
5354:
5355: debug('Start get_trackable_bom_comp_count');
5356:
5357: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));
5358: --
5359: SELECT Bom_Explosion_Temp_S.NextVal INTO l_group_id FROM sys.dual;
5360:
5361: debug('Calling Bompxinq.Exploder_Userexit');
5983: (
5984: p_option_item_id => p_order_line_rec.inventory_item_id
5985: ,p_organization_id => p_order_line_rec.ship_from_org_id
5986: ,p_wip_job_id => l_config_rec.config_wip_job_id --Changed for Bug 14126123
5987: ,p_explosion_level => to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'))
5988: ,p_phantom_option_item_ord_qty => p_order_line_rec.ordered_quantity --Added for bug 12673745
5989: ,x_child_line_tbl => l_child_line_tbl
5990: ,x_return_status => l_return_status
5991: );
9479: -- l_shipment_processed - N => Shipment line not processed
9480: -- Bug 11060276 - Check check_shipment_lines only if this Fulfillment line is linked to
9481: -- other lines
9482: --Added additional If condition for Bug 13437384
9483: l_check_pending_ship_lines := FND_PROFILE.VALUE('CSI_CHECK_PENDING_SHIP_LINES');
9484: IF(NVL(l_check_pending_ship_lines, 'N') = 'Y') THEN
9485: IF NVL(l_order_line_rec.top_model_line_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
9486:
9487: l_shipment_processed := check_shipment_lines(
9883: l_ratio_split_qty := 1;
9884:
9885: IF l_order_line_rec.fulfilled_quantity > 1 THEN
9886:
9887: l_split_flag := nvl(fnd_profile.value('CSI_AUTO_SPLIT_INSTANCE'), 'N');
9888:
9889: -- ER 11683789/12770660
9890: -- The profile is used only when CSI_AUTO_SPLIT_INSTANCE is 'Y'
9891: -- If CSI_OVERRIDE_INSTANCE_SPLIT - Y then it overrides the splitting of
9890: -- The profile is used only when CSI_AUTO_SPLIT_INSTANCE is 'Y'
9891: -- If CSI_OVERRIDE_INSTANCE_SPLIT - Y then it overrides the splitting of
9892: -- non-serial KIT Item with no IB trackable embedded exploded ATO under it
9893: -- If CSI_OVERRIDE_INSTANCE_SPLIT - N then splitting happens for non-serial KIT item
9894: l_override_split_for_kit := NVL(FND_PROFILE.VALUE('CSI_OVERRIDE_INSTANCE_SPLIT'), 'N');
9895:
9896: debug(' auto split profile :'||l_split_flag);
9897: debug(' Split Override profile : '||l_override_split_for_kit);
9898: debug(' Item_type_code : '||l_order_line_rec.item_type_code);
11734: ASO_HANDLE_EXCEPTION EXCEPTION;
11735: BEGIN
11736: SAVEPOINT PROCESS_OLD_ORDER_LINES;
11737: --
11738: l_process_profile := fnd_profile.value('CSI_PROCESS_FULFILL_LINES');
11739: --
11740: if l_process_profile is null then
11741: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');
11742: retcode := 2;
12273: -- Get the Profile Option ID
12274: Begin
12275: select profile_option_id
12276: into l_profile_option_id
12277: from FND_PROFILE_OPTIONS
12278: where upper(profile_option_name) = 'CSI_PROCESS_FULFILL_LINES';
12279: Exception
12280: when no_data_found then
12281: fnd_file.put_line(fnd_file.log,'Unable to find the Profile Option CSI_PROCESS_FULFILL_LINES');
12368: End Loop;
12369: if v_ret_counter = 0 then
12370: fnd_file.put_line(fnd_file.log,'All Old Fulfillable lines have been Processed. Updating the Profile');
12371: -- update the profile
12372: UPDATE fnd_profile_option_values
12373: SET profile_option_value = 'N'
12374: WHERE profile_option_id = l_profile_option_id
12375: AND application_id=542 --fix for the bug 4907945
12376: AND level_id = 10001;