APPS.BOM_VALIDATE_OP_NETWORK dependencies on STANDARD

Line 277: SELECT standard_operation_id

273: -- Check if Department is valid
274: CURSOR l_nwkop_csr ( p_op_seq_id NUMBER
275: )
276: IS
277: SELECT standard_operation_id
278: ,disable_date
279: FROM BOM_OPERATION_SEQUENCES bos
280: WHERE bos.operation_sequence_id = p_op_seq_id ;
281:

Line 344: IF l_nwkop_rec.standard_operation_id IS NULL THEN

340: ( p_op_seq_id => NVL(p_op_network_unexp_rec.new_from_op_seq_id,
341: p_op_network_unexp_rec.from_op_seq_id )
342: )
343: LOOP
344: IF l_nwkop_rec.standard_operation_id IS NULL THEN
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
346: THEN
347: Error_Handler.Add_Error_Token
348: ( p_message_name => 'BOM_OP_NWK_STDOP_REQUIRED'

Line 381: IF l_nwkop_rec.standard_operation_id IS NULL THEN

377: ( p_op_seq_id => NVL( p_op_network_unexp_rec.new_to_op_seq_id
378: , p_op_network_unexp_rec.to_op_seq_id )
379: )
380: LOOP
381: IF l_nwkop_rec.standard_operation_id IS NULL THEN
382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
383: THEN
384: Error_Handler.Add_Error_Token
385: ( p_message_name => 'BOM_OP_NWK_STDOP_REQUIRED'

Line 487: ('Check if parenet routing is a standard routing. ' || l_return_status) ;

483: AND BOM_Rtg_Globals.Get_Eam_Item_Type <> BOM_Rtg_Globals.G_ASSET_ACTIVITY
484: THEN
485:
486: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
487: ('Check if parenet routing is a standard routing. ' || l_return_status) ;
488: END IF ;
489: l_token_tbl.delete ;
490: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
491: l_token_tbl(1).token_value :=