eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPXINQ dependencies on FND_MESSAGE

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

570: Fetch conv into t_conversion_rate(i);
571: if conv%NOTFOUND then
572: close conv; -- added for Bug #2994556
573: /* Bug 9355186 : Error is thrown right away instead of raising exception */
574: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
575: fnd_message.Set_Token('FROMUOM',t_master_uom(i));
576: fnd_message.Set_Token('TOUOM',t_child_uom(i));
577: fnd_message.raise_error;
578: End if;

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

571: if conv%NOTFOUND then
572: close conv; -- added for Bug #2994556
573: /* Bug 9355186 : Error is thrown right away instead of raising exception */
574: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
575: fnd_message.Set_Token('FROMUOM',t_master_uom(i));
576: fnd_message.Set_Token('TOUOM',t_child_uom(i));
577: fnd_message.raise_error;
578: End if;
579: close conv; -- added for Bug #2994556

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

572: close conv; -- added for Bug #2994556
573: /* Bug 9355186 : Error is thrown right away instead of raising exception */
574: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
575: fnd_message.Set_Token('FROMUOM',t_master_uom(i));
576: fnd_message.Set_Token('TOUOM',t_child_uom(i));
577: fnd_message.raise_error;
578: End if;
579: close conv; -- added for Bug #2994556
580: END LOOP; -- curCSI.count loop

Line 577: fnd_message.raise_error;

573: /* Bug 9355186 : Error is thrown right away instead of raising exception */
574: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
575: fnd_message.Set_Token('FROMUOM',t_master_uom(i));
576: fnd_message.Set_Token('TOUOM',t_child_uom(i));
577: fnd_message.raise_error;
578: End if;
579: close conv; -- added for Bug #2994556
580: END LOOP; -- curCSI.count loop
581:

Line 636: err_msg := Fnd_Message.Get_Encoded;

632: Fnd_Msg_Pub.Build_Exc_Msg(
633: p_pkg_name => 'BOMPXINQ',
634: p_procedure_name => 'exploder_userexit',
635: p_error_text => 'verify parameters');
636: err_msg := Fnd_Message.Get_Encoded;
637: /* Commented for bug 9355186 WHEN inv_uom_conv_exe THEN
638: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
639: fnd_message.Set_Token('FROMUOM',t_master_uom);
640: fnd_message.Set_Token('TOUOM',t_child_uom);

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

634: p_procedure_name => 'exploder_userexit',
635: p_error_text => 'verify parameters');
636: err_msg := Fnd_Message.Get_Encoded;
637: /* Commented for bug 9355186 WHEN inv_uom_conv_exe THEN
638: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
639: fnd_message.Set_Token('FROMUOM',t_master_uom);
640: fnd_message.Set_Token('TOUOM',t_child_uom);
641: fnd_message.raise_error;*/
642:

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

635: p_error_text => 'verify parameters');
636: err_msg := Fnd_Message.Get_Encoded;
637: /* Commented for bug 9355186 WHEN inv_uom_conv_exe THEN
638: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
639: fnd_message.Set_Token('FROMUOM',t_master_uom);
640: fnd_message.Set_Token('TOUOM',t_child_uom);
641: fnd_message.raise_error;*/
642:
643: WHEN OTHERS THEN

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

636: err_msg := Fnd_Message.Get_Encoded;
637: /* Commented for bug 9355186 WHEN inv_uom_conv_exe THEN
638: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
639: fnd_message.Set_Token('FROMUOM',t_master_uom);
640: fnd_message.Set_Token('TOUOM',t_child_uom);
641: fnd_message.raise_error;*/
642:
643: WHEN OTHERS THEN
644: error_code := SQLCODE;

Line 641: fnd_message.raise_error;*/

