DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on BOM_PARAMETERS

Line 1099: from bom_parameters bp, mtl_system_items_b msi

1095: into l_inheritPhOpSeq,
1096: l_grpID,
1097: l_bomItemType,
1098: l_maxBomLevel
1099: from bom_parameters bp, mtl_system_items_b msi
1100: where bp.organization_id = p_orgID
1101: and bp.organization_id = msi.organization_id
1102: and msi.inventory_item_id = p_itemID;
1103: exception

Line 1104: when no_data_found then --assume bom parameters not defined. the item_id should be valid.

1100: where bp.organization_id = p_orgID
1101: and bp.organization_id = msi.organization_id
1102: and msi.inventory_item_id = p_itemID;
1103: exception
1104: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1105: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1106: fnd_msg_pub.add;
1107: l_errMsg := 'no bom parameters';
1108: raise fnd_api.g_exc_unexpected_error;

Line 1107: l_errMsg := 'no bom parameters';

1103: exception
1104: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1105: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1106: fnd_msg_pub.add;
1107: l_errMsg := 'no bom parameters';
1108: raise fnd_api.g_exc_unexpected_error;
1109: end;
1110:
1111: /* Fix for bug 5383135. To honour the profile 'WIP:Exclude ECOs',