[Home] [Help]
287:
288: /************************************************************************
289: * If the Transaction Type is CREATE and the ACD_type is ADD then check the
290: * type of item to which a ref. designator is being added. Planning bills
291: * cannot have ref. desgs and also components which are not Standard cannot
292: * have ref. desgs. This OR so even if either exists Ref. Designators cannot
293: * be added.
294: *************************************************************************/
295:
293: * be added.
294: *************************************************************************/
295:
296: BEGIN
297: SELECT 'Non-Standard Comp'
298: INTO l_dummy
299: FROM bom_inventory_Components bic
300: WHERE bic.component_sequence_id = p_component_seq_id
301: AND bic.bom_item_type IN (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
300: WHERE bic.component_sequence_id = p_component_seq_id
301: AND bic.bom_item_type IN (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
302:
303: -- If no exception is raised then
304: -- Generate an error saying that the component is non-standard.
305:
306: l_return_status := Fnd_Api.G_RET_STS_ERROR;
307: x_return_status := 'BOM_RFD_NON_STD_PARENT';
308: RETURN;
314: WHEN OTHERS THEN
315: -- do nothing
316: NULL;
317:
318: END; /* End Checking for non-standard component */
319:
320: BEGIN
321: SELECT 'Planning Bill'
322: INTO l_dummy