637: /* Commented for bug 9355186 WHEN inv_uom_conv_exe THEN
638: FND_MESSAGE.SET_NAME('BOM','BOM_UOMCV_INVUOMTYPE_ERR');
639: fnd_message.Set_Token('FROMUOM',t_master_uom);
640: fnd_message.Set_Token('TOUOM',t_child_uom);
641: fnd_message.raise_error;*/
642:
643: WHEN OTHERS THEN
644: error_code := SQLCODE;
645: Fnd_Msg_Pub.Build_Exc_Msg(

Line 649: err_msg := Fnd_Message.Get_Encoded;

645: Fnd_Msg_Pub.Build_Exc_Msg(
646: p_pkg_name => 'BOMPXINQ',
647: p_procedure_name => 'exploder_userexit',
648: p_error_text => SQLERRM);
649: err_msg := Fnd_Message.Get_Encoded;
650: ROLLBACK TO exploder_userexit_pvt; -- Added for bug: 3863319
651: END exploder_userexit;
652:
653: --========================================================================

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

1016: WHEN no_level_access THEN
1017: rollback ;
1018: bom_export_tab.delete;
1019: error_code := -122;
1020: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
1021: Fnd_Message.Set_Token('l_org_name',l_org_name);
1022: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1023: Err_Msg := Fnd_Message.Get;
1024: WHEN no_organization THEN

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

1017: rollback ;
1018: bom_export_tab.delete;
1019: error_code := -122;
1020: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
1021: Fnd_Message.Set_Token('l_org_name',l_org_name);
1022: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1023: Err_Msg := Fnd_Message.Get;
1024: WHEN no_organization THEN
1025: rollback ;

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

1018: bom_export_tab.delete;
1019: error_code := -122;
1020: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
1021: Fnd_Message.Set_Token('l_org_name',l_org_name);
1022: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1023: Err_Msg := Fnd_Message.Get;
1024: WHEN no_organization THEN
1025: rollback ;
1026: bom_export_tab.delete;

Line 1023: Err_Msg := Fnd_Message.Get;

1019: error_code := -122;
1020: Fnd_Message.Set_Name('BOM','BOM_NO_ORG_LEVEL_ACCESS');
1021: Fnd_Message.Set_Token('l_org_name',l_org_name);
1022: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1023: Err_Msg := Fnd_Message.Get;
1024: WHEN no_organization THEN
1025: rollback ;
1026: bom_export_tab.delete;
1027: error_code := -121;

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

1024: WHEN no_organization THEN
1025: rollback ;
1026: bom_export_tab.delete;
1027: error_code := -121;
1028: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
1029: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
1030: Err_Msg := Fnd_Message.Get;
1031: WHEN explode_error THEN
1032: rollback;

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

1025: rollback ;
1026: bom_export_tab.delete;
1027: error_code := -121;
1028: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
1029: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
1030: Err_Msg := Fnd_Message.Get;
1031: WHEN explode_error THEN
1032: rollback;
1033: bom_export_tab.delete;

Line 1030: Err_Msg := Fnd_Message.Get;

1026: bom_export_tab.delete;
1027: error_code := -121;
1028: Fnd_Message.Set_Name('BOM','BOM_INVALID_ORGANIZATION');
1029: Fnd_Message.Set_Token('l_organization_id',l_organization_id);
1030: Err_Msg := Fnd_Message.Get;
1031: WHEN explode_error THEN
1032: rollback;
1033: bom_export_tab.delete;
1034: error_code := -120;

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

1031: WHEN explode_error THEN
1032: rollback;
1033: bom_export_tab.delete;
1034: error_code := -120;
1035: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
1036: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
1037: Fnd_Message.Set_Token('Orgid',l_organization_id);
1038: Err_Msg:= Fnd_Message.Get;
1039: WHEN no_hierarchy THEN

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

1032: rollback;
1033: bom_export_tab.delete;
1034: error_code := -120;
1035: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
1036: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
1037: Fnd_Message.Set_Token('Orgid',l_organization_id);
1038: Err_Msg:= Fnd_Message.Get;
1039: WHEN no_hierarchy THEN
1040: rollback ;

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

1033: bom_export_tab.delete;
1034: error_code := -120;
1035: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
1036: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
1037: Fnd_Message.Set_Token('Orgid',l_organization_id);
1038: Err_Msg:= Fnd_Message.Get;
1039: WHEN no_hierarchy THEN
1040: rollback ;
1041: bom_export_tab.delete;

Line 1038: Err_Msg:= Fnd_Message.Get;

1034: error_code := -120;
1035: Fnd_Message.Set_Name('BOM','BOM_ORG_LEVELS_EXCEEDED');
1036: Fnd_Message.Set_Token('Assembly',Assembly_item_id);
1037: Fnd_Message.Set_Token('Orgid',l_organization_id);
1038: Err_Msg:= Fnd_Message.Get;
1039: WHEN no_hierarchy THEN
1040: rollback ;
1041: bom_export_tab.delete;
1042: error_code := -119;

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

1039: WHEN no_hierarchy THEN
1040: rollback ;
1041: bom_export_tab.delete;
1042: error_code := -119;
1043: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1044: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1045: Err_Msg := Fnd_Message.Get;
1046: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1047: WHEN cost_type THEN

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

1040: rollback ;
1041: bom_export_tab.delete;
1042: error_code := -119;
1043: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1044: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1045: Err_Msg := Fnd_Message.Get;
1046: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1047: WHEN cost_type THEN
1048: rollback ;

Line 1045: Err_Msg := Fnd_Message.Get;

1041: bom_export_tab.delete;
1042: error_code := -119;
1043: Fnd_Message.Set_Name('BOM','BOM_INVALID_HIER_OR_ACCESS');
1044: Fnd_Message.Set_Token('Org_hierarchy_name',Org_hierarchy_name);
1045: Err_Msg := Fnd_Message.Get;
1046: --dbms_output.put_line('Error: no_hierarchy ' || Err_Msg);
1047: WHEN cost_type THEN
1048: rollback ;
1049: bom_export_tab.delete;

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

1047: WHEN cost_type THEN
1048: rollback ;
1049: bom_export_tab.delete;
1050: error_code := -118;
1051: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1052: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1053: Fnd_Message.Set_Token('Orgid',l_organization_id);
1054: Err_Msg := Fnd_Message.Get;
1055: WHEN OTHERS THEN

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

1048: rollback ;
1049: bom_export_tab.delete;
1050: error_code := -118;
1051: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1052: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1053: Fnd_Message.Set_Token('Orgid',l_organization_id);
1054: Err_Msg := Fnd_Message.Get;
1055: WHEN OTHERS THEN
1056: rollback ;

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

1049: bom_export_tab.delete;
1050: error_code := -118;
1051: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1052: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1053: Fnd_Message.Set_Token('Orgid',l_organization_id);
1054: Err_Msg := Fnd_Message.Get;
1055: WHEN OTHERS THEN
1056: rollback ;
1057: bom_export_tab.delete ;

Line 1054: Err_Msg := Fnd_Message.Get;

1050: error_code := -118;
1051: Fnd_Message.Set_Name('BOM','BOM_COST_TYPE_INVALID');
1052: Fnd_Message.Set_Token('Cost_type',c_Cost_type_id);
1053: Fnd_Message.Set_Token('Orgid',l_organization_id);
1054: Err_Msg := Fnd_Message.Get;
1055: WHEN OTHERS THEN
1056: rollback ;
1057: bom_export_tab.delete ;
1058: error_code := SQLCODE;

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

1273: END LOOP;
1274:
1275: EXCEPTION
1276: WHEN invalid_bill_seq_id THEN
1277: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1278: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1279: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1280: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1281: RAISE invalid_bill_seq_id;

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

1274:
1275: EXCEPTION
1276: WHEN invalid_bill_seq_id THEN
1277: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1278: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1279: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1280: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1281: RAISE invalid_bill_seq_id;
1282: END Populate_Header;

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

1275: EXCEPTION
1276: WHEN invalid_bill_seq_id THEN
1277: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1278: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1279: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1280: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1281: RAISE invalid_bill_seq_id;
1282: END Populate_Header;
1283:

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

1276: WHEN invalid_bill_seq_id THEN
1277: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_BILL_SEQ_ID');
1278: FND_MESSAGE.Set_Token('BILL_SEQUENCE_ID', P_bill_sequence_id);
1279: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM_NAME', l_item_name);
1280: FND_MESSAGE.Set_Token('ORGANIZATION_CODE', l_org_code);
1281: RAISE invalid_bill_seq_id;
1282: END Populate_Header;
1283:
1284: PROCEDURE Populate_Details(P_component_item_id IN NUMBER,

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

1586: END LOOP;
1587:
1588: EXCEPTION
1589: WHEN invalid_comp_seq_id THEN
1590: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1591: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1592: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN

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

1587:
1588: EXCEPTION
1589: WHEN invalid_comp_seq_id THEN
1590: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1591: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1592: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');

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

1588: EXCEPTION
1589: WHEN invalid_comp_seq_id THEN
1590: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_COMP_SEQ_ID');
1591: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1592: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1596: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);

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

1591: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1592: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1596: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1597: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1598: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1599: RAISE invalid_locator_id;

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

1592: FND_MESSAGE.Set_Token('COMPONENT_SEQ_ID', P_component_sequence_id);
1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1596: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1597: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1598: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1599: RAISE invalid_locator_id;
1600: END Populate_Details;

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

1593: RAISE invalid_comp_seq_id;
1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1596: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1597: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1598: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1599: RAISE invalid_locator_id;
1600: END Populate_Details;
1601:

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

1594: WHEN invalid_locator_id THEN
1595: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_LOCATOR_ID');
1596: FND_MESSAGE.Set_Token('LOCATOR_ID', l_comp_details.supply_locator_id);
1597: FND_MESSAGE.Set_Token('ORGANIZATION_ID', P_organization_id);
1598: FND_MESSAGE.Set_Token('COMPONENT_ITEM_NAME', l_component_item_name);
1599: RAISE invalid_locator_id;
1600: END Populate_Details;
1601:
1602: --========================================================================

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

1798: EXCEPTION
1799: WHEN no_profile THEN
1800: rollback;
1801: X_error_code := -117;
1802: FND_MESSAGE.Set_Name('BOM', 'BOM_NO_PROFILE');
1803: X_Err_Msg := FND_MESSAGE.Get;
1804:
1805: WHEN missing_parameters THEN
1806: X_error_code := -112;

Line 1803: X_Err_Msg := FND_MESSAGE.Get;

1799: WHEN no_profile THEN
1800: rollback;
1801: X_error_code := -117;
1802: FND_MESSAGE.Set_Name('BOM', 'BOM_NO_PROFILE');
1803: X_Err_Msg := FND_MESSAGE.Get;
1804:
1805: WHEN missing_parameters THEN
1806: X_error_code := -112;
1807: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');

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

1803: X_Err_Msg := FND_MESSAGE.Get;
1804:
1805: WHEN missing_parameters THEN
1806: X_error_code := -112;
1807: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');
1808: X_err_Msg := FND_MESSAGE.Get;
1809:
1810: WHEN invalid_org THEN
1811: rollback;

Line 1808: X_err_Msg := FND_MESSAGE.Get;

1804:
1805: WHEN missing_parameters THEN
1806: X_error_code := -112;
1807: FND_MESSAGE.Set_Name('BOM', 'BOM_ASSY_OR_ORG_MISSING');
1808: X_err_Msg := FND_MESSAGE.Get;
1809:
1810: WHEN invalid_org THEN
1811: rollback;
1812: X_error_code := -121;

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

1809:
1810: WHEN invalid_org THEN
1811: rollback;
1812: X_error_code := -121;
1813: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1814: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1815: X_Err_Msg := FND_MESSAGE.Get;
1816:
1817: WHEN invalid_assembly_item_name THEN

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

1810: WHEN invalid_org THEN
1811: rollback;
1812: X_error_code := -121;
1813: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1814: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1815: X_Err_Msg := FND_MESSAGE.Get;
1816:
1817: WHEN invalid_assembly_item_name THEN
1818: rollback;

Line 1815: X_Err_Msg := FND_MESSAGE.Get;

1811: rollback;
1812: X_error_code := -121;
1813: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ORGANIZATION');
1814: FND_MESSAGE.Set_Token('L_ORGANIZATION_ID', P_organization_code);
1815: X_Err_Msg := FND_MESSAGE.Get;
1816:
1817: WHEN invalid_assembly_item_name THEN
1818: rollback;
1819: X_error_code := -116;

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

1816:
1817: WHEN invalid_assembly_item_name THEN
1818: rollback;
1819: X_error_code := -116;
1820: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1821: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1822: X_Err_Msg := FND_MESSAGE.Get;
1823:
1824: WHEN invalid_comp_seq_id THEN

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

1817: WHEN invalid_assembly_item_name THEN
1818: rollback;
1819: X_error_code := -116;
1820: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1821: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1822: X_Err_Msg := FND_MESSAGE.Get;
1823:
1824: WHEN invalid_comp_seq_id THEN
1825: rollback;

Line 1822: X_Err_Msg := FND_MESSAGE.Get;

1818: rollback;
1819: X_error_code := -116;
1820: FND_MESSAGE.Set_Name('BOM', 'BOM_INVALID_ASSEMBLY_ITEM');
1821: FND_MESSAGE.Set_Token('ASSEMBLY_ITEM', P_assembly_item_name);
1822: X_Err_Msg := FND_MESSAGE.Get;
1823:
1824: WHEN invalid_comp_seq_id THEN
1825: rollback;
1826: X_bom_header_tbl.DELETE;

Line 1833: X_Err_Msg := FND_MESSAGE.Get;

1829: X_bom_ref_designators_tbl.DELETE;
1830: X_bom_sub_components_tbl.DELETE;
1831: X_bom_comp_ops_tbl.DELETE;
1832: X_error_code := -115;
1833: X_Err_Msg := FND_MESSAGE.Get;
1834:
1835: WHEN invalid_locator_id THEN
1836: rollback;
1837: X_bom_header_tbl.DELETE;

Line 1844: X_Err_Msg := FND_MESSAGE.Get;

1840: X_bom_ref_designators_tbl.DELETE;
1841: X_bom_sub_components_tbl.DELETE;
1842: X_bom_comp_ops_tbl.DELETE;
1843: X_error_code := -114;
1844: X_Err_Msg := FND_MESSAGE.Get;
1845:
1846: WHEN invalid_bill_seq_id THEN
1847: rollback;
1848: X_bom_header_tbl.DELETE;

Line 1855: X_Err_Msg := FND_MESSAGE.Get;

1851: X_bom_ref_designators_tbl.DELETE;
1852: X_bom_sub_components_tbl.DELETE;
1853: X_bom_comp_ops_tbl.DELETE;
1854: X_error_code := -113;
1855: X_Err_Msg := FND_MESSAGE.Get;
1856: END EXPORT_BOM;
1857:
1858: END BOMPXINQ;