[Home] [Help]
1190:
1191: EXCEPTION
1192:
1193: WHEN OTHERS THEN
1194: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1196: THEN
1197: l_err_text := G_PKG_NAME ||' : Utility (Component Replicate) '
1198: || SUBSTR(SQLERRM, 1, 200);
1293: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1294:
1295: BEGIN
1296:
1297: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;
1298: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1299:
1300: SELECT operation_seq_num
1301: INTO l_operation_seq_num
1463: , NULL /* Cost Factor */
1464: , src_comp_details.required_for_revenue
1465: , src_comp_details.HIGH_QUANTITY
1466: , src_comp_details.component_sequence_id
1467: , BOM_Globals.Get_Prog_AppId
1468: , src_comp_details.wip_supply_type
1469: , DECODE(src_comp_details.supply_locator_id, FND_API.G_MISS_NUM,
1470: NULL, src_comp_details.supply_locator_id)
1471: , src_comp_details.bom_item_type
1485: , src_comp_details.Change_Notice
1486: , src_comp_details.implementation_date/* Implementation Date */
1487: /*
1488: , DECODE(l_Bo_Id,
1489: Bom_Globals.G_BOM_BO,
1490: SYSDATE,
1491: NULL
1492: ) -- Implementation Date
1493: */
1528: -- )
1529: , l_old_component_sequence_id --Chk this
1530: , src_comp_details.bill_sequence_id
1531: , NULL /* Request Id */
1532: , BOM_Globals.Get_Prog_Id
1533: , SYSDATE /* program_update_date */
1534: , src_comp_details.pick_components
1535: , src_comp_details.original_system_reference
1536: , DECODE( src_comp_details.from_end_item_unit_number
1542: , FND_API.G_MISS_CHAR
1543: , null
1544: , src_comp_details.to_end_item_unit_number
1545: )
1546: , BOM_Globals.Get_Eco_For_Production
1547: -- DECODE( l_Bo_Id, BOM_Globals.G_ECO_BO, l_Eco_For_Production, 2) /* Eco for Production flag */
1548: , src_comp_details.Enforce_Int_Requirements
1549: , src_comp_details.auto_request_material -- Added in 11.5.9 by ADEY
1550: , NULL-- Added by hgelli. Identifies this record as Bom Component.
1543: , null
1544: , src_comp_details.to_end_item_unit_number
1545: )
1546: , BOM_Globals.Get_Eco_For_Production
1547: -- DECODE( l_Bo_Id, BOM_Globals.G_ECO_BO, l_Eco_For_Production, 2) /* Eco for Production flag */
1548: , src_comp_details.Enforce_Int_Requirements
1549: , src_comp_details.auto_request_material -- Added in 11.5.9 by ADEY
1550: , NULL-- Added by hgelli. Identifies this record as Bom Component.
1551: , src_comp_details.component_item_id
1707:
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: --dbms_output.put_line(' SQL Error '||SQLERRM);
1711: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1712:
1713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: l_err_text := G_PKG_NAME ||' : Utility (Related Component Insert) '
1906: , INCLUDE_ON_SHIP_DOCS = src_comp.include_on_ship_docs
1907: , LOW_QUANTITY = src_comp.LOW_QUANTITY
1908: , ACD_TYPE = src_comp.acd_type
1909: , PROGRAM_UPDATE_DATE = SYSDATE
1910: , PROGRAM_ID = BOM_Globals.Get_Prog_Id
1911: , OPERATION_LEAD_TIME_PERCENT = src_comp.operation_lead_time_percent
1912: , Original_System_Reference =
1913: src_comp.original_system_reference
1914: , From_End_Item_Unit_Number = src_comp.From_End_Item_Unit_Number
2180: , ref_desg.change_notice
2181: , comp.component_sequence_id
2182: , ref_desg.acd_type
2183: , NULL /* Request Id */
2184: , Bom_Globals.Get_Prog_AppId
2185: , Bom_Globals.Get_Prog_Id
2186: , SYSDATE
2187: , ref_desg.attribute_category
2188: , ref_desg.attribute1
2181: , comp.component_sequence_id
2182: , ref_desg.acd_type
2183: , NULL /* Request Id */
2184: , Bom_Globals.Get_Prog_AppId
2185: , Bom_Globals.Get_Prog_Id
2186: , SYSDATE
2187: , ref_desg.attribute_category
2188: , ref_desg.attribute1
2189: , ref_desg.attribute2
2350: , ref_desg.Change_Notice
2351: , dest_comp.component_sequence_id
2352: , ref_desg.acd_type
2353: , NULL /* Request Id */
2354: , Bom_Globals.Get_Prog_AppId
2355: , Bom_Globals.Get_Prog_Id
2356: , SYSDATE
2357: , ref_desg.attribute_category
2358: , ref_desg.attribute1
2351: , dest_comp.component_sequence_id
2352: , ref_desg.acd_type
2353: , NULL /* Request Id */
2354: , Bom_Globals.Get_Prog_AppId
2355: , Bom_Globals.Get_Prog_Id
2356: , SYSDATE
2357: , ref_desg.attribute_category
2358: , ref_desg.attribute1
2359: , ref_desg.attribute2
2614: , dest_comp.component_sequence_id
2615: , sub_comp.acd_type
2616: , sub_comp.Change_Notice
2617: , NULL /* Request Id */
2618: , Bom_Globals.Get_Prog_AppId
2619: , SYSDATE
2620: , sub_comp.attribute_category
2621: , sub_comp.attribute1
2622: , sub_comp.attribute2
2632: , sub_comp.attribute12
2633: , sub_comp.attribute13
2634: , sub_comp.attribute14
2635: , sub_comp.attribute15
2636: , Bom_Globals.Get_Prog_Id
2637: , sub_comp.Original_System_Reference
2638: , sub_comp.enforce_int_requirements
2639: , sub_comp.component_sequence_id
2640: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp
2784: , dest_comp.component_sequence_id
2785: , sub_comp.acd_type
2786: , sub_comp.Change_Notice
2787: , NULL /* Request Id */
2788: , Bom_Globals.Get_Prog_AppId
2789: , SYSDATE
2790: , sub_comp.attribute_category
2791: , sub_comp.attribute1
2792: , sub_comp.attribute2
2802: , sub_comp.attribute12
2803: , sub_comp.attribute13
2804: , sub_comp.attribute14
2805: , sub_comp.attribute15
2806: , Bom_Globals.Get_Prog_Id
2807: , sub_comp.Original_System_Reference
2808: , sub_comp.enforce_int_requirements
2809: , sub_comp.component_sequence_id
2810: );