DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on BOM_PARAMETERS

Line 1125: from bom_parameters bp, mtl_system_items_b msi

1121: into l_inheritPhOpSeq,
1122: l_grpID,
1123: l_bomItemType,
1124: l_maxBomLevel
1125: from bom_parameters bp, mtl_system_items_b msi
1126: where bp.organization_id = p_orgID
1127: and bp.organization_id = msi.organization_id
1128: and msi.inventory_item_id = p_itemID;
1129: exception

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

1126: where bp.organization_id = p_orgID
1127: and bp.organization_id = msi.organization_id
1128: and msi.inventory_item_id = p_itemID;
1129: exception
1130: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1131: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1132: fnd_msg_pub.add;
1133: l_errMsg := 'no bom parameters';
1134: raise fnd_api.g_exc_unexpected_error;

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

1129: exception
1130: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1131: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1132: fnd_msg_pub.add;
1133: l_errMsg := 'no bom parameters';
1134: raise fnd_api.g_exc_unexpected_error;
1135: end;
1136:
1137: /* Fix for bug 5383135. To honour the profile 'WIP:Exclude ECOs',