DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on BOM_GLOBALS

Line 1399: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;

1395:
1396: EXCEPTION
1397:
1398: WHEN OTHERS THEN
1399: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: l_err_text := G_PKG_NAME ||' : Utility (Component Replicate) '
1403: || SUBSTR(SQLERRM, 1, 200);

Line 1502: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;

1498: l_comp_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1499:
1500: BEGIN
1501:
1502: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;
1503: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1504:
1505: SELECT operation_seq_num
1506: INTO l_operation_seq_num

Line 1672: , BOM_Globals.Get_Prog_AppId

1668: , NULL /* Cost Factor */
1669: , src_comp_details.required_for_revenue
1670: , src_comp_details.HIGH_QUANTITY
1671: , src_comp_details.component_sequence_id
1672: , BOM_Globals.Get_Prog_AppId
1673: , src_comp_details.wip_supply_type
1674: , DECODE(src_comp_details.supply_locator_id, FND_API.G_MISS_NUM,
1675: NULL, src_comp_details.supply_locator_id)
1676: , src_comp_details.bom_item_type

Line 1694: Bom_Globals.G_BOM_BO,

1690: , src_comp_details.Change_Notice
1691: , src_comp_details.implementation_date/* Implementation Date */
1692: /*
1693: , DECODE(l_Bo_Id,
1694: Bom_Globals.G_BOM_BO,
1695: SYSDATE,
1696: NULL
1697: ) -- Implementation Date
1698: */

Line 1737: , BOM_Globals.Get_Prog_Id

1733: -- )
1734: , l_old_component_sequence_id --Chk this
1735: , src_comp_details.bill_sequence_id
1736: , NULL /* Request Id */
1737: , BOM_Globals.Get_Prog_Id
1738: , SYSDATE /* program_update_date */
1739: , src_comp_details.pick_components
1740: , src_comp_details.original_system_reference
1741: , DECODE( src_comp_details.from_end_item_unit_number

Line 1751: , BOM_Globals.Get_Eco_For_Production

1747: , FND_API.G_MISS_CHAR
1748: , null
1749: , src_comp_details.to_end_item_unit_number
1750: )
1751: , BOM_Globals.Get_Eco_For_Production
1752: -- DECODE( l_Bo_Id, BOM_Globals.G_ECO_BO, l_Eco_For_Production, 2) /* Eco for Production flag */
1753: , src_comp_details.Enforce_Int_Requirements
1754: , src_comp_details.auto_request_material -- Added in 11.5.9 by ADEY
1755: , NULL-- Added by hgelli. Identifies this record as Bom Component.

Line 1752: -- DECODE( l_Bo_Id, BOM_Globals.G_ECO_BO, l_Eco_For_Production, 2) /* Eco for Production flag */

1748: , null
1749: , src_comp_details.to_end_item_unit_number
1750: )
1751: , BOM_Globals.Get_Eco_For_Production
1752: -- DECODE( l_Bo_Id, BOM_Globals.G_ECO_BO, l_Eco_For_Production, 2) /* Eco for Production flag */
1753: , src_comp_details.Enforce_Int_Requirements
1754: , src_comp_details.auto_request_material -- Added in 11.5.9 by ADEY
1755: , NULL-- Added by hgelli. Identifies this record as Bom Component.
1756: , src_comp_details.component_item_id

Line 1916: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;

1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN
1915: --dbms_output.put_line(' SQL Error '||SQLERRM);
1916: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1917:
1918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1919: THEN
1920: l_err_text := G_PKG_NAME ||' : Utility (Related Component Insert) '

Line 2202: , PROGRAM_ID = BOM_Globals.Get_Prog_Id

2198: , INCLUDE_ON_SHIP_DOCS = src_comp.include_on_ship_docs
2199: , LOW_QUANTITY = src_comp.LOW_QUANTITY
2200: , ACD_TYPE = src_comp.acd_type
2201: , PROGRAM_UPDATE_DATE = SYSDATE
2202: , PROGRAM_ID = BOM_Globals.Get_Prog_Id
2203: , OPERATION_LEAD_TIME_PERCENT = src_comp.operation_lead_time_percent
2204: , Original_System_Reference =
2205: src_comp.original_system_reference
2206: , From_End_Item_Unit_Number = src_comp.From_End_Item_Unit_Number

