739:
740: -- Check if valid eAM routing network exists
741: IF NOT CheckNwkExists( p_routing_sequence_id => p_routing_sequence_id )
742: THEN
743: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_NO_NETWORK_EXIST');
744: x_err_msg:= FND_MESSAGE.GET;
745: -- Commented as part of bug#3460975. This is not an error. It should be treated as warning
746: -- because a routing may or may not have a link.
747: -- x_return_status := FND_API.G_RET_STS_ERROR ;
740: -- Check if valid eAM routing network exists
741: IF NOT CheckNwkExists( p_routing_sequence_id => p_routing_sequence_id )
742: THEN
743: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_NO_NETWORK_EXIST');
744: x_err_msg:= FND_MESSAGE.GET;
745: -- Commented as part of bug#3460975. This is not an error. It should be treated as warning
746: -- because a routing may or may not have a link.
747: -- x_return_status := FND_API.G_RET_STS_ERROR ;
748:
825: ) ;
826:
827: IF NOT l_connected_flag THEN
828:
829: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
830: x_err_msg:= FND_MESSAGE.GET;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: RETURN ;
833:
826:
827: IF NOT l_connected_flag THEN
828:
829: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
830: x_err_msg:= FND_MESSAGE.GET;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: RETURN ;
833:
834: END IF ;
845: -- delete the connected list for re-use
846: l_connected_op_tbl.DELETE;
847:
848: ELSE
849: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_BROKEN_LINK_EXIST');
850: x_err_msg:= FND_MESSAGE.GET;
851: x_return_status := FND_API.G_RET_STS_ERROR ;
852: RETURN ;
853: END IF;
846: l_connected_op_tbl.DELETE;
847:
848: ELSE
849: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_BROKEN_LINK_EXIST');
850: x_err_msg:= FND_MESSAGE.GET;
851: x_return_status := FND_API.G_RET_STS_ERROR ;
852: RETURN ;
853: END IF;
854: END LOOP;
877: || to_char(l_network_link_tbl(i).to_op_seq_num)
878: );
879: END IF;
880:
881: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
882: x_err_msg:= FND_MESSAGE.GET;
883: x_return_status := FND_API.G_RET_STS_ERROR ;
884: RETURN ;
885: END IF ;
878: );
879: END IF;
880:
881: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
882: x_err_msg:= FND_MESSAGE.GET;
883: x_return_status := FND_API.G_RET_STS_ERROR ;
884: RETURN ;
885: END IF ;
886: END LOOP ;
908: || to_char(l_master_op_tbl(i).from_op_seq_num)
909: );
910: END IF;
911:
912: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
913: x_err_msg:= FND_MESSAGE.GET;
914: x_return_status := FND_API.G_RET_STS_ERROR ;
915: RETURN ;
916: END IF ;
909: );
910: END IF;
911:
912: FND_MESSAGE.SET_NAME('BOM','BOM_EAM_RTG_INVALID_LINK_EXIST');
913: x_err_msg:= FND_MESSAGE.GET;
914: x_return_status := FND_API.G_RET_STS_ERROR ;
915: RETURN ;
916: END IF ;
917: END LOOP ;
959: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
960: Error_Handler.Write_Debug('Loop exists in operation network : seq = ' || to_char(l_seq_num) );
961: END IF;
962:
963: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_LOOP_EXISTS');
964: x_err_msg:= FND_MESSAGE.GET;
965: x_return_status := FND_API.G_RET_STS_ERROR ;
966: RETURN ;
967: END IF ;
960: Error_Handler.Write_Debug('Loop exists in operation network : seq = ' || to_char(l_seq_num) );
961: END IF;
962:
963: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_LOOP_EXISTS');
964: x_err_msg:= FND_MESSAGE.GET;
965: x_return_status := FND_API.G_RET_STS_ERROR ;
966: RETURN ;
967: END IF ;
968:
1011: Error_Handler.Write_Debug('Loop exists in operation network : seq = '
1012: || to_char(l_seq_num) );
1013: END IF ;
1014:
1015: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_LOOP_EXISTS');
1016: x_err_msg:= FND_MESSAGE.GET;
1017: x_return_status := FND_API.G_RET_STS_ERROR ;
1018: RETURN ;
1019: END IF ;
1012: || to_char(l_seq_num) );
1013: END IF ;
1014:
1015: FND_MESSAGE.SET_NAME('BOM','BOM_RTG_NTWK_LOOP_EXISTS');
1016: x_err_msg:= FND_MESSAGE.GET;
1017: x_return_status := FND_API.G_RET_STS_ERROR ;
1018: RETURN ;
1019: END IF ;
1020:
1118: Error_Handler.Write_Debug('from operation is duplicate in operation network : seq = '
1119: || to_char(p_from_op_seq_num) );
1120: END IF ;
1121:
1122: FND_MESSAGE.SET_NAME('BOM','BOM_OP_NWK_PMOP_NOTUNIQUE');
1123: FND_MESSAGE.SET_TOKEN('FROM_OP_SEQ_NUMBER', p_from_op_seq_num) ;
1124: x_err_msg:= FND_MESSAGE.GET;
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126:
1119: || to_char(p_from_op_seq_num) );
1120: END IF ;
1121:
1122: FND_MESSAGE.SET_NAME('BOM','BOM_OP_NWK_PMOP_NOTUNIQUE');
1123: FND_MESSAGE.SET_TOKEN('FROM_OP_SEQ_NUMBER', p_from_op_seq_num) ;
1124: x_err_msg:= FND_MESSAGE.GET;
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126:
1127: END LOOP ;
1120: END IF ;
1121:
1122: FND_MESSAGE.SET_NAME('BOM','BOM_OP_NWK_PMOP_NOTUNIQUE');
1123: FND_MESSAGE.SET_TOKEN('FROM_OP_SEQ_NUMBER', p_from_op_seq_num) ;
1124: x_err_msg:= FND_MESSAGE.GET;
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126:
1127: END LOOP ;
1128:
1683:
1684: IF l_op_node_rec.transaction_type <> BOM_Rtg_Globals.G_OPR_UPDATE
1685: THEN
1686: /* Error Handling */
1687: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_TRANS_TYPE_INVALID');
1688: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1689: l_return_mesg := FND_MESSAGE.GET ;
1690: l_return_status := FND_API.G_RET_STS_ERROR ;
1691: RAISE EXC_SEV_QUIT_OBJECT ;
1684: IF l_op_node_rec.transaction_type <> BOM_Rtg_Globals.G_OPR_UPDATE
1685: THEN
1686: /* Error Handling */
1687: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_TRANS_TYPE_INVALID');
1688: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1689: l_return_mesg := FND_MESSAGE.GET ;
1690: l_return_status := FND_API.G_RET_STS_ERROR ;
1691: RAISE EXC_SEV_QUIT_OBJECT ;
1692:
1685: THEN
1686: /* Error Handling */
1687: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_TRANS_TYPE_INVALID');
1688: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1689: l_return_mesg := FND_MESSAGE.GET ;
1690: l_return_status := FND_API.G_RET_STS_ERROR ;
1691: RAISE EXC_SEV_QUIT_OBJECT ;
1692:
1693: END IF ;
1697: l_op_node_rec.operation_sequence_id = FND_API.G_MISS_NUM
1698: THEN
1699:
1700: /* Error Handling */
1701: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_SEQ_ID_NULL');
1702: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1703: l_return_mesg := FND_MESSAGE.GET ;
1704: l_return_status := FND_API.G_RET_STS_ERROR ;
1705: RAISE EXC_SEV_QUIT_OBJECT ;
1698: THEN
1699:
1700: /* Error Handling */
1701: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_SEQ_ID_NULL');
1702: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1703: l_return_mesg := FND_MESSAGE.GET ;
1704: l_return_status := FND_API.G_RET_STS_ERROR ;
1705: RAISE EXC_SEV_QUIT_OBJECT ;
1706:
1699:
1700: /* Error Handling */
1701: FND_MESSAGE.SET_NAME('BOM','BOM_OPNODE_SEQ_ID_NULL');
1702: FND_MESSAGE.SET_TOKEN('OP_SEQ_NUMBER', l_op_node_rec.operation_sequence_number) ;
1703: l_return_mesg := FND_MESSAGE.GET ;
1704: l_return_status := FND_API.G_RET_STS_ERROR ;
1705: RAISE EXC_SEV_QUIT_OBJECT ;
1706:
1707: