DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on FND_MESSAGE

Line 592: err_msg := Fnd_Message.Get_Encoded;

588: Fnd_Msg_Pub.Build_Exc_Msg(
589: p_pkg_name => 'BOMPXINQ',
590: p_procedure_name => 'exploder_userexit',
591: p_error_text => 'verify parameters');
592: err_msg := Fnd_Message.Get_Encoded;
593: WHEN inv_uom_conv_exe THEN
594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
595: fnd_message.Set_Token('FROMUOM',t_master_uom);
596: fnd_message.Set_Token('TOUOM',t_child_uom);

Line 594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');

590: p_procedure_name => 'exploder_userexit',
591: p_error_text => 'verify parameters');
592: err_msg := Fnd_Message.Get_Encoded;
593: WHEN inv_uom_conv_exe THEN
594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
595: fnd_message.Set_Token('FROMUOM',t_master_uom);
596: fnd_message.Set_Token('TOUOM',t_child_uom);
597: fnd_message.raise_error;
598:

Line 595: fnd_message.Set_Token('FROMUOM',t_master_uom);

591: p_error_text => 'verify parameters');
592: err_msg := Fnd_Message.Get_Encoded;
593: WHEN inv_uom_conv_exe THEN
594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
595: fnd_message.Set_Token('FROMUOM',t_master_uom);
596: fnd_message.Set_Token('TOUOM',t_child_uom);
597: fnd_message.raise_error;
598:
599: WHEN OTHERS THEN

Line 596: fnd_message.Set_Token('TOUOM',t_child_uom);

592: err_msg := Fnd_Message.Get_Encoded;
593: WHEN inv_uom_conv_exe THEN
594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
595: fnd_message.Set_Token('FROMUOM',t_master_uom);
596: fnd_message.Set_Token('TOUOM',t_child_uom);
597: fnd_message.raise_error;
598:
599: WHEN OTHERS THEN
600: error_code := SQLCODE;

Line 597: fnd_message.raise_error;

593: WHEN inv_uom_conv_exe THEN
594: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
595: fnd_message.Set_Token('FROMUOM',t_master_uom);
596: fnd_message.Set_Token('TOUOM',t_child_uom);
597: fnd_message.raise_error;
598:
599: WHEN OTHERS THEN
600: error_code := SQLCODE;
601: Fnd_Msg_Pub.Build_Exc_Msg(

Line 605: err_msg := Fnd_Message.Get_Encoded;

601: Fnd_Msg_Pub.Build_Exc_Msg(
602: p_pkg_name => 'BOMPXINQ',
603: p_procedure_name => 'exploder_userexit',
604: p_error_text => SQLERRM);
605: err_msg := Fnd_Message.Get_Encoded;
606: ROLLBACK TO exploder_userexit_pvt; -- Added for bug: 3863319
607: END exploder_userexit;
608:
609: --========================================================================

Line 976: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');

972: WHEN no_level_access THEN
973: rollback ;
974: bom_export_tab.delete;
975: error_code := -122;
976: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
977: Fnd_Message.Set_Token('l_org_name',l_org_name);
978: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
979: Err_Msg := Fnd_Message.Get;
980: WHEN no_organization THEN

Line 977: Fnd_Message.Set_Token('l_org_name',l_org_name);

973: rollback ;
974: bom_export_tab.delete;
975: error_code := -122;
976: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
977: Fnd_Message.Set_Token('l_org_name',l_org_name);
978: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
979: Err_Msg := Fnd_Message.Get;
980: WHEN no_organization THEN
981: rollback ;

Line 978: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);

974: bom_export_tab.delete;
975: error_code := -122;
976: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
977: Fnd_Message.Set_Token('l_org_name',l_org_name);
978: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
979: Err_Msg := Fnd_Message.Get;
980: WHEN no_organization THEN
981: rollback ;
982: bom_export_tab.delete;

Line 979: Err_Msg := Fnd_Message.Get;

975: error_code := -122;
976: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
977: Fnd_Message.Set_Token('l_org_name',l_org_name);
978: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
979: Err_Msg := Fnd_Message.Get;
980: WHEN no_organization THEN
981: rollback ;
982: bom_export_tab.delete;
983: error_code := -121;

Line 984: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');

980: WHEN no_organization THEN
981: rollback ;
982: bom_export_tab.delete;
983: error_code := -121;
984: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
985: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
986: Err_Msg := Fnd_Message.Get;
987: WHEN explode_error THEN
988: rollback;

Line 985: Fnd_Message.Set_Token('l_organization_id',l_organization_id);

981: rollback ;
982: bom_export_tab.delete;
983: error_code := -121;
984: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
985: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
986: Err_Msg := Fnd_Message.Get;
987: WHEN explode_error THEN
988: rollback;
989: bom_export_tab.delete;

Line 986: Err_Msg := Fnd_Message.Get;

982: bom_export_tab.delete;
983: error_code := -121;
984: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
985: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
986: Err_Msg := Fnd_Message.Get;
987: WHEN explode_error THEN
988: rollback;
989: bom_export_tab.delete;
990: error_code := -120;

Line 991: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');

987: WHEN explode_error THEN
988: rollback;
989: bom_export_tab.delete;
990: error_code := -120;
991: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
992: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
993: Fnd_Message.Set_Token('Orgid',l_organization_id);
994: Err_Msg:= Fnd_Message.Get;
995: WHEN no_hierarchy THEN

Line 992: Fnd_Message.Set_Token('Assembly',Assembly_item_id);

988: rollback;
989: bom_export_tab.delete;
990: error_code := -120;
991: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
992: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
993: Fnd_Message.Set_Token('Orgid',l_organization_id);
994: Err_Msg:= Fnd_Message.Get;
995: WHEN no_hierarchy THEN
996: rollback ;

Line 993: Fnd_Message.Set_Token('Orgid',l_organization_id);

989: bom_export_tab.delete;
990: error_code := -120;
991: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
992: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
993: Fnd_Message.Set_Token('Orgid',l_organization_id);
994: Err_Msg:= Fnd_Message.Get;
995: WHEN no_hierarchy THEN
996: rollback ;
997: bom_export_tab.delete;

Line 994: Err_Msg:= Fnd_Message.Get;

990: error_code := -120;
991: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
992: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
993: Fnd_Message.Set_Token('Orgid',l_organization_id);
994: Err_Msg:= Fnd_Message.Get;
995: WHEN no_hierarchy THEN
996: rollback ;
997: bom_export_tab.delete;
998: error_code := -119;

Line 999: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');

995: WHEN no_hierarchy THEN
996: rollback ;
997: bom_export_tab.delete;
998: error_code := -119;
999: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1000: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1001: Err_Msg := Fnd_Message.Get;
1002: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1003: WHEN cost_type THEN

Line 1000: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);

996: rollback ;
997: bom_export_tab.delete;
998: error_code := -119;
999: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1000: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1001: Err_Msg := Fnd_Message.Get;
1002: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1003: WHEN cost_type THEN
1004: rollback ;

Line 1001: Err_Msg := Fnd_Message.Get;

997: bom_export_tab.delete;
998: error_code := -119;
999: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1000: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1001: Err_Msg := Fnd_Message.Get;
1002: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1003: WHEN cost_type THEN
1004: rollback ;
1005: bom_export_tab.delete;

Line 1007: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');

1003: WHEN cost_type THEN
1004: rollback ;
1005: bom_export_tab.delete;
1006: error_code := -118;
1007: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1008: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1009: Fnd_Message.Set_Token('Orgid',l_organization_id);
1010: Err_Msg := Fnd_Message.Get;
1011: WHEN OTHERS THEN

Line 1008: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);

1004: rollback ;
1005: bom_export_tab.delete;
1006: error_code := -118;
1007: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1008: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1009: Fnd_Message.Set_Token('Orgid',l_organization_id);
1010: Err_Msg := Fnd_Message.Get;
1011: WHEN OTHERS THEN
1012: rollback ;

Line 1009: Fnd_Message.Set_Token('Orgid',l_organization_id);

1005: bom_export_tab.delete;
1006: error_code := -118;
1007: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1008: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1009: Fnd_Message.Set_Token('Orgid',l_organization_id);
1010: Err_Msg := Fnd_Message.Get;
1011: WHEN OTHERS THEN
1012: rollback ;
1013: bom_export_tab.delete ;

Line 1010: Err_Msg := Fnd_Message.Get;

1006: error_code := -118;
1007: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1008: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1009: Fnd_Message.Set_Token('Orgid',l_organization_id);
1010: Err_Msg := Fnd_Message.Get;
1011: WHEN OTHERS THEN
1012: rollback ;
1013: bom_export_tab.delete ;
1014: error_code := SQLCODE;

Line 1233: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');

1229: END LOOP;
1230:
1231: EXCEPTION
1232: WHEN invalid_bill_seq_id THEN
1233: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1234: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1235: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1236: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1237: RAISE invalid_bill_seq_id;

Line 1234: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);

1230:
1231: EXCEPTION
1232: WHEN invalid_bill_seq_id THEN
1233: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1234: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1235: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1236: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1237: RAISE invalid_bill_seq_id;
1238: END Populate_Header;

Line 1235: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);

1231: EXCEPTION
1232: WHEN invalid_bill_seq_id THEN
1233: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1234: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1235: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1236: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1237: RAISE invalid_bill_seq_id;
1238: END Populate_Header;
1239:

Line 1236: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);

1232: WHEN invalid_bill_seq_id THEN
1233: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1234: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1235: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1236: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1237: RAISE invalid_bill_seq_id;
1238: END Populate_Header;
1239:
1240: PROCEDURE Populate_Details(P_component_item_id IN NUMBER,

Line 1546: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');

1542: END LOOP;
1543:
1544: EXCEPTION
1545: WHEN invalid_comp_seq_id THEN
1546: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1547: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN

Line 1547: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);

1543:
1544: EXCEPTION
1545: WHEN invalid_comp_seq_id THEN
1546: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1547: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');

Line 1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);

1544: EXCEPTION
1545: WHEN invalid_comp_seq_id THEN
1546: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1547: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);

Line 1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');

1547: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1553: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1554: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1555: RAISE invalid_locator_id;

Line 1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);

1548: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1553: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1554: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1555: RAISE invalid_locator_id;
1556: END Populate_Details;

Line 1553: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);

1549: RAISE invalid_comp_seq_id;
1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1553: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1554: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1555: RAISE invalid_locator_id;
1556: END Populate_Details;
1557:

Line 1554: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);

1550: WHEN invalid_locator_id THEN
1551: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1552: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1553: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1554: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1555: RAISE invalid_locator_id;
1556: END Populate_Details;
1557:
1558: --========================================================================

Line 1758: FND_MESSAGE.Set_Name('BOM', 'BOM_NO_PROFILE');

1754: EXCEPTION
1755: WHEN no_profile THEN
1756: rollback;
1757: X_error_code := -117;
1758: FND_MESSAGE.Set_Name('BOM', 'BOM_NO_PROFILE');
1759: X_Err_Msg := FND_MESSAGE.Get;
1760:
1761: WHEN missing_parameters THEN
1762: X_error_code := -112;

Line 1759: X_Err_Msg := FND_MESSAGE.Get;

1755: WHEN no_profile THEN
1756: rollback;
1757: X_error_code := -117;
1758: FND_MESSAGE.Set_Name('BOM', 'BOM_NO_PROFILE');
1759: X_Err_Msg := FND_MESSAGE.Get;
1760:
1761: WHEN missing_parameters THEN
1762: X_error_code := -112;
1763: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');

Line 1763: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');

1759: X_Err_Msg := FND_MESSAGE.Get;
1760:
1761: WHEN missing_parameters THEN
1762: X_error_code := -112;
1763: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');
1764: X_err_Msg := FND_MESSAGE.Get;
1765:
1766: WHEN invalid_org THEN
1767: rollback;

Line 1764: X_err_Msg := FND_MESSAGE.Get;

1760:
1761: WHEN missing_parameters THEN
1762: X_error_code := -112;
1763: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');
1764: X_err_Msg := FND_MESSAGE.Get;
1765:
1766: WHEN invalid_org THEN
1767: rollback;
1768: X_error_code := -121;

Line 1769: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');

1765:
1766: WHEN invalid_org THEN
1767: rollback;
1768: X_error_code := -121;
1769: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1770: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1771: X_Err_Msg := FND_MESSAGE.Get;
1772:
1773: WHEN invalid_assembly_item_name THEN

Line 1770: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);

1766: WHEN invalid_org THEN
1767: rollback;
1768: X_error_code := -121;
1769: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1770: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1771: X_Err_Msg := FND_MESSAGE.Get;
1772:
1773: WHEN invalid_assembly_item_name THEN
1774: rollback;

Line 1771: X_Err_Msg := FND_MESSAGE.Get;

1767: rollback;
1768: X_error_code := -121;
1769: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1770: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1771: X_Err_Msg := FND_MESSAGE.Get;
1772:
1773: WHEN invalid_assembly_item_name THEN
1774: rollback;
1775: X_error_code := -116;

Line 1776: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');

1772:
1773: WHEN invalid_assembly_item_name THEN
1774: rollback;
1775: X_error_code := -116;
1776: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1777: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1778: X_Err_Msg := FND_MESSAGE.Get;
1779:
1780: WHEN invalid_comp_seq_id THEN

Line 1777: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);

1773: WHEN invalid_assembly_item_name THEN
1774: rollback;
1775: X_error_code := -116;
1776: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1777: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1778: X_Err_Msg := FND_MESSAGE.Get;
1779:
1780: WHEN invalid_comp_seq_id THEN
1781: rollback;

Line 1778: X_Err_Msg := FND_MESSAGE.Get;

1774: rollback;
1775: X_error_code := -116;
1776: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1777: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1778: X_Err_Msg := FND_MESSAGE.Get;
1779:
1780: WHEN invalid_comp_seq_id THEN
1781: rollback;
1782: X_bom_header_tbl.DELETE;

Line 1789: X_Err_Msg := FND_MESSAGE.Get;

1785: X_bom_ref_designators_tbl.DELETE;
1786: X_bom_sub_components_tbl.DELETE;
1787: X_bom_comp_ops_tbl.DELETE;
1788: X_error_code := -115;
1789: X_Err_Msg := FND_MESSAGE.Get;
1790:
1791: WHEN invalid_locator_id THEN
1792: rollback;
1793: X_bom_header_tbl.DELETE;

Line 1800: X_Err_Msg := FND_MESSAGE.Get;

1796: X_bom_ref_designators_tbl.DELETE;
1797: X_bom_sub_components_tbl.DELETE;
1798: X_bom_comp_ops_tbl.DELETE;
1799: X_error_code := -114;
1800: X_Err_Msg := FND_MESSAGE.Get;
1801:
1802: WHEN invalid_bill_seq_id THEN
1803: rollback;
1804: X_bom_header_tbl.DELETE;

Line 1811: X_Err_Msg := FND_MESSAGE.Get;

1807: X_bom_ref_designators_tbl.DELETE;
1808: X_bom_sub_components_tbl.DELETE;
1809: X_bom_comp_ops_tbl.DELETE;
1810: X_error_code := -113;
1811: X_Err_Msg := FND_MESSAGE.Get;
1812: END EXPORT_BOM;
1813:
1814: END BOMPXINQ;