Line 2476: , Bom_Globals.Get_Prog_AppId

2472: , ref_desg.change_notice
2473: , comp.component_sequence_id
2474: , ref_desg.acd_type
2475: , NULL /* Request Id */
2476: , Bom_Globals.Get_Prog_AppId
2477: , Bom_Globals.Get_Prog_Id
2478: , SYSDATE
2479: , ref_desg.attribute_category
2480: , ref_desg.attribute1

Line 2477: , Bom_Globals.Get_Prog_Id

2473: , comp.component_sequence_id
2474: , ref_desg.acd_type
2475: , NULL /* Request Id */
2476: , Bom_Globals.Get_Prog_AppId
2477: , Bom_Globals.Get_Prog_Id
2478: , SYSDATE
2479: , ref_desg.attribute_category
2480: , ref_desg.attribute1
2481: , ref_desg.attribute2

Line 2646: , Bom_Globals.Get_Prog_AppId

2642: , ref_desg.Change_Notice
2643: , dest_comp.component_sequence_id
2644: , ref_desg.acd_type
2645: , NULL /* Request Id */
2646: , Bom_Globals.Get_Prog_AppId
2647: , Bom_Globals.Get_Prog_Id
2648: , SYSDATE
2649: , ref_desg.attribute_category
2650: , ref_desg.attribute1

Line 2647: , Bom_Globals.Get_Prog_Id

2643: , dest_comp.component_sequence_id
2644: , ref_desg.acd_type
2645: , NULL /* Request Id */
2646: , Bom_Globals.Get_Prog_AppId
2647: , Bom_Globals.Get_Prog_Id
2648: , SYSDATE
2649: , ref_desg.attribute_category
2650: , ref_desg.attribute1
2651: , ref_desg.attribute2

Line 2910: , Bom_Globals.Get_Prog_AppId

2906: , dest_comp.component_sequence_id
2907: , sub_comp.acd_type
2908: , sub_comp.Change_Notice
2909: , NULL /* Request Id */
2910: , Bom_Globals.Get_Prog_AppId
2911: , SYSDATE
2912: , sub_comp.attribute_category
2913: , sub_comp.attribute1
2914: , sub_comp.attribute2

Line 2928: , Bom_Globals.Get_Prog_Id

2924: , sub_comp.attribute12
2925: , sub_comp.attribute13
2926: , sub_comp.attribute14
2927: , sub_comp.attribute15
2928: , Bom_Globals.Get_Prog_Id
2929: , sub_comp.Original_System_Reference
2930: , sub_comp.enforce_int_requirements
2931: , sub_comp.component_sequence_id
2932: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp

Line 3080: , Bom_Globals.Get_Prog_AppId

3076: , dest_comp.component_sequence_id
3077: , sub_comp.acd_type
3078: , sub_comp.Change_Notice
3079: , NULL /* Request Id */
3080: , Bom_Globals.Get_Prog_AppId
3081: , SYSDATE
3082: , sub_comp.attribute_category
3083: , sub_comp.attribute1
3084: , sub_comp.attribute2

Line 3098: , Bom_Globals.Get_Prog_Id

3094: , sub_comp.attribute12
3095: , sub_comp.attribute13
3096: , sub_comp.attribute14
3097: , sub_comp.attribute15
3098: , Bom_Globals.Get_Prog_Id
3099: , sub_comp.Original_System_Reference
3100: , sub_comp.enforce_int_requirements
3101: , sub_comp.component_sequence_id
3102: );

Line 4288: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('In Delete_Related_Components' ); END IF;

4284: Procedure Delete_Related_Components(p_src_comp_seq IN NUMBER)
4285: IS
4286: BEGIN
4287:
4288: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('In Delete_Related_Components' ); END IF;
4289: DELETE FROM BOM_COMPONENTS_B
4290: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq;
4291:
4292: DELETE FROM BOM_REFERENCE_DESIGNATORS